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

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 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.

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

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?

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.

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 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).

Context

This dataset contains the name, job title, department, and salary of every employee that was on the City of Chicago payroll at the time of capture in mid-2017. It provides a transparent lens into who gets paid how much and for what.

Content

This dataset provides columns for employee name, the city department they work for, their job title, and various fields describing their compensation. Most employee salaries are covered by the Annual Salary field, but some employees paid hourly are covered by a combination of Typical Hours and Hourly Rate fields.

Acknowledgements

This dataset is published as-is by the City of Chicago (here).

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?
• How do Chicago employee salaries compare against salaries of city employees in New York City? Is the difference more or less than the difference in cost of living between the two cities?

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.

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.

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.

List of civil service titles used by agencies throughout the City

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.

Quarterly Employment and Wage Data (Timeseries)

Detailed Insights into Local Industries

By State of New York [source]

About this dataset

The Quarterly Census of Employment and Wages (QCEW) program is the most comprehensive labor market data source out there, collecting vital information on employment and wage trends across New York State. It provides a virtual census of 97 percent of the state's nonfarm employees and employers who are covered by the Unemployment Insurance (UI) Law, making it incredibly precise in measuring total wages, establishments, unemployment insurance reports, as well as crucial geographical labor information by state region and county.

At its core, this program seeks to give users a precise quantitative view comparative data that takes into account differences in employee coverage regulatory policy across bureaus or federal laws. All this while taking into consideration factors like agricultural workers, private households employments students or unpaid family workers that are excluded from UI considerations but still count towards Current Employment Statistics totals. This dataset offers an eye-opening look into employment dynamics in New York State; one that you won't find anywhere else! Before using any found data though make sure to review and read through the Terms of Service license requirements first!

More Datasets

For more datasets, click here.

Featured Notebooks

• 🚨 Your notebook can be here! 🚨!

How to use the dataset

The New York Quarterly Employment and Wage Data is an invaluable resource for researchers, students, professionals and policymakers. The data offers a wealth of information on employment status and wages in New York State across all industries. This guide will provide you with a step-by-step introduction to using this dataset.

Research Ideas

• Analyzing small business trends over time to understand hiring trends in the localization and industry level.
• Creating predictive models to forecast future employment levels and wage demands for New York State's departments, businesses, and regions in the upcoming quarters or fiscal years.
• Tracking changes in average wages and employment by industry, region or area type over time to identify potential labor shortages or job losses due to automation or other factors that could lead to policy recommendations at a state level

Acknowledgements

If you use this dataset in your research, please credit the original authors. Data Source

License

See the dataset description for more information.

Columns

File: quarterly-census-of-employment-and-wages-quarterly-data-beginning-2000-1.csv | Column name | Description | |:-----------------------|:-----------------------------------------------------------------| | Area Type | The type of area the data is for (String) | | Year | The year the data is for (Integer) | | Quarter | The quarter the data is for (Integer) | | NAICS | The North American Industry Classification System code (Integer) | | NAICS Title | The title of the NAICS code (String) | | Establishments | The number of establishments in the area (Integer) | | Month 1 Employment | The number of employees in the first month (Integer) | | Month 2 Employment | The number of employees in the second month (Integer) | | Month 3 Employment | The number of employees in the third month (Integer) |

Acknowledgements

If you use this dataset in your research, please credit the original authors. If you use this dataset in your research, please credit State of New York.

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 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 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 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 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.