Global Health Observatory - World Health Organization

CREATE TABLE owid_subnational_bans_on_tobacco_advertising_promotion_889debc5 (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "subnational_bans_on_tobacco_advertising_promotion_and__45c1875a" VARCHAR  -- Subnational Bans On Tobacco Advertising, Promotion And Sponsorship Authority Exists
);

CREATE TABLE owid_subnational_bans_on_tobacco_advertising_promotion_d8a3894f (
  "year" INTEGER,
  "country" VARCHAR,
  "subnational_bans_on_tobacco_advertising_promotion_and__45c1875a" VARCHAR  -- Subnational Bans On Tobacco Advertising, Promotion And Sponsorship Authority Exists,
  "subnational_bans_on_tobacco_advertising_promotion_and__1161765d" VARCHAR  -- Subnational Bans On Tobacco Advertising, Promotion And Sponsorship Authority Exists Low,
  "subnational_bans_on_tobacco_advertising_promotion_and__c927620a" VARCHAR  -- Subnational Bans On Tobacco Advertising, Promotion And Sponsorship Authority Exists High,
  "comments" VARCHAR
);

CREATE TABLE owid_subnational_smoke_free_legislation_authority_exists_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "subnational_smoke_free_legislation_authority_exists" VARCHAR
);

CREATE TABLE owid_subnational_smoke_free_legislation_authority_exists_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "subnational_smoke_free_legislation_authority_exists" VARCHAR,
  "subnational_smoke_free_legislation_authority_exists_low" VARCHAR,
  "subnational_smoke_free_legislation_authority_exists_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_subnational_smoking_bans_at_least_one_jurisdictio_0422a9ea (
  "year" INTEGER,
  "country" VARCHAR,
  "subnational_smoking_bans_at_least_one_jurisdiction_has_8b1cd045" VARCHAR  -- Subnational Smoking Bans, At Least One Jurisdiction Has A Comprehensive Ban In Place,
  "subnational_smoking_bans_at_least_one_jurisdiction_has_fdc06a07" VARCHAR  -- Subnational Smoking Bans, At Least One Jurisdiction Has A Comprehensive Ban In Place Low,
  "subnational_smoking_bans_at_least_one_jurisdiction_has_a2ce8f93" VARCHAR  -- Subnational Smoking Bans, At Least One Jurisdiction Has A Comprehensive Ban In Place High,
  "comments" VARCHAR
);

CREATE TABLE owid_subnational_smoking_bans_at_least_one_jurisdictio_d93c50e8 (
  "year" INTEGER,
  "country" VARCHAR,
  "subnational_smoking_bans_at_least_one_jurisdiction_has_8b1cd045" VARCHAR  -- Subnational Smoking Bans, At Least One Jurisdiction Has A Comprehensive Ban In Place
);

CREATE TABLE owid_substance_use_policy_at_the_national_level_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "substance_use_policy_at_the_national_level" VARCHAR
);

CREATE TABLE owid_substance_use_policy_at_the_national_level_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "substance_use_policy_at_the_national_level" VARCHAR,
  "substance_use_policy_at_the_national_level_low" VARCHAR,
  "substance_use_policy_at_the_national_level_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_substance_use_policy_at_the_national_level_level__9897f35c (
  "year" INTEGER,
  "country" VARCHAR,
  "substance_use_policy_at_the_national_level_level_of_integration" VARCHAR  -- Substance Use Policy At The National Level, Level Of Integration,
  "substance_use_policy_at_the_national_level_level_of_in_16825d7d" VARCHAR  -- Substance Use Policy At The National Level, Level Of Integration Low,
  "substance_use_policy_at_the_national_level_level_of_in_12a6e57e" VARCHAR  -- Substance Use Policy At The National Level, Level Of Integration High,
  "comments" VARCHAR
);

CREATE TABLE owid_substance_use_policy_at_the_national_level_level__bd4d97f6 (
  "year" INTEGER,
  "country" VARCHAR,
  "substance_use_policy_at_the_national_level_level_of_integration" VARCHAR  -- Substance Use Policy At The National Level, Level Of Integration
);

CREATE TABLE owid_sugar_content_of_beverage_per_100ml_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "beverage_type" VARCHAR,
  "beverage" VARCHAR,
  "sugar_content_of_beverage_per_100ml" FLOAT,
  "comments" VARCHAR
);

CREATE TABLE owid_sugar_content_of_beverage_per_100ml_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "beverage_type" VARCHAR,
  "beverage" VARCHAR,
  "sugar_content_of_beverage_per_100ml" FLOAT,
  "sugar_content_of_beverage_per_100ml_low" VARCHAR,
  "sugar_content_of_beverage_per_100ml_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_supervision_requirements_for_buprenorphine_admini_781d0ec5 (
  "year" INTEGER,
  "country" VARCHAR,
  "rsud_drug_supervision" VARCHAR,
  "supervision_requirements_for_buprenorphine_administration" VARCHAR,
  "supervision_requirements_for_buprenorphine_administration_low" VARCHAR,
  "supervision_requirements_for_buprenorphine_administration_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_supervision_requirements_for_buprenorphine_admini_8b1da5ff (
  "year" INTEGER,
  "country" VARCHAR,
  "rsud_drug_supervision" VARCHAR,
  "supervision_requirements_for_buprenorphine_administration" VARCHAR
);

