Skip to content

hotel_stays

The room booked for each resort hotel trip. One row is one room stay.

One row is
one room stay
Columns
9
Rows in Sample
10,235
Rows in Standard
101,555
Rows in Full
1,015,512

Columns

ColumnTypeWhat it holdsValues or range
stay_idkeyintegerUnique id for the row.
booking_idintegerThe trip this row belongs to. Links to bookings.
hotel_idintegerLinks to hotels.
room_type_idintegerLinks to room_types.
check_in_datedateFirst night.2017-12-20 to 2025-12-31
check_out_datedateMorning of departure.2018-01-01 to 2026-01-12
nightsintegerNights stayed.1 to 14
nightly_ratedecimalAverage rate per night in dollars.101.6 to 3,050.88
room_revenuedecimalTotal room charge in dollars.106.29 to 35,370.58

How it connects

First five rows

Taken from the Sample size, exactly as they appear in the file. Empty cells are empty in the data.

stay_idbooking_idhotel_idroom_type_idcheck_in_datecheck_out_datenightsnightly_rateroom_revenue
700016050001651112017-12-312018-01-088161.591292.72
700025550002651112017-12-312018-01-055161.34806.7
700025650002651112017-12-312018-01-055161.34806.7
700035050003653312017-12-312018-01-066387.372324.22
700047750005054432017-12-302018-01-0121656.83313.6

Download from Kaggle