Dataset: SF Salary Ranges By Job Classification

About this Dataset

SF Salary Ranges By Job Classification

Content

Shows the job titles associated with job classifications. Used with the Job Titles by Classification and Employees by Classification

Context

This is a dataset hosted by the city of San Francisco. The organization has an open data platform found here and they update their information according the amount of data that is brought in. Explore San Francisco's Data using Kaggle and all of the data sources available through the San Francisco organization page!

Update Frequency: This dataset is updated quarterly.

Acknowledgements

This dataset is maintained using Socrata's API and Kaggle's API. Socrata has assisted countless organizations with hosting their open data and has been an integral part of the process of bringing more data to the public.

Cover photo by Sharon McCutcheon on Unsplash
Unsplash Images are distributed under a unique Unsplash License.

Tables

Salary Ranges By Job Classification

@kaggle.san_francisco_sf_salary_ranges_by_job_classification.salary_ranges_by_job_classification

31.18 KB
1356 rows
13 columns


CREATE TABLE salary_ranges_by_job_classification (
  "setid" VARCHAR,
  "job_code" VARCHAR,
  "eff_date" TIMESTAMP,
  "sal_end_date" TIMESTAMP,
  "salary_setid" VARCHAR,
  "sal_plan" VARCHAR,
  "grade" VARCHAR,
  "step" BIGINT,
  "biweekly_high_rate" DOUBLE,
  "biweekly_low_rate" DOUBLE,
  "union_code" BIGINT,
  "extended_step" BIGINT,
  "pay_type" VARCHAR
);