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	rr_bcg_inf	0.81
3	monthly_prob_relapse_tx_complete	0.0027	0.0014	0.00405
4	monthly_prob_relapse_tx_incomplete	0.0116	0.0058	0.0174
5	monthly_prob_relapse_2yrs	0.0001	5e-05	0.0015
6	rr_relapse_hiv	4.7
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_tb_child	0.1	assumed
16	rr_tb_bcg	0.42
17	rr_tb_hiv	5	assumed		20.6getahun2010
18	rr_tb_aids	26	assumed		26williams_pnas
19	rr_tb_art_adult	0.35
20	rr_tb_art_child	0.3
21	rr_tb_obese	0.4
22	rr_tb_diabetes1	3
23	rr_tb_alcohol	2.9
24	rr_tb_smoking	1.3
25	rr_ipt_adult	0.4
26	rr_ipt_child	0.55
27	rr_ipt_adult_hiv	0.68
28	rr_ipt_child_hiv	0.31
29	rr_ipt_art_child	0.76
30	rr_ipt_art_adult	0.63
31	sens_xpert_smear_negative	0.68
32	sens_xpert_smear_positive	0.98
33	spec_xpert_smear_negative	0.99
34	spec_xpert_smear_positive	0.99
35	sens_sputum_smear_positive	1
36	spec_sputum_smear_positive	1
37	sens_clinical	0.209	0.12	0.33
38	spec_clinical	0.953	0.92	0.97
39	sens_xray_smear_negative	0.8
40	sens_xray_smear_positive	0.91
41	spec_xray_smear_negative	0.67
42	spec_xray_smear_positive	0.67
43	prob_tx_success_ds	0.837
44	prob_tx_success_mdr	0.597
45	prob_tx_success_0_4	0.94
46	prob_tx_success_5_14	0.92
47	prob_tx_success_shorter	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	child_shorter_treatment_length	4
53	prob_retained_ipt_6_months	0.9
54	age_eligibility_for_ipt	5
55	ipt_start_date	2014
56	scenario	0
57	scenario_start_date	2023-01-01 00:00:00
58	first_line_test	sputum
59	second_line_test	xpert
60	probability_access_to_xray	0.1

scaleup_parameters

	parameter	value
