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_uniform_or_tiered_excise_tax_system_applied_on_no_e8742e3e (
"year" INTEGER,
"country" VARCHAR,
"beverage_type" VARCHAR,
"beverage" VARCHAR,
"comments" VARCHAR,
"uniform_or_tiered_excise_tax_system_applied_on_non_alc_f14a1bf3" VARCHAR -- Uniform Or Tiered Excise Tax System Applied On Non Alcoholic Beverage
);CREATE TABLE owid_unintended_pregnancy_rate_model_estimated_1 (
"year" INTEGER,
"country" VARCHAR,
"uncertainty_interval" VARCHAR,
"unintended_pregnancy_rate_model_estimated" FLOAT -- Unintended Pregnancy Rate, Model Estimated
);CREATE TABLE owid_unintended_pregnancy_rate_model_estimated_2 (
"year" INTEGER,
"country" VARCHAR,
"uncertainty_interval" VARCHAR,
"unintended_pregnancy_rate_model_estimated" FLOAT -- Unintended Pregnancy Rate, Model Estimated,
"unintended_pregnancy_rate_model_estimated_low" INTEGER -- Unintended Pregnancy Rate, Model Estimated Low,
"unintended_pregnancy_rate_model_estimated_high" INTEGER -- Unintended Pregnancy Rate, Model Estimated High,
"comments" VARCHAR
);CREATE TABLE owid_unit_in_the_ministry_of_health_responsible_for_th_796dcba8 (
"year" INTEGER,
"country" VARCHAR,
"unit_in_the_ministry_of_health_responsible_for_the_man_958f701f" INTEGER -- Unit In The Ministry Of Health Responsible For The Management Of Medical Devices,
"unit_in_the_ministry_of_health_responsible_for_the_man_b868a79a" VARCHAR -- Unit In The Ministry Of Health Responsible For The Management Of Medical Devices Low,
"unit_in_the_ministry_of_health_responsible_for_the_man_6ff0a613" VARCHAR -- Unit In The Ministry Of Health Responsible For The Management Of Medical Devices High,
"comments" VARCHAR
);CREATE TABLE owid_unit_in_the_ministry_of_health_responsible_for_th_af273123 (
"year" INTEGER,
"country" VARCHAR,
"unit_in_the_ministry_of_health_responsible_for_the_man_958f701f" INTEGER -- Unit In The Ministry Of Health Responsible For The Management Of Medical Devices,
"comments" VARCHAR
);CREATE TABLE owid_use_of_earmarked_excise_tax_on_beverages_1 (
"year" INTEGER,
"country" VARCHAR,
"beverage_type" VARCHAR,
"use_of_earmarked_excise_tax_on_beverages" VARCHAR
);CREATE TABLE owid_use_of_earmarked_excise_tax_on_beverages_2 (
"year" INTEGER,
"country" VARCHAR,
"beverage_type" VARCHAR,
"use_of_earmarked_excise_tax_on_beverages" VARCHAR,
"use_of_earmarked_excise_tax_on_beverages_low" VARCHAR,
"use_of_earmarked_excise_tax_on_beverages_high" VARCHAR,
"comments" VARCHAR
);CREATE TABLE owid_use_of_nomenclature_system_1 (
"year" INTEGER,
"country" VARCHAR,
"use_of_nomenclature_system" INTEGER
);CREATE TABLE owid_use_of_nomenclature_system_2 (
"year" INTEGER,
"country" VARCHAR,
"use_of_nomenclature_system" INTEGER,
"use_of_nomenclature_system_low" VARCHAR,
"use_of_nomenclature_system_high" VARCHAR,
"comments" VARCHAR
);CREATE TABLE owid_uv_radiation_1 (
"year" INTEGER,
"country" VARCHAR,
"uv_radiation" INTEGER
);CREATE TABLE owid_uv_radiation_2 (
"year" INTEGER,
"country" VARCHAR,
"uv_radiation" INTEGER,
"uv_radiation_low" VARCHAR,
"uv_radiation_high" VARCHAR,
"comments" VARCHAR
);CREATE TABLE owid_uv_radiation_attributable_dalys_000_1 (
"year" INTEGER,
"country" VARCHAR,
"uv_radiation_attributable_dalys_000" FLOAT -- Uv Radiation Attributable Dalys, 000
);CREATE TABLE owid_uv_radiation_attributable_dalys_000_2 (
"year" INTEGER,
"country" VARCHAR,
"uv_radiation_attributable_dalys_000" FLOAT -- Uv Radiation Attributable Dalys, 000,
"uv_radiation_attributable_dalys_000_low" VARCHAR -- Uv Radiation Attributable Dalys, 000 Low,
"uv_radiation_attributable_dalys_000_high" VARCHAR -- Uv Radiation Attributable Dalys, 000 High,
"comments" VARCHAR
);CREATE TABLE owid_uv_radiation_attributable_dalys_per_100000_capita_1 (
"year" INTEGER,
"country" VARCHAR,
"uv_radiation_attributable_dalys_per_100000_capita" FLOAT
);CREATE TABLE owid_uv_radiation_attributable_dalys_per_100000_capita_2 (
"year" INTEGER,
"country" VARCHAR,
"uv_radiation_attributable_dalys_per_100000_capita" FLOAT,
"uv_radiation_attributable_dalys_per_100000_capita_low" VARCHAR,
"uv_radiation_attributable_dalys_per_100000_capita_high" VARCHAR,
"comments" VARCHAR
);CREATE TABLE owid_uv_radiation_attributable_deaths_1 (
"year" INTEGER,
"country" VARCHAR,
"uv_radiation_attributable_deaths" FLOAT
);CREATE TABLE owid_uv_radiation_attributable_deaths_2 (
"year" INTEGER,
"country" VARCHAR,
"uv_radiation_attributable_deaths" FLOAT,
"uv_radiation_attributable_deaths_low" VARCHAR,
"uv_radiation_attributable_deaths_high" VARCHAR,
"comments" VARCHAR
);CREATE TABLE owid_uv_radiation_attributable_deaths_per_100000_capita_1 (
"year" INTEGER,
"country" VARCHAR,
"uv_radiation_attributable_deaths_per_100000_capita" FLOAT
);CREATE TABLE owid_uv_radiation_attributable_deaths_per_100000_capita_2 (
"year" INTEGER,
"country" VARCHAR,
"uv_radiation_attributable_deaths_per_100000_capita" FLOAT,
"uv_radiation_attributable_deaths_per_100000_capita_low" VARCHAR,
"uv_radiation_attributable_deaths_per_100000_capita_high" VARCHAR,
"comments" VARCHAR
);CREATE TABLE owid_value_added_sales_tax_on_beverages_pct_1 (
"year" INTEGER,
"country" VARCHAR,
"beverage_type" VARCHAR,
"beverage" VARCHAR,
"value_added_sales_tax_on_beverages_pct" FLOAT -- Value Added Sales Tax On Beverages, Pct,
"comments" VARCHAR
);CREATE TABLE owid_value_added_sales_tax_on_beverages_pct_2 (
"year" INTEGER,
"country" VARCHAR,
"beverage_type" VARCHAR,
"beverage" VARCHAR,
"value_added_sales_tax_on_beverages_pct" FLOAT -- Value Added Sales Tax On Beverages, Pct,
"value_added_sales_tax_on_beverages_pct_low" VARCHAR -- Value Added Sales Tax On Beverages, Pct Low,
"value_added_sales_tax_on_beverages_pct_high" VARCHAR -- Value Added Sales Tax On Beverages, Pct High,
"comments" VARCHAR
);CREATE TABLE owid_value_added_tax_vat_on_alcohol_pct_1 (
"year" INTEGER,
"country" VARCHAR,
"value_added_tax_vat_on_alcohol_pct" VARCHAR -- Value Added Tax, Vat, On Alcohol, Pct
);CREATE TABLE owid_value_added_tax_vat_on_alcohol_pct_2 (
"year" INTEGER,
"country" VARCHAR,
"value_added_tax_vat_on_alcohol_pct" VARCHAR -- Value Added Tax, Vat, On Alcohol, Pct,
"value_added_tax_vat_on_alcohol_pct_low" VARCHAR -- Value Added Tax, Vat, On Alcohol, Pct Low,
"value_added_tax_vat_on_alcohol_pct_high" VARCHAR -- Value Added Tax, Vat, On Alcohol, Pct High,
"comments" VARCHAR
);CREATE TABLE owid_varenicline_cost_covered_1 (
"year" INTEGER,
"country" VARCHAR,
"varenicline_cost_covered" VARCHAR -- Varenicline, Cost Covered
);CREATE TABLE owid_varenicline_cost_covered_2 (
"year" INTEGER,
"country" VARCHAR,
"varenicline_cost_covered" VARCHAR -- Varenicline, Cost Covered,
"varenicline_cost_covered_low" VARCHAR -- Varenicline, Cost Covered Low,
"varenicline_cost_covered_high" VARCHAR -- Varenicline, Cost Covered High,
"comments" VARCHAR
);Anyone who has the link will be able to view this.