2026-04-27 — "Have they all been deleted fully?" investigation
Jan's question on the blog archive Basecamp thread (in response to the Apr 27 follow-up about the 9 trashed posts).
Short answer
Trash: 9 posts. Recoverable with a one-line WP-CLI flip. Range 2023-08-31 → 2024-12-16.
Hard-deleted: ~38 additional posts. Not in wp_posts at any status. Captured by Wayback Machine, so content can be recreated from the archive but each one needs a manual paste/re-import — there's no "restore from trash" path for these.
Method
- Pulled all
wp_postsrows from production forpost_type = 'post', everypost_status(publish, trash, draft, pending, private, future). Result: 19 total (10 publish + 9 trash). Confirms the count Jan referenced. - Pulled the Wayback Machine CDX index for
californiaforever.com/*(45,048 captures, status 200), extracted all single-segment root paths, filtered out hub/landing pages and known sections. - Diffed the Wayback slug set against current DB slugs.
The site uses root-level permalinks (californiaforever.com/<slug>/), not /blog/<slug>/, which is why Wayback shows blog posts at the root.
Deleted blog posts (38)
Each link below points to a Wayback capture from 2024 — content is recoverable but not in our database.
https://web.archive.org/web/2024/https://californiaforever.com/annie-vogelpohl-california-forever-means-a-new-solano-county/
https://web.archive.org/web/2024/https://californiaforever.com/announcing-the-east-solano-homes-jobs-and-clean-energy-initiative/
https://web.archive.org/web/2024/https://californiaforever.com/announcing-the-recipients-of-500000-in-initial-community-funding-grants-for-solano-nonprofits/
https://web.archive.org/web/2024/https://californiaforever.com/archive-for-east-solano-homes-jobs-and-clean-energy-initiative/
https://web.archive.org/web/2024/https://californiaforever.com/as-part-of-its-partnership-with-northbay-health-california-forever-has-purchased-a-building-in-downtown-winters-for-a-new-primary-care-clinic-to-open-in-2025/
https://web.archive.org/web/2024/https://californiaforever.com/california-forever-and-artist-nick-stiles-unveil-new-murals-in-the-vista-theatre/
https://web.archive.org/web/2024/https://californiaforever.com/california-forever-ceo-speaks-on-a-panel-with-senator-dodd-supervisor-mashburn-and-steve-vancil/
https://web.archive.org/web/2024/https://californiaforever.com/california-forever-proposes-land-exchange-that-protects-travis-air-force-base-creates-a-15000-acre-contiguous-preserve-on-the-jepson-prairie-and-funds-completion-of-the-solano-county-habitat-conser/
https://web.archive.org/web/2024/https://californiaforever.com/california-forever-releases-new-images-of-proposed-community-in-solano-county/
https://web.archive.org/web/2024/https://californiaforever.com/california-forever-statement-ahead-of-solano-county-water-agency-meeting/
https://web.archive.org/web/2024/https://californiaforever.com/creating-jobs-in-solano-county/
https://web.archive.org/web/2024/https://californiaforever.com/david-cates-why-im-a-yes-on-california-forever/
https://web.archive.org/web/2024/https://californiaforever.com/economic-impact-report-finds-east-solano-plan-will-create-between-53036-and-86952-permanent-new-jobs-in-solano-county-by-2040/
https://web.archive.org/web/2024/https://californiaforever.com/gen-mike-minihan-ret-joins-california-forever-as-senior-advisor/
https://web.archive.org/web/2024/https://californiaforever.com/introducing-500000-in-initial-grants-for-solano-non-profits-copy/
https://web.archive.org/web/2024/https://californiaforever.com/joint-statement-by-solano-county-and-california-forever/
https://web.archive.org/web/2024/https://californiaforever.com/kqed-interview-with-our-ceo/
https://web.archive.org/web/2024/https://californiaforever.com/kqed-report-from-our-vallejo-town-hall/
https://web.archive.org/web/2024/https://californiaforever.com/michael-fortney-lets-create-tomorrow-together/
https://web.archive.org/web/2024/https://californiaforever.com/mike-genest-the-solano-county-gap/
https://web.archive.org/web/2024/https://californiaforever.com/more-than-20000-solano-voter-signatures-submitted-for-the-east-solano-homes-jobs-and-clean-energy-initiative-on-november-ballot/
https://web.archive.org/web/2024/https://californiaforever.com/northbay-health-announces-partnership-with-california-forever-to-accelerate-opening-of-six-to-ten-clinics-serving-solano-county-by-five-years-starting-with-rio-vista/
https://web.archive.org/web/2024/https://californiaforever.com/our-letter-to-solano-county-board-of-supervisors-county-administrator-and-director-of-resource-management-re-the-50m-deficit-and-prime-farmland-protection/
https://web.archive.org/web/2024/https://californiaforever.com/our-letter-to-solano-county-board-of-supervisors-county-administrator-and-director-of-resource-management-re-the-agricultural-mitigation-ordinance/
https://web.archive.org/web/2024/https://californiaforever.com/our-letter-to-the-solano-county-administrator-re-the-timeline-of-the-east-solano-plan/
https://web.archive.org/web/2024/https://californiaforever.com/our-letter-to-the-solano-county-board-of-supervisors-county-administrator-and-county-counsel/
https://web.archive.org/web/2024/https://californiaforever.com/our-letter-to-the-solano-county-board-of-supervisors-county-administrator-director-of-resource-management-and-bess-technical-working-group-re-the-bess-moratorium/
https://web.archive.org/web/2024/https://californiaforever.com/preliminary-results-from-resident-surveys/
https://web.archive.org/web/2024/https://californiaforever.com/seeking-community-input-on-design-of-community-benefits/
https://web.archive.org/web/2024/https://californiaforever.com/statement-on-misinformation-about-signature-gathering-in-solano-county/
https://web.archive.org/web/2024/https://californiaforever.com/statement-regarding-solano-county-water-agency-meeting/
https://web.archive.org/web/2024/https://californiaforever.com/statement-regarding-solano-land-trusts-opposition-to-east-solano-plan/
https://web.archive.org/web/2024/https://californiaforever.com/update-regarding-community-funding-grants/
https://web.archive.org/web/2024/https://californiaforever.com/updated-land-exchange-offer-public-agencies-can-choose-whether-to-make-closing-subject-to-voter-approval-or-not/
https://web.archive.org/web/2024/https://californiaforever.com/updating-format-of-our-town-halls-in-response-to-community-input/
https://web.archive.org/web/2024/https://californiaforever.com/we-revised-our-initiative-to-provide-additional-protections-for-travis-air-force-base/
https://web.archive.org/web/2024/https://californiaforever.com/welcoming-new-community-ambassadors/
https://web.archive.org/web/2024/https://californiaforever.com/year-in-review-new-website-and-moving-to-californiaforever-com/
Caveats on the 38
- A handful may have originally been WordPress pages, not posts (e.g.
creating-jobs-in-solano-county,urgency-of-shipbuilding). I filtered out the obvious hub/landing pages, but the diff is slug-based, not type-aware, so a few may not be true blog posts. Sanity-check with Jan before mass-importing. - One slug (
year-in-review-new-website-and-moving-to-californiaforever-com) suggests there was a domain/CMS migration at some point. That's likely when the bulk of these were dropped. - "Copy" suffix on
introducing-500000-in-initial-grants-for-solano-non-profits-copyimplies a duplicate WordPress made automatically — probably skip. - The Wayback CDX returns up to 50k captures; I pulled all of them, so the slug list is complete for what Wayback has indexed. If they ever had posts that never got crawled by Wayback, those would not appear here. (Unlikely — IA crawls actively, but possible for very short-lived posts.)
Recovery options if Jan wants any back
- Pick the ones he wants — give him the title list, ask which to bring back.
- Pull each from Wayback — fetch the captured HTML, extract title/body/date/featured image manually, recreate as a draft on production with
archivecategory, then publish. - Estimate: ~10–15 min per post for a clean restore (copy text, find image asset on Wayback, save attachment, set date to original publish date, tag
archive). 38 posts ≈ 6–10 hours of work if he wants the lot.
Files
/tmp/cf-deleted-blog-posts.txt— same list as above, raw/tmp/cf-cdx-big.json— raw Wayback CDX dump (45,048 captures)