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 2019 Ontime

@kaggle.divyansh22_flight_delay_prediction.jan_2019_ontime

8.28 MB
583985 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	2	9E	20363	9E	N8688C	3280	11953	1195302	GNV	10397	1039707	ATL	601	0600-0659	722	300
1	2	9E	20363	9E	N348PQ	3281	13487	1348702	MSP	11193	1119302	CVG	1359	1400-1459	1633	596
1	2	9E	20363	9E	N8896A	3282	11433	1143302	DTW	11193	1119302	CVG	1215	1200-1259	1329	229
1	2	9E	20363	9E	N8886A	3283	15249	1524906	TLH	10397	1039707	ATL	1521	1500-1559	1625	223
1	2	9E	20363	9E	N8974C	3284	10397	1039707	ATL	11778	1177801	FSM	1847	1900-1959	1940	579
1	2	9E	20363	9E	N927EV	3285	11267	1126702	DAY	13487	1348702	MSP	853	0900-0959	953	574
1	2	9E	20363	9E	N915XJ	3286	12448	1244807	JAN	10397	1039707	ATL	1553	1500-1559	1832	341
1	2	9E	20363	9E	N295PQ	3287	12953	1295304	LGA	11193	1119302	CVG	1551	1500-1559	1824	585
1	2	9E	20363	9E	N337PQ	3288	12451	1245102	JAX	12953	1295304	LGA	1037	1000-1059	1239	833
1	2	9E	20363	9E	N311PQ	3289	10397	1039707	ATL	10685	1068502	BMI	1245	1200-1259	1318	533


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