Global Health Observatory - World Health Organization

CREATE TABLE owid_existence_of_a_national_target_on_drug_therapy_an_d20e2d5e (
  "year" INTEGER,
  "country" VARCHAR,
  "existence_of_a_national_target_on_drug_therapy_and_counselling" VARCHAR
);

CREATE TABLE owid_existence_of_a_national_target_on_essential_medic_5775d106 (
  "year" INTEGER,
  "country" VARCHAR,
  "existence_of_a_national_target_on_essential_medicines__0d98151a" VARCHAR  -- Existence Of A National Target On Essential Medicines And Technologies
);

CREATE TABLE owid_existence_of_a_national_target_on_essential_medic_d4e8f615 (
  "year" INTEGER,
  "country" VARCHAR,
  "existence_of_a_national_target_on_essential_medicines__0d98151a" VARCHAR  -- Existence Of A National Target On Essential Medicines And Technologies,
  "existence_of_a_national_target_on_essential_medicines__5436443e" VARCHAR  -- Existence Of A National Target On Essential Medicines And Technologies Low,
  "existence_of_a_national_target_on_essential_medicines__259d6f69" VARCHAR  -- Existence Of A National Target On Essential Medicines And Technologies High,
  "comments" VARCHAR
);

CREATE TABLE owid_existence_of_a_national_target_on_ncd_mortality_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "existence_of_a_national_target_on_ncd_mortality" VARCHAR
);

CREATE TABLE owid_existence_of_a_national_target_on_ncd_mortality_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "existence_of_a_national_target_on_ncd_mortality" VARCHAR,
  "existence_of_a_national_target_on_ncd_mortality_low" VARCHAR,
  "existence_of_a_national_target_on_ncd_mortality_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_existence_of_a_national_target_on_obesity_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "existence_of_a_national_target_on_obesity" VARCHAR
);

CREATE TABLE owid_existence_of_a_national_target_on_obesity_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "existence_of_a_national_target_on_obesity" VARCHAR,
  "existence_of_a_national_target_on_obesity_low" VARCHAR,
  "existence_of_a_national_target_on_obesity_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_existence_of_a_national_target_on_physical_inactivity_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "existence_of_a_national_target_on_physical_inactivity" VARCHAR
);

CREATE TABLE owid_existence_of_a_national_target_on_physical_inactivity_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "existence_of_a_national_target_on_physical_inactivity" VARCHAR,
  "existence_of_a_national_target_on_physical_inactivity_low" VARCHAR,
  "existence_of_a_national_target_on_physical_inactivity_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_existence_of_a_national_target_on_salt_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "existence_of_a_national_target_on_salt" VARCHAR
);

CREATE TABLE owid_existence_of_a_national_target_on_salt_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "existence_of_a_national_target_on_salt" VARCHAR,
  "existence_of_a_national_target_on_salt_low" VARCHAR,
  "existence_of_a_national_target_on_salt_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_existence_of_a_national_target_on_tobacco_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "existence_of_a_national_target_on_tobacco" VARCHAR
);

CREATE TABLE owid_existence_of_a_national_target_on_tobacco_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "existence_of_a_national_target_on_tobacco" VARCHAR,
  "existence_of_a_national_target_on_tobacco_low" VARCHAR,
  "existence_of_a_national_target_on_tobacco_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_existence_of_an_health_surveillance_system_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "cch_survey_sub_question" VARCHAR,
  "existence_of_an_health_surveillance_system" VARCHAR
);

CREATE TABLE owid_existence_of_an_health_surveillance_system_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "cch_survey_sub_question" VARCHAR,
  "existence_of_an_health_surveillance_system" VARCHAR,
  "existence_of_an_health_surveillance_system_low" VARCHAR,
  "existence_of_an_health_surveillance_system_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_existence_of_an_ncd_surveillance_and_monitoring_s_1539722b (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "existence_of_an_ncd_surveillance_and_monitoring_system_ebf19c16" VARCHAR  -- Existence Of An Ncd Surveillance And Monitoring System In Place To Enable Reporting Against The Nine Global Ncd Targets
);

