About this Dataset

L&I Public Works Project Details

Updated daily for all projects where the prime’s intent was filed on/after July 1, 2019. Fields beginning with “Final” will only have data populated once the Notice of Completion is filed by the Awarding Agency for the project. Use the Project ID as the unique identifier to link data from other L&I public works datasets.
Organization: State of Washington
Last updated: 2020-11-10T17:21:16.973149
Tags: apprentice, omwbe, prevailing-wage, project, public-works, utilization

Tables

Table 1

@usgov.state_of_washington_li_public_works_project_details.table_1

19.91 MB
274,236 rows
37 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 #,
  "contract_total" DOUBLE,
  "contract_type" VARCHAR,
  "bid_due_date" TIMESTAMP,
  "award_date" TIMESTAMP,
  "date_work_completed" TIMESTAMP,
  "n__of_contractors" BIGINT  -- # Of Contractors,
  "federally_funded" VARCHAR,
  "housing_act_of_1937" VARCHAR,
  "apprentice_utilization_required" VARCHAR  -- Apprentice Utilization Required?,
  "final_apprentice_utilization" DOUBLE  -- Final % Apprentice Utilization,
  "omwbe_utilization" VARCHAR,
  "final_omwbe_utilization" DOUBLE  -- Final % OMWBE Utilization,
  "noc_filed_date" TIMESTAMP,
  "bond_waived" VARCHAR,
  "retained_amount" DOUBLE,
  "retainage_waived_reduced" VARCHAR,
  "reduced_retainage" BIGINT  -- Reduced Retainage %,
  "final_journey_level_hours" DOUBLE,
  "final_apprentice_hours" DOUBLE,
  "final_total_hours" DOUBLE,
  "final_apprentice_wages" DOUBLE,
  "final_journey_level_wages" DOUBLE,
  "final_total_wages" DOUBLE,
  "final_female_hours" DOUBLE,
  "final_female_utilization" DOUBLE  -- Final % Female Utilization,
  "final_minority_hours" DOUBLE,
  "final_minority_utilization" DOUBLE  -- Final % Minority Utilization,
  "final_veteran_hours" DOUBLE,
  "final_veteran_utilization" DOUBLE  -- Final % Veteran Utilization
);