Travel Dataset - Datathon 2019

A synthetic dataset of corporate travels

@kaggle.leomauro_argodatathon2019

Table List

3 tables(2.72 MB)

Flights

Hotels

Users

Flights

@kaggle.leomauro_argodatathon2019.flights

2.31 MB
271888 rows
10 columns

travelcode TravelCode	from From	to To	flighttype FlightType	price Price	time Time	distance Distance	agency Agency	date Date
	Recife (PE)	Florianopolis (SC)	firstClass	1434.38	1.76	676.53	FlyingDrops	Thu Sep 26 2019 00:00:00 GMT+0000 (Coordinated Universal Time)
	Florianopolis (SC)	Recife (PE)	firstClass	1292.29	1.76	676.53	FlyingDrops	Mon Sep 30 2019 00:00:00 GMT+0000 (Coordinated Universal Time)
1	Brasilia (DF)	Florianopolis (SC)	firstClass	1487.52	1.66	637.56	CloudFy	Thu Oct 03 2019 00:00:00 GMT+0000 (Coordinated Universal Time)
1	Florianopolis (SC)	Brasilia (DF)	firstClass	1127.36	1.66	637.56	CloudFy	Fri Oct 04 2019 00:00:00 GMT+0000 (Coordinated Universal Time)
2	Aracaju (SE)	Salvador (BH)	firstClass	1684.05	2.16	830.86	CloudFy	Thu Oct 10 2019 00:00:00 GMT+0000 (Coordinated Universal Time)
2	Salvador (BH)	Aracaju (SE)	firstClass	1531.92	2.16	830.86	CloudFy	Sat Oct 12 2019 00:00:00 GMT+0000 (Coordinated Universal Time)
3	Aracaju (SE)	Campo Grande (MS)	economic	743.54	1.69	650.1	Rainbow	Thu Oct 17 2019 00:00:00 GMT+0000 (Coordinated Universal Time)
3	Campo Grande (MS)	Aracaju (SE)	economic	877.56	1.69	650.1	Rainbow	Sun Oct 20 2019 00:00:00 GMT+0000 (Coordinated Universal Time)
4	Recife (PE)	Florianopolis (SC)	economic	803.39	1.76	676.53	Rainbow	Thu Oct 24 2019 00:00:00 GMT+0000 (Coordinated Universal Time)
4	Florianopolis (SC)	Recife (PE)	economic	695.3	1.76	676.53	Rainbow	Sat Oct 26 2019 00:00:00 GMT+0000 (Coordinated Universal Time)


CREATE TABLE flights (
  "travelcode" BIGINT,
  "usercode" BIGINT,
  "from" VARCHAR,
  "to" VARCHAR,
  "flighttype" VARCHAR,
  "price" DOUBLE,
  "time" DOUBLE,
  "distance" DOUBLE,
  "agency" VARCHAR,
  "date" TIMESTAMP
);