Name: February Flight Delay Prediction
Creator: Kaggle
License: https://www.usa.gov/government-works

About this Dataset

February Flight Delay Prediction

This is the second part of flight delay prediction i.e. for the month of February. To check the first part i.e. for the month of January, please have a look at this dataset: January Flight Delay Prediction

This data is collected from the Bureau of Transportation Statistics, Govt. of the USA. This data is open-sourced under U.S. Govt. Works. This dataset contains all the flights in the month of February 2019 and February 2020. There are more than 400,000 flights in the month of February itself throughout the United States. The features were manually chosen to do a primary time series analysis. There are several other features available on their website.

This data could well be used to predict the flight delay at the destination airport particularly for the month of February in upcoming years as the data is for February only.

Tables

Feb 2019 Ontime

@kaggle.divyansh22_february_flight_delay_prediction.feb_2019_ontime

7.59 MB
533175 rows
22 columns


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

Feb 2020 Ontime

@kaggle.divyansh22_february_flight_delay_prediction.feb_2020_ontime

8.14 MB
574268 rows
22 columns


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
);