City-Parish Employees

City-Parish employees, both active and inactive, that exist in the City-Parish Payroll System. The information includes employee current pay information, including any special pay. Special pay is earned per pay period.

***In November of 2018, the City-Parish switched to a new payroll system. This dataset contains employee information from this new system. For data prior to 2018, please see the Legacy City-Parish Employees at https://data.brla.gov/Government/Legacy-City-Parish-Employees/gyhq-w3h3

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 \"brla-gov/cityparish-employees-bj3z-jksg\".\"cityparish_employees\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.