TB (.xlsx)

Download original .xlsx file from GitHub

parameters

	parameter_name	value	lower	upper	notes
0	scaling_factor_WHO	1.60303
1	prop_mdr2010	0.0186
2	monthly_prob_relapse_tx_complete	0.0027	0.0014	0.00405
3	monthly_prob_relapse_tx_incomplete	0.0116	0.0058	0.0174
4	monthly_prob_relapse_2yrs	0.0001	5e-05	0.0015
5	rr_relapse_hiv	4.7
6	rr_relapse_diabetes	1.86			Huangfu et al 2019
7	duration_active_disease_years	3
8	prop_smear_positive	0.62	0.42	0.8
9	prop_smear_positive_hiv	0.35	0.19	0.54
10	death_rate_child0_4_treated	0.05
11	death_rate_child5_14_treated	0.06
12	death_rate_adult_treated	0.107	changed from 0.086
13	death_rate_smear_pos_untreated	0.7
14	death_rate_smear_neg_untreated	0.2
15	rr_death_diabetes	1.51			Huangfu et al 2019
16	rr_tb_child	0.1	assumed
17	rr_tb_bcg	0.42
18	rr_tb_hiv	5	assumed		20.6getahun2010
19	rr_tb_aids	26	assumed		26williams_pnas
20	rr_tb_art_adult	0.35
21	rr_tb_art_child	0.3
22	rr_tb_obese	0.4
23	rr_tb_diabetes	3
24	rr_tb_alcohol	2.9
25	rr_tb_smoking	1.3
26	rr_ipt_adult	0.4
27	rr_ipt_child	0.55
28	rr_ipt_adult_hiv	0.68
29	rr_ipt_child_hiv	0.31
30	rr_ipt_art_child	0.76
31	rr_ipt_art_adult	0.63
32	sens_xpert_smear_negative	0.68
33	sens_xpert_smear_positive	0.98
34	spec_xpert_smear_negative	0.99
35	spec_xpert_smear_positive	0.99
36	sens_sputum_smear_positive	1
37	spec_sputum_smear_positive	1
38	sens_clinical	0.209	0.12	0.33
39	spec_clinical	0.953	0.92	0.97
40	sens_xray_smear_negative	0.8
41	sens_xray_smear_positive	0.91
42	spec_xray_smear_negative	0.67
43	spec_xray_smear_positive	0.67
44	prob_tx_success_ds	0.837
45	prob_tx_success_mdr	0.597
46	prob_tx_success_0_4	0.94
47	prob_tx_success_5_14	0.92
48	rate_testing_general_pop	0.025
49	ds_treatment_length	6
50	ds_retreatment_length	8
51	mdr_treatment_length	24
52	prob_retained_ipt_6_months	0.9
53	age_eligibility_for_ipt	5
54	ipt_start_date	2014
55	first_line_test	sputum
56	second_line_test	xpert
57	tb_healthseekingbehaviour_cap	5
58	data_end	2022
59	length_of_inpatient_stay_if_terminal	[5,10]
60	type_of_scaleup	none
61	scaleup_start_year	2025

scaleup_parameters

	parameter	target_value	min_value	max_value
0	tb_treatment_coverage	90	0	100
1	tb_prob_tx_success_ds	0.9	0	1
2	tb_prob_tx_success_mdr	0.9	0	1
3	tb_prob_tx_success_0_4	0.9	0	1
4	tb_prob_tx_success_5_14	0.9	0	1
5	first_line_test	xpert	sputum	xpert
6	second_line_test	sputum	sputum	xpert
7	ipt_coverage_plhiv	0.9	0	1
8	ipt_coverage_paediatric	90	0	100

calibrated_transmission_rates

	draw	hiv	tb	deviance
0	1	0.125176	16.7101	0.814946
1	12	0.121988	18.0221	0.83383
2	0	0.10922	15.8241	0.862322
3	9	0.115698	19.2184	0.92932
4	16	0.13272	15.4037	0.96256

IPTdistricts

	district_name	region
0	Lilongwe City	central
1	Blantyre	southern
2	Mangochi	southern
3	Machinga	southern
4	Chikwawa	southern
5	Mzimba	northern
6	Thyolo	southern
7	Mulanje	southern
8	Nsanje	southern
9	Chiradzulu	southern

all_districts

	district_name
