Capacities – Scheduled
To access the full sample data set on Amazon Web Services manually or programmatically, the S3 bucket URLs are provided here.
To get user name and password for manual access or access key and secret key for programmatic access, contact sales@ch-aviation.com.
| Column | Data Type | Data description | Package | Key | Data Set | Join On |
|---|---|---|---|---|---|---|
| Operator Name | varchar(255) | Operator name | Commercial Aviation Operator Capacity Data | |||
| Operator ch-a Code | varchar(5) | Operator ch-aviation code (assigned by ch-aviation). Operator ch-aviation codes can be 2, 3, or 5 characters. | Capacities - Scheduled | Foreign | Operators | Operator ch-a Code |
| 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) | Origin airport 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 stable airport ID | 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 the day | Commercial Aviation Operator Capacity Data | |||
| Flight day | date | Date of the flight(s) | Capacities - Scheduled |