Global Health Observatory - World Health Organization

CREATE TABLE owid_pregnant_women_attending_antenatal_care_at_least__26d3c786 (
  "year" INTEGER,
  "country" VARCHAR,
  "pregnant_women_attending_antenatal_care_at_least_once__5063a311" FLOAT  -- Pregnant Women Attending Antenatal Care, At Least Once And Receiving At Least 3 Doses Of Intermittent Preventive Treatment Of Malaria For Pregnant Women, Iptp3, Pct
);

CREATE TABLE owid_pregnant_women_attending_antenatal_care_at_least__7162f5ba (
  "year" INTEGER,
  "country" VARCHAR,
  "pregnant_women_attending_antenatal_care_at_least_once__5063a311" FLOAT  -- Pregnant Women Attending Antenatal Care, At Least Once And Receiving At Least 3 Doses Of Intermittent Preventive Treatment Of Malaria For Pregnant Women, Iptp3, Pct,
  "pregnant_women_attending_antenatal_care_at_least_once__e63f88d1" VARCHAR  -- Pregnant Women Attending Antenatal Care, At Least Once And Receiving At Least 3 Doses Of Intermittent Preventive Treatment Of Malaria For Pregnant Women, Iptp3, Pct Low,
  "pregnant_women_attending_antenatal_care_at_least_once__f8afb438" VARCHAR  -- Pregnant Women Attending Antenatal Care, At Least Once And Receiving At Least 3 Doses Of Intermittent Preventive Treatment Of Malaria For Pregnant Women, Iptp3, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_pregnant_women_sleeping_under_insecticide_treated_05098915 (
  "year" INTEGER,
  "country" VARCHAR,
  "age_group" VARCHAR,
  "wealth_decile" VARCHAR,
  "wealth_quintile" VARCHAR,
  "residence_area_type" VARCHAR,
  "dhs_mics_subnational_regions_health_equity_monitor" VARCHAR  -- Dhs Mics Subnational Regions, Health Equity Monitor,
  "education_level" VARCHAR,
  "pregnant_women_sleeping_under_insecticide_treated_nets_pct" FLOAT  -- Pregnant Women Sleeping Under Insecticide Treated Nets, Pct,
  "pregnant_women_sleeping_under_insecticide_treated_nets_pct_low" FLOAT  -- Pregnant Women Sleeping Under Insecticide Treated Nets, Pct Low,
  "pregnant_women_sleeping_under_insecticide_treated_nets_pct_high" FLOAT  -- Pregnant Women Sleeping Under Insecticide Treated Nets, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_pregnant_women_sleeping_under_insecticide_treated_eb57fd77 (
  "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  -- Dhs Mics Subnational Regions, Health Equity Monitor,
  "wealth_decile" VARCHAR,
  "pregnant_women_sleeping_under_insecticide_treated_nets_pct" FLOAT  -- Pregnant Women Sleeping Under Insecticide Treated Nets, Pct,
  "comments" VARCHAR
);

CREATE TABLE owid_premature_deaths_due_to_noncommunicable_diseases__0aa2ae5c (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "causes" VARCHAR,
  "premature_deaths_due_to_noncommunicable_diseases_ncd_a_eb6255f4" FLOAT  -- Premature Deaths Due To Noncommunicable Diseases, Ncd, As A Proportion Of All Ncd Deaths, Pct,
  "premature_deaths_due_to_noncommunicable_diseases_ncd_a_c0466fed" VARCHAR  -- Premature Deaths Due To Noncommunicable Diseases, Ncd, As A Proportion Of All Ncd Deaths, Pct Low,
  "premature_deaths_due_to_noncommunicable_diseases_ncd_a_a3bafdf4" VARCHAR  -- Premature Deaths Due To Noncommunicable Diseases, Ncd, As A Proportion Of All Ncd Deaths, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_premature_deaths_due_to_noncommunicable_diseases__8294619e (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "causes" VARCHAR,
  "premature_deaths_due_to_noncommunicable_diseases_ncd_a_eb6255f4" FLOAT  -- Premature Deaths Due To Noncommunicable Diseases, Ncd, As A Proportion Of All Ncd Deaths, Pct
);

CREATE TABLE owid_premium_brand_of_cigarettes_currency_reported_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "premium_brand_of_cigarettes_currency_reported" VARCHAR  -- Premium Brand Of Cigarettes, Currency Reported
);

CREATE TABLE owid_premium_brand_of_cigarettes_currency_reported_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "premium_brand_of_cigarettes_currency_reported" VARCHAR  -- Premium Brand Of Cigarettes, Currency Reported,
  "premium_brand_of_cigarettes_currency_reported_low" VARCHAR  -- Premium Brand Of Cigarettes, Currency Reported Low,
  "premium_brand_of_cigarettes_currency_reported_high" VARCHAR  -- Premium Brand Of Cigarettes, Currency Reported High,
  "comments" VARCHAR
);

CREATE TABLE owid_premium_brand_of_cigarettes_price_in_currency_reported_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "premium_brand_of_cigarettes_price_in_currency_reported" FLOAT  -- Premium Brand Of Cigarettes, Price In Currency Reported
);

