RITA > BTS
 
transtats logo
 
Advanced Search
Resources
Data Tools
: DB1BTicket
   Database Profile   Data Tables   Table Profile
Latest Available Data: March 2014All Rows Shown
Field NameDescription
ItinIDItinerary ID 
CouponsNumber of Coupons in the ItineraryAnalysis
YearYear 
QuarterQuarter (1-4)Analysis
OriginOrigin Airport CodeAnalysis
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
OriginCountryOrigin Airport, Country 
OriginStateFipsOrigin Airport, State FIPSAnalysis
OriginStateOrigin Airport, StateAnalysis
OriginStateNameOrigin State Name 
OriginWacOrigin Airport, World Area CodeAnalysis
RoundTripRound Trip Indicator (1=Yes)Analysis
OnLineSingle Carrier Indicator (1=Yes)Analysis
DollarCredDollar Credibility IndicatorAnalysis
FarePerMileItinerary Fare Per Miles Flown in Dollars (ItinFare/MilesFlown). 
RPCarrierReporting CarrierAnalysis
PassengersNumber of PassengersAnalysis
ItinFareItinerary Fare Per Person 
BulkFareBulk Fare Indicator (1=Yes) 
DistanceItinerary Distance (Including Ground Transport) 
DistanceGroupDistance Group, in 500 Mile IntervalsAnalysis
MilesFlownItinerary Miles Flown (Track Miles) 
ItinGeoTypeItinerary 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.