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 
"}
EOF

See the Splitgraph documentation for more information.