#### BACKGROUND
The data contained in the compressed file has been extracted from the DB1BCoupon 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
SeqNum | Coupon Sequence Number
Coupons | Number of Coupons in the Itinerary
Year | Year
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.
Quarter | Quarter (1-4)
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
Break | Trip Break Code
CouponType | Coupon Type Code
TkCarrier | Ticketing Carrier Code
OpCarrier | Operating Carrier Code
RPCarrier | Reporting Carrier Code
Passengers | Number of Passengers
FareClass | Fare Class Code. Value Is Defined By Carriers And May Not Follow The Same Standard. Not Recommended For Analysis.
Distance | Coupon Distance
DistanceGroup | Distance Group, in 500 Mile Intervals
Gateway | Gateway Indicator (1=Yes)
ItinGeoType | Itinerary Geography Type
CouponGeoType | Coupon Geography Type