Webscraping.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Scraping the class and year information of patents from the US Patent and Trademark Office website"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "import urllib2\n",
    "import pandas as pd\n",
    "from bs4 import BeautifulSoup\n",
    "from mechanize import Browser"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "patents = pd.read_excel(\"/Users/satrajitmaitra/WebScraping/data/Patents.xlsx\")\n",
    "df = pd.DataFrame(patents)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "pi_list = []\n",
    "for index, row in df.iterrows():\n",
    "    pi_list.append([row['Patent'], row['Inventor_Number']])"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Request the url for all the patent numbers in the dataframe and extract class and year information"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "6295557 0\n",
      "709/709/709/714/\n",
      "5742604 1\n",
      "370/370/\n",
      "6600724 2\n",
      "\n",
      "August 1984/\n",
      "1998\n",
      "5632021 3\n",
      "\n",
      "November 1994/\n",
      "1995\n",
      "6205465 4\n",
      "\n",
      "August 1998/\n",
      "1998\n",
      "5974051 5\n",
      "370/370/710/\n",
      "6205477 6\n",
      "\n",
      "June 1999/\n",
      "1998\n",
      "6078504 7\n",
      "\n",
      "November 1990/\n",
      "1997\n",
      "6049833 8\n",
      "\n",
      "October 1985/\n",
      "1997\n",
      "6049834 9\n",
      "\n",
      "March 1994/\n",
      "1998\n",
      "6115374 10\n",
      "\n",
      "December 1984/\n",
      "1995\n",
      "6205487 11\n",
      "\n",
      "/\n",
      "6424624 12\n",
      "370/370/370/709/\n",
      "1998\n",
      "6088754 13\n",
      "\n",
      "August 1986/\n",
      "1997\n",
      "6285364 14\n",
      "\n",
      "September 1998/\n",
      "1997\n",
      "6366558 15\n",
      "\n",
      "/\n",
      "5742649 16\n",
      "\n",
      "October 1990/\n",
      "1995\n",
      "5802042 17\n",
      "\n",
      "April 1992/\n",
      "1996\n",
      "6256699 18\n",
      "\n",
      "February 1991/\n",
      "1998\n",
      "5854901 19\n",
      "\n",
      "September 1992/\n",
      "1996\n",
      "7233600 20\n",
      "\n",
      "December 1979/\n",
      "1998\n",
      "6339595 21\n",
      "\n",
      "September 1993/\n",
      "1997\n",
      "6473798 22\n",
      "\n",
      "October 1977/\n",
      "1998\n",
      "6424649 23\n",
      "6381646 24\n",
      "6385747 25\n",
      "6377577 26\n",
      "6418543 27\n",
      "7701924 28\n",
      "6101115 29\n",
      "6314110 30\n",
      "6512769 31\n",
      "6058114 32\n",
      "6192491 33\n",
      "6058117 34\n",
      "D0431557 35\n",
      "5884043 36\n",
      "6115468 37\n",
      "5838994 38\n",
      "5970067 39\n",
      "6181572 40\n",
      "6408347 41\n",
      "6178160 42\n",
      "6138019 43\n",
      "7020712 44\n",
      "6052012 45\n",
      "5834925 46\n",
      "6101169 47\n",
      "6490290 48\n",
      "6523060 49\n",
      "6195385 50\n",
      "5905781 51\n",
      "6775840 52\n",
      "5793987 53\n",
      "6240461 54\n",
      "6484175 55\n",
      "6317433 56\n",
      "6615257 57\n",
      "6121693 58\n",
      "5859550 59\n",
      "6230241 60\n",
      "6182267 61\n",
      "6904037 62\n",
      "6330599 63\n",
      "6330600 64\n",
      "5896427 65\n",
      "6470013 66\n",
      "6446121 67\n",
      "6785274 68\n",
      "6148347 69\n",
      "6275797 70\n",
      "6185222 71\n",
      "6246669 72\n",
      "6330645 73\n",
      "5835036 74\n",
      "5959968 75\n",
      "6349092 76\n",
      "6484261 77\n",
      "6215982 78\n",
      "5943604 79\n",
      "5959989 80\n",
      "6252855 81\n",
      "6252878 82\n",
      "6535505 83\n",
      "6115385 84\n",
      "7246168 85\n",
      "6226266 86\n",
      "6345051 87\n",
      "6115386 88\n",
      "6535520 89\n",
      "6965608 90\n",
      "6324585 91\n",
      "6920562 92\n",
      "6549882 93\n",
      "6308219 94\n",
      "5947773 95\n",
      "5812618 96\n",
      "6697360 97\n",
      "5838915 98\n",
      "6101399 99\n",
      "6343072 100\n",
      "6697378 101\n",
      "D0420361 102\n",
      "6115751 103\n",
      "6091725 104\n",
      "6324656 105\n",
      "6044081 106\n",
      "6810040 107\n",
      "5982655 108\n",
      "5898688 109\n",
      "5898691 110\n",
      "6560196 111\n",
      "6072773 112\n",
      "6298055 113\n",
      "6160843 114\n",
      "6512766 115\n",
      "6373838 116\n",
      "7043537 117\n",
      "6513108 118\n",
      "6201813 119\n",
      "5945814 120\n",
      "5898713 121\n",
      "6529498 122\n",
      "6400476 123\n",
      "6775265 124\n",
      "6769124 125\n",
      "6081006 126\n",
      "6236658 127\n",
      "6580723 128\n",
      "6275574 129\n",
      "6154743 130\n",
      "6195705 131\n",
      "6283770 132\n",
      "5898761 133\n",
      "6341132 134\n",
      "6052379 135\n",
      "6427170 136\n",
      "7031333 137\n",
      "6427174 138\n",
      "6390320 139\n",
      "6216244 140\n",
      "6023733 141\n",
      "6092214 142\n",
      "6263369 143\n",
      "6611531 144\n",
      "6707792 145\n",
      "6250936 146\n",
      "6132306 147\n",
      "6212182 148\n",
      "6212183 149\n",
      "5691997 150\n",
      "6351454 151\n",
      "6101599 152\n",
      "6546024 153\n",
      "6085237 154\n",
      "5898687 155\n",
      "6144637 156\n",
      "6445697 157\n",
      "6111877 158\n",
      "6285960 159\n",
      "6640269 160\n",
      "6144658 161\n",
      "6480531 162\n",
      "6111893 163\n",
      "6967961 164\n",
      "6247072 165\n",
      "6128296 166\n",
      "6400681 167\n",
      "6845102 168\n",
      "6128313 169\n",
      "5989060 170\n",
      "6144711 171\n",
      "6320845 172\n",
      "6415061 173\n",
      "5987030 174\n",
      "6286039 175\n",
      "5987034 176\n",
      "6286048 177\n",
      "6286052 178\n",
      "5835494 179\n",
      "6202090 180\n",
      "6460146 181\n",
      "6078590 182\n",
      "5950205 183\n",
      "6202114 184\n",
      "6286084 185\n",
      "6650632 186\n",
      "6522668 187\n",
      "6505228 188\n",
      "6298381 189\n",
      "6253327 190\n",
      "6243088 191\n",
      "6154371 192\n",
      "6122272 193\n",
      "6304546 194\n",
      "6499107 195\n",
      "6122276 196\n",
      "6407985 197\n",
      "6038318 198\n",
      "6038322 199\n",
      "6470453 200\n",
      "6097718 201\n",
      "6304905 202\n",
      "6304575 203\n",
      "6304576 204\n",
      "6032194 205\n",
      "6370119 206\n",
      "6370121 207\n",
      "6181708 208\n",
      "6181711 209\n",
      "6175570 210\n",
      "6226771 211\n",
      "6073176 212\n",
      "6163599 213\n",
      "6370141 214\n",
      "6415321 215\n",
      "6226788 216\n",
      "5867666 217\n",
      "6073199 218\n",
      "6175603 219\n",
      "6570869 220\n",
      "6870847 221\n",
      "5796732 222\n",
      "6032253 223\n",
      "6738814 224\n",
      "6128512 225\n",
      "6065027 226\n",
      "5991300 227\n",
      "5991302 228\n",
      "6134666 229\n",
      "6081419 230\n",
      "6591374 231\n",
      "6073233 232\n",
      "6167445 233\n",
      "6192026 234\n",
      "6430191 235\n",
      "5751710 236\n",
      "6396833 237\n",
      "6134690 238\n",
      "5999524 239\n",
      "6065062 240\n",
      "6718376 241\n",
      "6167027 242\n",
      "5999540 243\n",
      "6134709 244\n",
      "5678006 245\n",
      "6108655 246\n",
      "6636484 247\n",
      "6011851 248\n",
      "5835725 249\n",
      "6628304 250\n",
      "6212561 251\n",
      "5737635 252\n",
      "6091732 253\n",
      "6212569 254\n",
      "6144987 255\n",
      "6259677 256\n",
      "6038694 257\n",
      "6222822 258\n",
      "6269096 259\n",
      "6519635 260\n",
      "6466548 261\n",
      "6466550 262\n",
      "6603774 263\n",
      "6853638 264\n",
      "6292491 265\n",
      "6292495 266\n",
      "6128656 267\n",
      "6128662 268\n",
      "6054942 269\n",
      "6466592 270\n",
      "6282273 271\n",
      "6292516 272\n",
      "6185106 273\n",
      "6490289 274\n",
      "5983272 275\n",
      "5964841 276\n",
      "6446122 277\n",
      "6507563 278\n",
      "6587436 279\n",
      "5909550 280\n",
      "6763017 281\n",
      "6122639 282\n",
      "6317236 283\n",
      "6597694 284\n",
      "6269452 285\n",
      "5864542 286\n",
      "6321255 287\n",
      "6526056 288\n",
      "5799017 289\n",
      "6526060 290\n",
      "6532215 291\n",
      "6272120 292\n",
      "6128761 293\n",
      "5917820 294\n",
      "6493317 295\n",
      "6728839 296\n",
      "6208649 297\n",
      "6108300 298\n",
      "5872783 299\n",
      "5938324 300\n",
      "6446230 301\n",
      "6108312 302\n",
      "6151325 303\n",
      "6487202 304\n",
      "6195739 305\n",
      "5940390 306\n",
      "6175915 307\n",
      "6487214 308\n",
      "6704308 309\n",
      "6442165 310\n",
      "6829242 311\n",
      "6360255 312\n",
      "6223053 313\n",
      "6438102 314\n",
      "6421720 315\n",
      "6151390 316\n",
      "6026464 317\n",
      "6151395 318\n",
      "5952741 319\n",
      "6182119 320\n",
      "6314105 321\n",
      "6647028 322\n",
      "6438133 323\n",
      "6618358 324\n",
      "6388989 325\n",
      "6515967 326\n",
      "6040834 327\n",
      "6182147 328\n",
      "5729546 329\n",
      "6628624 330\n",
      "6061348 331\n",
      "6061349 332\n",
      "6282546 333\n",
      "5930294 334\n",
      "6311226 335\n",
      "6483850 336\n",
      "5905726 337\n",
      "6327618 338\n",
      "5918019 339\n",
      "5918022 340\n",
      "6434120 341\n",
      "6157641 342\n",
      "6507855 343\n",
      "6182224 344\n",
      "6243667 345\n",
      "6006110 346\n",
      "6272351 347\n",
      "6292832 348\n",
      "6765928 349\n",
      "6311275 350\n",
      "6249838 351\n",
      "6163824 352\n",
      "6067573 353\n",
      "6477174 354\n",
      "6061431 355\n",
      "6075769 356\n",
      "6366587 357\n",
      "6178176 358\n",
      "6118791 359\n",
      "6501768 360\n",
      "5991817 361\n",
      "6532493 362\n",
      "6012056 363\n",
      "6141348 364\n",
      "6243749 365\n",
      "6131117 366\n",
      "6366644 367\n",
      "6004150 368\n",
      "6239672 369\n",
      "5787070 370\n",
      "5852607 371\n",
      "6141377 372\n",
      "6347339 373\n",
      "6055364 374\n",
      "6430153 375\n",
      "6430155 376\n",
      "6862284 377\n",
      "6430159 378\n",
      "7116707 379\n",
      "6131163 380\n",
      "6014431 381\n",
      "6870828 382\n",
      "6333931 383\n",
      "6081106 384\n",
      "5852655 385\n",
      "6917617 386\n",
      "6430196 387\n",
      "6335990 388\n",
      "6006268 389\n",
      "6034945 390\n",
      "5805595 391\n",
      "5764636 392\n",
      "6553117 393\n",
      "6209054 394\n",
      "5764641 395\n",
      "6487591 396\n",
      "5666353 397\n",
      "6356530 398\n",
      "6385203 399\n",
      "6278708 400\n",
      "6385208 401\n",
      "6028858 402\n",
      "6643260 403\n",
      "6356548 404\n",
      "6278728 405\n",
      "6510154 406\n",
      "5926475 407\n",
      "6047308 408\n",
      "6684237 409\n",
      "6114897 410\n",
      "6463068 411\n",
      "6588016 412\n",
      "5787255 413\n",
      "6463096 414\n",
      "5973628 415\n",
      "6178429 416\n",
      "6108801 417\n",
      "6157957 418\n",
      "6626953 419\n",
      "5740171 420\n",
      "6104717 421\n",
      "6807185 422\n",
      "6188694 423\n",
      "6219416 424\n",
      "6188698 425\n",
      "6035105 426\n",
      "6381221 427\n",
      "7009962 428\n",
      "6266539 429\n",
      "6778545 430\n",
      "6256309 431\n",
      "6381245 432\n",
      "6473406 433\n",
      "6721824 434\n",
      "6256323 435\n",
      "5770950 436\n",
      "6418125 437\n",
      "6438606 438\n",
      "5999565 439\n",
      "6473424 440\n",
      "6188760 441\n",
      "6158041 442\n",
      "6889181 443\n",
      "6229727 444\n",
      "6704866 445\n",
      "6088430 446\n",
      "5732079 447\n",
      "6141687 448\n",
      "6119160 449\n",
      "6205182 450\n",
      "6295296 451\n",
      "6389506 452\n",
      "6985477 453\n",
      "6393473 454\n",
      "6735625 455\n",
      "6678282 456\n",
      "6332172 457\n",
      "6438678 458\n",
      "7739159 459\n",
      "6754224 460\n",
      "6584108 461\n",
      "6119215 462\n",
      "6502192 463\n",
      "6445704 464\n",
      "6434612 465\n",
      "6308148 466\n",
      "6065980 467\n",
      "6119231 468\n",
      "5953345 469\n",
      "6700872 470\n",
      "6577996 471\n",
      "6266705 472\n",
      "6240084 473\n",
      "6700890 474\n",
      "6700891 475\n",
      "6539237 476\n",
      "6330221 477\n",
      "6445715 478\n",
      "6094708 479\n",
      "6711178 480\n",
      "6434700 481\n",
      "5961619 482\n",
      "7339924 483\n",
      "6147993 484\n",
      "6115226 485\n",
      "6147996 486\n",
      "6510156 487\n",
      "6195107 488\n",
      "5765032 489\n",
      "6301613 490\n",
      "5822383 491\n",
      "6920112 492\n",
      "6219706 493\n",
      "6385653 494\n",
      "6324177 495\n",
      "6563798 496\n",
      "6324185 497\n",
      "5793763 498\n",
      "6301668 499\n",
      "6008805 500\n",
      "6295527 501\n",
      "6611624 502\n",
      "5883893 503\n",
      "6463485 504\n",
      "6295551 505\n"
     ]
    }
   ],
   "source": [
    "browser = Browser()\n",
    "class_list = []\n",
    "year_list = []\n",
    "plist = [pi_list[i][0] for i in range(len(pi_list))]\n",
    "plist = (list(set(plist)))\n",
    "\n",
    "for i in range(len(plist)):\n",
    "    print plist[i], i\n",
    "    browser.set_handle_robots(False)\n",
    "    browser.set_handle_robots(False)\n",
    "    browser.addheaders = [('User-agent','Mozilla/5.0 (X11; Linux x86_64; rv:18.0)Gecko/20100101 Firefox/18.0 (compatible;)'),('Accept', '*/*')]\n",
    "\n",
    "    browser.open(\"http://patft.uspto.gov/netahtml/PTO/search-bool.html\").read()\n",
    "\n",
    "    if len(browser.forms()) != 0:\n",
    "        browser.select_form(nr=0)\n",
    "\n",
    "        browser['TERM1'] = str(plist[i])\n",
    "        browser['FIELD1'] = ['PN']\n",
    "        response = browser.submit()\n",
    "\n",
    "        content = response.read()\n",
    "\n",
    "        soup = BeautifulSoup(content)\n",
    "        info = soup.select('table')\n",
    "        if len(info) > 5:\n",
    "            pnos = info[5].findAll('td')[1].text.split('; ')\n",
    "            patent_class = ''\n",
    "            for no in pnos:\n",
    "                patent_class += no.split('/')[0]+'/'\n",
    "            print patent_class\n",
    "            class_list.append(patent_class)\n",
    "        else:\n",
    "            class_list.append(\"Cannot extract\")\n",
    "        if len(info) > 3:\n",
    "            date = info[3].findAll('b')[-1].text.split(', ')\n",
    "            if len(date) > 1:\n",
    "                year_list.append(date[1])\n",
    "                print date[1]\n",
    "            else:\n",
    "                year_list.append('Cannot extract')\n",
    "        else:\n",
    "            year_list.append('Cannot extract')\n",
    "\n",
    "    "
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Create a coherrent list having all the information"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "combined_list = []\n",
    "for i in range(len(plist)):\n",
    "    for j in range(len(pi_list)):\n",
    "        if plist[i] == pi_list[j][0]:\n",
    "            combined_list.append([plist[i], pi_list[j][1], year_list[i], class_list[i]])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 229,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[[6295557, 348, 'Cannot extract', u'709/709/709/714/'],\n",
       " [6295557, 751, 'Cannot extract', u'709/709/709/714/'],\n",
       " [6295557, 752, 'Cannot extract', u'709/709/709/714/'],\n",
       " [6295557, 1433, 'Cannot extract', u'709/709/709/714/'],\n",
       " [5742604, 497, 'Cannot extract', u'370/370/'],\n",
       " [5742604, 2208, 'Cannot extract', u'370/370/'],\n",
       " [6600724, 1404, u'1998', u'\\nAugust 1984/'],\n",
       " [5632021, 434, u'1995', u'\\nNovember 1994/'],\n",
       " [5632021, 435, u'1995', u'\\nNovember 1994/'],\n",
       " [5632021, 436, u'1995', u'\\nNovember 1994/'],\n",
       " [6205465, 46, u'1998', u'\\nAugust 1998/'],\n",
       " [6205465, 986, u'1998', u'\\nAugust 1998/'],\n",
       " [6205465, 987, u'1998', u'\\nAugust 1998/'],\n",
       " [5974051, 713, 'Cannot extract', u'370/370/710/'],\n",
       " [5974051, 1083, 'Cannot extract', u'370/370/710/'],\n",
       " [6205477, 989, u'1998', u'\\nJune 1999/'],\n",
       " [6205477, 990, u'1998', u'\\nJune 1999/'],\n",
       " [6205477, 991, u'1998', u'\\nJune 1999/'],\n",
       " [6078504, 78, u'1997', u'\\nNovember 1990/'],\n",
       " [6049833, 803, u'1997', u'\\nOctober 1985/'],\n",
       " [6049833, 804, u'1997', u'\\nOctober 1985/'],\n",
       " [6049834, 704, u'1998', u'\\nMarch 1994/'],\n",
       " [6049834, 2208, u'1998', u'\\nMarch 1994/'],\n",
       " [6115374, 98, u'1995', u'\\nDecember 1984/'],\n",
       " [6115374, 486, u'1995', u'\\nDecember 1984/'],\n",
       " [6205487, 139, 'Cannot extract', u'\\n/'],\n",
       " [6205487, 779, 'Cannot extract', u'\\n/'],\n",
       " [6205487, 780, 'Cannot extract', u'\\n/'],\n",
       " [6205487, 781, 'Cannot extract', u'\\n/'],\n",
       " [6205487, 782, 'Cannot extract', u'\\n/'],\n",
       " [6424624, 21, u'1998', u'370/370/370/709/'],\n",
       " [6424624, 413, u'1998', u'370/370/370/709/'],\n",
       " [6424624, 414, u'1998', u'370/370/370/709/'],\n",
       " [6424624, 966, u'1998', u'370/370/370/709/'],\n",
       " [6088754, 126, u'1997', u'\\nAugust 1986/'],\n",
       " [6285364, 1072, u'1997', u'\\nSeptember 1998/'],\n",
       " [6285364, 1073, u'1997', u'\\nSeptember 1998/'],\n",
       " [6366558, 348, 'Cannot extract', u'\\n/'],\n",
       " [6366558, 727, 'Cannot extract', u'\\n/'],\n",
       " [6366558, 751, 'Cannot extract', u'\\n/'],\n",
       " [6366558, 752, 'Cannot extract', u'\\n/'],\n",
       " [6366558, 1155, 'Cannot extract', u'\\n/'],\n",
       " [6366558, 1433, 'Cannot extract', u'\\n/'],\n",
       " [5742649, 42, u'1995', u'\\nOctober 1990/'],\n",
       " [5742649, 499, u'1995', u'\\nOctober 1990/'],\n",
       " [5802042, 540, u'1996', u'\\nApril 1992/'],\n",
       " [5802042, 541, u'1996', u'\\nApril 1992/'],\n",
       " [6256699, 992, u'1998', u'\\nFebruary 1991/'],\n",
       " [5854901, 36, u'1996', u'\\nSeptember 1992/'],\n",
       " [5854901, 1730, u'1996', u'\\nSeptember 1992/'],\n",
       " [7233600, 462, u'1998', u'\\nDecember 1979/'],\n",
       " [7233600, 547, u'1998', u'\\nDecember 1979/'],\n",
       " [6339595, 221, u'1997', u'\\nSeptember 1993/'],\n",
       " [6339595, 643, u'1997', u'\\nSeptember 1993/'],\n",
       " [6473798, 255, u'1998', u'\\nOctober 1977/'],\n",
       " [6473798, 1327, u'1998', u'\\nOctober 1977/'],\n",
       " [6473798, 3264, u'1998', u'\\nOctober 1977/'],\n",
       " [6424649, 1227, 'Cannot extract', u'370/370/370/370/370/'],\n",
       " [6424649, 1228, 'Cannot extract', u'370/370/370/370/370/'],\n",
       " [6381646, 881, u'1998', u'\\nAugust 1993/'],\n",
       " [6381646, 882, u'1998', u'\\nAugust 1993/'],\n",
       " [6381646, 1028, u'1998', u'\\nAugust 1993/'],\n",
       " [6381646, 1029, u'1998', u'\\nAugust 1993/'],\n",
       " [6381646, 1050, u'1998', u'\\nAugust 1993/'],\n",
       " [6385747, 863, u'1998', u'\\nApril 1986/'],\n",
       " [6385747, 864, u'1998', u'\\nApril 1986/'],\n",
       " [6385747, 943, u'1998', u'\\nApril 1986/'],\n",
       " [6385747, 2475, u'1998', u'\\nApril 1986/'],\n",
       " [6377577, 43, 'Cannot extract', u'370/370/370/'],\n",
       " [6377577, 457, 'Cannot extract', u'370/370/370/'],\n",
       " [6418543, 1223, u'1998', u'\\nJanuary 1996/'],\n",
       " [6418543, 1224, u'1998', u'\\nJanuary 1996/'],\n",
       " [6418543, 1225, u'1998', u'\\nJanuary 1996/'],\n",
       " [7701924, 95, u'1998', u'\\nFebruary 1997/'],\n",
       " [7701924, 405, u'1998', u'\\nFebruary 1997/'],\n",
       " [7701924, 573, u'1998', u'\\nFebruary 1997/'],\n",
       " [7701924, 574, u'1998', u'\\nFebruary 1997/'],\n",
       " [6101115, 230, u'1998', u'\\nApril 1992/'],\n",
       " [6314110, 345, u'1998', u'\\nNovember 1995/'],\n",
       " [6314110, 347, u'1998', u'\\nNovember 1995/'],\n",
       " [6314110, 384, u'1998', u'\\nNovember 1995/'],\n",
       " [6314110, 1107, u'1998', u'\\nNovember 1995/'],\n",
       " [6314110, 1108, u'1998', u'\\nNovember 1995/'],\n",
       " [6512769, 113, u'1998', u'\\nFebruary 1993/'],\n",
       " [6512769, 1270, u'1998', u'\\nFebruary 1993/'],\n",
       " [6512769, 1839, u'1998', u'\\nFebruary 1993/'],\n",
       " [6058114, 564, u'1996', u'\\nNovember 1994/'],\n",
       " [6058114, 815, u'1996', u'\\nNovember 1994/'],\n",
       " [6058114, 816, u'1996', u'\\nNovember 1994/'],\n",
       " [6192491, 779, u'1998', u'714/712/'],\n",
       " [6192491, 780, u'1998', u'714/712/'],\n",
       " [6192491, 781, u'1998', u'714/712/'],\n",
       " [6192491, 782, u'1998', u'714/712/'],\n",
       " [6058117, 817, u'1997', u'\\nOctober 1987/'],\n",
       " [6058117, 818, u'1997', u'\\nOctober 1987/'],\n",
       " [6058117, 819, u'1997', u'\\nOctober 1987/'],\n",
       " [6058117, 820, u'1997', u'\\nOctober 1987/'],\n",
       " [u'D0431557', 954, 'Cannot extract', 'Cannot extract'],\n",
       " [5884043, 607, u'1995', u'\\nMay 1991/'],\n",
       " [6115468, 1083, u'1998', u'\\nFebruary 1988/'],\n",
       " [5838994, 461, u'1996', u'\\nMarch 1981/'],\n",
       " [5970067, 71, u'1996', u'370/370/370/370/'],\n",
       " [5970067, 422, u'1996', u'370/370/370/370/'],\n",
       " [5970067, 423, u'1996', u'370/370/370/370/'],\n",
       " [5970067, 424, u'1996', u'370/370/370/370/'],\n",
       " [6181572, 954, u'1998', u'\\nOctober 1970/'],\n",
       " [6408347, 392, 'Cannot extract', u'710/370/707/710/710/713/713/'],\n",
       " [6408347, 1209, 'Cannot extract', u'710/370/707/710/710/713/713/'],\n",
       " [6178160, 892, u'1997', u'\\nJune 1996/'],\n",
       " [6178160, 948, u'1997', u'\\nJune 1996/'],\n",
       " [6138019, 476, u'1996', u'455/455/'],\n",
       " [6138019, 583, u'1996', u'455/455/'],\n",
       " [6138019, 654, u'1996', u'455/455/'],\n",
       " [6138019, 731, u'1996', u'455/455/'],\n",
       " [6138019, 850, u'1996', u'455/455/'],\n",
       " [7020712, 384, u'1998', u'\\nMarch 1992/'],\n",
       " [6052012, 805, 'Cannot extract', u'327/327/327/327/'],\n",
       " [5834925, 165, u'1997', u'\\nJuly 1977/'],\n",
       " [6101169, 861, u'1997', u'\\nFebruary 1995/'],\n",
       " [6490290, 881, 'Cannot extract', u'370/'],\n",
       " [6490290, 1029, 'Cannot extract', u'370/'],\n",
       " [6490290, 1050, 'Cannot extract', u'370/'],\n",
       " [6523060, 1400, u'1995', u'\\nSeptember 1985/'],\n",
       " [6195385, 976, 'Cannot extract', u'375/'],\n",
       " [6195385, 977, 'Cannot extract', u'375/'],\n",
       " [5905781, 253, 'Cannot extract', 'Cannot extract'],\n",
       " [5905781, 458, 'Cannot extract', 'Cannot extract'],\n",
       " [5905781, 519, 'Cannot extract', 'Cannot extract'],\n",
       " [5905781, 520, 'Cannot extract', 'Cannot extract'],\n",
       " [5905781, 632, 'Cannot extract', 'Cannot extract'],\n",
       " [6775840, 535, u'1997', u'\\nJuly 1973/'],\n",
       " [6775840, 1075, u'1997', u'\\nJuly 1973/'],\n",
       " [5793987, 40, 'Cannot extract', u'710/713/'],\n",
       " [5793987, 126, 'Cannot extract', u'710/713/'],\n",
       " [5793987, 347, 'Cannot extract', u'710/713/'],\n",
       " [5793987, 535, 'Cannot extract', u'710/713/'],\n",
       " [5793987, 992, 'Cannot extract', u'710/713/'],\n",
       " [6240461, 532, u'1997', u'709/709/709/709/709/718/'],\n",
       " [6240461, 885, u'1997', u'709/709/709/709/709/718/'],\n",
       " [6240461, 917, u'1997', u'709/709/709/709/709/718/'],\n",
       " [6484175, 1332, u'1998', u'\\nJanuary 1998/'],\n",
       " [6317433, 5, u'1998', u'370/370/370/'],\n",
       " [6317433, 15, u'1998', u'370/370/370/'],\n",
       " [6317433, 21, u'1998', u'370/370/370/'],\n",
       " [6317433, 559, u'1998', u'370/370/370/'],\n",
       " [6615257, 992, u'1998', u'\\nNovember 1993/'],\n",
       " [6615257, 1587, u'1998', u'\\nNovember 1993/'],\n",
       " [6615257, 1588, u'1998', u'\\nNovember 1993/'],\n",
       " [6121693, 887, u'1998', u'\\nJuly 1977/'],\n",
       " [5859550, 504, u'1997', u'327/327/327/327/'],\n",
       " [6230241, 1009, u'1998', u'\\nSeptember 1993/'],\n",
       " [6182267, 434, u'1998', u'\\nNovember 1984/'],\n",
       " [6182267, 508, u'1998', u'\\nNovember 1984/'],\n",
       " [6904037, 295, 'Cannot extract', u'370/370/'],\n",
       " [6904037, 756, 'Cannot extract', u'370/370/'],\n",
       " [6904037, 1021, 'Cannot extract', u'370/370/'],\n",
       " [6330599, 839, u'1998', u'709/709/709/'],\n",
       " [6330600, 901, u'1998', u'709/709/'],\n",
       " [6330600, 902, u'1998', u'709/709/'],\n",
       " [6330600, 903, u'1998', u'709/709/'],\n",
       " [5896427, 499, u'1998', u'375/370/375/'],\n",
       " [5896427, 554, u'1998', u'375/370/375/'],\n",
       " [5896427, 1882, u'1998', u'375/370/375/'],\n",
       " [6470013, 292, 'Cannot extract', u'370/370/'],\n",
       " [6470013, 1321, 'Cannot extract', u'370/370/'],\n",
       " [6470013, 2663, 'Cannot extract', u'370/370/'],\n",
       " [6446121, 990, u'1998', u'\\nAugust 1994/'],\n",
       " [6446121, 991, u'1998', u'\\nAugust 1994/'],\n",
       " [6446121, 1281, u'1998', u'\\nAugust 1994/'],\n",
       " [6785274, 914, u'1998', u'\\nApril 1989/'],\n",
       " [6785274, 915, u'1998', u'\\nApril 1989/'],\n",
       " [6785274, 1280, u'1998', u'\\nApril 1989/'],\n",
       " [6785274, 1613, u'1998', u'\\nApril 1989/'],\n",
       " [6148347, 164, 'Cannot extract', u'710/710/710/'],\n",
       " [6148347, 317, 'Cannot extract', u'710/710/710/'],\n",
       " [6148347, 728, 'Cannot extract', u'710/710/710/'],\n",
       " [6148347, 918, 'Cannot extract', u'710/710/710/'],\n",
       " [6275797, 1061, u'1998', u'\\nSeptember 1988/'],\n",
       " [6185222, 568, u'1995', u'\\nNovember 1986/'],\n",
       " [6246669, 213, u'1998', u'370/370/370/'],\n",
       " [6246669, 311, u'1998', u'370/370/370/'],\n",
       " [6246669, 410, u'1998', u'370/370/370/'],\n",
       " [6246669, 416, u'1998', u'370/370/370/'],\n",
       " [6246669, 559, u'1998', u'370/370/370/'],\n",
       " [6246669, 672, u'1998', u'370/370/370/'],\n",
       " [6246669, 1032, u'1998', u'370/370/370/'],\n",
       " [6330645, 244, u'1998', u'\\nJanuary 1989/'],\n",
       " [5835036, 234, u'1997', u'\\nSeptember 1987/'],\n",
       " [5959968, 124, u'1997', u'\\nMay 1991/'],\n",
       " [5959968, 384, u'1997', u'\\nMay 1991/'],\n",
       " [5959968, 409, u'1997', u'\\nMay 1991/'],\n",
       " [5959968, 2208, u'1997', u'\\nMay 1991/'],\n",
       " [6349092, 257, u'1998', u'\\nAugust 1994/'],\n",
       " [6349092, 469, u'1998', u'\\nAugust 1994/'],\n",
       " [6349092, 1133, u'1998', u'\\nAugust 1994/'],\n",
       " [6349092, 1134, u'1998', u'\\nAugust 1994/'],\n",
       " [6349092, 1135, u'1998', u'\\nAugust 1994/'],\n",
       " [6484261, 906, 'Cannot extract', u'726/715/715/726/'],\n",
       " [6215982, 654, 'Cannot extract', 'Cannot extract'],\n",
       " [5943604, 680, u'1997', u'\\nSeptember 1989/'],\n",
       " [5943604, 681, u'1997', u'\\nSeptember 1989/'],\n",
       " [5959989, 316, u'1997', u'\\nSeptember 1988/'],\n",
       " [5959989, 704, u'1997', u'\\nSeptember 1988/'],\n",
       " [5959989, 2208, u'1997', u'\\nSeptember 1988/'],\n",
       " [6252855, 136, u'1997', u'\\nOctober 1970/'],\n",
       " [6252878, 520, u'1998', u'\\nMay 1988/'],\n",
       " [6252878, 632, u'1998', u'\\nMay 1988/'],\n",
       " [6252878, 738, u'1998', u'\\nMay 1988/'],\n",
       " [6252878, 739, u'1998', u'\\nMay 1988/'],\n",
       " [6252878, 2623, u'1998', u'\\nMay 1988/'],\n",
       " [6535505, 129, u'1998', u'\\nApril 1989/'],\n",
       " [6535505, 1408, u'1998', u'\\nApril 1989/'],\n",
       " [6115385, 826, u'1998', u'\\nSeptember 1989/'],\n",
       " [7246168, 823, u'1997', u'370/370/'],\n",
       " [6226266, 21, u'1998', u'\\nMay 1995/'],\n",
       " [6226266, 239, u'1998', u'\\nMay 1995/'],\n",
       " [6226266, 410, u'1998', u'\\nMay 1995/'],\n",
       " [6226266, 413, u'1998', u'\\nMay 1995/'],\n",
       " [6345051, 39, u'1997', u'\\nNovember 1993/'],\n",
       " [6345051, 768, u'1997', u'\\nNovember 1993/'],\n",
       " [6345051, 1126, u'1997', u'\\nNovember 1993/'],\n",
       " [6345051, 1127, u'1997', u'\\nNovember 1993/'],\n",
       " [6115386, 405, u'1998', u'\\nOctober 1970/'],\n",
       " [6115386, 573, u'1998', u'\\nOctober 1970/'],\n",
       " [6115386, 615, u'1998', u'\\nOctober 1970/'],\n",
       " [6115386, 616, u'1998', u'\\nOctober 1970/'],\n",
       " [6535520, 632, u'1998', u'\\nJuly 1996/'],\n",
       " [6535520, 1177, u'1998', u'\\nJuly 1996/'],\n",
       " [6535520, 1178, u'1998', u'\\nJuly 1996/'],\n",
       " [6535520, 1286, u'1998', u'\\nJuly 1996/'],\n",
       " [6965608, 976, u'1998', u'\\nAugust 1993/'],\n",
       " [6965608, 977, u'1998', u'\\nAugust 1993/'],\n",
       " [6324585, 881, u'1998', u'\\nMay 1986/'],\n",
       " [6324585, 882, u'1998', u'\\nMay 1986/'],\n",
       " [6324585, 884, u'1998', u'\\nMay 1986/'],\n",
       " [6920562, 865, 'Cannot extract', u'703/703/703/703/703/709/709/'],\n",
       " [6920562, 1405, 'Cannot extract', u'703/703/703/703/703/709/709/'],\n",
       " [6549882, 1442, u'1998', u'\\nApril 1992/'],\n",
       " [6549882, 1443, u'1998', u'\\nApril 1992/'],\n",
       " [6308219, 111, u'1997', u'\\nSeptember 1980/'],\n",
       " [5947773, 686, u'1995', u'\\nOctober 1990/'],\n",
       " [5812618, 499, u'1998', u'\\nFebruary 1994/'],\n",
       " [5812618, 554, u'1998', u'\\nFebruary 1994/'],\n",
       " [6697360, 643, u'1997', u'709/370/709/'],\n",
       " [6697360, 776, u'1997', u'709/370/709/'],\n",
       " [6697360, 777, u'1997', u'709/370/709/'],\n",
       " [5838915, 382, u'1995', u'455/342/375/455/455/'],\n",
       " [5838915, 575, u'1995', u'455/342/375/455/455/'],\n",
       " [6101399, 91, u'1997', u'\\nDecember 1978/'],\n",
       " [6101399, 438, u'1997', u'\\nDecember 1978/'],\n",
       " [6101399, 911, u'1997', u'\\nDecember 1978/'],\n",
       " [6101399, 2813, u'1997', u'\\nDecember 1978/'],\n",
       " [6343072, 43, 'Cannot extract', u'370/370/370/370/370/370/'],\n",
       " [6343072, 457, 'Cannot extract', u'370/370/370/370/370/370/'],\n",
       " [6697378, 1393, 'Cannot extract', 'Cannot extract'],\n",
       " [u'D0420361', 954, u'1997', u'\\nNovember 1984/'],\n",
       " [6115751, 673, u'1995', u'\\nApril 1992/'],\n",
       " [6115751, 674, u'1995', u'\\nApril 1992/'],\n",
       " [6091725, 43, u'1998', u'\\nSeptember 1990/'],\n",
       " [6091725, 457, u'1998', u'\\nSeptember 1990/'],\n",
       " [6324656, 1092, u'1997', u'370/370/'],\n",
       " [6324656, 1095, u'1997', u'370/370/'],\n",
       " [6324656, 1096, u'1997', u'370/370/'],\n",
       " [6324656, 1339, u'1997', u'370/370/'],\n",
       " [6044081, 95, 'Cannot extract', u'370/370/709/'],\n",
       " [6044081, 405, 'Cannot extract', u'370/370/709/'],\n",
       " [6810040, 136, u'1998', u'\\nFebruary 1996/'],\n",
       " [6810040, 1743, u'1998', u'\\nFebruary 1996/'],\n",
       " [5982655, 718, u'1996', u'\\nDecember 1994/'],\n",
       " [5898688, 77, u'1996', u'\\nMarch 1987/'],\n",
       " [5898688, 604, u'1996', u'\\nMarch 1987/'],\n",
       " [5898691, 291, u'1998', u'\\nMay 1988/'],\n",
       " [6560196, 1457, u'1997', u'370/370/370/'],\n",
       " [6072773, 215, u'1998', u'\\nSeptember 1997/'],\n",
       " [6072773, 413, u'1998', u'\\nSeptember 1997/'],\n",
       " [6072773, 414, u'1998', u'\\nSeptember 1997/'],\n",
       " [6072773, 559, u'1998', u'\\nSeptember 1997/'],\n",
       " [6298055, 202, u'1997', u'375/370/370/'],\n",
       " [6160843, 458, u'1997', u'\\nJune 1968/'],\n",
       " [6160843, 520, u'1997', u'\\nJune 1968/'],\n",
       " [6160843, 929, u'1997', u'\\nJune 1968/'],\n",
       " [6512766, 345, 'Cannot extract', u'370/370/379/379/379/709/709/709/709/'],\n",
       " [6373838, 1161, u'1997', u'\\nFebruary 1994/'],\n",
       " [6373838, 1162, u'1997', u'\\nFebruary 1994/'],\n",
       " [6373838, 3862, u'1997', u'\\nFebruary 1994/'],\n",
       " [7043537, 910, u'1998', u'\\nAugust 1984/'],\n",
       " [6513108, 434, u'1997', u'\\nDecember 1993/'],\n",
       " [6513108, 863, u'1997', u'\\nDecember 1993/'],\n",
       " [6513108, 864, u'1997', u'\\nDecember 1993/'],\n",
       " [6513108, 865, u'1997', u'\\nDecember 1993/'],\n",
       " [6201813, 382, u'1997', u'\\nJuly 1972/'],\n",
       " [6201813, 568, u'1997', u'\\nJuly 1972/'],\n",
       " [6201813, 981, u'1997', u'\\nJuly 1972/'],\n",
       " [5945814, 683, u'1997', u'\\nMay 1991/'],\n",
       " [5898713, 620, u'1998', u'370/370/'],\n",
       " [5898713, 621, u'1998', u'370/370/'],\n",
       " [5898713, 622, u'1998', u'370/370/'],\n",
       " [5898713, 623, u'1998', u'370/370/'],\n",
       " [5898713, 624, u'1998', u'370/370/'],\n",
       " [5898713, 625, u'1998', u'370/370/'],\n",
       " [6529498, 1404, u'1998', u'398/398/'],\n",
       " [6400476, 628, 'Cannot extract', u'370/370/'],\n",
       " [6775265, 295, 'Cannot extract', u'719/711/711/707/707/711/707/'],\n",
       " [6769124, 46, u'1998', u'\\nJuly 1976/'],\n",
       " [6769124, 986, u'1998', u'\\nJuly 1976/'],\n",
       " [6769124, 987, u'1998', u'\\nJuly 1976/'],\n",
       " [6081006, 197, u'1997', u'\\nMay 1996/'],\n",
       " [6236658, 259, u'1998', u'\\nSeptember 1988/'],\n",
       " [6236658, 557, u'1998', u'\\nSeptember 1988/'],\n",
       " [6580723, 126, u'1998', u'\\nFebruary 1999/'],\n",
       " [6275574, 295, u'1998', u'\\nMay 1990/'],\n",
       " [6154743, 923, u'1998', u'\\nSeptember 1987/'],\n",
       " [6154743, 924, u'1998', u'\\nSeptember 1987/'],\n",
       " [6154743, 925, u'1998', u'\\nSeptember 1987/'],\n",
       " [6195705, 978, 'Cannot extract', 'Cannot extract'],\n",
       " [6283770, 1014, u'1997', u'379/379/379/'],\n",
       " [6283770, 1069, u'1997', u'379/379/379/'],\n",
       " [6283770, 1070, u'1997', u'379/379/379/'],\n",
       " [5898761, 7, u'1998', u'\\nNovember 1992/'],\n",
       " [5898761, 253, u'1998', u'\\nNovember 1992/'],\n",
       " [5898761, 458, u'1998', u'\\nNovember 1992/'],\n",
       " [5898761, 519, u'1998', u'\\nNovember 1992/'],\n",
       " [5898761, 520, u'1998', u'\\nNovember 1992/'],\n",
       " [5898761, 938, u'1998', u'\\nNovember 1992/'],\n",
       " [6341132, 125, 'Cannot extract', u'\\n/'],\n",
       " [6341132, 141, 'Cannot extract', u'\\n/'],\n",
       " [6341132, 186, 'Cannot extract', u'\\n/'],\n",
       " [6341132, 439, 'Cannot extract', u'\\n/'],\n",
       " [6052379, 52, u'1998', u'\\nAugust 1993/'],\n",
       " [6052379, 808, u'1998', u'\\nAugust 1993/'],\n",
       " [6052379, 809, u'1998', u'\\nAugust 1993/'],\n",
       " [6427170, 881, u'1998', u'\\nMay 1988/'],\n",
       " [6427170, 882, u'1998', u'\\nMay 1988/'],\n",
       " [6427170, 884, u'1998', u'\\nMay 1988/'],\n",
       " [6427170, 1029, u'1998', u'\\nMay 1988/'],\n",
       " [6427170, 1030, u'1998', u'\\nMay 1988/'],\n",
       " [7031333, 144, u'1998', u'\\nSeptember 1988/'],\n",
       " [7031333, 238, u'1998', u'\\nSeptember 1988/'],\n",
       " [7031333, 695, u'1998', u'\\nSeptember 1988/'],\n",
       " [7031333, 696, u'1998', u'\\nSeptember 1988/'],\n",
       " [6427174, 882, u'1998', u'\\nJune 1928/'],\n",
       " [6427174, 884, u'1998', u'\\nJune 1928/'],\n",
       " [6427174, 1029, u'1998', u'\\nJune 1928/'],\n",
       " [6427174, 1030, u'1998', u'\\nJune 1928/'],\n",
       " [6427174, 1237, u'1998', u'\\nJune 1928/'],\n",
       " [6390320, 1070, u'1998', u'\\nJune 1987/'],\n",
       " [6390320, 1193, u'1998', u'\\nJune 1987/'],\n",
       " [6390320, 1194, u'1998', u'\\nJune 1987/'],\n",
       " [6216244, 763, u'1997', u'\\nFebruary 1997/'],\n",
       " [6216244, 993, u'1997', u'\\nFebruary 1997/'],\n",
       " [6023733, 212, 'Cannot extract', u'714/370/709/'],\n",
       " [6023733, 240, 'Cannot extract', u'714/370/709/'],\n",
       " [6023733, 241, 'Cannot extract', u'714/370/709/'],\n",
       " [6023733, 494, 'Cannot extract', u'714/370/709/'],\n",
       " [6023733, 495, 'Cannot extract', u'714/370/709/'],\n",
       " [6092214, 853, 'Cannot extract', u'709/709/709/709/'],\n",
       " [6092214, 854, 'Cannot extract', u'709/709/709/709/'],\n",
       " [6263369, 881, u'1998', u'\\nMay 1988/'],\n",
       " [6263369, 884, u'1998', u'\\nMay 1988/'],\n",
       " [6263369, 1049, u'1998', u'\\nMay 1988/'],\n",
       " [6263369, 1050, u'1998', u'\\nMay 1988/'],\n",
       " [6263369, 1051, u'1998', u'\\nMay 1988/'],\n",
       " [6611531, 129, u'1998', u'\\nApril 1985/'],\n",
       " [6611531, 1579, u'1998', u'\\nApril 1985/'],\n",
       " [6707792, 873, 'Cannot extract', u'439/333/439/'],\n",
       " [6707792, 874, 'Cannot extract', u'439/333/439/'],\n",
       " [6707792, 875, 'Cannot extract', u'439/333/439/'],\n",
       " [6250936, 1039, u'1996', u'455/375/455/'],\n",
       " [6250936, 1040, u'1996', u'455/375/455/'],\n",
       " [6250936, 1041, u'1996', u'455/375/455/'],\n",
       " [6132306, 654, u'1996', u'\\nApril 1992/'],\n",
       " [6212182, 173, u'1997', u'\\nApril 1992/'],\n",
       " [6212183, 345, u'1995', u'\\nJune 1992/'],\n",
       " [5691997, 42, u'1998', u'\\nJuly 1985/'],\n",
       " [6351454, 945, u'1998', u'\\nMay 1986/'],\n",
       " [6351454, 1136, u'1998', u'\\nMay 1986/'],\n",
       " [6101599, 434, u'1998', u'\\nNovember 1988/'],\n",
       " [6101599, 863, u'1998', u'\\nNovember 1988/'],\n",
       " [6101599, 864, u'1998', u'\\nNovember 1988/'],\n",
       " [6101599, 865, u'1998', u'\\nNovember 1988/'],\n",
       " [6546024, 52, 'Cannot extract', u'709/'],\n",
       " [6546024, 976, 'Cannot extract', u'709/'],\n",
       " [6546024, 977, 'Cannot extract', u'709/'],\n",
       " [6546024, 1422, 'Cannot extract', u'709/'],\n",
       " [6546024, 1423, 'Cannot extract', u'709/'],\n",
       " [6085237, 848, u'1996', u'\\nMarch 1988/'],\n",
       " [6085237, 849, u'1996', u'\\nMarch 1988/'],\n",
       " [5898687, 244, u'1997', u'370/370/'],\n",
       " [5898687, 619, u'1997', u'370/370/'],\n",
       " [6144637, 187, u'1998', u'\\nSeptember 1994/'],\n",
       " [6144637, 527, u'1998', u'\\nSeptember 1994/'],\n",
       " [6144637, 1088, u'1998', u'\\nSeptember 1994/'],\n",
       " [6445697, 1278, u'1997', u'\\nApril 1992/'],\n",
       " [6111877, 345, u'1998', u'\\nMarch 1991/'],\n",
       " [6111877, 872, u'1998', u'\\nMarch 1991/'],\n",
       " [6285960, 535, 'Cannot extract', u'710/710/710/710/710/710/710/710/710/707/'],\n",
       " [6285960, 681, 'Cannot extract', u'710/710/710/710/710/710/710/710/710/707/'],\n",
       " [6285960,\n",
       "  1074,\n",
       "  'Cannot extract',\n",
       "  u'710/710/710/710/710/710/710/710/710/707/'],\n",
       " [6285960,\n",
       "  1075,\n",
       "  'Cannot extract',\n",
       "  u'710/710/710/710/710/710/710/710/710/707/'],\n",
       " [6285960,\n",
       "  1076,\n",
       "  'Cannot extract',\n",
       "  u'710/710/710/710/710/710/710/710/710/707/'],\n",
       " [6285960,\n",
       "  1077,\n",
       "  'Cannot extract',\n",
       "  u'710/710/710/710/710/710/710/710/710/707/'],\n",
       " [6640269, 1332, u'1997', u'370/370/375/'],\n",
       " [6144658, 162, u'1998', u'\\nMay 1983/'],\n",
       " [6144658, 239, u'1998', u'\\nMay 1983/'],\n",
       " [6144658, 314, u'1998', u'\\nMay 1983/'],\n",
       " [6144658, 411, u'1998', u'\\nMay 1983/'],\n",
       " [6480531, 868, u'1997', u'\\nFebruary 1994/'],\n",
       " [6111893, 418, u'1998', u'\\nJune 1993/'],\n",
       " [6111893, 873, u'1998', u'\\nJune 1993/'],\n",
       " [6111893, 874, u'1998', u'\\nJune 1993/'],\n",
       " [6111893, 875, u'1998', u'\\nJune 1993/'],\n",
       " [6111893, 876, u'1998', u'\\nJune 1993/'],\n",
       " [6111893, 877, u'1998', u'\\nJune 1993/'],\n",
       " [6967961, 113, u'1998', u'\\nJanuary 1990/'],\n",
       " [6967961, 1270, u'1998', u'\\nJanuary 1990/'],\n",
       " [6967961, 1839, u'1998', u'\\nJanuary 1990/'],\n",
       " [6247072, 4446, u'1997', u'\\nFebruary 1991/'],\n",
       " [6128296, 384, u'1997', u'370/370/370/370/370/370/709/709/'],\n",
       " [6128296, 898, u'1997', u'370/370/370/370/370/370/709/709/'],\n",
       " [6400681, 21, 'Cannot extract', u'370/370/'],\n",
       " [6400681, 133, 'Cannot extract', u'370/370/'],\n",
       " [6400681, 311, 'Cannot extract', u'370/370/'],\n",
       " [6400681, 410, 'Cannot extract', u'370/370/'],\n",
       " [6400681, 559, 'Cannot extract', u'370/370/'],\n",
       " [6845102, 388, 'Cannot extract', u'370/370/'],\n",
       " [6845102, 2016, 'Cannot extract', u'370/370/'],\n",
       " [6845102, 2017, 'Cannot extract', u'370/370/'],\n",
       " [6128313, 126, u'1997', u'439/439/714/'],\n",
       " [6128313, 899, u'1997', u'439/439/714/'],\n",
       " [5989060, 533, 'Cannot extract', u'375/375/375/'],\n",
       " [5989060, 727, 'Cannot extract', u'375/375/375/'],\n",
       " [6144711, 438, u'1998', u'\\nApril 1995/'],\n",
       " [6144711, 551, u'1998', u'\\nApril 1995/'],\n",
       " [6144711, 911, u'1998', u'\\nApril 1995/'],\n",
       " [6320845, 1380, u'1998', u'382/382/'],\n",
       " [6415061, 125, u'1996', u'\\nDecember 1993/'],\n",
       " [6415061, 140, u'1996', u'\\nDecember 1993/'],\n",
       " [6415061, 141, u'1996', u'\\nDecember 1993/'],\n",
       " [6415061, 439, u'1996', u'\\nDecember 1993/'],\n",
       " [5987030, 605, 'Cannot extract', u'\\n/'],\n",
       " [5987030, 722, 'Cannot extract', u'\\n/'],\n",
       " [6286039, 70, u'1996', u'\\nMay 1994/'],\n",
       " [6286039, 725, u'1996', u'\\nMay 1994/'],\n",
       " [6286039, 726, u'1996', u'\\nMay 1994/'],\n",
       " [5987034, 145, u'1998', u'\\nFebruary 1992/'],\n",
       " [5987034, 604, u'1998', u'\\nFebruary 1992/'],\n",
       " [5987034, 723, u'1998', u'\\nFebruary 1992/'],\n",
       " [5987034, 724, u'1998', u'\\nFebruary 1992/'],\n",
       " [6286048, 1078, u'1998', u'\\nSeptember 1988/'],\n",
       " [6286052, 776, u'1997', u'370/370/370/'],\n",
       " [6286052, 777, u'1997', u'370/370/370/'],\n",
       " [6286052, 1080, u'1997', u'370/370/370/'],\n",
       " [5835494, 382, u'1997', u'\\nMarch 1992/'],\n",
       " [5835494, 568, u'1997', u'\\nMarch 1992/'],\n",
       " [6202090, 982, u'1998', u'\\nApril 1989/'],\n",
       " [6460146, 1078, u'1997', u'\\nApril 1992/'],\n",
       " [6460146, 1300, u'1997', u'\\nApril 1992/'],\n",
       " [6078590, 353, u'1997', u'\\nMay 1989/'],\n",
       " [6078590, 643, u'1997', u'\\nMay 1989/'],\n",
       " [5950205, 693, u'1997', u'\\nAugust 1984/'],\n",
       " [6202114, 776, u'1998', u'\\nAugust 1987/'],\n",
       " [6202114, 777, u'1998', u'\\nAugust 1987/'],\n",
       " [6202114, 778, u'1998', u'\\nAugust 1987/'],\n",
       " [6286084, 359, u'1998', u'\\nDecember 1976/'],\n",
       " [6286084, 1081, u'1998', u'\\nDecember 1976/'],\n",
       " [6650632, 873, u'1998', u'\\nOctober 1970/'],\n",
       " [6650632, 874, u'1998', u'\\nOctober 1970/'],\n",
       " [6650632, 875, u'1998', u'\\nOctober 1970/'],\n",
       " [6650632, 877, u'1998', u'\\nOctober 1970/'],\n",
       " [6650632, 1481, u'1998', u'\\nOctober 1970/'],\n",
       " [6650632, 1644, u'1998', u'\\nOctober 1970/'],\n",
       " [6522668, 938, u'1998', u'\\nFebruary 1995/'],\n",
       " [6522668, 1287, u'1998', u'\\nFebruary 1995/'],\n",
       " [6522668, 1396, u'1998', u'\\nFebruary 1995/'],\n",
       " [6522668, 1397, u'1998', u'\\nFebruary 1995/'],\n",
       " [6505228, 46, u'1998', u'\\nAugust 1994/'],\n",
       " [6505228, 986, u'1998', u'\\nAugust 1994/'],\n",
       " [6505228, 987, u'1998', u'\\nAugust 1994/'],\n",
       " [6298381, 989, 'Cannot extract', u'726/'],\n",
       " [6298381, 990, 'Cannot extract', u'726/'],\n",
       " [6253327, 881, 'Cannot extract', u'715/715/'],\n",
       " [6253327, 882, 'Cannot extract', u'715/715/'],\n",
       " [6243088, 893, u'1998', u'\\nApril 1987/'],\n",
       " [6243088, 1023, u'1998', u'\\nApril 1987/'],\n",
       " [6243088, 1024, u'1998', u'\\nApril 1987/'],\n",
       " [6243088, 3124, u'1998', u'\\nApril 1987/'],\n",
       " [6154371, 831, u'1997', u'\\nApril 1992/'],\n",
       " [6154371, 921, u'1997', u'\\nApril 1992/'],\n",
       " [6154371, 922, u'1997', u'\\nApril 1992/'],\n",
       " [6122272, 888, u'1996', u'\\nApril 1992/'],\n",
       " [6122272, 889, u'1996', u'\\nApril 1992/'],\n",
       " [6122272, 890, u'1996', u'\\nApril 1992/'],\n",
       " [6304546, 540, u'1998', u'\\nJuly 1991/'],\n",
       " [6304546, 541, u'1998', u'\\nJuly 1991/'],\n",
       " [6499107, 1092, u'1997', u'\\nOctober 1985/'],\n",
       " [6499107, 1094, u'1997', u'\\nOctober 1985/'],\n",
       " [6499107, 1356, u'1997', u'\\nOctober 1985/'],\n",
       " [6122276, 804, u'1998', u'\\nFebruary 1992/'],\n",
       " [6122276, 892, u'1998', u'\\nFebruary 1992/'],\n",
       " [6407985, 313, u'1998', u'\\nApril 1980/'],\n",
       " [6038318, 790, u'1998', u'\\nSeptember 1990/'],\n",
       " [6038322, 791, u'1998', u'\\nMarch 1997/'],\n",
       " [6470453, 1326, u'1996', u'\\nApril 1992/'],\n",
       " [6097718, 860, u'1998', u'\\nOctober 1988/'],\n",
       " [6304905, 1101, u'1998', u'\\nMay 1990/'],\n",
       " [6304575, 243, u'1998', u'370/370/'],\n",
       " [6304575, 313, u'1998', u'370/370/'],\n",
       " [6304575, 1097, u'1998', u'370/370/'],\n",
       " [6304575, 1098, u'1998', u'370/370/'],\n",
       " [6304576, 95, u'1997', u'\\nMay 1990/'],\n",
       " [6304576, 571, u'1997', u'\\nMay 1990/'],\n",
       " [6304576, 572, u'1997', u'\\nMay 1990/'],\n",
       " [6304576, 573, u'1997', u'\\nMay 1990/'],\n",
       " [6304576, 574, u'1997', u'\\nMay 1990/'],\n",
       " [6304576, 1754, u'1997', u'\\nMay 1990/'],\n",
       " [6032194, 776, u'1998', u'370/'],\n",
       " [6032194, 777, u'1998', u'370/'],\n",
       " [6032194, 778, u'1998', u'370/'],\n",
       " [6370119, 191, u'1998', u'\\nDecember 1978/'],\n",
       " [6370119, 1157, u'1998', u'\\nDecember 1978/'],\n",
       " [6370121, 409, 'Cannot extract', u'370/370/'],\n",
       " [6181708, 40, u'1997', u'\\nFebruary 1996/'],\n",
       " [6181708, 384, u'1997', u'\\nFebruary 1996/'],\n",
       " [6181708, 435, u'1997', u'\\nFebruary 1996/'],\n",
       " [6181711, 32, u'1996', u'370/370/370/370/370/'],\n",
       " [6181711, 585, u'1996', u'370/370/370/370/370/'],\n",
       " [6181711, 595, u'1996', u'370/370/370/370/370/'],\n",
       " [6175570, 30, u'1998', u'\\nApril 1992/'],\n",
       " [6175570, 158, u'1998', u'\\nApril 1992/'],\n",
       " [6175570, 203, u'1998', u'\\nApril 1992/'],\n",
       " [6175570, 252, u'1998', u'\\nApril 1992/'],\n",
       " [6175570, 862, u'1998', u'\\nApril 1992/'],\n",
       " [6226771, 434, u'1997', u'709/709/709/709/709/709/'],\n",
       " [6226771, 857, u'1997', u'709/709/709/709/709/709/'],\n",
       " [6226771, 1005, u'1997', u'709/709/709/709/709/709/'],\n",
       " [6226771, 1006, u'1997', u'709/709/709/709/709/709/'],\n",
       " [6073176, 201, u'1997', u'379/379/379/'],\n",
       " [6073176, 838, u'1997', u'379/379/379/'],\n",
       " [6073176, 839, u'1997', u'379/379/379/'],\n",
       " [6073176, 840, u'1997', u'379/379/379/'],\n",
       " [6073176, 841, u'1997', u'379/379/379/'],\n",
       " [6163599, 458, u'1998', u'\\nJune 1988/'],\n",
       " [6370141, 1072, u'1998', u'\\nJuly 1991/'],\n",
       " [6370141, 1158, u'1998', u'\\nJuly 1991/'],\n",
       " [6415321, 1092, u'1998', u'\\nApril 1993/'],\n",
       " [6415321, 1095, u'1998', u'\\nApril 1993/'],\n",
       " [6415321, 1222, u'1998', u'\\nApril 1993/'],\n",
       " [6226788, 46, u'1997', u'709/709/'],\n",
       " [6226788, 986, u'1997', u'709/709/'],\n",
       " [6226788, 987, u'1997', u'709/709/'],\n",
       " [5867666, 839, u'1997', u'\\nDecember 1980/'],\n",
       " [6073199, 492, 'Cannot extract', u'375/327/327/327/375/'],\n",
       " [6073199, 842, 'Cannot extract', u'375/327/327/327/375/'],\n",
       " [6175603, 126, u'1998', u'\\nApril 1985/'],\n",
       " [6175603, 945, u'1998', u'\\nApril 1985/'],\n",
       " [6175603, 946, u'1998', u'\\nApril 1985/'],\n",
       " [6570869, 38, u'1997', u'\\nMarch 1991/'],\n",
       " [6570869, 568, u'1997', u'\\nMarch 1991/'],\n",
       " [6570869, 875, u'1997', u'\\nMarch 1991/'],\n",
       " [6570869, 1480, u'1997', u'\\nMarch 1991/'],\n",
       " [6570869, 1481, u'1997', u'\\nMarch 1991/'],\n",
       " [6570869, 1482, u'1997', u'\\nMarch 1991/'],\n",
       " [6870847, 568, u'1996', u'\\nAugust 1989/'],\n",
       " [6870847, 2075, u'1996', u'\\nAugust 1989/'],\n",
       " [5796732, 61, 'Cannot extract', u'\\n/'],\n",
       " [5796732, 62, 'Cannot extract', u'\\n/'],\n",
       " [5796732, 63, 'Cannot extract', u'\\n/'],\n",
       " [5796732, 497, 'Cannot extract', u'\\n/'],\n",
       " [6032253, 779, 'Cannot extract', u'709/709/726/'],\n",
       " [6032253, 780, 'Cannot extract', u'709/709/726/'],\n",
       " [6032253, 781, 'Cannot extract', u'709/709/726/'],\n",
       " [6032253, 782, 'Cannot extract', u'709/709/726/'],\n",
       " [6738814, 739, u'1997', u'455/375/379/455/455/455/'],\n",
       " [6738814, 1814, u'1997', u'455/375/379/455/455/455/'],\n",
       " [6128512, 583, u'1998', u'708/379/712/'],\n",
       " [6128512, 654, u'1998', u'708/379/712/'],\n",
       " [6065027, 779, u'1998', u'\\nSeptember 1993/'],\n",
       " [6065027, 780, u'1998', u'\\nSeptember 1993/'],\n",
       " [6065027, 781, u'1998', u'\\nSeptember 1993/'],\n",
       " [6065027, 782, u'1998', u'\\nSeptember 1993/'],\n",
       " [6065027, 827, u'1998', u'\\nSeptember 1993/'],\n",
       " [5991300, 288, u'1997', u'\\nMay 1990/'],\n",
       " [5991302, 241, 'Cannot extract', u'713/713/713/'],\n",
       " [5991302, 673, 'Cannot extract', u'713/713/713/'],\n",
       " [6134666, 1083, u'1998', u'\\nJuly 1979/'],\n",
       " [6081419, 122, u'1995', u'\\nMay 1989/'],\n",
       " [6591374, 486, u'1997', u'\\nFebruary 1989/'],\n",
       " [6591374, 1525, u'1997', u'\\nFebruary 1989/'],\n",
       " [6073233, 126, u'1998', u'\\nSeptember 1988/'],\n",
       " [6167445, 776, u'1998', u'\\nJanuary 1999/'],\n",
       " [6167445, 777, u'1998', u'\\nJanuary 1999/'],\n",
       " [6192026, 438, u'1997', u'\\nFebruary 1984/'],\n",
       " [6192026, 551, u'1997', u'\\nFebruary 1984/'],\n",
       " [6192026, 911, u'1997', u'\\nFebruary 1984/'],\n",
       " [6430191, 106, u'1996', u'\\nApril 1989/'],\n",
       " [6430191, 266, u'1996', u'\\nApril 1989/'],\n",
       " [6430191, 267, u'1996', u'\\nApril 1989/'],\n",
       " [6430191, 382, u'1996', u'\\nApril 1989/'],\n",
       " [6430191, 568, u'1996', u'\\nApril 1989/'],\n",
       " [6430191, 981, u'1996', u'\\nApril 1989/'],\n",
       " [6430191, 1245, u'1996', u'\\nApril 1989/'],\n",
       " [5751710, 19, u'1998', u'\\nAugust 1993/'],\n",
       " [5751710, 504, u'1998', u'\\nAugust 1993/'],\n",
       " [6396833, 521, u'1998', u'\\nOctober 1987/'],\n",
       " [6396833, 881, u'1998', u'\\nOctober 1987/'],\n",
       " [6396833, 882, u'1998', u'\\nOctober 1987/'],\n",
       " [6396833, 1028, u'1998', u'\\nOctober 1987/'],\n",
       " [6396833, 1029, u'1998', u'\\nOctober 1987/'],\n",
       " [6396833, 1050, u'1998', u'\\nOctober 1987/'],\n",
       " [6134690, 241, u'1996', u'\\nDecember 1995/'],\n",
       " [6134690, 909, u'1996', u'\\nDecember 1995/'],\n",
       " [5999524, 71, u'1997', u'\\nFebruary 1990/'],\n",
       " [5999524, 232, u'1997', u'\\nFebruary 1990/'],\n",
       " [5999524, 734, u'1997', u'\\nFebruary 1990/'],\n",
       " [5999524, 735, u'1997', u'\\nFebruary 1990/'],\n",
       " [5999524, 736, u'1997', u'\\nFebruary 1990/'],\n",
       " [5999524, 737, u'1997', u'\\nFebruary 1990/'],\n",
       " [6065062, 212, 'Cannot extract', u'709/370/709/714/714/'],\n",
       " [6065062, 240, 'Cannot extract', u'709/370/709/714/714/'],\n",
       " [6065062, 241, 'Cannot extract', u'709/370/709/714/714/'],\n",
       " [6065062, 493, 'Cannot extract', u'709/370/709/714/714/'],\n",
       " [6065062, 495, 'Cannot extract', u'709/370/709/714/714/'],\n",
       " [6718376, 884, u'1997', u'370/370/370/370/'],\n",
       " [6718376, 1050, u'1997', u'370/370/370/370/'],\n",
       " [6718376, 1051, u'1997', u'370/370/370/370/'],\n",
       " [6167027, 55, u'1998', u'\\nOctober 1970/'],\n",
       " [6167027, 305, u'1998', u'\\nOctober 1970/'],\n",
       " [6167027, 934, u'1998', u'\\nOctober 1970/'],\n",
       " [6167027, 935, u'1998', u'\\nOctober 1970/'],\n",
       " [6167027, 936, u'1998', u'\\nOctober 1970/'],\n",
       " [6167027, 937, u'1998', u'\\nOctober 1970/'],\n",
       " [5999540, 1450, u'1998', u'\\nJanuary 1996/'],\n",
       " [6134709, 910, u'1996', u'709/709/709/'],\n",
       " [5678006, 461, u'1997', u'\\nJune 1994/'],\n",
       " [5678006, 462, u'1997', u'\\nJune 1994/'],\n",
       " [6108655, 46, u'1998', u'\\nJune 1984/'],\n",
       " [6108655, 48, u'1998', u'\\nJune 1984/'],\n",
       " [6108655, 280, u'1998', u'\\nJune 1984/'],\n",
       " [6636484, 462, u'1997', u'\\nMarch 1985/'],\n",
       " [6636484, 1240, u'1997', u'\\nMarch 1985/'],\n",
       " [6636484, 1637, u'1997', u'\\nMarch 1985/'],\n",
       " [6011851, 295, u'1996', u'\\nJuly 1987/'],\n",
       " [6011851, 755, u'1996', u'\\nJuly 1987/'],\n",
       " [6011851, 756, u'1996', u'\\nJuly 1987/'],\n",
       " [5835725, 569, 'Cannot extract', u'715/715/715/'],\n",
       " [5835725, 570, 'Cannot extract', u'715/715/715/'],\n",
       " [6628304, 1610, u'1998', u'\\nMay 1990/'],\n",
       " [6628304, 1611, u'1998', u'\\nMay 1990/'],\n",
       " [6212561, 881, u'1996', u'710/709/709/709/710/'],\n",
       " [6212561, 882, u'1996', u'710/709/709/709/710/'],\n",
       " [6212561, 884, u'1996', u'710/709/709/709/710/'],\n",
       " [5737635, 84, u'1997', u'\\nMay 1992/'],\n",
       " [5737635, 329, u'1997', u'\\nMay 1992/'],\n",
       " [5737635, 409, u'1997', u'\\nMay 1992/'],\n",
       " [6091732, 121, u'1998', u'709/'],\n",
       " [6091732, 594, u'1998', u'709/'],\n",
       " [6091732, 688, u'1998', u'709/'],\n",
       " [6091732, 807, u'1998', u'709/'],\n",
       " [6091732, 826, u'1998', u'709/'],\n",
       " [6212569, 139, u'1998', u'\\nOctober 1996/'],\n",
       " [6212569, 779, u'1998', u'\\nOctober 1996/'],\n",
       " [6212569, 780, u'1998', u'\\nOctober 1996/'],\n",
       " [6212569, 781, u'1998', u'\\nOctober 1996/'],\n",
       " [6212569, 782, u'1998', u'\\nOctober 1996/'],\n",
       " [6144987, 1323, 'Cannot extract', u'370/370/370/370/'],\n",
       " [6259677, 137, 'Cannot extract', u'714/714/714/'],\n",
       " [6038694, 793, u'1997', u'370/370/370/'],\n",
       " [6222822, 88, u'1998', u'\\nSeptember 1988/'],\n",
       " [6222822, 214, u'1998', u'\\nSeptember 1988/'],\n",
       " [6222822, 1002, u'1998', u'\\nSeptember 1988/'],\n",
       " [6269096, 930, u'1998', u'\\nAugust 1995/'],\n",
       " [6269096, 1286, u'1998', u'\\nAugust 1995/'],\n",
       " [6519635, 1389, u'1998', u'\\nMarch 1985/'],\n",
       " [6519635, 1390, u'1998', u'\\nMarch 1985/'],\n",
       " [6466548, 1021, u'1998', u'\\nJune 1992/'],\n",
       " [6466550, 1021, u'1998', u'\\nMarch 1985/'],\n",
       " [6466550, 1313, u'1998', u'\\nMarch 1985/'],\n",
       " [6603774, 295, u'1998', u'\\nDecember 1978/'],\n",
       " [6603774, 756, u'1998', u'\\nDecember 1978/'],\n",
       " [6853638, 108, 'Cannot extract', u'370/370/370/'],\n",
       " [6292491, 52, u'1998', u'\\nFebruary 1996/'],\n",
       " [6292495, 723, u'1998', u'\\nMay 1993/'],\n",
       " [6292495, 1062, u'1998', u'\\nMay 1993/'],\n",
       " [6128656, 901, u'1997', u'\\nOctober 1985/'],\n",
       " [6128656, 902, u'1997', u'\\nOctober 1985/'],\n",
       " [6128656, 903, u'1997', u'\\nOctober 1985/'],\n",
       " [6128662, 804, u'1997', u'\\nMay 1985/'],\n",
       " [6128662, 892, u'1997', u'\\nMay 1985/'],\n",
       " [6054942, 810, 'Cannot extract', u'370/375/375/'],\n",
       " [6466592, 126, u'1998', u'379/379/379/'],\n",
       " [6282273, 7, u'1997', u'\\nApril 1982/'],\n",
       " [6282273, 253, u'1997', u'\\nApril 1982/'],\n",
       " [6282273, 458, u'1997', u'\\nApril 1982/'],\n",
       " [6282273, 519, u'1997', u'\\nApril 1982/'],\n",
       " [6282273, 520, u'1997', u'\\nApril 1982/'],\n",
       " [6282273, 938, u'1997', u'\\nApril 1982/'],\n",
       " [6292516, 733, 'Cannot extract', u'361/361/361/361/439/'],\n",
       " [6292516, 762, 'Cannot extract', u'361/361/361/361/439/'],\n",
       " [6185106, 960, 'Cannot extract', u'370/709/'],\n",
       " [6490289, 881, u'1997', u'\\nMay 1991/'],\n",
       " [6490289, 882, u'1997', u'\\nMay 1991/'],\n",
       " [6490289, 1028, u'1997', u'\\nMay 1991/'],\n",
       " [6490289, 1029, u'1997', u'\\nMay 1991/'],\n",
       " [6490289, 1050, u'1997', u'\\nMay 1991/'],\n",
       " [5983272, 621, u'1997', u'\\nFebruary 1992/'],\n",
       " [5983272, 622, u'1997', u'\\nFebruary 1992/'],\n",
       " [5983272, 624, u'1997', u'\\nFebruary 1992/'],\n",
       " [5983272, 625, u'1997', u'\\nFebruary 1992/'],\n",
       " [5964841, 643, u'1998', u'\\nOctober 1993/'],\n",
       " [6446122, 136, u'1998', u'\\nJuly 1998/'],\n",
       " [6446122, 1282, u'1998', u'\\nJuly 1998/'],\n",
       " [6507563, 1364, u'1997', u'\\nMay 1997/'],\n",
       " [6587436, 271, u'1996', u'\\nOctober 1985/'],\n",
       " [6587436, 785, u'1996', u'\\nOctober 1985/'],\n",
       " [6587436, 939, u'1996', u'\\nOctober 1985/'],\n",
       " [5909550, 634, u'1998', u'\\nNovember 1986/'],\n",
       " [5909550, 635, u'1998', u'\\nNovember 1986/'],\n",
       " [6763017, 129, u'1997', u'\\nMay 1989/'],\n",
       " [6763017, 1511, u'1997', u'\\nMay 1989/'],\n",
       " [6763017, 1661, u'1997', u'\\nMay 1989/'],\n",
       " [6763017, 1662, u'1997', u'\\nMay 1989/'],\n",
       " [6122639, 893, u'1998', u'\\nAugust 1994/'],\n",
       " [6122639, 894, u'1998', u'\\nAugust 1994/'],\n",
       " [6122639, 3124, u'1998', u'\\nAugust 1994/'],\n",
       " [6317236, 712, u'1998', u'\\nAugust 1995/'],\n",
       " [6597694, 1538, u'1998', u'\\nJuly 1989/'],\n",
       " [6597694, 1539, u'1998', u'\\nJuly 1989/'],\n",
       " [6269452, 347, u'1996', u'370/348/348/348/348/370/370/'],\n",
       " [6269452, 384, u'1996', u'370/348/348/348/348/370/370/'],\n",
       " [6269452, 898, u'1996', u'370/348/348/348/348/370/370/'],\n",
       " [6269452, 1055, u'1996', u'370/348/348/348/348/370/370/'],\n",
       " [6269452, 1056, u'1996', u'370/348/348/348/348/370/370/'],\n",
       " [5864542, 39, u'1998', u'\\nOctober 1993/'],\n",
       " [5864542, 52, u'1998', u'\\nOctober 1993/'],\n",
       " [5864542, 376, u'1998', u'\\nOctober 1993/'],\n",
       " [5864542, 377, u'1998', u'\\nOctober 1993/'],\n",
       " [6321255, 681, u'1998', u'370/370/370/'],\n",
       " [6321255, 1110, u'1998', u'370/370/370/'],\n",
       " [6321255, 1111, u'1998', u'370/370/370/'],\n",
       " [6321255, 1112, u'1998', u'370/370/370/'],\n",
       " [6526056, 221, u'1996', u'370/348/348/348/348/370/370/370/370/'],\n",
       " [6526056, 643, u'1996', u'370/348/348/348/348/370/370/370/370/'],\n",
       " [5799017, 39, u'1997', u'\\nFebruary 1984/'],\n",
       " [5799017, 52, u'1997', u'\\nFebruary 1984/'],\n",
       " [5799017, 376, u'1997', u'\\nFebruary 1984/'],\n",
       " [5799017, 377, u'1997', u'\\nFebruary 1984/'],\n",
       " [6526060, 568, u'1998', u'\\nSeptember 1982/'],\n",
       " [6526060, 1240, u'1998', u'\\nSeptember 1982/'],\n",
       " [6532215, 499, u'1997', u'\\nMarch 1994/'],\n",
       " [6272120, 1058, u'1997', u'714/'],\n",
       " [6128761, 125, u'1996', u'\\nSeptember 1993/'],\n",
       " [6128761, 141, u'1996', u'\\nSeptember 1993/'],\n",
       " [6128761, 209, u'1996', u'\\nSeptember 1993/'],\n",
       " [6128761, 229, u'1996', u'\\nSeptember 1993/'],\n",
       " [6128761, 439, u'1996', u'\\nSeptember 1993/'],\n",
       " [5917820, 643, u'1998', u'\\nAugust 1993/'],\n",
       " [6493317, 973, u'1998', u'\\nMay 1986/'],\n",
       " [6728839, 1405, u'1998', u'\\nApril 1989/'],\n",
       " [6208649, 914, u'1997', u'370/340/370/714/714/'],\n",
       " [6108300, 533, u'1996', u'\\nSeptember 1993/'],\n",
       " [6108300, 727, u'1996', u'\\nSeptember 1993/'],\n",
       " [5872783, 384, u'1996', u'\\nMarch 1977/'],\n",
       " [5938324, 667, u'1998', u'\\nJuly 1979/'],\n",
       " [5938324, 668, u'1998', u'\\nJuly 1979/'],\n",
       " [5938324, 669, u'1998', u'\\nJuly 1979/'],\n",
       " [6446230, 1283, u'1997', u'\\nOctober 1997/'],\n",
       " [6108312, 708, u'1997', u'\\nNovember 1980/'],\n",
       " [6151325, 65, u'1997', u'\\nFebruary 1984/'],\n",
       " [6487202, 382, u'1998', u'\\nMay 1986/'],\n",
       " [6487202, 981, u'1998', u'\\nMay 1986/'],\n",
       " [6195739, 434, u'1997', u'\\nMay 1995/'],\n",
       " [6195739, 863, u'1997', u'\\nMay 1995/'],\n",
       " [6195739, 864, u'1997', u'\\nMay 1995/'],\n",
       " [6195739, 865, u'1997', u'\\nMay 1995/'],\n",
       " [5940390, 673, u'1998', u'712/712/712/'],\n",
       " [5940390, 674, u'1998', u'712/712/712/'],\n",
       " [6175915, 779, u'1998', u'\\nAugust 1994/'],\n",
       " [6175915, 780, u'1998', u'\\nAugust 1994/'],\n",
       " [6175915, 781, u'1998', u'\\nAugust 1994/'],\n",
       " [6175915, 782, u'1998', u'\\nAugust 1994/'],\n",
       " [6175915, 827, u'1998', u'\\nAugust 1994/'],\n",
       " [6487214, 1335, u'1998', u'\\nNovember 1994/'],\n",
       " [6704308, 462, u'1998', u'\\nSeptember 1988/'],\n",
       " [6704308, 1738, u'1998', u'\\nSeptember 1988/'],\n",
       " [6442165, 881, u'1998', u'\\nApril 1998/'],\n",
       " [6442165, 882, u'1998', u'\\nApril 1998/'],\n",
       " [6442165, 884, u'1998', u'\\nApril 1998/'],\n",
       " [6442165, 1030, u'1998', u'\\nApril 1998/'],\n",
       " [6829242, 136, u'1998', u'\\nFebruary 1989/'],\n",
       " [6829242, 1412, u'1998', u'\\nFebruary 1989/'],\n",
       " [6829242, 1999, u'1998', u'\\nFebruary 1989/'],\n",
       " [6360255, 1023, u'1996', u'\\nMay 1993/'],\n",
       " [6360255, 1149, u'1996', u'\\nMay 1993/'],\n",
       " [6360255, 1150, u'1996', u'\\nMay 1993/'],\n",
       " [6223053, 374, u'1998', u'\\nAugust 1985/'],\n",
       " [6223053, 583, u'1998', u'\\nAugust 1985/'],\n",
       " [6438102, 113, 'Cannot extract', u'709/709/'],\n",
       " [6438102, 1270, 'Cannot extract', u'709/709/'],\n",
       " [6438102, 1839, 'Cannot extract', u'709/709/'],\n",
       " [6421720, 1021, u'1998', u'379/370/370/379/379/'],\n",
       " [6151390, 38, u'1997', u'\\nFebruary 1987/'],\n",
       " [6151390, 873, u'1997', u'\\nFebruary 1987/'],\n",
       " [6151390, 874, u'1997', u'\\nFebruary 1987/'],\n",
       " [6151390, 875, u'1997', u'\\nFebruary 1987/'],\n",
       " [6151390, 1481, u'1997', u'\\nFebruary 1987/'],\n",
       " [6151390, 1644, u'1997', u'\\nFebruary 1987/'],\n",
       " [6026464, 492, u'1997', u'\\nOctober 1988/'],\n",
       " [6151395, 791, 'Cannot extract', u'307/307/307/307/307/'],\n",
       " [5952741, 33, u'1997', u'\\nJanuary 1999/'],\n",
       " [6182119, 956, u'1998', u'\\nMarch 1995/'],\n",
       " [6314105, 1106, u'1998', u'370/370/370/370/'],\n",
       " [6647028, 132, u'1998', u'\\nFebruary 1992/'],\n",
       " [6647028, 222, u'1998', u'\\nFebruary 1992/'],\n",
       " [6647028, 389, u'1998', u'\\nFebruary 1992/'],\n",
       " [6647028, 1641, u'1998', u'\\nFebruary 1992/'],\n",
       " [6438133, 121, 'Cannot extract', u'370/370/370/370/370/370/375/375/375/379/'],\n",
       " [6438133, 786, 'Cannot extract', u'370/370/370/370/370/370/375/375/375/379/'],\n",
       " [6438133, 807, 'Cannot extract', u'370/370/370/370/370/370/375/375/375/379/'],\n",
       " [6438133, 826, 'Cannot extract', u'370/370/370/370/370/370/375/375/375/379/'],\n",
       " [6618358,\n",
       "  1116,\n",
       "  'Cannot extract',\n",
       "  u'370/370/370/710/710/710/710/710/711/711/711/'],\n",
       " [6618358,\n",
       "  1589,\n",
       "  'Cannot extract',\n",
       "  u'370/370/370/710/710/710/710/710/711/711/711/'],\n",
       " [6388989, 868, u'1998', u'\\nJune 1992/'],\n",
       " [6515967, 353, u'1996', u'\\nJanuary 1994/'],\n",
       " [6515967, 1385, u'1996', u'\\nJanuary 1994/'],\n",
       " [6040834, 678, u'1998', u'\\nApril 1992/'],\n",
       " [6040834, 794, u'1998', u'\\nApril 1992/'],\n",
       " [6182147, 353, u'1995', u'\\nJune 1993/'],\n",
       " [5729546, 282, u'1998', u'\\nMarch 1989/'],\n",
       " [5729546, 422, u'1998', u'\\nMarch 1989/'],\n",
       " [5729546, 481, u'1998', u'\\nMarch 1989/'],\n",
       " [5729546, 482, u'1998', u'\\nMarch 1989/'],\n",
       " [6628624, 313, u'1995', u'\\nDecember 1984/'],\n",
       " [6628624, 1280, u'1995', u'\\nDecember 1984/'],\n",
       " [6628624, 1613, u'1995', u'\\nDecember 1984/'],\n",
       " [6061348, 98, u'1997', u'370/370/370/714/'],\n",
       " [6061348, 486, u'1997', u'370/370/370/714/'],\n",
       " [6061349, 533, u'1998', u'\\nSeptember 1989/'],\n",
       " [6061349, 751, u'1998', u'\\nSeptember 1989/'],\n",
       " [6061349, 1433, u'1998', u'\\nSeptember 1989/'],\n",
       " [6282546, 1092, u'1997', u'\\nSeptember 1978/'],\n",
       " [6282546, 1339, u'1997', u'\\nSeptember 1978/'],\n",
       " [5930294, 126, u'1997', u'\\nJanuary 1988/'],\n",
       " [6311226, 621, u'1998', u'\\nAugust 1985/'],\n",
       " [6311226, 622, u'1998', u'\\nAugust 1985/'],\n",
       " [6311226, 624, u'1998', u'\\nAugust 1985/'],\n",
       " [6311226, 625, u'1998', u'\\nAugust 1985/'],\n",
       " [6483850, 113, u'1996', u'\\nSeptember 1992/'],\n",
       " [6483850, 1270, u'1996', u'\\nSeptember 1992/'],\n",
       " [6483850, 1839, u'1996', u'\\nSeptember 1992/'],\n",
       " [5905726, 39, u'1998', u'\\nSeptember 1996/'],\n",
       " [6327618, 46, 'Cannot extract', u'709/709/'],\n",
       " [6327618, 48, 'Cannot extract', u'709/709/'],\n",
       " [5918019, 201, u'1998', u'\\nMarch 1992/'],\n",
       " [5918022, 649, 'Cannot extract', u'370/370/'],\n",
       " [5918022, 650, 'Cannot extract', u'370/370/'],\n",
       " [5918022, 651, 'Cannot extract', u'370/370/'],\n",
       " [6434120, 540, u'1997', u'\\nApril 1992/'],\n",
       " [6434120, 541, u'1997', u'\\nApril 1992/'],\n",
       " [6157641, 345, u'1998', u'\\nAugust 1989/'],\n",
       " [6507855, 1368, u'1996', u'\\nApril 1992/'],\n",
       " [6182224, 328, u'1996', u'\\nApril 1992/'],\n",
       " [6182224, 957, u'1996', u'\\nApril 1992/'],\n",
       " [6182224, 958, u'1996', u'\\nApril 1992/'],\n",
       " [6243667, 865, u'1996', u'455/342/375/455/455/'],\n",
       " [6243667, 1027, u'1996', u'455/342/375/455/455/'],\n",
       " [6006110, 438, u'1997', u'\\nSeptember 1975/'],\n",
       " [6272351, 75, u'1998', u'709/709/'],\n",
       " [6272351, 746, u'1998', u'709/709/'],\n",
       " [6272351, 763, u'1998', u'709/709/'],\n",
       " [6272351, 993, u'1998', u'709/709/'],\n",
       " [6292832, 989, 'Cannot extract', u'370/370/370/'],\n",
       " [6292832, 990, 'Cannot extract', u'370/370/370/'],\n",
       " [6765928, 365, 'Cannot extract', u'726/709/726/'],\n",
       " [6765928, 408, 'Cannot extract', u'726/709/726/'],\n",
       " [6765928, 564, 'Cannot extract', u'726/709/726/'],\n",
       " [6765928, 1877, 'Cannot extract', u'726/709/726/'],\n",
       " [6765928, 1878, 'Cannot extract', u'726/709/726/'],\n",
       " [6765928, 1879, 'Cannot extract', u'726/709/726/'],\n",
       " [6311275, 521, u'1998', u'\\nMay 1992/'],\n",
       " [6311275, 881, u'1998', u'\\nMay 1992/'],\n",
       " [6311275, 882, u'1998', u'\\nMay 1992/'],\n",
       " [6311275, 1028, u'1998', u'\\nMay 1992/'],\n",
       " [6311275, 1029, u'1998', u'\\nMay 1992/'],\n",
       " [6311275, 1050, u'1998', u'\\nMay 1992/'],\n",
       " [6249838, 1038, u'1998', u'710/'],\n",
       " [6163824, 40, u'1997', u'\\nFebruary 1998/'],\n",
       " [6163824, 126, u'1997', u'\\nFebruary 1998/'],\n",
       " [6163824, 347, u'1997', u'\\nFebruary 1998/'],\n",
       " [6163824, 535, u'1997', u'\\nFebruary 1998/'],\n",
       " [6163824, 992, u'1997', u'\\nFebruary 1998/'],\n",
       " [6067573, 260, u'1998', u'370/'],\n",
       " [6067573, 673, u'1998', u'370/'],\n",
       " [6067573, 674, u'1998', u'370/'],\n",
       " [6067573, 833, u'1998', u'370/'],\n",
       " [6067573, 834, u'1998', u'370/'],\n",
       " [6067573, 835, u'1998', u'370/'],\n",
       " [6477174, 568, 'Cannot extract', u'379/379/379/'],\n",
       " [6477174, 2255, 'Cannot extract', u'379/379/379/'],\n",
       " [6061431, 295, u'1997', u'\\nAugust 1999/'],\n",
       " [6061431, 756, u'1997', u'\\nAugust 1999/'],\n",
       " [6075769, 271, u'1998', u'\\nApril 1990/'],\n",
       " [6075769, 785, u'1998', u'\\nApril 1990/'],\n",
       " [6075769, 939, u'1998', u'\\nApril 1990/'],\n",
       " [6366587, 687, u'1997', u'\\nJuly 1995/'],\n",
       " [6178176, 708, u'1996', u'370/370/370/370/709/'],\n",
       " [6178176, 949, u'1996', u'370/370/370/370/709/'],\n",
       " [6118791, 21, u'1998', u'\\nJanuary 1984/'],\n",
       " [6118791, 413, u'1998', u'\\nJanuary 1984/'],\n",
       " [6118791, 414, u'1998', u'\\nJanuary 1984/'],\n",
       " [6501768, 75, 'Cannot extract', u'709/370/370/709/709/709/'],\n",
       " [6501768, 993, 'Cannot extract', u'709/370/370/709/709/709/'],\n",
       " [6501768, 1004, 'Cannot extract', u'709/370/370/709/709/709/'],\n",
       " [6501768, 1042, 'Cannot extract', u'709/370/370/709/709/709/'],\n",
       " [6501768, 1099, 'Cannot extract', u'709/370/370/709/709/709/'],\n",
       " [5991817, 317, u'1998', u'\\nMay 1989/'],\n",
       " [5991817, 728, u'1998', u'\\nMay 1989/'],\n",
       " [5991817, 729, u'1998', u'\\nMay 1989/'],\n",
       " [6532493, 693, u'1998', u'\\nApril 1994/'],\n",
       " [6532493, 917, u'1998', u'\\nApril 1994/'],\n",
       " [6532493, 1407, u'1998', u'\\nApril 1994/'],\n",
       " [6012056, 757, u'1997', u'\\nJune 1992/'],\n",
       " [6141348, 499, 'Cannot extract', u'709/709/709/709/'],\n",
       " [6243749, 884, u'1997', u'\\nFebruary 1987/'],\n",
       " [6243749, 1028, u'1997', u'\\nFebruary 1987/'],\n",
       " [6243749, 1029, u'1997', u'\\nFebruary 1987/'],\n",
       " [6243749, 1030, u'1997', u'\\nFebruary 1987/'],\n",
       " [6131117, 212, u'1997', u'\\nOctober 1970/'],\n",
       " [6131117, 493, u'1997', u'\\nOctober 1970/'],\n",
       " [6366644, 458, 'Cannot extract', u'439/439/439/'],\n",
       " [6366644, 519, 'Cannot extract', u'439/439/439/'],\n",
       " [6004150, 6, u'1998', u'\\nOctober 1970/'],\n",
       " [6004150, 126, u'1998', u'\\nOctober 1970/'],\n",
       " [6004150, 744, u'1998', u'\\nOctober 1970/'],\n",
       " [6239672, 7, u'1995', u'\\nNovember 1980/'],\n",
       " [6239672, 519, u'1995', u'\\nNovember 1980/'],\n",
       " [6239672, 954, u'1995', u'\\nNovember 1980/'],\n",
       " [5787070, 282, u'1997', u'\\nJuly 1987/'],\n",
       " [5787070, 422, u'1997', u'\\nJuly 1987/'],\n",
       " [5787070, 481, u'1997', u'\\nJuly 1987/'],\n",
       " [5787070, 526, u'1997', u'\\nJuly 1987/'],\n",
       " [5852607, 384, u'1998', u'\\nOctober 1993/'],\n",
       " [6141377, 52, u'1998', u'\\nJune 1997/'],\n",
       " [6141377, 171, u'1998', u'\\nJune 1997/'],\n",
       " [6347339, 1129, u'1997', u'\\nJuly 1987/'],\n",
       " [6347339, 1130, u'1997', u'\\nJuly 1987/'],\n",
       " [6055364, 353, u'1998', u'\\nMay 1991/'],\n",
       " [6055364, 812, u'1998', u'\\nMay 1991/'],\n",
       " [6055364, 813, u'1998', u'\\nMay 1991/'],\n",
       " [6055364, 814, u'1998', u'\\nMay 1991/'],\n",
       " [6430153, 568, u'1998', u'\\nOctober 1996/'],\n",
       " [6430153, 1240, u'1998', u'\\nOctober 1996/'],\n",
       " [6430153, 1241, u'1998', u'\\nOctober 1996/'],\n",
       " [6430155, 288, u'1997', u'\\nMay 1989/'],\n",
       " [6430155, 1242, u'1997', u'\\nMay 1989/'],\n",
       " [6430155, 1380, u'1997', u'\\nMay 1989/'],\n",
       " [6862284, 888, u'1998', u'\\nOctober 1995/'],\n",
       " [6862284, 889, u'1998', u'\\nOctober 1995/'],\n",
       " [6862284, 890, u'1998', u'\\nOctober 1995/'],\n",
       " [6862284, 1232, u'1998', u'\\nOctober 1995/'],\n",
       " [6430159, 1243, u'1998', u'\\nJanuary 1981/'],\n",
       " [6430159, 1244, u'1998', u'\\nJanuary 1981/'],\n",
       " [7116707, 1039, u'1998', u'\\nApril 1993/'],\n",
       " [6131163, 906, u'1997', u'379/379/379/'],\n",
       " [6014431, 7, 'Cannot extract', u'370/370/379/709/'],\n",
       " [6014431, 253, 'Cannot extract', u'370/370/379/709/'],\n",
       " [6014431, 458, 'Cannot extract', u'370/370/379/709/'],\n",
       " [6014431, 519, 'Cannot extract', u'370/370/379/709/'],\n",
       " [6014431, 520, 'Cannot extract', u'370/370/379/709/'],\n",
       " [6014431, 938, 'Cannot extract', u'370/370/379/709/'],\n",
       " [6870828, 1072, 'Cannot extract', u'370/370/370/'],\n",
       " [6333931, 295, u'1998', u'\\nApril 1973/'],\n",
       " [6333931, 874, u'1998', u'\\nApril 1973/'],\n",
       " [6333931, 1117, u'1998', u'\\nApril 1973/'],\n",
       " [6333931, 1118, u'1998', u'\\nApril 1973/'],\n",
       " [6333931, 1119, u'1998', u'\\nApril 1973/'],\n",
       " [6081106, 805, u'1997', u'379/379/'],\n",
       " [5852655, 7, u'1998', u'\\nOctober 1998/'],\n",
       " [5852655, 253, u'1998', u'\\nOctober 1998/'],\n",
       " [5852655, 458, u'1998', u'\\nOctober 1998/'],\n",
       " [5852655, 519, u'1998', u'\\nOctober 1998/'],\n",
       " [5852655, 520, u'1998', u'\\nOctober 1998/'],\n",
       " [5852655, 938, u'1998', u'\\nOctober 1998/'],\n",
       " [6917617, 881, u'1998', u'\\nSeptember 1988/'],\n",
       " [6917617, 882, u'1998', u'\\nSeptember 1988/'],\n",
       " [6917617, 1028, u'1998', u'\\nSeptember 1988/'],\n",
       " [6917617, 1029, u'1998', u'\\nSeptember 1988/'],\n",
       " [6917617, 1050, u'1998', u'\\nSeptember 1988/'],\n",
       " [6430196, 1246, u'1997', u'\\nAugust 1995/'],\n",
       " [6335990, 32, 'Cannot extract', u'709/709/709/709/709/'],\n",
       " [6335990, 585, 'Cannot extract', u'709/709/709/709/709/'],\n",
       " [6335990, 595, 'Cannot extract', u'709/709/709/709/709/'],\n",
       " [6006268, 533, u'1996', u'\\nFebruary 1984/'],\n",
       " [6006268, 751, u'1996', u'\\nFebruary 1984/'],\n",
       " [6006268, 752, u'1996', u'\\nFebruary 1984/'],\n",
       " [6034945, 382, u'1996', u'\\nFebruary 1990/'],\n",
       " [6034945, 568, u'1996', u'\\nFebruary 1990/'],\n",
       " [5805595, 52, u'1996', u'\\nJune 1986/'],\n",
       " [5805595, 545, u'1996', u'\\nJune 1986/'],\n",
       " [5764636, 497, u'1998', u'\\nDecember 1981/'],\n",
       " [6553117, 1039, 'Cannot extract', u'710/710/710/710/'],\n",
       " ...]"
      ]
     },
     "execution_count": 229,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "combined_list"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 235,
   "metadata": {},
   "outputs": [],
   "source": [
    "headers = ['Patent Number', 'Inventor Number', 'Year', 'Class']\n",
    "df1 = pd.DataFrame(combined_list, columns = headers)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 237,
   "metadata": {},
   "outputs": [],
   "source": [
    "df1.to_csv('/Users/satrajitmaitra/Desktop/Patents_Scraping_Output.csv', sep='\\t', encoding='utf-8')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 2",
   "language": "python",
   "name": "python2"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 2
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython2",
   "version": "2.7.15"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}