0	Balaka
1	Blantyre
2	Blantyre City
3	Chikwawa
4	Chiradzulu
5	Chitipa
6	Dedza
7	Dowa
8	Karonga
9	Kasungu
10	Likoma
11	Lilongwe
12	Lilongwe City
13	Machinga
14	Mangochi
15	Mchinji
16	Mulanje
17	Mwanza
18	Mzimba
19	Mzuzu City
20	Neno
21	Nkhata Bay
22	Nkhotakota
23	Nsanje
24	Ntcheu
25	Ntchisi
26	Phalombe
27	Rumphi
28	Salima
29	Thyolo
30	Zomba
31	Zomba City

ipt_coverage

	year	coverage_plhiv	source	coverage_paediatric	source2
0	2010	0	not_implemented	0
1	2011	0	not_implemented	0
2	2012	0	not_implemented	0
3	2013	0	not_implemented	0
4	2014	0	not_implemented	35	NTP2019
5	2015	0	not_implemented	42	NTP2019
6	2016	0	not_implemented	51	NTP2019
7	2017	0	not_implemented	61	NTP2019
8	2018	0.31	MoH_quart_repQ1	57	NTP2019
9	2019	0.3	MoH_quart_repQ2	57	NTP2020
10	2020	0.11	MoH_quart_repQ3	48	NTP2020
11	2021	0.3	no_data	41	NTP2021
12	2022	0.3	no_data	57
13	2023	0.3	no_data	57
14	2024	0.3	no_data	57
15	2025	0.3	no_data	57
16	2026	0.3	no_data	57
17	2027	0.3	no_data	57
18	2028	0.3	no_data	57
19	2029	0.3	no_data	57
20	2030	0.3	no_data	57
21	2031	0.3	no_data	57
22	2032	0.3	no_data	57
23	2033	0.3	no_data	57
24	2034	0.3	no_data	57
25	2035	0.3	no_data	57
26	2036	0.3	no_data	57
27	2037	0.3	no_data	57
28	2038	0.3	no_data	57
29	2039	0.3	no_data	57
30	2040	0.3	no_data	57
31	2041	0.3	no_data	57
32	2042	0.3	no_data	57
33	2043	0.3	no_data	57
34	2044	0.3	no_data	57
35	2045	0.3	no_data	57
36	2046	0.3	no_data	57
37	2047	0.3	no_data	57
38	2048	0.3	no_data	57
39	2049	0.3	no_data	57
40	2050	0.3	no_data	57

testing_rates

	year	testing_rate_active_cases	treatment_coverage	source
0	2010	45	45	assumed
1	2011	45	45	assumed
2	2012	47	47	who_reports_treatment_coverage
3	2013	44	44	who_reports_treatment_coverage
4	2014	45	45	who_reports_treatment_coverage
5	2015	50	50	who_reports_treatment_coverage
6	2016	58	58	who_reports_treatment_coverage
7	2017	71	71	who_reports_treatment_coverage
8	2018	75	75	assumed
9	2019	75	75	assumed
10	2020	75	75	assumed
11	2021	75	75	assumed
12	2022	75	75	assumed
13	2023	75	75	assumed
14	2024	75	75	assumed
15	2025	75	75	assumed
16	2026	75	75	assumed
17	2027	75	75	assumed
18	2028	75	75	assumed
19	2029	75	75	assumed
20	2030	75	75	assumed
21	2031	75	75	assumed
22	2032	75	75	assumed
23	2033	75	75	assumed
24	2034	75	75	assumed
25	2035	75	75	assumed
26	2036	75	75	assumed
27	2037	75	75	assumed
28	2038	75	75	assumed
29	2039	75	75	assumed
30	2040	75	75	assumed
31	2041	75	75	assumed
32	2042	75	75	assumed
33	2043	75	75	assumed
34	2044	75	75	assumed
35	2045	75	75	assumed
36	2046	75	75	assumed
37	2047	75	75	assumed
38	2048	75	75	assumed
39	2049	75	75	assumed
40	2050	75	75	assumed

pulm_tb

	age	hiv	prob_pulm
