Global Health Observatory - World Health Organization
@owid.gho
@owid.gho
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
);
CREATE TABLE owid_unintended_pregnancy_rate_model_estimated_1 (
"year" INTEGER,
"country" VARCHAR,
"uncertainty_interval" VARCHAR,
"unintended_pregnancy_rate_model_estimated" FLOAT
);
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_low" INTEGER,
"unintended_pregnancy_rate_model_estimated_high" INTEGER,
"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_man_b868a79a" VARCHAR,
"unit_in_the_ministry_of_health_responsible_for_the_man_6ff0a613" VARCHAR,
"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,
"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
);
CREATE TABLE owid_uv_radiation_attributable_dalys_000_2 (
"year" INTEGER,
"country" VARCHAR,
"uv_radiation_attributable_dalys_000" FLOAT,
"uv_radiation_attributable_dalys_000_low" VARCHAR,
"uv_radiation_attributable_dalys_000_high" VARCHAR,
"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,
"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_low" VARCHAR,
"value_added_sales_tax_on_beverages_pct_high" VARCHAR,
"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
);
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_low" VARCHAR,
"value_added_tax_vat_on_alcohol_pct_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_varenicline_cost_covered_1 (
"year" INTEGER,
"country" VARCHAR,
"varenicline_cost_covered" VARCHAR
);
CREATE TABLE owid_varenicline_cost_covered_2 (
"year" INTEGER,
"country" VARCHAR,
"varenicline_cost_covered" VARCHAR,
"varenicline_cost_covered_low" VARCHAR,
"varenicline_cost_covered_high" VARCHAR,
"comments" VARCHAR
);
Anyone who has the link will be able to view this.