2026-04-06

Lead Pipe

Every pipe has a name. Every city gets a grade. Your water's report card, updated automatically.

Consumer-facing lead service line replacement accountability — city-by-city progress scorecards, utility report cards, violation tracking, funding accountability, and hyperlocal "is my water safe?" intelligence, auto-generated from EPA's first-ever national lead pipe inventory data plus SDWIS/ECHO enforcement records.

Niche Explored

Lead service line (LSL) replacement accountability — consumer-facing intelligence tracking the biggest forced infrastructure replacement in US drinking water history. The EPA’s Lead and Copper Rule Improvements (LCRI), finalized October 2024, requires all ~66,500 US water systems to inventory and replace lead pipes by 2037. EPA’s November 2025 dashboard revealed 4 million confirmed/projected LSLs. $15 billion in federal funding allocated via the Bipartisan Infrastructure Law.

Why This Niche, Why Now

Regulatory trigger: LCRI compliance deadlines are NOW. Water systems submitted first inventories October 2024. Updated inventories due November 2027.
Massive public interest: Affects 4+ million homes directly. 250+ million people served by systems with worrisome lead levels (NRDC).
High anxiety niche: Parents, homeowners, renters — all want to know “is MY water safe?”
$15B in federal money flowing: Creates accountability journalism opportunity (who’s spending it well, who isn’t).
Affiliate goldmine: Lead testing kits ($30-$200), NSF-53 certified filters ($50-$500), whole-house systems ($1,000+).

Existing Competition

EWG Tap Water Database — Excellent but broad (all contaminants), not laser-focused on lead pipes. No replacement tracking.
NRDC Lead Pipe Map — Great state-level analysis, but static reports, not a living dashboard site.
Unleaded Kids — Strong advocacy/blog, not data-journalism formatted or auto-updated.
TapWorks — Compliance-focused for utilities, not consumer-facing.
Local news — Sporadic coverage, no national aggregation.
GAP: Nobody is building an auto-updating, city-by-city, utility-by-utility lead pipe replacement progress tracker with consumer-grade design, accountability scorecards, and affiliate monetization. The data exists but is buried in government databases.

Data Sources Found

Primary — All Free, Machine-Readable

EPA SDWIS/ECHO API — REST API with JSON responses for all 160,000+ public water systems. Lead & Copper violations, enforcement actions, compliance status.
- URL: https://echo.epa.gov/tools/web-services
- Download: https://echo.epa.gov/tools/data-downloads/sdwa-download-summary
- Contains: water system info, violations, enforcement, lead/copper sample results
EPA Service Line Inventory Dashboard — First-ever national LSL inventory data (released Nov 2025)
- 66,500+ water systems with service line counts by category (lead, GRR, unknown, non-lead)
- URL: https://sdwis.epa.gov/ords/sfdw_pub/r/sfdw/sdwis_fed_reports_public/service-line-inventory
- State-level and water-system-level data
EPA DWSRF Funding Allocations — How much each state received for LSL replacement
- $15B total via BIL, broken out by fiscal year and state
- URL: https://www.epa.gov/dwsrf
EPA Lead and Copper Rule Sampling Data — Actual lead levels measured at the tap
- 90th percentile lead levels for every water system
- Available through SDWIS/ECHO
Census Bureau ACS — Demographics for environmental justice overlay
- Median income, % children under 6, race/ethnicity by census tract
- API: https://api.census.gov/data.html
HUD Lead Paint Data — Correlates with lead pipe presence in older housing
- URL: https://data.hud.gov
State-level open data portals — Many states publish their own LSL inventories
- Chicago: https://www.chicago.gov/city/en/depts/water/supp_info/lead-service-line-replacement.html
- Michigan: public LSL inventory maps
- New Jersey: published utility-level data

SEO Analysis

Keywords:
- “lead pipes in my area” — high volume, moderate competition
- “does my water have lead” — high volume
- “lead service line replacement [city]” — long-tail, LOW competition (each city is its own keyword)
- “lead pipe map” — growing search volume
- “EPA lead pipe rule 2026” — trending, very low competition
- “lead water filter” — extremely high volume, high competition (but content + affiliate)
- “water lead test kit” — high volume, moderate competition
SEO strategy: Programmatic SEO — auto-generate a page for every water system (66,500+ pages), every state (50+), every city with lead pipes. Each page is a unique long-tail keyword target. This is the same strategy that made sites like Zillow and Yelp massive.
Content freshness signal: Auto-update when EPA data refreshes (quarterly/annually) — Google loves freshness.

Communities

r/centuryhomes (303K members) — constant “is my water safe?” posts
r/FirstTimeHomeBuyer — lead anxiety is a recurring theme
r/HomeImprovement (3.5M members) — plumbing/water quality posts
r/ScienceBasedParenting — lead exposure anxiety is HUGE
r/water, r/WaterTreatment — niche but engaged
Facebook groups: “Lead-Free Kids”, local parent groups
Nextdoor: hyperlocal concern about water quality
Twitter/X: #GetTheLeadOut, #LeadPipes trending during news cycles

Image/Graphic Feasibility

Maps: Choropleth maps by state/county/city showing LSL density — VERY automatable with D3.js or Mapbox
Scorecards: Utility report card graphics with letter grades — templated, auto-generated
Progress bars: Replacement progress trackers per city — engaging, shareable
Comparison charts: Your city vs. national average lead levels
Data viz: Trend lines of lead violations over time, funding allocation breakdowns
Before/after: Lead pipe photos from public domain sources + AI-generated infographics
Shareability factor: 10/10 — people WILL share “Your city has X thousand lead pipes” graphics

Monetization Viability

Affiliate: Lead test kits (Tap Score pays 15% commission, $30-200 per kit), NSF-53 certified filters (Amazon Associates, 3-8%), whole-house filtration (higher commissions via direct partnerships)
Tap Score affiliate program: https://mytapscore.com/pages/become-a-tap-score-affiliate (15% commission, 60-day cookie)
Newsletter premium tier: Parents would pay $5-10/mo for hyperlocal lead alerts
Donations: Strong cause — protecting kids from lead poisoning
Potential sponsors: Water filter companies, home inspection services, real estate platforms