pass_products
Annual pass products that have been on sale. One row is one pass product.
- One row is
- one pass product
- Columns
- 6
- Rows in Sample
- 5
- Rows in Standard
- 5
- Rows in Full
- 5
This table describes the company, not individual guests, so it is identical in all three sizes.
Columns
| Column | Type | What it holds | Values or range |
|---|---|---|---|
| pass_product_idkey | integer | Unique id for the row. | |
| pass_name | text | Name. | Faro Pass; Marea Pass; Sol Pass; Velaluz Annual Pass; Velaluz Premier Pass |
| sold_from | date | First day on sale. Empty means on sale before 2018. Can be empty. | 2024-01-08 to 2024-01-08 |
| sold_until | date | Last day on sale. Empty means still on sale. Can be empty. | 2024-01-08 to 2024-01-08 |
| blocked_dates | text | Days the pass cannot be used. | none; peak dates; weekends, holiday periods and peak dates |
| includes_water_park | true/false | True when the pass admits to Playa Zambulla. |
How it connects
Tables that point here
First five rows
Taken from the Sample size, exactly as they appear in the file. Empty cells are empty in the data.
| pass_product_id | pass_name | sold_from | sold_until | blocked_dates | includes_water_park |
|---|---|---|---|---|---|
| 1 | Velaluz Annual Pass | 2024-01-08 | none | false | |
| 2 | Velaluz Premier Pass | 2024-01-08 | none | true | |
| 3 | Sol Pass | 2024-01-08 | weekends, holiday periods and peak dates | true | |
| 4 | Marea Pass | 2024-01-08 | peak dates | true | |
| 5 | Faro Pass | 2024-01-08 | none | true |