| Field | Type | Description | Example |
|---|
| YYMM | VARCHAR(4) | Travel year and month | 2101 |
| ORG | VARCHAR(3) | IATA airport code of the trip origin | JFK |
| DST | VARCHAR(3) | IATA airport code of the trip destination | SLC |
| STATION2 | VARCHAR(3) | IATA airport code of the first connecting point, if any. Otherwise, it’s the same as the DST field. | SFO |
| STATION3 | VARCHAR(3) | IATA airport code of the second connecting point, if any. Empty if there is no connection point or the same as the DST field if there is only one connection point. | SLC |
| STATION4 | VARCHAR(3) | Empty if there are one or fewer connection points. Otherwise, it’s the same as the DST field. | |
| DOM_MKT_AL | VARCHAR(3) | Dominant marketing airline code | AA |
| MKT_AL1 | VARCHAR(3) | IATA code of the marketing airline on the first segment | AA |
| MKT_AL2 | VARCHAR(3) | IATA code of the marketing airline on the second segment, if any | AA |
| MKT_AL3 | VARCHAR(3) | IATA code of the marketing airline on the third segment, if any | |
| DOM_OPT_AL | VARCHAR(3) | Dominant operating airline code | AA |
| OPT_AL1 | VARCHAR(3) | IATA code of the operating airline on the first segment | AA |
| OPT_AL2 | VARCHAR(3) | IATA code of the operating airline on the second segment, if any | OO |
| OPT_AL3 | VARCHAR(3) | IATA code of the operating airline on the third segment, if any | |
| DOM_PARENT_AL | VARCHAR(3) | Parent carrier of the dominant operating carrier | AA |
| PARENT_AL1 | VARCHAR(3) | Parent carrier of the operating airline on the first segment | AA |
| PARENT_AL2 | VARCHAR(3) | Parent carrier of the operating airline on the second segment, if any | AS |
| PARENT_AL3 | VARCHAR(3) | Parent carrier of the operating airline on the third segment, if any | |
| RPT_CARRIER | VARCHAR(3) | IATA code of the reported carrier in the DB1B raw data, if applied | AA |
| PAX | DOUBLE | Number of passengers | 30 |
| PAX_PER_DAY | DOUBLE | Number of average passengers per day | 0.97 |
| PAX_PER_DAY_RAW | DOUBLE | Number of passengers per day in the raw DB1B data | 0.91 |
| FARE | DOUBLE | Net fare in USD to airlines | 228.28 |
| GROSS_FARE | DOUBLE | Gross fare/Payment in USD, including taxes and fees | 251.11 |
| LEGS | NUMBER | Number of flight legs in the itinerary | 2 |
| OWAC | NUMBER | WAC code of the origin | 22 |
| DWAC | NUMBER | WAC code of the destination | 87 |
| OD_MILES | DOUBLE | Miles between trip origin and trip destination | 1984 |
| CIRCUITY | DOUBLE | Circuity of the trip (total segment miles / direct OD miles) | 1.605 |
| DI | VARCHAR(1) | Domestic or international | D |
| POO | VARCHAR(3) | IATA airport code of the point of origin | JFK |
| SOURCE | VARCHAR(8) | Source of the data | DB1B_raw |
| LOAD_DATE | DATE | Date when the data is produced | 2021-07-10 |
| TYPE | VARCHAR(10) | Data status: Interim, Near-Final, or Final | Final |
