Global Health Observatory - World Health Organization

CREATE TABLE owid_promoting_the_development_and_adoption_of_mhealth_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "promoting_the_development_and_adoption_of_mhealth" VARCHAR
);

CREATE TABLE owid_promoting_the_development_and_adoption_of_mhealth_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "promoting_the_development_and_adoption_of_mhealth" VARCHAR,
  "promoting_the_development_and_adoption_of_mhealth_low" VARCHAR,
  "promoting_the_development_and_adoption_of_mhealth_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_proportion_of_bloodstream_infection_due_to_escher_301652b5 (
  "year" INTEGER,
  "country" VARCHAR,
  "proportion_of_bloodstream_infection_due_to_escherichia_efb14f01" FLOAT  -- Proportion Of Bloodstream Infection Due To Escherichia Coli Resistant To Third Generation Cephalosporins, Pct,
  "proportion_of_bloodstream_infection_due_to_escherichia_7e2682d5" VARCHAR  -- Proportion Of Bloodstream Infection Due To Escherichia Coli Resistant To Third Generation Cephalosporins, Pct Low,
  "proportion_of_bloodstream_infection_due_to_escherichia_486ef232" VARCHAR  -- Proportion Of Bloodstream Infection Due To Escherichia Coli Resistant To Third Generation Cephalosporins, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_proportion_of_bloodstream_infection_due_to_escher_95ae684c (
  "year" INTEGER,
  "country" VARCHAR,
  "proportion_of_bloodstream_infection_due_to_escherichia_efb14f01" FLOAT  -- Proportion Of Bloodstream Infection Due To Escherichia Coli Resistant To Third Generation Cephalosporins, Pct,
  "comments" VARCHAR
);

CREATE TABLE owid_proportion_of_bloodstream_infection_due_to_methic_af102da2 (
  "year" INTEGER,
  "country" VARCHAR,
  "proportion_of_bloodstream_infection_due_to_methicillin_31043925" FLOAT  -- Proportion Of Bloodstream Infection Due To Methicillin Resistant Staphylococcus Aureus, Mrsa, Pct,
  "comments" VARCHAR
);

CREATE TABLE owid_proportion_of_bloodstream_infection_due_to_methic_caa8a261 (
  "year" INTEGER,
  "country" VARCHAR,
  "proportion_of_bloodstream_infection_due_to_methicillin_31043925" FLOAT  -- Proportion Of Bloodstream Infection Due To Methicillin Resistant Staphylococcus Aureus, Mrsa, Pct,
  "proportion_of_bloodstream_infection_due_to_methicillin_20041628" VARCHAR  -- Proportion Of Bloodstream Infection Due To Methicillin Resistant Staphylococcus Aureus, Mrsa, Pct Low,
  "proportion_of_bloodstream_infection_due_to_methicillin_c8e73aae" VARCHAR  -- Proportion Of Bloodstream Infection Due To Methicillin Resistant Staphylococcus Aureus, Mrsa, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_proportion_of_children_aged_6_23_months_who_recei_b25a5d84 (
  "year" INTEGER,
  "country" VARCHAR,
  "proportion_of_children_aged_6_23_months_who_receive_a__82d56dc9" FLOAT  -- Proportion Of Children Aged 6–23 Months Who Receive A Minimum Acceptable Diet,
  "comments" VARCHAR
);

CREATE TABLE owid_proportion_of_children_aged_6_23_months_who_recei_f0017f5d (
  "year" INTEGER,
  "country" VARCHAR,
  "proportion_of_children_aged_6_23_months_who_receive_a__82d56dc9" FLOAT  -- Proportion Of Children Aged 6–23 Months Who Receive A Minimum Acceptable Diet,
  "proportion_of_children_aged_6_23_months_who_receive_a__78112928" VARCHAR  -- Proportion Of Children Aged 6–23 Months Who Receive A Minimum Acceptable Diet Low,
  "proportion_of_children_aged_6_23_months_who_receive_a__cfd7f7c1" VARCHAR  -- Proportion Of Children Aged 6–23 Months Who Receive A Minimum Acceptable Diet High,
  "comments" VARCHAR
);

CREATE TABLE owid_proportion_of_children_at_the_end_of_lower_second_41ca8416 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "proportion_of_children_at_the_end_of_lower_secondary_a_44a80e12" FLOAT  -- Proportion Of Children At The End Of Lower Secondary Achieving At Least A Minimum Proficiency Level In Reading, Pct
);