CREATE TABLE owid_existence_of_an_ncd_surveillance_and_monitoring_s_f0a64d56 (
  "year" INTEGER,
  "country" VARCHAR,
  "existence_of_an_ncd_surveillance_and_monitoring_system_ebf19c16" VARCHAR  -- Existence Of An Ncd Surveillance And Monitoring System In Place To Enable Reporting Against The Nine Global Ncd Targets,
  "existence_of_an_ncd_surveillance_and_monitoring_system_5873d978" VARCHAR  -- Existence Of An Ncd Surveillance And Monitoring System In Place To Enable Reporting Against The Nine Global Ncd Targets Low,
  "existence_of_an_ncd_surveillance_and_monitoring_system_e0c4aaa9" VARCHAR  -- Existence Of An Ncd Surveillance And Monitoring System In Place To Enable Reporting Against The Nine Global Ncd Targets High,
  "comments" VARCHAR
);

CREATE TABLE owid_existence_of_an_operational_multisectoral_nationa_32bf783b (
  "year" INTEGER,
  "country" VARCHAR,
  "existence_of_an_operational_multisectoral_national_ncd_e2b98257" VARCHAR  -- Existence Of An Operational, Multisectoral National Ncd Policy, Strategy Or Action Plan That Integrates Several Ncds And Their Risk Factors,
  "existence_of_an_operational_multisectoral_national_ncd_e755a85a" VARCHAR  -- Existence Of An Operational, Multisectoral National Ncd Policy, Strategy Or Action Plan That Integrates Several Ncds And Their Risk Factors Low,
  "existence_of_an_operational_multisectoral_national_ncd_55f48f31" VARCHAR  -- Existence Of An Operational, Multisectoral National Ncd Policy, Strategy Or Action Plan That Integrates Several Ncds And Their Risk Factors High,
  "comments" VARCHAR
);

CREATE TABLE owid_existence_of_an_operational_multisectoral_nationa_750210f0 (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "existence_of_an_operational_multisectoral_national_ncd_e2b98257" VARCHAR  -- Existence Of An Operational, Multisectoral National Ncd Policy, Strategy Or Action Plan That Integrates Several Ncds And Their Risk Factors
);

CREATE TABLE owid_existence_of_an_operational_unit_branch_or_dept_i_5078b13f (
  "year" INTEGER,
  "country" VARCHAR,
  "existence_of_an_operational_unit_branch_or_dept_in_min_f59044ff" VARCHAR  -- Existence Of An Operational Unit, Branch, Or Dept, In Ministry Of Health With Responsibility For Ncds,
  "existence_of_an_operational_unit_branch_or_dept_in_min_04d7ab89" VARCHAR  -- Existence Of An Operational Unit, Branch, Or Dept, In Ministry Of Health With Responsibility For Ncds Low,
  "existence_of_an_operational_unit_branch_or_dept_in_min_1e86e1ba" VARCHAR  -- Existence Of An Operational Unit, Branch, Or Dept, In Ministry Of Health With Responsibility For Ncds High,
  "comments" VARCHAR
);

CREATE TABLE owid_existence_of_an_operational_unit_branch_or_dept_i_bdae8332 (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "existence_of_an_operational_unit_branch_or_dept_in_min_f59044ff" VARCHAR  -- Existence Of An Operational Unit, Branch, Or Dept, In Ministry Of Health With Responsibility For Ncds
);

CREATE TABLE owid_existence_of_any_national_radon_activity_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "existence_of_any_national_radon_activity" VARCHAR
);

CREATE TABLE owid_existence_of_any_national_radon_activity_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "existence_of_any_national_radon_activity" VARCHAR,
  "existence_of_any_national_radon_activity_low" VARCHAR,
  "existence_of_any_national_radon_activity_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_existence_of_any_policies_on_marketing_of_foods_t_65e22a1a (
  "year" INTEGER,
  "country" VARCHAR,
  "existence_of_any_policies_on_marketing_of_foods_to_children" VARCHAR,
  "existence_of_any_policies_on_marketing_of_foods_to_children_low" VARCHAR,
  "existence_of_any_policies_on_marketing_of_foods_to_chi_e796c67a" VARCHAR  -- Existence Of Any Policies On Marketing Of Foods To Children High,
  "comments" VARCHAR
);

CREATE TABLE owid_existence_of_any_policies_on_marketing_of_foods_t_b0cc2e4b (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "existence_of_any_policies_on_marketing_of_foods_to_children" VARCHAR
);