Global Health Observatory - World Health Organization
@owid.gho
@owid.gho
CREATE TABLE owid_standards_of_care_for_health_professionals_maintenance_1 (
"year" INTEGER,
"country" VARCHAR,
"rsud_standards_of_care" VARCHAR,
"standards_of_care_for_health_professionals_maintenance" VARCHAR -- Standards Of Care For Health Professionals, Maintenance
);
CREATE TABLE owid_standards_of_care_for_health_professionals_maintenance_2 (
"year" INTEGER,
"country" VARCHAR,
"rsud_standards_of_care" VARCHAR,
"standards_of_care_for_health_professionals_maintenance" VARCHAR -- Standards Of Care For Health Professionals, Maintenance,
"standards_of_care_for_health_professionals_maintenance_low" VARCHAR -- Standards Of Care For Health Professionals, Maintenance Low,
"standards_of_care_for_health_professionals_maintenance_high" VARCHAR -- Standards Of Care For Health Professionals, Maintenance High,
"comments" VARCHAR
);
CREATE TABLE owid_standards_of_care_for_professionals_providing_tre_2e7127d0 (
"year" INTEGER,
"country" VARCHAR,
"human_resources_health_workforce" VARCHAR -- Human Resources, Health Workforce,
"standards_of_care_for_professionals_providing_treatmen_f695262b" VARCHAR -- Standards Of Care For Professionals Providing Treatment For Alcohol And Drug Use Disorders,
"standards_of_care_for_professionals_providing_treatmen_28fbfddc" VARCHAR -- Standards Of Care For Professionals Providing Treatment For Alcohol And Drug Use Disorders Low,
"standards_of_care_for_professionals_providing_treatmen_0e076743" VARCHAR -- Standards Of Care For Professionals Providing Treatment For Alcohol And Drug Use Disorders High,
"comments" VARCHAR
);
CREATE TABLE owid_standards_of_care_for_professionals_providing_tre_8534f811 (
"year" INTEGER,
"country" VARCHAR,
"human_resources_health_workforce" VARCHAR -- Human Resources, Health Workforce,
"standards_of_care_for_professionals_providing_treatmen_f695262b" VARCHAR -- Standards Of Care For Professionals Providing Treatment For Alcohol And Drug Use Disorders
);
CREATE TABLE owid_standards_of_treatment_and_care_for_public_specia_57acef1c (
"year" INTEGER,
"country" VARCHAR,
"standards_of_treatment_and_care_for_public_specialized_0e47a339" VARCHAR -- Standards Of Treatment And Care For Public Specialized Treatment Facilities
);
CREATE TABLE owid_standards_of_treatment_and_care_for_public_specia_6c3fd5d2 (
"year" INTEGER,
"country" VARCHAR,
"standards_of_treatment_and_care_for_public_specialized_0e47a339" VARCHAR -- Standards Of Treatment And Care For Public Specialized Treatment Facilities,
"standards_of_treatment_and_care_for_public_specialized_107ca80d" VARCHAR -- Standards Of Treatment And Care For Public Specialized Treatment Facilities Low,
"standards_of_treatment_and_care_for_public_specialized_c014ec21" VARCHAR -- Standards Of Treatment And Care For Public Specialized Treatment Facilities High,
"comments" VARCHAR
);
CREATE TABLE owid_status_of_alcohol_sale_1 (
"year" INTEGER,
"country" VARCHAR,
"beverage_type" VARCHAR,
"beverage" VARCHAR,
"comments" VARCHAR,
"status_of_alcohol_sale" VARCHAR
);
CREATE TABLE owid_status_of_alcohol_sale_2 (
"year" INTEGER,
"country" VARCHAR,
"beverage_type" VARCHAR,
"beverage" VARCHAR,
"status_of_alcohol_sale" VARCHAR,
"status_of_alcohol_sale_low" VARCHAR,
"status_of_alcohol_sale_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_status_of_bejel_endemicity_1 (
"year" INTEGER,
"country" VARCHAR,
"status_of_bejel_endemicity" VARCHAR
);
CREATE TABLE owid_status_of_bejel_endemicity_2 (
"year" INTEGER,
"country" VARCHAR,
"status_of_bejel_endemicity" VARCHAR,
"status_of_bejel_endemicity_low" VARCHAR,
"status_of_bejel_endemicity_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_status_of_elimination_of_trachoma_as_a_public_hea_491a640f (
"year" INTEGER,
"country" VARCHAR,
"status_of_elimination_of_trachoma_as_a_public_health_problem" VARCHAR,
"status_of_elimination_of_trachoma_as_a_public_health_p_047153df" VARCHAR -- Status Of Elimination Of Trachoma As A Public Health Problem Low,
"status_of_elimination_of_trachoma_as_a_public_health_p_90782c60" VARCHAR -- Status Of Elimination Of Trachoma As A Public Health Problem High,
"comments" VARCHAR
);
CREATE TABLE owid_status_of_elimination_of_trachoma_as_a_public_hea_699f2357 (
"year" INTEGER,
"country" VARCHAR,
"status_of_elimination_of_trachoma_as_a_public_health_problem" VARCHAR
);
CREATE TABLE owid_status_of_endemicity_of_buruli_ulcer_1 (
"year" INTEGER,
"country" VARCHAR,
"status_of_endemicity_of_buruli_ulcer" VARCHAR
);
CREATE TABLE owid_status_of_endemicity_of_buruli_ulcer_2 (
"year" INTEGER,
"country" VARCHAR,
"status_of_endemicity_of_buruli_ulcer" VARCHAR,
"status_of_endemicity_of_buruli_ulcer_low" VARCHAR,
"status_of_endemicity_of_buruli_ulcer_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_status_of_endemicity_of_cutaneous_leishmaniasis_1 (
"year" INTEGER,
"country" VARCHAR,
"status_of_endemicity_of_cutaneous_leishmaniasis" VARCHAR
);
CREATE TABLE owid_status_of_endemicity_of_cutaneous_leishmaniasis_2 (
"year" INTEGER,
"country" VARCHAR,
"status_of_endemicity_of_cutaneous_leishmaniasis" VARCHAR,
"status_of_endemicity_of_cutaneous_leishmaniasis_low" VARCHAR,
"status_of_endemicity_of_cutaneous_leishmaniasis_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_status_of_endemicity_of_onchocerciasis_1 (
"year" INTEGER,
"country" VARCHAR,
"status_of_endemicity_of_onchocerciasis" VARCHAR
);
CREATE TABLE owid_status_of_endemicity_of_onchocerciasis_2 (
"year" INTEGER,
"country" VARCHAR,
"status_of_endemicity_of_onchocerciasis" VARCHAR,
"status_of_endemicity_of_onchocerciasis_low" VARCHAR,
"status_of_endemicity_of_onchocerciasis_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_status_of_endemicity_of_taenia_solium_1 (
"year" INTEGER,
"country" VARCHAR,
"status_of_endemicity_of_taenia_solium" VARCHAR
);
CREATE TABLE owid_status_of_endemicity_of_taenia_solium_2 (
"year" INTEGER,
"country" VARCHAR,
"status_of_endemicity_of_taenia_solium" VARCHAR,
"status_of_endemicity_of_taenia_solium_low" VARCHAR,
"status_of_endemicity_of_taenia_solium_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_status_of_endemicity_of_visceral_leishmaniasis_1 (
"year" INTEGER,
"country" VARCHAR,
"status_of_endemicity_of_visceral_leishmaniasis" VARCHAR
);
CREATE TABLE owid_status_of_endemicity_of_visceral_leishmaniasis_2 (
"year" INTEGER,
"country" VARCHAR,
"status_of_endemicity_of_visceral_leishmaniasis" VARCHAR,
"status_of_endemicity_of_visceral_leishmaniasis_low" VARCHAR,
"status_of_endemicity_of_visceral_leishmaniasis_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_status_of_indigenous_malaria_cases_1 (
"year" INTEGER,
"country" VARCHAR,
"status_of_indigenous_malaria_cases" VARCHAR
);
CREATE TABLE owid_status_of_indigenous_malaria_cases_2 (
"year" INTEGER,
"country" VARCHAR,
"status_of_indigenous_malaria_cases" VARCHAR,
"status_of_indigenous_malaria_cases_low" VARCHAR,
"status_of_indigenous_malaria_cases_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_status_of_pinta_endemicity_1 (
"year" INTEGER,
"country" VARCHAR,
"status_of_pinta_endemicity" VARCHAR
);
Anyone who has the link will be able to view this.