mydata-iowa-gov/state-of-iowa-expenditures-mn9y-cwp6
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated 2 months ago
Indexed 1 month ago

State of Iowa Expenditures

This dataset provides summarized data for all expenditures from July 2003 through the current fiscal year, year to date, from the State of Iowa's central accounting system. The state fiscal year runs from July 1 to the following June 30 and is numbered for the calendar year in which it ends. The State of Iowa operates on a modified accrual basis which provides that encumbrances on June 30 must be paid within 60 days after year end. The expenditures are summarized by Fiscal Year, Month, Fund, Appropriation, Department, Unit, and Object Class.

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 \"mydata-iowa-gov/state-of-iowa-expenditures-mn9y-cwp6\".\"state_of_iowa_expenditures\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • state_of_iowa_expenditures
     
     
     
     
     
Upstream Metadata