USA Banner

Official US Government Icon

Official websites use .gov
A .gov website belongs to an official government organization in the United States.

Secure Site Icon

Secure .gov websites use HTTPS
A lock ( ) or https:// means you’ve safely connected to the .gov website. Share sensitive information only on official, secure websites.

Site Notification

Site Notification

U.S. Department of TransportationU.S. Department of Transportation IconUnited States Department of TransportationUnited States Department of Transportation
BTS> TranStats
transtats logo
 
Advanced Search
Resources
Data Tools
: DB1BCoupon
   Database Profile   Data Tables   Table Profile
Latest Available Data: December 2023All Rows Shown
Field NameDescription
ItinIDItinerary ID 
MktIDMarket ID 
SeqNumCoupon Sequence Number 
CouponsNumber of Coupons in the ItineraryAnalysis
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.Analysis
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.Analysis
QuarterQuarter (1-4)Analysis
OriginOrigin Airport CodeAnalysis
OriginCountryOrigin Airport, Country Code 
OriginStateFipsOrigin Airport, State FIPS CodeAnalysis
OriginStateOrigin Airport, State CodeAnalysis
OriginStateNameOrigin State Name 
OriginWacOrigin Airport, World Area CodeAnalysis
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.Analysis
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. 
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.Analysis
DestDestination Airport CodeAnalysis
DestCountryDestination Airport, Country Code 
DestStateFipsDestination Airport, State FIPS CodeAnalysis
DestStateDestination Airport, State CodeAnalysis
DestStateNameDestination State Name 
DestWacDestination Airport, World Area CodeAnalysis
BreakTrip Break CodeAnalysis
CouponTypeCoupon Type CodeAnalysis
TkCarrierTicketing Carrier Code 
OpCarrierOperating Carrier Code 
RPCarrierReporting Carrier CodeAnalysis
PassengersNumber of PassengersAnalysis
FareClassFare Class Code. Value Is Defined By Carriers And May Not Follow The Same Standard. Not Recommended For Analysis.Analysis
DistanceCoupon Distance 
DistanceGroupDistance Group, in 500 Mile IntervalsAnalysis
GatewayGateway Indicator (1=Yes)Analysis
ItinGeoTypeItinerary Geography TypeAnalysis
CouponGeoTypeCoupon Geography TypeAnalysis
All Rows Shown