← Health board

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.

97%golden-diff pass
Run it on Apify verified nightly

Verification

97%golden-diff success
309canary runs
0days since last canary run

Output fields

Authoritative field set from the dataset schema.

FieldType
countystring|null
person_namestring|null
business_namestring|null
credential_typestring|null
credential_numberstring|null
statusstring|null
issue_datestring|null
effective_datestring|null
expiration_datestring|null
citystring|null
state_codestring|null
zip_codestring|null
source_urlstring|null
scraped_atstring|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

FieldTypeReqDefaultDescription
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