Flights dataset metadata
Column Name
DA Y_OF_WEEK
AIRLINE FLIGHT_NUMBER
Copyright By PowCoder代写 加微信 powcoder
T AIL_NUMBER ORIGIN_AIRPORT DESTINA TION_AIRPORT SCHEDULED_DEP ARTURE DEP ARTURE_TIME DEPARTURE_DELAY
T AXI_OUT WHEELS_OFF SCHEDULED_TIME ELAPSED_TIME AIR_TIME
DIST ANCE WHEELS_ON
TAXI_IN SCHEDULED_ARRIVAL ARRIVAL_TIME ARRIVAL_DELAY DIVERTED
Description
Year of the Flight Trip
Month of the Flight Trip, Example 1 means month of January, 2 means February and so on Day of the Flight Trip, Example 1 means date 1, 2 means date 2 and so on
Day of week of the Flight Trip, e.g. 1 represents Monday, 2 represents Tuesday and so on Airline Identifier
Flight Identifier
Aircraft Identifier
Starting Airport
Destination Airport
Planned Departure Time
WHEEL_OFF – TAXI_OUT
Total Delay on Departure
The time duration elapsed between departure from the origin airport gate and wheels off The time point that the aircraft’s wheels leave the ground
Planned time amount needed for the flight trip
AIR_TIME+T AXI_IN+T AXI_OUT
The time duration between wheels off and wheels on time
Distance between two airports
The time point that the aircraft’s wheels touch on the ground
The time duration elapsed between wheels-on and gate arrival at the destination airport Planned arrival time
WHEELS_ON+T AXI_IN
ARRIVAL_TIME-SCHEDULED_ARRIVAL
Aircraft landed on airport that out of schedule
Data type Int
Int Int Int String Int String String String Int Int Int Int Int Int Int Int Int Int Int Int Int Int Int
26 CANCELLATION_REASO
AIR_SYSTEM_DELAY SECURITY_DELAY AIRLINE_DELAY LATE_AIRCRAFT_DELAY WEATHER_DELAY
Airports dataset metadata
Flight Cancelled (1 = cancelled)
Reason for Cancellation of flight: A – Airline/Carrier; B – Weather; C – National Air System; D – Security Delay caused by air system
Delay caused by security
Delay caused by the airline
Delay caused by aircraft Delay caused by weather
Description
Location Identifier. This location identifier is used as a code in ORIGIN_AIRPORT and DESTINATION_AIRPORT in Flights Data
Airports Name
The City where the airport is located The State where the airport is located The Country where the airport is located Latitude of the Airport
Longitude of the Airport
String Int Int Int Int Int
String String String String String Float Float
27 28 29 30 31
1 2 3 4 5 6 7
Column Name
IA T A_CODE AIRPORT CITY
STATE COUNTRY
A LATITUDA
A LONGITUDE
程序代写 CS代考 加微信: powcoder QQ: 1823890830 Email: powcoder@163.com