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.

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 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 include salary and compensation data. The dataset consists of salary data by employee reported by State Authorities 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.

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.

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?

Overview

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.

Columns

Column Name - Description

Fiscal Year - Fiscal Year

Payroll Number - Payroll Number

Agency Name - The Payroll agency that the employee works for

Last Name - Last name of employee

First Name - First name of employee

Mid Init - Middle initial of employee

Agency Start Date - Date which employee began working for their current agency

Work Location Borough - Borough of employee's primary work location

Title Description - Civil service title description of the employee

Leave Status as of June 30 - Status of employee as of the close of the relevant fiscal year: Active, Ceased, or On Leave

Base Salary - Base Salary assigned to the employee

Pay Basis - Lists whether the employee is paid on an hourly, per diem or annual basis

Regular Hours - Number of regular hours employee worked in the fiscal year

Regular Gross Paid - The amount paid to the employee for base salary during the fiscal year

OT Hours - Overtime Hours worked by employee in the fiscal year

Total OT Paid - Total overtime pay paid to the employee in the fiscal year

Total Other Pay - Includes any compensation in addition to gross salary and overtime pay, ie Differentials, lump sums, uniform allowance, meal allowance, retroactive pay increases, settlement amounts, and bonus pay, if applicable.

Source

Agency - Office of Payroll Administration (OPA) https://data.cityofnewyork.us/City-Government/Citywide-Payroll-Data-Fiscal-Year-/k397-673e

Graph and download economic data for Total Wages and Salaries in New York (NYWTOT) from Q1 1998 to Q2 2025 about salaries, NY, wages, and USA.

The New York City Controller's Office maintains a database of the salary and benefits paid to city employees since the fiscal year 2013. This is data representing the Employee Compensation report.

Year Type: Fiscal (July through June) or Calendar (January through December)

Year: An accounting period of 12 months. The New York City operates operates on a fiscal year that begins on July 1 and ends on June 30 the following year. The Fiscal Year ending June 30, 2012 is represented as FY2011-2012.

Employee Identifier: Each distinct number in the “Employee Identifier” column represents one employee. These identifying numbers are not meaningful but rather are randomly assigned for the purpose of building this dataset.

Salaries: Normal salaries paid to permanent or temporary City employees.

Overtime: Amounts paid to City employees working in excess of 40 hours per week.

Other Salaries: Various irregular payments made to City employees including premium pay, incentive pay, or other one-time payments.

Total Salary: The sum of all salaries paid to City employees.

Retirement: City contributions to employee retirement plans.

Health/Dental: City-paid premiums to health and dental insurance plans covering City employees. To protect confidentiality as legally required, pro-rated citywide averages are presented in lieu of employee-specific health and dental benefits.

Other Benefits: Mandatory benefits paid on behalf of employees, such as Social Security (FICA and Medicare) contributions, unemployment insurance premiums, and minor discretionary benefits not included in the above categories.

Total Benefits: The sum of all benefits paid to City employees.

Total Compensation: The sum of all salaries and benefits paid to City employees.

Explore the historical Whois records related to salary.nyc (Domain). Get insights into ownership history and changes over time.

Free payroll history for government employees in open information datasets

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.

Graph and download economic data for Information Wages and Salaries in New York (NYWINF) from Q1 1998 to Q2 2025 about information, salaries, NY, wages, and USA.

Graph and download economic data for Real Median Household Income in New York (MEHOINUSNYA672N) from 1984 to 2024 about NY, households, median, income, real, and USA.

Content

More details about each file are in the individual file descriptions.

Context

This is a dataset hosted by the State of New York. The state has an open data platform found here and they update their information according the amount of data that is brought in. Explore New York State using Kaggle and all of the data sources available through the State 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.

This dataset is distributed under the following licenses: Public Domain

Graph and download economic data for Construction Wages and Salaries in New York (NYWCON) from Q1 1998 to Q2 2025 about salaries, NY, construction, wages, and USA.

The dataset consists of three years of salary data, by employee, reported by local authorities. Public authorities are required by Section 2800 of Public Authorities Law to submit annual reports to the Authorities Budget Office (ABO) that include salary and compensation data.

Graph and download economic data for Average Weekly Wages for Employees in State Government Establishments in Binghamton, NY (MSA) (ENUC137840210SA) from Q1 2001 to Q1 2025 about Binghamton, state govt, establishments, average, NY, wages, government, employment, and USA.