🏛 Connecticut Business Registry Scraper

🚀 Export Connecticut business entities in seconds. Name, account number, status, standing, entity type, registration date, business and mailing address and principals for entities in the official Connecticut business registry, with no account and no API key.

The Connecticut Secretary of the State publishes its business registry as open data on data.ct.gov, refreshed daily. This Actor queries that official dataset by entity name, account number or principal name and returns one flat row per entity, with the principals attached when you ask for details.

Because it reads the open data API and not a web form, it is fast and does not depend on a browser or a captcha.

🎯 Target Audience	💡 Primary Use Cases
Sales and lead generation teams	Find registered Connecticut companies and keep only the active ones
Lawyers and paralegals	Check entity type, standing and listed principals before a transaction
Banks, KYC and compliance teams	Confirm a counterparty exists and is in good standing
Journalists and researchers	See which principals are listed on a Connecticut company
Insurance and credit teams	Verify business details before underwriting
Data teams	Seed or refresh a company table for Connecticut

📋 What the Connecticut Business Registry Scraper does

💡 Why it matters: a company name alone proves nothing. The registry shows whether the entity exists, what kind it is, how it stands, and who is listed as a principal.

• Reads the official Connecticut business registry open dataset on data.ct.gov.
• Three search types: entity name, account number and principal name.
• Returns status, standing, entity type, registration date and the state of formation.
• Business address and mailing address, parsed into street, city, state and zip.
• Optional detail pass adds the principals with their title and business address.
• Registered agents are not part of the open data and are not returned.
• Writes an unbilled error row when the registry returns nothing or fails.

🎬 Full Demo (🚧 Coming soon)

📊 Output

Every row is one Connecticut business entity. Registered agent, FEI/EIN and filing documents are not in the Connecticut open data and are not returned.

Field	Type	Description
🏢 corporateName	string	Legal name of the entity as the registry prints it
🧾 corporationType	string	Entity type, for example corporation or LLC
🔢 documentNumber	string	Connecticut business account number
📅 dateFiled	string	Registration date, YYYY-MM-DD
📍 state	string	State or jurisdiction of formation
🚦 status	string	Registry status of the entity
✅ standing	string	Sub-status published by the registry, for example Active or Good Standing
📝 lastEvent	string	Reason for the administrative status, when the registry gives one
📬 principalAddress	object	Principal office address: street, city, state, zip
📮 mailingAddress	object	Mailing address: street, city, state, zip
👥 officers	array	Principals listed in the registry: title, name and business address
🔗 detailUrl	string	Link to the entity record in the state open data portal
🕒 scrapedAt	string	ISO 8601 timestamp of the extraction
❌ error	string	Error message on a failed row, null on a real record

Real records from a run:

[
  {
    "corporateName": "PRATTE, LLC",
    "corporationType": "LLC",
    "documentNumber": "1296085",
    "dateFiled": "2019-01-15",
    "state": "CT",
    "status": "Active",
    "standing": "Annual report past due",
    "lastEvent": "",
    "principalAddress": {
      "street": "50 BEACH ROAD",
      "city": "WOLCOTT",
      "state": "CT",
      "zip": "06716"
    },
    "mailingAddress": {
      "street": "50 BEACH ROAD",
      "city": "WOLCOTT",
      "state": "CT",
      "zip": "06716"
    },
    "officers": [
      {
        "title": "",
        "name": "EDWARD CLEARY",
        "address": "50 BEACH ROAD, WOLCOTT, CT, 06716"
      }
    ],
    "detailUrl": "https://data.ct.gov/resource/n7gp-d28j.json?id=001t000000WoKlnAAF",
    "scrapedAt": "2026-10-23T21:59:06.998Z",
    "error": null
  },
  {
    "corporateName": "Pratt Equity Holdings LLC",
    "corporationType": "LLC",
    "documentNumber": "3265156",
    "dateFiled": "2025-07-30",
    "state": "Connecticut",
    "status": "Active",
    "standing": "Annual report past due",
    "lastEvent": "",
    "principalAddress": {
      "street": "183 Wilson St Ste 426",
      "city": "Brooklyn",
      "state": "NY",
      "zip": "11211"
    },
    "mailingAddress": {
      "street": "183 Wilson St Ste 426",
      "city": "Brooklyn",
      "state": "NY",
      "zip": "11211"
    },
    "officers": [
      {
        "title": "",
        "name": "Israel Braver",
        "address": ""
      },
      {
        "title": "",
        "name": "Shloime Iliovits",
        "address": ""
      }
    ],
    "detailUrl": "https://data.ct.gov/resource/n7gp-d28j.json?id=001eq00000hG7McAAK",
    "scrapedAt": "2026-10-23T21:59:07.069Z",
    "error": null
  },
  {
    "corporateName": "PRATT HOPEWELL, LLC",
    "corporationType": "LLC",
    "documentNumber": "1168902",
    "dateFiled": "2015-02-23",
    "state": "CT",
    "status": "Active",
    "standing": "Annual report past due",
    "lastEvent": "",
    "principalAddress": {
      "street": "300 HEBRON AVENUE, SUITE 203",
      "city": "GLASTONBURY",
      "state": "CT",
      "zip": "06033"
    },
    "mailingAddress": {
      "street": "300 HEBRON AVENUE SUITE 203",
      "city": "",
      "state": "GLASTONBURY",
      "zip": "UNITED STATES"
    },
    "officers": [
      {
        "title": "",
        "name": "KRISTINE SCHLICHTING",
        "address": "300 HEBRON AVENUE, SUITE 203, GLASTONBURY, CT, 06033"
      }
    ],
    "detailUrl": "https://data.ct.gov/resource/n7gp-d28j.json?id=001t000000WnwM9AAJ",
    "scrapedAt": "2026-10-23T21:59:07.316Z",
    "error": null
  }
]

