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

121 rows where DistrictVersion = 2

View and edit SQL

DistrictVersion

Link rowid ▼ S.No. StateCode StateName(InEnglish) DistrictCode DistrictVersion DistrictName(InEnglish) DistrictName(InLocal) Census2001Code Census2011Code wikidataId
636 636 5 UTTARAKHAND 57 2 UTTAR KASHI UTTAR KASHI 01 056 Q1773437
640 640 9 UTTAR PRADESH 640 2 Amethi Amethi   000 Q1071494
641 641 9 UTTAR PRADESH 154 2 AMROHA AMROHA 06 137 Q1891677
643 643 9 UTTAR PRADESH 140 2 AYODHYA AYODHYA 47 177 Q1814132
653 653 9 UTTAR PRADESH 179 2 BHADOHI BHADOHI 68 198 Q127533
655 655 9 UTTAR PRADESH 133 2 BUDAUN BUDAUN 19 149 Q1815262
666 666 9 UTTAR PRADESH 145 2 GHAZIABAD GHAZIABAD 09 140 Q1773444
671 671 9 UTTAR PRADESH 661 2 HAPUR HAPUR   000 Q5653340
673 673 9 UTTAR PRADESH 163 2 HATHRAS HATHRAS 13 144 Q1814892
680 680 9 UTTAR PRADESH 633 2 Kasganj Kasganj   202 Q890800
693 693 9 UTTAR PRADESH 171 2 MORADABAD MORADABAD 04 135 Q1345006
694 694 9 UTTAR PRADESH 172 2 MUZAFFARNAGAR MUZAFFARNAGAR 02 133 Q2365710
697 697 9 UTTAR PRADESH 120 2 PRAYAGRAJ PRAYAGRAJ 45 175 Q1773426
701 701 9 UTTAR PRADESH 659 2 SAMBHAL SAMBHAL   000 Q3000436
704 704 9 UTTAR PRADESH 660 2 SHAMLI SHAMLI   000 Q2999938
718 718 19 WEST BENGAL 309 2 DARJEELING DARJEELING 01 327 Q1134759
721 721 19 WEST BENGAL 312 2 HOOGHLY HOOGHLY 12 338 Q548518
723 723 19 WEST BENGAL 314 2 JALPAIGURI JALPAIGURI 02 328 Q1351487
724 724 19 WEST BENGAL 703 2 Jhargram Jhargram   000 Q29168456
729 729 19 WEST BENGAL 318 2 MEDINIPUR WEST MEDINIPUR WEST 15 344 Q1855537
731 731 19 WEST BENGAL 320 2 NADIA NADIA 10 336 Q1143880

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "districts" (
	"S.No."	,
	"StateCode"	,
	"StateName(InEnglish)"	,
	"DistrictCode"	,
	"DistrictVersion"	,
	"DistrictName(InEnglish)"	,
	"DistrictName(InLocal)"	,
	"Census2001Code"	,
	"Census2011Code"	
, "wikidataId"	TEXT);