Global Health Observatory - World Health Organization

CREATE TABLE owid_name_of_latest_adult_prevalence_survey_nonsmoked_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "name_of_latest_adult_prevalence_survey_nonsmoked" VARCHAR  -- Name Of Latest Adult Prevalence Survey, Nonsmoked,
  "name_of_latest_adult_prevalence_survey_nonsmoked_low" VARCHAR  -- Name Of Latest Adult Prevalence Survey, Nonsmoked Low,
  "name_of_latest_adult_prevalence_survey_nonsmoked_high" VARCHAR  -- Name Of Latest Adult Prevalence Survey, Nonsmoked High,
  "comments" VARCHAR
);

CREATE TABLE owid_name_of_latest_youth_prevalence_survey_nonsmoked_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "name_of_latest_youth_prevalence_survey_nonsmoked" VARCHAR  -- Name Of Latest Youth Prevalence Survey, Nonsmoked
);

CREATE TABLE owid_name_of_latest_youth_prevalence_survey_nonsmoked_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "name_of_latest_youth_prevalence_survey_nonsmoked" VARCHAR  -- Name Of Latest Youth Prevalence Survey, Nonsmoked,
  "name_of_latest_youth_prevalence_survey_nonsmoked_low" VARCHAR  -- Name Of Latest Youth Prevalence Survey, Nonsmoked Low,
  "name_of_latest_youth_prevalence_survey_nonsmoked_high" VARCHAR  -- Name Of Latest Youth Prevalence Survey, Nonsmoked High,
  "comments" VARCHAR
);

CREATE TABLE owid_national_agency_for_tobacco_control_exists_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "national_agency_for_tobacco_control_exists" VARCHAR
);

CREATE TABLE owid_national_agency_for_tobacco_control_exists_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "national_agency_for_tobacco_control_exists" VARCHAR,
  "national_agency_for_tobacco_control_exists_low" VARCHAR,
  "national_agency_for_tobacco_control_exists_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_national_alcohol_policy_specifically_involves_you_b1fe6885 (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "national_alcohol_policy_specifically_involves_young_pe_c69a4074" VARCHAR  -- National Alcohol Policy Specifically Involves Young People Activities
);

CREATE TABLE owid_national_alcohol_policy_specifically_involves_you_c449f67b (
  "year" INTEGER,
  "country" VARCHAR,
  "national_alcohol_policy_specifically_involves_young_pe_c69a4074" VARCHAR  -- National Alcohol Policy Specifically Involves Young People Activities,
  "national_alcohol_policy_specifically_involves_young_pe_ac7f1df6" VARCHAR  -- National Alcohol Policy Specifically Involves Young People Activities Low,
  "national_alcohol_policy_specifically_involves_young_pe_37781fe8" VARCHAR  -- National Alcohol Policy Specifically Involves Young People Activities High,
  "comments" VARCHAR
);

CREATE TABLE owid_national_authority_responsible_for_regulating_med_082650b5 (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "national_authority_responsible_for_regulating_medical_devices" VARCHAR
);

CREATE TABLE owid_national_authority_responsible_for_regulating_med_5758e33f (
  "year" INTEGER,
  "country" VARCHAR,
  "national_authority_responsible_for_regulating_medical_devices" VARCHAR,
  "national_authority_responsible_for_regulating_medical__f18757ce" VARCHAR  -- National Authority Responsible For Regulating Medical Devices Low,
  "national_authority_responsible_for_regulating_medical__fe20b058" VARCHAR  -- National Authority Responsible For Regulating Medical Devices High,
  "comments" VARCHAR
);

CREATE TABLE owid_national_drinking_guidelines_2010_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "national_drinking_guidelines_2010" VARCHAR  -- National Drinking Guidelines, 2010
);

CREATE TABLE owid_national_drinking_guidelines_2010_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "national_drinking_guidelines_2010" VARCHAR  -- National Drinking Guidelines, 2010,
  "national_drinking_guidelines_2010_low" VARCHAR  -- National Drinking Guidelines, 2010 Low,
  "national_drinking_guidelines_2010_high" VARCHAR  -- National Drinking Guidelines, 2010 High,
  "comments" VARCHAR
);

CREATE TABLE owid_national_drinking_guidelines_2016_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "national_drinking_guidelines_2016" VARCHAR
);

CREATE TABLE owid_national_drinking_guidelines_2016_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "national_drinking_guidelines_2016" VARCHAR,
  "national_drinking_guidelines_2016_low" VARCHAR,
  "national_drinking_guidelines_2016_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_national_ehealth_strategy_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "national_ehealth_strategy" VARCHAR
);

