WA Health Care Professional Licenses (wa-professional-licenses)

Pull Washington health-care provider credentials - 2.45 million records from the WA Department of Health (free public open data), covering every credential DOH has issued: registered nurses (RN), licensed practical nurses (LPN), nursing assistants (CNA), physicians & surgeons, physician assistants, pharmacists, counselors, EMTs, dentists, and dozens more - including the full historical record, not just who's active today.

This is the public record behind the DOH's license lookup, packaged for verification and screening: does this person hold an active license? Has regulatory action been taken against a credential? How big is WA's nursing workforce?

Built for employers and staffing firms verifying licenses, credentialing and compliance teams, healthcare recruiters, insurers, regulators, researchers and market-intelligence users.

What this data is

Each record is one credential:

Field	Meaning
credentialType	e.g. Registered Nurse License, Physician And Surgeon License, Physician Assistant License, Pharmacist License, Counselor Registration, Emergency Medical Technician Certification
status	Active / Expired / Suspended / Revoked / Terminated / Pending...
lastName / firstName	License holder
credentialNumber	e.g. RN.RN.61687583.MSL
birthYear	Holder's birth year
firstIssued / lastIssued / expiration	Issuance and expiry dates
actionTaken	Yes / Pending / No - regulatory action against the license

Note on status: the corpus is the full history (1.5M expired records). The tool defaults to Active (~556k live licenses) - the useful slice. Set status=all to search everything, or filter to a specific state like Revoked or Suspended.

Typical questions it answers

• Is this nurse's license active? - name=Miller + credentialType=Registered Nurse (defaults Active).
• Physicians with regulatory action - credentialType=Physician And Surgeon + actionTaken=Yes, or status=Revoked.
• Has this credential number been sanctioned? - credentialNumber=... + status=all.
• How big is WA's active nursing workforce? - aggregate by credentialType -> RN 107k, CNA 59k, physicians 31k active.
• Workforce / license-status mix - aggregate by status -> Active vs Expired vs Suspended.

Aggregate mode

Turn on aggregate and it rolls up counts over the whole 2.45M-record corpus instantly:

Output field	Meaning
key	The credential type or status
credentials	Number of records in that group
pctOfTotal	Share of the (filtered) total

Group by credentialType (the workforce mix) or status (how many are active / under action).

Inputs (all optional)

Input	What it does
credentialType	Substring on type: Registered Nurse, Physician And Surgeon, Counselor...
status	Substring on status. Default Active; all = full history
name / lastName / firstName	Holder name (substring)
credentialNumber	Credential number (substring ok)
actionTaken	Yes / No / Pending - regulatory action
aggregate + groupBy	Roll up by credentialType / status -> credentials + share
maxResults	Cap records (default 200)

Low cost

From $0.001 per record - with a per-run charge cap so even a full-corpus aggregate can't surprise-bill.

The credential corpus is 2.45 million rows - every credential the state has issued, active or long-expired. The subtle part is status semantics: WA's own status values nest inside each other (Active, Inactive, Retired Active, Expired - Active MSL), so a naive "active" text match quietly pulls in ~12k credentials that are anything but active. We match the source's exact status vocabulary instead of substring-guessing, so an "active nurses in WA" query returns active nurses - and the profile fields (credential number, status, expiry) carry the real granularity behind the count.

Data source & freshness

• Source: data.wa.gov - WA Health Care Provider Credential (qxh8-f4bd, Socrata SODA API, free public, no login). The same public data DOH's license lookup shows.
• Update cadence: refreshed as DOH issues / renews / sanctions credentials.
• Coverage: DOH-regulated health-care professions in Washington state.