Name: TripAdvisor Hotel Reviews
Creator: Kaggle
License: http://opendatacommons.org/licenses/dbcl/1.0/

About this Dataset

TripAdvisor Hotel Reviews

This dataset consists of 878561 reviews (1.3GB) from 4333 hotels crawled from TripAdvisor. The use of json would make it easier to read the data. Pay attention that some of the reviews are written in French.

Source: https://www.cs.cmu.edu/~jiweil/html/hotel-review.html

Tables

Offerings

@kaggle.joebeachcapital_hotel_reviews.offerings

311.77 kB
4,333 rows
9 columns

CREATE TABLE offerings (
  "hotel_class" DOUBLE,
  "region_id" BIGINT,
  "url" VARCHAR,
  "phone" VARCHAR,
  "details" VARCHAR,
  "address" VARCHAR,
  "type" VARCHAR,
  "id" BIGINT,
  "name" VARCHAR
);

Reviews

@kaggle.joebeachcapital_hotel_reviews.reviews

543.74 MB
878,561 rows
10 columns

CREATE TABLE reviews (
  "ratings" VARCHAR,
  "title" VARCHAR,
  "text" VARCHAR,
  "author" VARCHAR,
  "date_stayed" VARCHAR,
  "offering_id" BIGINT,
  "num_helpful_votes" BIGINT,
  "date" TIMESTAMP,
  "id" BIGINT,
  "via_mobile" BOOLEAN
);