Amazon User Review Database

Currently limited to Wharton affiliated research

Working with UCSD we have collected a massive (~233 million) collection of Amazon product user reviews spanning nearly 22 (1996-2018) years. Please email us to request access. The database uses Amazon Web Services’ Athena offering and is queryable using SQL. Queries can be made using the AWS console or using an ODBC connection on the HPCC.

Reviews are partitioned by category, year and month.

Examples

SELECT * FROM "user_product_reviews"."edu_upenn_wharton_randa_amazon_user_review_db" 
limit 10;

returns 409cca25-38ac-4a97-9062-a4e0a77644d9

SELECT
regexp_extract(reviewtext, '.{0,50}sucks.{0,50}')
FROM "user_product_reviews"."edu_upenn_wharton_randa_amazon_user_review_db"
WHERE category = 'Home_and_Kitchen'
AND description LIKE '%vacuum%'
AND reviewtext LIKE '%sucks%'
AND overall = 5
limit 10;

Returns

it fine in the model I have and the vacuum really sucks now (pun intended).
I could make a lame joke the fact that it really sucks, but a vacuum this amazing deserves a joke of hi
Never thought I’d give a 5 stars on an item that sucks. And boy, does it ever. I’ve vacuumed everyday fo
xtension, one perfect for those who have cats. It sucks in cat hair like crazy. One head is powered with
irty which proves this cleaner actually works and sucks all the dirts. Highly recommended.
maneuvering around furniture super easy! And it sucks better than those expensive vacuums. It has a ho
e. Features to love about this vacuum: * really sucks up the dirt – it sucks in a good way. We had a p
f the previous reviewers. This B&D vacuum really sucks! And I mean that in a great way. Very lightweig
t. But, it does big work! Its easy to handle, and sucks up all that grime that builds in your carpet. I a
asy to assemble and man when I tell you that this sucks the dirt from the foundation of your house lol. N

Fields

overall (bigint) – User rating (1-5)
verified (boolean) Is the review verified (true, false)
reviewtime (string) – Timestamp formatted like “10 30, 2009”
reviewerid (string) – Amazon generated user id
asin (string) – Unique Amazon generated product id
reviewername (string) – User supplied name
reviewtext (string) – Review text
summary (string) – Summary of Review text
unixreviewtime (bigint) – Timestamp formatted in epoch time.
vote (double) – Userful voters form other users
title (string) – Product title
description (string) – Product description
category (string) (Partitioned)
year (string) (Partitioned)
month (string) (Partitioned)

Citation

Please cite the following paper if you use the data in any way:

Justifying recommendations using distantly-labeled reviews and fined-grained aspects
Jianmo Ni, Jiacheng Li, Julian McAuley
Empirical Methods in Natural Language Processing (EMNLP), 2019
pdf

Categories

Examples

Fields

Citation