Yelp Open Dataset

Creators:

Yelp, Inc.

Publication Date:

2015

Data Category:

Dataset Description:

The Yelp dataset is a subset of businesses, reviews, and user data for use in personal, educational, and academic purposes. It contains 6.9M online reviews for 150k businesses. It also includes more than 200,000 images related to the reviews.The data consists of multiple sub datasets:

Yelp Business data: Contains business data including location data, attributes, and categories.
Yelp Review data: Contains full review text data including the user_id that wrote the review and the business_id the review is written for.
Yelp User data: User data including the user's friend mapping and all the metadata associated with the user.
Yelp Checkin data: Checkins on a business.
Yelp Tip data: Tips written by a user on a business. Tips are shorter than reviews and tend to convey quick suggestions.
Yelp Photo data: Contains photo data including the caption and classification (one of "food", "drink", "menu", "inside" or "outside").

Available as JSON files, use can use it to teach students about databases, to learn NLP, or for sample production data while you learn how to make mobile apps.

Publications Citing This Dataset:

Huang, James; Rogers, Stephanie; Joo, Eunkwang (2014). Improving Restaurants by Extracting Subtopics from Yelp Reviews. iConference 2014 Social Media Expo.
http://hdl.handle.net/2142/48832

Variables:

Name	Description
business_id	22 character unique string business id
name	The business's name
address	The full address of the business
city	The city where the business is
state	2 character state code, if applicable
postal code	The postal code of the business
latitude	Latitude of the reviewed business
longitude	Longitude of the reviewed business
stars	Star rating of the business, rounded to half-stars
review_count	Number of reviews of the business
is_open	0 or 1 for closed or open business, respectively
attributes	Business attributes to values, e.g., RestaurantsTakeOut and BusinessParking
categories	An array of strings of business categories, e.g, "Mexican", "Burgers", "Gastropubs"
hours	An object of key day to value hours, e.g., "Monday": "10:00-21:00"
review_id	22 character unique review id
user_id	22 character unique user id
stars	Star rating provided in a rating
date	Review date, formatted YYYY-MM-DD
text	The review itself
useful	Number of useful votes received
funny	Number of funny votes received
cool	Number of cool votes received
name	The user's first name
review_count	The number of reviews the user has written
yelping_since	When the user joined Yelp, formatted like YYYY-MM-DD
friends	An array of the user's friend as user_ids
useful	Number of useful votes sent by the user
funny	Number of funny votes sent by the user
cool	Number of cool votes sent by the user
fans	Number of fans the user has
elite	The years the user was elite
average_stars	Average rating of all reviews provided by a user
compliment_hot	Number of hot compliments received by the user
compliment_more	Number of more compliments received by the user
compliment_profile	Number of profile compliments received by the user
compliment_cute	Number of cute compliments received by the user
compliment_list	Number of list compliments received by the user
compliment_note	Number of note compliments received by the user
compliment_plain	Number of plain compliments received by the user
compliment_cool	Number of cool compliments received by the user
compliment_funny	Number of funny compliments received by the user
compliment_writer	Number of writer compliments received by the user
compliment_photos	Number of photo compliments received by the user
date	A comma-separated list of timestamps for each checkin, each with format YYYY-MM-DD HH:MM:SS
text	Text of the tip
date	When the tip was written, formatted like YYYY-MM-DD
compliment_count	How many compliments a tip has
photo_id	22 character unique photo id
caption	The photo caption, if any
label	The category the photo belongs to, if any, e.g., "food"

Details:

Bookmark this Dataset/Publication

Yelp Open Dataset

Stock return prediction with tweets

COVID-19 Economic Stimulus Packages Database

Spotify Million Playlist Dataset

Yelp Open Dataset

Sign In

Register

Reset Password