0	0	False	0.7
1	1	False	0.74
2	2	False	0.91
3	3	False	0.91
4	4	False	0.91
5	5	False	0.89
6	6	False	0.89
7	7	False	0.89
8	8	False	0.89
9	9	False	0.89
10	10	False	0.99
11	11	False	0.99
12	12	False	0.99
13	13	False	0.99
14	14	False	0.99
15	15	False	0.8
16	16	False	0.8
17	17	False	0.8
18	18	False	0.8
19	19	False	0.8
20	20	False	0.8
21	21	False	0.8
22	22	False	0.8
23	23	False	0.8
24	24	False	0.8
25	25	False	0.8
26	26	False	0.8
27	27	False	0.8
28	28	False	0.8
29	29	False	0.8
30	30	False	0.8
31	31	False	0.8
32	32	False	0.8
33	33	False	0.8
34	34	False	0.8
35	35	False	0.8
36	36	False	0.8
37	37	False	0.8
38	38	False	0.8
39	39	False	0.8
40	40	False	0.8
41	41	False	0.8
42	42	False	0.8
43	43	False	0.8
44	44	False	0.8
45	45	False	0.8
46	46	False	0.8
47	47	False	0.8
48	48	False	0.8
49	49	False	0.8
50	50	False	0.8
51	51	False	0.8
52	52	False	0.8
53	53	False	0.8
54	54	False	0.8
55	55	False	0.8
56	56	False	0.8
57	57	False	0.8
58	58	False	0.8
59	59	False	0.8
60	60	False	0.8
61	61	False	0.8
62	62	False	0.8
63	63	False	0.8
64	64	False	0.8
65	65	False	0.8
66	66	False	0.8
67	67	False	0.8
68	68	False	0.8
69	69	False	0.8
70	70	False	0.8
71	71	False	0.8
72	72	False	0.8
73	73	False	0.8
74	74	False	0.8
75	75	False	0.8
76	76	False	0.8
77	77	False	0.8
78	78	False	0.8
79	79	False	0.8
80	80	False	0.8
81	81	False	0.8
82	82	False	0.8
83	83	False	0.8
84	84	False	0.8
85	85	False	0.8
86	86	False	0.8
87	87	False	0.8
88	88	False	0.8
89	89	False	0.8
90	90	False	0.8
91	91	False	0.8
92	92	False	0.8
93	93	False	0.8
94	94	False	0.8
95	95	False	0.8
96	96	False	0.8
97	97	False	0.8
98	98	False	0.8
99	99	False	0.8
100	100	False	0.8
101	0	True	0.5
102	1	True	0.5
103	2	True	0.5
104	3	True	0.5
105	4	True	0.5
106	5	True	0.5
107	6	True	0.5
108	7	True	0.5
109	8	True	0.5
110	9	True	0.5
111	10	True	0.5
112	11	True	0.5
113	12	True	0.5
114	13	True	0.5
115	14	True	0.5
116	15	True	0.5
117	16	True	0.5
118	17	True	0.5
119	18	True	0.5
120	19	True	0.5
121	20	True	0.5
122	21	True	0.5
123	22	True	0.5
124	23	True	0.5
125	24	True	0.5
126	25	True	0.5
127	26	True	0.5
128	27	True	0.5
129	28	True	0.5
130	29	True	0.5
131	30	True	0.5
132	31	True	0.5
133	32	True	0.5
134	33	True	0.5
135	34	True	0.5
136	35	True	0.5
137	36	True	0.5
138	37	True	0.5
139	38	True	0.5
140	39	True	0.5
141	40	True	0.5
142	41	True	0.5
143	42	True	0.5
144	43	True	0.5
145	44	True	0.5
146	45	True	0.5
147	46	True	0.5
148	47	True	0.5
149	48	True	0.5
150	49	True	0.5
151	50	True	0.5
152	51	True	0.5
153	52	True	0.5
154	53	True	0.5
155	54	True	0.5
156	55	True	0.5
157	56	True	0.5
158	57	True	0.5
159	58	True	0.5
160	59	True	0.5
161	60	True	0.5
162	61	True	0.5
163	62	True	0.5
164	63	True	0.5
165	64	True	0.5
166	65	True	0.5
167	66	True	0.5
168	67	True	0.5
169	68	True	0.5
170	69	True	0.5
171	70	True	0.5
172	71	True	0.5
173	72	True	0.5
174	73	True	0.5
175	74	True	0.5
176	75	True	0.5
177	76	True	0.5
178	77	True	0.5
179	78	True	0.5
180	79	True	0.5
181	80	True	0.5
182	81	True	0.5
183	82	True	0.5
184	83	True	0.5
185	84	True	0.5
186	85	True	0.5
187	86	True	0.5
188	87	True	0.5
189	88	True	0.5
190	89	True	0.5
191	90	True	0.5
192	91	True	0.5
193	92	True	0.5
194	93	True	0.5
195	94	True	0.5
196	95	True	0.5
197	96	True	0.5
198	97	True	0.5
199	98	True	0.5
200	99	True	0.5
201	100	True	0.5

