2026-04-06 · 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.

Lead Pipe

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

Channel: Lead Pipe Tagline: Every pipe has a name. Every city gets a grade. Your water’s report card, updated automatically. Niche: 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. Target audience: Homeowners in older homes (pre-1986 construction), parents of young children, renters in cities with known lead pipe problems, real estate buyers doing due diligence, environmental justice advocates, and local journalists covering water infrastructure. Why now: The EPA’s Lead and Copper Rule Improvements (LCRI) just created the most consequential US drinking water regulation since 1991. As of October 2024, all 66,500+ water systems were required to submit their first-ever service line inventories. EPA published the national dashboard in November 2025, revealing 4 million lead and galvanized-requiring-replacement service lines. The 10-year replacement clock is now ticking. $15 billion in federal funding is flowing. Updated inventories are due November 2027. There has NEVER been more data available — or more public anxiety — about lead in drinking water. And nobody is building the consumer-facing accountability tracker this moment demands.

Content Example

🔴 CITY REPORT CARD: Chicago, IL — Grade: D+

Population served: 2.7 million | Lead pipes: 333,000 projected | Replacement rate: 0.7%/yr | Years to complete at current pace: 142 years | Federal funding received: $368M

Chicago has more lead service lines than any city in America. That’s not an opinion — it’s EPA inventory data filed in October 2024.

The numbers tell a damning story. Of the city’s 487,000 service lines, Chicago Water Management reported 150,767 as confirmed lead and another 251,569 as “unknown” — a bureaucratic category that, in Chicago’s case, almost certainly means “lead but we haven’t dug it up yet.” In 2022, the city reported 409,734 lead lines and zero unknowns. By 2024, they’d magically reclassified 258,967 lead lines as “unknown.” The pipes didn’t change. The paperwork did.

At the current replacement rate of roughly 2,300 lines per year, Chicago won’t finish until the year 2168. The LCRI deadline is 2037. The math doesn’t work unless the city replaces 30,000+ lines annually — a 13x acceleration from current pace.

Here’s what’s actually happening with the money: Chicago received $368 million in Bipartisan Infrastructure Law funds through the Drinking Water State Revolving Fund. The city’s own lead pipe replacement program, launched in 2020, has replaced approximately 4,600 lines in four years. That’s $80,000 per pipe at current spending rates — well above the national average replacement cost of $4,700 estimated by EPA.

Where is the rest of the money going? Inventory verification, program administration, engineering studies, and equity mapping. All defensible line items. But the clock is ticking, and 333,000 families are still drinking through lead.

How Chicago Compares

What You Should Do If You Live in Chicago

1. Check your service line — Use the city’s online lookup tool and physically inspect where the pipe enters your basement. A lead pipe is dull gray, soft (you can scratch it with a key), and a magnet won’t stick.
2. Get your water tested — Chicago’s free testing program has a multi-month waitlist. A certified lab test kit gives results in 5-7 business days and tests for 100+ contaminants, not just lead.
3. Use a certified filter — Only filters certified to NSF/ANSI Standard 53 for lead reduction are proven effective. Brita Elite and PUR PLUS pitchers are the most accessible options (~$30). For kitchen sink use, an under-sink reverse osmosis system removes >99% of lead.
4. Flush your pipes — Run cold water for 2+ minutes each morning before drinking or cooking, especially if water has been sitting in pipes for 6+ hours. Never use hot tap water for cooking or baby formula — heat leaches more lead from pipes.
5. Sign up for replacement notifications — Your water system is required to notify you annually if your line is lead or unknown. Check your latest notice and register for updates.

The data behind this report card updates automatically when EPA publishes new inventory data. Last updated: April 6, 2026.

Data Sources

• EPA ECHO/SDWIS REST API — Water system violations, enforcement actions, lead/copper sampling results. Free, JSON, no API key required for basic queries. Rate limited but generous for batch use.

  • Endpoint: https://echodata.epa.gov/echo/sdw_rest_services.get_systems
  • Download bulk CSVs: https://echo.epa.gov/tools/data-downloads/sdwa-download-summary

• EPA Service Line Inventory Dashboard — First national dataset of LSL counts by water system (Nov 2025). Scrape-able or bulk downloadable.

  • URL: https://sdwis.epa.gov/ords/sfdw_pub/r/sfdw/sdwis_fed_reports_public/service-line-inventory

