Skip to content

product_prices

Price history for each product. One row is one price for one product over a date range.

One row is
one price for one product over a date range
Columns
4
Rows in Sample
2,569
Rows in Standard
2,569
Rows in Full
2,569

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

Columns

ColumnTypeWhat it holdsValues or range
product_idkeyintegerThe item sold to guests. Links to products.
effective_fromkeydateFirst day at this price.
effective_todateLast day at this price. Empty means current. Can be empty.2019-01-31 to 2025-01-31
pricedecimalMenu or shelf price in dollars.3.25 to 144.99

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_ideffective_fromeffective_toprice
100012018-01-012019-01-3132
100012019-02-012020-01-3132.5
100012020-02-012021-01-3133.25
100012021-02-012022-01-3135.5
100012022-02-012023-01-3136.5

Download from Kaggle