Airlines CSV File
From the CORGIS Dataset Project
By Austin Cory Bart acbart@vt.edu
Version 2.0.0, created 3/27/2015
Tags: airplane, airports, travel, plane, air, flights, delays, national, united states, transportation
Overview
This dataset is all about flights in the united states, including information about the number, length, and type of delays. The data is reported for individual months at every major airport for every carrier. Additional information is available: http://www.rita.dot.gov/bts/help/aviation/html/understanding.html
Download
Download the following file:
Key Descriptions
| Key | List of... | Comment | Example Value |
|---|---|---|---|
| Airport.Code | String | The 3 letter code for this airport, assigned by IATA. For more information, consult this List of Airport Codes. | "ATL" |
| Airport.Name | String | The full name of this airport. | "Atlanta, GA: Hartsfield-Jackson Atlanta International" |
| Time.Label | String | The "year/month" reported as a string, to make it easier to sort by time periods. | "2003/06" |
| Time.Month | Integer | The reported month as a number. 0 is January, 1 is February, etc. | 6 |
| Time.Month Name | String | $MISSING_FIELD | "June" |
| Time.Year | Integer | The reported year as a 4-digit number. | 2003 |
| Statistics.# of Delays.Carrier | Integer | The number of delays and cancellations due to circumstances within the airline's control (e.g. maintenance or crew problems, aircraft cleaning, baggage loading, fueling, etc.) in this month. | 1009 |
| Statistics.# of Delays.Late Aircraft | Integer | The number of delays and cancellations caused by a previous flight with the same aircraft arriving late, causing the present flight to depart late in this month. | 1275 |
| Statistics.# of Delays.National Aviation System | Integer | The number of delays and cancellations attributable to the national aviation system that refer to a broad set of conditions, such as non-extreme weather conditions, airport operations, heavy traffic volume, and air traffic control in this month. | 3217 |
| Statistics.# of Delays.Security | Integer | Number of delays or cancellations caused by evacuation of a terminal or concourse, re-boarding of aircraft because of security breach, inoperative screening equipment and/or long lines in excess of 29 minutes at screening areas in this month. | 17 |
| Statistics.# of Delays.Weather | Integer | Number of delays or cancellations caused by significant meteorological conditions (actual or forecasted) that, in the judgment of the carrier, delays or prevents the operation of a flight such as tornado, blizzard or hurricane in this month. | 328 |
| Statistics.Carriers.Names | String | The full names of the carriers that reported in. | "American Airlines Inc.,JetBlue Airways,Continental Air Lines Inc.,Delta Air Lines Inc.,Atlantic Southeast Airlines,AirTran Airways Corporation,America West Airlines Inc.,Northwest Airlines Inc.,ExpressJet Airlines Inc.,United Air Lines Inc.,US Airways Inc." |
| Statistics.Carriers.Total | Integer | The number of carriers that reported flight information during this time period and at this location. | 11 |
| Statistics.Flights.Cancelled | Integer | The number of flights that were cancelled in this month. | 216 |
| Statistics.Flights.Delayed | Integer | The number of flights that were delayed in this month. | 5843 |
| Statistics.Flights.Diverted | Integer | The number of flights that were diverted in this month. | 27 |
| Statistics.Flights.On Time | Integer | The number of flights that were on time in this month. | 23974 |
| Statistics.Flights.Total | Integer | The total number of flights in this month. | 30060 |
| Statistics.Minutes Delayed.Carrier | Integer | The number of minutes delayed due to circumstances within the airline's control (e.g. maintenance or crew problems, aircraft cleaning, baggage loading, fueling, etc.) in this month. | 61606 |
| Statistics.Minutes Delayed.Late Aircraft | Integer | The number of minutes delayed caused by a previous flight with the same aircraft arriving late, causing the present flight to depart late in this month. | 68335 |
| Statistics.Minutes Delayed.National Aviation System | Integer | The number of minutes delayed attributable to the national aviation system that refer to a broad set of conditions, such as non-extreme weather conditions, airport operations, heavy traffic volume, and air traffic control in this month. | 118831 |
| Statistics.Minutes Delayed.Security | Integer | Number of minutes delayed caused by evacuation of a terminal or concourse, re-boarding of aircraft because of security breach, inoperative screening equipment and/or long lines in excess of 29 minutes at screening areas in this month. | 518 |
| Statistics.Minutes Delayed.Total | Integer | $MISSING_FIELD | 268764 |
| Statistics.Minutes Delayed.Weather | Integer | Number of of minutes delayed caused by significant meteorological conditions (actual or forecasted) that, in the judgment of the carrier, delays or prevents the operation of a flight such as tornado, blizzard or hurricane in this month. | 19474 |