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 Title and Salary Listing is a compilation of job titles under the jurisdiction of the Department of Civil Service.

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.

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.

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.

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.

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

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.

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

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

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 Brighton 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 Brighton town, the median income for all workers aged 15 years and older, regardless of work hours, was $54,780 for males and $40,934 for females.

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

- Full-time workers, aged 15 years and older: In Brighton town, among full-time, year-round workers aged 15 years and older, males earned a median income of $84,319, while females earned $73,430, resulting in a 13% gender pay gap among full-time workers. This illustrates that women earn 87 cents for each dollar earned by men in full-time positions. While this gap shows a trend where women are inching closer to wage parity with men, it also exhibits a noticeable income difference for women working full-time in the town of Brighton town.

Interestingly, when analyzing income across all roles, including non-full-time employment, the gender pay gap percentage was higher for women compared to men. It appears that full-time employment presents a more favorable income scenario for women compared to other employment patterns in Brighton town.

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 Brighton town median household income by race. You can refer the same here

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.

View monthly updates and historical trends for New York Average Weekly Earnings of All Employees: Information. Source: Bureau of Labor Statistics. Track e…

Workers' Compensation Claims (NYS)

Injury Types, Claim Processing, and Benefits Recipients

By State of New York [source]

About this dataset

The dataset includes more than twenty years of Workers’ Compensation Claims records starting from the year 2000, giving a comprehensive overview of this important segment of the labor market. From information on claimants' age, gender and zip code to details on claim type, injury type, injury source and event exposure they each hold invaluable insights into the health of workers' compensation. Stay up-to-date with WIBC's constantly growing database featuring essential data that can help you in making informed decisions on how to manage claims and look after your workforce. Learn what types of injuries lead to successful claims; understand which carrier types are most often involved in claims; research claim assembly process times; gain an understanding of slow or disputed claims; find out about wage averages for claimants; and numerous other aspects related to workers’ compensation. With such insight available at your fingertips make sure you capitalize on its potential as you work towards better management and protection of your workforce - Now with complete data from 2000 all the way up till today!

More Datasets

For more datasets, click here.

Featured Notebooks

• 🚨 Your notebook can be here! 🚨!

How to use the dataset

Welcome to the Workers’ Compensation Claims in New York State: 2000-Present dataset! This dataset contains information about workers’ compensation claims in New York State between the years 2000 and present.

This guide will provide you with an overview of the data included, as well as how to use this information for your own research and exploration.

Firstly, you should familiarize yourself with the data columns. This dataset includes a variety of fields related to workers’ compensation claims such as claim type, injury type, district name and current claim status, age at injury, assembly date and ANCR date (claim acceptance or denial). Additionally it contains details about medical costs covered by WCB (Average Weekly Wage) , dispute resolution mechanisms (Alternative Dispute Resolution), legal representatives handling the case(Attorney/Representative), insurance carrier involved(Carrier Name)and other useful details pertinent for understanding workers' compenstation cases such as Hearing count & Closed count.

Once you understand all available fields/columns and their respective values/labels in this dataset you can start exploring them one by one & create custom queries based on specific parameters within each field. For example some common analysis could include:

- Analyzing worker benefits based on salary ranges or specific professions; 

- Comparing survival rates of injured employees across different regions; 

- Seeing how injuries vary across gender lines;

- Studying dispute resolution patterns over time;

- Examining attorney or representative impact on settlement outcomes; And much more!  

With this guide hopefully you have been equipped with a basic understanding of how to use the Workers’ Compensation Claims in New York State: 2000-Present Kaggle database so that your explorations become more fruitful! Enjoy!

Research Ideas

• Identifying potential problem areas in the workers’ compensation system and illustrating how to best resolve those issues.
• Demonstrating potential correlations between types of injuries, claim types, and outcomes in order to inform better decision-making with regards to workplace safety.
• Estimating the financial impact of future claims based on current trends in workers' compensation data

Acknowledgements

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

License

License: Dataset copyright by authors - You are free to: - Share - copy and redistribute the material in any medium or format for any purpose, even commercially. - Adapt - remix, transform, and build upon the material for any purpose, even commercially. - You must: - Give appropriate credit - Provide a link to the license, and indicate if changes were made. - ShareAlike - You must distribute your contributions under the same license as the original. - Keep intact - all notices that refer to this license, including copyright notices.

Columns

File: Assembled_Workers_Compensation_Claims_Beginning_2000.csv | Column ...

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