Global Health Observatory - World Health Organization
@owid.gho
@owid.gho
CREATE TABLE owid_existence_of_a_diabetes_registry_1 (
"year" INTEGER,
"country" VARCHAR,
"comments" VARCHAR,
"existence_of_a_diabetes_registry" VARCHAR
);
CREATE TABLE owid_existence_of_a_diabetes_registry_2 (
"year" INTEGER,
"country" VARCHAR,
"existence_of_a_diabetes_registry" VARCHAR,
"existence_of_a_diabetes_registry_low" VARCHAR,
"existence_of_a_diabetes_registry_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_existence_of_a_formal_pre_hospital_care_system_1 (
"year" INTEGER,
"country" VARCHAR,
"comments" VARCHAR,
"existence_of_a_formal_pre_hospital_care_system" VARCHAR
);
CREATE TABLE owid_existence_of_a_formal_pre_hospital_care_system_2 (
"year" INTEGER,
"country" VARCHAR,
"existence_of_a_formal_pre_hospital_care_system" VARCHAR,
"existence_of_a_formal_pre_hospital_care_system_low" INTEGER,
"existence_of_a_formal_pre_hospital_care_system_high" INTEGER,
"comments" VARCHAR
);
CREATE TABLE owid_existence_of_a_health_surveillance_system_which_i_5aeb05e3 (
"year" INTEGER,
"country" VARCHAR,
"cch_survey_sub_question" VARCHAR,
"existence_of_a_health_surveillance_system_which_includ_64aef8f7" VARCHAR -- Existence Of A Health Surveillance System Which Includes Meteorological Information,
"existence_of_a_health_surveillance_system_which_includ_ba5b35b0" VARCHAR -- Existence Of A Health Surveillance System Which Includes Meteorological Information Low,
"existence_of_a_health_surveillance_system_which_includ_67709e8d" VARCHAR -- Existence Of A Health Surveillance System Which Includes Meteorological Information High,
"comments" VARCHAR
);
CREATE TABLE owid_existence_of_a_health_surveillance_system_which_i_5c0abb7d (
"year" INTEGER,
"country" VARCHAR,
"cch_survey_sub_question" VARCHAR,
"existence_of_a_health_surveillance_system_which_includ_64aef8f7" VARCHAR -- Existence Of A Health Surveillance System Which Includes Meteorological Information
);
CREATE TABLE owid_existence_of_a_multi_stakeholder_mechanism_on_hea_09a4c1f3 (
"year" INTEGER,
"country" VARCHAR,
"existence_of_a_multi_stakeholder_mechanism_on_health_a_90a4f15c" VARCHAR -- Existence Of A Multi Stakeholder Mechanism On Health And Climate Change,
"existence_of_a_multi_stakeholder_mechanism_on_health_a_78ba0985" VARCHAR -- Existence Of A Multi Stakeholder Mechanism On Health And Climate Change Low,
"existence_of_a_multi_stakeholder_mechanism_on_health_a_5bff5501" VARCHAR -- Existence Of A Multi Stakeholder Mechanism On Health And Climate Change High,
"comments" VARCHAR
);
CREATE TABLE owid_existence_of_a_multi_stakeholder_mechanism_on_hea_77e6f2b8 (
"year" INTEGER,
"country" VARCHAR,
"existence_of_a_multi_stakeholder_mechanism_on_health_a_90a4f15c" VARCHAR -- Existence Of A Multi Stakeholder Mechanism On Health And Climate Change
);
CREATE TABLE owid_existence_of_a_national_child_restraint_law_1 (
"year" INTEGER,
"country" VARCHAR,
"comments" VARCHAR,
"existence_of_a_national_child_restraint_law" VARCHAR
);
CREATE TABLE owid_existence_of_a_national_child_restraint_law_2 (
"year" INTEGER,
"country" VARCHAR,
"existence_of_a_national_child_restraint_law" VARCHAR,
"existence_of_a_national_child_restraint_law_low" VARCHAR,
"existence_of_a_national_child_restraint_law_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_existence_of_a_national_drink_driving_law_1 (
"year" INTEGER,
"country" VARCHAR,
"comments" VARCHAR,
"existence_of_a_national_drink_driving_law" VARCHAR
);
CREATE TABLE owid_existence_of_a_national_drink_driving_law_2 (
"year" INTEGER,
"country" VARCHAR,
"existence_of_a_national_drink_driving_law" VARCHAR,
"existence_of_a_national_drink_driving_law_low" VARCHAR,
"existence_of_a_national_drink_driving_law_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_existence_of_a_national_multisectoral_commission__b8c6f643 (
"year" INTEGER,
"country" VARCHAR,
"existence_of_a_national_multisectoral_commission_agenc_7a2452cc" VARCHAR -- Existence Of A National Multisectoral Commission, Agency Or Mechanism For Ncds,
"existence_of_a_national_multisectoral_commission_agenc_9bd6d00a" VARCHAR -- Existence Of A National Multisectoral Commission, Agency Or Mechanism For Ncds Low,
"existence_of_a_national_multisectoral_commission_agenc_5b8ca837" VARCHAR -- Existence Of A National Multisectoral Commission, Agency Or Mechanism For Ncds High,
"comments" VARCHAR
);
CREATE TABLE owid_existence_of_a_national_multisectoral_commission__bd1e97b2 (
"year" INTEGER,
"country" VARCHAR,
"comments" VARCHAR,
"existence_of_a_national_multisectoral_commission_agenc_7a2452cc" VARCHAR -- Existence Of A National Multisectoral Commission, Agency Or Mechanism For Ncds
);
CREATE TABLE owid_existence_of_a_national_road_safety_strategy_1 (
"year" INTEGER,
"country" VARCHAR,
"existence_of_a_national_road_safety_strategy" VARCHAR
);
CREATE TABLE owid_existence_of_a_national_road_safety_strategy_2 (
"year" INTEGER,
"country" VARCHAR,
"existence_of_a_national_road_safety_strategy" VARCHAR,
"existence_of_a_national_road_safety_strategy_low" VARCHAR,
"existence_of_a_national_road_safety_strategy_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_existence_of_a_national_seat_belt_law_1 (
"year" INTEGER,
"country" VARCHAR,
"comments" VARCHAR,
"existence_of_a_national_seat_belt_law" VARCHAR
);
CREATE TABLE owid_existence_of_a_national_seat_belt_law_2 (
"year" INTEGER,
"country" VARCHAR,
"existence_of_a_national_seat_belt_law" VARCHAR,
"existence_of_a_national_seat_belt_law_low" VARCHAR,
"existence_of_a_national_seat_belt_law_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_existence_of_a_national_target_on_alcohol_1 (
"year" INTEGER,
"country" VARCHAR,
"existence_of_a_national_target_on_alcohol" VARCHAR
);
CREATE TABLE owid_existence_of_a_national_target_on_alcohol_2 (
"year" INTEGER,
"country" VARCHAR,
"existence_of_a_national_target_on_alcohol" VARCHAR,
"existence_of_a_national_target_on_alcohol_low" VARCHAR,
"existence_of_a_national_target_on_alcohol_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_existence_of_a_national_target_on_blood_pressure__609162c3 (
"year" INTEGER,
"country" VARCHAR,
"existence_of_a_national_target_on_blood_pressure_hypertension" VARCHAR -- Existence Of A National Target On Blood Pressure, Hypertension
);
CREATE TABLE owid_existence_of_a_national_target_on_blood_pressure__a8175b17 (
"year" INTEGER,
"country" VARCHAR,
"existence_of_a_national_target_on_blood_pressure_hypertension" VARCHAR -- Existence Of A National Target On Blood Pressure, Hypertension,
"existence_of_a_national_target_on_blood_pressure_hyper_d83a0ca8" VARCHAR -- Existence Of A National Target On Blood Pressure, Hypertension Low,
"existence_of_a_national_target_on_blood_pressure_hyper_ab6cf825" VARCHAR -- Existence Of A National Target On Blood Pressure, Hypertension High,
"comments" VARCHAR
);
CREATE TABLE owid_existence_of_a_national_target_on_diabetes_1 (
"year" INTEGER,
"country" VARCHAR,
"existence_of_a_national_target_on_diabetes" VARCHAR
);
CREATE TABLE owid_existence_of_a_national_target_on_diabetes_2 (
"year" INTEGER,
"country" VARCHAR,
"existence_of_a_national_target_on_diabetes" VARCHAR,
"existence_of_a_national_target_on_diabetes_low" VARCHAR,
"existence_of_a_national_target_on_diabetes_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_existence_of_a_national_target_on_drug_therapy_an_13696a8d (
"year" INTEGER,
"country" VARCHAR,
"existence_of_a_national_target_on_drug_therapy_and_counselling" VARCHAR,
"existence_of_a_national_target_on_drug_therapy_and_cou_41689af2" VARCHAR -- Existence Of A National Target On Drug Therapy And Counselling Low,
"existence_of_a_national_target_on_drug_therapy_and_cou_59c0ed80" VARCHAR -- Existence Of A National Target On Drug Therapy And Counselling High,
"comments" VARCHAR
);
Anyone who has the link will be able to view this.