• EPA DWSRF Funding Data — State-by-state BIL allocation for LSL replacement, by fiscal year.

  • URL: https://www.epa.gov/dwsrf

• US Census ACS API — Demographics for environmental justice overlay (median income, % children under 6, race/ethnicity by census tract).

  • API: https://api.census.gov/data.html

• State Open Data Portals — Many states publish utility-level LSL inventories and replacement progress (IL, MI, NJ, OH, PA).

• NRDC Lead Pipe Analysis — State and city-level estimates, supplemental to EPA data.

  • URL: https://www.nrdc.org/resources/lead-pipes-are-widespread-and-used-every-state

Automation Pipeline

• Schedule: Weekly rebuild on Sundays. Daily check for new EPA enforcement actions and violations.
• Collect:
  1. Fetch SDWIS/ECHO bulk CSV downloads (updated quarterly by EPA) — water system details, violations, enforcement, lead/copper results
  2. Scrape EPA Service Line Inventory dashboard for latest LSL counts per water system (updated when EPA refreshes, currently ~annually)
  3. Pull DWSRF funding allocations from EPA published data
  4. Fetch Census ACS data for demographic overlay (annually)
  5. Monitor state portals for updated local inventories (monthly check)
• Process:
  1. Parse and normalize all data into a unified per-water-system record (ID, name, state, population served, LSLs reported, unknowns, non-lead, total lines, violations, enforcement actions, 90th percentile lead level, funding received)
  2. Calculate derived metrics: replacement rate, years-to-completion at current pace, LSLs per capita, grade assignment (A-F based on composite score of replacement progress, violation history, transparency, and lead levels)
  3. AI analysis: For top 200 water systems by LSL count, generate narrative report cards with context, comparison, and actionable consumer advice
  4. AI generates city-specific “what you should do” sections with localized filter recommendations and testing resources
• Generate:
  1. Choropleth maps (state-level, city-level) using D3.js/Mapbox — auto-rendered as static SVG/PNG
  2. Utility scorecard graphics — templated SVG with letter grades, key metrics, progress bars
  3. Comparison charts and trend lines
  4. Social sharing images — per-city “lead pipe count” cards optimized for Twitter/Facebook
• Publish:
  1. Static site builds with Astro + TypeScript
  2. Programmatic page generation: one page per water system (66,500+), one per state (50+), one per major city (500+)
  3. Deploy to Cloudflare Pages (free tier handles the scale)
  4. RSS feed for new report cards and violation alerts
  5. Newsletter generation via Buttondown or similar

Tech Stack

• Static site: Astro + TypeScript + Tailwind CSS
• Maps: D3.js + TopoJSON for choropleths, Mapbox GL JS for interactive city maps
• Charts: Observable Plot or Chart.js for trend visualizations
• Image generation: Satori (Vercel) for Open Graph images + scorecard PNGs from HTML/CSS templates, sharp for image processing
• Data collection: Node.js scripts with fetch + cheerio for scraping, Papa Parse for CSV
• Data storage: JSON files in repo (git-tracked for versioning), SQLite for local query during build
• CI/CD: GitHub Actions — weekly cron for full rebuild, daily for violation checks
• Hosting: Cloudflare Pages (free, handles 66K+ static pages easily)
• Search: Pagefind (client-side search, no server needed)

Monetization Model

Channel 1: Affiliate Revenue (Primary)

• Lead testing kits: Tap Score affiliate program (15% commission, 60-day cookie). Average test kit $100-$200 → $15-$30 per conversion. Embedded contextually in every city report card and “what to do” section.
• NSF-53 certified filters: Amazon Associates links to pitcher filters ($30), faucet-mount ($35), under-sink RO ($200-$500). 3-8% commission.
• Whole-house systems: Direct partnerships with Aquasana, SpringWell, etc. (higher commissions, 10-15%).
• Projected month-1: $200-500 (SEO hasn’t kicked in, initial traffic from social sharing)
• Projected month-6: $2,000-5,000/mo (programmatic SEO pages begin ranking for long-tail city-specific queries)

Channel 2: Newsletter Premium Tier

• Free tier: monthly national digest
• Premium ($5/mo): weekly hyperlocal alerts for your water system, violation notifications, replacement progress updates
• Projected month-6: 500 subscribers × $5 = $2,500/mo

