# Connecticut Secretary of State Business Search Scraper (`crawlerbros/connecticut-sos-business-search-scraper`) Actor Search Connecticut's official business registry by entity name, Business ID, city, or NAICS code. Get entity type, status, formation date, mailing/records address, and diversity-ownership flags. - **URL**: https://apify.com/crawlerbros/connecticut-sos-business-search-scraper.md - **Developed by:** [Crawler Bros](https://apify.com/crawlerbros) (community) - **Categories:** Automation, Developer tools, Integrations - **Stats:** 2 total users, 1 monthly users, 100.0% runs succeeded, 0 bookmarks - **User rating**: No ratings yet ## Pricing from $3.00 / 1,000 results This Actor is paid per event and usage. You are charged both the fixed price for specific events and for Apify platform usage. Since this Actor supports Apify Store discounts, the price gets lower the higher subscription plan you have. Learn more: https://docs.apify.com/platform/actors/running/actors-in-store#pay-per-event ## What's an Apify Actor? Actors are a software tools running on the Apify platform, for all kinds of web data extraction and automation use cases. 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. Actors are written with capital "A". ## 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. The best way to integrate Actors is as follows. In JavaScript/TypeScript projects, use official [JavaScript/TypeScript client](https://docs.apify.com/api/client/js/docs.md): ```bash npm install apify-client ``` In Python projects, use official [Python client library](https://docs.apify.com/api/client/python/docs.md): ```bash pip install apify-client ``` In shell scripts, use [Apify CLI](https://docs.apify.com/cli/docs.md): ````bash # MacOS / Linux curl -fsSL https://apify.com/install-cli.sh | bash # Windows irm https://apify.com/install-cli.ps1 | iex ```bash In AI frameworks, you might use the [Apify MCP server](https://docs.apify.com/integrations/mcp.md). If your project is in a different language, use the [REST API](https://docs.apify.com/api/v2.md). For usage examples, see the [API](#api) section below. For more details, see Apify documentation as [Markdown index](https://docs.apify.com/llms.txt) and [Markdown full-text](https://docs.apify.com/llms-full.txt). # README ## Connecticut Secretary of State Business Search Scraper Search **Connecticut's official business registry**, published by the Connecticut Secretary of State on the state's own open-data portal (`data.ct.gov`). Look up a business by entity name, exact Business ID (account number), business city, or NAICS industry code, and get entity type, status, formation date, mailing/records address, NAICS classification, and diversity-ownership flags. HTTP-only via Connecticut's public open-data API — no login required. ### Data Source & Usage Notes **Read this before running a large job.** - **No login, no API key, no CAPTCHA.** The source is Connecticut's public Socrata open-data API (`data.ct.gov/resource/n7gp-d28j.json`, "Connecticut Business Registry - Business Master"), the same underlying Secretary of State record set that powers the interactive `Business.CT.Gov` online search. - **Why the open-data API instead of `Business.CT.Gov` directly?** The interactive site is a JS-rendered Salesforce Experience Cloud portal with no documented public search API to call directly. Connecticut's own Secretary of State publishes the identical business registry, updated regularly, on the state's official open-data portal — this actor queries that official mirror directly. - **No named registered agent.** Unlike most other states, Connecticut's registry model does not carry a named registered-agent field — only a "Keeper of Records" address (exposed here as `recordsAddress`). There is no separate agent name to return. - **Sentinel dates are filtered.** A small number of malformed/rejected filings carry a `0001-01-01` placeholder registration date in the source data; this actor treats that sentinel as "no date on file" rather than emitting a nonsensical date. - **Conservative by design.** The actor only ever uses Apify's free datacenter (AUTO) proxy group — never a paid residential proxy — to get a fresh IP if a request is ever blocked. - **Not affiliated with the State of Connecticut.** This is an independent third-party tool using the Secretary of State's own public, no-login open-data API. #### Why Connecticut's open-data API instead of the interactive search site? This actor was originally scoped as an Arizona Corporation Commission (`arizonabusinesscenter.azcc.gov`) business search. Live verification showed Arizona's public business-search API (`api-azbusinessconnectonline.azcc.gov`) requires a valid Google reCAPTCHA token on every search request server-side — confirmed by direct API calls returning `"reCAPTCHA token is missing"` on the actual search endpoint used by the site's own UI, with no captcha-free lookup axis available (an ID-lookup endpoint exists but requires an internal database ID only obtainable from a captcha-gated search). This is a genuine CAPTCHA-solving requirement, which this project's zero-cost/no-forbidden-dependency policy prohibits working around. Per the same policy, the target was replaced with Connecticut's Secretary of State business registry, published as free public open data with no CAPTCHA, no login, and no rate-limit challenge of any kind — confirmed live and returning real, current data. ### What this actor does - **4 search modes**: - `byEntityName` — business entity name (substring match) - `byAccountNumber` — exact Connecticut Business ID (account number) - `byCity` — business (mailing) address city (exact match) - `byNaicsCode` — NAICS industry classification code - **Entity status filter** — 25 status values (`Active`, `Dissolved`, `Revoked`, `Forfeited`, etc.) - **Entity type filter** — 22 business type values (LLC, Stock, Non-Stock, Limited Partnership, LLP, Statutory Trust, etc.) - **Domestic/foreign filter** — restrict to entities formed in Connecticut vs. elsewhere - **Diversity-ownership flags** — woman-owned, veteran-owned, minority-owned, disability-owned, LGBTQI-owned, when on file - **Administrative dissolution/forfeiture reason** — the reason on file for dissolved/forfeited entities - **Geocoded coordinates** — latitude/longitude of the mailing address, when available - **Formation-jurisdiction detail** — formation country, organization-meeting date, and (for foreign entities) the name registered in the home jurisdiction plus the date the entity began transacting business in Connecticut - **Total authorized shares** — for stock corporations, when on file - **Automatic pagination** up to `maxItems` - **Empty fields are omitted** ### What's NOT included (and why) - **Registered agent name** — Connecticut's registry model carries only a Keeper-of-Records address, not a named agent; see "Data Source & Usage Notes" above. - **Individual officer/director names** — not present in the open-data extract. - **Filing history / document list** — not present in the open-data extract. ### Output per entity - `entityName` - `entityId` — Connecticut Business ID (account number) - `recordId` — internal registry record ID - `entityType` — e.g. `LLC`, `Stock`, `Non-Stock` - `status`, `subStatus` — e.g. `Active`, `Annual report due` - `administrativeDissolutionReason` — reason on file when an entity was administratively dissolved/forfeited (e.g. "Failure to appoint or maintain an agent for service"), when on file - `citizenship` — `Domestic` or `Foreign` - `jurisdictionOfFormation` — formation state/territory - `formationCountry` — country of formation (almost always US, but includes Canada, UK, India, Cayman Islands, etc. for true foreign entities), when on file - `formationDate`, `organizationMeetingDate`, `beganTransactingInCtDate`, `annualReportDueDate`, `dissolutionDate` — `YYYY-MM-DD`, when on file - `nameInFormationJurisdiction` — the entity's registered name in its home jurisdiction, when it differs from `entityName` (foreign entities), when on file - `mailingAddress` — the entity's mailing address on file - `recordsAddress` — the Keeper-of-Records ("Business Address") on file - `formationJurisdictionAddress` — the entity's registered address in its home (formation) state/country, for foreign entities, when on file - `latitude`, `longitude` — geocoded coordinates of the mailing address on file, when available - `naicsCode`, `naicsDescription`, `naicsSubCode` — when on file - `businessEmail`, `surveyEmail` — email addresses on file (business email and a separate survey-provided email) - `totalAuthorizedShares` — for stock corporations, when a positive value is on file - `womanOwned`, `veteranOwned`, `minorityOwned`, `disabilityOwned`, `lgbtqiOwned` — boolean, when on file - `sourceUrl` — link to this entity's record on Connecticut's open-data API - `recordType: "entity"`, `scrapedAt` ### Input | Field | Type | Default | Description | |---|---|---|---| | `mode` | string | `byEntityName` | One of the 4 search modes | | `entityName` | string | `WALMART` | mode=byEntityName | | `entityId` | string | – | mode=byAccountNumber | | `businessCity` | string | – | mode=byCity | | `naicsCode` | string | – | mode=byNaicsCode | | `entityStatus` | string | any | Optional status filter | | `entityType` | string | any | Optional entity type filter | | `citizenship` | string | any | Optional domestic/foreign filter | | `proxyConfiguration` | object | AUTO proxy | Apify proxy config; always datacenter (AUTO), never residential | | `maxItems` | int | `25` | Hard cap (1–1000) | #### Example: search by entity name ```json { "mode": "byEntityName", "entityName": "GOOGLE", "maxItems": 10 } ```` #### Example: lookup by exact Business ID ```json { "mode": "byAccountNumber", "entityId": "0818011" } ``` #### Example: browse by city and status ```json { "mode": "byCity", "businessCity": "Hartford", "entityStatus": "Active", "entityType": "LLC", "maxItems": 50 } ``` #### Example: search by NAICS industry code ```json { "mode": "byNaicsCode", "naicsCode": "522320", "maxItems": 25 } ``` ### Use cases - **Due diligence** — confirm a counterparty's Connecticut formation date, entity type, and status before contracting - **Compliance & KYC** — cross-check a business's legal entity name and Business ID - **Industry research** — pull every active entity under a NAICS code - **Supplier diversity sourcing** — filter for woman-owned, veteran-owned, or minority-owned businesses - **Local market research** — pull every active entity in a given city - **Company name availability checks** — see what similarly-named entities already exist before choosing a new name ### FAQ **What's the data source?** The Connecticut Secretary of State's own business registry, published on the state's official open-data portal at `data.ct.gov`. This actor is an independent third-party tool and is not affiliated with the State of Connecticut. **Is this data official / legally binding?** No. For an official Certificate of Legal Existence or certified copies, use the state's paid ordering channels via `service.ct.gov/business`. This actor returns the same free, public informational data the state republishes as open data. **Why did my run return 0 results?** Either the query genuinely has no match, or a status/type/citizenship filter is narrower than expected. Try a broader query or remove a filter. **How fresh is the data?** The open-data extract is refreshed regularly by the Connecticut Secretary of State (typically daily); it may lag the live interactive site by up to a day. **Why is there no registered agent name in the output?** Connecticut's own registry model tracks only a Keeper-of-Records address for service of process, not a named agent — this differs from most other states. See `recordsAddress`. # Actor input Schema ## `mode` (type: `string`): Which search axis to use. ## `entityName` (type: `string`): Business entity name to search for (substring match), e.g. `WALMART`. ## `entityId` (type: `string`): Exact Connecticut Business ID (account number), e.g. `0818011`. ## `businessCity` (type: `string`): Exact business (mailing) address city to browse entities in, e.g. `Hartford`. ## `naicsCode` (type: `string`): North American Industry Classification System code to search for, e.g. `541810`. ## `entityStatus` (type: `string`): Optionally restrict results to a single entity status. ## `entityType` (type: `string`): Optionally restrict results to a single entity (business) type. ## `citizenship` (type: `string`): Optionally restrict results to entities formed in Connecticut (Domestic) or elsewhere (Foreign). ## `proxyConfiguration` (type: `object`): Uses Apify's free datacenter (AUTO) proxy group to get a fresh IP if a request is temporarily blocked. Residential proxy is never used by this actor. ## `maxItems` (type: `integer`): Hard cap on emitted records. ## Actor input object example ```json { "mode": "byEntityName", "entityName": "WALMART", "entityStatus": "", "entityType": "", "citizenship": "", "proxyConfiguration": { "useApifyProxy": true }, "maxItems": 10 } ``` # Actor output Schema ## `entities` (type: `string`): Dataset containing all scraped Connecticut business entity records. # 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 '' with your token const client = new ApifyClient({ token: '', }); // Prepare Actor input const input = { "mode": "byEntityName", "entityName": "WALMART", "entityStatus": "", "entityType": "", "citizenship": "", "proxyConfiguration": { "useApifyProxy": true }, "maxItems": 10 }; // Run the Actor and wait for it to finish const run = await client.actor("crawlerbros/connecticut-sos-business-search-scraper").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 '' with your token. client = ApifyClient("") # Prepare the Actor input run_input = { "mode": "byEntityName", "entityName": "WALMART", "entityStatus": "", "entityType": "", "citizenship": "", "proxyConfiguration": { "useApifyProxy": True }, "maxItems": 10, } # Run the Actor and wait for it to finish run = client.actor("crawlerbros/connecticut-sos-business-search-scraper").call(run_input=run_input) # Fetch and print Actor results from the run's dataset (if there are any) print("💾 Check your data here: https://console.apify.com/storage/datasets/" + run["defaultDatasetId"]) for item in client.dataset(run["defaultDatasetId"]).iterate_items(): print(item) # 📚 Want to learn more 📖? Go to → https://docs.apify.com/api/client/python/docs/quick-start ``` ## CLI example ```bash echo '{ "mode": "byEntityName", "entityName": "WALMART", "entityStatus": "", "entityType": "", "citizenship": "", "proxyConfiguration": { "useApifyProxy": true }, "maxItems": 10 }' | apify call crawlerbros/connecticut-sos-business-search-scraper --silent --output-dataset ``` ## MCP server setup ```json { "mcpServers": { "apify": { "command": "npx", "args": [ "mcp-remote", "https://mcp.apify.com/?tools=crawlerbros/connecticut-sos-business-search-scraper", "--header", "Authorization: Bearer " ] } } } ``` ## OpenAPI specification ```json { "openapi": "3.0.1", "info": { "title": "Connecticut Secretary of State Business Search Scraper", "description": "Search Connecticut's official business registry by entity name, Business ID, city, or NAICS code. Get entity type, status, formation date, mailing/records address, and diversity-ownership flags.", "version": "1.0", "x-build-id": "4VZpFsiiheAQkDpLq" }, "servers": [ { "url": "https://api.apify.com/v2" } ], "paths": { "/acts/crawlerbros~connecticut-sos-business-search-scraper/run-sync-get-dataset-items": { "post": { "operationId": "run-sync-get-dataset-items-crawlerbros-connecticut-sos-business-search-scraper", "x-openai-isConsequential": false, "summary": "Executes an Actor, waits for its completion, and returns Actor's dataset items in response.", "tags": [ "Run Actor" ], "requestBody": { "required": true, "content": { "application/json": { "schema": { "$ref": "#/components/schemas/inputSchema" } } } }, "parameters": [ { "name": "token", "in": "query", "required": true, "schema": { "type": "string" }, "description": "Enter your Apify token here" } ], "responses": { "200": { "description": "OK" } } } }, "/acts/crawlerbros~connecticut-sos-business-search-scraper/runs": { "post": { "operationId": "runs-sync-crawlerbros-connecticut-sos-business-search-scraper", "x-openai-isConsequential": false, "summary": "Executes an Actor and returns information about the initiated run in response.", "tags": [ "Run Actor" ], "requestBody": { "required": true, "content": { "application/json": { "schema": { "$ref": "#/components/schemas/inputSchema" } } } }, "parameters": [ { "name": "token", "in": "query", "required": true, "schema": { "type": "string" }, "description": "Enter your Apify token here" } ], "responses": { "200": { "description": "OK", "content": { "application/json": { "schema": { "$ref": "#/components/schemas/runsResponseSchema" } } } } } } }, "/acts/crawlerbros~connecticut-sos-business-search-scraper/run-sync": { "post": { "operationId": "run-sync-crawlerbros-connecticut-sos-business-search-scraper", "x-openai-isConsequential": false, "summary": "Executes an Actor, waits for completion, and returns the OUTPUT from Key-value store in response.", "tags": [ "Run Actor" ], "requestBody": { "required": true, "content": { "application/json": { "schema": { "$ref": "#/components/schemas/inputSchema" } } } }, "parameters": [ { "name": "token", "in": "query", "required": true, "schema": { "type": "string" }, "description": "Enter your Apify token here" } ], "responses": { "200": { "description": "OK" } } } } }, "components": { "schemas": { "inputSchema": { "type": "object", "required": [ "mode", "proxyConfiguration" ], "properties": { "mode": { "title": "Search mode", "enum": [ "byEntityName", "byAccountNumber", "byCity", "byNaicsCode" ], "type": "string", "description": "Which search axis to use.", "default": "byEntityName" }, "entityName": { "title": "Entity name (mode=byEntityName)", "type": "string", "description": "Business entity name to search for (substring match), e.g. `WALMART`.", "default": "WALMART" }, "entityId": { "title": "Business ID / account number (mode=byAccountNumber)", "type": "string", "description": "Exact Connecticut Business ID (account number), e.g. `0818011`." }, "businessCity": { "title": "Business city (mode=byCity)", "type": "string", "description": "Exact business (mailing) address city to browse entities in, e.g. `Hartford`." }, "naicsCode": { "title": "NAICS code (mode=byNaicsCode)", "type": "string", "description": "North American Industry Classification System code to search for, e.g. `541810`." }, "entityStatus": { "title": "Entity status filter", "enum": [ "", "Active", "Active - Pending Domestication", "Cancelled", "Consolidation", "Converted", "Converted Out", "Dissolved", "Domesticated", "Expired", "Expired Reservation", "Forfeited", "Merged", "Pending Conversion", "Pending Filing", "Pending Merger", "Pending Withdrawal", "Recorded", "Redomesticated", "Registered", "Rejected", "Removed", "Renunciated", "Reserved", "Reserved Cancel", "Revoked", "Withdrawn" ], "type": "string", "description": "Optionally restrict results to a single entity status.", "default": "" }, "entityType": { "title": "Entity type filter", "enum": [ "", "LLC", "Stock", "Non-Stock", "Limited Partnership", "LLP", "Statutory Trust", "General Partnerships", "B Corp", "Bank Stock", "Bank Non-Stock", "Credit Union Stock", "Credit Union Non-Stock", "Insurance Stock", "Insurance Non-Stock", "Cooperative Association", "Cemetery", "Religious", "Special Chartered", "Stock Specially Chartered", "Non-Stock Specially Chartered", "Unauthorized", "Unknown" ], "type": "string", "description": "Optionally restrict results to a single entity (business) type.", "default": "" }, "citizenship": { "title": "Domestic / foreign filter", "enum": [ "", "Domestic", "Foreign" ], "type": "string", "description": "Optionally restrict results to entities formed in Connecticut (Domestic) or elsewhere (Foreign).", "default": "" }, "proxyConfiguration": { "title": "Proxy configuration", "type": "object", "description": "Uses Apify's free datacenter (AUTO) proxy group to get a fresh IP if a request is temporarily blocked. Residential proxy is never used by this actor.", "default": { "useApifyProxy": true } }, "maxItems": { "title": "Max items", "minimum": 1, "maximum": 1000, "type": "integer", "description": "Hard cap on emitted records.", "default": 25 } } }, "runsResponseSchema": { "type": "object", "properties": { "data": { "type": "object", "properties": { "id": { "type": "string" }, "actId": { "type": "string" }, "userId": { "type": "string" }, "startedAt": { "type": "string", "format": "date-time", "example": "2025-01-08T00:00:00.000Z" }, "finishedAt": { "type": "string", "format": "date-time", "example": "2025-01-08T00:00:00.000Z" }, "status": { "type": "string", "example": "READY" }, "meta": { "type": "object", "properties": { "origin": { "type": "string", "example": "API" }, "userAgent": { "type": "string" } } }, "stats": { "type": "object", "properties": { "inputBodyLen": { "type": "integer", "example": 2000 }, "rebootCount": { "type": "integer", "example": 0 }, "restartCount": { "type": "integer", "example": 0 }, "resurrectCount": { "type": "integer", "example": 0 }, "computeUnits": { "type": "integer", "example": 0 } } }, "options": { "type": "object", "properties": { "build": { "type": "string", "example": "latest" }, "timeoutSecs": { "type": "integer", "example": 300 }, "memoryMbytes": { "type": "integer", "example": 1024 }, "diskMbytes": { "type": "integer", "example": 2048 } } }, "buildId": { "type": "string" }, "defaultKeyValueStoreId": { "type": "string" }, "defaultDatasetId": { "type": "string" }, "defaultRequestQueueId": { "type": "string" }, "buildNumber": { "type": "string", "example": "1.0.0" }, "containerUrl": { "type": "string" }, "usage": { "type": "object", "properties": { "ACTOR_COMPUTE_UNITS": { "type": "integer", "example": 0 }, "DATASET_READS": { "type": "integer", "example": 0 }, "DATASET_WRITES": { "type": "integer", "example": 0 }, "KEY_VALUE_STORE_READS": { "type": "integer", "example": 0 }, "KEY_VALUE_STORE_WRITES": { "type": "integer", "example": 1 }, "KEY_VALUE_STORE_LISTS": { "type": "integer", "example": 0 }, "REQUEST_QUEUE_READS": { "type": "integer", "example": 0 }, "REQUEST_QUEUE_WRITES": { "type": "integer", "example": 0 }, "DATA_TRANSFER_INTERNAL_GBYTES": { "type": "integer", "example": 0 }, "DATA_TRANSFER_EXTERNAL_GBYTES": { "type": "integer", "example": 0 }, "PROXY_RESIDENTIAL_TRANSFER_GBYTES": { "type": "integer", "example": 0 }, "PROXY_SERPS": { "type": "integer", "example": 0 } } }, "usageTotalUsd": { "type": "number", "example": 0.00005 }, "usageUsd": { "type": "object", "properties": { "ACTOR_COMPUTE_UNITS": { "type": "integer", "example": 0 }, "DATASET_READS": { "type": "integer", "example": 0 }, "DATASET_WRITES": { "type": "integer", "example": 0 }, "KEY_VALUE_STORE_READS": { "type": "integer", "example": 0 }, "KEY_VALUE_STORE_WRITES": { "type": "number", "example": 0.00005 }, "KEY_VALUE_STORE_LISTS": { "type": "integer", "example": 0 }, "REQUEST_QUEUE_READS": { "type": "integer", "example": 0 }, "REQUEST_QUEUE_WRITES": { "type": "integer", "example": 0 }, "DATA_TRANSFER_INTERNAL_GBYTES": { "type": "integer", "example": 0 }, "DATA_TRANSFER_EXTERNAL_GBYTES": { "type": "integer", "example": 0 }, "PROXY_RESIDENTIAL_TRANSFER_GBYTES": { "type": "integer", "example": 0 }, "PROXY_SERPS": { "type": "integer", "example": 0 } } } } } } } } } } ```