0	hiv_beta	0.9
1	prob_prep_for_fsw_after_hiv_test	0.5
2	prob_prep_for_agyw	0.1
3	probability_of_being_retained_on_prep_every_3_months	0.75
4	prob_circ_after_hiv_test	0.25
5	annual_testing_rate_children	0.1
6	annual_testing_rate_adults	0.3
7	prob_hiv_test_at_anc_or_delivery	0.95
8	prob_hiv_test_for_newborn_infant	0.95
9	prob_start_art_after_hiv_test	0.95
10	virally_suppressed_on_art	95
11	tb_treatment_coverage	90
12	tb_prob_tx_success_ds	0.9
13	tb_prob_tx_success_mdr	0.9
14	tb_prob_tx_success_0_4	0.9
15	tb_prob_tx_success_5_14	0.9
16	tb_prob_tx_success_shorter	0.9
17	first_line_test	xpert
18	second_line_test	sputum
19	ipt_coverage_plhiv	0.9
20	ipt_coverage_paediatric	90

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
10	2020	0.11	MoH_quart_repQ3	57
11	2021	0.3	no_data	57
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
0	2000	83	386	43	1100	79	65	91	20	6.1	43	116	60	191	137	77	213	2000	1900	3000	0.003955636395089666	0.0022854788060518074	0.0059774061081354956	54	18	570
1	2001	93	395	40	1140	77	53	94	18	3.9	43	116	59	192	134	73	213	2000	1700	2000	0.003933014605249737	0.0023085085726465846	0.005985022225380034	50	17	510
2	2002	78	401	39	1170	71	53	86	29	9.5	58	113	56	190	142	79	223	4000	2700	4000	0.003995434882693616	0.002413908574960726	0.00590991409731764	49	17	460
3	2003	91	403	38	1190	68	49	84	27	9.3	55	100	49	168	127	71	199	3000	2700	4000	0.003971892940138629	0.0024317711878399768	0.005917309890410611	47	17	420
4	2004	97	402	39	1180	67	47	83	30	10	60	105	51	178	135	75	212	4000	3000	4000	0.003944450150748996	0.0024455590934643772	0.005837786223108514	46	17	370
5	2005	99	398	40	1160	67	47	84	31	10	63	111	54	190	143	79	225	4000	3100	5000	0.003987818441681721	0.0024540421179579824	0.005828350030150208	45	17	310
6	2006	99	392	41	1130	70	69	70	27	14	46	119	65	189	146	89	218	3000	3500	4000	0.003946605554348407	0.002457320439499952	0.005733747692166554	42	16	260
7	2007	95	383	43	1080	68	68	69	29	15	48	116	63	185	145	89	215	4000	3500	4000	0.0038292116686338942	0.002384226133300349	0.005635443587800825	40	16	210
8	2008	97	371	47	1020	63	50	75	33	14	60	105	54	173	138	82	209	4000	3500	5000	0.003713764345816206	0.002312343837961034	0.005465539980635171	45	19	190
9	2009	95	356	50	952	64	64	65	32	16	53	106	58	170	138	85	204	5000	3800	5000	0.003533904620729803	0.002174710535833725	0.0052328972268499	42	20	150
10	2010	97	338	55	870	77	53	94	20	4.2	48	125	61	211	145	77	233	3000	2000	3000	0.0032966101946351623	0.0019779661167810977	0.005010847495845447	43	22	130
11	2011	99	316	61	777	60	59	60	34	17	57	93	50	149	127	79	186	5000	4500	5000	0.003135474644952289	0.0017916997971155937	0.004799195885131054	47	26	110
12	2012	99	291	67	675	59	59	60	29	15	49	79	42	127	108	67	158	5000	3400	5000	0.0029197433980408523	0.001677299398874532	0.004597042796915384	51	29	110	47
13	2013	96	261	73	567	56	55	57	30	15	50	69	37	112	99	62	145	5000	4000	5000	0.002593932478248519	0.0013874522558073473	0.0042226807785441	57	34	120	44
14	2014	97	228	78	455	54	53	55	27	13	45	57	31	92	84	53	122	4600	3700	5000	0.002284865554409738	0.0012303122216052434	0.0036323503685488138	56	34	110	45
15	2015	90	197	81	364	53	52	54	22	11	37	46	25	74	68	43	99	4200	3100	5000	0.0019347194915648222	0.0010242632602402	0.003129693295178389	61	38	110	50
16	2016	86	176	81	307	53	52	53	19	9.5	31	38	20	61	57	36	82	3300	2700	3000	0.0016029560720943312	0.0008291152097039644	0.0025426199764254907	56	35	110	58
17	2017	89	162	80	272	49	49	50	16	8.3	27	29	16	47	46	29	65	2900	2400	3700	0.0012887909980526368	0.0006980951239451783	0.002094285371835535	55	33	110	71
18	2018	92	153	79	250	48	48	49	16	8.2	27	28	15	44	44	28	63	3000	2400	3900
19	2019		146	78	235	47	46	47	14	7.3	23	23	12	36	37	24	53	2700	2200	3100
20	2020		138	73	225	45	44	45	16	7.9	26	24	13	38	40	26	57	3000	2400	3600
21	2021		132	67	218	45	44	46	15	7.3	26	24	13	39	39	25	57	3000	2400	3300
22	2022		132	67	218
23	2023		132	67	218
24	2024		132	67	218
25	2025		132	67	218
26	2026		132	67	218
27	2027		132	67	218
28	2028		132	67	218
29	2029		132	67	218
30	2030		132	67	218
31	2031		132	67	218
32	2032		132	67	218
33	2033		132	67	218
34	2034		132	67	218
35	2035		132	67	218
36	2036		132	67	218
37	2037		132	67	218
38	2038		132	67	218
39	2039		132	67	218
40	2040		132	67	218
41	2041		132	67	218
42	2042		132	67	218
43	2043		132	67	218
44	2044		132	67	218
45	2045		132	67	218
46	2046		132	67	218
47	2047		132	67	218
48	2048		132	67	218
49	2049		132	67	218
50	2050		132	67	218

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		57
9	2019	92	51			35.5	104			57