Name: L&I Contractor License Data - Insurance
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

L&I Contractor License Data - Insurance

State of Washington, Labor & Industries contractor license and insurance data
Organization: State of Washington
Last updated: 2020-11-10T17:20:22.339415
Tags: contractor, labor-industries, li, license, lni

Tables

Table 1

@usgov.state_of_washington_li_contractor_license_data_insurance.table_1

4.09 MB
75367 rows
18 columns


CREATE TABLE table_1 (
  "businessname" VARCHAR,
  "contractorlicensenumber" VARCHAR,
  "contractorlicensetypecode" VARCHAR,
  "contractorlicensetypecodedesc" VARCHAR,
  "licensestatus" VARCHAR,
  "licensestatusdesc" VARCHAR,
  "ubi" BIGINT,
  "insurancecompany" VARCHAR,
  "insurancepolicyno" VARCHAR,
  "insuranceamt" BIGINT,
  "effectivedate" TIMESTAMP,
  "expirationdate" VARCHAR,
  "canceldate" VARCHAR,
  "createdate" TIMESTAMP,
  "createdby_waoic_id" VARCHAR,
  "lastupdatedate" TIMESTAMP,
  "updatedby_waoic_id" VARCHAR,
  "insuranceagencyname" VARCHAR
);