openwashdata/waterpointstatus

This dataset contains water point assessment data collected during routine field monitoring activities conducted in Malawi in 2023 # Water Point Functionality and Service Delivery Monitoring Dataset - 2023 This dataset contains water point assessment data collected during routine field monitoring activities conducted in Malawi in 2023 under the Trocaire water point functionality survey program. The survey was designed to evaluate the operational status, service reliability, and management conditions of rural water supply infrastructure, with a focus on boreholes and community-managed water points. Data collection was carried out using the mWater platform. The dataset includes geospatial coordinates, functionality status, water availability and reliability indicators, pump and civil works condition, reported mechanical failures, seasonal variability, water quality observations (including salinity and contamination issues), and basic performance metrics such as collection time and access distance. The dataset also captures governance and service delivery information, including water point committee composition, tariff structures, financial record keeping, maintenance practices, and service provider arrangements. The survey was conducted across multiple rural water points in Malawi, with locations determined by program implementation and field accessibility. This dataset can be used for: 1. Rural water infrastructure functionality analysis 2. Borehole and handpump performance monitoring 3. WASH program evaluation and reporting 4. Geospatial mapping of service delivery gaps 5. Water quality risk screening (e.g., salinity and contamination indicators) 6. Governance and sustainability assessments of community-managed water systems ## Installation You can install the development version of waterpointstatus from GitHub with: ``` r # install.packages("devtools") devtools::install_github("openwashdata/waterpointstatus") ``` ``` r ## Run the following code in console if you don't have the packages ## install.packages(c("dplyr", "knitr", "readr", "stringr", "gt", "kableExtra")) …