# UCC Filings Scraper – CO, CT & OR UCC-1 Lien Leads, $4/1k (`appetizing_horsefly/ucc-filings-feed`) Actor

Extract new UCC-1 financing statements from Colorado, Connecticut and Oregon open data. Get debtor name and address, secured party (lender), collateral, file number, filing and lapse dates. $0.004 per filing.

- **URL**: https://apify.com/appetizing_horsefly/ucc-filings-feed.md
- **Developed by:** [GM Labs](https://apify.com/appetizing_horsefly) (community)
- **Categories:** Lead generation, Business
- **Stats:** 2 total users, 1 monthly users, 100.0% runs succeeded, 0 bookmarks
- **User rating**: No ratings yet

## Pricing

$4.00 / 1,000 filings

This Actor is paid per event. You are not charged for the Apify platform usage, but only a fixed price for specific events.

Learn more: https://docs.apify.com/actors/running/actors-in-store.md#pay-per-event

## What's an Apify Actor?

An Actor is a serverless cloud program that runs on the Apify platform. It has two run modes.
In Batch mode, an Actor accepts a well-defined JSON input, performs an action which can take anything from a few seconds to a few hours,
and optionally produces a well-defined JSON output, datasets with results, or files in key-value store.
In Standby mode, an Actor provides a web server which can be used as a website, API, or an MCP server.

Apify vocabulary and the platform model are defined once, in the agent quickstart at https://apify.com/agents.md.

## How to integrate an Actor?

If asked about integration, you help developers integrate Actors into their projects.
You adapt to their stack and deliver integrations that are safe, well-documented, and production-ready.

Do not guess an integration path. Every one of them is in the agent quickstart at https://apify.com/agents.md: the Apify MCP server, Agent Skills with the Apify CLI, the JavaScript and Python clients, the REST API, and the account-free path for an agent with no human to sign in. It also carries the rule on stating cost before the first paid run.

For examples already wired to this Actor's own input schema, see the [API](#api) section below.

Each client library has reference documentation the quickstart does not restate: [JavaScript/TypeScript](https://docs.apify.com/api/client/js/docs.md) (`npm install apify-client`) and [Python](https://docs.apify.com/api/client/python/docs.md) (`pip install apify-client`).

# README

## UCC Filings Scraper – New UCC-1 Liens from Colorado, Connecticut & Oregon

### What is UCC Filings Scraper?

UCC Filings Scraper pulls **new UCC-1 financing statements** from the official Secretary of State open-data portals of Colorado, Connecticut and Oregon and returns them as one clean, normalized dataset. No login, no CAPTCHA, no browser. It is built for **MCA funders and ISOs, equipment lenders, factoring companies, commercial loan brokers and B2B sales teams** who want businesses that just took on financing.

### What data can I extract?

`state`, `fileNumber`, `filingType`, `transactionType`, `filingDate`, `lapseDate`, `status`, `debtorName`, `debtorCity`, `debtorState`, full `debtors[]` (name, business flag, address, city, state, zip), `securedPartyName`, full `securedParties[]` with addresses, `collateral` (CO) and `sourceUrl`.

### How much does it cost to scrape UCC filings?

Pay per result: **$0.004 per filing** ($4 per 1,000), no monthly rental and no start fee. The 20-filing prefilled run costs about $0.08, well inside Apify's free monthly credit.

### Why use it

- **Fresh leads:** filter by a *new since* date and pull only the filings made since your last run.
- **Normalized output:** one record per filing with a consistent schema across states. You don't need to learn each state's field names.
- **Business debtors only (default):** individual or consumer debtors are excluded.
- **Lender intelligence:** see which lenders are funding which businesses, and filter by secured party name (for example "capital" or "funding") to track competitor MCA activity.
- **Collateral text** (Colorado): find equipment financings such as forklifts, trucks or medical equipment.
- **No login and no CAPTCHA:** the data comes from the states' own public open-data APIs (data.colorado.gov, data.ct.gov, data.oregon.gov).

### Use cases

1. **MCA lead generation:** businesses with a recent UCC-1 from an MCA funder are proven buyers of working capital and good candidates for stacking or refinance offers.
2. **Equipment finance prospecting:** new equipment-lease UCCs show who is buying equipment now.
3. **Competitive intelligence:** track how many filings each lender makes per month, by state.
4. **Credit and risk monitoring:** check whether a client or prospect has new liens filed against it.
5. **CRM enrichment:** add lien activity to account records.

### Try it free in 1 click

The input form is **prefilled with a small, working example**. Press **Start** without changing anything: the run returns 20 new UCC-1 financing statements from CO, CT and OR. Our test run of exactly this input finished in about 17 seconds with 20 results. At $0.004 per filing that is about $0.08, which fits inside the free monthly credit of Apify's free plan. Then swap in your own values.

Prefilled input:

```json
{
  "states": [
    "CO",
    "CT",
    "OR"
  ],
  "maxResults": 20
}
```

### Sample output

Real rows from the prefilled run on 2026-10-14 (5 of 20 results shown; long fields trimmed). Download the full dataset as JSON, CSV or Excel.

| state | fileNumber | filingDate | debtorName | debtorCity | securedPartyName | lapseDate |
|---|---|---|---|---|---|---|
| CT | 0005414677 | 2026-10-12 | SAHARA INC | NEW BRITAIN | FIRST DATA MERCHANT SERVICES LLC | 2031-10-12 |
| CT | 0005414678 | 2026-10-12 | BEYOGLU LLC | CROMWELL | FIRST DATA MERCHANT SERVICES LLC | 2031-10-12 |
| OR | 94609500 | 2026-09-30 | ST. PHILBERT'S HAZELNUTS, LLC | HARRISBURG | CNH INDUSTRIAL CAPITAL AMERICA LLC | 2031-09-30 |
| CT | 0005414685 | 2026-10-12 | A & C Home Care LLC | Monroe | Corporation Service Company, as Representative | 2031-10-12 |
| CT | 0005414687 | 2026-10-12 | Gano's Power Equipment, LLC | Colchester | Huntington Distribution Finance, Inc. | 2031-10-12 |

### Input

| Field | Description | Default |
|---|---|---|
| `states` | `CO`, `CT`, `OR` | all |
| `sinceDate` | Only filings on or after this date (YYYY-MM-DD) | last 30 days |
| `initialFilingsOnly` | Only original UCC-1 filings (no amendments or continuations) | true |
| `businessDebtorsOnly` | Exclude filings where every debtor is an individual | true |
| `uccOnly` | Exclude tax, hospital, municipal and other statutory liens | true |
| `debtorNameContains` / `securedPartyContains` | Case-insensitive name filters | – |
| `maxResults` | Maximum number of results (0 = unlimited) | 100 |

### Example output

```json
{
  "state": "CO",
  "fileNumber": "20262100428",
  "filingType": "UCC financing statement",
  "transactionType": "Initial Filing",
  "filingDate": "2026-10-07",
  "lapseDate": "2031-10-07",
  "status": "active",
  "debtorName": "Richlawn Turf Food LLC",
  "debtorCity": "PLATTEVILLE",
  "debtorState": "CO",
  "securedPartyName": "Farm Credit Leasing Services Corporation",
  "debtors": [{"name": "Richlawn Turf Food LLC", "isBusiness": true, "address": "15121 COUNTY ROAD 32", "city": "PLATTEVILLE", "state": "CO", "zip": "80651"}],
  "securedParties": [{"name": "Farm Credit Leasing Services Corporation", "address": "1665 Utica Ave S, Suite 400", "city": "Minneapolis", "state": "MN", "zip": "55416"}],
  "collateral": "Two (2) TOYOTA Forklifts ...",
  "sourceUrl": "https://data.colorado.gov/d/wffy-3uut"
}
```

### Typical volume

For September 2026 (business debtors, initial UCC-1 only), the Actor returned about 3,500 filings for Colorado, 1,950 for Connecticut and 1,400 for Oregon.

### Data notes

- **Colorado:** filings, debtors, secured parties and collateral datasets, updated regularly by the CO Secretary of State.
- **Connecticut:** the active-lien dataset, updated nightly. It includes active (unlapsed) liens only and has no collateral text.
- **Oregon:** the "UCC List of Filings Entered Last Month" dataset holds only the **previous calendar month**, so schedule monthly runs to build history. Each record links to the filing image.
- The data is public record as published by each state. It is not a consumer report and must not be used for FCRA-regulated purposes.

### Scheduling tip

Run the Actor daily or weekly with `sinceDate` set to your last run date, then send the results to Google Sheets, your CRM or a webhook through Apify integrations.

**Keywords:** UCC filings, UCC-1 scraper, UCC lien search, MCA leads, merchant cash advance leads, equipment finance leads, secured party search, Secretary of State UCC data, Colorado UCC, Connecticut UCC, Oregon UCC.

### Use it as an MCP tool (Claude, Cursor, ChatGPT, any AI agent)

This Actor works as a tool in the [Apify MCP server](https://mcp.apify.com), so an AI agent can call it directly and you pay per result, the same as a normal run. Add this server URL to any MCP client:

```
https://mcp.apify.com/?tools=appetizing_horsefly/ucc-filings-feed
```

Sign in with your Apify account (or pass your Apify API token as a Bearer header). The agent reads the input fields above from the Actor's input schema. Example request to the agent: "Find new UCC-1 filings in Colorado since last Monday where the secured party is an equipment lender."

# Actor input Schema

## `states` (type: `array`):

Secretary of State UCC sources to pull.

## `sinceDate` (type: `string`):

Only filings dated on/after this date. Empty = last 30 days.

## `initialFilingsOnly` (type: `boolean`):

Skip amendments, continuations, terminations and releases.

## `businessDebtorsOnly` (type: `boolean`):

Exclude filings whose debtors are all individuals.

## `uccOnly` (type: `boolean`):

Exclude tax/hospital/other liens (CO and CT also carry these).

## `debtorNameContains` (type: `string`):

Optional case-insensitive filter.

## `securedPartyContains` (type: `string`):

Optional, e.g. a competitor lender.

## `maxResults` (type: `integer`):

Maximum number of filings to return across all states. 0 means no limit. You are charged per filing returned, so set a cap to control cost. Default 100 keeps a first try cheap; set 0 for no cap.

## Actor input object example

```json
{
  "states": [
    "CO",
    "CT",
    "OR"
  ],
  "initialFilingsOnly": true,
  "businessDebtorsOnly": true,
  "uccOnly": true,
  "maxResults": 20
}
```

# Actor output Schema

## `results` (type: `string`):

All results in the default dataset

# API

You can run this Actor programmatically using our API. Below are code examples in JavaScript, Python, and CLI, as well as the OpenAPI specification and MCP server setup.

## JavaScript example

```javascript
import { ApifyClient } from 'apify-client';

// Initialize the ApifyClient with your Apify API token
// Replace the '<YOUR_API_TOKEN>' with your token
const client = new ApifyClient({
    token: '<YOUR_API_TOKEN>',
});

// Prepare Actor input
const input = {
    "states": [
        "CO",
        "CT",
        "OR"
    ],
    "sinceDate": "",
    "maxResults": 20
};

// Run the Actor and wait for it to finish
const run = await client.actor("appetizing_horsefly/ucc-filings-feed").call(input);

// Fetch and print Actor results from the run's dataset (if any)
console.log('Results from dataset');
console.log(`💾 Check your data here: https://console.apify.com/storage/datasets/${run.defaultDatasetId}`);
const { items } = await client.dataset(run.defaultDatasetId).listItems();
items.forEach((item) => {
    console.dir(item);
});

// 📚 Want to learn more 📖? Go to → https://docs.apify.com/api/client/js/docs

```

## Python example

```python
from apify_client import ApifyClient

# Initialize the ApifyClient with your Apify API token
# Replace '<YOUR_API_TOKEN>' with your token.
client = ApifyClient("<YOUR_API_TOKEN>")

# Prepare the Actor input
run_input = {
    "states": [
        "CO",
        "CT",
        "OR",
    ],
    "sinceDate": "",
    "maxResults": 20,
}

# Run the Actor and wait for it to finish
run = client.actor("appetizing_horsefly/ucc-filings-feed").call(run_input=run_input)

# Fetch and print Actor results from the run's dataset (if there are any)
print(f"💾 Check your data here: https://console.apify.com/storage/datasets/{run.default_dataset_id}")
for item in client.dataset(run.default_dataset_id).iterate_items():
    print(item)

# 📚 Want to learn more 📖? Go to → https://docs.apify.com/api/client/python/docs/quick-start

```

## CLI example

```bash
echo '{
  "states": [
    "CO",
    "CT",
    "OR"
  ],
  "sinceDate": "",
  "maxResults": 20
}' |
apify call appetizing_horsefly/ucc-filings-feed --silent --output-dataset

```

## MCP server setup

```json
{
    "mcpServers": {
        "apify": {
            "type": "http",
            "url": "https://mcp.apify.com/?tools=fetch-actor-details,appetizing_horsefly/ucc-filings-feed"
        }
    }
}
```

The hosted server signs you in with OAuth on first connect, so no API token belongs in this config. Clients without OAuth support can send an `Authorization: Bearer <APIFY_API_TOKEN>` header instead, using a token from API & Integrations in Apify Console (https://console.apify.com/settings/integrations).

## OpenAPI specification

Download the OpenAPI definition: https://api.apify.com/v2/actors/FYNJ0MSdaJIfUffti/builds/mwGmkVJgcgWCgj2YZ/openapi.json