Travel Dataset - Datathon 2019

A synthetic dataset of corporate travels

@kaggle.leomauro_argodatathon2019

Table List

3 tables(2.72 MB)

Flights

Hotels

Users

Hotels

@kaggle.leomauro_argodatathon2019.hotels

395.41 KB
40552 rows
8 columns

travelcode TravelCode	name Name	place Place	days Days	price Price	total Total	date Date
	Hotel A	Florianopolis (SC)	4	313.02	1252.08	Thu Sep 26 2019 00:00:00 GMT+0000 (Coordinated Universal Time)
2	Hotel K	Salvador (BH)	2	263.41	526.82	Thu Oct 10 2019 00:00:00 GMT+0000 (Coordinated Universal Time)
7	Hotel K	Salvador (BH)	3	263.41	790.23	Thu Nov 14 2019 00:00:00 GMT+0000 (Coordinated Universal Time)
11	Hotel K	Salvador (BH)	4	263.41	1053.64	Thu Dec 12 2019 00:00:00 GMT+0000 (Coordinated Universal Time)
13	Hotel A	Florianopolis (SC)	1	313.02	313.02	Thu Dec 26 2019 00:00:00 GMT+0000 (Coordinated Universal Time)
15	Hotel BD	Natal (RN)	2	242.88	485.76	Thu Jan 09 2020 00:00:00 GMT+0000 (Coordinated Universal Time)
22	Hotel Z	Aracaju (SE)	2	208.04	416.08	Thu Feb 27 2020 00:00:00 GMT+0000 (Coordinated Universal Time)
29	Hotel AU	Recife (PE)	4	312.83	1251.32	Thu Apr 16 2020 00:00:00 GMT+0000 (Coordinated Universal Time)
32	Hotel AF	Sao Paulo (SP)	2	139.1	278.2	Thu May 07 2020 00:00:00 GMT+0000 (Coordinated Universal Time)
33	Hotel K	Salvador (BH)	4	263.41	1053.64	Thu May 14 2020 00:00:00 GMT+0000 (Coordinated Universal Time)


CREATE TABLE hotels (
  "travelcode" BIGINT,
  "usercode" BIGINT,
  "name" VARCHAR,
  "place" VARCHAR,
  "days" BIGINT,
  "price" DOUBLE,
  "total" DOUBLE,
  "date" TIMESTAMP
);