Global Health Observatory - World Health Organization

CREATE TABLE owid_status_of_pinta_endemicity_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "status_of_pinta_endemicity" VARCHAR,
  "status_of_pinta_endemicity_low" VARCHAR,
  "status_of_pinta_endemicity_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_status_of_yaws_endemicity_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "status_of_yaws_endemicity" VARCHAR
);

CREATE TABLE owid_status_of_yaws_endemicity_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "status_of_yaws_endemicity" VARCHAR,
  "status_of_yaws_endemicity_low" VARCHAR,
  "status_of_yaws_endemicity_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_stillbirth_rate_per_1000_total_births_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "stillbirth_rate_per_1000_total_births" FLOAT  -- Stillbirth Rate, Per 1000 Total Births
);

CREATE TABLE owid_stillbirth_rate_per_1000_total_births_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "stillbirth_rate_per_1000_total_births" FLOAT  -- Stillbirth Rate, Per 1000 Total Births,
  "stillbirth_rate_per_1000_total_births_low" FLOAT  -- Stillbirth Rate, Per 1000 Total Births Low,
  "stillbirth_rate_per_1000_total_births_high" FLOAT  -- Stillbirth Rate, Per 1000 Total Births High,
  "comments" VARCHAR
);

CREATE TABLE owid_strategy_implementation_funding_available_for_ehealth_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "strategy_implementation_funding_available_for_ehealth" VARCHAR
);

CREATE TABLE owid_strategy_implementation_funding_available_for_ehealth_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "strategy_implementation_funding_available_for_ehealth" VARCHAR,
  "strategy_implementation_funding_available_for_ehealth_low" VARCHAR,
  "strategy_implementation_funding_available_for_ehealth_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_strategy_includes_objectives_as_to_how_telehealth_94281d97 (
  "year" INTEGER,
  "country" VARCHAR,
  "strategy_includes_objectives_as_to_how_telehealth_cont_7a7408c9" VARCHAR  -- Strategy Includes Objectives As To How Telehealth Contributes To Uhc
);

CREATE TABLE owid_strategy_includes_objectives_as_to_how_telehealth_c13b9af8 (
  "year" INTEGER,
  "country" VARCHAR,
  "strategy_includes_objectives_as_to_how_telehealth_cont_7a7408c9" VARCHAR  -- Strategy Includes Objectives As To How Telehealth Contributes To Uhc,
  "strategy_includes_objectives_as_to_how_telehealth_cont_a756b0ef" VARCHAR  -- Strategy Includes Objectives As To How Telehealth Contributes To Uhc Low,
  "strategy_includes_objectives_as_to_how_telehealth_cont_430e553a" VARCHAR  -- Strategy Includes Objectives As To How Telehealth Contributes To Uhc High,
  "comments" VARCHAR
);

CREATE TABLE owid_strategy_refers_to_the_use_of_ict_to_support_uhc_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "strategy_refers_to_the_use_of_ict_to_support_uhc" VARCHAR
);

CREATE TABLE owid_strategy_refers_to_the_use_of_ict_to_support_uhc_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "strategy_refers_to_the_use_of_ict_to_support_uhc" VARCHAR,
  "strategy_refers_to_the_use_of_ict_to_support_uhc_low" VARCHAR,
  "strategy_refers_to_the_use_of_ict_to_support_uhc_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_stunting_numbers_among_children_under_5_years_of__4ee822c7 (
  "year" INTEGER,
  "country" VARCHAR,
  "stunting_numbers_among_children_under_5_years_of_age_m_8c904de4" FLOAT  -- Stunting Numbers Among Children Under 5 Years Of Age, Millions, Model Based Estimates,
  "comments" VARCHAR
);

