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
| Column | Type | What it holds | Values or range |
|---|---|---|---|
| work_order_idkey | integer | Unique id for the row. | |
| work_order_type | text | Preventive, corrective, refurbishment or facility. | corrective; facility; preventive; refurbishment |
| attraction_id | integer | The ride, for ride work. Can be empty. | |
| venue_id | integer | The venue, for venue repairs. Can be empty. | |
| hotel_id | integer | The hotel, for hotel repairs. Can be empty. | |
| downtime_id | integer | The closure this job dealt with, when there was one. Can be empty. | |
| description | text | What the job was. | |
| priority | text | How urgent it was. | emergency; routine; scheduled; urgent |
| opened_at | date and time | When the job was raised. | 2018-01-01 06:00 to 2025-12-31 21:20 |
| due_date | date | Date scheduled work was due. Can be empty. | 2018-01-02 to 2025-12-31 |
| completed_at | date and time | When it was finished. Empty when not done. Can be empty. | 2018-01-01 16:20 to 2025-12-31 22:32 |
| status | text | Completed, open, or deferred. Deferred preventive work was skipped for that cycle. | completed; deferred; open |
| assigned_employee_id | integer | Who did the work. Links to employees. | |
| labor_hours | decimal | Hours spent. | 0 to 1,099.5 |
| parts_cost | decimal | Parts and materials in dollars. | 0 to 175,024.59 |
How it connects
This table points to
- attraction_id matches attractions.attraction_id
- venue_id matches venues.venue_id
- hotel_id matches hotels.hotel_id
- downtime_id matches ride_downtime.downtime_id
- assigned_employee_id matches employees.employee_id
First five rows
Taken from the Sample size, exactly as they appear in the file. Empty cells are empty in the data.
| work_order_id | work_order_type | attraction_id | venue_id | hotel_id | downtime_id | description | priority | opened_at | due_date | completed_at | status | assigned_employee_id | labor_hours | parts_cost |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 800001 | preventive | 102 | Weekly safety inspection | scheduled | 2018-01-01 06:00:00 | 2018-01-05 | 2018-01-05 08:05:23 | completed | 211067 | 1.3 | 0 | |||
| 800002 | preventive | 104 | Weekly safety inspection | scheduled | 2018-01-01 06:00:00 | 2018-01-02 | 2018-01-03 05:56:45 | completed | 201821 | 1.7 | 0 | |||
| 800003 | preventive | 105 | Weekly safety inspection | scheduled | 2018-01-01 06:00:00 | 2018-01-05 | 2018-01-05 05:39:57 | completed | 201876 | 1.5 | 0 | |||
| 800004 | preventive | 105 | Monthly lubrication and wear check | scheduled | 2018-01-01 06:00:00 | 2018-01-11 | 2018-01-11 07:09:44 | completed | 215835 | 5.3 | 168.22 | |||
| 800005 | preventive | 107 | Weekly safety inspection | scheduled | 2018-01-01 06:00:00 | 2018-01-03 | 2018-01-03 07:28:02 | completed | 215835 | 1.2 | 0 |