RITA > BTS
 
transtats logo
 
Advanced Search
Resources
Data Tools
: DB1BMarket
   Database Profile   Data Tables   Table Profile
Latest Available Data: June 2014All Rows Shown
Field NameDescription
ItinIDItinerary ID 
MktIDMarket ID 
MktCouponsNumber of Coupons in the MarketAnalysis
YearYear 
QuarterQuarter (1-4)Analysis
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
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
AirportGroupAirport Group 
WacGroupWorld Area Code Group 
TkCarrierChangeTicketing Carrier Change Indicator (1=Yes)Analysis
TkCarrierGroupTicketing Carrier Group 
OpCarrierChangeOperating Carrier Change Indicator (1=Yes)Analysis
OpCarrierGroupOperating Carrier Group 
RPCarrierReporting Carrier CodeAnalysis
TkCarrierTicketing Carrier Code for On-line Itineraries (otherwise equal to 99) 
OpCarrierOperating Carrier Code for On-line Itineraries (otherwise equals to 99) 
BulkFareBulk Fare Indicator (1=Yes) 
PassengersNumber of PassengersAnalysis
MktFareMarket Fare (ItinYield*MktMilesFlown) 
MktDistanceMarket Distance (Including Ground Transport) 
MktDistanceGroupDistance Group, in 500 Mile IntervalsAnalysis
MktMilesFlownMarket Miles Flown (Track Miles) 
NonStopMilesNon-Stop Market Miles (Using Radian Measure) 
ItinGeoTypeItinerary Geography TypeAnalysis
MktGeoTypeMarket Geography TypeAnalysis
All Rows Shown



BTS's privacy policies and procedures do not necessarily apply to external web sites.
We suggest contacting these sites directly for information on their data collection and distribution policies.