Name: L&I Affidavit - Apprentice Level Worker Details
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

L&I Affidavit - Apprentice Level Worker Details

Apprentice Level Worker Details
Organization: State of Washington
Last updated: 2020-11-10T17:21:42.476276
Tags: affidavit, apprentice, hours, wage, worker

Tables

Table 1

@usgov.state_of_washington_li_affidavit_apprentice_level_work_f0be4561.table_1

9.82 MB
428,913 rows
14 columns

CREATE TABLE table_1 (
  "affidavit_id_number" BIGINT,
  "project_id" BIGINT,
  "apprentice_id_number" VARCHAR,
  "number_of_hours_worked" DOUBLE,
  "apprentice_occupation_name" VARCHAR,
  "apprentice_program_name" VARCHAR,
  "registered_state" VARCHAR,
  "hourly_wage_rate" DOUBLE,
  "hourly_fringe_benefits_rate" DOUBLE,
  "apprentice_beginning_hours_per_step" BIGINT,
  "apprentice_ending_hours_per_step" BIGINT,
  "job_classification" VARCHAR,
  "county_name" VARCHAR,
  "prevailing_wage_trade" VARCHAR
);