Name: 2015 Flight Delays And Cancellations
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

2015 Flight Delays And Cancellations

Context

The U.S. Department of Transportation's (DOT) Bureau of Transportation Statistics tracks the on-time performance of domestic flights operated by large air carriers. Summary information on the number of on-time, delayed, canceled, and diverted flights is published in DOT's monthly Air Travel Consumer Report and in this dataset of 2015 flight delays and cancellations.

Acknowledgements

The flight delay and cancellation data was collected and published by the DOT's Bureau of Transportation Statistics.

Tables

Airlines

@kaggle.usdot_flight_delays.airlines

2.33 KB
14 rows
2 columns


CREATE TABLE airlines (
  "iata_code" VARCHAR,
  "airline" VARCHAR
);

Airports

@kaggle.usdot_flight_delays.airports

22.34 KB
322 rows
7 columns


CREATE TABLE airports (
  "iata_code" VARCHAR,
  "airport" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "country" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);

Flights

@kaggle.usdot_flight_delays.flights

135.51 MB
5819079 rows
31 columns


CREATE TABLE flights (
  "year" BIGINT,
  "month" BIGINT,
  "day" BIGINT,
  "day_of_week" BIGINT,
  "airline" VARCHAR,
  "flight_number" BIGINT,
  "tail_number" VARCHAR,
  "origin_airport" VARCHAR,
  "destination_airport" VARCHAR,
  "scheduled_departure" BIGINT,
  "departure_time" DOUBLE,
  "departure_delay" DOUBLE,
  "taxi_out" DOUBLE,
  "wheels_off" DOUBLE,
  "scheduled_time" DOUBLE,
  "elapsed_time" DOUBLE,
  "air_time" DOUBLE,
  "distance" BIGINT,
  "wheels_on" DOUBLE,
  "taxi_in" DOUBLE,
  "scheduled_arrival" BIGINT,
  "arrival_time" DOUBLE,
  "arrival_delay" DOUBLE,
  "diverted" BIGINT,
  "cancelled" BIGINT,
  "cancellation_reason" VARCHAR,
  "air_system_delay" DOUBLE,
  "security_delay" DOUBLE,
  "airline_delay" DOUBLE,
  "late_aircraft_delay" DOUBLE,
  "weather_delay" DOUBLE
);