Global Health Observatory - World Health Organization

CREATE TABLE owid_ambient_air_pollution_attributable_yll_in_childre_e2132868 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "cause" VARCHAR,
  "ambient_air_pollution_attributable_yll_in_children_und_1fcb1c6d" FLOAT  -- Ambient Air Pollution Attributable Yll In Children Under 15 Years
);

CREATE TABLE owid_ambient_air_pollution_attributable_yll_in_childre_eb97bc52 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "cause" VARCHAR,
  "ambient_air_pollution_attributable_yll_in_children_und_1fcb1c6d" FLOAT  -- Ambient Air Pollution Attributable Yll In Children Under 15 Years,
  "ambient_air_pollution_attributable_yll_in_children_und_06e91c34" FLOAT  -- Ambient Air Pollution Attributable Yll In Children Under 15 Years Low,
  "ambient_air_pollution_attributable_yll_in_children_und_a1e37b79" FLOAT  -- Ambient Air Pollution Attributable Yll In Children Under 15 Years High,
  "comments" VARCHAR
);

CREATE TABLE owid_ambient_air_pollution_attributable_ylls_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "cause" VARCHAR,
  "ambient_air_pollution_attributable_ylls" FLOAT
);

CREATE TABLE owid_ambient_air_pollution_attributable_ylls_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "cause" VARCHAR,
  "ambient_air_pollution_attributable_ylls" FLOAT,
  "ambient_air_pollution_attributable_ylls_low" FLOAT,
  "ambient_air_pollution_attributable_ylls_high" FLOAT,
  "comments" VARCHAR
);

CREATE TABLE owid_ambient_and_household_air_pollution_attributable__09a82ce8 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "cause" VARCHAR,
  "ambient_and_household_air_pollution_attributable_death_78eccd32" FLOAT  -- Ambient And Household Air Pollution Attributable Death Rate, Per 100–000 Population, Age Standardized
);

CREATE TABLE owid_ambient_and_household_air_pollution_attributable__100bd24c (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "cause" VARCHAR,
  "ambient_and_household_air_pollution_attributable_death_0f299e79" FLOAT  -- Ambient And Household Air Pollution Attributable Death Rate, Per 100–000 Population,
  "ambient_and_household_air_pollution_attributable_death_33763998" FLOAT  -- Ambient And Household Air Pollution Attributable Death Rate, Per 100–000 Population Low,
  "ambient_and_household_air_pollution_attributable_death_82d9fd5c" FLOAT  -- Ambient And Household Air Pollution Attributable Death Rate, Per 100–000 Population High,
  "comments" VARCHAR
);

CREATE TABLE owid_ambient_and_household_air_pollution_attributable__1798ebfd (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "cause" VARCHAR,
  "ambient_and_household_air_pollution_attributable_death_0f299e79" FLOAT  -- Ambient And Household Air Pollution Attributable Death Rate, Per 100–000 Population
);

CREATE TABLE owid_ambient_and_household_air_pollution_attributable__2167a249 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "ghe_cause_of_death_codes" VARCHAR,
  "ambient_and_household_air_pollution_attributable_death_78eccd32" FLOAT  -- Ambient And Household Air Pollution Attributable Death Rate, Per 100–000 Population, Age Standardized,
  "ambient_and_household_air_pollution_attributable_death_ddf5dd8b" FLOAT  -- Ambient And Household Air Pollution Attributable Death Rate, Per 100–000 Population, Age Standardized Low,
  "ambient_and_household_air_pollution_attributable_death_f2a79ee4" FLOAT  -- Ambient And Household Air Pollution Attributable Death Rate, Per 100–000 Population, Age Standardized High,
  "comments" VARCHAR
);

CREATE TABLE owid_amount_of_water_and_sanitation_related_official_d_783018b3 (
  "year" INTEGER,
  "country" VARCHAR,
  "amount_of_water_and_sanitation_related_official_develo_277867e1" FLOAT  -- Amount Of Water, And Sanitation Related Official Development Assistance That Is Part Of A Government Coordinated Spending Plan, Current Usd Millions,
  "amount_of_water_and_sanitation_related_official_develo_7a55c946" VARCHAR  -- Amount Of Water, And Sanitation Related Official Development Assistance That Is Part Of A Government Coordinated Spending Plan, Current Usd Millions Low,
  "amount_of_water_and_sanitation_related_official_develo_c03c0559" VARCHAR  -- Amount Of Water, And Sanitation Related Official Development Assistance That Is Part Of A Government Coordinated Spending Plan, Current Usd Millions High,
  "comments" VARCHAR
);

