Washington L&I Contractor & License Scraper

Scrape Washington State contractor licenses with insurance, bond and principal/owner data from data.wa.gov — joining 4 L&I open datasets in a single run.

---

Why This Actor Is Unique

Other contractor scrapers give you a license list. This actor gives you due diligence data — everything a GC, insurer, or compliance team needs:

Data Source	Dataset	What You Get
General	m8qx-ubtq	Business name, license #, type, specialty, status, address, phone, UBI, principal
Insurance	ciwg-agsx	Insurance company, policy #, coverage amount, effective/expiration dates, agency
Bond	bzff-4fmt	Surety firm, bond amount, impaired status, dates
Principal	4xk5-x9j6	All company owners/officers with start/end dates

All 4 datasets joined by ContractorLicenseNumber into one enriched record per contractor.

---

How It Works

Step 1: Fetch General dataset with SoQL filters (status, specialty, city, date)
Step 2: Collect unique license numbers from results
Step 3: Batch-fetch Insurance, Bond, Principal for those license numbers
Step 4: Join all 4 datasets by license number → enriched output

Pure Socrata SODA API — no browser, no proxy, no authentication required.

---

Input

{
  "statuses": ["ACTIVE"],
  "specialties": ["01"],
  "cities": ["SEATTLE", "TACOMA"],
  "enrichInsurance": true,
  "enrichBond": true,
  "enrichPrincipal": true,
  "maxRecords": 5000
}

Parameters

Parameter	Type	Default	Description
statuses	array	["ACTIVE"]	License status filter. Values: ACTIVE, EXPIRED, SUSPENDED, RE-LICENSED, CANCELLED.
specialties	array	[]	Specialty code filter. 01=General, 02=Electrical, 03=Plumbing, 04=HVAC, etc.
licenseTypes	array	[]	License type filter. CC=Construction, EC=Electrical, GC=General.
cities	array	[]	City filter. Case-insensitive.
effectiveAfter	string	—	License effective after date (YYYY-MM-DD).
effectiveBefore	string	—	License effective before date (YYYY-MM-DD).
enrichInsurance	boolean	true	Join insurance data.
enrichBond	boolean	true	Join bond data.
enrichPrincipal	boolean	true	Join principal/owner data.
maxRecords	integer	5000	Max records. 0 = unlimited.
pageSize	integer	1000	Records per API call.
requestDelay	integer (ms)	200	Delay between requests.

---

Specialty Codes

Code	Description
01	General
02	Electrical
03	Plumbing
04	HVAC
BW	Bridge/Water
CB	Painting
DP	Demolition
EL	Elevator
RO	Roofing

---

Output

{
  "businessName": "PACIFIC BUILDERS LLC",
  "licenseNumber": "PACIFBL789KH",
  "licenseTypeDesc": "CONSTRUCTION CONTRACTOR",
  "status": "ACTIVE",
  "address": "1234 PIKE ST",
  "city": "SEATTLE",
  "state": "WA",
  "zip": "98101",
  "phone": "2065551234",
  "ubi": "604123456",
  "businessType": "Limited Liability Company",
  "specialty1Desc": "GENERAL",
  "primaryPrincipal": "SMITH, JOHN A.",
  "licenseEffectiveDate": "2024-03-15",
  "licenseExpirationDate": "2026-03-15",
  "insuranceCompany": "State Farm Insurance",
  "insurancePolicyNo": "GL-123456",
  "insuranceAmount": "1000000",
  "insuranceExpiration": "2025-09-15",
  "insuranceAgency": "Northwest Insurance Agency",
  "bondFirm": "Western Surety Co",
  "bondAmount": "12000",
  "bondExpiration": "Until Canceled",
  "bondImpaired": "No",
  "principals": "SMITH, JOHN A.; SMITH, JANE B.",
  "scrapedAt": "2026-04-20T14:00:00.000Z"
}

---

Use Cases

• Subcontractor due diligence — verify license + insurance + bond in one lookup
• Lead generation — find active contractors by specialty and city
• Compliance monitoring — track expiring insurance and bond impairments
• Market analysis — count contractors by type, specialty, and region
• Risk assessment — identify contractors with expired insurance or impaired bonds

---

Performance

~0.005 CU per 1,000 enriched records. A full run with 5,000 contractors + insurance + bond + principal completes in ~2-3 minutes.

---

Data Source

• Provider: Washington State Dept. of Labor & Industries
• Portal: data.wa.gov (Socrata SODA API)
• Auth: None (public open data)
• Update frequency: Regular (varies by dataset)

---

Changelog

Version	Date	Notes
1.0.0	2026-04-20	Initial release — 4-dataset join, SoQL filtering, batch enrichment