d o t logoUnited States Department of Transportation
  OST-R > BTS
transtats logo
 
Advanced Search
Resources
Data Tools
Origin and Destination Survey : DB1BCoupon
   Data Tables   Table Contents
Download Instructions  
Latest Available Data: March 2018
 Prezipped File % Missing Documentation Terms
Field Name  Description  Support Table 
ItinIDItinerary ID 
MktIDMarket ID 
SeqNumCoupon Sequence Number 
CouponsNumber of Coupons in the ItineraryGet Lookup Table
YearYear 
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
QuarterQuarter (1-4)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
BreakTrip Break CodeGet Lookup Table
CouponTypeCoupon Type CodeGet Lookup Table
TkCarrierTicketing Carrier CodeGet Lookup Table
OpCarrierOperating Carrier CodeGet Lookup Table
RPCarrierReporting Carrier CodeGet Lookup Table
PassengersNumber of Passengers 
FareClassFare Class Code. Value Is Defined By Carriers And May Not Follow The Same Standard. Not Recommended For Analysis.Get Lookup Table
DistanceCoupon Distance 
DistanceGroupDistance Group, in 500 Mile IntervalsGet Lookup Table
GatewayGateway Indicator (1=Yes)Get Lookup Table
ItinGeoTypeItinerary Geography TypeGet Lookup Table
CouponGeoTypeCoupon Geography TypeGet Lookup Table