Lead Pipe Inventory: Quarterly Movement
Data current as of June 2026. Recomputed by ZipCheckup from federal data each build.
ZipCheckup's SDWIS snapshot-diff shows 1,526 systems completed lead inventories between 2026Q1 and 2026Q2, as of June 2026.
Between 2026Q1 and 2026Q2, EPA SDWIS records show a net change of +194,299 lead lines and -623,674 unknown-material lines, with 1,526 systems completing their inventory.
By state
We report two independent facts side by side and do not rank states. A larger count reflects the size of a state's inventory and its reporting activity, not a judgment about water safety.
| state | net lead | net unknown | net galv | inventory completed |
|---|---|---|---|---|
| AK | 0 | 0 | 0 | 1 |
| AR | 0 | 0 | 0 | 0 |
| AZ | 1 | -4,417 | 596 | 30 |
| CA | -9 | -179,694 | -212 | 78 |
| CO | 1 | -3,144 | -1,028 | 23 |
| CT | 0 | -1 | 0 | 2 |
| DE | 0 | 0 | 0 | 0 |
| FL | 0 | -1,678 | -4,046 | 0 |
| GA | -4 | -22,386 | -555 | 78 |
| HI | 0 | 0 | 0 | 0 |
| IA | -4 | -309 | -62 | 1 |
| ID | 0 | -17 | -1 | 1 |
| IL | 201,957 | -223,447 | -1,636 | 7 |
| IN | 7 | -5,989 | -13 | 11 |
| KS | -1 | -74 | -7 | 0 |
| KY | 0 | 0 | 0 | 0 |
| LA | 0 | -1,122 | -83 | 5 |
| MA | 0 | 0 | 0 | 754 |
| MD | -152 | -1,055 | 8 | 2 |
| ME | 0 | -45 | 1 | 0 |
| MI | 0 | 0 | 0 | 0 |
| MN | -2,177 | -48,568 | 1,377 | 1 |
| MO | 20 | -10,386 | -48 | 30 |
| MP | 0 | 0 | 0 | 2 |
| MS | 0 | 0 | 0 | 0 |
| MT | 0 | 0 | 0 | 0 |
| NC | 60 | 0 | 0 | 0 |
| NE | -1 | -208 | -330 | 0 |
| NH | 0 | 0 | 0 | 0 |
| NJ | 0 | 0 | 0 | 0 |
| NM | 0 | -740 | 0 | 34 |
| NN | 0 | 0 | 0 | 101 |
| NV | 0 | -7 | 0 | 0 |
| NY | 0 | 0 | 0 | 19 |
| OH | 2 | -231 | 19 | 21 |
| OK | 0 | 0 | 0 | 47 |
| OR | 0 | -523 | 0 | 5 |
| PA | -3 | -11,192 | -192 | 62 |
| PR | 0 | 0 | 0 | 0 |
| SC | -801 | -48,796 | -3,743 | 1 |
| SD | -1 | -5,528 | 1 | 0 |
| TN | 0 | 0 | 0 | 0 |
| TX | -59 | -41,320 | -452 | 75 |
| UT | 0 | -539 | 0 | 0 |
| VA | 0 | -215 | -1 | 45 |
| VT | 5 | -1,707 | -62 | 13 |
| WA | -3,624 | -10,713 | -88 | 69 |
| WI | -778 | 1,256 | -718 | 4 |
| WV | 0 | 0 | 0 | 0 |
| WY | 0 | -39 | 0 | 0 |
Open data, licensed CC BY 4.0 · DOI: 10.5281/zenodo.19427201
How we compute this
We diff two consecutive federal SDWIS snapshots and sum the signed change per category across every reporting system. A negative net-unknown means utilities reclassified previously-unknown lines after physically verifying them.
Direction is reported, not judged. A change in lead-classified lines reflects reclassification and replacement together; we do not attribute causation between the two.
Systems that started or stopped reporting between snapshots are counted as reporting transitions, not as numeric changes from zero, so a new reporter never inflates the movement totals.
Frequently asked questions
How much did U.S. lead-pipe inventories move last quarter?
Comparing the 2026Q1 and 2026Q2 EPA SDWIS snapshots, the net change was +194,299 lead lines and -623,674 unknown-material lines as of June 2026. These are signed sums across all reporting systems. according to ZipCheckup's reading of federal data as of June 2026.
How many systems completed an inventory between snapshots?
EPA SDWIS records show 1,526 systems first reported a completed lead service line inventory between 2026Q1 and 2026Q2.
How to cite this page
ZipCheckup. (2026). Lead Pipe Inventory: Quarterly Movement. https://zipcheckup.com/findings/lead-pipe-inventory-quarterly-movement/
@misc{zipcheckup-findings-lead-pipe-inventory-quarterly-movement,
author = {{ZipCheckup}},
title = {{Lead Pipe Inventory: Quarterly Movement}},
year = {2026},
url = {https://zipcheckup.com/findings/lead-pipe-inventory-quarterly-movement/}
}
Data as of June 2026.