transtats logo
 
Advanced Search
Resources
Data Finder
By Mode
By Subject
Database Name: Airline Origin and Destination Survey (DB1B)
   Database Profile
All Rows Shown
Table NameDescription
Note: 1- Over time both the code and the name of a carrier may change and the same code or name may be assumed by a different airline. To ensure that you are analyzing data from the same airline, TranStats provides four airline-specific variables that identify one and only one carrier or its entity: Airline ID (AirlineID), Unique Carrier Code (UniqueCarrier), Unique Carrier Name (UniqueCarrierName), and Unique Entity (UniqCarrierEntity). A unique airline (carrier) is defined as one holding and reporting under the same DOT certificate regardless of its Code, Name, or holding company/corporation.
         2- Local traffic carried by ExpressJet Airlines is under represented from the 2nd quarter 2007 to the present.
DB1BCouponThis table provides coupon-specific information for each domestic itinerary of the Origin and Destination Survey, such as the operating carrier, origin and destination airports, number of passengers, fare class, coupon type, trip break indicator, and distance.
Table Profile Carrier Release Status Download
DB1BMarketThis table contains directional market characteristics of each domestic itinerary of the Origin and Destination Survey, such as the reporting carrier, origin and destination airport, prorated market fare, number of market coupons, market miles flown, and carrier change indicators.
Table Profile Carrier Release Status Download
DB1BTicketThis table contains summary characteristics of each domestic itinerary on the Origin and Destination Survey, including the reporting carrier, itinerary fare, number of passengers, originating airport, roundtrip indicator, and miles flown.
Table Profile Carrier Release Status Download
All Rows Shown