Metro Groups
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.
To access the full sample data set on Snowflake, visit the ch-aviation profile on Snowflake Marketplace here.
| Sample File Name | Sample Description |
|---|---|
| metro_groups.csv | Sample data |
| Column | Data Type | Data description | Package required | Key | Data Set | Join On |
|---|---|---|---|---|---|---|
| ID | int(11) | Unique ch-aviation created metro group ID | Airports | Primary | ||
| Metro_Group | char(3) | Metro Group IATA three-character code | Airports | Unique | ||
| Description | varchar(255) | Metro Group description | Airports | |||
| State Name | varchar(255) | State name | Airports | |||
| State ISO | char(2) | ISO 3166-2 Alpha-2 subdivision code (used for states) | Airports | Foreign | States | State ISO |
| Country Name | varchar(255) | Country name | Airports | |||
| Country ISO | char(2) | ISO 3166-1 Alpha-2 country code | Airports | Foreign | Countries | Country ISO |
| Airport Count | int(11) | Number of airports located in the metro group | Airports |