CREATE TABLE owid_stunting_numbers_among_children_under_5_years_of__c179fa8d (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "stunting_numbers_among_children_under_5_years_of_age_m_8c904de4" FLOAT  -- Stunting Numbers Among Children Under 5 Years Of Age, Millions, Model Based Estimates,
  "stunting_numbers_among_children_under_5_years_of_age_m_281d2823" FLOAT  -- Stunting Numbers Among Children Under 5 Years Of Age, Millions, Model Based Estimates Low,
  "stunting_numbers_among_children_under_5_years_of_age_m_de44136a" FLOAT  -- Stunting Numbers Among Children Under 5 Years Of Age, Millions, Model Based Estimates High,
  "comments" VARCHAR
);

CREATE TABLE owid_stunting_prevalence_among_children_under_5_years__b02991a5 (
  "year" INTEGER,
  "country" VARCHAR,
  "stunting_prevalence_among_children_under_5_years_of_ag_814f0521" FLOAT  -- Stunting Prevalence Among Children Under 5 Years Of Age, Pct Height For Age, Lt, 2 Sd, Model Based Estimates,
  "comments" VARCHAR
);

CREATE TABLE owid_stunting_prevalence_among_children_under_5_years__cc806181 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "household_wealth" VARCHAR,
  "wealth_tercile" VARCHAR,
  "wealth_decile" VARCHAR,
  "wealth_quintile" VARCHAR,
  "residence_area_type" VARCHAR,
  "education_level" VARCHAR,
  "stunting_prevalence_among_children_under_5_years_of_ag_0d00652a" FLOAT  -- Stunting Prevalence Among Children Under 5 Years Of Age, Pct Height For Age, Lt, 2 Sd, Survey Based Estimates,
  "stunting_prevalence_among_children_under_5_years_of_ag_18343667" FLOAT  -- Stunting Prevalence Among Children Under 5 Years Of Age, Pct Height For Age, Lt, 2 Sd, Survey Based Estimates Low,
  "stunting_prevalence_among_children_under_5_years_of_ag_f3b37f06" FLOAT  -- Stunting Prevalence Among Children Under 5 Years Of Age, Pct Height For Age, Lt, 2 Sd, Survey Based Estimates High,
  "comments" VARCHAR
);

CREATE TABLE owid_stunting_prevalence_among_children_under_5_years__e58bed76 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "stunting_prevalence_among_children_under_5_years_of_ag_814f0521" FLOAT  -- Stunting Prevalence Among Children Under 5 Years Of Age, Pct Height For Age, Lt, 2 Sd, Model Based Estimates,
  "stunting_prevalence_among_children_under_5_years_of_ag_cf7a4e69" FLOAT  -- Stunting Prevalence Among Children Under 5 Years Of Age, Pct Height For Age, Lt, 2 Sd, Model Based Estimates Low,
  "stunting_prevalence_among_children_under_5_years_of_ag_9b4c5fb1" FLOAT  -- Stunting Prevalence Among Children Under 5 Years Of Age, Pct Height For Age, Lt, 2 Sd, Model Based Estimates High,
  "comments" VARCHAR
);

CREATE TABLE owid_stunting_prevalence_in_children_aged_lt_5_years_p_83b08c05 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" 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,
  "stunting_prevalence_in_children_aged_lt_5_years_pct_he_0d018f36" FLOAT  -- Stunting Prevalence In Children Aged, Lt, 5 Years, Pct, Health Inequality Monitor,
  "stunting_prevalence_in_children_aged_lt_5_years_pct_he_23fc031f" FLOAT  -- Stunting Prevalence In Children Aged, Lt, 5 Years, Pct, Health Inequality Monitor Low,
  "stunting_prevalence_in_children_aged_lt_5_years_pct_he_8d87d41b" FLOAT  -- Stunting Prevalence In Children Aged, Lt, 5 Years, Pct, Health Inequality Monitor High,
  "comments" VARCHAR
);

CREATE TABLE owid_stunting_prevalence_in_children_aged_lt_5_years_p_c284b627 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" 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,
  "stunting_prevalence_in_children_aged_lt_5_years_pct_he_0d018f36" FLOAT  -- Stunting Prevalence In Children Aged, Lt, 5 Years, Pct, Health Inequality Monitor,
  "comments" VARCHAR
);

