Schisto (.xlsx)

Download original .xlsx file from GitHub

Parameters

	Parameter	Value	Reference	Area
0	delay_till_hsi_a_repeated	5	assumption	HSI
1	delay_till_hsi_b_repeated	20	assumption	HSI
2	prob_sent_to_lab_test_children	0.9	assumption	HSI
3	prob_sent_to_lab_test_adults	0.6	assumption	HSI
4	PZQ_efficacy	1	assumption	HSI
5	high_intensity_threshold_haematobium	20	WHO	transmission model
6	high_intensity_threshold_PSAC_haematobium	5	assumption	transmission model
7	low_intensity_threshold_haematobium	2	assumption	transmission model
8	worms_fecundity_haematobium	0.005	Truscott et al	transmission model
9	worm_lifespan_haematobium	6	Anderson et al 2016	transmission model
10	beta_PSAC_haematobium	0.3	Truscott et al	transmission model
11	beta_SAC_haematobium	1	Truscott et al	transmission model
12	beta_Adults_haematobium	0.05	Truscott et al	transmission model
13	high_intensity_threshold_mansoni	46	WHO	transmission model
14	high_intensity_threshold_PSAC_mansoni	20	assumption	transmission model
15	low_intensity_threshold_mansoni	2	assumption	transmission model
16	worms_fecundity_mansoni	0.0006	Chan et al	transmission model
17	worm_lifespan_mansoni	4	Anderson et al 2017	transmission model
18	beta_PSAC_mansoni	0.3	Truscott et al	transmission model
19	beta_SAC_mansoni	1	Truscott et al	transmission model
20	beta_Adults_mansoni	0.05	Truscott et al	transmission model

Symptoms

	Symptom	HSB_mapped_symptom	Prevalence	Reference	Infection_type
0	anemia	other	0.9	assumption	both
1	fever	fever	0.3	assumption	both
2	haematuria	other	0.625	van der Werf et al., 2003	haematobium
3	hydronephrosis	stomach_ache	0.083	van der Werf et al., 2003	haematobium
4	dysuria	stomach_ache	0.2857	van der Werf et al., 2003	haematobium
5	bladder_pathology	stomach_ache	0.7857	van der Werf et al., 2003	haematobium
6	ascites	stomach_ache	0.0054	van der Werf et al., 2003	mansoni
7	diarrhoea	diarrhoea	0.0144	van der Werf et al., 2003	mansoni
8	vomiting	vomit	0.0172	van der Werf et al., 2003	mansoni
9	hepatomegaly	stomach_ache	0.1574	van der Werf et al., 2003	mansoni

DALYs

	TLO_Sequela_Code	Sequela	Health state name	Health state lay description	disability weight	lower	uppper
0	254	Mild diarrhea due to schistosomiasis	Diarrhea, mild	has diarrhea three or more times a day with occasional discomfort in the belly.	0.074	0.049	0.104
1	255	Severe anemia due to schistosomiasis	Anemia, severe	feels very weak, tired and short of breath, and has problems with activities that require physical effort or deep concentration.	0.149	0.101	0.209
2	256	Hematemesis due to schistosomiasis	Gastric bleeding	vomits blood and feels nauseous.	0.325	0.209	0.462
3	257	Hepatomegaly due to schistosomiasis	Abdominopelvic problem, mild	has some pain in the belly that causes nausea but does not interfere with daily activities.	0.011	0.005	0.021
4	258	Moderate anemia due to schistosomiasis	Anemia, moderate	feels moderate fatigue, weakness, and shortness of breath after exercise, making daily activities more difficult.	0.052	0.034	0.076
5	259	Mild anemia due to schistosomiasis	Anemia, mild	feels slightly tired and weak at times, but this does not interfere with normal daily activities.	0.004	0.001	0.008
6	260	Hydronephrosis due to schistosomiasis	Abdominopelvic problem, mild	has some pain in the belly that causes nausea but does not interfere with daily activities.	0.011	0.005	0.021
7	261	Ascites due to schistosomiasis	Abdominopelvic problem, moderate	has pain in the belly and feels nauseous. The person has difficulties with daily activities.	0.114	0.078	0.159
8	262	Mild schistosomiasis	Infectious disease, acute episode, mild	has a low fever and mild discomfort , but no difficulty with daily activities.	0.006	0.002	0.012
9	263	Dysuria due to schistosomiasis	Abdominopelvic problem, mild	has some pain in the belly that causes nausea but does not interfere with daily activities.	0.011	0.005	0.021
10	264	Bladder pathology due to schistosomiasis	Abdominopelvic problem, mild	has some pain in the belly that causes nausea but does not interfere with daily activities.	0.011	0.005	0.021

