PRODUCT PRICE DATASET

Data for over a decade's period by UK’s Office for National Statistics

@kaggle.sujaykapadnis_price_quote_data

Table List

1 table(1.4 MB)

Upload Pricequotes202301

@kaggle.sujaykapadnis_price_quote_data.upload_pricequotes202301

1.4 MB
139419 rows
20 columns

quote_date QUOTE DATE	item_id ITEM ID	item_desc ITEM DESC	validity VALIDITY	shop_code SHOP CODE	price PRICE	indicator_box INDICATOR BOX	orig_indicator_box ORIG INDICATOR BOX	price_relative PRICE RELATIVE	log_price_relative LOG PRICE RELATIVE	stratum_weight STRATUM WEIGHT	stratum_type STRATUM TYPE	start_date START DATE	end_date END DATE	region REGION	shop_type SHOP TYPE	shop_weight SHOP WEIGHT	base_price BASE PRICE	base_validity BASE VALIDITY	stratum_cell STRATUM CELL
202301	210102	LGE LOAF-WHTE-UNSLED-750-800G	3	801	1.3	nan	nan	1.13	0.123	11.92	1	202202	999999	2	1	1	1.15	3	2
202301	210102	LGE LOAF-WHTE-UNSLED-750-800G	3	802	2	nan	nan	1.429	0.357	11.92	1	202202	999999	2	1	1	1.4	3	2
202301	210102	LGE LOAF-WHTE-UNSLED-750-800G	3	803	1.25	nan	nan	1.087	0.083	11.92	1	202202	999999	2	1	1	1.15	3	2
202301	210102	LGE LOAF-WHTE-UNSLED-750-800G	3	807	1.3	nan	nan	1.153	0.142	11.92	1	202204	999999	2	1	2	1.128	4	2
202301	210102	LGE LOAF-WHTE-UNSLED-750-800G	3	808	1.25	nan	nan	1.087	0.083	11.92	1	202202	999999	2	1	2	1.15	3	2
202301	210102	LGE LOAF-WHTE-UNSLED-750-800G	3	814	2.4	nan	nan	1.211	0.192	11.92	1	202203	999999	2	1	1	1.982	4	2
202301	210102	LGE LOAF-WHTE-UNSLED-750-800G	3	941	1.85	nan	nan	1.233	0.21	11.92	1	202202	999999	2	1	1	1.5	3	2
202301	210102	LGE LOAF-WHTE-UNSLED-750-800G	3	801	1.3	nan	nan	1.13	0.123	13.01	1	202202	999999	3	1	1	1.15	3	3
202301	210102	LGE LOAF-WHTE-UNSLED-750-800G	3	802	2	nan	nan	1.429	0.357	13.01	1	202202	999999	3	1	1	1.4	3	3
202301	210102	LGE LOAF-WHTE-UNSLED-750-800G	3	803	1.25	nan	nan	1.087	0.083	13.01	1	202202	999999	3	1	1	1.15	3	3


CREATE TABLE upload_pricequotes202301 (
  "quote_date" BIGINT,
  "item_id" BIGINT,
  "item_desc" VARCHAR,
  "validity" BIGINT,
  "shop_code" BIGINT,
  "price" DOUBLE,
  "indicator_box" VARCHAR,
  "orig_indicator_box" VARCHAR,
  "price_relative" DOUBLE,
  "log_price_relative" DOUBLE,
  "stratum_weight" DOUBLE,
  "stratum_type" BIGINT,
  "start_date" BIGINT,
  "end_date" BIGINT,
  "region" BIGINT,
  "shop_type" BIGINT,
  "shop_weight" BIGINT,
  "base_price" DOUBLE,
  "base_validity" BIGINT,
  "stratum_cell" BIGINT
);