Global Health Observatory - World Health Organization
@owid.gho
@owid.gho
CREATE TABLE owid_ambient_air_pollution_attributable_yll_in_childre_e2132868 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"cause" VARCHAR,
"ambient_air_pollution_attributable_yll_in_children_und_1fcb1c6d" FLOAT
);
CREATE TABLE owid_ambient_air_pollution_attributable_yll_in_childre_eb97bc52 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"cause" VARCHAR,
"ambient_air_pollution_attributable_yll_in_children_und_1fcb1c6d" FLOAT,
"ambient_air_pollution_attributable_yll_in_children_und_06e91c34" FLOAT,
"ambient_air_pollution_attributable_yll_in_children_und_a1e37b79" FLOAT,
"comments" VARCHAR
);
CREATE TABLE owid_ambient_air_pollution_attributable_ylls_1 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"age_group" VARCHAR,
"cause" VARCHAR,
"ambient_air_pollution_attributable_ylls" FLOAT
);
CREATE TABLE owid_ambient_air_pollution_attributable_ylls_2 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"age_group" VARCHAR,
"cause" VARCHAR,
"ambient_air_pollution_attributable_ylls" FLOAT,
"ambient_air_pollution_attributable_ylls_low" FLOAT,
"ambient_air_pollution_attributable_ylls_high" FLOAT,
"comments" VARCHAR
);
CREATE TABLE owid_ambient_and_household_air_pollution_attributable__09a82ce8 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"age_group" VARCHAR,
"cause" VARCHAR,
"ambient_and_household_air_pollution_attributable_death_78eccd32" FLOAT
);
CREATE TABLE owid_ambient_and_household_air_pollution_attributable__100bd24c (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"age_group" VARCHAR,
"cause" VARCHAR,
"ambient_and_household_air_pollution_attributable_death_0f299e79" FLOAT,
"ambient_and_household_air_pollution_attributable_death_33763998" FLOAT,
"ambient_and_household_air_pollution_attributable_death_82d9fd5c" FLOAT,
"comments" VARCHAR
);
CREATE TABLE owid_ambient_and_household_air_pollution_attributable__1798ebfd (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"age_group" VARCHAR,
"cause" VARCHAR,
"ambient_and_household_air_pollution_attributable_death_0f299e79" FLOAT
);
CREATE TABLE owid_ambient_and_household_air_pollution_attributable__2167a249 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"ghe_cause_of_death_codes" VARCHAR,
"ambient_and_household_air_pollution_attributable_death_78eccd32" FLOAT,
"ambient_and_household_air_pollution_attributable_death_ddf5dd8b" FLOAT,
"ambient_and_household_air_pollution_attributable_death_f2a79ee4" FLOAT,
"comments" VARCHAR
);
CREATE TABLE owid_amount_of_water_and_sanitation_related_official_d_783018b3 (
"year" INTEGER,
"country" VARCHAR,
"amount_of_water_and_sanitation_related_official_develo_277867e1" FLOAT,
"amount_of_water_and_sanitation_related_official_develo_7a55c946" VARCHAR,
"amount_of_water_and_sanitation_related_official_develo_c03c0559" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_amount_of_water_and_sanitation_related_official_d_b374fd71 (
"year" INTEGER,
"country" VARCHAR,
"amount_of_water_and_sanitation_related_official_develo_277867e1" FLOAT,
"comments" VARCHAR
);
CREATE TABLE owid_annual_budget_for_tobacco_control_in_currency_reported_1 (
"year" INTEGER,
"country" VARCHAR,
"annual_budget_for_tobacco_control_in_currency_reported" BIGINT,
"comments" VARCHAR
);
CREATE TABLE owid_annual_budget_for_tobacco_control_in_currency_reported_2 (
"year" INTEGER,
"country" VARCHAR,
"annual_budget_for_tobacco_control_in_currency_reported" BIGINT,
"annual_budget_for_tobacco_control_in_currency_reported_low" VARCHAR,
"annual_budget_for_tobacco_control_in_currency_reported_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_annual_revenues_from_alcohol_excise_tax_in_millions_usd_1 (
"year" INTEGER,
"country" VARCHAR,
"annual_revenues_from_alcohol_excise_tax_in_millions_usd" FLOAT
);
CREATE TABLE owid_annual_revenues_from_alcohol_excise_tax_in_millions_usd_2 (
"year" INTEGER,
"country" VARCHAR,
"annual_revenues_from_alcohol_excise_tax_in_millions_usd" FLOAT,
"annual_revenues_from_alcohol_excise_tax_in_millions_usd_low" VARCHAR,
"annual_revenues_from_alcohol_excise_tax_in_millions_usd_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_antenatal_care_attendees_positive_for_syphilis_wh_4af6e889 (
"year" INTEGER,
"country" VARCHAR,
"antenatal_care_attendees_positive_for_syphilis_who_rec_91f1b72a" FLOAT,
"antenatal_care_attendees_positive_for_syphilis_who_rec_ae62c4d1" VARCHAR,
"antenatal_care_attendees_positive_for_syphilis_who_rec_dfe45290" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_antenatal_care_attendees_positive_for_syphilis_wh_d328cdf9 (
"year" INTEGER,
"country" VARCHAR,
"antenatal_care_attendees_positive_for_syphilis_who_rec_91f1b72a" FLOAT,
"comments" VARCHAR
);
CREATE TABLE owid_antenatal_care_attendees_who_were_positive_for_sy_371a1f85 (
"year" INTEGER,
"country" VARCHAR,
"antenatal_care_attendees_who_were_positive_for_syphili_aaa90ab4" FLOAT,
"comments" VARCHAR
);
CREATE TABLE owid_antenatal_care_attendees_who_were_positive_for_sy_a459a171 (
"year" INTEGER,
"country" VARCHAR,
"antenatal_care_attendees_who_were_positive_for_syphili_aaa90ab4" FLOAT,
"antenatal_care_attendees_who_were_positive_for_syphili_9322710d" VARCHAR,
"antenatal_care_attendees_who_were_positive_for_syphili_91a5c72a" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_antenatal_care_coverage_at_least_four_visits_in_t_2bf696f8 (
"year" INTEGER,
"country" VARCHAR,
"age_group" VARCHAR,
"mothers_education_level" VARCHAR,
"residence_area_type" VARCHAR,
"wealth_quintile" VARCHAR,
"dhs_mics_subnational_regions_health_equity_monitor" VARCHAR,
"wealth_decile" VARCHAR,
"antenatal_care_coverage_at_least_four_visits_in_the_tw_4a76718e" FLOAT,
"comments" VARCHAR
);
CREATE TABLE owid_antenatal_care_coverage_at_least_four_visits_in_t_351cb479 (
"year" INTEGER,
"country" VARCHAR,
"age_group" VARCHAR,
"wealth_decile" VARCHAR,
"wealth_quintile" VARCHAR,
"residence_area_type" VARCHAR,
"dhs_mics_subnational_regions_health_equity_monitor" VARCHAR,
"education_level" VARCHAR,
"antenatal_care_coverage_at_least_four_visits_in_the_tw_4a76718e" FLOAT,
"antenatal_care_coverage_at_least_four_visits_in_the_tw_62aa6eff" FLOAT,
"antenatal_care_coverage_at_least_four_visits_in_the_tw_a309ef2e" FLOAT,
"comments" VARCHAR
);
CREATE TABLE owid_antenatal_care_coverage_at_least_four_visits_in_t_c65b133a (
"year" INTEGER,
"country" VARCHAR,
"age_group" VARCHAR,
"mothers_education_level" VARCHAR,
"residence_area_type" VARCHAR,
"wealth_quintile" VARCHAR,
"dhs_mics_subnational_regions_health_equity_monitor" VARCHAR,
"wealth_decile" VARCHAR,
"antenatal_care_coverage_at_least_four_visits_in_the_fi_cfc9057e" FLOAT,
"comments" VARCHAR
);
CREATE TABLE owid_antenatal_care_coverage_at_least_four_visits_in_t_fa48bcd9 (
"year" INTEGER,
"country" VARCHAR,
"age_group" VARCHAR,
"wealth_decile" VARCHAR,
"wealth_quintile" VARCHAR,
"dhs_mics_subnational_regions_health_equity_monitor" VARCHAR,
"education_level" VARCHAR,
"residence_area_type" VARCHAR,
"antenatal_care_coverage_at_least_four_visits_in_the_fi_cfc9057e" FLOAT,
"antenatal_care_coverage_at_least_four_visits_in_the_fi_b8c997b2" FLOAT,
"antenatal_care_coverage_at_least_four_visits_in_the_fi_7b3ee55a" FLOAT,
"comments" VARCHAR
);
CREATE TABLE owid_antenatal_care_coverage_at_least_four_visits_pct_1 (
"year" INTEGER,
"country" VARCHAR,
"antenatal_care_coverage_at_least_four_visits_pct" FLOAT,
"comments" VARCHAR
);
CREATE TABLE owid_antenatal_care_coverage_at_least_four_visits_pct_2 (
"year" INTEGER,
"country" VARCHAR,
"antenatal_care_coverage_at_least_four_visits_pct" FLOAT,
"antenatal_care_coverage_at_least_four_visits_pct_low" VARCHAR,
"antenatal_care_coverage_at_least_four_visits_pct_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_antenatal_care_coverage_at_least_one_visit_in_the_0e0bdc03 (
"year" INTEGER,
"country" VARCHAR,
"age_group" VARCHAR,
"wealth_decile" VARCHAR,
"wealth_quintile" VARCHAR,
"residence_area_type" VARCHAR,
"dhs_mics_subnational_regions_health_equity_monitor" VARCHAR,
"education_level" VARCHAR,
"antenatal_care_coverage_at_least_one_visit_in_the_five_2037813b" FLOAT,
"antenatal_care_coverage_at_least_one_visit_in_the_five_da3fe0dd" FLOAT,
"antenatal_care_coverage_at_least_one_visit_in_the_five_4b51fdf7" FLOAT,
"comments" VARCHAR
);
Anyone who has the link will be able to view this.