Operator Passenger Figures
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 Seat Kilometres | | | |
RPM | bigint(20) unsigned | Revenue Seat 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 | | | |