Field | Type | Description | Example |
---|
YEAR | NUMBER | Travel year | 2022 |
MONTH | NUMBER | Travel month | 9 |
O_COUNTRY | VARCHAR(2) | Origin country code | US |
D_COUNTRY | VARHCAR(2) | Destination country code | NE |
O_CITY | VARCHAR(3) | Origin city code | NYC |
D_CITY | VARCHAR(3) | Destination city code | NIM |
ORG | VARCHAR(3) | IATA airport code of the trip origin | JFK |
DST | VARCHAR(3) | IATA airport code of the trip destination | NIM |
CNX1 | VARCHAR(3) | IATA airport code of the first connecting point, if any. | CDG |
CNX2 | VARCHAR(3) | IATA airport code of the second connecting point, if any. | |
DOM_MKT_AL | VARCHAR(3) | Dominant marketing airline code | DL |
MKT_AL1 | VARCHAR(3) | IATA code of the marketing airline on the first segment | DL |
MKT_AL2 | VARCHAR(3) | IATA code of the marketing airline on the second segment, if any | AF |
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 | DL |
OPT_AL1 | VARCHAR(3) | IATA code of the operating airline on the first segment | DL |
OPT_AL2 | VARCHAR(3) | IATA code of the operating airline on the second segment, if any | AF |
OPT_AL3 | VARCHAR(3) | IATA code of the operating airline on the third segment, if any | |
PAX | NUMBER | Number of passengers | 30 |
FARE_USD | NUMBER | Net fare in USD to airlines | 1331 |