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.
To access the full sample data set on Snowflake, visit the ch-aviation profile on Snowflake Marketplace here.
| Sample File Name | Sample Description |
|---|---|
| capacities_scheduled.csv | Sample data for commercial aviation |
| 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 | Primary (combined)/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 | Primary (combined)/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 | Primary (combined)/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 |
| aircraft_iata | char(3) | Aircraft three character IATA code (ch-aviation assigns dummy IATA codes to types for which IATA has not designated a code) | Capacities - Scheduled | Primary (combined)/Foreign | Aircraft Codes/Aircraft Data | IATA |
| Aircraft IATA Description | varchar(255) | Aircraft IATA Description | Capacities - Scheduled | |||
| Economy Capacity | int(11) | Total number of Economy seats across all flights for the specified route, aircraft type, and day | Capacities - Scheduled | |||
| Economy Plus/Comfort Capacity | int(11) | Total number of Economy Plus/Comfort seats across all flights for the specified route, aircraft type, and day | Capacities - Scheduled | |||
| Premium Economy Capacity | int(11) | Total number of Premium Economy seats across all flights for the specified route, aircraft type, and day | Capacities - Scheduled | |||
| Business Capacity | int(11) | Total number of Business seats across all flights for the specified route, aircraft type, and day | Capacities - Scheduled | |||
| First Class Capacity | int(11) | Total number of First Class seats across all flights for the specified route, aircraft type, and day | Capacities - Scheduled | |||
| Total Capacity | int(11) | Total number of seats across all cabin classes for the specified route, aircraft type, and day | Capacities - Scheduled | |||
| Frequency | int(11) | Number of flights in a day | Capacities - Scheduled | |||
| ASM | bigint(20) | Available Seat Miles | Capacities - Scheduled | |||
| ASK | bigint(20) | Available Seat Kilometres | Capacities - Scheduled | |||
| Flight day | date | Date of the flight(s) | Capacities - Scheduled | Primary (combined) |