return_vouchers
Vouchers for a free return visit, given after a spoiled day. One row is one voucher.
- One row is
- one voucher
- Columns
- 7
- Rows in Sample
- 1,227
- Rows in Standard
- 12,383
- Rows in Full
- 125,724
Columns
| Column | Type | What it holds | Values or range |
|---|---|---|---|
| voucher_idkey | integer | Unique id for the row. | |
| household_id | integer | The travelling party's account. Links to households. | |
| booking_id | integer | The trip this row belongs to. Links to bookings. | |
| park_code | text | CE Costa Encandela, PT Punta Tormenta, PY Playa Zambulla. Links to parks. | CE; PT; PY |
| issued_date | date | Day issued. | 2018-01-05 to 2025-11-24 |
| expires_date | date | Last day it can be used. | 2019-01-05 to 2026-11-24 |
| reason | text | Why it was given. | weather |
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.
| voucher_id | household_id | booking_id | park_code | issued_date | expires_date | reason |
|---|---|---|---|---|---|---|
| 4000035 | 1081407 | 5000865 | PT | 2018-01-05 | 2019-01-05 | weather |
| 4000093 | 1067307 | 5002330 | CE | 2018-01-05 | 2019-01-05 | weather |
| 4000192 | 1058507 | 5003233 | CE | 2018-01-05 | 2019-01-05 | weather |
| 4000272 | 1026507 | 5003623 | PT | 2018-01-05 | 2019-01-05 | weather |
| 4000281 | 1054607 | 5003700 | PT | 2018-01-05 | 2019-01-05 | weather |