Skip to content

express_purchases

Sales of Paso Rapido, the paid skip-the-line product. One row is one purchase for one park day.

One row is
one purchase for one park day
Columns
9
Rows in Sample
3,294
Rows in Standard
33,371
Rows in Full
333,335

Columns

ColumnTypeWhat it holdsValues or range
purchase_idkeyintegerUnique id for the row.
household_idintegerThe travelling party's account. Links to households.
booking_idintegerThe trip. Empty for annual pass visits. Can be empty.
park_codetextCE Costa Encandela, PT Punta Tormenta, PY Playa Zambulla. Links to parks.CE; PT
visit_datedateDay it was valid.2022-02-14 to 2025-12-31
purchased_atdate and timeWhen it was bought.2022-02-14 09:21 to 2025-12-31 18:59
guestsintegerPeople covered.1 to 9
price_per_guestdecimalPrice per person in dollars.23 to 59.62
total_paiddecimalTotal in dollars.23 to 536.56

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.

purchase_idhousehold_idbooking_idpark_codevisit_datepurchased_atguestsprice_per_guesttotal_paid
200003115349075931116PT2022-02-142022-02-14 11:47:05535175
200006615353075931963CE2022-02-142022-02-14 11:12:51335105
20003061173507CE2022-02-152022-02-15 10:26:5113333
200037515360075933362CE2022-02-162022-02-16 10:31:3833296
200048615361075933741PT2022-02-172022-02-17 11:25:3223366

Download from Kaggle