CREATE TABLE owid_subclinical_vitamin_a_deficiency_in_preschool_age_2d4b7042 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "subclinical_vitamin_a_deficiency_in_preschool_age_chil_b66ab8e9" FLOAT  -- Subclinical Vitamin A Deficiency In Preschool Age Children, Serum Plasma Retinol, Lt 0–70 Mmol L, Pct,
  "comments" VARCHAR
);

CREATE TABLE owid_subnational_advertising_promotion_and_sponsorship_e0c9b3cd (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "subnational_advertising_promotion_and_sponsorship_bans_12faac04" VARCHAR  -- Subnational Advertising, Promotion And Sponsorship Bans, At Least One Jurisdiction Has A Comprehensive Ban In Place
);

CREATE TABLE owid_subnational_advertising_promotion_and_sponsorship_e25c7b2f (
  "year" INTEGER,
  "country" VARCHAR,
  "subnational_advertising_promotion_and_sponsorship_bans_12faac04" VARCHAR  -- Subnational Advertising, Promotion And Sponsorship Bans, At Least One Jurisdiction Has A Comprehensive Ban In Place,
  "subnational_advertising_promotion_and_sponsorship_bans_31ff327d" VARCHAR  -- Subnational Advertising, Promotion And Sponsorship Bans, At Least One Jurisdiction Has A Comprehensive Ban In Place Low,
  "subnational_advertising_promotion_and_sponsorship_bans_46b4bd19" VARCHAR  -- Subnational Advertising, Promotion And Sponsorship Bans, At Least One Jurisdiction Has A Comprehensive Ban In Place High,
  "comments" VARCHAR
);

CREATE TABLE owid_subnational_bans_on_advertising_promotion_and_spo_230328fb (
  "year" INTEGER,
  "country" VARCHAR,
  "subnational_bans_on_advertising_promotion_and_sponsors_595bb6bf" VARCHAR  -- Subnational Bans On Advertising, Promotion And Sponsorship, At Least One Jurisdiction Has A Comprehensive Ban In Place,
  "subnational_bans_on_advertising_promotion_and_sponsors_1f595cc4" VARCHAR  -- Subnational Bans On Advertising, Promotion And Sponsorship, At Least One Jurisdiction Has A Comprehensive Ban In Place Low,
  "subnational_bans_on_advertising_promotion_and_sponsors_489b58b7" VARCHAR  -- Subnational Bans On Advertising, Promotion And Sponsorship, At Least One Jurisdiction Has A Comprehensive Ban In Place High,
  "comments" VARCHAR
);

CREATE TABLE owid_subnational_bans_on_advertising_promotion_and_spo_eef16c35 (
  "year" INTEGER,
  "country" VARCHAR,
  "subnational_bans_on_advertising_promotion_and_sponsors_595bb6bf" VARCHAR  -- Subnational Bans On Advertising, Promotion And Sponsorship, At Least One Jurisdiction Has A Comprehensive Ban In Place
);

CREATE TABLE owid_subnational_bans_on_tobacco_advertising_promotion_1a39278f (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "subnational_bans_on_tobacco_advertising_promotion_and__db9b892d" VARCHAR  -- Subnational Bans On Tobacco Advertising, Promotion And Sponsorship
);

CREATE TABLE owid_subnational_bans_on_tobacco_advertising_promotion_49c614f1 (
  "year" INTEGER,
  "country" VARCHAR,
  "subnational_bans_on_tobacco_advertising_promotion_and__db9b892d" VARCHAR  -- Subnational Bans On Tobacco Advertising, Promotion And Sponsorship,
  "subnational_bans_on_tobacco_advertising_promotion_and__aadd6819" VARCHAR  -- Subnational Bans On Tobacco Advertising, Promotion And Sponsorship Low,
  "subnational_bans_on_tobacco_advertising_promotion_and__4c667e1a" VARCHAR  -- Subnational Bans On Tobacco Advertising, Promotion And Sponsorship High,
  "comments" VARCHAR
);