Employee Compensation

Standard, overtime, and other pay totals for Ramsey County employees by year. This data includes deferred compensation and pandemic pay as part of an employee's overall compensation. It does not include vaccination incentives or COVID-19 testing payments.

Employees with start dates of "Jan 1, 1901" are missing an official start date in their record and we are working to update this 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 \"ramseycounty-us/employee-compensation-j6yb-2znn\".\"employee_compensation\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.