Rollford Research

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

Rollford compiles each system's inventory, replacement plan, consultant, funding and procurement record from public filings, with a source and a date on every fact. It is built for the engineering firms, contractors and suppliers who will do the work.

Request the Illinois sample See pricing

First edition: every community water supply in Illinois, December 2026. Questions go to Connor at connor@rollfordresearch.com.

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. Sources: 2026 replacement plan update, Village Council agenda, March 2026; council presentation, March 11, 2025.

The dates that set the pace

  1. Final replacement plans are due to Illinois EPA from every community water supply.

    Illinois Lead Service Line Replacement and Notification Act

  2. 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

  3. 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.

What a record holds

One row per water system in the spreadsheet, and a full sheet 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
State revolving fund awards, principal forgiveness and project priority list entries.
Procurement
Purchasing contact, bid portal, past lead line contracts, awarded contractors and unit prices where published.
Sources
A link and a checked-on date for every fact, so anyone on your team can verify it.

Who uses it

Engineering firms

See which systems have no consultant named on their plan, and which firm holds the rest, before the final 2027 plans are written.

Utility contractors

Find funded replacement programs before they go to bid, with past unit prices and the contractors who won.

Distributors and manufacturers

Plan territories by where the next lines will be replaced, system by system and year by year.

Pricing

Company-wide licenses. Pay by card, or by invoice on net 30 terms.

  • 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.

    Founding buyers: the first five pay $500 and give us a 30-minute feedback call.

    $750one time

    Email to order

  • 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

    Email to subscribe

  • 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

    Email to request

Sources

Compiled from the public record. We cite; we don't forecast.

  • U.S. EPA service line inventory data reported by each water system
  • Illinois EPA material inventory reports and replacement plans filed under state law
  • Illinois EPA Public Water Supply Loan Program intended use plans and project priority lists
  • Village and city council packets, bid notices and award notices

Spot an error? Write to us and it will be corrected, with the change noted, within five business days.