Skip to content

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

ColumnTypeWhat it holdsValues or range
pass_idkeyintegerUnique id for the row.
guest_idintegerOne person in a household. Links to guests.
household_idintegerThe travelling party's account. Links to households.
pass_product_idintegerLinks to pass_products.
start_datedateFirst valid day.2017-01-02 to 2025-12-31
end_datedateExpiry date.2018-01-02 to 2026-12-31
price_paiddecimalPrice in dollars.0 to 986
is_renewaltrue/falseTrue when this pass follows an earlier one.
renewed_at_expirytrue/falseTrue when the holder bought another pass when this one ended. Can be empty.

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.

pass_idguest_idhousehold_idpass_product_idstart_dateend_dateprice_paidis_renewalrenewed_at_expiry
300044410000071100000712017-01-142018-01-14434falsefalse
300044510000072100000712017-01-142018-01-140falsefalse
300044610000073100000712017-01-142018-01-140falsefalse
300071710128071101280712017-01-192018-01-19434falsefalse
300071810128072101280712017-01-192018-01-19434falsefalse

Download from Kaggle