Global Health Observatory - World Health Organization

CREATE TABLE owid_restrictions_on_sales_promotion_from_owners_of_pu_6040f423 (
  "year" INTEGER,
  "country" VARCHAR,
  "beverage_types" VARCHAR,
  "restrictions_on_sales_promotion_from_owners_of_pubs_an_c5a34c58" VARCHAR  -- Restrictions On Sales Promotion From Owners Of Pubs And Bars, Alcohol For Free
);

CREATE TABLE owid_restrictions_on_sales_promotion_from_producers_pa_d2b431f7 (
  "year" INTEGER,
  "country" VARCHAR,
  "beverage_types" VARCHAR,
  "restrictions_on_sales_promotion_from_producers_parties_events" VARCHAR  -- Restrictions On Sales Promotion From Producers, Parties, Events,
  "restrictions_on_sales_promotion_from_producers_parties_54b5efa5" VARCHAR  -- Restrictions On Sales Promotion From Producers, Parties, Events Low,
  "restrictions_on_sales_promotion_from_producers_parties_48a8c6ec" VARCHAR  -- Restrictions On Sales Promotion From Producers, Parties, Events High,
  "comments" VARCHAR
);

CREATE TABLE owid_restrictions_on_sales_promotion_from_producers_pa_fd0f1cd1 (
  "year" INTEGER,
  "country" VARCHAR,
  "beverage_types" VARCHAR,
  "restrictions_on_sales_promotion_from_producers_parties_events" VARCHAR  -- Restrictions On Sales Promotion From Producers, Parties, Events
);

CREATE TABLE owid_restrictions_on_sales_promotion_from_retailers_sa_1ec17d47 (
  "year" INTEGER,
  "country" VARCHAR,
  "beverage_types" VARCHAR,
  "restrictions_on_sales_promotion_from_retailers_sales_below_cost" VARCHAR  -- Restrictions On Sales Promotion From Retailers, Sales Below Cost,
  "restrictions_on_sales_promotion_from_retailers_sales_b_9659eecc" VARCHAR  -- Restrictions On Sales Promotion From Retailers, Sales Below Cost Low,
  "restrictions_on_sales_promotion_from_retailers_sales_b_000b86bb" VARCHAR  -- Restrictions On Sales Promotion From Retailers, Sales Below Cost High,
  "comments" VARCHAR
);

CREATE TABLE owid_restrictions_on_sales_promotion_from_retailers_sa_d63d20fa (
  "year" INTEGER,
  "country" VARCHAR,
  "beverage_types" VARCHAR,
  "restrictions_on_sales_promotion_from_retailers_sales_below_cost" VARCHAR  -- Restrictions On Sales Promotion From Retailers, Sales Below Cost
);

CREATE TABLE owid_restrictions_on_sponsorship_of_sporting_events_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "sponsorship_originator" VARCHAR,
  "restrictions_on_sponsorship_of_sporting_events" VARCHAR
);

CREATE TABLE owid_restrictions_on_sponsorship_of_sporting_events_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "sponsorship_originator" VARCHAR,
  "restrictions_on_sponsorship_of_sporting_events" VARCHAR,
  "restrictions_on_sponsorship_of_sporting_events_low" VARCHAR,
  "restrictions_on_sponsorship_of_sporting_events_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_restrictions_on_sponsorship_of_youth_events_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "sponsorship_originator" VARCHAR,
  "restrictions_on_sponsorship_of_youth_events" VARCHAR
);

CREATE TABLE owid_restrictions_on_sponsorship_of_youth_events_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "sponsorship_originator" VARCHAR,
  "restrictions_on_sponsorship_of_youth_events" VARCHAR,
  "restrictions_on_sponsorship_of_youth_events_low" VARCHAR,
  "restrictions_on_sponsorship_of_youth_events_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_retail_price_for_tobacco_and_nicotine_products_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "price" VARCHAR,
  "tobacco_and_nicotine_product" VARCHAR,
  "retail_price_for_tobacco_and_nicotine_products" FLOAT,
  "comments" VARCHAR
);

CREATE TABLE owid_retail_price_for_tobacco_and_nicotine_products_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "tobacco_and_nicotine_product" VARCHAR,
  "price" VARCHAR,
  "retail_price_for_tobacco_and_nicotine_products" FLOAT,
  "retail_price_for_tobacco_and_nicotine_products_low" VARCHAR,
  "retail_price_for_tobacco_and_nicotine_products_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_retreatment_cases_other_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "retreatment_cases_other" UINTEGER  -- Retreatment Cases, Other
);

CREATE TABLE owid_retreatment_cases_other_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "retreatment_cases_other" UINTEGER  -- Retreatment Cases, Other,
  "retreatment_cases_other_low" VARCHAR  -- Retreatment Cases, Other Low,
  "retreatment_cases_other_high" VARCHAR  -- Retreatment Cases, Other High,
  "comments" VARCHAR
);

CREATE TABLE owid_retreatment_cases_treatment_after_default_pulmona_18a147c0 (
  "year" INTEGER,
  "country" VARCHAR,
  "retreatment_cases_treatment_after_default_pulmonary_sm_a9c6958b" UINTEGER  -- Retreatment Cases, Treatment After Default, Pulmonary Smear And Or Culture Positive
);

