EDA_004_local_extract_i94_lookup_from_sas.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {
    "editable": true
   },
   "source": [
    "Objective: given the `I94_SAS_Labels_Descriptions.SAS` text file, programmatically create CSV lookup tables. Given the small dataset, we can do this with just Pandas (no Spark required).\n",
    "\n",
    "* lookup_i94cntyl.csv\n",
    "* lookup_i94port.csv\n",
    "* lookup_i94mode.csv\n",
    "* lookup_i94addr.csv\n",
    "* lookup_i94visa.csv\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "editable": true
   },
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "import json\n",
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "editable": true
   },
   "outputs": [],
   "source": [
    "INPUT_PATH = 'raw_input_data/i94_proc_format_code_sas/I94_SAS_Labels_Descriptions.SAS'\n",
    "OUTPUT_DIR = 'raw_input_data/i94_lookup_csv'\n",
    "\n",
    "OUTPUT_PATH_LKUP_I94CNTYL = f\"{OUTPUT_DIR}/lookup_i94cntyl.csv\"\n",
    "OUTPUT_PATH_LKUP_I94PORT = f\"{OUTPUT_DIR}/lookup_i94port.csv\"\n",
    "OUTPUT_PATH_LKUP_I94MODE = f\"{OUTPUT_DIR}/lookup_i94mode.csv\"\n",
    "OUTPUT_PATH_LKUP_I94ADDR = f\"{OUTPUT_DIR}/lookup_i94addr.csv\"\n",
    "OUTPUT_PATH_LKUP_I94VISA = f\"{OUTPUT_DIR}/lookup_i94visa.csv\""
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "editable": true
   },
   "source": [
    "# Utility Functions"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "editable": true
   },
   "outputs": [],
   "source": [
    "def txt_to_list(txt_path):\n",
    "    with open(txt_path) as f:\n",
    "        lines = f.readlines()     \n",
    "    return np.asarray(lines)\n",
    "\n",
    "\n",
    "def subset_lookup_lines(\n",
    "    np_array,\n",
    "    lookup_title: str,\n",
    "    start_str: str,\n",
    "    start_pos_offset: int,\n",
    "    end_str: str,\n",
    "    end_pos_offset: int):\n",
    "    \n",
    "    start_pos, end_pos = None, None\n",
    "    for idx, line in enumerate(np_array):\n",
    "        #print(line)\n",
    "        if line == start_str:\n",
    "            start_pos = idx + start_pos_offset   \n",
    "            break\n",
    "            \n",
    "    for idx, line in enumerate(np_array[start_pos:]):            \n",
    "        if line == end_str:\n",
    "            end_pos = start_pos + idx + end_pos_offset\n",
    "            break\n",
    "        \n",
    "    return {\n",
    "        \"lookup_title\": lookup_title,\n",
    "        \"start_pos\": start_pos,\n",
    "        \"end_pos\": end_pos,\n",
    "        \"subset\": np_array[start_pos:end_pos].copy()\n",
    "    }\n",
    "\n",
    "\n",
    "def array_to_df(np_array, numeric_key=True, sort_by='key'):\n",
    "    lookup_list = []\n",
    "    for idx, line in enumerate(np_array):\n",
    "        left_right = line.split(\"=\")\n",
    "        left, right = left_right[0], left_right[1]\n",
    "        if numeric_key:\n",
    "            key = int(left.strip())\n",
    "        else:\n",
    "            key = left.strip().replace(\"'\", \"\").strip()\n",
    "        value = right.strip().replace(\"'\", \"\").replace(\";\", \"\").replace(\"\\n\", \"\").strip()\n",
    "        lookup_list.append({\n",
    "            \"key\": key,\n",
    "            \"value\": value\n",
    "        })\n",
    "    \n",
    "    df = pd.DataFrame(lookup_list).sort_values(by=sort_by)\n",
    "    return df\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "editable": true
   },
   "source": [
    "# Read SAS Proc Format text file into a list of text lines"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "editable": true
   },
   "outputs": [],
   "source": [
    "lines = txt_to_list('raw_input_data/i94_proc_format_code_sas/I94_SAS_Labels_Descriptions.SAS')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "editable": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[\"libname library 'Your file location' ;\\n\",\n",
       " 'proc format library=library ;\\n',\n",
       " '\\n',\n",
       " '/* I94YR - 4 digit year */\\n',\n",
       " '\\n',\n",
       " '/* I94MON - Numeric month */\\n',\n",
       " '\\n',\n",
       " '/* I94CIT & I94RES - This format shows all the valid and invalid codes for processing */\\n',\n",
       " '  value i94cntyl\\n',\n",
       " \"   582 =  'MEXICO Air Sea, and Not Reported (I-94, no land arrivals)'\\n\",\n",
       " \"   236 =  'AFGHANISTAN'\\n\",\n",
       " \"   101 =  'ALBANIA'\\n\",\n",
       " \"   316 =  'ALGERIA'\\n\",\n",
       " \"   102 =  'ANDORRA'\\n\",\n",
       " \"   324 =  'ANGOLA'\\n\",\n",
       " \"   529 =  'ANGUILLA'\\n\",\n",
       " \"   518 =  'ANTIGUA-BARBUDA'\\n\",\n",
       " \"   687 =  'ARGENTINA '\\n\",\n",
       " \"   151 =  'ARMENIA'\\n\",\n",
       " \"   532 =  'ARUBA'\\n\",\n",
       " \"   438 =  'AUSTRALIA'\\n\",\n",
       " \"   103 =  'AUSTRIA'\\n\",\n",
       " \"   152 =  'AZERBAIJAN'\\n\",\n",
       " \"   512 =  'BAHAMAS'\\n\",\n",
       " \"   298 =  'BAHRAIN'\\n\",\n",
       " \"   274 =  'BANGLADESH'\\n\",\n",
       " \"   513 =  'BARBADOS'\\n\",\n",
       " \"   104 =  'BELGIUM'\\n\",\n",
       " \"   581 =  'BELIZE'\\n\",\n",
       " \"   386 =  'BENIN'\\n\",\n",
       " \"   509 =  'BERMUDA'\\n\",\n",
       " \"   153 =  'BELARUS'\\n\",\n",
       " \"   242 =  'BHUTAN'\\n\",\n",
       " \"   688 =  'BOLIVIA'\\n\",\n",
       " \"   717 =  'BONAIRE, ST EUSTATIUS, SABA' \\n\",\n",
       " \"   164 =  'BOSNIA-HERZEGOVINA'\\n\",\n",
       " \"   336 =  'BOTSWANA'\\n\",\n",
       " \"   689 =  'BRAZIL'\\n\",\n",
       " \"   525 =  'BRITISH VIRGIN ISLANDS'\\n\",\n",
       " \"   217 =  'BRUNEI'\\n\",\n",
       " \"   105 =  'BULGARIA'\\n\",\n",
       " \"   393 =  'BURKINA FASO'\\n\",\n",
       " \"   243 =  'BURMA'\\n\",\n",
       " \"   375 =  'BURUNDI'\\n\",\n",
       " \"   310 =  'CAMEROON'\\n\",\n",
       " \"   326 =  'CAPE VERDE'\\n\",\n",
       " \"   526 =  'CAYMAN ISLANDS'\\n\",\n",
       " \"   383 =  'CENTRAL AFRICAN REPUBLIC'\\n\",\n",
       " \"   384 =  'CHAD'\\n\",\n",
       " \"   690 =  'CHILE'\\n\",\n",
       " \"   245 =  'CHINA, PRC'\\n\",\n",
       " \"   721 =  'CURACAO' \\n\",\n",
       " \"   270 =  'CHRISTMAS ISLAND'\\n\",\n",
       " \"   271 =  'COCOS ISLANDS'\\n\",\n",
       " \"   691 =  'COLOMBIA'\\n\",\n",
       " \"   317 =  'COMOROS'\\n\",\n",
       " \"   385 =  'CONGO'\\n\",\n",
       " \"   467 =  'COOK ISLANDS'\\n\",\n",
       " \"   575 =  'COSTA RICA'\\n\",\n",
       " \"   165 =  'CROATIA'\\n\",\n",
       " \"   584 =  'CUBA'\\n\",\n",
       " \"   218 =  'CYPRUS'\\n\",\n",
       " \"   140 =  'CZECH REPUBLIC'\\n\",\n",
       " \"   723 =  'FAROE ISLANDS (PART OF DENMARK)'  \\n\",\n",
       " \"   108 =  'DENMARK'\\n\",\n",
       " \"   322 =  'DJIBOUTI'\\n\",\n",
       " \"   519 =  'DOMINICA'\\n\",\n",
       " \"   585 =  'DOMINICAN REPUBLIC'\\n\",\n",
       " \"   240 =  'EAST TIMOR'\\n\",\n",
       " \"   692 =  'ECUADOR'\\n\",\n",
       " \"   368 =  'EGYPT'\\n\",\n",
       " \"   576 =  'EL SALVADOR'\\n\",\n",
       " \"   399 =  'EQUATORIAL GUINEA'\\n\",\n",
       " \"   372 =  'ERITREA'\\n\",\n",
       " \"   109 =  'ESTONIA'\\n\",\n",
       " \"   369 =  'ETHIOPIA'\\n\",\n",
       " \"   604 =  'FALKLAND ISLANDS'\\n\",\n",
       " \"   413 =  'FIJI'\\n\",\n",
       " \"   110 =  'FINLAND'\\n\",\n",
       " \"   111 =  'FRANCE'\\n\",\n",
       " \"   601 =  'FRENCH GUIANA'\\n\",\n",
       " \"   411 =  'FRENCH POLYNESIA'\\n\",\n",
       " \"   387 =  'GABON'\\n\",\n",
       " \"   338 =  'GAMBIA'\\n\",\n",
       " \"   758 =  'GAZA STRIP' \\n\",\n",
       " \"   154 =  'GEORGIA'\\n\",\n",
       " \"   112 =  'GERMANY'\\n\",\n",
       " \"   339 =  'GHANA'\\n\",\n",
       " \"   143 =  'GIBRALTAR'\\n\",\n",
       " \"   113 =  'GREECE'\\n\",\n",
       " \"   520 =  'GRENADA'\\n\",\n",
       " \"   507 =  'GUADELOUPE'\\n\",\n",
       " \"   577 =  'GUATEMALA'\\n\",\n",
       " \"   382 =  'GUINEA'\\n\",\n",
       " \"   327 =  'GUINEA-BISSAU'\\n\",\n",
       " \"   603 =  'GUYANA'\\n\",\n",
       " \"   586 =  'HAITI'\\n\",\n",
       " \"   726 =  'HEARD AND MCDONALD IS.'\\n\",\n",
       " \"   149 =  'HOLY SEE/VATICAN'\\n\",\n",
       " \"   528 =  'HONDURAS'\\n\",\n",
       " \"   206 =  'HONG KONG'\\n\",\n",
       " \"   114 =  'HUNGARY'\\n\",\n",
       " \"   115 =  'ICELAND'\\n\",\n",
       " \"   213 =  'INDIA'\\n\",\n",
       " \"   759 =  'INDIAN OCEAN AREAS (FRENCH)' \\n\",\n",
       " \"   729 =  'INDIAN OCEAN TERRITORY' \\n\",\n",
       " \"   204 =  'INDONESIA'\\n\",\n",
       " \"   249 =  'IRAN'\\n\",\n",
       " \"   250 =  'IRAQ'\\n\",\n",
       " \"   116 =  'IRELAND'\\n\",\n",
       " \"   251 =  'ISRAEL'\\n\",\n",
       " \"   117 =  'ITALY'\\n\",\n",
       " \"   388 =  'IVORY COAST'\\n\",\n",
       " \"   514 =  'JAMAICA'\\n\",\n",
       " \"   209 =  'JAPAN'\\n\",\n",
       " \"   253 =  'JORDAN'\\n\",\n",
       " \"   201 =  'KAMPUCHEA'\\n\",\n",
       " \"   155 =  'KAZAKHSTAN'\\n\",\n",
       " \"   340 =  'KENYA'\\n\",\n",
       " \"   414 =  'KIRIBATI'\\n\",\n",
       " \"   732 =  'KOSOVO' \\n\",\n",
       " \"   272 =  'KUWAIT'\\n\",\n",
       " \"   156 =  'KYRGYZSTAN'\\n\",\n",
       " \"   203 =  'LAOS'\\n\",\n",
       " \"   118 =  'LATVIA'\\n\",\n",
       " \"   255 =  'LEBANON'\\n\",\n",
       " \"   335 =  'LESOTHO'\\n\",\n",
       " \"   370 =  'LIBERIA'\\n\",\n",
       " \"   381 =  'LIBYA'\\n\",\n",
       " \"   119 =  'LIECHTENSTEIN'\\n\",\n",
       " \"   120 =  'LITHUANIA'\\n\",\n",
       " \"   121 =  'LUXEMBOURG'\\n\",\n",
       " \"   214 =  'MACAU'\\n\",\n",
       " \"   167 =  'MACEDONIA'\\n\",\n",
       " \"   320 =  'MADAGASCAR'\\n\",\n",
       " \"   345 =  'MALAWI'\\n\",\n",
       " \"   273 =  'MALAYSIA'\\n\",\n",
       " \"   220 =  'MALDIVES'\\n\",\n",
       " \"   392 =  'MALI'\\n\",\n",
       " \"   145 =  'MALTA'\\n\",\n",
       " \"   472 =  'MARSHALL ISLANDS'\\n\",\n",
       " \"   511 =  'MARTINIQUE'\\n\",\n",
       " \"   389 =  'MAURITANIA'\\n\",\n",
       " \"   342 =  'MAURITIUS'\\n\",\n",
       " \"   760 =  'MAYOTTE (AFRICA - FRENCH)' \\n\",\n",
       " \"   473 =  'MICRONESIA, FED. STATES OF'\\n\",\n",
       " \"   157 =  'MOLDOVA'\\n\",\n",
       " \"   122 =  'MONACO'\\n\",\n",
       " \"   299 =  'MONGOLIA'\\n\",\n",
       " \"   735 =  'MONTENEGRO' \\n\",\n",
       " \"   521 =  'MONTSERRAT'\\n\",\n",
       " \"   332 =  'MOROCCO'\\n\",\n",
       " \"   329 =  'MOZAMBIQUE'\\n\",\n",
       " \"   371 =  'NAMIBIA'\\n\",\n",
       " \"   440 =  'NAURU'\\n\",\n",
       " \"   257 =  'NEPAL'\\n\",\n",
       " \"   123 =  'NETHERLANDS'\\n\",\n",
       " \"   508 =  'NETHERLANDS ANTILLES'\\n\",\n",
       " \"   409 =  'NEW CALEDONIA'\\n\",\n",
       " \"   464 =  'NEW ZEALAND'\\n\",\n",
       " \"   579 =  'NICARAGUA'\\n\",\n",
       " \"   390 =  'NIGER'\\n\",\n",
       " \"   343 =  'NIGERIA'\\n\",\n",
       " \"   470 =  'NIUE'\\n\",\n",
       " \"   275 =  'NORTH KOREA'\\n\",\n",
       " \"   124 =  'NORWAY'\\n\",\n",
       " \"   256 =  'OMAN'\\n\",\n",
       " \"   258 =  'PAKISTAN'\\n\",\n",
       " \"   474 =  'PALAU'\\n\",\n",
       " \"   743 =  'PALESTINE' \\n\",\n",
       " \"   504 =  'PANAMA'\\n\",\n",
       " \"   441 =  'PAPUA NEW GUINEA'\\n\",\n",
       " \"   693 =  'PARAGUAY'\\n\",\n",
       " \"   694 =  'PERU'\\n\",\n",
       " \"   260 =  'PHILIPPINES'\\n\",\n",
       " \"   416 =  'PITCAIRN ISLANDS'\\n\",\n",
       " \"   107 =  'POLAND'\\n\",\n",
       " \"   126 =  'PORTUGAL'\\n\",\n",
       " \"   297 =  'QATAR'\\n\",\n",
       " \"   748 =  'REPUBLIC OF SOUTH SUDAN'\\n\",\n",
       " \"   321 =  'REUNION'\\n\",\n",
       " \"   127 =  'ROMANIA'\\n\",\n",
       " \"   158 =  'RUSSIA'\\n\",\n",
       " \"   376 =  'RWANDA'\\n\",\n",
       " \"   128 =  'SAN MARINO'\\n\",\n",
       " \"   330 =  'SAO TOME AND PRINCIPE'\\n\",\n",
       " \"   261 =  'SAUDI ARABIA'\\n\",\n",
       " \"   391 =  'SENEGAL'\\n\",\n",
       " \"   142 =  'SERBIA AND MONTENEGRO'\\n\",\n",
       " \"   745 =  'SERBIA' \\n\",\n",
       " \"   347 =  'SEYCHELLES'\\n\",\n",
       " \"   348 =  'SIERRA LEONE'\\n\",\n",
       " \"   207 =  'SINGAPORE'\\n\",\n",
       " \"   141 =  'SLOVAKIA'\\n\",\n",
       " \"   166 =  'SLOVENIA'\\n\",\n",
       " \"   412 =  'SOLOMON ISLANDS'\\n\",\n",
       " \"   397 =  'SOMALIA'\\n\",\n",
       " \"   373 =  'SOUTH AFRICA'\\n\",\n",
       " \"   276 =  'SOUTH KOREA'\\n\",\n",
       " \"   129 =  'SPAIN'\\n\",\n",
       " \"   244 =  'SRI LANKA'\\n\",\n",
       " \"   346 =  'ST. HELENA'\\n\",\n",
       " \"   522 =  'ST. KITTS-NEVIS'\\n\",\n",
       " \"   523 =  'ST. LUCIA'\\n\",\n",
       " \"   502 =  'ST. PIERRE AND MIQUELON'\\n\",\n",
       " \"   524 =  'ST. VINCENT-GRENADINES'\\n\",\n",
       " \"   716 =  'SAINT BARTHELEMY' \\n\",\n",
       " \"   736 =  'SAINT MARTIN' \\n\",\n",
       " \"   749 =  'SAINT MAARTEN' \\n\",\n",
       " \"   350 =  'SUDAN'\\n\",\n",
       " \"   602 =  'SURINAME'\\n\",\n",
       " \"   351 =  'SWAZILAND'\\n\",\n",
       " \"   130 =  'SWEDEN'\\n\",\n",
       " \"   131 =  'SWITZERLAND'\\n\",\n",
       " \"   262 =  'SYRIA'\\n\",\n",
       " \"   268 =  'TAIWAN'\\n\",\n",
       " \"   159 =  'TAJIKISTAN'\\n\",\n",
       " \"   353 =  'TANZANIA'\\n\",\n",
       " \"   263 =  'THAILAND'\\n\",\n",
       " \"   304 =  'TOGO'\\n\",\n",
       " \"   417 =  'TONGA'\\n\",\n",
       " \"   516 =  'TRINIDAD AND TOBAGO'\\n\",\n",
       " \"   323 =  'TUNISIA'\\n\",\n",
       " \"   264 =  'TURKEY'\\n\",\n",
       " \"   161 =  'TURKMENISTAN'\\n\",\n",
       " \"   527 =  'TURKS AND CAICOS ISLANDS'\\n\",\n",
       " \"   420 =  'TUVALU'\\n\",\n",
       " \"   352 =  'UGANDA'\\n\",\n",
       " \"   162 =  'UKRAINE'\\n\",\n",
       " \"   296 =  'UNITED ARAB EMIRATES'\\n\",\n",
       " \"   135 =  'UNITED KINGDOM'\\n\",\n",
       " \"   695 =  'URUGUAY'\\n\",\n",
       " \"   163 =  'UZBEKISTAN'\\n\",\n",
       " \"   410 =  'VANUATU'\\n\",\n",
       " \"   696 =  'VENEZUELA'\\n\",\n",
       " \"   266 =  'VIETNAM'\\n\",\n",
       " \"   469 =  'WALLIS AND FUTUNA ISLANDS'\\n\",\n",
       " \"   757 =  'WEST INDIES (FRENCH)' \\n\",\n",
       " \"   333 =  'WESTERN SAHARA'\\n\",\n",
       " \"   465 =  'WESTERN SAMOA'\\n\",\n",
       " \"   216 =  'YEMEN'\\n\",\n",
       " \"   139 =  'YUGOSLAVIA'\\n\",\n",
       " \"   301 =  'ZAIRE'\\n\",\n",
       " \"   344 =  'ZAMBIA'\\n\",\n",
       " \"   315 =  'ZIMBABWE'\\n\",\n",
       " \"   403 =  'INVALID: AMERICAN SAMOA'\\n\",\n",
       " \"   712 =  'INVALID: ANTARCTICA' \\n\",\n",
       " \"   700 =  'INVALID: BORN ON BOARD SHIP'\\n\",\n",
       " \"   719 =  'INVALID: BOUVET ISLAND (ANTARCTICA/NORWAY TERR.)'\\n\",\n",
       " \"   574 =  'INVALID: CANADA'\\n\",\n",
       " \"   720 =  'INVALID: CANTON AND ENDERBURY ISLS' \\n\",\n",
       " \"   106 =  'INVALID: CZECHOSLOVAKIA'\\n\",\n",
       " \"   739 =  'INVALID: DRONNING MAUD LAND (ANTARCTICA-NORWAY)' \\n\",\n",
       " \"   394 =  'INVALID: FRENCH SOUTHERN AND ANTARCTIC'\\n\",\n",
       " \"   501 =  'INVALID: GREENLAND'\\n\",\n",
       " \"   404 =  'INVALID: GUAM'\\n\",\n",
       " \"   730 =  'INVALID: INTERNATIONAL WATERS' \\n\",\n",
       " \"   731 =  'INVALID: JOHNSON ISLAND' \\n\",\n",
       " \"   471 =  'INVALID: MARIANA ISLANDS, NORTHERN'\\n\",\n",
       " \"   737 =  'INVALID: MIDWAY ISLANDS' \\n\",\n",
       " \"   753 =  'INVALID: MINOR OUTLYING ISLANDS - USA'\\n\",\n",
       " \"   740 =  'INVALID: NEUTRAL ZONE (S. ARABIA/IRAQ)' \\n\",\n",
       " \"   710 =  'INVALID: NON-QUOTA IMMIGRANT'\\n\",\n",
       " \"   505 =  'INVALID: PUERTO RICO'\\n\",\n",
       " \"    0  =  'INVALID: STATELESS'\\n\",\n",
       " \"   705 =  'INVALID: STATELESS'\\n\",\n",
       " \"   583 =  'INVALID: UNITED STATES'\\n\",\n",
       " \"   407 =  'INVALID: UNITED STATES'\\n\",\n",
       " \"   999 =  'INVALID: UNKNOWN'\\n\",\n",
       " \"   239 =  'INVALID: UNKNOWN COUNTRY'\\n\",\n",
       " \"   134 =  'INVALID: USSR'\\n\",\n",
       " \"   506 =  'INVALID: U.S. VIRGIN ISLANDS'\\n\",\n",
       " \"   755 =  'INVALID: WAKE ISLAND'  \\n\",\n",
       " \"   311 =  'Collapsed Tanzania (should not show)'\\n\",\n",
       " \"   741 =  'Collapsed Curacao (should not show)'\\n\",\n",
       " \"    54 =  'No Country Code (54)'\\n\",\n",
       " \"   100 =  'No Country Code (100)'\\n\",\n",
       " \"   187 =  'No Country Code (187)'\\n\",\n",
       " \"   190 =  'No Country Code (190)'\\n\",\n",
       " \"   200 =  'No Country Code (200)'\\n\",\n",
       " \"   219 =  'No Country Code (219)'\\n\",\n",
       " \"   238 =  'No Country Code (238)'\\n\",\n",
       " \"   277 =  'No Country Code (277)'\\n\",\n",
       " \"   293 =  'No Country Code (293)'\\n\",\n",
       " \"   300 =  'No Country Code (300)'\\n\",\n",
       " \"   319 =  'No Country Code (319)'\\n\",\n",
       " \"   365 =  'No Country Code (365)'\\n\",\n",
       " \"   395 =  'No Country Code (395)'\\n\",\n",
       " \"   400 =  'No Country Code (400)'\\n\",\n",
       " \"   485 =  'No Country Code (485)'\\n\",\n",
       " \"   503 =  'No Country Code (503)'\\n\",\n",
       " \"   589 =  'No Country Code (589)'\\n\",\n",
       " \"   592 =  'No Country Code (592)'\\n\",\n",
       " \"   791 =  'No Country Code (791)'\\n\",\n",
       " \"   849 =  'No Country Code (849)'\\n\",\n",
       " \"   914 =  'No Country Code (914)'\\n\",\n",
       " \"   944 =  'No Country Code (944)'\\n\",\n",
       " \"   996 =  'No Country Code (996)' ;\\n\",\n",
       " '\\n',\n",
       " '\\n',\n",
       " '/* I94PORT - This format shows all the valid and invalid codes for processing */\\n',\n",
       " '  value $i94prtl\\n',\n",
       " \"   'ALC'\\t=\\t'ALCAN, AK             '\\n\",\n",
       " \"   'ANC'\\t=\\t'ANCHORAGE, AK         '\\n\",\n",
       " \"   'BAR'\\t=\\t'BAKER AAF - BAKER ISLAND, AK'\\n\",\n",
       " \"   'DAC'\\t=\\t'DALTONS CACHE, AK     '\\n\",\n",
       " \"   'PIZ'\\t=\\t'DEW STATION PT LAY DEW, AK'\\n\",\n",
       " \"   'DTH'\\t=\\t'DUTCH HARBOR, AK      '\\n\",\n",
       " \"   'EGL'\\t=\\t'EAGLE, AK             '\\n\",\n",
       " \"   'FRB'\\t=\\t'FAIRBANKS, AK         '\\n\",\n",
       " \"   'HOM'\\t=\\t'HOMER, AK             '           \\n\",\n",
       " \"   'HYD'\\t=\\t'HYDER, AK             '\\n\",\n",
       " \"   'JUN'\\t=\\t'JUNEAU, AK            '\\n\",\n",
       " \"   '5KE'\\t=\\t'KETCHIKAN, AK'\\n\",\n",
       " \"   'KET'\\t=\\t'KETCHIKAN, AK         '\\n\",\n",
       " \"   'MOS'\\t=\\t'MOSES POINT INTERMEDIATE, AK'\\n\",\n",
       " \"   'NIK'\\t=\\t'NIKISKI, AK           '\\n\",\n",
       " \"   'NOM'\\t=\\t'NOM, AK               '\\n\",\n",
       " \"   'PKC'\\t=\\t'POKER CREEK, AK       '\\n\",\n",
       " \"   'ORI'\\t=\\t'PORT LIONS SPB, AK'\\n\",\n",
       " \"   'SKA'\\t=\\t'SKAGWAY, AK           '\\n\",\n",
       " \"   'SNP'\\t=\\t'ST. PAUL ISLAND, AK'\\n\",\n",
       " \"   'TKI'\\t=\\t'TOKEEN, AK'\\n\",\n",
       " \"   'WRA'\\t=\\t'WRANGELL, AK          '\\n\",\n",
       " \"   'HSV'\\t=\\t'MADISON COUNTY - HUNTSVILLE, AL'\\n\",\n",
       " \"   'MOB'\\t=\\t'MOBILE, AL            '\\n\",\n",
       " \"   'LIA'\\t=\\t'LITTLE ROCK, AR (BPS)'\\n\",\n",
       " \"   'ROG'\\t=\\t'ROGERS ARPT, AR'\\n\",\n",
       " \"   'DOU'\\t=\\t'DOUGLAS, AZ           '\\n\",\n",
       " \"   'LUK'\\t=\\t'LUKEVILLE, AZ         '\\n\",\n",
       " \"   'MAP'\\t=\\t'MARIPOSA AZ           '\\n\",\n",
       " \"   'NAC'\\t=\\t'NACO, AZ              '\\n\",\n",
       " \"   'NOG'\\t=\\t'NOGALES, AZ           '\\n\",\n",
       " \"   'PHO'\\t=\\t'PHOENIX, AZ           '\\n\",\n",
       " \"   'POR'\\t=\\t'PORTAL, AZ'\\n\",\n",
       " \"   'SLU'\\t=\\t'SAN LUIS, AZ          '\\n\",\n",
       " \"   'SAS'\\t=\\t'SASABE, AZ            '\\n\",\n",
       " \"   'TUC'\\t=\\t'TUCSON, AZ            '\\n\",\n",
       " \"   'YUI'\\t=\\t'YUMA, AZ              ' \\n\",\n",
       " \"   'AND'\\t=\\t'ANDRADE, CA           '\\n\",\n",
       " \"   'BUR'\\t=\\t'BURBANK, CA'\\n\",\n",
       " \"   'CAL'\\t=\\t'CALEXICO, CA          '\\n\",\n",
       " \"   'CAO'\\t=\\t'CAMPO, CA             ' \\n\",\n",
       " \"   'FRE'\\t=\\t'FRESNO, CA            '\\n\",\n",
       " \"   'ICP'\\t=\\t'IMPERIAL COUNTY, CA   '\\n\",\n",
       " \"   'LNB'\\t=\\t'LONG BEACH, CA         '\\n\",\n",
       " \"   'LOS'\\t=\\t'LOS ANGELES, CA       '\\n\",\n",
       " \"   'BFL'\\t=\\t'MEADOWS FIELD - BAKERSFIELD, CA'\\n\",\n",
       " \"   'OAK'\\t=\\t'OAKLAND, CA ' \\n\",\n",
       " \"   'ONT'\\t=\\t'ONTARIO, CA'\\n\",\n",
       " \"   'OTM'\\t=\\t'OTAY MESA, CA          '\\n\",\n",
       " \"   'BLT'\\t=\\t'PACIFIC, HWY. STATION, CA '\\n\",\n",
       " \"   'PSP'\\t=\\t'PALM SPRINGS, CA'\\n\",\n",
       " \"   'SAC'\\t=\\t'SACRAMENTO, CA        '\\n\",\n",
       " \"   'SLS'\\t=\\t'SALINAS, CA (BPS)'\\n\",\n",
       " \"   'SDP'\\t=\\t'SAN DIEGO, CA'\\n\",\n",
       " \"   'SFR'\\t=\\t'SAN FRANCISCO, CA     '\\n\",\n",
       " \"   'SNJ'\\t=\\t'SAN JOSE, CA          '\\n\",\n",
       " \"   'SLO'\\t=\\t'SAN LUIS OBISPO, CA   '\\n\",\n",
       " \"   'SLI'\\t=\\t'SAN LUIS OBISPO, CA (BPS)'\\n\",\n",
       " \"   'SPC'\\t=\\t'SAN PEDRO, CA         '\\n\",\n",
       " \"   'SYS'\\t=\\t'SAN YSIDRO, CA        '\\n\",\n",
       " \"   'SAA'\\t=\\t'SANTA ANA, CA         '\\n\",\n",
       " \"   'STO'\\t=\\t'STOCKTON, CA (BPS)'\\n\",\n",
       " \"   'TEC'\\t=\\t'TECATE, CA            '\\n\",\n",
       " \"   'TRV'\\t=\\t'TRAVIS-AFB, CA        '\\n\",\n",
       " \"   'APA'\\t=\\t'ARAPAHOE COUNTY, CO'\\n\",\n",
       " \"   'ASE'\\t=\\t'ASPEN, CO #ARPT'\\n\",\n",
       " \"   'COS'\\t=\\t'COLORADO SPRINGS, CO'\\n\",\n",
       " \"   'DEN'\\t=\\t'DENVER, CO            '\\n\",\n",
       " \"   'DRO'\\t=\\t'LA PLATA - DURANGO, CO'\\n\",\n",
       " \"   'BDL'\\t=\\t'BRADLEY INTERNATIONAL, CT'\\n\",\n",
       " \"   'BGC'\\t=\\t'BRIDGEPORT, CT        '\\n\",\n",
       " \"   'GRT'\\t=\\t'GROTON, CT            '\\n\",\n",
       " \"   'HAR'\\t=\\t'HARTFORD, CT          '\\n\",\n",
       " \"   'NWH'\\t=\\t'NEW HAVEN, CT         '\\n\",\n",
       " \"   'NWL'\\t=\\t'NEW LONDON, CT        '\\n\",\n",
       " \"   'TST'\\t=\\t'NEWINGTON DATA CENTER TEST, CT'\\n\",\n",
       " \"   'WAS'\\t=\\t'WASHINGTON DC         '\\n\",\n",
       " \"   'DOV'\\t=\\t'DOVER AFB, DE'\\n\",\n",
       " \"   'DVD'\\t=\\t'DOVER-AFB, DE         '\\n\",\n",
       " \"   'WLL'\\t=\\t'WILMINGTON, DE        '\\n\",\n",
       " \"   'BOC'\\t=\\t'BOCAGRANDE, FL        '\\n\",\n",
       " \"   'SRQ'\\t=\\t'BRADENTON - SARASOTA, FL'\\n\",\n",
       " \"   'CAN'\\t=\\t'CAPE CANAVERAL, FL    '\\n\",\n",
       " \"   'DAB'\\t=\\t'DAYTONA BEACH INTERNATIONAL, FL'\\n\",\n",
       " \"   'FRN'\\t=\\t'FERNANDINA, FL        '\\n\",\n",
       " \"   'FTL'\\t=\\t'FORT LAUDERDALE, FL   '\\n\",\n",
       " \"   'FMY'\\t=\\t'FORT MYERS, FL        '\\n\",\n",
       " \"   'FPF'\\t=\\t'FORT PIERCE, FL       '\\n\",\n",
       " \"   'HUR'\\t=\\t'HURLBURT FIELD, FL'\\n\",\n",
       " \"   'GNV'\\t=\\t'J R ALISON MUNI - GAINESVILLE, FL'\\n\",\n",
       " \"   'JAC'\\t=\\t'JACKSONVILLE, FL      '\\n\",\n",
       " \"   'KEY'\\t=\\t'KEY WEST, FL          '\\n\",\n",
       " \"   'LEE'\\t=\\t'LEESBURG MUNICIPAL AIRPORT, FL'\\n\",\n",
       " \"   'MLB'\\t=\\t'MELBOURNE, FL'\\n\",\n",
       " \"   'MIA'\\t=\\t'MIAMI, FL             '\\n\",\n",
       " \"   'APF'\\t=\\t'NAPLES, FL #ARPT'\\n\",\n",
       " \"   'OPF'\\t=\\t'OPA LOCKA, FL'\\n\",\n",
       " \"   'ORL'\\t=\\t'ORLANDO, FL           '\\n\",\n",
       " \"   'PAN'\\t=\\t'PANAMA CITY, FL       '\\n\",\n",
       " \"   'PEN'\\t=\\t'PENSACOLA, FL         '\\n\",\n",
       " \"   'PCF'\\t=\\t'PORT CANAVERAL, FL    '\\n\",\n",
       " \"   'PEV'\\t=\\t'PORT EVERGLADES, FL   '\\n\",\n",
       " \"   'PSJ'\\t=\\t'PORT ST JOE, FL       '\\n\",\n",
       " \"   'SFB'\\t=\\t'SANFORD, FL           '\\n\",\n",
       " \"   'SGJ'\\t=\\t'ST AUGUSTINE ARPT, FL'\\n\",\n",
       " \"   'SAU'\\t=\\t'ST AUGUSTINE, FL      '\\n\",\n",
       " \"   'FPR'\\t=\\t'ST LUCIE COUNTY, FL'\\n\",\n",
       " \"   'SPE'\\t=\\t'ST PETERSBURG, FL     '\\n\",\n",
       " \"   'TAM'\\t=\\t'TAMPA, FL             '\\n\",\n",
       " \"   'WPB'\\t=\\t'WEST PALM BEACH, FL   '\\n\",\n",
       " \"   'ATL'\\t=\\t'ATLANTA, GA           '\\n\",\n",
       " \"   'BRU'\\t=\\t'BRUNSWICK, GA         '\\n\",\n",
       " \"   'AGS'\\t=\\t'BUSH FIELD - AUGUSTA, GA'\\n\",\n",
       " \"   'SAV'\\t=\\t'SAVANNAH, GA          '\\n\",\n",
       " \"   'AGA'\\t=\\t'AGANA, GU             '\\n\",\n",
       " \"   'HHW'\\t=\\t'HONOLULU, HI          '\\n\",\n",
       " \"   'OGG'\\t=\\t'KAHULUI - MAUI, HI'\\n\",\n",
       " \"   'KOA'\\t=\\t'KEAHOLE-KONA, HI      '\\n\",\n",
       " \"   'LIH'\\t=\\t'LIHUE, HI             '\\n\",\n",
       " \"   'CID'\\t=\\t'CEDAR RAPIDS/IOWA CITY, IA'\\n\",\n",
       " \"   'DSM'\\t=\\t'DES MOINES, IA'\\n\",\n",
       " \"   'BOI'\\t=\\t'AIR TERM. (GOWEN FLD) BOISE, ID'\\n\",\n",
       " \"   'EPI'\\t=\\t'EASTPORT, ID          '\\n\",\n",
       " \"   'IDA'\\t=\\t'FANNING FIELD - IDAHO FALLS, ID'\\n\",\n",
       " \"   'PTL'\\t=\\t'PORTHILL, ID          '\\n\",\n",
       " \"   'SPI'\\t=\\t'CAPITAL - SPRINGFIELD, IL'\\n\",\n",
       " \"   'CHI'\\t=\\t'CHICAGO, IL           '\\n\",\n",
       " \"   'DPA'\\t=\\t'DUPAGE COUNTY, IL'\\n\",\n",
       " \"   'PIA'\\t=\\t'GREATER PEORIA, IL'\\n\",\n",
       " \"   'RFD'\\t=\\t'GREATER ROCKFORD, IL'\\n\",\n",
       " \"   'UGN'\\t=\\t'MEMORIAL - WAUKEGAN, IL'\\n\",\n",
       " \"   'GAR'\\t=\\t'GARY, IN              '\\n\",\n",
       " \"   'HMM'\\t=\\t'HAMMOND, IN           '\\n\",\n",
       " \"   'INP'\\t=\\t'INDIANAPOLIS, IN      '\\n\",\n",
       " \"   'MRL'\\t=\\t'MERRILLVILLE, IN      '\\n\",\n",
       " \"   'SBN'\\t=\\t'SOUTH BEND, IN'\\n\",\n",
       " \"   'ICT'\\t=\\t'MID-CONTINENT - WITCHITA, KS'\\n\",\n",
       " \"   'LEX'\\t=\\t'BLUE GRASS - LEXINGTON, KY'\\n\",\n",
       " \"   'LOU'\\t=\\t'LOUISVILLE, KY        '\\n\",\n",
       " \"   'BTN'\\t=\\t'BATON ROUGE, LA       '\\n\",\n",
       " \"   'LKC'\\t=\\t'LAKE CHARLES, LA      '\\n\",\n",
       " \"   'LAK'\\t=\\t'LAKE CHARLES, LA (BPS)'\\n\",\n",
       " \"   'MLU'\\t=\\t'MONROE, LA'\\n\",\n",
       " \"   'MGC'\\t=\\t'MORGAN CITY, LA       '\\n\",\n",
       " \"   'NOL'\\t=\\t'NEW ORLEANS, LA       '\\n\",\n",
       " \"   'BOS'\\t=\\t'BOSTON, MA            '\\n\",\n",
       " \"   'GLO'\\t=\\t'GLOUCESTER, MA        '\\n\",\n",
       " \"   'BED'\\t=\\t'HANSCOM FIELD - BEDFORD, MA'\\n\",\n",
       " \"   'LYN'\\t=\\t'LYNDEN, WA            '\\n\",\n",
       " \"   'ADW'\\t=\\t'ANDREWS AFB, MD'\\n\",\n",
       " \"   'BAL'\\t=\\t'BALTIMORE, MD         '\\n\",\n",
       " \"   'MKG'\\t=\\t'MUSKEGON, MD'\\n\",\n",
       " \"   'PAX'\\t=\\t'PATUXENT RIVER, MD    '\\n\",\n",
       " \"   'BGM'\\t=\\t'BANGOR, ME            '\\n\",\n",
       " \"   'BOO'\\t=\\t'BOOTHBAY HARBOR, ME   '\\n\",\n",
       " \"   'BWM'\\t=\\t'BRIDGEWATER, ME       '\\n\",\n",
       " \"   'BCK'\\t=\\t'BUCKPORT, ME          '\\n\",\n",
       " \"   'CLS'\\t=\\t'CALAIS, ME   '\\n\",\n",
       " \"   'CRB'\\t=\\t'CARIBOU, ME           '\\n\",\n",
       " \"   'COB'\\t=\\t'COBURN GORE, ME       '\\n\",\n",
       " \"   'EST'\\t=\\t'EASTCOURT, ME         '\\n\",\n",
       " \"   'EPT'\\t=\\t'EASTPORT MUNICIPAL, ME'\\n\",\n",
       " \"   'EPM'\\t=\\t'EASTPORT, ME          '\\n\",\n",
       " \"   'FOR'\\t=\\t'FOREST CITY, ME       '\\n\",\n",
       " \"   'FTF'\\t=\\t'FORT FAIRFIELD, ME    '\\n\",\n",
       " \"   'FTK'\\t=\\t'FORT KENT, ME         '\\n\",\n",
       " \"   'HML'\\t=\\t'HAMIIN, ME            '\\n\",\n",
       " \"   'HTM'\\t=\\t'HOULTON, ME           '\\n\",\n",
       " \"   'JKM'\\t=\\t'JACKMAN, ME           '\\n\",\n",
       " \"   'KAL'\\t=\\t'KALISPEL, MT          '\\n\",\n",
       " \"   'LIM'\\t=\\t'LIMESTONE, ME         '\\n\",\n",
       " \"   'LUB'\\t=\\t'LUBEC, ME             '\\n\",\n",
       " \"   'MAD'\\t=\\t'MADAWASKA, ME         '\\n\",\n",
       " \"   'POM'\\t=\\t'PORTLAND, ME          '\\n\",\n",
       " \"   'RGM'\\t=\\t'RANGELEY, ME (BPS)'\\n\",\n",
       " \"   'SBR'\\t=\\t'SOUTH BREWER, ME      '\\n\",\n",
       " \"   'SRL'\\t=\\t'ST AURELIE, ME        '\\n\",\n",
       " \"   'SPA'\\t=\\t'ST PAMPILE, ME        '\\n\",\n",
       " \"   'VNB'\\t=\\t'VAN BUREN, ME         '\\n\",\n",
       " \"   'VCB'\\t=\\t'VANCEBORO, ME         '\\n\",\n",
       " \"   'AGN'\\t=\\t'ALGONAC, MI           '\\n\",\n",
       " \"   'ALP'\\t=\\t'ALPENA, MI            '\\n\",\n",
       " \"   'BCY'\\t=\\t'BAY CITY, MI          '\\n\",\n",
       " \"   'DET'\\t=\\t'DETROIT, MI           '\\n\",\n",
       " \"   'GRP'\\t=\\t'GRAND RAPIDS, MI'\\n\",\n",
       " \"   'GRO'\\t=\\t'GROSSE ISLE, MI       '\\n\",\n",
       " \"   'ISL'\\t=\\t'ISLE ROYALE, MI       '\\n\",\n",
       " \"   'MRC'\\t=\\t'MARINE CITY, MI       '\\n\",\n",
       " \"   'MRY'\\t=\\t'MARYSVILLE, MI        '\\n\",\n",
       " \"   'PTK'\\t=\\t'OAKLAND COUNTY - PONTIAC, MI'\\n\",\n",
       " \"   'PHU'\\t=\\t'PORT HURON, MI        '\\n\",\n",
       " \"   'RBT'\\t=\\t'ROBERTS LANDING, MI   '\\n\",\n",
       " \"   'SAG'\\t=\\t'SAGINAW, MI           '\\n\",\n",
       " \"   'SSM'\\t=\\t'SAULT STE. MARIE, MI  '\\n\",\n",
       " \"   'SCL'\\t=\\t'ST CLAIR, MI          '\\n\",\n",
       " \"   'YIP'\\t=\\t'WILLOW RUN - YPSILANTI, MI'\\n\",\n",
       " \"   'BAU'\\t=\\t'BAUDETTE, MN          '\\n\",\n",
       " \"   'CAR'\\t=\\t'CARIBOU MUNICIPAL AIRPORT, MN'\\n\",\n",
       " \"   'GTF'\\t=\\t'Collapsed into INT, MN'\\n\",\n",
       " \"   'INL'\\t=\\t'Collapsed into INT, MN'\\n\",\n",
       " \"   'CRA'\\t=\\t'CRANE LAKE, MN        '\\n\",\n",
       " \"   'MIC'\\t=\\t'CRYSTAL MUNICIPAL AIRPORT, MN'\\n\",\n",
       " \"   'DUL'\\t=\\t'DULUTH, MN            '\\n\",\n",
       " \"   'ELY'\\t=\\t'ELY, MN               '\\n\",\n",
       " \"   'GPM'\\t=\\t'GRAND PORTAGE, MN     '\\n\",\n",
       " \"   'SVC'\\t=\\t'GRANT COUNTY - SILVER CITY, MN'\\n\",\n",
       " \"   'INT'\\t=\\t'INT''L FALLS, MN      '\\n\",\n",
       " \"   'LAN'\\t=\\t'LANCASTER, MN         '\\n\",\n",
       " \"   'MSP'\\t=\\t'MINN./ST PAUL, MN     '\\n\",\n",
       " \"   'LIN'\\t=\\t'NORTHERN SVC CENTER, MN   '\\n\",\n",
       " \"   'NOY'\\t=\\t'NOYES, MN             '\\n\",\n",
       " \"   'PIN'\\t=\\t'PINE CREEK, MN        '\\n\",\n",
       " \"   '48Y'\\t=\\t'PINECREEK BORDER ARPT, MN'\\n\",\n",
       " \"   'RAN'\\t=\\t'RAINER, MN            '\\n\",\n",
       " \"   'RST'\\t=\\t'ROCHESTER, MN'\\n\",\n",
       " \"   'ROS'\\t=\\t'ROSEAU, MN            '\\n\",\n",
       " \"   'SPM'\\t=\\t'ST PAUL, MN           '\\n\",\n",
       " \"   'WSB'\\t=\\t'WARROAD INTL, SPB, MN'\\n\",\n",
       " \"   'WAR'\\t=\\t'WARROAD, MN           '\\n\",\n",
       " \"   'KAN'\\t=\\t'KANSAS CITY, MO       '\\n\",\n",
       " \"   'SGF'\\t=\\t'SPRINGFIELD-BRANSON, MO'\\n\",\n",
       " \"   'STL'\\t=\\t'ST LOUIS, MO          '\\n\",\n",
       " \"   'WHI'\\t=\\t'WHITETAIL, MT         '\\n\",\n",
       " \"   'WHM'\\t=\\t'WILD HORSE, MT        '\\n\",\n",
       " \"   'GPT'\\t=\\t'BILOXI REGIONAL, MS'\\n\",\n",
       " \"   'GTR'\\t=\\t'GOLDEN TRIANGLE LOWNDES CNTY, MS'\\n\",\n",
       " \"   'GUL'\\t=\\t'GULFPORT, MS          '\\n\",\n",
       " \"   'PAS'\\t=\\t'PASCAGOULA, MS        '\\n\",\n",
       " \"   'JAN'\\t=\\t'THOMPSON FIELD - JACKSON, MS'\\n\",\n",
       " \"   'BIL'\\t=\\t'BILLINGS, MT          '\\n\",\n",
       " \"   'BTM'\\t=\\t'BUTTE, MT             '\\n\",\n",
       " \"   'CHF'\\t=\\t'CHIEF MT, MT          '\\n\",\n",
       " \"   'CTB'\\t=\\t'CUT BANK MUNICIPAL, MT'\\n\",\n",
       " \"   'CUT'\\t=\\t'CUT BANK, MT          '\\n\",\n",
       " \"   'DLB'\\t=\\t'DEL BONITA, MT        '\\n\",\n",
       " \"   'EUR'\\t=\\t'EUREKA, MT (BPS)'\\n\",\n",
       " \"   'BZN'\\t=\\t'GALLATIN FIELD - BOZEMAN, MT'\\n\",\n",
       " \"   'FCA'\\t=\\t'GLACIER NATIONAL PARK, MT'\\n\",\n",
       " \"   'GGW'\\t=\\t'GLASGOW, MT           '\\n\",\n",
       " \"   'GRE'\\t=\\t'GREAT FALLS, MT       '\\n\",\n",
       " \"   'HVR'\\t=\\t'HAVRE, MT             '\\n\",\n",
       " \"   'HEL'\\t=\\t'HELENA, MT            '\\n\",\n",
       " \"   'LWT'\\t=\\t'LEWISTON, MT          '\\n\",\n",
       " \"   'MGM'\\t=\\t'MORGAN, MT            '\\n\",\n",
       " \"   'OPH'\\t=\\t'OPHEIM, MT            '\\n\",\n",
       " \"   'PIE'\\t=\\t'PIEGAN, MT            '\\n\",\n",
       " \"   'RAY'\\t=\\t'RAYMOND, MT           '\\n\",\n",
       " \"   'ROO'\\t=\\t'ROOSVILLE, MT         '\\n\",\n",
       " \"   'SCO'\\t=\\t'SCOBEY, MT            '\\n\",\n",
       " \"   'SWE'\\t=\\t'SWEETGTASS, MT        '\\n\",\n",
       " \"   'TRL'\\t=\\t'TRIAL CREEK, MT       '\\n\",\n",
       " \"   'TUR'\\t=\\t'TURNER, MT            '\\n\",\n",
       " \"   'WCM'\\t=\\t'WILLOW CREEK, MT      '\\n\",\n",
       " \"   'CLT'\\t=\\t'CHARLOTTE, NC         '\\n\",\n",
       " \"   'FAY'\\t=\\t'FAYETTEVILLE, NC'\\n\",\n",
       " \"   'MRH'\\t=\\t'MOREHEAD CITY, NC     '\\n\",\n",
       " \"   'FOP'\\t=\\t'MORRIS FIELDS AAF, NC'\\n\",\n",
       " \"   'GSO'\\t=\\t'PIEDMONT TRIAD INTL AIRPORT, NC'\\n\",\n",
       " \"   'RDU'\\t=\\t'RALEIGH/DURHAM, NC    '\\n\",\n",
       " \"   'SSC'\\t=\\t'SHAW AFB - SUMTER, NC'\\n\",\n",
       " \"   'WIL'\\t=\\t'WILMINGTON, NC        '\\n\",\n",
       " \"   'AMB'\\t=\\t'AMBROSE, ND           '\\n\",\n",
       " \"   'ANT'\\t=\\t'ANTLER, ND            '\\n\",\n",
       " \"   'CRY'\\t=\\t'CARBURY, ND           '\\n\",\n",
       " \"   'DNS'\\t=\\t'DUNSEITH, ND          '\\n\",\n",
       " \"   'FAR'\\t=\\t'FARGO, ND             '\\n\",\n",
       " \"   'FRT'\\t=\\t'FORTUNA, ND           '\\n\",\n",
       " \"   'GRF'\\t=\\t'GRAND FORKS, ND       '\\n\",\n",
       " \"   'HNN'\\t=\\t'HANNAH, ND            '\\n\",\n",
       " \"   'HNS'\\t=\\t'HANSBORO, ND          '\\n\",\n",
       " \"   'MAI'\\t=\\t'MAIDA, ND             '\\n\",\n",
       " \"   'MND'\\t=\\t'MINOT, ND             '\\n\",\n",
       " \"   'NEC'\\t=\\t'NECHE, ND             '\\n\",\n",
       " \"   'NOO'\\t=\\t'NOONAN, ND            '\\n\",\n",
       " \"   'NRG'\\t=\\t'NORTHGATE, ND         '\\n\",\n",
       " \"   'PEM'\\t=\\t'PEMBINA, ND           '\\n\",\n",
       " \"   'SAR'\\t=\\t'SARLES, ND            '\\n\",\n",
       " \"   'SHR'\\t=\\t'SHERWOOD, ND          '\\n\",\n",
       " \"   'SJO'\\t=\\t'ST JOHN, ND           '\\n\",\n",
       " \"   'WAL'\\t=\\t'WALHALLA, ND          '\\n\",\n",
       " \"   'WHO'\\t=\\t'WESTHOPE, ND          '\\n\",\n",
       " \"   'WND'\\t=\\t'WILLISTON, ND         '\\n\",\n",
       " \"   'OMA'\\t=\\t'OMAHA, NE             '\\n\",\n",
       " \"   'LEB'\\t=\\t'LEBANON, NH           '\\n\",\n",
       " \"   'MHT'\\t=\\t'MANCHESTER, NH'\\n\",\n",
       " \"   'PNH'\\t=\\t'PITTSBURG, NH         '\\n\",\n",
       " \"   'PSM'\\t=\\t'PORTSMOUTH, NH        '\\n\",\n",
       " \"   'BYO'\\t=\\t'BAYONNE, NJ           '\\n\",\n",
       " \"   'CNJ'\\t=\\t'CAMDEN, NJ            '\\n\",\n",
       " \"   'HOB'\\t=\\t'HOBOKEN, NJ           '\\n\",\n",
       " \"   'JER'\\t=\\t'JERSEY CITY, NJ       '\\n\",\n",
       " \"   'WRI'\\t=\\t'MC GUIRE AFB - WRIGHTSOWN, NJ'\\n\",\n",
       " \"   'MMU'\\t=\\t'MORRISTOWN, NJ'\\n\",\n",
       " \"   'NEW'\\t=\\t'NEWARK/TETERBORO, NJ  '\\n\",\n",
       " \"   'PER'\\t=\\t'PERTH AMBOY, NJ       '\\n\",\n",
       " \"   'ACY'\\t=\\t'POMONA FIELD - ATLANTIC CITY, NJ'\\n\",\n",
       " \"   'ALA'\\t=\\t'ALAMAGORDO, NM (BPS)'\\n\",\n",
       " \"   'ABQ'\\t=\\t'ALBUQUERQUE, NM       '\\n\",\n",
       " \"   'ANP'\\t=\\t'ANTELOPE WELLS, NM    '\\n\",\n",
       " \"   'CRL'\\t=\\t'CARLSBAD, NM          '\\n\",\n",
       " \"   'COL'\\t=\\t'COLUMBUS, NM          '\\n\",\n",
       " \"   'CDD'\\t=\\t'CRANE LAKE - ST. LOUIS CNTY, NM'\\n\",\n",
       " \"   'DNM'\\t=\\t'DEMING, NM (BPS)'\\n\",\n",
       " \"   'LAS'\\t=\\t'LAS CRUCES, NM        '\\n\",\n",
       " \"   'LOB'\\t=\\t'LORDSBURG, NM (BPS)'\\n\",\n",
       " \"   'RUI'\\t=\\t'RUIDOSO, NM'\\n\",\n",
       " \"   'STR'\\t=\\t'SANTA TERESA, NM      '\\n\",\n",
       " \"   'RNO'\\t=\\t'CANNON INTL - RENO/TAHOE, NV'\\n\",\n",
       " \"   'FLX'\\t=\\t'FALLON MUNICIPAL AIRPORT, NV'\\n\",\n",
       " \"   'LVG'\\t=\\t'LAS VEGAS, NV         '\\n\",\n",
       " \"   'REN'\\t=\\t'RENO, NV              '\\n\",\n",
       " \"   'ALB'\\t=\\t'ALBANY, NY            '\\n\",\n",
       " \"   'AXB'\\t=\\t'ALEXANDRIA BAY, NY    '\\n\",\n",
       " \"   'BUF'\\t=\\t'BUFFALO, NY           '\\n\",\n",
       " \"   'CNH'\\t=\\t'CANNON CORNERS, NY'\\n\",\n",
       " \"   'CAP'\\t=\\t'CAPE VINCENT, NY      '\\n\",\n",
       " \"   'CHM'\\t=\\t'CHAMPLAIN, NY         '\\n\",\n",
       " \"   'CHT'\\t=\\t'CHATEAUGAY, NY        '\\n\",\n",
       " \"   'CLA'\\t=\\t'CLAYTON, NY           '\\n\",\n",
       " \"   'FTC'\\t=\\t'FORT COVINGTON, NY    '\\n\",\n",
       " \"   'LAG'\\t=\\t'LA GUARDIA, NY        '\\n\",\n",
       " \"   'LEW'\\t=\\t'LEWISTON, NY          '\\n\",\n",
       " \"   'MAS'\\t=\\t'MASSENA, NY           '\\n\",\n",
       " \"   'MAG'\\t=\\t'MCGUIRE AFB, NY       '\\n\",\n",
       " \"   'MOO'\\t=\\t'MOORES, NY            '\\n\",\n",
       " \"   'MRR'\\t=\\t'MORRISTOWN, NY        '\\n\",\n",
       " \"   'NYC'\\t=\\t'NEW YORK, NY          '\\n\",\n",
       " \"   'NIA'\\t=\\t'NIAGARA FALLS, NY     '\\n\",\n",
       " \"   'OGD'\\t=\\t'OGDENSBURG, NY        '\\n\",\n",
       " \"   'OSW'\\t=\\t'OSWEGO, NY            '\\n\",\n",
       " \"   'ELM'\\t=\\t'REGIONAL ARPT - HORSEHEAD, NY'\\n\",\n",
       " \"   'ROC'\\t=\\t'ROCHESTER, NY         '\\n\",\n",
       " \"   'ROU'\\t=\\t'ROUSES POINT, NY      '\\n\",\n",
       " \"   'SWF'\\t=\\t'STEWART - ORANGE CNTY, NY'\\n\",\n",
       " \"   'SYR'\\t=\\t'SYRACUSE, NY          '\\n\",\n",
       " \"   'THO'\\t=\\t'THOUSAND ISLAND BRIDGE, NY'\\n\",\n",
       " \"   'TRO'\\t=\\t'TROUT RIVER, NY       '\\n\",\n",
       " \"   'WAT'\\t=\\t'WATERTOWN, NY         '\\n\",\n",
       " \"   'HPN'\\t=\\t'WESTCHESTER - WHITE PLAINS, NY'\\n\",\n",
       " \"   'WRB'\\t=\\t'WHIRLPOOL BRIDGE, NY'\\n\",\n",
       " \"   'YOU'\\t=\\t'YOUNGSTOWN, NY        '\\n\",\n",
       " \"   'AKR'\\t=\\t'AKRON, OH             '\\n\",\n",
       " \"   'ATB'\\t=\\t'ASHTABULA, OH         '\\n\",\n",
       " \"   'CIN'\\t=\\t'CINCINNATI, OH        '\\n\",\n",
       " \"   'CLE'\\t=\\t'CLEVELAND, OH         '\\n\",\n",
       " \"   'CLM'\\t=\\t'COLUMBUS, OH          '\\n\",\n",
       " \"   'LOR'\\t=\\t'LORAIN, OH            '\\n\",\n",
       " \"   'MBO'\\t=\\t'MARBLE HEADS, OH      '\\n\",\n",
       " \"   'SDY'\\t=\\t'SANDUSKY, OH          '\\n\",\n",
       " \"   'TOL'\\t=\\t'TOLEDO, OH            '\\n\",\n",
       " \"   'OKC'\\t=\\t'OKLAHOMA CITY, OK     '\\n\",\n",
       " \"   'TUL'\\t=\\t'TULSA, OK'\\n\",\n",
       " \"   'AST'\\t=\\t'ASTORIA, OR           '\\n\",\n",
       " \"   'COO'\\t=\\t'COOS BAY, OR          '\\n\",\n",
       " \"   'HIO'\\t=\\t'HILLSBORO, OR'\\n\",\n",
       " \"   'MED'\\t=\\t'MEDFORD, OR           '\\n\",\n",
       " \"   'NPT'\\t=\\t'NEWPORT, OR           '\\n\",\n",
       " \"   'POO'\\t=\\t'PORTLAND, OR          '\\n\",\n",
       " \"   'PUT'\\t=\\t'PUT-IN-BAY, OH        '\\n\",\n",
       " \"   'RDM'\\t=\\t'ROBERTS FIELDS - REDMOND, OR'\\n\",\n",
       " \"   'ERI'\\t=\\t'ERIE, PA              '\\n\",\n",
       " \"   'MDT'\\t=\\t'HARRISBURG, PA'\\n\",\n",
       " \"   'HSB'\\t=\\t'HARRISONBURG, PA      '\\n\",\n",
       " \"   'PHI'\\t=\\t'PHILADELPHIA, PA      '\\n\",\n",
       " \"   'PIT'\\t=\\t'PITTSBURG, PA         '\\n\",\n",
       " \"   'AGU'\\t=\\t'AGUADILLA, PR         '\\n\",\n",
       " \"   'BQN'\\t=\\t'BORINQUEN - AGUADILLO, PR'\\n\",\n",
       " \"   'JCP'\\t=\\t'CULEBRA - BENJAMIN RIVERA, PR'\\n\",\n",
       " \"   'ENS'\\t=\\t'ENSENADA, PR          '\\n\",\n",
       " \"   'FAJ'\\t=\\t'FAJARDO, PR           '\\n\",\n",
       " \"   'HUM'\\t=\\t'HUMACAO, PR           '\\n\",\n",
       " \"   'JOB'\\t=\\t'JOBOS, PR             '\\n\",\n",
       " \"   'MAY'\\t=\\t'MAYAGUEZ, PR          '\\n\",\n",
       " \"   'PON'\\t=\\t'PONCE, PR             '\\n\",\n",
       " \"   'PSE'\\t=\\t'PONCE-MERCEDITA, PR'\\n\",\n",
       " \"   'SAJ'\\t=\\t'SAN JUAN, PR          '\\n\",\n",
       " \"   'VQS'\\t=\\t'VIEQUES-ARPT, PR'\\n\",\n",
       " \"   'PRO'\\t=\\t'PROVIDENCE, RI        '\\n\",\n",
       " \"   'PVD'\\t=\\t'THEODORE FRANCIS - WARWICK, RI'\\n\",\n",
       " \"   'CHL'\\t=\\t'CHARLESTON, SC        '\\n\",\n",
       " \"   'CAE'\\t=\\t'COLUMBIA, SC #ARPT'\\n\",\n",
       " \"   'GEO'\\t=\\t'GEORGETOWN, SC        '\\n\",\n",
       " \"   'GSP'\\t=\\t'GREENVILLE, SC'\\n\",\n",
       " \"   'GRR'\\t=\\t'GREER, SC'\\n\",\n",
       " \"   'MYR'\\t=\\t'MYRTLE BEACH, SC'\\n\",\n",
       " \"   'SPF'\\t=\\t'BLACK HILLS, SPEARFISH, SD'\\n\",\n",
       " \"   'HON'\\t=\\t'HOWES REGIONAL ARPT - HURON, SD'\\n\",\n",
       " \"   'SAI'\\t=\\t'SAIPAN, SPN           '\\n\",\n",
       " \"   'TYS'\\t=\\t'MC GHEE TYSON - ALCOA, TN'\\n\",\n",
       " \"   'MEM'\\t=\\t'MEMPHIS, TN           '\\n\",\n",
       " \"   'NSV'\\t=\\t'NASHVILLE, TN         '\\n\",\n",
       " \"   'TRI'\\t=\\t'TRI CITY ARPT, TN'\\n\",\n",
       " \"   'ADS'\\t=\\t'ADDISON AIRPORT- ADDISON, TX'\\n\",\n",
       " \"   'ADT'\\t=\\t'AMISTAD DAM, TX       '\\n\",\n",
       " \"   'ANZ'\\t=\\t'ANZALDUAS, TX'\\n\",\n",
       " \"   'AUS'\\t=\\t'AUSTIN, TX            '\\n\",\n",
       " \"   'BEA'\\t=\\t'BEAUMONT, TX          '\\n\",\n",
       " \"   'BBP'\\t=\\t'BIG BEND PARK, TX (BPS)'\\n\",\n",
       " \"   'SCC'\\t=\\t'BP SPEC COORD. CTR, TX'\\n\",\n",
       " \"   'BTC'\\t=\\t'BP TACTICAL UNIT, TX  ' \\n\",\n",
       " \"   'BOA'\\t=\\t'BRIDGE OF AMERICAS, TX'\\n\",\n",
       " \"   'BRO'\\t=\\t'BROWNSVILLE, TX       '\\n\",\n",
       " \"   'CRP'\\t=\\t'CORPUS CHRISTI, TX    '\\n\",\n",
       " \"   'DAL'\\t=\\t'DALLAS, TX            '\\n\",\n",
       " \"   'DLR'\\t=\\t'DEL RIO, TX           '\\n\",\n",
       " \"   'DNA'\\t=\\t'DONNA, TX'\\n\",\n",
       " \"   'EGP'\\t=\\t'EAGLE PASS, TX        '\\n\",\n",
       " \"   'ELP'\\t=\\t'EL PASO, TX           '\\n\",\n",
       " \"   'FAB'\\t=\\t'FABENS, TX            '\\n\",\n",
       " \"   'FAL'\\t=\\t'FALCON HEIGHTS, TX    '\\n\",\n",
       " \"   'FTH'\\t=\\t'FORT HANCOCK, TX      '\\n\",\n",
       " \"   'AFW'\\t=\\t'FORT WORTH ALLIANCE, TX'\\n\",\n",
       " \"   'FPT'\\t=\\t'FREEPORT, TX          '\\n\",\n",
       " \"   'GAL'\\t=\\t'GALVESTON, TX         '\\n\",\n",
       " \"   'HLG'\\t=\\t'HARLINGEN, TX         '\\n\",\n",
       " \"   'HID'\\t=\\t'HIDALGO, TX           '\\n\",\n",
       " \"   'HOU'\\t=\\t'HOUSTON, TX           '\\n\",\n",
       " \"   'SGR'\\t=\\t'HULL FIELD, SUGAR LAND ARPT, TX'\\n\",\n",
       " \"   'LLB'\\t=\\t'JUAREZ-LINCOLN BRIDGE, TX'\\n\",\n",
       " \"   'LCB'\\t=\\t'LAREDO COLUMBIA BRIDGE, TX'\\n\",\n",
       " \"   'LRN'\\t=\\t'LAREDO NORTH, TX      '\\n\",\n",
       " \"   'LAR'\\t=\\t'LAREDO, TX            '\\n\",\n",
       " \"   'LSE'\\t=\\t'LOS EBANOS, TX        '\\n\",\n",
       " \"   'IND'\\t=\\t'LOS INDIOS, TX'\\n\",\n",
       " \"   'LOI'\\t=\\t'LOS INDIOS, TX        '\\n\",\n",
       " \"   'MRS'\\t=\\t'MARFA, TX (BPS)'\\n\",\n",
       " \"   'MCA'\\t=\\t'MCALLEN, TX           '\\n\",\n",
       " \"   'MAF'\\t=\\t'ODESSA REGIONAL, TX'\\n\",\n",
       " \"   'PDN'\\t=\\t'PASO DEL NORTE,TX     '\\n\",\n",
       " \"   'PBB'\\t=\\t'PEACE BRIDGE, NY      '\\n\",\n",
       " \"   'PHR'\\t=\\t'PHARR, TX             '\\n\",\n",
       " \"   'PAR'\\t=\\t'PORT ARTHUR, TX       '\\n\",\n",
       " \"   'ISB'\\t=\\t'PORT ISABEL, TX       '\\n\",\n",
       " \"   'POE'\\t=\\t'PORT OF EL PASO, TX   '\\n\",\n",
       " \"   'PRE'\\t=\\t'PRESIDIO, TX          '\\n\",\n",
       " \"   'PGR'\\t=\\t'PROGRESO, TX          '\\n\",\n",
       " \"   'RIO'\\t=\\t'RIO GRANDE CITY, TX   '\\n\",\n",
       " \"   'ROM'\\t=\\t'ROMA, TX              '\\n\",\n",
       " \"   'SNA'\\t=\\t'SAN ANTONIO, TX       '\\n\",\n",
       " \"   'SNN'\\t=\\t'SANDERSON, TX         '\\n\",\n",
       " \"   'VIB'\\t=\\t'VETERAN INTL BRIDGE, TX'\\n\",\n",
       " \"   'YSL'\\t=\\t'YSLETA, TX            '\\n\",\n",
       " \"   'CHA'\\t=\\t'CHARLOTTE AMALIE, VI  '\\n\",\n",
       " \"   'CHR'\\t=\\t'CHRISTIANSTED, VI     '\\n\",\n",
       " \"   'CRU'\\t=\\t'CRUZ BAY, ST JOHN, VI '\\n\",\n",
       " \"   'FRK'\\t=\\t'FREDERIKSTED, VI      '\\n\",\n",
       " \"   'STT'\\t=\\t'ST THOMAS, VI         '\\n\",\n",
       " \"   'LGU'\\t=\\t'CACHE AIRPORT - LOGAN, UT'\\n\",\n",
       " \"   'SLC'\\t=\\t'SALT LAKE CITY, UT    '\\n\",\n",
       " \"   'CHO'\\t=\\t'ALBEMARLE CHARLOTTESVILLE, VA'\\n\",\n",
       " \"   'DAA'\\t=\\t'DAVISON AAF - FAIRFAX CNTY, VA'\\n\",\n",
       " \"   'HOP'\\t=\\t'HOPEWELL, VA          '\\n\",\n",
       " \"   'HEF'\\t=\\t'MANASSAS, VA #ARPT'\\n\",\n",
       " \"   'NWN'\\t=\\t'NEWPORT, VA           '\\n\",\n",
       " \"   'NOR'\\t=\\t'NORFOLK, VA           '\\n\",\n",
       " \"   'RCM'\\t=\\t'RICHMOND, VA          '\\n\",\n",
       " \"   'ABS'\\t=\\t'ALBURG SPRINGS, VT    '\\n\",\n",
       " \"   'ABG'\\t=\\t'ALBURG, VT            '\\n\",\n",
       " \"   'BEB'\\t=\\t'BEEBE PLAIN, VT       '\\n\",\n",
       " \"   'BEE'\\t=\\t'BEECHER FALLS, VT     '\\n\",\n",
       " \"   'BRG'\\t=\\t'BURLINGTON, VT        '\\n\",\n",
       " \"   'CNA'\\t=\\t'CANAAN, VT            '\\n\",\n",
       " \"   'DER'\\t=\\t'DERBY LINE, VT (I-91) '\\n\",\n",
       " \"   'DLV'\\t=\\t'DERBY LINE, VT (RT. 5)'\\n\",\n",
       " \"   'ERC'\\t=\\t'EAST RICHFORD, VT     '\\n\",\n",
       " \"   'HIG'\\t=\\t'HIGHGATE SPRINGS, VT  '\\n\",\n",
       " \"   'MOR'\\t=\\t'MORSES LINE, VT       '\\n\",\n",
       " \"   'NPV'\\t=\\t'NEWPORT, VT           '\\n\",\n",
       " \"   'NRT'\\t=\\t'NORTH TROY, VT        '\\n\",\n",
       " \"   'NRN'\\t=\\t'NORTON, VT            '\\n\",\n",
       " \"   'PIV'\\t=\\t'PINNACLE ROAD, VT     '\\n\",\n",
       " \"   'RIF'\\t=\\t'RICHFORT, VT          '\\n\",\n",
       " \"   'STA'\\t=\\t'ST ALBANS, VT         '\\n\",\n",
       " \"   'SWB'\\t=\\t'SWANTON, VT (BP - SECTOR HQ)'\\n\",\n",
       " \"   'WBE'\\t=\\t'WEST BERKSHIRE, VT    '\\n\",\n",
       " \"   'ABE'\\t=\\t'ABERDEEN, WA          '\\n\",\n",
       " \"   'ANA'\\t=\\t'ANACORTES, WA         '\\n\",\n",
       " \"   'BEL'\\t=\\t'BELLINGHAM, WA        '\\n\",\n",
       " \"   'BLI'\\t=\\t'BELLINGHAM, WASHINGTON #INTL'\\n\",\n",
       " \"   'BLA'\\t=\\t'BLAINE, WA            '\\n\",\n",
       " \"   'BWA'\\t=\\t'BOUNDARY, WA          '\\n\",\n",
       " \"   'CUR'\\t=\\t'CURLEW, WA (BPS)'\\n\",\n",
       " \"   'DVL'\\t=\\t'DANVILLE, WA          '\\n\",\n",
       " \"   'EVE'\\t=\\t'EVERETT, WA           '\\n\",\n",
       " \"   'FER'\\t=\\t'FERRY, WA             '\\n\",\n",
       " \"   'FRI'\\t=\\t'FRIDAY HARBOR, WA     '\\n\",\n",
       " \"   'FWA'\\t=\\t'FRONTIER, WA          '\\n\",\n",
       " \"   'KLM'\\t=\\t'KALAMA, WA            '\\n\",\n",
       " \"   'LAU'\\t=\\t'LAURIER, WA           '\\n\",\n",
       " \"   'LON'\\t=\\t'LONGVIEW, WA          '\\n\",\n",
       " \"   'MET'\\t=\\t'METALINE FALLS, WA    '\\n\",\n",
       " \"   'MWH'\\t=\\t'MOSES LAKE GRANT COUNTY ARPT, WA'\\n\",\n",
       " \"   'NEA'\\t=\\t'NEAH BAY, WA          '\\n\",\n",
       " \"   'NIG'\\t=\\t'NIGHTHAWK, WA         '\\n\",\n",
       " \"   'OLY'\\t=\\t'OLYMPIA, WA           '\\n\",\n",
       " \"   'ORO'\\t=\\t'OROVILLE, WA          '\\n\",\n",
       " \"   'PWB'\\t=\\t'PASCO, WA             '\\n\",\n",
       " \"   'PIR'\\t=\\t'POINT ROBERTS, WA     '\\n\",\n",
       " \"   'PNG'\\t=\\t'PORT ANGELES, WA      '\\n\",\n",
       " \"   'PTO'\\t=\\t'PORT TOWNSEND, WA     '\\n\",\n",
       " \"   'SEA'\\t=\\t'SEATTLE, WA           '\\n\",\n",
       " \"   'SPO'\\t=\\t'SPOKANE, WA           '\\n\",\n",
       " \"   'SUM'\\t=\\t'SUMAS, WA             '\\n\",\n",
       " \"   'TAC'\\t=\\t'TACOMA, WA            '\\n\",\n",
       " \"   'PSC'\\t=\\t'TRI-CITIES - PASCO, WA'\\n\",\n",
       " \"   'VAN'\\t=\\t'VANCOUVER, WA         '\\n\",\n",
       " \"   'AGM'\\t=\\t'ALGOMA, WI            '\\n\",\n",
       " \"   'BAY'\\t=\\t'BAYFIELD, WI          '\\n\",\n",
       " \"   'GRB'\\t=\\t'GREEN BAY, WI         '\\n\",\n",
       " \"   'MNW'\\t=\\t'MANITOWOC, WI         '\\n\",\n",
       " \"   'MIL'\\t=\\t'MILWAUKEE, WI         '\\n\",\n",
       " \"   'MSN'\\t=\\t'TRUAX FIELD - DANE COUNTY, WI'\\n\",\n",
       " \"   'CHS'\\t=\\t'CHARLESTON, WV        '\\n\",\n",
       " \"   'CLK'\\t=\\t'CLARKSBURG, WV        '\\n\",\n",
       " \"   'BLF'\\t=\\t'MERCER COUNTY, WV'\\n\",\n",
       " \"   'CSP'\\t=\\t'CASPER, WY            '\\n\",\n",
       " \"   'XXX'\\t=\\t'NOT REPORTED/UNKNOWN  ' \\n\",\n",
       " \"   '888'\\t=\\t'UNIDENTIFED AIR / SEAPORT'\\n\",\n",
       " \"   'UNK'\\t=\\t'UNKNOWN POE           '\\n\",\n",
       " \"   'CLG'\\t=\\t'CALGARY, CANADA       '\\n\",\n",
       " \"   'EDA'\\t=\\t'EDMONTON, CANADA      '\\n\",\n",
       " \"   'YHC'\\t=\\t'HAKAI PASS, CANADA'\\n\",\n",
       " \"   'HAL'\\t=\\t'Halifax, NS, Canada   '\\n\",\n",
       " \"   'MON'\\t=\\t'MONTREAL, CANADA      '\\n\",\n",
       " \"   'OTT'\\t=\\t'OTTAWA, CANADA        '\\n\",\n",
       " \"   'YXE'\\t=\\t'SASKATOON, CANADA'\\n\",\n",
       " \"   'TOR'\\t=\\t'TORONTO, CANADA       '\\n\",\n",
       " \"   'VCV'\\t=\\t'VANCOUVER, CANADA     '\\n\",\n",
       " \"   'VIC'\\t=\\t'VICTORIA, CANADA      '\\n\",\n",
       " \"   'WIN'\\t=\\t'WINNIPEG, CANADA      '\\n\",\n",
       " \"   'AMS'\\t=\\t'AMSTERDAM-SCHIPHOL, NETHERLANDS'\\n\",\n",
       " \"   'ARB'\\t=\\t'ARUBA, NETH ANTILLES  '\\n\",\n",
       " \"   'BAN'\\t=\\t'BANKOK, THAILAND      '\\n\",\n",
       " \"   'BEI'\\t=\\t'BEICA #ARPT, ETHIOPIA'\\n\",\n",
       " \"   'PEK'\\t=\\t'BEIJING CAPITAL INTL, PRC'\\n\",\n",
       " \"   'BDA'\\t=\\t'KINDLEY FIELD, BERMUDA'\\n\",\n",
       " \"   'BOG'\\t=\\t'BOGOTA, EL DORADO #ARPT, COLOMBIA'\\n\",\n",
       " \"   'EZE'\\t=\\t'BUENOS AIRES, MINISTRO PIST, ARGENTINA'\\n\",\n",
       " \"   'CUN'\\t=\\t'CANCUN, MEXICO'\\n\",\n",
       " \"   'CRQ'\\t=\\t'CARAVELAS, BA #ARPT, BRAZIL'\\n\",\n",
       " \"   'MVD'\\t=\\t'CARRASCO, URUGUAY'\\n\",\n",
       " \"   'DUB'\\t=\\t'DUBLIN, IRELAND       '\\n\",\n",
       " \"   'FOU'\\t=\\t'FOUGAMOU #ARPT, GABON'\\n\",\n",
       " \"   'FBA'\\t=\\t'FREEPORT, BAHAMAS      '\\n\",\n",
       " \"   'MTY'\\t=\\t'GEN M. ESCOBEDO, Monterrey, MX'\\n\",\n",
       " \"   'HMO'\\t=\\t'GEN PESQUEIRA GARCIA, MX'\\n\",\n",
       " \"   'GCM'\\t=\\t'GRAND CAYMAN, CAYMAN ISLAND'\\n\",\n",
       " \"   'GDL'\\t=\\t'GUADALAJARA, MIGUEL HIDAL, MX'\\n\",\n",
       " \"   'HAM'\\t=\\t'HAMILTON, BERMUDA     '\\n\",\n",
       " \"   'ICN'\\t=\\t'INCHON, SEOUL KOREA'\\n\",\n",
       " \"   'IWA'\\t=\\t'INVALID - IWAKUNI, JAPAN'\\n\",\n",
       " \"   'CND'\\t=\\t'KOGALNICEANU, ROMANIA'\\n\",\n",
       " \"   'LAH'\\t=\\t'LABUHA ARPT, INDONESIA'\\n\",\n",
       " \"   'DUR'\\t=\\t'LOUIS BOTHA, SOUTH AFRICA'\\n\",\n",
       " \"   'MAL'\\t=\\t'MANGOLE ARPT, INDONESIA'\\n\",\n",
       " \"   'MDE'\\t=\\t'MEDELLIN, COLOMBIA'\\n\",\n",
       " \"   'MEX'\\t=\\t'JUAREZ INTL, MEXICO CITY, MX'\\n\",\n",
       " \"   'LHR'\\t=\\t'MIDDLESEX, ENGLAND'\\n\",\n",
       " \"   'NBO'\\t=\\t'NAIROBI, KENYA        '\\n\",\n",
       " \"   'NAS'\\t=\\t'NASSAU, BAHAMAS       '\\n\",\n",
       " \"   'NCA'\\t=\\t'NORTH CAICOS, TURK & CAIMAN'\\n\",\n",
       " \"   'PTY'\\t=\\t'OMAR TORRIJOS, PANAMA'\\n\",\n",
       " \"   'SPV'\\t=\\t'PAPUA, NEW GUINEA'\\n\",\n",
       " \"   'UIO'\\t=\\t'QUITO (MARISCAL SUCR), ECUADOR'\\n\",\n",
       " \"   'RIT'\\t=\\t'ROME, ITALY           '\\n\",\n",
       " \"   'SNO'\\t=\\t'SAKON NAKHON #ARPT, THAILAND'\\n\",\n",
       " \"   'SLP'\\t=\\t'SAN LUIS POTOSI #ARPT, MEXICO'\\n\",\n",
       " \"   'SAN'\\t=\\t'SAN SALVADOR, EL SALVADOR'\\n\",\n",
       " \"   'SRO'\\t=\\t'SANTANA RAMOS #ARPT, COLOMBIA'\\n\",\n",
       " \"   'GRU'\\t=\\t'GUARULHOS INTL, SAO PAULO, BRAZIL'\\n\",\n",
       " \"   'SHA'\\t=\\t'SHANNON, IRELAND      '\\n\",\n",
       " \"   'HIL'\\t=\\t'SHILLAVO, ETHIOPIA'\\n\",\n",
       " \"   'TOK'\\t=\\t'TOROKINA #ARPT, PAPUA, NEW GUINEA'\\n\",\n",
       " \"   'VER'\\t=\\t'VERACRUZ, MEXICO'\\n\",\n",
       " \"   'LGW'\\t=\\t'WEST SUSSEX, ENGLAND  '\\n\",\n",
       " \"   'ZZZ'\\t=\\t'MEXICO Land (Banco de Mexico) '\\n\",\n",
       " \"   'CHN'\\t=\\t'No PORT Code (CHN)'\\n\",\n",
       " \"   'CNC'\\t=\\t'CANNON CORNERS, NY'\\n\",\n",
       " \"   'MAA'\\t=\\t'Abu Dhabi'\\n\",\n",
       " \"   'AG0'\\t=\\t'MAGNOLIA, AR'\\n\",\n",
       " \"   'BHM'\\t=\\t'BAR HARBOR, ME'\\n\",\n",
       " \"   'BHX'\\t=\\t'BIRMINGHAM, AL'\\n\",\n",
       " \"   'CAK'\\t=\\t'AKRON, OH'\\n\",\n",
       " \"   'FOK'\\t=\\t'SUFFOLK COUNTY, NY'\\n\",\n",
       " \"   'LND'\\t=\\t'LANDER, WY'\\n\",\n",
       " \"   'MAR'\\t=\\t'MARFA, TX'\\n\",\n",
       " \"   'MLI'\\t=\\t'MOLINE, IL'\\n\",\n",
       " \"   'RIV'\\t=\\t'RIVERSIDE, CA'\\n\",\n",
       " \"   'RME'\\t=\\t'ROME, NY'\\n\",\n",
       " \"   'VNY'\\t=\\t'VAN NUYS, CA'\\n\",\n",
       " \"   'YUM'\\t=\\t'YUMA, AZ'\\n\",\n",
       " \"   'FRG'\\t=\\t'Collapsed (FOK) 06/15'\\n\",\n",
       " \"   'HRL'\\t=\\t'Collapsed (HLG) 06/15'\\n\",\n",
       " \"   'ISP'\\t=\\t'Collapsed (FOK) 06/15'\\n\",\n",
       " \"   'JSJ'\\t=\\t'Collapsed (SAJ) 06/15'\\n\",\n",
       " \"   'BUS'\\t=\\t'Collapsed (BUF) 06/15'\\n\",\n",
       " \"   'IAG'\\t=\\t'Collapsed (NIA) 06/15'\\n\",\n",
       " \"   'PHN'\\t=\\t'Collapsed (PHU) 06/15'\\n\",\n",
       " \"   'STN'\\t=\\t'Collapsed (STR) 06/15'\\n\",\n",
       " \"   'VMB'\\t=\\t'Collapsed (VNB) 06/15'\\n\",\n",
       " \"   'T01'\\t=\\t'Collapsed (SEA) 06/15'\\n\",\n",
       " \"   'PHF'\\t=\\t'No PORT Code (PHF)'\\n\",\n",
       " \"   'DRV'\\t=\\t'No PORT Code (DRV)'\\n\",\n",
       " \"   'FTB'\\t=\\t'No PORT Code (FTB)'\\n\",\n",
       " \"   'GAC'\\t=\\t'No PORT Code (GAC)'\\n\",\n",
       " \"   'GMT'\\t=\\t'No PORT Code (GMT)'\\n\",\n",
       " \"   'JFA'\\t=\\t'No PORT Code (JFA)'\\n\",\n",
       " \"   'JMZ'\\t=\\t'No PORT Code (JMZ)'\\n\",\n",
       " \"   'NC8'\\t=\\t'No PORT Code (NC8)'\\n\",\n",
       " \"   'NYL'\\t=\\t'No PORT Code (NYL)'\\n\",\n",
       " \"   'OAI'\\t=\\t'No PORT Code (OAI)'\\n\",\n",
       " \"   'PCW'\\t=\\t'No PORT Code (PCW)'\\n\",\n",
       " \"   'WA5'\\t=\\t'No PORT Code (WAS)'\\n\",\n",
       " \"   'WTR'\\t=\\t'No PORT Code (WTR)'\\n\",\n",
       " \"   'X96'\\t=\\t'No PORT Code (X96)'\\n\",\n",
       " \"   'XNA'\\t=\\t'No PORT Code (XNA)'\\n\",\n",
       " \"   'YGF'\\t=\\t'No PORT Code (YGF)'\\n\",\n",
       " \"   '5T6'\\t=\\t'No PORT Code (5T6)'\\n\",\n",
       " \"   '060'\\t=\\t'No PORT Code (60)'\\n\",\n",
       " \"   'SP0'\\t=\\t'No PORT Code (SP0)'\\n\",\n",
       " \"   'W55'\\t=\\t'No PORT Code (W55)'\\n\",\n",
       " \"   'X44'\\t=\\t'No PORT Code (X44)'\\n\",\n",
       " \"   'AUH'\\t=\\t'No PORT Code (AUH)'\\n\",\n",
       " \"   'RYY'\\t=\\t'No PORT Code (RYY)'\\n\",\n",
       " \"   'SUS'\\t=\\t'No PORT Code (SUS)'\\n\",\n",
       " \"   '74S'\\t=\\t'No PORT Code (74S)'\\n\",\n",
       " \"   'ATW'\\t=\\t'No PORT Code (ATW)'\\n\",\n",
       " \"   'CPX'\\t=\\t'No PORT Code (CPX)'\\n\",\n",
       " \"   'MTH'\\t=\\t'No PORT Code (MTH)'\\n\",\n",
       " \"   'PFN'\\t=\\t'No PORT Code (PFN)'\\n\",\n",
       " \"   'SCH'\\t=\\t'No PORT Code (SCH)'\\n\",\n",
       " \"   'ASI'\\t=\\t'No PORT Code (ASI)'\\n\",\n",
       " \"   'BKF'\\t=\\t'No PORT Code (BKF)'\\n\",\n",
       " \"   'DAY'\\t=\\t'No PORT Code (DAY)'\\n\",\n",
       " \"   'Y62'\\t=\\t'No PORT Code (Y62)'\\n\",\n",
       " \"   'AG'\\t\\t=\\t'No PORT Code (AG)'\\n\",\n",
       " \"   'BCM'\\t=\\t'No PORT Code (BCM)'\\n\",\n",
       " \"   'DEC'\\t=\\t'No PORT Code (DEC)'\\n\",\n",
       " \"   'PLB'\\t=\\t'No PORT Code (PLB)'\\n\",\n",
       " \"   'CXO'\\t=\\t'No PORT Code (CXO)'\\n\",\n",
       " \"   'JBQ'\\t=\\t'No PORT Code (JBQ)'\\n\",\n",
       " \"   'JIG'\\t=\\t'No PORT Code (JIG)'\\n\",\n",
       " \"   'OGS'\\t=\\t'No PORT Code (OGS)'\\n\",\n",
       " \"   'TIW'\\t=\\t'No PORT Code (TIW)'\\n\",\n",
       " \"   'OTS'\\t=\\t'No PORT Code (OTS)'\\n\",\n",
       " \"   'AMT'\\t=\\t'No PORT Code (AMT)'\\n\",\n",
       " \"   'EGE'\\t=\\t'No PORT Code (EGE)'\\n\",\n",
       " \"   'GPI'\\t=\\t'No PORT Code (GPI)'\\n\",\n",
       " \"   'NGL'\\t=\\t'No PORT Code (NGL)'\\n\",\n",
       " \"   'OLM'\\t=\\t'No PORT Code (OLM)'\\n\",\n",
       " \"   '.GA'\\t=\\t'No PORT Code (.GA)'\\n\",\n",
       " \"   'CLX'\\t=\\t'No PORT Code (CLX)'\\n\",\n",
       " \"   'CP '\\t=\\t'No PORT Code (CP)'\\n\",\n",
       " \"   'FSC'\\t=\\t'No PORT Code (FSC)'\\n\",\n",
       " \"   'NK' \\t=\\t'No PORT Code (NK)'\\n\",\n",
       " \"   'ADU' \\t=\\t'No PORT Code (ADU)'\\n\",\n",
       " \"   'AKT' \\t=\\t'No PORT Code (AKT)'\\n\",\n",
       " \"   'LIT' \\t=\\t'No PORT Code (LIT)'\\n\",\n",
       " \"   'A2A' \\t=\\t'No PORT Code (A2A)'\\n\",\n",
       " \"   'OSN' \\t=\\t'No PORT Code (OSN)'\\n\",\n",
       " ';\\n',\n",
       " '\\n',\n",
       " '\\n',\n",
       " '/* ARRDATE is the Arrival Date in the USA. It is a SAS date numeric field that a \\n',\n",
       " '   permament format has not been applied.  Please apply whichever date format \\n',\n",
       " '   works for you. */\\n',\n",
       " '\\n',\n",
       " '\\n',\n",
       " '/* I94MODE - There are missing values as well as not reported (9) */\\n',\n",
       " 'value i94model\\n',\n",
       " \"\\t1 = 'Air'\\n\",\n",
       " \"\\t2 = 'Sea'\\n\",\n",
       " \"\\t3 = 'Land'\\n\",\n",
       " \"\\t9 = 'Not reported' ;\\n\",\n",
       " '\\t\\n',\n",
       " '\\n',\n",
       " '/* I94ADDR - There is lots of invalid codes in this variable and the list below \\n',\n",
       " \"   shows what we have found to be valid, everything else goes into 'other' */\\n\",\n",
       " 'value i94addrl\\n',\n",
       " \"\\t'AL'='ALABAMA'\\n\",\n",
       " \"\\t'AK'='ALASKA'\\n\",\n",
       " \"\\t'AZ'='ARIZONA'\\n\",\n",
       " \"\\t'AR'='ARKANSAS'\\n\",\n",
       " \"\\t'CA'='CALIFORNIA'\\n\",\n",
       " \"\\t'CO'='COLORADO'\\n\",\n",
       " \"\\t'CT'='CONNECTICUT'\\n\",\n",
       " \"\\t'DE'='DELAWARE'\\n\",\n",
       " \"\\t'DC'='DIST. OF COLUMBIA'\\n\",\n",
       " \"\\t'FL'='FLORIDA'\\n\",\n",
       " \"\\t'GA'='GEORGIA'\\n\",\n",
       " \"\\t'GU'='GUAM'\\n\",\n",
       " \"\\t'HI'='HAWAII'\\n\",\n",
       " \"\\t'ID'='IDAHO'\\n\",\n",
       " \"\\t'IL'='ILLINOIS'\\n\",\n",
       " \"\\t'IN'='INDIANA'\\n\",\n",
       " \"\\t'IA'='IOWA'\\n\",\n",
       " \"\\t'KS'='KANSAS'\\n\",\n",
       " \"\\t'KY'='KENTUCKY'\\n\",\n",
       " ...]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "list(lines)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "editable": true
   },
   "source": [
    "# Create lookup_i94cntyl.csv"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "editable": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>key</th>\n",
       "      <th>value</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>255</th>\n",
       "      <td>0</td>\n",
       "      <td>INVALID: STATELESS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>266</th>\n",
       "      <td>54</td>\n",
       "      <td>No Country Code (54)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>267</th>\n",
       "      <td>100</td>\n",
       "      <td>No Country Code (100)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>101</td>\n",
       "      <td>ALBANIA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>102</td>\n",
       "      <td>ANDORRA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>103</td>\n",
       "      <td>AUSTRIA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>104</td>\n",
       "      <td>BELGIUM</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>105</td>\n",
       "      <td>BULGARIA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>242</th>\n",
       "      <td>106</td>\n",
       "      <td>INVALID: CZECHOSLOVAKIA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>167</th>\n",
       "      <td>107</td>\n",
       "      <td>POLAND</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>108</td>\n",
       "      <td>DENMARK</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>109</td>\n",
       "      <td>ESTONIA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69</th>\n",
       "      <td>110</td>\n",
       "      <td>FINLAND</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>111</td>\n",
       "      <td>FRANCE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>112</td>\n",
       "      <td>GERMANY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>113</td>\n",
       "      <td>GREECE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>114</td>\n",
       "      <td>HUNGARY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93</th>\n",
       "      <td>115</td>\n",
       "      <td>ICELAND</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>100</th>\n",
       "      <td>116</td>\n",
       "      <td>IRELAND</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>102</th>\n",
       "      <td>117</td>\n",
       "      <td>ITALY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115</th>\n",
       "      <td>118</td>\n",
       "      <td>LATVIA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>120</th>\n",
       "      <td>119</td>\n",
       "      <td>LIECHTENSTEIN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>121</th>\n",
       "      <td>120</td>\n",
       "      <td>LITHUANIA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>122</th>\n",
       "      <td>121</td>\n",
       "      <td>LUXEMBOURG</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>138</th>\n",
       "      <td>122</td>\n",
       "      <td>MONACO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>147</th>\n",
       "      <td>123</td>\n",
       "      <td>NETHERLANDS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>156</th>\n",
       "      <td>124</td>\n",
       "      <td>NORWAY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>168</th>\n",
       "      <td>126</td>\n",
       "      <td>PORTUGAL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>172</th>\n",
       "      <td>127</td>\n",
       "      <td>ROMANIA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>175</th>\n",
       "      <td>128</td>\n",
       "      <td>SAN MARINO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>241</th>\n",
       "      <td>720</td>\n",
       "      <td>INVALID: CANTON AND ENDERBURY ISLS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>721</td>\n",
       "      <td>CURACAO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>723</td>\n",
       "      <td>FAROE ISLANDS (PART OF DENMARK)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88</th>\n",
       "      <td>726</td>\n",
       "      <td>HEARD AND MCDONALD IS.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>729</td>\n",
       "      <td>INDIAN OCEAN TERRITORY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>247</th>\n",
       "      <td>730</td>\n",
       "      <td>INVALID: INTERNATIONAL WATERS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>248</th>\n",
       "      <td>731</td>\n",
       "      <td>INVALID: JOHNSON ISLAND</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>111</th>\n",
       "      <td>732</td>\n",
       "      <td>KOSOVO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>140</th>\n",
       "      <td>735</td>\n",
       "      <td>MONTENEGRO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>198</th>\n",
       "      <td>736</td>\n",
       "      <td>SAINT MARTIN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>250</th>\n",
       "      <td>737</td>\n",
       "      <td>INVALID: MIDWAY ISLANDS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>243</th>\n",
       "      <td>739</td>\n",
       "      <td>INVALID: DRONNING MAUD LAND (ANTARCTICA-NORWAY)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>252</th>\n",
       "      <td>740</td>\n",
       "      <td>INVALID: NEUTRAL ZONE (S. ARABIA/IRAQ)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>265</th>\n",
       "      <td>741</td>\n",
       "      <td>Collapsed Curacao (should not show)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>160</th>\n",
       "      <td>743</td>\n",
       "      <td>PALESTINE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>180</th>\n",
       "      <td>745</td>\n",
       "      <td>SERBIA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>170</th>\n",
       "      <td>748</td>\n",
       "      <td>REPUBLIC OF SOUTH SUDAN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199</th>\n",
       "      <td>749</td>\n",
       "      <td>SAINT MAARTEN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>251</th>\n",
       "      <td>753</td>\n",
       "      <td>INVALID: MINOR OUTLYING ISLANDS - USA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>263</th>\n",
       "      <td>755</td>\n",
       "      <td>INVALID: WAKE ISLAND</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>228</th>\n",
       "      <td>757</td>\n",
       "      <td>WEST INDIES (FRENCH)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>758</td>\n",
       "      <td>GAZA STRIP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>759</td>\n",
       "      <td>INDIAN OCEAN AREAS (FRENCH)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>135</th>\n",
       "      <td>760</td>\n",
       "      <td>MAYOTTE (AFRICA - FRENCH)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>284</th>\n",
       "      <td>791</td>\n",
       "      <td>No Country Code (791)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>285</th>\n",
       "      <td>849</td>\n",
       "      <td>No Country Code (849)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>286</th>\n",
       "      <td>914</td>\n",
       "      <td>No Country Code (914)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>287</th>\n",
       "      <td>944</td>\n",
       "      <td>No Country Code (944)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>288</th>\n",
       "      <td>996</td>\n",
       "      <td>No Country Code (996)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>259</th>\n",
       "      <td>999</td>\n",
       "      <td>INVALID: UNKNOWN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>289 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     key                                            value\n",
       "255    0                               INVALID: STATELESS\n",
       "266   54                             No Country Code (54)\n",
       "267  100                            No Country Code (100)\n",
       "2    101                                          ALBANIA\n",
       "4    102                                          ANDORRA\n",
       "12   103                                          AUSTRIA\n",
       "18   104                                          BELGIUM\n",
       "31   105                                         BULGARIA\n",
       "242  106                          INVALID: CZECHOSLOVAKIA\n",
       "167  107                                           POLAND\n",
       "55   108                                          DENMARK\n",
       "65   109                                          ESTONIA\n",
       "69   110                                          FINLAND\n",
       "70   111                                           FRANCE\n",
       "77   112                                          GERMANY\n",
       "80   113                                           GREECE\n",
       "92   114                                          HUNGARY\n",
       "93   115                                          ICELAND\n",
       "100  116                                          IRELAND\n",
       "102  117                                            ITALY\n",
       "115  118                                           LATVIA\n",
       "120  119                                    LIECHTENSTEIN\n",
       "121  120                                        LITHUANIA\n",
       "122  121                                       LUXEMBOURG\n",
       "138  122                                           MONACO\n",
       "147  123                                      NETHERLANDS\n",
       "156  124                                           NORWAY\n",
       "168  126                                         PORTUGAL\n",
       "172  127                                          ROMANIA\n",
       "175  128                                       SAN MARINO\n",
       "..   ...                                              ...\n",
       "241  720               INVALID: CANTON AND ENDERBURY ISLS\n",
       "42   721                                          CURACAO\n",
       "54   723                  FAROE ISLANDS (PART OF DENMARK)\n",
       "88   726                           HEARD AND MCDONALD IS.\n",
       "96   729                           INDIAN OCEAN TERRITORY\n",
       "247  730                    INVALID: INTERNATIONAL WATERS\n",
       "248  731                          INVALID: JOHNSON ISLAND\n",
       "111  732                                           KOSOVO\n",
       "140  735                                       MONTENEGRO\n",
       "198  736                                     SAINT MARTIN\n",
       "250  737                          INVALID: MIDWAY ISLANDS\n",
       "243  739  INVALID: DRONNING MAUD LAND (ANTARCTICA-NORWAY)\n",
       "252  740           INVALID: NEUTRAL ZONE (S. ARABIA/IRAQ)\n",
       "265  741              Collapsed Curacao (should not show)\n",
       "160  743                                        PALESTINE\n",
       "180  745                                           SERBIA\n",
       "170  748                          REPUBLIC OF SOUTH SUDAN\n",
       "199  749                                    SAINT MAARTEN\n",
       "251  753            INVALID: MINOR OUTLYING ISLANDS - USA\n",
       "263  755                             INVALID: WAKE ISLAND\n",
       "228  757                             WEST INDIES (FRENCH)\n",
       "75   758                                       GAZA STRIP\n",
       "95   759                      INDIAN OCEAN AREAS (FRENCH)\n",
       "135  760                        MAYOTTE (AFRICA - FRENCH)\n",
       "284  791                            No Country Code (791)\n",
       "285  849                            No Country Code (849)\n",
       "286  914                            No Country Code (914)\n",
       "287  944                            No Country Code (944)\n",
       "288  996                            No Country Code (996)\n",
       "259  999                                 INVALID: UNKNOWN\n",
       "\n",
       "[289 rows x 2 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_i94cntyl = array_to_df(\n",
    "    subset_lookup_lines(\n",
    "        lines,\n",
    "        'i94cntyl',\n",
    "        '  value i94cntyl\\n',\n",
    "        1,\n",
    "        '\\n',\n",
    "        0\n",
    "    )[\"subset\"],\n",
    "    numeric_key=True,\n",
    "    sort_by='key'\n",
    ")\n",
    "df_i94cntyl"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "editable": true
   },
   "outputs": [],
   "source": [
    "df_i94cntyl.to_csv(\n",
    "    OUTPUT_PATH_LKUP_I94CNTYL,\n",
    "    sep=',',\n",
    "    index=False\n",
    ")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "editable": true
   },
   "source": [
    "# Create lookup_i94port.csv"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {
    "editable": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>key</th>\n",
       "      <th>value</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>650</th>\n",
       "      <td>.GA</td>\n",
       "      <td>No PORT Code (.GA)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>618</th>\n",
       "      <td>060</td>\n",
       "      <td>No PORT Code (60)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>212</th>\n",
       "      <td>48Y</td>\n",
       "      <td>PINECREEK BORDER ARPT, MN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>5KE</td>\n",
       "      <td>KETCHIKAN, AK</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>617</th>\n",
       "      <td>5T6</td>\n",
       "      <td>No PORT Code (5T6)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>625</th>\n",
       "      <td>74S</td>\n",
       "      <td>No PORT Code (74S)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>517</th>\n",
       "      <td>888</td>\n",
       "      <td>UNIDENTIFED AIR / SEAPORT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>658</th>\n",
       "      <td>A2A</td>\n",
       "      <td>No PORT Code (A2A)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>475</th>\n",
       "      <td>ABE</td>\n",
       "      <td>ABERDEEN, WA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>457</th>\n",
       "      <td>ABG</td>\n",
       "      <td>ALBURG, VT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>297</th>\n",
       "      <td>ABQ</td>\n",
       "      <td>ALBUQUERQUE, NM</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>456</th>\n",
       "      <td>ABS</td>\n",
       "      <td>ALBURG SPRINGS, VT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>295</th>\n",
       "      <td>ACY</td>\n",
       "      <td>POMONA FIELD - ATLANTIC CITY, NJ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>392</th>\n",
       "      <td>ADS</td>\n",
       "      <td>ADDISON AIRPORT- ADDISON, TX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>393</th>\n",
       "      <td>ADT</td>\n",
       "      <td>AMISTAD DAM, TX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>655</th>\n",
       "      <td>ADU</td>\n",
       "      <td>No PORT Code (ADU)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>149</th>\n",
       "      <td>ADW</td>\n",
       "      <td>ANDREWS AFB, MD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>411</th>\n",
       "      <td>AFW</td>\n",
       "      <td>FORT WORTH ALLIANCE, TX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>635</th>\n",
       "      <td>AG</td>\n",
       "      <td>No PORT Code (AG)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>579</th>\n",
       "      <td>AG0</td>\n",
       "      <td>MAGNOLIA, AR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>114</th>\n",
       "      <td>AGA</td>\n",
       "      <td>AGANA, GU</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>506</th>\n",
       "      <td>AGM</td>\n",
       "      <td>ALGOMA, WI</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>180</th>\n",
       "      <td>AGN</td>\n",
       "      <td>ALGONAC, MI</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>112</th>\n",
       "      <td>AGS</td>\n",
       "      <td>BUSH FIELD - AUGUSTA, GA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>365</th>\n",
       "      <td>AGU</td>\n",
       "      <td>AGUADILLA, PR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>341</th>\n",
       "      <td>AKR</td>\n",
       "      <td>AKRON, OH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>656</th>\n",
       "      <td>AKT</td>\n",
       "      <td>No PORT Code (AKT)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>296</th>\n",
       "      <td>ALA</td>\n",
       "      <td>ALAMAGORDO, NM (BPS)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>311</th>\n",
       "      <td>ALB</td>\n",
       "      <td>ALBANY, NY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>ALC</td>\n",
       "      <td>ALCAN, AK</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>337</th>\n",
       "      <td>WAT</td>\n",
       "      <td>WATERTOWN, NY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>474</th>\n",
       "      <td>WBE</td>\n",
       "      <td>WEST BERKSHIRE, VT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>252</th>\n",
       "      <td>WCM</td>\n",
       "      <td>WILLOW CREEK, MT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>222</th>\n",
       "      <td>WHI</td>\n",
       "      <td>WHITETAIL, MT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>223</th>\n",
       "      <td>WHM</td>\n",
       "      <td>WILD HORSE, MT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>280</th>\n",
       "      <td>WHO</td>\n",
       "      <td>WESTHOPE, ND</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>260</th>\n",
       "      <td>WIL</td>\n",
       "      <td>WILMINGTON, NC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>529</th>\n",
       "      <td>WIN</td>\n",
       "      <td>WINNIPEG, CANADA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79</th>\n",
       "      <td>WLL</td>\n",
       "      <td>WILMINGTON, DE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>281</th>\n",
       "      <td>WND</td>\n",
       "      <td>WILLISTON, ND</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>109</th>\n",
       "      <td>WPB</td>\n",
       "      <td>WEST PALM BEACH, FL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>WRA</td>\n",
       "      <td>WRANGELL, AK</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>339</th>\n",
       "      <td>WRB</td>\n",
       "      <td>WHIRLPOOL BRIDGE, NY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>291</th>\n",
       "      <td>WRI</td>\n",
       "      <td>MC GUIRE AFB - WRIGHTSOWN, NJ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>217</th>\n",
       "      <td>WSB</td>\n",
       "      <td>WARROAD INTL, SPB, MN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>613</th>\n",
       "      <td>WTR</td>\n",
       "      <td>No PORT Code (WTR)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>621</th>\n",
       "      <td>X44</td>\n",
       "      <td>No PORT Code (X44)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>614</th>\n",
       "      <td>X96</td>\n",
       "      <td>No PORT Code (X96)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>615</th>\n",
       "      <td>XNA</td>\n",
       "      <td>No PORT Code (XNA)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>516</th>\n",
       "      <td>XXX</td>\n",
       "      <td>NOT REPORTED/UNKNOWN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>634</th>\n",
       "      <td>Y62</td>\n",
       "      <td>No PORT Code (Y62)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>616</th>\n",
       "      <td>YGF</td>\n",
       "      <td>No PORT Code (YGF)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>521</th>\n",
       "      <td>YHC</td>\n",
       "      <td>HAKAI PASS, CANADA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>195</th>\n",
       "      <td>YIP</td>\n",
       "      <td>WILLOW RUN - YPSILANTI, MI</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>340</th>\n",
       "      <td>YOU</td>\n",
       "      <td>YOUNGSTOWN, NY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>441</th>\n",
       "      <td>YSL</td>\n",
       "      <td>YSLETA, TX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>YUI</td>\n",
       "      <td>YUMA, AZ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>590</th>\n",
       "      <td>YUM</td>\n",
       "      <td>YUMA, AZ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>525</th>\n",
       "      <td>YXE</td>\n",
       "      <td>SASKATOON, CANADA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>575</th>\n",
       "      <td>ZZZ</td>\n",
       "      <td>MEXICO Land (Banco de Mexico)</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>660 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     key                             value\n",
       "650  .GA                No PORT Code (.GA)\n",
       "618  060                 No PORT Code (60)\n",
       "212  48Y         PINECREEK BORDER ARPT, MN\n",
       "11   5KE                     KETCHIKAN, AK\n",
       "617  5T6                No PORT Code (5T6)\n",
       "625  74S                No PORT Code (74S)\n",
       "517  888         UNIDENTIFED AIR / SEAPORT\n",
       "658  A2A                No PORT Code (A2A)\n",
       "475  ABE                      ABERDEEN, WA\n",
       "457  ABG                        ALBURG, VT\n",
       "297  ABQ                   ALBUQUERQUE, NM\n",
       "456  ABS                ALBURG SPRINGS, VT\n",
       "295  ACY  POMONA FIELD - ATLANTIC CITY, NJ\n",
       "392  ADS      ADDISON AIRPORT- ADDISON, TX\n",
       "393  ADT                   AMISTAD DAM, TX\n",
       "655  ADU                No PORT Code (ADU)\n",
       "149  ADW                   ANDREWS AFB, MD\n",
       "411  AFW           FORT WORTH ALLIANCE, TX\n",
       "635   AG                 No PORT Code (AG)\n",
       "579  AG0                      MAGNOLIA, AR\n",
       "114  AGA                         AGANA, GU\n",
       "506  AGM                        ALGOMA, WI\n",
       "180  AGN                       ALGONAC, MI\n",
       "112  AGS          BUSH FIELD - AUGUSTA, GA\n",
       "365  AGU                     AGUADILLA, PR\n",
       "341  AKR                         AKRON, OH\n",
       "656  AKT                No PORT Code (AKT)\n",
       "296  ALA              ALAMAGORDO, NM (BPS)\n",
       "311  ALB                        ALBANY, NY\n",
       "0    ALC                         ALCAN, AK\n",
       "..   ...                               ...\n",
       "337  WAT                     WATERTOWN, NY\n",
       "474  WBE                WEST BERKSHIRE, VT\n",
       "252  WCM                  WILLOW CREEK, MT\n",
       "222  WHI                     WHITETAIL, MT\n",
       "223  WHM                    WILD HORSE, MT\n",
       "280  WHO                      WESTHOPE, ND\n",
       "260  WIL                    WILMINGTON, NC\n",
       "529  WIN                  WINNIPEG, CANADA\n",
       "79   WLL                    WILMINGTON, DE\n",
       "281  WND                     WILLISTON, ND\n",
       "109  WPB               WEST PALM BEACH, FL\n",
       "21   WRA                      WRANGELL, AK\n",
       "339  WRB              WHIRLPOOL BRIDGE, NY\n",
       "291  WRI     MC GUIRE AFB - WRIGHTSOWN, NJ\n",
       "217  WSB             WARROAD INTL, SPB, MN\n",
       "613  WTR                No PORT Code (WTR)\n",
       "621  X44                No PORT Code (X44)\n",
       "614  X96                No PORT Code (X96)\n",
       "615  XNA                No PORT Code (XNA)\n",
       "516  XXX              NOT REPORTED/UNKNOWN\n",
       "634  Y62                No PORT Code (Y62)\n",
       "616  YGF                No PORT Code (YGF)\n",
       "521  YHC                HAKAI PASS, CANADA\n",
       "195  YIP        WILLOW RUN - YPSILANTI, MI\n",
       "340  YOU                    YOUNGSTOWN, NY\n",
       "441  YSL                        YSLETA, TX\n",
       "36   YUI                          YUMA, AZ\n",
       "590  YUM                          YUMA, AZ\n",
       "525  YXE                 SASKATOON, CANADA\n",
       "575  ZZZ     MEXICO Land (Banco de Mexico)\n",
       "\n",
       "[660 rows x 2 columns]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_i94port = array_to_df(\n",
    "    subset_lookup_lines(\n",
    "        lines,\n",
    "        'i94port',\n",
    "        '  value $i94prtl\\n',\n",
    "        1,\n",
    "        ';\\n',\n",
    "        0\n",
    "    )[\"subset\"],\n",
    "    numeric_key=False,\n",
    "    sort_by='key'\n",
    ")\n",
    "df_i94port"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {
    "editable": true
   },
   "outputs": [],
   "source": [
    "df_i94port.to_csv(\n",
    "    OUTPUT_PATH_LKUP_I94PORT,\n",
    "    sep=',',\n",
    "    index=False\n",
    ")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "editable": true
   },
   "source": [
    "# lookup_i94mode.csv"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {
    "editable": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>key</th>\n",
       "      <th>value</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>Air</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>Sea</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>Land</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>9</td>\n",
       "      <td>Not reported</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   key         value\n",
       "0    1           Air\n",
       "1    2           Sea\n",
       "2    3          Land\n",
       "3    9  Not reported"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_i94mode = array_to_df(\n",
    "    subset_lookup_lines(\n",
    "        lines,\n",
    "        'i94mode',\n",
    "        'value i94model\\n',\n",
    "        1,\n",
    "        '\\t\\n',\n",
    "        0\n",
    "    )[\"subset\"],\n",
    "    numeric_key=True,\n",
    "    sort_by='key'\n",
    ")\n",
    "df_i94mode"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {
    "editable": true
   },
   "outputs": [],
   "source": [
    "df_i94mode.to_csv(\n",
    "    OUTPUT_PATH_LKUP_I94MODE,\n",
    "    sep=',',\n",
    "    index=False\n",
    ")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "editable": true
   },
   "source": [
    "# lookup_i94addr.csv"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {
    "editable": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>key</th>\n",
       "      <th>value</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>99</td>\n",
       "      <td>All Other Codes</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>AK</td>\n",
       "      <td>ALASKA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>AL</td>\n",
       "      <td>ALABAMA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>AR</td>\n",
       "      <td>ARKANSAS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>AZ</td>\n",
       "      <td>ARIZONA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>CA</td>\n",
       "      <td>CALIFORNIA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>CO</td>\n",
       "      <td>COLORADO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>CT</td>\n",
       "      <td>CONNECTICUT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>DC</td>\n",
       "      <td>DIST. OF COLUMBIA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>DE</td>\n",
       "      <td>DELAWARE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>FL</td>\n",
       "      <td>FLORIDA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>GA</td>\n",
       "      <td>GEORGIA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>GU</td>\n",
       "      <td>GUAM</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>HI</td>\n",
       "      <td>HAWAII</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>IA</td>\n",
       "      <td>IOWA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>ID</td>\n",
       "      <td>IDAHO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>IL</td>\n",
       "      <td>ILLINOIS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>IN</td>\n",
       "      <td>INDIANA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>KS</td>\n",
       "      <td>KANSAS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>KY</td>\n",
       "      <td>KENTUCKY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>LA</td>\n",
       "      <td>LOUISIANA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>MA</td>\n",
       "      <td>MASSACHUSETTS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>MD</td>\n",
       "      <td>MARYLAND</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>ME</td>\n",
       "      <td>MAINE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>MI</td>\n",
       "      <td>MICHIGAN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>MN</td>\n",
       "      <td>MINNESOTA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>MO</td>\n",
       "      <td>MISSOURI</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>MS</td>\n",
       "      <td>MISSISSIPPI</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>MT</td>\n",
       "      <td>MONTANA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>NC</td>\n",
       "      <td>N. CAROLINA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>ND</td>\n",
       "      <td>N. DAKOTA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>NE</td>\n",
       "      <td>NEBRASKA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>NH</td>\n",
       "      <td>NEW HAMPSHIRE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>NJ</td>\n",
       "      <td>NEW JERSEY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>NM</td>\n",
       "      <td>NEW MEXICO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>NV</td>\n",
       "      <td>NEVADA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>NY</td>\n",
       "      <td>NEW YORK</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>OH</td>\n",
       "      <td>OHIO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>OK</td>\n",
       "      <td>OKLAHOMA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>OR</td>\n",
       "      <td>OREGON</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>PA</td>\n",
       "      <td>PENNSYLVANIA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>PR</td>\n",
       "      <td>PUERTO RICO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>RI</td>\n",
       "      <td>RHODE ISLAND</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>SC</td>\n",
       "      <td>S. CAROLINA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>SD</td>\n",
       "      <td>S. DAKOTA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>TN</td>\n",
       "      <td>TENNESSEE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>TX</td>\n",
       "      <td>TEXAS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>UT</td>\n",
       "      <td>UTAH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>VA</td>\n",
       "      <td>VIRGINIA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>VI</td>\n",
       "      <td>VIRGIN ISLANDS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>VT</td>\n",
       "      <td>VERMONT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>WA</td>\n",
       "      <td>WASHINGTON</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>WI</td>\n",
       "      <td>WISCONSON</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>WV</td>\n",
       "      <td>W. VIRGINIA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>WY</td>\n",
       "      <td>WYOMING</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   key              value\n",
       "54  99    All Other Codes\n",
       "1   AK             ALASKA\n",
       "0   AL            ALABAMA\n",
       "3   AR           ARKANSAS\n",
       "2   AZ            ARIZONA\n",
       "4   CA         CALIFORNIA\n",
       "5   CO           COLORADO\n",
       "6   CT        CONNECTICUT\n",
       "8   DC  DIST. OF COLUMBIA\n",
       "7   DE           DELAWARE\n",
       "9   FL            FLORIDA\n",
       "10  GA            GEORGIA\n",
       "11  GU               GUAM\n",
       "12  HI             HAWAII\n",
       "16  IA               IOWA\n",
       "13  ID              IDAHO\n",
       "14  IL           ILLINOIS\n",
       "15  IN            INDIANA\n",
       "17  KS             KANSAS\n",
       "18  KY           KENTUCKY\n",
       "19  LA          LOUISIANA\n",
       "22  MA      MASSACHUSETTS\n",
       "21  MD           MARYLAND\n",
       "20  ME              MAINE\n",
       "23  MI           MICHIGAN\n",
       "24  MN          MINNESOTA\n",
       "26  MO           MISSOURI\n",
       "25  MS        MISSISSIPPI\n",
       "27  MT            MONTANA\n",
       "28  NC        N. CAROLINA\n",
       "29  ND          N. DAKOTA\n",
       "30  NE           NEBRASKA\n",
       "32  NH      NEW HAMPSHIRE\n",
       "33  NJ         NEW JERSEY\n",
       "34  NM         NEW MEXICO\n",
       "31  NV             NEVADA\n",
       "35  NY           NEW YORK\n",
       "36  OH               OHIO\n",
       "37  OK           OKLAHOMA\n",
       "38  OR             OREGON\n",
       "39  PA       PENNSYLVANIA\n",
       "40  PR        PUERTO RICO\n",
       "41  RI       RHODE ISLAND\n",
       "42  SC        S. CAROLINA\n",
       "43  SD          S. DAKOTA\n",
       "44  TN          TENNESSEE\n",
       "45  TX              TEXAS\n",
       "46  UT               UTAH\n",
       "49  VA           VIRGINIA\n",
       "48  VI     VIRGIN ISLANDS\n",
       "47  VT            VERMONT\n",
       "51  WA         WASHINGTON\n",
       "52  WI          WISCONSON\n",
       "50  WV        W. VIRGINIA\n",
       "53  WY            WYOMING"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_i94addr = array_to_df(\n",
    "    subset_lookup_lines(\n",
    "        lines,\n",
    "        'i94addr',\n",
    "        'value i94addrl\\n',\n",
    "        1,\n",
    "        '\\n',\n",
    "        0\n",
    "    )[\"subset\"],\n",
    "    numeric_key=False,\n",
    "    sort_by='key'\n",
    ")\n",
    "df_i94addr"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {
    "editable": true
   },
   "outputs": [],
   "source": [
    "df_i94addr.to_csv(\n",
    "    OUTPUT_PATH_LKUP_I94ADDR,\n",
    "    sep=',',\n",
    "    index=False\n",
    ")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "editable": true
   },
   "source": [
    "# lookup_i94visa.csv"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {
    "editable": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>key</th>\n",
       "      <th>value</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>Business</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>Pleasure</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>Student</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   key     value\n",
       "0    1  Business\n",
       "1    2  Pleasure\n",
       "2    3   Student"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_i94visa = array_to_df(\n",
    "    subset_lookup_lines(\n",
    "        lines,\n",
    "        'i94visa',\n",
    "        '/* I94VISA - Visa codes collapsed into three categories:\\n',\n",
    "        1,\n",
    "        '*/\\n',\n",
    "        0\n",
    "    )[\"subset\"],\n",
    "    numeric_key=True,\n",
    "    sort_by='key'\n",
    ")\n",
    "df_i94visa"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {
    "editable": true
   },
   "outputs": [],
   "source": [
    "df_i94visa.to_csv(\n",
    "    OUTPUT_PATH_LKUP_I94VISA,\n",
    "    sep=',',\n",
    "    index=False\n",
    ")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "editable": true
   },
   "source": [
    "# Conclusion\n",
    "\n",
    "We have developed a working text parser that is able to extract the unstructured lookup info (from a SAS code / text file), into structured tabular lookup tables (in CSV format). These CSV files may be used downstream to make the consolidated analytical dataset richer. For instance, to include text labels, in additional to just cryptic numeric or letter codes. Analytical teams often find categorial labels like this useful when conducting analysis downstream.\n",
    "\n",
    "We may convert the Jupyter Notebook logic into Python modules or scripts to make this process more repeatable."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "editable": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}