CREATE TABLE owid_premium_brand_of_cigarettes_price_in_currency_reported_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "premium_brand_of_cigarettes_price_in_currency_reported" FLOAT  -- Premium Brand Of Cigarettes, Price In Currency Reported,
  "premium_brand_of_cigarettes_price_in_currency_reported_low" VARCHAR  -- Premium Brand Of Cigarettes, Price In Currency Reported Low,
  "premium_brand_of_cigarettes_price_in_currency_reported_high" VARCHAR  -- Premium Brand Of Cigarettes, Price In Currency Reported High,
  "comments" VARCHAR
);

CREATE TABLE owid_premium_brand_of_cigarettes_price_in_pppdollar_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "premium_brand_of_cigarettes_price_in_pppdollar" FLOAT  -- Premium Brand Of Cigarettes, Price In Pppdollar
);

CREATE TABLE owid_premium_brand_of_cigarettes_price_in_pppdollar_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "premium_brand_of_cigarettes_price_in_pppdollar" FLOAT  -- Premium Brand Of Cigarettes, Price In Pppdollar,
  "premium_brand_of_cigarettes_price_in_pppdollar_low" VARCHAR  -- Premium Brand Of Cigarettes, Price In Pppdollar Low,
  "premium_brand_of_cigarettes_price_in_pppdollar_high" VARCHAR  -- Premium Brand Of Cigarettes, Price In Pppdollar High,
  "comments" VARCHAR
);

CREATE TABLE owid_premium_brand_of_cigarettes_price_in_usd_at_offic_34d72d16 (
  "year" INTEGER,
  "country" VARCHAR,
  "premium_brand_of_cigarettes_price_in_usd_at_official_e_ef0d6f55" FLOAT  -- Premium Brand Of Cigarettes, Price In Usd At Official Exchange Rates,
  "premium_brand_of_cigarettes_price_in_usd_at_official_e_346537bc" VARCHAR  -- Premium Brand Of Cigarettes, Price In Usd At Official Exchange Rates Low,
  "premium_brand_of_cigarettes_price_in_usd_at_official_e_c7236a01" VARCHAR  -- Premium Brand Of Cigarettes, Price In Usd At Official Exchange Rates High,
  "comments" VARCHAR
);

CREATE TABLE owid_premium_brand_of_cigarettes_price_in_usd_at_offic_e45e1971 (
  "year" INTEGER,
  "country" VARCHAR,
  "premium_brand_of_cigarettes_price_in_usd_at_official_e_ef0d6f55" FLOAT  -- Premium Brand Of Cigarettes, Price In Usd At Official Exchange Rates
);