✨ Why choose this Actor

• Official open data. Rows come from data.ct.gov, the state own portal, not from a resold list.
• Search by principal. Find the entities where a named principal is listed.
• Fast. A JSON API, no browser and no captcha.
• Standing included. Status and sub-status on every row.
• Honest limits. No registered agent in the source, and the README says so.
• Clean tables. Fixed column order, ready for CSV, Excel, JSON or XML.

📈 How it compares to alternatives

	This Actor	Multi-state registry scrapers	Manual lookups
Connecticut official source	✅ data.ct.gov	Sometimes	✅
Search by name, ID and principal	✅	Name only	✅ one at a time
Status and standing	✅	Sometimes	✅ one at a time
Principals on the row	✅ with details	Rare	✅ one at a time
Registered agent	❌ not in open data	Varies	✅ on the web form
Bulk export to CSV, Excel, JSON	✅	✅	❌

🚀 How to use

1. Create a free Apify account. New accounts get $5 in free credit: sign up here.
2. Open the Connecticut Business Registry Scraper and click Try for free.
3. Choose the search type, then type the entity name (or part of it), the account number or the name of a principal.
4. Set the maximum number of businesses you want.
5. Keep Include full details on if you need the principals, or turn it off for a faster list.
6. Click Start and watch the run log.
7. When the run finishes, open the Storage tab and download CSV, Excel, JSON or XML, or pull the same rows through the Apify API.

💼 Business use cases

Lead generation

Search a company name and keep only active entities so your list has no dissolved companies.

Counterparty checks

Confirm a Connecticut company exists, its type and its standing before you sign.

Due diligence

Search a person name as a principal to find the entities where that person is listed.

Data enrichment

Match your own company list to the registry by name or account number.

🔌 Automating Connecticut Business Registry Scraper

• Make and Zapier: run the Actor on a schedule and push new entities into a CRM or a spreadsheet.
• Slack: post an alert when a watched business changes status.
• Airbyte: sync the dataset into a warehouse and join it to your own customer data.
• GitHub Actions: run weekly and commit the CSV so a status history builds itself.
• Google Drive: drop each export into a shared folder for the compliance team.
• Apify Scheduler: run daily, weekly or hourly with no external tooling at all.

🌟 Beyond business use cases

• Research: study formation trends and entity types in Connecticut.
• Journalism: check who stands behind a company named in a story.
• Personal: confirm that a contractor or a landlord is registered and in good standing.
• Non-profit: verify the legal status of partner organizations.

🤖 Ask an AI assistant about this scraper

Paste this into ChatGPT, Claude or any assistant:

I am using the Connecticut Business Registry Scraper on Apify. It returns fields such as corporateName, documentNumber, status, standing, dateFiled and officers. Help me design a workflow that checks a list of Connecticut supplier names against the registry and flags the ones that are not active.

❓ Frequently Asked Questions

🔎 Which searches does it support?

Entity name, account number and principal name.

🌐 Which source does it read?

The Connecticut business registry open dataset on data.ct.gov, published by the Secretary of the State and refreshed daily.

🧑‍💼 Does it return the registered agent?

No. The open data does not include registered agents.

👥 What are the officers?

The principals the registry lists for the entity, with title and business address when published. Residence addresses are not returned.

📅 What date format is used?

YYYY-MM-DD.

🔑 Do I need an account or API key for the registry?

No. The Actor reads the public Connecticut registry. There is nothing to sign up for and no key to paste.

🧾 Is this personal data?

The Actor returns business entity records as the registry publishes them: legal name, ID, status, addresses of the business and its registered agent. It does not look anyone up elsewhere and adds nothing to what the registry prints. Use the data in line with the privacy and marketing laws that apply to you.

📦 How many records can I export?

As many as the registry returns for the search, up to 1,000,000 on a paid plan. Free accounts are limited to 10 records per run.

🔀 Can the same entity appear twice?

Not within one run for searches that list entities. Rows are deduplicated on the registry identifier where the registry lists several rows per entity.

🌐 Do I need a proxy?

The default is Apify Proxy with a United States exit, which is enough in most cases. If the registry refuses it, the Actor retries from a residential US exit on its own.

🛑 What happens when the registry does not answer?

The Actor writes one error row that says what went wrong and does not charge for it. A run that finds nothing says so on a row instead of finishing silently empty.

💰 What am I charged for?

One result per business record delivered. Error rows and empty searches are not charged. The price per result is on the Pricing tab of the Actor page.

📤 Which formats can I export?

CSV, Excel, JSON and XML from the Storage tab, or through the Apify API.

🔌 Integrate with any app

Every run writes to an Apify dataset you can read over the REST API, stream into a webhook, or export as CSV, Excel, JSON or XML. Apify's integrations cover Make, Zapier, Airbyte, Slack, Google Drive, GitHub, Google Sheets and plain HTTP webhooks, so the rows land wherever your team already works.

🔗 Recommended Actors

• Sunbiz Florida Scraper for Florida business entities.
• Texas SOS Business Scraper for Texas business entities.
• Delaware Business Search Scraper for Delaware entities, where many corporations are incorporated.
• NY Business Entity Scraper for New York entities.

💡 Pro Tip: browse the complete ParseForge collection.

🆘 Need Help? Open our contact form

⚠️ Disclaimer: This is an independent tool and is not affiliated with, endorsed by, or connected to the Connecticut Secretary of the State. It collects only publicly available data.