Name: Restaurant Business Rankings 2020
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

Restaurant Business Rankings 2020

Context

The year 2020 is behind us, therefore, many summaries of this pandemic year are created, e.g. in the form of rankings. Such a list (or actually 3 lists) was created by the "Restaurant Business" magazine. On the website you can find only basic information about ranked restaurants, full data and analyzes are available in the paid report.

Content

The data was obtained by means of web scraping, i.e. data download with the use of programming code based on the website code. In this case, the "rvest" package from the R programming language was used along with the "SelectorGadet" browser add-on to facilitate work with the website.

The data was downloaded from www.restaurantbusinessonline.com on January 30, 2021 with three plants describing 3 rankings: top 250, top 100 indenents and future 50 thus creating 3 tables, where the restaurant is described by several variables in each row.

Inspiration

The data can be used to tell the story of what 2020 was like for restaurants, what was hot, what could be more popular soon, or what the difference is between large companies and smaller businesses. I am curious what useful information can be obtained from this data!

Photo by Luis Hansel on Unsplash.

Tables

Future50

@kaggle.michau96_restaurant_business_rankings_2020.future50

9.2 KB
50 rows
9 columns


CREATE TABLE future50 (
  "rank" BIGINT,
  "restaurant" VARCHAR,
  "location" VARCHAR,
  "sales" BIGINT,
  "yoy_sales" VARCHAR,
  "units" BIGINT,
  "yoy_units" VARCHAR,
  "unit_volume" BIGINT,
  "franchising" VARCHAR
);

Independence100

@kaggle.michau96_restaurant_business_rankings_2020.independence100

9.72 KB
100 rows
7 columns


CREATE TABLE independence100 (
  "rank" BIGINT,
  "restaurant" VARCHAR,
  "sales" DOUBLE,
  "average_check" BIGINT,
  "city" VARCHAR,
  "state" VARCHAR,
  "meals_served" DOUBLE
);

Top250

@kaggle.michau96_restaurant_business_rankings_2020.top250

23.82 KB
250 rows
9 columns


CREATE TABLE top250 (
  "rank" BIGINT,
  "restaurant" VARCHAR,
  "content" VARCHAR,
  "sales" BIGINT,
  "yoy_sales" VARCHAR,
  "units" BIGINT,
  "yoy_units" VARCHAR,
  "headquarters" VARCHAR,
  "segment_category" VARCHAR
);