Global Health Observatory - World Health Organization

CREATE TABLE owid_representation_of_latest_youth_prevalence_survey__a48e1d78 (
  "year" INTEGER,
  "country" VARCHAR,
  "representation_of_latest_youth_prevalence_survey_nonsmoked" VARCHAR  -- Representation Of Latest Youth Prevalence Survey, Nonsmoked,
  "representation_of_latest_youth_prevalence_survey_nonsmoked_low" VARCHAR  -- Representation Of Latest Youth Prevalence Survey, Nonsmoked Low,
  "representation_of_latest_youth_prevalence_survey_nonsmoked_high" VARCHAR  -- Representation Of Latest Youth Prevalence Survey, Nonsmoked High,
  "comments" VARCHAR
);

CREATE TABLE owid_representativeness_of_most_recent_adolescent_survey_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "representativeness_of_most_recent_adolescent_survey" VARCHAR
);

CREATE TABLE owid_representativeness_of_most_recent_adolescent_survey_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "representativeness_of_most_recent_adolescent_survey" VARCHAR,
  "representativeness_of_most_recent_adolescent_survey_low" VARCHAR,
  "representativeness_of_most_recent_adolescent_survey_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_representativeness_of_most_recent_survey_of_adults_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "representativeness_of_most_recent_survey_of_adults" VARCHAR
);

CREATE TABLE owid_representativeness_of_most_recent_survey_of_adults_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "representativeness_of_most_recent_survey_of_adults" VARCHAR,
  "representativeness_of_most_recent_survey_of_adults_low" VARCHAR,
  "representativeness_of_most_recent_survey_of_adults_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_required_anti_tobacco_ads_for_any_visual_entertai_0aa79806 (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "required_anti_tobacco_ads_for_any_visual_entertainment_69b1c5ee" VARCHAR  -- Required Anti Tobacco Ads For Any Visual Entertainment Media Product That Depicts Tobacco Products, Use Or Images, See E14b Movies Anti Tob Ads
);

CREATE TABLE owid_required_anti_tobacco_ads_for_any_visual_entertai_10a3cc45 (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "required_anti_tobacco_ads_for_any_visual_entertainment_3cce26be" VARCHAR  -- Required Anti Tobacco Ads For Any Visual Entertainment Media Product That Depicts Tobacco Products, Use Or Images
);

CREATE TABLE owid_required_anti_tobacco_ads_for_any_visual_entertai_67116f2a (
  "year" INTEGER,
  "country" VARCHAR,
  "required_anti_tobacco_ads_for_any_visual_entertainment_69b1c5ee" VARCHAR  -- Required Anti Tobacco Ads For Any Visual Entertainment Media Product That Depicts Tobacco Products, Use Or Images, See E14b Movies Anti Tob Ads,
  "required_anti_tobacco_ads_for_any_visual_entertainment_7c5b8ccf" VARCHAR  -- Required Anti Tobacco Ads For Any Visual Entertainment Media Product That Depicts Tobacco Products, Use Or Images, See E14b Movies Anti Tob Ads Low,
  "required_anti_tobacco_ads_for_any_visual_entertainment_e732eec5" VARCHAR  -- Required Anti Tobacco Ads For Any Visual Entertainment Media Product That Depicts Tobacco Products, Use Or Images, See E14b Movies Anti Tob Ads High,
  "comments" VARCHAR
);

CREATE TABLE owid_required_anti_tobacco_ads_for_any_visual_entertai_9424da4d (
  "year" INTEGER,
  "country" VARCHAR,
  "required_anti_tobacco_ads_for_any_visual_entertainment_3cce26be" VARCHAR  -- Required Anti Tobacco Ads For Any Visual Entertainment Media Product That Depicts Tobacco Products, Use Or Images,
  "required_anti_tobacco_ads_for_any_visual_entertainment_8dd4b256" VARCHAR  -- Required Anti Tobacco Ads For Any Visual Entertainment Media Product That Depicts Tobacco Products, Use Or Images Low,
  "required_anti_tobacco_ads_for_any_visual_entertainment_d851f781" VARCHAR  -- Required Anti Tobacco Ads For Any Visual Entertainment Media Product That Depicts Tobacco Products, Use Or Images High,
  "comments" VARCHAR
);

CREATE TABLE owid_research_into_new_analytical_methods_needs_occur__25376719 (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "research_into_new_analytical_methods_needs_occur_to_me_20bf9638" VARCHAR  -- Research Into New Analytical Methods Needs Occur To Meet The Challenges Of Working With Big Data,
  "research_into_new_analytical_methods_needs_occur_to_me_b1df67bc" VARCHAR  -- Research Into New Analytical Methods Needs Occur To Meet The Challenges Of Working With Big Data Low,
  "research_into_new_analytical_methods_needs_occur_to_me_151da0a4" VARCHAR  -- Research Into New Analytical Methods Needs Occur To Meet The Challenges Of Working With Big Data High,
  "comments" VARCHAR
);

