L&I Contractor License - Principal Data

Dataset

Name Value
Catalog Link
Metadata Link
Data: JSON 100 Rows
Data: CSV 100 Rows
Host data.wa.gov
Id 4xk5-x9j6
Name L&I Contractor License - Principal Data
Attribution Washington State Department of Labor & Industries
Category Labor
Tags l&i, contractor, license
Created 2015-10-13T20:41:50Z
Publication Date 2015-10-30T17:05:23Z

Description

Addendum to L&I Contractor License Data - General. Principles are owners associated with a registered license number.

Columns

| Included | Schema Type    | Field Name                    | Name                          | Data Type     | Render Type   |
| ======== | ============== | ============================= | ============================= | ============= | ============= |
| Yes      | series tag     | businessname                  | BusinessName                  | text          | text          |
| Yes      | series tag     | contractorlicensenumber       | ContractorLicenseNumber       | text          | text          |
| Yes      | series tag     | contractorlicensetypecode     | ContractorLicenseTypeCode     | text          | text          |
| Yes      | series tag     | contractorlicensetypecodedesc | ContractorLicenseTypeCodeDesc | text          | text          |
| Yes      | series tag     | businesstypecode              | BusinessTypeCode              | text          | text          |
| Yes      | series tag     | businesstypecodedesc          | BusinessTypeCodeDesc          | text          | text          |
| Yes      | numeric metric | ubi                           | UBI                           | number        | number        |
| Yes      | series tag     | principalname                 | PrincipalName                 | text          | text          |
| Yes      | time           | startdate                     | StartDate                     | calendar_date | calendar_date |
| No       |                | enddate                       | EndDate                       | calendar_date | calendar_date |

Time Field

Value = startdate
Format & Zone = yyyy-MM-dd'T'HH:mm:ss

Series Fields

Excluded Fields = enddate

Data Commands

series e:4xk5-x9j6 d:2014-02-19T00:00:00.000Z t:contractorlicensetypecode=CC t:businessname="04 CONSTRUCTION LLC" t:businesstypecode=L t:contractorlicensenumber=04CONCL862CR t:contractorlicensetypecodedesc="CONSTRUCTION CONTRACTOR" t:principalname="Ochoa, Eric James" t:businesstypecodedesc="Limited Liability Company" m:ubi=603320569

series e:4xk5-x9j6 d:2014-01-03T00:00:00.000Z t:contractorlicensetypecode=CC t:businessname="1,2 Call Handyman Services LLC" t:businesstypecode=L t:contractorlicensenumber=1*2CACH865BC t:contractorlicensetypecodedesc="CONSTRUCTION CONTRACTOR" t:principalname="Moore, Anthony L" t:businesstypecodedesc="Limited Liability Company" m:ubi=603304731

series e:4xk5-x9j6 d:2010-04-28T00:00:00.000Z t:contractorlicensetypecode=CC t:businessname="100 ACRES LANDSCAPING" t:businesstypecode=I t:contractorlicensenumber=100ACAL903J8 t:contractorlicensetypecodedesc="CONSTRUCTION CONTRACTOR" t:principalname="FIGUEROA, JOSE REFUGIO" t:businesstypecodedesc=Individual m:ubi=602696920

Meta Commands

metric m:ubi p:integer l:UBI t:dataTypeName=number

entity e:4xk5-x9j6 l:"L&I Contractor License - Principal Data" t:attribution="Washington State Department of Labor & Industries" t:url=https://data.wa.gov/api/views/4xk5-x9j6

property e:4xk5-x9j6 t:meta.view v:id=4xk5-x9j6 v:category=Labor v:attributionLink=http://www.lni.wa.gov/TradesLicensing/Contractors/HireCon/default.asp v:averageRating=0 v:name="L&I Contractor License - Principal Data" v:attribution="Washington State Department of Labor & Industries"

property e:4xk5-x9j6 t:meta.view.license v:name="Public Domain"

property e:4xk5-x9j6 t:meta.view.owner v:id=u5wz-eny8 v:profileImageUrlMedium=/api/users/u5wz-eny8/profile_images/THUMB v:profileImageUrlLarge=/api/users/u5wz-eny8/profile_images/LARGE v:screenName=Estz235LI v:profileImageUrlSmall=/api/users/u5wz-eny8/profile_images/TINY v:displayName=Estz235LI

property e:4xk5-x9j6 t:meta.view.tableauthor v:id=u5wz-eny8 v:profileImageUrlMedium=/api/users/u5wz-eny8/profile_images/THUMB v:profileImageUrlLarge=/api/users/u5wz-eny8/profile_images/LARGE v:screenName=Estz235LI v:profileImageUrlSmall=/api/users/u5wz-eny8/profile_images/TINY v:roleName=editor v:displayName=Estz235LI

Top Records

| businessname                   | contractorlicensenumber | contractorlicensetypecode | contractorlicensetypecodedesc | businesstypecode | businesstypecodedesc      | ubi       | principalname                 | startdate           | enddate | 
| ============================== | ======================= | ========================= | ============================= | ================ | ========================= | ========= | ============================= | =================== | ======= | 
| 04 CONSTRUCTION LLC            | 04CONCL862CR            | CC                        | CONSTRUCTION CONTRACTOR       | L                | Limited Liability Company | 603320569 | Ochoa, Eric James             | 2014-02-19T00:00:00 |         | 
| 1,2 Call Handyman Services LLC | 1*2CACH865BC            | CC                        | CONSTRUCTION CONTRACTOR       | L                | Limited Liability Company | 603304731 | Moore, Anthony L              | 2014-01-03T00:00:00 |         | 
| 100 ACRES LANDSCAPING          | 100ACAL903J8            | CC                        | CONSTRUCTION CONTRACTOR       | I                | Individual                | 602696920 | FIGUEROA, JOSE REFUGIO        | 2010-04-28T00:00:00 |         | 
| 100 Oaks Nrsy Lndscp/Grdn Srvs | 100OAON875M5            | CC                        | CONSTRUCTION CONTRACTOR       | I                | Individual                | 600615685 | Hollingsworth, James Melford  | 2013-07-25T00:00:00 |         | 
| 100 WORKS LLC                  | 100WOWL901NE            | CC                        | CONSTRUCTION CONTRACTOR       | L                | Limited Liability Company | 603036471 | DETERING, BRADLEY NEIL        | 2010-08-05T00:00:00 |         | 
| 101 Pest Control LLC           | 101PEPC881MZ            | CC                        | CONSTRUCTION CONTRACTOR       | L                | Limited Liability Company | 603217463 | Mason, John R                 | 2012-07-09T00:00:00 |         | 
| 108 Contractors                | 108COC*861NR            | CC                        | CONSTRUCTION CONTRACTOR       | L                | Limited Liability Company | 603423944 | Sripha, Thon                  | 2014-08-19T00:00:00 |         | 
| 10Point Painting LLC           | 10POIPL865DM            | CC                        | CONSTRUCTION CONTRACTOR       | L                | Limited Liability Company | 603330386 | Amonson, Jason Ronald         | 2014-03-14T00:00:00 |         | 
| 10TH CASTLE LLC                | 10THCCL851D7            | CC                        | CONSTRUCTION CONTRACTOR       | L                | Limited Liability Company | 603488046 | MARTINEZ, FRANCISCO GUADALUPE | 2015-03-27T00:00:00 |         | 
| 10TH CASTLE LLC                | 10THCCL851D7            | CC                        | CONSTRUCTION CONTRACTOR       | L                | Limited Liability Company | 603488046 | MARTINEZ, VANESSA IASI        | 2015-03-27T00:00:00 |         |