CREATE TABLE owid_retreatment_cases_treatment_after_default_pulmona_a6c23b9d (
  "year" INTEGER,
  "country" VARCHAR,
  "retreatment_cases_treatment_after_default_pulmonary_sm_a9c6958b" UINTEGER  -- Retreatment Cases, Treatment After Default, Pulmonary Smear And Or Culture Positive,
  "retreatment_cases_treatment_after_default_pulmonary_sm_dce89eae" VARCHAR  -- Retreatment Cases, Treatment After Default, Pulmonary Smear And Or Culture Positive Low,
  "retreatment_cases_treatment_after_default_pulmonary_sm_714a2734" VARCHAR  -- Retreatment Cases, Treatment After Default, Pulmonary Smear And Or Culture Positive High,
  "comments" VARCHAR
);

CREATE TABLE owid_retreatment_cases_treatment_after_failure_pulmona_a140b4c3 (
  "year" INTEGER,
  "country" VARCHAR,
  "retreatment_cases_treatment_after_failure_pulmonary_sm_e96f406f" INTEGER  -- Retreatment Cases, Treatment After Failure, Pulmonary Smear And Or Culture Positive,
  "retreatment_cases_treatment_after_failure_pulmonary_sm_4ae2dcd3" VARCHAR  -- Retreatment Cases, Treatment After Failure, Pulmonary Smear And Or Culture Positive Low,
  "retreatment_cases_treatment_after_failure_pulmonary_sm_1a0f2501" VARCHAR  -- Retreatment Cases, Treatment After Failure, Pulmonary Smear And Or Culture Positive High,
  "comments" VARCHAR
);

CREATE TABLE owid_retreatment_cases_treatment_after_failure_pulmona_aa9a4c04 (
  "year" INTEGER,
  "country" VARCHAR,
  "retreatment_cases_treatment_after_failure_pulmonary_sm_e96f406f" INTEGER  -- Retreatment Cases, Treatment After Failure, Pulmonary Smear And Or Culture Positive
);

CREATE TABLE owid_risk_communication (
  "year" INTEGER,
  "country" VARCHAR,
  "risk_communication" INTEGER
);

CREATE TABLE owid_risk_communication_spar (
  "year" INTEGER,
  "country" VARCHAR,
  "ihr_spar_capacity_level" VARCHAR,
  "risk_communication_spar" INTEGER  -- Risk Communication, Spar
);

CREATE TABLE owid_road_traffic_injuries_age_standardized_death_rate_e6492894 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "road_traffic_injuries_age_standardized_death_rates_15p_e6ecf1bb" FLOAT  -- Road Traffic Injuries, Age Standardized Death Rates, 15plus, Per 100–000 Population,
  "road_traffic_injuries_age_standardized_death_rates_15p_c738ff80" VARCHAR  -- Road Traffic Injuries, Age Standardized Death Rates, 15plus, Per 100–000 Population Low,
  "road_traffic_injuries_age_standardized_death_rates_15p_6f5928f8" VARCHAR  -- Road Traffic Injuries, Age Standardized Death Rates, 15plus, Per 100–000 Population High,
  "comments" VARCHAR
);

CREATE TABLE owid_road_traffic_injuries_age_standardized_death_rate_f503a51a (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "road_traffic_injuries_age_standardized_death_rates_15p_e6ecf1bb" VARCHAR  -- Road Traffic Injuries, Age Standardized Death Rates, 15plus, Per 100–000 Population
);

CREATE TABLE owid_rotavirus_vaccines_completed_dose_rotac_immunizat_363c85cc (
  "year" INTEGER,
  "country" VARCHAR,
  "rotavirus_vaccines_completed_dose_rotac_immunization_c_d9714321" INTEGER  -- Rotavirus Vaccines Completed Dose, Rotac, Immunization Coverage Among 1 Year Olds, Pct
);

CREATE TABLE owid_rotavirus_vaccines_completed_dose_rotac_immunizat_5b502f7a (
  "year" INTEGER,
  "country" VARCHAR,
  "rotavirus_vaccines_completed_dose_rotac_immunization_c_d9714321" INTEGER  -- Rotavirus Vaccines Completed Dose, Rotac, Immunization Coverage Among 1 Year Olds, Pct,
  "rotavirus_vaccines_completed_dose_rotac_immunization_c_0bcb32e8" VARCHAR  -- Rotavirus Vaccines Completed Dose, Rotac, Immunization Coverage Among 1 Year Olds, Pct Low,
  "rotavirus_vaccines_completed_dose_rotac_immunization_c_791340e3" VARCHAR  -- Rotavirus Vaccines Completed Dose, Rotac, Immunization Coverage Among 1 Year Olds, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_routine_monitoring_of_people_with_dementia_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "routine_monitoring_of_people_with_dementia" VARCHAR
);

CREATE TABLE owid_routine_monitoring_of_people_with_dementia_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "routine_monitoring_of_people_with_dementia" VARCHAR,
  "routine_monitoring_of_people_with_dementia_low" VARCHAR,
  "routine_monitoring_of_people_with_dementia_high" VARCHAR,
  "comments" VARCHAR
);