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
| Column | Type | What it holds | Values or range |
|---|---|---|---|
| stay_idkey | integer | Unique id for the row. | |
| booking_id | integer | The trip this row belongs to. Links to bookings. | |
| hotel_id | integer | Links to hotels. | |
| room_type_id | integer | Links to room_types. | |
| check_in_date | date | First night. | 2017-12-20 to 2025-12-31 |
| check_out_date | date | Morning of departure. | 2018-01-01 to 2026-01-12 |
| nights | integer | Nights stayed. | 1 to 14 |
| nightly_rate | decimal | Average rate per night in dollars. | 101.6 to 3,050.88 |
| room_revenue | decimal | Total room charge in dollars. | 106.29 to 35,370.58 |
How it connects
This table points to
- booking_id matches bookings.booking_id
- hotel_id matches hotels.hotel_id
- room_type_id matches room_types.room_type_id
First five rows
Taken from the Sample size, exactly as they appear in the file. Empty cells are empty in the data.
| stay_id | booking_id | hotel_id | room_type_id | check_in_date | check_out_date | nights | nightly_rate | room_revenue |
|---|---|---|---|---|---|---|---|---|
| 7000160 | 5000165 | 1 | 11 | 2017-12-31 | 2018-01-08 | 8 | 161.59 | 1292.72 |
| 7000255 | 5000265 | 1 | 11 | 2017-12-31 | 2018-01-05 | 5 | 161.34 | 806.7 |
| 7000256 | 5000265 | 1 | 11 | 2017-12-31 | 2018-01-05 | 5 | 161.34 | 806.7 |
| 7000350 | 5000365 | 3 | 31 | 2017-12-31 | 2018-01-06 | 6 | 387.37 | 2324.22 |
| 7000477 | 5000505 | 4 | 43 | 2017-12-30 | 2018-01-01 | 2 | 1656.8 | 3313.6 |