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_uhc_service_coverage_index_sdg_3_8_1_1 (
"year" INTEGER,
"country" VARCHAR,
"uhc_service_coverage_index_sdg_3_8_1" FLOAT -- Uhc Service Coverage Index, Sdg 3–8 1
);CREATE TABLE owid_uhc_service_coverage_index_sdg_3_8_1_2 (
"year" INTEGER,
"country" VARCHAR,
"uhc_service_coverage_index_sdg_3_8_1" FLOAT -- Uhc Service Coverage Index, Sdg 3–8 1,
"uhc_service_coverage_index_sdg_3_8_1_low" VARCHAR -- Uhc Service Coverage Index, Sdg 3–8 1 Low,
"uhc_service_coverage_index_sdg_3_8_1_high" VARCHAR -- Uhc Service Coverage Index, Sdg 3–8 1 High,
"comments" VARCHAR
);CREATE TABLE owid_uhc_service_coverage_sub_index_on_infectious_diseases_1 (
"year" INTEGER,
"country" VARCHAR,
"uhc_service_coverage_sub_index_on_infectious_diseases" FLOAT
);CREATE TABLE owid_uhc_service_coverage_sub_index_on_infectious_diseases_2 (
"year" INTEGER,
"country" VARCHAR,
"uhc_service_coverage_sub_index_on_infectious_diseases" FLOAT,
"uhc_service_coverage_sub_index_on_infectious_diseases_low" VARCHAR,
"uhc_service_coverage_sub_index_on_infectious_diseases_high" VARCHAR,
"comments" VARCHAR
);CREATE TABLE owid_uhc_service_coverage_sub_index_on_noncommunicable_2e398bfd (
"year" INTEGER,
"country" VARCHAR,
"uhc_service_coverage_sub_index_on_noncommunicable_diseases" FLOAT,
"uhc_service_coverage_sub_index_on_noncommunicable_diseases_low" VARCHAR,
"uhc_service_coverage_sub_index_on_noncommunicable_diseases_high" VARCHAR,
"comments" VARCHAR
);CREATE TABLE owid_uhc_service_coverage_sub_index_on_noncommunicable_659c3de4 (
"year" INTEGER,
"country" VARCHAR,
"uhc_service_coverage_sub_index_on_noncommunicable_diseases" FLOAT
);CREATE TABLE owid_uhc_service_coverage_sub_index_on_reproductive_ma_483a1bd6 (
"year" INTEGER,
"country" VARCHAR,
"uhc_service_coverage_sub_index_on_reproductive_materna_739354fc" FLOAT -- Uhc Service Coverage Sub Index On Reproductive, Maternal, Newborn And Child Health
);CREATE TABLE owid_uhc_service_coverage_sub_index_on_reproductive_ma_adfb7d43 (
"year" INTEGER,
"country" VARCHAR,
"uhc_service_coverage_sub_index_on_reproductive_materna_739354fc" FLOAT -- Uhc Service Coverage Sub Index On Reproductive, Maternal, Newborn And Child Health,
"uhc_service_coverage_sub_index_on_reproductive_materna_69fea5ee" VARCHAR -- Uhc Service Coverage Sub Index On Reproductive, Maternal, Newborn And Child Health Low,
"uhc_service_coverage_sub_index_on_reproductive_materna_267c64c7" VARCHAR -- Uhc Service Coverage Sub Index On Reproductive, Maternal, Newborn And Child Health High,
"comments" VARCHAR
);CREATE TABLE owid_uhc_service_coverage_sub_index_on_service_capacit_227936bb (
"year" INTEGER,
"country" VARCHAR,
"uhc_service_coverage_sub_index_on_service_capacity_and_access" FLOAT,
"uhc_service_coverage_sub_index_on_service_capacity_and_f3d0ebf3" VARCHAR -- Uhc Service Coverage Sub Index On Service Capacity And Access Low,
"uhc_service_coverage_sub_index_on_service_capacity_and_7c7f830a" VARCHAR -- Uhc Service Coverage Sub Index On Service Capacity And Access High,
"comments" VARCHAR
);CREATE TABLE owid_uhc_service_coverage_sub_index_on_service_capacit_285e7c91 (
"year" INTEGER,
"country" VARCHAR,
"uhc_service_coverage_sub_index_on_service_capacity_and_access" FLOAT
);CREATE TABLE owid_under_five_mortality_rate_deaths_per_1000_live_births_1 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"age_group" VARCHAR,
"mothers_education_level" VARCHAR,
"residence_area_type" VARCHAR,
"wealth_quintile" VARCHAR,
"dhs_mics_subnational_regions_health_equity_monitor" VARCHAR -- Dhs Mics Subnational Regions, Health Equity Monitor,
"wealth_decile" VARCHAR,
"under_five_mortality_rate_deaths_per_1000_live_births" FLOAT -- Under Five Mortality Rate, Deaths Per 1000 Live Births,
"comments" VARCHAR
);CREATE TABLE owid_under_five_mortality_rate_deaths_per_1000_live_births_2 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"age_group" VARCHAR,
"wealth_decile" VARCHAR,
"wealth_quintile" VARCHAR,
"residence_area_type" VARCHAR,
"dhs_mics_subnational_regions_health_equity_monitor" VARCHAR -- Dhs Mics Subnational Regions, Health Equity Monitor,
"education_level" VARCHAR,
"under_five_mortality_rate_deaths_per_1000_live_births" FLOAT -- Under Five Mortality Rate, Deaths Per 1000 Live Births,
"under_five_mortality_rate_deaths_per_1000_live_births_low" FLOAT -- Under Five Mortality Rate, Deaths Per 1000 Live Births Low,
"under_five_mortality_rate_deaths_per_1000_live_births_high" FLOAT -- Under Five Mortality Rate, Deaths Per 1000 Live Births High,
"comments" VARCHAR
);CREATE TABLE owid_under_five_mortality_rate_per_1000_live_births_sdg_3_2_1_1 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"under_five_mortality_rate_per_1000_live_births_sdg_3_2_1" FLOAT -- Under Five Mortality Rate, Per 1000 Live Births, Sdg 3–2 1
);CREATE TABLE owid_under_five_mortality_rate_per_1000_live_births_sdg_3_2_1_2 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"age_group" VARCHAR,
"wealth_quintile" VARCHAR,
"under_five_mortality_rate_per_1000_live_births_sdg_3_2_1" FLOAT -- Under Five Mortality Rate, Per 1000 Live Births, Sdg 3–2 1,
"under_five_mortality_rate_per_1000_live_births_sdg_3_2_1_low" FLOAT -- Under Five Mortality Rate, Per 1000 Live Births, Sdg 3–2 1 Low,
"under_five_mortality_rate_per_1000_live_births_sdg_3_2_1_high" FLOAT -- Under Five Mortality Rate, Per 1000 Live Births, Sdg 3–2 1 High,
"comments" VARCHAR
);CREATE TABLE owid_underweight_numbers_among_children_under_5_years__25f9f9e5 (
"year" INTEGER,
"country" VARCHAR,
"underweight_numbers_among_children_under_5_years_of_ag_3ec42be0" FLOAT -- Underweight Numbers Among Children Under 5 Years Of Age, Millions, Model Based Estimates
);CREATE TABLE owid_underweight_numbers_among_children_under_5_years__31ee8cac (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"underweight_numbers_among_children_under_5_years_of_ag_3ec42be0" FLOAT -- Underweight Numbers Among Children Under 5 Years Of Age, Millions, Model Based Estimates,
"underweight_numbers_among_children_under_5_years_of_ag_5b6a98b2" FLOAT -- Underweight Numbers Among Children Under 5 Years Of Age, Millions, Model Based Estimates Low,
"underweight_numbers_among_children_under_5_years_of_ag_9a618fe3" FLOAT -- Underweight Numbers Among Children Under 5 Years Of Age, Millions, Model Based Estimates High,
"comments" VARCHAR
);CREATE TABLE owid_underweight_prevalence_among_children_under_5_yea_6eaf4e9b (
"year" INTEGER,
"country" VARCHAR,
"underweight_prevalence_among_children_under_5_years_of_58664be7" FLOAT -- Underweight Prevalence Among Children Under 5 Years Of Age, Pct Weight For Age, Lt, 2 Sd, Survey Based Estimates,
"comments" VARCHAR
);CREATE TABLE owid_underweight_prevalence_among_children_under_5_yea_b2ad9ee2 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"age_group" VARCHAR,
"household_wealth" VARCHAR,
"wealth_tercile" VARCHAR,
"wealth_decile" VARCHAR,
"wealth_quintile" VARCHAR,
"residence_area_type" VARCHAR,
"education_level" VARCHAR,
"underweight_prevalence_among_children_under_5_years_of_58664be7" FLOAT -- Underweight Prevalence Among Children Under 5 Years Of Age, Pct Weight For Age, Lt, 2 Sd, Survey Based Estimates,
"underweight_prevalence_among_children_under_5_years_of_56e5e762" FLOAT -- Underweight Prevalence Among Children Under 5 Years Of Age, Pct Weight For Age, Lt, 2 Sd, Survey Based Estimates Low,
"underweight_prevalence_among_children_under_5_years_of_9f0dfcec" FLOAT -- Underweight Prevalence Among Children Under 5 Years Of Age, Pct Weight For Age, Lt, 2 Sd, Survey Based Estimates High,
"comments" VARCHAR
);CREATE TABLE owid_underweight_prevalence_among_children_under_5_yea_be1f5ef6 (
"year" INTEGER,
"country" VARCHAR,
"underweight_prevalence_among_children_under_5_years_of_75a44f80" FLOAT -- Underweight Prevalence Among Children Under 5 Years Of Age, Pct, Model Based Estimates
);CREATE TABLE owid_underweight_prevalence_among_children_under_5_yea_e3598498 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"underweight_prevalence_among_children_under_5_years_of_75a44f80" FLOAT -- Underweight Prevalence Among Children Under 5 Years Of Age, Pct, Model Based Estimates,
"underweight_prevalence_among_children_under_5_years_of_9ab4a7a9" FLOAT -- Underweight Prevalence Among Children Under 5 Years Of Age, Pct, Model Based Estimates Low,
"underweight_prevalence_among_children_under_5_years_of_c1bc349d" FLOAT -- Underweight Prevalence Among Children Under 5 Years Of Age, Pct, Model Based Estimates High,
"comments" VARCHAR
);CREATE TABLE owid_underweight_prevalence_in_children_aged_lt_5_year_094181ce (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"age_group" VARCHAR,
"mothers_education_level" VARCHAR,
"residence_area_type" VARCHAR,
"wealth_quintile" VARCHAR,
"dhs_mics_subnational_regions_health_equity_monitor" VARCHAR -- Dhs Mics Subnational Regions, Health Equity Monitor,
"wealth_decile" VARCHAR,
"underweight_prevalence_in_children_aged_lt_5_years_pct_e2951f44" FLOAT -- Underweight Prevalence In Children Aged, Lt, 5 Years, Pct, Health Inequality Monitor,
"comments" VARCHAR
);CREATE TABLE owid_underweight_prevalence_in_children_aged_lt_5_year_11c76ea0 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"age_group" VARCHAR,
"wealth_decile" VARCHAR,
"wealth_quintile" VARCHAR,
"residence_area_type" VARCHAR,
"dhs_mics_subnational_regions_health_equity_monitor" VARCHAR -- Dhs Mics Subnational Regions, Health Equity Monitor,
"education_level" VARCHAR,
"underweight_prevalence_in_children_aged_lt_5_years_pct_e2951f44" FLOAT -- Underweight Prevalence In Children Aged, Lt, 5 Years, Pct, Health Inequality Monitor,
"underweight_prevalence_in_children_aged_lt_5_years_pct_678eef0a" FLOAT -- Underweight Prevalence In Children Aged, Lt, 5 Years, Pct, Health Inequality Monitor Low,
"underweight_prevalence_in_children_aged_lt_5_years_pct_fcf35128" FLOAT -- Underweight Prevalence In Children Aged, Lt, 5 Years, Pct, Health Inequality Monitor High,
"comments" VARCHAR
);CREATE TABLE owid_uniform_or_tiered_excise_tax_system_applied_on_al_c78de320 (
"year" INTEGER,
"country" VARCHAR,
"beverage_type" VARCHAR,
"beverage" VARCHAR,
"uniform_or_tiered_excise_tax_system_applied_on_alcohol_45307b74" VARCHAR -- Uniform Or Tiered Excise Tax System Applied On Alcoholic Beverage,
"uniform_or_tiered_excise_tax_system_applied_on_alcohol_66eb564e" VARCHAR -- Uniform Or Tiered Excise Tax System Applied On Alcoholic Beverage Low,
"uniform_or_tiered_excise_tax_system_applied_on_alcohol_9d63c1ee" VARCHAR -- Uniform Or Tiered Excise Tax System Applied On Alcoholic Beverage High,
"comments" VARCHAR
);CREATE TABLE owid_uniform_or_tiered_excise_tax_system_applied_on_al_e4b2de51 (
"year" INTEGER,
"country" VARCHAR,
"beverage_type" VARCHAR,
"beverage" VARCHAR,
"comments" VARCHAR,
"uniform_or_tiered_excise_tax_system_applied_on_alcohol_45307b74" VARCHAR -- Uniform Or Tiered Excise Tax System Applied On Alcoholic Beverage
);CREATE TABLE owid_uniform_or_tiered_excise_tax_system_applied_on_no_b23d4d96 (
"year" INTEGER,
"country" VARCHAR,
"beverage_type" VARCHAR,
"beverage" VARCHAR,
"uniform_or_tiered_excise_tax_system_applied_on_non_alc_f14a1bf3" VARCHAR -- Uniform Or Tiered Excise Tax System Applied On Non Alcoholic Beverage,
"uniform_or_tiered_excise_tax_system_applied_on_non_alc_7d10a980" VARCHAR -- Uniform Or Tiered Excise Tax System Applied On Non Alcoholic Beverage Low,
"uniform_or_tiered_excise_tax_system_applied_on_non_alc_a55e849a" VARCHAR -- Uniform Or Tiered Excise Tax System Applied On Non Alcoholic Beverage High,
"comments" VARCHAR
);Anyone who has the link will be able to view this.