February Flight Delay Prediction

US Flight Data for the month of Feb 2019 and Feb 2020

@kaggle.divyansh22_february_flight_delay_prediction

Table List

2 tables(15.73 MB)

Feb 2019 Ontime

Feb 2020 Ontime

Feb 2020 Ontime

@kaggle.divyansh22_february_flight_delay_prediction.feb_2020_ontime

8.14 MB
574268 rows
22 columns

day_of_month DAY OF MONTH	day_of_week DAY OF WEEK	op_unique_carrier OP UNIQUE CARRIER	op_carrier_airline_id OP CARRIER AIRLINE ID	op_carrier OP CARRIER	tail_num TAIL NUM	op_carrier_fl_num OP CARRIER FL NUM	origin_airport_id ORIGIN AIRPORT ID	origin_airport_seq_id ORIGIN AIRPORT SEQ ID	origin ORIGIN	dest_airport_id DEST AIRPORT ID	dest_airport_seq_id DEST AIRPORT SEQ ID	dest DEST	dep_time DEP TIME	dep_time_blk DEP TIME BLK	arr_time ARR TIME	arr_del15 ARR DEL15	distance DISTANCE
1	6	MQ	20398	MQ	N269NN	3825	13930	1393007	ORD	15370	1537002	TUL	1646	1600-1659	1820		585
1	6	MQ	20398	MQ	N908AE	3829	12478	1247805	JFK	10693	1069302	BNA	1336	1300-1359	1458		765
1	6	MQ	20398	MQ	N663AR	3831	11953	1195302	GNV	13303	1330303	MIA	844	0800-0859	1020	1	294
1	6	MQ	20398	MQ	N618AE	3833	11298	1129806	DFW	14842	1484202	SJT	852	0800-0859	955		229
1	6	MQ	20398	MQ	N618AE	3833	14842	1484202	SJT	11298	1129806	DFW	1024	1000-1059	1132		229
1	6	MQ	20398	MQ	N252NN	3837	13486	1348602	MSO	11298	1129806	DFW	755	0800-0859	1154		1320
1	6	MQ	20398	MQ	N246NN	3838	14576	1457606	ROC	13930	1393007	ORD	1122	1100-1159	1211		528
1	6	MQ	20398	MQ	N836AE	3840	11298	1129806	DFW	14783	1478302	SGF	1629	1600-1659	1745		364
1	6	MQ	20398	MQ	N687JS	3841	10599	1059904	BHM	13303	1330303	MIA	1725	1700-1759	2019		661
1	6	MQ	20398	MQ	N687JS	3841	13303	1330303	MIA	10599	1059904	BHM	1552	1600-1659	1653		661


CREATE TABLE feb_2020_ontime (
  "day_of_month" BIGINT,
  "day_of_week" BIGINT,
  "op_unique_carrier" VARCHAR,
  "op_carrier_airline_id" BIGINT,
  "op_carrier" VARCHAR,
  "tail_num" VARCHAR,
  "op_carrier_fl_num" BIGINT,
  "origin_airport_id" BIGINT,
  "origin_airport_seq_id" BIGINT,
  "origin" VARCHAR,
  "dest_airport_id" BIGINT,
  "dest_airport_seq_id" BIGINT,
  "dest" VARCHAR,
  "dep_time" DOUBLE,
  "dep_del15" DOUBLE,
  "dep_time_blk" VARCHAR,
  "arr_time" DOUBLE,
  "arr_del15" DOUBLE,
  "cancelled" DOUBLE,
  "diverted" DOUBLE,
  "distance" DOUBLE,
  "unnamed_21" VARCHAR
);