Skip to content

payroll

Pay for each two-week period. One row is one person's pay for one period.

One row is
one person's pay for one period
Columns
7
Rows in Sample
494,485
Rows in Standard
494,485
Rows in Full
494,485

This table describes the company, not individual guests, so it is identical in all three sizes.

Columns

ColumnTypeWhat it holdsValues or range
payroll_idkeyintegerUnique id for the row.
employee_idintegerLinks to employees.
period_startdateFirst day of the period.2018-01-01 to 2025-12-22
period_enddateLast day of the period.2018-01-14 to 2026-01-04
regular_hoursdecimalHours paid at the normal rate.6 to 80
overtime_hoursdecimalHours over 40 in a week, paid at time and a half.0 to 52
gross_paydecimalPay before deductions, in dollars.53.88 to 6,480.77

How it connects

First five rows

Taken from the Sample size, exactly as they appear in the file. Empty cells are empty in the data.

payroll_idemployee_idperiod_startperiod_endregular_hoursovertime_hoursgross_pay
12169662018-01-012018-01-14360337.32
22043762018-01-012018-01-14360340.2
32163252018-01-012018-01-14300300.9
42080832018-01-012018-01-14720725.76
52081742018-01-012018-01-14300291.9

Download from Kaggle