Berkeley payroll data as reported on Transparent California, http://transparentcalifornia.com .
This dataset has the following 11 columns:
Column Name | API Column Name | Data Type | Description | Sample Values |
---|---|---|---|---|
Employee Name | employee_name | text | PETER S BAILEY ROMEO C MOSCARDON YASSIR CHADLY PAMELA M BOLAND VALARIE CAREY view top 100 | |
Job Title | job_title | text | POLICE OFFICER OFFICE SPECIALIST II FIREFIGHTER FIRE APPARATUS OPERATOR SOLID WASTE WORKER view top 100 | |
Base Pay | base_pay | number | 115539.58 108897.36 114929.67 0 101317.58 view top 100 | |
Overtime Pay | overtime_pay | number | The “Overtime pay” column includes overtime compensation as the reporting agency classifies it. | 0 791.06 193.69 314.92 366.72 view top 100 |
Other Pay | other_pay | number | The "Other pay" category includes the compensation in the numerous other pay categories some public employees receive. | 0 200 1400 7124.4 700 view top 100 |
Total Benefits | total_benefits | number | "Total benefits" only includes benefits directly received by the employee: medical insurance (health, dental, and vision) and employer-paid retirement contributions. The total cost of the employee will be higher than the values reported here as there are associated costs (such as workman's comp, state unemployment insurance, medicare/SS costs, etc) that we do not report as employee compensation. | 0 41223.27 636.35 2651.1 36875.6 view top 100 |
Total Pay | total_pay | number | 0 57761.08 18000.06 67144.22 29694.09 view top 100 | |
Total Pay & Benefits | total_pay_benefits | number | The "Total pay & benefits" column underreports the total compensation of government employees whose government employer did not provided complete salary or benefit information. | 18636.41 2651.1 0 479.5 648.98 view top 100 |
Year | year | calendar_date | 2012-01-01T00:00:00.000 2011-01-01T00:00:00.000 2013-01-01T00:00:00.000 view top 100 | |
Notes | notes | text | view top 100 | |
Agency | agency | text | Berkeley view top 100 |