Every US state licenses contractors separately, so a territory list usually means several websites and formats. Building-supply distributors, insurance and bonding desks, construction SaaS sales teams and lead-gen agencies want one schema: business name, licence number and type, trade, status, expiry, phone, address, and bond or insurance where the registry publishes it.

This walkthrough uses the Contractor License Lookup & Leads: 9 US State Registries Actor (quarrylane-data/us-contractor-license-leads) to query official government open-data APIs and public-records files in one run. There is no browser automation and no contractor-board login. You need an Apify account and an API token from Console → Settings → API & Integrations. Keep the token in a secret or credential vault — never in a public workflow, gist or blog comment.

It covers nine official state and city registries: Washington L&I, Oregon CCB, Oregon Building Codes Division, Texas TDLR, Connecticut DCP, New York State DOL, New York City DCWP, Delaware Division of Revenue, and California CSLB. Florida DBPR is available as FL but is left out of the default list, because the official file server often returns a Cloudflare challenge from Apify cloud IPs. For Texas only, the standalone Texas TDLR Contractor License Leads Actor uses the same TDLR file.

Why this list matters

A whole-state export is useful for territory planning. Most sales and insurance workflows instead schedule a filtered list — roofers in Seattle, HVAC in Houston, or licences issued in the last seven days. Phone coverage is not uniform: WA, OR CCB, TX, NY, NYC and CA publish business phones; CT, DE and OR-BCD generally do not. Set requirePhone only when you can drop the registries that have none.

Run it once from curl or Python

run-sync-get-dataset-items starts a run, waits for it to finish, and returns the dataset items in one response. The HTTP call times out at 300 seconds. Filtered pulls usually finish in seconds; a full-state export (for example ~76,000 active Washington licences) needs a longer async run and the Actor's default 60-minute timeout, not this sync endpoint. Use a tilde (~) between the username and the Actor name.

Input fields from the schema:

  • sources — WA, OR, OR-BCD, TX, CT, NY, NYC, DE, CA, plus optional FL. Empty means the nine default registries (not Florida)
  • trades — including general, home-improvement, electrical, plumbing, hvac, roofing, solar, pool and others listed in the input schema. New York State and Delaware are skipped when a trade is selected, because those registries do not publish trade detail
  • licenseTypeKeywords, businessNameContains, cities, zipCodes
  • activeOnly — default true
  • requirePhone — skips CT, DE and OR-BCD, which publish no phones
  • newLicensesWithinDays — only licences issued in the last N days; billed as the premium event. Texas, Delaware and Oregon BCD are skipped because those files have no issue dates
  • onlyNew + monitorKey — monitor mode
  • maxItems (default 1,000, maximum 1,000,000) and optional maxItemsPerSource
  • enrichWebsiteContacts — optional; only when the registry already publishes the firm's own website (most do not)

The snippets below match a succeeded run on 13 Nov 2026 that pulled five active California CSLB licences. After you confirm the schema, add trades and newLicensesWithinDays for a sales list.

export APIFY_TOKEN="YOUR_APIFY_TOKEN" curl -sS -X POST \ "https://api.apify.com/v2/acts/quarrylane-data~us-contractor-license-leads/run-sync-get-dataset-items" \ -H "Authorization: Bearer $APIFY_TOKEN" \ -H "Content-Type: application/json" \ -d '{ "sources": ["CA"], "maxItems": 5, "activeOnly": true }' 

A scheduled "new roofers this week" input looks like this. Registries without issue dates or trade fields are skipped automatically, and the log says why.

{ "sources": ["WA", "OR", "CA"], "trades": ["roofing"], "newLicensesWithinDays": 7, "onlyNew": true, "monitorKey": "weekly-new-roofers", "requirePhone": true, "maxItems": 500 } 
import json, os, urllib.request TOKEN = os.environ["APIFY_TOKEN"] url = ( "https://api.apify.com/v2/acts/" "quarrylane-data~us-contractor-license-leads/" "run-sync-get-dataset-items" ) body = {"sources": ["CA"], "maxItems": 5, "activeOnly": True} req = urllib.request.Request( url, data=json.dumps(body).encode(), headers={ "Authorization": f"Bearer {TOKEN}", "Content-Type": "application/json", }, method="POST", ) with urllib.request.urlopen(req, timeout=300) as resp: items = json.loads(resp.read()) for row in items: print(row["businessName"], row["licenseNumber"], row.get("phoneFormatted")) 

Sample output

These two California corporations came from that run on 13 Nov 2026 (2:16pm Australia/Brisbane). CSLB class B is a general building licence. trades is empty here because the raw classification lives in licenseType / licenseClass; it fills in when you use the trades filter or when a registry publishes a mappable specialty (Washington does). The official principalName field is omitted so the example stays on business data. A few null fields are omitted for brevity.