CREATE TABLE owid_amount_of_water_and_sanitation_related_official_d_b374fd71 (
  "year" INTEGER,
  "country" VARCHAR,
  "amount_of_water_and_sanitation_related_official_develo_277867e1" FLOAT  -- Amount Of Water, And Sanitation Related Official Development Assistance That Is Part Of A Government Coordinated Spending Plan, Current Usd Millions,
  "comments" VARCHAR
);

CREATE TABLE owid_annual_budget_for_tobacco_control_in_currency_reported_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "annual_budget_for_tobacco_control_in_currency_reported" BIGINT,
  "comments" VARCHAR
);

CREATE TABLE owid_annual_budget_for_tobacco_control_in_currency_reported_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "annual_budget_for_tobacco_control_in_currency_reported" BIGINT,
  "annual_budget_for_tobacco_control_in_currency_reported_low" VARCHAR,
  "annual_budget_for_tobacco_control_in_currency_reported_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_annual_revenues_from_alcohol_excise_tax_in_millions_usd_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "annual_revenues_from_alcohol_excise_tax_in_millions_usd" FLOAT
);

CREATE TABLE owid_annual_revenues_from_alcohol_excise_tax_in_millions_usd_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "annual_revenues_from_alcohol_excise_tax_in_millions_usd" FLOAT,
  "annual_revenues_from_alcohol_excise_tax_in_millions_usd_low" VARCHAR,
  "annual_revenues_from_alcohol_excise_tax_in_millions_usd_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_antenatal_care_attendees_positive_for_syphilis_wh_4af6e889 (
  "year" INTEGER,
  "country" VARCHAR,
  "antenatal_care_attendees_positive_for_syphilis_who_rec_91f1b72a" FLOAT  -- Antenatal Care Attendees Positive For Syphilis Who Received Treatment, Pct, Reported,
  "antenatal_care_attendees_positive_for_syphilis_who_rec_ae62c4d1" VARCHAR  -- Antenatal Care Attendees Positive For Syphilis Who Received Treatment, Pct, Reported Low,
  "antenatal_care_attendees_positive_for_syphilis_who_rec_dfe45290" VARCHAR  -- Antenatal Care Attendees Positive For Syphilis Who Received Treatment, Pct, Reported High,
  "comments" VARCHAR
);

CREATE TABLE owid_antenatal_care_attendees_positive_for_syphilis_wh_d328cdf9 (
  "year" INTEGER,
  "country" VARCHAR,
  "antenatal_care_attendees_positive_for_syphilis_who_rec_91f1b72a" FLOAT  -- Antenatal Care Attendees Positive For Syphilis Who Received Treatment, Pct, Reported,
  "comments" VARCHAR
);

CREATE TABLE owid_antenatal_care_attendees_who_were_positive_for_sy_371a1f85 (
  "year" INTEGER,
  "country" VARCHAR,
  "antenatal_care_attendees_who_were_positive_for_syphili_aaa90ab4" FLOAT  -- Antenatal Care Attendees Who Were Positive For Syphilis, Pct, Reported,
  "comments" VARCHAR
);

CREATE TABLE owid_antenatal_care_attendees_who_were_positive_for_sy_a459a171 (
  "year" INTEGER,
  "country" VARCHAR,
  "antenatal_care_attendees_who_were_positive_for_syphili_aaa90ab4" FLOAT  -- Antenatal Care Attendees Who Were Positive For Syphilis, Pct, Reported,
  "antenatal_care_attendees_who_were_positive_for_syphili_9322710d" VARCHAR  -- Antenatal Care Attendees Who Were Positive For Syphilis, Pct, Reported Low,
  "antenatal_care_attendees_who_were_positive_for_syphili_91a5c72a" VARCHAR  -- Antenatal Care Attendees Who Were Positive For Syphilis, Pct, Reported High,
  "comments" VARCHAR
);

CREATE TABLE owid_antenatal_care_coverage_at_least_four_visits_in_t_2bf696f8 (
  "year" INTEGER,
  "country" VARCHAR,
  "age_group" VARCHAR,
  "mothers_education_level" VARCHAR,
  "residence_area_type" VARCHAR,
  "wealth_quintile" VARCHAR,
  "dhs_mics_subnational_regions_health_equity_monitor" VARCHAR  -- Dhs Mics Subnational Regions, Health Equity Monitor,
  "wealth_decile" VARCHAR,
  "antenatal_care_coverage_at_least_four_visits_in_the_tw_4a76718e" FLOAT  -- Antenatal Care Coverage, At Least Four Visits, In The Two Or Three Years Preceding The Survey, Pct,
  "comments" VARCHAR
);

