Global Health Observatory - World Health Organization
@owid.gho
@owid.gho
The GHO data repository is WHO's gateway to health-related statistics for its 194 Member States. It provides access to over 1000 indicators on priority health topics including mortality and burden of diseases, the Millennium Development Goals (child nutrition, child health, maternal and reproductive health, immunization, HIV/AIDS, tuberculosis, malaria, neglected diseases, water and sanitation), non communicable diseases and risk factors, epidemic-prone diseases, health systems, environmental health, violence and injuries, equity among others.
CREATE TABLE owid_treatment_success_rate_previously_treated_tb_cases_1 (
"year" INTEGER,
"country" VARCHAR,
"treatment_success_rate_previously_treated_tb_cases" INTEGER -- Treatment Success Rate, Previously Treated Tb Cases
);CREATE TABLE owid_treatment_success_rate_previously_treated_tb_cases_2 (
"year" INTEGER,
"country" VARCHAR,
"treatment_success_rate_previously_treated_tb_cases" INTEGER -- Treatment Success Rate, Previously Treated Tb Cases,
"treatment_success_rate_previously_treated_tb_cases_low" VARCHAR -- Treatment Success Rate, Previously Treated Tb Cases Low,
"treatment_success_rate_previously_treated_tb_cases_high" VARCHAR -- Treatment Success Rate, Previously Treated Tb Cases High,
"comments" VARCHAR
);CREATE TABLE owid_treatment_success_rate_xdr_tb_cases_1 (
"year" INTEGER,
"country" VARCHAR,
"treatment_success_rate_xdr_tb_cases" INTEGER -- Treatment Success Rate, Xdr Tb Cases
);CREATE TABLE owid_treatment_success_rate_xdr_tb_cases_2 (
"year" INTEGER,
"country" VARCHAR,
"treatment_success_rate_xdr_tb_cases" INTEGER -- Treatment Success Rate, Xdr Tb Cases,
"treatment_success_rate_xdr_tb_cases_low" VARCHAR -- Treatment Success Rate, Xdr Tb Cases Low,
"treatment_success_rate_xdr_tb_cases_high" VARCHAR -- Treatment Success Rate, Xdr Tb Cases High,
"comments" VARCHAR
);CREATE TABLE owid_treatment_system_for_substance_use_disorders_1 (
"year" INTEGER,
"country" VARCHAR,
"treatment_system_for_substance_use_disorders" VARCHAR
);CREATE TABLE owid_treatment_system_for_substance_use_disorders_2 (
"year" INTEGER,
"country" VARCHAR,
"treatment_system_for_substance_use_disorders" VARCHAR,
"treatment_system_for_substance_use_disorders_low" VARCHAR,
"treatment_system_for_substance_use_disorders_high" VARCHAR,
"comments" VARCHAR
);CREATE TABLE owid_tuberculosis_effective_treatment_coverage_pct (
"year" INTEGER,
"country" VARCHAR,
"tuberculosis_effective_treatment_coverage_pct" FLOAT -- Tuberculosis Effective Treatment Coverage, Pct
);CREATE TABLE owid_tuberculosis_new_and_relapse_cases_1 (
"year" INTEGER,
"country" VARCHAR,
"tuberculosis_new_and_relapse_cases" UINTEGER -- Tuberculosis, New And Relapse Cases
);CREATE TABLE owid_tuberculosis_new_and_relapse_cases_2 (
"year" INTEGER,
"country" VARCHAR,
"tuberculosis_new_and_relapse_cases" UINTEGER -- Tuberculosis, New And Relapse Cases,
"tuberculosis_new_and_relapse_cases_low" VARCHAR -- Tuberculosis, New And Relapse Cases Low,
"tuberculosis_new_and_relapse_cases_high" VARCHAR -- Tuberculosis, New And Relapse Cases High,
"comments" VARCHAR
);CREATE TABLE owid_tuberculosis_new_and_relapse_cases_tb_c_newinc_1 (
"year" INTEGER,
"country" VARCHAR,
"tuberculosis_new_and_relapse_cases_tb_c_newinc" UINTEGER -- Tuberculosis, New And Relapse Cases, Tb C Newinc
);CREATE TABLE owid_tuberculosis_new_and_relapse_cases_tb_c_newinc_2 (
"year" INTEGER,
"country" VARCHAR,
"tuberculosis_new_and_relapse_cases_tb_c_newinc" UINTEGER -- Tuberculosis, New And Relapse Cases, Tb C Newinc,
"tuberculosis_new_and_relapse_cases_tb_c_newinc_low" VARCHAR -- Tuberculosis, New And Relapse Cases, Tb C Newinc Low,
"tuberculosis_new_and_relapse_cases_tb_c_newinc_high" VARCHAR -- Tuberculosis, New And Relapse Cases, Tb C Newinc High,
"comments" VARCHAR
);CREATE TABLE owid_tuberculosis_treatment_coverage_1 (
"year" INTEGER,
"country" VARCHAR,
"tuberculosis_treatment_coverage" FLOAT
);CREATE TABLE owid_tuberculosis_treatment_coverage_2 (
"year" INTEGER,
"country" VARCHAR,
"tuberculosis_treatment_coverage" FLOAT,
"tuberculosis_treatment_coverage_low" FLOAT,
"tuberculosis_treatment_coverage_high" FLOAT,
"comments" VARCHAR
);CREATE TABLE owid_tx_person_years_lived_above_age_x_1 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"age_group" VARCHAR,
"tx_person_years_lived_above_age_x" FLOAT -- Tx, Person Years Lived Above Age X
);CREATE TABLE owid_tx_person_years_lived_above_age_x_2 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"age_group" VARCHAR,
"tx_person_years_lived_above_age_x" FLOAT -- Tx, Person Years Lived Above Age X,
"tx_person_years_lived_above_age_x_low" VARCHAR -- Tx, Person Years Lived Above Age X Low,
"tx_person_years_lived_above_age_x_high" VARCHAR -- Tx, Person Years Lived Above Age X High,
"comments" VARCHAR
);CREATE TABLE owid_type_of_excise_tax_applied_on_beverage_1 (
"year" INTEGER,
"country" VARCHAR,
"beverage_type" VARCHAR,
"beverage" VARCHAR,
"comments" VARCHAR,
"type_of_excise_tax_applied_on_beverage" VARCHAR
);CREATE TABLE owid_type_of_excise_tax_applied_on_beverage_2 (
"year" INTEGER,
"country" VARCHAR,
"beverage_type" VARCHAR,
"beverage" VARCHAR,
"type_of_excise_tax_applied_on_beverage" VARCHAR,
"type_of_excise_tax_applied_on_beverage_low" VARCHAR,
"type_of_excise_tax_applied_on_beverage_high" VARCHAR,
"comments" VARCHAR
);CREATE TABLE owid_type_of_national_cervical_cancer_screening_program_1 (
"year" INTEGER,
"country" VARCHAR,
"comments" VARCHAR,
"type_of_national_cervical_cancer_screening_program" VARCHAR
);CREATE TABLE owid_type_of_national_cervical_cancer_screening_program_2 (
"year" INTEGER,
"country" VARCHAR,
"type_of_national_cervical_cancer_screening_program" VARCHAR,
"type_of_national_cervical_cancer_screening_program_low" VARCHAR,
"type_of_national_cervical_cancer_screening_program_high" VARCHAR,
"comments" VARCHAR
);CREATE TABLE owid_type_of_nomenclature_system_1 (
"year" INTEGER,
"country" VARCHAR,
"type_of_nomenclature_system" INTEGER,
"comments" VARCHAR
);CREATE TABLE owid_type_of_nomenclature_system_2 (
"year" INTEGER,
"country" VARCHAR,
"type_of_nomenclature_system" INTEGER,
"type_of_nomenclature_system_low" VARCHAR,
"type_of_nomenclature_system_high" VARCHAR,
"comments" VARCHAR
);CREATE TABLE owid_types_of_antimicrobial_susceptibility_testing_ast_9708aee5 (
"year" INTEGER,
"country" VARCHAR,
"amr_glass_category" VARCHAR,
"types_of_antimicrobial_susceptibility_testing_ast_stan_5ca000bf" FLOAT -- Types Of Antimicrobial Susceptibility Testing, Ast, Standards Followed By Countries
);CREATE TABLE owid_types_of_antimicrobial_susceptibility_testing_ast_c01dd597 (
"year" INTEGER,
"country" VARCHAR,
"amr_glass_category" VARCHAR,
"types_of_antimicrobial_susceptibility_testing_ast_stan_5ca000bf" FLOAT -- Types Of Antimicrobial Susceptibility Testing, Ast, Standards Followed By Countries,
"types_of_antimicrobial_susceptibility_testing_ast_stan_fc3eb35a" VARCHAR -- Types Of Antimicrobial Susceptibility Testing, Ast, Standards Followed By Countries Low,
"types_of_antimicrobial_susceptibility_testing_ast_stan_82b1cc23" VARCHAR -- Types Of Antimicrobial Susceptibility Testing, Ast, Standards Followed By Countries High,
"comments" VARCHAR
);CREATE TABLE owid_types_of_lists_recommending_health_technology_for_bb1fc0a0 (
"year" INTEGER,
"country" VARCHAR,
"types_of_lists_recommending_health_technology_for_high_b594309f" INTEGER -- Types Of Lists Recommending Health Technology For High Burden Diseases
);CREATE TABLE owid_types_of_lists_recommending_health_technology_for_c5273e13 (
"year" INTEGER,
"country" VARCHAR,
"types_of_lists_recommending_health_technology_for_high_b594309f" INTEGER -- Types Of Lists Recommending Health Technology For High Burden Diseases,
"types_of_lists_recommending_health_technology_for_high_4bc125a2" VARCHAR -- Types Of Lists Recommending Health Technology For High Burden Diseases Low,
"types_of_lists_recommending_health_technology_for_high_0ee931bd" VARCHAR -- Types Of Lists Recommending Health Technology For High Burden Diseases High,
"comments" VARCHAR
);Anyone who has the link will be able to view this.