Global Health Observatory - World Health Organization

CREATE TABLE owid_monopoly_on_imports_of_alcoholic_beverages_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "beverage_types" VARCHAR,
  "monopoly_on_imports_of_alcoholic_beverages" VARCHAR,
  "monopoly_on_imports_of_alcoholic_beverages_low" VARCHAR,
  "monopoly_on_imports_of_alcoholic_beverages_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_monopoly_on_wholesale_distribution_of_alcoholic_b_5a3ca6e9 (
  "year" INTEGER,
  "country" VARCHAR,
  "beverage_types" VARCHAR,
  "monopoly_on_wholesale_distribution_of_alcoholic_beverages" VARCHAR  -- Monopoly On Wholesale, Distribution Of Alcoholic Beverages,
  "monopoly_on_wholesale_distribution_of_alcoholic_beverages_low" VARCHAR  -- Monopoly On Wholesale, Distribution Of Alcoholic Beverages Low,
  "monopoly_on_wholesale_distribution_of_alcoholic_beverages_high" VARCHAR  -- Monopoly On Wholesale, Distribution Of Alcoholic Beverages High,
  "comments" VARCHAR
);

CREATE TABLE owid_monopoly_on_wholesale_distribution_of_alcoholic_b_c9f055db (
  "year" INTEGER,
  "country" VARCHAR,
  "beverage_types" VARCHAR,
  "monopoly_on_wholesale_distribution_of_alcoholic_beverages" VARCHAR  -- Monopoly On Wholesale, Distribution Of Alcoholic Beverages
);

CREATE TABLE owid_mortality_rate_among_children_ages_10_to_14_years_0f6cb1a1 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "mortality_rate_among_children_ages_10_to_14_years_per__11c7b65b" FLOAT  -- Mortality Rate Among Children Ages 10 To 14 Years, Per 1000 Children Aged 10
);

CREATE TABLE owid_mortality_rate_among_children_ages_10_to_14_years_d882fe72 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "mortality_rate_among_children_ages_10_to_14_years_per__11c7b65b" FLOAT  -- Mortality Rate Among Children Ages 10 To 14 Years, Per 1000 Children Aged 10,
  "mortality_rate_among_children_ages_10_to_14_years_per__0cfbb272" FLOAT  -- Mortality Rate Among Children Ages 10 To 14 Years, Per 1000 Children Aged 10 Low,
  "mortality_rate_among_children_ages_10_to_14_years_per__d4b8b28c" FLOAT  -- Mortality Rate Among Children Ages 10 To 14 Years, Per 1000 Children Aged 10 High,
  "comments" VARCHAR
);

CREATE TABLE owid_mortality_rate_among_children_ages_5_to_9_years_p_005660bd (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "mortality_rate_among_children_ages_5_to_9_years_per_10_e916d9d6" FLOAT  -- Mortality Rate Among Children Ages 5 To 9 Years, Per 1000 Children Aged 5,
  "mortality_rate_among_children_ages_5_to_9_years_per_10_dbe0f9ba" FLOAT  -- Mortality Rate Among Children Ages 5 To 9 Years, Per 1000 Children Aged 5 Low,
  "mortality_rate_among_children_ages_5_to_9_years_per_10_7c0f5b78" FLOAT  -- Mortality Rate Among Children Ages 5 To 9 Years, Per 1000 Children Aged 5 High,
  "comments" VARCHAR
);

CREATE TABLE owid_mortality_rate_among_children_ages_5_to_9_years_p_93b06d1a (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "mortality_rate_among_children_ages_5_to_9_years_per_10_e916d9d6" FLOAT  -- Mortality Rate Among Children Ages 5 To 9 Years, Per 1000 Children Aged 5
);

CREATE TABLE owid_mortality_rate_attributed_to_exposure_to_unsafe_w_5322732b (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "mortality_rate_attributed_to_exposure_to_unsafe_wash_s_7020e8f0" FLOAT  -- Mortality Rate Attributed To Exposure To Unsafe Wash Services, Per 100–000 Population, Sdg 3–9 2,
  "mortality_rate_attributed_to_exposure_to_unsafe_wash_s_7a1b4390" VARCHAR  -- Mortality Rate Attributed To Exposure To Unsafe Wash Services, Per 100–000 Population, Sdg 3–9 2 Low,
  "mortality_rate_attributed_to_exposure_to_unsafe_wash_s_85ac1d69" VARCHAR  -- Mortality Rate Attributed To Exposure To Unsafe Wash Services, Per 100–000 Population, Sdg 3–9 2 High,
  "comments" VARCHAR
);

