US Lead and Copper Rule Violations Dataset by Cited Data
Every active US public water system with a Lead and Copper Rule violation in the last 5 years, one row per system, in plain words, from EPA's Safe Drinking Water data.
What we added to the public records
- Picked out: the 21,374 systems with a Lead and Copper Rule violation, out of EPA's 143,015 active systems, so there is nothing to filter.
- Joined: EPA's linked tables become one row per system.
- Counted: Lead and Copper Rule violations, violations of every rule, open violations and enforcement actions, per system, as distinct events.
- Plain words: every code turned into words.
- Cleaned: personal contact details removed, and names that were a person's replaced.
- Summed up: a count table for each of the 55 states and territories.
- 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.
This is the Lead and Copper Rule cut of our US water system file: the 21,374 active public water systems that EPA's records show had at least one Lead and Copper Rule violation in the five years 2021-10-01 to 2026-09-30. That is 14.9% of the 143,015 active systems, in 55 states and territories, with 43,440 such violations between them.
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, with its Lead and Copper Rule violation count, its violations of every rule, how many are still open, and its enforcement actions. 15,379 are community systems (the ones that serve homes).
What it is not: the file has no lead or copper test results and no action-level exceedances. A Lead and Copper Rule violation can be a sample not taken, a report not filed, or a required treatment or public-education step not done. The file shows which systems have such violations on record, not lead levels in anyone's water.
Personal contact details are never in the file. A free sample and a full state-by-state count table are available first.
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, owner_type, primary_source, 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 |
| Lead and Copper Rule | lead_copper_violations_5y (1 or more on every row) |
| Violations of any rule, last 5 years | violations_5y, health_violations_5y, monitoring_violations_5y, health_rule_families_5y |
| Open now | open_violations (any rule, 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 from this file, drawn by state with a fixed seed: 55 states and territories, 50 with a violation still open. Same 30 columns as the full file. With it: the count table for all 55 states and territories, and the data dictionary.
Price
| Option | Price | What you get |
|---|---|---|
| Subset, one-time | $29 | The subset file for the current snapshot, with the state counts |
| Annual plan | $59 a year | The subset 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. It is the Lead and Copper Rule cut of the US Water System Violations Dataset.
- 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
- Does this file show lead levels?
- No. It has no lead or copper sample results and no action-level exceedances. It lists systems with at least one Lead and Copper Rule violation on record in the five years, and how many.
- What does a Lead and Copper Rule violation mean?
- That EPA's records show the system broke a requirement of the rule: for example a sample not taken, a report not filed, or a required treatment or public-education step not done. The file counts them; it doesn't say which kind each one was. Check a system on EPA's ECHO site before acting on a single row.
- How fresh is the data?
- EPA's 2026Q3 snapshot, with violations counted over 2021-10-01 to 2026-09-30. Each row carries
source_quarter. - How is it different from the full water system file?
- Same columns, same rows for these systems; the full file has all 143,015 active systems, with or without a Lead and Copper Rule violation.
- Are personal details included?
- No. Contact names, phones, emails and mailing addresses are dropped when the data is loaded, and a system name that was or looked like a person's is shown as "Water system <pwsid>".
- What format is it?
- A CSV file with a header row (30 columns), plus
state-counts.csvand the data dictionary.