About this Dataset

Building Codes Division - Active Contractor/Individual Licenses

Building Codes division provides this list of all active license holders as required by Oregon Revised Statute Chapter 192. License types include inspector code certifications and electrical, plumbing, boiler, elevator, prefab and manufactured dwelling contractor licenses for individuals and businesses.
Organization: State of Oregon
Last updated: 2020-11-10T17:23:13.965338
Tags: bcd, boiler, certification, contractor, electrical, elevator, license, licensee, plumbing

Tables

Table 1

@usgov.state_of_oregon_building_codes_division_active_contrac_4391f8c4.table_1

1.76 MB
46,761 rows
15 columns

CREATE TABLE table_1 (
  "licnbr" VARCHAR,
  "profession" VARCHAR,
  "lictype" VARCHAR,
  "full_name" VARCHAR,
  "dba" VARCHAR,
  "addr1" VARCHAR,
  "addr2" VARCHAR,
  "addr3" VARCHAR,
  "addr4" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zipcode" DOUBLE,
  "county" VARCHAR,
  "lic_status" VARCHAR,
  "expiration_date" VARCHAR
);