Filter the file
Sort by county, deadline, published amount and evidence grade. Deadlines run 2026-10-23 to 2027-06-08; 28 fall inside 90 days of this build, 2 inside 30.
Stop rebuilding county lists one website at a time. 121 excess-proceeds records from 9 California counties, normalized into one schema, every row citing the county document it came from and where inside it the row sits.
*$2,060,025.74 — the exact sum of county-published amounts on grades A and C. The 12 grade D rows carry $1,771,698.00 of estimated spread, which is an arithmetic difference between two published figures, not a balance, and is excluded. Not a statement that any amount remains claimable.
The county remains the authority. Evidence grades show what the source supports — and which rows still need checking.
The product organizes public-source research. It does not replace your diligence and it does not promise a recoverable claim.
Sort by county, deadline, published amount and evidence grade. Deadlines run 2026-10-23 to 2027-06-08; 28 fall inside 90 days of this build, 2 inside 30.
Every row carries a source URL, a page or row locator, and a verification label saying how far the check got — so a check takes about a minute, not a scavenger hunt.
Recheck current funds, deed recordation, eligibility and the applicable deadline with the county or qualified counsel. The grade tells you what still needs checking.
Not “unclaimed money.” Not a claim service. The honest description is duller and more useful: this is the collection-and-normalization step of excess-proceeds research, done once per cycle, with the evidence left attached.
9 counties publish in 9 different shapes — scanned PDFs, legal notices with interleaved columns, Word documents, HTML tables. Rebuilding them into one table by hand is roughly one to two analyst days per cycle, and it is the same work every cycle. Here it arrives as 21 columns you can sort.
A scraped spreadsheet cannot be defended. Each row here carries the document title, the page or row locator, the source URL and the result of the live re-check — so a memo or a claim file can cite the county document rather than your own transcription.
Deadlines run 2026-10-23 to 2027-06-08, and the file is sorted by them. 2 fall inside 30 days of this build and 28 inside 90, so review time goes to what closes first instead of what looks largest on a spreadsheet.
121 of 121 rows carry a verification_warning stating exactly
what is weaker about them, and 12 rows are labelled estimates rather than balances.
That is what lets you promise a client what the evidence supports — and what makes the
refund offer credible rather than risky.
A refresh replaces this file with a new dated snapshot. Same 21 columns, same grades, same verification labels — so the filter, the merge and the review checklist you build around it keep working instead of being rebuilt alongside the data.
| Rebuilding it yourself | This file | |
|---|---|---|
| County sources to open | 9, in 9 formats | Already read and preserved |
| Records to normalize | 121 by hand | 121, 21 columns |
| Evidence per row | Whatever you remembered to save | Locator + source URL + verification label |
| Deadline logic | Manual, easy to mix auction and deed dates | Anchor date stored, day count computed in your browser |
| What it costs | 1–2 analyst days per cycle | $79 once |
The analyst-day figure is an estimate from this build’s own experience of the work, not a measured study. The rest is arithmetic you can check against the file.
These are all 10 rows of the free sample. Two are unredacted, so you can check them against the county source before you buy. The other 8 have masked APNs but keep their county and amounts.
| County | APN | Grade | Amount | Deadline | Days left | Deadline basis | Source check |
|---|---|---|---|---|---|---|---|
| Colusa | 005-320-***-*** | B | not published | 2026-10-23 | … | County-stated | Masked APN |
| Sonoma | 019-620-***-*** | D | 623,300.00 est. | 2026-11-19 | … | 1 yr from recorder date | Masked APN |
| Sonoma | 137-350-***-*** | D | 508,000.00 est. | 2026-11-19 | … | 1 yr from recorder date | Masked APN |
| Nevada | 002-450-***-*** | B | not published | 2026-12-19 | … | County-stated | Masked APN |
| Tulare | 093-083-***-*** | C | 51,465.68 | 2027-03-03 | … | 1 yr from sale date | Masked APN |
| San Joaquin | 027-134-***-*** | C | 394,583.34 | 2027-03-12 | … | 1 yr from sale date | Masked APN |
| Shasta | 018-380-***-*** | B | not published | 2027-03-20 | … | 1 yr from printed deed date | Masked APN |
| Del Norte | 110-221-025-000 | A | 47,157.89 | 2027-05-27 | … | 1 yr from printed deed date | Unredacted — check it |
| Humboldt | 016-232-***-*** | C | 112,106.44 | 2027-05-29 | … | 1 yr from sale date | Masked APN |
| Madera | 001-172-010-000 | A | 209,448.36 | 2027-06-08 | … | County-stated | Unredacted — check it |
“Days left” is computed in your browser on every load. The CSV stores deadlines as dates and anchors, never as a precomputed day count, so nothing in the file goes stale in your hands. Blank amounts mean the county does not publish one for that parcel.
Use the grade to decide how much additional verification a row needs. A grade is not a prediction that a claim succeeds.
| Grade | Rows | Evidence standard | Practical interpretation |
|---|---|---|---|
| A | 28 | County-published amount, and a deadline anchored to a date the county printed — 19 state the filing deadline outright, 9 count the statutory year from a deed date the county printed | Strongest documented starting point; confirm current status |
| B | 39 | Source located and deadline anchored to a printed county date; the county publishes no amount | Amount may need a separate county inquiry |
| C | 42 | County-published amount; deadline calculated one year from the sale date because the county publishes no recording date | Verify deed recording and the deadline basis |
| D | 12 | Estimated amount (published sale price minus published minimum bid); deadline derived from a recorder-confirmed deed date | Lead only, not a balance; further research required |
The document title, the source URL, a page or row locator, a live_check
result and a verification_status label. The preserved copies and their
SHA-256 digests stay in the compiler's internal master file, not in the sold CSV, and
are available on request for any row.
64 of 121 rows were found again on a live fetch, including 9 of the 28 grade A rows. 42 sit on county sites that return 403 to automated clients, though the same links open normally in a desktop browser; 3 point at a URL that now returns 404; and 12 come from a county that publishes no excess-proceeds list, so their amounts are sale-price estimates. The row says which, always. A blank re-check date is not a claim that the row is wrong.
verification_warning. Grade C deadlines are earlier than the statutory date,
never later, but they are arithmetic. Published amounts can go stale. Verify deed
recordation, current funds, eligibility and the applicable deadline before acting.
Best suited to independent researchers and recovery professionals who can run their own follow-up verification.
Instant download after purchase.
Checkout and delivery through Gumroad.
Refunds: if an A, B or C row's APN, amount or deadline does not match its cited county document, email the address in the footer within 7 days with the row and the county page and the purchase is refunded in full.
Use terms: single organization, internal research use. No resale or redistribution. Follow California law and each county's requirements when contacting anyone about funds — no harassment or misleading contact.
No. It is the sum of the amounts the counties published, on grade A and C rows only. It does not establish current availability, and it excludes the 12 grade D estimates entirely.
Because they publish it separately, in 9 different formats — scanned PDFs, legal notices with interleaved columns, Word documents, HTML tables — and never together. The value is the union, the schema and the deadline sort, not the individual documents. If you need one county, take the free sample and go straight to that county's site.
Open the row's source_url, find the APN at the cited
source_locator, and compare the amount and deadline on the page with the
row. live_check and verification_status say how far our own
re-check got. If an A, B or C row does not match its cited document, email within 7 days
and the purchase is refunded in full.
No. 19 grade A rows quote a deadline the county stated.
9 grade A rows and 23 grade B rows rest on a deed date the
county printed but did not label as a filing deadline; all 42 grade C rows use the
sale date; the 12 grade D rows use a recorder-confirmed recording date. Every such
row says so in verification_warning and carries its anchor in
deadline_anchor_date.
Yes, on 2026-10-19. 64 of 121 rows were found again on a live fetch, including 9 of the 28 grade A rows. 42 sit on county sites that return 403 to automated clients, though the same links open normally in a desktop browser; 3 point at a URL that now returns 404; and 12 come from a county that publishes no excess-proceeds list, so their amounts are sale-price estimates. Each row states its own result.
No. No addresses, phone numbers or emails — party is only the name the
county printed. No title search, lien priority, heirship or probate research.
A snapshot built 2026-10-19 from county-published documents. 2 deadlines fall inside 30 days of this build, and 28 inside 90.
The build date in the README tells you which version you hold. Deadlines are stored as
dates, never as day counts, so sorting by claim_deadline will not mislead you.
One organization, internal research use. No resale, redistribution or publication. The county documents remain the counties' property and subject to their terms.
Chuck Terrell, LogicFlow Systems and Solutions. Questions and refunds: mrt@logicflowsystems.io.
121 structured records across 9 California counties, $79 once.