Field Name | Description |
---|
ItinID | Itinerary ID | |
Coupons | Number of Coupons in the Itinerary | Analysis |
Year | Year | |
Quarter | Quarter (1-4) | Analysis |
Origin | Origin Airport Code | 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 |
OriginCountry | Origin Airport, Country | |
OriginStateFips | Origin Airport, State FIPS | Analysis |
OriginState | Origin Airport, State | Analysis |
OriginStateName | Origin State Name | |
OriginWac | Origin Airport, World Area Code | Analysis |
RoundTrip | Round Trip Indicator (1=Yes) | Analysis |
OnLine | Single Carrier Indicator (1=Yes) | Analysis |
DollarCred | Dollar Credibility Indicator | Analysis |
FarePerMile | Itinerary Fare Per Miles Flown in Dollars (ItinFare/MilesFlown). | |
RPCarrier | Reporting Carrier | Analysis |
Passengers | Number of Passengers | Analysis |
ItinFare | Itinerary Fare Per Person | |
BulkFare | Bulk Fare Indicator (1=Yes) | |
Distance | Itinerary Distance (Including Ground Transport) | |
DistanceGroup | Distance Group, in 500 Mile Intervals | Analysis |
MilesFlown | Itinerary Miles Flown (Track Miles) | |
ItinGeoType | Itinerary Geography Type | Analysis |