Global Health Observatory - World Health Organization
@owid.gho
@owid.gho
CREATE TABLE owid_antenatal_care_coverage_at_least_one_visit_in_the_68c45cb0 (
"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_one_visit_in_the_five_2037813b" FLOAT,
"comments" VARCHAR
);
CREATE TABLE owid_antenatal_care_coverage_at_least_one_visit_in_the_af043979 (
"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_one_visit_in_the_two__893c42fd" FLOAT,
"comments" VARCHAR
);
CREATE TABLE owid_antenatal_care_coverage_at_least_one_visit_pct_1 (
"year" INTEGER,
"country" VARCHAR,
"antenatal_care_coverage_at_least_one_visit_pct" FLOAT,
"comments" VARCHAR
);
CREATE TABLE owid_antenatal_care_coverage_at_least_one_visit_pct_2 (
"year" INTEGER,
"country" VARCHAR,
"antenatal_care_coverage_at_least_one_visit_pct" FLOAT,
"antenatal_care_coverage_at_least_one_visit_pct_low" VARCHAR,
"antenatal_care_coverage_at_least_one_visit_pct_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_antiretroviral_therapy_coverage_among_people_with_41e9e0c6 (
"year" INTEGER,
"country" VARCHAR,
"antiretroviral_therapy_coverage_among_people_with_adva_c5c16bb0" INTEGER,
"antiretroviral_therapy_coverage_among_people_with_adva_5df16293" INTEGER,
"antiretroviral_therapy_coverage_among_people_with_adva_021179b5" INTEGER,
"comments" VARCHAR
);
CREATE TABLE owid_antiretroviral_therapy_coverage_among_people_with_710cb6b7 (
"year" INTEGER,
"country" VARCHAR,
"antiretroviral_therapy_coverage_among_people_with_adva_c5c16bb0" INTEGER
);
CREATE TABLE owid_antiretroviral_therapy_coverage_among_people_with_73702099 (
"year" INTEGER,
"country" VARCHAR,
"antiretroviral_therapy_coverage_among_people_with_hiv__9279127d" FLOAT,
"antiretroviral_therapy_coverage_among_people_with_hiv__7fe39a2c" FLOAT,
"antiretroviral_therapy_coverage_among_people_with_hiv__56f4b081" FLOAT,
"comments" VARCHAR
);
CREATE TABLE owid_antiretroviral_therapy_coverage_among_people_with_b80fb381 (
"year" INTEGER,
"country" VARCHAR,
"antiretroviral_therapy_coverage_among_people_with_hiv__9279127d" FLOAT,
"comments" VARCHAR
);
CREATE TABLE owid_anti_tobacco_mass_media_campaigns_1 (
"year" INTEGER,
"country" VARCHAR,
"anti_tobacco_mass_media_campaigns" INTEGER
);
CREATE TABLE owid_anti_tobacco_mass_media_campaigns_2 (
"year" INTEGER,
"country" VARCHAR,
"anti_tobacco_mass_media_campaigns" INTEGER,
"anti_tobacco_mass_media_campaigns_low" VARCHAR,
"anti_tobacco_mass_media_campaigns_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_any_antenatal_iron_supplementation_pct (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"any_antenatal_iron_supplementation_pct" FLOAT,
"comments" VARCHAR
);
CREATE TABLE owid_appearance_of_tobacco_products_in_tv_and_or_films_1 (
"year" INTEGER,
"country" VARCHAR,
"comments" VARCHAR,
"appearance_of_tobacco_products_in_tv_and_or_films" VARCHAR
);
CREATE TABLE owid_appearance_of_tobacco_products_in_tv_and_or_films_2 (
"year" INTEGER,
"country" VARCHAR,
"appearance_of_tobacco_products_in_tv_and_or_films" VARCHAR,
"appearance_of_tobacco_products_in_tv_and_or_films_low" VARCHAR,
"appearance_of_tobacco_products_in_tv_and_or_films_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_applicability_of_national_motorcycle_helmet_law_t_be0a330f (
"year" INTEGER,
"country" VARCHAR,
"motorcycle_occupant_type" VARCHAR,
"applicability_of_national_motorcycle_helmet_law_to_all_9b4ded05" VARCHAR,
"applicability_of_national_motorcycle_helmet_law_to_all_62e977cf" VARCHAR,
"applicability_of_national_motorcycle_helmet_law_to_all_c5ba7d8d" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_applicability_of_national_motorcycle_helmet_law_t_f9fc6312 (
"year" INTEGER,
"country" VARCHAR,
"motorcycle_occupant_type" VARCHAR,
"comments" VARCHAR,
"applicability_of_national_motorcycle_helmet_law_to_all_9b4ded05" VARCHAR
);
CREATE TABLE owid_at_least_one_national_mass_media_campaign_ran_dur_0708452d (
"year" INTEGER,
"country" VARCHAR,
"at_least_one_national_mass_media_campaign_ran_during_t_7c80e167" VARCHAR,
"at_least_one_national_mass_media_campaign_ran_during_t_b5c55df3" VARCHAR,
"at_least_one_national_mass_media_campaign_ran_during_t_5195bf38" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_at_least_one_national_mass_media_campaign_ran_dur_e6af6ebb (
"year" INTEGER,
"country" VARCHAR,
"comments" VARCHAR,
"at_least_one_national_mass_media_campaign_ran_during_t_7c80e167" VARCHAR
);
CREATE TABLE owid_attributable_fraction_of_diarrhoea_to_inadequate__6eadd12c (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"age_group" VARCHAR,
"attributable_fraction_of_diarrhoea_to_inadequate_sanitation" FLOAT
);
CREATE TABLE owid_attributable_fraction_of_diarrhoea_to_inadequate__759ce780 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"age_group" VARCHAR,
"attributable_fraction_of_diarrhoea_to_inadequate_water_c66b44b4" FLOAT,
"attributable_fraction_of_diarrhoea_to_inadequate_water_119da944" FLOAT,
"attributable_fraction_of_diarrhoea_to_inadequate_water_3217c4c0" FLOAT,
"comments" VARCHAR
);
CREATE TABLE owid_attributable_fraction_of_diarrhoea_to_inadequate__861734d5 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"age_group" VARCHAR,
"attributable_fraction_of_diarrhoea_to_inadequate_water_c66b44b4" FLOAT
);
CREATE TABLE owid_attributable_fraction_of_diarrhoea_to_inadequate__ed4fc0a9 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"age_group" VARCHAR,
"attributable_fraction_of_diarrhoea_to_inadequate_sanitation" FLOAT,
"attributable_fraction_of_diarrhoea_to_inadequate_sanitation_low" FLOAT,
"attributable_fraction_of_diarrhoea_to_inadequate_sanit_6c543bca" FLOAT,
"comments" VARCHAR
);
CREATE TABLE owid_attributable_fraction_of_diarrhoea_to_inadequate_hygiene_1 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"age_group" VARCHAR,
"attributable_fraction_of_diarrhoea_to_inadequate_hygiene" FLOAT
);
CREATE TABLE owid_attributable_fraction_of_diarrhoea_to_inadequate_hygiene_2 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"age_group" VARCHAR,
"attributable_fraction_of_diarrhoea_to_inadequate_hygiene" FLOAT,
"attributable_fraction_of_diarrhoea_to_inadequate_hygiene_low" FLOAT,
"attributable_fraction_of_diarrhoea_to_inadequate_hygiene_high" FLOAT,
"comments" VARCHAR
);
CREATE TABLE owid_attributable_fraction_of_diarrhoea_to_inadequate_water_1 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"age_group" VARCHAR,
"attributable_fraction_of_diarrhoea_to_inadequate_water" FLOAT
);
CREATE TABLE owid_attributable_fraction_of_diarrhoea_to_inadequate_water_2 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"age_group" VARCHAR,
"attributable_fraction_of_diarrhoea_to_inadequate_water" FLOAT,
"attributable_fraction_of_diarrhoea_to_inadequate_water_low" FLOAT,
"attributable_fraction_of_diarrhoea_to_inadequate_water_high" FLOAT,
"comments" VARCHAR
);
Anyone who has the link will be able to view this.