Operator Name | varchar(255) | Operator name | Commercial Aviation Operator Capacity Data | | | |
Origin | varchar(255) | Origin airport Display Name (combination of City Name and Origin airport Name) | Commercial Aviation Operator Capacity Data | | | |
Origin IATA Code | char(3) | Origin airport three character IATA code | Commercial Aviation Operator Capacity Data | | | |
Origin Airport ID | int(11) | Numeric stable airport ID | Commercial Aviation Operator Capacity Data | Foreign | Airports | Airport ID |
Origin Continent | varchar(6) | Origin airport ch-aviation code (not a stable ID, IATA code if available, otherwise ICAO, otherwise alternative code) | Commercial Aviation Operator Capacity Data | | | |
Origin Subdivision | varchar(255) | Origin State name | Commercial Aviation Operator Capacity Data | | | |
Origin Subdivision ISO Code | char(2) | Origin ISO 3166-2 Alpha-2 subdivision code (used for states) | Commercial Aviation Operator Capacity Data | Foreign | States | State ISO |
Origin Metro Group | varchar(255) | Origin Metro Group name | Commercial Aviation Operator Capacity Data | | | |
Origin Metro Group Code | char(3) | Origin Metro Group three character IATA code | Commercial Aviation Operator Capacity Data | Foreign | Metro Groups | Metro_Group |
Origin Country | varchar(255) | Origin Country name | Commercial Aviation Operator Capacity Data | | | |
Origin Country ISO | char(2) | Origin ISO 3166-1 Alpha-2 country code | Commercial Aviation Operator Capacity Data | Foreign | Countries | Country ISO |
Destination | varchar(255) | Destination airport Display Name (combination of City Name and Destination airport Name) | Commercial Aviation Operator Capacity Data | | | |
Destination IATA Code | char(3) | Destination airport three character IATA code | Commercial Aviation Operator Capacity Data | | | |
Destination Airport ID | char(4) | Destination airport four character ICAO code | Commercial Aviation Operator Capacity Data | Foreign | Airports | Airport ID |
Destination Continent | varchar(6) | Destination airport ch-aviation code (not a stable ID, IATA code if available, otherwise ICAO, otherwise alternative code) | Commercial Aviation Operator Capacity Data | | | |
Destination Subdivision | varchar(255) | Destination State name | Commercial Aviation Operator Capacity Data | | | |
Destination Subdivision ISO Code | char(2) | Destination ISO 3166-2 Alpha-2 subdivision code (used for states) | Commercial Aviation Operator Capacity Data | Foreign | States | State ISO |
Destination Metro Group | varchar(255) | Destination Metro Group name | Commercial Aviation Operator Capacity Data | | | |
Destination Metro Group Code | char(3) | Destination Metro Group three character IATA code | Commercial Aviation Operator Capacity Data | Foreign | Metro Groups | Metro_Group |
Destination Country | varchar(255) | Destination Country name | Commercial Aviation Operator Capacity Data | | | |
Destination Country ISO | char(2) | Destination ISO 3166-1 Alpha-2 country code | Commercial Aviation Operator Capacity Data | Foreign | Countries | Country ISO |
Capacity | int(11) | Sum of total seats for the route and week | Commercial Aviation Operator Capacity Data | | | |