CREATE TABLE owid_proportion_of_children_at_the_end_of_lower_second_74a9309f (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "proportion_of_children_at_the_end_of_lower_secondary_a_f95d7853" FLOAT  -- Proportion Of Children At The End Of Lower Secondary Achieving At Least A Minimum Proficiency Level In Mathematics, Pct,
  "proportion_of_children_at_the_end_of_lower_secondary_a_a7116e73" VARCHAR  -- Proportion Of Children At The End Of Lower Secondary Achieving At Least A Minimum Proficiency Level In Mathematics, Pct Low,
  "proportion_of_children_at_the_end_of_lower_secondary_a_dcfd6671" VARCHAR  -- Proportion Of Children At The End Of Lower Secondary Achieving At Least A Minimum Proficiency Level In Mathematics, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_proportion_of_children_at_the_end_of_lower_second_b19f1b9d (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "proportion_of_children_at_the_end_of_lower_secondary_a_f95d7853" FLOAT  -- Proportion Of Children At The End Of Lower Secondary Achieving At Least A Minimum Proficiency Level In Mathematics, Pct
);

CREATE TABLE owid_proportion_of_children_at_the_end_of_lower_second_c69b7705 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "proportion_of_children_at_the_end_of_lower_secondary_a_44a80e12" FLOAT  -- Proportion Of Children At The End Of Lower Secondary Achieving At Least A Minimum Proficiency Level In Reading, Pct,
  "proportion_of_children_at_the_end_of_lower_secondary_a_97702d10" VARCHAR  -- Proportion Of Children At The End Of Lower Secondary Achieving At Least A Minimum Proficiency Level In Reading, Pct Low,
  "proportion_of_children_at_the_end_of_lower_secondary_a_6aeae3a8" VARCHAR  -- Proportion Of Children At The End Of Lower Secondary Achieving At Least A Minimum Proficiency Level In Reading, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_proportion_of_children_at_the_end_of_primary_achi_0e5edbbd (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "proportion_of_children_at_the_end_of_primary_achieving_1445272f" FLOAT  -- Proportion Of Children At The End Of Primary Achieving At Least A Minimum Proficiency Level In Mathematics, Pct,
  "proportion_of_children_at_the_end_of_primary_achieving_5af4f3fa" VARCHAR  -- Proportion Of Children At The End Of Primary Achieving At Least A Minimum Proficiency Level In Mathematics, Pct Low,
  "proportion_of_children_at_the_end_of_primary_achieving_4eb6d1b6" VARCHAR  -- Proportion Of Children At The End Of Primary Achieving At Least A Minimum Proficiency Level In Mathematics, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_proportion_of_children_at_the_end_of_primary_achi_3894cadf (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "proportion_of_children_at_the_end_of_primary_achieving_1445272f" FLOAT  -- Proportion Of Children At The End Of Primary Achieving At Least A Minimum Proficiency Level In Mathematics, Pct
);

CREATE TABLE owid_proportion_of_children_at_the_end_of_primary_achi_9841e7f5 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "proportion_of_children_at_the_end_of_primary_achieving_a2953809" FLOAT  -- Proportion Of Children At The End Of Primary Achieving At Least A Minimum Proficiency Level In Reading, Pct,
  "proportion_of_children_at_the_end_of_primary_achieving_8e8bc972" VARCHAR  -- Proportion Of Children At The End Of Primary Achieving At Least A Minimum Proficiency Level In Reading, Pct Low,
  "proportion_of_children_at_the_end_of_primary_achieving_e550d40b" VARCHAR  -- Proportion Of Children At The End Of Primary Achieving At Least A Minimum Proficiency Level In Reading, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_proportion_of_children_at_the_end_of_primary_achi_d46a48d7 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "proportion_of_children_at_the_end_of_primary_achieving_a2953809" FLOAT  -- Proportion Of Children At The End Of Primary Achieving At Least A Minimum Proficiency Level In Reading, Pct
);

CREATE TABLE owid_proportion_of_children_in_grades_2_3_achieving_at_0649da69 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "proportion_of_children_in_grades_2_3_achieving_at_leas_07c1c7b7" FLOAT  -- Proportion Of Children In Grades 2–3 Achieving At Least A Minimum Proficiency Level In Reading, Pct
);