CREATE TABLE owid_national_ehealth_strategy_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "national_ehealth_strategy" VARCHAR,
  "national_ehealth_strategy_low" VARCHAR,
  "national_ehealth_strategy_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_national_ehealth_strategy_refers_to_objectives_of_uhc_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "national_ehealth_strategy_refers_to_objectives_of_uhc" VARCHAR
);

CREATE TABLE owid_national_ehealth_strategy_refers_to_objectives_of_uhc_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "national_ehealth_strategy_refers_to_objectives_of_uhc" VARCHAR,
  "national_ehealth_strategy_refers_to_objectives_of_uhc_low" VARCHAR,
  "national_ehealth_strategy_refers_to_objectives_of_uhc_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_national_guidelines_for_alcohol_problem_preventio_4f53d6eb (
  "year" INTEGER,
  "country" VARCHAR,
  "national_guidelines_for_alcohol_problem_prevention_and_c6d6ecbf" VARCHAR  -- National Guidelines For Alcohol Problem Prevention And Counselling At Workplaces
);

CREATE TABLE owid_national_guidelines_for_alcohol_problem_preventio_d4f11b9f (
  "year" INTEGER,
  "country" VARCHAR,
  "national_guidelines_for_alcohol_problem_prevention_and_c6d6ecbf" VARCHAR  -- National Guidelines For Alcohol Problem Prevention And Counselling At Workplaces,
  "national_guidelines_for_alcohol_problem_prevention_and_82aaed76" VARCHAR  -- National Guidelines For Alcohol Problem Prevention And Counselling At Workplaces Low,
  "national_guidelines_for_alcohol_problem_prevention_and_76b81103" VARCHAR  -- National Guidelines For Alcohol Problem Prevention And Counselling At Workplaces High,
  "comments" VARCHAR
);

CREATE TABLE owid_national_guidelines_for_implementing_effective_co_842d40f7 (
  "year" INTEGER,
  "country" VARCHAR,
  "national_guidelines_for_implementing_effective_communi_a8fc7bdd" VARCHAR  -- National Guidelines For Implementing Effective Community Based Interventions,
  "national_guidelines_for_implementing_effective_communi_d597fbee" VARCHAR  -- National Guidelines For Implementing Effective Community Based Interventions Low,
  "national_guidelines_for_implementing_effective_communi_6e5fcf72" VARCHAR  -- National Guidelines For Implementing Effective Community Based Interventions High,
  "comments" VARCHAR
);

CREATE TABLE owid_national_guidelines_for_implementing_effective_co_99157712 (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "national_guidelines_for_implementing_effective_communi_a8fc7bdd" VARCHAR  -- National Guidelines For Implementing Effective Community Based Interventions
);

CREATE TABLE owid_national_guidelines_for_the_prevention_and_reduct_3fd6a18f (
  "year" INTEGER,
  "country" VARCHAR,
  "national_guidelines_for_the_prevention_and_reduction_o_c9e2c173" VARCHAR  -- National Guidelines For The Prevention And Reduction Of Alcohol Related Harm In Schools
);

CREATE TABLE owid_national_guidelines_for_the_prevention_and_reduct_eb52d7d9 (
  "year" INTEGER,
  "country" VARCHAR,
  "national_guidelines_for_the_prevention_and_reduction_o_c9e2c173" VARCHAR  -- National Guidelines For The Prevention And Reduction Of Alcohol Related Harm In Schools,
  "national_guidelines_for_the_prevention_and_reduction_o_12ae8845" VARCHAR  -- National Guidelines For The Prevention And Reduction Of Alcohol Related Harm In Schools Low,
  "national_guidelines_for_the_prevention_and_reduction_o_63d0080b" VARCHAR  -- National Guidelines For The Prevention And Reduction Of Alcohol Related Harm In Schools High,
  "comments" VARCHAR
);

CREATE TABLE owid_national_guidelines_policies_or_recommendations_o_422083f1 (
  "year" INTEGER,
  "country" VARCHAR,
  "national_guidelines_policies_or_recommendations_on_the_55edd975" INTEGER  -- National Guidelines, Policies Or Recommendations On The Procurement Of Medical Devices,
  "national_guidelines_policies_or_recommendations_on_the_64a903b0" VARCHAR  -- National Guidelines, Policies Or Recommendations On The Procurement Of Medical Devices Low,
  "national_guidelines_policies_or_recommendations_on_the_f1266412" VARCHAR  -- National Guidelines, Policies Or Recommendations On The Procurement Of Medical Devices High,
  "comments" VARCHAR
);

CREATE TABLE owid_national_guidelines_policies_or_recommendations_o_eb8f268c (
  "year" INTEGER,
  "country" VARCHAR,
  "national_guidelines_policies_or_recommendations_on_the_55edd975" INTEGER  -- National Guidelines, Policies Or Recommendations On The Procurement Of Medical Devices,
  "comments" VARCHAR
);