Extract Booking.com hotel reviews, ratings, stars, and reviewer details from hotel URLs
Here's a sample run for The Plaza Hotel on Booking.com, collecting 10 reviews, showing the exact schema and results you can expect.
| # | Hotel URL | Review Title | Liked | Disliked | Rating | Reviewer | Reviewer Location | Reviewer Avatar | Traveler Type | Nights | Room | Check-In | Check-Out | Posted | Language | Helpful Votes | Hotel Rating | Hotel Rating Label | Hotel Reviews | Top Subscore Category | Top Subscore | Subscore Code | Total Category Reviews | Score Filter | Page | Images | Hotel ID | Stay Room ID | Review ID |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Expereience worth for it | Great location. Very authentic and elegantly decorated ambiance. Kind and helpful service. | A bit expensive but worth for experience | 10 | Muhammet | Turkey | Couple | 1 | Plaza Room | 2026-04-24 | 2026-04-25 | 2026-04-29T15:18:40.000Z | en | 0 | 8.5 | Very good | 556 | Staff | 8.592 | hotel_staff | 556 | ALL | 1 | — | 58,958 | 5,895,801 | 95df545d99fa26b0 | ||
2 | An outrageous price attached to a poor quality hotel | Location | Very unfriendly staff - the staff at the counter were unhelpful and made multiple mistakes while checking in. The room service staff repeatedly forgot to provide key amenities like water and robes, meaning we had to keep calling to ask for these to be delivered, presumably because they were angling for tips. One man even asked us for a tip immediately after we had already tipped 25%. Cleanliness was extraordinarily disappointing with large stains on the bedding and even black mould in our room.
The price is utterly outrageous for how poor the quality is, and I say this as someone who has stayed at five stay hotels in countries across the world. | 3 | Dani | United Kingdom | Couple | 5 | Plaza Room | 2026-03-14 | 2026-03-19 | 2026-04-07T17:13:34.000Z | en | 1 | 8.5 | Very good | 556 | Staff | 8.592 | hotel_staff | 556 | ALL | 1 | — | 58,958 | 5,895,801 | 20f827bfbeba6cef | ||
3 | Exceptional | Staff were super kind and attentive | Location | 10 | Wayne | United Kingdom | Family | 4 | Plaza Room | 2026-02-20 | 2026-02-24 | 2026-03-23T14:26:41.000Z | en | 0 | 8.5 | Very good | 556 | Staff | 8.592 | hotel_staff | 556 | ALL | 1 | — | 58,958 | 5,895,801 | 10ed1a3647f39834 | ||
4 | Exceptional | The smell | — | 10 | Diana | United States | Couple | 3 | Deluxe King Room | 2026-03-12 | 2026-03-15 | 2026-03-16T01:54:44.000Z | xu | 1 | 8.5 | Very good | 556 | Staff | 8.592 | hotel_staff | 556 | ALL | 1 | — | 58,958 | 5,895,802 | edb0bb6d0596a78c | ||
5 | Exceptional | The best hotel in NY | — | 10 | Valeriia | United States | Couple | 2 | Edwardian Suite | 2026-02-15 | 2026-02-17 | 2026-02-21T15:34:28.000Z | en | 1 | 8.5 | Very good | 556 | Staff | 8.592 | hotel_staff | 556 | ALL | 1 | — | 58,958 | 5,895,804 | bb9af80adc5a031e | ||
6 | A must while in New York | I have wanted to stay at the renowned PLAZA HOTEL since forever and I was able to celebrate my birthday there
The property is exquisite the accommodations nothing short of spectacular! They made my birthday incredibly special leaving a beautifully made cake and birthday bear with the signature plaza robe, balloons and a personalized card. So incredibly thoughtful and kind.
We stayed 2 nights. The rooms are just gorgeous
The palms court restaurant and champagne bar restaurant were divine! Wide range of champagne and cocktails and delicious food. This is one of the most sought after stays and it speaks for itself as to why it keeps its reputation
Absolutely a girls dream come true! | Nothing it was spectacular | 10 | Shannon | United States | Solo traveler | 2 | Plaza Room | 2026-01-16 | 2026-01-18 | 2026-02-14T15:36:34.000Z | xu | 3 | 8.5 | Very good | 556 | Staff | 8.592 | hotel_staff | 556 | ALL | 1 | https://q-xx.bstatic.com/xdata/images/xphoto/max1280x900/642520965.jpg?k=2669fa76648c0fb6c3029c6d69d5c0cb45b56cc59ead823f97db20d4dba0fdef&o=, https://r-xx.bstatic.com/xdata/images/xphoto/max1280x900/642520966.jpg?k=0f541515e986a6acd069f9382625731554d50deab24eb469662e83e7a1d92e6b&o=, https://r-xx.bstatic.com/xdata/images/xphoto/max1280x900/642520967.jpg?k=db149836290179d2a8716f1b5075f6bf1c4aba7b23306ec759ebdbdea6da0169&o=, https://q-xx.bstatic.com/xdata/images/xphoto/max1280x900/642520982.jpg?k=713af293d7676637b70dab43382668635fad10b691ffcc34e02bf624f77a3005&o= | 58,958 | 5,895,801 | d2840852ddf64ad1 | ||
7 | Wonderful stay at the Plaza as a surprise treat for my husband, staff left treats as we were celebrating our honeymoon a | The room was gorgeous, especially the large bathroom. | — | 10 | Brogan | United Kingdom | Couple | 1 | Deluxe King Room | 2026-02-09 | 2026-02-10 | 2026-02-13T00:16:49.000Z | en | 2 | 8.5 | Very good | 556 | Staff | 8.592 | hotel_staff | 556 | ALL | 1 | — | 58,958 | 5,895,802 | 52f939d4d4778647 | ||
8 | Beautiful stay in iconic hotel | Luxurious facilities and attentive staff | — | 9 | Kate | France | Solo traveler | 2 | Plaza Room | 2026-01-09 | 2026-01-11 | 2026-02-07T14:13:09.000Z | en | 0 | 8.5 | Very good | 556 | Staff | 8.592 | hotel_staff | 556 | ALL | 1 | — | 58,958 | 5,895,801 | 98ed1aacd33315ad | ||
9 | Great location with nice sized rooms, but value is questionable | Location, cleanliness and staff | No room to sit on the main floor. Breakfast should be in The Palm Court, not the lobby!
Room had issues on check in that were resolved; drapes, light bulbs, bedding | 8 | Robert | United States | Couple | 3 | Plaza Room | 2026-01-22 | 2026-01-25 | 2026-01-30T04:07:06.000Z | xu | 2 | 8.5 | Very good | 556 | Staff | 8.592 | hotel_staff | 556 | ALL | 1 | — | 58,958 | 5,895,801 | 7065e9df8879006a | ||
10 | Great location, pretty good experience… but at a steep cost :) | The location is pretty much unbeatable in NYC. Everyone I interacted with was very helpful and provided good customer service. It’s a landmark of New York City and my wife always wanted to experience staying there. | There didn’t seem to be enough staff at the hotel’s entrance so we had to wait a few minutes for someone to take our luggage in and show us to the reception. In general the bedroom was well cleaned everywhere you could see, but for instance there was a shelve with candy/nuts/etc in one of the closets, it was clear those hadn’t been touched for ages just because of the dust (hard to see for someone shorter than 6’). For the price, which is quite high, you’d expect those sharp edges to be fixed. | 9 | Bruno | United States | Couple | 1 | Deluxe King Room | 2026-01-23 | 2026-01-24 | 2026-01-25T03:57:37.000Z | xu | 2 | 8.5 | Very good | 556 | Staff | 8.592 | hotel_staff | 556 | ALL | 1 | — | 58,958 | 5,895,802 | 85ab556553c20268 |