dining_reservations
Table reservations at table service restaurants. One row is one reservation.
- One row is
- one reservation
- Columns
- 8
- Rows in Sample
- 14,623
- Rows in Standard
- 144,358
- Rows in Full
- 1,432,524
Columns
| Column | Type | What it holds | Values or range |
|---|---|---|---|
| reservation_idkey | integer | Unique id for the row. | |
| household_id | integer | The travelling party's account. Links to households. | |
| venue_id | integer | The restaurant, bar, stand or shop. Links to venues. | |
| reserved_for | date and time | Date and time of the table. | 2018-01-01 10:45 to 2025-12-31 21:45 |
| party_size | integer | Guests expected. | 1 to 9 |
| booked_at | date and time | When the reservation was made. | 2017-11-10 16:26 to 2025-12-31 15:44 |
| status | text | Whether the party showed up. | cancelled; completed; no show |
| transaction_id | integer | The bill, when the party dined. Links to transactions. Can be empty. |
How it connects
This table points to
- household_id matches households.household_id
- venue_id matches venues.venue_id
- transaction_id matches transactions.transaction_id
First five rows
Taken from the Sample size, exactly as they appear in the file. Empty cells are empty in the data.
| reservation_id | household_id | venue_id | reserved_for | party_size | booked_at | status | transaction_id |
|---|---|---|---|---|---|---|---|
| 60000117 | 1081707 | 109 | 2018-01-01 13:00:00 | 6 | 2017-12-27 15:59:36 | completed | 100002638 |
| 60000118 | 1013907 | 104 | 2018-01-01 13:00:00 | 3 | 2017-12-31 18:49:40 | completed | 100002617 |
| 60000120 | 1013907 | 104 | 2018-01-01 13:00:00 | 3 | 2017-12-31 20:08:20 | cancelled | |
| 60000184 | 1081507 | 501 | 2018-01-01 17:45:00 | 4 | 2017-12-08 17:37:55 | completed | 100004699 |
| 60000326 | 1081507 | 421 | 2018-01-01 19:00:00 | 4 | 2017-12-29 17:52:23 | completed | 100005433 |