Contractor License Lookup: WA, OR, TX & NY Status & Insurance
Pricing
from $3.00 / 1,000 licenses
Contractor License Lookup: WA, OR, TX & NY Status & Insurance
Verify contractor licenses or list them by city, trade, new or expiring, in Washington, Oregon, Texas and New York, from each state's official open data. Status, expiration, first-issued date, bond and insurance on file, New York compliance flags.
Pricing
from $3.00 / 1,000 licenses
Rating
0.0
(0)
Developer
宗諭 楊
Maintained by CommunityActor stats
0
Bookmarked
2
Total users
1
Monthly active users
2 days ago
Last modified
Categories
Share
Contractor License Lookup: Washington, Oregon, Texas & New York
Check whether a contractor is licensed, or pull every contractor license that matches a city, a trade, a new-license window or an expiry window, read straight from each state's official open-data portal. One table across four states, with status, expiration, the date the license was first issued, and the bond and insurance the state has on file.
Two ways to use it
- Verify. Paste license numbers (
WA:ECOSTSC758NN,TX:36159,OR:1441, or just the number to look it up in every selected state) or business names. Every match comes back whatever its status, so expired and suspended licenses show up as such, and the run summary lists the numbers that were not found. - List. Leave the lookups empty and filter: trade, status (active by default), cities, ZIP prefixes, newly licensed within N days (Washington and Oregon) or expiring within N days. New licenses are sorted newest first, expiring ones soonest first.
What you get for each license
| Field | Meaning |
|---|---|
state, licenseNumber, businessName, dba | The state, its license or registration number, the licensed business name (New York also gives a DBA) |
licenseType, category, specialties | The state's own license type; one of GENERAL, SPECIALTY, ELECTRICAL, PLUMBING, HVAC, ELEVATOR, OTHER; Washington's specialty (roofing, painting, HVAC and so on) |
status, statusRaw, statusIsDerived | ACTIVE, EXPIRED, SUSPENDED, INACTIVE, SUPERSEDED, REVOKED or OTHER; the state's own wording; true when the state publishes no status and it was worked out from the expiration date |
firstIssuedDate | When the license was first issued (Washington, Oregon) |
certificateIssuedDate | New York: issue date of the current registration certificate |
expirationDate, daysToExpiration | As published; negative when already expired |
address, county | Business address as filed; county where the state gives it |
bonds, insurance | Surety bonds and liability insurance on file that are not cancelled or expired: company, amount, dates. Washington and Oregon only |
endorsements | Oregon: every CCB endorsement on the license, with its official name |
compliance | Oregon: workers' compensation status. New York: the state's yes/no answers on debarment, outstanding wage assessments, labor or tax law violations, safety violations, workers' compensation insurance, MWBE ownership |
stateBusinessId | Washington UBI number |
matchedInput | Verify mode: which of your numbers or names this row answers |
sourceRecordUrl | The exact record on the state's open-data portal |
Coverage
| State | Source | What is included |
|---|---|---|
| Washington | Department of Labor & Industries | Construction, electrical, plumbing and elevator contractors, every status, with bonds and insurance |
| Oregon | Construction Contractors Board | Active licenses with all endorsements, bond and insurance |
| Texas | Department of Licensing and Regulation | Electrical, A/C, elevator, appliance installation and sign contractors; individual electricians and technicians on request. Texas plumbers are licensed by a different board and are not included |
| New York | Department of Labor | The Contractor Registry for public work projects, with its compliance answers |
Things to know
- Texas publishes no status, only an expiration date, so its status is derived from that date (
statusIsDerived). - Oregon and New York publish lists of active licenses. A license removed from the list comes back as not found in a lookup. A few Oregon licenses stay on the list past their expiration date; they are returned as
EXPIRED(statusIsDerived). - The city filter matches the city name in every selected state: Portland finds Oregon contractors and Washington contractors based in Portland. Choose states to narrow it.
- Texas individual licenses rarely carry a business address, so city and ZIP filters find few of them; look them up by license number.
- Empty
bondsorinsurancefor Texas and New York means not published, not "none". - If a portal has not been refreshed for more than 10 days, that state is reported as failed instead of being returned as if it were current.
Personal data
No phone numbers, e-mail addresses, or names of owners, principals, officers or responsible managing individuals are collected; those columns are not even requested from the portals. Sole proprietors are licensed under their own name, so a business name can be a person's name; that is the public license record each state publishes for verification.
Run summary
Stored under SUMMARY in the key-value store: mode, each state's status, source dataset, last refresh and rows read, rows left out by reason, counts by trade and status, lookups not found, and the caveats.
Data
Datasets published by the four state agencies on their open-data portals (Washington and Oregon in the public domain), read through each portal's public API. No login, no scraping of search pages, and one request per second per portal as the portals ask.
