Revenue and water production records from seven rural piped water service providers, 2016-2020

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.本数据集源自10个国家农村地区7家运营管道供水服务（piped water services）的机构留存的二级纵向记录。其中3家为以社会企业模式运营的国际非政府组织，3家为提供工程、建设与管理全品类服务的私营企业，剩余1家为公共事业单位。 经参与机构许可，研究人员从其维护的专有在线与离线电子数据库中提取运行数据。去标识化后的数据集被导入主数据库，在此完成额外的数据转换与聚合操作。 主数据库包含供水服务区、地理区域、财务数据与服务水平4个独立数据库，通过对应唯一管道供水服务区的记录标识号实现关联。转换后的数据均附带注释，用以说明变量间的关联关系。 完整数据集涵盖约5500个供水点，服务范围覆盖超50万人口，时间跨度为2016年至2020年。总体而言，本数据集包含以下类别： • 服务区特征（地理位置与管辖范围、规划与实施方式、安装日期） • 财务数据（月度营收、费率标准、缴费方式） • 服务水平（月度供水点类型与数量、供水量、供水系统配置细节） 此外，该数据集需满足以下筛选准则： 1. 服务覆盖农村区域或农村与城郊混合区域 2. 基础设施为中小规模管道供水系统，可为单个或多个村庄提供服务，支持计量式室内外用水连接 3. 用户需定期缴纳相关费用 4. 可获取至少12个月的连续月度营收与供水量记录 鉴于该整合数据集具备长期公共研究价值，包含匿名化数据的主数据库已以受控访问模式留存于牛津大学研究档案馆。