Expedia Travel Dataset

Expedia booking information

@kaggle.jacopoferretti_expedia_travel_dataset

Table List

1 table(4.44 MB)

Travel

@kaggle.jacopoferretti_expedia_travel_dataset.travel

4.44 MB
100000 rows
25 columns

unnamed_0 Unnamed: 0	date_time Date Time	site_name Site Name	posa_continent Posa Continent	user_location_country User Location Country	user_location_region User Location Region	user_location_city User Location City	orig_destination_distance Orig Destination Distance	user_id User Id	is_package Is Package	channel Channel	srch_ci Srch Ci	srch_co Srch Co	srch_adults_cnt Srch Adults Cnt	srch_children_cnt Srch Children Cnt	srch_rm_cnt Srch Rm Cnt	srch_destination_id Srch Destination Id	srch_destination_type_id Srch Destination Type Id	is_booking Is Booking	cnt Cnt	hotel_continent Hotel Continent	hotel_country Hotel Country	hotel_market Hotel Market	hotel_cluster Hotel Cluster
24636210	Mon Nov 03 2014 16:02:28 GMT+0000 (Coordinated Universal Time)	24	2	77	871	36643	456.1151	792280	1	1	Mon Dec 15 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Dec 19 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	2		1	8286	1		1		63	1258	68
19837144	Wed Mar 13 2013 19:25:01 GMT+0000 (Coordinated Universal Time)	11	3	205	135	38749	232.4737	961995		9	Wed Mar 13 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Mar 14 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	2		1	1842	3		1	2	198	786	37
13066459	Mon Oct 13 2014 13:20:25 GMT+0000 (Coordinated Universal Time)	2	3	66	314	48562	4468.272	495669	1	9	Fri Apr 03 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Apr 10 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	2		1	8746	1		1	6	105	29	22
4691082	Tue Nov 05 2013 10:40:34 GMT+0000 (Coordinated Universal Time)	11	3	205	411	52752	171.6021	106611			Thu Nov 07 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Nov 08 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	2		1	6210	3	1	1	2	198	1234	42
4878884	Tue Jun 10 2014 13:34:56 GMT+0000 (Coordinated Universal Time)	2	3	66	174	50644		596177		9	Sun Aug 03 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Aug 08 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	2	1	1	12812	5		1	2	50	368	83
34825186	Tue Dec 16 2014 14:34:39 GMT+0000 (Coordinated Universal Time)	2	3	66	220	38273	53.7481	260938		9	Tue Dec 16 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Dec 17 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	2		1	3448	3		1	2	50	582	54
24023139	Tue Jan 28 2014 13:16:36 GMT+0000 (Coordinated Universal Time)	2	3	66	337	54287	329.1833	908558		2	Thu Feb 27 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Sat Mar 01 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	2		1	8287	1	1	1	2	198	400	6
8184643	Thu Feb 27 2014 08:29:19 GMT+0000 (Coordinated Universal Time)	24	2	3	38	4999		1161104	1		Wed Jul 16 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Jul 20 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	1		1	8856	1		1	2	50	636
19270014	Mon Dec 15 2014 10:44:33 GMT+0000 (Coordinated Universal Time)	2	3	133	20	41185		560103		1	Wed Dec 17 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Dec 18 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	2		1	8226	1		1	5	100	1446	46
3997603	Sat Nov 16 2013 23:40:35 GMT+0000 (Coordinated Universal Time)	2	3	66	189	17017	2284.9105	748046		1	Fri Jan 10 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Jan 12 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	2	1	1	12206	6		1	2	50	628	1


CREATE TABLE travel (
  "unnamed_0" BIGINT,
  "date_time" TIMESTAMP,
  "site_name" BIGINT,
  "posa_continent" BIGINT,
  "user_location_country" BIGINT,
  "user_location_region" BIGINT,
  "user_location_city" BIGINT,
  "orig_destination_distance" DOUBLE,
  "user_id" BIGINT,
  "is_mobile" BIGINT,
  "is_package" BIGINT,
  "channel" BIGINT,
  "srch_ci" TIMESTAMP,
  "srch_co" TIMESTAMP,
  "srch_adults_cnt" BIGINT,
  "srch_children_cnt" BIGINT,
  "srch_rm_cnt" BIGINT,
  "srch_destination_id" BIGINT,
  "srch_destination_type_id" BIGINT,
  "is_booking" BIGINT,
  "cnt" BIGINT,
  "hotel_continent" BIGINT,
  "hotel_country" BIGINT,
  "hotel_market" BIGINT,
  "hotel_cluster" BIGINT
);