Flight Analytics Dataset

"Unveiling Insights into Air Travel Trends and Customer Behavior"

@kaggle.goyaladi_flight_dataset

Table List

1 table(22.15 KB)

Flight Data

@kaggle.goyaladi_flight_dataset.flight_data

22.15 KB
100 rows
18 columns

departure_city Departure City	arrival_city Arrival City	departure_date Departure Date	flight_duration Flight Duration	delay_minutes Delay Minutes	customer_id Customer ID	name Name	booking_class Booking Class	frequent_flyer_status Frequent Flyer Status	route Route	ticket_price Ticket Price	competitor_price Competitor Price	demand Demand	origin Origin	destination Destination	profitability Profitability	loyalty_points Loyalty Points	churned Churned
Wilsonstad	Lake Johnmouth	Tue May 02 2023 20:11:09 GMT+0000 (Coordinated Universal Time)	1.2758104513180268	120	3769	Daniel Oliver	Business	Gold	MEL-BNE	370.6381276565254	382.9473956372815	-0.9327545989981996	MEL	LHR	0.6322258706540151	4245	true
New Brent	Port Wanda	Fri Apr 21 2023 00:10:14 GMT+0000 (Coordinated Universal Time)	1.2758104513180268	35	3529	Deborah Hall	Economy	Platinum	BNE-SYD	114.52901630896034	394.5836405387877	-1.005569165664726	MEL	SIN	1.26502553191557	833	true
South Samanthaberg	Lake Meganside	Fri May 12 2023 15:16:31 GMT+0000 (Coordinated Universal Time)	0.7211102550927978	67	1303	Mary York	Economy	Platinum	MEL-BNE	164.46801800255258	479.83244389376665	1.7613843676632666	MEL	LAX	1.1416511371610871	2568	true
Lake Gracefurt	Jamesberg	Tue Jun 13 2023 20:53:09 GMT+0000 (Coordinated Universal Time)	-0.9429903335828896	72	2965	Christina Sanchez	Economy	Gold	BNE-SYD	318.9031670706702	286.30163231735867	-0.5201387212212184	MEL	LAX	1.1292913697945646	284	true
Owenborough	Kelleymouth	Mon May 15 2023 23:06:14 GMT+0000 (Coordinated Universal Time)	-0.3882901373576605	101	8779	Dustin Owens	Economy	Silver	BNE-SYD	389.971051294559	407.4633155191239	-0.6657678545542706	BNE	SIN	1.218239290714718	2805	true
Lake Randyland	Jacquelineland	Thu Jun 01 2023 07:58:06 GMT+0000 (Coordinated Universal Time)	-1.497690529808119	89	4269	Nicole Morales	First	Platinum	SYD-MEL	217.4027218771268	243.4767575467512	0.2080069454440427	SYD	LHR	1.3881205092047186	45
Lake Davidshire	Lake Shawn	Wed May 03 2023 19:21:08 GMT+0000 (Coordinated Universal Time)	-0.3882901373576605	37	9375	Monica Montgomery	First	Platinum	SYD-MEL	457.5739219428346	192.6673838224193	0.6934373898875502	MEL	LHR	1.2105199477212882	3981
South Deborah	New Kathrynburgh	Thu May 11 2023 04:28:23 GMT+0000 (Coordinated Universal Time)	0.1664100588675686	117	5855	Jason Whitaker	First	Silver	MEL-BNE	195.47067857949185	355.5125428212916	-1.6609002656634608	SYD	SIN	0.8796406208310951	371	true
Gregville	East John	Sun Jun 04 2023 05:55:27 GMT+0000 (Coordinated Universal Time)	0.7211102550927978	28	6021	Michael Wade	First	Platinum	MEL-BNE	334.9395556533641	154.07003450863488	-0.4473241545546922	SYD	LAX	1.4834760632493116	1689
Josephtown	Port Kennethfurt	Thu Jun 08 2023 03:03:54 GMT+0000 (Coordinated Universal Time)	1.2758104513180268	47	3065	David Cline	Business	Gold	SYD-MEL	145.36799902209123	109.24669284450997	0.3536360787770949	BNE	SIN	0.9240603622078836	112	true


CREATE TABLE flight_data (
  "departure_city" VARCHAR,
  "arrival_city" VARCHAR,
  "departure_date" TIMESTAMP,
  "flight_duration" DOUBLE,
  "delay_minutes" BIGINT,
  "customer_id" BIGINT,
  "name" VARCHAR,
  "booking_class" VARCHAR,
  "frequent_flyer_status" VARCHAR,
  "route" VARCHAR,
  "ticket_price" DOUBLE,
  "competitor_price" DOUBLE,
  "demand" DOUBLE,
  "origin" VARCHAR,
  "destination" VARCHAR,
  "profitability" DOUBLE,
  "loyalty_points" BIGINT,
  "churned" BOOLEAN
);