Global Health Observatory - World Health Organization
@owid.gho
@owid.gho
CREATE TABLE owid_treatment_success_rate_previously_treated_tb_cases_1 (
"year" INTEGER,
"country" VARCHAR,
"treatment_success_rate_previously_treated_tb_cases" INTEGER
);
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_low" VARCHAR,
"treatment_success_rate_previously_treated_tb_cases_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_treatment_success_rate_xdr_tb_cases_1 (
"year" INTEGER,
"country" VARCHAR,
"treatment_success_rate_xdr_tb_cases" INTEGER
);
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_low" VARCHAR,
"treatment_success_rate_xdr_tb_cases_high" VARCHAR,
"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
);
CREATE TABLE owid_tuberculosis_new_and_relapse_cases_1 (
"year" INTEGER,
"country" VARCHAR,
"tuberculosis_new_and_relapse_cases" UINTEGER
);
CREATE TABLE owid_tuberculosis_new_and_relapse_cases_2 (
"year" INTEGER,
"country" VARCHAR,
"tuberculosis_new_and_relapse_cases" UINTEGER,
"tuberculosis_new_and_relapse_cases_low" VARCHAR,
"tuberculosis_new_and_relapse_cases_high" VARCHAR,
"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
);
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_low" VARCHAR,
"tuberculosis_new_and_relapse_cases_tb_c_newinc_high" VARCHAR,
"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
);
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_low" VARCHAR,
"tx_person_years_lived_above_age_x_high" VARCHAR,
"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
);
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_stan_fc3eb35a" VARCHAR,
"types_of_antimicrobial_susceptibility_testing_ast_stan_82b1cc23" VARCHAR,
"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
);
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_4bc125a2" VARCHAR,
"types_of_lists_recommending_health_technology_for_high_0ee931bd" VARCHAR,
"comments" VARCHAR
);
Anyone who has the link will be able to view this.