LAX-JFK_AA & UA flights 6-2012
Use first line as column names: yes
Share with everyone: yes
Last edited: Oct 6, 2012
Filtered data from RITA: (http://www.transtats.bts.gov/DL_SelectFields.asp?Table_ID=236&DB_Short_Name=On-Time)
Data set for population t-Test project
The data contained in the compressed file has been extracted from the On-Time Performance data table of the "On-Time" database from the TranStats data library. The time period is indicated in the name of the compressed file; for example, XXX_XXXXX_2001_1 contains data of the first month of the year 2001.
Below are fields in the order that they appear on the records:
Quarter Quarter (1-4)
DayofMonth Day of Month
DayOfWeek Day of Week
FlightDate Flight Date (yyyymmdd)
UniqueCarrier Unique Carrier Code. When the same code has been used by multiple carriers, a numeric suffix is used for earlier users, for example, PA, PA(1), PA(2). Use this field for analysis across a range of years.
AirlineID An identification number assigned by US DOT to identify a unique airline (carrier). A unique airline (carrier) is defined as one holding and reporting under the same DOT certificate regardless of its Code, Name, or holding company/corporation.
Carrier Code assigned by IATA and commonly used to identify a carrier. As the same code may have been assigned to different carriers over time, the code is not always unique. For analysis, use the Unique Carrier Code.
TailNum Tail Number
FlightNum Flight Number
OriginCityName Origin Airport, City Name
DestCityName Destination Airport, City Name
CRSDepTime CRS Departure Time (local time: hhmm)
DepTime Actual Departure Time (local time: hhmm)
DepDelay Difference in minutes between scheduled and actual departure time. Early departures show negative numbers.
DepDelayMinutes Difference in minutes between scheduled and actual departure time. Early departures set to 0.
DepDel15 Departure Delay Indicator, 15 Minutes or More (1=Yes)
DepartureDelayGroups Departure Delay intervals, every (15 minutes from <-15 to >180)
DepTimeBlk CRS Departure Time Block, Hourly Intervals
TaxiOut Taxi Out Time, in Minutes
WheelsOff Wheels Off Time (local time: hhmm)
WheelsOn Wheels On Time (local time: hhmm)
TaxiIn Taxi In Time, in Minutes
CRSArrTime CRS Arrival Time (local time: hhmm)
ArrTime Actual Arrival Time (local time: hhmm)
ArrDelay Difference in minutes between scheduled and actual arrival time. Early arrivals show negative numbers.
ArrDelayMinutes Difference in minutes between scheduled and actual arrival time. Early arrivals set to 0.
ArrDel15 Arrival Delay Indicator, 15 Minutes or More (1=Yes)
ArrivalDelayGroups Arrival Delay intervals, every (15-minutes from <-15 to >180)
ArrTimeBlk CRS Arrival Time Block, Hourly Intervals
CRSElapsedTime CRS Elapsed Time of Flight, in Minutes
ActualElapsedTime Elapsed Time of Flight, in Minutes
AirTime Flight Time, in Minutes
Flights Number of Flights
Distance Distance between airports (miles)
CarrierDelay Carrier Delay, in Minutes
WeatherDelay Weather Delay, in Minutes
NASDelay National Air System Delay, in Minutes
SecurityDelay Security Delay, in Minutes
LateAircraftDelay Late Aircraft Delay, in Minutes
This data set has 2 favorites. Sign in to add it to your favorites!
Adding a data set to your favorites makes it easier to come back to in the future!