refunds
Refund requests of every kind. One row is one request.
- One row is
- one request
- Columns
- 12
- Rows in Sample
- 1,216
- Rows in Standard
- 12,536
- Rows in Full
- 124,826
Columns
| Column | Type | What it holds | Values or range |
|---|---|---|---|
| refund_idkey | integer | Unique id for the row. | |
| household_id | integer | The household, when known. Can be empty. | |
| booking_id | integer | The trip, for trip and ticket refunds. Can be empty. | |
| transaction_id | integer | The sale, for purchase refunds. Can be empty. | |
| refund_type | text | What the refund is for. | booking; purchase; skip-the-line; ticket |
| reason | text | Reason given. | billing error; changed mind; damaged item; duplicate charge; early departure; food quality; hurricane closure; illness; long wait; ride closures; room issue; travel disruption; weather; wrong order; wrong size |
| request_channel | text | Where the request was made. | at the venue; call center; guest services desk; mobile app; web form |
| requested_at | date and time | When it was made. | 2018-01-01 08:26 to 2025-12-31 22:00 |
| amount_requested | decimal | Dollars asked for. | 1 to 14,272.47 |
| status | text | Paid or rejected. | paid; rejected |
| amount_refunded | decimal | Dollars paid. 0 when rejected. | 0 to 14,272.47 |
| closed_at | date and time | When the request was closed. | 2018-01-01 08:36 to 2026-01-15 07:52 |
How it connects
This table points to
- household_id matches households.household_id
- booking_id matches bookings.booking_id
- transaction_id matches transactions.transaction_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.
| refund_id | household_id | booking_id | transaction_id | refund_type | reason | request_channel | requested_at | amount_requested | status | amount_refunded | closed_at |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 80000044 | 100016207 | purchase | long wait | at the venue | 2018-01-03 14:26:38 | 8.33 | paid | 8.33 | 2018-01-03 14:30:59 | ||
| 80000369 | 100081707 | purchase | wrong order | call center | 2018-01-15 12:59:59 | 26.87 | paid | 26.87 | 2018-01-16 22:36:38 | ||
| 80000410 | 1057007 | 100091960 | purchase | wrong order | at the venue | 2018-01-17 14:30:49 | 24.05 | paid | 24.05 | 2018-01-17 14:38:37 | |
| 80000416 | 1047107 | 100092625 | purchase | food quality | at the venue | 2018-01-17 17:14:09 | 21.94 | paid | 21.94 | 2018-01-17 17:20:19 | |
| 80000629 | 1002907 | 5009621 | booking | billing error | guest services desk | 2018-01-27 10:34:15 | 15 | paid | 15 | 2018-01-30 05:11:24 |