When foreign citizens enter the US, they arrive at aUS Port of Entry(PoE), each of the locations are designated with 3 letter codes. After arrival, all of them go throughUS Port of Entry Proceduresat PoE,CBP Officer Stamps their passportwith the visa type they are entering in and lets ...
Therefore, I opted to take the i94port field as this was likely to be more accurate and render a larger final dataset of valid arrivals. I then joined this with the local_code field on the airport_codes dataset to provide an arrival state code for each of the records in the data set...