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.

City employee Base and Overtime Salary by Fiscal Year.

Content

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.

Context

This is a dataset hosted by the City of New York. The city has an open data platform found here and they update their information according the amount of data that is brought in. Explore New York City using Kaggle and all of the data sources available through the City of New York organization page!

• Update Frequency: This dataset is updated annually.

Acknowledgements

This dataset is maintained using Socrata's API and Kaggle's API. Socrata has assisted countless organizations with hosting their open data and has been an integral part of the process of bringing more data to the public.

Cover photo by Dean Rose on Unsplash
Unsplash Images are distributed under a unique Unsplash License.

City employee Base and Overtime Salary by Fiscal Year.

City employee Base and Overtime Salary by Fiscal Year.

The Title and Salary Listing is a compilation of job titles under the jurisdiction of the Department of Civil Service.

Public authorities are required by Section 2800 of Public Authorities Law to submit annual reports to the Authorities Budget Office that includes salary and compensation data. The dataset consists of salary data by employee reported by Local Authorities that covers 8 fiscal years, which includes fiscal years ending in the most recently completed calendar year.

Free payroll history for government employees in open information datasets

The Civil List reports the agency code (DPT), first initial and last name (NAME), agency name (ADDRESS), title code (TTL #), pay class (PC), and salary (SAL-RATE) of individuals who were employed by the City of New York at any given time during the indicated year.

Public authorities are required by Section 2800 of Public Authorities Law to submit annual reports to the Authorities Budget Office that includes salary and compensation data. The dataset consists of salary data by employee reported by Industrial Development Agencies that covers 8 fiscal years, which includes fiscal years ending in the most recently completed calendar year.

City employee Base and Overtime Salary by Fiscal Year.

The Civil List reports the agency code (DPT), first initial and last name (NAME), agency name (ADDRESS), title code (TTL #), pay class (PC), and salary (SAL-RATE) of individuals who were employed by the City of New York at any given time during the indicated year.

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.

The opening day payroll of teams in the MLB is calculated by combining the base salary, incentives, and any signing bonuses. At the beginning of the 2024 season, the New York Mets had the highest combined payroll in the league, amounting to around 305.62 million U.S. dollars. At the other end of the scale, the Oakland Athletics had an opening day payroll of just over 60 million U.S. dollars.

Pitchers take home the money The MLB has a minimum player salary in place to ensure that its professionals are rewarded for the work that they do. In 2023, the minimum salary for an MLB player was 720 thousand U.S. dollars per year, a significant increase from the minimum of 490 thousand U.S. dollars ten years earlier. However, the average player salary in the league in 2023 stood at 4.9 million U.S. dollars, around seven times the value of the minimum salary. This figure is skewed by the fact that the top earners in baseball take home significant amounts of money. Typically, it is the pitchers within a baseball team that earn the biggest wages due to their integral role. Indeed, pitchers dominated the list of highest earning players in the MLB and the New York Mets' starting pitcher Max Scherzer topped the list. The eight-time MLB All-Star took home a salary of over 43 million U.S. dollars in 2023.

MLB Luxury Tax In order to avoid such wealth disparity amongst the teams, Major League Baseball implements a luxury tax (or competitive balance tax). This tax is paid by any teams whose annual payroll exceeds the league limit which, in 2023, stood at 233 million U.S. dollars.

The Civil List reports the agency code (DPT), first initial and last name (NAME), agency name (ADDRESS), title code (TTL #), pay class (PC), and salary (SAL-RATE) of individuals who were employed by the City of New York at any given time during the indicated year.

The Agency Report Table aggregates pay and employment characteristics in accordance with the requirements of Local Law 18 of 2019. The Table is a point-in-time snapshot of employees who were either active or on temporary leave (parental leave, military leave, illness, etc.) as of December 31st of each year the data is available (see Column "Data Year"). In addition, the Table contains snapshot data of active employees in seasonal titles as of June 30th. To protect the privacy of employees, the sign “<5” is used instead of the actual number for groups of less than five (5) employees, in accordance with the Citywide Privacy Protection Policies and Protocols. The Pay and Demographics Report, and the list of agencies included is available on the MODA Open Source Analytics Library: https://modaprojects.cityofnewyork.us/local-law-18/

Each row represents a group of employees with a common agency, EEO-4 Job Category, pay band, employee status and demographic attributes, which include race, ethnicity and gender.

Current Employment by Industry (CES) data reflect jobs by "place of work." It does not include the self-employed, unpaid family workers, and private household employees. Jobs located in the county or the metropolitan area that pay wages and salaries are counted although workers may live outside the area. Jobs are counted regardless of the number of hours worked. Individuals who hold more than one job (i.e. multiple job holders) may be counted more than once. The employment figure is an estimate of the number of jobs in the area (regardless of the place of residence of the workers) rather than a count of jobs held by the residents of the area.

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.

City employee Base and Overtime Salary by Fiscal Year.

The Rochester Police Department's Sworn Personnel pay totals for fiscal year 2021-2022. Data features total hours worked, and amounts paid to sworn personnel between 07/01/2021 and 06/30/2022 including overtime and compensation time pay types.