Dataset: Yelp Restaurants Data

About this Dataset

Yelp Restaurants Data

Context

Data was scraped from Yelp
The whole scraping script is on my GitHub

Yelp Inc. is an American company that develops the Yelp.com website and the Yelp mobile app, which publish crowd-sourced reviews about businesses. It also operates Yelp Guest Manager, a table reservation service. It is headquartered in San Francisco, California.

Content

The dataset covers over 1200 restaurant information in California. This dataset has 18 fields. The fileds are given below:

Yelp URL
Restaurant Name
Street Address
Zip Code
City
State
Price Range
Phone
Rating
Number of Reviews
Website
Menu Link
Image 1
Image 2
Image 3
Category 1
Category 2
Category 3

Acknowledgements

Data is from Yelp.

Tables

California Restaurants

@kaggle.farukalam_yelp_restaurants_data.california_restaurants

163.18 KB
1273 rows
18 columns


CREATE TABLE california_restaurants (
  "yelp_url" VARCHAR,
  "name" VARCHAR,
  "street_address" VARCHAR,
  "zip_code" DOUBLE,
  "city" VARCHAR,
  "state" VARCHAR,
  "price_range" VARCHAR,
  "phone" VARCHAR,
  "rating" DOUBLE,
  "number_of_reviews" VARCHAR,
  "website" VARCHAR,
  "menu_link" VARCHAR,
  "image_1" VARCHAR,
  "image_2" VARCHAR,
  "image_3" VARCHAR,
  "category_1" VARCHAR,
  "category_2" VARCHAR,
  "category_3" VARCHAR
);