Global Health Observatory - World Health Organization

CREATE TABLE owid_proportion_of_ever_partnered_women_and_girls_aged_4b990553 (
  "year" INTEGER,
  "country" VARCHAR,
  "proportion_of_ever_partnered_women_and_girls_aged_15_4_1d396cee" INTEGER  -- Proportion Of Ever Partnered Women And Girls Aged 15–49 Years Subjected To Physical And Or Sexual Violence By A Current Or Former Intimate Partner In Their Lifetime
);

CREATE TABLE owid_proportion_of_ever_partnered_women_and_girls_aged_6cfd79d8 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "proportion_of_ever_partnered_women_and_girls_aged_15_4_6677e762" FLOAT  -- Proportion Of Ever Partnered Women And Girls Aged 15–49 Years Subjected To Physical And Or Sexual Violence By A Current Or Former Intimate Partner In The Previous 12 Months,
  "comments" VARCHAR
);

CREATE TABLE owid_proportion_of_ever_partnered_women_and_girls_aged_8cc830f1 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "proportion_of_ever_partnered_women_and_girls_aged_15_4_6677e762" FLOAT  -- Proportion Of Ever Partnered Women And Girls Aged 15–49 Years Subjected To Physical And Or Sexual Violence By A Current Or Former Intimate Partner In The Previous 12 Months,
  "proportion_of_ever_partnered_women_and_girls_aged_15_4_f3efe3fb" INTEGER  -- Proportion Of Ever Partnered Women And Girls Aged 15–49 Years Subjected To Physical And Or Sexual Violence By A Current Or Former Intimate Partner In The Previous 12 Months Low,
  "proportion_of_ever_partnered_women_and_girls_aged_15_4_2e080699" INTEGER  -- Proportion Of Ever Partnered Women And Girls Aged 15–49 Years Subjected To Physical And Or Sexual Violence By A Current Or Former Intimate Partner In The Previous 12 Months High,
  "comments" VARCHAR
);

CREATE TABLE owid_proportion_of_girls_and_women_aged_15_49_years_wh_1f49c93c (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "residence_area_type" VARCHAR,
  "wealth_quintile" VARCHAR,
  "proportion_of_girls_and_women_aged_15_49_years_who_hav_32b14db4" FLOAT  -- Proportion Of Girls And Women Aged 15–49 Years Who Have Undergone Female Genital Mutilation Cutting, Fmg C, Pct,
  "comments" VARCHAR
);

CREATE TABLE owid_proportion_of_girls_and_women_aged_15_49_years_wh_f9cc7ad4 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "residence_area_type" VARCHAR,
  "wealth_quintile" VARCHAR,
  "proportion_of_girls_and_women_aged_15_49_years_who_hav_32b14db4" FLOAT  -- Proportion Of Girls And Women Aged 15–49 Years Who Have Undergone Female Genital Mutilation Cutting, Fmg C, Pct,
  "proportion_of_girls_and_women_aged_15_49_years_who_hav_2ced8234" VARCHAR  -- Proportion Of Girls And Women Aged 15–49 Years Who Have Undergone Female Genital Mutilation Cutting, Fmg C, Pct Low,
  "proportion_of_girls_and_women_aged_15_49_years_who_hav_e7df0c39" VARCHAR  -- Proportion Of Girls And Women Aged 15–49 Years Who Have Undergone Female Genital Mutilation Cutting, Fmg C, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_proportion_of_health_facilities_with_a_core_set_o_19e45857 (
  "year" INTEGER,
  "country" VARCHAR,
  "proportion_of_health_facilities_with_a_core_set_of_rel_ec18ca70" FLOAT  -- Proportion Of Health Facilities With A Core Set Of Relevant Essential Medicines Available And Affordable On A Sustainable Basis,
  "comments" VARCHAR
);

