Global Health Observatory - World Health Organization
@owid.gho
@owid.gho
CREATE TABLE owid_existence_of_operational_policy_strategy_action_p_b0dfc749 (
"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,
"existence_of_operational_policy_strategy_action_plan_t_30e70b04" VARCHAR -- Existence Of Operational Policy Strategy Action Plan To Reduce Overweight Obesity Low,
"existence_of_operational_policy_strategy_action_plan_t_fdf90e23" VARCHAR -- Existence Of Operational Policy Strategy Action Plan To Reduce Overweight Obesity High,
"comments" VARCHAR
);
CREATE TABLE owid_existence_of_operational_policy_strategy_action_p_be97173c (
"year" INTEGER,
"country" VARCHAR,
"comments" VARCHAR,
"existence_of_operational_policy_strategy_action_plan_t_e5a4a02a" VARCHAR -- Existence Of Operational Policy Strategy Action Plan To Reduce The Harmful Use Of Alcohol
);
CREATE TABLE owid_existence_of_operational_policy_strategy_action_p_c91a37e4 (
"year" INTEGER,
"country" VARCHAR,
"existence_of_operational_policy_strategy_action_plan_f_e8369058" VARCHAR -- Existence Of Operational Policy Strategy Action Plan For Hearing Health
);
CREATE TABLE owid_existence_of_operational_policy_strategy_action_p_cc8f7607 (
"year" INTEGER,
"country" 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,
"existence_of_operational_policy_strategy_action_plan_t_963d64ad" VARCHAR -- Existence Of Operational Policy Strategy Action Plan To Reduce Unhealthy Diet Related To Ncds Low,
"existence_of_operational_policy_strategy_action_plan_t_2fd265ce" VARCHAR -- Existence Of Operational Policy Strategy Action Plan To Reduce Unhealthy Diet Related To Ncds High,
"comments" VARCHAR
);
CREATE TABLE owid_existence_of_operational_policy_strategy_action_p_d3d7c9ee (
"year" INTEGER,
"country" VARCHAR,
"comments" VARCHAR,
"existence_of_operational_policy_strategy_action_plan_t_c4b1ff04" VARCHAR -- Existence Of Operational Policy Strategy Action Plan To Reduce Physical Inactivity
);
CREATE TABLE owid_existence_of_operational_policy_strategy_action_p_eb39e540 (
"year" INTEGER,
"country" VARCHAR,
"existence_of_operational_policy_strategy_action_plan_f_a695df4a" VARCHAR -- Existence Of Operational Policy Strategy Action Plan For Cardiovascular Diseases,
"existence_of_operational_policy_strategy_action_plan_f_557e6829" VARCHAR -- Existence Of Operational Policy Strategy Action Plan For Cardiovascular Diseases Low,
"existence_of_operational_policy_strategy_action_plan_f_381ab438" VARCHAR -- Existence Of Operational Policy Strategy Action Plan For Cardiovascular Diseases High,
"comments" VARCHAR
);
CREATE TABLE owid_existence_of_operational_policy_strategy_action_p_f09e1cc9 (
"year" INTEGER,
"country" VARCHAR,
"existence_of_operational_policy_strategy_action_plan_f_c703d2bc" VARCHAR -- Existence Of Operational Policy Strategy Action Plan For Diabetes,
"existence_of_operational_policy_strategy_action_plan_f_745f30db" VARCHAR -- Existence Of Operational Policy Strategy Action Plan For Diabetes Low,
"existence_of_operational_policy_strategy_action_plan_f_19a44116" VARCHAR -- Existence Of Operational Policy Strategy Action Plan For Diabetes High,
"comments" VARCHAR
);
CREATE TABLE owid_existence_of_operational_policy_strategy_action_p_f5466911 (
"year" INTEGER,
"country" VARCHAR,
"comments" VARCHAR,
"existence_of_operational_policy_strategy_action_plan_f_d8d5e319" VARCHAR -- Existence Of Operational Policy Strategy Action Plan For Chronic Respiratory Diseases
);
CREATE TABLE owid_existence_of_operational_policy_strategy_action_p_ffe51c17 (
"year" INTEGER,
"country" VARCHAR,
"existence_of_operational_policy_strategy_action_plan_t_e5a4a02a" VARCHAR -- Existence Of Operational Policy Strategy Action Plan To Reduce The Harmful Use Of Alcohol,
"existence_of_operational_policy_strategy_action_plan_t_24e318e6" VARCHAR -- Existence Of Operational Policy Strategy Action Plan To Reduce The Harmful Use Of Alcohol Low,
"existence_of_operational_policy_strategy_action_plan_t_2304ad7e" VARCHAR -- Existence Of Operational Policy Strategy Action Plan To Reduce The Harmful Use Of Alcohol High,
"comments" VARCHAR
);
CREATE TABLE owid_existence_of_other_laws_that_apply_to_the_rights__6cec08bb (
"year" INTEGER,
"country" VARCHAR,
"existence_of_other_laws_that_apply_to_the_rights_of_pe_1f9784d3" VARCHAR -- Existence Of Other Laws That Apply To The Rights Of People With Dementia
);
CREATE TABLE owid_existence_of_other_laws_that_apply_to_the_rights__753a479c (
"year" INTEGER,
"country" VARCHAR,
"existence_of_other_laws_that_apply_to_the_rights_of_pe_1f9784d3" VARCHAR -- Existence Of Other Laws That Apply To The Rights Of People With Dementia,
"existence_of_other_laws_that_apply_to_the_rights_of_pe_158fac8d" VARCHAR -- Existence Of Other Laws That Apply To The Rights Of People With Dementia Low,
"existence_of_other_laws_that_apply_to_the_rights_of_pe_815c0bdf" VARCHAR -- Existence Of Other Laws That Apply To The Rights Of People With Dementia High,
"comments" VARCHAR
);
CREATE TABLE owid_existence_of_policy_promoting_physical_activity_a_0afbdaf1 (
"year" INTEGER,
"country" VARCHAR,
"existence_of_policy_promoting_physical_activity_active_ageing" VARCHAR -- Existence Of Policy Promoting Physical Activity, Active Ageing,
"existence_of_policy_promoting_physical_activity_active_3380788d" VARCHAR -- Existence Of Policy Promoting Physical Activity, Active Ageing Low,
"existence_of_policy_promoting_physical_activity_active_cd787125" VARCHAR -- Existence Of Policy Promoting Physical Activity, Active Ageing High,
"comments" VARCHAR
);
CREATE TABLE owid_existence_of_policy_promoting_physical_activity_a_67aec8c0 (
"year" INTEGER,
"country" VARCHAR,
"existence_of_policy_promoting_physical_activity_active_ageing" VARCHAR -- Existence Of Policy Promoting Physical Activity, Active Ageing
);
CREATE TABLE owid_existence_of_policy_promoting_physical_activity_c_4e5b2672 (
"year" INTEGER,
"country" VARCHAR,
"existence_of_policy_promoting_physical_activity_commun_8d63da2f" VARCHAR -- Existence Of Policy Promoting Physical Activity, Community Based And Sports Initiatives,
"existence_of_policy_promoting_physical_activity_commun_d3e0ebb0" VARCHAR -- Existence Of Policy Promoting Physical Activity, Community Based And Sports Initiatives Low,
"existence_of_policy_promoting_physical_activity_commun_e1a7e3d3" VARCHAR -- Existence Of Policy Promoting Physical Activity, Community Based And Sports Initiatives High,
"comments" VARCHAR
);
CREATE TABLE owid_existence_of_policy_promoting_physical_activity_c_8dd2675d (
"year" INTEGER,
"country" VARCHAR,
"existence_of_policy_promoting_physical_activity_childc_47044457" VARCHAR -- Existence Of Policy Promoting Physical Activity, Childcare Settings,
"existence_of_policy_promoting_physical_activity_childc_25e5f0c8" VARCHAR -- Existence Of Policy Promoting Physical Activity, Childcare Settings Low,
"existence_of_policy_promoting_physical_activity_childc_45223812" VARCHAR -- Existence Of Policy Promoting Physical Activity, Childcare Settings High,
"comments" VARCHAR
);
CREATE TABLE owid_existence_of_policy_promoting_physical_activity_c_a8065337 (
"year" INTEGER,
"country" VARCHAR,
"existence_of_policy_promoting_physical_activity_commun_8d63da2f" VARCHAR -- Existence Of Policy Promoting Physical Activity, Community Based And Sports Initiatives
);
CREATE TABLE owid_existence_of_policy_promoting_physical_activity_c_eeaa9667 (
"year" INTEGER,
"country" VARCHAR,
"existence_of_policy_promoting_physical_activity_childc_47044457" VARCHAR -- Existence Of Policy Promoting Physical Activity, Childcare Settings
);
CREATE TABLE owid_existence_of_policy_promoting_physical_activity_p_78ce338e (
"year" INTEGER,
"country" VARCHAR,
"existence_of_policy_promoting_physical_activity_public_a8562f0b" VARCHAR -- Existence Of Policy Promoting Physical Activity, Public Open Spaces
);
CREATE TABLE owid_existence_of_policy_promoting_physical_activity_p_e5e34e75 (
"year" INTEGER,
"country" VARCHAR,
"existence_of_policy_promoting_physical_activity_public_a8562f0b" VARCHAR -- Existence Of Policy Promoting Physical Activity, Public Open Spaces,
"existence_of_policy_promoting_physical_activity_public_588f86c3" VARCHAR -- Existence Of Policy Promoting Physical Activity, Public Open Spaces Low,
"existence_of_policy_promoting_physical_activity_public_e48f6cd4" VARCHAR -- Existence Of Policy Promoting Physical Activity, Public Open Spaces High,
"comments" VARCHAR
);
CREATE TABLE owid_existence_of_policy_promoting_physical_activity_w_1141da0f (
"year" INTEGER,
"country" VARCHAR,
"existence_of_policy_promoting_physical_activity_walkin_00d3736d" VARCHAR -- Existence Of Policy Promoting Physical Activity, Walking And Cycling
);
CREATE TABLE owid_existence_of_policy_promoting_physical_activity_w_161d1ca8 (
"year" INTEGER,
"country" VARCHAR,
"existence_of_policy_promoting_physical_activity_walkin_00d3736d" VARCHAR -- Existence Of Policy Promoting Physical Activity, Walking And Cycling,
"existence_of_policy_promoting_physical_activity_walkin_d1a2dc43" VARCHAR -- Existence Of Policy Promoting Physical Activity, Walking And Cycling Low,
"existence_of_policy_promoting_physical_activity_walkin_af495edc" VARCHAR -- Existence Of Policy Promoting Physical Activity, Walking And Cycling High,
"comments" VARCHAR
);
CREATE TABLE owid_existence_of_policy_promoting_physical_activity_w_b3d1a544 (
"year" INTEGER,
"country" VARCHAR,
"existence_of_policy_promoting_physical_activity_workpl_5e32b105" VARCHAR -- Existence Of Policy Promoting Physical Activity, Workplace Initiatives,
"existence_of_policy_promoting_physical_activity_workpl_c3fd4ec8" VARCHAR -- Existence Of Policy Promoting Physical Activity, Workplace Initiatives Low,
"existence_of_policy_promoting_physical_activity_workpl_10a23d9c" VARCHAR -- Existence Of Policy Promoting Physical Activity, Workplace Initiatives High,
"comments" VARCHAR
);
CREATE TABLE owid_existence_of_policy_promoting_physical_activity_w_f895b74b (
"year" INTEGER,
"country" VARCHAR,
"existence_of_policy_promoting_physical_activity_workpl_5e32b105" VARCHAR -- Existence Of Policy Promoting Physical Activity, Workplace Initiatives
);
CREATE TABLE owid_existence_of_population_based_cancer_registry_1 (
"year" INTEGER,
"country" VARCHAR,
"existence_of_population_based_cancer_registry" VARCHAR
);
CREATE TABLE owid_existence_of_population_based_cancer_registry_2 (
"year" INTEGER,
"country" VARCHAR,
"existence_of_population_based_cancer_registry" VARCHAR,
"existence_of_population_based_cancer_registry_low" VARCHAR,
"existence_of_population_based_cancer_registry_high" VARCHAR,
"comments" VARCHAR
);
Anyone who has the link will be able to view this.