DCP
Connecticut Contractor Directory & Leads Scraper (DCP)
Browse all Connecticut Home Improvement Contractor (HIC) registrations filtered by county — business name, credential number, status, issue and expiry dates — from the official DCP open-data registry.
Verification
Output fields
Authoritative field set from the dataset schema.
| Field | Type |
|---|---|
county | string|null |
person_name | string|null |
business_name | string|null |
credential_type | string|null |
credential_number | string|null |
status | string|null |
issue_date | string|null |
effective_date | string|null |
expiration_date | string|null |
city | string|null |
state_code | string|null |
zip_code | string|null |
source_url | string|null |
scraped_at | string|null |
Sample row
{
"county": "Hartford",
"person_name": "JOHN SMITH",
"business_name": "HARTFORD HOME PROS LLC",
"credential_type": "HIC",
"credential_number": "HIC.0567890",
"status": "Active",
"issue_date": "2020-03-15T00:00:00.000",
"effective_date": "2020-03-15T00:00:00.000",
"expiration_date": "2026-03-15T00:00:00.000",
"city": "HARTFORD",
"state_code": "CT",
"zip_code": "06103",
"source_url": "https://data.ct.gov/Business/Connecticut-Home-Improvement-Contractors/5r9m-qgni"
} Inputs
| Field | Type | Req | Default | Description |
|---|---|---|---|---|
county | string | no | — | Return only contractors in this CT county (e.g. 'Hartford', 'Fairfield', 'New Haven'). Leave blank to return all 8 counties. Case-insensitive. |
counties | array | no | [] | Look up many in ONE run instead of starting a run per lookup. Takes the same values as 'County filter'. Combined with 'County filter' if you fill both, and duplicates are removed. Billing is unchanged: you are charged per record returned, not per entry submitted. |
statusFilter | string | no | "Active" | Filter by credential status. Use 'Active' (default) for current licenses only, or 'ALL' to include inactive and revoked records. |
maxResults | integer | no | 500 | Hard cap on the number of contractor records returned. A statewide ALL-status pull can be 130,000+ rows and will time out the default run — set higher deliberately. Default 500. |
Pricing
Pay per result (dataset-item) — no charge for empty runs.
Example: 5000 contractor records (typical mid-sized county) at $0.002/result ≈ $10.00.
FAQ
Where does the data come from?
The official Connecticut Department of Consumer Protection (DCP) Home Improvement Contractor credential dataset, published on data.ct.gov (Socrata). Public, authoritative, and refreshed regularly.
How does the county filter work?
The DCP dataset has no county field. This actor derives county from each contractor's ZIP code using a static CT ZIP→county mapping covering all 8 Connecticut counties. Contractors with out-of-state or unrecognised ZIP codes will have county=null and won't match a county filter.
What are Connecticut's 8 counties?
Fairfield, Hartford, Litchfield, Middlesex, New Haven, New London, Tolland, and Windham.
How many records does a typical county run return?
It varies by county size. Hartford and Fairfield counties have the most contractors; Litchfield and Middlesex are smaller. Run without a county filter to get all 134,000+ rows.
Can I get all counties at once?
Yes — leave the county field blank. The actor pulls the full registry and returns all records (or up to your maxResults cap).
What does statusFilter do?
Set to 'Active' (default) to return only currently licensed contractors. Set to 'ALL' to include inactive, revoked, and expired records for a full historical roster.
How am I charged?
Pay per record returned. No charge for runs that return zero records.
Is this personal data?
It's public professional-credential data (business and registration records as DCP publishes them); no personal/PII enrichment is added.
How current is the data?
The DCP open-data dataset on data.ct.gov is refreshed regularly. Expect up to 1–2 business days of lag for very recent changes.
Guides & use cases
Related actors