tickets
Park tickets, one per person per trip. One row is one ticket.
- One row is
- one ticket
- Columns
- 9
- Rows in Sample
- 69,206
- Rows in Standard
- 704,115
- Rows in Full
- 7,063,649
Columns
| Column | Type | What it holds | Values or range |
|---|---|---|---|
| ticket_idkey | integer | The booking_id followed by one digit for the person. | |
| booking_id | integer | The trip this row belongs to. Links to bookings. | |
| guest_id | integer | One person in a household. Links to guests. | |
| age_class | text | Adult, child or infant. | adult; child; infant |
| ticket_days | integer | Days of admission. | 1 to 8 |
| includes_water_park | true/false | True when the ticket admits to Playa Zambulla. | |
| price_paid | decimal | Total paid for the ticket in dollars. | 0 to 620.53 |
| purchased_at | date | Date bought. | 2016-06-28 to 2025-12-31 |
| valid_from | date | First day it can be used. | 2017-12-19 to 2025-12-31 |
How it connects
This table points to
- booking_id matches bookings.booking_id
- guest_id matches guests.guest_id
First five rows
Taken from the Sample size, exactly as they appear in the file. Empty cells are empty in the data.
| ticket_id | booking_id | guest_id | age_class | ticket_days | includes_water_park | price_paid | purchased_at | valid_from |
|---|---|---|---|---|---|---|---|---|
| 50000871 | 5000087 | 10802071 | adult | 3 | false | 231.84 | 2017-12-24 | 2017-12-31 |
| 50000872 | 5000087 | 10802072 | adult | 3 | false | 231.84 | 2017-12-24 | 2017-12-31 |
| 50000873 | 5000087 | 10802073 | infant | 3 | false | 0 | 2017-12-24 | 2017-12-31 |
| 50000874 | 5000087 | 10802074 | child | 3 | false | 217.93 | 2017-12-24 | 2017-12-31 |
| 50001651 | 5000165 | 10803071 | adult | 6 | false | 314.64 | 2017-12-07 | 2017-12-31 |