India Census 2011

Demographic Census Data for India

@kaggle.danofer_india_census

Table List

2 tables(1.1 MB)

India Districts Census 2011

India Census Housing Hlpca Full

@kaggle.danofer_india_census.india_census_housing_hlpca_full

610.54 KB
1908 rows
156 columns
Only the first 100 columns are shown

state_code State Code	state_name State Name	district_code District Code	district_name District Name	tehsil_name Tehsil Name	area_name Area Name	rural_urban Rural/Urban	total_number_of_households Total Number Of Households	total_number_of_good Total Number Of Good	total_number_of_livable Total Number Of Livable	total_number_of_dilapidated Total Number Of Dilapidated	total_number_of_residence_households Total Number Of Residence Households	total_number_of_residence_good Total Number Of Residence Good	total_number_of_residence_livable Total Number Of Residence Livable	total_number_of_residence_dilapidated Total Number Of Residence Dilapidated	total_number_of_residence_cum_other Total Number Of Residence Cum Other	number_of_residence_cum_good Number Of Residence Cum Good	residence_cum_livable Residence Cum Livable	residence_cum_dilapidated Residence Cum Dilapidated	material_roof_gtbw Material Roof GTBW	material_roof_pp Material Roof PP	material_roof_hmt Material Roof HMT	material_roof_mmt Material Roof MMT	material_roof_bb Material Roof BB	material_roof_ss Material Roof SS	material_roof_gmas Material Roof GMAS	material_roof_concrete Material Roof Concrete	material_roof_aom Material Roof AOM	material_roof_gtb Material Roof GTB	material_roof_pp1 Material Roof PP1	material_roof_mub Material Roof MUB	material_roof_wood Material Roof Wood	material_wall_snpwm Material Wall SNPWM	material_wall_spwm Material Wall SPWM	material_wall_gimas Material Wall GIMAS	material_wall_bb Material Wall Bb	material_wall_concrete Material Wall Concrete	material_wall_aom Material Wall AOM	material_floor_mud Material Floor Mud	material_floor_wb Material Floor WB	material_floor_bb Material Floor BB	material_floor_stone Material Floor Stone	material_floor_cement Material Floor Cement	material_floor_mf Material Floor MF	material_floor_aom Material Floor AOM	dwelling_r_ner Dwelling R NER	dwelling_r_or Dwelling R OR	dwelling_r_tr Dwelling R TR	dwelling_r_th_r Dwelling R TH R	dwelling_r_fr Dwelling R FR	dwelling_r_fi_r Dwelling R FI R	dwelling_r_sra Dwelling R SRA	h_size_1 H Size 1	h_size_2 H Size 2	h_size_3 H Size 3	h_size_4 H Size 4	h_size_5 H Size 5	h_size_6_8 H Size 6–8	h_size_9 H Size 9	o_status_o O Status O	o_status_r O Status R	o_status_ao O Status AO	married_c_n Married C N	married_c_1 Married C 1	married_c_2 Married C 2	married_c_3 Married C 3	married_c_4 Married C 4	married_c_5 Married C 5	dw_tfts DW TFTS	dw_tfus DW TFUS	dw_cw DW CW	dw_uw DW UW	dw_handpump DW Handpump	dw_tb DW TB	dw_spring DW Spring	dw_rc DW RC	dw_tpl DW TPL	dw_os DW OS	within_premises Within Premises	near_premises Near Premises	away Away	msl_electricty MSL Electricty	msl_kerosene MSL Kerosene	msl_se MSL SE	msl_oo MSL OO	msl_ao MSL AO	msl_nl MSL NL	latrine_premise Latrine Premise	latrine_pss Latrine PSS	latrine_st Latrine ST	latrine_os Latrine OS	pit_latrine_svi Pit Latrine SVI	pit_latrine_sop Pit Latrine SOP	disposed_drain Disposed Drain	service_latrine_nrh Service Latrine NRH	service_latrine_nsa Service Latrine NSA	h_latrine_premoses H Latrine Premoses
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
);