additional_params

	prop_pulm	0.8
0	prop_pulm_hiv	0.5
1	prop_pulm_1yr	0.7
2	prop_pulm_1_2yr	0.74
3	prop_pulm_2_5yr	0.91
4	prop_pulm_5_10yr	0.89
5	prop_pulm_10yr	0.99
6	rr_tbm_bcg	0.27
7	rr_miliary_bcg	0.23

cases2010district

	district	region	cases_2010	pop	proportion_active	all_cases	whole_pop	general_prob
0	Balaka	Southern	1563	438379	0.00356541	50000	17563749	0.00284677
1	Blantyre	Southern	1563	451220	0.00346394	50000	17563749	0.00284677
2	Blantyre City	Southern	1563	800264	0.00195311	50000	17563749	0.00284677
3	Chikwawa	Southern	1563	564684	0.00276792	50000	17563749	0.00284677
4	Chiradzulu	Southern	1563	356875	0.00437968	50000	17563749	0.00284677
5	Chitipa	Northern	1563	234927	0.00665313	50000	17563749	0.00284677
6	Dedza	Central	1563	830512	0.00188197	50000	17563749	0.00284677
7	Dowa	Central	1563	772569	0.00202312	50000	17563749	0.00284677
8	Karonga	Northern	1563	365028	0.00428186	50000	17563749	0.00284677
9	Kasungu	Central	1563	842953	0.0018542	50000	17563749	0.00284677
10	Likoma	Northern	1563	14527	0.107593	50000	17563749	0.00284677
11	Lilongwe	Central	1563	1637583	0.000954455	50000	17563749	0.00284677
12	Lilongwe City	Central	1563	989318	0.00157988	50000	17563749	0.00284677
13	Machinga	Southern	1563	735438	0.00212526	50000	17563749	0.00284677
14	Mangochi	Southern	1563	1148611	0.00136077	50000	17563749	0.00284677
15	Mchinji	Central	1563	602305	0.00259503	50000	17563749	0.00284677
16	Mulanje	Southern	1563	684107	0.00228473	50000	17563749	0.00284677
17	Mwanza	Southern	1563	130949	0.0119359	50000	17563749	0.00284677
18	Mzimba	Northern	1563	936250	0.00166943	50000	17563749	0.00284677
19	Mzuzu City	Northern	1563	221272	0.0070637	50000	17563749	0.00284677
20	Neno	Southern	1563	138291	0.0113023	50000	17563749	0.00284677
21	Nkhata Bay	Northern	1563	285795	0.00546896	50000	17563749	0.00284677
22	Nkhotakota	Central	1563	395897	0.003948	50000	17563749	0.00284677
23	Nsanje	Southern	1563	299168	0.00522449	50000	17563749	0.00284677
24	Ntcheu	Central	1563	659608	0.00236959	50000	17563749	0.00284677
25	Ntchisi	Central	1563	317069	0.00492953	50000	17563749	0.00284677
26	Phalombe	Southern	1563	429450	0.00363954	50000	17563749	0.00284677
27	Rumphi	Northern	1563	229161	0.00682053	50000	17563749	0.00284677
28	Salima	Central	1563	478346	0.00326751	50000	17563749	0.00284677
29	Thyolo	Southern	1563	721456	0.00216645	50000	17563749	0.00284677
30	Zomba	Southern	1563	746724	0.00209314	50000	17563749	0.00284677
31	Zomba City	Southern	1563	105013	0.0148839	50000	17563749	0.00284677

details_rates

	parameter	value1	value2	value3	value4	monthly_rate	monthly_probability	Unnamed: 7	source	Unnamed: 9
