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,243,556 records, verified September 27, 2026. Counts describe licensing records, not unique people or active licenses.

The trial contains the complete Connecticut extract in LICENSING.LICENSES_CT, with 3,998,567 records. It is a static snapshot created September 27, 2026. The full subscription adds Colorado, New York and Texas through LICENSING.LICENSES.

The full table 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: LICENSING.LICENSES_CT (trial) and LICENSING.LICENSES (full)

The trial and full tables use the same 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 LICENSING.LICENSES_CT
WHERE 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 LICENSING.LICENSES_CT
WHERE IS_CURRENT = TRUE
  AND LICENSE_SUBTYPE = 'REPLACE_WITH_LICENSE_SUBTYPE'
  AND LICENSE_NUMBER = 'REPLACE_WITH_LICENSE_NUMBER';

-- Check 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 LICENSING.LICENSES_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.

For full coverage or questions about this dataset: [email protected]