CREATE TABLE owid_proportion_of_children_in_grades_2_3_achieving_at_10e474ea (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "proportion_of_children_in_grades_2_3_achieving_at_leas_2f56c0bd" FLOAT  -- Proportion Of Children In Grades 2–3 Achieving At Least A Minimum Proficiency Level In Mathematics, Pct
);

CREATE TABLE owid_proportion_of_children_in_grades_2_3_achieving_at_749f1cba (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "proportion_of_children_in_grades_2_3_achieving_at_leas_2f56c0bd" FLOAT  -- Proportion Of Children In Grades 2–3 Achieving At Least A Minimum Proficiency Level In Mathematics, Pct,
  "proportion_of_children_in_grades_2_3_achieving_at_leas_f03fbe12" VARCHAR  -- Proportion Of Children In Grades 2–3 Achieving At Least A Minimum Proficiency Level In Mathematics, Pct Low,
  "proportion_of_children_in_grades_2_3_achieving_at_leas_dfc06abe" VARCHAR  -- Proportion Of Children In Grades 2–3 Achieving At Least A Minimum Proficiency Level In Mathematics, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_proportion_of_children_in_grades_2_3_achieving_at_d4b31662 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "proportion_of_children_in_grades_2_3_achieving_at_leas_07c1c7b7" FLOAT  -- Proportion Of Children In Grades 2–3 Achieving At Least A Minimum Proficiency Level In Reading, Pct,
  "proportion_of_children_in_grades_2_3_achieving_at_leas_f295ba56" VARCHAR  -- Proportion Of Children In Grades 2–3 Achieving At Least A Minimum Proficiency Level In Reading, Pct Low,
  "proportion_of_children_in_grades_2_3_achieving_at_leas_2ffec506" VARCHAR  -- Proportion Of Children In Grades 2–3 Achieving At Least A Minimum Proficiency Level In Reading, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_proportion_of_countries_that_have_conducted_at_le_a6c335ed (
  "year" INTEGER,
  "country" VARCHAR,
  "proportion_of_countries_that_have_conducted_at_least_o_729d806e" FLOAT  -- Proportion Of Countries That Have Conducted At Least One Population And Housing Census In The Last 10 Years, Pct,
  "comments" VARCHAR
);

CREATE TABLE owid_proportion_of_countries_that_have_conducted_at_le_dbc9b837 (
  "year" INTEGER,
  "country" VARCHAR,
  "proportion_of_countries_that_have_conducted_at_least_o_729d806e" FLOAT  -- Proportion Of Countries That Have Conducted At Least One Population And Housing Census In The Last 10 Years, Pct,
  "proportion_of_countries_that_have_conducted_at_least_o_142eeb01" VARCHAR  -- Proportion Of Countries That Have Conducted At Least One Population And Housing Census In The Last 10 Years, Pct Low,
  "proportion_of_countries_that_have_conducted_at_least_o_11d3cf6d" VARCHAR  -- Proportion Of Countries That Have Conducted At Least One Population And Housing Census In The Last 10 Years, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_proportion_of_donor_non_public_development_funding_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "proportion_of_donor_non_public_development_funding" VARCHAR
);

CREATE TABLE owid_proportion_of_donor_non_public_development_funding_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "proportion_of_donor_non_public_development_funding" VARCHAR,
  "proportion_of_donor_non_public_development_funding_low" VARCHAR,
  "proportion_of_donor_non_public_development_funding_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_proportion_of_ever_partnered_women_and_girls_aged_110ce3b8 (
  "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,
  "proportion_of_ever_partnered_women_and_girls_aged_15_4_cc86eda5" 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 Low,
  "proportion_of_ever_partnered_women_and_girls_aged_15_4_fe8c817d" 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 High,
  "comments" VARCHAR
);