0	prop_fast_progressor	0.14							vynnycky
1	transmission_rate	4.9							juan
2	annual_progression_to_active_rate	0.05				0.004166666666666667	0.004157998154890041		horsburgh
3	rr_tb_with_hiv_stages	3.44	6.76	13.28	26.06				williams_pnas2010
4	rr_tb_art	0.35							suthar_juan
5	rr_tb_ipt	0.63							rangaka_juan
6	rr_tb_malnourished	2.1							lonroth2010_dcp3
7	rr_tb_diabetes1	3							joen2008_dcp3
8	rr_tb_alcohol	2.9							lonroth2008_dcp3
9	rr_tb_smoking	2.6							lin2007_dcp3
10	rr_tb_pollution	1.5							lin2007_dcp3
11	rel_infectiousness_hiv	0.68							juan
12	annual_rate_self_cure_old_value	0.2				0.016666666666666666	0.01652854617838251		dye_1998_lancet
13	annual_rate_self_cure	0.33							Tiemersma	https://www.ncbi.nlm.nih.gov/pmc/articles/PMC3070694/
14	tb_mortality_rate	0.15				0.012499999999999999	0.012422199506118559		juan
15	tb_mortality_hiv_rate	0.84				0.06999999999999999	0.06760618009405173		juan
16	prop_mdr2010	0.0186							abouyannis
17	prop_mdr_new	0.075							who2017reports
18	prop_mdr_retreated	0.064							who2017reports
19	rate_relapse_tx_complete	0.032				0.0026666666666666666	0.002663114269499056		juan_tableparams
20	rate_relapse_tx_incomplete	0.14				0.011666666666666667	0.011598875001476161		juan_tableparams
21	rate_relapse_2yrs	0.0015				0.000125	0.00012499218782546784		juan_tableparams

followup

	ds_sputum	ds_clinical_monitor	ds_retreatment_sputum	ds_retreatment_clinical	mdr_sputum	mdr_clinical_monitor	shine_sputum	shine_clinical_monitor
0	2	1	3	1	2	1	2	1
1	5	2	5	2	5	2	4	2
2	6	3	8	3	6	3		3
3		4		4	8	4		4
4		5		5	10	5
5		6		6	12	6
6				7	14	7
7				8	16	8
8					18	9
9					20	10
10					22	11
11					24	12
12						13
13						14
14						15
15						16
16						17
17						18
18						19
19						20
20						21
21						22
22						23
23						24

latent_TB2014_summary

	Age_group	latent_TB_prev	lower_estimate	upper_estimate	population_size2016	proportion_latent_TB	proportion_latent_TB_lower	proportion_latent_TB_upper
0	0_14	525000	476000	567000	7847053	0.0669041	0.0606597151822474	0.07225642543767705
1	15_80	2645000			9726553	0.271936
2	0_80	3170000	2850000	3720000	17573606	0.180384	0.16217502543302723	0.2116810858283724

WHO_activeTB2023

	year	bcg_coverage	incidence_per_100k	incidence_per_100k_low	incidence_per_100k_high	percentage_tb_with_hiv	percentage_tb_with_hiv_low	percentage_tb_with_hiv_high	mortality_tb_excl_hiv_per_100k	mortality_tb_excl_hiv_per_100k_low	mortality_tb_excl_hiv_per_100k_high	mortality_tb_hiv_per_100k	mortality_tb_hiv_per_100k_low	mortality_tb_hiv_per_100k_high	total_mortality_tb_per_100k	total_mortality_tb_per_100k_low	total_mortality_tb_per_100k_high	num_deaths_tb_nonHiv	num_deaths_tb_nonHiv_low	num_deaths_tb_nonHiv_high	prevalence_all_ages	prevalence_all_ages_low	prevalence_all_ages_high	case_detection_rate	case_detection_rate_lower	case_detection_rate_upper	TB_program_tx_coverage	case_fatality_rate	case_fatality_rate_low	case_fatality_rate_high
