Skip to content

inventory_daily

Stock position of every item at the central warehouse, every day. One row is one stock item on one day.

One row is
one stock item on one day
Columns
7
Rows in Sample
449,988
Rows in Standard
449,988
Rows in Full
449,988

This table describes the company, not individual guests, so it is identical in all three sizes.

Columns

ColumnTypeWhat it holdsValues or range
item_idkeyintegerThe stock item. Links to inventory_items.
datekeydateThe day. Links to calendar.
opening_quantitydecimalOn hand at the start of the day.0 to 21,938.95
received_quantitydecimalDelivered that day.0 to 26,231
used_quantitydecimalUsed that day, worked out from what was sold and the recipes.0 to 8,684.08
wasted_quantitydecimalThrown out that day.0 to 1,512.22
closing_quantitydecimalOn hand at the end of the day: opening plus received less used less wasted.0 to 21,938.95

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.

item_iddateopening_quantityreceived_quantityused_quantitywasted_quantityclosing_quantity
50012018-01-01186.170168.79017.38
50012018-01-0217.38564.1177.471.74402.27
50012018-01-03402.270174.570227.7
50012018-01-04227.70165.89061.81
50012018-01-0561.81644.4115.746.18584.29

Download from Kaggle