Skip to content

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

ColumnTypeWhat it holdsValues or range
booking_idkeyintegerUnique id for the row.
household_idintegerThe travelling party's account. Links to households.
booking_datedateDate the trip was booked.2016-06-28 to 2025-12-31
arrival_datedateFirst day of the trip.2017-12-19 to 2025-12-31
departure_datedateLast day of the trip.2018-01-01 to 2026-01-12
nightsintegerNights actually stayed. 0 for day visits.0 to 14
nights_bookedintegerNights originally booked.0 to 14
trip_typetextResort hotel, off-site stay or day visit.day visit; off-site stay; resort hotel
party_sizeintegerPeople on the trip.1 to 9
booking_channeltextHow the trip was booked.call center; front gate; mobile app; travel agent; website
ticket_daysintegerDays of park admission bought with the trip. Can be empty.1 to 8
includes_water_parktrue/falseTrue when the tickets include Playa Zambulla. Can be empty.
promo_codetextPromotion applied. Links to promotions. Can be empty.STAYPLAY20
return_voucher_redeemedtrue/falseTrue when a return voucher was used on this trip.
is_first_visittrue/falseTrue for the household's first trip.
statustextWhether the trip went ahead.cancelled: hurricane; completed; cut short by hurricane

How it connects

First five rows

Taken from the Sample size, exactly as they appear in the file. Empty cells are empty in the data.

booking_idhousehold_idbooking_datearrival_datedeparture_datenightsnights_bookedtrip_typeparty_sizebooking_channelticket_daysincludes_water_parkpromo_codereturn_voucher_redeemedis_first_visitstatus
500008710802072017-12-242017-12-312018-01-0222off-site stay4call center3falsefalsefalsecompleted
500016510803072017-12-072017-12-312018-01-0888resort hotel2website6falsefalsetruecompleted
500026510804072017-10-042017-12-312018-01-0555resort hotel5website5truefalsefalsecompleted
500036510805072017-09-092017-12-312018-01-0666resort hotel4website5truefalsetruecompleted
500050510808072017-07-312017-12-302018-01-0122resort hotel6website2falsefalsetruecompleted

Download from Kaggle