OST_R | BTS | Transtats

United States Department of Transportation

OST-R > BTS

Resources

Data Tools

Table Contents

: DB1BCoupon

Data Tables Table Contents
Download Instructions	Filter Geography	Filter Year	Filter Period
Latest Available Data: June 2020

Field Name	Description	% Missing	Support Table
ItinID	Itinerary ID	<0.005
MktID	Market ID	<0.005
SeqNum	Coupon Sequence Number	<0.005
Coupons	Number of Coupons in the Itinerary	<0.005	Get Lookup Table
Year	Year	<0.005
OriginAirportID	Origin 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.	<0.005	Get Lookup Table
OriginAirportSeqID	Origin 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.	<0.005	Get Lookup Table
OriginCityMarketID	Origin 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.	<0.005	Get Lookup Table
Quarter	Quarter (1-4)	<0.005	Get Lookup Table
Origin	Origin Airport Code	<0.005	Get Lookup Table
OriginCountry	Origin Airport, Country Code	<0.005
OriginStateFips	Origin Airport, State FIPS Code	<0.005	Get Lookup Table
OriginState	Origin Airport, State Code	<0.005	Get Lookup Table
OriginStateName	Origin State Name	<0.005
OriginWac	Origin Airport, World Area Code	<0.005	Get Lookup Table
DestAirportID	Destination 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.	<0.005	Get Lookup Table
DestAirportSeqID	Destination 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.	<0.005	Get Lookup Table
DestCityMarketID	Destination 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.	<0.005	Get Lookup Table
Dest	Destination Airport Code	<0.005	Get Lookup Table
DestCountry	Destination Airport, Country Code	<0.005
DestStateFips	Destination Airport, State FIPS Code	<0.005	Get Lookup Table
DestState	Destination Airport, State Code	<0.005	Get Lookup Table
DestStateName	Destination State Name	<0.005
DestWac	Destination Airport, World Area Code	<0.005	Get Lookup Table
Break	Trip Break Code	38.96	Get Lookup Table
CouponType	Coupon Type Code	<0.005	Get Lookup Table
TkCarrier	Ticketing Carrier Code	<0.005	Get Lookup Table
OpCarrier	Operating Carrier Code	<0.005	Get Lookup Table
RPCarrier	Reporting Carrier Code	<0.005	Get Lookup Table
Passengers	Number of Passengers	<0.005
FareClass	Fare Class Code. Value Is Defined By Carriers And May Not Follow The Same Standard. Not Recommended For Analysis.	1.37	Get Lookup Table
Distance	Coupon Distance	<0.005
DistanceGroup	Distance Group, in 500 Mile Intervals	<0.005	Get Lookup Table
Gateway	Gateway Indicator (1=Yes)	<0.005	Get Lookup Table
ItinGeoType	Itinerary Geography Type	<0.005	Get Lookup Table
CouponGeoType	Coupon Geography Type	<0.005	Get Lookup Table

Topics

Geography

Modes

Statistical Products

Tools and Apps

BTS Publications

Statistical Methods and Policies

About BTS