L&I Public Works Apprentice Utilization by US Government | Demographics and Population Studies

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

20.08 MB
275400 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,
  "project_name" VARCHAR,
  "contract" VARCHAR,
  "n__apprentice_utilization" DOUBLE,
  "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,
  "minority_hours" DOUBLE,
  "n__minority_utilization" DOUBLE,
  "veteran_hours" DOUBLE,
  "n__veteran_utilization" DOUBLE,
  "asbestos_abatement_workers" DOUBLE,
  "boilermakers" DOUBLE,
  "bricklayers_marble_masons" DOUBLE,
  "brick_and_marble_masons" DOUBLE,
  "brick_mason" DOUBLE,
  "building_service_employees" DOUBLE,
  "cabinet_makers_in_shop" DOUBLE,
  "carpenters" DOUBLE,
  "cement_masons" DOUBLE,
  "divers_tenders" DOUBLE,
  "dredge_workers" DOUBLE,
  "drywall_applicator" DOUBLE,
  "drywall_tapers" DOUBLE,
  "electrical_fixture_maintenance_workers" DOUBLE,
  "electricians_inside" DOUBLE,
  "electricians_motor_shop" DOUBLE,
  "electricians_powerline_construction" DOUBLE,
  "elevator_constructors" DOUBLE,
  "electronic_technicians" DOUBLE,
  "electronic_telecommunication_technicians" DOUBLE,
  "fabricated_precast_concrete_products" DOUBLE,
  "fence_erectors" DOUBLE,
  "flaggers" DOUBLE,
  "glaziers" DOUBLE,
  "heat_frost_insulators_and_asbestos_workers" DOUBLE,
  "heating_equipment_mechanics" DOUBLE,
  "hod_carriers_mason_tenders" DOUBLE,
  "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_by__7d1448a9" DOUBLE,
  "insulation_applicators" DOUBLE,
  "ironworkers" DOUBLE,
  "laborers" DOUBLE,
  "laborers_underground_sewer_water" DOUBLE,
  "landscape_construction" DOUBLE,
  "landscape_maintenance" DOUBLE,
  "lathers" DOUBLE,
  "machinists_hydroelectric_site_work" BIGINT,
  "marble_setters" DOUBLE,
  "metal_fabrication_in_shop" DOUBLE,
  "millwright" DOUBLE,
  "modular_buildings" DOUBLE,
  "painters" DOUBLE,
  "pile_driver" DOUBLE,
  "plasterers" DOUBLE,
  "playground_park_equipment_installers" DOUBLE,
  "plumbers_pipefitters" DOUBLE,
  "power_equipment_operators" DOUBLE,
  "power_equipment_operators_underground_sewer_water" DOUBLE,
  "power_line_clearance_tree_trimmers" DOUBLE,
  "residential_brick_mason" DOUBLE,
  "refrigeration_air_conditioning_mechanics" DOUBLE,
  "residential_drywall_applicators" DOUBLE,
  "residential_brick_marble_masons" BIGINT,
  "residential_carpenters" DOUBLE,
  "residential_drywall_tapers" DOUBLE,
  "residential_electricians" DOUBLE,
  "residential_electronic_telecommunication_technicians" DOUBLE,
  "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_refrigeration_air_conditioning_mechanics" DOUBLE,
  "residential_sheet_metal_workers" DOUBLE,
  "residential_soft_floor_layers" DOUBLE,
  "residential_sprinkler_fitters_fire_protection" DOUBLE,
  "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
);