Global Health Observatory - World Health Organization

CREATE TABLE owid_proportion_of_population_with_primary_reliance_on_c1919771 (
  "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,
  "proportion_of_population_with_primary_reliance_on_fuel_748e458c" FLOAT  -- Proportion Of Population With Primary Reliance On Fuels And Technologies For Cooking, By Fuel Type, Pct Low,
  "proportion_of_population_with_primary_reliance_on_fuel_1e2a3262" FLOAT  -- Proportion Of Population With Primary Reliance On Fuels And Technologies For Cooking, By Fuel Type, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_proportion_of_population_with_primary_reliance_on_eb373298 (
  "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
);

CREATE TABLE owid_proportion_of_private_funding_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "proportion_of_private_funding" VARCHAR
);

CREATE TABLE owid_proportion_of_private_funding_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "proportion_of_private_funding" VARCHAR,
  "proportion_of_private_funding_low" VARCHAR,
  "proportion_of_private_funding_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_proportion_of_public_funding_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "proportion_of_public_funding" VARCHAR
);

CREATE TABLE owid_proportion_of_public_funding_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "proportion_of_public_funding" VARCHAR,
  "proportion_of_public_funding_low" VARCHAR,
  "proportion_of_public_funding_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_proportion_ofpublic_private_partnerships_funding_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "proportion_ofpublic_private_partnerships_funding" VARCHAR
);

CREATE TABLE owid_proportion_ofpublic_private_partnerships_funding_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "proportion_ofpublic_private_partnerships_funding" VARCHAR,
  "proportion_ofpublic_private_partnerships_funding_low" VARCHAR,
  "proportion_ofpublic_private_partnerships_funding_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_proportion_of_vaccination_cards_seen_pct_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "proportion_of_vaccination_cards_seen_pct" INTEGER  -- Proportion Of Vaccination Cards Seen, Pct,
  "comments" VARCHAR
);

CREATE TABLE owid_proportion_of_vaccination_cards_seen_pct_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "proportion_of_vaccination_cards_seen_pct" FLOAT  -- Proportion Of Vaccination Cards Seen, Pct,
  "proportion_of_vaccination_cards_seen_pct_low" VARCHAR  -- Proportion Of Vaccination Cards Seen, Pct Low,
  "proportion_of_vaccination_cards_seen_pct_high" VARCHAR  -- Proportion Of Vaccination Cards Seen, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_proportion_of_women_aged_15_49_years_who_make_the_e63bd2ab (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "proportion_of_women_aged_15_49_years_who_make_their_ow_cde3ce6e" FLOAT  -- Proportion Of Women Aged 15–49 Years Who Make Their Own Informed Decisions Regarding Sexual Relations, Contraceptive Use And Reproductive Health Care, Pct,
  "proportion_of_women_aged_15_49_years_who_make_their_ow_9046745a" VARCHAR  -- Proportion Of Women Aged 15–49 Years Who Make Their Own Informed Decisions Regarding Sexual Relations, Contraceptive Use And Reproductive Health Care, Pct Low,
  "proportion_of_women_aged_15_49_years_who_make_their_ow_40bf4127" VARCHAR  -- Proportion Of Women Aged 15–49 Years Who Make Their Own Informed Decisions Regarding Sexual Relations, Contraceptive Use And Reproductive Health Care, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_proportion_of_women_aged_20_24_years_who_were_mar_32568aee (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "proportion_of_women_aged_20_24_years_who_were_married__62aef505" INTEGER  -- Proportion Of Women Aged 20–24 Years Who Were Married Or In A Union By Age 18, Pct,
  "proportion_of_women_aged_20_24_years_who_were_married__4a246f01" VARCHAR  -- Proportion Of Women Aged 20–24 Years Who Were Married Or In A Union By Age 18, Pct Low,
  "proportion_of_women_aged_20_24_years_who_were_married__17b1c697" VARCHAR  -- Proportion Of Women Aged 20–24 Years Who Were Married Or In A Union By Age 18, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_proportion_of_women_aged_20_24_years_who_were_mar_bcf8cd50 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "proportion_of_women_aged_20_24_years_who_were_married__62aef505" INTEGER  -- Proportion Of Women Aged 20–24 Years Who Were Married Or In A Union By Age 18, Pct,
  "comments" VARCHAR
);

CREATE TABLE owid_proportion_of_women_aged_20_24_years_who_were_mar_f33e4d23 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "proportion_of_women_aged_20_24_years_who_were_married__1cb28a17" INTEGER  -- Proportion Of Women Aged 20–24 Years Who Were Married Or In A Union By Age 15, Pct,
  "comments" VARCHAR
);