CREATE TABLE owid_mortality_rate_attributed_to_exposure_to_unsafe_w_f436d6e1 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "mortality_rate_attributed_to_exposure_to_unsafe_wash_s_7020e8f0" FLOAT  -- Mortality Rate Attributed To Exposure To Unsafe Wash Services, Per 100–000 Population, Sdg 3–9 2
);

CREATE TABLE owid_mortality_rate_attributed_to_unintentional_poison_124b4416 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "mortality_rate_attributed_to_unintentional_poisoning_p_06f5078a" FLOAT  -- Mortality Rate Attributed To Unintentional Poisoning, Per 100–000 Population,
  "mortality_rate_attributed_to_unintentional_poisoning_p_4c23668a" FLOAT  -- Mortality Rate Attributed To Unintentional Poisoning, Per 100–000 Population Low,
  "mortality_rate_attributed_to_unintentional_poisoning_p_e7bba3a6" FLOAT  -- Mortality Rate Attributed To Unintentional Poisoning, Per 100–000 Population High,
  "comments" VARCHAR
);

CREATE TABLE owid_mortality_rate_attributed_to_unintentional_poison_64e5efc9 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "mortality_rate_attributed_to_unintentional_poisoning_p_06f5078a" FLOAT  -- Mortality Rate Attributed To Unintentional Poisoning, Per 100–000 Population
);

CREATE TABLE owid_mortality_rate_for_5_14_year_olds_probability_of__5828ae04 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "mortality_rate_for_5_14_year_olds_probability_of_dying_22c4eb49" FLOAT  -- Mortality Rate For 5–14 Year Olds, Probability Of Dying Per 1000 Children Aged 5–14 Years,
  "mortality_rate_for_5_14_year_olds_probability_of_dying_ccf3005d" FLOAT  -- Mortality Rate For 5–14 Year Olds, Probability Of Dying Per 1000 Children Aged 5–14 Years Low,
  "mortality_rate_for_5_14_year_olds_probability_of_dying_0de5324c" FLOAT  -- Mortality Rate For 5–14 Year Olds, Probability Of Dying Per 1000 Children Aged 5–14 Years High,
  "comments" VARCHAR
);

CREATE TABLE owid_mortality_rate_for_5_14_year_olds_probability_of__b876ff28 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "mortality_rate_for_5_14_year_olds_probability_of_dying_22c4eb49" FLOAT  -- Mortality Rate For 5–14 Year Olds, Probability Of Dying Per 1000 Children Aged 5–14 Years
);

CREATE TABLE owid_most_recent_school_based_survey_among_adolescents_2834a9ba (
  "year" INTEGER,
  "country" VARCHAR,
  "most_recent_school_based_survey_among_adolescents_was__deb1e459" VARCHAR  -- Most Recent School Based Survey Among Adolescents Was Recent, In The Past 5 Years,
  "most_recent_school_based_survey_among_adolescents_was__ef1d1feb" VARCHAR  -- Most Recent School Based Survey Among Adolescents Was Recent, In The Past 5 Years Low,
  "most_recent_school_based_survey_among_adolescents_was__82675944" VARCHAR  -- Most Recent School Based Survey Among Adolescents Was Recent, In The Past 5 Years High,
  "comments" VARCHAR
);

CREATE TABLE owid_most_recent_school_based_survey_among_adolescents_57b73729 (
  "year" INTEGER,
  "country" VARCHAR,
  "most_recent_school_based_survey_among_adolescents_was__f546b06e" VARCHAR  -- Most Recent School Based Survey Among Adolescents Was Representative Of The National Population
);

CREATE TABLE owid_most_recent_school_based_survey_among_adolescents_e797419b (
  "year" INTEGER,
  "country" VARCHAR,
  "most_recent_school_based_survey_among_adolescents_was__deb1e459" VARCHAR  -- Most Recent School Based Survey Among Adolescents Was Recent, In The Past 5 Years
);

