Every Illinois water system replacing lead service lines, in one ledger.

Each system's inventory, replacement plan, consultant, state funding and procurement record, compiled from public filings with a source and a date on every fact. Built for the engineering firms, contractors and suppliers who will do the work.

Get the Illinois sample See pricing

First edition: every community water supply in Illinois, December 2026.

Sample recordChecked November 8, 2026

Village of Downers Grove

PWS ID IL0430300, DuPage County

2,594lines to replace, of 17,064 service connections

LeadUp from 781 a year earlier1,287
Galvanized requiring replacement181
Material unknown1,126

Consultant of record: Engineering Enterprises, Inc.
Schedule: 254 replacements a year, November 2027 through 2037
Cost per line: $4,500 to $7,000 public side; $5,000 to $7,500 private side
Budget: $500,000 for lead line work in fiscal 2026
Next filing: Final plan due to Illinois EPA April 15, 2027

Inventory as of December 31, 2025, from the village's 2026 replacement plan update and its March 2025 council presentation.

Lead lines: 608,727Reported across Illinois
Material unknown: 514,187Lines that must be identified, and replaced if lead
State loans reserved: $96.5MFY2027, at eight of the 20 largest systems outside Chicago

Line counts as reported by water systems in 2026. Loan figures from Illinois EPA's FY2027 funding list.

The dates that set the pace

April 15, 2027
Final replacement plans are due to Illinois EPA from every community water supply.
Illinois Lead Service Line Replacement and Notification Act
November 1, 2027
Replacement plans are due from water systems nationwide, and required replacement begins at about 10 percent a year.
U.S. EPA Lead and Copper Rule Improvements
2037
Lead and galvanized lines must be gone, with longer schedules allowed for a small number of very large systems.
U.S. EPA Lead and Copper Rule Improvements

The federal rule is being challenged in court. Illinois's own law requires replacement regardless, on state schedules that begin in 2027.

Your territory first

The spreadsheet opens on Start here. Pick a county and you see its totals and every system in it, largest first, so each office, branch or estimator starts from the ground they cover.

A second tab, Coming up, lists every project funded or starting by the end of 2027, soonest first: a bid calendar you can filter by county.

Your countyKane

Systems: 20
Lines to address: 34,275
FY2027 loans listed: $38.4M
Funding reserved: $8.0M

Water system	Lines to address	State loan status
Aurora	16,079	Funding reserved
Elgin	9,687	Scored, loan only
St. Charles	4,629	Scored, loan only
17 more Kane County systems in the ledger, with loan amounts, start dates and any engineer or contractor named in public records

What Start here shows for Kane County, from the Illinois ledger checked November 8, 2026.

What a record holds

One row per water system in the spreadsheet, and a full record like the sample when you need the detail.

Lines by material: Lead, galvanized requiring replacement, unknown and non-lead counts, with the change since the last filing.
Replacement plan: Filing status, annual pace, schedule and cost estimates from the latest plan.
Consultant of record: The engineering firm named on the plan, or a note that none is named.
Funding: Loans, grants and forgiveness the system has been awarded or has applied for.
Procurement: Purchasing contact, past lead line contracts, who won them and unit prices where published.
Sources: A citation and a checked-on date for every fact, so anyone on your team can verify it.

Who it's for

The teams that decide where a firm pursues work.

Estimating and business development

Work from Coming up as a bid calendar: funded projects, estimated starts, the engineer of record and who won the last contract.

Water and municipal practice leads

See which systems have an engineer named on their lead line work and which have none on record yet, ahead of the April 2027 plan deadline.

Branch and territory managers

Rank counties and systems by lines and loans to plan coverage, and keep every office current with the quarterly subscription.

Pricing

Company-wide licenses. Pay by card, bank transfer or invoice.

Every fact is sourced and dated.

State ledger: Illinois
Every Illinois system with lead, galvanized or unknown lines, as a spreadsheet with a four-page brief. One update within 90 days is included.

$750one time
Request the ledger
Ledger subscription
The state ledger refreshed every quarter, with email alerts when a system wins funding, posts a plan or opens a bid.

$2,400per state, per year
Request a subscription
Custom pull
Your territory or a named list of up to 100 systems, with a one-page memo, delivered in two weeks.

$1,500one time
Request a custom pull

See the sample first

Twenty real systems from the Illinois ledger, with full records for four of them and the source of every value, so you can judge the depth before you buy.

Get the Illinois sample