Countries
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 | Package required | Key | Data Set | Join On |
---|---|---|---|---|---|---|
ID | int(11) | Unique ch-aviation created country ID | Airports | Primary | ||
Country ISO | char(2) | ISO 3166-1 Alpha-2 country code | Airports | Unique | ||
Country Name | varchar(255) | Country name | Airports | |||
Continent | varchar(255) | Continent name | Airports | |||
Registration | varchar(255) | Aircraft registration prefix(es) for the country | Airports | |||
IASAWS | char(1) | Country International Aviation Safety Assessment program status (assigned by FAA): 0 – not assessed / 1 – Category 1 (meets ICAO standards) / 2 – Category 2 (does not meet ICAO standards) | Airports | |||
GDPR Country | char(3) | European Union country where GDPR regulations apply: Yes / No / (NULL) | Airports |