Skip to content

inventory_items

What the resort keeps in stock: ingredients, and goods bought for resale. One row is one stock item.

One row is
one stock item
Columns
7
Rows in Sample
154
Rows in Standard
154
Rows in Full
154

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

Columns

ColumnTypeWhat it holdsValues or range
item_idkeyintegerUnique id for the row.
item_nametextName.
supplier_idintegerLinks to suppliers.
item_typetextIngredient, or resale for goods sold as bought.ingredient; resale
unit_of_measuretextUnit quantities are counted in.bottle; box; case; dozen; each; gal; keg; lb
is_perishabletrue/falseTrue when it spoils.
unit_cost_2018decimalCost per unit in 2018 dollars. Cost in later years is on purchase_order_lines.0.7 to 128

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_iditem_namesupplier_iditem_typeunit_of_measureis_perishableunit_cost_2018
5001Turkey legs1ingredientlbtrue3.1
5002Chicken, breast and thigh1ingredientlbtrue2.9
5003Beef, steaks and ground1ingredientlbtrue7.8
5004Pork, shoulder and ribs1ingredientlbtrue3.6
5005Pasta and noodles1ingredientlbfalse1.4

Download from Kaggle