L&I Public Works Apprentice Utilization

L&I Public Works Apprentice Utilization tracks workforce participation on Washington State public works projects. The dataset is updated daily from weekly certified payroll reports for projects initiated after July 1, 2019. It provides interim data on apprentice hours, minority utilization percentages, and wages across numerous construction trades.

Use Cases

• Monitoring contractor compliance with apprentice hiring requirements using columns like '% Minority Utilization' and 'Minority Hours'.
• Analyzing wage patterns for specific trades on public works projects using columns like 'Apprentice Wages' and 'Residential Carpenters'.
• Linking project-level labor data across L&I datasets using the 'Prime Intent #' as a unique identifier.
• Tracking workforce participation across specialized trades using columns like 'Elevator Constructors', 'Sheet Metal Workers', and 'Cement Masons'.

Strengths

• Updated daily, providing near-real-time insight into payroll reporting.
• Contains detailed, trade-specific columns for over 30 construction occupations.
• Designed to link with other L&I public works datasets via a 'Project ID' (implied by description).

Limitations

• Explicitly does NOT provide final utilization, hour, or wage data for projects.
• Metadata conflicts exist: last update dates differ between platforms (2026-05-27 vs. 2026-04-12).
• Key metadata like row count, file size, license, and author are missing from all sources.

Provenance

Source

Washington State Department of Labor & Industries (L&I), via data.wa.gov.

Collection Method

Compiled from weekly certified payroll reports filed by contractors on public works projects.

Time Range

Projects where the prime's intent was filed on or after July 1, 2019.

Freshness

2026-05-27 14:04:50

Geography

Washington State, USA.