Skip to content

transactions

Register sales at every venue. One row is one sale.

One row is
one sale
Columns
16
Rows in Sample
214,462
Rows in Standard
2,147,571
Rows in Full
21,438,303

Columns

ColumnTypeWhat it holdsValues or range
transaction_idkeyintegerUnique id for the row.
transacted_atdate and timeWhen the order was placed.2018-01-01 06:30 to 2025-12-31 23:04
venue_idintegerThe restaurant, bar, stand or shop. Links to venues.
employee_idintegerThe cashier. Links to employees.
household_idintegerThe household, when the sale could be tied to one. Empty for walk-up visitors. Can be empty.
booking_idintegerThe trip the sale happened on, when known. Can be empty.
order_channeltextCounter, table or mobile order.counter; mobile order; table service
payment_methodtextHow it was paid. The two register systems label the same methods differently.AMEX; CASH; Card; Cash; DISC; GIFT; Gift Card; MC; MOBILE; Mobile Wallet; ROOM; Room Charge; VISA
guests_servedintegerPeople the order was for. Can be empty.1 to 9
subtotaldecimalSum of the lines before discount and tax.3.25 to 1,044
discount_amountdecimalDiscount taken off.0 to 103.04
discount_codetextPromotion applied. Links to promotions. Can be empty.MOBILE5; PASSHOLDER
tax_amountdecimalSales tax.0.21 to 73.08
total_amountdecimalAmount charged: subtotal less discount plus tax.3.14 to 1,117.08
ready_atdate and timeWhen a food order was ready. Empty for shops. Can be empty.2018-01-01 06:32 to 2025-12-31 23:02
source_systemtextRegister system that recorded the sale.LegacyPOS; VelaluzPOS

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.

transaction_idtransacted_atvenue_idemployee_idhousehold_idbooking_idorder_channelpayment_methodguests_servedsubtotaldiscount_amountdiscount_codetax_amounttotal_amountready_atsource_system
1010487972018-06-16 13:40:4810621585310619075092443counterROOM1701.1918.192018-06-16 13:45:21LegacyPOS
1010488072018-06-16 13:41:24202215782counterCASH3002.132.12018-06-16 13:44:23LegacyPOS
1010488492018-06-16 13:44:342092000081106907counterVISA122.4712.25PASSHOLDER7.72117.942018-06-16 13:52:07LegacyPOS
1010489072018-06-16 13:49:44506207468counterVISA44.4803.1147.592018-06-16 13:54:59LegacyPOS
1010490072018-06-16 13:58:04512209311counterVISA90.9806.3797.35LegacyPOS

Download from Kaggle