BACKGROUND

The data contained in the compressed file has been extracted from the DB1BTicket 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:
ItinIDItinerary ID
CouponsNumber of Coupons in the Itinerary
YearYear
QuarterQuarter (1-4)
OriginOrigin Airport Code
OriginAirportIDOrigin 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.
OriginAirportSeqIDOrigin 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.
OriginCityMarketIDOrigin 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.
OriginCountryOrigin Airport, Country
OriginStateFipsOrigin Airport, State FIPS
OriginStateOrigin Airport, State
OriginStateNameOrigin State Name
OriginWacOrigin Airport, World Area Code
RoundTripRound Trip Indicator (1=Yes)
OnLineSingle Carrier Indicator (1=Yes)
DollarCredDollar Credibility Indicator
FarePerMileItinerary Fare Per Miles Flown in Dollars (ItinFare/MilesFlown).
RPCarrierReporting Carrier
PassengersNumber of Passengers
ItinFareItinerary Fare Per Person
BulkFareBulk Fare Indicator (1=Yes)
DistanceItinerary Distance (Including Ground Transport)
DistanceGroupDistance Group, in 500 Mile Intervals
MilesFlownItinerary Miles Flown (Track Miles)
ItinGeoTypeItinerary Geography Type