This dataset is a listing of all active City of Chicago employees, complete with full names, departments, positions, employment status (part-time or full-time), frequency of hourly employee –where applicable—and annual salaries or hourly rate. Please note that "active" has a specific meaning for Human Resources purposes and will sometimes exclude employees on certain types of temporary leave. For hourly employees, the City is providing the hourly rate and frequency of hourly employees (40, 35, 20 and 10) to allow dataset users to estimate annual wages for hourly employees. Please note that annual wages will vary by employee, depending on number of hours worked and seasonal status. For information on the positions and related salaries detailed in the annual budgets, see https://www.cityofchicago.org/city/en/depts/obm.html
Data Disclosure Exemptions: Information disclosed in this dataset is subject to FOIA Exemption Act, 5 ILCS 140/7 (Link:https://www.ilga.gov/legislation/ilcs/documents/000501400K7.htm)
This dataset includes Baltimore City employee salaries and gross pay from fiscal year 2011 through last fiscal year and includes employees who were employed on June 30 of the last fiscal year. For fiscal years 2020 and prior, data are extracted from the ADP payroll system. For fiscal year 2023, the data are combined from the ADP system and the Workday enterprise resource planning system which now includes payroll.Change Log- Added FY2023 data- Metadata added- Columns renamed to a standard format- Youth workers not employed by City removed- Agency names reformatted with Workday conventions-7/25/24: Added FY2024 data. To leave feedback or ask a question about this dataset, please fill out the following form: Baltimore City Employee Salaries feedback form.
Attribution 4.0 (CC BY 4.0)https://creativecommons.org/licenses/by/4.0/
License information was derived automatically
Salaries of City of Milwaukee employees by year.
To download XML and JSON files, click the CSV option below and click the down arrow next to the Download button in the upper right on its page.
ODC Public Domain Dedication and Licence (PDDL) v1.0http://www.opendatacommons.org/licenses/pddl/1.0/
License information was derived automatically
Each year, the City of Boston publishes payroll data for employees. This dataset contains employee names, job details, and earnings information including base salary, overtime, and total compensation for employees of the City.
See the "Payroll Categories" document below for an explanation of what types of earnings are included in each category.
Data is collected because of public interest in how the City’s budget is being spent on salary and overtime pay for all municipal employees. Data is input into the City's Personnel Management System (“PMS”) by the respective user Agencies. Each record represents the following statistics for every city employee: Agency, Last Name, First Name, Middle Initial, Agency Start Date, Work Location Borough, Job Title Description, Leave Status as of the close of the FY (June 30th), Base Salary, Pay Basis, Regular Hours Paid, Regular Gross Paid, Overtime Hours worked, Total Overtime Paid, and Total Other Compensation (i.e. lump sum and/or retro payments). This data can be used to analyze how the City's financial resources are allocated and how much of the City's budget is being devoted to overtime. The reader of this data should be aware that increments of salary increases received over the course of any one fiscal year will not be reflected. All that is captured, is the employee's final base and gross salary at the end of the fiscal year. In very limited cases, a check replacement and subsequent refund may reflect both the original check as well as the re-issued check in employee pay totals.
NOTE 1: To further improve the visibility into the number of employee OT hours worked, beginning with the FY 2023 report, an updated methodology will be used which will eliminate redundant reporting of OT hours in some specific instances. In the previous calculation, hours associated with both overtime pay as well as an accompanying overtime “companion code” pay were included in the employee total even though they represented pay for the same period of time. With the updated methodology, the dollars shown on the Open Data site will continue to be inclusive of both types of overtime, but the OT hours will now reflect a singular block of time, which will result in a more representative total of employee OT hours worked. The updated methodology will primarily impact the OT hours associated with City employees in uniformed civil service titles. The updated methodology will be applied to the Open Data posting for Fiscal Year 2023 and cannot be applied to prior postings and, as a result, the reader of this data should not compare OT hours prior to the 2023 report against OT hours published starting Fiscal Year 2023. The reader of this data may continue to compare OT dollars across all published Fiscal Years on Open Data.
NOTE 2: As a part of FISA-OPA’s routine process for reviewing and releasing Citywide Payroll Data, data for some agencies (specifically NYC Police Department (NYPD) and the District Attorneys’ Offices (Manhattan, Kings, Queens, Richmond, Bronx, and Special Narcotics)) have been redacted since they are exempt from disclosure pursuant to the Freedom of Information Law, POL § 87(2)(f), on the ground that disclosure of the information could endanger the life and safety of the public servants listed thereon. They are further exempt from disclosure pursuant to POL § 87(2)(e)(iii), on the ground that any release of the information would identify confidential sources or disclose confidential information relating to a criminal investigation, and POL § 87(2)(e)(iv), on the ground that disclosure would reveal non-routine criminal investigative techniques or procedures. Some of these redactions will appear as XXX in the name columns.
This data does not necessarily represent current salaries of employees and is intended for informational purposes only. Formal requests to document salary details or other personnel information should be made through the City's Human Resources department. Earnings for all City employees, including elected officials and Court staff. Data since 2019 up to the most recent quarter of this year. Please note that since employee counts fluctuate throughout the year, the sum of the BASE_SALARY field does not reflect the total budgeted amount. Also, when the BASE_SALARY column is blank, it represents part-time, temporary, or seasonal employees paid by the hour. Please see metadata for detailed explanations of each field.
U.S. Government Workshttps://www.usa.gov/government-works
License information was derived automatically
City-Parish employees' annual salaries and other payroll related information. Information is calculated after the last payroll is run for the year specified. Some fields, such as job title and department, are accurate as of the time the data was captured for Open Data BR. For example, if an employee worked for three departments throughout the year, only the department they worked for at the time we collected the data will be shown.
***In November of 2018, the City-Parish switched to a new payroll system. This data contains employee information from 2018 onward. For prior year data, please see the Legacy City-Parish Employee Annual Salaries https://data.brla.gov/Government/Legacy-City-Parish-Employee-Annual-Salaries/g5c2-myyj
Attribution 4.0 (CC BY 4.0)https://creativecommons.org/licenses/by/4.0/
License information was derived automatically
This data is subject to change at any time due to personnel actions that are consistent with the City's approved Pay Plan. Employee compensation is limited to the following pay: regular wages, over time, productivity enhancement, shift differential, standby, incentive pay, allowances, and leave payouts. The data is a snapshot as of December 31st of the reported year.
Job descriptions, pay ranges, and benefits information is available at: https://www.phoenix.gov/hr/job-descriptions
Total compensation information is available at: https://www.phoenix.gov/hr/current-jobs/total-compensation-information
Employee terms by unit is available at: https://www.phoenix.gov/hr/employee-terms-by-unit
U.S. Government Workshttps://www.usa.gov/government-works
License information was derived automatically
Data Description: This dataset lists all current City of Cincinnati employees, including full names, department, position title, full-time employee status, employee age range, employee race, and annual salary rate.
Data Creation: This data is pulled directly from the City's HR software; which centralizes all department HR actions city wide.
Data Created By: City Human Resource Information System (CHRIS)
Refresh Frequency: Daily
CincyInsights: The City of Cincinnati maintains an interactive dashboard portal, CincyInsights in addition to our Open Data in an effort to increase access and usage of city data. This data set has an associated dashboard available here: https://insights.cincinnati-oh.gov/stories/s/Employee-Profile/wjqv-hgc9/
Data Dictionary: A data dictionary providing definitions of columns and attributes is available as an attachment to this dataset.
Processing: The City of Cincinnati is committed to providing the most granular and accurate data possible. In that pursuit the Office of Performance and Data Analytics facilitates standard processing to most raw data prior to publication. Processing includes but is not limited: address verification, geocoding, decoding attributes, and addition of administrative areas (i.e. Census, neighborhoods, police districts, etc.).
Data Usage: For directions on downloading and using open data please visit our How-to Guide: https://data.cincinnati-oh.gov/dataset/Open-Data-How-To-Guide/gdr9-g3ad
Open Data Commons Attribution License (ODC-By) v1.0https://www.opendatacommons.org/licenses/by/1.0/
License information was derived automatically
There are over 20,000 employees working for the City of Houston. This portal contains payroll information from 2018 to present.
The Payroll dataset includes information about the City of Houston employee payroll, including salary and year to date pay.
This page, or other pages, in this Open Payroll module will serve a function similar to the check register, including salary and year to date pay of the employees of the City for the considered calendar year. The data is provided in an anonymized way to protect the personal information of the employees of the City while providing relevant actual and statistical information.
Attribution 4.0 (CC BY 4.0)https://creativecommons.org/licenses/by/4.0/
License information was derived automatically
Analysis of ‘Baltimore City Employee Salaries’ provided by Analyst-2 (analyst-2.ai), based on source dataset retrieved from https://catalog.data.gov/dataset/09dd5c6e-6cc5-4322-adf7-8c0a6616dbc7 on 12 February 2022.
--- Dataset description provided by original source is as follows ---
This dataset includes Baltimore City employee salaries
and gross pay from fiscal year 2011 through last fiscal year and
includes employees who were employed on June 30 of the last fiscal year.
For fiscal years 2020 and prior, data are extracted from the ADP
payroll system. For fiscal year 2021, the data are combined from the ADP
system and the Workday enterprise resource planning system which now
includes payroll.
Change Log
2021-10-29:
- Added FY2021 data
- Metadata added
- Columns renamed to a standard format
- Youth workers not employed by City removed
- Agency names reformatted with Workday conventions
Data Dictionary
field_name | description | data_type | range_of_possible_values | example_values |
firstName | The first name of the employee. | Text | N/A | |
middleInitial | The middle initial of the employee. | Text | N/A | |
lastName | The last name of the employee. | Text | N/A | |
jobClass | The job classification of the employee. Job classifications are a standardized system of job responsibilities and pay and are frequently not the same as an employee's functional title. Participants in Youthworks who were not employed by the City are not included in this dataset. | Category | There are 1,898 unique job classficiations in this dataset. | "911 OPERATOR" ; "LABORER" ; "CDL DRIVER I" ; "OPERATIONS MANAGER III" |
agencyID | A unique identifier for the agency or department the employee works for. There is a one-to-one relationship between the agencyID and agencyName fields. | Text | There are 73 unique agencyID values corresponding to 73 unique agencyName values. | "A01" ; "A54"; "R01" |
agencyName | The name of the agency or department the employee works for. There is a one-to-one relationship between the agencyID and agencyName fields. The agencyID is typically a letter followed by two numbers though there are a few exceptions. | Text | There are 73 unique agencyID values corresponding to 73 unique agencyName values. | "Police Department" ; "Public Works - Solid Waste (weekly)" ; "Convention Center" |
hireDate | The date the employee was hired. | Date | 6/23/1951 through 6/30/2021 | 4/3/1979 |
annualSalary | The employee's base annual salary for the fiscal year. | Number | 0 through 276375 | |
grossPay | The total sum of compensation the employee received during the fiscal year. To be included in this dataset the employee must have earned more than $0.00 in the fiscal year. | Number | 1.71 through 373111.20 | |
fiscalYear | The fiscal year during which the employee worked for the city. Fiscal years for the City begin July 1 and end June 30 each year. Employees must have earned more than $0.00 during the fiscal year to be included for that year. | Category | FY2011 through FY2021 | "FY2021" |
--- Original source retains full ownership of the source dataset ---
U.S. Government Workshttps://www.usa.gov/government-works
License information was derived automatically
This dataset provides base salary information about City of Norfolk employees. This data is provided by Norfolk's Department of Human Resources and is updated daily.
Please click here for table and filtered views.This dataset contains current active employee data from the most recent semimonthly pay cycle. Information includes employee salary information and department.The City of Greensboro currently employs more than 3,500 people in a wide variety of jobs. We are proud to offer administrative positions, public safety jobs, technical careers, trades work, and more. We hire for all jobs based on qualifications, knowledge, skills, and abilities.The City of Greensboro appreciates our skilled and qualified workforce. We offer a competitive and generous benefits and compensation package.The City of Greensboro is an equal opportunity, affirmative action employer. (Read more about the City's Diversity and Inclusion program.) Additionally, the City is committed to a family-friendly and drug-free work place environment.Our Mission Statement Maximizing service excellence through human capital management.BenefitsAre you are an employee or are you are interested in employment with the City of Greensboro? Learn more about our benefits by viewing the latest Benefits Book.Careers If you are interested in a career with the City of Greensboro, please go to iApplyGreensboro to see current vacant positions. Read more about the application process. Top Requested DocumentsOverview of the City of Greensboro Total Compensation Program (with links to the executive and general, fire, and police pay structures)Benefits Book Job DescriptionsPolicy Manual
This dataset contains the range of salaries of full-time city staff, by department and title, as of July, 2014.
This dataset displays the current salaries for City of Little Rock employees. Some employees are hourly. Their pay is reflected as an hourly rate.
Current Employee Names, Salaries, and Position Titles records where Full or Part-Time is F.
This dataset has been published by the Human Resources Department of the City of Virginia Beach and data.virginiabeach.gov. The mission of data.virginiabeach.gov is to provide timely and accurate City information to increase government transparency and access to useful and well organized data by the general public, non-governmental organizations, and City of Virginia Beach employees.Distributed bydata.virginiabeach.gov2405 Courthouse Dr.Virginia Beach, VA 23456EntityEmployee SalariesPoint of ContactHuman ResourcesSherri Arnold, Human Resources Business Partner IIIsharnold@vbgov.com757-385-8804Elda Soriano, HRIS Analystesoriano@vbgov.com757-385-8597AttributesColumn: DepartmentDescription: 3-letter department codeColumn: Department DivisionDescription: This is the City Division that the position is assigned to.Column: PCNDescription: Tracking number used to reference each unique position within the City.Column: Position TitleDescription: This is the title of the position (per the City’s pay plan).Column: FLSA Status Description: Represents the position’s status with regards to the Fair Labor Standards Act (FLSA) “Exempt” - These positions do not qualify for overtime compensation – Generally, a position is classified as FLSA exempt if all three of the following criteria are met: 1) Paid at least $47,476 per year ($913 per week); 2) Paid on a salary basis - generally, salary basis is defined as having a guaranteed minimum amount of pay for any work week in which the employee performs any work; 3) Perform exempt job duties - Job duties are split between three classifications: executive, professional, and administrative. All three have specific job functions which, if present in the employee’s regular work, would exempt the individual from FLSA. Employees may also be exempt from overtime compensation if they are a “highly compensated employee” as defined by the FLSA or the position meets the criteria for other enumerated exemptions in the FLSA.“Non-exempt” – These positions are eligible for overtime compensation - positions classified as FLSA non-exempt if they fail to meet any of exempt categories specified in the FLSA. Column: Initial Hire DateDescription: This is the date that the full-time employee first began employment with the City.Column: Date in TitleDescription: This is the date that the full-time employee first began employment in their current position.Column: SalaryDescription: This is the annual salary of the full-time employee or the hourly rate of the part-time employee.Frequency of dataset updateMonthly
U.S. Government Workshttps://www.usa.gov/government-works
License information was derived automatically
City-Parish employees, both active and inactive, that exist in the City-Parish Payroll System. The information includes employee current pay information, including any special pay. Special pay is earned per pay period.
***In November of 2018, the City-Parish switched to a new payroll system. This dataset contains employee information from this new system. For data prior to 2018, please see the Legacy City-Parish Employees at https://data.brla.gov/Government/Legacy-City-Parish-Employees/gyhq-w3h3
ODC Public Domain Dedication and Licence (PDDL) v1.0http://www.opendatacommons.org/licenses/pddl/1.0/
License information was derived automatically
City employee base salary as of 2024-04-17. This was updated on 2024-04-17 to include compensation of Inter-Governmental Agencies (such as Poudre Fire Authority).
Starting with 2020 data, in an effort to provide greater consumable and comparable data we're moving away from reporting individual employee earnings and instead provide base salaries as assigned per position. Due to this change this dataset cannot be directly combined with previous years' earnings data. The data represents a snapshot of salaries as of 2024-01-16 rather than actual paid amounts in 2024. Personnel spending data can be found on openbook.fcgov.com
These data are for the contracted position of each employee and therefore don't account for interim roles; the City of Fort Collins pay policy states that the employees in interim roles may be making up to 6% more than the reported salary.
This dataset contains the range of salaries of full-time city staff, by department and title, as of June, 2013.
This dataset is a listing of all active City of Chicago employees, complete with full names, departments, positions, employment status (part-time or full-time), frequency of hourly employee –where applicable—and annual salaries or hourly rate. Please note that "active" has a specific meaning for Human Resources purposes and will sometimes exclude employees on certain types of temporary leave. For hourly employees, the City is providing the hourly rate and frequency of hourly employees (40, 35, 20 and 10) to allow dataset users to estimate annual wages for hourly employees. Please note that annual wages will vary by employee, depending on number of hours worked and seasonal status. For information on the positions and related salaries detailed in the annual budgets, see https://www.cityofchicago.org/city/en/depts/obm.html
Data Disclosure Exemptions: Information disclosed in this dataset is subject to FOIA Exemption Act, 5 ILCS 140/7 (Link:https://www.ilga.gov/legislation/ilcs/documents/000501400K7.htm)