Global Health Observatory - World Health Organization
@owid.gho
@owid.gho
CREATE TABLE owid_number_of_people_protected_from_malaria_by_indoor_e5fb2585 (
"year" INTEGER,
"country" VARCHAR,
"number_of_people_protected_from_malaria_by_indoor_resi_60579390" UINTEGER -- Number Of People Protected From Malaria By Indoor Residual Spraying, Irs
);
CREATE TABLE owid_number_of_people_who_received_treatment_with_anti_16c1740e (
"country" VARCHAR,
"year" INTEGER,
"number_of_people_who_received_treatment_with_antibioti_bba93d2c" UINTEGER -- Number Of People Who Received Treatment With Antibiotics For Trachoma
);
CREATE TABLE owid_number_of_people_who_received_treatment_with_anti_19421a34 (
"country" VARCHAR,
"year" INTEGER,
"number_of_people_who_received_treatment_with_antibioti_bba93d2c" UINTEGER -- Number Of People Who Received Treatment With Antibiotics For Trachoma,
"number_of_people_who_received_treatment_with_antibioti_ac72616a" VARCHAR -- Number Of People Who Received Treatment With Antibiotics For Trachoma Low,
"number_of_people_who_received_treatment_with_antibioti_8cbe639e" VARCHAR -- Number Of People Who Received Treatment With Antibiotics For Trachoma High,
"comments" VARCHAR
);
CREATE TABLE owid_number_of_people_with_dementia_involved_in_resear_5a14c715 (
"year" INTEGER,
"country" VARCHAR,
"number_of_people_with_dementia_involved_in_research_ro_73354426" VARCHAR -- Number Of People With Dementia Involved In Research Routinely Monitored,
"number_of_people_with_dementia_involved_in_research_ro_bbbce238" VARCHAR -- Number Of People With Dementia Involved In Research Routinely Monitored Low,
"number_of_people_with_dementia_involved_in_research_ro_69af217c" VARCHAR -- Number Of People With Dementia Involved In Research Routinely Monitored High,
"comments" VARCHAR
);
CREATE TABLE owid_number_of_people_with_dementia_involved_in_resear_d9859f74 (
"year" INTEGER,
"country" VARCHAR,
"number_of_people_with_dementia_involved_in_research_ro_73354426" VARCHAR -- Number Of People With Dementia Involved In Research Routinely Monitored
);
CREATE TABLE owid_number_of_pigs_in_the_country_1 (
"year" INTEGER,
"country" VARCHAR,
"number_of_pigs_in_the_country" UINTEGER
);
CREATE TABLE owid_number_of_pigs_in_the_country_2 (
"year" INTEGER,
"country" VARCHAR,
"number_of_pigs_in_the_country" UINTEGER,
"number_of_pigs_in_the_country_low" VARCHAR,
"number_of_pigs_in_the_country_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_number_of_places_smoke_free_national_legislation_1 (
"year" INTEGER,
"country" VARCHAR,
"number_of_places_smoke_free_national_legislation" INTEGER -- Number Of Places Smoke Free, National Legislation,
"comments" VARCHAR
);
CREATE TABLE owid_number_of_places_smoke_free_national_legislation_2 (
"year" INTEGER,
"country" VARCHAR,
"number_of_places_smoke_free_national_legislation" INTEGER -- Number Of Places Smoke Free, National Legislation,
"number_of_places_smoke_free_national_legislation_low" VARCHAR -- Number Of Places Smoke Free, National Legislation Low,
"number_of_places_smoke_free_national_legislation_high" VARCHAR -- Number Of Places Smoke Free, National Legislation High,
"comments" VARCHAR
);
CREATE TABLE owid_number_of_pregnant_women_aged_15_49_years_with_an_3daaf514 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"severity" VARCHAR,
"number_of_pregnant_women_aged_15_49_years_with_anaemia_5fe261cf" FLOAT -- Number Of Pregnant Women, Aged 15–49 Years, With Anaemia, Thousands,
"number_of_pregnant_women_aged_15_49_years_with_anaemia_a267c1ed" FLOAT -- Number Of Pregnant Women, Aged 15–49 Years, With Anaemia, Thousands Low,
"number_of_pregnant_women_aged_15_49_years_with_anaemia_661b5cef" FLOAT -- Number Of Pregnant Women, Aged 15–49 Years, With Anaemia, Thousands High,
"comments" VARCHAR
);
CREATE TABLE owid_number_of_pregnant_women_aged_15_49_years_with_an_9ab49146 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"severity" VARCHAR,
"number_of_pregnant_women_aged_15_49_years_with_anaemia_5fe261cf" FLOAT -- Number Of Pregnant Women, Aged 15–49 Years, With Anaemia, Thousands
);
CREATE TABLE owid_number_of_pregnant_women_living_with_hiv_who_rece_9007eaa2 (
"year" INTEGER,
"country" VARCHAR,
"number_of_pregnant_women_living_with_hiv_who_received__bd756b02" UINTEGER -- Number Of Pregnant Women Living With Hiv Who Received Antiretrovirals For Preventing Mother To Child Transmission,
"number_of_pregnant_women_living_with_hiv_who_received__9ca745e5" VARCHAR -- Number Of Pregnant Women Living With Hiv Who Received Antiretrovirals For Preventing Mother To Child Transmission Low,
"number_of_pregnant_women_living_with_hiv_who_received__6ab84d4e" VARCHAR -- Number Of Pregnant Women Living With Hiv Who Received Antiretrovirals For Preventing Mother To Child Transmission High,
"comments" VARCHAR
);
CREATE TABLE owid_number_of_pregnant_women_living_with_hiv_who_rece_e273eae4 (
"year" INTEGER,
"country" VARCHAR,
"number_of_pregnant_women_living_with_hiv_who_received__bd756b02" UINTEGER -- Number Of Pregnant Women Living With Hiv Who Received Antiretrovirals For Preventing Mother To Child Transmission
);
CREATE TABLE owid_number_of_presumed_malaria_cases_1 (
"year" INTEGER,
"country" VARCHAR,
"number_of_presumed_malaria_cases" UINTEGER
);
CREATE TABLE owid_number_of_presumed_malaria_cases_2 (
"year" INTEGER,
"country" VARCHAR,
"number_of_presumed_malaria_cases" UINTEGER,
"number_of_presumed_malaria_cases_low" VARCHAR,
"number_of_presumed_malaria_cases_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_number_of_prevalent_tuberculosis_cases_1 (
"year" INTEGER,
"country" VARCHAR,
"number_of_prevalent_tuberculosis_cases" FLOAT
);
CREATE TABLE owid_number_of_prevalent_tuberculosis_cases_2 (
"year" INTEGER,
"country" VARCHAR,
"number_of_prevalent_tuberculosis_cases" FLOAT,
"number_of_prevalent_tuberculosis_cases_low" FLOAT,
"number_of_prevalent_tuberculosis_cases_high" FLOAT,
"comments" VARCHAR
);
CREATE TABLE owid_number_of_prisoners_1 (
"year" INTEGER,
"country" VARCHAR,
"number_of_prisoners" UINTEGER
);
CREATE TABLE owid_number_of_prisoners_2 (
"year" INTEGER,
"country" VARCHAR,
"number_of_prisoners" UINTEGER,
"number_of_prisoners_low" VARCHAR,
"number_of_prisoners_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_number_of_prisoners_per_100_000_inhabitants_1 (
"year" INTEGER,
"country" VARCHAR,
"number_of_prisoners_per_100_000_inhabitants" FLOAT -- Number Of Prisoners, Per 100–000 Inhabitants
);
CREATE TABLE owid_number_of_prisoners_per_100_000_inhabitants_2 (
"year" INTEGER,
"country" VARCHAR,
"number_of_prisoners_per_100_000_inhabitants" FLOAT -- Number Of Prisoners, Per 100–000 Inhabitants,
"number_of_prisoners_per_100_000_inhabitants_low" VARCHAR -- Number Of Prisoners, Per 100–000 Inhabitants Low,
"number_of_prisoners_per_100_000_inhabitants_high" VARCHAR -- Number Of Prisoners, Per 100–000 Inhabitants High,
"comments" VARCHAR
);
CREATE TABLE owid_number_of_registered_vehicles_1 (
"year" INTEGER,
"country" VARCHAR,
"residence_area_type" VARCHAR,
"number_of_registered_vehicles" UINTEGER,
"comments" VARCHAR
);
CREATE TABLE owid_number_of_registered_vehicles_2 (
"year" INTEGER,
"country" VARCHAR,
"residence_area_type" VARCHAR,
"number_of_registered_vehicles" UINTEGER,
"number_of_registered_vehicles_low" VARCHAR,
"number_of_registered_vehicles_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_number_of_reported_cases_of_cholera_1 (
"year" INTEGER,
"country" VARCHAR,
"number_of_reported_cases_of_cholera" UINTEGER,
"comments" VARCHAR
);
CREATE TABLE owid_number_of_reported_cases_of_cholera_2 (
"year" INTEGER,
"country" VARCHAR,
"number_of_reported_cases_of_cholera" UINTEGER,
"number_of_reported_cases_of_cholera_low" VARCHAR,
"number_of_reported_cases_of_cholera_high" VARCHAR,
"comments" VARCHAR
);
Anyone who has the link will be able to view this.