State of Iowa Executive Branch Comp Time, Holiday & Overtime Hours by Pay Period

This dataset includes hours of comp time earned, holiday earned and overtime paid for state employees within Executive Branch by pay period starting with the pay period ending July 8, 1999. Pay periods are two weeks long and end every other Thursday. Comp time and overtime reflect hours worked above an employee's regular work hours.

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-comp-time-holiday-kybj-gub8\".\"state_of_iowa_executive_branch_comp_time_holiday\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.