Global Health Observatory - World Health Organization

CREATE TABLE owid_antenatal_care_coverage_at_least_one_visit_in_the_68c45cb0 (
  "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_one_visit_in_the_five_2037813b" FLOAT  -- Antenatal Care Coverage, At Least One Visit, In The Five Years Preceding The Survey, Pct,
  "comments" VARCHAR
);

CREATE TABLE owid_antenatal_care_coverage_at_least_one_visit_in_the_af043979 (
  "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_one_visit_in_the_two__893c42fd" FLOAT  -- Antenatal Care Coverage, At Least One Visit, In The Two Or Three Years Preceding The Survey, Pct,
  "comments" VARCHAR
);

CREATE TABLE owid_antenatal_care_coverage_at_least_one_visit_pct_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "antenatal_care_coverage_at_least_one_visit_pct" FLOAT  -- Antenatal Care Coverage, At Least One Visit, Pct,
  "comments" VARCHAR
);

CREATE TABLE owid_antenatal_care_coverage_at_least_one_visit_pct_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "antenatal_care_coverage_at_least_one_visit_pct" FLOAT  -- Antenatal Care Coverage, At Least One Visit, Pct,
  "antenatal_care_coverage_at_least_one_visit_pct_low" VARCHAR  -- Antenatal Care Coverage, At Least One Visit, Pct Low,
  "antenatal_care_coverage_at_least_one_visit_pct_high" VARCHAR  -- Antenatal Care Coverage, At Least One Visit, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_antiretroviral_therapy_coverage_among_people_with_41e9e0c6 (
  "year" INTEGER,
  "country" VARCHAR,
  "antiretroviral_therapy_coverage_among_people_with_adva_c5c16bb0" INTEGER  -- Antiretroviral Therapy Coverage Among People With Advanced Hiv Infection, Pct, Who 2006 Guidelines,
  "antiretroviral_therapy_coverage_among_people_with_adva_5df16293" INTEGER  -- Antiretroviral Therapy Coverage Among People With Advanced Hiv Infection, Pct, Who 2006 Guidelines Low,
  "antiretroviral_therapy_coverage_among_people_with_adva_021179b5" INTEGER  -- Antiretroviral Therapy Coverage Among People With Advanced Hiv Infection, Pct, Who 2006 Guidelines High,
  "comments" VARCHAR
);

CREATE TABLE owid_antiretroviral_therapy_coverage_among_people_with_710cb6b7 (
  "year" INTEGER,
  "country" VARCHAR,
  "antiretroviral_therapy_coverage_among_people_with_adva_c5c16bb0" INTEGER  -- Antiretroviral Therapy Coverage Among People With Advanced Hiv Infection, Pct, Who 2006 Guidelines
);

CREATE TABLE owid_antiretroviral_therapy_coverage_among_people_with_73702099 (
  "year" INTEGER,
  "country" VARCHAR,
  "antiretroviral_therapy_coverage_among_people_with_hiv__9279127d" FLOAT  -- Antiretroviral Therapy Coverage Among People With Hiv Infection Eligible For Art According To 2010 Guidelines, Pct,
  "antiretroviral_therapy_coverage_among_people_with_hiv__7fe39a2c" FLOAT  -- Antiretroviral Therapy Coverage Among People With Hiv Infection Eligible For Art According To 2010 Guidelines, Pct Low,
  "antiretroviral_therapy_coverage_among_people_with_hiv__56f4b081" FLOAT  -- Antiretroviral Therapy Coverage Among People With Hiv Infection Eligible For Art According To 2010 Guidelines, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_antiretroviral_therapy_coverage_among_people_with_b80fb381 (
  "year" INTEGER,
  "country" VARCHAR,
  "antiretroviral_therapy_coverage_among_people_with_hiv__9279127d" FLOAT  -- Antiretroviral Therapy Coverage Among People With Hiv Infection Eligible For Art According To 2010 Guidelines, Pct,
  "comments" VARCHAR
);

CREATE TABLE owid_anti_tobacco_mass_media_campaigns_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "anti_tobacco_mass_media_campaigns" INTEGER
);

CREATE TABLE owid_anti_tobacco_mass_media_campaigns_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "anti_tobacco_mass_media_campaigns" INTEGER,
  "anti_tobacco_mass_media_campaigns_low" VARCHAR,
  "anti_tobacco_mass_media_campaigns_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_any_antenatal_iron_supplementation_pct (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "any_antenatal_iron_supplementation_pct" FLOAT  -- Any Antenatal Iron Supplementation, Pct,
  "comments" VARCHAR
);

CREATE TABLE owid_appearance_of_tobacco_products_in_tv_and_or_films_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "appearance_of_tobacco_products_in_tv_and_or_films" VARCHAR
);

