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.

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.

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.

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.

City employee Base and Overtime Salary by Fiscal Year.

Payroll information for all Los Angeles City Employees including the City's three proprietary departments: Water and Power, Airports and Harbor. Data is updated bi-weekly by the Los Angeles City Controller's Office. Payroll information for employees of the Department of Water and Power is updated every three months.

City employee Base and Overtime Salary by Fiscal Year.

This dataset is now updated annually here.

Context

This dataset contains the salary, pay rate, and total compensation of every New York City employee. In this dataset this information is provided for the 2014, 2015, 2016, and 2017 fiscal years, and provides a transparent lens into who gets paid how much and for what.

Note that fiscal years in the New York City budget cycle start on July 1st and end on June 30th (see here). That means that this dataset contains, in its sum, compensation information for all City of New York employees for the period July 1, 2014 to June 30, 2017.

Content

This dataset provides columns for fiscal year, employee name, the city department they work for, their job title, and various fields describing their compensation. The most important of these fields is "Regular Gross Pay", which provides that employee's total compensation.

Acknowledgements

This information was published as-is by the City of New York.

Inspiration

• How many people do the various city agencies employ, and how much does each department spend on salary in total?
• What are the most numerous job titles in civic government employment?
• Where does overtime pay seem to be especially common? How much of it is there?
• How do New York City employee salaries compare against salaries of city employees in Chicago? Is the difference more or less than the difference in cost of living between the two cities?

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.

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.

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

description: City-Parish employees' annual salaries and other payroll related information. Information is calculated after the last payroll is run for the year specified.; abstract: City-Parish employees' annual salaries and other payroll related information. Information is calculated after the last payroll is run for the year specified.

City employee Base and Overtime Salary by Fiscal Year.

This dataset contains the range of salaries of full-time city staff, by department and title, as of July, 2014.

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

Note, 7/10/2025: Please see this article for information on a change to the EMPLOYEE DATASET ID column and this article for information on a data correction. Welcome to the official source for Employee Payroll Costing data for the City of Chicago. This dataset offers a clean, comprehensive view of the City's payroll information by employee. About the Dataset: This has been extracted from the City of Chicago's Financial Management and Purchasing System (FMPS). FMPS is the system used to process all financial transactions made by the City of Chicago, ensuring accuracy and transparency in fiscal operations. This dataset includes useful details like employee name, pay element, pay period, fund, appropriation, department, and job title. Data Disclaimer: The following data disclaimer governs your use of the dataset extracted from the Payroll Costing module of the City of Chicago's Financial Management and Purchasing System (FMPS) or (FMPS Payroll Costing). Point-in-Time Extract: The dataset provided herein, represents a point-in-time extract from the FMPS Payroll Costing module and may not reflect real-time or up-to-date data. Financial Statement Disclaimer – Timeframe and Limitations: This dataset is provided without audit. It is essential to note that this dataset is not a component of the City's Annual Comprehensive Financial Report (ACFR). As such, it remains preliminary and is subject to the end-of-year reconciliation process inherent to the City's annual financial procedures outlined in the ACFR. Note on Pay Elements: All pay elements available in the FMPS Payroll Costing module have been included in this dataset. Previously published datasets, such as "Employee Overtime and Supplemental Earnings," contained only a subset of these pay elements. Payroll Period: The dataset's timeframe is organized into 24 payroll periods. It is important to understand that these periods may or may not directly correspond to specific earnings periods. Aggregating Data: The CIty of Chicago often has employees with the same name (including middle initials). It is vital to use the unique employee identifier code (EMPLOYEE DATASET ID) when aggregating at the employee level to avoid duplication. Data Subject to Change: This dataset is subject to updates and modifications due to the course of business, including activities such as canceling, adjusting, and reissuing checks. 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)

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.

NOTE: 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.

This dataset displays the current salaries for City of Little Rock employees. Some employees are hourly. Their pay is reflected as an hourly rate.

Each year, the City of Winchester 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.