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-
*Notes:
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 https://data.splitgraph.com/sql/query/ddn \ -H "Content-Type: application/json" \ -d@-<<EOF {"sql": " SELECT * FROM \"vermont-gov/total-pay-and-expenses-fy20092014-dbyi-rak2\".\"total_pay_and_expenses_fy20092014\" LIMIT 100 "} EOF
See the Splitgraph documentation for more information.