Cited Data

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

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 wordsColumns
Which systempwsid (EPA's ID, the row key), system_name, state, epa_region, primacy_agency (who regulates it)
What kindsystem_type, owner_type, primary_source, 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
Lead and Copper Rulelead_copper_violations_5y (1 or more on every row)
Violations of any rule, last 5 yearsviolations_5y, health_violations_5y, monitoring_violations_5y, health_rule_families_5y
Open nowopen_violations (any rule, 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 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

OptionPriceWhat you get
Subset, one-time$29The subset file for the current snapshot, with the state counts
Annual plan$59 a yearThe 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.

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.csv and the data dictionary.