Global Health Observatory - World Health Organization

CREATE TABLE owid_estimated_number_of_individuals_in_the_country_re_2ab6e14d (
  "country" VARCHAR,
  "year" INTEGER,
  "estimated_number_of_individuals_in_the_country_requiri_a3a1927c" UINTEGER  -- Estimated Number Of Individuals In The Country Requiring Preventive Chemotherapy For Onchocerciasis,
  "estimated_number_of_individuals_in_the_country_requiri_ca7c4b36" VARCHAR  -- Estimated Number Of Individuals In The Country Requiring Preventive Chemotherapy For Onchocerciasis Low,
  "estimated_number_of_individuals_in_the_country_requiri_92675705" VARCHAR  -- Estimated Number Of Individuals In The Country Requiring Preventive Chemotherapy For Onchocerciasis High,
  "comments" VARCHAR
);

CREATE TABLE owid_estimated_number_of_individuals_in_the_country_re_cf8bdc3e (
  "country" VARCHAR,
  "year" INTEGER,
  "estimated_number_of_individuals_in_the_country_requiri_a3a1927c" UINTEGER  -- Estimated Number Of Individuals In The Country Requiring Preventive Chemotherapy For Onchocerciasis
);

CREATE TABLE owid_estimated_number_of_malaria_cases_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "estimated_number_of_malaria_cases" UINTEGER
);

CREATE TABLE owid_estimated_number_of_malaria_cases_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "estimated_number_of_malaria_cases" UINTEGER,
  "estimated_number_of_malaria_cases_low" FLOAT,
  "estimated_number_of_malaria_cases_high" FLOAT,
  "comments" VARCHAR
);

CREATE TABLE owid_estimated_number_of_malaria_deaths_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "estimated_number_of_malaria_deaths" UINTEGER
);

CREATE TABLE owid_estimated_number_of_malaria_deaths_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "estimated_number_of_malaria_deaths" UINTEGER,
  "estimated_number_of_malaria_deaths_low" FLOAT,
  "estimated_number_of_malaria_deaths_high" FLOAT,
  "comments" VARCHAR
);

CREATE TABLE owid_estimated_number_of_mdr_rr_tb_incident_cases (
  "year" INTEGER,
  "country" VARCHAR,
  "estimated_number_of_mdr_rr_tb_incident_cases" UINTEGER,
  "estimated_number_of_mdr_rr_tb_incident_cases_low" UINTEGER,
  "estimated_number_of_mdr_rr_tb_incident_cases_high" UINTEGER,
  "comments" VARCHAR
);

CREATE TABLE owid_estimated_number_of_people_eligible_for_antiretro_287db009 (
  "year" INTEGER,
  "country" VARCHAR,
  "estimated_number_of_people_eligible_for_antiretroviral_04d1146c" UINTEGER  -- Estimated Number Of People Eligible For Antiretroviral Therapy According To 2010 Guidelines,
  "estimated_number_of_people_eligible_for_antiretroviral_d2bfe277" UINTEGER  -- Estimated Number Of People Eligible For Antiretroviral Therapy According To 2010 Guidelines Low,
  "estimated_number_of_people_eligible_for_antiretroviral_5e1b2d9e" UINTEGER  -- Estimated Number Of People Eligible For Antiretroviral Therapy According To 2010 Guidelines High,
  "comments" VARCHAR
);

CREATE TABLE owid_estimated_number_of_people_eligible_for_antiretro_e1a6b05c (
  "year" INTEGER,
  "country" VARCHAR,
  "estimated_number_of_people_eligible_for_antiretroviral_04d1146c" UINTEGER  -- Estimated Number Of People Eligible For Antiretroviral Therapy According To 2010 Guidelines
);

CREATE TABLE owid_estimated_number_of_people_with_dementia_living_i_119b9402 (
  "year" INTEGER,
  "country" VARCHAR,
  "estimated_number_of_people_with_dementia_living_in_res_87578cb4" UINTEGER  -- Estimated Number Of People With Dementia Living In Residential Long Term Care,
  "estimated_number_of_people_with_dementia_living_in_res_10881851" VARCHAR  -- Estimated Number Of People With Dementia Living In Residential Long Term Care Low,
  "estimated_number_of_people_with_dementia_living_in_res_b2d3c026" VARCHAR  -- Estimated Number Of People With Dementia Living In Residential Long Term Care High,
  "comments" VARCHAR
);

CREATE TABLE owid_estimated_number_of_people_with_dementia_living_i_6347f023 (
  "year" INTEGER,
  "country" VARCHAR,
  "estimated_number_of_people_with_dementia_living_in_res_87578cb4" UINTEGER  -- Estimated Number Of People With Dementia Living In Residential Long Term Care
);

CREATE TABLE owid_estimated_number_of_people_with_dementia_receivin_23598d59 (
  "year" INTEGER,
  "country" VARCHAR,
  "estimated_number_of_people_with_dementia_receiving_ser_15181284" FLOAT  -- Estimated Number Of People With Dementia Receiving Services At Outpatient Social Centre
);

CREATE TABLE owid_estimated_number_of_people_with_dementia_receivin_53bff19a (
  "year" INTEGER,
  "country" VARCHAR,
  "estimated_number_of_people_with_dementia_receiving_ser_a0b76661" FLOAT  -- Estimated Number Of People With Dementia Receiving Services At Outpatient Health Centre
);

