California Unclaimed Property Scraper

What does California Unclaimed Property Scraper do?

California Unclaimed Property Scraper searches the official weekly .CSV archives published by the California State Controller's Office. It is an unofficial structured-data API alternative for filtering public records by owner name, city, holder business, property ID, balance, and official value-range file.

The Actor searches public records only. It does not file claims, access claimant accounts, check claim status, bypass login controls, or determine who is legally entitled to property. It is not affiliated with or endorsed by the California State Controller's Office.

Why use California Unclaimed Property Scraper?

• Search real SCO weekly files rather than cached or fabricated samples.
• Browse one of five official ranges: $0–$9.99, $10–$99.99, $100–$499.99, $500+, or all records.
• Filter by reported owner, owner city, holder business, exact property ID, or cash balance.
• Extract rich fields covering cash, securities, owners, claims, holders, addresses, and CUSIP.
• Deduplicate with a stable propertyId + ownerName identity.
• Stream CSV parts from the downloaded ZIP and stop after the requested result or scan limit.
• Schedule searches and integrate datasets through Apify APIs, webhooks, and exports.

What data can California Unclaimed Property Scraper extract?

Field	Type	Description
propertyId	string	California public property identifier
propertyType	string	SCO/NAUPA property description
ownerName	string	Name as reported in the weekly file
currentCashBalance	number	Current public cash balance
cashReported	number	Originally reported cash
sharesReported	number	Reported securities quantity
securitiesName	string	Security name when available
holderName	string	Business that reported the property
pendingClaims	integer	Public pending-claim count
paidClaims	integer	Public paid-claim count
sourceFileUpdatedAt	string	Last-Modified time of the weekly ZIP

Unavailable optional cells are omitted instead of output as empty values.

How to search California unclaimed property

1. Open the Actor input tab.
2. Select an official value-range archive.
3. Enter an owner-name, city, holder, property-ID, or balance filter. Leave filters empty to browse the first records in the selected range.
4. Set a small maxResults and a realistic maxRowsScanned.
5. Ensure maxDownloadMbytes is above the current official file size.
6. Click Start and inspect the dataset.
7. Follow the official source link and California claim instructions if you believe a record belongs to you.

How much will it cost to search California unclaimed property?

Compute is normally modest, but official archives are large and data-transfer/storage usage can dominate cost. At the time of documentation, even the smallest $500+ archive exceeds 150 MB, while the all-records archive exceeds 3 GB. File sizes change weekly. Use one narrow range, strict scan limits, exact filters, and the default four-minute internal deadline. Check your Apify usage page for current plan pricing.

Input

See the input tab for full configuration options.

• valueRange: one official weekly ZIP.
• ownerName, city, holderName: case-insensitive substring filters.
• propertyId: exact public property ID.
• minCashBalance, maxCashBalance: inclusive numeric filters.
• maxResults: unique record limit.
• maxRowsScanned: CSV processing safety limit.
• maxRunMillis: Actor-side deadline below five minutes.
• maxDownloadMbytes: prevents accidentally downloading a larger-than-expected archive.

Output

You can download the dataset in various formats such as JSON, HTML, CSV, or Excel.

[
  {
    "recordId": "13755891:ADAMS GEORGE T",
    "propertyId": "13755891",
    "propertyType": "63: Non Standard NAUPA Code for - Endowments",
    "cashReported": 5675.28,
    "ownerName": "ADAMS GEORGE T",
    "ownerCity": "AGOURA",
    "ownerState": "CA",
    "currentCashBalance": 5675.28,
    "pendingClaims": 1,
    "paidClaims": 0,
    "holderName": "WEST COAST LIFE INSURANCE COMPANY",
    "valueRange": "500-plus",
    "sourceFileUrl": "https://claimit.ca.gov/upd-property-records/04_From_500_To_Beyond.zip"
  }
]

The example shows the live schema, but every run reads the current weekly file and values can change.

Tips and advanced options

• Start with $500+; it is usually the smallest archive.
• Exact property IDs produce deterministic filtering but the file still must be downloaded.
• A broad query may reach maxRowsScanned without a result. Narrow it or deliberately raise the limit while staying under five minutes.
• Never infer ownership solely from a name match. Use the official free claim process.

FAQ, disclaimers, and support

Is this an official SCO service?

No. It is an independent Actor that searches files the SCO makes public.

Can this Actor claim property?

No. Claims and identity verification must use official California channels.

Why did the run stop before scanning the whole file?

The archive size, row limit, download limit, and deadline protect predictable resource use. Increase only the specific limit you understand.

Our Actor is ethical and does not intentionally extract private user data. It extracts only information published in the SCO's public weekly records. Results contain personal data such as names and reported addresses. Personal data is protected by the GDPR in the European Union and by other regulations around the world. Do not scrape or use personal data unless you have a legitimate reason. If you are unsure whether your reason is legitimate, consult your lawyers.

Use the Actor's Issues tab for reproducible problems and the API tab for programmatic runs.