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 | Capacities - Scheduled | |||
| 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 Airport Name) | Capacities - Scheduled | |||
| Origin IATA Code | char(3) | Origin airport three character IATA code | Capacities - Scheduled | |||
| Origin Airport ID | int(11) | Origin airport stable airport ID | Capacities - Scheduled | Primary (combined)/Foreign | Airports | Airport ID |
| Origin Continent | varchar(255) | Origin airport continent name | Capacities - Scheduled | |||
| Origin Subdivision | varchar(255) | Origin airport state name | Capacities - Scheduled | |||
| Origin Subdivision ISO Code | char(2) | Origin ISO 3166-2 Alpha-2 subdivision code (used for states) | Capacities - Scheduled | Foreign | States | State ISO |
| Origin Metro Group | varchar(255) | Origin airport Metro Group name | Capacities - Scheduled | |||
| Origin Metro Group Code | char(3) | Origin Metro Group three character IATA code | Capacities - Scheduled | Foreign | Metro Groups | Metro_Group |
| Origin Country | varchar(255) | Origin airport country name | Capacities - Scheduled | |||
| Origin Country ISO | char(2) | Origin airport ISO 3166-1 Alpha-2 country code | Capacities - Scheduled | Foreign | Countries | Country ISO |
| Destination | varchar(255) | Destination airport display name (combination of City Name and Airport Name) | Capacities - Scheduled | |||
| Destination IATA Code | char(3) | Destination airport three character IATA code | Capacities - Scheduled | |||
| Destination Airport ID | char(4) | Destination airport stable airport ID | Capacities - Scheduled | Primary (combined)/Foreign | Airports | Airport ID |
| Destination Continent | varchar(255) | Destination airport continent name | Capacities - Scheduled | |||
| Destination Subdivision | varchar(255) | Destination airport state name | Capacities - Scheduled | |||
| Destination Subdivision ISO Code | char(2) | Destination ISO 3166-2 Alpha-2 subdivision code (used for states) | Capacities - Scheduled | Foreign | States | State ISO |
| Destination Metro Group | varchar(255) | Destination airport Metro Group name | Capacities - Scheduled | |||
| Destination Metro Group Code | char(3) | Destination Metro Group three character IATA code | Capacities - Scheduled | Foreign | Metro Groups | Metro_Group |
| Destination Country | varchar(255) | Destination airport country name | Capacities - Scheduled | |||
| Destination Country ISO | char(2) | Destination airport ISO 3166-1 Alpha-2 country code | Capacities - Scheduled | 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 | 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 for the route, operator and aircraft type. | Capacities - Scheduled | |||
| ASM | bigint(20) | Available Seat Miles: seats x flights x great-circle distance in statute miles. | Capacities - Scheduled | |||
| ASK | bigint(20) | Available Seat Kilometres (ASM x 1.60934, rounded). | Capacities - Scheduled | |||
| Flight day | date | Date of the flight(s) | Capacities - Scheduled | Primary (combined) |