Open repository in Console
Readme
Updated 3 years ago
‧ Indexed 25 minutes ago
City Employee Payroll (2013-2018)
Note this dataset is no longer being updated. Please use the updated payroll dataset with current pay year information: https://controllerdata.lacity.org/Payroll/City-Employee-Payroll-Current-/g9h8-fvhu.
Payroll information for all Los Angeles City Employees including the City's three proprietary departments: Water and Power, Airports and Harbor. Data is updated on a quarterly basis by the Los Angeles City Controller's Office. Payroll information for employees of the Department of Water and Power is provided by the Department.
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-employee-payroll-20132018-pazn-qyym\".\"city_employee_payroll_20132018\" LIMIT 100 "} EOF
See the Splitgraph documentation for more information.
Upstream Metadata