Global Health Observatory - World Health Organization
@owid.gho
@owid.gho
CREATE TABLE owid_existence_of_national_regulation_1 (
"year" INTEGER,
"country" VARCHAR,
"comments" VARCHAR,
"existence_of_national_regulation" VARCHAR
);
CREATE TABLE owid_existence_of_national_regulation_2 (
"year" INTEGER,
"country" VARCHAR,
"existence_of_national_regulation" VARCHAR,
"existence_of_national_regulation_low" VARCHAR,
"existence_of_national_regulation_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_existence_of_national_screening_program_for_breas_5033aba8 (
"year" INTEGER,
"country" VARCHAR,
"existence_of_national_screening_program_for_breast_cancer" VARCHAR,
"existence_of_national_screening_program_for_breast_cancer_low" VARCHAR,
"existence_of_national_screening_program_for_breast_cancer_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_existence_of_national_screening_program_for_breas_7e605c2e (
"year" INTEGER,
"country" VARCHAR,
"comments" VARCHAR,
"existence_of_national_screening_program_for_breast_cancer" VARCHAR
);
CREATE TABLE owid_existence_of_national_screening_program_for_cervi_c8369544 (
"year" INTEGER,
"country" VARCHAR,
"existence_of_national_screening_program_for_cervical_cancer" VARCHAR,
"existence_of_national_screening_program_for_cervical_cancer_low" VARCHAR,
"existence_of_national_screening_program_for_cervical_c_33f22039" VARCHAR -- Existence Of National Screening Program For Cervical Cancer High,
"comments" VARCHAR
);
CREATE TABLE owid_existence_of_national_screening_program_for_cervi_e1b41e4a (
"year" INTEGER,
"country" VARCHAR,
"comments" VARCHAR,
"existence_of_national_screening_program_for_cervical_cancer" VARCHAR
);
CREATE TABLE owid_existence_of_national_speed_limits_1 (
"year" INTEGER,
"country" VARCHAR,
"comments" VARCHAR,
"existence_of_national_speed_limits" VARCHAR
);
CREATE TABLE owid_existence_of_national_speed_limits_2 (
"year" INTEGER,
"country" VARCHAR,
"existence_of_national_speed_limits" VARCHAR,
"existence_of_national_speed_limits_low" VARCHAR,
"existence_of_national_speed_limits_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_existence_of_official_protocols_for_radon_measurements_1 (
"year" INTEGER,
"country" VARCHAR,
"existence_of_official_protocols_for_radon_measurements" VARCHAR
);
CREATE TABLE owid_existence_of_official_protocols_for_radon_measurements_2 (
"year" INTEGER,
"country" VARCHAR,
"existence_of_official_protocols_for_radon_measurements" VARCHAR,
"existence_of_official_protocols_for_radon_measurements_low" VARCHAR,
"existence_of_official_protocols_for_radon_measurements_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_existence_of_operational_policy_strategy_action_p_0625c30e (
"year" INTEGER,
"country" VARCHAR,
"existence_of_operational_policy_strategy_action_plan_f_571fd4b6" VARCHAR -- Existence Of Operational Policy Strategy Action Plan For Oral Health,
"existence_of_operational_policy_strategy_action_plan_f_68582704" VARCHAR -- Existence Of Operational Policy Strategy Action Plan For Oral Health Low,
"existence_of_operational_policy_strategy_action_plan_f_79ff831d" VARCHAR -- Existence Of Operational Policy Strategy Action Plan For Oral Health High,
"comments" VARCHAR
);
CREATE TABLE owid_existence_of_operational_policy_strategy_action_p_0bf6d488 (
"year" INTEGER,
"country" VARCHAR,
"existence_of_operational_policy_strategy_action_plan_f_e8369058" VARCHAR -- Existence Of Operational Policy Strategy Action Plan For Hearing Health,
"existence_of_operational_policy_strategy_action_plan_f_f5382298" VARCHAR -- Existence Of Operational Policy Strategy Action Plan For Hearing Health Low,
"existence_of_operational_policy_strategy_action_plan_f_ac97acbc" VARCHAR -- Existence Of Operational Policy Strategy Action Plan For Hearing Health High,
"comments" VARCHAR
);
CREATE TABLE owid_existence_of_operational_policy_strategy_action_p_10c3f9be (
"year" INTEGER,
"country" VARCHAR,
"existence_of_operational_policy_strategy_action_plan_t_c4b1ff04" VARCHAR -- Existence Of Operational Policy Strategy Action Plan To Reduce Physical Inactivity,
"existence_of_operational_policy_strategy_action_plan_t_4d732fa1" VARCHAR -- Existence Of Operational Policy Strategy Action Plan To Reduce Physical Inactivity Low,
"existence_of_operational_policy_strategy_action_plan_t_ec523eae" VARCHAR -- Existence Of Operational Policy Strategy Action Plan To Reduce Physical Inactivity High,
"comments" VARCHAR
);
CREATE TABLE owid_existence_of_operational_policy_strategy_action_p_13a0cb76 (
"year" INTEGER,
"country" VARCHAR,
"comments" VARCHAR,
"existence_of_operational_policy_strategy_action_plan_for_cancer" VARCHAR
);
CREATE TABLE owid_existence_of_operational_policy_strategy_action_p_17b2ef53 (
"year" INTEGER,
"country" VARCHAR,
"existence_of_operational_policy_strategy_action_plan_f_a85b382b" VARCHAR -- Existence Of Operational Policy Strategy Action Plan For Eye Health,
"existence_of_operational_policy_strategy_action_plan_f_9e3fb5d9" VARCHAR -- Existence Of Operational Policy Strategy Action Plan For Eye Health Low,
"existence_of_operational_policy_strategy_action_plan_f_ecf91e2f" VARCHAR -- Existence Of Operational Policy Strategy Action Plan For Eye Health High,
"comments" VARCHAR
);
CREATE TABLE owid_existence_of_operational_policy_strategy_action_p_1983f162 (
"year" INTEGER,
"country" VARCHAR,
"existence_of_operational_policy_strategy_action_plan_f_571fd4b6" VARCHAR -- Existence Of Operational Policy Strategy Action Plan For Oral Health
);
CREATE TABLE owid_existence_of_operational_policy_strategy_action_p_2df450f0 (
"year" INTEGER,
"country" VARCHAR,
"existence_of_operational_policy_strategy_action_plan_for_cancer" VARCHAR,
"existence_of_operational_policy_strategy_action_plan_f_8b34a46a" VARCHAR -- Existence Of Operational Policy Strategy Action Plan For Cancer Low,
"existence_of_operational_policy_strategy_action_plan_f_fd9fbdf1" VARCHAR -- Existence Of Operational Policy Strategy Action Plan For Cancer High,
"comments" VARCHAR
);
CREATE TABLE owid_existence_of_operational_policy_strategy_action_p_2fcd30b6 (
"year" INTEGER,
"country" VARCHAR,
"existence_of_operational_policy_strategy_action_plan_t_928f8742" VARCHAR -- Existence Of Operational Policy Strategy Action Plan To Reduce Overweight Obesity
);
CREATE TABLE owid_existence_of_operational_policy_strategy_action_p_4a958cdf (
"year" INTEGER,
"country" VARCHAR,
"existence_of_operational_policy_strategy_action_plan_f_a85b382b" VARCHAR -- Existence Of Operational Policy Strategy Action Plan For Eye Health
);
CREATE TABLE owid_existence_of_operational_policy_strategy_action_p_5d3cf46e (
"year" INTEGER,
"country" VARCHAR,
"comments" VARCHAR,
"existence_of_operational_policy_strategy_action_plan_f_c703d2bc" VARCHAR -- Existence Of Operational Policy Strategy Action Plan For Diabetes
);
CREATE TABLE owid_existence_of_operational_policy_strategy_action_p_6547f528 (
"year" INTEGER,
"country" VARCHAR,
"existence_of_operational_policy_strategy_action_plan_t_36b31759" VARCHAR -- Existence Of Operational Policy Strategy Action Plan To Decrease Tobacco Use,
"existence_of_operational_policy_strategy_action_plan_t_2a07212b" VARCHAR -- Existence Of Operational Policy Strategy Action Plan To Decrease Tobacco Use Low,
"existence_of_operational_policy_strategy_action_plan_t_db482339" VARCHAR -- Existence Of Operational Policy Strategy Action Plan To Decrease Tobacco Use High,
"comments" VARCHAR
);
CREATE TABLE owid_existence_of_operational_policy_strategy_action_p_73fcc488 (
"year" INTEGER,
"country" VARCHAR,
"comments" VARCHAR,
"existence_of_operational_policy_strategy_action_plan_f_a695df4a" VARCHAR -- Existence Of Operational Policy Strategy Action Plan For Cardiovascular Diseases
);
CREATE TABLE owid_existence_of_operational_policy_strategy_action_p_817f9ea5 (
"year" INTEGER,
"country" VARCHAR,
"comments" VARCHAR,
"existence_of_operational_policy_strategy_action_plan_t_36b31759" VARCHAR -- Existence Of Operational Policy Strategy Action Plan To Decrease Tobacco Use
);
CREATE TABLE owid_existence_of_operational_policy_strategy_action_p_8ec32bee (
"year" INTEGER,
"country" VARCHAR,
"comments" VARCHAR,
"existence_of_operational_policy_strategy_action_plan_t_054633ca" VARCHAR -- Existence Of Operational Policy Strategy Action Plan To Reduce Unhealthy Diet Related To Ncds
);
CREATE TABLE owid_existence_of_operational_policy_strategy_action_p_ae8874be (
"year" INTEGER,
"country" VARCHAR,
"existence_of_operational_policy_strategy_action_plan_f_d8d5e319" VARCHAR -- Existence Of Operational Policy Strategy Action Plan For Chronic Respiratory Diseases,
"existence_of_operational_policy_strategy_action_plan_f_9af20a94" VARCHAR -- Existence Of Operational Policy Strategy Action Plan For Chronic Respiratory Diseases Low,
"existence_of_operational_policy_strategy_action_plan_f_24a95b80" VARCHAR -- Existence Of Operational Policy Strategy Action Plan For Chronic Respiratory Diseases High,
"comments" VARCHAR
);
Anyone who has the link will be able to view this.