District_Params_haematobium

	District	Region	Reservoir	R0_value	alpha_value	Reference	Prevalence	Reference_prevalence
0	Balaka	Southern	0	1.12425	0.061841	fitted	0.154602	2011 SCI / MoH, ESPEN
1	Blantyre	Southern	1.87216	1.12956	0.107616	fitted	0.26904	rural, 2011 SCI / MoH. ESPEN
2	Blantyre City	Southern	0	1.1253	0.04664	fitted	0.1166	2011 SCI / MoH
3	Chikwawa	Southern	0	1.1248	0.0805	fitted	0.20125	2008 WFP / MoH, ESPEN
4	Chiradzulu	Southern	2.81222	1.14141	0.1377	fitted	0.34425	2010 MoH, ESPEN
5	Chitipa	Northern	0	1.12577	0.08905	fitted	0.222625	2010 MoH, ESPEN
6	Dedza	Central	0	1.12423	0.0698	fitted	0.1745	2010 MoH, ESPEN
7	Dowa	Central	0	0	0	fitted	0	ESPEN
8	Karonga	Northern	0	1.12421	0.0643	fitted	0.16075	2010 COM
9	Kasungu	Central	0	1.12471	0.0793714	fitted	0.198429	2008 WFP/MoH, 2010 MoH, ESPEN
10	Likoma	Northern	0	1.13144	0.114	fitted	0.285	ESPEN
11	Lilongwe	Central	0	1.12704	0.0967167	fitted	0.241792	2008 WFP / MoH, Jemu SK et al, 2011 SCI/MoH, , ESPEN
12	Lilongwe City	Central	0	1.12437	0.05852	fitted	0.1463	2011 SCI / MoH
13	Machinga	Southern	0	1.12429	0.0718	fitted	0.1795	2010 MoH, ESPEN
14	Mangochi	Southern	0	1.12421	0.0643333	fitted	0.160833	ESPEN
15	Mchinji	Central	0	1.12448	0.076	fitted	0.19	2010 MoH, ESPEN
16	Mulanje	Southern	3.05	1.14496	0.144	fitted	0.36	2010 MoH, ESPEN
17	Mwanza	Southern	0	1.12506	0.0832457	fitted	0.208114	2011 SCI / MoH, ESPEN
18	Mzimba	Northern	0	1.12536	0.046129	fitted	0.115323	2010 MoH, ESPEN
19	Mzuzu City	Northern	0	1.13018	0.02004	fitted	0.0501	2011 SCI / MoH
20	Neno	Southern	0	1.12631	0.03896	fitted	0.0974	2011 SCI / MoH, ESPEN
21	Nkhata Bay	Northern	0	1.13233	0.01225	fitted	0.030625	ESPEN
22	Nkhotakota	Central	2.19995	1.13321	0.119188	fitted	0.297971	2010 MoH, ESPEN
23	Nsanje	Southern	2.39017	1.13559	0.125333	fitted	0.313333	2008 WFP / MoH, ESPEN
24	Ntcheu	Central	0	1.12421	0.0684143	fitted	0.171036	2008 WFP/MoH, 2010 MoH, ESPEN
25	Ntchisi	Central	0	1.12433	0.073	fitted	0.1825	ESPEN
26	Phalombe	Southern	5.31723	1.1841	0.188	fitted	0.47	ESPEN
27	Rumphi	Northern	0	0	0	fitted	0	ESPEN
28	Salima	Central	0	1.12873	0.0261176	fitted	0.0652941	ESPEN
29	Thyolo	Southern	0	1.12421	0.06865	fitted	0.171625	2010 MoH, ESPEN
30	Zomba	Southern	0	1.1262	0.0397333	fitted	0.0993333	ESPEN
31	Zomba City	Southern	0	1.1262	0.0397333	fitted	0.0993333	ESPEN copy from Zomba

District_Params_mansoni

	District	Region	Reservoir	R0_value	alpha_value	Reference	Prevalence	Reference_prevalence
