States

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