#### BACKGROUND
The data contained in the compressed file has been extracted from the DB1BMarket data table of the "Origin and Destination Survey" database from the TranStats data library. The time period is indicated in the name of the compressed file; for example, XXX_XXXXX_2001_1 contains data of the first quarter of the year 2001.
#### RECORD LAYOUT
Below are fields in the order that they appear on the records:
ItinID | Itinerary ID
MktID | Market ID
MktCoupons | Number of Coupons in the Market
Year | Year
Quarter | Quarter (1-4)
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.
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.
Origin | Origin Airport Code
OriginCountry | Origin Airport, Country Code
OriginStateFips | Origin Airport, State FIPS Code
OriginState | Origin Airport, State Code
OriginStateName | Origin State Name
OriginWac | Origin Airport, World Area Code
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.
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.
Dest | Destination Airport Code
DestCountry | Destination Airport, Country Code
DestStateFips | Destination Airport, State FIPS Code
DestState | Destination Airport, State Code
DestStateName | Destination State Name
DestWac | Destination Airport, World Area Code
AirportGroup | Airport Group
WacGroup | World Area Code Group
TkCarrierChange | Ticketing Carrier Change Indicator (1=Yes)
TkCarrierGroup | Ticketing Carrier Group
OpCarrierChange | Operating Carrier Change Indicator (1=Yes)
OpCarrierGroup | Operating Carrier Group
RPCarrier | Reporting Carrier Code
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
MktFare | Market Fare (ItinYield*MktMilesFlown)
MktDistance | Market Distance (Including Ground Transport)
MktDistanceGroup | Distance Group, in 500 Mile Intervals
MktMilesFlown | Market Miles Flown (Track Miles)
NonStopMiles | Non-Stop Market Miles (Using Radian Measure)
ItinGeoType | Itinerary Geography Type
MktGeoType | Market Geography Type