Name: State Licenses And Credentials
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

State Licenses And Credentials

Licenses and Credentials recorded in Connecticut's eLicensing system.

Updated daily.
Organization: State of Connecticut
Last updated: 2020-11-12T14:57:02.804601
Tags: credential, das, dcp, elicense, license

Tables

Table 1

@usgov.state_of_connecticut_state_licenses_and_credentials.table_1

174.93 MB
2530978 rows
21 columns


CREATE TABLE table_1 (
  "credentialid" BIGINT,
  "name" VARCHAR,
  "type" VARCHAR,
  "businessname" VARCHAR,
  "dba" VARCHAR,
  "fullcredentialcode" VARCHAR,
  "credentialtype" VARCHAR,
  "credentialnumber" VARCHAR,
  "credentialsubcategory" VARCHAR,
  "credential" VARCHAR,
  "status" VARCHAR,
  "statusreason" VARCHAR,
  "active" BIGINT,
  "issuedate" TIMESTAMP,
  "effectivedate" TIMESTAMP,
  "expirationdate" VARCHAR,
  "address" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip" VARCHAR,
  "recordrefreshedon" TIMESTAMP
);