0	Balaka	Southern	0.0103949	3.28891	0.0528333	fitted	0.00944444	ESPEN
1	Blantyre	Southern	0.0796066	1.46175	0.0652093	fitted	0.0506977	ESPEN
2	Blantyre City	Southern	0.0796066	1.46175	0.0652093	fitted	0.0506977	copy from Blantyre
3	Chikwawa	Southern	0.0243277	2.18968	0.056	fitted	0.02	ESPEN
4	Chiradzulu	Southern	0.158777	1.26817	0.07445	fitted	0.0815	ESPEN
5	Chitipa	Northern	0	0	0.05	fitted	0	ESPEN
6	Dedza	Central	0	0	0.05	fitted	0	ESPEN
7	Dowa	Central	0	0	0.05	fitted	0	ESPEN
8	Karonga	Northern	0.0891927	1.42196	0.0665	fitted	0.055	average of all mansoni in Espen
9	Kasungu	Central	0	0	0.05	fitted	0	ESPEN
10	Likoma	Northern	1.12359	1.06177	0.125	fitted	0.25	ESPEN
11	Lilongwe	Central	0.187713	1.23539	0.0772459	fitted	0.0908197	ESPEN
12	Lilongwe City	Central	0.187713	1.23539	0.0772459	fitted	0.0908197	copy from Lilongwe
13	Machinga	Southern	0	0	0.05	fitted	0	ESPEN
14	Mangochi	Southern	0.114042	1.34757	0.0695882	fitted	0.0652941	ESPEN
15	Mchinji	Central	0	0	0.05	fitted	0	ESPEN
16	Mulanje	Southern	0	0	0.05	fitted	0	ESPEN
17	Mwanza	Southern	0.0411611	1.78166	0.0592308	fitted	0.0307692	ESPEN
18	Mzimba	Northern	0.0236342	2.21729	0.0558548	fitted	0.0195161	ESPEN
19	Mzuzu City	Northern	0.0891927	1.42196	0.0665	fitted	0.055	average of all mansoni in Espen
20	Neno	Southern	0	0	0.05	fitted	0	ESPEN
21	Nkhata Bay	Northern	0.0377989	1.83686	0.058625	fitted	0.02875	ESPEN
22	Nkhotakota	Central	0.172451	1.25145	0.0758	fitted	0.086	ESPEN
23	Nsanje	Southern	0	0	0.05	fitted	0	ESPEN
24	Ntcheu	Central	0.0194311	2.42068	0.05495	fitted	0.0165	ESPEN
25	Ntchisi	Central	0.203152	1.22138	0.07865	fitted	0.0955	ESPEN
26	Phalombe	Southern	0	0	0.05	fitted	0	ESPEN
27	Rumphi	Northern	0	0	0.05	fitted	0	ESPEN
28	Salima	Central	0.190781	1.23244	0.0775294	fitted	0.0917647	ESPEN
29	Thyolo	Southern	0	0	0.05	fitted	0	ESPEN
30	Zomba	Southern	0.172451	1.25145	0.0758	fitted	0.086	ESPEN
31	Zomba City	Southern	0.172451	1.25145	0.0758	fitted	0.086	copy from Zomba

MDA_historical_Coverage

	District	Region	Year	Coverage PSAC	Coverage SAC	Coverage Adults	Reference
