Dataset: 🍴USA Yelp Eats 2024: Top Dining Gems Revealed 🌟

About this Dataset

🍴USA Yelp Eats 2024: Top Dining Gems Revealed 🌟

Dataset Overview

This comprehensive dataset aggregates restaurant listings and reviews from Yelp across seven key states in the USA: Hawaii, Illinois, Michigan, Texas, Nevada, California, and New York. Designed for detailed analysis, it captures the rich diversity of the American culinary scene, presenting an invaluable resource for enthusiasts and professionals alike.

Data Science Applications

Ideal for exploratory data analysis, sentiment analysis, trend forecasting, and geographic information system (GIS) mapping, this dataset serves a wide array of data science applications. It's particularly suited for predictive modeling of restaurant success factors, customer preferences analysis, and regional culinary trend identification.

Column Descriptors

Name: The name of the restaurant.
Type: The establishment type, e.g., Restaurant, Nightlife.
PriceRange: The cost tier, usually represented by dollar signs.
Cuisine: The type of cuisine offered.
AggregatedRating: Average customer rating on a scale of 1 to 5.
ReviewCount: The number of reviews the establishment has received.
DirectUrl: A direct link to the Yelp page of the restaurant.
Website: The restaurant's official website URL.

Ethically Mined Data

This dataset was ethically mined, adhering to all applicable data privacy laws and guidelines. It consists solely of publicly available information that does not compromise individual privacy or business confidentiality.

Acknowledgments

Heartfelt thanks to Yelp for providing an open platform that encourages the sharing of honest customer feedback and experiences. This dataset stands as a testament to the vibrant and diverse culinary culture thriving across the USA, made visible through the collective voice of the Yelp community.

Tables

Yelp Restaurants Michigan

@kaggle.kanchana1990_usa_yelp_eats_2024_top_dining_gems_revealed.yelp_restaurants_michigan

20.78 KB
240 rows
8 columns


CREATE TABLE yelp_restaurants_michigan (
  "name" VARCHAR,
  "type" VARCHAR,
  "pricerange" VARCHAR,
  "cuisine" VARCHAR,
  "aggregatedrating" DOUBLE,
  "reviewcount" BIGINT,
  "directurl" VARCHAR,
  "website" VARCHAR
);

Yelp Restaurants Texas

@kaggle.kanchana1990_usa_yelp_eats_2024_top_dining_gems_revealed.yelp_restaurants_texas

20.34 KB
240 rows
8 columns


CREATE TABLE yelp_restaurants_texas (
  "name" VARCHAR,
  "type" VARCHAR,
  "pricerange" VARCHAR,
  "cuisine" VARCHAR,
  "aggregatedrating" DOUBLE,
  "reviewcount" BIGINT,
  "directurl" VARCHAR,
  "website" VARCHAR
);

Yelp Restaurants Hawaii

@kaggle.kanchana1990_usa_yelp_eats_2024_top_dining_gems_revealed.yelp_restaurants_hawaii

20.14 KB
240 rows
8 columns


CREATE TABLE yelp_restaurants_hawaii (
  "name" VARCHAR,
  "type" VARCHAR,
  "pricerange" VARCHAR,
  "cuisine" VARCHAR,
  "aggregatedrating" DOUBLE,
  "reviewcount" BIGINT,
  "directurl" VARCHAR,
  "website" VARCHAR
);

Yelp Restaurants California

@kaggle.kanchana1990_usa_yelp_eats_2024_top_dining_gems_revealed.yelp_restaurants_california

10.35 KB
81 rows
8 columns


CREATE TABLE yelp_restaurants_california (
  "name" VARCHAR,
  "type" VARCHAR,
  "pricerange" VARCHAR,
  "cuisine" VARCHAR,
  "aggregatedrating" DOUBLE,
  "reviewcount" BIGINT,
  "directurl" VARCHAR,
  "website" VARCHAR
);

Yelp Restaurants New York

@kaggle.kanchana1990_usa_yelp_eats_2024_top_dining_gems_revealed.yelp_restaurants_new_york

17.43 KB
197 rows
8 columns


CREATE TABLE yelp_restaurants_new_york (
  "name" VARCHAR,
  "type" VARCHAR,
  "pricerange" VARCHAR,
  "cuisine" VARCHAR,
  "aggregatedrating" DOUBLE,
  "reviewcount" BIGINT,
  "directurl" VARCHAR,
  "website" VARCHAR
);

Yelp Restaurants Illinois

@kaggle.kanchana1990_usa_yelp_eats_2024_top_dining_gems_revealed.yelp_restaurants_illinois

20.4 KB
240 rows
8 columns


CREATE TABLE yelp_restaurants_illinois (
  "name" VARCHAR,
  "type" VARCHAR,
  "pricerange" VARCHAR,
  "cuisine" VARCHAR,
  "aggregatedrating" DOUBLE,
  "reviewcount" BIGINT,
  "directurl" VARCHAR,
  "website" VARCHAR
);

Yelp Restaurants Nevada

@kaggle.kanchana1990_usa_yelp_eats_2024_top_dining_gems_revealed.yelp_restaurants_nevada

8.63 KB
30 rows
8 columns


CREATE TABLE yelp_restaurants_nevada (
  "name" VARCHAR,
  "type" VARCHAR,
  "pricerange" VARCHAR,
  "cuisine" VARCHAR,
  "aggregatedrating" DOUBLE,
  "reviewcount" BIGINT,
  "directurl" VARCHAR,
  "website" VARCHAR
);