Skip to content

products

Everything sold at a register: menu items and merchandise. One row is one product.

One row is
one product
Columns
8
Rows in Sample
367
Rows in Standard
367
Rows in Full
367

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

Columns

ColumnTypeWhat it holdsValues or range
product_idkeyintegerUnique id for the row.
product_nametextName.
departmenttextFood & Beverage or Merchandise, as classified today.Food & Beverage; Merchandise
category_codeintegerCurrent category code.1100 to 2500
category_nametextCurrent category name.Apparel & Headwear; Beer, Wine & Spirits; Beverages; Desserts & Sweets; Entrees; Home & Gifts; Kids Meals; Sides & Starters; Souvenirs & Collectibles; Sporting Goods; Toys & Plush
legacy_category_codetextThe code the old register system used for this product.FB-ALC; FB-APP; FB-DES; FB-ENT; FB-KID; FB-NAB; FB-SNK; MR-APP; MR-CND; MR-HOM; MR-JWL; MR-PIN; MR-SOU; MR-SPT; MR-TOY
supplier_idintegerLinks to suppliers.
introduced_datedateDate first sold. Empty means sold since before 2018. Can be empty.2021-05-21 to 2022-11-01

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.

product_idproduct_namedepartmentcategory_codecategory_namelegacy_category_codesupplier_idintroduced_date
10001Grilled Gulf SnapperFood & Beverage1100EntreesFB-ENT4
10002Blackened RedfishFood & Beverage1100EntreesFB-ENT4
10003Shrimp and GritsFood & Beverage1100EntreesFB-ENT4
10004Seared ScallopsFood & Beverage1100EntreesFB-ENT4
10005Lobster LinguineFood & Beverage1100EntreesFB-ENT4

Download from Kaggle