Download the lead service line data
Free CSV of lead service line counts for all 49,321 U.S. community water systems, one row per system.
What's in it
| Column | Meaning |
|---|---|
| pwsid | EPA public water system ID |
| name, state | Water system name and state |
| cities_served, counties_served | From EPA SDWIS service area records, where reported |
| population_served | Population served, as reported to EPA |
| lead, galvanized_requiring_replacement, lead_status_unknown, non_lead, total_reported | Service line counts from the inventory |
| report_status | Whether the system reported all required service line types |
| latest_sample_exceeded_action_level | Y if the most recent 90th-percentile lead result in EPA data was above 15 ppb |
| lcr_violations_since_2015, lcr_health_based_violations_since_2015, lcr_open_violations | Lead and Copper Rule violations in EPA SDWIS since 2015: all, health-based (treatment technique), and still open |
| latest_lead_90th_percentile_ppb, latest_lead_sampling_period | Most recent Lead and Copper Rule 90th-percentile lead result (ppb) and its sampling period |
| lead_pipe_map_url | The system's page on this site, if it has one |
Source and license
Counts come from EPA SDWIS service line inventory, 2026 Q3, a U.S. government work. Our cleaned and joined version is free to use under CC BY 4.0. Please credit "Lead Pipe Map (leadpipemap.com)" with a link.
Using it in a story
Reporters can also embed a live card for any water system; the code is at the bottom of each utility page. National lists are on the rankings page.