Data.WA

Close
Author
OCIO-Will Saunders
Description
Affidavit filed by an employer/contractor for work done on a public works project.
Category
Labor
Tags
contractor, affidavit, company, agency
Rating
Current value: 0 out of 5
Data Provided By
L&I
This view cannot be displayed
This view is currently private. You can preview it, but you will need to make it public before people will be able to see it.
Size
  • 500x425

  • 760x646

  • 950x808

Custom Size

425x425 is the minimum size

The Socrata Open Data API (SODA) provides programmatic access to this dataset including the ability to filter, query, and aggregate data. For more more information, view the API docs for this dataset or visit our developer portal

API Endpoint:

Field Names:

Awarding Agency Name
agencyname
Awarding Agency Address
agencyaddress
Awarding Agency Contact Person
agencycontact
Agency Phone Number
agencycontactphone
Prime Contractor Name
primecompany
Contractor Phone Number
primecompanyphone
Contractor License
primelicense
Contractor's UBI
primeubi
Project Bid Due Date
bidduedate
Project Award Date
awarddate
Contract Name
contractname
Contract Number
contractnumber
Project Site Address
projectlocation
Amount
amount
Intent ID
intent
Affidavit ID Number
id
Affidavit Received Date
formreceiveddate
City
city
Work Completion Date
projectcompletiondate
Contract Amount
contractamount
Did Owner/Operators Perform Work?
owner_operatorsworked
NumberOfOwnerWorked
numberofowner_operatorworked
FormFiledBy
formfiledby
AllWorkSubcontracted?
allworksubcontracted
AnySubContractor?
anysubcontractor
YourCompanyEmployeesWorked?
yourcompanyemployeesworked
AnyApprentices?
anyapprentices
FilingCompanyLicense
license
FilingCompanyUBI
ubi
FilingCompanyName
name
FilingCompanyPhone
phone
PhoneEXT
phoneext
FilngCompanyEmail
email
FilingCompanyAddress1
address1
FilingCompanyAddress2
address2
FilingCompanyCity
companycity
FilingCompanyState
state
FilingCompanyZipCode
zipcode
FilingCompanyInsuranceAccount
insuranceaccount
Work Start Date
workstartdate
Prime'sIntentNumber
prime_sintentnumber
AARAFundsUsed?
aarafundsused
WeatherizationFundsUsed?
weatherizationfundsused

Use OData to open the dataset in tools like Excel or Tableau. This provides a direct connection to the data that can be refreshed on-demand within the connected application.

Socrata OData documentation

Tableau users should select the OData v2 endpoint option.

OData V4 Endpoint:

OData V2 Endpoint:

You are viewing a mobile version of this dataset. To access the full dataset, tap here.