CREATE TABLE owid_proportion_of_health_facilities_with_a_core_set_o_f5b732c9 (
  "year" INTEGER,
  "country" VARCHAR,
  "proportion_of_health_facilities_with_a_core_set_of_rel_ec18ca70" FLOAT  -- Proportion Of Health Facilities With A Core Set Of Relevant Essential Medicines Available And Affordable On A Sustainable Basis,
  "proportion_of_health_facilities_with_a_core_set_of_rel_5821f2c1" VARCHAR  -- Proportion Of Health Facilities With A Core Set Of Relevant Essential Medicines Available And Affordable On A Sustainable Basis Low,
  "proportion_of_health_facilities_with_a_core_set_of_rel_52f19193" VARCHAR  -- Proportion Of Health Facilities With A Core Set Of Relevant Essential Medicines Available And Affordable On A Sustainable Basis High,
  "comments" VARCHAR
);

CREATE TABLE owid_proportion_of_isolates_with_decreased_susceptibil_10eb5ea9 (
  "year" INTEGER,
  "country" VARCHAR,
  "proportion_of_isolates_with_decreased_susceptibility_o_d49dcc6b" FLOAT  -- Proportion Of Isolates With Decreased Susceptibility Or Resistance, Ds R, To Cefixime Reported To Who Gasp,
  "comments" VARCHAR
);

CREATE TABLE owid_proportion_of_isolates_with_decreased_susceptibil_36765e24 (
  "year" INTEGER,
  "country" VARCHAR,
  "proportion_of_isolates_with_decreased_susceptibility_o_6b860dbe" FLOAT  -- Proportion Of Isolates With Decreased Susceptibility Or Resistance, Ds R, To Extended Spectrum Cephalosporins Reported To Who Gasp,
  "proportion_of_isolates_with_decreased_susceptibility_o_343bb160" VARCHAR  -- Proportion Of Isolates With Decreased Susceptibility Or Resistance, Ds R, To Extended Spectrum Cephalosporins Reported To Who Gasp Low,
  "proportion_of_isolates_with_decreased_susceptibility_o_0ccafaf2" VARCHAR  -- Proportion Of Isolates With Decreased Susceptibility Or Resistance, Ds R, To Extended Spectrum Cephalosporins Reported To Who Gasp High,
  "comments" VARCHAR
);

CREATE TABLE owid_proportion_of_isolates_with_decreased_susceptibil_4c33bd45 (
  "year" INTEGER,
  "country" VARCHAR,
  "proportion_of_isolates_with_decreased_susceptibility_o_600859c4" FLOAT  -- Proportion Of Isolates With Decreased Susceptibility Or Resistance, Ds R, To Ceftriaxone Reported To Who Gasp,
  "proportion_of_isolates_with_decreased_susceptibility_o_394097db" VARCHAR  -- Proportion Of Isolates With Decreased Susceptibility Or Resistance, Ds R, To Ceftriaxone Reported To Who Gasp Low,
  "proportion_of_isolates_with_decreased_susceptibility_o_b6e7bd8f" VARCHAR  -- Proportion Of Isolates With Decreased Susceptibility Or Resistance, Ds R, To Ceftriaxone Reported To Who Gasp High,
  "comments" VARCHAR
);

CREATE TABLE owid_proportion_of_isolates_with_decreased_susceptibil_91b82cd2 (
  "year" INTEGER,
  "country" VARCHAR,
  "proportion_of_isolates_with_decreased_susceptibility_o_600859c4" FLOAT  -- Proportion Of Isolates With Decreased Susceptibility Or Resistance, Ds R, To Ceftriaxone Reported To Who Gasp,
  "comments" VARCHAR
);

CREATE TABLE owid_proportion_of_isolates_with_decreased_susceptibil_9f1b913a (
  "year" INTEGER,
  "country" VARCHAR,
  "proportion_of_isolates_with_decreased_susceptibility_o_6b860dbe" FLOAT  -- Proportion Of Isolates With Decreased Susceptibility Or Resistance, Ds R, To Extended Spectrum Cephalosporins Reported To Who Gasp,
  "comments" VARCHAR
);

