Plug Ugly
America’s abandoned oil wells are leaking methane and money. We count the wells, track the plugs, and name who left the mess behind.
Channel: Plug Ugly Tagline: America’s abandoned oil wells are leaking methane and money. We count the wells, track the plugs, and name who left the mess behind. Niche: Consumer-facing orphaned oil & gas well accountability — automated state and county scorecards, plugging-progress trackers, taxpayer-spending dashboards, methane-risk explainers, property-adjacent well maps, and weekly data-journalism dispatches translating USGS, DOI, DOE, EPA, and state regulator data into gorgeous, opinionated public-interest reporting. Target audience: Rural landowners, people buying property in oil-and-gas states, local journalists, climate-concerned readers, environmental justice advocates, county officials, watchdog nonprofits, and ordinary taxpayers who keep hearing that billions are being spent to plug wells but have no idea where the money went. Core geography: Pennsylvania, West Virginia, Ohio, Texas, Oklahoma, Colorado, New Mexico, California, and Wyoming. This is especially sticky for readers who search questions like “abandoned oil wells near me,” “is there an orphan well on my land,” or “how many unplugged wells are in my county?” Why now: The timing is viciously good. The Department of the Interior’s orphaned wells program is a $4.7 billion federal accountability story, not a niche academic curiosity. USGS now distributes a structured national dataset covering 117,600+ documented unplugged orphaned wells, which means a real public tracker is finally automatable at scale. DOI announced states would begin plugging 10,000+ wells under Bipartisan Infrastructure Law funding, so the public now has a scoreboard to watch. Meanwhile, the audience signal is there: local Reddit discussions in Pennsylvania and West Virginia keep surfacing concern about methane leaks and property risk; Hacker News discussions on abandoned-well methane and AI-assisted well discovery reached 75 and 232 points respectively — proof that this topic triggers both civic outrage and technical curiosity. The gap is obvious: there are government PDFs, industry blog posts, and one-off investigations, but no memorable, consumer-grade site that answers the simple question: How many abandoned wells are near me, who is paying to fix them, and is my state actually making progress?
Content Example:
🛢️ Plug Ugly Dispatch #12 — April 8, 2026
Pennsylvania Plugged 1,146 Wells. It Still Has a Ghost Problem.
Pennsylvania wants credit for progress, and to be fair, it earned some. Since the federal orphan-well money started flowing, the state has accelerated plugging work and moved more aggressively than it did during the era of eternal pilot projects and ceremonial shovels. But here’s the less flattering version: even after this recent burst of plugging, Pennsylvania is still sitting on one of the ugliest abandoned-well legacies in America — thousands of documented orphan and abandoned wells, plus a much larger shadow inventory that probably hasn’t been mapped at all.
Our tracker counted 1,146 publicly reported plug jobs tied to recent state and federal updates, but the state’s progress score only moved from F to D+. Why so harsh? Because plugging a thousand wells sounds heroic until you compare it with the scale of the mess. In counties with long drilling histories, the backlog behaves like a bathtub with the drain barely open. The public hears “millions awarded” and imagines closure. The data says “partial triage.”
The methane story is worse. Abandoned wells don’t politely retire. Many continue leaking methane and volatile compounds for decades, often in places where nobody is routinely monitoring them. That means the true public-health burden falls on whoever happens to live nearby: the family on rural acreage, the town next to an old field, the school built long after the original operator disappeared. In our EJ overlay, some of the densest clusters of documented unplugged wells sit near communities that already score high on cumulative environmental burden. Translation: the same people who got the least upside from drilling often inherit the longest tail of risk.
Today’s ugly numbers:
- Documented unplugged orphan wells in Pennsylvania: 8,000+ in the current merged tracker
- Counties with the heaviest backlog: McKean, Venango, Washington, Greene, and adjacent historic production zones
- Federal + state dollars committed: substantial enough to matter, still nowhere near enough to declare victory
- Plug velocity: improving, but not yet fast enough to outrun discovery, backlog reconciliation, and the cost inflation that comes with deep or complex wells
And here’s the part the government dashboards don’t tell you clearly enough: plugging isn’t just climate policy. It’s land restoration, property-risk reduction, groundwater protection, and taxpayer cleanup of private-sector leftovers. Every orphan well is a tiny bankruptcy fossil — a hole in the ground where profits were privatized and liabilities were socialized.
Plug Ugly’s view is simple: if your state wants applause, it can earn it in public. Show the well list. Show the cost per plug. Show the counties still waiting. Show whether vulnerable communities are getting cleaned up first or last. Until then, the report card stays mean.
Data Sources:
- USGS Documented Unplugged Orphaned Oil and Gas Well Dataset — Core national well inventory with coordinates and metadata. Free, structured, machine-readable. https://data.usgs.gov/datacatalog/data/USGS:62ebd67bd34eacf539724c56
- DOE NETL Orphaned Wells Feature Service — Queryable ArcGIS endpoint for mapping and enrichment workflows. https://arcgis.netl.doe.gov/server/rest/services/Hosted/Orphaned_Wells_v2/FeatureServer
- DOI Orphaned Wells Program reports + press releases — Grant allocations, wells plugged, state updates, annual progress narratives. https://doi.gov/orphanedwells
- EPA EJScreen API — Environmental justice overlays for demographics and cumulative burden near orphan-well clusters. https://www.epa.gov/ejscreen/ejscreen-api
- EPA GHGRP datasets — Petroleum/natural-gas emissions context and regional methane framing. https://www.epa.gov/ghgreporting/data-sets
- State regulator datasets — Texas RRC orphan well lists, Ohio ODNR orphan-status layers, Colorado ECMC reports, Pennsylvania DEP updates, Oklahoma and New Mexico program reports.
- RFF / National Academies / USGS studies — Cost-per-plug estimates, leakage risk context, methodology for explaining why some wells are much uglier than others.
Automation Pipeline:
- Schedule: Daily for data refreshes, weekly for narrative dispatches, monthly for state score recalculation and leaderboard updates.
- Collect: GitHub Actions pulls the USGS dataset, queries DOE’s feature service, scrapes DOI press releases and annual reports for newly plugged-well counts and grant allocations, and syncs selected state regulator sources.
- Process: AI deduplicates wells across sources, normalizes state/county/operator fields, geocodes county and tract joins, overlays EJScreen indicators, and calculates a Plug Ugly Score for each state and county: backlog size × plug velocity × dollars spent × proximity burden × transparency quality.
- Generate: AI writes weekly dispatches, county pages, “what changed this week” summaries, and plain-English explainers (“What is an orphan well?”, “Can one be on my land?”, “Why plugging costs vary so much”). Graphic generation produces choropleth maps, county mini-cards, velocity charts, backlog countdowns, and “taxpayer bill vs. progress” graphics.
- Publish: Astro build generates static pages for every state, county, and major well cluster, then deploys automatically to GitHub Pages or Cloudflare Pages.
Tech Stack:
- Static site: TypeScript + Astro
- Mapping: MapLibre GL + PMTiles for lightweight, fast, static-friendly maps
- Image generation: Server-rendered SVG/PNG charts via D3 + Satori/resvg; optional AI editorial art for weekly dispatch headers
- Data collection: Node.js + fetch + CSV/GeoJSON ETL scripts
- Spatial analysis: DuckDB + GeoParquet / Turf.js for tract and county joins
- Search: Pagefind for static full-text search
- CI/CD: GitHub Actions on cron
- Hosting: Cloudflare Pages or GitHub Pages
Monetization Model:
- Channel 1: Donations / Membership — This is classic watchdog-journalism territory. Readers donate because the work feels public-serving and morally clean. Buy Me a Coffee, Ko-fi, GitHub Sponsors.
- Channel 2: Premium local alerts — $5-9/mo for county watchlists, “new wells discovered/plugs reported near me,” state program updates, and custom property-radius alerts.
- Channel 3: Research-grade exports — paid CSV/PDF county dossiers for journalists, NGOs, environmental lawyers, land buyers, and local civic groups.
- Channel 4: Ethical sponsors — air-quality sensor brands, land due-diligence tools, remediation tech firms, and environmental consulting services. Clearly labeled and kept far away from editorial scoring.
- Projected month-1 revenue: $150-400 (donations + a few premium local-alert subscribers)
- Projected month-6 revenue: $2,500-7,000 (memberships + local alert subscriptions + report sales + light sponsorship)
Launch Complexity: 4/5 — The data exists, which is the hard part, but the joins are messy. State data quality varies wildly. The opportunity is huge precisely because the raw material is bureaucratic and unpleasant. MVP in ~3 weeks if the first release focuses on national/state pages before county/property-radius features.
Content Quality Score: 5/5 — This is not “climate content.” This is land, health, public spending, and local accountability. The sample excerpt reads like real journalism because the topic naturally supports real journalism.
Automation Score: 4/5 — The core is very automatable, especially USGS + DOE + DOI. The slight hit comes from messy state-level sources and occasional PDF extraction for funding/progress updates.
Revenue Potential: 4/5 — This is not mass-market entertainment, but it has strong donor logic, excellent local-search SEO, civic virality, and a premium alert layer with genuine utility.
Total: 17/20
Why This Will Work: People care about abandoned wells for three reasons, and all three convert: fear, anger, and proximity. Fear: “Is this leaking near me?” Anger: “Why are taxpayers cleaning up private profits?” Proximity: “How bad is my county?” That is a beautiful audience triangle. Business-wise, the SEO moat is real because government sources are unusable for ordinary people, and local pages can rank for thousands of county/state/near-me queries. Design-wise, maps and scorecards make the site bingeable. Editorially, the site has a strong stance: this is not inevitable decay; it is an accountability ledger. The best part? Once the pipeline exists, the same template can expand into adjacent graveyard-infrastructure niches: abandoned mines, idle coal ash ponds, unplugged injection wells, or brownfield cleanup trackers.
Risk & Mitigation:
- Risk: State data is inconsistent and incomplete. Mitigation: be radically transparent about methodology and confidence levels. Publish “known gaps” on every state page.
- Risk: The true number of abandoned wells is much larger than the documented count. Mitigation: make that uncertainty a feature, not a bug. Track the documented universe while educating readers about the shadow inventory.
- Risk: Legal pressure from industry or political actors. Mitigation: every score is grounded in public data and published methodology. This is accountability journalism with receipts.
- Risk: Topic feels too grim. Mitigation: lean into a distinctive voice, sharp design, satisfying progress trackers, and the catharsis of watching real plugs happen in public.
🎭 Channel Soul
Name: Plug Ugly — because the cleanup story is ugly, the politics are ugly, and the abandoned hardware itself is ugly. Lean into it.
Mascot: Plugsy, a rusty wellhead wearing an apology tie and still somehow leaking from three different bolts. Plugsy is tired of hearing the phrase “legacy issue.”
Voice: A furious rural auditor with design taste. Half investigative reporter, half cartographer, half taxpayer with a long memory. Dry humor. Zero patience for bureaucratic euphemisms like “site closure activity.” If a state plugs 900 wells after inheriting 9,000, Plug Ugly says: “congratulations on discovering fractions.”
Opinion: Orphan wells are not quirky relics of energy history. They are a bill. A methane source. A land-value problem. A public-health burden. A governance test. The site is openly pro-cleanup, pro-transparency, and anti-amnesia.
Running jokes & traditions:
- “Congratulations on the fraction” — used when officials brag about progress that is numerically tiny relative to backlog
- The Ghost Count — a live tally of documented unplugged wells still on the books
- Plug of the Week — celebrating a real cleanup win with absurdly dramatic graphics
- The Apology Tie Index — a ranking of press-release language vs. actual progress
- County Shame / County Redemption — recurring leaderboard slots for worst backlog and fastest improvement
Visual style: Burnt orange, crude-oil black, warning-label cream, and a sour methane green. Maps are elegant. Cards feel like field reports. Icons borrow from surveying, drilling, and inspection tags. The design says “serious public-interest reporting,” but the attitude says “we brought receipts and a grudge.”