State of Iowa Executive Branch Full Time Equivalents by Month and Department

The dataset provides information on total full-time equivalents (FTE) for the State of Iowa - Executive Branch (including community based corrections), and those supported by the general fund, federal funds and other state funds starting with the pay period ending 12/23/2010. Counts are shown for the last pay period ending in the month. Two week long pay periods end every other Thursday.

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-full-time-rejw-2ccf\".\"state_of_iowa_executive_branch_full_time\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.