L&I Apprenticeship Occupation Details
State of Washington
@usgov.state_of_washington_li_apprenticeship_occupation_details
State of Washington
@usgov.state_of_washington_li_apprenticeship_occupation_details
Updated monthly for all Washington State registered apprenticeship programs. 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: 2021-08-07T13:53:19.207429
Tags: apprentice, apprenticeship
CREATE TABLE table_1 (
"programid" BIGINT,
"programname" VARCHAR,
"programoccupationid" BIGINT,
"occupationid" BIGINT,
"programstatus" VARCHAR,
"occupationname" VARCHAR,
"occupationstatus" VARCHAR,
"soccode" VARCHAR,
"socdescription" VARCHAR,
"termhours" DOUBLE,
"rsihours" DOUBLE,
"addeddate" VARCHAR,
"inactivedate" VARCHAR,
"step1wage" DOUBLE,
"journeywage" DOUBLE
);Anyone who has the link will be able to view this.