Employee Compensation (San Francisco)
San Francisco Controller's Office
Salary and benefits for every San Francisco city employee since fiscal 2013, by job and department.
A database of the salary and benefits paid to City employees since fiscal year 2013, maintained by the San Francisco Controller's Office. Rows are by employee and year with pay components, benefits, department, and job. Data is added twice a year, and it feeds the city's OpenBook report.
Access
- Cost
- FreeNo charge; open government data.
- License
- Open licenseOpen Data Commons Public Domain Dedication and License (PDDL) 1.0
- Sign-up
- No sign-up
- How you get it
- API and Bulk downloadCSV, JSON, XML
What's in it
- One row is
- One row per employee per year (and job)
- Covers
- City and County of San Francisco
- Years
- Fiscal year 2013-present
- Updated
- Annual
- Size
- Hundreds of thousands of rows
Quality
Clean, published with a data dictionary, and updated on a schedule. Rows are anonymized to job and department rather than named individuals.
- Does not name employees
- Updated only twice a year
Connects to
- Citywide Payroll Data (New York City): Compare with another large city's payroll
- State of Iowa Salary Book: Compare with a state's named salary data
- Occupational Employment and Wage Statistics (OES): Compare city pay with private-sector wages by occupation
Questions it could answer
- How much of total compensation goes to benefits by department?
- Which job families have the most overtime pay?