Online Retail II UCI

A real online retail transaction data set of two years.

@kaggle.mashlyn_online_retail_ii_uci

Table List

1 table(7.02 MB)

Online Retail Ii

@kaggle.mashlyn_online_retail_ii_uci.online_retail_ii

7.02 MB
1067371 rows
8 columns

invoice Invoice	stockcode StockCode	description Description	quantity Quantity	invoicedate InvoiceDate	price Price	customer_id Customer ID	country Country
489434	85048	15CM CHRISTMAS GLASS BALL 20 LIGHTS	12	Tue Dec 01 2009 07:45:00 GMT+0000 (Coordinated Universal Time)	6.95	13085	United Kingdom
489434	79323P	PINK CHERRY LIGHTS	12	Tue Dec 01 2009 07:45:00 GMT+0000 (Coordinated Universal Time)	6.75	13085	United Kingdom
489434	79323W	WHITE CHERRY LIGHTS	12	Tue Dec 01 2009 07:45:00 GMT+0000 (Coordinated Universal Time)	6.75	13085	United Kingdom
489434	22041	RECORD FRAME 7" SINGLE SIZE	48	Tue Dec 01 2009 07:45:00 GMT+0000 (Coordinated Universal Time)	2.1	13085	United Kingdom
489434	21232	STRAWBERRY CERAMIC TRINKET BOX	24	Tue Dec 01 2009 07:45:00 GMT+0000 (Coordinated Universal Time)	1.25	13085	United Kingdom
489434	22064	PINK DOUGHNUT TRINKET POT	24	Tue Dec 01 2009 07:45:00 GMT+0000 (Coordinated Universal Time)	1.65	13085	United Kingdom
489434	21871	SAVE THE PLANET MUG	24	Tue Dec 01 2009 07:45:00 GMT+0000 (Coordinated Universal Time)	1.25	13085	United Kingdom
489434	21523	FANCY FONT HOME SWEET HOME DOORMAT	10	Tue Dec 01 2009 07:45:00 GMT+0000 (Coordinated Universal Time)	5.95	13085	United Kingdom
489435	22350	CAT BOWL	12	Tue Dec 01 2009 07:46:00 GMT+0000 (Coordinated Universal Time)	2.55	13085	United Kingdom
489435	22349	DOG BOWL , CHASING BALL DESIGN	12	Tue Dec 01 2009 07:46:00 GMT+0000 (Coordinated Universal Time)	3.75	13085	United Kingdom


CREATE TABLE online_retail_ii (
  "invoice" VARCHAR,
  "stockcode" VARCHAR,
  "description" VARCHAR,
  "quantity" BIGINT,
  "invoicedate" TIMESTAMP,
  "price" DOUBLE,
  "customer_id" DOUBLE,
  "country" VARCHAR
);