CREATE TABLE owid_preparedness (
  "year" INTEGER,
  "country" VARCHAR,
  "preparedness" INTEGER
);

CREATE TABLE owid_prescription_requirements_for_buprenorphine_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "rsud_drug_prescription" VARCHAR,
  "prescription_requirements_for_buprenorphine" VARCHAR
);

CREATE TABLE owid_prescription_requirements_for_buprenorphine_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "rsud_drug_prescription" VARCHAR,
  "prescription_requirements_for_buprenorphine" VARCHAR,
  "prescription_requirements_for_buprenorphine_low" VARCHAR,
  "prescription_requirements_for_buprenorphine_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_prescription_requirements_for_buprenorphine_naloxone_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "rsud_drug_prescription" VARCHAR,
  "prescription_requirements_for_buprenorphine_naloxone" VARCHAR
);

CREATE TABLE owid_prescription_requirements_for_buprenorphine_naloxone_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "rsud_drug_prescription" VARCHAR,
  "prescription_requirements_for_buprenorphine_naloxone" VARCHAR,
  "prescription_requirements_for_buprenorphine_naloxone_low" VARCHAR,
  "prescription_requirements_for_buprenorphine_naloxone_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_prescription_requirements_for_methadone_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "rsud_drug_prescription" VARCHAR,
  "prescription_requirements_for_methadone" VARCHAR
);

CREATE TABLE owid_prescription_requirements_for_methadone_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "rsud_drug_prescription" VARCHAR,
  "prescription_requirements_for_methadone" VARCHAR,
  "prescription_requirements_for_methadone_low" VARCHAR,
  "prescription_requirements_for_methadone_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_presence_of_dedicated_staff_for_oral_health_worki_805cf8c9 (
  "year" INTEGER,
  "country" VARCHAR,
  "presence_of_dedicated_staff_for_oral_health_working_on_c8dfd499" VARCHAR  -- Presence Of Dedicated Staff For Oral Health Working On Ncds At The Moh
);

CREATE TABLE owid_presence_of_dedicated_staff_for_oral_health_worki_b989512e (
  "year" INTEGER,
  "country" VARCHAR,
  "presence_of_dedicated_staff_for_oral_health_working_on_c8dfd499" VARCHAR  -- Presence Of Dedicated Staff For Oral Health Working On Ncds At The Moh,
  "presence_of_dedicated_staff_for_oral_health_working_on_4a37d6f8" VARCHAR  -- Presence Of Dedicated Staff For Oral Health Working On Ncds At The Moh Low,
  "presence_of_dedicated_staff_for_oral_health_working_on_4e5b9413" VARCHAR  -- Presence Of Dedicated Staff For Oral Health Working On Ncds At The Moh High,
  "comments" VARCHAR
);

CREATE TABLE owid_presence_of_formal_agreement_joint_plan_for_demen_35e550e0 (
  "year" INTEGER,
  "country" VARCHAR,
  "presence_of_formal_agreement_joint_plan_for_dementia_c_4a46ece8" VARCHAR  -- Presence Of Formal Agreement Joint Plan For Dementia Care Coordination,
  "presence_of_formal_agreement_joint_plan_for_dementia_c_f2af595e" VARCHAR  -- Presence Of Formal Agreement Joint Plan For Dementia Care Coordination Low,
  "presence_of_formal_agreement_joint_plan_for_dementia_c_f633a779" VARCHAR  -- Presence Of Formal Agreement Joint Plan For Dementia Care Coordination High,
  "comments" VARCHAR
);

CREATE TABLE owid_presence_of_formal_agreement_joint_plan_for_demen_eaffd771 (
  "year" INTEGER,
  "country" VARCHAR,
  "presence_of_formal_agreement_joint_plan_for_dementia_c_4a46ece8" VARCHAR  -- Presence Of Formal Agreement Joint Plan For Dementia Care Coordination
);