USA Banner

Official US Government Icon

Official websites use .gov
A .gov website belongs to an official government organization in the United States.

Secure Site Icon

Secure .gov websites use HTTPS
A lock ( ) or https:// means you’ve safely connected to the .gov website. Share sensitive information only on official, secure websites.

Site Notification

Site Notification

U.S. Department of Transportation U.S. Department of Transportation Icon United States Department of Transportation United States Department of Transportation
BTS> TranStats
transtats logo
 
Advanced Search
Resources
Database Directory
Glossary
Upcoming Releases
Data Release History
Data Finder
By Mode
Aviation
Maritime
Highway
Transit
Rail
Pipeline
Bike/Pedestrian
Other
By Subject
Safety
Freight Transport
Passenger Travel
Infrastructure
Economic/Financial
Social/Demographic
Energy
Environment
National Security
Origin and Destination Survey : DB1BMarket
Latest Available Data: June 2024 Databases    Data Tables    Table Contents
Download Instructions
Filter Geography
 Filter Year
 Filter Period
      Prezipped File      % Missing in table         Documentation      Term     
Field NameDescriptionSupport Table
Itinerary ID
Market ID
Number of Coupons in the MarketGet Lookup Table
Year
Quarter (1-4)Get Lookup Table
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.Get Lookup Table
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.Get Lookup Table
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.Get Lookup Table
Origin Airport CodeGet Lookup Table
Origin Airport, Country Code
Origin Airport, State FIPS CodeGet Lookup Table
Origin Airport, State CodeGet Lookup Table
Origin State Name
Origin Airport, World Area CodeGet Lookup Table
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.Get Lookup Table
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.Get Lookup Table
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.Get Lookup Table
Destination Airport CodeGet Lookup Table
Destination Airport, Country Code
Destination Airport, State FIPS CodeGet Lookup Table
Destination Airport, State CodeGet Lookup Table
Destination State Name
Destination Airport, World Area CodeGet Lookup Table
Airport Group
World Area Code Group
Ticketing Carrier Change Indicator (1=Yes)Get Lookup Table
Ticketing Carrier Group
Operating Carrier Change Indicator (1=Yes)Get Lookup Table
Operating Carrier Group
Reporting Carrier CodeGet Lookup Table
Ticketing Carrier Code for On-line Itineraries (otherwise equal to 99)Get Lookup Table
Operating Carrier Code for On-line Itineraries (otherwise equals to 99)Get Lookup Table
Bulk Fare Indicator (1=Yes)Get Lookup Table
Number of Passengers
Market Fare (ItinYield*MktMilesFlown)
Market Distance (Including Ground Transport)
Distance Group, in 500 Mile IntervalsGet Lookup Table
Market Miles Flown (Track Miles)
Non-Stop Market Miles (Using Radian Measure)
Itinerary Geography TypeGet Lookup Table
Market Geography TypeGet Lookup Table