[ { "recordId": "CA:1000004", "businessName": "SOUTH COAST CONSTRUCTION & DEVELOPMENT", "businessEntityType": "Corporation", "licenseNumber": "1000004", "licenseType": "B", "licenseClass": "B", "status": "CLEAR", "isActive": true, "firstLicensedDate": "2015-01-10", "issueDate": "2026-04-20", "expirationDate": "2028-04-30", "phone": "+18182667487", "phoneFormatted": "(818) 266-7487", "address": "1270 S ALFRED ST #35190", "city": "LOS ANGELES", "state": "CA", "zip": "90035", "county": "Los Angeles", "bondCompany": "AMERICAN CONTRACTORS INDEMNITY COMPANY", "bondAmount": 25000, "insuranceCompany": "STATE COMPENSATION INSURANCE FUND", "insuranceExpirationDate": "2026-12-04", "contactsEnriched": false, "extra": { "lastUpdate": "2026-04-21", "primaryStatus": "CLEAR" }, "licensingState": "CA", "source": "CA", "sourceName": "California CSLB contractor licenses", "sourceAgency": "California Contractors State License Board", "verifyAt": "https://www.cslb.ca.gov/OnlineServices/CheckLicenseII/CheckLicense.aspx", "sourceDataUrl": "https://www.cslb.ca.gov/OnlineServices/DataPortal/ContractorList", "scrapedAt": "2026-11-13T04:16:57.351Z" }, { "recordId": "CA:1000012", "businessName": "INSTABUILT CONSTRUCTION INC", "businessEntityType": "Corporation", "licenseNumber": "1000012", "licenseType": "B", "licenseClass": "B", "status": "CLEAR", "isActive": true, "firstLicensedDate": "2015-01-10", "issueDate": "2015-01-10", "expirationDate": "2027-01-31", "phone": "+18186313295", "phoneFormatted": "(818) 631-3295", "address": "1799 N HILL AVE", "city": "PASADENA", "state": "CA", "zip": "91104", "county": "Los Angeles", "bondCompany": "ATLANTIC SPECIALTY INSURANCE COMPANY", "bondAmount": 25000, "insuranceCompany": "PIE CASUALTY INSURANCE COMPNAY", "insuranceExpirationDate": "2027-10-15", "contactsEnriched": false, "extra": { "lastUpdate": "2026-10-20", "primaryStatus": "CLEAR" }, "licensingState": "CA", "source": "CA", "sourceName": "California CSLB contractor licenses", "sourceAgency": "California Contractors State License Board", "verifyAt": "https://www.cslb.ca.gov/OnlineServices/CheckLicenseII/CheckLicense.aspx", "sourceDataUrl": "https://www.cslb.ca.gov/OnlineServices/DataPortal/ContractorList", "scrapedAt": "2026-11-13T04:16:57.351Z" } ] 

Oregon CCB rows add bond and insurance carriers, amounts and expiry in the same field names. New York State rows add MWBE, workers' comp, apprenticeship and debarment flags under extra.

n8n: weekly new licences, or a one-shot territory pull

  1. Add a Schedule Trigger for a weekly new-licence job, or run the workflow manually for a one-shot city or trade list.
  2. Apify node (@apify/n8n-nodes-apify): operation Run Actor and get dataset items, Actor quarrylane-data/us-contractor-license-leads, custom input as JSON.
  3. Or an HTTP Request node: Method POST, the same URL, Bearer token, JSON body, and a 300-second timeout for filtered lists. For a full-state export, skip the sync endpoint — start a run, wait for it, then read the dataset.
  4. Split Out the array and write businessName, licenseNumber, licenseType, phoneFormatted, city, state, expirationDate and verifyAt to Sheets or a CRM.

Make.com

Connect the official Apify app. For a filtered list of a few hundred licences, Run an Actor with "Run synchronously" set to Yes, then Get Dataset Items. For larger exports, start the run asynchronously and use Watch Actor Runs plus Get Dataset Items. Schedule weekly when you use newLicensesWithinDays and onlyNew.

Clay

HTTP API as source is the right shape for a territory or weekly new-licence list: Method POST, the same URL and Bearer token, body a filtered JSON input with a modest maxItems. Map business name, licence, trade, phone, city, state, expiry and verifyAt.

To look up firms you already have, use Run Apify Actor or an HTTP API column with businessNameContains (and a source state). Clay's HTTP API docs use /ColumnName inside a quoted string for column references. Do not run an unfiltered maxItems: 1000 search once per row.

Two different "new" modes — do not mix them up

This Actor has two switches that sound similar:

  • newLicensesWithinDays is a date filter. Only licences issued (or, for WA and NY State, issued or effective) in the last N days are returned, billed as new-license-lead. Texas, Delaware and Oregon BCD are skipped because they have no issue dates.
  • onlyNew + monitorKey is monitor mode. Later runs return only licences not already delivered under that key. Unlike the FMCSA, NPI and USASpending Actors, this monitor does not by itself switch you to the premium event — a later onlyNew run is still billed as contractor-record unless newLicensesWithinDays is also set.

For a weekly "who just got licensed?" feed, use both: newLicensesWithinDays: 7, onlyNew: true, and a stable monitorKey such as "weekly-new-roofers".

Optional enrichWebsiteContacts adds $0.02 only when the official record already has the firm's website and an email or phone is actually extracted from it. Domains are never guessed. Most of these registries do not publish a website, so the option is often a no-op.

What it costs

Pay per result, with no monthly rental of the Actor:

Event When it is charged Price
contractor-record Each licence saved in a standard run $0.005 ($5 per 1,000)
new-license-lead Each licence on a run that uses newLicensesWithinDays $0.025 ($25 per 1,000)
contact-enriched In addition, only when website enrichment finds an email or phone $0.02 each

Platform compute is usually a fraction of a cent for filtered pulls. Set Max cost per run as a hard budget. Free Apify plans are capped at 15 results per run.

Worked examples: the sample California run asked for 5 licences and delivered 5, which is $0.025 in contractor-record events. A weekly new-licence pull of 400 rows at $0.025 is $10. A 1,000-row standard territory list is $5.

Try the Actor

The Actor is on the Apify Store: quarrylane-data/us-contractor-license-leads. Start with one registry and a small maxItems, then add trades or newLicensesWithinDays once you like the schema.

Built by Quarrylane Data. Data comes from official public registries. Follow the CAN-SPAM Act, the TCPA, do-not-call rules and applicable state law when you contact businesses.