[
    {
        "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": "TIMESTAMP"
    },
    {
        "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"
    }
]