| Title: | USAID Flood Response Rehabilitation and Chlorination Survey |
|---|---|
| Description: | This R package provides tools for analyzing and visualizing data from the USAID Flood Response Rehabilitation and Chlorination Survey conducted in Mulanje, Malawi (2019–2020). It includes functions to assess handpump component replacements, evaluate changes in functionality before and after rehabilitation, and identify common repair trends using mWater-collected data. |
| 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.0 |
| Built: | 2026-10-03 13:39:33 UTC |
| Source: | https://github.com/openwashdata/floodchlorinationsurvey |
This dataset is from the USAID Flood Response Rehabilitation and Chlorination Survey, conducted between 2019 - 2020, to assess and rehabilitate flood-affected boreholes in Malawi. Using the mWater, data collectors captured detailed information on the condition of handpumps, their components, water safety risks, and the impact of chlorination and repairs. The survey was part of an emergency response initiative to restore access to safe drinking water following flood events.
floodchlorinationsurveyfloodchlorinationsurvey
A tibble with 328 rows and 118 variables
Date when the data was submitted
Name of the water point
Latitude coordinate of the water point
Longitude coordinate of the water point
Date chlorination or rehabilitation was conducted
Indicates whether the community was mobilized for support
Functional status of the water point before intervention
Condition rating of bolts and nuts
Condition rating of the compression cone
Condition rating of the cylinder
Condition rating of the flapper
Condition rating of the footvalve bobbin
Condition rating of the footvalve body
Condition rating of the footvalve O ring
Condition rating of the fulcrum pin
Condition rating of the fulcrum pin bush bearings
Condition rating of the pump handle
Condition rating of the hanger pin
Condition rating of the hanger pin bush bearings
Condition rating of the head bolt
Condition rating of the plunger bobbin
Condition rating of the plunger body
Condition rating of the plunger U seal
Condition rating of the pump head case
Condition rating of the pump head cover
Condition rating of the rising main pipe
Condition rating of rising main centralisers
Condition rating of connecting rods
Condition rating of rod centralisers
Condition rating of the rod hanger
Condition rating of the rope
Condition rating of the socket
Condition rating of the steel cone
Condition rating of the top sleeve
Number of rods in the borehole
Indicates whether broken parts were retrieved from the borehole
Comments on the broken parts retrieved
Presence of silt on parts (Yes/No)
Presence of corrosion on parts (Yes/No)
Presence of slime buildup on parts (Yes/No)
Length of the rising main pipe in meters
Indicates whether a rope was attached to the rising main
URLs or filenames of photos showing removed parts
General condition of the pedestal
Is the pedestal held firmly in place?
URLs or filenames of photos showing surrounding infrastructure
Presence of latrines within 30m of the water point
Presence of latrines within 100m of the water point
Presence of cemetery within 30m
Presence of waste dumps within 30m
Whether the site is difficult to reach by car
Indicates whether chlorination was conducted
Indicates whether the parts were chlorinated
TRUE if unsure whether parts were chlorinated
Total depth of the borehole in meters
Depth of water in the borehole in meters
Number of 20L buckets of chlorine-treated water used
Whether 1g of HTH was dissolved for every 20L of water
Were chlorinated parts reinstalled after treatment?
Length of rising main pipe replaced (m)
Number of rods replaced
TRUE if bolts and nuts were replaced
Number of bolts and nuts replaced
TRUE if compression cone was replaced
Number of compression cones replaced
TRUE if cylinder was replaced
Number of cylinders replaced
TRUE if flapper was replaced
Number of flappers replaced
TRUE if footvalve bobbin was replaced
Number of footvalve bobbins replaced
TRUE if footvalve body was replaced
Number of footvalve bodies replaced
TRUE if footvalve O-ring was replaced
Number of O-rings replaced
TRUE if fulcrum pin was replaced
Number of fulcrum pins replaced
TRUE if fulcrum bearings were replaced
Number of fulcrum bearings replaced
TRUE if handle was replaced
Number of handles replaced
TRUE if hanger pin was replaced
Number of hanger pins replaced
TRUE if hanger bearings were replaced
Number of hanger bearings replaced
TRUE if head bolt was replaced
Number of head bolts replaced
TRUE if plunger bobbin was replaced
Number of plunger bobbins replaced
TRUE if plunger body was replaced
Number of plunger bodies replaced
TRUE if plunger U-seal was replaced
Number of U-seals replaced
TRUE if pump head case was replaced
Number of pump head cases replaced
TRUE if pump head cover was replaced
Number of pump head covers replaced
TRUE if rising main pipe was replaced
Number of rising main pipes replaced
TRUE if rising main centralisers were replaced
Number of centralisers replaced
TRUE if rods were replaced
Number of rods replaced
TRUE if rod centralisers were replaced
Number of rod centralisers replaced
TRUE if rodhanger was replaced
Number of rodhangers replaced
TRUE if rope was replaced
Number of ropes replaced
TRUE if socket was replaced
Number of sockets replaced
TRUE if steel cone was replaced
Number of steel cones replaced
TRUE if top sleeve was replaced
Number of top sleeves replaced
Functional status of the water point after intervention
Time (in seconds) it took to fill a 20L bucket
Number of strokes required to yield water from the pump