Oregon Contractor License Leads

Apify Actor that turns the official Oregon Building Codes Division contractor licence registry into clean, ready-to-use contractor leads (lead generation lists with trade names, DBAs, business addresses and licence expiry dates).

• Source: Building Codes Division - Active Contractor/Individual Licenses (public Socrata open dataset, ~45k active licences, updated by the state - no login, no scraping of HTML).
• Who it's for: insurance agents, warranty providers, tool/material suppliers, software vendors and service businesses that sell to licensed contractors.

What it does

1. Pulls the live registry through Oregon's Socrata API (lic_status = Active).
2. Filters by trade, city, county, state and licence expiry window.
3. Classifies each record as a business or individual licence.
4. Cleans and dedupes: one record per licence number, DBA preferred as the business name, expiry normalized to ISO date with a computed daysUntilExpiration.
5. Privacy: individual records (journeymen, inspectors, trainees) have their street address removed; business records keep the published business address.
6. Filters by licence expiry date to find licences expiring soon.

Input

Field	Type	Default	Notes
professions	array	all	Electrical, Plumbing, Boiler, Certification, RV & Manufactured Dwellings, Prefab, Combo License, Elevator
businessOnly	boolean	true	Exclude individual certifications
expiringWithinDays	integer	-	Only licences expiring within N days
city / county / state	string	-	Case-insensitive exact match
mode	full / delta	full	Experimental: change tracking needs persistent storage and currently treats all records as new
deltaDays	integer	30	Expiry window used in delta mode
maxRecords	integer	0 (no cap)

Output

One dataset item per licence:

{
  "licenceNumber": "1875PB",
  "businessName": "ACME ROOTER",
  "registrantName": "ACME PLUMBING INC",
  "dba": "ACME ROOTER",
  "trade": "Plumbing",
  "licenceType": "PB-Plumbing Contractor",
  "recordType": "business",
  "status": "Active",
  "expirationDate": "2026-12-01",
  "daysUntilExpiration": 53,
  "address": "123 MAIN ST",
  "city": "PORTLAND",
  "state": "OR",
  "zip": "97201",
  "county": "MULTNOMAH",
  "isNewSinceLastRun": false,
  "sourceDataset": "Oregon Building Codes Division - Active Contractor/Individual Licenses"
}

address is present on business records only.

Data quirks worth knowing

• lic_status is Active for every row - the registry only lists active licences, so "status" filtering is really about the expiry window.
• expiration_date is a text field (M/D/YYYY); ~8,400 rows have none. Date filtering happens in the Actor, not in SoQL.
• The registry includes out-of-state licensees (~35k of ~45k rows are OR addresses). Use the state filter if you only want Oregon addresses.
• ~1,000 of 45k rows carry a DBA; when present it becomes businessName.
• No phone/email in this dataset - the registry doesn't publish them.

Run locally

npm install
node src/run-local.js --professions Plumbing --state OR --expiring 90 --max 25
npm test

Delta details

Delta mode is experimental. Change tracking needs persistent storage and currently treats all records as new under the Actor's default permissions. Filter by licence expiry date to find licences expiring soon.

Keywords

Oregon contractor leads, contractor lead generation, licensed contractor list, contractor license database, electrical contractor leads, plumbing contractor leads, trade names (DBA), Oregon Building Codes Division, CCB-style contractor lists, B2B leads for the construction trades.