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
| Column | Type | What it holds | Values or range |
|---|---|---|---|
| purchase_idkey | integer | Unique id for the row. | |
| 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 |
| visit_date | date | Day it was valid. | 2022-02-14 to 2025-12-31 |
| purchased_at | date and time | When it was bought. | 2022-02-14 09:21 to 2025-12-31 18:59 |
| guests | integer | People covered. | 1 to 9 |
| price_per_guest | decimal | Price per person in dollars. | 23 to 59.62 |
| total_paid | decimal | Total in dollars. | 23 to 536.56 |
How it connects
This table points to
- household_id matches households.household_id
- booking_id matches bookings.booking_id
First five rows
Taken from the Sample size, exactly as they appear in the file. Empty cells are empty in the data.
| purchase_id | household_id | booking_id | park_code | visit_date | purchased_at | guests | price_per_guest | total_paid |
|---|---|---|---|---|---|---|---|---|
| 2000031 | 1534907 | 5931116 | PT | 2022-02-14 | 2022-02-14 11:47:05 | 5 | 35 | 175 |
| 2000066 | 1535307 | 5931963 | CE | 2022-02-14 | 2022-02-14 11:12:51 | 3 | 35 | 105 |
| 2000306 | 1173507 | CE | 2022-02-15 | 2022-02-15 10:26:51 | 1 | 33 | 33 | |
| 2000375 | 1536007 | 5933362 | CE | 2022-02-16 | 2022-02-16 10:31:38 | 3 | 32 | 96 |
| 2000486 | 1536107 | 5933741 | PT | 2022-02-17 | 2022-02-17 11:25:32 | 2 | 33 | 66 |