Texas State Expenditures By County 2014

Texas State Expenditures by County shows where state dollars are spent. It lists state expenditures by agency and type of expenditure in each county. This report was created using information from the state's Uniform Statewide Accounting System. It reflects actual net expenditures of funds from accounts held in the State Treasury during the state's fiscal year, Sept. 1 through Aug. 31.

The data is available through the Texas Open Data Portal, can be filtered as needed and is downloadable for further analysis. PDF file reports predating 2017 can be provided upon request by emailing transparency@cpa.texas.gov.

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/texas-state-expenditures-by-county-2014-y4e4-khfv\".\"texas_state_expenditures_by_county_2014\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.