# Connecticut Home Improvement Contractor Leads (`gocreative.ai/ct-home-improvement-contractor-leads`) Actor Scrapes Connecticut-registered Home Improvement Contractors from the official CT DCP registry (data.ct.gov). Returns 27,000+ active B2B leads: name, DBA, entity type, HIC license, status, dates, city, ZIP. Filter by city, ZIP, or entity type. - **URL**: https://apify.com/gocreative.ai/ct-home-improvement-contractor-leads.md - **Developed by:** [GoCreative AI](https://apify.com/gocreative.ai) (community) - **Categories:** Lead generation, Business - **Stats:** 2 total users, 1 monthly users, 100.0% runs succeeded, 0 bookmarks - **User rating**: No ratings yet ## Pricing from $5.00 / 1,000 contractor records This Actor is paid per event. You are not charged for the Apify platform usage, but only a fixed price for specific events. 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.md): ```bash npm install apify-client ``` In Python projects, use official [Python client library](https://docs.apify.com/api/client/python.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/platform/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 Home Improvement Contractor Leads ### 📊 Example output (real run) ![Sample output](https://api.apify.com/v2/key-value-stores/1ztQFHwG8acESTazI/records/ct-home-improvement-contractor-leads-sample) A real record from a live run — clean structured data, exported as CSV / JSON / Excel or via API. ![Connecticut Home Improvement Contractor Leads — filter by city or ZIP, get structured contractor leads](https://api.apify.com/v2/key-value-stores/1ztQFHwG8acESTazI/records/ct-hic-hero.png) **Export every registered Home Improvement Contractor (HIC) in Connecticut** — remodelers, roofers, siding, kitchen & bath, decks, windows, painters, and general home-improvement firms — straight from the **official Connecticut Department of Consumer Protection (DCP) credential registry**. The data is pulled live from the [State of Connecticut Open Data portal](https://data.ct.gov/Business/Home-Improvement-Contractor-Licenses-Includes-Acti/5r9m-qgni), so every record is **authoritative and free of third-party scraping risk**. Filter by city, ZIP, or entity type and download clean B2B leads as JSON, CSV, or Excel. This Actor runs on the Apify platform, so you get scheduled runs, an HTTP API, dataset storage, webhooks, and integrations (Zapier, Make, Google Sheets) on top of the data. ### What does this Actor do? It queries the CT DCP "Home Improvement Contractor Licenses" registry (~134,000 records, ~27,000+ currently active) and returns a structured lead for every contractor matching your filters. Each lead includes the company / contractor name, DBA, entity type, full HIC license code, registration status with reason, issue / effective / expiration dates, and city / state / ZIP — plus a one-click state verification URL. ### Why use Connecticut Home Improvement Contractor Leads? - **Authoritative source.** Data comes directly from the state regulator, not a scraped directory — accurate names, real license numbers, and current status. - **Territory targeting.** Filter by city or ZIP prefix to build route-density lead lists for a sales rep or a delivery zone. - **License-status verification.** Confirm a contractor's HIC registration is active (and when it expires) before extending credit, a contract, or a partnership. - **Clean enrichment base.** Name + DBA + city + ZIP + license is the ideal seed for an email/phone enrichment step. #### Who buys this data? - Building-materials, roofing, window, and siding **suppliers & manufacturers** building dealer / installer networks - **Home-services SaaS** (CRM, field service, scheduling, invoicing) prospecting contractors - Contractor **financing, factoring, and insurance** providers - **Franchise & dealer-development** teams and home-improvement **trade-show / association** organizers ### How to use it 1. Click **Try for free / Start**. 2. (Optional) Enter a **City** or **ZIP Code Prefix** to narrow the territory. 3. (Optional) Choose **Entity Type** — businesses only, individuals only, or all. 4. Leave **Active Licenses Only** on to get only current contractors. 5. Run it, then download the results from the **Output** tab as JSON, CSV, or Excel. ### Input | Field | Description | |---|---| | `city` | CT city/town filter (case-insensitive), e.g. `STAMFORD`. Blank = whole state. | | `zip_prefix` | ZIP or ZIP prefix, e.g. `069` for the Fairfield County area, `06902` for one ZIP. | | `entity_type` | `all`, `business` (companies only), or `individual`. | | `active_only` | If on (default), returns only currently active registrations. | | `max_results` | Cap on rows returned (default 5,000; up to 140,000). | Example input: ```json { "city": "STAMFORD", "entity_type": "business", "active_only": true, "max_results": 5000 } ```` ### Output Each item looks like this (real record from the live registry): ```json { "company_name": "SHORELINE POOLS INC", "contractor_name": "SHORELINE POOLS INC", "dba": "", "entity_type": "CORPORATION", "license_code": "HIC.0508652", "license_number": "508652", "credential": "HOME IMPROVEMENT CONTRACTOR", "status": "ACTIVE", "status_reason": "CURRENT", "is_active": true, "issue_date": "1999-04-26", "effective_date": "2026-04-01", "expiration_date": "2027-03-31", "city": "Stamford", "state": "CT", "zip_code": "06902", "verify_url": "https://www.elicense.ct.gov/Lookup/LicenseLookup.aspx", "source": "CT DCP (data.ct.gov 5r9m-qgni)", "scraped_at": "2026-06-27T16:00:00Z" } ``` You can download the dataset in JSON, HTML, CSV, or Excel. A CRM-ready CSV of the full run is also saved to the run's key-value store. #### Data fields | Field | Description | |---|---| | `company_name` | Business name (falls back to contractor name for individuals) | | `contractor_name` | Registered name on the credential | | `dba` | Doing-business-as name, when present | | `entity_type` | LLC, corporation, partnership, sole proprietor, individual, etc. | | `license_code` / `license_number` | Full HIC code (e.g. `HIC.0508652`) and number | | `status` / `status_reason` / `is_active` | Registration status and current/expired reason | | `issue_date` / `effective_date` / `expiration_date` | Key dates (YYYY-MM-DD) | | `city` / `state` / `zip_code` | Location (ZIP normalized to ZIP or ZIP+4) | | `verify_url` | Official CT eLicense lookup to confirm any record | ### How much does it cost? This Actor uses **Pay-Per-Result** pricing — you only pay for the contractor records you actually receive, with no monthly subscription. Pulling a city or ZIP segment is a few cents; the full active statewide list is still inexpensive. The Actor uses lightweight HTTP requests against an official open-data API (no proxies or browsers required), so platform compute cost is minimal. ### Tips - Start with a **city** or **ZIP prefix** to keep runs small and targeted, then widen. - Turn **Active Licenses Only** off to also capture recently-expired contractors (good for win-back / re-registration campaigns). - Schedule a monthly run to keep your CRM in sync as registrations renew and lapse. ### FAQ, disclaimers & support **Is this legal?** Yes. This Actor reads publicly available license data the State of Connecticut publishes as open data for public use. **Does it include email or phone?** No. Connecticut law does **not** publish street address, phone, or email for HIC credentials, so this Actor returns every field the state makes public (name, DBA, license, status, dates, city, ZIP). That is ideal for territory targeting, status verification, and as a clean base for an enrichment step — but it is not a phone/email list. **How fresh is the data?** It is fetched live from the state portal on every run; the registry itself is refreshed by CT DCP regularly. For feature requests or issues, use the **Issues** tab. Custom registry scrapers for other states are available on request. # Actor input Schema ## `city` (type: `string`): Filter by Connecticut city/town name (e.g. STAMFORD, HARTFORD, NEW HAVEN, BRIDGEPORT). Case-insensitive. Leave blank for the whole state. ## `zip_prefix` (type: `string`): Filter by a ZIP code or ZIP prefix (e.g. '06' for all of CT, '069' for Fairfield County area, '06902' for one ZIP). Leave blank for all ZIPs. ## `entity_type` (type: `string`): Which kinds of registrants to return. 'all' = everyone; 'business' = companies only (LLC, corp, partnership, sole prop); 'individual' = individually-registered contractors only. ## `active_only` (type: `boolean`): If enabled, return only contractors whose HIC registration is currently active. Disable to include inactive/expired registrations. ## `max_results` (type: `integer`): Maximum number of records to return. Default 5,000. There are ~27,000 active and ~134,000 total HIC records. ## Actor input object example ```json { "city": "STAMFORD", "zip_prefix": "069", "entity_type": "all", "active_only": true, "max_results": 5000 } ``` # Actor output Schema # 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 = {}; // Run the Actor and wait for it to finish const run = await client.actor("gocreative.ai/ct-home-improvement-contractor-leads").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 = {} # Run the Actor and wait for it to finish run = client.actor("gocreative.ai/ct-home-improvement-contractor-leads").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 '{}' | apify call gocreative.ai/ct-home-improvement-contractor-leads --silent --output-dataset ``` ## MCP server setup ```json { "mcpServers": { "apify": { "command": "npx", "args": [ "mcp-remote", "https://mcp.apify.com/?tools=gocreative.ai/ct-home-improvement-contractor-leads", "--header", "Authorization: Bearer " ] } } } ``` ## OpenAPI specification ```json { "openapi": "3.0.1", "info": { "title": "Connecticut Home Improvement Contractor Leads", "description": "Scrapes Connecticut-registered Home Improvement Contractors from the official CT DCP registry (data.ct.gov). Returns 27,000+ active B2B leads: name, DBA, entity type, HIC license, status, dates, city, ZIP. Filter by city, ZIP, or entity type.", "version": "0.1", "x-build-id": "3b9LJ3J4eBBTsygKK" }, "servers": [ { "url": "https://api.apify.com/v2" } ], "paths": { "/acts/gocreative.ai~ct-home-improvement-contractor-leads/run-sync-get-dataset-items": { "post": { "operationId": "run-sync-get-dataset-items-gocreative.ai-ct-home-improvement-contractor-leads", "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/gocreative.ai~ct-home-improvement-contractor-leads/runs": { "post": { "operationId": "runs-sync-gocreative.ai-ct-home-improvement-contractor-leads", "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/gocreative.ai~ct-home-improvement-contractor-leads/run-sync": { "post": { "operationId": "run-sync-gocreative.ai-ct-home-improvement-contractor-leads", "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", "properties": { "city": { "title": "City", "type": "string", "description": "Filter by Connecticut city/town name (e.g. STAMFORD, HARTFORD, NEW HAVEN, BRIDGEPORT). Case-insensitive. Leave blank for the whole state.", "default": "" }, "zip_prefix": { "title": "ZIP Code Prefix", "type": "string", "description": "Filter by a ZIP code or ZIP prefix (e.g. '06' for all of CT, '069' for Fairfield County area, '06902' for one ZIP). Leave blank for all ZIPs.", "default": "" }, "entity_type": { "title": "Entity Type", "enum": [ "all", "business", "individual" ], "type": "string", "description": "Which kinds of registrants to return. 'all' = everyone; 'business' = companies only (LLC, corp, partnership, sole prop); 'individual' = individually-registered contractors only.", "default": "all" }, "active_only": { "title": "Active Licenses Only", "type": "boolean", "description": "If enabled, return only contractors whose HIC registration is currently active. Disable to include inactive/expired registrations.", "default": true }, "max_results": { "title": "Max Results", "minimum": 1, "maximum": 140000, "type": "integer", "description": "Maximum number of records to return. Default 5,000. There are ~27,000 active and ~134,000 total HIC records.", "default": 5000 } } }, "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 } } } } } } } } } } ```