CREATE TABLE owid_supervision_requirements_for_buprenorphine_naloxo_0bf998aa (
  "year" INTEGER,
  "country" VARCHAR,
  "rsud_drug_supervision" VARCHAR,
  "supervision_requirements_for_buprenorphine_naloxone_ad_a690e954" VARCHAR  -- Supervision Requirements For Buprenorphine Naloxone Administration
);

CREATE TABLE owid_supervision_requirements_for_buprenorphine_naloxo_23add8e3 (
  "year" INTEGER,
  "country" VARCHAR,
  "rsud_drug_supervision" VARCHAR,
  "supervision_requirements_for_buprenorphine_naloxone_ad_a690e954" VARCHAR  -- Supervision Requirements For Buprenorphine Naloxone Administration,
  "supervision_requirements_for_buprenorphine_naloxone_ad_a2454feb" VARCHAR  -- Supervision Requirements For Buprenorphine Naloxone Administration Low,
  "supervision_requirements_for_buprenorphine_naloxone_ad_c13d43e7" VARCHAR  -- Supervision Requirements For Buprenorphine Naloxone Administration High,
  "comments" VARCHAR
);

CREATE TABLE owid_supervision_requirements_for_methadone_administration_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "rsud_drug_supervision" VARCHAR,
  "supervision_requirements_for_methadone_administration" VARCHAR
);

CREATE TABLE owid_supervision_requirements_for_methadone_administration_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "rsud_drug_supervision" VARCHAR,
  "supervision_requirements_for_methadone_administration" VARCHAR,
  "supervision_requirements_for_methadone_administration_low" VARCHAR,
  "supervision_requirements_for_methadone_administration_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_surveillance (
  "year" INTEGER,
  "country" VARCHAR,
  "surveillance" INTEGER
);

CREATE TABLE owid_surveillance_spar (
  "year" INTEGER,
  "country" VARCHAR,
  "ihr_spar_capacity_level" VARCHAR,
  "surveillance_spar" INTEGER  -- Surveillance, Spar
);

CREATE TABLE owid_survey_previous_to_the_most_recent_school_based_s_1b7ef0eb (
  "year" INTEGER,
  "country" VARCHAR,
  "survey_previous_to_the_most_recent_school_based_survey_5af81f1e" VARCHAR  -- Survey Previous To The Most Recent School Based Survey Among Adolescents Was Within The 5 Years Prior,
  "survey_previous_to_the_most_recent_school_based_survey_e905a7d1" VARCHAR  -- Survey Previous To The Most Recent School Based Survey Among Adolescents Was Within The 5 Years Prior Low,
  "survey_previous_to_the_most_recent_school_based_survey_7d8fd1f9" VARCHAR  -- Survey Previous To The Most Recent School Based Survey Among Adolescents Was Within The 5 Years Prior High,
  "comments" VARCHAR
);

CREATE TABLE owid_survey_previous_to_the_most_recent_school_based_s_3ae53a92 (
  "year" INTEGER,
  "country" VARCHAR,
  "survey_previous_to_the_most_recent_school_based_survey_5af81f1e" VARCHAR  -- Survey Previous To The Most Recent School Based Survey Among Adolescents Was Within The 5 Years Prior
);

CREATE TABLE owid_survey_previous_to_the_most_recent_survey_among_a_cca7ffee (
  "year" INTEGER,
  "country" VARCHAR,
  "survey_previous_to_the_most_recent_survey_among_adults_3da93d0d" VARCHAR  -- Survey Previous To The Most Recent Survey Among Adults Was Within The 5 Years Prior
);

CREATE TABLE owid_survey_previous_to_the_most_recent_survey_among_a_f5398192 (
  "year" INTEGER,
  "country" VARCHAR,
  "survey_previous_to_the_most_recent_survey_among_adults_3da93d0d" VARCHAR  -- Survey Previous To The Most Recent Survey Among Adults Was Within The 5 Years Prior,
  "survey_previous_to_the_most_recent_survey_among_adults_8eb436c9" VARCHAR  -- Survey Previous To The Most Recent Survey Among Adults Was Within The 5 Years Prior Low,
  "survey_previous_to_the_most_recent_survey_among_adults_64b4393c" VARCHAR  -- Survey Previous To The Most Recent Survey Among Adults Was Within The 5 Years Prior High,
  "comments" VARCHAR
);

CREATE TABLE owid_surveys_research_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "surveys_research" VARCHAR  -- Surveys, Research
);