Operator Passenger Figures
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 | Key | Data Set | Join On |
|---|---|---|---|---|---|
| Operator Name | varchar(255) | Operator name | |||
| 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. | Primary (combined)/foreign | Operators | Operator ch-a Code |
| Financial Year | int(10) unsigned | Financial Year | Primary (combined) | ||
| Financial Month | int(10) unsigned | Financial Month | Primary (combined) | ||
| Financial Quarter | int(10) unsigned | Financial Quarter | Primary (combined) | ||
| Financial Half | int(10) unsigned | Financial Half | Primary (combined) | ||
| Passengers | bigint(20) unsigned | Number of passengers | |||
| ASK | bigint(20) unsigned | Available Seat Kilometres | |||
| ASM | bigint(20) unsigned | Available Seat Miles | |||
| RPK | bigint(20) unsigned | Revenue Passenger Kilometres | |||
| RPM | bigint(20) unsigned | Revenue Passenger Miles | |||
| Year End Date | date | Financial Year Ende Date | |||
| Data Source | varchar(255) | Data source description | |||
| Data Source URL | text | Data source URL | |||
| Comment | text | Free text remarks |