Global Health Observatory - World Health Organization
@owid.gho
@owid.gho
CREATE TABLE owid_existence_of_any_policies_to_reduce_population_sa_4680ac64 (
"year" INTEGER,
"country" VARCHAR,
"existence_of_any_policies_to_reduce_population_salt_consumption" VARCHAR,
"existence_of_any_policies_to_reduce_population_salt_co_7482cccd" VARCHAR -- Existence Of Any Policies To Reduce Population Salt Consumption Low,
"existence_of_any_policies_to_reduce_population_salt_co_73f514d1" VARCHAR -- Existence Of Any Policies To Reduce Population Salt Consumption High,
"comments" VARCHAR
);
CREATE TABLE owid_existence_of_any_policies_to_reduce_population_sa_b16ad1fa (
"year" INTEGER,
"country" VARCHAR,
"comments" VARCHAR,
"existence_of_any_policies_to_reduce_population_salt_consumption" VARCHAR
);
CREATE TABLE owid_existence_of_any_subnational_radon_activity_1 (
"year" INTEGER,
"country" VARCHAR,
"existence_of_any_subnational_radon_activity" VARCHAR
);
CREATE TABLE owid_existence_of_any_subnational_radon_activity_2 (
"year" INTEGER,
"country" VARCHAR,
"existence_of_any_subnational_radon_activity" VARCHAR,
"existence_of_any_subnational_radon_activity_low" VARCHAR,
"existence_of_any_subnational_radon_activity_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_existence_of_approved_government_dementia_standar_24424067 (
"year" INTEGER,
"country" VARCHAR,
"existence_of_approved_government_dementia_standards_gu_ca4ffe64" VARCHAR -- Existence Of Approved Government Dementia Standards, Guidelines, Protocols,
"existence_of_approved_government_dementia_standards_gu_c9b68f8f" VARCHAR -- Existence Of Approved Government Dementia Standards, Guidelines, Protocols Low,
"existence_of_approved_government_dementia_standards_gu_f677ac1c" VARCHAR -- Existence Of Approved Government Dementia Standards, Guidelines, Protocols High,
"comments" VARCHAR
);
CREATE TABLE owid_existence_of_approved_government_dementia_standar_d06ac356 (
"year" INTEGER,
"country" VARCHAR,
"existence_of_approved_government_dementia_standards_gu_ca4ffe64" VARCHAR -- Existence Of Approved Government Dementia Standards, Guidelines, Protocols
);
CREATE TABLE owid_existence_of_a_register_of_patients_who_had_rheum_b19cb312 (
"year" INTEGER,
"country" VARCHAR,
"existence_of_a_register_of_patients_who_had_rheumatic__ce9095df" VARCHAR -- Existence Of A Register Of Patients Who Had Rheumatic Fever And Rheumatic Heart Disease,
"existence_of_a_register_of_patients_who_had_rheumatic__c1f67737" VARCHAR -- Existence Of A Register Of Patients Who Had Rheumatic Fever And Rheumatic Heart Disease Low,
"existence_of_a_register_of_patients_who_had_rheumatic__dc45e250" VARCHAR -- Existence Of A Register Of Patients Who Had Rheumatic Fever And Rheumatic Heart Disease High,
"comments" VARCHAR
);
CREATE TABLE owid_existence_of_a_register_of_patients_who_had_rheum_c1b5f35e (
"year" INTEGER,
"country" VARCHAR,
"existence_of_a_register_of_patients_who_had_rheumatic__ce9095df" VARCHAR -- Existence Of A Register Of Patients Who Had Rheumatic Fever And Rheumatic Heart Disease
);
CREATE TABLE owid_existence_of_a_road_safety_lead_agency_1 (
"year" INTEGER,
"country" VARCHAR,
"existence_of_a_road_safety_lead_agency" VARCHAR
);
CREATE TABLE owid_existence_of_a_road_safety_lead_agency_2 (
"year" INTEGER,
"country" VARCHAR,
"existence_of_a_road_safety_lead_agency" VARCHAR,
"existence_of_a_road_safety_lead_agency_low" VARCHAR,
"existence_of_a_road_safety_lead_agency_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_existence_of_a_set_of_national_ncd_indicators_and_02cf8ee0 (
"year" INTEGER,
"country" VARCHAR,
"existence_of_a_set_of_national_ncd_indicators_and_has__5f975ad6" VARCHAR -- Existence Of A Set Of National Ncd Indicators And Has Set Time Bound National Targets For These Indicators,
"existence_of_a_set_of_national_ncd_indicators_and_has__d858ef06" VARCHAR -- Existence Of A Set Of National Ncd Indicators And Has Set Time Bound National Targets For These Indicators Low,
"existence_of_a_set_of_national_ncd_indicators_and_has__b70c166d" VARCHAR -- Existence Of A Set Of National Ncd Indicators And Has Set Time Bound National Targets For These Indicators High,
"comments" VARCHAR
);
CREATE TABLE owid_existence_of_a_set_of_national_ncd_indicators_and_2115da85 (
"year" INTEGER,
"country" VARCHAR,
"comments" VARCHAR,
"existence_of_a_set_of_national_ncd_indicators_and_has__5f975ad6" VARCHAR -- Existence Of A Set Of National Ncd Indicators And Has Set Time Bound National Targets For These Indicators
);
CREATE TABLE owid_existence_of_a_set_of_time_bound_national_targets_38734858 (
"year" INTEGER,
"country" VARCHAR,
"existence_of_a_set_of_time_bound_national_targets_base_99250962" VARCHAR -- Existence Of A Set Of Time Bound National Targets Based On Who Guidance,
"existence_of_a_set_of_time_bound_national_targets_base_a8f32e9f" VARCHAR -- Existence Of A Set Of Time Bound National Targets Based On Who Guidance Low,
"existence_of_a_set_of_time_bound_national_targets_base_9de755dc" VARCHAR -- Existence Of A Set Of Time Bound National Targets Based On Who Guidance High,
"comments" VARCHAR
);
CREATE TABLE owid_existence_of_a_set_of_time_bound_national_targets_970530ee (
"year" INTEGER,
"country" VARCHAR,
"existence_of_a_set_of_time_bound_national_targets_base_99250962" VARCHAR -- Existence Of A Set Of Time Bound National Targets Based On Who Guidance
);
CREATE TABLE owid_existence_of_at_least_one_functioning_dementia_aw_837b5295 (
"year" INTEGER,
"country" VARCHAR,
"existence_of_at_least_one_functioning_dementia_awarene_ee7f240f" VARCHAR -- Existence Of At Least One Functioning Dementia Awareness Campaign,
"existence_of_at_least_one_functioning_dementia_awarene_807ca5e8" VARCHAR -- Existence Of At Least One Functioning Dementia Awareness Campaign Low,
"existence_of_at_least_one_functioning_dementia_awarene_74f7293d" VARCHAR -- Existence Of At Least One Functioning Dementia Awareness Campaign High,
"comments" VARCHAR
);
CREATE TABLE owid_existence_of_at_least_one_functioning_dementia_aw_eb7fcf71 (
"year" INTEGER,
"country" VARCHAR,
"existence_of_at_least_one_functioning_dementia_awarene_ee7f240f" VARCHAR -- Existence Of At Least One Functioning Dementia Awareness Campaign
);
CREATE TABLE owid_existence_of_at_least_one_functioning_risk_reduct_0481b5ef (
"year" INTEGER,
"country" VARCHAR,
"existence_of_at_least_one_functioning_risk_reduction_campaign" VARCHAR
);
CREATE TABLE owid_existence_of_at_least_one_functioning_risk_reduct_6f4e8a54 (
"year" INTEGER,
"country" VARCHAR,
"existence_of_at_least_one_functioning_risk_reduction_campaign" VARCHAR,
"existence_of_at_least_one_functioning_risk_reduction_c_6bf2fbb2" VARCHAR -- Existence Of At Least One Functioning Risk Reduction Campaign Low,
"existence_of_at_least_one_functioning_risk_reduction_c_42e9936b" VARCHAR -- Existence Of At Least One Functioning Risk Reduction Campaign High,
"comments" VARCHAR
);
CREATE TABLE owid_existence_of_a_universal_access_telephone_number__cdfe2548 (
"year" INTEGER,
"country" VARCHAR,
"existence_of_a_universal_access_telephone_number_for_p_d5c92316" VARCHAR -- Existence Of A Universal Access Telephone Number For Pre Hospital Care
);
CREATE TABLE owid_existence_of_a_universal_access_telephone_number__fd56f25c (
"year" INTEGER,
"country" VARCHAR,
"existence_of_a_universal_access_telephone_number_for_p_d5c92316" VARCHAR -- Existence Of A Universal Access Telephone Number For Pre Hospital Care,
"existence_of_a_universal_access_telephone_number_for_p_8943ec14" VARCHAR -- Existence Of A Universal Access Telephone Number For Pre Hospital Care Low,
"existence_of_a_universal_access_telephone_number_for_p_180195d4" VARCHAR -- Existence Of A Universal Access Telephone Number For Pre Hospital Care High,
"comments" VARCHAR
);
CREATE TABLE owid_existence_of_community_based_health_or_social_car_33e84758 (
"year" INTEGER,
"country" VARCHAR,
"existence_of_community_based_health_or_social_care_ser_29641ddb" VARCHAR -- Existence Of Community Based Health Or Social Care Services For Dementia,
"existence_of_community_based_health_or_social_care_ser_2a46564c" VARCHAR -- Existence Of Community Based Health Or Social Care Services For Dementia Low,
"existence_of_community_based_health_or_social_care_ser_bcf1e42c" VARCHAR -- Existence Of Community Based Health Or Social Care Services For Dementia High,
"comments" VARCHAR
);
CREATE TABLE owid_existence_of_community_based_health_or_social_car_47f93fe7 (
"year" INTEGER,
"country" VARCHAR,
"existence_of_community_based_health_or_social_care_ser_29641ddb" VARCHAR -- Existence Of Community Based Health Or Social Care Services For Dementia
);
CREATE TABLE owid_existence_of_dedicated_resources_for_dementia_car_442ed8fc (
"year" INTEGER,
"country" VARCHAR,
"existence_of_dedicated_resources_for_dementia_carer_su_a901dc7e" VARCHAR -- Existence Of Dedicated Resources For Dementia Carer Support Services
);
CREATE TABLE owid_existence_of_dedicated_resources_for_dementia_car_5de14464 (
"year" INTEGER,
"country" VARCHAR,
"existence_of_dedicated_resources_for_dementia_carer_su_a901dc7e" VARCHAR -- Existence Of Dedicated Resources For Dementia Carer Support Services,
"existence_of_dedicated_resources_for_dementia_carer_su_4fdd3b70" VARCHAR -- Existence Of Dedicated Resources For Dementia Carer Support Services Low,
"existence_of_dedicated_resources_for_dementia_carer_su_36a49303" VARCHAR -- Existence Of Dedicated Resources For Dementia Carer Support Services High,
"comments" VARCHAR
);
CREATE TABLE owid_existence_of_dementia_carer_support_services_1 (
"year" INTEGER,
"country" VARCHAR,
"existence_of_dementia_carer_support_services" VARCHAR
);
Anyone who has the link will be able to view this.