Global Health Observatory - World Health Organization

CREATE TABLE owid_number_of_reported_cases_of_poliomyelitis_by_wild_81c92f96 (
  "year" INTEGER,
  "country" VARCHAR,
  "number_of_reported_cases_of_poliomyelitis_by_wild_poli_d1fbb537" INTEGER  -- Number Of Reported Cases Of Poliomyelitis By Wild Poliovirus, Wpv,
  "comments" VARCHAR
);

CREATE TABLE owid_number_of_reported_cases_of_poliomyelitis_by_wild_eabc2bdf (
  "year" INTEGER,
  "country" VARCHAR,
  "number_of_reported_cases_of_poliomyelitis_by_wild_poli_d1fbb537" INTEGER  -- Number Of Reported Cases Of Poliomyelitis By Wild Poliovirus, Wpv,
  "number_of_reported_cases_of_poliomyelitis_by_wild_poli_679eeaab" VARCHAR  -- Number Of Reported Cases Of Poliomyelitis By Wild Poliovirus, Wpv Low,
  "number_of_reported_cases_of_poliomyelitis_by_wild_poli_72e95e10" VARCHAR  -- Number Of Reported Cases Of Poliomyelitis By Wild Poliovirus, Wpv High,
  "comments" VARCHAR
);

CREATE TABLE owid_number_of_reported_deaths_from_cholera_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "number_of_reported_deaths_from_cholera" UINTEGER
);

CREATE TABLE owid_number_of_reported_deaths_from_cholera_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "number_of_reported_deaths_from_cholera" UINTEGER,
  "number_of_reported_deaths_from_cholera_low" VARCHAR,
  "number_of_reported_deaths_from_cholera_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_number_of_standard_alcoholic_drinks_displayed_on__24ccf884 (
  "year" INTEGER,
  "country" VARCHAR,
  "beverage_types" VARCHAR,
  "number_of_standard_alcoholic_drinks_displayed_on_containers" VARCHAR,
  "number_of_standard_alcoholic_drinks_displayed_on_containers_low" VARCHAR,
  "number_of_standard_alcoholic_drinks_displayed_on_conta_1730bd75" VARCHAR  -- Number Of Standard Alcoholic Drinks Displayed On Containers High,
  "comments" VARCHAR
);

CREATE TABLE owid_number_of_standard_alcoholic_drinks_displayed_on__bdd5c442 (
  "year" INTEGER,
  "country" VARCHAR,
  "beverage_types" VARCHAR,
  "number_of_standard_alcoholic_drinks_displayed_on_containers" VARCHAR
);

CREATE TABLE owid_number_of_surveillance_sites_reporting_to_glass_h_362d97da (
  "year" INTEGER,
  "country" VARCHAR,
  "number_of_surveillance_sites_reporting_to_glass_hospitals" INTEGER  -- Number Of Surveillance Sites Reporting To Glass, Hospitals
);

CREATE TABLE owid_number_of_surveillance_sites_reporting_to_glass_h_bff55c8b (
  "year" INTEGER,
  "country" VARCHAR,
  "number_of_surveillance_sites_reporting_to_glass_hospitals" INTEGER  -- Number Of Surveillance Sites Reporting To Glass, Hospitals,
  "number_of_surveillance_sites_reporting_to_glass_hospitals_low" VARCHAR  -- Number Of Surveillance Sites Reporting To Glass, Hospitals Low,
  "number_of_surveillance_sites_reporting_to_glass_hospitals_high" VARCHAR  -- Number Of Surveillance Sites Reporting To Glass, Hospitals High,
  "comments" VARCHAR
);

CREATE TABLE owid_number_of_surveillance_sites_reporting_to_glass_i_4d57db20 (
  "year" INTEGER,
  "country" VARCHAR,
  "number_of_surveillance_sites_reporting_to_glass_in_and_7252ac33" INTEGER  -- Number Of Surveillance Sites Reporting To Glass, In, And Outpatient Facilities,
  "number_of_surveillance_sites_reporting_to_glass_in_and_d07765bb" VARCHAR  -- Number Of Surveillance Sites Reporting To Glass, In, And Outpatient Facilities Low,
  "number_of_surveillance_sites_reporting_to_glass_in_and_da693bb4" VARCHAR  -- Number Of Surveillance Sites Reporting To Glass, In, And Outpatient Facilities High,
  "comments" VARCHAR
);

CREATE TABLE owid_number_of_surveillance_sites_reporting_to_glass_i_6176c2a0 (
  "year" INTEGER,
  "country" VARCHAR,
  "number_of_surveillance_sites_reporting_to_glass_in_and_7252ac33" INTEGER  -- Number Of Surveillance Sites Reporting To Glass, In, And Outpatient Facilities
);