CREATE TABLE owid_proportion_of_isolates_with_decreased_susceptibil_f3c27c34 (
  "year" INTEGER,
  "country" VARCHAR,
  "proportion_of_isolates_with_decreased_susceptibility_o_d49dcc6b" FLOAT  -- Proportion Of Isolates With Decreased Susceptibility Or Resistance, Ds R, To Cefixime Reported To Who Gasp,
  "proportion_of_isolates_with_decreased_susceptibility_o_68786fed" VARCHAR  -- Proportion Of Isolates With Decreased Susceptibility Or Resistance, Ds R, To Cefixime Reported To Who Gasp Low,
  "proportion_of_isolates_with_decreased_susceptibility_o_1e6752f4" VARCHAR  -- Proportion Of Isolates With Decreased Susceptibility Or Resistance, Ds R, To Cefixime Reported To Who Gasp High,
  "comments" VARCHAR
);

CREATE TABLE owid_proportion_of_isolates_with_resistance_to_azithro_1a753e57 (
  "year" INTEGER,
  "country" VARCHAR,
  "proportion_of_isolates_with_resistance_to_azithromycin_11a96600" FLOAT  -- Proportion Of Isolates With Resistance To Azithromycin Reported To Who Gasp,
  "proportion_of_isolates_with_resistance_to_azithromycin_b094b37d" VARCHAR  -- Proportion Of Isolates With Resistance To Azithromycin Reported To Who Gasp Low,
  "proportion_of_isolates_with_resistance_to_azithromycin_3682ab64" VARCHAR  -- Proportion Of Isolates With Resistance To Azithromycin Reported To Who Gasp High,
  "comments" VARCHAR
);

CREATE TABLE owid_proportion_of_isolates_with_resistance_to_azithro_cdce4179 (
  "year" INTEGER,
  "country" VARCHAR,
  "proportion_of_isolates_with_resistance_to_azithromycin_11a96600" FLOAT  -- Proportion Of Isolates With Resistance To Azithromycin Reported To Who Gasp,
  "comments" VARCHAR
);

CREATE TABLE owid_proportion_of_isolates_with_resistance_to_ciprofl_07863681 (
  "year" INTEGER,
  "country" VARCHAR,
  "proportion_of_isolates_with_resistance_to_ciprofloxaci_b4ee78f9" FLOAT  -- Proportion Of Isolates With Resistance To Ciprofloxacin Reported To Who Gasp,
  "comments" VARCHAR
);

CREATE TABLE owid_proportion_of_isolates_with_resistance_to_ciprofl_e167dfc9 (
  "year" INTEGER,
  "country" VARCHAR,
  "proportion_of_isolates_with_resistance_to_ciprofloxaci_b4ee78f9" FLOAT  -- Proportion Of Isolates With Resistance To Ciprofloxacin Reported To Who Gasp,
  "proportion_of_isolates_with_resistance_to_ciprofloxaci_1d5cc213" VARCHAR  -- Proportion Of Isolates With Resistance To Ciprofloxacin Reported To Who Gasp Low,
  "proportion_of_isolates_with_resistance_to_ciprofloxaci_1ba5626f" VARCHAR  -- Proportion Of Isolates With Resistance To Ciprofloxacin Reported To Who Gasp High,
  "comments" VARCHAR
);

CREATE TABLE owid_proportion_of_newborns_who_have_postnatal_contact_3bdca3ab (
  "year" INTEGER,
  "country" VARCHAR,
  "proportion_of_newborns_who_have_postnatal_contact_with_584eef20" FLOAT  -- Proportion Of Newborns Who Have Postnatal Contact With A Health Provider Within 2 Days Of Delivery, Pct,
  "comments" VARCHAR
);

