Dataset: Hotel Reviews

About this Dataset

Hotel Reviews

This is a list of 1,000 hotels and their reviews provided by Datafiniti's Business Database. The dataset includes hotel location, name, rating, review data, title, username, and more.
You can use this data to compare hotel reviews on a state-by-state basis; experiment with sentiment scoring and other natural language processing techniques.
The review data lets you correlate keywords in the review text with ratings. E.g.:
What are the bottom and top states for hotel reviews by average rating?
What is the correlation between a state’s population and their number of hotel reviews?
What is the correlation between a state’s tourism budget and their number of hotel reviews?

Tables

Datafiniti Hotel Reviews Jun19

@kaggle.meetnagadia_hotel_reviews.datafiniti_hotel_reviews_jun19

7.87 MB
10000 rows
26 columns


CREATE TABLE datafiniti_hotel_reviews_jun19 (
  "id" VARCHAR,
  "dateadded" TIMESTAMP,
  "dateupdated" TIMESTAMP,
  "address" VARCHAR,
  "categories" VARCHAR,
  "primarycategories" VARCHAR,
  "city" VARCHAR,
  "country" VARCHAR,
  "keys" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "name" VARCHAR,
  "postalcode" VARCHAR,
  "province" VARCHAR,
  "reviews_date" TIMESTAMP,
  "reviews_dateadded" VARCHAR,
  "reviews_dateseen" VARCHAR,
  "reviews_rating" BIGINT,
  "reviews_sourceurls" VARCHAR,
  "reviews_text" VARCHAR,
  "reviews_title" VARCHAR,
  "reviews_usercity" VARCHAR,
  "reviews_userprovince" VARCHAR,
  "reviews_username" VARCHAR,
  "sourceurls" VARCHAR,
  "websites" VARCHAR
);