City Bonus Codes

A listing of the different "bonus codes" that supplement the pay of City employees, not including DWP. DWP Pay Codes are available here: https://controllerdata.lacity.org/Payroll/Department-of-Water-and-Power-DWP-Pay-Codes/jwzw-nd84

The Category field indicates which column of the Payroll dataset (https://controllerdata.lacity.org/Payroll/Payroll/8hc2-qe2x) that particular pay code relates to. Pay codes are governed by the Memorandums of Understanding (MOUs) between the City and its labor representatives; State, City and Federal law; and Departmental policy.

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 \"controllerdata-lacity/city-bonus-codes-6k96-anmy\".\"city_bonus_codes\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.