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 : DB1BCoupon
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
Coupon Sequence Number
Number of Coupons in the ItineraryGet Lookup Table
Year
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
Quarter (1-4)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
Trip Break CodeGet Lookup Table
Coupon Type CodeGet Lookup Table
Ticketing Carrier CodeGet Lookup Table
Operating Carrier CodeGet Lookup Table
Reporting Carrier CodeGet Lookup Table
Number of Passengers
Fare Class Code. Value Is Defined By Carriers And May Not Follow The Same Standard. Not Recommended For Analysis.Get Lookup Table
Coupon Distance
Distance Group, in 500 Mile IntervalsGet Lookup Table
Gateway Indicator (1=Yes)Get Lookup Table
Itinerary Geography TypeGet Lookup Table
Coupon Geography TypeGet Lookup Table