Global Health Observatory - World Health Organization
@owid.gho
@owid.gho
The GHO data repository is WHO's gateway to health-related statistics for its 194 Member States. It provides access to over 1000 indicators on priority health topics including mortality and burden of diseases, the Millennium Development Goals (child nutrition, child health, maternal and reproductive health, immunization, HIV/AIDS, tuberculosis, malaria, neglected diseases, water and sanitation), non communicable diseases and risk factors, epidemic-prone diseases, health systems, environmental health, violence and injuries, equity among others.
CREATE TABLE owid_abortion_rate_model_estimated_2 (
"year" INTEGER,
"country" VARCHAR,
"uncertainty_interval" VARCHAR,
"abortion_rate_model_estimated" FLOAT -- Abortion Rate, Model Estimated,
"abortion_rate_model_estimated_low" INTEGER -- Abortion Rate, Model Estimated Low,
"abortion_rate_model_estimated_high" INTEGER -- Abortion Rate, Model Estimated High,
"comments" VARCHAR
);CREATE TABLE owid_abstainers_15_19_years_lifetime_pct_1 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"abstainers_15_19_years_lifetime_pct" FLOAT -- Abstainers, 15–19 Years, Lifetime, Pct
);CREATE TABLE owid_abstainers_15_19_years_lifetime_pct_2 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"abstainers_15_19_years_lifetime_pct" FLOAT -- Abstainers, 15–19 Years, Lifetime, Pct,
"abstainers_15_19_years_lifetime_pct_low" VARCHAR -- Abstainers, 15–19 Years, Lifetime, Pct Low,
"abstainers_15_19_years_lifetime_pct_high" VARCHAR -- Abstainers, 15–19 Years, Lifetime, Pct High,
"comments" VARCHAR
);CREATE TABLE owid_abstainers_15_19_years_past_12_months_pct_1 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"abstainers_15_19_years_past_12_months_pct" FLOAT -- Abstainers, 15–19 Years, Past 12 Months, Pct
);CREATE TABLE owid_abstainers_15_19_years_past_12_months_pct_2 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"abstainers_15_19_years_past_12_months_pct" FLOAT -- Abstainers, 15–19 Years, Past 12 Months, Pct,
"abstainers_15_19_years_past_12_months_pct_low" VARCHAR -- Abstainers, 15–19 Years, Past 12 Months, Pct Low,
"abstainers_15_19_years_past_12_months_pct_high" VARCHAR -- Abstainers, 15–19 Years, Past 12 Months, Pct High,
"comments" VARCHAR
);CREATE TABLE owid_accessibility_of_activities_of_daily_living_suppo_01c71a44 (
"year" INTEGER,
"country" VARCHAR,
"accessibility_of_activities_of_daily_living_support_se_25ed2c3d" VARCHAR -- Accessibility Of Activities Of Daily Living Support Services In Community For Dementia, Capital Capital And Main Cities Capital, Main Cities, Rural Areas
);CREATE TABLE owid_accessibility_of_activities_of_daily_living_suppo_2e5dfd75 (
"year" INTEGER,
"country" VARCHAR,
"accessibility_of_activities_of_daily_living_support_se_25ed2c3d" VARCHAR -- Accessibility Of Activities Of Daily Living Support Services In Community For Dementia, Capital Capital And Main Cities Capital, Main Cities, Rural Areas,
"accessibility_of_activities_of_daily_living_support_se_d9f528e3" VARCHAR -- Accessibility Of Activities Of Daily Living Support Services In Community For Dementia, Capital Capital And Main Cities Capital, Main Cities, Rural Areas Low,
"accessibility_of_activities_of_daily_living_support_se_8b003f6b" VARCHAR -- Accessibility Of Activities Of Daily Living Support Services In Community For Dementia, Capital Capital And Main Cities Capital, Main Cities, Rural Areas High,
"comments" VARCHAR
);CREATE TABLE owid_accessibility_of_behaviour_and_psychological_mana_316b9ad8 (
"year" INTEGER,
"country" VARCHAR,
"accessibility_of_behaviour_and_psychological_managemen_f391ef2f" VARCHAR -- Accessibility Of Behaviour And Psychological Management In Community For Dementia, Capital Capital And Main Cities Capital, Main Cities, Rural Areas
);CREATE TABLE owid_accessibility_of_behaviour_and_psychological_mana_678857d8 (
"year" INTEGER,
"country" VARCHAR,
"accessibility_of_behaviour_and_psychological_managemen_f391ef2f" VARCHAR -- Accessibility Of Behaviour And Psychological Management In Community For Dementia, Capital Capital And Main Cities Capital, Main Cities, Rural Areas,
"accessibility_of_behaviour_and_psychological_managemen_27393378" VARCHAR -- Accessibility Of Behaviour And Psychological Management In Community For Dementia, Capital Capital And Main Cities Capital, Main Cities, Rural Areas Low,
"accessibility_of_behaviour_and_psychological_managemen_6772547a" VARCHAR -- Accessibility Of Behaviour And Psychological Management In Community For Dementia, Capital Capital And Main Cities Capital, Main Cities, Rural Areas High,
"comments" VARCHAR
);CREATE TABLE owid_accessibility_of_dementia_carer_training_and_educ_250d353c (
"year" INTEGER,
"country" VARCHAR,
"accessibility_of_dementia_carer_training_and_education_c82d6a52" VARCHAR -- Accessibility Of Dementia Carer Training And Education, Capital Capital And Main Cities Capital, Main Cities, Rural Areas
);CREATE TABLE owid_accessibility_of_dementia_carer_training_and_educ_6f16013c (
"year" INTEGER,
"country" VARCHAR,
"accessibility_of_dementia_carer_training_and_education_c82d6a52" VARCHAR -- Accessibility Of Dementia Carer Training And Education, Capital Capital And Main Cities Capital, Main Cities, Rural Areas,
"accessibility_of_dementia_carer_training_and_education_0ad96c61" VARCHAR -- Accessibility Of Dementia Carer Training And Education, Capital Capital And Main Cities Capital, Main Cities, Rural Areas Low,
"accessibility_of_dementia_carer_training_and_education_c3ab10d2" VARCHAR -- Accessibility Of Dementia Carer Training And Education, Capital Capital And Main Cities Capital, Main Cities, Rural Areas High,
"comments" VARCHAR
);CREATE TABLE owid_accessibility_of_diagnostic_services_in_community_5d69d9d1 (
"year" INTEGER,
"country" VARCHAR,
"accessibility_of_diagnostic_services_in_community_for__52d4cd59" VARCHAR -- Accessibility Of Diagnostic Services In Community For Dementia, Capital Capital And Main Cities Capital, Main Cities, Rural Areas,
"accessibility_of_diagnostic_services_in_community_for__4717d035" VARCHAR -- Accessibility Of Diagnostic Services In Community For Dementia, Capital Capital And Main Cities Capital, Main Cities, Rural Areas Low,
"accessibility_of_diagnostic_services_in_community_for__115977a1" VARCHAR -- Accessibility Of Diagnostic Services In Community For Dementia, Capital Capital And Main Cities Capital, Main Cities, Rural Areas High,
"comments" VARCHAR
);CREATE TABLE owid_accessibility_of_diagnostic_services_in_community_f28c197a (
"year" INTEGER,
"country" VARCHAR,
"accessibility_of_diagnostic_services_in_community_for__52d4cd59" VARCHAR -- Accessibility Of Diagnostic Services In Community For Dementia, Capital Capital And Main Cities Capital, Main Cities, Rural Areas
);CREATE TABLE owid_accessibility_of_financial_benefits_social_protec_2785ce5b (
"year" INTEGER,
"country" VARCHAR,
"accessibility_of_financial_benefits_social_protection__4341fb0b" VARCHAR -- Accessibility Of Financial Benefits Social Protection For Dementia Carers, Capital Capital And Main Cities Capital, Main Cities, Rural Areas,
"accessibility_of_financial_benefits_social_protection__9a9caa95" VARCHAR -- Accessibility Of Financial Benefits Social Protection For Dementia Carers, Capital Capital And Main Cities Capital, Main Cities, Rural Areas Low,
"accessibility_of_financial_benefits_social_protection__c8229b2c" VARCHAR -- Accessibility Of Financial Benefits Social Protection For Dementia Carers, Capital Capital And Main Cities Capital, Main Cities, Rural Areas High,
"comments" VARCHAR
);CREATE TABLE owid_accessibility_of_financial_benefits_social_protec_3b694e20 (
"year" INTEGER,
"country" VARCHAR,
"accessibility_of_financial_benefits_social_protection__4341fb0b" VARCHAR -- Accessibility Of Financial Benefits Social Protection For Dementia Carers, Capital Capital And Main Cities Capital, Main Cities, Rural Areas
);CREATE TABLE owid_accessibility_of_information_on_legal_rights_for__73f82829 (
"year" INTEGER,
"country" VARCHAR,
"accessibility_of_information_on_legal_rights_for_demen_55bee451" VARCHAR -- Accessibility Of Information On Legal Rights For Dementia Carers, Capital Capital And Main Cities Capital, Main Cities, Rural Areas,
"accessibility_of_information_on_legal_rights_for_demen_e51a76bb" VARCHAR -- Accessibility Of Information On Legal Rights For Dementia Carers, Capital Capital And Main Cities Capital, Main Cities, Rural Areas Low,
"accessibility_of_information_on_legal_rights_for_demen_c24eb4d0" VARCHAR -- Accessibility Of Information On Legal Rights For Dementia Carers, Capital Capital And Main Cities Capital, Main Cities, Rural Areas High,
"comments" VARCHAR
);CREATE TABLE owid_accessibility_of_information_on_legal_rights_for__9030228a (
"year" INTEGER,
"country" VARCHAR,
"accessibility_of_information_on_legal_rights_for_demen_55bee451" VARCHAR -- Accessibility Of Information On Legal Rights For Dementia Carers, Capital Capital And Main Cities Capital, Main Cities, Rural Areas
);CREATE TABLE owid_accessibility_of_palliative_and_end_of_life_care__6ad1663b (
"year" INTEGER,
"country" VARCHAR,
"accessibility_of_palliative_and_end_of_life_care_servi_31839e96" VARCHAR -- Accessibility Of Palliative And End Of Life Care Services In Community For Dementia, Capital Capital And Main Cities Capital, Main Cities, Rural Areas,
"accessibility_of_palliative_and_end_of_life_care_servi_a6d69187" VARCHAR -- Accessibility Of Palliative And End Of Life Care Services In Community For Dementia, Capital Capital And Main Cities Capital, Main Cities, Rural Areas Low,
"accessibility_of_palliative_and_end_of_life_care_servi_cc35694d" VARCHAR -- Accessibility Of Palliative And End Of Life Care Services In Community For Dementia, Capital Capital And Main Cities Capital, Main Cities, Rural Areas High,
"comments" VARCHAR
);CREATE TABLE owid_accessibility_of_palliative_and_end_of_life_care__f4004659 (
"year" INTEGER,
"country" VARCHAR,
"accessibility_of_palliative_and_end_of_life_care_servi_31839e96" VARCHAR -- Accessibility Of Palliative And End Of Life Care Services In Community For Dementia, Capital Capital And Main Cities Capital, Main Cities, Rural Areas
);CREATE TABLE owid_accessibility_of_psychosocial_and_rehabilitation__2fb6f788 (
"year" INTEGER,
"country" VARCHAR,
"accessibility_of_psychosocial_and_rehabilitation_servi_d29c755e" VARCHAR -- Accessibility Of Psychosocial And Rehabilitation Services In Community For Dementia, Capital Capital And Main Cities Capital, Main Cities, Rural Areas
);CREATE TABLE owid_accessibility_of_psychosocial_and_rehabilitation__5935c9bb (
"year" INTEGER,
"country" VARCHAR,
"accessibility_of_psychosocial_and_rehabilitation_servi_d29c755e" VARCHAR -- Accessibility Of Psychosocial And Rehabilitation Services In Community For Dementia, Capital Capital And Main Cities Capital, Main Cities, Rural Areas,
"accessibility_of_psychosocial_and_rehabilitation_servi_5a66810e" VARCHAR -- Accessibility Of Psychosocial And Rehabilitation Services In Community For Dementia, Capital Capital And Main Cities Capital, Main Cities, Rural Areas Low,
"accessibility_of_psychosocial_and_rehabilitation_servi_a3696338" VARCHAR -- Accessibility Of Psychosocial And Rehabilitation Services In Community For Dementia, Capital Capital And Main Cities Capital, Main Cities, Rural Areas High,
"comments" VARCHAR
);CREATE TABLE owid_accessibility_of_psycho_social_supports_for_demen_0ee1e664 (
"year" INTEGER,
"country" VARCHAR,
"accessibility_of_psycho_social_supports_for_dementia_c_f4852e48" VARCHAR -- Accessibility Of Psycho Social Supports For Dementia Carers, Capital Capital And Main Cities Capital, Main Cities, Rural Areas
);CREATE TABLE owid_accessibility_of_psycho_social_supports_for_demen_12e7cda1 (
"year" INTEGER,
"country" VARCHAR,
"accessibility_of_psycho_social_supports_for_dementia_c_f4852e48" VARCHAR -- Accessibility Of Psycho Social Supports For Dementia Carers, Capital Capital And Main Cities Capital, Main Cities, Rural Areas,
"accessibility_of_psycho_social_supports_for_dementia_c_dbd95205" VARCHAR -- Accessibility Of Psycho Social Supports For Dementia Carers, Capital Capital And Main Cities Capital, Main Cities, Rural Areas Low,
"accessibility_of_psycho_social_supports_for_dementia_c_c584f58c" VARCHAR -- Accessibility Of Psycho Social Supports For Dementia Carers, Capital Capital And Main Cities Capital, Main Cities, Rural Areas High,
"comments" VARCHAR
);CREATE TABLE owid_accessibility_of_respite_care_for_dementia_carers_1c17e93e (
"year" INTEGER,
"country" VARCHAR,
"accessibility_of_respite_care_for_dementia_carers_capi_212e83c6" VARCHAR -- Accessibility Of Respite Care For Dementia Carers, Capital Capital And Main Cities Capital, Main Cities, Rural Areas,
"accessibility_of_respite_care_for_dementia_carers_capi_3dc95198" VARCHAR -- Accessibility Of Respite Care For Dementia Carers, Capital Capital And Main Cities Capital, Main Cities, Rural Areas Low,
"accessibility_of_respite_care_for_dementia_carers_capi_600cccfd" VARCHAR -- Accessibility Of Respite Care For Dementia Carers, Capital Capital And Main Cities Capital, Main Cities, Rural Areas High,
"comments" VARCHAR
);CREATE TABLE owid_accessibility_of_respite_care_for_dementia_carers_75087361 (
"year" INTEGER,
"country" VARCHAR,
"accessibility_of_respite_care_for_dementia_carers_capi_212e83c6" VARCHAR -- Accessibility Of Respite Care For Dementia Carers, Capital Capital And Main Cities Capital, Main Cities, Rural Areas
);Anyone who has the link will be able to view this.