Recapitulation

The Recapitulation dataset displays the data of summarized and consolidated information related to a construction contract.

This recapitulation includes information such as the unit of measurement, quantity of work completed, unit price, cost, and vendor information.

TxDOT uses this information to determine the amount work has been completed according to the contract specifications.

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/recapitulation-jxqk-9dmq\".\"recapitulation\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.