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.

City employee Base and Overtime Salary by Fiscal Year.

The payroll data represents the amount paid to an employee during the reported time period. In addition to regular pay, these amounts may include other pay types such as overtime, longevity, shift differential or terminal pay. This amount does not include any state share costs associated with the payroll i.e. FICA, state share retirement, etc. This amount may vary from an employee’s ‘salary’ due to pay adjustments or pay period timing. The payroll information will be updated monthly after the end of the month. For example, July information will be added in August after the 15th of the month.

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.

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.

The payroll data represents the amount paid to an employee during the reported time period. In addition to regular pay, these amounts may include other pay types such as overtime, longevity, shift differential or terminal pay. This amount does not include any state share costs associated with the payroll i.e. FICA, state share retirement, etc. This amount may vary from an employee’s ‘salary’ due to pay adjustments or pay period timing. The payroll information will be updated monthly after the end of the month. For example, July information will be added in August after the 15th of the month.

Annual salary information including gross pay and overtime pay for all active, permanent employees of Montgomery County, MD paid in calendar year 2024. This information will be published annually each 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.

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.

The County of Suffolk Annual Salaries File for the Year 2023 is a yearly summary of Payroll Data for all Suffolk County employees. This file contains the Employee Names and Hired Date along with their most recent Job Title and Department. In addition, the file contains the Employee’s Regular Pay Rate (Hourly, Biweekly or Annual Salary), the Year to Date Regular Earnings, Longevity Pay, Overtime Pay, and Other Payments (comprised of Holiday Pay, Night Differential Pay, Cleaning and Clothing Allowances, Taxable Legal Benefit Amounts, etc.). If an employee has been terminated or has separated from County employment, the Separation Payment Amount (if applicable), and Termination Date is also included.

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

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.

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

DC Department of Human Resources provides District government employees with a variety of services and programs on employee benefits, policy and procedures, performance management, and compensation. This dataset includes public employee salary compensation information found on the DCHR web application https://dchr.dc.gov/public-employee-salary-information.

Salary information for State of Vermont active employees from all branches. Generally, employees who are expected to work year-round have salaries stated as salary type "Annual." Temporary employees have salaries stated as salary type "Hourly." Legislators, who usually do not work year-round, have salaries stated as salary type "Weekly." The weekly rate reported here is the rate paid during the legislative session. Data as of the last Friday of each month. NOTE: Individuals covered by the Safe at Home Act (Title 15 Sections 1150-1160) have been excluded from this list.

Payroll Data, including Calendar Year 2015 through the most recent pay period. Data used in the Open Payroll application

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

The payroll data represents the amount paid to an employee during the reported time period. In addition to regular pay, these amounts may include other pay types such as overtime, longevity, shift differential or terminal pay. This amount does not include any state share costs associated with the payroll i.e. FICA, state share retirement, etc. This amount may vary from an employee’s ‘salary’ due to pay adjustments or pay period timing. The payroll information will be updated monthly after the end of the month. For example, July information will be added in August after the 15th of the month.

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.

The payroll data represents the amount paid to an employee during the reported time period. In addition to regular pay, these amounts may include other pay types such as overtime, longevity, shift differential or terminal pay. This amount does not include any state share costs associated with the payroll i.e. FICA, state share retirement, etc. This amount may vary from an employee’s ‘salary’ due to pay adjustments or pay period timing. The payroll information will be updated monthly after the end of the month. For example, July information will be added in August after the 15th of the month.