UCC Lien & Filing Scraper — CT, CO, NY, OR — Feed or Debtor Lookup

Reach a business the week it borrows money, leases equipment, or takes a merchant cash advance — not months later.

Built from official state UCC-1 financing-statement and lien registries (Connecticut, Colorado, New York, Oregon): every newly filed UCC-1 is the public paper trail of the exact day a business closed a financing deal. This Actor pulls the filing, classifies the lender, and enriches the debtor with stacking history, business-registry age, and — where the debtor looks like a trucking or medical business — a direct phone and email from a federal registry.

Two modes, one record shape:

• Feed — everything filed in the last N days, for lead generation.
• Lookup — give it a list of debtor business names and it returns every filing those businesses appear on, across each registry's whole archive. For KYB, credit underwriting, and diligence.

State coverage

State	Source	What it covers	Refresh
CT	Secretary of the State UCC lien filings	Statewide UCC-1 originals	Daily
CO	Secretary of State UCC + IRS federal tax liens	Statewide UCC-1 originals, with collateral text	Daily
NY	NYC Register (ACRIS) personal-property records	UCC-1s and federal liens recorded in the five boroughs, with collateral code and borough	~Monthly
NY	NYS Dept of Taxation and Finance tax warrants	Business tax liens statewide, with the dollar amount owed	Daily
OR	Secretary of State UCC filings	UCC-1 originals entered in the rolling last month	Monthly

Read this before relying on NY. New York does not publish its Article 9 central index at the Department of State — there is no bulk file and no API. NY here means the two official feeds that are public: UCC-1s recorded with the New York City Register (Manhattan, Bronx, Brooklyn, Queens, Staten Island — not upstate), and NYS tax warrants against businesses statewide. ACRIS is republished in monthly batches, so a daysBack of 1–7 will usually reach NY tax warrants but not NYC UCC-1s; use daysBack: 45 or more to pick up both. The run log always prints the date the ACRIS data currently runs through.

---

Pain points

• A UCC-1 filing tells you a business just financed something, but the state registry portal is a one-filing-at-a-time web form with no bulk export and no way to tell an equipment lease from a tax lien from a merchant cash advance without reading the secured party's name yourself.
• List brokers sell "just financed" leads at $0.20–$0.75 per lead (aged lists $0.05–$0.50), with none of the underwriting context — you don't know if this is their first financing or their sixth stacked position.
• MCA and equipment funders deliberately file under a filing agent's name (e.g. "C T Corporation System, as representative") specifically to hide their book from competitors and lead brokers — a raw filing feed just shows you an opaque name with no way to tell it's actually an MCA advance in disguise.
• No registry publishes a debtor phone number, so a "leads" list assembled from filings alone is a list of names, not a call list.

What we solve

• Same-day financing signal. Every record is an original UCC-1 (not a renewal or amendment) — a genuinely new financing event, sourced directly from the state's own daily open-data feed.
• Lender classification, decoded automatically. leadType reads the secured party's name and buckets it into equipmentFinancing, mcaOrAltLender, confidentialRep (the disguised-MCA filing-agent pattern), bankOrSba, taxLien, or other — so you can target MCA consolidation prospects or equipment-refi buyers without reading a single filing yourself.
• Debtor-name lookup, not just a feed. Set mode: "lookup" and pass up to 25 business names; you get every filing on record for those debtors, oldest to newest, in the same shape as the feed. Entity suffixes are handled for you — "Acme Logistics LLC" also finds "ACME LOGISTICS, LLC" and "ACME LOGISTICS INC". Repeat lookups of the same business always return in full; the run-to-run dedupe that keeps a scheduled feed cheap is deliberately off in lookup mode.
• Amount owed, where the registry publishes it. NYS tax warrants carry the exact dollar figure filed against the business — the fastest way to sort a tax-lien list by how much trouble the debtor is actually in.
• Stacking intelligence. For CT, CO and NY, every debtor's prior filing count, prior lender list, and last prior filing date come straight from the registry archive. isStacked = true (2+ priors) is the single hottest MCA-consolidation signal — live-verified at 46–48% of fresh debtors.
• Business-registry enrichment. For CO, NY and OR, a same-name join against the state business registry adds formation date, business age, entity status, and the registered agent's name — a real person to ask for.
• Direct phone/email where a registry can legally provide one. Debtors that look like trucking companies are matched against the FMCSA motor-carrier census (100% phone fill on matches, live-verified); medical-looking debtors can optionally be matched against the NPI Registry. No skip-traced or scraped contact data — every field shipped here is itself a public record.
• You are billed once per filing, per run — never twice. The actor dedupes internally by filing ID before it ever normalizes or pushes a record, so a filing can't be double-charged even if it's touched by more than one enrichment pass in the same run.

Who buys this

