| Title: | USAID Flood Response Post Intervention Survey Data |
|---|---|
| Description: | Post-intervention monitoring data for rural water points in the Mulanje district of Malawi, collected as part of the USAID Flood Response program during 2019-2020. The dataset includes comprehensive water point assessments covering physical condition, operational performance, hydraulic measurements, water quality parameters, and microbiological quality assessments. |
| Authors: | Emmanuel Mhango [aut, cre] (ORCID: <https://orcid.org/0000-0003-3197-6244>), Evance [ctb], Julius Kutaumbe [ctb], Eramore [ctb], Patrick Katholowamo [ctb], Rashid Kumbu [ctb], Mkangara [ctb], Benja Moree [ctb], Rober Gerald [ctb], Olipa [ctb], Laurent CT Levesque [ctb], Shaun MacLeod [ctb], Davie Selenje [ctb], Mayamiko Jumbe [ctb], Given Nyasulu [ctb] |
| Maintainer: | Emmanuel Mhango <[email protected]> |
| License: | CC BY 4.0 |
| Version: | 0.1.2 |
| Built: | 2026-10-09 12:58:45 UTC |
| Source: | https://github.com/openwashdata/postfloodintervention |
This dataset represents the USAID Flood Response Post Intervention Survey conducted in Mulanje during 2019-2020 using the mWater platform. It contains comprehensive water quality assessments and operational data from various water points affected by flooding.
This dataset contains detailed post-intervention monitoring data for rural water points in the Mulanje district of Malawi, collected as part of the USAID Flood Response program during 2019 and 2020. Using the mWater mobile data collection platform, enumerators conducted on-site assessments of water point conditions following flood recovery efforts.
postfloodintervention postfloodinterventionpostfloodintervention postfloodintervention
A tibble with 308 rows and 30 variables:
Date when the survey was submitted
Name of the water point
Geographic latitude coordinate of the water point
Geographic longitude coordinate of the water point
File names or URLs of photos illustrating the current condition of the water point
Qualitative assessment of how the pump feels during operation
Time taken (in seconds or minutes) to pump 20 liters of water
Number of pump strokes needed to produce water
Presence or absence of sediment in the water
Measured magnitude of electrical conductivity in the water sample
Units of electrical conductivity measurement (e.g., μS/cm)
Concentration of arsenic detected in the water sample
Units used to measure arsenic concentration (e.g., μg/L)
Ammonia concentration in mg per liter
Fluoride concentration in parts per million
Nitrate concentration in mg per liter
Total dissolved solids in parts per thousand
Concentration of free chlorine in mg per liter
pH level of the water sample (acidity/alkalinity)
Temperature value of the water sample
Units for temperature measurement (degree celsius)
Measured turbidity of water using a turbidity tube
Units for turbidity measurement (e.g., NTU)
Additional notes or observations related to the water point or sample
Type or source of the water sample (e.g., well, tap, river)
Date when the water sample was collected
Most probable number (MPN) of E. coli bacteria per 100 milliliters
Upper limit of the 95 percent confidence interval for E. coli MPN per 100 ml
Health risk classification based on E. coli levels (e.g., low, medium, high)
File name or URL of image showing E. coli test result or sample compartment color change
A tibble with 257 rows and 28 variables
Date when the water sample was collected
Geographic latitude coordinate of the water point
Geographic longitude coordinate of the water point
File names or URLs of photos illustrating the current condition of the water point
Qualitative assessment of how the pump feels during operation
Time taken (in seconds or minutes) to pump 20 liters of water
Number of pump strokes needed to produce water
Presence or absence of sediment in the water
Measured magnitude of electrical conductivity in the water sample
Units of electrical conductivity measurement (e.g., μS/cm)
Concentration of arsenic detected in the water sample
Units used to measure arsenic concentration (e.g., μg/L)
Ammonia concentration in mg per liter
Fluoride concentration in parts per million
Nitrate concentration in mg per liter
Total dissolved solids in parts per thousand
Concentration of free chlorine in mg per liter
pH level of the water sample (acidity/alkalinity)
Temperature value of the water sample
Units for temperature measurement (degree celsius)
Measured turbidity of water using a turbidity tube
Units for turbidity measurement (e.g., NTU)
Additional notes or observations related to the water point or sample
Type or source of the water sample (e.g., well, tap, river)
Most probable number (MPN) of E. coli bacteria per 100 milliliters
Upper limit of the 95 percent confidence interval for E. coli MPN per 100 ml
Health risk classification based on E. coli levels (e.g., low, medium, high)
File name or URL of image showing E. coli test result or sample compartment color change