Indian State, District, City SQL Database

This is clean and neat database of Indian State, District, City SQL Database. Download link contains entire database of Indian State, District and city. This SQL database has list of states, State-wise district records and District-wise city lists. It has more than 30+ state records and 600+ district records. This you can integrate with any of your project.

• State : This has 35 records.

CREATE TABLE state (
   state_id int(11) NOT NULL,
   state_title varchar(50) NOT NULL,
   state_description text NOT NULL,
   status varchar(10) NOT NULL
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

• District: This has 640 records.

CREATE TABLE district (
   districtid int(11) NOT NULL,
   state_id int(11) NOT NULL,
   district_title varchar(50) NOT NULL,
   district_description text NOT NULL,
   district_status varchar(10) NOT NULL
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

• City: This has 5924 city records.

CREATE TABLE city (
   id int(11) NOT NULL,
   name varchar(100) NOT NULL,
   districtid int(11) DEFAULT NULL,
   state_id int(11) DEFAULT NULL,
   description text NOT NULL,
   status varchar(10) DEFAULT NULL
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

---

Database Information

• The System has 3 database tables – state, district, city.
• All 35 state records, 600 districts and 5900 city records stored in this system.
• This is the backup of MySQL database.
• MySQL Version – 5.2+

---

Download link for Indian State, District, City SQL Database