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.

statenet leadnet unknownnet galvinventory completed
AK0001
AR0000
AZ1-4,41759630
CA-9-179,694-21278
CO1-3,144-1,02823
CT0-102
DE0000
FL0-1,678-4,0460
GA-4-22,386-55578
HI0000
IA-4-309-621
ID0-17-11
IL201,957-223,447-1,6367
IN7-5,989-1311
KS-1-74-70
KY0000
LA0-1,122-835
MA000754
MD-152-1,05582
ME0-4510
MI0000
MN-2,177-48,5681,3771
MO20-10,386-4830
MP0002
MS0000
MT0000
NC60000
NE-1-208-3300
NH0000
NJ0000
NM0-740034
NN000101
NV0-700
NY00019
OH2-2311921
OK00047
OR0-52305
PA-3-11,192-19262
PR0000
SC-801-48,796-3,7431
SD-1-5,52810
TN0000
TX-59-41,320-45275
UT0-53900
VA0-215-145
VT5-1,707-6213
WA-3,624-10,713-8869
WI-7781,256-7184
WV0000
WY0-3900
Download the data

Download CSV Download JSON

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.

Source: EPA SDWIS federal snapshot-diff (ZipCheckup engine)
Every number here is recomputed from public federal data on each build by open-source code in the ZipCheckup repository; a dated CSV snapshot is published with each finding. No data does not mean safe.

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

APA ZipCheckup. (2026). Lead Pipe Inventory: Quarterly Movement. https://zipcheckup.com/findings/lead-pipe-inventory-quarterly-movement/
BibTeX
@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.