India Census 2011
Demographic Census Data for India
@kaggle.danofer_india_census
Demographic Census Data for India
@kaggle.danofer_india_census
CREATE TABLE india_districts_census_2011 (
"district_code" BIGINT,
"state_name" VARCHAR,
"district_name" VARCHAR,
"population" BIGINT,
"male" BIGINT,
"female" BIGINT,
"literate" BIGINT,
"male_literate" BIGINT,
"female_literate" BIGINT,
"sc" BIGINT,
"male_sc" BIGINT,
"female_sc" BIGINT,
"st" BIGINT,
"male_st" BIGINT,
"female_st" BIGINT,
"workers" BIGINT,
"male_workers" BIGINT,
"female_workers" BIGINT,
"main_workers" BIGINT,
"marginal_workers" BIGINT,
"non_workers" BIGINT,
"cultivator_workers" BIGINT,
"agricultural_workers" BIGINT,
"household_workers" BIGINT,
"other_workers" BIGINT,
"hindus" BIGINT,
"muslims" BIGINT,
"christians" BIGINT,
"sikhs" BIGINT,
"buddhists" BIGINT,
"jains" BIGINT,
"others_religions" BIGINT,
"religion_not_stated" BIGINT,
"lpg_or_png_households" BIGINT,
"housholds_with_electric_lighting" BIGINT,
"households_with_internet" BIGINT,
"households_with_computer" BIGINT,
"rural_households" BIGINT,
"urban_households" BIGINT,
"households" BIGINT,
"below_primary_education" BIGINT,
"primary_education" BIGINT,
"middle_education" BIGINT,
"secondary_education" BIGINT,
"higher_education" BIGINT,
"graduate_education" BIGINT,
"other_education" BIGINT,
"literate_education" BIGINT,
"illiterate_education" BIGINT,
"total_education" BIGINT,
"age_group_0_29" BIGINT,
"age_group_30_49" BIGINT,
"age_group_50" BIGINT,
"age_not_stated" BIGINT,
"households_with_bicycle" BIGINT,
"households_with_car_jeep_van" BIGINT,
"households_with_radio_transistor" BIGINT,
"households_with_scooter_motorcycle_moped" BIGINT,
"households_with_telephone_mobile_phone_landline_only" BIGINT,
"households_with_telephone_mobile_phone_mobile_only" BIGINT,
"households_with_tv_computer_laptop_telephone_mobile_ph_7528d1ac" BIGINT,
"households_with_television" BIGINT,
"households_with_telephone_mobile_phone" BIGINT,
"households_with_telephone_mobile_phone_both" BIGINT,
"condition_of_occupied_census_houses_dilapidated_households" BIGINT,
"households_with_separate_kitchen_cooking_inside_house" BIGINT,
"having_bathing_facility_total_households" BIGINT,
"having_latrine_facility_within_the_premises_total_households" BIGINT,
"ownership_owned_households" BIGINT,
"ownership_rented_households" BIGINT,
"type_of_bathing_facility_enclosure_without_roof_households" BIGINT,
"type_of_fuel_used_for_cooking_any_other_households" BIGINT,
"type_of_latrine_facility_pit_latrine_households" BIGINT,
"type_of_latrine_facility_other_latrine_households" BIGINT,
"type_of_latrine_facility_night_soil_disposed_into_open_a1606375" BIGINT,
"type_of_latrine_facility_flush_pour_flush_latrine_conn_7d780936" BIGINT,
"not_having_bathing_facility_within_the_premises_total__9f8a46fc" BIGINT,
"not_having_latrine_facility_within_the_premises_altern_ba52e6d9" BIGINT,
"main_source_of_drinking_water_un_covered_well_households" BIGINT,
"main_source_of_drinking_water_handpump_tubewell_borewe_1821b075" BIGINT,
"main_source_of_drinking_water_spring_households" BIGINT,
"main_source_of_drinking_water_river_canal_households" BIGINT,
"main_source_of_drinking_water_other_sources_households" BIGINT,
"main_source_of_drinking_water_other_sources_spring_riv_74272086" BIGINT,
"location_of_drinking_water_source_near_the_premises_households" BIGINT,
"location_of_drinking_water_source_within_the_premises__76d9f44a" BIGINT,
"main_source_of_drinking_water_tank_pond_lake_households" BIGINT,
"main_source_of_drinking_water_tapwater_households" BIGINT,
"main_source_of_drinking_water_tubewell_borehole_households" BIGINT,
"household_size_1_person_households" BIGINT,
"household_size_2_persons_households" BIGINT,
"household_size_1_to_2_persons" BIGINT,
"household_size_3_persons_households" BIGINT,
"household_size_3_to_5_persons_households" BIGINT,
"household_size_4_persons_households" BIGINT,
"household_size_5_persons_households" BIGINT,
"household_size_6_8_persons_households" BIGINT,
"household_size_9_persons_and_above_households" BIGINT,
"location_of_drinking_water_source_away_households" BIGINT,
"married_couples_1_households" BIGINT
);
Anyone who has the link will be able to view this.