National Family Health Survey (NFHS) - 2019-21

CREATE TABLE datafile (
  "district_names" VARCHAR,
  "state_ut" VARCHAR,
  "number_of_households_surveyed" BIGINT,
  "number_of_women_age_15_49_years_interviewed" BIGINT,
  "number_of_men_age_15_54_years_interviewed" BIGINT,
  "female_population_age_6_years_and_above_who_ever_atten_f73854aa" DOUBLE  -- Female Population Age 6 Years And Above Who Ever Attended School (%),
  "population_below_age_15_years" DOUBLE  -- Population Below Age 15 Years (%),
  "n__sex_ratio_of_the_total_population_females_per_1_000_males" BIGINT  -- Sex Ratio Of The Total Population (females Per 1,000 Males),
  "sex_ratio_at_birth_for_children_born_in_the_last_five__cc6c4261" VARCHAR  -- Sex Ratio At Birth For Children Born In The Last Five Years (females Per 1,000 Males),
  "children_under_age_5_years_whose_birth_was_registered__386dbe17" DOUBLE  -- Children Under Age 5 Years Whose Birth Was Registered With The Civil Authority (%),
  "deaths_in_the_last_3_years_registered_with_the_civil_authority" VARCHAR  -- Deaths In The Last 3 Years Registered With The Civil Authority (%),
  "population_living_in_households_with_electricity" DOUBLE  -- Population Living In Households With Electricity (%),
  "population_living_in_households_with_an_improved_drink_9cb98339" DOUBLE  -- Population Living In Households With An Improved Drinking-water Source1 (%),
  "population_living_in_households_that_use_an_improved_s_45d943cd" DOUBLE  -- Population Living In Households That Use An Improved Sanitation Facility2 (%),
  "households_using_clean_fuel_for_cooking3" DOUBLE  -- Households Using Clean Fuel For Cooking3 (%),
  "households_using_iodized_salt" DOUBLE  -- Households Using Iodized Salt (%),
  "households_with_any_usual_member_covered_under_a_healt_1e90135b" DOUBLE  -- Households With Any Usual Member Covered Under A Health Insurance/financing Scheme (%),
  "children_age_5_years_who_attended_pre_primary_school_d_ce33887e" VARCHAR  -- Children Age 5 Years Who Attended Pre-primary School During The School Year 2019-20 (%),
  "women_age_15_49_who_are_literate4" DOUBLE  -- Women (age 15-49) Who Are Literate4 (%),
  "women_age_15_49_with_10_or_more_years_of_schooling" DOUBLE  -- Women (age 15-49) With 10 Or More Years Of Schooling (%),
  "women_age_20_24_years_married_before_age_18_years" VARCHAR  -- Women Age 20-24 Years Married Before Age 18 Years (%),
  "births_in_the_5_years_preceding_the_survey_that_are_th_7ceeefd9" VARCHAR  -- Births In The 5 Years Preceding The Survey That Are Third Or Higher Order (%),
  "women_age_15_19_years_who_were_already_mothers_or_preg_5f39367f" VARCHAR  -- Women Age 15-19 Years Who Were Already Mothers Or Pregnant At The Time Of The Survey (%),
  "women_age_15_24_years_who_use_hygienic_methods_of_prot_bb77fe12" DOUBLE  -- Women Age 15-24 Years Who Use Hygienic Methods Of Protection During Their Menstrual Period5 (%),
  "current_use_of_family_planning_methods_currently_marri_2dbf6f9a" DOUBLE  -- Current Use Of Family Planning Methods (Currently Married Women Age 15-49 Years) - Any Method6 (%),
  "current_use_of_family_planning_methods_currently_marri_d2af3b95" DOUBLE  -- Current Use Of Family Planning Methods (Currently Married Women Age 15-49 Years) - Any Modern Method6 (%),
  "current_use_of_family_planning_methods_currently_marri_833d788c" DOUBLE  -- Current Use Of Family Planning Methods (Currently Married Women Age 15-49 Years) - Female Sterilization (%),
  "current_use_of_family_planning_methods_currently_marri_96629d8a" DOUBLE  -- Current Use Of Family Planning Methods (Currently Married Women Age 15-49 Years) - Male Sterilization (%),
  "current_use_of_family_planning_methods_currently_marri_cb68d58a" DOUBLE  -- Current Use Of Family Planning Methods (Currently Married Women Age 15-49 Years) - IUD/PPIUD (%),
  "current_use_of_family_planning_methods_currently_marri_8185ab11" DOUBLE  -- Current Use Of Family Planning Methods (Currently Married Women Age 15-49 Years) - Pill (%),
  "current_use_of_family_planning_methods_currently_marri_f8e09dce" DOUBLE  -- Current Use Of Family Planning Methods (Currently Married Women Age 15-49 Years) - Condom (%),
  "current_use_of_family_planning_methods_currently_marri_fb5e3709" DOUBLE  -- Current Use Of Family Planning Methods (Currently Married Women Age 15-49 Years) - Injectables (%),
  "total_unmet_need_for_family_planning_currently_married_bfaffd48" DOUBLE  -- Total Unmet Need For Family Planning (Currently Married Women Age 15-49 Years)7 (%),
  "unmet_need_for_spacing_currently_married_women_age_15__1a44cb88" DOUBLE  -- Unmet Need For Spacing (Currently Married Women Age 15-49 Years)7 (%),
  "health_worker_ever_talked_to_female_non_users_about_fa_9b6d834d" DOUBLE  -- Health Worker Ever Talked To Female Non-users About Family Planning (%),
  "current_users_ever_told_about_side_effects_of_current__b0714a6e" VARCHAR  -- Current Users Ever Told About Side Effects Of Current Method Of Family Planning8 (%),
  "mothers_who_had_an_antenatal_check_up_in_the_first_tri_66b4231e" VARCHAR  -- Mothers Who Had An Antenatal Check-up In The First Trimester (for Last Birth In The 5 Years Before The Survey) (%),
  "mothers_who_had_at_least_4_antenatal_care_visits_for_l_d810f14f" VARCHAR  -- Mothers Who Had At Least 4 Antenatal Care Visits (for Last Birth In The 5 Years Before The Survey) (%),
  "mothers_whose_last_birth_was_protected_against_neonata_5b530123" VARCHAR  -- Mothers Whose Last Birth Was Protected Against Neonatal Tetanus (for Last Birth In The 5 Years Before The Survey)9 (%),
  "mothers_who_consumed_iron_folic_acid_for_100_days_or_m_48184c76" VARCHAR  -- Mothers Who Consumed Iron Folic Acid For 100 Days Or More When They Were Pregnant (for Last Birth In The 5 Years Before The Survey) (%),
  "mothers_who_consumed_iron_folic_acid_for_180_days_or_m_c11ed58f" VARCHAR  -- Mothers Who Consumed Iron Folic Acid For 180 Days Or More When They Were Pregnant (for Last Birth In The 5 Years Before The Survey} (%),
  "registered_pregnancies_for_which_the_mother_received_a_2a37575f" VARCHAR  -- Registered Pregnancies For Which The Mother Received A Mother And Child Protection (MCP) Card (for Last Birth In The 5 Years Before The Survey) (%),
  "mothers_who_received_postnatal_care_from_a_doctor_nurs_00dd2607" VARCHAR  -- Mothers Who Received Postnatal Care From A Doctor/nurse/LHV/ANM/midwife/other Health Personnel Within 2 Days Of Delivery (for Last Birth In The 5 Years Before The Survey) (%),
  "average_out_of_pocket_expenditure_per_delivery_in_a_pu_64aee8fd" VARCHAR  -- Average Out-of-pocket Expenditure Per Delivery In A Public Health Facility (for Last Birth In The 5 Years Before The Survey) (Rs.),
  "children_born_at_home_who_were_taken_to_a_health_facil_60c6d2ad" VARCHAR  -- Children Born At Home Who Were Taken To A Health Facility For A Check-up Within 24 Hours Of Birth (for Last Birth In The 5 Years Before The Survey} (%),
  "children_who_received_postnatal_care_from_a_doctor_nur_66e806ae" VARCHAR  -- Children Who Received Postnatal Care From A Doctor/nurse/LHV/ANM/midwife/ Other Health Personnel Within 2 Days Of Delivery (for Last Birth In The 5 Years Before The Survey) (%),
  "institutional_births_in_the_5_years_before_the_survey" DOUBLE  -- Institutional Births (in The 5 Years Before The Survey) (%),
  "institutional_births_in_public_facility_in_the_5_years_eec66c85" DOUBLE  -- Institutional Births In Public Facility (in The 5 Years Before The Survey) (%),
  "home_births_that_were_conducted_by_skilled_health_pers_da1727ac" DOUBLE  -- Home Births That Were Conducted By Skilled Health Personnel (in The 5 Years Before The Survey)10 (%),
  "births_attended_by_skilled_health_personnel_in_the_5_y_a7768924" DOUBLE  -- Births Attended By Skilled Health Personnel (in The 5 Years Before The Survey)10 (%),
  "births_delivered_by_caesarean_section_in_the_5_years_b_568cc502" DOUBLE  -- Births Delivered By Caesarean Section (in The 5 Years Before The Survey) (%),
  "births_in_a_private_health_facility_that_were_delivere_f6914cb6" VARCHAR  -- Births In A Private Health Facility That Were Delivered By Caesarean Section (in The 5 Years Before The Survey) (%),
  "births_in_a_public_health_facility_that_were_delivered_b819a093" VARCHAR  -- Births In A Public Health Facility That Were Delivered By Caesarean Section (in The 5 Years Before The Survey) (%),
  "children_age_12_23_months_fully_vaccinated_based_on_in_66296c3e" VARCHAR  -- Children Age 12-23 Months Fully Vaccinated Based On Information From Either Vaccination Card Or Mother's Recall11 (%),
  "children_age_12_23_months_fully_vaccinated_based_on_in_6eebbc3b" VARCHAR  -- Children Age 12-23 Months Fully Vaccinated Based On Information From Vaccination Card Only12 (%),
  "children_age_12_23_months_who_have_received_bcg" VARCHAR  -- Children Age 12-23 Months Who Have Received BCG (%),
  "children_age_12_23_months_who_have_received_3_doses_of_85ad3274" VARCHAR  -- Children Age 12-23 Months Who Have Received 3 Doses Of Polio Vaccine13 (%),
  "children_age_12_23_months_who_have_received_3_doses_of_3c21993e" VARCHAR  -- Children Age 12-23 Months Who Have Received 3 Doses Of Penta Or DPT Vaccine (%),
  "children_age_12_23_months_who_have_received_the_first__0a8cc056" VARCHAR  -- Children Age 12-23 Months Who Have Received The First Dose Of Measles-containing Vaccine (MCV) (%),
  "children_age_24_35_months_who_have_received_a_second_d_632c0e2a" VARCHAR  -- Children Age 24-35 Months Who Have Received A Second Dose Of Measles-containing Vaccine (MCV) (%),
  "children_age_12_23_months_who_have_received_3_doses_of_e18184a0" VARCHAR  -- Children Age 12-23 Months Who Have Received 3 Doses Of Rotavirus Vaccine14 (%),
  "children_age_12_23_months_who_have_received_3_doses_of_8595fbce" VARCHAR  -- Children Age 12-23 Months Who Have Received 3 Doses Of Penta Or Hepatitis B Vaccine (%),
  "children_age_9_35_months_who_received_a_vitamin_a_dose_9d7ae5c2" VARCHAR  -- Children Age 9-35 Months Who Received A Vitamin A Dose In The Last 6 Months (%),
  "children_age_12_23_months_who_received_most_of_their_v_825a1beb" VARCHAR  -- Children Age 12-23 Months Who Received Most Of Their Vaccinations In A Public Health Facility (%),
  "children_age_12_23_months_who_received_most_of_their_v_83459cef" VARCHAR  -- Children Age 12-23 Months Who Received Most Of Their Vaccinations In A Private Health Facility (%),
  "prevalence_of_diarrhoea_in_the_2_weeks_preceding_the_s_60f3c316" DOUBLE  -- Prevalence Of Diarrhoea In The 2 Weeks Preceding The Survey (Children Under Age 5 Years) (%),
  "children_with_diarrhoea_in_the_2_weeks_preceding_the_s_fb07c57f" VARCHAR  -- Children With Diarrhoea In The 2 Weeks Preceding The Survey Who Received Oral Rehydration Salts (ORS) (Children Under Age 5 Years) (%),
  "children_with_diarrhoea_in_the_2_weeks_preceding_the_s_f335bb23" VARCHAR  -- Children With Diarrhoea In The 2 Weeks Preceding The Survey Who Received Zinc (Children Under Age 5 Years) (%),
  "children_swith_diarrhoea_in_the_2_weeks_preceding_the__c84cab9b" VARCHAR  -- Children Swith Diarrhoea In The 2 Weeks Preceding The Survey Taken To A Health Facility Or Health Provider (Children Under Age 5 Years) (%),
  "children_prevalence_of_symptoms_of_acute_respiratory_i_134ea4a0" DOUBLE  -- Children Prevalence Of Symptoms Of Acute Respiratory Infection (ARI) In The 2 Weeks Preceding The Survey (Children Under Age 5 Years) (%),
  "children_with_fever_or_symptoms_of_ari_in_the_2_weeks__671d10de" VARCHAR  -- Children With Fever Or Symptoms Of ARI In The 2 Weeks Preceding The Survey Taken To A Health Facility Or Health Provider (Children Under Age 5 Years) (%),
  "children_under_age_3_years_breastfed_within_one_hour_o_87ca9760" VARCHAR  -- Children Under Age 3 Years Breastfed Within One Hour Of Birth15 (%),
  "children_under_age_6_months_exclusively_breastfed16" VARCHAR  -- Children Under Age 6 Months Exclusively Breastfed16 (%),
  "children_age_6_8_months_receiving_solid_or_semi_solid__d2bb6f3e" VARCHAR  -- Children Age 6-8 Months Receiving Solid Or Semi-solid Food And Breastmilk16 (%),
  "breastfeeding_children_age_6_23_months_receiving_an_ad_8bb967fa" VARCHAR  -- Breastfeeding Children Age 6-23 Months Receiving An Adequate Diet16, 17 (%),
  "non_breastfeeding_children_age_6_23_months_receiving_a_b998e224" VARCHAR  -- Non-breastfeeding Children Age 6-23 Months Receiving An Adequate Diet16, 17 (%),
  "total_children_age_6_23_months_receiving_an_adequate_diet16_17" VARCHAR  -- Total Children Age 6-23 Months Receiving An Adequate Diet16, 17 (%),
  "children_under_5_years_who_are_stunted_height_for_age_18" VARCHAR  -- Children Under 5 Years Who Are Stunted (height-for-age)18 (%),
  "children_under_5_years_who_are_wasted_weight_for_height_18" VARCHAR  -- Children Under 5 Years Who Are Wasted (weight-for-height)18 (%),
  "children_under_5_years_who_are_severely_wasted_weight__d79a4916" VARCHAR  -- Children Under 5 Years Who Are Severely Wasted (weight-for-height)19 (%),
  "children_under_5_years_who_are_underweight_weight_for_age_18" VARCHAR  -- Children Under 5 Years Who Are Underweight (weight-for-age)18 (%),
  "children_under_5_years_who_are_overweight_weight_for_height_20" VARCHAR  -- Children Under 5 Years Who Are Overweight (weight-for-height)20 (%),
  "women_age_15_49_years_whose_body_mass_index_bmi_is_bel_6e416f87" DOUBLE  -- Women (age 15-49 Years) Whose Body Mass Index (BMI) Is Below Normal (BMI <18.5 Kg/m2)21 (%),
  "women_age_15_49_years_who_are_overweight_or_obese_bmi__215f88b2" DOUBLE  -- Women (age 15-49 Years) Who Are Overweight Or Obese (BMI ≥25.0 Kg/m2)21 (%),
  "women_age_15_49_years_who_have_high_risk_waist_to_hip__0ab8998c" DOUBLE  -- Women (age 15-49 Years) Who Have High Risk Waist-to-hip Ratio (≥0.85) (%),
  "children_age_6_59_months_who_are_anaemic_11_0_g_dl_22" VARCHAR  -- Children Age 6-59 Months Who Are Anaemic (<11.0 G/dl)22 (%),
  "non_pregnant_women_age_15_49_years_who_are_anaemic_12__51cde14c" DOUBLE  -- Non-pregnant Women Age 15-49 Years Who Are Anaemic (<12.0 G/dl)22 (%),
  "pregnant_women_age_15_49_years_who_are_anaemic_11_0_g_dl_22" VARCHAR  -- Pregnant Women Age 15-49 Years Who Are Anaemic (<11.0 G/dl)22 (%),
  "all_women_age_15_49_years_who_are_anaemic22" DOUBLE  -- All Women Age 15-49 Years Who Are Anaemic22 (%),
  "all_women_age_15_19_years_who_are_anaemic22" VARCHAR  -- All Women Age 15-19 Years Who Are Anaemic22 (%),
  "women_age_15_years_and_above_with_high_141_160_mg_dl_b_e26b6c8d" DOUBLE  -- Women Age 15 Years And Above With High (141-160 Mg/dl) Blood Sugar Level23 (%),
  "women_age_15_years_and_above_wih_very_high_160_mg_dl_b_ca1edd75" DOUBLE  -- Women Age 15 Years And Above Wih Very High (>160 Mg/dl) Blood Sugar Level23 (%),
  "women_age_15_years_and_above_wih_high_or_very_high_140_3f597420" DOUBLE  -- Women Age 15 Years And Above Wih High Or Very High (>140 Mg/dl) Blood Sugar Level Or Taking Medicine To Control Blood Sugar Level23 (%),
  "men_age_15_years_and_above_wih_high_141_160_mg_dl_bloo_ceaa6f8e" DOUBLE  -- Men Age 15 Years And Above Wih High (141-160 Mg/dl) Blood Sugar Level23 (%),
  "men_age_15_years_and_above_wih_very_high_160_mg_dl_blo_b7557768" DOUBLE  -- Men (age 15 Years And Above Wih Very High (>160 Mg/dl) Blood Sugar Level23 (%),
  "men_age_15_years_and_above_wih_high_or_very_high_140_m_b4626b33" DOUBLE  -- Men Age 15 Years And Above Wih High Or Very High (>140 Mg/dl) Blood Sugar Level Or Taking Medicine To Control Blood Sugar Level23 (%),
  "women_age_15_years_and_above_wih_mildly_elevated_blood_e42280ae" DOUBLE  -- Women Age 15 Years And Above Wih Mildly Elevated Blood Pressure (Systolic 140-159 Mm Of Hg And/or Diastolic 90-99 Mm Of Hg) (%),
  "women_age_15_years_and_above_wih_moderately_or_severel_5dab6d15" DOUBLE  -- Women Age 15 Years And Above Wih Moderately Or Severely Elevated Blood Pressure (Systolic ≥160 Mm Of Hg And/or Diastolic ≥100 Mm Of Hg) (%),
  "women_age_15_years_and_above_wih_elevated_blood_pressu_052e6999" DOUBLE  -- Women Age 15 Years And Above Wih Elevated Blood Pressure (Systolic ≥140 Mm Of Hg And/or Diastolic ≥90 Mm Of Hg) Or Taking Medicine To Control Blood Pressure (%),
  "men_age_15_years_and_above_wih_mildly_elevated_blood_p_f30ed0aa" DOUBLE  -- Men Age 15 Years And Above Wih Mildly Elevated Blood Pressure (Systolic 140-159 Mm Of Hg And/or Diastolic 90-99 Mm Of Hg) (%)
);