Capacities – Scheduled

ColumnData TypeData descriptionPackageKeyData SetJoin On
Operator Namevarchar(255)Operator nameCommercial Aviation Operator Capacity Data
Originvarchar(255)Origin airport Display Name (combination of City Name and Origin airport Name)Commercial Aviation Operator Capacity Data
Origin IATA Codechar(3)Origin airport three character IATA codeCommercial Aviation Operator Capacity Data
Origin Airport IDint(11)Numeric stable airport IDCommercial Aviation Operator Capacity DataForeignAirportsAirport ID
Origin Continentvarchar(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 Subdivisionvarchar(255)Origin State nameCommercial Aviation Operator Capacity Data
Origin Subdivision ISO Codechar(2)Origin ISO 3166-2 Alpha-2 subdivision code (used for states)Commercial Aviation Operator Capacity DataForeignStatesState ISO
Origin Metro Groupvarchar(255)Origin Metro Group nameCommercial Aviation Operator Capacity Data
Origin Metro Group Codechar(3)Origin Metro Group three character IATA codeCommercial Aviation Operator Capacity DataForeignMetro GroupsMetro_Group
Origin Countryvarchar(255)Origin Country nameCommercial Aviation Operator Capacity Data
Origin Country ISOchar(2)Origin ISO 3166-1 Alpha-2 country codeCommercial Aviation Operator Capacity DataForeignCountriesCountry ISO
Destinationvarchar(255)Destination airport Display Name (combination of City Name and Destination airport Name)Commercial Aviation Operator Capacity Data
Destination IATA Codechar(3)Destination airport three character IATA codeCommercial Aviation Operator Capacity Data
Destination Airport IDchar(4)Destination airport four character ICAO codeCommercial Aviation Operator Capacity DataForeignAirportsAirport ID
Destination Continentvarchar(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 Subdivisionvarchar(255)Destination State nameCommercial Aviation Operator Capacity Data
Destination Subdivision ISO Codechar(2)Destination ISO 3166-2 Alpha-2 subdivision code (used for states)Commercial Aviation Operator Capacity DataForeignStatesState ISO
Destination Metro Groupvarchar(255)Destination Metro Group nameCommercial Aviation Operator Capacity Data
Destination Metro Group Codechar(3)Destination Metro Group three character IATA codeCommercial Aviation Operator Capacity DataForeignMetro GroupsMetro_Group
Destination Countryvarchar(255)Destination Country nameCommercial Aviation Operator Capacity Data
Destination Country ISOchar(2)Destination ISO 3166-1 Alpha-2 country codeCommercial Aviation Operator Capacity DataForeignCountriesCountry ISO
Capacityint(11)Sum of total seats for the route and weekCommercial Aviation Operator Capacity Data