CREATE TABLE owid_antenatal_care_coverage_at_least_four_visits_in_t_351cb479 (
  "year" INTEGER,
  "country" VARCHAR,
  "age_group" VARCHAR,
  "wealth_decile" VARCHAR,
  "wealth_quintile" VARCHAR,
  "residence_area_type" VARCHAR,
  "dhs_mics_subnational_regions_health_equity_monitor" VARCHAR  -- Dhs Mics Subnational Regions, Health Equity Monitor,
  "education_level" VARCHAR,
  "antenatal_care_coverage_at_least_four_visits_in_the_tw_4a76718e" FLOAT  -- Antenatal Care Coverage, At Least Four Visits, In The Two Or Three Years Preceding The Survey, Pct,
  "antenatal_care_coverage_at_least_four_visits_in_the_tw_62aa6eff" FLOAT  -- Antenatal Care Coverage, At Least Four Visits, In The Two Or Three Years Preceding The Survey, Pct Low,
  "antenatal_care_coverage_at_least_four_visits_in_the_tw_a309ef2e" FLOAT  -- Antenatal Care Coverage, At Least Four Visits, In The Two Or Three Years Preceding The Survey, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_antenatal_care_coverage_at_least_four_visits_in_t_c65b133a (
  "year" INTEGER,
  "country" VARCHAR,
  "age_group" VARCHAR,
  "mothers_education_level" VARCHAR,
  "residence_area_type" VARCHAR,
  "wealth_quintile" VARCHAR,
  "dhs_mics_subnational_regions_health_equity_monitor" VARCHAR  -- Dhs Mics Subnational Regions, Health Equity Monitor,
  "wealth_decile" VARCHAR,
  "antenatal_care_coverage_at_least_four_visits_in_the_fi_cfc9057e" FLOAT  -- Antenatal Care Coverage, At Least Four Visits, In The Five Years Preceding The Survey, Pct,
  "comments" VARCHAR
);

CREATE TABLE owid_antenatal_care_coverage_at_least_four_visits_in_t_fa48bcd9 (
  "year" INTEGER,
  "country" VARCHAR,
  "age_group" VARCHAR,
  "wealth_decile" VARCHAR,
  "wealth_quintile" VARCHAR,
  "dhs_mics_subnational_regions_health_equity_monitor" VARCHAR  -- Dhs Mics Subnational Regions, Health Equity Monitor,
  "education_level" VARCHAR,
  "residence_area_type" VARCHAR,
  "antenatal_care_coverage_at_least_four_visits_in_the_fi_cfc9057e" FLOAT  -- Antenatal Care Coverage, At Least Four Visits, In The Five Years Preceding The Survey, Pct,
  "antenatal_care_coverage_at_least_four_visits_in_the_fi_b8c997b2" FLOAT  -- Antenatal Care Coverage, At Least Four Visits, In The Five Years Preceding The Survey, Pct Low,
  "antenatal_care_coverage_at_least_four_visits_in_the_fi_7b3ee55a" FLOAT  -- Antenatal Care Coverage, At Least Four Visits, In The Five Years Preceding The Survey, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_antenatal_care_coverage_at_least_four_visits_pct_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "antenatal_care_coverage_at_least_four_visits_pct" FLOAT  -- Antenatal Care Coverage, At Least Four Visits, Pct,
  "comments" VARCHAR
);

CREATE TABLE owid_antenatal_care_coverage_at_least_four_visits_pct_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "antenatal_care_coverage_at_least_four_visits_pct" FLOAT  -- Antenatal Care Coverage, At Least Four Visits, Pct,
  "antenatal_care_coverage_at_least_four_visits_pct_low" VARCHAR  -- Antenatal Care Coverage, At Least Four Visits, Pct Low,
  "antenatal_care_coverage_at_least_four_visits_pct_high" VARCHAR  -- Antenatal Care Coverage, At Least Four Visits, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_antenatal_care_coverage_at_least_one_visit_in_the_0e0bdc03 (
  "year" INTEGER,
  "country" VARCHAR,
  "age_group" VARCHAR,
  "wealth_decile" VARCHAR,
  "wealth_quintile" VARCHAR,
  "residence_area_type" VARCHAR,
  "dhs_mics_subnational_regions_health_equity_monitor" VARCHAR  -- Dhs Mics Subnational Regions, Health Equity Monitor,
  "education_level" VARCHAR,
  "antenatal_care_coverage_at_least_one_visit_in_the_five_2037813b" FLOAT  -- Antenatal Care Coverage, At Least One Visit, In The Five Years Preceding The Survey, Pct,
  "antenatal_care_coverage_at_least_one_visit_in_the_five_da3fe0dd" FLOAT  -- Antenatal Care Coverage, At Least One Visit, In The Five Years Preceding The Survey, Pct Low,
  "antenatal_care_coverage_at_least_one_visit_in_the_five_4b51fdf7" FLOAT  -- Antenatal Care Coverage, At Least One Visit, In The Five Years Preceding The Survey, Pct High,
  "comments" VARCHAR
);