Global Health Observatory - World Health Organization
@owid.gho
@owid.gho
CREATE TABLE owid_number_of_malaria_cases_treated_with_any_first_li_8fbfb53e (
"year" INTEGER,
"country" VARCHAR,
"number_of_malaria_cases_treated_with_any_first_line_tx_088a9a17" UINTEGER -- Number Of Malaria Cases Treated With Any First, Line Tx Courses, Including Artemisinin Based Combination Therapies, Acts,
"number_of_malaria_cases_treated_with_any_first_line_tx_f6227010" VARCHAR -- Number Of Malaria Cases Treated With Any First, Line Tx Courses, Including Artemisinin Based Combination Therapies, Acts Low,
"number_of_malaria_cases_treated_with_any_first_line_tx_08cd35c1" VARCHAR -- Number Of Malaria Cases Treated With Any First, Line Tx Courses, Including Artemisinin Based Combination Therapies, Acts High,
"comments" VARCHAR
);
CREATE TABLE owid_number_of_malaria_cases_treated_with_artemisinin__0e4c5de4 (
"year" INTEGER,
"country" VARCHAR,
"number_of_malaria_cases_treated_with_artemisinin_based_f2186753" FLOAT -- Number Of Malaria Cases Treated With Artemisinin Based Combination Therapies, Acts,
"number_of_malaria_cases_treated_with_artemisinin_based_e8dfe547" VARCHAR -- Number Of Malaria Cases Treated With Artemisinin Based Combination Therapies, Acts Low,
"number_of_malaria_cases_treated_with_artemisinin_based_3fadce2e" VARCHAR -- Number Of Malaria Cases Treated With Artemisinin Based Combination Therapies, Acts High,
"comments" VARCHAR
);
CREATE TABLE owid_number_of_malaria_cases_treated_with_artemisinin__fa7dbe78 (
"year" INTEGER,
"country" VARCHAR,
"number_of_malaria_cases_treated_with_artemisinin_based_f2186753" UINTEGER -- Number Of Malaria Cases Treated With Artemisinin Based Combination Therapies, Acts
);
CREATE TABLE owid_number_of_malaria_positive_cases_by_microscopy_1 (
"year" INTEGER,
"country" VARCHAR,
"number_of_malaria_positive_cases_by_microscopy" UINTEGER
);
CREATE TABLE owid_number_of_malaria_positive_cases_by_microscopy_2 (
"year" INTEGER,
"country" VARCHAR,
"number_of_malaria_positive_cases_by_microscopy" UINTEGER,
"number_of_malaria_positive_cases_by_microscopy_low" VARCHAR,
"number_of_malaria_positive_cases_by_microscopy_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_number_of_malaria_positive_cases_by_rapid_diagnos_7d5ede8b (
"year" INTEGER,
"country" VARCHAR,
"number_of_malaria_positive_cases_by_rapid_diagnostic_test_rdt" UINTEGER -- Number Of Malaria Positive Cases By Rapid Diagnostic Test, Rdt
);
CREATE TABLE owid_number_of_malaria_positive_cases_by_rapid_diagnos_d9f73942 (
"year" INTEGER,
"country" VARCHAR,
"number_of_malaria_positive_cases_by_rapid_diagnostic_test_rdt" UINTEGER -- Number Of Malaria Positive Cases By Rapid Diagnostic Test, Rdt,
"number_of_malaria_positive_cases_by_rapid_diagnostic_t_2cf5527f" VARCHAR -- Number Of Malaria Positive Cases By Rapid Diagnostic Test, Rdt Low,
"number_of_malaria_positive_cases_by_rapid_diagnostic_t_614914d5" VARCHAR -- Number Of Malaria Positive Cases By Rapid Diagnostic Test, Rdt High,
"comments" VARCHAR
);
CREATE TABLE owid_number_of_malaria_suspects_examined_by_microscopy_1 (
"year" INTEGER,
"country" VARCHAR,
"number_of_malaria_suspects_examined_by_microscopy" UINTEGER
);
CREATE TABLE owid_number_of_malaria_suspects_examined_by_microscopy_2 (
"year" INTEGER,
"country" VARCHAR,
"number_of_malaria_suspects_examined_by_microscopy" UINTEGER,
"number_of_malaria_suspects_examined_by_microscopy_low" VARCHAR,
"number_of_malaria_suspects_examined_by_microscopy_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_number_of_malaria_suspects_examined_by_rapid_diag_58ac2c37 (
"year" INTEGER,
"country" VARCHAR,
"number_of_malaria_suspects_examined_by_rapid_diagnosti_97000371" UINTEGER -- Number Of Malaria Suspects Examined By Rapid Diagnostic Test, Rdt
);
CREATE TABLE owid_number_of_malaria_suspects_examined_by_rapid_diag_f71a2cfe (
"year" INTEGER,
"country" VARCHAR,
"number_of_malaria_suspects_examined_by_rapid_diagnosti_97000371" UINTEGER -- Number Of Malaria Suspects Examined By Rapid Diagnostic Test, Rdt,
"number_of_malaria_suspects_examined_by_rapid_diagnosti_aec6c20d" VARCHAR -- Number Of Malaria Suspects Examined By Rapid Diagnostic Test, Rdt Low,
"number_of_malaria_suspects_examined_by_rapid_diagnosti_0a72379e" VARCHAR -- Number Of Malaria Suspects Examined By Rapid Diagnostic Test, Rdt High,
"comments" VARCHAR
);
CREATE TABLE owid_number_of_maternal_deaths_1 (
"year" INTEGER,
"country" VARCHAR,
"number_of_maternal_deaths" FLOAT
);
CREATE TABLE owid_number_of_maternal_deaths_2 (
"year" INTEGER,
"country" VARCHAR,
"number_of_maternal_deaths" FLOAT,
"number_of_maternal_deaths_low" FLOAT,
"number_of_maternal_deaths_high" FLOAT,
"comments" VARCHAR
);
CREATE TABLE owid_number_of_meningitis_epidemic_districts_1 (
"year" INTEGER,
"country" VARCHAR,
"number_of_meningitis_epidemic_districts" INTEGER,
"comments" VARCHAR
);
CREATE TABLE owid_number_of_meningitis_epidemic_districts_2 (
"year" INTEGER,
"country" VARCHAR,
"number_of_meningitis_epidemic_districts" INTEGER,
"number_of_meningitis_epidemic_districts_low" VARCHAR,
"number_of_meningitis_epidemic_districts_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_number_of_neonatal_deaths_0_to_27_days_1 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"number_of_neonatal_deaths_0_to_27_days" UINTEGER -- Number Of Neonatal Deaths, 0 To 27 Days
);
CREATE TABLE owid_number_of_neonatal_deaths_0_to_27_days_2 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"age_group" VARCHAR,
"number_of_neonatal_deaths_0_to_27_days" UINTEGER -- Number Of Neonatal Deaths, 0 To 27 Days,
"number_of_neonatal_deaths_0_to_27_days_low" UINTEGER -- Number Of Neonatal Deaths, 0 To 27 Days Low,
"number_of_neonatal_deaths_0_to_27_days_high" UINTEGER -- Number Of Neonatal Deaths, 0 To 27 Days High,
"comments" VARCHAR
);
CREATE TABLE owid_number_of_neurologists_per_100_000_1 (
"year" INTEGER,
"country" VARCHAR,
"number_of_neurologists_per_100_000" FLOAT -- Number Of Neurologists, Per 100–000
);
CREATE TABLE owid_number_of_neurologists_per_100_000_2 (
"year" INTEGER,
"country" VARCHAR,
"number_of_neurologists_per_100_000" FLOAT -- Number Of Neurologists, Per 100–000,
"number_of_neurologists_per_100_000_low" VARCHAR -- Number Of Neurologists, Per 100–000 Low,
"number_of_neurologists_per_100_000_high" VARCHAR -- Number Of Neurologists, Per 100–000 High,
"comments" VARCHAR
);
CREATE TABLE owid_number_of_new_cases_of_lip_and_oral_cavity_cancer_1 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"number_of_new_cases_of_lip_and_oral_cavity_cancer" UINTEGER
);
CREATE TABLE owid_number_of_new_cases_of_lip_and_oral_cavity_cancer_2 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"number_of_new_cases_of_lip_and_oral_cavity_cancer" UINTEGER,
"number_of_new_cases_of_lip_and_oral_cavity_cancer_low" VARCHAR,
"number_of_new_cases_of_lip_and_oral_cavity_cancer_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_number_of_new_hiv_infections_1 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"number_of_new_hiv_infections" UINTEGER
);
CREATE TABLE owid_number_of_new_hiv_infections_2 (
"year" INTEGER,
"country" VARCHAR,
"number_of_new_hiv_infections" UINTEGER,
"number_of_new_hiv_infections_low" UINTEGER,
"number_of_new_hiv_infections_high" UINTEGER,
"comments" VARCHAR
);
CREATE TABLE owid_number_of_new_leprosy_cases_1 (
"year" INTEGER,
"country" VARCHAR,
"number_of_new_leprosy_cases" UINTEGER
);
CREATE TABLE owid_number_of_new_leprosy_cases_2 (
"year" INTEGER,
"country" VARCHAR,
"number_of_new_leprosy_cases" UINTEGER,
"number_of_new_leprosy_cases_low" VARCHAR,
"number_of_new_leprosy_cases_high" VARCHAR,
"comments" VARCHAR
);
Anyone who has the link will be able to view this.