scrapebench

← Health board

DCP

Connecticut Contractor Directory & Leads Scraper (DCP)

Browse all Connecticut Home Improvement Contractor (HIC) registrations by county, or look up any contractor by name or licence number — status, expiry dates and credential codes from the official DCP open-data registry.

98%golden-diff pass
Run it on Apify → verified nightly

Verification

98%golden-diff success
44canary runs
0days since last canary run

Output fields

Authoritative field set from the dataset schema.

FieldType
countystring|null
person_namestring|null
business_namestring|null
dbastring|null
entity_typestring|null
credential_descriptionstring|null
full_credential_codestring|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
statestring|null
license_numberstring|null
license_typestring|null
dba_namestring|null
address_statestring|null
matched_bystring|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
mode string no "auto" export: no names, just filters; returns the matching registrations statewide. lookup: put business names, person names or licence numbers (e.g. 660940 or HIC.0660940) in 'queries' to verify a contractor. auto picks the mode for you.
queries array no [] Lookup: business, person or trading names (matched if contained in the name) or licence numbers (exact). One run, many lookups; every status is returned unless you set 'Statuses'.
query string no — One name or licence number to look up. Kept alongside 'queries' for saved tasks.
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.
statuses array no [] Only these CT DCP statuses (e.g. ACTIVE, QUALIFIED, INACTIVE, SUSPENDED). Overrides 'License status filter' when set. Export defaults to Active; lookup returns every status unless you set this.
status string no — One status; combined with 'Statuses'.
licenseTypes array no [] CT DCP publishes one licence type in this dataset: HOME IMPROVEMENT CONTRACTOR (HIC). Leave empty.
expiresAfter string no — Only registrations expiring on or after this date (YYYY-MM-DD). CT registrations expire on March 31 each year.
expiresBefore string no — Only registrations expiring on or before this date (YYYY-MM-DD) — e.g. renewals coming due.
maxResults integer no 500 Export: hard cap on the number of contractor records returned (lookup: per name or number; 20 if left empty). A statewide ALL-status pull can be 130,000+ rows and will time out the default run — set higher deliberately. Default 500.
proxyConfiguration object no {"useApifyProxy":false} Off by default; data.ct.gov needs no proxy.

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).

Can I verify a single contractor?

Yes. Put names or licence numbers in `queries` (mode `auto` or `lookup`). A licence number matches exactly (660940 and HIC.0660940 both work); a name matches if it is contained in the owner's, business or trading name. Lookup returns every status — active, inactive, suspended — unless you set `statuses`. A name or number with no registration returns a free row saying so.

Can I find registrations that are about to expire?

Yes, in either mode: `expiresAfter` and `expiresBefore` take dates (YYYY-MM-DD). Connecticut registrations all expire on March 31, so a window ending 2027-03-31 lists the current renewal cycle.

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

Run Connecticut Contractor Directory & Leads Scraper (DCP) on Apify →