0	Blantyre	Southern	2015	0	0.78	0	data
1	Blantyre	Southern	2016	0	0.85	0.44	interpolated, mean of 2015 and 2017
2	Blantyre	Southern	2017	0	0.92	0.88	data
3	Blantyre	Southern	2018	0	0.87	0.88	data
4	Chiradzulu	Southern	2015	0	0.73	0.02	data
5	Chiradzulu	Southern	2016	0	0.8	0.155	interpolated, mean of 2015 and 2017
6	Chiradzulu	Southern	2017	0	0.87	0.29	value over 100% in the data for SAC so instead we use 2018 value
7	Chiradzulu	Southern	2018	0	0.87	0.9	data
8	Mulanje	Southern	2015	0	0.48	0.96	data
9	Mulanje	Southern	2016	0	0.605	0.96	interpolated, mean of 2015 and 2017
10	Mulanje	Southern	2017	0	0.73	0.96	values over 100% in the data so instead we used values from 2018
11	Mulanje	Southern	2018	0	0.73	0.96	value over 100% in the data for Adults so instead we use value for 2015
12	Nkhotakota	Central	2015	0	0.5	0.01	value over 100% in the data for SAC so instead we used 0.5
13	Nkhotakota	Central	2016	0	0.675	0.22	interpolated, mean of 2015 and 2017
14	Nkhotakota	Central	2017	0	0.85	0.43	value over 100% in the data for SAC so instead we used 2018 value
15	Nkhotakota	Central	2018	0	0.85	0.89	data
16	Nsanje	Southern	2015	0	0.75	0	data
17	Nsanje	Southern	2016	0	0.795	0.41	interpolated, mean of 2015 and 2017
18	Nsanje	Southern	2017	0	0.84	0.82	data
19	Nsanje	Southern	2018	0	0.9	0.88	data
20	Phalombe	Southern	2015	0	0.92	0.04	data
21	Phalombe	Southern	2016	0	0.88	0.445	interpolated, mean of 2015 and 2017
22	Phalombe	Southern	2017	0	0.84	0.85	data
23	Phalombe	Southern	2018	0	0.86	0.92	data
24	Balaka	Southern	2015	0	0.43	0	data
25	Balaka	Southern	2016	0	0.65	0.44	interpolated, mean of 2015 and 2017
26	Balaka	Southern	2017	0	0.87	0.88	data
27	Balaka	Southern	2018	0	0.83	0.89	data
28	Blantyre City	Southern	2015	0	0.78	0	data
29	Blantyre City	Southern	2016	0	0.85	0.44	interpolated, mean of 2015 and 2017
30	Blantyre City	Southern	2017	0	0.92	0.88	data
31	Blantyre City	Southern	2018	0	0.87	0.88	data
32	Chikwawa	Southern	2015	0	0.65	0	data
33	Chikwawa	Southern	2016	0	0.765	0.49	interpolated, mean of 2015 and 2017
34	Chikwawa	Southern	2017	0	0.88	0.98	data
35	Chikwawa	Southern	2018	0	0.74	0.52	data
36	Chitipa	Northern	2015	0	0.62	0	data
37	Chitipa	Northern	2016	0	0.74	0.345	interpolated, mean of 2015 and 2017
38	Chitipa	Northern	2017	0	0.86	0.69	errors in the data so instead we use2018 data
39	Chitipa	Northern	2018	0	0.86	0.69	data
40	Dedza	Central	2015	0	0.72	0	data
41	Dedza	Central	2016	0	0.81	0.445	interpolated, mean of 2015 and 2017
42	Dedza	Central	2017	0	0.9	0.89	data
43	Dedza	Central	2018	0	0.95	0.95	data
44	Dowa	Central	2015	0	0.85	0.02	data
45	Dowa	Central	2016	0	0.85	0.435	interpolated, mean of 2015 and 2017
46	Dowa	Central	2017	0	0.85	0.85	data
47	Dowa	Central	2018	0	0.8	0.77	data
48	Karonga	Northern	2015	0	0.97	0	data
49	Karonga	Northern	2016	0	0.91	0.435	interpolated, mean of 2015 and 2017
50	Karonga	Northern	2017	0	0.85	0.87	data
51	Karonga	Northern	2018	0	0.89	0.84	data
52	Kasungu	Central	2015	0	0.89	0	data
53	Kasungu	Central	2016	0	0.88	0.35	interpolated, mean of 2015 and 2017
54	Kasungu	Central	2017	0	0.87	0.7	data
55	Kasungu	Central	2018	0	0.82	0.86	data
56	Likoma	Northern	2015	0	0.52	0.26	data
57	Likoma	Northern	2016	0	0.685	0.615	interpolated, mean of 2015 and 2017
58	Likoma	Northern	2017	0	0.85	0.97	no data so we used Lilongwe data for 2017 and 2018
59	Likoma	Northern	2018	0	0.83	0.9	no data, random
60	Lilongwe	Central	2015	0	0.88	0.04	data
61	Lilongwe	Central	2016	0	0.865	0.505	interpolated, mean of 2015 and 2017
62	Lilongwe	Central	2017	0	0.85	0.97	data
63	Lilongwe	Central	2018	0	0.83	0.9	data
64	Lilongwe City	Central	2015	0	0.88	0.04	data
65	Lilongwe City	Central	2016	0	0.865	0.505	interpolated, mean of 2015 and 2017
66	Lilongwe City	Central	2017	0	0.85	0.97	data
67	Lilongwe City	Central	2018	0	0.83	0.9	data
68	Machinga	Southern	2015	0	0.45	0	data
69	Machinga	Southern	2016	0	0.68	0.46	interpolated, mean of 2015 and 2017
70	Machinga	Southern	2017	0	0.91	0.92	data
71	Machinga	Southern	2018	0	0.93	0.97	data
72	Mangochi	Southern	2015	0	0.82	0.01	data
73	Mangochi	Southern	2016	0	0.85	0.49	interpolated, mean of 2015 and 2017
74	Mangochi	Southern	2017	0	0.88	0.97	data
75	Mangochi	Southern	2018	0	0.73	0.75	data
76	Mchinji	Central	2015	0	0.77	0	data
77	Mchinji	Central	2016	0	0.815	0.435	interpolated, mean of 2015 and 2017
78	Mchinji	Central	2017	0	0.86	0.87	data
79	Mchinji	Central	2018	0	0.83	0.82	data
80	Mwanza	Southern	2015	0	0.5	0	errors in the data for SAC so instead we used 0.5
81	Mwanza	Southern	2016	0	0.675	0.415	interpolated, mean of 2015 and 2017
82	Mwanza	Southern	2017	0	0.85	0.83	data
83	Mwanza	Southern	2018	0	0.75	0.72	data
84	Mzimba	Northern	2015	0	0.41	0.03	data for Mzimba South
85	Mzimba	Northern	2016	0	0.7	0.48	interpolated, mean of 2015 and 2017
86	Mzimba	Northern	2017	0	0.99	0.93	value over 100% in the data for Adults so instead we used value for 2018
87	Mzimba	Northern	2018	0	0.78	0.93	data for Mzimba South
88	Mzuzu City	Northern	2015	0	0.83	0	no data, so copied from another Northern with data, Rumphi
89	Mzuzu City	Northern	2016	0	0.855	0.435	no data, so copied from another Northern with data, Rumphi
90	Mzuzu City	Northern	2017	0	0.88	0.87	no data, so copied from another Northern with data, Rumphi
91	Mzuzu City	Northern	2018	0	0.92	0.89	no data, so copied from another Northern with data, Rumphi
92	Neno	Southern	2015	0	0.8	0	data
93	Neno	Southern	2016	0	0.82	0.395	interpolated, mean of 2015 and 2017
94	Neno	Southern	2017	0	0.84	0.79	data
95	Neno	Southern	2018	0	0.87	0.87	data
96	Nkhata Bay	Northern	2015	0	0.5	0.76	value over 100% in the data for SAC so instead we used 0.5
97	Nkhata Bay	Northern	2016	0	0.66	0.765	interpolated, mean of 2015 and 2017
98	Nkhata Bay	Northern	2017	0	0.82	0.77	data
99	Nkhata Bay	Northern	2018	0	0.81	0.8	data
100	Ntcheu	Central	2015	0	0.91	0	data
101	Ntcheu	Central	2016	0	0.865	0.415	interpolated, mean of 2015 and 2017
102	Ntcheu	Central	2017	0	0.82	0.83	data
103	Ntcheu	Central	2018	0	0.84	0.87	data
104	Ntchisi	Central	2015	0	0.5	0	value over 100% in the data for SAC so instead we used 0.5
105	Ntchisi	Central	2016	0	0.66	0.45	interpolated, mean of 2015 and 2017
106	Ntchisi	Central	2017	0	0.82	0.9	data
107	Ntchisi	Central	2018	0	0.87	0.83	data
108	Rumphi	Northern	2015	0	0.83	0	data
109	Rumphi	Northern	2016	0	0.855	0.435	interpolated, mean of 2015 and 2017
110	Rumphi	Northern	2017	0	0.88	0.87	data
111	Rumphi	Northern	2018	0	0.92	0.89	data
112	Salima	Central	2015	0	0.5	0.33	value over 100% in the data for SAC so instead we used 0.5
113	Salima	Central	2016	0	0.675	0.6	interpolated, mean of 2015 and 2017
114	Salima	Central	2017	0	0.85	0.87	data
115	Salima	Central	2018	0	0.85	0.78	value over 100% in the data for SAC so instead we used 2017 value
116	Thyolo	Southern	2015	0	0.63	0.04	data
117	Thyolo	Southern	2016	0	0.745	0.395	interpolated, mean of 2015 and 2017
118	Thyolo	Southern	2017	0	0.86	0.75	data
119	Thyolo	Southern	2018	0	0.88	0.85	data
120	Zomba	Southern	2015	0	0.71	0	data
121	Zomba	Southern	2016	0	0.81	0.39	interpolated, mean of 2015 and 2017
122	Zomba	Southern	2017	0	0.91	0.78	data
123	Zomba	Southern	2018	0	0.91	0.87	data
124	Zomba City	Southern	2015	0	0.71	0	data
125	Zomba City	Southern	2016	0	0.81	0.39	interpolated, mean of 2015 and 2017
126	Zomba City	Southern	2017	0	0.91	0.78	data
127	Zomba City	Southern	2018	0	0.91	0.87	data

MDA_prognosed_Coverage

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