d o t logoUnited States Department of Transportation
  OST-R > BTS
transtats logo
 
Advanced Search
Resources
Data Tools
Origin and Destination Survey : DB1BMarket
   Data Tables   Table Contents
Download Instructions  
Latest Available Data: June 2018
 Prezipped File % Missing Documentation Terms
Field Name  Description  Support Table 
ItinIDItinerary ID 
MktIDMarket ID 
MktCouponsNumber of Coupons in the MarketGet Lookup Table
YearYear 
QuarterQuarter (1-4)Get Lookup Table
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.Get Lookup Table
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.Get Lookup Table
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.Get Lookup Table
OriginOrigin Airport CodeGet Lookup Table
OriginCountryOrigin Airport, Country Code 
OriginStateFipsOrigin Airport, State FIPS CodeGet Lookup Table
OriginStateOrigin Airport, State CodeGet Lookup Table
OriginStateNameOrigin State Name 
OriginWacOrigin Airport, World Area CodeGet Lookup Table
DestAirportIDDestination 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.Get Lookup Table
DestAirportSeqIDDestination 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.Get Lookup Table
DestCityMarketIDDestination 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.Get Lookup Table
DestDestination Airport CodeGet Lookup Table
DestCountryDestination Airport, Country Code 
DestStateFipsDestination Airport, State FIPS CodeGet Lookup Table
DestStateDestination Airport, State CodeGet Lookup Table
DestStateNameDestination State Name 
DestWacDestination Airport, World Area CodeGet Lookup Table
AirportGroupAirport Group 
WacGroupWorld Area Code Group 
TkCarrierChangeTicketing Carrier Change Indicator (1=Yes)Get Lookup Table
TkCarrierGroupTicketing Carrier Group 
OpCarrierChangeOperating Carrier Change Indicator (1=Yes)Get Lookup Table
OpCarrierGroupOperating Carrier Group 
RPCarrierReporting Carrier CodeGet Lookup Table
TkCarrierTicketing Carrier Code for On-line Itineraries (otherwise equal to 99)Get Lookup Table
OpCarrierOperating Carrier Code for On-line Itineraries (otherwise equals to 99)Get Lookup Table
BulkFareBulk Fare Indicator (1=Yes)Get Lookup Table
PassengersNumber of Passengers 
MktFareMarket Fare (ItinYield*MktMilesFlown) 
MktDistanceMarket Distance (Including Ground Transport) 
MktDistanceGroupDistance Group, in 500 Mile IntervalsGet Lookup Table
MktMilesFlownMarket Miles Flown (Track Miles) 
NonStopMilesNon-Stop Market Miles (Using Radian Measure) 
ItinGeoTypeItinerary Geography TypeGet Lookup Table
MktGeoTypeMarket Geography TypeGet Lookup Table