Hotel Bookings Demand

The information in this dataset is collected from tourists and guests.

@kaggle.qucwang_hotel_bookings_analysis_dataset

Table List

1 table(1.13 MB)

Hotel Bookings

@kaggle.qucwang_hotel_bookings_analysis_dataset.hotel_bookings

1.13 MB
119390 rows
32 columns

hotel Hotel	is_canceled Is Canceled	lead_time Lead Time	arrival_date_year Arrival Date Year	arrival_date_month Arrival Date Month	arrival_date_week_number Arrival Date Week Number	arrival_date_day_of_month Arrival Date Day Of Month	stays_in_week_nights Stays In Week Nights	adults Adults	meal Meal	country Country	market_segment Market Segment	distribution_channel Distribution Channel	reserved_room_type Reserved Room Type	assigned_room_type Assigned Room Type	booking_changes Booking Changes	deposit_type Deposit Type	agent Agent	customer_type Customer Type	adr Adr	total_of_special_requests Total Of Special Requests	reservation_status Reservation Status	reservation_status_date Reservation Status Date
Resort Hotel		342	2015	July	27	1		2	BB	PRT	Direct	Direct	C	C	3	No Deposit		Transient			Check-Out	Wed Jul 01 2015 00:00:00 GMT+0000 (Coordinated Universal Time)
Resort Hotel		737	2015	July	27	1		2	BB	PRT	Direct	Direct	C	C	4	No Deposit		Transient			Check-Out	Wed Jul 01 2015 00:00:00 GMT+0000 (Coordinated Universal Time)
Resort Hotel		7	2015	July	27	1	1	1	BB	GBR	Direct	Direct	A	C		No Deposit		Transient	75		Check-Out	Thu Jul 02 2015 00:00:00 GMT+0000 (Coordinated Universal Time)
Resort Hotel		13	2015	July	27	1	1	1	BB	GBR	Corporate	Corporate	A	A		No Deposit	304	Transient	75		Check-Out	Thu Jul 02 2015 00:00:00 GMT+0000 (Coordinated Universal Time)
Resort Hotel		14	2015	July	27	1	2	2	BB	GBR	Online TA	TA/TO	A	A		No Deposit	240	Transient	98	1	Check-Out	Fri Jul 03 2015 00:00:00 GMT+0000 (Coordinated Universal Time)
Resort Hotel		14	2015	July	27	1	2	2	BB	GBR	Online TA	TA/TO	A	A		No Deposit	240	Transient	98	1	Check-Out	Fri Jul 03 2015 00:00:00 GMT+0000 (Coordinated Universal Time)
Resort Hotel			2015	July	27	1	2	2	BB	PRT	Direct	Direct	C	C		No Deposit		Transient	107		Check-Out	Fri Jul 03 2015 00:00:00 GMT+0000 (Coordinated Universal Time)
Resort Hotel		9	2015	July	27	1	2	2	FB	PRT	Direct	Direct	C	C		No Deposit	303	Transient	103	1	Check-Out	Fri Jul 03 2015 00:00:00 GMT+0000 (Coordinated Universal Time)
Resort Hotel	1	85	2015	July	27	1	3	2	BB	PRT	Online TA	TA/TO	A	A		No Deposit	240	Transient	82	1	Canceled	Wed May 06 2015 00:00:00 GMT+0000 (Coordinated Universal Time)
Resort Hotel	1	75	2015	July	27	1	3	2	HB	PRT	Offline TA/TO	TA/TO	D	D		No Deposit	15	Transient	105.5		Canceled	Wed Apr 22 2015 00:00:00 GMT+0000 (Coordinated Universal Time)


CREATE TABLE hotel_bookings (
  "hotel" VARCHAR,
  "is_canceled" BIGINT,
  "lead_time" BIGINT,
  "arrival_date_year" BIGINT,
  "arrival_date_month" VARCHAR,
  "arrival_date_week_number" BIGINT,
  "arrival_date_day_of_month" BIGINT,
  "stays_in_weekend_nights" BIGINT,
  "stays_in_week_nights" BIGINT,
  "adults" BIGINT,
  "children" DOUBLE,
  "babies" BIGINT,
  "meal" VARCHAR,
  "country" VARCHAR,
  "market_segment" VARCHAR,
  "distribution_channel" VARCHAR,
  "is_repeated_guest" BIGINT,
  "previous_cancellations" BIGINT,
  "previous_bookings_not_canceled" BIGINT,
  "reserved_room_type" VARCHAR,
  "assigned_room_type" VARCHAR,
  "booking_changes" BIGINT,
  "deposit_type" VARCHAR,
  "agent" DOUBLE,
  "company" DOUBLE,
  "days_in_waiting_list" BIGINT,
  "customer_type" VARCHAR,
  "adr" DOUBLE,
  "required_car_parking_spaces" BIGINT,
  "total_of_special_requests" BIGINT,
  "reservation_status" VARCHAR,
  "reservation_status_date" TIMESTAMP
);