Skip to content

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

ColumnTypeWhat it holdsValues or range
reservation_idkeyintegerUnique id for the row.
household_idintegerThe travelling party's account. Links to households.
venue_idintegerThe restaurant, bar, stand or shop. Links to venues.
reserved_fordate and timeDate and time of the table.2018-01-01 10:45 to 2025-12-31 21:45
party_sizeintegerGuests expected.1 to 9
booked_atdate and timeWhen the reservation was made.2017-11-10 16:26 to 2025-12-31 15:44
statustextWhether the party showed up.cancelled; completed; no show
transaction_idintegerThe bill, when the party dined. Links to transactions. Can be empty.

How it connects

First five rows

Taken from the Sample size, exactly as they appear in the file. Empty cells are empty in the data.

reservation_idhousehold_idvenue_idreserved_forparty_sizebooked_atstatustransaction_id
6000011710817071092018-01-01 13:00:0062017-12-27 15:59:36completed100002638
6000011810139071042018-01-01 13:00:0032017-12-31 18:49:40completed100002617
6000012010139071042018-01-01 13:00:0032017-12-31 20:08:20cancelled
6000018410815075012018-01-01 17:45:0042017-12-08 17:37:55completed100004699
6000032610815074212018-01-01 19:00:0042017-12-29 17:52:23completed100005433

Download from Kaggle