Online Retail Dataset

Transactions of a UK-based non-store online retail

@kaggle.ulrikthygepedersen_online_retail_dataset

Table List

1 table(3.55 MB)

Online Retail

@kaggle.ulrikthygepedersen_online_retail_dataset.online_retail

3.55 MB
541909 rows
8 columns

invoiceno InvoiceNo	stockcode StockCode	description Description	quantity Quantity	invoicedate InvoiceDate	unitprice UnitPrice	customerid CustomerID	country Country
536365	85123A	WHITE HANGING HEART T-LIGHT HOLDER	6	Wed Dec 01 2010 08:26:00 GMT+0000 (Coordinated Universal Time)	2.55	17850	United Kingdom
536365	71053	WHITE METAL LANTERN	6	Wed Dec 01 2010 08:26:00 GMT+0000 (Coordinated Universal Time)	3.39	17850	United Kingdom
536365	84406B	CREAM CUPID HEARTS COAT HANGER	8	Wed Dec 01 2010 08:26:00 GMT+0000 (Coordinated Universal Time)	2.75	17850	United Kingdom
536365	84029G	KNITTED UNION FLAG HOT WATER BOTTLE	6	Wed Dec 01 2010 08:26:00 GMT+0000 (Coordinated Universal Time)	3.39	17850	United Kingdom
536365	84029E	RED WOOLLY HOTTIE WHITE HEART.	6	Wed Dec 01 2010 08:26:00 GMT+0000 (Coordinated Universal Time)	3.39	17850	United Kingdom
536365	22752	SET 7 BABUSHKA NESTING BOXES	2	Wed Dec 01 2010 08:26:00 GMT+0000 (Coordinated Universal Time)	7.65	17850	United Kingdom
536365	21730	GLASS STAR FROSTED T-LIGHT HOLDER	6	Wed Dec 01 2010 08:26:00 GMT+0000 (Coordinated Universal Time)	4.25	17850	United Kingdom
536366	22633	HAND WARMER UNION JACK	6	Wed Dec 01 2010 08:28:00 GMT+0000 (Coordinated Universal Time)	1.85	17850	United Kingdom
536366	22632	HAND WARMER RED POLKA DOT	6	Wed Dec 01 2010 08:28:00 GMT+0000 (Coordinated Universal Time)	1.85	17850	United Kingdom
536367	84879	ASSORTED COLOUR BIRD ORNAMENT	32	Wed Dec 01 2010 08:34:00 GMT+0000 (Coordinated Universal Time)	1.69	13047	United Kingdom


CREATE TABLE online_retail (
  "invoiceno" VARCHAR,
  "stockcode" VARCHAR,
  "description" VARCHAR,
  "quantity" BIGINT,
  "invoicedate" TIMESTAMP,
  "unitprice" DOUBLE,
  "customerid" DOUBLE,
  "country" VARCHAR
);