Expenditure Category Numbers and Titles

This lists the broad categories of expenditure by 2-digit code and corresponding title. Expenditure Comptroller Objects are consolidated under these categories for presentation on Where-the-Money-Goes and the Texas Cash Report.

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/expenditure-category-numbers-and-titles-d57d-zxw6\".\"expenditure_category_numbers_and_titles\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.