Daily Delta: New Business Entities (CO, CT, OR)

You sell something every new company needs — business insurance, bookkeeping, payroll, a bank account, a website. The best moment to reach a founder is the fortnight after they file, while they are still choosing vendors and nothing is locked in. Miss that window and you are asking someone to switch rather than to start.

So you want yesterday’s filings, every morning, for the states you cover. Not a list someone resells you three weeks late.

The manual way, and what it costs

This data is genuinely open. Colorado, Connecticut and Oregon each publish their business-entity registry as a Socrata dataset, and you can filter and export from those portals yourself without paying anyone. If you work a single state, go and do exactly that — bookmark the dataset, sort by formation date, download the CSV. It costs nothing and this actor has little to offer you.

The cost appears when you cover more than one. Each state is a separate portal with its own column names: what Colorado calls the formation date field is not what Connecticut calls it, entity-type codes differ, and addresses are shaped differently in each. So “new companies this week across my territory” becomes three exports plus a normalisation script you now own and maintain — every morning, indefinitely.

The faster way

US Business Entity Search (Secretary of State) queries all three registries and returns the same columns from each.

{
  "mode": "export",
  "states": ["CO", "CT", "OR"],
  "entityTypes": ["LLC"],
  "statuses": ["Active"],
  "formedAfter": "2026-10-06",
  "maxResults": 100
}

formedAfter is what makes this a delta rather than a dump: only entities formed on or after that date come back. Set it to yesterday and schedule the run daily, and each run returns only what is new. Set it to the first of the month and you get the month so far. entityTypes and statuses use one list for every state, so “LLC” and “Active” mean the same thing in Colorado as in Oregon.

What comes back

{
  "state": "CT",
  "entity_id": "3545105",
  "entity_name": "Serve & Sip Cafe L.L.C.",
  "entity_type": "Limited Liability Company",
  "status": "Active",
  "formation_date": "2026-11-04",
  "principal_street": "61 E Industrial Rd",
  "principal_city": "Branford",
  "principal_zip": "06405-6509",
  "agent_name": "Brian Gallagher"
}

Field	Why it matters here
formation_date	How old the company is, to the day — the entire basis for a timed outreach window
entity_name	Who to address
entity_type	LLC, corporation, non-profit — filters out forms you do not sell to
status	Active (Good Standing in Colorado), or not
principal_street / _city / _zip	Territory routing, and a mailing address
agent_name	The registered agent — often a formation service, not the founder

The field that closes the loop is formation_date. Sort by it and the list is ordered by how warm the lead is.

What you’d do with it

Schedule it daily with formedAfter set to yesterday and push the rows into your CRM as new leads, keeping the formation date as a custom field. Route by principal_state to the right rep. Filter entity_type down to the forms you actually sell to — most B2B sellers want LLCs and corporations and little else.

Worth knowing

A few states, not fifty. This example runs Colorado, Connecticut and Oregon; New York works the same way (add "NY"), and more Secretary of State registries are being added one at a time. The actor’s States field lists exactly what is live.

A registered agent is not a founder. agent_name is frequently a formation service or a law firm shared by thousands of companies. Treat it as routing metadata, not a contact.

No phone numbers. State registries publish addresses, not business phones. Connecticut is the exception for email: it publishes a business email for most active companies (often a formation service’s address), returned as business_email.

Filing date is not opening date. A company can form months before it trades, or form to hold an asset and never trade at all.

---

Run it yourself: How to run US Business Entity Search walks the input field by field.

Looking for a name rather than a date range? Search Multi-State Business Entities by Name runs the same three registries by name substring. If the companies you care about are specifically contractors, Connecticut Contractor Directory & Leads Scraper returns the licensed-trade roster for one of the same states.