Sales Store Overview

Sales Store Transaction Snapshot

@kaggle.fekihmea_sales_store_overview

Table List

1 table(12.57 KB)

Salesstore

@kaggle.fekihmea_sales_store_overview.salesstore

12.57 KB
216 rows
12 columns

order_date Order Date	ship_date Ship Date	ship_mode Ship Mode	postal_code Postal Code	region Region	product_reference Product Reference	category Category	sub_category Sub Category	sales Sales	quantity Quantity	profit Profit	state State
Mon Feb 15 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Sat Feb 20 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Ground	44104	Midwest	OFF-TAP-10022901	Office Supplies	Tape	5	1	0.15	OH
Mon Feb 15 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Sat Feb 20 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Ground	44104	Midwest	OFF-TAP-10023012	Office Supplies	Tape	5	1	0.15	OH
Mon Feb 15 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Sat Feb 20 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Ground	44104	Midwest	OFF-TAP-10002828	Office Supplies	Tape	5	1	0.15	OH
Mon Feb 15 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Sat Feb 20 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Ground	44104	Midwest	OFF-TAP-10022901	Office Supplies	Tape	5	1	0.15	OH
Mon Feb 15 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Sat Feb 20 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Ground	44104	Midwest	OFF-TAP-10000482	Office Supplies	Tape	5	1	0.15	OH
Wed Mar 10 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Mar 15 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Air	75201	South	FUR-CH-10000454	Electronics	Phones	500	2	10	TX
Wed Mar 10 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Mar 15 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Air	75201	South	FUR-CH-10000454	Electronics	Phones	500	2	10	TX
Wed Mar 10 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Mar 15 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Air	75201	South	FUR-CH-10000454	Furniture	Chairs	500	2	10	TX
Wed Mar 10 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Mar 15 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Air	75201	South	FUR-CH-10000454	Furniture	Chairs	500	2	10	TX
Wed Mar 10 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Mar 15 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Air	75201	South	FUR-CH-10000454	Electronics	Phones	500	2	10	TX


CREATE TABLE salesstore (
  "order_date" TIMESTAMP,
  "ship_date" TIMESTAMP,
  "ship_mode" VARCHAR,
  "postal_code" BIGINT,
  "region" VARCHAR,
  "product_reference" VARCHAR,
  "category" VARCHAR,
  "sub_category" VARCHAR,
  "sales" BIGINT,
  "quantity" BIGINT,
  "profit" DOUBLE,
  "state" VARCHAR
);