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

List of civil service titles used by agencies throughout the City

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.

List of Civil Service title codes and title descriptions used by City of New York agencies

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.

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

Content

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

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.

Cover photo by Renan Kamikoga on Unsplash
Unsplash Images are distributed under a unique Unsplash License.

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

The provided dataset offers comprehensive insights into various job postings within different governmental agencies in New York City. Ranging from administrative roles to specialized technical positions, each entry outlines essential details such as job titles, agency affiliations, qualifications, and application procedures.

https://media.giphy.com/media/v1.Y2lkPTc5MGI3NjExdHN5ZGZ4dzd2cHlhOWp5bzZndXNjYjdyMDkxMTZsNmEwcGdjcTZkcyZlcD12MV9naWZzX3NlYXJjaCZjdD1n/jTvp1Ck02UeAt0ZfSf/giphy.gif" alt="">

With a focus on roles within departments like the Department of Environmental Protection, Bronx District Attorney's Office, Office of Criminal Justice, and Department of Design & Construction, this dataset provides a valuable resource for individuals seeking employment opportunities in public service.

https://media.giphy.com/media/FOV9923exXGM78DoSZ/giphy.gif?cid=790b7611tsydfxw7vpya9jyo6guscb7r09116l6a0pgcq6ds&ep=v1_gifs_search&rid=giphy.gif&ct=g" alt="">

Through detailed descriptions of job responsibilities, qualifications, and application processes, this dataset serves as a guide for both prospective applicants and organizational recruiters, facilitating informed decision-making and efficient recruitment processes within the New York City governmental sector.

https://media.giphy.com/media/ccWnirowyT2U9wdBdI/giphy.gif?cid=790b7611tsydfxw7vpya9jyo6guscb7r09116l6a0pgcq6ds&ep=v1_gifs_search&rid=giphy.gif&ct=g" alt="">

Job ID: Unique identifier for each job posting.

Agency: Governmental organization or department responsible for the job posting.

Posting Type: Indicates whether the posting is internal or external.

# Of Positions: Number of vacancies available for the position.

Business Title: Job title used within the agency.

Civil Service Title: Official civil service title assigned to the position.

Title Classification: Classification level of the title (e.g., Competitive, Non-Competitive).

Title Code No: Code assigned to the title for organizational purposes.

Level: Level of the position within the organizational hierarchy.

Job Category: Category or field of work the position falls under.

Full-Time/Part-Time Indicator: Indicates whether the position is full-time or part-time.

Career Level: Indicates the career level or experience required for the position.

Salary Range From: Starting salary range for the position.

Salary Range To: Ending salary range for the position.

Salary Frequency: Frequency at which the salary is paid (e.g., Annual, Hourly).

Work Location: Location where the job will be based.

Division/Work Unit: Specific division or unit within the agency where the position is located.

Job Description: Description of the duties and responsibilities associated with the position.

Minimum Qual Requirements: Minimum qualifications required for the position.

Preferred Skills: Skills or qualifications preferred but not required for the position.

Additional Information: Any additional information provided about the job posting.

To Apply: Instructions on how to apply for the position.

Posting Date: Date when the job posting was initially posted.

Post Until: Date until which the job posting is active.

Posting Updated: Date when the job posting information was last updated.

Process Date: Date related to the processing of the job posting (if available).

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.