Do you also provide an API?

ch-aviation can provide the data feeds to you directly via file transfer protocol (FTP), safe file transfer protocol (SFTP) or a shared Amazon Web Services (AWS) S3 bucket.

Which delivery formats you support?

The data is provided as Comma-separated values (.csv) flat files. Optionally we can provide them as Microsoft Excel (.xlsx) or XML (.xml)

How often does data get updated?

The ch-aviation database is updated in batches to ensure all data flows through ch-aviation’s semi-automated quality assurance process built to maximise data integrity. As a result, the data set remains relatively static in the ch-aviation production database, for most data sets for a week or month at a time. Therefore, the most efficient integration option is the transfer of flat files provided for integration into your own applications in various formats.

Operator Passenger Figures - ch-aviation

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