wait_snapshots
The wait time posted at each attraction every 15 minutes while its park was open. One row is one attraction at one quarter hour.
- One row is
- one attraction at one quarter hour
- Columns
- 4
- Rows in Sample
- 4,370,700
- Rows in Standard
- 4,370,700
- Rows in Full
- 4,370,700
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 |
|---|---|---|---|
| attraction_idkey | integer | The ride, show or slide. Links to attractions. | |
| snapshot_atkey | date and time | Time of the reading. | |
| posted_wait_minutes | integer | Wait shown on the sign. Empty when not running. Can be empty. | 5 to 220 |
| status | text | Whether the attraction was running. | operating; temporarily closed |
How it connects
This table points to
- 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.
| attraction_id | snapshot_at | posted_wait_minutes | status |
|---|---|---|---|
| 102 | 2018-01-01 09:00:00 | 5 | operating |
| 104 | 2018-01-01 09:00:00 | 5 | operating |
| 105 | 2018-01-01 09:00:00 | 5 | operating |
| 107 | 2018-01-01 09:00:00 | 5 | operating |
| 108 | 2018-01-01 09:00:00 | 5 | operating |