complaints
Complaints received through any channel, with the guest's own words. One row is one complaint.
- One row is
- one complaint
- Columns
- 15
- Rows in Sample
- 667
- Rows in Standard
- 6,444
- Rows in Full
- 64,966
Columns
| Column | Type | What it holds | Values or range |
|---|---|---|---|
| complaint_idkey | integer | Unique id for the row. | |
| received_at | date and time | When it came in. | 2018-01-01 01:48 to 2025-12-31 23:26 |
| household_id | integer | The household, when known. Can be empty. | |
| booking_id | integer | The trip, when known. Can be empty. | |
| channel | text | How it arrived. | call center; email; guest services desk; mobile app; social media |
| category | text | Category chosen by the agent who logged it. | Accessibility; Cleanliness; Food & Beverage; Hotel; Mobile App; Other; Rides & Wait Times; Staff; Ticketing & Billing; Weather Policy |
| severity | text | Low, medium or high. | high; low; medium |
| park_code | text | The park it concerns, if any. Can be empty. | CE; PT; PY |
| venue_id | integer | The venue it concerns, if any. Can be empty. | |
| attraction_id | integer | The attraction it concerns, if any. Can be empty. | |
| hotel_id | integer | The hotel it concerns, if any. Can be empty. | |
| complaint_text | text | What the guest wrote or said. | |
| status | text | Open or resolved. | open; resolved |
| resolved_at | date and time | When it was resolved. Can be empty. | 2018-01-01 01:39 to 2025-12-31 23:36 |
| resolution | text | What was done. Can be empty. | apology; explanation given; forwarded to another team; meal voucher; no action; partial refund; return ticket |
How it connects
This table points to
- household_id matches households.household_id
- booking_id matches bookings.booking_id
- venue_id matches venues.venue_id
- attraction_id matches attractions.attraction_id
First five rows
Taken from the Sample size, exactly as they appear in the file. Empty cells are empty in the data.
| complaint_id | received_at | household_id | booking_id | channel | category | severity | park_code | venue_id | attraction_id | hotel_id | complaint_text | status | resolved_at | resolution |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 70000053 | 2018-01-04 13:05:53 | 1080407 | 5000265 | call center | Food & Beverage | low | PT | 204 | Hi, Our mobile order at The Rivet Room showed ready and then sat for 46 minutes. | resolved | 2018-01-05 05:17:57 | apology | ||
| 70000207 | 2018-01-14 09:29:55 | Cleanliness | medium | CE | Hi, The restroom by Constellation Coaster had no soap and no paper towels. Thanks. | resolved | 2018-01-17 02:20:29 | apology | ||||||
| 70000375 | 2018-01-21 16:52:32 | 1092107 | 5010514 | guest services desk | Hotel | medium | 1 | Writing this from the hotel. Housekeeping skipped our room at Palmetto Court two days i... | resolved | 2018-01-22 06:40:30 | no action | |||
| 70000389 | 2018-01-22 16:01:35 | 1010407 | call center | Rides & Wait Times | medium | PT | 204 | Hi, The lines at Punta Tormenta were out of control. We got on 4 rides the whole day. W... | resolved | 2018-01-23 21:54:13 | explanation given | |||
| 70000421 | 2018-01-24 10:33:10 | 1057207 | 5010835 | guest services desk | Rides & Wait Times | medium | PT | 213 | Writing this from the hotel. It would help if the app sent a message when a closed ride... | resolved | 2018-01-25 04:56:03 | no action |