Global Health Observatory - World Health Organization

CREATE TABLE owid_donor_disbursements_million_constant_2009_usd_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "donor_disbursements_million_constant_2009_usd" FLOAT  -- Donor Disbursements, Million, Constant 2009 Usd,
  "donor_disbursements_million_constant_2009_usd_low" VARCHAR  -- Donor Disbursements, Million, Constant 2009 Usd Low,
  "donor_disbursements_million_constant_2009_usd_high" VARCHAR  -- Donor Disbursements, Million, Constant 2009 Usd High,
  "comments" VARCHAR
);

CREATE TABLE owid_donor_non_public_development_funding_for_ehealth_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "donor_non_public_development_funding_for_ehealth" VARCHAR  -- Donor, Non Public Development Funding For Ehealth
);

CREATE TABLE owid_donor_non_public_development_funding_for_ehealth_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "donor_non_public_development_funding_for_ehealth" VARCHAR  -- Donor, Non Public Development Funding For Ehealth,
  "donor_non_public_development_funding_for_ehealth_low" VARCHAR  -- Donor, Non Public Development Funding For Ehealth Low,
  "donor_non_public_development_funding_for_ehealth_high" VARCHAR  -- Donor, Non Public Development Funding For Ehealth High,
  "comments" VARCHAR
);

CREATE TABLE owid_drug_courts_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "drug_courts" VARCHAR
);

CREATE TABLE owid_drug_courts_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "drug_courts" VARCHAR,
  "drug_courts_low" VARCHAR,
  "drug_courts_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_dtp3_immunization_coverage_among_one_year_olds_pct_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,
  "dtp3_immunization_coverage_among_one_year_olds_pct" FLOAT  -- Dtp3 Immunization Coverage Among One Year Olds, Pct,
  "comments" VARCHAR
);

CREATE TABLE owid_dtp3_immunization_coverage_among_one_year_olds_pct_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "wealth_decile" VARCHAR,
  "wealth_quintile" VARCHAR,
  "dhs_mics_subnational_regions_health_equity_monitor" VARCHAR  -- Dhs Mics Subnational Regions, Health Equity Monitor,
  "education_level" VARCHAR,
  "residence_area_type" VARCHAR,
  "dtp3_immunization_coverage_among_one_year_olds_pct" FLOAT  -- Dtp3 Immunization Coverage Among One Year Olds, Pct,
  "dtp3_immunization_coverage_among_one_year_olds_pct_low" FLOAT  -- Dtp3 Immunization Coverage Among One Year Olds, Pct Low,
  "dtp3_immunization_coverage_among_one_year_olds_pct_high" FLOAT  -- Dtp3 Immunization Coverage Among One Year Olds, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_duty_paid_or_excise_stamp_on_alcohol_container_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "beverage_types" VARCHAR,
  "duty_paid_or_excise_stamp_on_alcohol_container" VARCHAR
);

CREATE TABLE owid_duty_paid_or_excise_stamp_on_alcohol_container_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "beverage_types" VARCHAR,
  "duty_paid_or_excise_stamp_on_alcohol_container" VARCHAR,
  "duty_paid_or_excise_stamp_on_alcohol_container_low" VARCHAR,
  "duty_paid_or_excise_stamp_on_alcohol_container_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_early_initiation_of_breastfeeding_children_born_i_35369612 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "mothers_education_level" VARCHAR,
  "residence_area_type" VARCHAR,
  "wealth_quintile" VARCHAR,
  "household_wealth" VARCHAR,
  "early_initiation_of_breastfeeding_children_born_in_the_6591a626" FLOAT  -- Early Initiation Of Breastfeeding, Children Born In The Last 24 Months,
  "comments" VARCHAR
);

CREATE TABLE owid_early_initiation_of_breastfeeding_children_born_i_7ef1b9bf (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "household_wealth" VARCHAR,
  "wealth_quintile" VARCHAR,
  "residence_area_type" VARCHAR,
  "education_level" VARCHAR,
  "early_initiation_of_breastfeeding_children_born_in_the_6591a626" FLOAT  -- Early Initiation Of Breastfeeding, Children Born In The Last 24 Months,
  "early_initiation_of_breastfeeding_children_born_in_the_92092954" FLOAT  -- Early Initiation Of Breastfeeding, Children Born In The Last 24 Months Low,
  "early_initiation_of_breastfeeding_children_born_in_the_4ac4f8f5" FLOAT  -- Early Initiation Of Breastfeeding, Children Born In The Last 24 Months High,
  "comments" VARCHAR
);

