Dark Mode
San Francisco Public Employee Compensation: 2011–2019
Data Science and Analytics
Tags and Keywords
Trusted By
"No reviews yet"
Free
About
Presents detailed salary and compensation data for public employees working for the City of San Francisco, California. The data spans a nine-year period, allowing for analysis of compensation trends, payroll structures, and variations across different job titles within the public sector. It includes various pay components, benefits, and figures relating to pension debt.
Columns
The dataset features ten distinct fields related to employee compensation:
- Employee Name: The name of the individual employee. This field contains approximately 135,000 unique values.
- Job Title: The specific role held by the employee. Transit Operator and Special Nurse are frequently occurring job roles.
- Base Pay: The regular pay component. The mean value is about £70,700, though minimums are negative and maximums exceed £592,000.
- Overtime Pay: The component related to overtime earnings, with a mean of around £5,860.
- Other Pay: Additional pay components, averaging about £3,470.
- Total Pay: The overall gross pay, calculated as the sum of base, overtime, and other pay, with a mean of roughly £79,900.
- Benefits: The monetary value of other benefits, averaging £25,300.
- Pension debt: The component detailing pension debt.
- Total Pay & Benefits: The overall sum of total pay and benefits. The mean value is approximately £102,000, and the maximum recorded value approaches £713,000.
- Year: The calendar year the compensation data belongs to, ranging from 2011 to 2019.
- Status: Indicates employment status (FT for Full Time, PT for Part Time). Note that 42% of records are missing a status value.
Distribution
This dataset contains 357,407 records detailing employee compensation. The information is typically provided in a CSV file format, measuring 32.99 MB. The data structure is based on 10 distinct compensation fields. While pay fields are generally intact, the benefits column shows a 10% mismatch rate, and the employment status column has a significant proportion of missing data.
Usage
This data is highly valuable for economic analysis, governmental transparency projects, and labour studies. Ideal applications include:
- Tracking salary fluctuations and growth across the public sector from 2011 to 2019.
- Benchmarking municipal employee wages against similar roles in other regions or sectors.
- Analysing variations and equity in pay across different job titles and employment statuses.
- Studying the allocation of public funds via payroll, overtime, and benefits.
Coverage
The geographic focus is California, specifically pertaining to public employee salaries within San Francisco City. The data time range spans nine years, from 2011 through 2019. The dataset is generally expected to receive updates on an annual basis.
License
CC0: Public Domain
Who Can Use It
- Researchers and Academics: For detailed studies on public finance, labour economics, and municipal budgeting.
- Data Scientists: For building predictive models focused on public payroll trends and cost analysis.
- Citizens and Civic Watchdogs: For monitoring governmental spending and ensuring accountability in public compensation.
- Journalists: For investigative reporting focused on high-earning public officials or significant shifts in municipal spending.
Dataset Name Suggestions
- San Francisco Public Employee Compensation: 2011–2019
- SF City Payroll Data Analysis (2011–2019)
- California Public Employee Salaries: San Francisco (Nine Year Span)
Attributes
Original Data Source: San Francisco Public Employee Compensation: 2011–2019
QUALITYLoading...