BACKGROUND |
| The data contained in the compressed file has been extracted from the
DB1BCoupon data table of the "Origin and Destination Survey" database from the TranStats data library.
The time period is indicated in the name of the compressed file;
for example, XXX_XXXXX_2001_1 contains data of the first quarter of the year 2001. |
| |
RECORD LAYOUT |
| Below are fields in the order that they appear on the records: |
| ItinID | Itinerary ID |
| MktID | Market ID |
| SeqNum | Coupon Sequence Number |
| Coupons | Number of Coupons in the Itinerary |
| Year | Year |
| OriginAirportID | 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. |
| OriginAirportSeqID | 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. |
| OriginCityMarketID | 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. |
| Quarter | Quarter (1-4) |
| Origin | Origin Airport Code |
| OriginCountry | Origin Airport, Country Code |
| OriginStateFips | Origin Airport, State FIPS Code |
| OriginState | Origin Airport, State Code |
| OriginStateName | Origin State Name |
| OriginWac | Origin Airport, World Area Code |
| DestAirportID | 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. |
| DestAirportSeqID | 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. |
| DestCityMarketID | 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. |
| Dest | Destination Airport Code |
| DestCountry | Destination Airport, Country Code |
| DestStateFips | Destination Airport, State FIPS Code |
| DestState | Destination Airport, State Code |
| DestStateName | Destination State Name |
| DestWac | Destination Airport, World Area Code |
| Break | Trip Break Code |
| CouponType | Coupon Type Code |
| TkCarrier | Ticketing Carrier Code |
| OpCarrier | Operating Carrier Code |
| RPCarrier | Reporting Carrier Code |
| Passengers | Number of Passengers |
| FareClass | Fare Class Code. Value Is Defined By Carriers And May Not Follow The Same Standard. Not Recommended For Analysis. |
| Distance | Coupon Distance |
| DistanceGroup | Distance Group, in 500 Mile Intervals |
| Gateway | Gateway Indicator (1=Yes) |
| ItinGeoType | Itinerary Geography Type |
| CouponGeoType | Coupon Geography Type |