Global Tuberculosis Report - Burden Estimates
@owid.burden_estimates
@owid.burden_estimates
WHO has published a global tuberculosis (TB) report every year since 1997. The report provides a comprehensive and up-to-date assessment of the TB epidemic, and of progress in prevention, diagnosis and treatment of the disease at global, regional and country levels.
CREATE TABLE owid_burden_estimates_1 (
"country" VARCHAR,
"year" INTEGER,
"e_inc_100k" FLOAT,
"e_inc_100k_lo" FLOAT,
"e_inc_100k_hi" FLOAT,
"e_inc_num" UINTEGER,
"e_inc_num_lo" UINTEGER,
"e_inc_num_hi" UINTEGER,
"e_tbhiv_prct" FLOAT,
"e_tbhiv_prct_lo" FLOAT,
"e_tbhiv_prct_hi" FLOAT,
"e_inc_tbhiv_100k" FLOAT,
"e_inc_tbhiv_100k_lo" FLOAT,
"e_inc_tbhiv_100k_hi" FLOAT,
"e_inc_tbhiv_num" UINTEGER,
"e_inc_tbhiv_num_lo" UINTEGER,
"e_inc_tbhiv_num_hi" UINTEGER,
"e_mort_exc_tbhiv_100k" FLOAT,
"e_mort_exc_tbhiv_100k_lo" FLOAT,
"e_mort_exc_tbhiv_100k_hi" FLOAT,
"e_mort_exc_tbhiv_num" UINTEGER,
"e_mort_exc_tbhiv_num_lo" UINTEGER,
"e_mort_exc_tbhiv_num_hi" UINTEGER,
"e_mort_tbhiv_100k" FLOAT,
"e_mort_tbhiv_100k_lo" FLOAT,
"e_mort_tbhiv_100k_hi" FLOAT,
"e_mort_tbhiv_num" UINTEGER,
"e_mort_tbhiv_num_lo" UINTEGER,
"e_mort_tbhiv_num_hi" UINTEGER,
"e_mort_100k" FLOAT,
"e_mort_100k_lo" FLOAT,
"e_mort_100k_hi" FLOAT,
"e_mort_num" UINTEGER,
"e_mort_num_lo" UINTEGER,
"e_mort_num_hi" UINTEGER,
"cfr" FLOAT,
"cfr_lo" FLOAT,
"cfr_hi" FLOAT,
"cfr_pct" FLOAT,
"cfr_pct_lo" INTEGER,
"cfr_pct_hi" INTEGER,
"c_newinc_100k" FLOAT,
"c_cdr" FLOAT,
"c_cdr_lo" FLOAT,
"c_cdr_hi" FLOAT
);CREATE TABLE owid_burden_estimates_2 (
"country" VARCHAR,
"year" INTEGER,
"e_inc_100k" FLOAT,
"e_inc_100k_lo" FLOAT,
"e_inc_100k_hi" FLOAT,
"e_inc_num" UINTEGER,
"e_inc_num_lo" UINTEGER,
"e_inc_num_hi" UINTEGER,
"e_tbhiv_prct" FLOAT,
"e_tbhiv_prct_lo" FLOAT,
"e_tbhiv_prct_hi" FLOAT,
"e_inc_tbhiv_100k" FLOAT,
"e_inc_tbhiv_100k_lo" FLOAT,
"e_inc_tbhiv_100k_hi" FLOAT,
"e_inc_tbhiv_num" UINTEGER,
"e_inc_tbhiv_num_lo" UINTEGER,
"e_inc_tbhiv_num_hi" UINTEGER,
"e_mort_exc_tbhiv_100k" FLOAT,
"e_mort_exc_tbhiv_100k_lo" FLOAT,
"e_mort_exc_tbhiv_100k_hi" FLOAT,
"e_mort_exc_tbhiv_num" UINTEGER,
"e_mort_exc_tbhiv_num_lo" UINTEGER,
"e_mort_exc_tbhiv_num_hi" UINTEGER,
"e_mort_tbhiv_100k" FLOAT,
"e_mort_tbhiv_100k_lo" FLOAT,
"e_mort_tbhiv_100k_hi" FLOAT,
"e_mort_tbhiv_num" UINTEGER,
"e_mort_tbhiv_num_lo" INTEGER,
"e_mort_tbhiv_num_hi" UINTEGER,
"e_mort_100k" FLOAT,
"e_mort_100k_lo" FLOAT,
"e_mort_100k_hi" FLOAT,
"e_mort_num" UINTEGER,
"e_mort_num_lo" UINTEGER,
"e_mort_num_hi" UINTEGER,
"cfr" FLOAT,
"cfr_lo" FLOAT,
"cfr_hi" FLOAT,
"cfr_pct" FLOAT,
"cfr_pct_lo" INTEGER,
"cfr_pct_hi" INTEGER,
"c_newinc_100k" FLOAT,
"c_cdr" FLOAT,
"c_cdr_lo" FLOAT,
"c_cdr_hi" FLOAT
);Anyone who has the link will be able to view this.