- Data for State (and University of Connecticut) Payroll from 2010--2017 from http://transparency.ct.gov/html/downloads.asp
Each year has 3 files:
-
CT-Payroll-Earns-FY20XX.csv "This file contains the detailed earnings data for employees compensated in FY 2013. The data details earnings by employee, job description, and earnings type."
-
CT-Payroll-FY20XX.csv "This file contains compensation data for the fiscal year 2013. The file details employee wages and fringe benefits for all employees paid in the fiscal year 2013."
-
CT-Pensions-CY20XX.csv "This file contains pension data for the calendar year 2014. The file details the total pension amounts paid."
Note: Pension data is not available for 2017.
From the website:
"Employee Compensation is calculated from actual fiscal year payroll payments. Totals are for the fiscal year which runs from July 1 through June 30. Data will be updated annually after the end of the fiscal year. The total cost of state employees includes both compensation and fringe benefits. The fringe benefits amount reflect the employers costs for the normal cost of retirement, health insurance, group life insurance, FICA, Medicare, and unemployment compensation. In general these fringe benefits are calculated as a percentage of salary. Please note the fringe benefit amounts do not reflect costs associated with the state’s unfunded pension liability for the state’s defined benefit plans. Additional information on the individual components that make up both compensation and fringe benefits are described in the glossary.
Please note that the amounts shown may represent partial year totals if the employee was not employed for the full year or was employed by multiple agencies. Most state employees are supported entirely by the General Fund, which is the main operating fund of state government. However, some state employees are supported through other state funds or federal funds, in whole or in part."