0	2000	83	386	43	1100	79	65	91	20	6.1	43	116	60	191	137	77	213	2300	680	4900	0.003955636395089666	0.0022854788060518074	0.0059774061081354956	54	19	490		0.54	0.05	0.97
1	2001	93	395	40	1140	77	53	94	18	3.9	43	116	59	192	134	73	213	2100	450	4900	0.003933014605249737	0.0023085085726465846	0.005985022225380034	57	20	560		0.53	0.05	0.97
2	2002	78	401	39	1170	71	53	86	29	9.5	58	113	56	190	142	79	223	3400	1100	6900	0.003995434882693616	0.002413908574960726	0.00590991409731764	52	18	540		0.56	0.04	0.98
3	2003	91	403	38	1190	68	49	84	27	9.3	55	100	49	168	127	71	199	3300	1100	6600	0.003971892940138629	0.0024317711878399768	0.005917309890410611	58	20	610		0.5	0.06	0.94
4	2004	97	402	39	1180	67	47	83	30	10	60	105	51	178	135	75	212	3700	1300	7500	0.003944450150748996	0.0024455590934643772	0.005837786223108514	54	18	570		0.53	0.05	0.97
5	2005	99	398	40	1160	67	47	84	31	10	63	111	54	190	143	79	225	4000	1300	8000	0.003987818441681721	0.0024540421179579824	0.005828350030150208	50	17	510		0.56	0.04	0.99
6	2006	99	392	41	1130	70	69	70	27	14	46	119	65	189	146	89	218	3600	1800	6000	0.003946605554348407	0.002457320439499952	0.005733747692166554	49	17	460		0.58	0.04	0.99
7	2007	95	383	43	1080	68	68	69	29	15	48	116	63	185	145	89	215	3900	2000	6500	0.0038292116686338942	0.002384226133300349	0.005635443587800825	47	17	420		0.58	0.05	0.99
8	2008	97	371	47	1020	63	50	75	33	14	60	105	54	173	138	82	209	4600	2000	8300	0.003713764345816206	0.002312343837961034	0.005465539980635171	46	17	370		0.55	0.05	0.98
9	2009	95	356	50	952	64	64	65	32	16	53	106	58	170	138	85	204	4500	2300	7500	0.003533904620729803	0.002174710535833725	0.0052328972268499	45	17	310		0.56	0.06	0.98
10	2010	97	338	55	870	77	53	94	20	4.2	48	125	61	211	145	77	233	3000	620	7100	0.0032966101946351623	0.0019779661167810977	0.005010847495845447	42	16	260		0.6	0.04	1
11	2011	99	316	61	777	60	59	60	34	17	57	93	50	149	127	79	186	5100	2600	8600	0.003135474644952289	0.0017916997971155937	0.004799195885131054	40	16	210		0.54	0.07	0.96
12	2012	99	291	67	675	59	59	60	29	15	49	79	42	127	108	67	158	4600	2300	7600	0.0029197433980408523	0.001677299398874532	0.004597042796915384	45	19	190	47	0.48	0.09	0.89
13	2013	96	261	73	567	56	55	57	30	15	50	69	37	112	99	62	145	4700	2400	7900	0.002593932478248519	0.0013874522558073473	0.0042226807785441	42	20	150	44	0.47	0.11	0.86
14	2014	97	228	78	455	54	53	55	27	13	45	57	31	92	84	53	122	4400	2200	7400	0.002284865554409738	0.0012303122216052434	0.0036323503685488138	43	22	130	45	0.44	0.12	0.78
15	2015	90	197	81	364	53	52	54	22	11	37	46	25	74	68	43	99	3700	1900	6200	0.0019347194915648222	0.0010242632602402	0.003129693295178389	47	26	110	50	0.39	0.13	0.69
16	2016	86	176	81	307	53	52	53	19	9.5	31	38	20	61	57	36	82	3300	1700	5400	0.0016029560720943312	0.0008291152097039644	0.0025426199764254907	51	29	110	58	0.36	0.14	0.62
17	2017	89	162	80	272	49	49	50	16	8.3	27	29	16	47	46	29	65	2900	1500	4800	0.0012887909980526368	0.0006980951239451783	0.002094285371835535	57	34	120	71	0.31	0.13	0.52
18	2018	92	153	79	250	48	48	49	16	8.2	27	28	15	44	44	28	63	3000	1500	4900				56	34	110		0.31	0.13	0.52
19	2019		146	78	235	47	46	47	14	7.3	23	23	12	36	37	24	53	2700	1400	4400				61	38	110		0.27	0.12	0.45
20	2020		138	73	225	45	44	45	16	7.9	26	24	13	38	40	26	57	3000	1500	5100				56	35	110		0.31	0.14	0.52
21	2021		132	67	218	45	44	46	15	7.3	26	24	13	39	39	25	57	3000	1500	5100				55	33	110		0.32	0.13	0.55
22	2022		125	61	212	48	48	49	9.5	4.6	16	18	9.4	28	27	17	39	1900	930	3300				71	42	150		0.24	0.1	0.42
23	2023
24	2024
25	2025
26	2026
27	2027
28	2028
29	2029
30	2030
31	2031
32	2032
33	2033
34	2034
35	2035
36	2036
37	2037
38	2038
39	2039
40	2040
41	2041
42	2042
43	2043
44	2044
45	2045
46	2046
47	2047
48	2048
49	2049
50	2050

WHO_latentTB2017

	variable	definition	value
