SF Salaries

One way to understand how a city government works is by looking at who it employs and how its employees are compensated. This data contains the names, job title, and compensation for San Francisco city employees on an annual basis from 2011 to 2014.

[](https://www.kaggle.com/benhamner/d/kaggle/sf-salaries/exploring-the-sf-city-salary-data)

## Exploration Ideas

To help get you started, here are some data exploration ideas:

- How have salaries changed over time between different groups of people?
- How are base pay, overtime pay, and benefits allocated between different groups?
- Is there any evidence of pay discrimination based on gender in this dataset?
- How is budget allocated based on different groups and responsibilities?

Have other ideas you're curious for someone else to explore? Post them in [this forum thread](https://www.kaggle.com/forums/f/977/sf-salaries/t/18264/sf-salaries-dataset).

## Data Description

sf-salaries-release-*.zip (downloadable via the "Download Data" link in the header above) contains a CSV table and a SQLite database (with the same data as the CSV file). Here's the [code that creates this data release](https://github.com/benhamner/sf-salaries).

The original source for this data is [here](http://transparentcalifornia.com/salaries/san-francisco/). We've taken the raw files here and combined/normalized them into a single CSV file as well as a SQLite database with an equivalently-defined table.

解读一座市政府运作机制的一种途径，便是审视其雇员构成及其薪酬支付方式。本数据集包含了2011年至2014年间，旧金山市政府雇员的姓名、职位以及年度薪酬信息。数据来源包括CSV表格和SQLite数据库，两者包含相同的数据。原始数据源自[透明加州网站](http://transparentcalifornia.com/salaries/san-francisco/)，我们已将原始文件合并/标准化，形成单一的CSV文件及对应的SQLite数据库表。