State Employee Payroll Data, FY 2010-2014
Detailed compensation data for state employees from FY 2010-2014. Payroll data from 2015 through the present is available in this dataset: State Employee Payroll Data Calendar Year 2015 through Present (https://data.ct.gov/Government/State-Employee-Payroll-Data-Calendar-Year-2015-thr/virr-yb6n)
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 \"ct-gov/state-employee-payroll-data-fy-20102014-ajs4-6pgz\".\"state_employee_payroll_data_fy_20102014\"
LIMIT 100
"}
EOFSee the Splitgraph documentation
for more information.
