Preliminary Release of Microbial and Disinfection Byproduct Data Files (2012-2019) from EPA’s Fourth Six-Year Review Information Collection Request
As a result of EPA’s third Six-Year Review (SYR3) of the National Primary Drinking Water Regulations (NPDWRs), EPA identified eight contaminants covered by the Microbial and Disinfection Byproducts (MDBP) rules as candidates for revision. EPA is currently conducting analyses with relevant data and information (including characterization of national baselines after implementation of MDBP rules) to further evaluate the eight NPDWRs for potential regulatory revisions.
In support of conducting these analyses, in August 2022 EPA did a preliminary release of the MDBP-related data that were collected under the fourth Six-Year Review (SYR4) Information Collection Request (ICR). The released datasets contain compliance monitoring data and treatment technique information from January 2012 to December 2019, voluntarily provided by states and primacy agencies.
The preliminary release of SYR4's MDBP data files ahead of the publication of SYR4 results allows access to these data prior to the publication of EPA's SYR decisions. In particular, these MDBP compliance data could help inform analyses related to the potential revisions of the MDBP rules. The other data elements (e.g., those related to chemical phase rules) from the SYR4 ICR will be released along with the publication when the SYR4 is completed. The SYR4 data files released in August 2022 have undergone a rigorous Quality Assurance/Quality Control (QA/QC) review and are believed to be accurate. EPA has updated the preliminary release files to allow for compatibility with previous Six-Year Review data. The updated files include a field to identify the location of tribal systems, as was included in previous SYR data files.
You can see the updated data files here.
Each zip file below includes data for multiple contaminants and related information. The number of records and associated systems in the data files and the size of the files range considerably from contaminant to contaminant, which may be attributed to many factors such as the applicability of monitoring requirements (e.g., required sampling frequencies and locations), results from QA/QC measures, and completeness of data records.
The Data Management and Quality Assurance/Quality Control Process for EPA’s Fourth Six-Year Review’s Microbial and Disinfection Byproduct Preliminary Datasets contains a detailed description of each of these datasets (including the data fields, definitions, and associated QA/QC) and instructions for downloading and importing datasets into common analytical software applications such as Excel, Access, or R.
View the document here:
Microbial and Disinfection Byproducts Dataset Zip Files (grouped by category)
Disinfection Byproducts Datasets
SYR4_THMs.zip file contains individual files for:
- Total Trihalomethanes (TTHM)
- Bromodichloromethane
- Bromoform
- Chloroform
- Dibromochloromethane
SYR4_HAAs.zip file contains individual files for:
- Haloacetic Acids (HAA5)
- Bromoacetic acid
- Dibromoacetic acid
- Dichloroacetic acid
- Monochloroacetic acid
- Trichloroacetic acid
SYR4_Bromate_Chlorite.zip (zip)
SYR4_Bromate_Chlorite.zip contains individual files for:
- Bromate
- Chlorite
Disinfection Byproduct Related Parameters Datasets
SYR4_DBP_Related Parameters.zip (zip)
SYR4_DBP_Related Parameters.zip contains individual files for:
- DOC
- pH
- SUVA
- Total Alkalinity
- Total Organic Carbon (TOC) (raw and finished TOC)
- Paired TOC and Alkalinity
- UV_absorbance
Microbial Contaminants, Microbial Related Parameters, and Associated Disinfectant Residuals Datasets
SYR4_TC.zip (Total Coliform files by individual years) (zip)
SYR4_TC.zip contains individual files for:
- Total Coliform_2012
- Total Coliform_2013
- Total Coliform_2014
- Total Coliform_2015
- Total Coliform_2016
- Total Coliform_2017
- Total Coliform_2018
- Total Coliform_2019
SYR4_EC_FC_HPC_Giardia.zip (zip)
SYR4_EC_FC_HPC_Giardia.zip contains individual files for:
- Escherichia coli (EC)
- Fecal coliform (FC)
- Giardia Lamblia
- Heterotrophic Plate Count (HPC)
SYR4_Disinfectant Residuals.zip (zip)
SYR4_Disinfectant Residuals.zip contains individual files for:
- Chloramines
- Chlorine
- Chlorine dioxide
- Free Residual Chlorine
- Residual Chlorine
- Total Chlorine
SYR4_Paired Microbes_DR (Disinfectant Residuals).zip (zip)
SYR4_Paired Microbes _DR.zip contains individual files for:
- Paired EC_DR
- Paired FC_DR
- Paired TC_DR_2012
- Paired TC_DR_2013
- Paired TC_DR_2014
- Paired TC_DR_2015
- Paired TC_DR_2016
- Paired TC_DR_2017
- Paired TC_DR_2018
- Paired TC_DR_2019