0	year		2017
1	source_hh	Source of estimate of average household size	DHS 2015
2	e_hh_size	Estimated average household size	4.508918
3	prevtx_data_available	Are data available on the number of children aged under 5 who are household contacts of TB cases and started on TB preventive therapy?	60
4	newinc_con04_prevtx	Number of children aged under 5 started on TB preventive therapy who are household contacts of bacteriologically-confirmed new and relapse TB cases notified	3068
5	ptsurvey_newinc	Number of bacteriologically-confirmed TB new and relapse cases notified in the reporting year whose medical records or treatment cards were included in a survey
6	ptsurvey_newinc_con04_prevtx	Number of children aged under 5 started on TB preventive therapy who are household contacts of the TB cases in ptsurvey_newinc
7	e_prevtx_eligible	Estimated number of children aged under 5 who are household contacts of TB cases who are eligible for TB preventive therapy	4400
8	e_prevtx_eligible_hi	Estimated number of children aged under 5 who are household contacts of TB cases who are eligible for TB preventive therapy: high bound	4000
9	e_prevtx_eligible_lo	Estimated number of children aged under 5 who are household contacts of TB cases who are eligible for TB preventive therapy: low bound	4800
10	e_prevtx_kids_pct	Estimated % of children received TB preventive therapy aged under 5 who are household contacts of TB cases and who are eligible for TB preventive therapy	69
11	e_prevtx_kids_pct_hi	Estimated % of children received TB preventive therapy aged under 5 who are household contacts of TB cases and who are eligible for TB preventive therapy: High bound	64
12	e_prevtx_kids_pct_lo	Estimated % of children received TB preventive therapy aged under 5 who are household contacts of TB cases and who are eligible for TB preventive therapy: Low bound	76

WHO_mdrTB2017

	variable	definition	value
0	year		2017
1	source_rr_new	Method used to estimate proportion of new TB patients with rifampicin-resistant TB	Survey
2	source_drs_coverage_new	Indicates whether national or subnational data from drug resistance surveys or surveillance was used to estimate the proportion of new TB cases with MDR-TB	National
3	source_drs_year_new	Year of drug resistance surveillance, survey or model used to estimate proportion of new TB cases with MDR-TB	2011
4	e_rr_pct_new	Estimated percentage of new TB cases with rifampicin resistant TB	0.75
5	e_rr_pct_new_hi	Estimated percentage of new TB cases with rifampicin resistant TB: high bound	0.16
6	e_rr_pct_new_lo	Estimated percentage of new TB cases with rifampicin resistant TB: low bound	1.8
7	e_mdr_pct_rr_new	Estimated percentage of new rifampicin resistant TB cases that have MDR-TB	56
8	source_rr_ret	Method used to estimate proportion of previously treated TB patients with rifampicin-resistant TB	Survey
9	source_drs_coverage_ret	Indicates whether national or subnational data from drug resistance surveys or surveillance was used to estimate the proportion of previously treated TB cases with MDR-TB	National
10	source_drs_year_ret	Year of drug resistance surveillance, survey or model used to estimate proportion of previously treated TB cases with MDR-TB	2011
11	e_rr_pct_ret	Estimated percentage of previously treated TB cases with rifampicin resistant TB	6.4
12	e_rr_pct_ret_hi	Estimated percentage of previously treated TB cases with rifampicin resistant TB: high bound	4
13	e_rr_pct_ret_lo	Estimated percentage of previously treated TB cases with rifampicin resistant TB: low bound	9.2
14	e_mdr_pct_rr_ret	Estimated percentage of previously treated rifampicin resistant TB cases that have MDR-TB	76
15	e_inc_rr_num	Estimated incidence of rifampicin resistant TB (absolute number)	330
16	e_inc_rr_num_hi	Estimated incidence of rifampicin resistant TB (absolute number): high bound	90
17	e_inc_rr_num_lo	Estimated incidence of rifampicin resistant TB (absolute number): low bound	710
18	e_mdr_pct_rr	Estimated percentage of rifampicin resistant TB cases that have MDR-TB	63
19	e_rr_in_notified_pulm	Estimated number of RR-TB cases among notified pulmonary TB cases	180
20	e_rr_in_notified_pulm_hi	Estimated number of RR-TB cases among notified pulmonary TB cases: high bound	83
21	e_rr_in_notified_pulm_lo	Estimated number of RR-TB cases among notified pulmonary TB cases: low bound	270

