openwashdata/boreholelabdata

The dataset captures water quality test results from various water points across Malawi, collected between 2017 and 2019 # Water Quality Laboratory Analysis and Reporting Dataset – Malawi (2017–2019) The dataset captures water quality test results from various water points across Malawi, collected between 2017 and 2019 using the mWater platform. It includes metadata on sample collection events, site geolocation, submission and approval timelines, and laboratory analysis outcomes. The data reflects structured workflows for monitoring water safety, supporting both operational decision-making and long-term water quality management. **Intended Users and Applications** 1. **Water Utilities and Service Providers:** To monitor the quality of water from different sources, schedule maintenance or treatment, and improve service delivery. 2. **Environmental Health Officers and District Councils:** To identify unsafe water points, plan targeted inspections, and coordinate local water safety interventions. 3. **WASH Program Implementers:** To assess baseline water quality conditions, prioritize high-risk areas, and track the impact of water safety programs. 4. **Academic Institutions and Research Bodies:** To analyze regional and seasonal trends in water quality and contribute to the evidence base for safe water practices in low-resource settings. 5. **Government Ministries**: To inform national water safety planning, update regulations, and allocate resources based on real-world data. 6. **Development Agencies and International Donors**: To evaluate program outcomes, justify investments, and align support with areas of greatest water quality need. ## Installation You can install the development version of boreholelabdata from GitHub with: ``` r # install.packages("devtools") devtools::install_github("openwashdata/boreholelabdata") ``` ``` r ## Run the following code in console if you don't have the packages ## install.packages(c("dplyr", "knitr", "readr", "stringr", "gt", "kableExtra")) library(dplyr) library(knitr) library(readr) library(stringr) library(gt) library(kabl …