| name | Citywide Payroll Data (Fiscal Year) |
|---|---|
| description | 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. |
| attribution | Office of Payroll Administration (OPA) |
| id | k397-673e |
| assetType | dataset |
| category | City Government |
| createdAt | 2015-10-31 16:15:21 |
| provenance | official |
| rowsUpdatedAt | 2025-10-08 15:57:11 |
| Name | Data Type | Description | Field Name |
|---|---|---|---|
| Fiscal Year | number | Fiscal Year | fiscal_year |
| Payroll Number | number | Payroll Number | payroll_number |
| Agency Name | text | The Payroll agency that the employee works for | agency_name |
| Last Name | text | Last name of employee | last_name |
| First Name | text | First name of employee | first_name |
| Mid Init | text | Middle initial of employee | mid_init |
| Agency Start Date | calendar_date | Date which employee began working for their current agency | agency_start_date |
| Work Location Borough | text | Borough of employee's primary work location | work_location_borough |
| Title Description | text | Civil service title description of the employee | title_description |
| Leave Status as of June 30 | text | Status of employee as of the close of the relevant fiscal year: Active, Ceased, or On Leave | leave_status_as_of_june_30 |
| Base Salary | number | Base Salary assigned to the employee | base_salary |
| Pay Basis | text | Lists whether the employee is paid on an hourly, per diem or annual basis | pay_basis |
| Regular Hours | number | Number of regular hours employee worked in the fiscal year | regular_hours |
| Regular Gross Paid | number | The amount paid to the employee for base salary during the fiscal year | regular_gross_paid |
| OT Hours | number | Overtime Hours worked by employee in the fiscal year | ot_hours |
| Total OT Paid | number | Total overtime pay paid to the employee in the fiscal year | total_ot_paid |
| Total Other Pay | number | 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. | total_other_pay |
| Normalized Fields | Agency Name |
|---|---|
| Next Update Scheduled |
| Source Data Last Updated | 2025-10-08 15:57:11 |
|---|---|
| Transformed Data Last Updated | 11/25/2025 19:29 |
| Columns Added | Calculating... |
| Added Column Names | Calculating... |
Loading data...
Loading data...