CREATE TABLE owid_proportion_of_women_aged_20_24_years_who_were_mar_fbdb05ca (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "proportion_of_women_aged_20_24_years_who_were_married__1cb28a17" INTEGER  -- Proportion Of Women Aged 20–24 Years Who Were Married Or In A Union By Age 15, Pct,
  "proportion_of_women_aged_20_24_years_who_were_married__73d8ace9" VARCHAR  -- Proportion Of Women Aged 20–24 Years Who Were Married Or In A Union By Age 15, Pct Low,
  "proportion_of_women_aged_20_24_years_who_were_married__06ac4e64" VARCHAR  -- Proportion Of Women Aged 20–24 Years Who Were Married Or In A Union By Age 15, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_protect_from_tobacco_smoke_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "protect_from_tobacco_smoke" INTEGER
);

CREATE TABLE owid_protect_from_tobacco_smoke_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "protect_from_tobacco_smoke" INTEGER,
  "protect_from_tobacco_smoke_low" VARCHAR,
  "protect_from_tobacco_smoke_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_providing_guidance_on_privacy_and_security_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "providing_guidance_on_privacy_and_security" VARCHAR
);

CREATE TABLE owid_providing_guidance_on_privacy_and_security_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "providing_guidance_on_privacy_and_security" VARCHAR,
  "providing_guidance_on_privacy_and_security_low" VARCHAR,
  "providing_guidance_on_privacy_and_security_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_providing_incentives_and_guidance_for_innovation__38ceea97 (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "providing_incentives_and_guidance_for_innovation_resea_ea64caba" VARCHAR  -- Providing Incentives And Guidance For Innovation Research And Evaluation Of Health
);

CREATE TABLE owid_providing_incentives_and_guidance_for_innovation__432bc18e (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "providing_incentives_and_guidance_for_innovation_resea_ea64caba" VARCHAR  -- Providing Incentives And Guidance For Innovation Research And Evaluation Of Health,
  "providing_incentives_and_guidance_for_innovation_resea_e3679090" VARCHAR  -- Providing Incentives And Guidance For Innovation Research And Evaluation Of Health Low,
  "providing_incentives_and_guidance_for_innovation_resea_c89a77d4" VARCHAR  -- Providing Incentives And Guidance For Innovation Research And Evaluation Of Health High,
  "comments" VARCHAR
);

CREATE TABLE owid_providing_oversight_and_enforcement_of_data_ownership_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "providing_oversight_and_enforcement_of_data_ownership" VARCHAR
);

CREATE TABLE owid_providing_oversight_and_enforcement_of_data_ownership_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "providing_oversight_and_enforcement_of_data_ownership" VARCHAR,
  "providing_oversight_and_enforcement_of_data_ownership_low" VARCHAR,
  "providing_oversight_and_enforcement_of_data_ownership_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_provision_for_care_of_acute_stroke_and_rehabilita_8e92db08 (
  "year" INTEGER,
  "country" VARCHAR,
  "provision_for_care_of_acute_stroke_and_rehabilitation__ceebb041" VARCHAR  -- Provision For Care Of Acute Stroke And Rehabilitation In More Than 50pct Of Public Sector Health Facilities,
  "provision_for_care_of_acute_stroke_and_rehabilitation__57dd5a15" VARCHAR  -- Provision For Care Of Acute Stroke And Rehabilitation In More Than 50pct Of Public Sector Health Facilities Low,
  "provision_for_care_of_acute_stroke_and_rehabilitation__e23db504" VARCHAR  -- Provision For Care Of Acute Stroke And Rehabilitation In More Than 50pct Of Public Sector Health Facilities High,
  "comments" VARCHAR
);

CREATE TABLE owid_provision_for_care_of_acute_stroke_and_rehabilita_b1ba177c (
  "year" INTEGER,
  "country" VARCHAR,
  "provision_for_care_of_acute_stroke_and_rehabilitation__ceebb041" VARCHAR  -- Provision For Care Of Acute Stroke And Rehabilitation In More Than 50pct Of Public Sector Health Facilities
);