Total Compensation and Expenses FY2020 - 2023

State employee salary, benefits and expense reimbursement information starting with fiscal year 2020. For the purpose of this report, all employees of the Department of States Attorneys and Sheriffs are included. Employees in the respective county offices , such as States Attorneys, Sheriffs and Deputy States Attorneys are County employees not State employees.

To access the pay and expense data for Fiscal years 2009-2014, please see data set: Total Pay and Expenses FY2009-2014. To access the previous 5 years of this data set, please see: Total Compensation and Expenses FY2015-2019.

NOTE: Individuals covered by the Safe At Home Act (Title 15 Sections 1150-1160) have been excluded from this list.

2017 Change - Temporary employees now earn sick leave per 21 V.S.A. § 487.

This data set will be capped when it reaches five fiscal years of data.

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-compensation-and-expenses-fy2020-2023-2is8-zt8g\".\"total_compensation_and_expenses_fy2020_2023\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.