India Census 2011
Demographic Census Data for India
@kaggle.danofer_india_census
Demographic Census Data for India
@kaggle.danofer_india_census
state_codeState Code | state_nameState Name | district_codeDistrict Code | district_nameDistrict Name | tehsil_codeTehsil Code | tehsil_nameTehsil Name | town_code_village_codeTown Code/Village Code | ward_noWard No | area_nameArea Name | rural_urbanRural/Urban | total_number_of_householdsTotal Number Of Households | total_number_of_goodTotal Number Of Good | total_number_of_livableTotal Number Of Livable | total_number_of_dilapidatedTotal Number Of Dilapidated | total_number_of_residence_householdsTotal Number Of Residence Households | total_number_of_residence_goodTotal Number Of Residence Good | total_number_of_residence_livableTotal Number Of Residence Livable | total_number_of_residence_dilapidatedTotal Number Of Residence Dilapidated | total_number_of_residence_cum_otherTotal Number Of Residence Cum Other | number_of_residence_cum_goodNumber Of Residence Cum Good | residence_cum_livableResidence Cum Livable | residence_cum_dilapidatedResidence Cum Dilapidated | material_roof_gtbwMaterial Roof GTBW | material_roof_ppMaterial Roof PP | material_roof_hmtMaterial Roof HMT | material_roof_mmtMaterial Roof MMT | material_roof_bbMaterial Roof BB | material_roof_ssMaterial Roof SS | material_roof_gmasMaterial Roof GMAS | material_roof_concreteMaterial Roof Concrete | material_roof_aomMaterial Roof AOM | material_roof_gtbMaterial Roof GTB | material_roof_pp1Material Roof PP1 | material_roof_mubMaterial Roof MUB | material_roof_woodMaterial Roof Wood | material_wall_snpwmMaterial Wall SNPWM | material_wall_spwmMaterial Wall SPWM | material_wall_gimasMaterial Wall GIMAS | material_wall_bbMaterial Wall Bb | material_wall_concreteMaterial Wall Concrete | material_wall_aomMaterial Wall AOM | material_floor_mudMaterial Floor Mud | material_floor_wbMaterial Floor WB | material_floor_bbMaterial Floor BB | material_floor_stoneMaterial Floor Stone | material_floor_cementMaterial Floor Cement | material_floor_mfMaterial Floor MF | material_floor_aomMaterial Floor AOM | dwelling_r_nerDwelling R NER | dwelling_r_orDwelling R OR | dwelling_r_trDwelling R TR | dwelling_r_th_rDwelling R TH R | dwelling_r_frDwelling R FR | dwelling_r_fi_rDwelling R FI R | dwelling_r_sraDwelling R SRA | h_size_1H Size 1 | h_size_2H Size 2 | h_size_3H Size 3 | h_size_4H Size 4 | h_size_5H Size 5 | h_size_6_8H Size 6–8 | h_size_9H Size 9 | o_status_oO Status O | o_status_rO Status R | o_status_aoO Status AO | married_c_nMarried C N | married_c_1Married C 1 | married_c_2Married C 2 | married_c_3Married C 3 | married_c_4Married C 4 | married_c_5Married C 5 | dw_tftsDW TFTS | dw_tfusDW TFUS | dw_cwDW CW | dw_uwDW UW | dw_handpumpDW Handpump | dw_tbDW TB | dw_springDW Spring | dw_rcDW RC | dw_tplDW TPL | dw_osDW OS | within_premisesWithin Premises | near_premisesNear Premises | awayAway | msl_electrictyMSL Electricty | msl_keroseneMSL Kerosene | msl_seMSL SE | msl_ooMSL OO | msl_aoMSL AO | msl_nlMSL NL | latrine_premiseLatrine Premise | latrine_pssLatrine PSS | latrine_stLatrine ST | latrine_osLatrine OS | pit_latrine_sviPit Latrine SVI | pit_latrine_sopPit Latrine SOP | disposed_drainDisposed Drain | service_latrine_nrhService Latrine NRH | service_latrine_nsaService Latrine NSA | h_latrine_premosesH Latrine Premoses | alternative_sourceAlternative Source | alternative_source_openAlternative Source Open | households_bathroomHouseholds Bathroom | households_ewrHouseholds EWR | households_noHouseholds No | waste_water_cdWaste Water CD | waste_water_odWaste Water OD | waste_water_ndWaste Water ND | cooking_fwCooking FW | cooking_crCooking CR | cooking_ccCooking CC | cooking_clcCooking CLC | cooking_keroseneCooking Kerosene | cooking_lpg_pngCooking LPG PNG | cooking_electricityCooking Electricity | cooking_biogasCooking Biogas | cooking_aoCooking AO | cooking_ncCooking NC | totalTotal | cooking_ihCooking IH | has_kitchenHas Kitchen | dnhkDNHK | cooking_ohCooking OH | has_kitchen1Has Kitchen1 | dnh_kitchenDNH Kitchen | no_cookingNo Cooking | tnhabTNHAB | assets_rtAssets RT | assets_telAssets Tel | assets_cl_wiAssets CL WI | assets_clwiAssets CLWI | assets_tm_loAssets TM LO | assets_tm_moAssets TM MO | assets_tm_bothAssets TM Both | assets_bicycleAssets Bicycle | assets_smmAssets SMM | assets_cjvAssets CJV | household_tv_lpHousehold TV LP | none_asNone AS | permanentsPermanents | semi_permanentSemi Permanent | total_temporaryTotal Temporary | serviceableServiceable | non_serviceableNon Serviceable | unclassifiableUnclassifiable | tc_vcTC VC | contition_t_totalContition T Total | contition_t_goodContition T Good | contition_t_livableContition T Livable | contition_t_dilapidatedContition T Dilapidated | contition_r_totalContition R Total | residence_goodResidence Good | residence_livableResidence Livable | residence_dilapidatedResidence Dilapidated | residence_cum_otherResidence Cum Other | residence_cum_goodResidence Cum Good |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | JAMMU & KASHMIR | 1 | Kupwara | Kupwara | District - Kupwara | Rural | 100 | 33.6 | 58.1 | 8.3 | 90.9 | 32.7 | 51 | 7.2 | 9.1 | 1 | 7.1 | 1.1 | 7.8 | 0.1 | 0.3 | 0.2 | 0.1 | 1.1 | 87.1 | 0.6 | 2.6 | 0.5 | 0.4 | 11.1 | 31.1 | 7.3 | 2.2 | 0.3 | 44.7 | 1.4 | 1 | 55.9 | 6.6 | 0.3 | 3.6 | 33.5 | 0.1 | 0.1 | 2.7 | 21.3 | 27 | 25.3 | 12.8 | 3.5 | 7.3 | 0.8 | 3.8 | 5.9 | 10 | 13.9 | 40.3 | 25.2 | 98.2 | 0.4 | 1.4 | 8.4 | 75.6 | 13.6 | 2 | 0.3 | 0.1 | 11.8 | 33.5 | 5 | 10.7 | 2.8 | 1.7 | 1.8 | 24.8 | 1.6 | 6.2 | 19 | 36 | 45 | 76.5 | 11.1 | 3 | 1.2 | 4.9 | 3.2 | 48.9 | 4.6 | 4.4 | 10.2 | 2.8 | 6.3 | 2.2 | 17.8 | 0.7 | 51.1 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
1 | JAMMU & KASHMIR | 1 | Kupwara | Kupwara | District - Kupwara | Total | 100 | 34.8 | 57.3 | 7.9 | 91 | 33.8 | 50.2 | 6.9 | 9 | 0.9 | 7.1 | 1 | 7.3 | 0.1 | 0.3 | 0.2 | 0.1 | 1.1 | 87.5 | 0.7 | 2.6 | 0.5 | 0.4 | 11.4 | 28.6 | 7.9 | 2.4 | 0.3 | 46.2 | 1.4 | 1 | 53.7 | 6.3 | 0.4 | 3.5 | 36 | 0.1 | 2.7 | 20.6 | 27 | 25.7 | 12.8 | 3.6 | 7.6 | 0.9 | 3.8 | 6 | 10 | 13.9 | 40 | 25.4 | 98.2 | 0.6 | 1.3 | 8.4 | 75.5 | 13.7 | 2.1 | 0.3 | 0.1 | 13 | 34.1 | 5.1 | 10.4 | 2.8 | 1.9 | 1.8 | 23.2 | 1.5 | 6.2 | 21.3 | 35.4 | 43.2 | 77.8 | 10.4 | 2.8 | 1.1 | 4.8 | 3.1 | 50.9 | 4.8 | 6.2 | 10.2 | 3 | 6.2 | 2.1 | 17.6 | 0.8 | 49.1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
1 | JAMMU & KASHMIR | 1 | Kupwara | Kupwara | District - Kupwara | Urban | 100 | 45.7 | 49.5 | 4.8 | 91.8 | 45 | 42.2 | 4.5 | 8.2 | 0.7 | 7.3 | 0.2 | 2.9 | 0.2 | 0.4 | 0.1 | 0.8 | 91.3 | 2 | 2.2 | 0.4 | 0.2 | 14 | 4.8 | 13.2 | 4.6 | 0.2 | 60.6 | 0.8 | 1.2 | 32.3 | 3.3 | 1.1 | 2.7 | 60.5 | 0.1 | 2.1 | 14 | 26.2 | 29.8 | 12.9 | 4.6 | 10.4 | 1 | 3.5 | 6.4 | 10.2 | 14.6 | 37.3 | 27 | 97.5 | 2.2 | 0.4 | 8.4 | 74.1 | 14.6 | 2.4 | 0.4 | 0.1 | 25.1 | 40 | 5.4 | 7.7 | 2.6 | 3.8 | 1.1 | 8 | 0.3 | 6 | 43.9 | 29.7 | 26.4 | 90.2 | 3.2 | 0.3 | 1 | 3.5 | 1.7 | 70.2 | 6.6 | 23.5 | 10.9 | 5.2 | 5.1 | 1.3 | 16.2 | 1.4 | 29.8 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
1 | JAMMU & KASHMIR | 2 | Badgam | Badgam | District - Badgam | Rural | 100 | 49.7 | 46.3 | 3.9 | 97.2 | 49 | 44.5 | 3.7 | 2.8 | 0.7 | 1.8 | 0.2 | 2.6 | 0.2 | 0.4 | 0.1 | 0.7 | 92.2 | 1.8 | 2.1 | 0.2 | 0.2 | 8.4 | 1.1 | 0.9 | 0.4 | 0.3 | 85.7 | 1.2 | 1.8 | 47.2 | 1.9 | 0.3 | 2.4 | 48 | 0.1 | 0.1 | 2.2 | 14.8 | 25.9 | 23.6 | 18.2 | 5.3 | 10 | 0.8 | 2.1 | 3.4 | 7.1 | 11 | 61.5 | 14 | 98.9 | 0.5 | 0.6 | 8.9 | 72.4 | 15.4 | 2.9 | 0.4 | 0.1 | 26.2 | 45.6 | 0.7 | 0.8 | 8.2 | 2.1 | 0.5 | 14.7 | 1.2 | 48.3 | 35.9 | 15.8 | 89.8 | 6.7 | 1.6 | 0.1 | 1.3 | 0.4 | 83.3 | 6.7 | 12.3 | 9.8 | 3.1 | 4.6 | 0.6 | 45.8 | 0.5 | 16.7 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
1 | JAMMU & KASHMIR | 2 | Badgam | Badgam | District - Badgam | Total | 100 | 51.6 | 44.7 | 3.8 | 97.3 | 50.8 | 43 | 3.5 | 2.7 | 0.8 | 1.7 | 0.2 | 2.8 | 0.2 | 0.4 | 0.1 | 0.7 | 91.6 | 2.2 | 1.9 | 0.2 | 0.2 | 8.2 | 1 | 0.9 | 0.3 | 0.3 | 85.8 | 1.5 | 1.6 | 43.2 | 1.8 | 0.5 | 2.2 | 52.1 | 0.1 | 0.1 | 2.3 | 14.2 | 25.3 | 24.1 | 17.9 | 5.5 | 10.8 | 0.9 | 2.2 | 3.8 | 8.1 | 12 | 59.6 | 13.5 | 98.8 | 0.6 | 0.6 | 9.1 | 72 | 15.4 | 3 | 0.5 | 0.1 | 30.4 | 43.5 | 0.7 | 0.7 | 7.6 | 2.3 | 0.5 | 13.2 | 0.1 | 1.1 | 51.8 | 33.8 | 14.4 | 90.9 | 6 | 1.4 | 0.1 | 1.2 | 0.4 | 84.3 | 8.1 | 15.5 | 9.3 | 2.9 | 4.1 | 1.8 | 41.8 | 0.7 | 15.7 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
1 | JAMMU & KASHMIR | 2 | Badgam | Badgam | District - Badgam | Urban | 100 | 63.6 | 33.8 | 2.6 | 98.1 | 62.5 | 33.2 | 2.4 | 1.9 | 1.1 | 0.6 | 0.2 | 4.6 | 0.3 | 0.5 | 0.2 | 0.4 | 88 | 5 | 0.9 | 0.4 | 0.2 | 7.1 | 0.2 | 1.4 | 0.2 | 0.3 | 86 | 3.5 | 0.7 | 17.1 | 1 | 1.6 | 1 | 79.1 | 0.2 | 2.7 | 10.2 | 21.4 | 27.5 | 15.8 | 6.7 | 15.7 | 1 | 2.7 | 6 | 14.1 | 18.8 | 46.9 | 10.5 | 98 | 1.6 | 0.5 | 10.7 | 69.5 | 15.3 | 3.7 | 0.7 | 0.1 | 58.1 | 29.4 | 0.2 | 0.1 | 3.8 | 4.1 | 0.1 | 3.2 | 0.7 | 0.4 | 74.4 | 20.2 | 5.4 | 97.9 | 1.7 | 0.1 | 0.1 | 0.2 | 90.4 | 17.9 | 36.3 | 6.1 | 1.9 | 1 | 9.8 | 15.6 | 1.7 | 9.6 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
1 | JAMMU & KASHMIR | 3 | Leh(Ladakh) | Leh(Ladakh) | District - Leh(Ladakh) | Rural | 100 | 46.4 | 51.5 | 2.1 | 98.6 | 45.8 | 50.8 | 2 | 1.4 | 0.6 | 0.7 | 97.3 | 0.1 | 0.1 | 0.1 | 0.6 | 0.5 | 1.2 | 0.2 | 0.1 | 59 | 0.7 | 25.9 | 12.7 | 0.1 | 0.1 | 1.2 | 90.2 | 1.3 | 0.7 | 0.2 | 6.7 | 0.1 | 0.7 | 7.4 | 19.8 | 22.6 | 18.5 | 13.8 | 8 | 9.9 | 8 | 6.8 | 9.8 | 18.4 | 17.9 | 28.9 | 10.3 | 95.3 | 2.3 | 2.4 | 17.3 | 59.3 | 18.7 | 4.1 | 0.5 | 0.2 | 3.9 | 18.5 | 0.5 | 0.4 | 27.5 | 0.4 | 4 | 40.3 | 0.1 | 4.3 | 10.5 | 55.7 | 33.8 | 76.3 | 4.9 | 18 | 0.1 | 0.3 | 0.5 | 88.1 | 1.7 | 1.3 | 4.4 | 65.8 | 4.5 | 10.4 | 0.1 | 11.9 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
1 | JAMMU & KASHMIR | 3 | Leh(Ladakh) | Leh(Ladakh) | District - Leh(Ladakh) | Total | 100 | 45.8 | 52.4 | 1.8 | 98.7 | 45.1 | 51.8 | 1.8 | 1.3 | 0.7 | 0.6 | 95.8 | 0.2 | 0.2 | 0.1 | 0.1 | 0.3 | 0.8 | 1.5 | 1.1 | 0.5 | 0.2 | 68.2 | 0.6 | 19.6 | 9.8 | 0.1 | 0.2 | 0.8 | 81.6 | 1.3 | 0.6 | 0.3 | 15.5 | 0.2 | 0.5 | 7.3 | 19.3 | 21.1 | 17.9 | 14.5 | 8.2 | 11.6 | 7.8 | 7.1 | 11.1 | 21.3 | 18.3 | 25.9 | 8.5 | 93.3 | 4.3 | 2.4 | 17.8 | 61.3 | 16.8 | 3.4 | 0.4 | 0.2 | 9.5 | 20.6 | 0.5 | 0.3 | 28.2 | 0.6 | 3 | 29.4 | 0.3 | 7.5 | 14.6 | 52.8 | 32.7 | 83 | 3.5 | 12.7 | 0.1 | 0.3 | 0.4 | 90.4 | 2.6 | 2.1 | 3.3 | 67.9 | 4.2 | 0.3 | 9.8 | 0.1 | 9.6 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
1 | JAMMU & KASHMIR | 3 | Leh(Ladakh) | Leh(Ladakh) | District - Leh(Ladakh) | Urban | 100 | 44.3 | 54.6 | 1.1 | 98.7 | 43.4 | 54.2 | 1.1 | 1.3 | 0.9 | 0.4 | 92.3 | 0.4 | 0.3 | 0.1 | 0.2 | 0.9 | 1.2 | 3.9 | 0.8 | 1.1 | 0.2 | 89.7 | 0.2 | 4.8 | 3.1 | 0.2 | 0.5 | 61.2 | 1.2 | 0.4 | 0.3 | 36.3 | 0.6 | 0.1 | 7.1 | 18.2 | 17.4 | 16.6 | 16.3 | 8.7 | 15.6 | 7.5 | 8 | 14.1 | 28 | 19.4 | 18.8 | 4.1 | 88.6 | 9 | 2.4 | 19.2 | 66.1 | 12.4 | 2 | 0.3 | 0.1 | 22.5 | 25.7 | 0.6 | 0.1 | 29.8 | 1.1 | 0.7 | 3.7 | 0.6 | 15.2 | 24.2 | 45.9 | 29.9 | 98.9 | 0.4 | 0.4 | 0.1 | 0.2 | 95.8 | 4.8 | 4.2 | 1 | 73 | 3.4 | 0.8 | 8.4 | 0.2 | 4.2 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
1 | JAMMU & KASHMIR | 4 | Kargil | Kargil | District - Kargil | Rural | 100 | 23.2 | 73.3 | 3.5 | 96.4 | 22.7 | 70.5 | 3.1 | 3.6 | 0.5 | 2.7 | 0.4 | 97.2 | 0.1 | 0.1 | 0.2 | 2.4 | 0.1 | 0.1 | 42.1 | 0.1 | 45.3 | 12.2 | 0.1 | 95.7 | 2.6 | 1.6 | 0.1 | 2.1 | 14.2 | 30.8 | 23 | 14.2 | 6.7 | 8.9 | 2.9 | 3.5 | 4.4 | 8.4 | 12.6 | 39.2 | 29 | 97.5 | 1.8 | 0.7 | 9.6 | 57.8 | 22.8 | 7.4 | 1.8 | 0.5 | 8.4 | 52.8 | 0.5 | 14.2 | 0.1 | 2.1 | 16.8 | 1.1 | 4 | 7.3 | 53.2 | 39.5 | 84.6 | 3.3 | 11.7 | 0.1 | 0.1 | 0.2 | 96.8 | 1.3 | 1.4 | 52.9 | 1 | 9.9 | 0.2 | 29.7 | 0.2 | 3.2 |
CREATE TABLE india_census_housing_hlpca_full (
"state_code" BIGINT,
"state_name" VARCHAR,
"district_code" BIGINT,
"district_name" VARCHAR,
"tehsil_code" BIGINT,
"tehsil_name" VARCHAR,
"town_code_village_code" BIGINT,
"ward_no" BIGINT,
"area_name" VARCHAR,
"rural_urban" VARCHAR,
"total_number_of_households" BIGINT,
"total_number_of_good" DOUBLE,
"total_number_of_livable" DOUBLE,
"total_number_of_dilapidated" DOUBLE,
"total_number_of_residence_households" DOUBLE,
"total_number_of_residence_good" DOUBLE,
"total_number_of_residence_livable" DOUBLE,
"total_number_of_residence_dilapidated" DOUBLE,
"total_number_of_residence_cum_other" DOUBLE,
"number_of_residence_cum_good" DOUBLE,
"residence_cum_livable" DOUBLE,
"residence_cum_dilapidated" DOUBLE,
"material_roof_gtbw" DOUBLE,
"material_roof_pp" DOUBLE,
"material_roof_hmt" DOUBLE,
"material_roof_mmt" DOUBLE,
"material_roof_bb" DOUBLE,
"material_roof_ss" DOUBLE,
"material_roof_gmas" DOUBLE,
"material_roof_concrete" DOUBLE,
"material_roof_aom" DOUBLE,
"material_roof_gtb" DOUBLE,
"material_roof_pp1" DOUBLE,
"material_roof_mub" DOUBLE,
"material_roof_wood" DOUBLE,
"material_wall_snpwm" DOUBLE,
"material_wall_spwm" DOUBLE,
"material_wall_gimas" DOUBLE,
"material_wall_bb" DOUBLE,
"material_wall_concrete" DOUBLE,
"material_wall_aom" DOUBLE,
"material_floor_mud" DOUBLE,
"material_floor_wb" DOUBLE,
"material_floor_bb" DOUBLE,
"material_floor_stone" DOUBLE,
"material_floor_cement" DOUBLE,
"material_floor_mf" DOUBLE,
"material_floor_aom" DOUBLE,
"dwelling_r_ner" DOUBLE,
"dwelling_r_or" DOUBLE,
"dwelling_r_tr" DOUBLE,
"dwelling_r_th_r" DOUBLE,
"dwelling_r_fr" DOUBLE,
"dwelling_r_fi_r" DOUBLE,
"dwelling_r_sra" DOUBLE,
"h_size_1" DOUBLE,
"h_size_2" DOUBLE,
"h_size_3" DOUBLE,
"h_size_4" DOUBLE,
"h_size_5" DOUBLE,
"h_size_6_8" DOUBLE,
"h_size_9" DOUBLE,
"o_status_o" DOUBLE,
"o_status_r" DOUBLE,
"o_status_ao" DOUBLE,
"married_c_n" DOUBLE,
"married_c_1" DOUBLE,
"married_c_2" DOUBLE,
"married_c_3" DOUBLE,
"married_c_4" DOUBLE,
"married_c_5" DOUBLE,
"dw_tfts" DOUBLE,
"dw_tfus" DOUBLE,
"dw_cw" DOUBLE,
"dw_uw" DOUBLE,
"dw_handpump" DOUBLE,
"dw_tb" DOUBLE,
"dw_spring" DOUBLE,
"dw_rc" DOUBLE,
"dw_tpl" DOUBLE,
"dw_os" DOUBLE,
"within_premises" DOUBLE,
"near_premises" DOUBLE,
"away" DOUBLE,
"msl_electricty" DOUBLE,
"msl_kerosene" DOUBLE,
"msl_se" DOUBLE,
"msl_oo" DOUBLE,
"msl_ao" DOUBLE,
"msl_nl" DOUBLE,
"latrine_premise" DOUBLE,
"latrine_pss" DOUBLE,
"latrine_st" DOUBLE,
"latrine_os" DOUBLE,
"pit_latrine_svi" DOUBLE,
"pit_latrine_sop" DOUBLE,
"disposed_drain" DOUBLE,
"service_latrine_nrh" DOUBLE,
"service_latrine_nsa" DOUBLE,
"h_latrine_premoses" DOUBLE
);
Anyone who has the link will be able to view this.