Metro Groups

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