Dataset

dominicks-scanner-dataset Data Contract Specification v1.1.0
scanner-dataset

Info

Information about the dataset

Dataset-page
Manual
Mehrhoff-paper
Title
Dominicks finer foods scanner dataset
Version
1.0
Description
A dataset made up of 9 years of transaction (scanner) data for 26 different categories in 100 stores sold by Dominick's finer foods (a now defunct retailer in Chicago in the 90s).
Owner
Chicago Booth School of Business
Contact
Chicago Booth School of Business

Terms

Terms and conditions of the dataset

Usage
Open dataset on seasonal products shared by Chicago Booth School Kilts Center for Marketing

Cite as:
APA:
TBC

Chicago:
TBC

BibTeX:
 @misc{dominiks_dataset,
 author = {Chicago Booth School},
 title = {Dominicks Finer Foods Dataset},
 year = {2022},
 doi = https://doi.org/10.2785/873932,
 howpublished = {\url{https://circabc.europa.eu/ui/group/7b031f10-ac19-4da3-a36f-58708a70133d/library/e52b1b37-38f3-4f2d-82be-14b005da1ce3/details}},
 note = {Accessed: YYYY-MM-DD} % Optional: date accessed 
 }
Limitations
None

Entity Relationship Diagram

Visual representation of data model relationships

                    erDiagram
	"**movement**" {
	STORE int
	UPC bigint
	WEEK int
	MOVE int
	QTY int
	PRICE float
	SALES float
}
	"**upc**" {
	UPC bigint
	DESCRIP text
	NITEM bigint
	COM_CODE int
	SIZE bigint
}

Data Model

The logical data model

movement table
The movement (or turnover) data. Schema identical but this is provided separately for each of the 26 categories.
STORE
int
Store number (references store data on https://github.com/eurostat/dff/blob/master/CSV/stores.csv)
Example: 76
primary
UPC
bigint
Universal Product Code for sold product
Example: 1192603016
primary
WEEK
int
Week number representing the sales (references weeks data on https://github.com/eurostat/dff/blob/master/CSV/weeks.csv)
Example: 306
primary
MOVE
int
Number of units sold
Example: 1
QTY
int
Quantity of products sold
Example: 1
PRICE
float
Price a product (i.e. the UPC) was sold for
Example: 2.99
SALES
float
Derived variable for sales per UPC (SALES = PRICE x MOVE / QTY)
Example: 2.99
upc table
List of unique products (tracked by UPC) sold by category
UPC
bigint
Universal Product Code for sold product
Example: 1192603016
primary
DESCRIP
text
Description of the product (i.e. the UPC)
Example: CAFFEDRINE CAPLETS 1
NITEM
bigint
Item code (attempt at tracking products across multiple UPCs)
Example: 7342431
COM_CODE
int
Commodity code (Dominick's version of categories). Lower granularity that each category file, hence one file may have more than one COM_CODE
Example: 953
SIZE
bigint
Size of the product
Example: 16 CT
Created at 01 Oct 2025 02:51:48 UTC with Data Contract CLI v0.10.35

Data Contract YAML

dataContractSpecification: 1.1.0
id: dominicks-scanner-dataset
info:
  title: Dominicks finer foods scanner dataset
  version: '1.0'
  description: A dataset made up of 9 years of transaction (scanner) data for 26 different
    categories in 100 stores sold by Dominick's finer foods (a now defunct retailer
    in Chicago in the 90s).
  owner: Chicago Booth School of Business
  contact:
    name: Chicago Booth School of Business
    url: https://www.chicagobooth.edu/research/kilts/research-data/dominicks
terms:
  usage: ' Open dataset on seasonal products shared by Chicago Booth School Kilts
    Center for Marketing 

 Cite as:
 APA:
 TBC 


    Chicago:
 TBC 

 BibTeX:
 
 @misc{dominiks_dataset,

    author = {Chicago Booth School},
 title = {Dominicks Finer Foods Dataset},

    year = {2022},
 doi = https://doi.org/10.2785/873932,
 howpublished = {\url{https://circabc.europa.eu/ui/group/7b031f10-ac19-4da3-a36f-58708a70133d/library/e52b1b37-38f3-4f2d-82be-14b005da1ce3/details}},

    note = {Accessed: YYYY-MM-DD} % Optional: date accessed 
 } 
 
 '
models:
  movement:
    description: The movement (or turnover) data. Schema identical but this is provided
      separately for each of the 26 categories.
    type: table
    fields:
      STORE:
        type: int
        primary: true
        description: Store number (references store data on https://github.com/eurostat/dff/blob/master/CSV/stores.csv)
        example: '76'
      UPC:
        type: bigint
        primary: true
        description: Universal Product Code for sold product
        example: '1192603016'
      WEEK:
        type: int
        primary: true
        description: Week number representing the sales (references weeks data on
          https://github.com/eurostat/dff/blob/master/CSV/weeks.csv)
        example: '306'
      MOVE:
        type: int
        description: Number of units sold
        example: '1'
      QTY:
        type: int
        description: Quantity of products sold
        example: '1'
      PRICE:
        type: float
        description: Price a product (i.e. the UPC) was sold for
        example: '2.99'
      SALES:
        type: float
        description: Derived variable for sales per UPC (SALES = PRICE x MOVE / QTY)
        example: '2.99'
  upc:
    description: List of unique products (tracked by UPC) sold by category
    type: table
    fields:
      UPC:
        type: bigint
        primary: true
        description: Universal Product Code for sold product
        example: '1192603016'
      DESCRIP:
        type: text
        description: Description of the product (i.e. the UPC)
        example: CAFFEDRINE CAPLETS 1
      NITEM:
        type: bigint
        description: Item code (attempt at tracking products across multiple UPCs)
        example: '7342431'
      COM_CODE:
        type: int
        description: Commodity code (Dominick's version of categories). Lower granularity
          that each category file, hence one file may have more than one COM_CODE
        example: '953'
      SIZE:
        type: bigint
        description: Size of the product
        example: 16 CT
links:
  Dataset-page: https://www.chicagobooth.edu/research/kilts/research-data/dominicks
  Manual: https://www.chicagobooth.edu/-/media/enterprise/centers/kilts/datasets/dominicks-dataset/dominicks-manual-and-codebook_kiltscenter
  Mehrhoff-paper: https://stats.unece.org/ottawagroup/download/f577.pdf
tags:
- scanner-dataset