Dataset
Revenue and water production records from seven rural piped water service providers, 2016-2020
- Documentation:
- This dataset has been compiled from secondary, longitudinal records maintained by seven agencies that operate piped water services in rural areas of ten countries. Three of the agencies are international nongovernmental organisations that operate as social enterprises. Three agencies are private companies that offer a range of engineering, construction, and management services. One agency is a public utility. Operational data have been extracted, with permission, from proprietary online and offline electronic databases maintained by the participating agencies. Deidentified data have been transferred to a master database where additional transformations and aggregations have been performed. The master database contains separate databases for water service areas, geographic regions, financials, and service levels which are linked with a record identification number corresponding to unique piped water service areas. Transformed data are documented with comments that explain relationships between variables. The full dataset covers roughly 5,500 waterpoints and represents services provided to more than half a million people spanning the years 2016 to 2020. In general, the dataset consists of the following: • Service area characteristics (geolocations and jurisdictions, planning and implementation approach, installation dates) • Financials (monthly revenues, tariff rates, payment modalities) • Service levels (monthly waterpoint types and counts, volumes, scheme configuration details) Furthermore, the data adhere to the following criteria: 1. Services cover rural or a mixture of rural and peri-urban areas 2. Infrastructure consists of small to medium-sized piped schemes covering one or multiple villages with metered on and off premises connections 3. Users make regular financial contributions 4. At least 12 concurrent monthly revenue and water volume records are available Since the assembled dataset holds long-term value to the public, the master database containing anonymised data has been preserved under controlled access in the Oxford University Research Archive.
Actions
Access Document
- Files:
-
-
(Version of record, sheet, 2.2MB, Terms of use)
-
Authors/Creators
Contributors
+ Cuscuna, L
- Institution:
- Safe Water Network
- Role:
- Data collector
+ Deal, P
- Institution:
- Water4
- Role:
- Data collector
+ Batarda, C
- Institution:
- Water For People
- Role:
- Data collector
+ Staub, M
- Institution:
- Water Mission
- Role:
- Data collector
+ Knobeloch, S
- Institution:
- Water Mission
- Role:
- Data collector
+ Foreign, Commonwealth and Development Office
More from this funder
- Funder identifier:
- http://dx.doi.org/10.13039/501100020171
- Funding agency for:
- Armstrong, A
- Grant:
- 201880
- Programme:
- REACH programme
- Publisher:
- University of Oxford
- Publication date:
- 2023
- Spatial coverage:
- Ghana, Indonesia, Kenya, Malawi, Mexico, Peru, Rwanda, Sierra Leone, Tanzania, Uganda
- Digital size:
- 2.2MB
- File format:
- .xlsx
- Physical storage location:
- Andrew Armstrong's (lina3457) OneDrive folder in Nexus365
- Digital storage location:
- https://unioxfordnexus-my.sharepoint.com/:x:/r/personal/lina3457_ox_ac_uk/Documents/Data/Armstrong2022_Master%20database_clean%20for%20deposit.xlsx?d=wee5b4f838c6d48b791b7b46fb3576e09&csf=1&web=1&e=3VTlGy
- DOI:
- Temporal coverage:
- 2016 - 2020
- Data collected:
- 2020-03-01 - 2020-10-31
- Language:
-
English
- Keywords:
- Subjects:
- Pubs id:
-
1481297
- Local pid:
-
pubs:1481297
- Deposit date:
-
2023-03-09
- ARK identifier:
Terms of use
- Copyright date:
- 2023
If you are the owner of this record, you can report an update to it here: Report update to this record