[ { "description": "Year", "name": "YEAR", "type": "INTEGER" }, { "description": "Quarter (1-4)", "name": "QUARTER", "type": "INTEGER" }, { "description": "Month", "name": "MONTH", "type": "INTEGER" }, { "description": "Day of Month", "name": "DAY_OF_MONTH", "type": "INTEGER" }, { "description": "Day of Week", "name": "DAY_OF_WEEK", "type": "INTEGER" }, { "description": "Flight Date (yyyymmdd)", "name": "FL_DATE", "type": "STRING" }, { "description": "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.", "name": "OP_UNIQUE_CARRIER", "type": "STRING" }, { "description": "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.", "name": "OP_CARRIER_AIRLINE_ID", "type": "INTEGER" }, { "description": "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.", "name": "OP_CARRIER", "type": "STRING" }, { "description": "Tail Number", "name": "TAIL_NUM", "type": "STRING" }, { "description": "Flight Number", "name": "OP_CARRIER_FL_NUM", "type": "INTEGER" }, { "description": "Origin Airport, Airport ID. An identification number assigned by US DOT to identify a unique airport. Use this field for airport analysis across a range of years because an airport can change its airport code and airport codes can be reused.", "name": "ORIGIN_AIRPORT_ID", "type": "INTEGER" }, { "description": "Origin Airport, Airport Sequence ID. An identification number assigned by US DOT to identify a unique airport at a given point of time. Airport attributes, such as airport name or coordinates, may change over time.", "name": "ORIGIN_AIRPORT_SEQ_ID", "type": "INTEGER" }, { "description": "Origin Airport, City Market ID. City Market ID is an identification number assigned by US DOT to identify a city market. Use this field to consolidate airports serving the same city market.", "name": "ORIGIN_CITY_MARKET_ID", "type": "INTEGER" }, { "description": "Origin Airport", "name": "ORIGIN", "type": "STRING" }, { "description": "Origin Airport, City Name", "name": "ORIGIN_CITY_NAME", "type": "STRING" }, { "description": "Origin Airport, State Code", "name": "ORIGIN_STATE_ABR", "type": "STRING" }, { "description": "Origin Airport, State Fips", "name": "ORIGIN_STATE_FIPS", "type": "STRING" }, { "description": "Origin Airport, State Name", "name": "ORIGIN_STATE_NM", "type": "STRING" }, { "description": "Origin Airport, World Area Code", "name": "ORIGIN_WAC", "type": "INTEGER" }, { "description": "Destination Airport, Airport ID. An identification number assigned by US DOT to identify a unique airport. Use this field for airport analysis across a range of years because an airport can change its airport code and airport codes can be reused.", "name": "DEST_AIRPORT_ID", "type": "INTEGER" }, { "description": "Destination Airport, Airport Sequence ID. An identification number assigned by US DOT to identify a unique airport at a given point of time. Airport attributes, such as airport name or coordinates, may change over time.", "name": "DEST_AIRPORT_SEQ_ID", "type": "INTEGER" }, { "description": "Destination Airport, City Market ID. City Market ID is an identification number assigned by US DOT to identify a city market. Use this field to consolidate airports serving the same city market.", "name": "DEST_CITY_MARKET_ID", "type": "INTEGER" }, { "description": "Destination Airport", "name": "DEST", "type": "STRING" }, { "description": "Destination Airport, City Name", "name": "DEST_CITY_NAME", "type": "STRING" }, { "description": "Destination Airport, State Code", "name": "DEST_STATE_ABR", "type": "STRING" }, { "description": "Destination Airport, State Fips", "name": "DEST_STATE_FIPS", "type": "STRING" }, { "description": "Destination Airport, State Name", "name": "DEST_STATE_NM", "type": "STRING" }, { "description": "Destination Airport, World Area Code", "name": "DEST_WAC", "type": "INTEGER" }, { "description": "CRS Departure Time (local time: hhmm)", "name": "CRS_DEP_TIME", "type": "STRING" }, { "description": "Actual Departure Time (local time: hhmm)", "name": "DEP_TIME", "type": "STRING" }, { "description": "Difference in minutes between scheduled and actual departure time. Early departures show negative numbers.", "name": "DEP_DELAY", "type": "FLOAT" }, { "description": "Difference in minutes between scheduled and actual departure time. Early departures set to 0.", "name": "DEP_DELAY_NEW", "type": "FLOAT" }, { "description": "Departure Delay Indicator, 15 Minutes or More (1=Yes)", "name": "DEP_DEL15", "type": "FLOAT" }, { "description": "Departure Delay intervals, every (15 minutes from <-15 to >180)", "name": "DEP_DELAY_GROUP", "type": "INTEGER" }, { "description": "CRS Departure Time Block, Hourly Intervals", "name": "DEP_TIME_BLK", "type": "STRING" }, { "description": "Taxi Out Time, in Minutes", "name": "TAXI_OUT", "type": "FLOAT" }, { "description": "Wheels Off Time (local time: hhmm)", "name": "WHEELS_OFF", "type": "STRING" }, { "description": "Wheels On Time (local time: hhmm)", "name": "WHEELS_ON", "type": "STRING" }, { "description": "Taxi In Time, in Minutes", "name": "TAXI_IN", "type": "FLOAT" }, { "description": "CRS Arrival Time (local time: hhmm)", "name": "CRS_ARR_TIME", "type": "STRING" }, { "description": "Actual Arrival Time (local time: hhmm)", "name": "ARR_TIME", "type": "STRING" }, { "description": "Difference in minutes between scheduled and actual arrival time. Early arrivals show negative numbers.", "name": "ARR_DELAY", "type": "FLOAT" }, { "description": "Difference in minutes between scheduled and actual arrival time. Early arrivals set to 0.", "name": "ARR_DELAY_NEW", "type": "FLOAT" }, { "description": "Arrival Delay Indicator, 15 Minutes or More (1=Yes)", "name": "ARR_DEL15", "type": "FLOAT" }, { "description": "Arrival Delay intervals, every (15 minutes from <-15 to >180)", "name": "ARR_DELAY_GROUP", "type": "INTEGER" }, { "description": "CRS Arrival Time Block, Hourly Intervals", "name": "ARR_TIME_BLK", "type": "STRING" }, { "description": "Cancelled Flight Indicator (1=Yes)", "name": "CANCELLED", "type": "FLOAT" }, { "description": "Specifies The Reason For Cancellation", "name": "CANCELLATION_CODE", "type": "STRING" }, { "description": "Diverted Flight Indicator (1=Yes)", "name": "DIVERTED", "type": "FLOAT" }, { "description": "CRS Elapsed Time of Flight, in Minutes", "name": "CRS_ELAPSED_TIME", "type": "FLOAT" }, { "description": "Elapsed Time of Flight, in Minutes", "name": "ACTUAL_ELAPSED_TIME", "type": "FLOAT" }, { "description": "Flight Time, in Minutes", "name": "AIR_TIME", "type": "FLOAT" }, { "description": "Number of Flight", "name": "FLIGHTS", "type": "FLOAT" }, { "description": "Distance between airports (miles)", "name": "DISTANCE", "type": "FLOAT" }, { "description": "Distance Intervals, every 250 Miles, for Flight Segment", "name": "DISTANCE_GROUP", "type": "INTEGER" }, { "description": "Carrier Delay, in Minutes", "name": "CARRIER_DELAY", "type": "FLOAT" }, { "description": "Weather Delay, in Minutes", "name": "WEATHER_DELAY", "type": "FLOAT" }, { "description": "National Air System Delay, in Minutes", "name": "NAS_DELAY", "type": "FLOAT" }, { "description": "Security Delay, in Minutes", "name": "SECURITY_DELAY", "type": "FLOAT" }, { "description": "Late Aircraft Delay, in Minutes", "name": "LATE_AIRCRAFT_DELAY", "type": "FLOAT" } ]