About this Dataset

L&I Public Works Apprentice Utilization

Updated daily based on weekly certified payroll reports filed for all projects where the prime’s intent was filed on/after July 1, 2019. Use the Project ID as the unique identifier to link data from other L&I public works datasets. Important: This DOES NOT provide the FINAL utilization, hour, or wage data for the project.
Organization: State of Washington
Last updated: 2021-08-07T14:13:45.015985
Tags: apprentice, omwbe, prevailing-wage, project, public-works, trades, utilization

Tables

Table 1

@usgov.state_of_washington_li_public_works_apprentice_utilization.table_1

21.06 MB
275,400 rows
119 columns

CREATE TABLE table_1 (
  "project_id" BIGINT,
  "awarding_agency_name" VARCHAR,
  "agency_category_type" VARCHAR,
  "prime_contractor_name" VARCHAR,
  "prime_contractor_ubi" BIGINT,
  "prime_intent" BIGINT  -- Prime Intent #,
  "project_name" VARCHAR,
  "contract" VARCHAR  -- Contract #,
  "n__apprentice_utilization" DOUBLE  -- % Apprentice Utilization,
  "journey_level_hours" DOUBLE,
  "apprentice_hours" DOUBLE,
  "total_hours" DOUBLE,
  "apprentice_wages" DOUBLE,
  "journey_level_wages" DOUBLE,
  "total_wages" DOUBLE,
  "female_hours" DOUBLE,
  "n__female_utilization" DOUBLE  -- % Female Utilization,
  "minority_hours" DOUBLE,
  "n__minority_utilization" DOUBLE  -- % Minority Utilization,
  "veteran_hours" DOUBLE,
  "n__veteran_utilization" DOUBLE  -- % Veteran Utilization,
  "asbestos_abatement_workers" DOUBLE,
  "boilermakers" DOUBLE,
  "bricklayers_marble_masons" DOUBLE  -- Bricklayers & Marble Masons,
  "brick_and_marble_masons" DOUBLE,
  "brick_mason" DOUBLE,
  "building_service_employees" DOUBLE,
  "cabinet_makers_in_shop" DOUBLE  -- Cabinet Makers (In Shop),
  "carpenters" DOUBLE,
  "cement_masons" DOUBLE,
  "divers_tenders" DOUBLE  -- Divers & Tenders,
  "dredge_workers" DOUBLE,
  "drywall_applicator" DOUBLE,
  "drywall_tapers" DOUBLE,
  "electrical_fixture_maintenance_workers" DOUBLE,
  "electricians_inside" DOUBLE  -- Electricians - Inside,
  "electricians_motor_shop" DOUBLE  -- Electricians - Motor Shop,
  "electricians_powerline_construction" DOUBLE  -- Electricians - Powerline Construction,
  "elevator_constructors" DOUBLE,
  "electronic_technicians" DOUBLE,
  "electronic_telecommunication_technicians" DOUBLE  -- Electronic & Telecommunication Technicians,
  "fabricated_precast_concrete_products" DOUBLE,
  "fence_erectors" DOUBLE,
  "flaggers" DOUBLE,
  "glaziers" DOUBLE,
  "heat_frost_insulators_and_asbestos_workers" DOUBLE  -- Heat & Frost Insulators And Asbestos Workers,
  "heating_equipment_mechanics" DOUBLE,
  "hod_carriers_mason_tenders" DOUBLE  -- Hod Carriers & Mason Tenders,
  "industrial_engine_and_machine_mechanics" DOUBLE,
  "industrial_power_vacuum_cleaner" DOUBLE,
  "inland_boatmen" DOUBLE,
  "inspection_cleaning_sealing_of_sewer_water_systems" BIGINT  -- Inspection, Cleaning, Sealing Of Sewer & Water Systems,
  "inspection_cleaning_sealing_of_sewer_water_systems_by__7d1448a9" DOUBLE  -- Inspection, Cleaning, Sealing Of Sewer & Water Systems By Remote Control,
  "insulation_applicators" DOUBLE,
  "ironworkers" DOUBLE,
  "laborers" DOUBLE,
  "laborers_underground_sewer_water" DOUBLE  -- Laborers - Underground Sewer & Water,
  "landscape_construction" DOUBLE,
  "landscape_maintenance" DOUBLE,
  "lathers" DOUBLE,
  "machinists_hydroelectric_site_work" BIGINT  -- Machinists (Hydroelectric Site Work),
  "marble_setters" DOUBLE,
  "metal_fabrication_in_shop" DOUBLE  -- Metal Fabrication (In Shop),
  "millwright" DOUBLE,
  "modular_buildings" DOUBLE,
  "painters" DOUBLE,
  "pile_driver" DOUBLE,
  "plasterers" DOUBLE,
  "playground_park_equipment_installers" DOUBLE  -- Playground & Park Equipment Installers,
  "plumbers_pipefitters" DOUBLE  -- Plumbers & Pipefitters,
  "power_equipment_operators" DOUBLE,
  "power_equipment_operators_underground_sewer_water" DOUBLE  -- Power Equipment Operators- Underground Sewer & Water,
  "power_line_clearance_tree_trimmers" DOUBLE,
  "residential_brick_mason" DOUBLE,
  "refrigeration_air_conditioning_mechanics" DOUBLE  -- Refrigeration & Air Conditioning Mechanics,
  "residential_drywall_applicators" DOUBLE,
  "residential_brick_marble_masons" BIGINT  -- Residential Brick & Marble Masons,
  "residential_carpenters" DOUBLE,
  "residential_drywall_tapers" DOUBLE,
  "residential_electricians" DOUBLE,
  "residential_electronic_telecommunication_technicians" DOUBLE  -- Residential Electronic & Telecommunication Technicians,
  "residential_glaziers" DOUBLE,
  "residential_insulation_applicators" DOUBLE,
  "residential_laborers" DOUBLE,
  "residential_cement_masons" DOUBLE,
  "residential_marble_setters" DOUBLE,
  "residential_stone_masons" DOUBLE,
  "residential_painters" DOUBLE,
  "residential_plumbers_pipefitters" DOUBLE  -- Residential Plumbers & Pipefitters,
  "residential_refrigeration_air_conditioning_mechanics" DOUBLE  -- Residential Refrigeration & Air Conditioning Mechanics,
  "residential_sheet_metal_workers" DOUBLE,
  "residential_soft_floor_layers" DOUBLE,
  "residential_sprinkler_fitters_fire_protection" DOUBLE  -- Residential Sprinkler Fitters (Fire Protection),
  "residential_terrazzo_tile_finishers" DOUBLE,
  "residential_terrazzo_tile_setters" BIGINT,
  "residential_tile_setters" DOUBLE,
  "residential_terrazzo_workers" BIGINT,
  "roofers" DOUBLE,
  "sheet_metal_workers" DOUBLE,
  "shipbuilding_ship_repair" DOUBLE  -- Shipbuilding & Ship Repair
);