Name: L&I Affidavit Project Details
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

L&I Affidavit Project Details

Updated daily. Provide the project details for the Affidavit of Wages Paid filed by an employer/contractor for work performed on a public works project.
Organization: State of Washington
Last updated: 2020-11-10T17:20:09.996569
Tags: affidavit, agency, apprentice, contractor, labor-industries, prevailing-wage, public-works

Tables

Table 1

@usgov.state_of_washington_li_affidavit_project_details.table_1

169.8 MB
1,066,808 rows
44 columns

CREATE TABLE table_1 (
  "affidavit_id_number" BIGINT,
  "project_id" BIGINT,
  "awarding_agency_name" VARCHAR,
  "awarding_agency_address" VARCHAR,
  "awarding_agency_contact_person" VARCHAR,
  "agency_phone_number" VARCHAR,
  "prime_contractor_name" VARCHAR,
  "contractor_phone_number" VARCHAR,
  "contractor_license" VARCHAR,
  "contractor_s_ubi" VARCHAR,
  "project_bid_due_date" TIMESTAMP,
  "project_award_date" TIMESTAMP,
  "contract_name" VARCHAR,
  "contract_number" VARCHAR,
  "project_site_address" VARCHAR,
  "amount" DOUBLE,
  "intent_id" BIGINT,
  "affidavit_received_date" TIMESTAMP,
  "city" VARCHAR,
  "work_completion_date" VARCHAR,
  "contract_amount" DOUBLE,
  "did_owner_operators_perform_work" VARCHAR  -- Did Owner/Operators Perform Work?,
  "numberofownerworked" BIGINT,
  "formfiledby" VARCHAR,
  "allworksubcontracted" VARCHAR  -- AllWorkSubcontracted?,
  "anysubcontractor" VARCHAR  -- AnySubContractor?,
  "yourcompanyemployeesworked" VARCHAR  -- YourCompanyEmployeesWorked?,
  "anyapprentices" VARCHAR  -- AnyApprentices?,
  "n__apprentice_utilization" DOUBLE  -- % Apprentice Utilization,
  "omwbe_certification" BOOLEAN,
  "filingcompanylicense" VARCHAR,
  "filingcompanyubi" VARCHAR,
  "filingcompanyname" VARCHAR,
  "filingcompanyphone" VARCHAR,
  "phoneext" VARCHAR,
  "filngcompanyemail" VARCHAR,
  "filingcompanyaddress1" VARCHAR,
  "filingcompanyaddress2" VARCHAR,
  "filingcompanycity" VARCHAR,
  "filingcompanystate" VARCHAR,
  "filingcompanyzipcode" VARCHAR,
  "filingcompanyinsuranceaccount" VARCHAR,
  "work_start_date" VARCHAR,
  "prime_sintentnumber" DOUBLE
);