CREATE TABLE owid_estimated_number_of_people_with_dementia_receivin_62083b3b (
  "year" INTEGER,
  "country" VARCHAR,
  "estimated_number_of_people_with_dementia_receiving_ser_a0b76661" FLOAT  -- Estimated Number Of People With Dementia Receiving Services At Outpatient Health Centre,
  "estimated_number_of_people_with_dementia_receiving_ser_fc31d09a" VARCHAR  -- Estimated Number Of People With Dementia Receiving Services At Outpatient Health Centre Low,
  "estimated_number_of_people_with_dementia_receiving_ser_97360461" VARCHAR  -- Estimated Number Of People With Dementia Receiving Services At Outpatient Health Centre High,
  "comments" VARCHAR
);

CREATE TABLE owid_estimated_number_of_people_with_dementia_receivin_84921a39 (
  "year" INTEGER,
  "country" VARCHAR,
  "estimated_number_of_people_with_dementia_receiving_ser_15181284" FLOAT  -- Estimated Number Of People With Dementia Receiving Services At Outpatient Social Centre,
  "estimated_number_of_people_with_dementia_receiving_ser_3b08d5d7" VARCHAR  -- Estimated Number Of People With Dementia Receiving Services At Outpatient Social Centre Low,
  "estimated_number_of_people_with_dementia_receiving_ser_38df658b" VARCHAR  -- Estimated Number Of People With Dementia Receiving Services At Outpatient Social Centre High,
  "comments" VARCHAR
);

CREATE TABLE owid_estimated_number_of_pregnant_women_living_with_hi_06d0552c (
  "year" INTEGER,
  "country" VARCHAR,
  "estimated_number_of_pregnant_women_living_with_hiv_nee_7cc2aa3b" UINTEGER  -- Estimated Number Of Pregnant Women Living With Hiv Needing Antiretrovirals For Preventing Mother To Child Transmission,
  "estimated_number_of_pregnant_women_living_with_hiv_nee_59bfabb6" UINTEGER  -- Estimated Number Of Pregnant Women Living With Hiv Needing Antiretrovirals For Preventing Mother To Child Transmission Low,
  "estimated_number_of_pregnant_women_living_with_hiv_nee_81a2ebf4" UINTEGER  -- Estimated Number Of Pregnant Women Living With Hiv Needing Antiretrovirals For Preventing Mother To Child Transmission High,
  "comments" VARCHAR
);

CREATE TABLE owid_estimated_number_of_pregnant_women_living_with_hi_bf949fe3 (
  "year" INTEGER,
  "country" VARCHAR,
  "estimated_number_of_pregnant_women_living_with_hiv_nee_7cc2aa3b" UINTEGER  -- Estimated Number Of Pregnant Women Living With Hiv Needing Antiretrovirals For Preventing Mother To Child Transmission
);

CREATE TABLE owid_estimated_number_of_pregnant_women_living_with_hiv_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "estimated_number_of_pregnant_women_living_with_hiv" INTEGER
);

CREATE TABLE owid_estimated_number_of_pregnant_women_living_with_hiv_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "estimated_number_of_pregnant_women_living_with_hiv" INTEGER,
  "estimated_number_of_pregnant_women_living_with_hiv_low" INTEGER,
  "estimated_number_of_pregnant_women_living_with_hiv_high" INTEGER,
  "comments" VARCHAR
);

CREATE TABLE owid_estimated_number_of_road_traffic_deaths_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "estimated_number_of_road_traffic_deaths" FLOAT
);

CREATE TABLE owid_estimated_number_of_road_traffic_deaths_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "estimated_number_of_road_traffic_deaths" UINTEGER,
  "estimated_number_of_road_traffic_deaths_low" UINTEGER,
  "estimated_number_of_road_traffic_deaths_high" UINTEGER,
  "comments" VARCHAR
);

CREATE TABLE owid_estimated_number_of_tests_performed_where_results_6bd3f845 (
  "year" INTEGER,
  "country" VARCHAR,
  "estimated_number_of_tests_performed_where_results_were_fbca8f80" FLOAT  -- Estimated Number Of Tests Performed Where Results Were Received By A Person, Testing Volume, Estimated Number Per 1000 Population,
  "comments" VARCHAR
);

CREATE TABLE owid_estimated_percentage_of_hospitals_following_natio_159923a1 (
  "year" INTEGER,
  "country" VARCHAR,
  "estimated_percentage_of_hospitals_following_national_d_4eea5460" INTEGER  -- Estimated Percentage Of Hospitals Following National Dementia Standards
);

CREATE TABLE owid_estimated_percentage_of_hospitals_following_natio_a5041b24 (
  "year" INTEGER,
  "country" VARCHAR,
  "estimated_percentage_of_hospitals_following_national_d_4eea5460" INTEGER  -- Estimated Percentage Of Hospitals Following National Dementia Standards,
  "estimated_percentage_of_hospitals_following_national_d_0271aa91" VARCHAR  -- Estimated Percentage Of Hospitals Following National Dementia Standards Low,
  "estimated_percentage_of_hospitals_following_national_d_9d4c324f" VARCHAR  -- Estimated Percentage Of Hospitals Following National Dementia Standards High,
  "comments" VARCHAR
);

CREATE TABLE owid_estimated_percentage_of_residential_long_term_car_07642029 (
  "year" INTEGER,
  "country" VARCHAR,
  "estimated_percentage_of_residential_long_term_care_fac_c1d01f24" INTEGER  -- Estimated Percentage Of Residential Long Term Care Facilities Following National Dementia Standards
);