Global Health Observatory - World Health Organization
@owid.gho
@owid.gho
CREATE TABLE owid_number_of_health_warnings_approved_by_the_law_for_945f51ef (
"year" INTEGER,
"country" VARCHAR,
"number_of_health_warnings_approved_by_the_law_for_smok_89bd7281" INTEGER -- Number Of Health Warnings Approved By The Law For Smokeless Tobacco Packaging,
"comments" VARCHAR
);
CREATE TABLE owid_number_of_health_warnings_approved_by_the_law_for_afd8fedd (
"year" INTEGER,
"country" VARCHAR,
"number_of_health_warnings_approved_by_the_law_for_othe_29ad1fd9" INTEGER -- Number Of Health Warnings Approved By The Law For Other Smoked Tobacco Packaging,
"comments" VARCHAR
);
CREATE TABLE owid_number_of_health_warnings_approved_by_the_law_for_bbdc3598 (
"year" INTEGER,
"country" VARCHAR,
"number_of_health_warnings_approved_by_the_law_for_othe_29ad1fd9" INTEGER -- Number Of Health Warnings Approved By The Law For Other Smoked Tobacco Packaging,
"number_of_health_warnings_approved_by_the_law_for_othe_c057e680" VARCHAR -- Number Of Health Warnings Approved By The Law For Other Smoked Tobacco Packaging Low,
"number_of_health_warnings_approved_by_the_law_for_othe_2dd9d719" VARCHAR -- Number Of Health Warnings Approved By The Law For Other Smoked Tobacco Packaging High,
"comments" VARCHAR
);
CREATE TABLE owid_number_of_imported_cases_of_cutaneous_leishmanias_c92cff93 (
"year" INTEGER,
"country" VARCHAR,
"number_of_imported_cases_of_cutaneous_leishmaniasis_reported" INTEGER,
"number_of_imported_cases_of_cutaneous_leishmaniasis_re_4bc1f4e5" VARCHAR -- Number Of Imported Cases Of Cutaneous Leishmaniasis Reported Low,
"number_of_imported_cases_of_cutaneous_leishmaniasis_re_b279042e" VARCHAR -- Number Of Imported Cases Of Cutaneous Leishmaniasis Reported High,
"comments" VARCHAR
);
CREATE TABLE owid_number_of_imported_cases_of_cutaneous_leishmanias_e2e89767 (
"year" INTEGER,
"country" VARCHAR,
"number_of_imported_cases_of_cutaneous_leishmaniasis_reported" INTEGER,
"comments" VARCHAR
);
CREATE TABLE owid_number_of_imported_cases_of_visceral_leishmaniasi_50ab458f (
"year" INTEGER,
"country" VARCHAR,
"number_of_imported_cases_of_visceral_leishmaniasis_reported" INTEGER
);
CREATE TABLE owid_number_of_imported_cases_of_visceral_leishmaniasi_99bfbf9d (
"year" INTEGER,
"country" VARCHAR,
"number_of_imported_cases_of_visceral_leishmaniasis_reported" INTEGER,
"number_of_imported_cases_of_visceral_leishmaniasis_reported_low" VARCHAR,
"number_of_imported_cases_of_visceral_leishmaniasis_rep_36489030" VARCHAR -- Number Of Imported Cases Of Visceral Leishmaniasis Reported High,
"comments" VARCHAR
);
CREATE TABLE owid_number_of_imported_malaria_cases_1 (
"year" INTEGER,
"country" VARCHAR,
"number_of_imported_malaria_cases" UINTEGER
);
CREATE TABLE owid_number_of_imported_malaria_cases_2 (
"year" INTEGER,
"country" VARCHAR,
"number_of_imported_malaria_cases" INTEGER,
"number_of_imported_malaria_cases_low" VARCHAR,
"number_of_imported_malaria_cases_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_number_of_incident_tuberculosis_cases_1 (
"year" INTEGER,
"country" VARCHAR,
"number_of_incident_tuberculosis_cases" UINTEGER
);
CREATE TABLE owid_number_of_incident_tuberculosis_cases_2 (
"year" INTEGER,
"country" VARCHAR,
"number_of_incident_tuberculosis_cases" UINTEGER,
"number_of_incident_tuberculosis_cases_low" UINTEGER,
"number_of_incident_tuberculosis_cases_high" UINTEGER,
"comments" VARCHAR
);
CREATE TABLE owid_number_of_incident_tuberculosis_cases_hiv_positive_cases_1 (
"year" INTEGER,
"country" VARCHAR,
"number_of_incident_tuberculosis_cases_hiv_positive_cases" UINTEGER -- Number Of Incident Tuberculosis Cases, Hiv Positive Cases
);
CREATE TABLE owid_number_of_incident_tuberculosis_cases_hiv_positive_cases_2 (
"year" INTEGER,
"country" VARCHAR,
"number_of_incident_tuberculosis_cases_hiv_positive_cases" UINTEGER -- Number Of Incident Tuberculosis Cases, Hiv Positive Cases,
"number_of_incident_tuberculosis_cases_hiv_positive_cases_low" UINTEGER -- Number Of Incident Tuberculosis Cases, Hiv Positive Cases Low,
"number_of_incident_tuberculosis_cases_hiv_positive_cases_high" UINTEGER -- Number Of Incident Tuberculosis Cases, Hiv Positive Cases High,
"comments" VARCHAR
);
CREATE TABLE owid_number_of_incident_tuberculosis_cases_in_children_72f717e1 (
"year" INTEGER,
"country" VARCHAR,
"number_of_incident_tuberculosis_cases_in_children_aged_0_14" UINTEGER -- Number Of Incident Tuberculosis Cases In Children Aged 0, 14,
"number_of_incident_tuberculosis_cases_in_children_aged_0_14_low" UINTEGER -- Number Of Incident Tuberculosis Cases In Children Aged 0, 14 Low,
"number_of_incident_tuberculosis_cases_in_children_aged_75997952" UINTEGER -- Number Of Incident Tuberculosis Cases In Children Aged 0, 14 High,
"comments" VARCHAR
);
CREATE TABLE owid_number_of_incident_tuberculosis_cases_in_children_e13eb905 (
"year" INTEGER,
"country" VARCHAR,
"number_of_incident_tuberculosis_cases_in_children_aged_0_14" UINTEGER -- Number Of Incident Tuberculosis Cases In Children Aged 0, 14
);
CREATE TABLE owid_number_of_indigenous_malaria_cases_1 (
"year" INTEGER,
"country" VARCHAR,
"number_of_indigenous_malaria_cases" UINTEGER
);
CREATE TABLE owid_number_of_indigenous_malaria_cases_2 (
"year" INTEGER,
"country" VARCHAR,
"number_of_indigenous_malaria_cases" UINTEGER,
"number_of_indigenous_malaria_cases_low" VARCHAR,
"number_of_indigenous_malaria_cases_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_number_of_indigenous_p_falciparum_malaria_cases_1 (
"year" INTEGER,
"country" VARCHAR,
"number_of_indigenous_p_falciparum_malaria_cases" UINTEGER -- Number Of Indigenous P, Falciparum Malaria Cases
);
CREATE TABLE owid_number_of_indigenous_p_falciparum_malaria_cases_2 (
"year" INTEGER,
"country" VARCHAR,
"number_of_indigenous_p_falciparum_malaria_cases" UINTEGER -- Number Of Indigenous P, Falciparum Malaria Cases,
"number_of_indigenous_p_falciparum_malaria_cases_low" VARCHAR -- Number Of Indigenous P, Falciparum Malaria Cases Low,
"number_of_indigenous_p_falciparum_malaria_cases_high" VARCHAR -- Number Of Indigenous P, Falciparum Malaria Cases High,
"comments" VARCHAR
);
CREATE TABLE owid_number_of_indigenous_p_vivax_malaria_cases_1 (
"year" INTEGER,
"country" VARCHAR,
"number_of_indigenous_p_vivax_malaria_cases" UINTEGER -- Number Of Indigenous P, Vivax Malaria Cases
);
CREATE TABLE owid_number_of_indigenous_p_vivax_malaria_cases_2 (
"year" INTEGER,
"country" VARCHAR,
"number_of_indigenous_p_vivax_malaria_cases" UINTEGER -- Number Of Indigenous P, Vivax Malaria Cases,
"number_of_indigenous_p_vivax_malaria_cases_low" VARCHAR -- Number Of Indigenous P, Vivax Malaria Cases Low,
"number_of_indigenous_p_vivax_malaria_cases_high" VARCHAR -- Number Of Indigenous P, Vivax Malaria Cases High,
"comments" VARCHAR
);
CREATE TABLE owid_number_of_infant_deaths_between_birth_and_11_months_1 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"number_of_infant_deaths_between_birth_and_11_months" UINTEGER -- Number Of Infant Deaths, Between Birth And 11 Months
);
CREATE TABLE owid_number_of_infant_deaths_between_birth_and_11_months_2 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"age_group" VARCHAR,
"number_of_infant_deaths_between_birth_and_11_months" UINTEGER -- Number Of Infant Deaths, Between Birth And 11 Months,
"number_of_infant_deaths_between_birth_and_11_months_low" UINTEGER -- Number Of Infant Deaths, Between Birth And 11 Months Low,
"number_of_infant_deaths_between_birth_and_11_months_high" UINTEGER -- Number Of Infant Deaths, Between Birth And 11 Months High,
"comments" VARCHAR
);
CREATE TABLE owid_number_of_insecticide_classes_to_which_resistance_1f51259d (
"year" INTEGER,
"country" VARCHAR,
"number_of_insecticide_classes_to_which_resistance_was_reported" INTEGER,
"number_of_insecticide_classes_to_which_resistance_was__93c1e218" VARCHAR -- Number Of Insecticide Classes To Which Resistance Was Reported Low,
"number_of_insecticide_classes_to_which_resistance_was__deb9f10d" VARCHAR -- Number Of Insecticide Classes To Which Resistance Was Reported High,
"comments" VARCHAR
);
CREATE TABLE owid_number_of_insecticide_classes_to_which_resistance_aa5c2626 (
"year" INTEGER,
"country" VARCHAR,
"number_of_insecticide_classes_to_which_resistance_was_reported" INTEGER
);
Anyone who has the link will be able to view this.