households
Every travelling party that has an account with the resort. One row is one household.
- One row is
- one household
- Columns
- 10
- Rows in Sample
- 10,026
- Rows in Standard
- 100,251
- Rows in Full
- 1,002,509
Columns
| Column | Type | What it holds | Values or range |
|---|---|---|---|
| household_idkey | integer | Unique id for the row. | |
| home_market | text | Where they travel from: LOCAL lives nearby, DRIVE within a day's drive, FLY rest of the United States, INTL abroad. | DRIVE; FLY; INTL; LOCAL |
| home_country | text | Country of residence. | Argentina; Brazil; Canada; Chile; Colombia; France; Germany; Mexico; Spain; United Kingdom; United States |
| home_state | text | US state. Empty for international households. Can be empty. | |
| party_type | text | Who usually travels together. | ADULT_GROUP; COUPLE; FAMILY_SCHOOL; FAMILY_TEEN; FAMILY_YOUNG; MULTI_GEN; SOLO |
| adults | integer | Adults in the household. | 1 to 6 |
| children | integer | Children in the household. | 0 to 4 |
| income_band | text | Household income band. | 110k to 200k; 60k to 110k; over 200k; under 60k |
| customer_since | date | Date of their first booking or pass. | 1998-07-05 to 2025-12-31 |
| visits_before_2018 | integer | Trips taken before the data starts. | 0 to 11 |
How it connects
Tables that point here
- guests.household_id
- bookings.household_id
- annual_passes.household_id
- park_entries.household_id
- express_purchases.household_id
- return_vouchers.household_id
- dining_reservations.household_id
- transactions.household_id
- refunds.household_id
- experiment_assignments.household_id
- survey_responses.household_id
- complaints.household_id
- campaign_audience.household_id
- event_registrations.household_id
First five rows
Taken from the Sample size, exactly as they appear in the file. Empty cells are empty in the data.
| household_id | home_market | home_country | home_state | party_type | adults | children | income_band | customer_since | visits_before_2018 |
|---|---|---|---|---|---|---|---|---|---|
| 1000007 | LOCAL | United States | FL | FAMILY_YOUNG | 1 | 2 | 60k to 110k | 2016-06-06 | 4 |
| 1000107 | LOCAL | United States | FL | FAMILY_TEEN | 2 | 1 | under 60k | 2016-06-11 | 2 |
| 1000207 | LOCAL | United States | FL | FAMILY_TEEN | 1 | 2 | 110k to 200k | 2012-05-20 | 8 |
| 1000307 | LOCAL | United States | FL | FAMILY_TEEN | 1 | 1 | under 60k | 2017-06-16 | 5 |
| 1000407 | LOCAL | United States | FL | ADULT_GROUP | 5 | 0 | under 60k | 2017-09-04 | 5 |