ride_downtime
Every time an attraction closed during park hours, planned or not. One row is one closure.
- One row is
- one closure
- Columns
- 6
- Rows in Sample
- 18,785
- Rows in Standard
- 18,785
- Rows in Full
- 18,785
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 |
|---|---|---|---|
| downtime_idkey | integer | Unique id for the row. | |
| attraction_id | integer | The ride, show or slide. Links to attractions. | |
| started_at | date and time | When it closed. | 2018-01-03 11:15 to 2025-12-31 12:15 |
| ended_at | date and time | When it reopened. | 2018-01-03 11:55 to 2025-12-31 19:52 |
| minutes | integer | Length of the closure. | 1 to 41160 |
| cause | text | Why it closed. | mechanical; planned refurbishment; weather: lightning |
How it connects
This table points to
- attraction_id matches attractions.attraction_id
Tables that point here
First five rows
Taken from the Sample size, exactly as they appear in the file. Empty cells are empty in the data.
| downtime_id | attraction_id | started_at | ended_at | minutes | cause |
|---|---|---|---|---|---|
| 1 | 305 | 2018-01-03 11:15:00 | 2018-01-03 11:55:00 | 40 | mechanical |
| 2 | 209 | 2018-01-06 15:18:00 | 2018-01-06 15:49:00 | 31 | mechanical |
| 3 | 105 | 2018-01-07 16:12:00 | 2018-01-07 17:30:00 | 78 | weather: lightning |
| 4 | 107 | 2018-01-07 16:12:00 | 2018-01-07 17:30:00 | 78 | weather: lightning |
| 5 | 108 | 2018-01-07 16:12:00 | 2018-01-07 17:30:00 | 78 | weather: lightning |