What’s Out There
← Back to swiping
Government & lawFreeState or local government

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
yeardepartmentjob familysalariesovertimeother payhealth and dentaltotal compensation

Quality

4 of 5

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?

Similar data sets

  • Los Angeles City Employee Payroll

    Pay for every Los Angeles city employee, including Water and Power, Airports, and Harbor, updated bi-weekly.

    Government & lawController, City of Los AngelesFree

  • Transparent California Public Pay and Pensions

    Name, title, and total pay for millions of California public employees, from city managers to lifeguards.

    Government & lawTransparent CaliforniaFree

  • NYC Citywide Payroll Data (Fiscal Year)

    Pay, overtime, and hours for every New York City employee, one row per person per fiscal year.

    Government & lawOffice of Payroll Administration (OPA), New York CityFree

  • Oregon Salaries of State Agencies Multi-Year Report

    Oregon state agency salaries over many fiscal years, by classification and service type.

    LaborDepartment of Administrative Services, State of OregonFree

  • Los Angeles City Revenue

    Los Angeles revenue by source and fund since fiscal 2012, budgeted against collected.

    Government & lawController's Office, City of Los AngelesFree

  • State of Vermont Employee Salaries

    Salaries for active Vermont state employees across all branches, including legislators on a weekly rate.

    LaborDepartment of Human Resources, State of VermontFree