Dataset: San Francisco City Employee Salaries

About this Dataset

San Francisco City Employee Salaries

Employee Compensation
Metadata Updated: August 19, 2023

A. SUMMARY The San Francisco Controller's Office maintains a database of the salary and benefits paid to City employees since fiscal year 2013.

B. HOW THE DATASET IS CREATED This data is summarized and presented on the Employee Compensation report hosted at http://openbook.sfgov.org, and is also available in this dataset in CSV format.

C. UPDATE PROCESS New data is added on a bi-annual basis when available for each fiscal and calendar year.

D. HOW TO USE THIS DATASET Before using please first review the following two resources: Data Dictionary - Can be found in 'About this dataset' section after click 'Show More' Employee Compensation FAQ - https://support.datasf.org/help/employee-compensation-faq

License: https://opendatacommons.org/licenses/pddl/1-0/

Tables

Employee Compensation

@kaggle.joebeachcapital_san_francisco_city_employee_salaries.employee_compensation

55.62 MB
881800 rows
22 columns


CREATE TABLE employee_compensation (
  "organization_group_code" BIGINT,
  "job_family_code" VARCHAR,
  "job_code" VARCHAR,
  "year_type" VARCHAR,
  "year" BIGINT,
  "organization_group" VARCHAR,
  "department_code" VARCHAR,
  "department" VARCHAR,
  "union_code" DOUBLE,
  "union" VARCHAR,
  "job_family" VARCHAR,
  "job" VARCHAR,
  "employee_identifier" BIGINT,
  "salaries" DOUBLE,
  "overtime" DOUBLE,
  "other_salaries" DOUBLE,
  "total_salary" DOUBLE,
  "retirement" DOUBLE,
  "health_and_dental" DOUBLE,
  "other_benefits" DOUBLE,
  "total_benefits" DOUBLE,
  "total_compensation" DOUBLE
);