Skip to content

shifts

Scheduled shifts for hourly staff. One row is one person's shift on one day.

One row is
one person's shift on one day
Columns
8
Rows in Sample
3,490,509
Rows in Standard
3,490,509
Rows in Full
3,490,509

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

Columns

ColumnTypeWhat it holdsValues or range
shift_idkeyintegerUnique id for the row.
employee_idintegerLinks to employees.
location_idintegerThe work location. Links to work_locations.
shift_datedateThe day.2018-01-01 to 2025-12-31
scheduled_startdate and timePlanned start.2018-01-01 04:30 to 2025-12-31 18:00
scheduled_enddate and timePlanned end.2018-01-01 11:00 to 2026-01-01 00:30
statustextWorked, or called out.called out; worked
hours_workeddecimalHours actually worked. 0 when called out.0 to 10

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.

shift_idemployee_idlocation_idshift_datescheduled_startscheduled_endstatushours_worked
5000000012032351242018-01-012018-01-01 04:30:002018-01-01 13:00:00worked8
5000000022072901242018-01-012018-01-01 04:30:002018-01-01 13:00:00worked8
5000000032001871242018-01-012018-01-01 04:30:002018-01-01 13:00:00worked8
5000000042056131242018-01-012018-01-01 04:30:002018-01-01 13:00:00worked8
5000000052050011242018-01-012018-01-01 04:30:002018-01-01 13:00:00worked8

Download from Kaggle