CREATE TABLE owid_most_recent_school_based_survey_among_adolescents_eb820cfa (
  "year" INTEGER,
  "country" VARCHAR,
  "most_recent_school_based_survey_among_adolescents_was__f546b06e" VARCHAR  -- Most Recent School Based Survey Among Adolescents Was Representative Of The National Population,
  "most_recent_school_based_survey_among_adolescents_was__35fb50d6" VARCHAR  -- Most Recent School Based Survey Among Adolescents Was Representative Of The National Population Low,
  "most_recent_school_based_survey_among_adolescents_was__d85db832" VARCHAR  -- Most Recent School Based Survey Among Adolescents Was Representative Of The National Population High,
  "comments" VARCHAR
);

CREATE TABLE owid_most_recent_survey_among_adults_was_recent_in_the_48467041 (
  "year" INTEGER,
  "country" VARCHAR,
  "most_recent_survey_among_adults_was_recent_in_the_past_5_years" VARCHAR  -- Most Recent Survey Among Adults Was Recent, In The Past 5 Years,
  "most_recent_survey_among_adults_was_recent_in_the_past_d9c94fbc" VARCHAR  -- Most Recent Survey Among Adults Was Recent, In The Past 5 Years Low,
  "most_recent_survey_among_adults_was_recent_in_the_past_5e146893" VARCHAR  -- Most Recent Survey Among Adults Was Recent, In The Past 5 Years High,
  "comments" VARCHAR
);

CREATE TABLE owid_most_recent_survey_among_adults_was_recent_in_the_816c7e2c (
  "year" INTEGER,
  "country" VARCHAR,
  "most_recent_survey_among_adults_was_recent_in_the_past_5_years" VARCHAR  -- Most Recent Survey Among Adults Was Recent, In The Past 5 Years
);

CREATE TABLE owid_most_recent_survey_among_adults_was_representativ_d48215ae (
  "year" INTEGER,
  "country" VARCHAR,
  "most_recent_survey_among_adults_was_representative_of__2194bc84" VARCHAR  -- Most Recent Survey Among Adults Was Representative Of The National Population,
  "most_recent_survey_among_adults_was_representative_of__d1d00860" VARCHAR  -- Most Recent Survey Among Adults Was Representative Of The National Population Low,
  "most_recent_survey_among_adults_was_representative_of__582f3d22" VARCHAR  -- Most Recent Survey Among Adults Was Representative Of The National Population High,
  "comments" VARCHAR
);

CREATE TABLE owid_most_recent_survey_among_adults_was_representativ_fec247bb (
  "year" INTEGER,
  "country" VARCHAR,
  "most_recent_survey_among_adults_was_representative_of__2194bc84" VARCHAR  -- Most Recent Survey Among Adults Was Representative Of The National Population
);

CREATE TABLE owid_most_sold_brand_of_cigarettes_currency_reported_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "most_sold_brand_of_cigarettes_currency_reported" VARCHAR  -- Most Sold Brand Of Cigarettes, Currency Reported
);

CREATE TABLE owid_most_sold_brand_of_cigarettes_currency_reported_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "most_sold_brand_of_cigarettes_currency_reported" VARCHAR  -- Most Sold Brand Of Cigarettes, Currency Reported,
  "most_sold_brand_of_cigarettes_currency_reported_low" VARCHAR  -- Most Sold Brand Of Cigarettes, Currency Reported Low,
  "most_sold_brand_of_cigarettes_currency_reported_high" VARCHAR  -- Most Sold Brand Of Cigarettes, Currency Reported High,
  "comments" VARCHAR
);

CREATE TABLE owid_most_sold_brand_of_cigarettes_price_in_currency_reported_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "most_sold_brand_of_cigarettes_price_in_currency_reported" FLOAT  -- Most Sold Brand Of Cigarettes, Price In Currency Reported
);

CREATE TABLE owid_most_sold_brand_of_cigarettes_price_in_currency_reported_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "most_sold_brand_of_cigarettes_price_in_currency_reported" FLOAT  -- Most Sold Brand Of Cigarettes, Price In Currency Reported,
  "most_sold_brand_of_cigarettes_price_in_currency_reported_low" VARCHAR  -- Most Sold Brand Of Cigarettes, Price In Currency Reported Low,
  "most_sold_brand_of_cigarettes_price_in_currency_reported_high" VARCHAR  -- Most Sold Brand Of Cigarettes, Price In Currency Reported High,
  "comments" VARCHAR
);