park_entries
Each time a person entered a park. One row is one person entering one park on one day.
- One row is
- one person entering one park on one day
- Columns
- 9
- Rows in Sample
- 195,989
- Rows in Standard
- 1,959,853
- Rows in Full
- 19,581,106
Columns
| Column | Type | What it holds | Values or range |
|---|---|---|---|
| entry_idkey | integer | Unique id for the row. | |
| guest_id | integer | One person in a household. Links to guests. | |
| household_id | integer | The travelling party's account. Links to households. | |
| booking_id | integer | The trip. Empty for annual pass visits. Can be empty. | |
| park_code | text | CE Costa Encandela, PT Punta Tormenta, PY Playa Zambulla. Links to parks. | CE; PT; PY |
| entry_date | date | The day. | 2018-01-01 to 2025-12-31 |
| entered_at | date and time | Time through the gate. | 2018-01-01 08:51 to 2025-12-31 18:17 |
| exited_at | date and time | Time they left. | 2018-01-01 10:30 to 2025-12-31 23:15 |
| admission_type | text | Ticket or annual pass. | annual pass; ticket |
How it connects
This table points to
- guest_id matches guests.guest_id
- household_id matches households.household_id
- booking_id matches bookings.booking_id
- park_code matches parks.park_code
First five rows
Taken from the Sample size, exactly as they appear in the file. Empty cells are empty in the data.
| entry_id | guest_id | household_id | booking_id | park_code | entry_date | entered_at | exited_at | admission_type |
|---|---|---|---|---|---|---|---|---|
| 9000271 | 10802071 | 1080207 | 5000087 | CE | 2018-01-01 | 2018-01-01 10:07:34 | 2018-01-01 13:16:45 | ticket |
| 9000272 | 10802072 | 1080207 | 5000087 | CE | 2018-01-01 | 2018-01-01 10:07:41 | 2018-01-01 13:14:59 | ticket |
| 9000273 | 10802073 | 1080207 | 5000087 | CE | 2018-01-01 | 2018-01-01 10:07:39 | 2018-01-01 13:17:50 | ticket |
| 9000274 | 10802074 | 1080207 | 5000087 | CE | 2018-01-01 | 2018-01-01 10:07:54 | 2018-01-01 13:16:37 | ticket |
| 9000521 | 10803071 | 1080307 | 5000165 | PT | 2018-01-01 | 2018-01-01 11:04:28 | 2018-01-01 16:52:49 | ticket |