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
- Joined: EPA's 11 linked tables become one row per system, so there is nothing to join.
- Counted: violations, health-based violations, open violations and enforcement actions over five years, counted per system as distinct events, not table rows.
- Plain words: every code turned into words.
- Cleaned: inactive systems left out; personal contact details removed, and 7,798 names that were a person's replaced.
- One format: a CSV with a data dictionary that gives each column's meaning and fill rate.
- Kept current: rebuilt from each quarterly EPA snapshot; the yearly plan sends each one.
- Cited: every source file, its download date and its SHA-256 are listed.
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 words | Columns |
|---|---|
| Which system | pwsid (EPA's ID, the row key), system_name, state, epa_region, primacy_agency (who regulates it) |
| What kind | system_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 big | population_served, service_connections, size_class |
| Where | counties_served, cities_served, zips_served |
| Violations, last 5 years | violations_5y, health_violations_5y, monitoring_violations_5y, lead_copper_violations_5y, health_rule_families_5y |
| Open now | open_violations (any age, not yet back in compliance) |
| Most recent | latest_violation_date, latest_violation_rule, latest_violation_contaminant |
| Enforcement | formal_enforcement_5y, latest_enforcement_date |
| Dates and source | first_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
| Option | Price | What you get |
|---|---|---|
| National file, one-time | $79 | The full system file for the current snapshot |
| Annual plan | $199 a year | The 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.
- EPA ECHO SDWA bulk download (SDWIS): https://echo.epa.gov/files/echodownloads/SDWA_latest_downloads.zip
- EPA ECHO Drinking Water System Search export (cross-check only): https://echo.epa.gov/files/echodownloads/SDWA_system_search_download.zip
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.