515K Hotel Reviews Data In Europe

Can you make your trip more cozy by using data science?

@kaggle.jiashenliu_515k_hotel_reviews_data_in_europe

Table List

1 table(59.5 MB)

Hotel Reviews

@kaggle.jiashenliu_515k_hotel_reviews_data_in_europe.hotel_reviews

59.5 MB
515738 rows
17 columns

hotel_address Hotel Address	additional_number_of_scoring Additional Number Of Scoring	review_date Review Date	average_score Average Score	hotel_name Hotel Name	reviewer_nationality Reviewer Nationality	negative_review Negative Review	review_total_negative_word_counts Review Total Negative Word Counts	total_number_of_reviews Total Number Of Reviews	positive_review Positive Review	review_total_positive_word_counts Review Total Positive Word Counts	total_number_of_reviews_reviewer_has_given Total Number Of Reviews Reviewer Has Given	reviewer_score Reviewer Score	tags Tags	days_since_review Days Since Review	lat Lat	lng Lng
s Gravesandestraat 55 Oost 1092 AA Amsterdam Netherlands	194	Thu Aug 03 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	7.7	Hotel Arena	Russia	I am so angry that i made this post available via all possible sites i use when planing my trips so no one will make the mistake of booking this place I made my booking via booking com We stayed for 6 nights in this hotel from 11 to 17 July Upon arrival we were placed in a small room on the 2nd flo…	397	1403	Only the park outside of the hotel was beautiful	11	7	2.9	[' Leisure trip ', ' Couple ', ' Duplex Double Room ', ' Stayed 6 nights ']	0 days	52.3605759	4.9159683
s Gravesandestraat 55 Oost 1092 AA Amsterdam Netherlands	194	Thu Aug 03 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	7.7	Hotel Arena	Ireland	No Negative		1403	No real complaints the hotel was great great location surroundings rooms amenities and service Two recommendations however firstly the staff upon check in are very confusing regarding deposit payments and the staff offer you upon checkout to refund your original payment and you can make a new one B…	105	7	7.5	[' Leisure trip ', ' Couple ', ' Duplex Double Room ', ' Stayed 4 nights ']	0 days	52.3605759	4.9159683
s Gravesandestraat 55 Oost 1092 AA Amsterdam Netherlands	194	Mon Jul 31 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	7.7	Hotel Arena	Australia	Rooms are nice but for elderly a bit difficult as most rooms are two story with narrow steps So ask for single level Inside the rooms are very very basic just tea coffee and boiler and no bar empty fridge	42	1403	Location was good and staff were ok It is cute hotel the breakfast range is nice Will go back	21	9	7.1	[' Leisure trip ', ' Family with young children ', ' Duplex Double Room ', ' Stayed 3 nights ', ' Submitted from a mobile device ']	3 days	52.3605759	4.9159683
s Gravesandestraat 55 Oost 1092 AA Amsterdam Netherlands	194	Mon Jul 31 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	7.7	Hotel Arena	United Kingdom	My room was dirty and I was afraid to walk barefoot on the floor which looked as if it was not cleaned in weeks White furniture which looked nice in pictures was dirty too and the door looked like it was attacked by an angry dog My shower drain was clogged and the staff did not respond to my reques…	210	1403	Great location in nice surroundings the bar and restaurant are nice and have a lovely outdoor area The building also has quite some character	26	1	3.8	[' Leisure trip ', ' Solo traveler ', ' Duplex Double Room ', ' Stayed 3 nights ']	3 days	52.3605759	4.9159683
s Gravesandestraat 55 Oost 1092 AA Amsterdam Netherlands	194	Mon Jul 24 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	7.7	Hotel Arena	New Zealand	You When I booked with your company on line you showed me pictures of a room I thought I was getting and paying for and then when we arrived that s room was booked and the staff told me we could only book the villa suite theough them directly Which was completely false advertising After being there…	140	1403	Amazing location and building Romantic setting	8	3	6.7	[' Leisure trip ', ' Couple ', ' Suite ', ' Stayed 2 nights ', ' Submitted from a mobile device ']	10 days	52.3605759	4.9159683
s Gravesandestraat 55 Oost 1092 AA Amsterdam Netherlands	194	Mon Jul 24 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	7.7	Hotel Arena	Poland	Backyard of the hotel is total mess shouldn t happen in hotel with 4 stars	17	1403	Good restaurant with modern design great chill out place Great park nearby the hotel and awesome main stairs	20	1	6.7	[' Leisure trip ', ' Group ', ' Duplex Double Room ', ' Stayed 1 night ']	10 days	52.3605759	4.9159683
s Gravesandestraat 55 Oost 1092 AA Amsterdam Netherlands	194	Mon Jul 17 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	7.7	Hotel Arena	United Kingdom	Cleaner did not change our sheet and duvet everyday but just made bed They also didn t clean the floor and changed the body gel when we run out of it	33	1403	The room is spacious and bright The hotel is located in a quiet and beautiful park	18	6	4.6	[' Leisure trip ', ' Group ', ' Duplex Twin Room ', ' Stayed 5 nights ', ' Submitted from a mobile device ']	17 days	52.3605759	4.9159683
s Gravesandestraat 55 Oost 1092 AA Amsterdam Netherlands	194	Mon Jul 17 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	7.7	Hotel Arena	United Kingdom	Apart from the price for the brekfast Everything very good	11	1403	Good location Set in a lovely park friendly staff Food high quality We Oth enjoyed the breakfast	19	1	10	[' Leisure trip ', ' Couple ', ' Duplex Double Room ', ' Stayed 2 nights ', ' Submitted from a mobile device ']	17 days	52.3605759	4.9159683
s Gravesandestraat 55 Oost 1092 AA Amsterdam Netherlands	194	Sun Jul 09 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	7.7	Hotel Arena	Belgium	Even though the pictures show very clean rooms the actual room was quit dirty and outlived Also check in is at 15 o clock but our room was not ready at that time	34	1403	No Positive		3	6.5	[' Leisure trip ', ' Couple ', ' Duplex Double Room ', ' Stayed 1 night ', ' Submitted from a mobile device ']	25 days	52.3605759	4.9159683
s Gravesandestraat 55 Oost 1092 AA Amsterdam Netherlands	194	Sat Jul 08 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	7.7	Hotel Arena	Norway	The aircondition makes so much noise and its hard to sleep at night	15	1403	The room was big enough and the bed is good The breakfast food and service on the hotel is good outside the hotel there is a big park which is very good for walk in the morning and evening Many people are having picnics and do some bicycling	50	1	7.9	[' Leisure trip ', ' Couple ', ' Large King Room ', ' Stayed 7 nights ']	26 days	52.3605759	4.9159683


CREATE TABLE hotel_reviews (
  "hotel_address" VARCHAR,
  "additional_number_of_scoring" BIGINT,
  "review_date" TIMESTAMP,
  "average_score" DOUBLE,
  "hotel_name" VARCHAR,
  "reviewer_nationality" VARCHAR,
  "negative_review" VARCHAR,
  "review_total_negative_word_counts" BIGINT,
  "total_number_of_reviews" BIGINT,
  "positive_review" VARCHAR,
  "review_total_positive_word_counts" BIGINT,
  "total_number_of_reviews_reviewer_has_given" BIGINT,
  "reviewer_score" DOUBLE,
  "tags" VARCHAR,
  "days_since_review" VARCHAR,
  "lat" DOUBLE,
  "lng" DOUBLE
);