Checking for missing content type metadata ...

Checking for non-preferred file/folder path names (may take a long time depending on the number of files/folders) ...

A harmonised sampling-event database of disinfection by-product compliance monitoring in United States drinking water, 2006-2019


Authors:
Owners: This resource does not have an owner who is an active HydroShare user. Contact CUAHSI (help@cuahsi.org) for information on this resource.
Type: Resource
Storage: The size of this resource is 640.8 MB
Created: Oct 03, 2026 at 1:04 p.m. (UTC)
Last updated: Oct 06, 2026 at 2:55 p.m. (UTC)
Citation: See how to cite this resource
Content types: CSV Content 
Sharing Status: Public
Views: 46
Downloads: 4
+1 Votes: Be the first one to 
 this.
Comments: No comments (yet)

Abstract

This dataset converts the disinfection by-product (DBP) compliance monitoring that United States public water systems submit under the Stage 1 and Stage 2 Disinfectants and Disinfection Byproducts Rules into a validated sampling-event panel. It contains 3,154,095 sampling events for the four trihalomethanes and five haloacetic acids, covering 2006-2019, 60,468 public water systems and 52 states and territories, derived from the 13,772,104 analyte results in the US Environmental Protection Agency's Third and Fourth Six-Year Review collections. Each event carries the reported family total and all available species concentrations, system and sampling attributes, county FIPS code, NOAA climate-division identifier and the division's monthly mean temperature (97.4% of events linked), together with explicit quality flags for species completeness, non-detect fraction and brominated-fraction validity. Intended use: within-system analysis of DBP occurrence, source-water contrasts in level and speciation, seasonal and temperature sensitivity analysis, and benchmarking of DBP formation models. Before use, read data_dictionary.csv (all variables, units and missing-value conventions) and README.md (usage caveats); in particular, BR_FRACTION must only be used where BR_FRACTION_VALID is TRUE, and the two Six-Year Review rounds should not be pooled without testing comparability. A minimal-dependency example script (pandas only) is included.

Subject Keywords

Coverage

Temporal

Start Date:
End Date:

Content

Credits

Funding Agencies

This resource was created using funding from the following sources:
Agency Name Award Title Award Number
Shandong Provincial Medical and Health Science and Technology Plan Project None 202512010339
Qingdao Outstanding Health Professional Development Fund None 2025-2027

How to Cite

WANG, B., Su, Y., Wang, Y., Shi, Y., Li, D. (2026). A harmonised sampling-event database of disinfection by-product compliance monitoring in United States drinking water, 2006-2019, HydroShare, http://www.hydroshare.org/resource/5877746ebb2e43d3a15ab691441868b6

This resource is shared under the Creative Commons Attribution CC BY.

http://creativecommons.org/licenses/by/4.0/
CC-BY

Comments

There are currently no comments

New Comment

required