Cited Data

US Water System Violations Dataset by Cited Data

Every active US public water system in one flat file, with its violations and open violations in plain words, from EPA's Safe Drinking Water data.

What we added to the public records

EPA publishes drinking-water compliance data as 11 linked tables full of codes. This dataset does the joining for you: one row for each of the 143,015 active US public water systems, in 56 states and territories, with the EPA snapshot quarter (2026Q3) on every row.

Each row says who runs the system, who owns it, what type it is, where its water comes from, how many people it serves and the places it serves. It counts the violations in the last five years (2021-10-01 to 2026-09-30), how many were health-based, how many were monitoring and reporting failures, and how many are still open. Codes are turned into words.

In this snapshot, 23,118 systems have at least one open violation (61,962 open violations in all), and 19,763 had a health-based violation in the five years. The file includes all 49,339 community systems (the ones that serve homes), so you can rank, map or screen by state, size or owner.

Personal contact details (names, phones, emails, mailing addresses) are never in the file. A free sample and a full 56-row state summary are available first, so you can check the columns before you buy.

What's in it

30 columns, one row per system

In plain wordsColumns
Which systempwsid (EPA's ID, the row key), system_name, state, epa_region, primacy_agency (who regulates it)
What kindsystem_type (community, schools and workplaces, or passers-by), owner_type, primary_source (ground or surface water, bought or not), is_wholesaler, serves_school_or_daycare, operator_org (only when it is clearly an organization)
How bigpopulation_served, service_connections, size_class
Wherecounties_served, cities_served, zips_served
Violations, last 5 yearsviolations_5y, health_violations_5y, monitoring_violations_5y, lead_copper_violations_5y, health_rule_families_5y
Open nowopen_violations (any age, not yet back in compliance)
Most recentlatest_violation_date, latest_violation_rule, latest_violation_contaminant
Enforcementformal_enforcement_5y, latest_enforcement_date
Dates and sourcefirst_reported, source_quarter

Free sample

100 community water systems, drawn by state with a fixed seed, so every state and territory shows up. Same 30 columns as the full file. With it: every state's and territory's totals (56 rows), and the data dictionary.

Price

OptionPriceWhat you get
National file, one-time$79The full system file for the current snapshot
Annual plan$199 a yearThe full file now, and each quarterly update for a year

Checkout opens when the store goes live.

See the refund policy and the terms.

Sources

Built from the US Environmental Protection Agency's Safe Drinking Water Information System (SDWIS), as published on ECHO.

Permission: EPA's data is in the US public domain (17 U.S.C. 105), so anyone may reuse it.

No warranty: the source data comes from the US Environmental Protection Agency with no warranty of accuracy, completeness or timeliness, and the files are provided as they are.

Cited Data is not affiliated with or endorsed by the US Environmental Protection Agency or any government body.

Questions

How fresh is the data?
It is EPA's 2026Q3 snapshot (built 2026-10-21), with violations counted over 2021-10-01 to 2026-09-30. Each row carries source_quarter, so you always know the snapshot.
What does "open violation" mean?
A violation of any age that has not yet returned to compliance: EPA's status is "unaddressed" or "addressed" and no return-to-compliance date is recorded. A system can have more than one.
Does a violation mean the water is unsafe?
Not necessarily. Health-based violations (a contaminant over its limit, or a required treatment not done) are separate from monitoring and reporting violations (tests not taken or not reported); the file counts them separately. States also report to EPA late or incompletely, so check a system on EPA's ECHO site before acting on a single row.
Are personal details included?
No. Contact names, phones, emails and mailing addresses are dropped when the data is loaded. 7,798 system names that were or looked like a person's name are shown as "Water system <pwsid>".
Which systems are in the file?
All 143,015 active public water systems in the 2026Q3 snapshot: 49,339 community systems plus non-community ones (schools, workplaces, campgrounds and similar). Inactive systems are left out.