survey_responses
Answers to the survey sent after a trip or pass visit. One row is one completed survey.
- One row is
- one completed survey
- Columns
- 9
- Rows in Sample
- 3,317
- Rows in Standard
- 33,415
- Rows in Full
- 333,574
Columns
| Column | Type | What it holds | Values or range |
|---|---|---|---|
| survey_idkey | integer | Unique id for the row. | |
| household_id | integer | The travelling party's account. Links to households. | |
| booking_id | integer | The trip. Empty for annual pass surveys. Can be empty. | |
| survey_type | text | Which survey. | pass holder visit; post-trip |
| submitted_at | date and time | When it was completed. | 2018-01-01 05:33 to 2026-01-23 01:26 |
| overall_rating | integer | Overall rating of the visit, 0 to 10. | 0 to 10 |
| likelihood_to_recommend | integer | 0 to 10. | 0 to 10 |
| plans_to_return | true/false | True when they said they plan to come back. | |
| comment | text | Free text, when given. Can be empty. |
How it connects
This table points to
- household_id matches households.household_id
- booking_id matches bookings.booking_id
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.
| survey_id | household_id | booking_id | survey_type | submitted_at | overall_rating | likelihood_to_recommend | plans_to_return | comment |
|---|---|---|---|---|---|---|---|---|
| 40000537 | 1026507 | 5003623 | post-trip | 2018-01-05 14:52:20 | 8 | 6 | true | Writing this from the hotel. Our mobile order at Squall Snacks showed ready and then sa... |
| 40000217 | 1083707 | 5001474 | post-trip | 2018-01-06 13:26:10 | 5 | 7 | false | |
| 40308720 | 1033707 | pass holder visit | 2018-01-09 04:44:09 | 9 | 10 | true | ||
| 40000861 | 1041907 | 5005977 | post-trip | 2018-01-10 09:55:20 | 10 | 10 | true | |
| 40000549 | 1054607 | 5003700 | post-trip | 2018-01-10 14:26:31 | 7 | 5 | true |