Airports

Column Data Type Data description Package required Key Data Set Join On
ID int(11) Unique ch-aviation created state ID Airports Primary    
Country ISO char(2) ISO 3166-1 Alpha-2 country code Airports Unique/Foreign Countries Country ISO
Country Name varchar(255) Country name Airports      
State ISO char(2) ISO 3166-2 Alpha-2 subdivision code (used for states) Airports Unique    
State Name varchar(255) State name Airports