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.
Querying over HTTP
Splitgraph serves as an HTTP API that lets you run SQL queries directly on
this data to power Web applications. For example:
curl https://data.splitgraph.com/sql/query/ddn \
-H "Content-Type: application/json" \
-d@-<<EOF
{"sql": "
SELECT *
FROM \"wa-gov/li-public-works-project-details-qp8s-a5uf\".\"li_public_works_project_details\"
LIMIT 100
"}
EOFSee the Splitgraph documentation
for more information.