Channel 3: Donations

• Ko-fi / GitHub Sponsors / Buy Me a Coffee
• Strong cause alignment (protecting kids from lead)
• Projected month-6: $300-500/mo

Channel 4: Sponsored Content (Month 6+)

• Water filter companies, home inspection services, real estate platforms
• Projected: $500-2,000/mo once traffic justifies it

Projected total month-1: $200-500 Projected total month-6: $5,000-10,000/mo

Growth Mechanics

SEO (Primary Growth Engine)

• Programmatic SEO: 66,500+ water system pages = 66,500+ long-tail keyword targets. “Lead pipes [city name]”, “water quality [zip code]”, “lead service line replacement [utility name]”. Each page is unique, data-driven, and regularly updated.
• Content freshness: Auto-updated pages signal freshness to Google.
• Topical authority: 500+ articles on a single topic (lead in water) builds massive domain authority.
• Featured snippets: Structured data (FAQ schema, HowTo schema) for common queries.

Social Sharing Hooks

• Shareable city scorecard graphics (“Chicago gets a D+ for lead pipes”)
• “How many lead pipes are in YOUR city?” interactive lookup
• Outrage fuel: “This city has 333,000 lead pipes and replaced 2,300 last year”
• Environmental justice angles: “The zip codes with the most lead pipes are also the poorest”

Community Building

• Subreddit partnerships: AMA posts in r/centuryhomes, r/HomeImprovement
• Local journalist sourcing: Every city page is a ready-made local news story
• Parent communities: Shareable safety guides for r/ScienceBasedParenting, Facebook groups

Newsletter Capture

• Free lead test reminder email sequence
• “Get notified when your city’s grade changes” opt-in
• Annual report cards emailed to subscribers

Channel Soul & Identity

Name: Lead Pipe Visual identity: Industrial-brutalist meets data journalism. Dark background, lead-gray (#6B6B6B) as primary accent, warning red (#CC0000) for critical scores, safety green (#00AA55) for good scores. Typography: bold condensed headlines (think newspaper front page), clean sans-serif body text. Mascot: A cracked lead pipe with eyes — grumpy, tired, honestly telling you it shouldn’t be there. Named “Leady.” Appears in the corner of scorecard graphics with speech bubbles like “I was installed in 1923 and I’m STILL here” or “They said they’d replace me. That was 12 years ago.” Voice: The frustrated investigative data journalist who has read 10,000 pages of EPA documents so you don’t have to. Not alarmist — factual, specific, and slightly angry. Cites exact numbers. Names names. Uses dark humor. Think “John Oliver meets data.gov.” Opinions: Takes a clear stance — every community deserves lead-free water, “unknown” is not an acceptable long-term classification, replacement pace matters more than inventory completeness, and environmental justice is not optional. Running traditions:

• Monday: “Lead of the Week” — spotlight on one water system’s progress (or lack thereof)
• Friday: “Pipe Dream” — highlight a city that’s actually making progress, celebrating what works
• Quarterly: “National Report Card” — full state-by-state rankings with grade changes
• “Leady Says” — recurring sidebar quotes from the mascot on each article Shareability: Every report card is designed to be screenshotted and shared. The letter grade + city name + “Lead Pipe” branding creates instant recognition.

Scores

Why This Will Work

Psychology: Lead in drinking water triggers the deepest parental protection instinct. “Is my child safe?” is the highest-urgency query a parent can have. A site that answers this with real government data, specific to THEIR city, with clear action steps — that’s a site people bookmark, share, and tell their friends about. And when the answer is “get a filter” or “test your water,” the affiliate conversion rate will be extraordinary because the recommendation comes with data-backed authority, not sales copy.

Market logic: 4 million homes with confirmed lead pipes. Tens of millions more with “unknown” status. The LCRI rule created a 10-year compliance window that guarantees this issue stays in the news cycle through 2037. Every time a city misses a deadline, every time a violation is issued, every time a child tests positive for elevated blood lead — Lead Pipe has a new data point and a new story. The topic doesn’t expire.

Competitive moat: Programmatic SEO with 66,500+ unique data-driven pages is extremely hard to replicate manually. The data pipeline, once built, generates content at a scale no traditional news outlet can match. And the auto-updating nature means freshness compounds over time.

Risk & Mitigation