January Flight Delay Prediction

US Flight Data for the month of Jan 2019 and Jan 2020.

@kaggle.divyansh22_flight_delay_prediction

Table List

2 tables(16.94 MB)

Jan 2019 Ontime

Jan 2020 Ontime

Jan 2020 Ontime

@kaggle.divyansh22_flight_delay_prediction.jan_2020_ontime

8.66 MB
607346 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	distance DISTANCE
1	3	EV	20366	EV	N48901	4397	13930	1393007	ORD	11977	1197705	GRB	1003	1000-1059	1117	174
1	3	EV	20366	EV	N16976	4401	15370	1537002	TUL	13930	1393007	ORD	1027	1000-1059	1216	585
1	3	EV	20366	EV	N12167	4404	11618	1161802	EWR	15412	1541205	TYS	1848	1800-1859	2120	631
1	3	EV	20366	EV	N14902	4405	10781	1078105	BTR	12266	1226603	IAH	1846	1800-1859	2004	253
1	3	EV	20366	EV	N606UX	4407	14524	1452401	RIC	12266	1226603	IAH	1038	1000-1059	1330	1157
1	3	EV	20366	EV	N605UX	4408	13871	1387102	OMA	12266	1226603	IAH	555	0600-0659	838	781
1	3	EV	20366	EV	N14991	4410	12266	1226603	IAH	14814	1481402	SHV	1610	1600-1659	1718	192
1	3	EV	20366	EV	N15986	4411	12266	1226603	IAH	12206	1220605	HRL	1415	1400-1459	1531	295
1	3	EV	20366	EV	N603UX	4412	13930	1393007	ORD	10140	1014005	ABQ	1938	1900-1959	2204	1118
1	3	EV	20366	EV	N13975	4414	11618	1161802	EWR	13485	1348502	MSN	1011	1000-1059	1139	799


CREATE TABLE jan_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
);