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.

  • 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;

Subscribe
Notify of
guest

This site uses Akismet to reduce spam. Learn how your comment data is processed.

2 Comments
Oldest
Newest Most Voted
Inline Feedbacks
View all comments
ravinder
ravinder
5 months ago

thanks for data its really help me