annual_passes
Annual passes, one per person per pass year. One row is one pass for one year.
- One row is
- one pass for one year
- Columns
- 9
- Rows in Sample
- 2,300
- Rows in Standard
- 21,107
- Rows in Full
- 206,991
Columns
| Column | Type | What it holds | Values or range |
|---|---|---|---|
| pass_idkey | integer | Unique id for the row. | |
| guest_id | integer | One person in a household. Links to guests. | |
| household_id | integer | The travelling party's account. Links to households. | |
| pass_product_id | integer | Links to pass_products. | |
| start_date | date | First valid day. | 2017-01-02 to 2025-12-31 |
| end_date | date | Expiry date. | 2018-01-02 to 2026-12-31 |
| price_paid | decimal | Price in dollars. | 0 to 986 |
| is_renewal | true/false | True when this pass follows an earlier one. | |
| renewed_at_expiry | true/false | True when the holder bought another pass when this one ended. Can be empty. |
How it connects
This table points to
- guest_id matches guests.guest_id
- household_id matches households.household_id
- pass_product_id matches pass_products.pass_product_id
First five rows
Taken from the Sample size, exactly as they appear in the file. Empty cells are empty in the data.
| pass_id | guest_id | household_id | pass_product_id | start_date | end_date | price_paid | is_renewal | renewed_at_expiry |
|---|---|---|---|---|---|---|---|---|
| 3000444 | 10000071 | 1000007 | 1 | 2017-01-14 | 2018-01-14 | 434 | false | false |
| 3000445 | 10000072 | 1000007 | 1 | 2017-01-14 | 2018-01-14 | 0 | false | false |
| 3000446 | 10000073 | 1000007 | 1 | 2017-01-14 | 2018-01-14 | 0 | false | false |
| 3000717 | 10128071 | 1012807 | 1 | 2017-01-19 | 2018-01-19 | 434 | false | false |
| 3000718 | 10128072 | 1012807 | 1 | 2017-01-19 | 2018-01-19 | 434 | false | false |