CREATE TABLE owid_research_into_new_analytical_methods_needs_occur__561b20c6 (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "research_into_new_analytical_methods_needs_occur_to_me_20bf9638" VARCHAR  -- Research Into New Analytical Methods Needs Occur To Meet The Challenges Of Working With Big Data
);

CREATE TABLE owid_residential_long_term_care_beds_per_10_000_population_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "residential_long_term_care_beds_per_10_000_population" UINTEGER  -- Residential Long Term Care Beds, Per 10–000 Population
);

CREATE TABLE owid_residential_long_term_care_beds_per_10_000_population_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "residential_long_term_care_beds_per_10_000_population" UINTEGER  -- Residential Long Term Care Beds, Per 10–000 Population,
  "residential_long_term_care_beds_per_10_000_population_low" VARCHAR  -- Residential Long Term Care Beds, Per 10–000 Population Low,
  "residential_long_term_care_beds_per_10_000_population_high" VARCHAR  -- Residential Long Term Care Beds, Per 10–000 Population High,
  "comments" VARCHAR
);

CREATE TABLE owid_response (
  "year" INTEGER,
  "country" VARCHAR,
  "response" INTEGER
);

CREATE TABLE owid_restriction_and_inspection_of_facilities_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "restriction_and_inspection_of_sunbed_facilities" VARCHAR,
  "comments" VARCHAR,
  "restriction_and_inspection_of_facilities" VARCHAR
);

CREATE TABLE owid_restriction_and_inspection_of_facilities_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "restriction_and_inspection_of_sunbed_facilities" VARCHAR,
  "restriction_and_inspection_of_facilities" VARCHAR,
  "restriction_and_inspection_of_facilities_low" VARCHAR,
  "restriction_and_inspection_of_facilities_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_restrictions_on_alcohol_use_in_public_places_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "substance_abuse_public_places" VARCHAR,
  "restrictions_on_alcohol_use_in_public_places" VARCHAR
);

CREATE TABLE owid_restrictions_on_alcohol_use_in_public_places_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "substance_abuse_public_places" VARCHAR,
  "restrictions_on_alcohol_use_in_public_places" VARCHAR,
  "restrictions_on_alcohol_use_in_public_places_low" VARCHAR,
  "restrictions_on_alcohol_use_in_public_places_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_restrictions_on_product_placement_in_films_movies_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "substance_abuse_advertising_types" VARCHAR,
  "restrictions_on_product_placement_in_films_movies" VARCHAR
);

CREATE TABLE owid_restrictions_on_product_placement_in_films_movies_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "substance_abuse_advertising_types" VARCHAR,
  "restrictions_on_product_placement_in_films_movies" VARCHAR,
  "restrictions_on_product_placement_in_films_movies_low" VARCHAR,
  "restrictions_on_product_placement_in_films_movies_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_restrictions_on_product_placement_on_cable_television_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "substance_abuse_advertising_types" VARCHAR,
  "restrictions_on_product_placement_on_cable_television" VARCHAR
);

CREATE TABLE owid_restrictions_on_product_placement_on_cable_television_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "substance_abuse_advertising_types" VARCHAR,
  "restrictions_on_product_placement_on_cable_television" VARCHAR,
  "restrictions_on_product_placement_on_cable_television_low" VARCHAR,
  "restrictions_on_product_placement_on_cable_television_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_restrictions_on_product_placement_on_national_television_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "substance_abuse_advertising_types" VARCHAR,
  "restrictions_on_product_placement_on_national_television" VARCHAR
);

CREATE TABLE owid_restrictions_on_product_placement_on_national_television_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "substance_abuse_advertising_types" VARCHAR,
  "restrictions_on_product_placement_on_national_television" VARCHAR,
  "restrictions_on_product_placement_on_national_television_low" VARCHAR,
  "restrictions_on_product_placement_on_national_television_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_restrictions_on_sales_promotion_from_owners_of_pu_5ffa49cc (
  "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,
  "restrictions_on_sales_promotion_from_owners_of_pubs_an_549385f4" VARCHAR  -- Restrictions On Sales Promotion From Owners Of Pubs And Bars, Alcohol For Free Low,
  "restrictions_on_sales_promotion_from_owners_of_pubs_an_9817d5a8" VARCHAR  -- Restrictions On Sales Promotion From Owners Of Pubs And Bars, Alcohol For Free High,
  "comments" VARCHAR
);