Know where infrastructure work is coming before it goes to bid.
Rollford Research tracks the replacement programs that federal and state rules require, utility by utility: what each system must replace, what it has filed, who is advising it and how it is paying. Every fact is sourced and dated.
Lead service lines
Largest systems outside Chicago
| Water system | Lines to replace | State loans, FY2027 |
|---|---|---|
| Rockford | 43,926 | $20.0M |
| Aurora | 16,079 | $8.0M |
| Skokie | 15,259 | $12.0M |
| Chicago Heights | 9,289 | $30.0M |
| Springfield | 9,201 | $4.5M |
The full ledger covers every Illinois system, with plans, consultants, contracts and sources. See what a record holds
- Lead and galvanized lines
- 3.1 millionReported to EPA by water systems in 2026, all to be replaced under the federal rule
- Replacement work
- $20 billion+Those lines at EPA's estimated $6,500 to $8,500 per full replacement
- Federal funding
- $15 billionSet aside for lead lines by the 2021 infrastructure law, 2022 to 2026, before state and local money
What you get
One spreadsheet per state, with a short brief, licensed to your whole company.
Below are a few real rows from the Illinois edition. The full ledger has every row, for every system in the state.
A bid calendar: every funded project by its estimated start, soonest first, with the engineer where records name one.
| Start | Water system | Loan requested |
|---|---|---|
| May 2027 | Forest Park | $4.0M |
| May 2027 | Oak Lawn | $4.4M |
| Aug 2027 | Western Springs | $1.3M |
| Sep 2027 | Marshall | $4.0M |
| Oct 2027 | Quincy | $4.3M |
5 of 136 Illinois projects shown. The full tab lists every one through 2027.
Every system in the state, one row each: lines by material, plan status, consultant, state funding and past contracts.
| Water system | Lead and galvanized | State loans, 2027 |
|---|---|---|
| Aurora | 16,063 | $8.0M reserved |
| Rockford | 15,328 | $20.0M reserved |
| Cicero | 13,039 | $10.0M reserved |
| Berwyn | 10,828 | $7.0M reserved |
| Bloomington | 5,531 | $40.0M listed |
5 of 559 Illinois systems shown. The full tab has one row for each.
Who bid, who won and at what price, each traced to the council vote or bid tab.
| Water system | Contractor | Contract |
|---|---|---|
| St. Charles | Swallow Construction | $7.65M |
| Naperville | Trine Construction | $3.39M |
| Aurora | Brandt Excavating | $2.72M |
| Riverside | Pipe Strong | up to $2.59M |
| Western Springs | Anchor Mechanical | up to $1.05M |
5 of 149 Illinois contract records shown, with more added each quarter.
With the subscription: an email when a system wins funding, posts a plan or opens a bid.
Illinois EPA finalizes its 2027 loan lists: 275 lead line projects requesting $1.24 billion.
Western Springs awards Phase 2 (47 properties) to Anchor Mechanical, up to $1.05 million.
Riverside approves Phase 2 with Pipe Strong, up to $2.59 million for at least 325 lines, pending its state loan.
Three examples from 2026.
Also in every edition: a Start here tab that totals any county you pick, county and state loan tabs, and a Sources tab with a link and checked date behind every value.
Who it's for
Estimators, business development and water practice leads, and the branch managers who stock the job.
Utility contractors
Which towns go to bid next, and who won the last one?
Quincy has $4.25 million in 2027 loans for 470 lines. Hood Construction won its 2025 contract at $2.73 million.
Engineering firms
Which systems still have no engineer on their lead line work?
110 of the 137 Illinois systems with 2027 lead line loans name no engineer in public documents.
Waterworks suppliers
Where will the pipe and fittings go, county by county?
Cook County: 509,043 lead and galvanized lines across 92 systems, and $691 million in 2027 loans listed.
Pricing
Priced per state and licensed to your whole company. Pay by card, bank transfer or invoice.
State ledger
$750per state, one time
Every system in one state, as a spreadsheet and a short brief.
- Coming up, Ledger and Who won tabs
- A source and checked date on every fact
- One update within 90 days
- Company-wide license
Ledger subscription
$2,400per state, per year
For teams that bid every year: the state ledger kept current all year.
- Everything in the state ledger
- Refreshed every quarter
- Email alerts when a system wins funding, posts a plan or opens a bid
Several states
Customquoted by states and teams
One license for every state your firm works in, up to all of them.
- Subscriptions for each state you choose
- One license and one renewal date
- New states built on request
Need one territory or a list of systems instead? A custom pull covers up to 100 named systems, with a one-page memo, for $1,500. Request one.
How we work
Filings, not forecasts. Every number can be checked by anyone on your team.
1,287 lead service lines in Downers Grove
- FiledThe village's 2026 replacement plan update, inventory as of December 31, 2025
- RecordedIn the ledger with a link to that document, next to last year's 781
- CheckedNovember 8, 2026, and again every quarter for subscribers
- 559
- Illinois systems, every one with lines to address
- 327
- state loan entries, matched to their systems
- 149
- contracts and bids traced to the firms named
- $1.24B
- requested in 2027 state loans for 275 lead line projects
Every state
Every state has its own page with its line counts and largest programs. Pick one on the map.
| State | Lead and galvanized lines | Replacement work |
|---|---|---|
| Illinois | 666,132 | $4.3 billion |
| Ohio | 322,473 | $2.1 billion |
| New York | 289,055 | $1.9 billion |
| Michigan | 255,236 | $1.7 billion |
| Indiana | 190,933 | $1.2 billion |
| Wisconsin | 159,084 | $1.0 billion |
| New Jersey | 115,171 | $749 million |
| Texas | 114,872 | $747 million |
| Pennsylvania | 113,711 | $739 million |
| Minnesota | 87,014 | $566 million |
See the sample first
Twenty real systems from the Illinois ledger, with full records for four of them and the source of every value. Every state's ledger follows the same format.