d o t logoUnited States Department of Transportation
  BTS
transtats logo
 
Advanced Search
Resources
Data Tools
: DB1BCoupon
   Database Profile   Data Tables   Table Contents
Property Description
NameDB1BCoupon
DescriptionThis table provides coupon-specific information for each itinerary, such as the operating carrier, origin and destination airports, number of passengers, fare class, coupon type, trip break indicator, gateway indicator, and distance.
Records910,606,119
Fields36
First Year1993
Last Year2020
FrequencyQuarterly
Latest Available DataDecember, 2020
  
TermsDefinitions
Airport CodeA three character alpha-numeric code issued by the U.S. Department of Transportation which is the official designation of the airport. The airport code is not always unique to a specific airport because airport codes can change or can be reused.
Airport IDAn 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.
City Market IDAn identification number assigned by US DOT to identify a city market. Use this field to consolidate airports serving the same city market.
CodeshareAn arrangement whereby a marketing carrier's code is used to identify a flight operated by another carrier. The marketing carrier may make reservations and issue tickets for the operating carrier's flights.
CouponA piece of paper or series of papers indicating the itinerary of a passenger. An airline ticket includes an auditor's coupon, flight coupons, and a passenger receipt.
GatewayIn international travel, the port where customs clearance takes place.
Marketing CarrierAn air carrier that issued a flight reservation or ticket under a codeshare agreement.
Operating CarrierAn air carrier engaged directly in the operation of aircraft in passenger air transportation.
Reporting CarrierThe carrier that submitted data to the Office of Airline Information for a given passenger segment.
Trip BreakTrip Breaks are points in the itinerary at which a passenger is assumed to have stopped for a reason other than changing planes. A break in the passenger's trip creates a market. For example: An itinerary BOS-LAS-BOS would have two markets BOS-LAS and LAS-BOS. The trip break occurred at LAS.
World Area Code (WAC)Numeric codes used to identify geopolitical areas such as countries, states (U.S.), provinces (Canada), and territories or possessions of certain countries. The codes are used within the various data banks maintained by the Office of Airline Information (OAI) and are created by OAI.