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
India - Annual Health Survey(AHS) 2012-13:
The survey was conducted in Empowered Action Group (EAG) states Uttarakhand, Rajasthan, Uttar Pradesh, Bihar, Jharkhand,
Odisha, Chhattisgarh & Madhya Pradesh and Assam. These nine states, which account for about 48 percent of the total population, 59 percent of Births, 70 percent of Infant Deaths, 75 percent of Under 5 Deaths and 62 percent of Maternal Deaths in the country, are the high focus States in view of their relatively higher fertility and mortality.
A representative sample of about 21 million population and 4.32 million households were covered 20k+ sample units which is spread across rural and urban area of these 9 states.
The objective of the AHS is to yield a comprehensive, representative and reliable dataset on core vital indicators including composite ones like Infant Mortality Rate, Maternal Mortality Ratio and Total Fertility Rate along with their co-variates (process and outcome indicators) at the district level and map the changes therein on an annual basis. These benchmarks would help in better and holistic understanding and timely monitoring of various determinants on well-being and health of population particularly Reproductive and Child Health. Source
This dataset contains the data about the below 26 key indicators.
AA. Sample Particulars
BB. Household Characteristics
CC. Sex Ratio
DD. Effective Literacy Rate
EE. Marriage
FF. Schooling Status
GG. Work Status
HH. Disability
II. Injury
JJ. Acute Illness
KK. Chronic Illness
LL. Fertility
MM. Abortion
NN. Family Planning Practices (Cmw Aged 15-49 Years)
OO. Unmet Need For Family Planning
PP. Ante Natal Care
QQ. Delivery Care
RR. Post Natal Care
SS. Janani Suraksha Yojana (JSY)
TT. Immunization, Vitamin A & Iron Supplement And Birth Weight
UU. Childhood Diseases
VV. Breastfeeding And Supplementation
WW. Birth Registration
XX. Awareness On Hiv/Aids, Rti/Sti, Haf/Ors/Ort/Zinc And
Ari/Pneumonia
YY. Mortality (unit level data of mortality is available here)
ZZ. Confidence Interval (95%) For Some Important Indicators
Department of Health and Family Welfare, Govt. of India has published this data in Open Govt Data Platform India portal under Govt. Open Data License - India.
Banner Photo by rawpixel on Unsplash
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 Before Legal Age 18 Years Total,
  "ee_currently_married_women_aged_20_24_years_married_be_e1d4ab25" DOUBLE  -- EE Currently Married Women Aged 20–24 Years Married Before Legal Age 18 Years Rural,
  "ee_currently_married_women_aged_20_24_years_married_be_d3a0c3ff" DOUBLE  -- EE Currently Married Women Aged 20–24 Years Married Before Legal Age 18 Years Urban,
  "ee_currently_married_men_aged_25_29_years_married_befo_ae1ad5e9" DOUBLE  -- EE Currently Married Men Aged 25–29 Years Married Before Legal Age 21 Years Total,
  "ee_currently_married_men_aged_25_29_years_married_befo_93a7cd96" DOUBLE  -- EE Currently Married Men Aged 25–29 Years Married Before Legal Age 21 Years Rural,
  "ee_currently_married_men_aged_25_29_years_married_befo_b9bb4c85" DOUBLE  -- EE Currently Married Men Aged 25–29 Years Married Before Legal Age 21 Years Urban,
  "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 Person Total,
  "ff_children_currently_attending_school_age_6_17_years__93dd0b59" DOUBLE  -- FF Children Currently Attending School Age 6–17 Years Person Rural,
  "ff_children_currently_attending_school_age_6_17_years__255e542b" DOUBLE  -- FF Children Currently Attending School Age 6–17 Years Person Urban,
  "ff_children_currently_attending_school_age_6_17_years__03e74820" DOUBLE  -- FF Children Currently Attending School Age 6–17 Years Male Total,
  "ff_children_currently_attending_school_age_6_17_years__db81f59d" DOUBLE  -- FF Children Currently Attending School Age 6–17 Years Male Rural,
  "ff_children_currently_attending_school_age_6_17_years__19c89214" DOUBLE  -- FF Children Currently Attending School Age 6–17 Years Male Urban,
  "ff_children_currently_attending_school_age_6_17_years__bc274b5b" DOUBLE  -- FF Children Currently Attending School Age 6–17 Years Female Total,
  "ff_children_currently_attending_school_age_6_17_years__ffabbb76" DOUBLE  -- FF Children Currently Attending School Age 6–17 Years Female Rural,
  "ff_children_currently_attending_school_age_6_17_years__46b190f0" DOUBLE  -- FF Children Currently Attending School Age 6–17 Years Female Urban,
  "ff_children_attended_before_drop_out_age_6_17_years_pe_6e58663d" DOUBLE  -- FF Children Attended Before Drop Out Age 6–17 Years Person Total,
  "ff_children_attended_before_drop_out_age_6_17_years_pe_d7549f4f" DOUBLE  -- FF Children Attended Before Drop Out Age 6–17 Years Person Rural,
  "ff_children_attended_before_drop_out_age_6_17_years_pe_71f844a9" DOUBLE  -- FF Children Attended Before Drop Out Age 6–17 Years Person Urban,
  "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 Female Total,
  "ff_children_attended_before_drop_out_age_6_17_years_fe_fe4de0d1" DOUBLE  -- FF Children Attended Before Drop Out Age 6–17 Years Female Rural,
  "ff_children_attended_before_drop_out_age_6_17_years_fe_955021de" DOUBLE  -- FF Children Attended Before Drop Out Age 6–17 Years Female Urban,
  "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 Before Legal Age 18 Years Total,
  "ee_currently_married_women_aged_20_24_years_married_be_e1d4ab25" DOUBLE  -- EE Currently Married Women Aged 20–24 Years Married Before Legal Age 18 Years Rural,
  "ee_currently_married_women_aged_20_24_years_married_be_d3a0c3ff" DOUBLE  -- EE Currently Married Women Aged 20–24 Years Married Before Legal Age 18 Years Urban,
  "ee_currently_married_men_aged_25_29_years_married_befo_ae1ad5e9" DOUBLE  -- EE Currently Married Men Aged 25–29 Years Married Before Legal Age 21 Years Total,
  "ee_currently_married_men_aged_25_29_years_married_befo_93a7cd96" DOUBLE  -- EE Currently Married Men Aged 25–29 Years Married Before Legal Age 21 Years Rural,
  "ee_currently_married_men_aged_25_29_years_married_befo_b9bb4c85" DOUBLE  -- EE Currently Married Men Aged 25–29 Years Married Before Legal Age 21 Years Urban,
  "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 Person Total,
  "ff_children_currently_attending_school_age_6_17_years__93dd0b59" DOUBLE  -- FF Children Currently Attending School Age 6–17 Years Person Rural,
  "ff_children_currently_attending_school_age_6_17_years__255e542b" DOUBLE  -- FF Children Currently Attending School Age 6–17 Years Person Urban,
  "ff_children_currently_attending_school_age_6_17_years__03e74820" DOUBLE  -- FF Children Currently Attending School Age 6–17 Years Male Total,
  "ff_children_currently_attending_school_age_6_17_years__db81f59d" DOUBLE  -- FF Children Currently Attending School Age 6–17 Years Male Rural,
  "ff_children_currently_attending_school_age_6_17_years__19c89214" DOUBLE  -- FF Children Currently Attending School Age 6–17 Years Male Urban,
  "ff_children_currently_attending_school_age_6_17_years__bc274b5b" DOUBLE  -- FF Children Currently Attending School Age 6–17 Years Female Total,
  "ff_children_currently_attending_school_age_6_17_years__ffabbb76" DOUBLE  -- FF Children Currently Attending School Age 6–17 Years Female Rural,
  "ff_children_currently_attending_school_age_6_17_years__46b190f0" DOUBLE  -- FF Children Currently Attending School Age 6–17 Years Female Urban,
  "ff_children_attended_before_drop_out_age_6_17_years_pe_6e58663d" DOUBLE  -- FF Children Attended Before Drop Out Age 6–17 Years Person Total,
  "ff_children_attended_before_drop_out_age_6_17_years_pe_d7549f4f" DOUBLE  -- FF Children Attended Before Drop Out Age 6–17 Years Person Rural,
  "ff_children_attended_before_drop_out_age_6_17_years_pe_71f844a9" DOUBLE  -- FF Children Attended Before Drop Out Age 6–17 Years Person Urban,
  "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 Female Total,
  "ff_children_attended_before_drop_out_age_6_17_years_fe_fe4de0d1" DOUBLE  -- FF Children Attended Before Drop Out Age 6–17 Years Female Rural,
  "ff_children_attended_before_drop_out_age_6_17_years_fe_955021de" DOUBLE  -- FF Children Attended Before Drop Out Age 6–17 Years Female Urban,
  "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.