Dataset: TripAdvisor Hotel Reviews

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

304.46 KB
4333 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

518.55 MB
878561 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
);