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

About this Dataset

L&I Apprenticeship Apprentice Details

Updated monthly for all Washington State registered apprentices. Use the Program ID and Program Occupation ID as the unique identifier to link data from other L&I Apprenticeship datasets.
Organization: State of Washington
Last updated: 2020-11-10T17:21:04.125325
Tags: apprentice, apprenticeship, labor, labor-industries

Tables

Table 1

@usgov.state_of_washington_arts_public_data.table_1

7.13 MB
127,651 rows
49 columns

CREATE TABLE table_1 (
  "apprentice_id" BIGINT,
  "last_name" VARCHAR,
  "first_name" VARCHAR,
  "middle_initial" VARCHAR,
  "program_id" BIGINT,
  "program_name" VARCHAR,
  "occupation_id" BIGINT,
  "occupation_name" VARCHAR,
  "standard_occupational_classification" VARCHAR,
  "registration_date" TIMESTAMP,
  "transfer_date" TIMESTAMP,
  "work_start_date" TIMESTAMP,
  "current_status" VARCHAR,
  "current_status_date" TIMESTAMP,
  "term_in_hours" DOUBLE,
  "previous_work_hours_credit" DOUBLE,
  "additional_work_hours_credit" DOUBLE,
  "ojt_work_hours_reported" DOUBLE,
  "work_hours_not_recorded_elsewhere" DOUBLE,
  "total_ojt_hours" DOUBLE,
  "rsi_reported_hours" DOUBLE,
  "rsi_other_hours" DOUBLE,
  "total_rsi_hours" DOUBLE,
  "sex" VARCHAR,
  "race" VARCHAR,
  "ethnicity" VARCHAR,
  "veteran" VARCHAR,
  "education_level" VARCHAR,
  "initial_step" DOUBLE,
  "initial_step_eff_date" TIMESTAMP,
  "current_step" DOUBLE,
  "current_step_eff_date" VARCHAR,
  "probation_start_date" TIMESTAMP,
  "probation_end_date" VARCHAR,
  "hours_at_time_of_probation_end_date" DOUBLE,
  "employer_id" DOUBLE,
  "employer_name" VARCHAR,
  "employment_start_date" TIMESTAMP,
  "special_registration_reason" VARCHAR,
  "special_program_identification" VARCHAR,
  "other_license" VARCHAR,
  "county" VARCHAR,
  "zip_code" VARCHAR,
  "direct_entry_flag" VARCHAR,
  "public_employee" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "programoccupationid" DOUBLE,
  "cancel_reason" VARCHAR
);