Data
New-York-City---Citywide-Payroll-Data

New-York-City---Citywide-Payroll-Data

active ARFF CC0: Public Domain Visibility: public Uploaded 24-03-2022 by Dustin Carrion
0 likes downloaded by 0 people , 0 total downloads 0 issues 0 downvotes
Issue #Downvotes for this reason By


Loading wiki
Help us complete this description Edit
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?

16 features

Fiscal_Yearnumeric4 unique values
0 missing
Agency_Namestring165 unique values
0 missing
Last_Namestring135711 unique values
942 missing
First_Namestring73182 unique values
952 missing
Mid_Initstring42 unique values
890022 missing
Agency_Start_Datestring13871 unique values
0 missing
Work_Location_Boroughstring27 unique values
506214 missing
Title_Descriptionstring1963 unique values
21 missing
Leave_Status_as_of_June_30string5 unique values
0 missing
Base_Salarystring76321 unique values
0 missing
Pay_Basisstring8 unique values
0 missing
Regular_Hoursnumeric62996 unique values
0 missing
Regular_Gross_Paidstring1076134 unique values
0 missing
OT_Hoursnumeric44980 unique values
0 missing
Total_OT_Paidstring492187 unique values
0 missing
Total_Other_Paystring479574 unique values
0 missing

19 properties

2194488
Number of instances (rows) of the dataset.
16
Number of attributes (columns) of the dataset.
Number of distinct values of the target attribute (if it is nominal).
1398151
Number of missing values in the dataset.
1190848
Number of instances with at least one value missing.
3
Number of numeric attributes.
0
Number of nominal attributes.
0
Number of attributes divided by the number of instances.
18.75
Percentage of numeric attributes.
Percentage of instances belonging to the most frequent class.
0
Percentage of nominal attributes.
Number of instances belonging to the most frequent class.
Percentage of instances belonging to the least frequent class.
Number of instances belonging to the least frequent class.
0
Number of binary attributes.
0
Percentage of binary attributes.
54.27
Percentage of instances having missing values.
Average class difference between consecutive instances.
3.98
Percentage of missing values.

0 tasks

Define a new task