CREATE TABLE owid_proportion_of_newborns_who_have_postnatal_contact_60b4f51c (
  "year" INTEGER,
  "country" VARCHAR,
  "proportion_of_newborns_who_have_postnatal_contact_with_584eef20" FLOAT  -- Proportion Of Newborns Who Have Postnatal Contact With A Health Provider Within 2 Days Of Delivery, Pct,
  "proportion_of_newborns_who_have_postnatal_contact_with_fba84d4b" VARCHAR  -- Proportion Of Newborns Who Have Postnatal Contact With A Health Provider Within 2 Days Of Delivery, Pct Low,
  "proportion_of_newborns_who_have_postnatal_contact_with_36843ed5" VARCHAR  -- Proportion Of Newborns Who Have Postnatal Contact With A Health Provider Within 2 Days Of Delivery, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_proportion_of_population_below_the_international__0016dd69 (
  "year" INTEGER,
  "country" VARCHAR,
  "proportion_of_population_below_the_international_pover_c332e1dd" FLOAT  -- Proportion Of Population Below The International Poverty Line Of Usd1–90 Per Day, Pct,
  "proportion_of_population_below_the_international_pover_eed6bd51" VARCHAR  -- Proportion Of Population Below The International Poverty Line Of Usd1–90 Per Day, Pct Low,
  "proportion_of_population_below_the_international_pover_b47621b2" VARCHAR  -- Proportion Of Population Below The International Poverty Line Of Usd1–90 Per Day, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_proportion_of_population_below_the_international__8ccbad67 (
  "year" INTEGER,
  "country" VARCHAR,
  "proportion_of_population_below_the_international_pover_c332e1dd" FLOAT  -- Proportion Of Population Below The International Poverty Line Of Usd1–90 Per Day, Pct,
  "comments" VARCHAR
);

CREATE TABLE owid_proportion_of_population_with_primary_reliance_on_62fcf4d9 (
  "year" INTEGER,
  "country" VARCHAR,
  "residence_area_type" VARCHAR,
  "cooking_fuel" VARCHAR,
  "proportion_of_population_with_primary_reliance_on_fuel_8cc8a53c" FLOAT  -- Proportion Of Population With Primary Reliance On Fuels And Technologies For Cooking, By Fuel Type, Pct
);

CREATE TABLE owid_proportion_of_population_with_primary_reliance_on_7ab10076 (
  "year" INTEGER,
  "country" VARCHAR,
  "residence_area_type" VARCHAR,
  "proportion_of_population_with_primary_reliance_on_poll_787bdf98" FLOAT  -- Proportion Of Population With Primary Reliance On Polluting Fuels And Technologies For Cooking, Pct,
  "proportion_of_population_with_primary_reliance_on_poll_b318daf4" FLOAT  -- Proportion Of Population With Primary Reliance On Polluting Fuels And Technologies For Cooking, Pct Low,
  "proportion_of_population_with_primary_reliance_on_poll_3035c1e8" FLOAT  -- Proportion Of Population With Primary Reliance On Polluting Fuels And Technologies For Cooking, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_proportion_of_population_with_primary_reliance_on_9348fb66 (
  "year" INTEGER,
  "country" VARCHAR,
  "residence_area_type" VARCHAR,
  "proportion_of_population_with_primary_reliance_on_clea_e8b41727" FLOAT  -- Proportion Of Population With Primary Reliance On Clean Fuels And Technologies For Cooking, Pct,
  "proportion_of_population_with_primary_reliance_on_clea_e498657e" FLOAT  -- Proportion Of Population With Primary Reliance On Clean Fuels And Technologies For Cooking, Pct Low,
  "proportion_of_population_with_primary_reliance_on_clea_c67273a5" FLOAT  -- Proportion Of Population With Primary Reliance On Clean Fuels And Technologies For Cooking, Pct High,
  "comments" VARCHAR,
  "proportion_of_population_without_primary_reliance_on_c_3631e791" FLOAT  -- Proportion Of Population Without Primary Reliance On Clean Fuels And Technologies For Cooking, Pct
);

CREATE TABLE owid_proportion_of_population_with_primary_reliance_on_a624a025 (
  "year" INTEGER,
  "country" VARCHAR,
  "residence_area_type" VARCHAR,
  "proportion_of_population_with_primary_reliance_on_clea_e8b41727" FLOAT  -- Proportion Of Population With Primary Reliance On Clean Fuels And Technologies For Cooking, Pct,
  "proportion_of_population_without_primary_reliance_on_c_3631e791" FLOAT  -- Proportion Of Population Without Primary Reliance On Clean Fuels And Technologies For Cooking, Pct
);