Find the top five hotels with the highest total reviews given by a particular reviewer

select top 5 hotel_name,max(total_number_of_reviews_reviewer_has_given) as maxReviews from hotel_reviews group by hotel_name
order by maxReviews desc

USE [StrataScratch]
Go
CREATE TABLE [dbo].[hotel_reviews](
	[hotel_address] [varchar](max) NULL,
	[additional_number_of_scoring] [int] NULL,
	[review_date] [datetime] NULL,
	[average_score] [decimal](18, 5) NULL,
	[hotel_name] [varchar](500) NULL,
	[reviewer_nationality] [varchar](50) NULL,
	[negative_review] [varchar](500) NULL,
	[review_total_negative_word_counts] [int] NULL,
	[total_number_of_reviews] [int] NULL,
	[positive_review] [varchar](500) NULL,
	[review_total_positive_word_counts] [int] NULL,
	[total_number_of_reviews_reviewer_has_given] [int] NULL,
	[reviewer_score] [decimal](18, 5) NULL,
	[tags] [varchar](500) NULL,
	[days_since_review] [varchar](50) NULL,
	[lat] [decimal](18, 7) NULL,
	[lng] [decimal](18, 7) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
INSERT [dbo].[hotel_reviews] ([hotel_address], [additional_number_of_scoring], [review_date], [average_score], [hotel_name], [reviewer_nationality], [negative_review], [review_total_negative_word_counts], [total_number_of_reviews], [positive_review], [review_total_positive_word_counts], [total_number_of_reviews_reviewer_has_given], [reviewer_score], [tags], [days_since_review], [lat], [lng]) VALUES (N'7 Western Gateway Royal Victoria Dock Newham London E16 1AA United Kingdom', 359, CAST(N'2017-07-05T00:00:00.000' AS DateTime), CAST(8.50000 AS Decimal(18, 5)), N'Novotel London Excel', N'United Kingdom', N'coffee and tea at breakfast were not particularly hot Otherwise everything else was fine', 16, 1158, N'we were allocated the newly refurbished rooms and so everything was fresh and the bed was very comfortable the hotel is ideally situated near City Airport although eventually we travelled by train', 34, 2, CAST(10.00000 AS Decimal(18, 5)), N'['' Leisure trip '', '' Family with young children '', '' Standard Double Room with Two Single Beds '', '' Stayed 2 nights '', '' Submitted from a mobile device '']', N'29 days', CAST(51.5080000 AS Decimal(18, 7)), CAST(0.0230000 AS Decimal(18, 7)))
GO
INSERT [dbo].[hotel_reviews] ([hotel_address], [additional_number_of_scoring], [review_date], [average_score], [hotel_name], [reviewer_nationality], [negative_review], [review_total_negative_word_counts], [total_number_of_reviews], [positive_review], [review_total_positive_word_counts], [total_number_of_reviews_reviewer_has_given], [reviewer_score], [tags], [days_since_review], [lat], [lng]) VALUES (N'35 Charles Street Mayfair Westminster Borough London W1J 5EB United Kingdom', 252, CAST(N'2015-08-29T00:00:00.000' AS DateTime), CAST(9.10000 AS Decimal(18, 5)), N'The Chesterfield Mayfair', N'Israel', N'No Negative', 0, 1166, N'We liked everything The hotel is simply a boutique the staff were all polite and helpfull The room was clean and been serviced daily Wifi was completely free Breakfast was simply great I so much want to get back', 41, 8, CAST(10.00000 AS Decimal(18, 5)), N'['' Leisure trip '', '' Couple '', '' Classic Double Room '', '' Stayed 4 nights '', '' Submitted from a mobile device '']', N'705 day', CAST(51.5080000 AS Decimal(18, 7)), CAST(-0.1470000 AS Decimal(18, 7)))
GO
INSERT [dbo].[hotel_reviews] ([hotel_address], [additional_number_of_scoring], [review_date], [average_score], [hotel_name], [reviewer_nationality], [negative_review], [review_total_negative_word_counts], [total_number_of_reviews], [positive_review], [review_total_positive_word_counts], [total_number_of_reviews_reviewer_has_given], [reviewer_score], [tags], [days_since_review], [lat], [lng]) VALUES (N'14 Rue Stanislas 6th arr 75006 Paris France', 40, CAST(N'2017-05-23T00:00:00.000' AS DateTime), CAST(9.10000 AS Decimal(18, 5)), N'Hotel Le Six', N'United States of America', N'There is currently utility construction taking place on the street in front of the hotel so a little noisy at times and barriers in place', 27, 177, N'Neat boutique hotel Some of the most comfortable hotel beds I have ever come across Staff was wonderful Loved the location Not too touristy Luxembourg gardens close by and a great place for a morning run walk', 39, 3, CAST(9.20000 AS Decimal(18, 5)), N'['' Leisure trip '', '' Family with young children '', '' Deluxe Double Room '', '' Stayed 4 nights '', '' Submitted from a mobile device '']', N'72 days', CAST(48.8440000 AS Decimal(18, 7)), CAST(2.3280000 AS Decimal(18, 7)))
GO
INSERT [dbo].[hotel_reviews] ([hotel_address], [additional_number_of_scoring], [review_date], [average_score], [hotel_name], [reviewer_nationality], [negative_review], [review_total_negative_word_counts], [total_number_of_reviews], [positive_review], [review_total_positive_word_counts], [total_number_of_reviews_reviewer_has_given], [reviewer_score], [tags], [days_since_review], [lat], [lng]) VALUES (N'Gran V a De Les Corts Catalanes 570 Eixample 08011 Barcelona Spain', 325, CAST(N'2016-08-25T00:00:00.000' AS DateTime), CAST(8.20000 AS Decimal(18, 5)), N'Sunotel Central', N'United Kingdom', N'Coffee at breakfast could be better When you spend this amount in a hotel I expect better coffee in the morning', 22, 3870, N'Great bed nice to have a coffee machine in the room love the air conditioning and basically loved the attitude of the staff Really great', 26, 2, CAST(9.20000 AS Decimal(18, 5)), N'['' Leisure trip '', '' Group '', '' Comfort Double or Twin Room '', '' Stayed 1 night '', '' Submitted from a mobile device '']', N'343 day', CAST(41.3840000 AS Decimal(18, 7)), CAST(2.1620000 AS Decimal(18, 7)))
GO
INSERT [dbo].[hotel_reviews] ([hotel_address], [additional_number_of_scoring], [review_date], [average_score], [hotel_name], [reviewer_nationality], [negative_review], [review_total_negative_word_counts], [total_number_of_reviews], [positive_review], [review_total_positive_word_counts], [total_number_of_reviews_reviewer_has_given], [reviewer_score], [tags], [days_since_review], [lat], [lng]) VALUES (N'Rathausstra e 17 01 Innere Stadt 1010 Vienna Austria', 195, CAST(N'2015-09-17T00:00:00.000' AS DateTime), CAST(8.50000 AS Decimal(18, 5)), N'Austria Trend Hotel Rathauspark Wien', N'United Kingdom', N'A bit out of the way location wise', 9, 1884, N'Clean modern rooms and bathroom well equipped', 9, 2, CAST(7.50000 AS Decimal(18, 5)), N'['' Leisure trip '', '' Couple '', '' Comfort Room '', '' Stayed 2 nights '', '' Submitted from a mobile device '']', N'686 day', CAST(48.2130000 AS Decimal(18, 7)), CAST(16.3570000 AS Decimal(18, 7)))
GO
INSERT [dbo].[hotel_reviews] ([hotel_address], [additional_number_of_scoring], [review_date], [average_score], [hotel_name], [reviewer_nationality], [negative_review], [review_total_negative_word_counts], [total_number_of_reviews], [positive_review], [review_total_positive_word_counts], [total_number_of_reviews_reviewer_has_given], [reviewer_score], [tags], [days_since_review], [lat], [lng]) VALUES (N'100 110 Euston Road Camden London NW1 2AJ United Kingdom', 728, CAST(N'2016-02-28T00:00:00.000' AS DateTime), CAST(8.90000 AS Decimal(18, 5)), N'Pullman London St Pancras', N'United Kingdom', N'No pool', 3, 3168, N'Breakfast', 2, 1, CAST(8.80000 AS Decimal(18, 5)), N'['' Business trip '', '' Solo traveler '', '' Classic King Room '', '' Stayed 1 night '', '' Submitted from a mobile device '']', N'522 day', CAST(51.5290000 AS Decimal(18, 7)), CAST(-0.1280000 AS Decimal(18, 7)))
GO
INSERT [dbo].[hotel_reviews] ([hotel_address], [additional_number_of_scoring], [review_date], [average_score], [hotel_name], [reviewer_nationality], [negative_review], [review_total_negative_word_counts], [total_number_of_reviews], [positive_review], [review_total_positive_word_counts], [total_number_of_reviews_reviewer_has_given], [reviewer_score], [tags], [days_since_review], [lat], [lng]) VALUES (N'12 Folgate Street City of London London E1 6BX United Kingdom', 197, CAST(N'2016-11-28T00:00:00.000' AS DateTime), CAST(9.40000 AS Decimal(18, 5)), N'Batty Langley s', N'United Kingdom', N'Couldn t fault anything about this hotel', 9, 644, N'Plush luxurious room with excellent friendly staff', 9, 2, CAST(10.00000 AS Decimal(18, 5)), N'['' Leisure trip '', '' Couple '', '' Superior Double Room '', '' Stayed 1 night '', '' Submitted from a mobile device '']', N'248 day', CAST(51.5210000 AS Decimal(18, 7)), CAST(-0.0780000 AS Decimal(18, 7)))
GO
INSERT [dbo].[hotel_reviews] ([hotel_address], [additional_number_of_scoring], [review_date], [average_score], [hotel_name], [reviewer_nationality], [negative_review], [review_total_negative_word_counts], [total_number_of_reviews], [positive_review], [review_total_positive_word_counts], [total_number_of_reviews_reviewer_has_given], [reviewer_score], [tags], [days_since_review], [lat], [lng]) VALUES (N'252 High Holborn Holborn Camden London WC1V 7EN United Kingdom', 256, CAST(N'2017-01-13T00:00:00.000' AS DateTime), CAST(9.40000 AS Decimal(18, 5)), N'Rosewood London', N'Australia', N'Nothing', 2, 1008, N'Best bat in London', 5, 1, CAST(9.60000 AS Decimal(18, 5)), N'['' Leisure trip '', '' Family with young children '', '' Executive King Room '', '' Stayed 5 nights '', '' Submitted from a mobile device '']', N'202 day', CAST(51.5170000 AS Decimal(18, 7)), CAST(-0.1180000 AS Decimal(18, 7)))
GO
INSERT [dbo].[hotel_reviews] ([hotel_address], [additional_number_of_scoring], [review_date], [average_score], [hotel_name], [reviewer_nationality], [negative_review], [review_total_negative_word_counts], [total_number_of_reviews], [positive_review], [review_total_positive_word_counts], [total_number_of_reviews_reviewer_has_given], [reviewer_score], [tags], [days_since_review], [lat], [lng]) VALUES (N'Neubaug rtel 34 36 07 Neubau 1070 Vienna Austria', 106, CAST(N'2016-10-01T00:00:00.000' AS DateTime), CAST(8.20000 AS Decimal(18, 5)), N'ARCOTEL Wimberger', N'Iran', N'It had not electric kettle', 7, 1886, N'Good location good stuff good breakfast', 7, 14, CAST(7.50000 AS Decimal(18, 5)), N'['' Leisure trip '', '' Group '', '' Comfort Double Room '', '' Stayed 2 nights '', '' Submitted from a mobile device '']', N'306 day', CAST(48.2010000 AS Decimal(18, 7)), CAST(16.3390000 AS Decimal(18, 7)))
GO
INSERT [dbo].[hotel_reviews] ([hotel_address], [additional_number_of_scoring], [review_date], [average_score], [hotel_name], [reviewer_nationality], [negative_review], [review_total_negative_word_counts], [total_number_of_reviews], [positive_review], [review_total_positive_word_counts], [total_number_of_reviews_reviewer_has_given], [reviewer_score], [tags], [days_since_review], [lat], [lng]) VALUES (N'372 Strand Westminster Borough London WC2R 0JJ United Kingdom', 2288, CAST(N'2016-08-30T00:00:00.000' AS DateTime), CAST(8.10000 AS Decimal(18, 5)), N'Strand Palace Hotel', N'United Kingdom', N'Room didnt have aircon', 5, 9568, N'No Positive', 0, 3, CAST(8.80000 AS Decimal(18, 5)), N'['' Leisure trip '', '' Group '', '' Cosy Double Room '', '' Stayed 1 night '', '' Submitted from a mobile device '']', N'338 day', CAST(51.5110000 AS Decimal(18, 7)), CAST(-0.1210000 AS Decimal(18, 7)))
GO
INSERT [dbo].[hotel_reviews] ([hotel_address], [additional_number_of_scoring], [review_date], [average_score], [hotel_name], [reviewer_nationality], [negative_review], [review_total_negative_word_counts], [total_number_of_reviews], [positive_review], [review_total_positive_word_counts], [total_number_of_reviews_reviewer_has_given], [reviewer_score], [tags], [days_since_review], [lat], [lng]) VALUES (N'Via Lucio Giunio Columella 36 Distretto Viale Monza 20128 Milan Italy', 228, CAST(N'2016-08-24T00:00:00.000' AS DateTime), CAST(8.30000 AS Decimal(18, 5)), N'Hilton Garden Inn Milan North', N'United Kingdom', N'Same breakfast daily', 4, 3613, N'Comfortable bed', 3, 5, CAST(7.10000 AS Decimal(18, 5)), N'['' Leisure trip '', '' Solo traveler '', '' King Room '', '' Stayed 2 nights '', '' Submitted from a mobile device '']', N'344 day', CAST(45.5160000 AS Decimal(18, 7)), CAST(9.2270000 AS Decimal(18, 7)))
GO
INSERT [dbo].[hotel_reviews] ([hotel_address], [additional_number_of_scoring], [review_date], [average_score], [hotel_name], [reviewer_nationality], [negative_review], [review_total_negative_word_counts], [total_number_of_reviews], [positive_review], [review_total_positive_word_counts], [total_number_of_reviews_reviewer_has_given], [reviewer_score], [tags], [days_since_review], [lat], [lng]) VALUES (N'Via Napo Torriani 18 Central Station 20124 Milan Italy', 384, CAST(N'2016-12-10T00:00:00.000' AS DateTime), CAST(9.20000 AS Decimal(18, 5)), N'Hotel Berna', N'United Kingdom', N'The noise from other rooms and the hallway was rather noticeable', 13, 4017, N'I loved the wonderful service I received here the room was very comfortable with a lovely big bath and a rubber duckie The staff were very helpful and friendly The hotel is very close to the main train station and there was no street noise despite being in a busy part of town', 55, 23, CAST(9.60000 AS Decimal(18, 5)), N'['' Leisure trip '', '' Solo traveler '', '' Superior Single Room '', '' Stayed 4 nights '']', N'236 day', CAST(45.4830000 AS Decimal(18, 7)), CAST(9.2030000 AS Decimal(18, 7)))
GO
INSERT [dbo].[hotel_reviews] ([hotel_address], [additional_number_of_scoring], [review_date], [average_score], [hotel_name], [reviewer_nationality], [negative_review], [review_total_negative_word_counts], [total_number_of_reviews], [positive_review], [review_total_positive_word_counts], [total_number_of_reviews_reviewer_has_given], [reviewer_score], [tags], [days_since_review], [lat], [lng]) VALUES (N'Hendrikje Stoffelstraat 1 Slotervaart 1058 GC Amsterdam Netherlands', 757, CAST(N'2017-04-26T00:00:00.000' AS DateTime), CAST(8.70000 AS Decimal(18, 5)), N'WestCord Fashion Hotel Amsterdam', N'United Kingdom', N'cleaning staff took no notice of do not disturb signe on door and twice attempted to enter room with out knocking', 22, 5236, N'No Positive', 0, 6, CAST(7.90000 AS Decimal(18, 5)), N'['' Solo traveler '', '' Large Double Room '', '' Stayed 4 nights '']', N'99 days', CAST(52.3580000 AS Decimal(18, 7)), CAST(4.8450000 AS Decimal(18, 7)))
GO
INSERT [dbo].[hotel_reviews] ([hotel_address], [additional_number_of_scoring], [review_date], [average_score], [hotel_name], [reviewer_nationality], [negative_review], [review_total_negative_word_counts], [total_number_of_reviews], [positive_review], [review_total_positive_word_counts], [total_number_of_reviews_reviewer_has_given], [reviewer_score], [tags], [days_since_review], [lat], [lng]) VALUES (N'101 Buckingham Palace Road Westminster Borough London SW1W 0SJ United Kingdom', 838, CAST(N'2015-09-22T00:00:00.000' AS DateTime), CAST(8.40000 AS Decimal(18, 5)), N'The Grosvenor', N'France', N'Toilet didn t flush properly Room a bit noisy could hear the train annoucements from nearby station', 18, 3274, N'No Positive', 0, 1, CAST(6.30000 AS Decimal(18, 5)), N'['' Leisure trip '', '' Couple '', '' Standard Double Room '', '' Stayed 3 nights '', '' Submitted from a mobile device '']', N'681 day', CAST(51.4960000 AS Decimal(18, 7)), CAST(-0.1450000 AS Decimal(18, 7)))
GO
INSERT [dbo].[hotel_reviews] ([hotel_address], [additional_number_of_scoring], [review_date], [average_score], [hotel_name], [reviewer_nationality], [negative_review], [review_total_negative_word_counts], [total_number_of_reviews], [positive_review], [review_total_positive_word_counts], [total_number_of_reviews_reviewer_has_given], [reviewer_score], [tags], [days_since_review], [lat], [lng]) VALUES (N'Great Cumberland Place Westminster Borough London W1H 7DL United Kingdom', 1190, CAST(N'2015-10-08T00:00:00.000' AS DateTime), CAST(7.50000 AS Decimal(18, 5)), N'The Cumberland A Guoman Hotel', N'United States of America', N'Noise', 2, 5180, N'Location', 2, 21, CAST(7.50000 AS Decimal(18, 5)), N'['' Business trip '', '' Solo traveler '', '' Standard Single Room '', '' Stayed 3 nights '', '' Submitted from a mobile device '']', N'665 day', CAST(51.5150000 AS Decimal(18, 7)), CAST(-0.1610000 AS Decimal(18, 7)))
GO
INSERT [dbo].[hotel_reviews] ([hotel_address], [additional_number_of_scoring], [review_date], [average_score], [hotel_name], [reviewer_nationality], [negative_review], [review_total_negative_word_counts], [total_number_of_reviews], [positive_review], [review_total_positive_word_counts], [total_number_of_reviews_reviewer_has_given], [reviewer_score], [tags], [days_since_review], [lat], [lng]) VALUES (N'Via Gian Battista Pirelli 20 Central Station 20124 Milan Italy', 283, CAST(N'2016-12-08T00:00:00.000' AS DateTime), CAST(8.70000 AS Decimal(18, 5)), N'LaGare Hotel Milano Centrale MGallery by Sofitel', N'Singapore', N'Staff is just so so but not too bad', 10, 2678, N'Everything is nice', 5, 10, CAST(9.20000 AS Decimal(18, 5)), N'['' Leisure trip '', '' Couple '', '' Superior Twin Room '', '' Stayed 2 nights '', '' Submitted from a mobile device '']', N'238 day', CAST(45.4840000 AS Decimal(18, 7)), CAST(9.1990000 AS Decimal(18, 7)))
GO
INSERT [dbo].[hotel_reviews] ([hotel_address], [additional_number_of_scoring], [review_date], [average_score], [hotel_name], [reviewer_nationality], [negative_review], [review_total_negative_word_counts], [total_number_of_reviews], [positive_review], [review_total_positive_word_counts], [total_number_of_reviews_reviewer_has_given], [reviewer_score], [tags], [days_since_review], [lat], [lng]) VALUES (N's Gravesandestraat 55 Oost 1092 AA Amsterdam Netherlands', 194, CAST(N'2016-12-27T00:00:00.000' AS DateTime), CAST(7.70000 AS Decimal(18, 5)), N'Hotel Arena', N'Netherlands', N'Breakfast poor', 4, 1403, N'Great hotel with beautiful interior', 6, 17, CAST(7.50000 AS Decimal(18, 5)), N'['' Leisure trip '', '' Couple '', '' 2 rooms '', '' Stayed 2 nights '', '' Submitted from a mobile device '']', N'219 day', CAST(52.3610000 AS Decimal(18, 7)), CAST(4.9160000 AS Decimal(18, 7)))
GO
INSERT [dbo].[hotel_reviews] ([hotel_address], [additional_number_of_scoring], [review_date], [average_score], [hotel_name], [reviewer_nationality], [negative_review], [review_total_negative_word_counts], [total_number_of_reviews], [positive_review], [review_total_positive_word_counts], [total_number_of_reviews_reviewer_has_given], [reviewer_score], [tags], [days_since_review], [lat], [lng]) VALUES (N'One Ham Yard Westminster Borough London W1D 7DT United Kingdom', 96, CAST(N'2016-02-04T00:00:00.000' AS DateTime), CAST(9.50000 AS Decimal(18, 5)), N'Ham Yard Hotel', N'United Kingdom', N'No Negative', 0, 314, N'Staff and the Honesty Bar', 7, 5, CAST(10.00000 AS Decimal(18, 5)), N'['' Leisure trip '', '' Couple '', '' Superior Room '', '' Stayed 1 night '', '' Submitted from a mobile device '']', N'546 day', CAST(51.5110000 AS Decimal(18, 7)), CAST(-0.1350000 AS Decimal(18, 7)))
GO
INSERT [dbo].[hotel_reviews] ([hotel_address], [additional_number_of_scoring], [review_date], [average_score], [hotel_name], [reviewer_nationality], [negative_review], [review_total_negative_word_counts], [total_number_of_reviews], [positive_review], [review_total_positive_word_counts], [total_number_of_reviews_reviewer_has_given], [reviewer_score], [tags], [days_since_review], [lat], [lng]) VALUES (N'Eerste Constantijn huygensstraat 26G Oud West 1054 BR Amsterdam Netherlands', 272, CAST(N'2016-04-02T00:00:00.000' AS DateTime), CAST(8.10000 AS Decimal(18, 5)), N'Amadi Park Hotel', N'United Kingdom', N'the breakfast could be better with more choices', 9, 1615, N'very clean and comfortable environment', 6, 10, CAST(9.20000 AS Decimal(18, 5)), N'['' Leisure trip '', '' Solo traveler '', '' Single Room '', '' Stayed 2 nights '', '' Submitted from a mobile device '']', N'488 day', CAST(52.3650000 AS Decimal(18, 7)), CAST(4.8730000 AS Decimal(18, 7)))
GO
INSERT [dbo].[hotel_reviews] ([hotel_address], [additional_number_of_scoring], [review_date], [average_score], [hotel_name], [reviewer_nationality], [negative_review], [review_total_negative_word_counts], [total_number_of_reviews], [positive_review], [review_total_positive_word_counts], [total_number_of_reviews_reviewer_has_given], [reviewer_score], [tags], [days_since_review], [lat], [lng]) VALUES (N'Leeuwendalersweg 21 Bos en Lommer 1055 JE Amsterdam Netherlands', 587, CAST(N'2016-07-24T00:00:00.000' AS DateTime), CAST(7.40000 AS Decimal(18, 5)), N'Best Western Blue Tower Hotel', N'Kuwait', N'The AC was not working They promised me to fix it but they did that the next day My children could not sleep the whole night because the room was hot', 32, 3869, N'No Positive', 0, 20, CAST(4.60000 AS Decimal(18, 5)), N'['' Leisure trip '', '' Family with young children '', '' Standard Quadruple Room '', '' Stayed 2 nights '']', N'375 day', CAST(52.3790000 AS Decimal(18, 7)), CAST(4.8460000 AS Decimal(18, 7)))
GO
INSERT [dbo].[hotel_reviews] ([hotel_address], [additional_number_of_scoring], [review_date], [average_score], [hotel_name], [reviewer_nationality], [negative_review], [review_total_negative_word_counts], [total_number_of_reviews], [positive_review], [review_total_positive_word_counts], [total_number_of_reviews_reviewer_has_given], [reviewer_score], [tags], [days_since_review], [lat], [lng]) VALUES (N'Prinsengracht 444 Amsterdam City Center 1017 KE Amsterdam Netherlands', 278, CAST(N'2017-03-12T00:00:00.000' AS DateTime), CAST(8.40000 AS Decimal(18, 5)), N'Dikker en Thijs Fenice Hotel', N'United Kingdom', N'No Negative', 0, 1971, N'Excellent location Great breakfast lots of choice Room large comfortable with great view Helpful friendly staff Tram right outside Couldn t have got a better hotel Good value too', 31, 4, CAST(9.60000 AS Decimal(18, 5)), N'['' Leisure trip '', '' Couple '', '' Superior Room with canal view '', '' Stayed 3 nights '', '' Submitted from a mobile device '']', N'144 day', CAST(52.3650000 AS Decimal(18, 7)), CAST(4.8840000 AS Decimal(18, 7)))
GO
INSERT [dbo].[hotel_reviews] ([hotel_address], [additional_number_of_scoring], [review_date], [average_score], [hotel_name], [reviewer_nationality], [negative_review], [review_total_negative_word_counts], [total_number_of_reviews], [positive_review], [review_total_positive_word_counts], [total_number_of_reviews_reviewer_has_given], [reviewer_score], [tags], [days_since_review], [lat], [lng]) VALUES (N'Wrights Lane Kensington and Chelsea London W8 5SP United Kingdom', 1172, CAST(N'2016-01-16T00:00:00.000' AS DateTime), CAST(7.80000 AS Decimal(18, 5)), N'Holiday Inn London Kensington', N'United Kingdom', N'Would have been better if everthing wasn t extra surcharge to use the pool surchaege for wi fi etc Luggage rack in room would have been handy', 29, 5945, N'Already recommended the hotel to friends going to London soon Great base oppulent feel without the price tag', 20, 2, CAST(10.00000 AS Decimal(18, 5)), N'['' Business trip '', '' Couple '', '' Superior Double Room '', '' Stayed 2 nights '', '' Submitted from a mobile device '']', N'565 day', CAST(51.5000000 AS Decimal(18, 7)), CAST(-0.1930000 AS Decimal(18, 7)))
GO
INSERT [dbo].[hotel_reviews] ([hotel_address], [additional_number_of_scoring], [review_date], [average_score], [hotel_name], [reviewer_nationality], [negative_review], [review_total_negative_word_counts], [total_number_of_reviews], [positive_review], [review_total_positive_word_counts], [total_number_of_reviews_reviewer_has_given], [reviewer_score], [tags], [days_since_review], [lat], [lng]) VALUES (N'Spuistraat 288 292 Amsterdam City Center 1012 VX Amsterdam Netherlands', 407, CAST(N'2017-07-31T00:00:00.000' AS DateTime), CAST(8.20000 AS Decimal(18, 5)), N'NH City Centre Amsterdam', N'India', N'Be careful about the superior view facing rooms being advertised They are very small with a queen bed and if u r carrying 2 to 3 pieces of luggage just not enough space I had to change my room once i saw them which costed me more', 49, 3417, N'Nice Restaurant with good breakfast spread Nice Location', 10, 6, CAST(6.30000 AS Decimal(18, 5)), N'['' Leisure trip '', '' Family with young children '', '' Superior Double or Twin Room with View '', '' Stayed 3 nights '']', N'3 days', CAST(52.3700000 AS Decimal(18, 7)), CAST(4.8890000 AS Decimal(18, 7)))
GO
INSERT [dbo].[hotel_reviews] ([hotel_address], [additional_number_of_scoring], [review_date], [average_score], [hotel_name], [reviewer_nationality], [negative_review], [review_total_negative_word_counts], [total_number_of_reviews], [positive_review], [review_total_positive_word_counts], [total_number_of_reviews_reviewer_has_given], [reviewer_score], [tags], [days_since_review], [lat], [lng]) VALUES (N'60 Hyde Park gate Kensington and Chelsea London SW7 5BB United Kingdom', 72, CAST(N'2016-01-30T00:00:00.000' AS DateTime), CAST(9.00000 AS Decimal(18, 5)), N'Baglioni Hotel London The Leading Hotels of the World', N'Switzerland', N'No Negative', 0, 290, N'Very friendly staff Rooms clean but not exactly sunlit Comfortably situated near Kensington Gardens It takes a ten minute walk to the next tube station Probably not quite a five star hotel but perhaps the most relaxed and welcoming accomodation in London', 44, 28, CAST(8.80000 AS Decimal(18, 5)), N'['' Leisure trip '', '' Couple '', '' Deluxe Double Room '', '' Stayed 4 nights '', '' Submitted from a mobile device '']', N'551 day', CAST(51.5020000 AS Decimal(18, 7)), CAST(-0.1850000 AS Decimal(18, 7)))
GO
INSERT [dbo].[hotel_reviews] ([hotel_address], [additional_number_of_scoring], [review_date], [average_score], [hotel_name], [reviewer_nationality], [negative_review], [review_total_negative_word_counts], [total_number_of_reviews], [positive_review], [review_total_positive_word_counts], [total_number_of_reviews_reviewer_has_given], [reviewer_score], [tags], [days_since_review], [lat], [lng]) VALUES (N'163 Marsh Wall Docklands Tower Hamlets London E14 9SJ United Kingdom', 2682, CAST(N'2017-03-14T00:00:00.000' AS DateTime), CAST(7.10000 AS Decimal(18, 5)), N'Britannia International Hotel Canary Wharf', N'United Kingdom', N'Everything was good', 4, 9086, N'Good location friendly', 4, 9, CAST(8.80000 AS Decimal(18, 5)), N'['' Leisure trip '', '' Couple '', '' Standard Double Room without Window '', '' Stayed 3 nights '', '' Submitted from a mobile device '']', N'142 day', CAST(51.5020000 AS Decimal(18, 7)), CAST(-0.0230000 AS Decimal(18, 7)))
GO
INSERT [dbo].[hotel_reviews] ([hotel_address], [additional_number_of_scoring], [review_date], [average_score], [hotel_name], [reviewer_nationality], [negative_review], [review_total_negative_word_counts], [total_number_of_reviews], [positive_review], [review_total_positive_word_counts], [total_number_of_reviews_reviewer_has_given], [reviewer_score], [tags], [days_since_review], [lat], [lng]) VALUES (N'2 The Avenue Ealing London W13 8PH United Kingdom', 187, CAST(N'2016-09-15T00:00:00.000' AS DateTime), CAST(8.80000 AS Decimal(18, 5)), N'The Drayton Court Hotel', N'United Kingdom', N'Card keys un reliable receptionist missing when needed', 9, 750, N'Good AC comfy chairs in room secondary glazing to reduce noise', 12, 3, CAST(7.50000 AS Decimal(18, 5)), N'['' Leisure trip '', '' Couple '', '' Double Room '', '' Stayed 1 night '', '' Submitted from a mobile device '']', N'322 day', CAST(51.5140000 AS Decimal(18, 7)), CAST(-0.3190000 AS Decimal(18, 7)))
GO
INSERT [dbo].[hotel_reviews] ([hotel_address], [additional_number_of_scoring], [review_date], [average_score], [hotel_name], [reviewer_nationality], [negative_review], [review_total_negative_word_counts], [total_number_of_reviews], [positive_review], [review_total_positive_word_counts], [total_number_of_reviews_reviewer_has_given], [reviewer_score], [tags], [days_since_review], [lat], [lng]) VALUES (N'8 10 Rue F licien David 16th arr 75016 Paris France', 134, CAST(N'2016-07-11T00:00:00.000' AS DateTime), CAST(7.50000 AS Decimal(18, 5)), N'Auteuil Tour Eiffel', N'Turkey', N'Front office do not know mathematics', 8, 1266, N'Location', 2, 29, CAST(7.50000 AS Decimal(18, 5)), N'['' Leisure trip '', '' Couple '', '' Standard Room '', '' Stayed 1 night '']', N'388 day', CAST(48.8510000 AS Decimal(18, 7)), CAST(2.2750000 AS Decimal(18, 7)))
GO
INSERT [dbo].[hotel_reviews] ([hotel_address], [additional_number_of_scoring], [review_date], [average_score], [hotel_name], [reviewer_nationality], [negative_review], [review_total_negative_word_counts], [total_number_of_reviews], [positive_review], [review_total_positive_word_counts], [total_number_of_reviews_reviewer_has_given], [reviewer_score], [tags], [days_since_review], [lat], [lng]) VALUES (N'Albany Street London NW1 3UP United Kingdom', 354, CAST(N'2016-12-28T00:00:00.000' AS DateTime), CAST(8.30000 AS Decimal(18, 5)), N'Melia White House Hotel', N'United Kingdom', N'2 faults in bathroom reported on arrival but still not fixed 4 days later', 15, 1871, N'Mattress topper orthopaedic pillows made bed comfortable Staff friendly helpful', 11, 2, CAST(8.80000 AS Decimal(18, 5)), N'['' Leisure trip '', '' Couple '', '' Classic Double Room '', '' Stayed 4 nights '']', N'218 day', CAST(51.5300000 AS Decimal(18, 7)), CAST(-0.1440000 AS Decimal(18, 7)))
GO
INSERT [dbo].[hotel_reviews] ([hotel_address], [additional_number_of_scoring], [review_date], [average_score], [hotel_name], [reviewer_nationality], [negative_review], [review_total_negative_word_counts], [total_number_of_reviews], [positive_review], [review_total_positive_word_counts], [total_number_of_reviews_reviewer_has_given], [reviewer_score], [tags], [days_since_review], [lat], [lng]) VALUES (N'372 Strand Westminster Borough London WC2R 0JJ United Kingdom', 2288, CAST(N'2016-03-12T00:00:00.000' AS DateTime), CAST(8.10000 AS Decimal(18, 5)), N'Strand Palace Hotel', N'Guernsey', N'Nothing really', 4, 9568, N'Very good breakfast Helpful reception staff Charming doormen', 10, 1, CAST(8.30000 AS Decimal(18, 5)), N'['' Leisure trip '', '' Solo traveler '', '' Standard Single Room '', '' Stayed 1 night '']', N'509 day', CAST(51.5110000 AS Decimal(18, 7)), CAST(-0.1210000 AS Decimal(18, 7)))
GO
INSERT [dbo].[hotel_reviews] ([hotel_address], [additional_number_of_scoring], [review_date], [average_score], [hotel_name], [reviewer_nationality], [negative_review], [review_total_negative_word_counts], [total_number_of_reviews], [positive_review], [review_total_positive_word_counts], [total_number_of_reviews_reviewer_has_given], [reviewer_score], [tags], [days_since_review], [lat], [lng]) VALUES (N'54 Queens Gate Kensington and Chelsea London SW7 5JW United Kingdom', 161, CAST(N'2017-05-21T00:00:00.000' AS DateTime), CAST(8.20000 AS Decimal(18, 5)), N'Fifty Four Boutique Hotel', N'Australia', N'TV wasn t working so they changed our room the new room didn t have a bath and had to go up and down stairs to elevator', 28, 684, N'the location', 3, 2, CAST(7.50000 AS Decimal(18, 5)), N'['' Leisure trip '', '' Couple '', '' Standard Double Room '', '' Stayed 3 nights '']', N'74 days', CAST(51.4960000 AS Decimal(18, 7)), CAST(-0.1800000 AS Decimal(18, 7)))
GO
INSERT [dbo].[hotel_reviews] ([hotel_address], [additional_number_of_scoring], [review_date], [average_score], [hotel_name], [reviewer_nationality], [negative_review], [review_total_negative_word_counts], [total_number_of_reviews], [positive_review], [review_total_positive_word_counts], [total_number_of_reviews_reviewer_has_given], [reviewer_score], [tags], [days_since_review], [lat], [lng]) VALUES (N'Gran Via 550 Eixample 08011 Barcelona Spain', 167, CAST(N'2016-05-03T00:00:00.000' AS DateTime), CAST(8.80000 AS Decimal(18, 5)), N'Hotel Vueling Bcn by HC', N'Tunisia', N'No Negative', 0, 1696, N'The bed is so comfortable and the hotelderly is very clean The staff is so friendly', 17, 1, CAST(10.00000 AS Decimal(18, 5)), N'['' Leisure trip '', '' Couple '', '' Twin Room '', '' Stayed 4 nights '', '' Submitted from a mobile device '']', N'457 day', CAST(41.3830000 AS Decimal(18, 7)), CAST(2.1600000 AS Decimal(18, 7)))
GO
INSERT [dbo].[hotel_reviews] ([hotel_address], [additional_number_of_scoring], [review_date], [average_score], [hotel_name], [reviewer_nationality], [negative_review], [review_total_negative_word_counts], [total_number_of_reviews], [positive_review], [review_total_positive_word_counts], [total_number_of_reviews_reviewer_has_given], [reviewer_score], [tags], [days_since_review], [lat], [lng]) VALUES (N'41 54 Buckingham Gate Westminster Borough London SW1E 6AF United Kingdom', 1299, CAST(N'2017-04-15T00:00:00.000' AS DateTime), CAST(8.70000 AS Decimal(18, 5)), N'St James Court A Taj Hotel London', N'Australia', N'The air con control was uncertain', 8, 5394, N'Excellent location great service helpful staff', 8, 5, CAST(10.00000 AS Decimal(18, 5)), N'['' Leisure trip '', '' Family with young children '', '' Executive Double Room '', '' Stayed 4 nights '', '' Submitted from a mobile device '']', N'110 day', CAST(51.4990000 AS Decimal(18, 7)), CAST(-0.1380000 AS Decimal(18, 7)))
GO
INSERT [dbo].[hotel_reviews] ([hotel_address], [additional_number_of_scoring], [review_date], [average_score], [hotel_name], [reviewer_nationality], [negative_review], [review_total_negative_word_counts], [total_number_of_reviews], [positive_review], [review_total_positive_word_counts], [total_number_of_reviews_reviewer_has_given], [reviewer_score], [tags], [days_since_review], [lat], [lng]) VALUES (N'Staalmeesterslaan 410 Slotervaart 1057 PH Amsterdam Netherlands', 926, CAST(N'2016-07-19T00:00:00.000' AS DateTime), CAST(8.20000 AS Decimal(18, 5)), N'Ramada Apollo Amsterdam Centre', N'China', N'Dirty poor staff service', 6, 5770, N'Very poor hotel only two star', 8, 3, CAST(2.50000 AS Decimal(18, 5)), N'['' Leisure trip '', '' Solo traveler '', '' Standard Double Room with Parking '', '' Stayed 1 night '', '' Submitted from a mobile device '']', N'380 day', CAST(52.3680000 AS Decimal(18, 7)), CAST(4.8440000 AS Decimal(18, 7)))
GO
INSERT [dbo].[hotel_reviews] ([hotel_address], [additional_number_of_scoring], [review_date], [average_score], [hotel_name], [reviewer_nationality], [negative_review], [review_total_negative_word_counts], [total_number_of_reviews], [positive_review], [review_total_positive_word_counts], [total_number_of_reviews_reviewer_has_given], [reviewer_score], [tags], [days_since_review], [lat], [lng]) VALUES (N'Apollolaan 138 Oud Zuid 1077 BG Amsterdam Netherlands', 168, CAST(N'2017-01-02T00:00:00.000' AS DateTime), CAST(8.30000 AS Decimal(18, 5)), N'Hilton Amsterdam', N'Germany', N'There were no additional blankets in the wardrobe', 9, 1064, N'No Positive', 0, 2, CAST(9.60000 AS Decimal(18, 5)), N'['' Leisure trip '', '' Couple '', '' Twin Deluxe Guest Room '', '' Stayed 1 night '', '' Submitted from a mobile device '']', N'213 day', CAST(52.3510000 AS Decimal(18, 7)), CAST(4.8730000 AS Decimal(18, 7)))
GO
INSERT [dbo].[hotel_reviews] ([hotel_address], [additional_number_of_scoring], [review_date], [average_score], [hotel_name], [reviewer_nationality], [negative_review], [review_total_negative_word_counts], [total_number_of_reviews], [positive_review], [review_total_positive_word_counts], [total_number_of_reviews_reviewer_has_given], [reviewer_score], [tags], [days_since_review], [lat], [lng]) VALUES (N'Via Luigi Galvani 12 Central Station 20124 Milan Italy', 143, CAST(N'2017-05-29T00:00:00.000' AS DateTime), CAST(8.20000 AS Decimal(18, 5)), N'Hilton Milan', N'Australia', N'No Negative', 0, 988, N'The room was nice and quiet and the staff knowledgeable and friendly', 14, 1, CAST(10.00000 AS Decimal(18, 5)), N'['' Leisure trip '', '' Couple '', '' King Guest Room '', '' Stayed 2 nights '', '' Submitted from a mobile device '']', N'66 days', CAST(45.4860000 AS Decimal(18, 7)), CAST(9.2000000 AS Decimal(18, 7)))
GO
INSERT [dbo].[hotel_reviews] ([hotel_address], [additional_number_of_scoring], [review_date], [average_score], [hotel_name], [reviewer_nationality], [negative_review], [review_total_negative_word_counts], [total_number_of_reviews], [positive_review], [review_total_positive_word_counts], [total_number_of_reviews_reviewer_has_given], [reviewer_score], [tags], [days_since_review], [lat], [lng]) VALUES (N'29 31 rue des Ecoles 5th arr 75005 Paris France', 90, CAST(N'2016-07-27T00:00:00.000' AS DateTime), CAST(8.70000 AS Decimal(18, 5)), N'Hotel Atmospheres', N'Japan', N'A triple room was really small Extra bed was not comfortable', 13, 654, N'The reception lady was very friendly', 8, 1, CAST(7.90000 AS Decimal(18, 5)), N'['' Leisure trip '', '' Group '', '' Triple Room '', '' Stayed 3 nights '']', N'372 day', CAST(48.8490000 AS Decimal(18, 7)), CAST(2.3480000 AS Decimal(18, 7)))
GO
INSERT [dbo].[hotel_reviews] ([hotel_address], [additional_number_of_scoring], [review_date], [average_score], [hotel_name], [reviewer_nationality], [negative_review], [review_total_negative_word_counts], [total_number_of_reviews], [positive_review], [review_total_positive_word_counts], [total_number_of_reviews_reviewer_has_given], [reviewer_score], [tags], [days_since_review], [lat], [lng]) VALUES (N'97 Great Russell Street Bloomsbury Camden London WC1B 3LB United Kingdom', 406, CAST(N'2016-04-24T00:00:00.000' AS DateTime), CAST(8.20000 AS Decimal(18, 5)), N'Radisson Blu Edwardian Kenilworth', N'Hungary', N'Rooms bathrooms are the size of a matchbox A double room is too small', 15, 2011, N'Location', 2, 1, CAST(5.80000 AS Decimal(18, 5)), N'['' Solo traveler '', '' Standard Double Twin Room '', '' Stayed 2 nights '', '' Submitted from a mobile device '']', N'466 day', CAST(51.5180000 AS Decimal(18, 7)), CAST(-0.1280000 AS Decimal(18, 7)))
GO
INSERT [dbo].[hotel_reviews] ([hotel_address], [additional_number_of_scoring], [review_date], [average_score], [hotel_name], [reviewer_nationality], [negative_review], [review_total_negative_word_counts], [total_number_of_reviews], [positive_review], [review_total_positive_word_counts], [total_number_of_reviews_reviewer_has_given], [reviewer_score], [tags], [days_since_review], [lat], [lng]) VALUES (N'44 Grosvenor Square Westminster Borough London W1K 2HP United Kingdom', 806, CAST(N'2016-06-23T00:00:00.000' AS DateTime), CAST(7.80000 AS Decimal(18, 5)), N'Millennium Hotel London Mayfair', N'United Kingdom', N'Staff were very rude shower wouldn t turn off', 10, 3117, N'Location', 2, 1, CAST(2.90000 AS Decimal(18, 5)), N'['' Business trip '', '' Solo traveler '', '' Double or Twin Room '', '' Stayed 2 nights '']', N'406 day', CAST(51.5110000 AS Decimal(18, 7)), CAST(-0.1510000 AS Decimal(18, 7)))
GO
INSERT [dbo].[hotel_reviews] ([hotel_address], [additional_number_of_scoring], [review_date], [average_score], [hotel_name], [reviewer_nationality], [negative_review], [review_total_negative_word_counts], [total_number_of_reviews], [positive_review], [review_total_positive_word_counts], [total_number_of_reviews_reviewer_has_given], [reviewer_score], [tags], [days_since_review], [lat], [lng]) VALUES (N'Excel 2 Festoon Way Royal Victoria Dock Newham London E16 1RH United Kingdom', 853, CAST(N'2017-06-27T00:00:00.000' AS DateTime), CAST(8.40000 AS Decimal(18, 5)), N'DoubleTree By Hilton London Excel', N'United Kingdom', N'Phone in room not working No robes in room No option of nutrition free cookies Area around hotel vety derelict', 21, 2726, N'Good breakfast selection', 4, 1, CAST(5.40000 AS Decimal(18, 5)), N'['' Leisure trip '', '' Group '', '' Queen Guest Room with Sofa Bed '', '' Stayed 1 night '', '' Submitted from a mobile device '']', N'37 days', CAST(51.5070000 AS Decimal(18, 7)), CAST(0.0390000 AS Decimal(18, 7)))
GO
INSERT [dbo].[hotel_reviews] ([hotel_address], [additional_number_of_scoring], [review_date], [average_score], [hotel_name], [reviewer_nationality], [negative_review], [review_total_negative_word_counts], [total_number_of_reviews], [positive_review], [review_total_positive_word_counts], [total_number_of_reviews_reviewer_has_given], [reviewer_score], [tags], [days_since_review], [lat], [lng]) VALUES (N'Manor Road London IG8 8AE United Kingdom', 227, CAST(N'2016-09-30T00:00:00.000' AS DateTime), CAST(6.90000 AS Decimal(18, 5)), N'Hallmark Hotel London Chigwell Prince Regent', N'United Kingdom', N'There was confusion when I booked in as reception hadn t recieved acted on the Booking com reservation Luckily there was a room available', 26, 747, N'Location', 2, 4, CAST(7.90000 AS Decimal(18, 5)), N'['' Business trip '', '' Solo traveler '', '' Single Room '', '' Stayed 1 night '']', N'307 day', CAST(51.6070000 AS Decimal(18, 7)), CAST(0.0590000 AS Decimal(18, 7)))
GO
INSERT [dbo].[hotel_reviews] ([hotel_address], [additional_number_of_scoring], [review_date], [average_score], [hotel_name], [reviewer_nationality], [negative_review], [review_total_negative_word_counts], [total_number_of_reviews], [positive_review], [review_total_positive_word_counts], [total_number_of_reviews_reviewer_has_given], [reviewer_score], [tags], [days_since_review], [lat], [lng]) VALUES (N'152 Cricklewood Broadway Cricklewood London NW2 3ED United Kingdom', 512, CAST(N'2016-03-02T00:00:00.000' AS DateTime), CAST(8.00000 AS Decimal(18, 5)), N'Clayton Crown Hotel London', N'United Kingdom', N'No Negative', 0, 2491, N'Very clean friendly staff stayed several times fab breakfast pub and restaurant in situ and a swimming pool bus outside to take you in to Oxford st', 29, 2, CAST(9.60000 AS Decimal(18, 5)), N'['' Leisure trip '', '' Family with older children '', '' Deluxe Double and Single Room '', '' Stayed 4 nights '', '' Submitted from a mobile device '']', N'519 day', CAST(51.5560000 AS Decimal(18, 7)), CAST(-0.2140000 AS Decimal(18, 7)))
GO
INSERT [dbo].[hotel_reviews] ([hotel_address], [additional_number_of_scoring], [review_date], [average_score], [hotel_name], [reviewer_nationality], [negative_review], [review_total_negative_word_counts], [total_number_of_reviews], [positive_review], [review_total_positive_word_counts], [total_number_of_reviews_reviewer_has_given], [reviewer_score], [tags], [days_since_review], [lat], [lng]) VALUES (N'Praterstra e 1 02 Leopoldstadt 1020 Vienna Austria', 137, CAST(N'2016-01-04T00:00:00.000' AS DateTime), CAST(9.00000 AS Decimal(18, 5)), N'Sofitel Vienna Stephansdom', N'Turkey', N'No Negative', 0, 1148, N'The personnel was very helpful and great location Book forward for the roof restaurant', 16, 6, CAST(8.80000 AS Decimal(18, 5)), N'['' Leisure trip '', '' Couple '', '' Superior Queen Room '', '' Stayed 4 nights '']', N'577 day', CAST(48.2130000 AS Decimal(18, 7)), CAST(16.3800000 AS Decimal(18, 7)))
GO
INSERT [dbo].[hotel_reviews] ([hotel_address], [additional_number_of_scoring], [review_date], [average_score], [hotel_name], [reviewer_nationality], [negative_review], [review_total_negative_word_counts], [total_number_of_reviews], [positive_review], [review_total_positive_word_counts], [total_number_of_reviews_reviewer_has_given], [reviewer_score], [tags], [days_since_review], [lat], [lng]) VALUES (N'41 Buckingham Palace Road Westminster Borough London SW1W 0PS United Kingdom', 66, CAST(N'2016-02-23T00:00:00.000' AS DateTime), CAST(9.60000 AS Decimal(18, 5)), N'41', N'Czech Republic', N'No Negative', 0, 244, N'The lounge Lauren the room top in London', 10, 10, CAST(10.00000 AS Decimal(18, 5)), N'['' Leisure trip '', '' Couple '', '' Executive King Room with Lounge Access '', '' Stayed 2 nights '', '' Submitted from a mobile device '']', N'527 day', CAST(51.4980000 AS Decimal(18, 7)), CAST(-0.1440000 AS Decimal(18, 7)))
GO
INSERT [dbo].[hotel_reviews] ([hotel_address], [additional_number_of_scoring], [review_date], [average_score], [hotel_name], [reviewer_nationality], [negative_review], [review_total_negative_word_counts], [total_number_of_reviews], [positive_review], [review_total_positive_word_counts], [total_number_of_reviews_reviewer_has_given], [reviewer_score], [tags], [days_since_review], [lat], [lng]) VALUES (N'Hobbemakade 50 Oud Zuid 1071 XL Amsterdam Netherlands', 141, CAST(N'2016-12-05T00:00:00.000' AS DateTime), CAST(8.00000 AS Decimal(18, 5)), N'NH Amsterdam Museum Quarter', N'Lebanon', N'No Negative', 0, 854, N'Every things', 3, 2, CAST(7.50000 AS Decimal(18, 5)), N'['' Leisure trip '', '' Couple '', '' Superior Double Room '', '' Stayed 3 nights '', '' Submitted from a mobile device '']', N'241 day', CAST(52.3560000 AS Decimal(18, 7)), CAST(4.8860000 AS Decimal(18, 7)))
GO
INSERT [dbo].[hotel_reviews] ([hotel_address], [additional_number_of_scoring], [review_date], [average_score], [hotel_name], [reviewer_nationality], [negative_review], [review_total_negative_word_counts], [total_number_of_reviews], [positive_review], [review_total_positive_word_counts], [total_number_of_reviews_reviewer_has_given], [reviewer_score], [tags], [days_since_review], [lat], [lng]) VALUES (N'Westminster Bridge Road Lambeth London SE1 7UT United Kingdom', 2623, CAST(N'2016-10-14T00:00:00.000' AS DateTime), CAST(8.70000 AS Decimal(18, 5)), N'Park Plaza Westminster Bridge London', N'Norway', N'No Negative', 0, 12158, N'Staff were friendly and the hotel is in a great location', 13, 1, CAST(7.50000 AS Decimal(18, 5)), N'['' Business trip '', '' Solo traveler '', '' Superior Double Room Disability Access '', '' Stayed 2 nights '']', N'293 day', CAST(51.5010000 AS Decimal(18, 7)), CAST(-0.1170000 AS Decimal(18, 7)))
GO
INSERT [dbo].[hotel_reviews] ([hotel_address], [additional_number_of_scoring], [review_date], [average_score], [hotel_name], [reviewer_nationality], [negative_review], [review_total_negative_word_counts], [total_number_of_reviews], [positive_review], [review_total_positive_word_counts], [total_number_of_reviews_reviewer_has_given], [reviewer_score], [tags], [days_since_review], [lat], [lng]) VALUES (N'81 Jermyn Street Westminster Borough London SW1Y 6JF United Kingdom', 243, CAST(N'2015-08-30T00:00:00.000' AS DateTime), CAST(8.80000 AS Decimal(18, 5)), N'The Cavendish London', N'Switzerland', N'Nothing', 2, 1039, N'Everything', 2, 4, CAST(10.00000 AS Decimal(18, 5)), N'['' Leisure trip '', '' Solo traveler '', '' Classic Double Room '', '' Stayed 4 nights '', '' Submitted from a mobile device '']', N'704 day', CAST(51.5080000 AS Decimal(18, 7)), CAST(-0.1380000 AS Decimal(18, 7)))
GO
INSERT [dbo].[hotel_reviews] ([hotel_address], [additional_number_of_scoring], [review_date], [average_score], [hotel_name], [reviewer_nationality], [negative_review], [review_total_negative_word_counts], [total_number_of_reviews], [positive_review], [review_total_positive_word_counts], [total_number_of_reviews_reviewer_has_given], [reviewer_score], [tags], [days_since_review], [lat], [lng]) VALUES (N'19 21 Penywern Road Kensington and Chelsea London SW5 9TT United Kingdom', 249, CAST(N'2016-09-14T00:00:00.000' AS DateTime), CAST(7.70000 AS Decimal(18, 5)), N'Best Western The Boltons Hotel London Kensington', N'Australia', N'limited space in bedroom particularly with 3 cases', 9, 1573, N'Extremely welcoming helpful welcoming staff all shifts especially on arrival at MN great location close to everything transport etc', 20, 1, CAST(9.20000 AS Decimal(18, 5)), N'['' Leisure trip '', '' Couple '', '' Double Room '', '' Stayed 2 nights '']', N'323 day', CAST(51.4910000 AS Decimal(18, 7)), CAST(-0.1930000 AS Decimal(18, 7)))
GO
INSERT [dbo].[hotel_reviews] ([hotel_address], [additional_number_of_scoring], [review_date], [average_score], [hotel_name], [reviewer_nationality], [negative_review], [review_total_negative_word_counts], [total_number_of_reviews], [positive_review], [review_total_positive_word_counts], [total_number_of_reviews_reviewer_has_given], [reviewer_score], [tags], [days_since_review], [lat], [lng]) VALUES (N'Boquer a 10 Ciutat Vella 08002 Barcelona Spain', 392, CAST(N'2016-06-30T00:00:00.000' AS DateTime), CAST(8.50000 AS Decimal(18, 5)), N'Petit Palace Boqueria Garden', N'United Kingdom', N'Nothing obvious', 3, 3602, N'Superb location but it was wonderful staff who made it', 11, 17, CAST(9.20000 AS Decimal(18, 5)), N'['' Leisure trip '', '' Couple '', '' Double or Twin Room 1 2 Adults '', '' Stayed 2 nights '', '' Submitted from a mobile device '']', N'399 day', CAST(41.3810000 AS Decimal(18, 7)), CAST(2.1740000 AS Decimal(18, 7)))
GO
INSERT [dbo].[hotel_reviews] ([hotel_address], [additional_number_of_scoring], [review_date], [average_score], [hotel_name], [reviewer_nationality], [negative_review], [review_total_negative_word_counts], [total_number_of_reviews], [positive_review], [review_total_positive_word_counts], [total_number_of_reviews_reviewer_has_given], [reviewer_score], [tags], [days_since_review], [lat], [lng]) VALUES (N'26 28 Trebovir Rd Kensington and Chelsea London SW5 9NJ United Kingdom', 328, CAST(N'2016-09-15T00:00:00.000' AS DateTime), CAST(7.50000 AS Decimal(18, 5)), N'Mayflower Hotel Apartments', N'United Kingdom', N'The bed was small Very noisy too eveytime you moved there was a creaking noise', 17, 2197, N'The location was perfect round the corner from the tube station The staff was friendly', 17, 2, CAST(7.90000 AS Decimal(18, 5)), N'['' Leisure trip '', '' Couple '', '' Small Double Room '', '' Stayed 2 nights '', '' Submitted from a mobile device '']', N'322 day', CAST(51.4920000 AS Decimal(18, 7)), CAST(-0.1950000 AS Decimal(18, 7)))
GO
INSERT [dbo].[hotel_reviews] ([hotel_address], [additional_number_of_scoring], [review_date], [average_score], [hotel_name], [reviewer_nationality], [negative_review], [review_total_negative_word_counts], [total_number_of_reviews], [positive_review], [review_total_positive_word_counts], [total_number_of_reviews_reviewer_has_given], [reviewer_score], [tags], [days_since_review], [lat], [lng]) VALUES (N'Delflandlaan 15 Slotervaart 1062 EA Amsterdam Netherlands', 947, CAST(N'2017-05-07T00:00:00.000' AS DateTime), CAST(8.70000 AS Decimal(18, 5)), N'Best Western Premier Hotel Couture', N'Italy', N'No Negative', 0, 8177, N'Very good hotel I highly recommend especially for who is travelling for business', 15, 15, CAST(10.00000 AS Decimal(18, 5)), N'['' Business trip '', '' Solo traveler '', '' Standard Double or Twin Room '', '' Stayed 2 nights '', '' Submitted from a mobile device '']', N'88 days', CAST(52.3510000 AS Decimal(18, 7)), CAST(4.8410000 AS Decimal(18, 7)))
GO
INSERT [dbo].[hotel_reviews] ([hotel_address], [additional_number_of_scoring], [review_date], [average_score], [hotel_name], [reviewer_nationality], [negative_review], [review_total_negative_word_counts], [total_number_of_reviews], [positive_review], [review_total_positive_word_counts], [total_number_of_reviews_reviewer_has_given], [reviewer_score], [tags], [days_since_review], [lat], [lng]) VALUES (N'Wurzbachgasse 21 15 Rudolfsheim F nfhaus 1150 Vienna Austria', 168, CAST(N'2016-04-28T00:00:00.000' AS DateTime), CAST(8.10000 AS Decimal(18, 5)), N'Atlantis Hotel Vienna', N'Iraq', N'breakfast price', 3, 2823, N'Location of the hotel', 5, 5, CAST(9.20000 AS Decimal(18, 5)), N'['' Group '', '' Standard Double or Twin Room '', '' Stayed 3 nights '', '' Submitted from a mobile device '']', N'462 day', CAST(48.2040000 AS Decimal(18, 7)), CAST(16.3360000 AS Decimal(18, 7)))
GO
INSERT [dbo].[hotel_reviews] ([hotel_address], [additional_number_of_scoring], [review_date], [average_score], [hotel_name], [reviewer_nationality], [negative_review], [review_total_negative_word_counts], [total_number_of_reviews], [positive_review], [review_total_positive_word_counts], [total_number_of_reviews_reviewer_has_given], [reviewer_score], [tags], [days_since_review], [lat], [lng]) VALUES (N'Hietzinger Hauptstra e 10 14 13 Hietzing 1130 Vienna Austria', 247, CAST(N'2017-05-04T00:00:00.000' AS DateTime), CAST(8.60000 AS Decimal(18, 5)), N'Austria Trend Parkhotel Sch nbrunn Wien', N'Australia', N'Far away from city centre and other sightseeings However public transport underground train is easily accessible', 18, 4026, N'Nice Hotel and Good location to see Sch nbrunn Palace Palm House Zoo and the Glory specially for those who are travelling with family kids', 27, 1, CAST(5.00000 AS Decimal(18, 5)), N'['' Leisure trip '', '' Family with young children '', '' Comfort Double Room '', '' Stayed 4 nights '']', N'91 days', CAST(48.1870000 AS Decimal(18, 7)), CAST(16.3020000 AS Decimal(18, 7)))
GO
INSERT [dbo].[hotel_reviews] ([hotel_address], [additional_number_of_scoring], [review_date], [average_score], [hotel_name], [reviewer_nationality], [negative_review], [review_total_negative_word_counts], [total_number_of_reviews], [positive_review], [review_total_positive_word_counts], [total_number_of_reviews_reviewer_has_given], [reviewer_score], [tags], [days_since_review], [lat], [lng]) VALUES (N'10 Beaufort Gardens Kensington and Chelsea London SW3 1PT United Kingdom', 129, CAST(N'2016-12-02T00:00:00.000' AS DateTime), CAST(9.10000 AS Decimal(18, 5)), N'Knightsbridge Hotel', N'United Kingdom', N'A little small', 4, 473, N'Quiet and good beds', 5, 1, CAST(7.90000 AS Decimal(18, 5)), N'['' Leisure trip '', '' Couple '', '' Superior Room '', '' Stayed 1 night '', '' Submitted from a mobile device '']', N'244 day', CAST(51.4980000 AS Decimal(18, 7)), CAST(-0.1640000 AS Decimal(18, 7)))
GO
INSERT [dbo].[hotel_reviews] ([hotel_address], [additional_number_of_scoring], [review_date], [average_score], [hotel_name], [reviewer_nationality], [negative_review], [review_total_negative_word_counts], [total_number_of_reviews], [positive_review], [review_total_positive_word_counts], [total_number_of_reviews_reviewer_has_given], [reviewer_score], [tags], [days_since_review], [lat], [lng]) VALUES (N'53 Upper Street Islington London N1 0UY United Kingdom', 429, CAST(N'2016-05-06T00:00:00.000' AS DateTime), CAST(8.60000 AS Decimal(18, 5)), N'Hilton London Angel Islington', N'United Kingdom', N'No Negative', 0, 1462, N'Clean comfortable lovely staff', 5, 10, CAST(10.00000 AS Decimal(18, 5)), N'['' Business trip '', '' Group '', '' Twin Guest Room '', '' Stayed 1 night '', '' Submitted from a mobile device '']', N'454 day', CAST(51.5360000 AS Decimal(18, 7)), CAST(-0.1050000 AS Decimal(18, 7)))
GO
INSERT [dbo].[hotel_reviews] ([hotel_address], [additional_number_of_scoring], [review_date], [average_score], [hotel_name], [reviewer_nationality], [negative_review], [review_total_negative_word_counts], [total_number_of_reviews], [positive_review], [review_total_positive_word_counts], [total_number_of_reviews_reviewer_has_given], [reviewer_score], [tags], [days_since_review], [lat], [lng]) VALUES (N'Herengracht 341 Amsterdam City Center 1016 AZ Amsterdam Netherlands', 265, CAST(N'2016-06-08T00:00:00.000' AS DateTime), CAST(9.30000 AS Decimal(18, 5)), N'Ambassade Hotel', N'United States of America', N'No Negative', 0, 1611, N'Aesthetics comfortable bed and room personal touches delicious breakfast very helpful and friendly staff I could not have wished for better in any respect', 26, 1, CAST(10.00000 AS Decimal(18, 5)), N'['' Leisure trip '', '' Solo traveler '', '' Deluxe Double or Twin Room with Canal View '', '' Stayed 6 nights '']', N'421 day', CAST(52.3690000 AS Decimal(18, 7)), CAST(4.8870000 AS Decimal(18, 7)))
GO
INSERT [dbo].[hotel_reviews] ([hotel_address], [additional_number_of_scoring], [review_date], [average_score], [hotel_name], [reviewer_nationality], [negative_review], [review_total_negative_word_counts], [total_number_of_reviews], [positive_review], [review_total_positive_word_counts], [total_number_of_reviews_reviewer_has_given], [reviewer_score], [tags], [days_since_review], [lat], [lng]) VALUES (N'58 Shepherds Bush Green Hammersmith and Fulham London W12 8QE United Kingdom', 690, CAST(N'2016-08-30T00:00:00.000' AS DateTime), CAST(8.60000 AS Decimal(18, 5)), N'Dorsett Shepherds Bush', N'United Kingdom', N'Bar closed early', 4, 2890, N'Free upgrade', 3, 4, CAST(9.20000 AS Decimal(18, 5)), N'['' Leisure trip '', '' Group '', '' Dorsett Double Room '', '' Stayed 2 nights '', '' Submitted from a mobile device '']', N'338 day', CAST(51.5040000 AS Decimal(18, 7)), CAST(-0.2240000 AS Decimal(18, 7)))
GO
INSERT [dbo].[hotel_reviews] ([hotel_address], [additional_number_of_scoring], [review_date], [average_score], [hotel_name], [reviewer_nationality], [negative_review], [review_total_negative_word_counts], [total_number_of_reviews], [positive_review], [review_total_positive_word_counts], [total_number_of_reviews_reviewer_has_given], [reviewer_score], [tags], [days_since_review], [lat], [lng]) VALUES (N'Jan Luijkenstraat 76 Oud Zuid 1071 CT Amsterdam Netherlands', 146, CAST(N'2017-01-04T00:00:00.000' AS DateTime), CAST(8.80000 AS Decimal(18, 5)), N'Hotel JL No76', N'Cyprus', N'No Negative', 0, 914, N'everything', 2, 3, CAST(10.00000 AS Decimal(18, 5)), N'['' Leisure trip '', '' Couple '', '' Comfort Double or Twin Room '', '' Stayed 5 nights '']', N'211 day', CAST(52.3600000 AS Decimal(18, 7)), CAST(4.8800000 AS Decimal(18, 7)))
GO
INSERT [dbo].[hotel_reviews] ([hotel_address], [additional_number_of_scoring], [review_date], [average_score], [hotel_name], [reviewer_nationality], [negative_review], [review_total_negative_word_counts], [total_number_of_reviews], [positive_review], [review_total_positive_word_counts], [total_number_of_reviews_reviewer_has_given], [reviewer_score], [tags], [days_since_review], [lat], [lng]) VALUES (N'Fleischmarkt 1a 01 Innere Stadt 1010 Vienna Austria', 104, CAST(N'2017-03-19T00:00:00.000' AS DateTime), CAST(8.30000 AS Decimal(18, 5)), N'Mercure Wien Zentrum', N'Singapore', N'No Negative', 0, 1105, N'Bed was too soft encountered one unfriendly staff manning the concierge', 12, 1, CAST(7.10000 AS Decimal(18, 5)), N'['' Business trip '', '' Solo traveler '', '' Standard Double Room '', '' Stayed 5 nights '']', N'137 day', CAST(48.2110000 AS Decimal(18, 7)), CAST(16.3750000 AS Decimal(18, 7)))
GO
INSERT [dbo].[hotel_reviews] ([hotel_address], [additional_number_of_scoring], [review_date], [average_score], [hotel_name], [reviewer_nationality], [negative_review], [review_total_negative_word_counts], [total_number_of_reviews], [positive_review], [review_total_positive_word_counts], [total_number_of_reviews_reviewer_has_given], [reviewer_score], [tags], [days_since_review], [lat], [lng]) VALUES (N'Arend Janszoon Ernststraat 577 Zuideramstel 1082 LD Amsterdam Netherlands', 161, CAST(N'2016-06-26T00:00:00.000' AS DateTime), CAST(8.90000 AS Decimal(18, 5)), N'Element Amsterdam', N'India', N'No Negative', 0, 1369, N'Very convenient location 10 min walk from Amst Zuid connected to a v nice mall in a charming neighbourhood Great base for business or leisure Very clean good kitchenette Lovely people esp those at breakfast', 37, 10, CAST(9.60000 AS Decimal(18, 5)), N'['' Leisure trip '', '' Family with young children '', '' One Bedroom Suite '', '' Stayed 3 nights '']', N'403 day', CAST(52.3310000 AS Decimal(18, 7)), CAST(4.8770000 AS Decimal(18, 7)))
GO
INSERT [dbo].[hotel_reviews] ([hotel_address], [additional_number_of_scoring], [review_date], [average_score], [hotel_name], [reviewer_nationality], [negative_review], [review_total_negative_word_counts], [total_number_of_reviews], [positive_review], [review_total_positive_word_counts], [total_number_of_reviews_reviewer_has_given], [reviewer_score], [tags], [days_since_review], [lat], [lng]) VALUES (N'Delflandlaan 15 Slotervaart 1062 EA Amsterdam Netherlands', 947, CAST(N'2016-07-21T00:00:00.000' AS DateTime), CAST(8.70000 AS Decimal(18, 5)), N'Best Western Premier Hotel Couture', N'United Kingdom', N'No bar it would have been nice to have a glass of wine with our meal or enjoy a gin and tonic in the evening The boys would have liked a beer', 33, 8177, N'Nice light comfortable room very handy for tram into town', 12, 2, CAST(6.70000 AS Decimal(18, 5)), N'['' Leisure trip '', '' Group '', '' Standard Double or Twin Room '', '' Stayed 2 nights '', '' Submitted from a mobile device '']', N'378 day', CAST(52.3510000 AS Decimal(18, 7)), CAST(4.8410000 AS Decimal(18, 7)))
GO
INSERT [dbo].[hotel_reviews] ([hotel_address], [additional_number_of_scoring], [review_date], [average_score], [hotel_name], [reviewer_nationality], [negative_review], [review_total_negative_word_counts], [total_number_of_reviews], [positive_review], [review_total_positive_word_counts], [total_number_of_reviews_reviewer_has_given], [reviewer_score], [tags], [days_since_review], [lat], [lng]) VALUES (N'26 28 Trebovir Rd Kensington and Chelsea London SW5 9NJ United Kingdom', 328, CAST(N'2016-12-22T00:00:00.000' AS DateTime), CAST(7.50000 AS Decimal(18, 5)), N'Mayflower Hotel Apartments', N'United States of America', N'Despite what I just said this room was a little tight for two people but I d do it again for the value', 25, 2197, N'I go to London to mostly be out and about doing theatre and museums When I am in the room I am usually sleeping so overall accommodations aren t that important to me Plus Earls Court is a great location with three tube lines', 46, 3, CAST(8.50000 AS Decimal(18, 5)), N'['' Leisure trip '', '' Family with young children '', '' Standard Twin Room '', '' Stayed 4 nights '']', N'224 day', CAST(51.4920000 AS Decimal(18, 7)), CAST(-0.1950000 AS Decimal(18, 7)))
GO
INSERT [dbo].[hotel_reviews] ([hotel_address], [additional_number_of_scoring], [review_date], [average_score], [hotel_name], [reviewer_nationality], [negative_review], [review_total_negative_word_counts], [total_number_of_reviews], [positive_review], [review_total_positive_word_counts], [total_number_of_reviews_reviewer_has_given], [reviewer_score], [tags], [days_since_review], [lat], [lng]) VALUES (N'61 Quai De Grenelle 15th arr 75015 Paris France', 342, CAST(N'2015-08-13T00:00:00.000' AS DateTime), CAST(7.60000 AS Decimal(18, 5)), N'Novotel Paris Centre Tour Eiffel', N'United States of America', N'Breakfast buffet was the same everyday Toilet was separate from bathroom and on opposite side but I guess it has its advantages of it being separate', 28, 2310, N'Great location comfortable accommodation', 6, 1, CAST(9.60000 AS Decimal(18, 5)), N'['' Leisure trip '', '' Couple '', '' Standard Room with 1 Double Bed '', '' Stayed 5 nights '']', N'721 day', CAST(48.8500000 AS Decimal(18, 7)), CAST(2.2830000 AS Decimal(18, 7)))
GO
INSERT [dbo].[hotel_reviews] ([hotel_address], [additional_number_of_scoring], [review_date], [average_score], [hotel_name], [reviewer_nationality], [negative_review], [review_total_negative_word_counts], [total_number_of_reviews], [positive_review], [review_total_positive_word_counts], [total_number_of_reviews_reviewer_has_given], [reviewer_score], [tags], [days_since_review], [lat], [lng]) VALUES (N'Hendrikje Stoffelstraat 1 Slotervaart 1058 GC Amsterdam Netherlands', 757, CAST(N'2016-10-27T00:00:00.000' AS DateTime), CAST(8.70000 AS Decimal(18, 5)), N'WestCord Fashion Hotel Amsterdam', N'Ireland', N'One security man was a bit unsettling creepy when you went out late at night', 17, 5236, N'Felt very comfortable in the room the bath was lovely Great location and amenities available', 17, 1, CAST(10.00000 AS Decimal(18, 5)), N'['' Leisure trip '', '' Couple '', '' Large Double Room '', '' Stayed 6 nights '']', N'280 day', CAST(52.3580000 AS Decimal(18, 7)), CAST(4.8450000 AS Decimal(18, 7)))
GO
INSERT [dbo].[hotel_reviews] ([hotel_address], [additional_number_of_scoring], [review_date], [average_score], [hotel_name], [reviewer_nationality], [negative_review], [review_total_negative_word_counts], [total_number_of_reviews], [positive_review], [review_total_positive_word_counts], [total_number_of_reviews_reviewer_has_given], [reviewer_score], [tags], [days_since_review], [lat], [lng]) VALUES (N'335 337 Old Street Hackney London EC1V 9LL United Kingdom', 144, CAST(N'2017-01-27T00:00:00.000' AS DateTime), CAST(8.90000 AS Decimal(18, 5)), N'Courthouse Hotel Shoreditch', N'Netherlands', N'The staff didn t seem to match the maturity of the hotel All very inexperienced and at times not very helpful The bar was also quite lifeless and not very welcoming from the entrance hall', 37, 477, N'The room bathroom and bed were all very nice The mobile phone you can take out was also very useful even if it was a bit bulky', 28, 3, CAST(8.30000 AS Decimal(18, 5)), N'['' Leisure trip '', '' Couple '', '' Dalston King '', '' Stayed 3 nights '', '' Submitted from a mobile device '']', N'188 day', CAST(51.5270000 AS Decimal(18, 7)), CAST(-0.0800000 AS Decimal(18, 7)))
GO
INSERT [dbo].[hotel_reviews] ([hotel_address], [additional_number_of_scoring], [review_date], [average_score], [hotel_name], [reviewer_nationality], [negative_review], [review_total_negative_word_counts], [total_number_of_reviews], [positive_review], [review_total_positive_word_counts], [total_number_of_reviews_reviewer_has_given], [reviewer_score], [tags], [days_since_review], [lat], [lng]) VALUES (N'22 Hertsmere Road Tower Hamlets London E14 4ED United Kingdom', 930, CAST(N'2016-06-07T00:00:00.000' AS DateTime), CAST(8.90000 AS Decimal(18, 5)), N'London Marriott Hotel West India Quay', N'United Kingdom', N'All good', 3, 2836, N'Everything had a great time staff were great and friendly Little hard to get a drink later at night but it was busy', 25, 1, CAST(9.60000 AS Decimal(18, 5)), N'['' Leisure trip '', '' Couple '', '' Deluxe King or Twin Room '', '' Stayed 1 night '', '' Submitted from a mobile device '']', N'422 day', CAST(51.5070000 AS Decimal(18, 7)), CAST(-0.0210000 AS Decimal(18, 7)))
GO
INSERT [dbo].[hotel_reviews] ([hotel_address], [additional_number_of_scoring], [review_date], [average_score], [hotel_name], [reviewer_nationality], [negative_review], [review_total_negative_word_counts], [total_number_of_reviews], [positive_review], [review_total_positive_word_counts], [total_number_of_reviews_reviewer_has_given], [reviewer_score], [tags], [days_since_review], [lat], [lng]) VALUES (N'Damrak 1 5 Amsterdam City Center 1012 LG Amsterdam Netherlands', 973, CAST(N'2017-03-13T00:00:00.000' AS DateTime), CAST(8.00000 AS Decimal(18, 5)), N'Park Plaza Victoria Amsterdam', N'United Kingdom', N'Rooms are a little dated', 6, 4820, N'Excellent location standard rooms are a little dated however very clean Very helpful staff fantastic level of service Perfect location', 22, 6, CAST(8.80000 AS Decimal(18, 5)), N'['' Leisure trip '', '' Couple '', '' Double Room '', '' Stayed 1 night '', '' Submitted from a mobile device '']', N'143 day', CAST(52.3770000 AS Decimal(18, 7)), CAST(4.8980000 AS Decimal(18, 7)))
GO
INSERT [dbo].[hotel_reviews] ([hotel_address], [additional_number_of_scoring], [review_date], [average_score], [hotel_name], [reviewer_nationality], [negative_review], [review_total_negative_word_counts], [total_number_of_reviews], [positive_review], [review_total_positive_word_counts], [total_number_of_reviews_reviewer_has_given], [reviewer_score], [tags], [days_since_review], [lat], [lng]) VALUES (N'25 Courtfield Gardens Kensington and Chelsea London SW5 0PG United Kingdom', 222, CAST(N'2016-05-01T00:00:00.000' AS DateTime), CAST(9.00000 AS Decimal(18, 5)), N'The Nadler Kensington', N'Malta', N'Minute room', 3, 1209, N'No Positive', 0, 4, CAST(8.80000 AS Decimal(18, 5)), N'['' Business trip '', '' Solo traveler '', '' Small Double Room '', '' Stayed 2 nights '', '' Submitted from a mobile device '']', N'459 day', CAST(51.4930000 AS Decimal(18, 7)), CAST(-0.1900000 AS Decimal(18, 7)))
GO
INSERT [dbo].[hotel_reviews] ([hotel_address], [additional_number_of_scoring], [review_date], [average_score], [hotel_name], [reviewer_nationality], [negative_review], [review_total_negative_word_counts], [total_number_of_reviews], [positive_review], [review_total_positive_word_counts], [total_number_of_reviews_reviewer_has_given], [reviewer_score], [tags], [days_since_review], [lat], [lng]) VALUES (N's Gravesandestraat 55 Oost 1092 AA Amsterdam Netherlands', 194, CAST(N'2015-12-30T00:00:00.000' AS DateTime), CAST(7.70000 AS Decimal(18, 5)), N'Hotel Arena', N'United States of America', N'No Negative', 0, 1403, N'location and staff', 4, 3, CAST(9.60000 AS Decimal(18, 5)), N'['' Leisure trip '', '' Couple '', '' Duplex Double Room '', '' Stayed 3 nights '']', N'582 day', CAST(52.3610000 AS Decimal(18, 7)), CAST(4.9160000 AS Decimal(18, 7)))
GO
INSERT [dbo].[hotel_reviews] ([hotel_address], [additional_number_of_scoring], [review_date], [average_score], [hotel_name], [reviewer_nationality], [negative_review], [review_total_negative_word_counts], [total_number_of_reviews], [positive_review], [review_total_positive_word_counts], [total_number_of_reviews_reviewer_has_given], [reviewer_score], [tags], [days_since_review], [lat], [lng]) VALUES (N's Gravesandestraat 55 Oost 1092 AA Amsterdam Netherlands', 194, CAST(N'2016-05-30T00:00:00.000' AS DateTime), CAST(7.70000 AS Decimal(18, 5)), N'Hotel Arena', N'United Kingdom', N'No Negative', 0, 1403, N'breakfast', 2, 1, CAST(3.80000 AS Decimal(18, 5)), N'['' Leisure trip '', '' Family with older children '', '' Duplex Double Room '', '' Stayed 4 nights '', '' Submitted from a mobile device '']', N'430 day', CAST(52.3610000 AS Decimal(18, 7)), CAST(4.9160000 AS Decimal(18, 7)))
GO
INSERT [dbo].[hotel_reviews] ([hotel_address], [additional_number_of_scoring], [review_date], [average_score], [hotel_name], [reviewer_nationality], [negative_review], [review_total_negative_word_counts], [total_number_of_reviews], [positive_review], [review_total_positive_word_counts], [total_number_of_reviews_reviewer_has_given], [reviewer_score], [tags], [days_since_review], [lat], [lng]) VALUES (N's Gravesandestraat 55 Oost 1092 AA Amsterdam Netherlands', 194, CAST(N'2016-04-17T00:00:00.000' AS DateTime), CAST(7.70000 AS Decimal(18, 5)), N'Hotel Arena', N'Spain', N'Currently have building work in the complex This didn t affect our stay as we heard nothing but visually not ideal when you arrive', 26, 1403, N'Very comfortable bed and cool hotel', 7, 17, CAST(8.80000 AS Decimal(18, 5)), N'['' Leisure trip '', '' Couple '', '' Duplex Twin Room '', '' Stayed 1 night '', '' Submitted from a mobile device '']', N'473 day', CAST(52.3610000 AS Decimal(18, 7)), CAST(4.9160000 AS Decimal(18, 7)))
GO
INSERT [dbo].[hotel_reviews] ([hotel_address], [additional_number_of_scoring], [review_date], [average_score], [hotel_name], [reviewer_nationality], [negative_review], [review_total_negative_word_counts], [total_number_of_reviews], [positive_review], [review_total_positive_word_counts], [total_number_of_reviews_reviewer_has_given], [reviewer_score], [tags], [days_since_review], [lat], [lng]) VALUES (N's Gravesandestraat 55 Oost 1092 AA Amsterdam Netherlands', 194, CAST(N'2015-08-26T00:00:00.000' AS DateTime), CAST(7.70000 AS Decimal(18, 5)), N'Hotel Arena', N'United Kingdom', N'There were renovations going on that made it quite noisy at times', 13, 1403, N'How different it was from other hotels the staff the bar area and the location was good for tram access', 21, 8, CAST(8.30000 AS Decimal(18, 5)), N'['' Leisure trip '', '' Group '', '' Duplex Double Room '', '' Stayed 3 nights '', '' Submitted from a mobile device '']', N'708 day', CAST(52.3610000 AS Decimal(18, 7)), CAST(4.9160000 AS Decimal(18, 7)))
GO
INSERT [dbo].[hotel_reviews] ([hotel_address], [additional_number_of_scoring], [review_date], [average_score], [hotel_name], [reviewer_nationality], [negative_review], [review_total_negative_word_counts], [total_number_of_reviews], [positive_review], [review_total_positive_word_counts], [total_number_of_reviews_reviewer_has_given], [reviewer_score], [tags], [days_since_review], [lat], [lng]) VALUES (N's Gravesandestraat 55 Oost 1092 AA Amsterdam Netherlands', 194, CAST(N'2016-11-27T00:00:00.000' AS DateTime), CAST(7.70000 AS Decimal(18, 5)), N'Hotel Arena', N'France', N'Hotel under renovation', 5, 1403, N'Breakfast', 2, 23, CAST(6.30000 AS Decimal(18, 5)), N'['' Business trip '', '' Solo traveler '', '' Duplex Twin Room '', '' Stayed 2 nights '']', N'249 day', CAST(52.3610000 AS Decimal(18, 7)), CAST(4.9160000 AS Decimal(18, 7)))
GO
INSERT [dbo].[hotel_reviews] ([hotel_address], [additional_number_of_scoring], [review_date], [average_score], [hotel_name], [reviewer_nationality], [negative_review], [review_total_negative_word_counts], [total_number_of_reviews], [positive_review], [review_total_positive_word_counts], [total_number_of_reviews_reviewer_has_given], [reviewer_score], [tags], [days_since_review], [lat], [lng]) VALUES (N's Gravesandestraat 55 Oost 1092 AA Amsterdam Netherlands', 194, CAST(N'2017-05-21T00:00:00.000' AS DateTime), CAST(7.70000 AS Decimal(18, 5)), N'Hotel Arena', N'United States of America', N'We had 2 different rooms here and both were duplexes with identical floorplans There was very little space and the staircase was precarious with no handrail Was kind of a pain to have to go downstairs every time we needed something out of our luggage or needed to use the bathroom', 53, 1403, N'The hotel itself is beautiful restaurant is very good and the adjacent park is gorgeous with beautiful birds and rabbits', 22, 4, CAST(8.30000 AS Decimal(18, 5)), N'['' Leisure trip '', '' Couple '', '' Duplex Double Room '', '' Stayed 3 nights '']', N'74 days', CAST(52.3610000 AS Decimal(18, 7)), CAST(4.9160000 AS Decimal(18, 7)))
GO
INSERT [dbo].[hotel_reviews] ([hotel_address], [additional_number_of_scoring], [review_date], [average_score], [hotel_name], [reviewer_nationality], [negative_review], [review_total_negative_word_counts], [total_number_of_reviews], [positive_review], [review_total_positive_word_counts], [total_number_of_reviews_reviewer_has_given], [reviewer_score], [tags], [days_since_review], [lat], [lng]) VALUES (N's Gravesandestraat 55 Oost 1092 AA Amsterdam Netherlands', 194, CAST(N'2016-02-03T00:00:00.000' AS DateTime), CAST(7.70000 AS Decimal(18, 5)), N'Hotel Arena', N'Netherlands', N'The location isn t great bit far out from the centre and area surrounding hotel looks rough The hotel looked out of place there When upgrading to a suite with bathtub extra 25 one of the pillows was filthy A call to reception and a new pillow arrived within the hour But still not what you would expect Room service is very expensive and not good quality or as described on the menu', 75, 1403, N'The rooms were gorgeous bathroom to die for we upgraded to a suite with bath the hotel interior very nice lovely atmosphere Due to building work In progress we were given a voucher for a free drink at the bar nice gesture', 44, 1, CAST(7.10000 AS Decimal(18, 5)), N'['' Leisure trip '', '' Couple '', '' Duplex Double Room '', '' Stayed 1 night '', '' Submitted from a mobile device '']', N'547 day', CAST(52.3610000 AS Decimal(18, 7)), CAST(4.9160000 AS Decimal(18, 7)))
GO
INSERT [dbo].[hotel_reviews] ([hotel_address], [additional_number_of_scoring], [review_date], [average_score], [hotel_name], [reviewer_nationality], [negative_review], [review_total_negative_word_counts], [total_number_of_reviews], [positive_review], [review_total_positive_word_counts], [total_number_of_reviews_reviewer_has_given], [reviewer_score], [tags], [days_since_review], [lat], [lng]) VALUES (N's Gravesandestraat 55 Oost 1092 AA Amsterdam Netherlands', 194, CAST(N'2016-10-19T00:00:00.000' AS DateTime), CAST(7.70000 AS Decimal(18, 5)), N'Hotel Arena', N'United States of America', N'Hotel is currently under renovation so not looking very nice from outside', 14, 1403, N'nice location super helpful front desk staff', 9, 2, CAST(8.80000 AS Decimal(18, 5)), N'['' Business trip '', '' Solo traveler '', '' Large King Room '', '' Stayed 9 nights '']', N'288 day', CAST(52.3610000 AS Decimal(18, 7)), CAST(4.9160000 AS Decimal(18, 7)))
GO
INSERT [dbo].[hotel_reviews] ([hotel_address], [additional_number_of_scoring], [review_date], [average_score], [hotel_name], [reviewer_nationality], [negative_review], [review_total_negative_word_counts], [total_number_of_reviews], [positive_review], [review_total_positive_word_counts], [total_number_of_reviews_reviewer_has_given], [reviewer_score], [tags], [days_since_review], [lat], [lng]) VALUES (N's Gravesandestraat 55 Oost 1092 AA Amsterdam Netherlands', 194, CAST(N'2015-10-28T00:00:00.000' AS DateTime), CAST(7.70000 AS Decimal(18, 5)), N'Hotel Arena', N'Portugal', N'the room felt cramped the staff at breakfast was a little to busy to help out when asked', 20, 1403, N'the breakfast area is nice', 6, 1, CAST(5.40000 AS Decimal(18, 5)), N'['' Leisure trip '', '' Couple '', '' Duplex Double Room '', '' Stayed 2 nights '']', N'645 day', CAST(52.3610000 AS Decimal(18, 7)), CAST(4.9160000 AS Decimal(18, 7)))
GO
INSERT [dbo].[hotel_reviews] ([hotel_address], [additional_number_of_scoring], [review_date], [average_score], [hotel_name], [reviewer_nationality], [negative_review], [review_total_negative_word_counts], [total_number_of_reviews], [positive_review], [review_total_positive_word_counts], [total_number_of_reviews_reviewer_has_given], [reviewer_score], [tags], [days_since_review], [lat], [lng]) VALUES (N's Gravesandestraat 55 Oost 1092 AA Amsterdam Netherlands', 194, CAST(N'2016-12-11T00:00:00.000' AS DateTime), CAST(7.70000 AS Decimal(18, 5)), N'Hotel Arena', N'Ireland', N'Rooms were a little louder than we would have liked A lot of noise from people walking by and shutting doors', 23, 1403, N'Funky rooms well designed hotel friendly and helpful staff comfy bed', 13, 2, CAST(7.50000 AS Decimal(18, 5)), N'['' Leisure trip '', '' Couple '', '' Duplex Double Room '', '' Stayed 2 nights '', '' Submitted from a mobile device '']', N'235 day', CAST(52.3610000 AS Decimal(18, 7)), CAST(4.9160000 AS Decimal(18, 7)))
GO
INSERT [dbo].[hotel_reviews] ([hotel_address], [additional_number_of_scoring], [review_date], [average_score], [hotel_name], [reviewer_nationality], [negative_review], [review_total_negative_word_counts], [total_number_of_reviews], [positive_review], [review_total_positive_word_counts], [total_number_of_reviews_reviewer_has_given], [reviewer_score], [tags], [days_since_review], [lat], [lng]) VALUES (N's Gravesandestraat 55 Oost 1092 AA Amsterdam Netherlands', 194, CAST(N'2016-01-12T00:00:00.000' AS DateTime), CAST(7.70000 AS Decimal(18, 5)), N'Hotel Arena', N'United Kingdom', N'No Negative', 0, 1403, N'Fantastic staff that could not have been more helpful friendly and professional', 13, 1, CAST(9.60000 AS Decimal(18, 5)), N'['' Leisure trip '', '' Couple '', '' Large King Room '', '' Stayed 3 nights '', '' Submitted from a mobile device '']', N'569 day', CAST(52.3610000 AS Decimal(18, 7)), CAST(4.9160000 AS Decimal(18, 7)))
GO
INSERT [dbo].[hotel_reviews] ([hotel_address], [additional_number_of_scoring], [review_date], [average_score], [hotel_name], [reviewer_nationality], [negative_review], [review_total_negative_word_counts], [total_number_of_reviews], [positive_review], [review_total_positive_word_counts], [total_number_of_reviews_reviewer_has_given], [reviewer_score], [tags], [days_since_review], [lat], [lng]) VALUES (N'Vijzelstraat 4 Amsterdam City Center 1017 HK Amsterdam Netherlands', 589, CAST(N'2016-10-20T00:00:00.000' AS DateTime), CAST(7.00000 AS Decimal(18, 5)), N'NH Carlton Amsterdam', N'United Kingdom', N'Poor wi fi dirty bath', 6, 4231, N'Location is excellent', 4, 1, CAST(6.70000 AS Decimal(18, 5)), N'['' Leisure trip '', '' Couple '', '' Standard Double or Twin Room '', '' Stayed 2 nights '', '' Submitted from a mobile device '']', N'287 day', CAST(52.3660000 AS Decimal(18, 7)), CAST(4.8930000 AS Decimal(18, 7)))
GO
INSERT [dbo].[hotel_reviews] ([hotel_address], [additional_number_of_scoring], [review_date], [average_score], [hotel_name], [reviewer_nationality], [negative_review], [review_total_negative_word_counts], [total_number_of_reviews], [positive_review], [review_total_positive_word_counts], [total_number_of_reviews_reviewer_has_given], [reviewer_score], [tags], [days_since_review], [lat], [lng]) VALUES (N'Vijzelstraat 4 Amsterdam City Center 1017 HK Amsterdam Netherlands', 589, CAST(N'2017-05-30T00:00:00.000' AS DateTime), CAST(7.00000 AS Decimal(18, 5)), N'NH Carlton Amsterdam', N'United States of America', N'Room was dirty and over priced Not as described in pics Tub was Dirty hair from others on bed an bath Lack of pillows asked for addition pillows they could not proved any', 35, 4231, N'Location', 2, 2, CAST(3.80000 AS Decimal(18, 5)), N'['' Leisure trip '', '' Couple '', '' Standard Double or Twin Room '', '' Stayed 2 nights '', '' Submitted from a mobile device '']', N'65 days', CAST(52.3660000 AS Decimal(18, 7)), CAST(4.8930000 AS Decimal(18, 7)))
GO
INSERT [dbo].[hotel_reviews] ([hotel_address], [additional_number_of_scoring], [review_date], [average_score], [hotel_name], [reviewer_nationality], [negative_review], [review_total_negative_word_counts], [total_number_of_reviews], [positive_review], [review_total_positive_word_counts], [total_number_of_reviews_reviewer_has_given], [reviewer_score], [tags], [days_since_review], [lat], [lng]) VALUES (N'Staalmeesterslaan 410 Slotervaart 1057 PH Amsterdam Netherlands', 926, CAST(N'2017-03-20T00:00:00.000' AS DateTime), CAST(8.20000 AS Decimal(18, 5)), N'Ramada Apollo Amsterdam Centre', N'United States of America', N'Bathroom in the lobby was very dirty That is the only negative thing I have to say about this hotel We were VERY pleased with the overall stay and will be returning for sure', 36, 5770, N'Comfortable bed lovely facilities and amazing staff', 9, 4, CAST(8.80000 AS Decimal(18, 5)), N'['' Leisure trip '', '' Couple '', '' Standard Queen Room '', '' Stayed 2 nights '']', N'136 day', CAST(52.3680000 AS Decimal(18, 7)), CAST(4.8440000 AS Decimal(18, 7)))
GO
INSERT [dbo].[hotel_reviews] ([hotel_address], [additional_number_of_scoring], [review_date], [average_score], [hotel_name], [reviewer_nationality], [negative_review], [review_total_negative_word_counts], [total_number_of_reviews], [positive_review], [review_total_positive_word_counts], [total_number_of_reviews_reviewer_has_given], [reviewer_score], [tags], [days_since_review], [lat], [lng]) VALUES (N'Prins Hendrikkade 59 72 Amsterdam City Center 1012 AD Amsterdam Netherlands', 493, CAST(N'2016-07-13T00:00:00.000' AS DateTime), CAST(8.60000 AS Decimal(18, 5)), N'NH Collection Amsterdam Barbizon Palace', N'United Kingdom', N'Expensive parking no help on getting luggage in from car porter at reception just ignored you and just looked down and would not make eye contact Bedroom was not cleaned properly dirty cups left for more than two days also soap not changed and just put back in its carbord box wet so it stuck to it and could not be used', 63, 2865, N'Central location', 3, 7, CAST(3.80000 AS Decimal(18, 5)), N'['' Leisure trip '', '' Couple '', '' Superior Double or Twin Room '', '' Stayed 2 nights '', '' Submitted from a mobile device '']', N'386 day', CAST(52.3760000 AS Decimal(18, 7)), CAST(4.9000000 AS Decimal(18, 7)))
GO
INSERT [dbo].[hotel_reviews] ([hotel_address], [additional_number_of_scoring], [review_date], [average_score], [hotel_name], [reviewer_nationality], [negative_review], [review_total_negative_word_counts], [total_number_of_reviews], [positive_review], [review_total_positive_word_counts], [total_number_of_reviews_reviewer_has_given], [reviewer_score], [tags], [days_since_review], [lat], [lng]) VALUES (N's Gravesandestraat 55 Oost 1092 AA Amsterdam Netherlands', 194, CAST(N'2016-03-16T00:00:00.000' AS DateTime), CAST(7.70000 AS Decimal(18, 5)), N'Hotel Arena', N'United States of America', N'The cleanness was quite poor A lot of dust under the bed under the furniture on top of the bed side lamps the remote control and even the plastic glasses in the bathroom were dirty Also something went wrong with the pipes of the shower a horrible smell came out at night', 54, 1403, N'The staff was very nice and friendly the size of the room was really great and the style of the hotel is also very nice The bed was quite confortable', 32, 4, CAST(5.80000 AS Decimal(18, 5)), N'['' Business trip '', '' Solo traveler '', '' Duplex Double Room '', '' Stayed 5 nights '']', N'505 day', CAST(52.3610000 AS Decimal(18, 7)), CAST(4.9160000 AS Decimal(18, 7)))
GO
INSERT [dbo].[hotel_reviews] ([hotel_address], [additional_number_of_scoring], [review_date], [average_score], [hotel_name], [reviewer_nationality], [negative_review], [review_total_negative_word_counts], [total_number_of_reviews], [positive_review], [review_total_positive_word_counts], [total_number_of_reviews_reviewer_has_given], [reviewer_score], [tags], [days_since_review], [lat], [lng]) VALUES (N'Spaarndammerdijk 304 Westerpark 1013 ZX Amsterdam Netherlands', 252, CAST(N'2016-03-15T00:00:00.000' AS DateTime), CAST(8.50000 AS Decimal(18, 5)), N'WestCord Art Hotel Amsterdam 4 stars', N'Ireland', N'There was a big dip in the bed which made sleep very difficult The carpet was also a little dirty looking in the room', 26, 1712, N'It was quiet and the food in the bar was good The staff were lovely too', 18, 1, CAST(7.50000 AS Decimal(18, 5)), N'['' Leisure trip '', '' Couple '', '' Large Double Room '', '' Stayed 4 nights '']', N'506 day', CAST(52.3920000 AS Decimal(18, 7)), CAST(4.8680000 AS Decimal(18, 7)))
GO
INSERT [dbo].[hotel_reviews] ([hotel_address], [additional_number_of_scoring], [review_date], [average_score], [hotel_name], [reviewer_nationality], [negative_review], [review_total_negative_word_counts], [total_number_of_reviews], [positive_review], [review_total_positive_word_counts], [total_number_of_reviews_reviewer_has_given], [reviewer_score], [tags], [days_since_review], [lat], [lng]) VALUES (N'Professor Tulpplein 1 Amsterdam City Center 1018 GX Amsterdam Netherlands', 29, CAST(N'2016-10-16T00:00:00.000' AS DateTime), CAST(9.00000 AS Decimal(18, 5)), N'InterContinental Amstel Amsterdam', N'Greece', N'The carpet in the room was dirty', 8, 151, N'Very good location breakfast very good coctail bar super matress and pillows', 13, 1, CAST(8.30000 AS Decimal(18, 5)), N'['' Leisure trip '', '' Couple '', '' Executive King Room with City View '', '' Stayed 4 nights '', '' Submitted from a mobile device '']', N'291 day', CAST(52.3600000 AS Decimal(18, 7)), CAST(4.9050000 AS Decimal(18, 7)))
GO
INSERT [dbo].[hotel_reviews] ([hotel_address], [additional_number_of_scoring], [review_date], [average_score], [hotel_name], [reviewer_nationality], [negative_review], [review_total_negative_word_counts], [total_number_of_reviews], [positive_review], [review_total_positive_word_counts], [total_number_of_reviews_reviewer_has_given], [reviewer_score], [tags], [days_since_review], [lat], [lng]) VALUES (N'Stadhouderskade 7 Oud West 1054 ES Amsterdam Netherlands', 241, CAST(N'2016-11-01T00:00:00.000' AS DateTime), CAST(7.70000 AS Decimal(18, 5)), N'NH Amsterdam Centre', N'United Kingdom', N'About 2 months before I traveled I asked for early check in late check out a nice room as it was a special occasion I got none of the above My room was dirty small not that was shown online pictures Had to wait to check in also had to check out at usual time We got told the hotel was fully booked although when we went online it wouldn t let us book for a extra night Overall I was extremely disappointed with my stay I would aprieate it if you could contact me back to explain why this happened', 102, 1574, N'Nothing much atal', 4, 1, CAST(3.30000 AS Decimal(18, 5)), N'['' Leisure trip '', '' Couple '', '' Standard Double or Twin Room '', '' Stayed 2 nights '', '' Submitted from a mobile device '']', N'275 day', CAST(52.3630000 AS Decimal(18, 7)), CAST(4.8790000 AS Decimal(18, 7)))
GO
INSERT [dbo].[hotel_reviews] ([hotel_address], [additional_number_of_scoring], [review_date], [average_score], [hotel_name], [reviewer_nationality], [negative_review], [review_total_negative_word_counts], [total_number_of_reviews], [positive_review], [review_total_positive_word_counts], [total_number_of_reviews_reviewer_has_given], [reviewer_score], [tags], [days_since_review], [lat], [lng]) VALUES (N'Wibautstraat 129 Oost 1091 GL Amsterdam Netherlands', 975, CAST(N'2016-08-02T00:00:00.000' AS DateTime), CAST(8.70000 AS Decimal(18, 5)), N'The Student Hotel Amsterdam City', N'South Africa', N'My room was not cleaned and was left with dirty towels to reuse', 14, 7656, N'Location', 2, 19, CAST(7.50000 AS Decimal(18, 5)), N'['' Leisure trip '', '' Couple '', '' Double Room '', '' Stayed 2 nights '', '' Submitted from a mobile device '']', N'366 day', CAST(52.3550000 AS Decimal(18, 7)), CAST(4.9130000 AS Decimal(18, 7)))
GO
INSERT [dbo].[hotel_reviews] ([hotel_address], [additional_number_of_scoring], [review_date], [average_score], [hotel_name], [reviewer_nationality], [negative_review], [review_total_negative_word_counts], [total_number_of_reviews], [positive_review], [review_total_positive_word_counts], [total_number_of_reviews_reviewer_has_given], [reviewer_score], [tags], [days_since_review], [lat], [lng]) VALUES (N'Staalmeesterslaan 410 Slotervaart 1057 PH Amsterdam Netherlands', 926, CAST(N'2016-12-31T00:00:00.000' AS DateTime), CAST(8.20000 AS Decimal(18, 5)), N'Ramada Apollo Amsterdam Centre', N'Romania', N'Sorry but the room was not clean I travel a lot every month but i never seen so dirty bathroom in a hotel Room was extremly small Matress and pilows not comfy There not even a little window to open in room for fresh air Dust was everywhere', 50, 5770, N'Breakfast hotel location', 5, 31, CAST(5.40000 AS Decimal(18, 5)), N'['' Leisure trip '', '' Couple '', '' Standard Double Room '', '' Stayed 3 nights '', '' Submitted from a mobile device '']', N'215 day', CAST(52.3680000 AS Decimal(18, 7)), CAST(4.8440000 AS Decimal(18, 7)))
GO
INSERT [dbo].[hotel_reviews] ([hotel_address], [additional_number_of_scoring], [review_date], [average_score], [hotel_name], [reviewer_nationality], [negative_review], [review_total_negative_word_counts], [total_number_of_reviews], [positive_review], [review_total_positive_word_counts], [total_number_of_reviews_reviewer_has_given], [reviewer_score], [tags], [days_since_review], [lat], [lng]) VALUES (N'Roemer Visscherstraat 8 10 Oud West 1054 EV Amsterdam Netherlands', 119, CAST(N'2017-01-16T00:00:00.000' AS DateTime), CAST(8.30000 AS Decimal(18, 5)), N'Hotel Roemer Amsterdam', N'Canada', N'The room was quite dirty The fridge looked like it has never been cleaned before The bathtub had hair in it from the previous guests The walls were very dirty The hotel shampoo was in a big container with almost nothing in it We were surprised how dirty the room felt for being a 4 star hotel', 59, 974, N'Bed was comfy', 5, 1, CAST(5.40000 AS Decimal(18, 5)), N'['' Couple '', '' Executive Twin Room with Whirlpool '', '' Stayed 2 nights '', '' Submitted from a mobile device '']', N'199 day', CAST(52.3620000 AS Decimal(18, 7)), CAST(4.8780000 AS Decimal(18, 7)))
GO
INSERT [dbo].[hotel_reviews] ([hotel_address], [additional_number_of_scoring], [review_date], [average_score], [hotel_name], [reviewer_nationality], [negative_review], [review_total_negative_word_counts], [total_number_of_reviews], [positive_review], [review_total_positive_word_counts], [total_number_of_reviews_reviewer_has_given], [reviewer_score], [tags], [days_since_review], [lat], [lng]) VALUES (N'Prins Hendrikkade 108 Amsterdam City Center 1011 AK Amsterdam Netherlands', 207, CAST(N'2016-03-17T00:00:00.000' AS DateTime), CAST(8.30000 AS Decimal(18, 5)), N'Grand Hotel Amr th Amsterdam', N'Israel', N'Windows were dirty Windows couldn t be opened and heating could not be controlled so the room was sometimes stiflingly hot television reception was dismal', 27, 1530, N'The decor was amazingly beautiful The minibar was free and constantly restocked', 14, 1, CAST(9.60000 AS Decimal(18, 5)), N'['' Business trip '', '' Couple '', '' Deluxe Room '', '' Stayed 5 nights '']', N'504 day', CAST(52.3740000 AS Decimal(18, 7)), CAST(4.9040000 AS Decimal(18, 7)))
GO