bookings
Trips: hotel stays, visits by guests staying off site, and day visits. One row is one trip.
- One row is
- one trip
- Columns
- 16
- Rows in Sample
- 19,324
- Rows in Standard
- 195,304
- Rows in Full
- 1,955,497
Columns
| Column | Type | What it holds | Values or range |
|---|---|---|---|
| booking_idkey | integer | Unique id for the row. | |
| household_id | integer | The travelling party's account. Links to households. | |
| booking_date | date | Date the trip was booked. | 2016-06-28 to 2025-12-31 |
| arrival_date | date | First day of the trip. | 2017-12-19 to 2025-12-31 |
| departure_date | date | Last day of the trip. | 2018-01-01 to 2026-01-12 |
| nights | integer | Nights actually stayed. 0 for day visits. | 0 to 14 |
| nights_booked | integer | Nights originally booked. | 0 to 14 |
| trip_type | text | Resort hotel, off-site stay or day visit. | day visit; off-site stay; resort hotel |
| party_size | integer | People on the trip. | 1 to 9 |
| booking_channel | text | How the trip was booked. | call center; front gate; mobile app; travel agent; website |
| ticket_days | integer | Days of park admission bought with the trip. Can be empty. | 1 to 8 |
| includes_water_park | true/false | True when the tickets include Playa Zambulla. Can be empty. | |
| promo_code | text | Promotion applied. Links to promotions. Can be empty. | STAYPLAY20 |
| return_voucher_redeemed | true/false | True when a return voucher was used on this trip. | |
| is_first_visit | true/false | True for the household's first trip. | |
| status | text | Whether the trip went ahead. | cancelled: hurricane; completed; cut short by hurricane |
How it connects
This table points to
- household_id matches households.household_id
- promo_code matches promotions.promo_code
First five rows
Taken from the Sample size, exactly as they appear in the file. Empty cells are empty in the data.
| booking_id | household_id | booking_date | arrival_date | departure_date | nights | nights_booked | trip_type | party_size | booking_channel | ticket_days | includes_water_park | promo_code | return_voucher_redeemed | is_first_visit | status |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5000087 | 1080207 | 2017-12-24 | 2017-12-31 | 2018-01-02 | 2 | 2 | off-site stay | 4 | call center | 3 | false | false | false | completed | |
| 5000165 | 1080307 | 2017-12-07 | 2017-12-31 | 2018-01-08 | 8 | 8 | resort hotel | 2 | website | 6 | false | false | true | completed | |
| 5000265 | 1080407 | 2017-10-04 | 2017-12-31 | 2018-01-05 | 5 | 5 | resort hotel | 5 | website | 5 | true | false | false | completed | |
| 5000365 | 1080507 | 2017-09-09 | 2017-12-31 | 2018-01-06 | 6 | 6 | resort hotel | 4 | website | 5 | true | false | true | completed | |
| 5000505 | 1080807 | 2017-07-31 | 2017-12-30 | 2018-01-01 | 2 | 2 | resort hotel | 6 | website | 2 | false | false | true | completed |