Rollford Research

Every state 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 on request: we confirm the delivery date with you, and you're billed when it ships

U.S. EPA service line inventoryThird quarter of 2026

State

community water systems with lines to address

lead, galvanized or unknown lines to replace or identify

  • Lead
  • Galvanized requiring replacement
  • Material unknown

Counts as each water system reported them. The full ledger adds plans, consultants, funding and contracts for every system.

The largest programs

By lead and galvanized lines reported in 2026.

Water systemLead and galvanizedUnknown

What the ledger holds

One row per water system in the spreadsheet, the same format as the Illinois ledger.

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.

The dates that set the pace

  1. 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
  2. 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. The state ledger adds any earlier deadlines that state law sets.

Pricing

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

Built on request. We confirm the delivery date with you, and you're billed when it ships.

  • State ledger

    Every system in the state with lead, galvanized or unknown lines, as a spreadsheet with a short 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
  • Several states or nationwide

    One company-wide license and one renewal date for every state your firm works in.

    Customquoted by states and teams

    Request a quote

See the sample first

Twenty real systems from the Illinois ledger, with full records for four of them. Every state's ledger follows the same format.