India Census 2011

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
);

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
);