New UCC Filings: Colorado & Connecticut

Every new UCC-1 financing statement filed against a business in Colorado and Connecticut, in one table, read straight from each Secretary of State's official open-data portal: who borrowed or leased, where they are, which lender or lessor filed, and when the filing lapses. Filter by lender or debtor location, schedule it daily with tracking to get only new filings, or look up every filing against a business by name.

A 7-day window across both states is roughly 350 to 450 filings.

What you get for each filing

Field	Meaning
state, filingNumber	The filing state and its filing number
filingDate, lapseDate	When it was filed (Connecticut: accepted) and when it lapses unless continued (normally five years later)
status	ACTIVE, LAPSED (lapse date passed), TERMINATED (Colorado termination on file, checked in lookups), RELEASED or OTHER (Connecticut's own status)
debtors	Every business debtor: name, organization type and jurisdiction where Colorado gives them, address
individualDebtorsWithheld	How many private persons were also debtors on this filing (not named)
securedParties	The lenders, lessors or their filing agents: name and address. A secured party who is a private person is shown without a name
documentType	The state's document type
sourceRecordUrl	The exact record on the state's open-data portal
changeStatus, firstSeen	With tracking: FIRST_RUN, NEW or SEEN, and when this filing was first returned to you

Two ways to use it

• New filings. A date window (the last 7 days by default) with optional filters: lender keywords (for example bank, capital, Caterpillar), lenders to leave out (for example as representative, which drops filing-agent placeholders such as Corporation Service Company), debtor states, cities or ZIP prefixes. With tracking and "only filings not seen before", a daily run returns each filing once.
• Lien lookup. Paste business names: every UCC-1 against a business whose name contains the text, of any date, active only unless you include lapsed and ended filings.

What is left out, and counted

• Hospital, IRS, state revenue, municipal, judgment, labor, vessel, aircraft and agricultural liens. They are not commercial financing, and hospital liens concern patients.
• Filings whose debtors are all private persons (consumer and farm-family filings). In a filing with both, the business debtors are listed and the people are only counted.
• Amendments, continuations and terminations are not listed as separate rows; a Colorado termination shows as TERMINATED on the original filing in lookups.

The run summary counts what was left out, per state, together with the rows your filters removed, filings per day and the most frequent secured parties.

How current it is

The portals are refreshed every day and trail the filings by about one to two days. The run summary shows each portal's last refresh and the newest filing date it has published, and the status message says when a state has not caught up with the end of your window. A portal not refreshed for more than 7 days is reported as failed instead of being returned as if it were current.

Things to know

• Many filings name a filing agent "as representative" instead of the lender itself; use the lender filters to keep or drop them.
• Collateral descriptions are not published in a usable form (Colorado mostly "See attached", Connecticut none) and are not included.

Data

Public-domain datasets from the Colorado Secretary of State and the Connecticut Secretary of the State, read through each portal's public API. No login, no scraping of search pages, and one request per second per portal as the portals ask.