Professional and occupational license types in Colorado from the Department of Regulatory Agencies (DORA).
This dataset has the following 24 columns:
| Column Name | API Column Name | Data Type | Description | Sample Values |
|---|---|---|---|---|
| lastName | lastname | text | Last name of license holder | Smith Johnson Miller Brown Jones view top 100 |
| firstName | firstname | text | First name of license holder | Michael John Robert David James view top 100 |
| middleName | middlename | text | Middle name of license holder | L M A Marie Ann view top 100 |
| suffix | suffix | text | Suffix name of license holder | JR III II SR I view top 100 |
| entityName | entityname | text | Entity name provided by license holder | Great Clips Omnicare of Golden Fantastic Sams Omnicare of Pueblo Salon PS Colorado LLC view top 100 |
| city | city | text | City provided by license holder | Denver Colorado Springs Aurora DENVER Fort Collins view top 100 |
| state | state | text | State provided by license holder | CO CA TX FL AZ view top 100 |
| mailZipCode | mailzipcode | text | Zip provided by license holder | 80013 80525 80015 80134 80634 view top 100 |
| licensePrefix | licensetype | text | Type of license or professional certification with the state | RN NA COS APE DR view top 100 |
| subCategory | subcategory | text | Sub type of license or division of professional certification with the state | NP C-NP CRNA CNS CNM view top 100 |
| licenseNumber | licensenumber | text | Unique number assigned to license holder | 1 2 3 4 5 view top 100 |
| licenseFirstIssueDate | licensefirstissuedate | calendar_date | First date license holder obtained license | 2009-04-01T00:00:00.000 2020-03-30T00:00:00.000 1990-03-08T00:00:00.000 2009-01-01T00:00:00.000 2008-01-01T00:00:00.000 view top 100 |
| licenseLastRenewedDate | licenselastreneweddate | calendar_date | Most recent date license holder's license became effective | 2020-10-01T00:00:00.000 2021-11-01T00:00:00.000 2021-10-01T00:00:00.000 2021-05-01T00:00:00.000 2021-02-01T00:00:00.000 view top 100 |
| licenseExpirationDate | licenseexpirationdate | calendar_date | Expected expiration (and upcoming renewal date) license holder's license became effective | 2023-09-30T00:00:00.000 2023-10-31T00:00:00.000 2022-09-30T00:00:00.000 2023-04-30T00:00:00.000 2023-01-31T00:00:00.000 view top 100 |
| licenseStatusDescription | licensestatusdescription | text | Current status of license | Expired Active Cancelled Revoked Inactive view top 100 |
| specialty | specialty | text | Specialty of license holder | Fixed Location Family Civil Internal Medicine Family Medicine view top 100 |
| title | title | text | Title of license holder | view top 100 |
| degrees | degrees | text | Degree of license holder | ~Bachelors of Science in Nursing ~Associate Degree in Nursing ~Diploma in Nursing ~Medical Doctor ~Certificate in Nursing view top 100 |
| caseNumber | casenumber | text | Case Number, if present, is the case tracking number of a public action that may be attached to a record | 2019-43 2019-5983 2011-4804 2013-2567 2009-2647 view top 100 |
| programAction | programaction | text | Program Action, if present, is the type of public action that has been levied on a record | CLS Stipulation CLS Letter of Admonition CLS Revocation CLS Voluntary Surrender/Relinquishment ID Hearing Formal Complaint/Charges Filed with OAC view top 100 |
| disciplineEffectiveDate | disciplineeffectivedate | text | Effective date of the action | 06/13/1996 01/08/2018 05/21/2013 06/02/2015 02/20/2018 view top 100 |
| disciplineCompleteDate | disciplinecompletedate | text | Completion date of the action if it is a limited term action | 01/08/2018 06/01/2016 06/07/2017 01/25/2012 07/06/2012 view top 100 |
| linkToVerifyLicense | linktoverifylicense | url | URL to html page with dynamically updated details about the individual license | {"description":"Verify License","url":"https://www.colorado.gov/dora/licensing/Lookup/PrintLicenseDetails.aspx?cred=1245971&contact=444839"} {"description":"Verify License","url":"https://www.colorado.gov/dora/licensing/Lookup/PrintLicenseDetails.aspx?cred=422245&contact=471352"} view top 100 |
| linkToViewHealthcareProfile | linktoviewhealthcareprofile | url | URL to html page with dynamically updated details about the Healthcare Professional | {"description":"View Healthcare Profile","url":"https://www.colorado.gov/dora/licensing/SnapshotViewer.aspx?cid=425484&Key=57189A11-8DA2-4F0D-A5FE-763B33A123EE"} {"description":"View Healthcare Profile","url":"https://www.colorado.gov/dora/licensing/SnapshotViewer.aspx?cid=959997&Key=374DC433-DE78-4CE2-9572-255570DBCEEF"} {"description":"View Healthcare Profile","url":"https://www.colorado.gov/dora/licensing/SnapshotViewer.aspx?cid=1200136&Key=D4C0C35B-664D-42A4-98A8-38F02CD88E19"} {"description":"View Healthcare Profile","url":"https://www.colorado.gov/dora/licensing/SnapshotViewer.aspx?cid=969354&Key=968B2CE7-EFF0-44A4-BF53-9AFE1E284E0E"} {"description":"View Healthcare Profile","url":"https://www.colorado.gov/dora/licensing/SnapshotViewer.aspx?cid=418151&Key=1E59716C-E349-488D-B738-FF334AA002EF"} view top 100 |