Icon for Socrata external plugin
Open repository in Console
Updated 2 years ago
Indexed 3 hours ago

Total Pay and Expenses FY2009-2014

State employee salary and expense reimbursement information for the fiscal years 2009 through 2014. Starting with fiscal year 2015, this data is in a new data set with additional benefits data, please see data set: Total Compensation and Expenses FY2015-19 and Total Compensation and Expenses FY2020-


From time to time, pay categories for reporting purposes are reviewed and adjusted. Paid leave has been re-categorized from "other pay" to "pay." Total pay is not affected.

Base pay for certain law enforcement positions includes premium pay at overtime rates for a specified number of regularly scheduled hours  each pay period.   Within FY13/14, categorization of this premium base pay has been reviewed and adjusted. It has been re-categorized to "pay" from "overtime." Total pay is not affected. It was adjusted back to "overtime" in Jan.2014

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 \
    -H "Content-Type: application/json" \
{"sql": "
    SELECT *
    FROM \"vermont-gov/total-pay-and-expenses-fy20092014-dbyi-rak2\".\"total_pay_and_expenses_fy20092014\"
    LIMIT 100 

See the Splitgraph documentation for more information.

  • total_pay_and_expenses_fy20092014