park_hours
Opening hours for each park on each day. One row is one park on one day.
- One row is
- one park on one day
- Columns
- 6
- Rows in Sample
- 8,766
- Rows in Standard
- 8,766
- Rows in Full
- 8,766
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 |
|---|---|---|---|
| datekey | date | The day. Links to calendar. | |
| park_codekey | text | CE Costa Encandela, PT Punta Tormenta, PY Playa Zambulla. Links to parks. | CE; PT; PY |
| is_open | true/false | False when the park did not open. | |
| open_hour | integer | Opening hour on a 24-hour clock. -1 when closed. Can be empty. | 9 to 10 |
| close_hour | integer | Closing hour on a 24-hour clock. -1 when closed. Can be empty. | 14 to 23 |
| closure_reason | text | Why the park was closed, when it was. Can be empty. | cold weather; hurricane; seasonal refurbishment |
How it connects
This table points to
- park_code matches parks.park_code
- date matches calendar.date
First five rows
Taken from the Sample size, exactly as they appear in the file. Empty cells are empty in the data.
| date | park_code | is_open | open_hour | close_hour | closure_reason |
|---|---|---|---|---|---|
| 2018-01-01 | CE | true | 9 | 23 | |
| 2018-01-02 | CE | true | 9 | 23 | |
| 2018-01-03 | CE | true | 9 | 21 | |
| 2018-01-04 | CE | true | 9 | 21 | |
| 2018-01-05 | CE | true | 9 | 21 |