Operator Financial 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.
| Sample File Name | Sample Description |
|---|---|
| operator_financial_figures.csv | Sample data for commercial aviation |
| Column | Data Type | Data description | Package required | Key | Data Set | Join On |
|---|---|---|---|---|---|---|
| Operator Name | varchar(255) | Operator name | Operator Financial Figures | |||
| 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. | Operator Financial Figures | Primary | Operators | Operator ch-a Code |
| Financial Year | int(4) | Financial Year | Operator Financial Figures | Primary | ||
| Currency Code | char(3) | Currency ISO 4217 code | Operator Financial Figures | Foreign | Currencies | Currency Code |
| Passenger Revenue | bigint(20) | Passenger revenue | Operator Financial Figures | |||
| Cargo Revenue | bigint(20) | Cargo revenue | Operator Financial Figures | |||
| Other Revenue | bigint(20) | Other revenue | Operator Financial Figures | |||
| Total Revenue | bigint(20) | Total revenue | Operator Financial Figures | |||
| Operating Profit | bigint(20) | Operating profit | Operator Financial Figures | |||
| Net Profit | bigint(20) | Net profit | Operator Financial Figures | |||
| Employee | int(11) | Number of employees | Operator Financial Figures | |||
| Year End Date | date | Financial Year Ende Date | Operator Financial Figures | |||
| Data Source | varchar(255) | Data source description | Operator Financial Figures | |||
| Data Source URL | text | Data source URL | Operator Financial Figures | |||
| Comment | text | Free text remarks | Operator Financial Figures |