# Washington L\&I Contractor & License Scraper (`haketa/washington-li-contractor-license-scraper`) Actor Scrape Washington State L\&I contractor licenses with insurance, bond and principal data from data.wa.gov Socrata API. Joins 4 datasets: General + Insurance + Bond + Principal by license number. Filter by status, specialty, city and date. No auth, no proxy, no browser. - **URL**: https://apify.com/haketa/washington-li-contractor-license-scraper.md - **Developed by:** [Haketa](https://apify.com/haketa) (community) - **Categories:** Developer tools, Automation, Other - **Stats:** 2 total users, 1 monthly users, 100.0% runs succeeded, NaN bookmarks - **User rating**: No ratings yet ## Pricing from $5.00 / 1,000 results This Actor is paid per event. You are not charged for the Apify platform usage, but only a fixed price for specific events. Since this Actor supports Apify Store discounts, the price gets lower the higher subscription plan you have. Learn more: https://docs.apify.com/platform/actors/running/actors-in-store#pay-per-event ## What's an Apify Actor? Actors are a software tools running on the Apify platform, for all kinds of web data extraction and automation use cases. In Batch mode, an Actor accepts a well-defined JSON input, performs an action which can take anything from a few seconds to a few hours, and optionally produces a well-defined JSON output, datasets with results, or files in key-value store. In Standby mode, an Actor provides a web server which can be used as a website, API, or an MCP server. Actors are written with capital "A". ## How to integrate an Actor? If asked about integration, you help developers integrate Actors into their projects. You adapt to their stack and deliver integrations that are safe, well-documented, and production-ready. The best way to integrate Actors is as follows. In JavaScript/TypeScript projects, use official [JavaScript/TypeScript client](https://docs.apify.com/api/client/js.md): ```bash npm install apify-client ``` In Python projects, use official [Python client library](https://docs.apify.com/api/client/python.md): ```bash pip install apify-client ``` In shell scripts, use [Apify CLI](https://docs.apify.com/cli/docs.md): ````bash # MacOS / Linux curl -fsSL https://apify.com/install-cli.sh | bash # Windows irm https://apify.com/install-cli.ps1 | iex ```bash In AI frameworks, you might use the [Apify MCP server](https://docs.apify.com/platform/integrations/mcp.md). If your project is in a different language, use the [REST API](https://docs.apify.com/api/v2.md). For usage examples, see the [API](#api) section below. For more details, see Apify documentation as [Markdown index](https://docs.apify.com/llms.txt) and [Markdown full-text](https://docs.apify.com/llms-full.txt). # README ## Washington L&I Contractor & License Scraper Scrape Washington State contractor licenses with **insurance, bond and principal/owner data** from **[data.wa.gov](https://data.wa.gov)** — joining 4 L&I open datasets in a single run. [![Apify Actor](https://img.shields.io/badge/Apify-Actor-blue)](https://apify.com) [![No Browser](https://img.shields.io/badge/Engine-Direct%20API-green)]() [![4 Datasets](https://img.shields.io/badge/Joins-4%20Datasets-purple)]() --- ### 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 ```json { "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 ```json { "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 | # Actor input Schema ## `statuses` (type: `array`): Filter by license status. Leave empty for all. Values: 'ACTIVE', 'EXPIRED', 'SUSPENDED', 'RE-LICENSED', 'CANCELLED'. ## `specialties` (type: `array`): Filter by specialty. Leave empty for all. Common codes: '01' (General), '02' (Electrical), '03' (Plumbing), '04' (HVAC), 'BW' (Bridge/Water), 'CB' (Painting), 'DP' (Demolition), 'EL' (Elevator), 'RO' (Roofing). ## `licenseTypes` (type: `array`): Filter by license type. Leave empty for all. Values: 'CC' (Construction Contractor), 'EC' (Electrical Contractor), 'GC' (General Contractor). ## `cities` (type: `array`): Filter by city. Leave empty for all. Case-insensitive. Example: \['SEATTLE', 'TACOMA', 'SPOKANE']. ## `effectiveAfter` (type: `string`): Only licenses effective on or after this date. Leave empty for no lower bound. ## `effectiveBefore` (type: `string`): Only licenses effective on or before this date. Leave empty for no upper bound. ## `enrichInsurance` (type: `boolean`): Join insurance dataset (company, policy number, coverage amount, dates). Adds ~1 API call per 1000 records. ## `enrichBond` (type: `boolean`): Join bond dataset (surety firm, bond amount, impaired status). Adds ~1 API call per 1000 records. ## `enrichPrincipal` (type: `boolean`): Join principal dataset (owner/officer names). Adds ~1 API call per 1000 records. ## `maxRecords` (type: `integer`): Maximum total records to fetch from General dataset. Set 0 for unlimited. ## `pageSize` (type: `integer`): Records per API request. Socrata max 50000, recommended 1000-5000. ## `requestDelay` (type: `integer`): Delay between API requests. ## Actor input object example ```json { "statuses": [ "ACTIVE" ], "specialties": [], "licenseTypes": [], "cities": [], "enrichInsurance": true, "enrichBond": true, "enrichPrincipal": true, "maxRecords": 100, "pageSize": 100, "requestDelay": 200 } ``` # Actor output Schema ## `businessName` (type: `string`): No description ## `licenseNumber` (type: `string`): No description ## `licenseTypeCode` (type: `string`): No description ## `licenseTypeDesc` (type: `string`): No description ## `status` (type: `string`): No description ## `address` (type: `string`): No description ## `city` (type: `string`): No description ## `state` (type: `string`): No description ## `zip` (type: `string`): No description ## `phone` (type: `string`): No description ## `ubi` (type: `string`): No description ## `businessType` (type: `string`): No description ## `specialty1Desc` (type: `string`): No description ## `primaryPrincipal` (type: `string`): No description ## `licenseEffectiveDate` (type: `string`): No description ## `licenseExpirationDate` (type: `string`): No description ## `insuranceCompany` (type: `string`): No description ## `insuranceAmount` (type: `string`): No description ## `bondFirm` (type: `string`): No description ## `bondAmount` (type: `string`): No description ## `bondImpaired` (type: `string`): No description ## `principals` (type: `string`): No description ## `scrapedAt` (type: `string`): No description # API You can run this Actor programmatically using our API. Below are code examples in JavaScript, Python, and CLI, as well as the OpenAPI specification and MCP server setup. ## JavaScript example ```javascript import { ApifyClient } from 'apify-client'; // Initialize the ApifyClient with your Apify API token // Replace the '' with your token const client = new ApifyClient({ token: '', }); // Prepare Actor input const input = { "statuses": [ "ACTIVE" ], "specialties": [], "licenseTypes": [], "cities": [], "effectiveAfter": "", "effectiveBefore": "" }; // Run the Actor and wait for it to finish const run = await client.actor("haketa/washington-li-contractor-license-scraper").call(input); // Fetch and print Actor results from the run's dataset (if any) console.log('Results from dataset'); console.log(`💾 Check your data here: https://console.apify.com/storage/datasets/${run.defaultDatasetId}`); const { items } = await client.dataset(run.defaultDatasetId).listItems(); items.forEach((item) => { console.dir(item); }); // 📚 Want to learn more 📖? Go to → https://docs.apify.com/api/client/js/docs ``` ## Python example ```python from apify_client import ApifyClient # Initialize the ApifyClient with your Apify API token # Replace '' with your token. client = ApifyClient("") # Prepare the Actor input run_input = { "statuses": ["ACTIVE"], "specialties": [], "licenseTypes": [], "cities": [], "effectiveAfter": "", "effectiveBefore": "", } # Run the Actor and wait for it to finish run = client.actor("haketa/washington-li-contractor-license-scraper").call(run_input=run_input) # Fetch and print Actor results from the run's dataset (if there are any) print("💾 Check your data here: https://console.apify.com/storage/datasets/" + run["defaultDatasetId"]) for item in client.dataset(run["defaultDatasetId"]).iterate_items(): print(item) # 📚 Want to learn more 📖? Go to → https://docs.apify.com/api/client/python/docs/quick-start ``` ## CLI example ```bash echo '{ "statuses": [ "ACTIVE" ], "specialties": [], "licenseTypes": [], "cities": [], "effectiveAfter": "", "effectiveBefore": "" }' | apify call haketa/washington-li-contractor-license-scraper --silent --output-dataset ``` ## MCP server setup ```json { "mcpServers": { "apify": { "command": "npx", "args": [ "mcp-remote", "https://mcp.apify.com/?tools=haketa/washington-li-contractor-license-scraper", "--header", "Authorization: Bearer " ] } } } ``` ## OpenAPI specification ```json { "openapi": "3.0.1", "info": { "title": "Washington L&I Contractor & License Scraper", "description": "Scrape Washington State L&I contractor licenses with insurance, bond and principal data from data.wa.gov Socrata API. Joins 4 datasets: General + Insurance + Bond + Principal by license number. Filter by status, specialty, city and date. No auth, no proxy, no browser.", "version": "0.0", "x-build-id": "wsNPgrpYqPmxWkc2t" }, "servers": [ { "url": "https://api.apify.com/v2" } ], "paths": { "/acts/haketa~washington-li-contractor-license-scraper/run-sync-get-dataset-items": { "post": { "operationId": "run-sync-get-dataset-items-haketa-washington-li-contractor-license-scraper", "x-openai-isConsequential": false, "summary": "Executes an Actor, waits for its completion, and returns Actor's dataset items in response.", "tags": [ "Run Actor" ], "requestBody": { "required": true, "content": { "application/json": { "schema": { "$ref": "#/components/schemas/inputSchema" } } } }, "parameters": [ { "name": "token", "in": "query", "required": true, "schema": { "type": "string" }, "description": "Enter your Apify token here" } ], "responses": { "200": { "description": "OK" } } } }, "/acts/haketa~washington-li-contractor-license-scraper/runs": { "post": { "operationId": "runs-sync-haketa-washington-li-contractor-license-scraper", "x-openai-isConsequential": false, "summary": "Executes an Actor and returns information about the initiated run in response.", "tags": [ "Run Actor" ], "requestBody": { "required": true, "content": { "application/json": { "schema": { "$ref": "#/components/schemas/inputSchema" } } } }, "parameters": [ { "name": "token", "in": "query", "required": true, "schema": { "type": "string" }, "description": "Enter your Apify token here" } ], "responses": { "200": { "description": "OK", "content": { "application/json": { "schema": { "$ref": "#/components/schemas/runsResponseSchema" } } } } } } }, "/acts/haketa~washington-li-contractor-license-scraper/run-sync": { "post": { "operationId": "run-sync-haketa-washington-li-contractor-license-scraper", "x-openai-isConsequential": false, "summary": "Executes an Actor, waits for completion, and returns the OUTPUT from Key-value store in response.", "tags": [ "Run Actor" ], "requestBody": { "required": true, "content": { "application/json": { "schema": { "$ref": "#/components/schemas/inputSchema" } } } }, "parameters": [ { "name": "token", "in": "query", "required": true, "schema": { "type": "string" }, "description": "Enter your Apify token here" } ], "responses": { "200": { "description": "OK" } } } } }, "components": { "schemas": { "inputSchema": { "type": "object", "properties": { "statuses": { "title": "License Statuses", "type": "array", "description": "Filter by license status. Leave empty for all. Values: 'ACTIVE', 'EXPIRED', 'SUSPENDED', 'RE-LICENSED', 'CANCELLED'.", "items": { "type": "string" } }, "specialties": { "title": "Specialty Codes", "type": "array", "description": "Filter by specialty. Leave empty for all. Common codes: '01' (General), '02' (Electrical), '03' (Plumbing), '04' (HVAC), 'BW' (Bridge/Water), 'CB' (Painting), 'DP' (Demolition), 'EL' (Elevator), 'RO' (Roofing).", "items": { "type": "string" } }, "licenseTypes": { "title": "License Type Codes", "type": "array", "description": "Filter by license type. Leave empty for all. Values: 'CC' (Construction Contractor), 'EC' (Electrical Contractor), 'GC' (General Contractor).", "items": { "type": "string" } }, "cities": { "title": "Cities (optional)", "type": "array", "description": "Filter by city. Leave empty for all. Case-insensitive. Example: ['SEATTLE', 'TACOMA', 'SPOKANE'].", "items": { "type": "string" } }, "effectiveAfter": { "title": "License Effective After (YYYY-MM-DD)", "type": "string", "description": "Only licenses effective on or after this date. Leave empty for no lower bound." }, "effectiveBefore": { "title": "License Effective Before (YYYY-MM-DD)", "type": "string", "description": "Only licenses effective on or before this date. Leave empty for no upper bound." }, "enrichInsurance": { "title": "Enrich with Insurance Data", "type": "boolean", "description": "Join insurance dataset (company, policy number, coverage amount, dates). Adds ~1 API call per 1000 records.", "default": true }, "enrichBond": { "title": "Enrich with Bond Data", "type": "boolean", "description": "Join bond dataset (surety firm, bond amount, impaired status). Adds ~1 API call per 1000 records.", "default": true }, "enrichPrincipal": { "title": "Enrich with Principal/Owner Data", "type": "boolean", "description": "Join principal dataset (owner/officer names). Adds ~1 API call per 1000 records.", "default": true }, "maxRecords": { "title": "Max Records", "minimum": 0, "type": "integer", "description": "Maximum total records to fetch from General dataset. Set 0 for unlimited.", "default": 100 }, "pageSize": { "title": "Page Size", "minimum": 100, "maximum": 50000, "type": "integer", "description": "Records per API request. Socrata max 50000, recommended 1000-5000.", "default": 100 }, "requestDelay": { "title": "Request Delay (ms)", "minimum": 0, "maximum": 5000, "type": "integer", "description": "Delay between API requests.", "default": 200 } } }, "runsResponseSchema": { "type": "object", "properties": { "data": { "type": "object", "properties": { "id": { "type": "string" }, "actId": { "type": "string" }, "userId": { "type": "string" }, "startedAt": { "type": "string", "format": "date-time", "example": "2025-01-08T00:00:00.000Z" }, "finishedAt": { "type": "string", "format": "date-time", "example": "2025-01-08T00:00:00.000Z" }, "status": { "type": "string", "example": "READY" }, "meta": { "type": "object", "properties": { "origin": { "type": "string", "example": "API" }, "userAgent": { "type": "string" } } }, "stats": { "type": "object", "properties": { "inputBodyLen": { "type": "integer", "example": 2000 }, "rebootCount": { "type": "integer", "example": 0 }, "restartCount": { "type": "integer", "example": 0 }, "resurrectCount": { "type": "integer", "example": 0 }, "computeUnits": { "type": "integer", "example": 0 } } }, "options": { "type": "object", "properties": { "build": { "type": "string", "example": "latest" }, "timeoutSecs": { "type": "integer", "example": 300 }, "memoryMbytes": { "type": "integer", "example": 1024 }, "diskMbytes": { "type": "integer", "example": 2048 } } }, "buildId": { "type": "string" }, "defaultKeyValueStoreId": { "type": "string" }, "defaultDatasetId": { "type": "string" }, "defaultRequestQueueId": { "type": "string" }, "buildNumber": { "type": "string", "example": "1.0.0" }, "containerUrl": { "type": "string" }, "usage": { "type": "object", "properties": { "ACTOR_COMPUTE_UNITS": { "type": "integer", "example": 0 }, "DATASET_READS": { "type": "integer", "example": 0 }, "DATASET_WRITES": { "type": "integer", "example": 0 }, "KEY_VALUE_STORE_READS": { "type": "integer", "example": 0 }, "KEY_VALUE_STORE_WRITES": { "type": "integer", "example": 1 }, "KEY_VALUE_STORE_LISTS": { "type": "integer", "example": 0 }, "REQUEST_QUEUE_READS": { "type": "integer", "example": 0 }, "REQUEST_QUEUE_WRITES": { "type": "integer", "example": 0 }, "DATA_TRANSFER_INTERNAL_GBYTES": { "type": "integer", "example": 0 }, "DATA_TRANSFER_EXTERNAL_GBYTES": { "type": "integer", "example": 0 }, "PROXY_RESIDENTIAL_TRANSFER_GBYTES": { "type": "integer", "example": 0 }, "PROXY_SERPS": { "type": "integer", "example": 0 } } }, "usageTotalUsd": { "type": "number", "example": 0.00005 }, "usageUsd": { "type": "object", "properties": { "ACTOR_COMPUTE_UNITS": { "type": "integer", "example": 0 }, "DATASET_READS": { "type": "integer", "example": 0 }, "DATASET_WRITES": { "type": "integer", "example": 0 }, "KEY_VALUE_STORE_READS": { "type": "integer", "example": 0 }, "KEY_VALUE_STORE_WRITES": { "type": "number", "example": 0.00005 }, "KEY_VALUE_STORE_LISTS": { "type": "integer", "example": 0 }, "REQUEST_QUEUE_READS": { "type": "integer", "example": 0 }, "REQUEST_QUEUE_WRITES": { "type": "integer", "example": 0 }, "DATA_TRANSFER_INTERNAL_GBYTES": { "type": "integer", "example": 0 }, "DATA_TRANSFER_EXTERNAL_GBYTES": { "type": "integer", "example": 0 }, "PROXY_RESIDENTIAL_TRANSFER_GBYTES": { "type": "integer", "example": 0 }, "PROXY_SERPS": { "type": "integer", "example": 0 } } } } } } } } } } ```