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.

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.

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

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

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.

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?

In 2023, the average annual pay of employees in New York totaled to ****** U.S. dollars. This is a significant increase from 2001 levels, when the average annual pay of employees was ****** U.S. dollars.

City employee Base and Overtime Salary by Fiscal Year.

The County of Broome Personnel Department produces areport annually containing the Name, Title, Department,Base Earnings and Over Time Earnings of each employee who has held a position within the County anytime duringthat year.

City employee Base and Overtime Salary by Fiscal Year.

Graph and download economic data for Average Hourly Earnings of All Employees: Total Private in New York City, NY (SMU36935610500000003) from Jan 2007 to Aug 2025 about New York, earnings, hours, NY, private, employment, and USA.

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.

The New York City Job Dataset

This dataset provides detailed information about various job positions available within the city government. This dataset encompasses a wide range of roles, agencies, and qualifications, offering valuable insights into the city's workforce landscape.

https://media.giphy.com/media/RiykPw9tgdOylwFgUe/giphy.gif" alt="">

Key Insights

Job Categories: The dataset covers a diverse array of job categories, ranging from legal affairs and engineering to health and community programs. This diversity showcases the wide spectrum of public sector roles available in NYC.

Qualifications and Skills: Detailed qualification requirements and preferred skills are provided for each job, giving candidates clear insights into the competencies needed to apply successfully.

Salary Information: The dataset includes salary ranges for each position, allowing job seekers to gauge potential earnings based on their experience and qualifications.

Application Process: Clear instructions on how to apply, including application links and deadlines, provide valuable guidance to potential applicants.

Work Details: Information about work hours, shift patterns, and potential remote work options (where applicable) offers a comprehensive understanding of the job's work-life balance.

https://media.giphy.com/media/u2oNak2nuaYYAcZlM8/giphy.gif" alt="">

Conclusion

The New York City Job Dataset is a valuable resource for job seekers, offering comprehensive insights into available positions, qualifications, and application procedures within the city's public sector. Users should leverage this data responsibly and refer to official sources for the most up-to-date information.

A dataset that explores Green Card sponsorship trends, salary data, and employer insights for new york city, ny in the U.S.

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.

About this dataset

Context

The dataset presents median income data over a decade or more for males and females categorized by Total, Full-Time Year-Round (FT), and Part-Time (PT) employment in Broadalbin town. It showcases annual income, providing insights into gender-specific income distributions and the disparities between full-time and part-time work. The dataset can be utilized to gain insights into gender-based pay disparity trends and explore the variations in income for male and female individuals.

Key observations: Insights from 2023

Based on our analysis ACS 2019-2023 5-Year Estimates, we present the following observations: - All workers, aged 15 years and older: In Broadalbin town, the median income for all workers aged 15 years and older, regardless of work hours, was $45,027 for males and $31,825 for females.

These income figures indicate a substantial gender-based pay disparity, showcasing a gap of approximately 29% between the median incomes of males and females in Broadalbin town. With women, regardless of work hours, earning 71 cents to each dollar earned by men, this income disparity reveals a concerning trend toward wage inequality that demands attention in thetown of Broadalbin town.

- Full-time workers, aged 15 years and older: In Broadalbin town, among full-time, year-round workers aged 15 years and older, males earned a median income of $78,083, while females earned $49,417, leading to a 37% gender pay gap among full-time workers. This illustrates that women earn 63 cents for each dollar earned by men in full-time roles. This level of income gap emphasizes the urgency to address and rectify this ongoing disparity, where women, despite working full-time, face a more significant wage discrepancy compared to men in the same employment roles.

Remarkably, across all roles, including non-full-time employment, women displayed a lower gender pay gap percentage. This indicates that Broadalbin town offers better opportunities for women in non-full-time positions.

Content

When available, the data consists of estimates from the U.S. Census Bureau American Community Survey (ACS) 2019-2023 5-Year Estimates. All incomes have been adjusting for inflation and are presented in 2023-inflation-adjusted dollars.

Gender classifications include:

• Male
• Female

Employment type classifications include:

• Full-time, year-round: A full-time, year-round worker is a person who worked full time (35 or more hours per week) and 50 or more weeks during the previous calendar year.
• Part-time: A part-time worker is a person who worked less than 35 hours per week during the previous calendar year.

Variables / Data Columns

• Year: This column presents the data year. Expected values are 2010 to 2023
• Male Total Income: Annual median income, for males regardless of work hours
• Male FT Income: Annual median income, for males working full time, year-round
• Male PT Income: Annual median income, for males working part time
• Female Total Income: Annual median income, for females regardless of work hours
• Female FT Income: Annual median income, for females working full time, year-round
• Female PT Income: Annual median income, for females working part time

Good to know

Margin of Error

Data in the dataset are based on the estimates and are subject to sampling variability and thus a margin of error. Neilsberg Research recommends using caution when presening these estimates in your research.

Custom data

If you do need custom data for any of your research project, report or presentation, you can contact our research staff at research@neilsberg.com for a feasibility of a custom tabulation on a fee-for-service basis.

Inspiration

Neilsberg Research Team curates, analyze and publishes demographics and economic data from a variety of public and proprietary sources, each of which often includes multiple surveys and programs. The large majority of Neilsberg Research aggregated datasets and insights is made available for free download at https://www.neilsberg.com/research/.

Recommended for further research

This dataset is a part of the main dataset for Broadalbin town median household income by race. You can refer the same here

A dataset that explores Green Card sponsorship trends, salary data, and employer insights for garden city, ny in the U.S.