Amazon Products Dataset (+1M Products)

Scraped dataset from Sep 2023. Contains pricing & sales data

@kaggle.aaronfriasr_amazon_products_dataset

Table List

2 tables(142.34 MB)

Amazon Products

@kaggle.aaronfriasr_amazon_products_dataset.amazon_products

142.33 MB
1426337 rows
11 columns

asin Asin	title Title	imgurl ImgUrl	producturl ProductURL	stars Stars	price Price	listprice ListPrice	category_id Category Id	boughtinlastmonth BoughtInLastMonth
B014TMV5YE	Sion Softside Expandable Roller Luggage, Black, Checked-Large 29-Inch	https://m.media-amazon.com/images/I/815dLQKYIYL._AC_UL320_.jpg	https://www.amazon.com/dp/B014TMV5YE	4.5	139.99		104	2000
B07GDLCQXV	Luggage Sets Expandable PC+ABS Durable Suitcase Double Wheels TSA Lock Blue	https://m.media-amazon.com/images/I/81bQlm7vf6L._AC_UL320_.jpg	https://www.amazon.com/dp/B07GDLCQXV	4.5	169.99	209.99	104	1000
B07XSCCZYG	Platinum Elite Softside Expandable Checked Luggage, 8 Wheel Spinner Suitcase, TSA Lock, Men and Women, True Navy Blue, Checked Medium 25-Inch	https://m.media-amazon.com/images/I/71EA35zvJBL._AC_UL320_.jpg	https://www.amazon.com/dp/B07XSCCZYG	4.6	365.49	429.99	104	300
B08MVFKGJM	Freeform Hardside Expandable with Double Spinner Wheels, Navy, 2-Piece Set (21/28)	https://m.media-amazon.com/images/I/91k6NYLQyIL._AC_UL320_.jpg	https://www.amazon.com/dp/B08MVFKGJM	4.6	291.59	354.37	104	400
B01DJLKZBA	Winfield 2 Hardside Expandable Luggage with Spinner Wheels, Checked-Large 28-Inch, Deep Blue	https://m.media-amazon.com/images/I/61NJoaZcP9L._AC_UL320_.jpg	https://www.amazon.com/dp/B01DJLKZBA	4.5	174.99	309.99	104	400
B07XSCD2R4	Maxlite 5 Softside Expandable Luggage with 4 Spinner Wheels, Lightweight Suitcase, Men and Women, Sapphire Blue, Carry-On 21-Inch	https://m.media-amazon.com/images/I/61LnBNsSBSL._AC_UL320_.jpg	https://www.amazon.com/dp/B07XSCD2R4	4.5	144.49		104	500
B07MXF4G8K	Hard Shell Carry on Luggage Airline Approved, Carry on Suitcases with Wheels, Lightweight PC Luminous Textured Travel Luggage, TSA Approved, 20 Inch Small Carry-On, Black	https://m.media-amazon.com/images/I/71CghLYrnAL._AC_UL320_.jpg	https://www.amazon.com/dp/B07MXF4G8K	4.5	169.99		104	400
B07H515VCZ	Maxporter II 30" Hardside Spinner Trunk Luggage, Expandable, Navy	https://m.media-amazon.com/images/I/81f3h+YHOXL._AC_UL320_.jpg	https://www.amazon.com/dp/B07H515VCZ	4.5	299.99		104	100
B08BXBCNMQ	Omni 2 Hardside Expandable Luggage with Spinner Wheels, Checked-Large 28-Inch, Arctic Silver	https://m.media-amazon.com/images/I/91eOWP4mySL._AC_UL320_.jpg	https://www.amazon.com/dp/B08BXBCNMQ	4.5	112.63	137.04	104	500
B0B9K44XTS	Luggage Sets Expandable Lightweight Suitcases with Wheels PC+ABS Durable Travel Luggage TSA Lock Navy Blue 4pcs	https://m.media-amazon.com/images/I/81dsv5GrCLL._AC_UL320_.jpg	https://www.amazon.com/dp/B0B9K44XTS	4.4	209.99		104	200


CREATE TABLE amazon_products (
  "asin" VARCHAR,
  "title" VARCHAR,
  "imgurl" VARCHAR,
  "producturl" VARCHAR,
  "stars" DOUBLE,
  "reviews" BIGINT,
  "price" DOUBLE,
  "listprice" DOUBLE,
  "category_id" BIGINT,
  "isbestseller" BOOLEAN,
  "boughtinlastmonth" BIGINT
);