R8-Testing-Cancele or Changed Project List

The dataset of canceled or changed projects comprises those that have either been canceled or changed within the previous month due to shifts in estimated let dates or changes in project status.

canceled or changed projects dataset includes data in rolling previous 30 months.

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 \"texas-gov/r8testingcancele-or-changed-project-list-7ud2-scfm\".\"r8testingcancele_or_changed_project_list\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.