Name: L&I Contractor License Data - General
Creator: US Government
License: http://opendatacommons.org/licenses/pddl/1.0/

About this Dataset

L&I Contractor License Data - General

State of Washington, Labor & Industries contractor license and registration data
Organization: State of Washington
Last updated: 2020-11-10T17:21:03.305275
Tags: contractor, labor-industries, li, licenses

Tables

Table 1

@usgov.state_of_washington_li_contractor_license_data_general.table_1

12.46 MB
157440 rows
23 columns


CREATE TABLE table_1 (
  "businessname" VARCHAR,
  "contractorlicensenumber" VARCHAR,
  "contractorlicensetypecode" VARCHAR,
  "contractorlicensetypecodedesc" VARCHAR,
  "address1" VARCHAR,
  "address2" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip" VARCHAR,
  "phonenumber" DOUBLE,
  "licenseeffectivedate" TIMESTAMP,
  "licenseexpirationdate" TIMESTAMP,
  "businesstypecode" VARCHAR,
  "businesstypecodedesc" VARCHAR,
  "specialtycode1" VARCHAR,
  "specialtycode1desc" VARCHAR,
  "specialtycode2" VARCHAR,
  "specialtycode2desc" VARCHAR,
  "ubi" BIGINT,
  "primaryprincipalname" VARCHAR,
  "statuscode" VARCHAR,
  "contractorlicensestatus" VARCHAR,
  "contractorlicensesuspenddate" TIMESTAMP
);