ride_events
Every ride taken. The largest table. One row is one person on one ride.
- One row is
- one person on one ride
- Columns
- 8
- Rows in Sample
- 1,166,930
- Rows in Standard
- 11,701,653
- Rows in Full
- 117,255,655
Columns
| Column | Type | What it holds | Values or range |
|---|---|---|---|
| ride_event_idkey | integer | Unique id for the row. | |
| guest_id | integer | One person in a household. Links to guests. | |
| attraction_id | integer | The ride, show or slide. Links to attractions. | |
| ride_date | date | The day. | 2018-01-01 to 2025-12-31 |
| queue_entered_at | date and time | When they joined the line. | 2018-01-01 09:00 to 2025-12-31 22:54 |
| boarded_at | date and time | When they boarded. | 2018-01-01 09:03 to 2025-12-31 22:57 |
| wait_minutes | integer | Minutes in line. | 0 to 264 |
| used_express_lane | true/false | True when they used the skip-the-line entrance. |
How it connects
This table points to
- guest_id matches guests.guest_id
- attraction_id matches attractions.attraction_id
First five rows
Taken from the Sample size, exactly as they appear in the file. Empty cells are empty in the data.
| ride_event_id | guest_id | attraction_id | ride_date | queue_entered_at | boarded_at | wait_minutes | used_express_lane |
|---|---|---|---|---|---|---|---|
| 20000595 | 10804071 | 114 | 2018-01-01 | 2018-01-01 09:31:06 | 2018-01-01 09:50:29 | 19 | false |
| 20000596 | 10804072 | 114 | 2018-01-01 | 2018-01-01 09:31:06 | 2018-01-01 09:50:29 | 19 | false |
| 20000597 | 10804073 | 114 | 2018-01-01 | 2018-01-01 09:31:06 | 2018-01-01 09:50:29 | 19 | false |
| 20000598 | 10804074 | 114 | 2018-01-01 | 2018-01-01 09:31:06 | 2018-01-01 09:50:29 | 19 | false |
| 20000599 | 10804075 | 114 | 2018-01-01 | 2018-01-01 09:31:06 | 2018-01-01 09:50:29 | 19 | false |