• MCA / alt-lending sales teams targeting mcaOrAltLender and confidentialRep leads, filtered by isStacked for consolidation prospects.
• Equipment finance & leasing companies targeting equipmentFinancing leads, sorted by priorFilingsCount for proven borrowers ready to refinance.
• Tax-resolution firms targeting taxLien leads — CT municipal/state liens, CO business IRS federal tax liens, and NYS tax warrants with the dollar amount owed.
• KYB, credit and diligence teams running mode: "lookup" against a portfolio or an applicant list to see every lien and financing statement filed against those businesses.
• B2B sellers into trucking or medical practices that want a financing-event trigger paired with a real phone number.

Input

Feed mode — a daily MCA-prospect feed:

{
  "mode": "feed",
  "states": ["CT", "CO", "NY"],
  "daysBack": 7,
  "leadTypes": ["mcaOrAltLender", "confidentialRep"],
  "enrichStacking": true,
  "enrichRegistry": true,
  "enrichTrucking": true
}

Lookup mode — everything on file against three businesses:

{
  "mode": "lookup",
  "states": ["CT", "CO", "NY", "OR"],
  "debtorNames": [
    "Acme Logistics LLC",
    "Constitution Surgery Center East",
    "2065 Creston LLC"
  ],
  "matchMode": "startsWith"
}

Field	Type	Default	Notes
mode	string	feed	feed = everything filed in the last N days. lookup = every filing for the businesses in debtorNames.
debtorNames	array	—	Up to 25 business names. Required in lookup mode, ignored in feed mode.
matchMode	string	startsWith	startsWith tolerates entity suffixes and is recommended; exact matches the registry name character for character.
states	array	["CT","CO","NY","OR"]	Which state registries to scan.
daysBack	integer	7	Feed mode only — 1–365. Small = fresh daily feed; large = aged-lead archive sweep. Use 45+ to include NYC UCC-1s. Ignored in lookup mode, which searches the whole archive.
leadTypes	array	[] (all)	Restrict to lender types, e.g. ["mcaOrAltLender","confidentialRep"].
debtorKeyword	string	—	Debtor name must contain this (e.g. TRUCKING).
enrichStacking	boolean	true	Prior filings + prior lenders + isStacked (CT, CO, NY).
enrichRegistry	boolean	true	Business age, status, registered agent (CO, NY, OR).
enrichTrucking	boolean	true	FMCSA phone/email/fleet for trucking-looking debtors.
fmcsaMatchAll	boolean	false	Attempt an FMCSA match on every debtor, not just trucking-looking names (slower).
enrichMedical	boolean	false	NPI Registry phone/specialty for medical-looking debtors.
maxItems	integer	—	Hard cap on records pushed. You are billed per record pushed, so this bounds your cost.
onlyNewSinceLastRun	boolean	true	Scheduled runs only return (and charge for) filings not seen before. Forced off in lookup mode so a repeat lookup always answers in full.
webhookUrl	string	—	Optional — the result batch is POSTed here as JSON on finish.
syncEnabled	boolean	false	Optional. Also send each new lead to a connected app — see Sync below.
syncDestination, syncWriteTool, syncFieldMap, syncExtraArgs	—	—	Only used when syncEnabled is on.

Output

One record per debtor, one row per original filing. This is a real record pulled from a local run of the actor — not a placeholder:

{
  "filingId": "CT-0005400253-BLADIMIR LLC",
  "filingState": "CT",
  "filingNumber": "0005400253",
  "filingDate": "2026-08-05",
  "lapseDate": "2031-08-05",
  "filingType": "ORIG FIN STMT",
  "leadType": "bankOrSba",
  "debtorName": "BLADIMIR LLC",
  "debtorStreet": "212 College Street",
  "debtorCity": "New Haven",
  "debtorState": "CT",
  "debtorZip": "06510",
  "securedParty": "WebBank, its successors and assignees",
  "securedPartyLocation": "Salt Lake City, UT",
  "collateral": null,
  "priorFilingsCount": 8,
  "priorLenders": "WebBank, its successors and assignees | COLLECTOR OF TAXES | U.S. SMALL BUSINESS ADMINISTRATION",
  "lastPriorFilingDate": "2026-02-03",
  "isStacked": true,
  "businessFormedDate": null,
  "businessAgeYears": null,
  "entityStatus": null,
  "entityType": null,
  "registeredAgent": null,
  "truckingMatch": false,
  "dotNumber": null,
  "fleetSize": null,
  "drivers": null,
  "phone": null,
  "email": null,
  "phoneSource": null,
  "medicalMatch": false,
  "npiNumber": null,
  "specialty": null,
  "saferUrl": null,
  "filingImageUrl": null,
  "source": "Connecticut Secretary of the State"
}

This particular debtor is a stacked MCA-consolidation prospect (8 prior filings) rather than a trucking or registry match, so those enrichment fields are null — that's expected, not missing data. See the field table below for when each field populates.