CREATE TABLE owid_appearance_of_tobacco_products_in_tv_and_or_films_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "appearance_of_tobacco_products_in_tv_and_or_films" VARCHAR,
  "appearance_of_tobacco_products_in_tv_and_or_films_low" VARCHAR,
  "appearance_of_tobacco_products_in_tv_and_or_films_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_applicability_of_national_motorcycle_helmet_law_t_be0a330f (
  "year" INTEGER,
  "country" VARCHAR,
  "motorcycle_occupant_type" VARCHAR,
  "applicability_of_national_motorcycle_helmet_law_to_all_9b4ded05" VARCHAR  -- Applicability Of National Motorcycle Helmet Law To All Occupants,
  "applicability_of_national_motorcycle_helmet_law_to_all_62e977cf" VARCHAR  -- Applicability Of National Motorcycle Helmet Law To All Occupants Low,
  "applicability_of_national_motorcycle_helmet_law_to_all_c5ba7d8d" VARCHAR  -- Applicability Of National Motorcycle Helmet Law To All Occupants High,
  "comments" VARCHAR
);

CREATE TABLE owid_applicability_of_national_motorcycle_helmet_law_t_f9fc6312 (
  "year" INTEGER,
  "country" VARCHAR,
  "motorcycle_occupant_type" VARCHAR,
  "comments" VARCHAR,
  "applicability_of_national_motorcycle_helmet_law_to_all_9b4ded05" VARCHAR  -- Applicability Of National Motorcycle Helmet Law To All Occupants
);

CREATE TABLE owid_at_least_one_national_mass_media_campaign_ran_dur_0708452d (
  "year" INTEGER,
  "country" VARCHAR,
  "at_least_one_national_mass_media_campaign_ran_during_t_7c80e167" VARCHAR  -- At Least One National Mass Media Campaign Ran During The Survey Period,
  "at_least_one_national_mass_media_campaign_ran_during_t_b5c55df3" VARCHAR  -- At Least One National Mass Media Campaign Ran During The Survey Period Low,
  "at_least_one_national_mass_media_campaign_ran_during_t_5195bf38" VARCHAR  -- At Least One National Mass Media Campaign Ran During The Survey Period High,
  "comments" VARCHAR
);

CREATE TABLE owid_at_least_one_national_mass_media_campaign_ran_dur_e6af6ebb (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "at_least_one_national_mass_media_campaign_ran_during_t_7c80e167" VARCHAR  -- At Least One National Mass Media Campaign Ran During The Survey Period
);

CREATE TABLE owid_attributable_fraction_of_diarrhoea_to_inadequate__6eadd12c (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "attributable_fraction_of_diarrhoea_to_inadequate_sanitation" FLOAT
);

CREATE TABLE owid_attributable_fraction_of_diarrhoea_to_inadequate__759ce780 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "attributable_fraction_of_diarrhoea_to_inadequate_water_c66b44b4" FLOAT  -- Attributable Fraction Of Diarrhoea To Inadequate Water, Sanitation And Hygiene,
  "attributable_fraction_of_diarrhoea_to_inadequate_water_119da944" FLOAT  -- Attributable Fraction Of Diarrhoea To Inadequate Water, Sanitation And Hygiene Low,
  "attributable_fraction_of_diarrhoea_to_inadequate_water_3217c4c0" FLOAT  -- Attributable Fraction Of Diarrhoea To Inadequate Water, Sanitation And Hygiene High,
  "comments" VARCHAR
);

CREATE TABLE owid_attributable_fraction_of_diarrhoea_to_inadequate__861734d5 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "attributable_fraction_of_diarrhoea_to_inadequate_water_c66b44b4" FLOAT  -- Attributable Fraction Of Diarrhoea To Inadequate Water, Sanitation And Hygiene
);

CREATE TABLE owid_attributable_fraction_of_diarrhoea_to_inadequate__ed4fc0a9 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "attributable_fraction_of_diarrhoea_to_inadequate_sanitation" FLOAT,
  "attributable_fraction_of_diarrhoea_to_inadequate_sanitation_low" FLOAT,
  "attributable_fraction_of_diarrhoea_to_inadequate_sanit_6c543bca" FLOAT  -- Attributable Fraction Of Diarrhoea To Inadequate Sanitation High,
  "comments" VARCHAR
);

CREATE TABLE owid_attributable_fraction_of_diarrhoea_to_inadequate_hygiene_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "attributable_fraction_of_diarrhoea_to_inadequate_hygiene" FLOAT
);

CREATE TABLE owid_attributable_fraction_of_diarrhoea_to_inadequate_hygiene_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "attributable_fraction_of_diarrhoea_to_inadequate_hygiene" FLOAT,
  "attributable_fraction_of_diarrhoea_to_inadequate_hygiene_low" FLOAT,
  "attributable_fraction_of_diarrhoea_to_inadequate_hygiene_high" FLOAT,
  "comments" VARCHAR
);

CREATE TABLE owid_attributable_fraction_of_diarrhoea_to_inadequate_water_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "attributable_fraction_of_diarrhoea_to_inadequate_water" FLOAT
);

CREATE TABLE owid_attributable_fraction_of_diarrhoea_to_inadequate_water_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "attributable_fraction_of_diarrhoea_to_inadequate_water" FLOAT,
  "attributable_fraction_of_diarrhoea_to_inadequate_water_low" FLOAT,
  "attributable_fraction_of_diarrhoea_to_inadequate_water_high" FLOAT,
  "comments" VARCHAR
);