| Field Name | Description |
|---|
| ItinID | Itinerary ID | |
| MktID | Market ID | |
| MktCoupons | Number of Coupons in the Market | Analysis |
| Year | Year | |
| Quarter | Quarter (1-4) | Analysis |
| OriginAirportID | 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. | Analysis |
| OriginAirportSeqID | 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. | |
| OriginCityMarketID | 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. | Analysis |
| Origin | Origin Airport Code | Analysis |
| OriginCountry | Origin Airport, Country Code | |
| OriginStateFips | Origin Airport, State FIPS Code | Analysis |
| OriginState | Origin Airport, State Code | Analysis |
| OriginStateName | Origin State Name | |
| OriginWac | Origin Airport, World Area Code | Analysis |
| DestAirportID | 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. | Analysis |
| DestAirportSeqID | 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. | |
| DestCityMarketID | 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. | Analysis |
| Dest | Destination Airport Code | Analysis |
| DestCountry | Destination Airport, Country Code | |
| DestStateFips | Destination Airport, State FIPS Code | Analysis |
| DestState | Destination Airport, State Code | Analysis |
| DestStateName | Destination State Name | |
| DestWac | Destination Airport, World Area Code | Analysis |
| AirportGroup | Airport Group | |
| WacGroup | World Area Code Group | |
| TkCarrierChange | Ticketing Carrier Change Indicator (1=Yes) | Analysis |
| TkCarrierGroup | Ticketing Carrier Group | |
| OpCarrierChange | Operating Carrier Change Indicator (1=Yes) | Analysis |
| OpCarrierGroup | Operating Carrier Group | |
| RPCarrier | Reporting Carrier Code | Analysis |
| TkCarrier | Ticketing Carrier Code for On-line Itineraries (otherwise equal to 99) | |
| OpCarrier | Operating Carrier Code for On-line Itineraries (otherwise equals to 99) | |
| BulkFare | Bulk Fare Indicator (1=Yes) | |
| Passengers | Number of Passengers | Analysis |
| MktFare | Market Fare (ItinYield*MktMilesFlown) | |
| MktDistance | Market Distance (Including Ground Transport) | |
| MktDistanceGroup | Distance Group, in 500 Mile Intervals | Analysis |
| MktMilesFlown | Market Miles Flown (Track Miles) | |
| NonStopMiles | Non-Stop Market Miles (Using Radian Measure) | |
| ItinGeoType | Itinerary Geography Type | Analysis |
| MktGeoType | Market Geography Type | Analysis |