Field	Description
filingId	Stable unique ID for the filing (state + filing number + debtor name).
filingState	Two-letter registry state (CT, CO, NY, OR).
filingNumber	The state's own filing number.
filingDate	Date the filing was accepted (ISO).
lapseDate	Date the filing lapses under state law (ISO), when published.
filingType	Filing type as recorded by the registry (originals only — no renewals/amendments).
leadType	Decoded lender category: equipmentFinancing, mcaOrAltLender, confidentialRep, bankOrSba, taxLien, other.
debtorName	Legal name of the business that financed.
debtorStreet / debtorCity / debtorState / debtorZip	Debtor's address of record.
securedParty	Name of the lender/funder as filed.
securedPartyLocation	Lender's city/state, when published.
collateral	Collateral description (CO, ~80% fill) or ACRIS collateral class (NY — e.g. Fixture filing, Cooperative), truncated to 500 characters.
filedAmount	Dollar amount filed against the debtor, when the registry publishes one (NYS tax warrants; NYC filings that record an amount).
debtorCounty	County, or NYC borough, of record (NY).
priorFilingsCount	Count of this debtor's prior UCC filings (CT, CO, NY).
priorLenders	Up to 3 prior secured-party names, pipe-separated.
lastPriorFilingDate	Date of the debtor's most recent prior filing (ISO).
isStacked	true when priorFilingsCount >= 2 — the MCA-stacking signal.
businessFormedDate	Business formation date from the state business registry (CO, NY, OR).
businessAgeYears	Years between formation and this filing.
entityStatus / entityType	Business registry status and entity type (CO, NY, OR).
registeredAgent	Registered agent's name on file — a real person to ask for.
truckingMatch	true when the debtor matched the FMCSA motor-carrier census.
dotNumber	USDOT number on an FMCSA match.
fleetSize	Power-unit count on an FMCSA match.
drivers	Driver count on an FMCSA match.
phone	Business phone, sourced from FMCSA or NPI Registry only.
email	Business email, sourced from FMCSA only.
phoneSource	FMCSA or NPI Registry — which registry supplied phone.
medicalMatch	true when the debtor matched the NPI Registry (enrichMedical only).
npiNumber	NPI number on a medical match.
specialty	NPI taxonomy/specialty on a medical match.
saferUrl	Link to the debtor's public FMCSA SAFER snapshot, when matched.
filingImageUrl	Link to the scanned filing image, when the registry publishes one.
source	Which office the filing came from — e.g. Colorado Secretary of State, New York City Register (ACRIS), NYS Department of Taxation and Finance.

Sync to your CRM, Notion, HubSpot, Airtable or Supabase (optional)

Turn on syncEnabled to also send each new lead straight to a connected app — free, with no extra charge. Connect the app under Integrations in Apify Console, pick it as syncDestination, and set syncWriteTool to the name of the tool that creates one record there (run the dataset-sync-connector Actor in list-tools mode against the same connector if you don't know the name). A sync failure is logged as a warning and never blocks the dataset — your leads always land here first regardless of what the destination does.

Pricing (Pay-Per-Event)

Event	Price
query (per run)	$0.01
ucc-lead (per record)	$0.005
Sync to a connected app (optional)	Free

500 classified, stacking-scored, registry-enriched filings ≈ $2.51. Sync to a connected app never triggers a billable event — it's an added convenience on top of the dataset you already paid for.

Notes & compliance

• Source: official state UCC-1 registries (Connecticut, Colorado, Oregon), plus the FMCSA motor-carrier census and NPI Registry for trucking/medical phone enrichment — all public records.
• Phone/email ship only when sourced from FMCSA or NPI Registry. No scraped or skip-traced contact data anywhere in the pipeline.
• You are responsible for TCPA / DNC compliance when calling numbers from phone.

Run frequency

Schedule it daily with daysBack: 1–7 and onlyNewSinceLastRun: true for a fresh feed. For archive-building, run once with daysBack: 90–365.

FAQ

How am I charged?

Pay-per-lead. Each run charges one query event, then one ucc-lead event per debtor record actually pushed to the dataset. The actor dedupes internally by filing ID before normalizing, so a single filing is never charged twice in the same run, and onlyNewSinceLastRun (on by default) keeps scheduled runs from recharging filings you've already seen.

Where does the data come from?

Official state UCC-1 financing-statement registries — Connecticut Secretary of the State, Colorado Secretary of State, and Oregon Secretary of State — published as open data. Phone/email enrichment comes only from the FMCSA motor-carrier census and the NPI Registry, both federal public registries. Nothing here is scraped or skip-traced.

How fresh is it?

CT and CO publish daily; OR publishes a rolling monthly batch. Run on a daily schedule with daysBack: 1–7 to catch each state's new filings the day they post.

Which actor do I want if I need something adjacent?

For newly formed Texas businesses (not financing events), see texas-new-business-leads. For newly registered motor carriers nationwide with guaranteed phone fill, see fmcsa-new-carrier-leads. Why only CT, CO and OR here? They're the only states currently publishing their complete UCC stream as machine-readable open data — more will be added as states publish.