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

8 rows where StateorUT = "U" sorted by wikidataId

View and edit SQL

Suggested facets: StateVersion, Census2001Code

StateorUT

Link rowid S.No. StateCode StateVersion StateName(InEnglish) StateName(InLocal) Census2001Code Census2011Code StateorUT wikidataId ▼
8 8 7 1 DELHI DELHI 07 07 U Q1353
17 17 37 1 LADAKH   01 00 U Q200667
18 18 31 1 LAKSHADWEEP LAKSHADWEEP 31 31 U Q26927
1 1 35 1 ANDAMAN AND NICOBAR ISLANDS ANDAMAN AND NICOBAR ISLANDS 35 35 U Q40888
6 6 4 1 CHANDIGARH CHANDIGARH 04 04 U Q43433
13 13 1 3 JAMMU AND KASHMIR JAMMU AND KASHMIR 01 01 U Q66278313
26 26 34 1 PUDUCHERRY PUDUCHERRY 34 34 U Q66743
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);