City-Parish Employee Annual Salaries

City-Parish employees' annual salaries and other payroll related information. Information is calculated after the last payroll is run for the year specified. Some fields, such as job title and department, are accurate as of the time the data was captured for Open Data BR. For example, if an employee worked for three departments throughout the year, only the department they worked for at the time we collected the data will be shown.

***In November of 2018, the City-Parish switched to a new payroll system. This data contains employee information from 2018 onward. For prior year data, please see the Legacy City-Parish Employee Annual Salaries https://data.brla.gov/Government/Legacy-City-Parish-Employee-Annual-Salaries/g5c2-myyj

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-employee-annual-salaries-g9vh-zeiw\".\"cityparish_employee_annual_salaries\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.