| 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 |
|
|
|
