US State Professional Licensing Records

About this dataset

What’s in the listing

Civly compiles public professional and occupational licensing records from Colorado, Connecticut, New York and Texas into a consistent table. The bundle contains 10,253,359 records. Counts describe licensing records, not unique people or active licenses.

One view, PROFESSIONAL_LICENSING.LICENSES, serves the trial and the subscription. During the free 30-day trial it returns every Connecticut record, 4,003,083 in all. Subscribers also see Colorado, New York and Texas.

The data is checked for source changes weekly. Publication by the issuing authority and Civly's collection dates may differ. Each record includes a source dataset identifier and collection timestamps. Source and board coverage varies within each state.

Coverage

Records by issuing state

Schema

Data dictionary: PROFESSIONAL_LICENSING.LICENSES

One view serves the trial and the subscription. During the free trial it returns Connecticut only. Subscribers see all four states. 37 columns. Field availability varies by source.

Matching

Matching records

A license number alone is not a universal identifier. Connecticut numbers can repeat across credential types. Match on source, state, license subtype and number, then review the holder name and other identifying fields.

License and discipline dates remain source text because formats vary. CREATED_AT and UPDATED_AT are Snowflake timestamps describing Civly's collection. They are not license approval dates.

Getting started

Sample queries

After installing, set your worksheet's database selector to the installed database. These queries then run as written. Replace placeholder values with the credential you are checking.

-- Connecticut license records by type and status
SELECT LICENSE_TYPE, STATUS, COUNT(*) AS RECORDS
FROM PROFESSIONAL_LICENSING.LICENSES
WHERE STATE = 'CT' AND IS_CURRENT = TRUE
GROUP BY LICENSE_TYPE, STATUS
ORDER BY RECORDS DESC;

-- Count matches for a Connecticut credential
SELECT COUNT(*) AS MATCHING_LICENSE_RECORDS
FROM PROFESSIONAL_LICENSING.LICENSES
WHERE STATE = 'CT' AND IS_CURRENT = TRUE
  AND LICENSE_SUBTYPE = 'REPLACE_WITH_LICENSE_SUBTYPE'
  AND LICENSE_NUMBER = 'REPLACE_WITH_LICENSE_NUMBER';

-- Check Connecticut source coverage and collection dates
SELECT SOURCE_DATASET_ID, COUNT(*) AS RECORDS,
       COUNT_IF(IS_CURRENT) AS CURRENT_SOURCE_RECORDS,
       MIN(CREATED_AT) AS EARLIEST_COLLECTION,
       MAX(UPDATED_AT) AS LATEST_COLLECTION_UPDATE
FROM PROFESSIONAL_LICENSING.LICENSES
WHERE STATE = 'CT'
GROUP BY SOURCE_DATASET_ID
ORDER BY RECORDS DESC;

Provenance

Sourcing and attribution

Records originate from state open-data portals. Use STATE with SOURCE_DATASET_ID to identify the issuing source. The address state is stored separately in LIC_STATE. Sources include Colorado open data, Connecticut licensing data, New York open data, and Texas open data.

Questions about this dataset: matthew@civly.ai