State of Iowa Executive Branch Out-of-State Travel Reimbursements

Dataset provides information on out-of-state travel for State of Iowa Executive Branch employees including amount reimbursed, source of funds, time frame for traveling, purpose for traveling, and destination starting July 1, 2011 through current fiscal year, year to date. 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.

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-executive-branch-outofstate-travel-vtga-efxt\".\"state_of_iowa_executive_branch_outofstate_travel\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.