WHO_tx_success_rates2021

	year	Are outcomes of relapse cases included in the newrel outcome variables?	Outcomes for all new and relapse cases (but only new cases if rel_with_new_flg = 0): cohort size	Outcomes for all new and relapse cases (but only new cases if rel_with_new_flg = 0): treatment success (cured or treatment completed)	Outcomes for all new and relapse cases (but only new cases if rel_with_new_flg = 0): treatment failed	Outcomes for all new and relapse cases (but only new cases if rel_with_new_flg = 0): died	Outcomes for all new and relapse cases (but only new cases if rel_with_new_flg = 0): lost to follow-up	Treatment success rate for all new cases (including relapse cases if rel_with_new_flg = 1), percent	Outcomes for previously treated patients (excluding relapse cases if rel_with_new_flg = 1): cohort size	Outcomes for previously treated patients (excluding relapse cases if rel_with_new_flg = 1): treatment success (cured or treatment completed)	Outcomes for previously treated patients (excluding relapse cases if rel_with_new_flg = 1): treatment failed	Outcomes for previously treated patients (excluding relapse cases if rel_with_new_flg = 1): died	Outcomes for previously treated patients (excluding relapse cases if rel_with_new_flg = 1): lost to follow-up	Treatment success rate for re-treatment cases (excluding relapse cases if rel_with_new_flg = 1), percent	Outcomes for HIV-positive TB cases, all types: cohort size	Outcomes for HIV-positive TB cases, all types: treatment success (cured or treatment completed)	Outcomes for HIV-positive TB cases, all types: treatment failed	Outcomes for HIV-positive TB cases, all types: died	Outcomes for HIV-positive TB cases, all types: lost to follow-up	Treatment success rate for HIV-positive TB cases, percent	Outcomes for new and relapse cases in children aged 0-14 years: cohort size	Outcomes for new and relapse cases in children aged 0-14 years: treatment success	Outcomes for new and relapse cases in children aged 0-14 years: treatment failed	Outcomes for new and relapse cases in children aged 0-14 years: died	Outcomes for new and relapse cases in children aged 0-14 years: lost to follow-up	Treatment success rate for new and relapse cases in children aged 0-14 years, percent	Outcomes for MDR-TB cases: cohort size	Outcomes for MDR-TB cases: treatment success (Cured or treatment completed)	Outcomes for MDR-TB cases: treatment failed	Outcomes for MDR-TB cases: died	Outcomes for MDR-TB cases: lost to follow-up
0	2010							83						77													26	18	2	5	1
1	2011							83						82													16	11		4	1
2	2012	1	19361	15849	159	2015	292	82	1493	847	8	136	8	57													19	12	0	6	1
3	2013	1	17779	14506	139	1710	312	82																			19	10	0	7	1
4	2014	1	16267	13867	148	1414	332	85	1456	1086	8	152	30	75													53	31	0	18	2
5	2015	1	15597	12585	164	1576	358	81	1284	977	9	218	32	76	7799	6320	92	959	108	81							64	39	0	21	3
6	2016	1	15683	12877	153	1590	311	82	1023	828	11	130	14	81	7804	6244	101	938	121	80							58	34	1	17	5
7	2017	1	16321	14003	104	1586	266	86	352	281	9	37	11	80	7763	6498	67	938	117	84							58	32	1	20	4
8	2018	1	15435	13522	140	1286	246	88	321	259	13	21	19	81	7268	6222	81	790	73	86	1183	1096				93

NTP2019

	year	case_notification_rate_per_100k	treatment_coverage	treatment_success_rates	death_rate	percent_hiv_positive	number_notified_mdr_cases	percent_mdr_treatment_success	percent_death_mdr_cases	coverage_ipt_paediatric_contacts
0	2010
1	2011		46	82.7	10.7
2	2012	138	51	81.8	10.7		27	63.2	31.6
3	2013	126	48	83.3	9.8		91	52.6	36.8
4	2014	112	46	85	8.9		106	58.6	34	35
5	2015	105	46	81.6	10.6	42.6	107	60.9	32.8	42
6	2016	101	47	82.1	10.3	38.8	66	58.6	29.3	51
7	2017	95	50	86	9.7	39.1	85	55	35	61
8	2018	88	48	87.2	8.6	38.5	126	68.8	17	57
9	2019	92	51	87.6	8.2	35.5	104	73	16	57
10	2020	76	56	89	8	45	97	76		48
11	2021									41