states
Data source: DataMeet · About: https://github.com/datameet/india-local-government-directory
8 rows where StateorUT = "U" sorted by rowid descending
This data as json, CSV (advanced)
Suggested facets: StateVersion, Census2001Code
Link | rowid ▲ | S.No. | StateCode | StateVersion | StateName(InEnglish) | StateName(InLocal) | Census2001Code | Census2011Code | StateorUT | wikidataId |
---|---|---|---|---|---|---|---|---|---|---|
32 | 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 |
26 | 26 | 26 | 34 | 1 | PUDUCHERRY | PUDUCHERRY | 34 | 34 | U | Q66743 |
18 | 18 | 18 | 31 | 1 | LAKSHADWEEP | LAKSHADWEEP | 31 | 31 | U | Q26927 |
17 | 17 | 17 | 37 | 1 | LADAKH | 01 | 00 | U | Q200667 | |
13 | 13 | 13 | 1 | 3 | JAMMU AND KASHMIR | JAMMU AND KASHMIR | 01 | 01 | U | Q66278313 |
8 | 8 | 8 | 7 | 1 | DELHI | DELHI | 07 | 07 | U | Q1353 |
6 | 6 | 6 | 4 | 1 | CHANDIGARH | CHANDIGARH | 04 | 04 | U | Q43433 |
1 | 1 | 1 | 35 | 1 | ANDAMAN AND NICOBAR ISLANDS | ANDAMAN AND NICOBAR ISLANDS | 35 | 35 | U | Q40888 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "states" ( "S.No." , "StateCode" , "StateVersion" , "StateName(InEnglish)" , "StateName(InLocal)" , "Census2001Code" , "Census2011Code" , "StateorUT" , "wikidataId" TEXT);