Contractor License Watch: Oregon CCB + Washington L&I

Paste a watchlist of Oregon CCB and Washington L&I contractor license numbers. Each run returns, per contractor: license status, days until the license, bond and insurance expire, an atRisk flag, and what changed since your last run (carrier switch, bond change, status change, new expiry date).

Input

Field	Description
licenseNumbers	OR CCB numbers (digits) and/or WA L&I numbers. Prefix OR: / WA: to force a state.
atRiskDays	Window for the at-risk flag (default 30). atRisk is true when status is not ACTIVE, or any expiry is lapsed or within the window.
watchlistName	Name of the key-value store in your account that keeps your last snapshot (LAST_SNAPSHOT). Use different names for different watchlists.

Output fields

state, licenseNumber, found, status, businessName, licenseType, licenseExpires, daysToLicenseExpiry, bondCompany, bondAmount, bondExpires, daysToBondExpiry, insuranceCarrierOnFile, insuranceAmount, insuranceExpires, daysToInsuranceExpiry, atRisk, atRiskReasons, changesSinceLastRun, firstSeenThisWatchlist, checkedAt, source

changesSinceLastRun is null on the first run of a watchlist, then a list of {field, old, new}.

recentChanges (Oregon only) lists field changes {changedAt, licenseType, field, old, new} recorded by our daily snapshots of the CCB feed in the last recentChangeDays days, so the first run already shows recent carrier switches, lapses and renewals. recentChangesCoverage gives the snapshot date range; changes before it are not covered. The change history is refreshed by an automated daily rebuild of this Actor. Every row carries historyCoverageEnd (last snapshot date). If that date is more than 3 days before the check date, historyStale is true and historyWarning explains that recent changes after that date are not shown. Dates in recentChanges are ISO (YYYY-MM-DD).

noInsuranceOnFile is true when an Oregon license has no insurance carrier on file in the feed; it counts toward atRisk.

Important limits — read before relying on this

• Insurance shown is the carrier on file with the state, not a certificate of insurance and not proof of coverage. Ask the contractor for a current COI.
• Washington bond and insurance: not published. The WA L&I open-data feed (data.wa.gov m8qx-ubtq) does not publish bond or insurance fields. For WA rows, bondCompany, bondAmount, bondExpires, insuranceCarrierOnFile, insuranceAmount, insuranceExpires and their day counts are always null. They are never inferred.
• Oregon status: not published. The Oregon feed (data.oregon.gov g77e-6bhs, "CCB Active Licenses") has no status field, and no other official Oregon open-data API publishes CCB status, so status is null for Oregon rows. It does not confirm a license is active, suspended or inactive; check the CCB lookup. listedInActiveFeed only tells you whether the number appears in that feed. A number that isn't listed counts as at-risk.
• Person names are not output: WA primaryprincipalname and Oregon rmi_name are dropped. Business names appear as published.

Pricing

Pay per event: one charge per contractor checked.

Sources and terms

Oregon CCB via data.oregon.gov (Public Domain U.S. Government); WA L&I via data.wa.gov (ODC Public Domain Dedication). Official Socrata APIs only; no lookup pages are scraped. Freshness equals each publisher's update schedule. No warranty. Do not use the data to contact individuals in violation of TCPA, CAN-SPAM or do-not-call rules.