Skip to content

work_orders

Maintenance jobs on rides, venues and hotels. One row is one job.

One row is
one job
Columns
15
Rows in Sample
64,541
Rows in Standard
64,541
Rows in Full
64,541

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

Columns

ColumnTypeWhat it holdsValues or range
work_order_idkeyintegerUnique id for the row.
work_order_typetextPreventive, corrective, refurbishment or facility.corrective; facility; preventive; refurbishment
attraction_idintegerThe ride, for ride work. Can be empty.
venue_idintegerThe venue, for venue repairs. Can be empty.
hotel_idintegerThe hotel, for hotel repairs. Can be empty.
downtime_idintegerThe closure this job dealt with, when there was one. Can be empty.
descriptiontextWhat the job was.
prioritytextHow urgent it was.emergency; routine; scheduled; urgent
opened_atdate and timeWhen the job was raised.2018-01-01 06:00 to 2025-12-31 21:20
due_datedateDate scheduled work was due. Can be empty.2018-01-02 to 2025-12-31
completed_atdate and timeWhen it was finished. Empty when not done. Can be empty.2018-01-01 16:20 to 2025-12-31 22:32
statustextCompleted, open, or deferred. Deferred preventive work was skipped for that cycle.completed; deferred; open
assigned_employee_idintegerWho did the work. Links to employees.
labor_hoursdecimalHours spent.0 to 1,099.5
parts_costdecimalParts and materials in dollars.0 to 175,024.59

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.

work_order_idwork_order_typeattraction_idvenue_idhotel_iddowntime_iddescriptionpriorityopened_atdue_datecompleted_atstatusassigned_employee_idlabor_hoursparts_cost
800001preventive102Weekly safety inspectionscheduled2018-01-01 06:00:002018-01-052018-01-05 08:05:23completed2110671.30
800002preventive104Weekly safety inspectionscheduled2018-01-01 06:00:002018-01-022018-01-03 05:56:45completed2018211.70
800003preventive105Weekly safety inspectionscheduled2018-01-01 06:00:002018-01-052018-01-05 05:39:57completed2018761.50
800004preventive105Monthly lubrication and wear checkscheduled2018-01-01 06:00:002018-01-112018-01-11 07:09:44completed2158355.3168.22
800005preventive107Weekly safety inspectionscheduled2018-01-01 06:00:002018-01-032018-01-03 07:28:02completed2158351.20

Download from Kaggle