CREATE TABLE owid_early_initiation_of_breastfeeding_in_the_two_year_69c37836 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "wealth_decile" VARCHAR,
  "wealth_quintile" VARCHAR,
  "dhs_mics_subnational_regions_health_equity_monitor" VARCHAR  -- Dhs Mics Subnational Regions, Health Equity Monitor,
  "education_level" VARCHAR,
  "residence_area_type" VARCHAR,
  "early_initiation_of_breastfeeding_in_the_two_years_pre_1e2af650" FLOAT  -- Early Initiation Of Breastfeeding, In The Two Years Preceding The Survey, Pct,
  "early_initiation_of_breastfeeding_in_the_two_years_pre_4e6d6182" FLOAT  -- Early Initiation Of Breastfeeding, In The Two Years Preceding The Survey, Pct Low,
  "early_initiation_of_breastfeeding_in_the_two_years_pre_c00a12a1" FLOAT  -- Early Initiation Of Breastfeeding, In The Two Years Preceding The Survey, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_early_initiation_of_breastfeeding_in_the_two_year_753c3b8a (
  "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,
  "early_initiation_of_breastfeeding_in_the_two_years_pre_1e2af650" FLOAT  -- Early Initiation Of Breastfeeding, In The Two Years Preceding The Survey, Pct,
  "comments" VARCHAR
);

CREATE TABLE owid_early_initiation_of_breastfeeding_pct_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "early_initiation_of_breastfeeding_pct" FLOAT  -- Early Initiation Of Breastfeeding, Pct,
  "comments" VARCHAR
);

CREATE TABLE owid_early_initiation_of_breastfeeding_pct_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "early_initiation_of_breastfeeding_pct" FLOAT  -- Early Initiation Of Breastfeeding, Pct,
  "early_initiation_of_breastfeeding_pct_low" VARCHAR  -- Early Initiation Of Breastfeeding, Pct Low,
  "early_initiation_of_breastfeeding_pct_high" VARCHAR  -- Early Initiation Of Breastfeeding, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_earned_media_public_relations_were_used_to_promot_3854b1f2 (
  "year" INTEGER,
  "country" VARCHAR,
  "earned_media_public_relations_were_used_to_promote_the_campaign" VARCHAR,
  "earned_media_public_relations_were_used_to_promote_the_6ce3aaaa" VARCHAR  -- Earned Media Public Relations Were Used To Promote The Campaign Low,
  "earned_media_public_relations_were_used_to_promote_the_efc90c8c" VARCHAR  -- Earned Media Public Relations Were Used To Promote The Campaign High,
  "comments" VARCHAR
);

CREATE TABLE owid_earned_media_public_relations_were_used_to_promot_e3ac3d51 (
  "year" INTEGER,
  "country" VARCHAR,
  "earned_media_public_relations_were_used_to_promote_the_campaign" VARCHAR
);

CREATE TABLE owid_educational_attainment_in_prevention_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "mothers_education_level" VARCHAR,
  "educational_attainment_in_prevention" VARCHAR
);

CREATE TABLE owid_educational_attainment_in_prevention_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "education_level" VARCHAR,
  "educational_attainment_in_prevention" VARCHAR,
  "educational_attainment_in_prevention_low" VARCHAR,
  "educational_attainment_in_prevention_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_educational_attainment_in_treatment_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "mothers_education_level" VARCHAR,
  "educational_attainment_in_treatment" VARCHAR
);

CREATE TABLE owid_educational_attainment_in_treatment_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "education_level" VARCHAR,
  "educational_attainment_in_treatment" VARCHAR,
  "educational_attainment_in_treatment_low" VARCHAR,
  "educational_attainment_in_treatment_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_educational_programmes_involving_target_groups_in_1709aa00 (
  "year" INTEGER,
  "country" VARCHAR,
  "educational_programmes_involving_target_groups_in_scho_7866f9c6" VARCHAR  -- Educational Programmes Involving Target Groups In School Curriculum,
  "educational_programmes_involving_target_groups_in_scho_f4408d1b" VARCHAR  -- Educational Programmes Involving Target Groups In School Curriculum Low,
  "educational_programmes_involving_target_groups_in_scho_4d640353" VARCHAR  -- Educational Programmes Involving Target Groups In School Curriculum High,
  "comments" VARCHAR
);

CREATE TABLE owid_educational_programmes_involving_target_groups_in_b3c7a92e (
  "year" INTEGER,
  "country" VARCHAR,
  "educational_programmes_involving_target_groups_in_scho_7866f9c6" VARCHAR  -- Educational Programmes Involving Target Groups In School Curriculum
);

CREATE TABLE owid_effective_cataract_surgical_coverage_of_adults_ag_b403aee6 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "effective_cataract_surgical_coverage_of_adults_aged_50_cb803e95" INTEGER  -- Effective Cataract Surgical Coverage Of Adults Aged 50 And Over, Pct,
  "effective_cataract_surgical_coverage_of_adults_aged_50_a6534692" VARCHAR  -- Effective Cataract Surgical Coverage Of Adults Aged 50 And Over, Pct Low,
  "effective_cataract_surgical_coverage_of_adults_aged_50_a5e2c0bf" VARCHAR  -- Effective Cataract Surgical Coverage Of Adults Aged 50 And Over, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_effective_cataract_surgical_coverage_of_adults_ag_f45ee98d (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "effective_cataract_surgical_coverage_of_adults_aged_50_cb803e95" INTEGER  -- Effective Cataract Surgical Coverage Of Adults Aged 50 And Over, Pct,
  "comments" VARCHAR
);