Health Analytics
26 health indicators (642 variables) from 9 states and 284 districts of India
@kaggle.rajanand_key_indicators_of_annual_health_survey
26 health indicators (642 variables) from 9 states and 284 districts of India
@kaggle.rajanand_key_indicators_of_annual_health_survey
CREATE TABLE key_indicator_districtwise (
"state_name" VARCHAR,
"state_district_name" VARCHAR,
"aa_sample_units_total" BIGINT,
"aa_sample_units_rural" BIGINT,
"aa_sample_units_urban" BIGINT,
"aa_households_total" BIGINT,
"aa_households_rural" BIGINT,
"aa_households_urban" BIGINT,
"aa_population_total" BIGINT,
"aa_population_rural" BIGINT,
"aa_population_urban" BIGINT,
"aa_ever_married_women_aged_15_49_years_total" DOUBLE,
"aa_ever_married_women_aged_15_49_years_rural" DOUBLE,
"aa_ever_married_women_aged_15_49_years_urban" BIGINT,
"aa_currently_married_women_aged_15_49_years_total" DOUBLE,
"aa_currently_married_women_aged_15_49_years_rural" DOUBLE,
"aa_currently_married_women_aged_15_49_years_urban" BIGINT,
"aa_children_12_23_months_total" BIGINT,
"aa_children_12_23_months_rural" BIGINT,
"aa_children_12_23_months_urban" BIGINT,
"bb_average_household_size_sc_total" DOUBLE,
"bb_average_household_size_sc_rural" DOUBLE,
"bb_average_household_size_sc_urban" DOUBLE,
"bb_average_household_size_st_total" DOUBLE,
"bb_average_household_size_st_rural" DOUBLE,
"bb_average_household_size_st_urban" DOUBLE,
"bb_average_household_size_all_total" DOUBLE,
"bb_average_household_size_all_rural" DOUBLE,
"bb_average_household_size_all_urban" DOUBLE,
"bb_population_below_age_15_years_total" DOUBLE,
"bb_population_below_age_15_years_rural" DOUBLE,
"bb_population_below_age_15_years_urban" DOUBLE,
"bb_dependency_ratio_total" DOUBLE,
"bb_dependency_ratio_rural" DOUBLE,
"bb_dependency_ratio_urban" DOUBLE,
"bb_currently_married_illiterate_women_aged_15_49_years_total" DOUBLE,
"bb_currently_married_illiterate_women_aged_15_49_years_rural" DOUBLE,
"bb_currently_married_illiterate_women_aged_15_49_years_urban" DOUBLE,
"cc_sex_ratio_at_birth_total" DOUBLE,
"cc_sex_ratio_at_birth_rural" DOUBLE,
"cc_sex_ratio_at_birth_urban" DOUBLE,
"cc_sex_ratio_0_4_years_total" DOUBLE,
"cc_sex_ratio_0_4_years_rural" DOUBLE,
"cc_sex_ratio_0_4_years_urban" DOUBLE,
"cc_sex_ratio_all_ages_total" DOUBLE,
"cc_sex_ratio_all_ages_rural" DOUBLE,
"cc_sex_ratio_all_ages_urban" DOUBLE,
"dd_person_total" DOUBLE,
"dd_person_rural" DOUBLE,
"dd_person_urban" DOUBLE,
"dd_male_total" DOUBLE,
"dd_male_rural" DOUBLE,
"dd_male_urban" DOUBLE,
"dd_female_total" DOUBLE,
"dd_female_rural" DOUBLE,
"dd_female_urban" DOUBLE,
"ee_marriages_among_females_below_legal_age_18_years_total" DOUBLE,
"ee_marriages_among_females_below_legal_age_18_years_rural" DOUBLE,
"ee_marriages_among_females_below_legal_age_18_years_urban" DOUBLE,
"ee_marriages_among_males_below_legal_age_21_years_total" DOUBLE,
"ee_marriages_among_males_below_legal_age_21_years_rural" DOUBLE,
"ee_marriages_among_males_below_legal_age_21_years_urban" DOUBLE,
"ee_currently_married_women_aged_20_24_years_married_be_7a9b88c3" DOUBLE,
"ee_currently_married_women_aged_20_24_years_married_be_e1d4ab25" DOUBLE,
"ee_currently_married_women_aged_20_24_years_married_be_d3a0c3ff" DOUBLE,
"ee_currently_married_men_aged_25_29_years_married_befo_ae1ad5e9" DOUBLE,
"ee_currently_married_men_aged_25_29_years_married_befo_93a7cd96" DOUBLE,
"ee_currently_married_men_aged_25_29_years_married_befo_b9bb4c85" DOUBLE,
"ee_mean_age_at_marriage_male_total" DOUBLE,
"ee_mean_age_at_marriage_male_rural" DOUBLE,
"ee_mean_age_at_marriage_male_urban" DOUBLE,
"ee_mean_age_at_marriage_female_total" DOUBLE,
"ee_mean_age_at_marriage_female_rural" DOUBLE,
"ee_mean_age_at_marriage_female_urban" DOUBLE,
"ff_children_currently_attending_school_age_6_17_years__994e1441" DOUBLE,
"ff_children_currently_attending_school_age_6_17_years__93dd0b59" DOUBLE,
"ff_children_currently_attending_school_age_6_17_years__255e542b" DOUBLE,
"ff_children_currently_attending_school_age_6_17_years__03e74820" DOUBLE,
"ff_children_currently_attending_school_age_6_17_years__db81f59d" DOUBLE,
"ff_children_currently_attending_school_age_6_17_years__19c89214" DOUBLE,
"ff_children_currently_attending_school_age_6_17_years__bc274b5b" DOUBLE,
"ff_children_currently_attending_school_age_6_17_years__ffabbb76" DOUBLE,
"ff_children_currently_attending_school_age_6_17_years__46b190f0" DOUBLE,
"ff_children_attended_before_drop_out_age_6_17_years_pe_6e58663d" DOUBLE,
"ff_children_attended_before_drop_out_age_6_17_years_pe_d7549f4f" DOUBLE,
"ff_children_attended_before_drop_out_age_6_17_years_pe_71f844a9" DOUBLE,
"ff_children_attended_before_drop_out_age_6_17_years_male_total" DOUBLE,
"ff_children_attended_before_drop_out_age_6_17_years_male_rural" DOUBLE,
"ff_children_attended_before_drop_out_age_6_17_years_male_urban" DOUBLE,
"ff_children_attended_before_drop_out_age_6_17_years_fe_e56064c9" DOUBLE,
"ff_children_attended_before_drop_out_age_6_17_years_fe_fe4de0d1" DOUBLE,
"ff_children_attended_before_drop_out_age_6_17_years_fe_955021de" DOUBLE,
"gg_children_aged_5_14_years_engaged_in_work_person_total" DOUBLE,
"gg_children_aged_5_14_years_engaged_in_work_person_rural" DOUBLE,
"gg_children_aged_5_14_years_engaged_in_work_person_urban" DOUBLE,
"gg_children_aged_5_14_years_engaged_in_work_male_total" DOUBLE,
"gg_children_aged_5_14_years_engaged_in_work_male_rural" DOUBLE,
"gg_children_aged_5_14_years_engaged_in_work_male_urban" DOUBLE,
"gg_children_aged_5_14_years_engaged_in_work_female_total" DOUBLE,
"gg_children_aged_5_14_years_engaged_in_work_female_rural" DOUBLE
);
CREATE TABLE key_indicator_statewise (
"state_name" VARCHAR,
"aa_sample_units_total" BIGINT,
"aa_sample_units_rural" BIGINT,
"aa_sample_units_urban" BIGINT,
"aa_households_total" BIGINT,
"aa_households_rural" BIGINT,
"aa_households_urban" BIGINT,
"aa_population_total" BIGINT,
"aa_population_rural" BIGINT,
"aa_population_urban" BIGINT,
"aa_ever_married_women_aged_15_49_years_total" DOUBLE,
"aa_ever_married_women_aged_15_49_years_rural" DOUBLE,
"aa_ever_married_women_aged_15_49_years_urban" DOUBLE,
"aa_currently_married_women_aged_15_49_years_total" DOUBLE,
"aa_currently_married_women_aged_15_49_years_rural" DOUBLE,
"aa_currently_married_women_aged_15_49_years_urban" DOUBLE,
"aa_children_12_23_months_total" BIGINT,
"aa_children_12_23_months_rural" BIGINT,
"aa_children_12_23_months_urban" BIGINT,
"bb_average_household_size_sc_total" DOUBLE,
"bb_average_household_size_sc_rural" DOUBLE,
"bb_average_household_size_sc_urban" DOUBLE,
"bb_average_household_size_st_total" DOUBLE,
"bb_average_household_size_st_rural" DOUBLE,
"bb_average_household_size_st_urban" DOUBLE,
"bb_average_household_size_all_total" DOUBLE,
"bb_average_household_size_all_rural" DOUBLE,
"bb_average_household_size_all_urban" DOUBLE,
"bb_population_below_age_15_years_total" DOUBLE,
"bb_population_below_age_15_years_rural" DOUBLE,
"bb_population_below_age_15_years_urban" DOUBLE,
"bb_dependency_ratio_total" DOUBLE,
"bb_dependency_ratio_rural" DOUBLE,
"bb_dependency_ratio_urban" DOUBLE,
"bb_currently_married_illiterate_women_aged_15_49_years_total" DOUBLE,
"bb_currently_married_illiterate_women_aged_15_49_years_rural" DOUBLE,
"bb_currently_married_illiterate_women_aged_15_49_years_urban" DOUBLE,
"cc_sex_ratio_at_birth_total" DOUBLE,
"cc_sex_ratio_at_birth_rural" DOUBLE,
"cc_sex_ratio_at_birth_urban" DOUBLE,
"cc_sex_ratio_0_4_years_total" DOUBLE,
"cc_sex_ratio_0_4_years_rural" DOUBLE,
"cc_sex_ratio_0_4_years_urban" DOUBLE,
"cc_sex_ratio_all_ages_total" DOUBLE,
"cc_sex_ratio_all_ages_rural" DOUBLE,
"cc_sex_ratio_all_ages_urban" DOUBLE,
"dd_person_total" DOUBLE,
"dd_person_rural" DOUBLE,
"dd_person_urban" DOUBLE,
"dd_male_total" DOUBLE,
"dd_male_rural" DOUBLE,
"dd_male_urban" DOUBLE,
"dd_female_total" DOUBLE,
"dd_female_rural" DOUBLE,
"dd_female_urban" DOUBLE,
"ee_marriages_among_females_below_legal_age_18_years_total" DOUBLE,
"ee_marriages_among_females_below_legal_age_18_years_rural" DOUBLE,
"ee_marriages_among_females_below_legal_age_18_years_urban" DOUBLE,
"ee_marriages_among_males_below_legal_age_21_years_total" DOUBLE,
"ee_marriages_among_males_below_legal_age_21_years_rural" DOUBLE,
"ee_marriages_among_males_below_legal_age_21_years_urban" DOUBLE,
"ee_currently_married_women_aged_20_24_years_married_be_7a9b88c3" DOUBLE,
"ee_currently_married_women_aged_20_24_years_married_be_e1d4ab25" DOUBLE,
"ee_currently_married_women_aged_20_24_years_married_be_d3a0c3ff" DOUBLE,
"ee_currently_married_men_aged_25_29_years_married_befo_ae1ad5e9" DOUBLE,
"ee_currently_married_men_aged_25_29_years_married_befo_93a7cd96" DOUBLE,
"ee_currently_married_men_aged_25_29_years_married_befo_b9bb4c85" DOUBLE,
"ee_mean_age_at_marriage_male_total" DOUBLE,
"ee_mean_age_at_marriage_male_rural" DOUBLE,
"ee_mean_age_at_marriage_male_urban" DOUBLE,
"ee_mean_age_at_marriage_female_total" DOUBLE,
"ee_mean_age_at_marriage_female_rural" DOUBLE,
"ee_mean_age_at_marriage_female_urban" DOUBLE,
"ff_children_currently_attending_school_age_6_17_years__994e1441" DOUBLE,
"ff_children_currently_attending_school_age_6_17_years__93dd0b59" DOUBLE,
"ff_children_currently_attending_school_age_6_17_years__255e542b" DOUBLE,
"ff_children_currently_attending_school_age_6_17_years__03e74820" DOUBLE,
"ff_children_currently_attending_school_age_6_17_years__db81f59d" DOUBLE,
"ff_children_currently_attending_school_age_6_17_years__19c89214" DOUBLE,
"ff_children_currently_attending_school_age_6_17_years__bc274b5b" DOUBLE,
"ff_children_currently_attending_school_age_6_17_years__ffabbb76" DOUBLE,
"ff_children_currently_attending_school_age_6_17_years__46b190f0" DOUBLE,
"ff_children_attended_before_drop_out_age_6_17_years_pe_6e58663d" DOUBLE,
"ff_children_attended_before_drop_out_age_6_17_years_pe_d7549f4f" DOUBLE,
"ff_children_attended_before_drop_out_age_6_17_years_pe_71f844a9" DOUBLE,
"ff_children_attended_before_drop_out_age_6_17_years_male_total" DOUBLE,
"ff_children_attended_before_drop_out_age_6_17_years_male_rural" DOUBLE,
"ff_children_attended_before_drop_out_age_6_17_years_male_urban" DOUBLE,
"ff_children_attended_before_drop_out_age_6_17_years_fe_e56064c9" DOUBLE,
"ff_children_attended_before_drop_out_age_6_17_years_fe_fe4de0d1" DOUBLE,
"ff_children_attended_before_drop_out_age_6_17_years_fe_955021de" DOUBLE,
"gg_children_aged_5_14_years_engaged_in_work_person_total" DOUBLE,
"gg_children_aged_5_14_years_engaged_in_work_person_rural" DOUBLE,
"gg_children_aged_5_14_years_engaged_in_work_person_urban" DOUBLE,
"gg_children_aged_5_14_years_engaged_in_work_male_total" DOUBLE,
"gg_children_aged_5_14_years_engaged_in_work_male_rural" DOUBLE,
"gg_children_aged_5_14_years_engaged_in_work_male_urban" DOUBLE,
"gg_children_aged_5_14_years_engaged_in_work_female_total" DOUBLE,
"gg_children_aged_5_14_years_engaged_in_work_female_rural" DOUBLE,
"gg_children_aged_5_14_years_engaged_in_work_female_urban" DOUBLE
);
Anyone who has the link will be able to view this.