| A | B | C | D | E | F | G | H | I | J | ||
|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Parameters Sheet | Anyone | |||||||||
2 | Dispensers for Safe Water (2018 data unless otherwise specified) | Value | Source | ||||||||
3 | Expected under-5 mortality averted (per child year), Kenya | 0.0007 | "2019 prior" tab | ||||||||
4 | Expected under-5 mortality averted (per child year), Uganda | 0.0008 | "2019 prior" tab | ||||||||
5 | Expected under-5 mortality averted (per child year), Malawi | 0.0006 | "2019 prior" tab | ||||||||
6 | Kenya: Total dispensers maintained | 18253 | DSW 2019 draft CEA, p. 7. Unpublished | ||||||||
7 | Uganda: Total dispensers maintained | 5686 | DSW 2019 draft CEA, p. 7. Unpublished | ||||||||
8 | Malawi: Total dispensers maintained | 3726 | DSW 2019 draft CEA, p. 7. Unpublished | ||||||||
9 | Kenya: Number of households served per dispenser | 21.8 | DSW 2019 draft CEA, p. 7. Unpublished | ||||||||
10 | Uganda: Number of households served per dispenser | 39.97 | DSW 2019 draft CEA, p. 7. Unpublished | ||||||||
11 | Malawi: Number of households served per dispenser | 35.7 | DSW 2019 draft CEA, p. 7. Unpublished | ||||||||
12 | Kenya: Children under 5 per household | 0.68 | DSW 2019 draft CEA, p. 7. Unpublished | ||||||||
13 | Uganda: Children under 5 per household | 0.91 | DSW 2019 draft CEA, p. 7. Unpublished | ||||||||
14 | Malawi: Children under 5 per household | 0.67 | DSW 2019 draft CEA, p. 7. Unpublished | ||||||||
15 | Proportion of functional dispensers, Kenya | 97% | A dispenser is defined as "functional" if it dispenses chlorine. "Dispenser functionality was above 90% in all countries, with Kenya leading with 97% of present dispensers being able to dispense chlorine, while Uganda and Malawi had 91% of the present dispensers dispensing chlorine." DSW 2018 Annual Report, p. 4. Unpublished | ||||||||
16 | Proportion of functional dispensers, Uganda | 91% | A dispenser is defined as "functional" if it dispenses chlorine. "Dispenser functionality was above 90% in all countries, with Kenya leading with 97% of present dispensers being able to dispense chlorine, while Uganda and Malawi had 91% of the present dispensers dispensing chlorine." DSW 2018 Annual Report, p. 4. Unpublished. | ||||||||
17 | Proportion of functional dispensers, Malawi | 91% | A dispenser is defined as "functional" if it dispenses chlorine. "Dispenser functionality was above 90% in all countries, with Kenya leading with 97% of present dispensers being able to dispense chlorine, while Uganda and Malawi had 91% of the present dispensers dispensing chlorine." DSW 2018 Annual Report, p. 4. Unpublished. | ||||||||
18 | Adoption rate, Kenya | 0.44 | DSW estimates that, in 2018, the percentage of households using water sources with dispensers that tested positive for total (free) chlorine was 47% (44%) in Kenya, 64% (61%) in Uganda, and 79% (71%) in Malawi. DSW 2018 Annual Report, p. 1. Unpublished We use free chlorine as we take it to be a better indication of whether the water is safe to drink than total chlorine. “Total chlorine is further divided into: 1) the amount of chlorine that has reacted with nitrates and is unavailable for disinfection which is called combined chlorine and, 2) the free chlorine, which is the chlorine available to inactivate disease-causing organisms, and thus a measure to determine the potability of water.“ Chlorine Residual Testing Fact Sheet, CDC SWS Project, https://www.cdc.gov/safewater/publications_pages/chlorineresidual.pdf, p. 1 | ||||||||
19 | Adoption rate, Uganda | 0.61 | DSW estimates that, in 2018, the percentage of households using water sources with dispensers that tested positive for total (free) chlorine was 47% (44%) in Kenya, 64% (61%) in Uganda, and 79% (71%) in Malawi. DSW 2018 Annual Report, p. 1, Unpublished. See cell C18 for the difference between total and free chlorine and why we employ the latter. | ||||||||
20 | Adoption rate, Malawi | 0.71 | DSW estimates that, in 2018, the percentage of households using water sources with dispensers that tested positive for total (free) chlorine was 47% (44%) in Kenya, 64% (61%) in Uganda, and 79% (71%) in Malawi. DSW 2018 Annual Report, p. 1. Upublished. See cell C18 for the difference between total and free chlorine and why we employ the latter. | ||||||||
21 | Cost per dispenser, average across a 10 year period, Kenya | 220 | GW's costing analysis for DSW, unpublished | ||||||||
22 | Cost per dispenser, average across a 10 year period, Uganda | 254 | GW's costing analysis for DSW, unpublished | ||||||||
23 | Cost per dispenser, average across a 10 year period, Malawi | 345 | GW's costing analysis for DSW, unpublished | ||||||||
24 | GiveDirectly, total units of value generated with a $10,000 donation | 34.4 | https://docs.google.com/spreadsheets/d/16XOOB1oWse1ICbF0OVXUYtwWwpvG3mxAAQ6LYAAndQU/edit#gid=1680005064 |