Global Health Observatory - World Health Organization
@owid.gho
@owid.gho
CREATE TABLE owid_nqx_probability_of_dying_between_ages_x_and_xplusn_2 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"age_group" VARCHAR,
"nqx_probability_of_dying_between_ages_x_and_xplusn" FLOAT -- Nqx, Probability Of Dying Between Ages X And Xplusn,
"nqx_probability_of_dying_between_ages_x_and_xplusn_low" VARCHAR -- Nqx, Probability Of Dying Between Ages X And Xplusn Low,
"nqx_probability_of_dying_between_ages_x_and_xplusn_high" VARCHAR -- Nqx, Probability Of Dying Between Ages X And Xplusn High,
"comments" VARCHAR
);
CREATE TABLE owid_number_of_biomedical_engineers_1 (
"year" INTEGER,
"country" VARCHAR,
"number_of_biomedical_engineers" UINTEGER,
"comments" VARCHAR
);
CREATE TABLE owid_number_of_biomedical_engineers_2 (
"year" INTEGER,
"country" VARCHAR,
"number_of_biomedical_engineers" UINTEGER,
"number_of_biomedical_engineers_low" VARCHAR,
"number_of_biomedical_engineers_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_number_of_biomedical_technicians_1 (
"year" INTEGER,
"country" VARCHAR,
"number_of_biomedical_technicians" UINTEGER,
"comments" VARCHAR
);
CREATE TABLE owid_number_of_biomedical_technicians_2 (
"year" INTEGER,
"country" VARCHAR,
"number_of_biomedical_technicians" UINTEGER,
"number_of_biomedical_technicians_low" VARCHAR,
"number_of_biomedical_technicians_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_number_of_cases_of_cutaneous_leishmaniasis_reported_1 (
"year" INTEGER,
"country" VARCHAR,
"number_of_cases_of_cutaneous_leishmaniasis_reported" UINTEGER,
"comments" VARCHAR
);
CREATE TABLE owid_number_of_cases_of_cutaneous_leishmaniasis_reported_2 (
"year" INTEGER,
"country" VARCHAR,
"number_of_cases_of_cutaneous_leishmaniasis_reported" UINTEGER,
"number_of_cases_of_cutaneous_leishmaniasis_reported_low" VARCHAR,
"number_of_cases_of_cutaneous_leishmaniasis_reported_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_number_of_cases_of_visceral_leishmaniasis_reported_1 (
"year" INTEGER,
"country" VARCHAR,
"number_of_cases_of_visceral_leishmaniasis_reported" INTEGER
);
CREATE TABLE owid_number_of_cases_of_visceral_leishmaniasis_reported_2 (
"year" INTEGER,
"country" VARCHAR,
"number_of_cases_of_visceral_leishmaniasis_reported" INTEGER,
"number_of_cases_of_visceral_leishmaniasis_reported_low" VARCHAR,
"number_of_cases_of_visceral_leishmaniasis_reported_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_number_of_cases_of_yaws_reported_1 (
"year" INTEGER,
"country" VARCHAR,
"number_of_cases_of_yaws_reported" UINTEGER
);
CREATE TABLE owid_number_of_cases_of_yaws_reported_2 (
"year" INTEGER,
"country" VARCHAR,
"number_of_cases_of_yaws_reported" UINTEGER,
"number_of_cases_of_yaws_reported_low" INTEGER,
"number_of_cases_of_yaws_reported_high" INTEGER,
"comments" INTEGER
);
CREATE TABLE owid_number_of_children_aged_6_59_months_with_anaemia__6069824b (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"severity" VARCHAR,
"number_of_children_aged_6_59_months_with_anaemia_thousands" FLOAT -- Number Of Children Aged 6–59 Months With Anaemia, Thousands
);
CREATE TABLE owid_number_of_children_aged_6_59_months_with_anaemia__d677b622 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"severity" VARCHAR,
"number_of_children_aged_6_59_months_with_anaemia_thousands" FLOAT -- Number Of Children Aged 6–59 Months With Anaemia, Thousands,
"number_of_children_aged_6_59_months_with_anaemia_thousands_low" FLOAT -- Number Of Children Aged 6–59 Months With Anaemia, Thousands Low,
"number_of_children_aged_6_59_months_with_anaemia_thousands_high" FLOAT -- Number Of Children Aged 6–59 Months With Anaemia, Thousands High,
"comments" VARCHAR
);
CREATE TABLE owid_number_of_confirmed_malaria_cases_1 (
"year" INTEGER,
"country" VARCHAR,
"number_of_confirmed_malaria_cases" UINTEGER
);
CREATE TABLE owid_number_of_confirmed_malaria_cases_2 (
"year" INTEGER,
"country" VARCHAR,
"number_of_confirmed_malaria_cases" UINTEGER,
"number_of_confirmed_malaria_cases_low" VARCHAR,
"number_of_confirmed_malaria_cases_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_number_of_confirmed_yaws_cases_reported_1 (
"year" INTEGER,
"country" VARCHAR,
"number_of_confirmed_yaws_cases_reported" INTEGER
);
CREATE TABLE owid_number_of_confirmed_yaws_cases_reported_2 (
"year" INTEGER,
"country" VARCHAR,
"number_of_confirmed_yaws_cases_reported" INTEGER,
"number_of_confirmed_yaws_cases_reported_low" VARCHAR,
"number_of_confirmed_yaws_cases_reported_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_number_of_deaths_among_children_ages_10_to_14_years_1 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"number_of_deaths_among_children_ages_10_to_14_years" UINTEGER
);
CREATE TABLE owid_number_of_deaths_among_children_ages_10_to_14_years_2 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"number_of_deaths_among_children_ages_10_to_14_years" UINTEGER,
"number_of_deaths_among_children_ages_10_to_14_years_low" UINTEGER,
"number_of_deaths_among_children_ages_10_to_14_years_high" UINTEGER,
"comments" VARCHAR
);
CREATE TABLE owid_number_of_deaths_among_children_ages_5_to_9_years_1 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"number_of_deaths_among_children_ages_5_to_9_years" UINTEGER
);
CREATE TABLE owid_number_of_deaths_among_children_ages_5_to_9_years_2 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"age_group" VARCHAR,
"number_of_deaths_among_children_ages_5_to_9_years" UINTEGER,
"number_of_deaths_among_children_ages_5_to_9_years_low" UINTEGER,
"number_of_deaths_among_children_ages_5_to_9_years_high" UINTEGER,
"comments" VARCHAR
);
CREATE TABLE owid_number_of_deaths_among_children_under_five_1 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"number_of_deaths_among_children_under_five" UINTEGER
);
CREATE TABLE owid_number_of_deaths_among_children_under_five_2 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"age_group" VARCHAR,
"wealth_quintile" VARCHAR,
"number_of_deaths_among_children_under_five" UINTEGER,
"number_of_deaths_among_children_under_five_low" UINTEGER,
"number_of_deaths_among_children_under_five_high" UINTEGER,
"comments" VARCHAR
);
CREATE TABLE owid_number_of_deaths_attributed_to_non_communicable_d_b7d0cfee (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"causes" VARCHAR,
"number_of_deaths_attributed_to_non_communicable_diseas_7e982ef4" FLOAT -- Number Of Deaths Attributed To Non Communicable Diseases, By Type Of Disease And Sex
);
CREATE TABLE owid_number_of_deaths_attributed_to_non_communicable_d_f1a9b561 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"causes" VARCHAR,
"number_of_deaths_attributed_to_non_communicable_diseas_7e982ef4" FLOAT -- Number Of Deaths Attributed To Non Communicable Diseases, By Type Of Disease And Sex,
"number_of_deaths_attributed_to_non_communicable_diseas_79ce273e" FLOAT -- Number Of Deaths Attributed To Non Communicable Diseases, By Type Of Disease And Sex Low,
"number_of_deaths_attributed_to_non_communicable_diseas_dd439f1a" FLOAT -- Number Of Deaths Attributed To Non Communicable Diseases, By Type Of Disease And Sex High,
"comments" VARCHAR
);
Anyone who has the link will be able to view this.