Data source: DataMeet · About: https://github.com/datameet/india-local-government-directory

36 rows sorted by Census2011Code

View and edit SQL

Suggested facets: StateVersion, StateorUT

Link rowid S.No. StateCode StateVersion StateName(InEnglish) StateName(InLocal) Census2001Code Census2011Code ▼ StateorUT wikidataId
17 17 37 1 LADAKH   01 00 U Q200667
31 31 36 1 TELANGANA తెలంగాణ 28 00 S Q677037
13 13 1 3 JAMMU AND KASHMIR JAMMU AND KASHMIR 01 01 U Q66278313
12 12 2 1 HIMACHAL PRADESH HIMACHAL PRADESH 02 02 S Q1177
27 27 3 1 PUNJAB PUNJAB 03 03 S Q22424
6 6 4 1 CHANDIGARH CHANDIGARH 04 04 U Q43433
34 34 5 1 UTTARAKHAND UTTARAKHAND 05 05 S Q1499
11 11 6 1 HARYANA HARYANA 06 06 S Q1174
8 8 7 1 DELHI DELHI 07 07 U Q1353
28 28 8 1 RAJASTHAN RAJASTHAN 08 08 S Q1437
35 35 9 1 UTTAR PRADESH UTTAR PRADESH 09 09 S Q1498
5 5 10 1 BIHAR BIHAR 10 10 S Q1165
29 29 11 1 SIKKIM SIKKIM 11 11 S Q1505
3 3 12 1 ARUNACHAL PRADESH ARUNACHAL PRADESH 12 12 S Q1162
24 24 13 1 NAGALAND NAGALAND 13 13 S Q1599
21 21 14 1 MANIPUR MANIPUR 14 14 S Q1193
23 23 15 1 MIZORAM MIZORAM 15 15 S Q1502
33 33 16 1 TRIPURA ত্রিপুরা 16 16 S Q1363
22 22 17 1 MEGHALAYA MEGHALAYA 17 17 S Q1195
4 4 18 1 ASSAM ASSAM 18 18 S Q1164
36 36 19 1 WEST BENGAL WEST BENGAL 19 19 S Q1356
14 14 20 1 JHARKHAND झारखंड 20 20 S Q1184
25 25 21 1 ODISHA ODISHA 21 21 S Q22048
7 7 22 1 CHHATTISGARH छत्तीसगढ़ 22 22 S Q1168
19 19 23 1 MADHYA PRADESH MADHYA PRADESH 23 23 S Q1188
10 10 24 1 GUJARAT GUJARAT 24 24 S Q1061
20 20 27 1 MAHARASHTRA MAHARASHTRA 27 27 S Q1191
2 2 28 2 ANDHRA PRADESH ANDHRA PRADESH 28 28 S Q1159
15 15 29 1 KARNATAKA ಕರ್ನಾಟಕ 29 29 S Q1185
9 9 30 1 GOA GOA 30 30 S Q1171
18 18 31 1 LAKSHADWEEP LAKSHADWEEP 31 31 U Q26927
16 16 32 1 KERALA KERALA 32 32 S Q1186
30 30 33 1 TAMIL NADU TAMIL NADU 33 33 S Q1445
26 26 34 1 PUDUCHERRY PUDUCHERRY 34 34 U Q66743
1 1 35 1 ANDAMAN AND NICOBAR ISLANDS ANDAMAN AND NICOBAR ISLANDS 35 35 U Q40888
32 32 38 1 THE DADRA AND NAGAR HAVELI AND DAMAN AND DIU THE DADRA AND NAGAR HAVELI AND DAMAN AND DIU 38 38 U Q77997266

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "states" (
	"S.No."	,
	"StateCode"	,
	"StateVersion"	,
	"StateName(InEnglish)"	,
	"StateName(InLocal)"	,
	"Census2001Code"	,
	"Census2011Code"	,
	"StateorUT"	
, "wikidataId"	TEXT);