CREATE TABLE owid_number_of_surveillance_sites_reporting_to_glass_o_1602963c (
  "year" INTEGER,
  "country" VARCHAR,
  "number_of_surveillance_sites_reporting_to_glass_outpat_40673a02" INTEGER  -- Number Of Surveillance Sites Reporting To Glass, Outpatient Facilities,
  "number_of_surveillance_sites_reporting_to_glass_outpat_664c57d2" VARCHAR  -- Number Of Surveillance Sites Reporting To Glass, Outpatient Facilities Low,
  "number_of_surveillance_sites_reporting_to_glass_outpat_19bdc9f4" VARCHAR  -- Number Of Surveillance Sites Reporting To Glass, Outpatient Facilities High,
  "comments" VARCHAR
);

CREATE TABLE owid_number_of_surveillance_sites_reporting_to_glass_o_edc10056 (
  "year" INTEGER,
  "country" VARCHAR,
  "number_of_surveillance_sites_reporting_to_glass_outpat_40673a02" INTEGER  -- Number Of Surveillance Sites Reporting To Glass, Outpatient Facilities
);

CREATE TABLE owid_number_of_suspected_malaria_cases_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "number_of_suspected_malaria_cases" UINTEGER
);

CREATE TABLE owid_number_of_suspected_malaria_cases_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "number_of_suspected_malaria_cases" UINTEGER,
  "number_of_suspected_malaria_cases_low" VARCHAR,
  "number_of_suspected_malaria_cases_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_number_of_suspected_meningitis_cases_reported_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "number_of_suspected_meningitis_cases_reported" INTEGER,
  "comments" VARCHAR
);

CREATE TABLE owid_number_of_suspected_meningitis_cases_reported_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "number_of_suspected_meningitis_cases_reported" INTEGER,
  "number_of_suspected_meningitis_cases_reported_low" VARCHAR,
  "number_of_suspected_meningitis_cases_reported_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_number_of_suspected_meningitis_deaths_reported_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "number_of_suspected_meningitis_deaths_reported" INTEGER,
  "comments" VARCHAR
);

CREATE TABLE owid_number_of_suspected_meningitis_deaths_reported_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "number_of_suspected_meningitis_deaths_reported" INTEGER,
  "number_of_suspected_meningitis_deaths_reported_low" VARCHAR,
  "number_of_suspected_meningitis_deaths_reported_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_number_of_suspected_yaws_cases_reported_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "number_of_suspected_yaws_cases_reported" UINTEGER
);

CREATE TABLE owid_number_of_suspected_yaws_cases_reported_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "number_of_suspected_yaws_cases_reported" UINTEGER,
  "number_of_suspected_yaws_cases_reported_low" VARCHAR,
  "number_of_suspected_yaws_cases_reported_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_number_of_women_of_reproductive_age_aged_15_49_ye_0f44abb0 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "pregnancy_status" VARCHAR,
  "number_of_women_of_reproductive_age_aged_15_49_years_w_12d69ab3" FLOAT  -- Number Of Women Of Reproductive Age, Aged 15–49 Years, With Anaemia, Thousands,
  "number_of_women_of_reproductive_age_aged_15_49_years_w_94bcacc7" FLOAT  -- Number Of Women Of Reproductive Age, Aged 15–49 Years, With Anaemia, Thousands Low,
  "number_of_women_of_reproductive_age_aged_15_49_years_w_f6a182b1" FLOAT  -- Number Of Women Of Reproductive Age, Aged 15–49 Years, With Anaemia, Thousands High,
  "comments" VARCHAR
);

CREATE TABLE owid_number_of_women_of_reproductive_age_aged_15_49_ye_d9888b45 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "severity" VARCHAR,
  "number_of_women_of_reproductive_age_aged_15_49_years_w_12d69ab3" FLOAT  -- Number Of Women Of Reproductive Age, Aged 15–49 Years, With Anaemia, Thousands
);

CREATE TABLE owid_nurses_in_prisons_ftes_per_1000_prisoners_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "nurses_in_prisons_ftes_per_1000_prisoners" FLOAT  -- Nurses In Prisons, Ftes Per 1000 Prisoners
);

CREATE TABLE owid_nurses_in_prisons_ftes_per_1000_prisoners_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "nurses_in_prisons_ftes_per_1000_prisoners" FLOAT  -- Nurses In Prisons, Ftes Per 1000 Prisoners,
  "nurses_in_prisons_ftes_per_1000_prisoners_low" VARCHAR  -- Nurses In Prisons, Ftes Per 1000 Prisoners Low,
  "nurses_in_prisons_ftes_per_1000_prisoners_high" VARCHAR  -- Nurses In Prisons, Ftes Per 1000 Prisoners High,
  "comments" VARCHAR
);

CREATE TABLE owid_nurses_working_in_mental_health_sector_per_100_00_9112eb85 (
  "year" INTEGER,
  "country" VARCHAR,
  "nurses_working_in_mental_health_sector_per_100_000_population" FLOAT  -- Nurses Working In Mental Health Sector, Per 100–000 Population
);