now-register-extraction.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Requirement already satisfied: pdftotext in /home/thomas/work/sandbox/venv/lib/python3.8/site-packages (2.1.4)\n",
      "\u001b[33mWARNING: You are using pip version 19.3.1; however, version 20.1.1 is available.\n",
      "You should consider upgrading via the 'pip install --upgrade pip' command.\u001b[0m\n"
     ]
    }
   ],
   "source": [
    "import sys\n",
    "\n",
    "!{sys.executable} -m pip install pdftotext"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "# info: https://www.uwv.nl/overuwv/pers/documenten/2020/gegevens-ontvangers-now-1-0-regeling.aspx\n",
    "# pdf: https://www.simulatienow.nl/Register-NOW-100720.pdf\n",
    "\n",
    "import requests\n",
    "from pathlib import Path\n",
    "\n",
    "reports = [\n",
    "    'Register-NOW-100720.pdf',\n",
    "]\n",
    "\n",
    "outputfolder = Path('./data-misc/data-economy/')\n",
    "\n",
    "for report in reports:\n",
    "    url = f'https://www.simulatienow.nl/{report}'\n",
    "    \n",
    "    outputfile = outputfolder / f'now-register-{report.split(\"-\")[-1]}'\n",
    "    \n",
    "    if not outputfile.exists():\n",
    "        r = requests.get(url, allow_redirects=True)\n",
    "        open(outputfile, 'wb').write(r.content)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "# I'm using poppler pdfinfo because it was available and it performs quite fast\n",
    "# compared to alternatives using pdfminer library. - Thomas\n",
    "\n",
    "# source: https://gist.github.com/godber/7692812#file-pdfinfo-py\n",
    "\n",
    "import subprocess\n",
    "import os.path as osp\n",
    "\n",
    "\n",
    "def pdfinfo(infile):\n",
    "    \"\"\"\n",
    "    Wraps command line utility pdfinfo to extract the PDF meta information.\n",
    "    Returns metainfo in a dictionary.\n",
    "    sudo apt-get install poppler-utils\n",
    "    This function parses the text output that looks like this:\n",
    "        Title:          PUBLIC MEETING AGENDA\n",
    "        Author:         Customer Support\n",
    "        Creator:        Microsoft Word 2010\n",
    "        Producer:       Microsoft Word 2010\n",
    "        CreationDate:   Thu Dec 20 14:44:56 2012\n",
    "        ModDate:        Thu Dec 20 14:44:56 2012\n",
    "        Tagged:         yes\n",
    "        Pages:          2\n",
    "        Encrypted:      no\n",
    "        Page size:      612 x 792 pts (letter)\n",
    "        File size:      104739 bytes\n",
    "        Optimized:      no\n",
    "        PDF version:    1.5\n",
    "    \"\"\"\n",
    "\n",
    "    cmd = '/usr/bin/pdfinfo'\n",
    "    if not osp.exists(cmd):\n",
    "        raise RuntimeError('System command not found: %s' % cmd)\n",
    "\n",
    "    if not osp.exists(infile):\n",
    "        raise RuntimeError('Provided input file not found: %s' % infile)\n",
    "\n",
    "    def _extract(row):\n",
    "        \"\"\"Extracts the right hand value from a : delimited row\"\"\"\n",
    "        return row.split(':', 1)[1].strip()\n",
    "\n",
    "    output = {}\n",
    "\n",
    "    labels = ['Title', 'Author', 'Creator', 'Producer', 'CreationDate',\n",
    "              'ModDate', 'Tagged', 'Pages', 'Encrypted', 'Page size',\n",
    "              'File size', 'Optimized', 'PDF version']\n",
    "\n",
    "    cmd_output = subprocess.check_output([cmd, infile])\n",
    "    for line in map(str, cmd_output.splitlines()):\n",
    "        for label in labels:\n",
    "            if label in line:\n",
    "                output[label] = _extract(line)\n",
    "\n",
    "    return output"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "# some more utility functions\n",
    "\n",
    "import pdftotext\n",
    "import re\n",
    "    \n",
    "def read_dutch_float(num):\n",
    "    return float(num.replace('.', '').replace(',', '.'))\n",
    "    \n",
    "def extract_page(page):\n",
    "    column_names = None\n",
    "    data = []\n",
    "    \n",
    "    column_phase = True\n",
    "    \n",
    "    for row in page.splitlines():\n",
    "        fields = re.split(r'\\s{2,}', row.strip())\n",
    "        \n",
    "        \n",
    "        if column_phase and column_names is None:\n",
    "            if len(fields) == 2:\n",
    "                column_names = ' '.join([x.strip() for x in fields]).split(' ')  # reassemble and split\n",
    "            else:\n",
    "                column_names = fields\n",
    "            #print(column_names)\n",
    "        elif column_phase and len(fields) < 3:\n",
    "            column_names[2] += ' ' + fields[0]\n",
    "            #print(column_names)\n",
    "            column_phase = False\n",
    "        else:\n",
    "            if len(fields) == 1:\n",
    "                try:\n",
    "                    int(fields[0])  # check if this is a pagenum\n",
    "                    continue # if it is, just skip to the next\n",
    "                except ValueError as e:  # unfortunately it is not, most likely it is now part of the company location or company name\n",
    "                    print('NOT PAGENUM', fields)\n",
    "                    print(f'--{row}--')\n",
    "                    \n",
    "                    if row.lstrip() != row:  # check if it has a bunch of spaces in front\n",
    "                        # it's a location\n",
    "                        print('Assuming location')\n",
    "                        data[len(data) -1][1] += f' {fields[0]}'\n",
    "                    else:\n",
    "                        # it's part of the companies name\n",
    "                        print('Assuming company name')\n",
    "                        data[len(data) -1][0] += f' {fields[0]}'\n",
    "                    continue  # on to the next row\n",
    "            elif len(fields) == 2:\n",
    "                # placename is probably not extracted due to not having two whitespace chars between\n",
    "                # the columns, let's split them anyways\n",
    "                \n",
    "                fields_new = [\n",
    "                    ' '.join(fields[0].split(' ')[:-1]),\n",
    "                    ' '.join(fields[0].split(' ')[-1:]),\n",
    "                    fields[1]\n",
    "                ]\n",
    "                fields = fields_new\n",
    "            elif len(fields) != 3:\n",
    "                print('ERROR', fields) # something's not right\n",
    "                continue\n",
    "                \n",
    "            fields[2] = read_dutch_float(fields[2])\n",
    "            data.append(fields)\n",
    "    \n",
    "    return column_names, data\n",
    "\n",
    "def pdf_find_page_for_text(file, text):\n",
    "    with open(file, \"rb\") as fh:\n",
    "        pdf = pdftotext.PDF(fh)\n",
    "\n",
    "    counter = 1\n",
    "    for page in pdf:\n",
    "        if text.lower() in page.lower():\n",
    "            return counter\n",
    "        counter += 1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Page 2/2045\n",
      "Page 3/2045\n",
      "Page 4/2045\n",
      "Page 5/2045\n",
      "Page 6/2045\n",
      "Page 7/2045\n",
      "Page 8/2045\n",
      "Page 9/2045\n",
      "Page 10/2045\n",
      "Page 11/2045\n",
      "Page 12/2045\n",
      "Page 13/2045\n",
      "Page 14/2045\n",
      "Page 15/2045\n",
      "Page 16/2045\n",
      "Page 17/2045\n",
      "Page 18/2045\n",
      "Page 19/2045\n",
      "Page 20/2045\n",
      "Page 21/2045\n",
      "Page 22/2045\n",
      "Page 23/2045\n",
      "Page 24/2045\n",
      "Page 25/2045\n",
      "Page 26/2045\n",
      "Page 27/2045\n",
      "Page 28/2045\n",
      "Page 29/2045\n",
      "Page 30/2045\n",
      "Page 31/2045\n",
      "Page 32/2045\n",
      "Page 33/2045\n",
      "Page 34/2045\n",
      "Page 35/2045\n",
      "Page 36/2045\n",
      "Page 37/2045\n",
      "NOT PAGENUM ['ALBRANDSWAARD']\n",
      "--                                                   ALBRANDSWAARD--\n",
      "Assuming location\n",
      "Page 38/2045\n",
      "Page 39/2045\n",
      "Page 40/2045\n",
      "Page 41/2045\n",
      "Page 42/2045\n",
      "Page 43/2045\n",
      "Page 44/2045\n",
      "Page 45/2045\n",
      "Page 46/2045\n",
      "Page 47/2045\n",
      "Page 48/2045\n",
      "Page 49/2045\n",
      "Page 50/2045\n",
      "Page 51/2045\n",
      "Page 52/2045\n",
      "Page 53/2045\n",
      "Page 54/2045\n",
      "Page 55/2045\n",
      "Page 56/2045\n",
      "Page 57/2045\n",
      "Page 58/2045\n",
      "Page 59/2045\n",
      "NOT PAGENUM ['ALBRANDSWAARD']\n",
      "--                                                 ALBRANDSWAARD--\n",
      "Assuming location\n",
      "Page 60/2045\n",
      "Page 61/2045\n",
      "Page 62/2045\n",
      "Page 63/2045\n",
      "Page 64/2045\n",
      "Page 65/2045\n",
      "Page 66/2045\n",
      "Page 67/2045\n",
      "Page 68/2045\n",
      "Page 69/2045\n",
      "Page 70/2045\n",
      "Page 71/2045\n",
      "Page 72/2045\n",
      "Page 73/2045\n",
      "Page 74/2045\n",
      "Page 75/2045\n",
      "Page 76/2045\n",
      "Page 77/2045\n",
      "Page 78/2045\n",
      "Page 79/2045\n",
      "Page 80/2045\n",
      "Page 81/2045\n",
      "Page 82/2045\n",
      "Page 83/2045\n",
      "Page 84/2045\n",
      "Page 85/2045\n",
      "Page 86/2045\n",
      "Page 87/2045\n",
      "Page 88/2045\n",
      "Page 89/2045\n",
      "Page 90/2045\n",
      "Page 91/2045\n",
      "Page 92/2045\n",
      "Page 93/2045\n",
      "Page 94/2045\n",
      "Page 95/2045\n",
      "Page 96/2045\n",
      "Page 97/2045\n",
      "Page 98/2045\n",
      "Page 99/2045\n",
      "Page 100/2045\n",
      "Page 101/2045\n",
      "Page 102/2045\n",
      "Page 103/2045\n",
      "Page 104/2045\n",
      "Page 105/2045\n",
      "Page 106/2045\n",
      "Page 107/2045\n",
      "Page 108/2045\n",
      "NOT PAGENUM ['SMALLINGERLND']\n",
      "--                                               SMALLINGERLND--\n",
      "Assuming location\n",
      "Page 109/2045\n",
      "Page 110/2045\n",
      "Page 111/2045\n",
      "Page 112/2045\n",
      "Page 113/2045\n",
      "Page 114/2045\n",
      "Page 115/2045\n",
      "Page 116/2045\n",
      "Page 117/2045\n",
      "Page 118/2045\n",
      "Page 119/2045\n",
      "Page 120/2045\n",
      "Page 121/2045\n",
      "Page 122/2045\n",
      "Page 123/2045\n",
      "Page 124/2045\n",
      "Page 125/2045\n",
      "Page 126/2045\n",
      "Page 127/2045\n",
      "Page 128/2045\n",
      "Page 129/2045\n",
      "Page 130/2045\n",
      "Page 131/2045\n",
      "Page 132/2045\n",
      "Page 133/2045\n",
      "Page 134/2045\n",
      "Page 135/2045\n",
      "Page 136/2045\n",
      "Page 137/2045\n",
      "Page 138/2045\n",
      "NOT PAGENUM ['LABOUCHERE']\n",
      "--LABOUCHERE--\n",
      "Assuming company name\n",
      "Page 139/2045\n",
      "Page 140/2045\n",
      "Page 141/2045\n",
      "Page 142/2045\n",
      "Page 143/2045\n",
      "Page 144/2045\n",
      "Page 145/2045\n",
      "Page 146/2045\n",
      "Page 147/2045\n",
      "Page 148/2045\n",
      "Page 149/2045\n",
      "Page 150/2045\n",
      "Page 151/2045\n",
      "Page 152/2045\n",
      "Page 153/2045\n",
      "Page 154/2045\n",
      "Page 155/2045\n",
      "Page 156/2045\n",
      "Page 157/2045\n",
      "Page 158/2045\n",
      "Page 159/2045\n",
      "Page 160/2045\n",
      "Page 161/2045\n",
      "Page 162/2045\n",
      "Page 163/2045\n",
      "Page 164/2045\n",
      "Page 165/2045\n",
      "Page 166/2045\n",
      "Page 167/2045\n",
      "Page 168/2045\n",
      "Page 169/2045\n",
      "Page 170/2045\n",
      "Page 171/2045\n",
      "Page 172/2045\n",
      "Page 173/2045\n",
      "Page 174/2045\n",
      "Page 175/2045\n",
      "Page 176/2045\n",
      "Page 177/2045\n",
      "Page 178/2045\n",
      "Page 179/2045\n",
      "Page 180/2045\n",
      "Page 181/2045\n",
      "Page 182/2045\n",
      "Page 183/2045\n",
      "Page 184/2045\n",
      "Page 185/2045\n",
      "Page 186/2045\n",
      "Page 187/2045\n",
      "Page 188/2045\n",
      "Page 189/2045\n",
      "Page 190/2045\n",
      "Page 191/2045\n",
      "Page 192/2045\n",
      "Page 193/2045\n",
      "Page 194/2045\n",
      "Page 195/2045\n",
      "Page 196/2045\n",
      "Page 197/2045\n",
      "Page 198/2045\n",
      "Page 199/2045\n",
      "Page 200/2045\n",
      "Page 201/2045\n",
      "Page 202/2045\n",
      "Page 203/2045\n",
      "Page 204/2045\n",
      "Page 205/2045\n",
      "Page 206/2045\n",
      "Page 207/2045\n",
      "Page 208/2045\n",
      "Page 209/2045\n",
      "Page 210/2045\n",
      "Page 211/2045\n",
      "Page 212/2045\n",
      "Page 213/2045\n",
      "Page 214/2045\n",
      "NOT PAGENUM ['ALBRANDSWAARD']\n",
      "--                                                ALBRANDSWAARD--\n",
      "Assuming location\n",
      "Page 215/2045\n",
      "Page 216/2045\n",
      "Page 217/2045\n",
      "Page 218/2045\n",
      "Page 219/2045\n",
      "Page 220/2045\n",
      "Page 221/2045\n",
      "Page 222/2045\n",
      "Page 223/2045\n",
      "Page 224/2045\n",
      "Page 225/2045\n",
      "Page 226/2045\n",
      "Page 227/2045\n",
      "Page 228/2045\n",
      "Page 229/2045\n",
      "Page 230/2045\n",
      "Page 231/2045\n",
      "Page 232/2045\n",
      "Page 233/2045\n",
      "Page 234/2045\n",
      "Page 235/2045\n",
      "Page 236/2045\n",
      "Page 237/2045\n",
      "Page 238/2045\n",
      "Page 239/2045\n",
      "Page 240/2045\n",
      "Page 241/2045\n",
      "Page 242/2045\n",
      "Page 243/2045\n",
      "Page 244/2045\n",
      "Page 245/2045\n",
      "Page 246/2045\n",
      "Page 247/2045\n",
      "Page 248/2045\n",
      "Page 249/2045\n",
      "Page 250/2045\n",
      "Page 251/2045\n",
      "Page 252/2045\n",
      "Page 253/2045\n",
      "Page 254/2045\n",
      "Page 255/2045\n",
      "Page 256/2045\n",
      "Page 257/2045\n",
      "Page 258/2045\n",
      "Page 259/2045\n",
      "Page 260/2045\n",
      "Page 261/2045\n",
      "Page 262/2045\n",
      "Page 263/2045\n",
      "Page 264/2045\n",
      "Page 265/2045\n",
      "Page 266/2045\n",
      "Page 267/2045\n",
      "Page 268/2045\n",
      "Page 269/2045\n",
      "NOT PAGENUM ['HEINSBERG']\n",
      "--                                          HEINSBERG--\n",
      "Assuming location\n",
      "Page 270/2045\n",
      "Page 271/2045\n",
      "Page 272/2045\n",
      "Page 273/2045\n",
      "Page 274/2045\n",
      "Page 275/2045\n",
      "Page 276/2045\n",
      "Page 277/2045\n",
      "Page 278/2045\n",
      "Page 279/2045\n",
      "Page 280/2045\n",
      "Page 281/2045\n",
      "Page 282/2045\n",
      "Page 283/2045\n",
      "Page 284/2045\n",
      "Page 285/2045\n",
      "Page 286/2045\n",
      "Page 287/2045\n",
      "Page 288/2045\n",
      "Page 289/2045\n",
      "Page 290/2045\n",
      "Page 291/2045\n",
      "Page 292/2045\n",
      "Page 293/2045\n",
      "Page 294/2045\n",
      "Page 295/2045\n",
      "Page 296/2045\n",
      "Page 297/2045\n",
      "Page 298/2045\n",
      "Page 299/2045\n",
      "Page 300/2045\n",
      "Page 301/2045\n",
      "Page 302/2045\n",
      "Page 303/2045\n",
      "Page 304/2045\n",
      "Page 305/2045\n",
      "Page 306/2045\n",
      "Page 307/2045\n",
      "Page 308/2045\n",
      "Page 309/2045\n",
      "Page 310/2045\n",
      "Page 311/2045\n",
      "Page 312/2045\n",
      "Page 313/2045\n",
      "Page 314/2045\n",
      "Page 315/2045\n",
      "Page 316/2045\n",
      "Page 317/2045\n",
      "Page 318/2045\n",
      "Page 319/2045\n",
      "Page 320/2045\n",
      "Page 321/2045\n",
      "Page 322/2045\n",
      "Page 323/2045\n",
      "Page 324/2045\n",
      "Page 325/2045\n",
      "Page 326/2045\n",
      "Page 327/2045\n",
      "Page 328/2045\n",
      "Page 329/2045\n",
      "Page 330/2045\n",
      "Page 331/2045\n",
      "Page 332/2045\n",
      "Page 333/2045\n",
      "Page 334/2045\n",
      "Page 335/2045\n",
      "Page 336/2045\n",
      "Page 337/2045\n",
      "Page 338/2045\n",
      "Page 339/2045\n",
      "Page 340/2045\n",
      "Page 341/2045\n",
      "Page 342/2045\n",
      "Page 343/2045\n",
      "NOT PAGENUM ['DRENTHE B.A.']\n",
      "--DRENTHE B.A.--\n",
      "Assuming company name\n",
      "Page 344/2045\n",
      "NOT PAGENUM ['U.A.']\n",
      "--U.A.--\n",
      "Assuming company name\n",
      "Page 345/2045\n",
      "Page 346/2045\n",
      "Page 347/2045\n",
      "Page 348/2045\n",
      "Page 349/2045\n",
      "Page 350/2045\n",
      "Page 351/2045\n",
      "Page 352/2045\n",
      "Page 353/2045\n",
      "Page 354/2045\n",
      "Page 355/2045\n",
      "Page 356/2045\n",
      "Page 357/2045\n",
      "Page 358/2045\n",
      "Page 359/2045\n",
      "Page 360/2045\n",
      "Page 361/2045\n",
      "Page 362/2045\n",
      "Page 363/2045\n",
      "Page 364/2045\n",
      "Page 365/2045\n",
      "Page 366/2045\n",
      "Page 367/2045\n",
      "Page 368/2045\n",
      "Page 369/2045\n",
      "Page 370/2045\n",
      "Page 371/2045\n",
      "Page 372/2045\n",
      "Page 373/2045\n",
      "Page 374/2045\n",
      "Page 375/2045\n",
      "Page 376/2045\n",
      "Page 377/2045\n",
      "Page 378/2045\n",
      "Page 379/2045\n",
      "Page 380/2045\n",
      "Page 381/2045\n",
      "Page 382/2045\n",
      "Page 383/2045\n",
      "Page 384/2045\n",
      "Page 385/2045\n",
      "Page 386/2045\n",
      "Page 387/2045\n",
      "Page 388/2045\n",
      "Page 389/2045\n",
      "Page 390/2045\n",
      "Page 391/2045\n",
      "Page 392/2045\n",
      "Page 393/2045\n",
      "Page 394/2045\n",
      "Page 395/2045\n",
      "Page 396/2045\n",
      "Page 397/2045\n",
      "Page 398/2045\n",
      "Page 399/2045\n",
      "Page 400/2045\n",
      "Page 401/2045\n",
      "Page 402/2045\n",
      "Page 403/2045\n",
      "Page 404/2045\n",
      "Page 405/2045\n",
      "Page 406/2045\n",
      "Page 407/2045\n",
      "Page 408/2045\n",
      "Page 409/2045\n",
      "Page 410/2045\n",
      "Page 411/2045\n",
      "Page 412/2045\n",
      "Page 413/2045\n",
      "Page 414/2045\n",
      "Page 415/2045\n",
      "Page 416/2045\n",
      "Page 417/2045\n",
      "Page 418/2045\n",
      "Page 419/2045\n",
      "Page 420/2045\n",
      "NOT PAGENUM ['ALBRANDSWAARD']\n",
      "--                                    ALBRANDSWAARD--\n",
      "Assuming location\n",
      "Page 421/2045\n",
      "Page 422/2045\n",
      "Page 423/2045\n",
      "Page 424/2045\n",
      "Page 425/2045\n",
      "Page 426/2045\n",
      "Page 427/2045\n",
      "Page 428/2045\n",
      "Page 429/2045\n",
      "Page 430/2045\n",
      "Page 431/2045\n",
      "Page 432/2045\n",
      "Page 433/2045\n",
      "Page 434/2045\n",
      "Page 435/2045\n",
      "Page 436/2045\n",
      "Page 437/2045\n",
      "Page 438/2045\n",
      "Page 439/2045\n",
      "Page 440/2045\n",
      "Page 441/2045\n",
      "Page 442/2045\n",
      "Page 443/2045\n",
      "Page 444/2045\n",
      "Page 445/2045\n",
      "Page 446/2045\n",
      "Page 447/2045\n",
      "Page 448/2045\n",
      "Page 449/2045\n",
      "Page 450/2045\n",
      "Page 451/2045\n",
      "Page 452/2045\n",
      "Page 453/2045\n",
      "Page 454/2045\n",
      "Page 455/2045\n",
      "Page 456/2045\n",
      "Page 457/2045\n",
      "Page 458/2045\n",
      "Page 459/2045\n",
      "Page 460/2045\n",
      "Page 461/2045\n",
      "Page 462/2045\n",
      "Page 463/2045\n",
      "Page 464/2045\n",
      "Page 465/2045\n",
      "Page 466/2045\n",
      "Page 467/2045\n",
      "Page 468/2045\n",
      "Page 469/2045\n",
      "Page 470/2045\n",
      "Page 471/2045\n",
      "Page 472/2045\n",
      "Page 473/2045\n",
      "Page 474/2045\n",
      "Page 475/2045\n",
      "Page 476/2045\n",
      "Page 477/2045\n",
      "Page 478/2045\n",
      "Page 479/2045\n",
      "Page 480/2045\n",
      "Page 481/2045\n",
      "Page 482/2045\n",
      "Page 483/2045\n",
      "Page 484/2045\n",
      "Page 485/2045\n",
      "Page 486/2045\n",
      "Page 487/2045\n",
      "Page 488/2045\n",
      "Page 489/2045\n",
      "Page 490/2045\n",
      "Page 491/2045\n",
      "Page 492/2045\n",
      "Page 493/2045\n",
      "Page 494/2045\n",
      "Page 495/2045\n",
      "Page 496/2045\n",
      "Page 497/2045\n",
      "Page 498/2045\n",
      "Page 499/2045\n",
      "Page 500/2045\n",
      "Page 501/2045\n",
      "Page 502/2045\n",
      "Page 503/2045\n",
      "Page 504/2045\n",
      "Page 505/2045\n",
      "Page 506/2045\n",
      "Page 507/2045\n",
      "Page 508/2045\n",
      "Page 509/2045\n",
      "Page 510/2045\n",
      "Page 511/2045\n",
      "Page 512/2045\n",
      "Page 513/2045\n",
      "Page 514/2045\n",
      "Page 515/2045\n",
      "Page 516/2045\n",
      "Page 517/2045\n",
      "Page 518/2045\n",
      "Page 519/2045\n",
      "Page 520/2045\n",
      "Page 521/2045\n",
      "Page 522/2045\n",
      "Page 523/2045\n",
      "Page 524/2045\n",
      "Page 525/2045\n",
      "Page 526/2045\n",
      "Page 527/2045\n",
      "Page 528/2045\n",
      "Page 529/2045\n",
      "Page 530/2045\n",
      "Page 531/2045\n",
      "Page 532/2045\n",
      "Page 533/2045\n",
      "Page 534/2045\n",
      "Page 535/2045\n",
      "Page 536/2045\n",
      "Page 537/2045\n",
      "Page 538/2045\n",
      "Page 539/2045\n",
      "Page 540/2045\n",
      "Page 541/2045\n",
      "Page 542/2045\n",
      "Page 543/2045\n",
      "Page 544/2045\n",
      "Page 545/2045\n",
      "Page 546/2045\n",
      "Page 547/2045\n",
      "Page 548/2045\n",
      "Page 549/2045\n",
      "Page 550/2045\n",
      "Page 551/2045\n",
      "Page 552/2045\n",
      "Page 553/2045\n",
      "Page 554/2045\n",
      "Page 555/2045\n",
      "Page 556/2045\n",
      "Page 557/2045\n",
      "Page 558/2045\n",
      "Page 559/2045\n",
      "Page 560/2045\n",
      "Page 561/2045\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Page 562/2045\n",
      "Page 563/2045\n",
      "Page 564/2045\n",
      "Page 565/2045\n",
      "Page 566/2045\n",
      "Page 567/2045\n",
      "Page 568/2045\n",
      "Page 569/2045\n",
      "Page 570/2045\n",
      "Page 571/2045\n",
      "Page 572/2045\n",
      "Page 573/2045\n",
      "Page 574/2045\n",
      "Page 575/2045\n",
      "Page 576/2045\n",
      "Page 577/2045\n",
      "Page 578/2045\n",
      "Page 579/2045\n",
      "Page 580/2045\n",
      "Page 581/2045\n",
      "Page 582/2045\n",
      "Page 583/2045\n",
      "Page 584/2045\n",
      "Page 585/2045\n",
      "Page 586/2045\n",
      "Page 587/2045\n",
      "Page 588/2045\n",
      "Page 589/2045\n",
      "Page 590/2045\n",
      "Page 591/2045\n",
      "Page 592/2045\n",
      "Page 593/2045\n",
      "Page 594/2045\n",
      "Page 595/2045\n",
      "Page 596/2045\n",
      "Page 597/2045\n",
      "Page 598/2045\n",
      "Page 599/2045\n",
      "Page 600/2045\n",
      "Page 601/2045\n",
      "Page 602/2045\n",
      "Page 603/2045\n",
      "Page 604/2045\n",
      "Page 605/2045\n",
      "Page 606/2045\n",
      "Page 607/2045\n",
      "Page 608/2045\n",
      "Page 609/2045\n",
      "Page 610/2045\n",
      "Page 611/2045\n",
      "Page 612/2045\n",
      "Page 613/2045\n",
      "Page 614/2045\n",
      "Page 615/2045\n",
      "Page 616/2045\n",
      "Page 617/2045\n",
      "Page 618/2045\n",
      "Page 619/2045\n",
      "Page 620/2045\n",
      "Page 621/2045\n",
      "Page 622/2045\n",
      "Page 623/2045\n",
      "Page 624/2045\n",
      "Page 625/2045\n",
      "Page 626/2045\n",
      "Page 627/2045\n",
      "Page 628/2045\n",
      "Page 629/2045\n",
      "Page 630/2045\n",
      "Page 631/2045\n",
      "Page 632/2045\n",
      "Page 633/2045\n",
      "NOT PAGENUM ['ALBRANDSWAARD']\n",
      "--                                         ALBRANDSWAARD--\n",
      "Assuming location\n",
      "Page 634/2045\n",
      "Page 635/2045\n",
      "Page 636/2045\n",
      "Page 637/2045\n",
      "Page 638/2045\n",
      "Page 639/2045\n",
      "Page 640/2045\n",
      "Page 641/2045\n",
      "Page 642/2045\n",
      "Page 643/2045\n",
      "Page 644/2045\n",
      "Page 645/2045\n",
      "Page 646/2045\n",
      "NOT PAGENUM ['ALBRANDSWAARD']\n",
      "--                                                       ALBRANDSWAARD--\n",
      "Assuming location\n",
      "Page 647/2045\n",
      "Page 648/2045\n",
      "Page 649/2045\n",
      "Page 650/2045\n",
      "Page 651/2045\n",
      "Page 652/2045\n",
      "NOT PAGENUM ['WESTERKWARTIER']\n",
      "--                                                       WESTERKWARTIER--\n",
      "Assuming location\n",
      "Page 653/2045\n",
      "Page 654/2045\n",
      "Page 655/2045\n",
      "Page 656/2045\n",
      "Page 657/2045\n",
      "Page 658/2045\n",
      "Page 659/2045\n",
      "Page 660/2045\n",
      "Page 661/2045\n",
      "Page 662/2045\n",
      "Page 663/2045\n",
      "Page 664/2045\n",
      "Page 665/2045\n",
      "Page 666/2045\n",
      "Page 667/2045\n",
      "Page 668/2045\n",
      "Page 669/2045\n",
      "Page 670/2045\n",
      "Page 671/2045\n",
      "Page 672/2045\n",
      "Page 673/2045\n",
      "Page 674/2045\n",
      "Page 675/2045\n",
      "Page 676/2045\n",
      "Page 677/2045\n",
      "Page 678/2045\n",
      "Page 679/2045\n",
      "Page 680/2045\n",
      "Page 681/2045\n",
      "Page 682/2045\n",
      "Page 683/2045\n",
      "Page 684/2045\n",
      "Page 685/2045\n",
      "Page 686/2045\n",
      "Page 687/2045\n",
      "Page 688/2045\n",
      "Page 689/2045\n",
      "Page 690/2045\n",
      "Page 691/2045\n",
      "Page 692/2045\n",
      "Page 693/2045\n",
      "Page 694/2045\n",
      "Page 695/2045\n",
      "Page 696/2045\n",
      "Page 697/2045\n",
      "Page 698/2045\n",
      "Page 699/2045\n",
      "Page 700/2045\n",
      "Page 701/2045\n",
      "Page 702/2045\n",
      "Page 703/2045\n",
      "Page 704/2045\n",
      "Page 705/2045\n",
      "Page 706/2045\n",
      "Page 707/2045\n",
      "Page 708/2045\n",
      "Page 709/2045\n",
      "Page 710/2045\n",
      "Page 711/2045\n",
      "Page 712/2045\n",
      "Page 713/2045\n",
      "Page 714/2045\n",
      "Page 715/2045\n",
      "Page 716/2045\n",
      "Page 717/2045\n",
      "Page 718/2045\n",
      "Page 719/2045\n",
      "Page 720/2045\n",
      "Page 721/2045\n",
      "Page 722/2045\n",
      "Page 723/2045\n",
      "Page 724/2045\n",
      "NOT PAGENUM ['ALBRANDSWAARD']\n",
      "--                                         ALBRANDSWAARD--\n",
      "Assuming location\n",
      "Page 725/2045\n",
      "Page 726/2045\n",
      "Page 727/2045\n",
      "Page 728/2045\n",
      "Page 729/2045\n",
      "Page 730/2045\n",
      "Page 731/2045\n",
      "Page 732/2045\n",
      "Page 733/2045\n",
      "Page 734/2045\n",
      "Page 735/2045\n",
      "Page 736/2045\n",
      "Page 737/2045\n",
      "Page 738/2045\n",
      "Page 739/2045\n",
      "NOT PAGENUM ['SMALLINGERLND']\n",
      "--                                                             SMALLINGERLND--\n",
      "Assuming location\n",
      "Page 740/2045\n",
      "Page 741/2045\n",
      "Page 742/2045\n",
      "Page 743/2045\n",
      "Page 744/2045\n",
      "Page 745/2045\n",
      "Page 746/2045\n",
      "Page 747/2045\n",
      "Page 748/2045\n",
      "Page 749/2045\n",
      "Page 750/2045\n",
      "Page 751/2045\n",
      "Page 752/2045\n",
      "Page 753/2045\n",
      "Page 754/2045\n",
      "Page 755/2045\n",
      "Page 756/2045\n",
      "Page 757/2045\n",
      "Page 758/2045\n",
      "Page 759/2045\n",
      "Page 760/2045\n",
      "Page 761/2045\n",
      "Page 762/2045\n",
      "Page 763/2045\n",
      "Page 764/2045\n",
      "Page 765/2045\n",
      "Page 766/2045\n",
      "Page 767/2045\n",
      "Page 768/2045\n",
      "Page 769/2045\n",
      "Page 770/2045\n",
      "Page 771/2045\n",
      "Page 772/2045\n",
      "Page 773/2045\n",
      "Page 774/2045\n",
      "Page 775/2045\n",
      "Page 776/2045\n",
      "Page 777/2045\n",
      "Page 778/2045\n",
      "Page 779/2045\n",
      "Page 780/2045\n",
      "Page 781/2045\n",
      "Page 782/2045\n",
      "Page 783/2045\n",
      "Page 784/2045\n",
      "Page 785/2045\n",
      "Page 786/2045\n",
      "NOT PAGENUM ['ALBRANDSWAARD']\n",
      "--                                                              ALBRANDSWAARD--\n",
      "Assuming location\n",
      "Page 787/2045\n",
      "Page 788/2045\n",
      "Page 789/2045\n",
      "Page 790/2045\n",
      "Page 791/2045\n",
      "Page 792/2045\n",
      "Page 793/2045\n",
      "Page 794/2045\n",
      "Page 795/2045\n",
      "Page 796/2045\n",
      "Page 797/2045\n",
      "Page 798/2045\n",
      "Page 799/2045\n",
      "Page 800/2045\n",
      "Page 801/2045\n",
      "Page 802/2045\n",
      "Page 803/2045\n",
      "Page 804/2045\n",
      "Page 805/2045\n",
      "Page 806/2045\n",
      "Page 807/2045\n",
      "Page 808/2045\n",
      "Page 809/2045\n",
      "Page 810/2045\n",
      "Page 811/2045\n",
      "Page 812/2045\n",
      "Page 813/2045\n",
      "Page 814/2045\n",
      "Page 815/2045\n",
      "Page 816/2045\n",
      "Page 817/2045\n",
      "Page 818/2045\n",
      "Page 819/2045\n",
      "Page 820/2045\n",
      "Page 821/2045\n",
      "Page 822/2045\n",
      "Page 823/2045\n",
      "Page 824/2045\n",
      "Page 825/2045\n",
      "Page 826/2045\n",
      "Page 827/2045\n",
      "Page 828/2045\n",
      "Page 829/2045\n",
      "Page 830/2045\n",
      "Page 831/2045\n",
      "Page 832/2045\n",
      "Page 833/2045\n",
      "Page 834/2045\n",
      "Page 835/2045\n",
      "Page 836/2045\n",
      "Page 837/2045\n",
      "Page 838/2045\n",
      "Page 839/2045\n",
      "Page 840/2045\n",
      "Page 841/2045\n",
      "Page 842/2045\n",
      "Page 843/2045\n",
      "Page 844/2045\n",
      "Page 845/2045\n",
      "Page 846/2045\n",
      "Page 847/2045\n",
      "Page 848/2045\n",
      "Page 849/2045\n",
      "Page 850/2045\n",
      "Page 851/2045\n",
      "Page 852/2045\n",
      "Page 853/2045\n",
      "Page 854/2045\n",
      "Page 855/2045\n",
      "Page 856/2045\n",
      "Page 857/2045\n",
      "Page 858/2045\n",
      "Page 859/2045\n",
      "Page 860/2045\n",
      "Page 861/2045\n",
      "Page 862/2045\n",
      "Page 863/2045\n",
      "Page 864/2045\n",
      "Page 865/2045\n",
      "Page 866/2045\n",
      "Page 867/2045\n",
      "Page 868/2045\n",
      "Page 869/2045\n",
      "Page 870/2045\n",
      "Page 871/2045\n",
      "Page 872/2045\n",
      "Page 873/2045\n",
      "Page 874/2045\n",
      "Page 875/2045\n",
      "Page 876/2045\n",
      "Page 877/2045\n",
      "Page 878/2045\n",
      "NOT PAGENUM ['ALBRANDSWAARD']\n",
      "--                                                    ALBRANDSWAARD--\n",
      "Assuming location\n",
      "Page 879/2045\n",
      "Page 880/2045\n",
      "Page 881/2045\n",
      "Page 882/2045\n",
      "Page 883/2045\n",
      "Page 884/2045\n",
      "Page 885/2045\n",
      "Page 886/2045\n",
      "Page 887/2045\n",
      "Page 888/2045\n",
      "Page 889/2045\n",
      "Page 890/2045\n",
      "Page 891/2045\n",
      "Page 892/2045\n",
      "Page 893/2045\n",
      "Page 894/2045\n",
      "Page 895/2045\n",
      "Page 896/2045\n",
      "Page 897/2045\n",
      "Page 898/2045\n",
      "Page 899/2045\n",
      "Page 900/2045\n",
      "Page 901/2045\n",
      "Page 902/2045\n",
      "Page 903/2045\n",
      "Page 904/2045\n",
      "Page 905/2045\n",
      "Page 906/2045\n",
      "Page 907/2045\n",
      "Page 908/2045\n",
      "Page 909/2045\n",
      "Page 910/2045\n",
      "Page 911/2045\n",
      "Page 912/2045\n",
      "Page 913/2045\n",
      "Page 914/2045\n",
      "Page 915/2045\n",
      "Page 916/2045\n",
      "Page 917/2045\n",
      "Page 918/2045\n",
      "Page 919/2045\n",
      "Page 920/2045\n",
      "Page 921/2045\n",
      "Page 922/2045\n",
      "Page 923/2045\n",
      "Page 924/2045\n",
      "Page 925/2045\n",
      "Page 926/2045\n",
      "Page 927/2045\n",
      "Page 928/2045\n",
      "Page 929/2045\n",
      "Page 930/2045\n",
      "Page 931/2045\n",
      "Page 932/2045\n",
      "Page 933/2045\n",
      "Page 934/2045\n",
      "Page 935/2045\n",
      "Page 936/2045\n",
      "Page 937/2045\n",
      "Page 938/2045\n",
      "Page 939/2045\n",
      "Page 940/2045\n",
      "Page 941/2045\n",
      "Page 942/2045\n",
      "Page 943/2045\n",
      "Page 944/2045\n",
      "Page 945/2045\n",
      "Page 946/2045\n",
      "Page 947/2045\n",
      "Page 948/2045\n",
      "Page 949/2045\n",
      "Page 950/2045\n",
      "Page 951/2045\n",
      "Page 952/2045\n",
      "Page 953/2045\n",
      "Page 954/2045\n",
      "Page 955/2045\n",
      "Page 956/2045\n",
      "Page 957/2045\n",
      "Page 958/2045\n",
      "Page 959/2045\n",
      "Page 960/2045\n",
      "Page 961/2045\n",
      "Page 962/2045\n",
      "Page 963/2045\n",
      "Page 964/2045\n",
      "Page 965/2045\n",
      "Page 966/2045\n",
      "Page 967/2045\n",
      "Page 968/2045\n",
      "Page 969/2045\n",
      "Page 970/2045\n",
      "Page 971/2045\n",
      "Page 972/2045\n",
      "Page 973/2045\n",
      "Page 974/2045\n",
      "Page 975/2045\n",
      "Page 976/2045\n",
      "Page 977/2045\n",
      "Page 978/2045\n",
      "Page 979/2045\n",
      "Page 980/2045\n",
      "Page 981/2045\n",
      "Page 982/2045\n",
      "Page 983/2045\n",
      "Page 984/2045\n",
      "Page 985/2045\n",
      "Page 986/2045\n",
      "Page 987/2045\n",
      "Page 988/2045\n",
      "Page 989/2045\n",
      "Page 990/2045\n",
      "Page 991/2045\n",
      "Page 992/2045\n",
      "Page 993/2045\n",
      "Page 994/2045\n",
      "Page 995/2045\n",
      "Page 996/2045\n",
      "Page 997/2045\n",
      "Page 998/2045\n",
      "Page 999/2045\n",
      "Page 1000/2045\n",
      "NOT PAGENUM ['HENDRIKSE-VOOGT']\n",
      "--HENDRIKSE-VOOGT--\n",
      "Assuming company name\n",
      "Page 1001/2045\n",
      "Page 1002/2045\n",
      "Page 1003/2045\n",
      "Page 1004/2045\n",
      "Page 1005/2045\n",
      "Page 1006/2045\n",
      "Page 1007/2045\n",
      "NOT PAGENUM ['TANDHEELKUNDE AMSTERDAM']\n",
      "--TANDHEELKUNDE AMSTERDAM--\n",
      "Assuming company name\n",
      "Page 1008/2045\n",
      "Page 1009/2045\n",
      "Page 1010/2045\n",
      "Page 1011/2045\n",
      "Page 1012/2045\n",
      "Page 1013/2045\n",
      "Page 1014/2045\n",
      "Page 1015/2045\n",
      "Page 1016/2045\n",
      "Page 1017/2045\n",
      "Page 1018/2045\n",
      "Page 1019/2045\n",
      "Page 1020/2045\n",
      "Page 1021/2045\n",
      "Page 1022/2045\n",
      "Page 1023/2045\n",
      "Page 1024/2045\n",
      "Page 1025/2045\n",
      "Page 1026/2045\n",
      "Page 1027/2045\n",
      "Page 1028/2045\n",
      "Page 1029/2045\n",
      "Page 1030/2045\n",
      "Page 1031/2045\n",
      "Page 1032/2045\n",
      "Page 1033/2045\n",
      "Page 1034/2045\n",
      "Page 1035/2045\n",
      "Page 1036/2045\n",
      "Page 1037/2045\n",
      "Page 1038/2045\n",
      "Page 1039/2045\n",
      "Page 1040/2045\n",
      "Page 1041/2045\n",
      "Page 1042/2045\n",
      "Page 1043/2045\n",
      "Page 1044/2045\n",
      "Page 1045/2045\n",
      "Page 1046/2045\n",
      "Page 1047/2045\n",
      "Page 1048/2045\n",
      "Page 1049/2045\n",
      "Page 1050/2045\n",
      "Page 1051/2045\n",
      "Page 1052/2045\n",
      "Page 1053/2045\n",
      "Page 1054/2045\n",
      "Page 1055/2045\n",
      "Page 1056/2045\n",
      "Page 1057/2045\n",
      "Page 1058/2045\n",
      "Page 1059/2045\n",
      "Page 1060/2045\n",
      "Page 1061/2045\n",
      "Page 1062/2045\n",
      "Page 1063/2045\n",
      "Page 1064/2045\n",
      "Page 1065/2045\n",
      "Page 1066/2045\n",
      "Page 1067/2045\n",
      "Page 1068/2045\n",
      "Page 1069/2045\n",
      "Page 1070/2045\n",
      "Page 1071/2045\n",
      "Page 1072/2045\n",
      "Page 1073/2045\n",
      "Page 1074/2045\n",
      "Page 1075/2045\n",
      "Page 1076/2045\n",
      "Page 1077/2045\n",
      "Page 1078/2045\n",
      "Page 1079/2045\n",
      "Page 1080/2045\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Page 1081/2045\n",
      "Page 1082/2045\n",
      "Page 1083/2045\n",
      "Page 1084/2045\n",
      "Page 1085/2045\n",
      "Page 1086/2045\n",
      "Page 1087/2045\n",
      "Page 1088/2045\n",
      "Page 1089/2045\n",
      "Page 1090/2045\n",
      "Page 1091/2045\n",
      "Page 1092/2045\n",
      "Page 1093/2045\n",
      "Page 1094/2045\n",
      "Page 1095/2045\n",
      "Page 1096/2045\n",
      "Page 1097/2045\n",
      "Page 1098/2045\n",
      "Page 1099/2045\n",
      "Page 1100/2045\n",
      "Page 1101/2045\n",
      "Page 1102/2045\n",
      "Page 1103/2045\n",
      "Page 1104/2045\n",
      "Page 1105/2045\n",
      "Page 1106/2045\n",
      "Page 1107/2045\n",
      "Page 1108/2045\n",
      "Page 1109/2045\n",
      "Page 1110/2045\n",
      "Page 1111/2045\n",
      "Page 1112/2045\n",
      "Page 1113/2045\n",
      "NOT PAGENUM ['ALBRANDSWAARD']\n",
      "--                                               ALBRANDSWAARD--\n",
      "Assuming location\n",
      "NOT PAGENUM ['ALBRANDSWAARD']\n",
      "--                                               ALBRANDSWAARD--\n",
      "Assuming location\n",
      "NOT PAGENUM ['ALBRANDSWAARD']\n",
      "--                                               ALBRANDSWAARD--\n",
      "Assuming location\n",
      "NOT PAGENUM ['ALBRANDSWAARD']\n",
      "--                                               ALBRANDSWAARD--\n",
      "Assuming location\n",
      "Page 1114/2045\n",
      "Page 1115/2045\n",
      "Page 1116/2045\n",
      "Page 1117/2045\n",
      "NOT PAGENUM ['ALBRANDSWAARD']\n",
      "--                                          ALBRANDSWAARD--\n",
      "Assuming location\n",
      "NOT PAGENUM ['ALBRANDSWAARD']\n",
      "--                                          ALBRANDSWAARD--\n",
      "Assuming location\n",
      "Page 1118/2045\n",
      "Page 1119/2045\n",
      "Page 1120/2045\n",
      "Page 1121/2045\n",
      "Page 1122/2045\n",
      "Page 1123/2045\n",
      "Page 1124/2045\n",
      "Page 1125/2045\n",
      "Page 1126/2045\n",
      "Page 1127/2045\n",
      "Page 1128/2045\n",
      "Page 1129/2045\n",
      "Page 1130/2045\n",
      "Page 1131/2045\n",
      "Page 1132/2045\n",
      "Page 1133/2045\n",
      "Page 1134/2045\n",
      "Page 1135/2045\n",
      "Page 1136/2045\n",
      "Page 1137/2045\n",
      "Page 1138/2045\n",
      "Page 1139/2045\n",
      "Page 1140/2045\n",
      "Page 1141/2045\n",
      "Page 1142/2045\n",
      "Page 1143/2045\n",
      "Page 1144/2045\n",
      "Page 1145/2045\n",
      "Page 1146/2045\n",
      "Page 1147/2045\n",
      "Page 1148/2045\n",
      "Page 1149/2045\n",
      "Page 1150/2045\n",
      "Page 1151/2045\n",
      "Page 1152/2045\n",
      "Page 1153/2045\n",
      "Page 1154/2045\n",
      "Page 1155/2045\n",
      "Page 1156/2045\n",
      "Page 1157/2045\n",
      "Page 1158/2045\n",
      "Page 1159/2045\n",
      "Page 1160/2045\n",
      "Page 1161/2045\n",
      "Page 1162/2045\n",
      "Page 1163/2045\n",
      "Page 1164/2045\n",
      "Page 1165/2045\n",
      "Page 1166/2045\n",
      "Page 1167/2045\n",
      "Page 1168/2045\n",
      "Page 1169/2045\n",
      "Page 1170/2045\n",
      "Page 1171/2045\n",
      "Page 1172/2045\n",
      "Page 1173/2045\n",
      "Page 1174/2045\n",
      "Page 1175/2045\n",
      "Page 1176/2045\n",
      "Page 1177/2045\n",
      "Page 1178/2045\n",
      "Page 1179/2045\n",
      "Page 1180/2045\n",
      "Page 1181/2045\n",
      "Page 1182/2045\n",
      "Page 1183/2045\n",
      "Page 1184/2045\n",
      "Page 1185/2045\n",
      "Page 1186/2045\n",
      "Page 1187/2045\n",
      "Page 1188/2045\n",
      "Page 1189/2045\n",
      "Page 1190/2045\n",
      "Page 1191/2045\n",
      "Page 1192/2045\n",
      "Page 1193/2045\n",
      "Page 1194/2045\n",
      "Page 1195/2045\n",
      "Page 1196/2045\n",
      "Page 1197/2045\n",
      "Page 1198/2045\n",
      "Page 1199/2045\n",
      "Page 1200/2045\n",
      "Page 1201/2045\n",
      "Page 1202/2045\n",
      "Page 1203/2045\n",
      "Page 1204/2045\n",
      "Page 1205/2045\n",
      "Page 1206/2045\n",
      "Page 1207/2045\n",
      "Page 1208/2045\n",
      "Page 1209/2045\n",
      "Page 1210/2045\n",
      "Page 1211/2045\n",
      "Page 1212/2045\n",
      "Page 1213/2045\n",
      "Page 1214/2045\n",
      "Page 1215/2045\n",
      "Page 1216/2045\n",
      "Page 1217/2045\n",
      "Page 1218/2045\n",
      "Page 1219/2045\n",
      "Page 1220/2045\n",
      "Page 1221/2045\n",
      "Page 1222/2045\n",
      "Page 1223/2045\n",
      "Page 1224/2045\n",
      "Page 1225/2045\n",
      "Page 1226/2045\n",
      "Page 1227/2045\n",
      "Page 1228/2045\n",
      "Page 1229/2045\n",
      "Page 1230/2045\n",
      "Page 1231/2045\n",
      "Page 1232/2045\n",
      "Page 1233/2045\n",
      "Page 1234/2045\n",
      "Page 1235/2045\n",
      "Page 1236/2045\n",
      "Page 1237/2045\n",
      "Page 1238/2045\n",
      "Page 1239/2045\n",
      "Page 1240/2045\n",
      "Page 1241/2045\n",
      "Page 1242/2045\n",
      "Page 1243/2045\n",
      "Page 1244/2045\n",
      "Page 1245/2045\n",
      "Page 1246/2045\n",
      "Page 1247/2045\n",
      "Page 1248/2045\n",
      "Page 1249/2045\n",
      "Page 1250/2045\n",
      "Page 1251/2045\n",
      "Page 1252/2045\n",
      "Page 1253/2045\n",
      "Page 1254/2045\n",
      "Page 1255/2045\n",
      "Page 1256/2045\n",
      "Page 1257/2045\n",
      "Page 1258/2045\n",
      "Page 1259/2045\n",
      "Page 1260/2045\n",
      "Page 1261/2045\n",
      "Page 1262/2045\n",
      "Page 1263/2045\n",
      "Page 1264/2045\n",
      "Page 1265/2045\n",
      "Page 1266/2045\n",
      "Page 1267/2045\n",
      "Page 1268/2045\n",
      "Page 1269/2045\n",
      "Page 1270/2045\n",
      "Page 1271/2045\n",
      "Page 1272/2045\n",
      "Page 1273/2045\n",
      "Page 1274/2045\n",
      "Page 1275/2045\n",
      "Page 1276/2045\n",
      "Page 1277/2045\n",
      "Page 1278/2045\n",
      "Page 1279/2045\n",
      "Page 1280/2045\n",
      "Page 1281/2045\n",
      "Page 1282/2045\n",
      "Page 1283/2045\n",
      "Page 1284/2045\n",
      "Page 1285/2045\n",
      "Page 1286/2045\n",
      "Page 1287/2045\n",
      "Page 1288/2045\n",
      "Page 1289/2045\n",
      "Page 1290/2045\n",
      "Page 1291/2045\n",
      "Page 1292/2045\n",
      "Page 1293/2045\n",
      "Page 1294/2045\n",
      "Page 1295/2045\n",
      "Page 1296/2045\n",
      "Page 1297/2045\n",
      "Page 1298/2045\n",
      "Page 1299/2045\n",
      "Page 1300/2045\n",
      "Page 1301/2045\n",
      "Page 1302/2045\n",
      "Page 1303/2045\n",
      "Page 1304/2045\n",
      "Page 1305/2045\n",
      "Page 1306/2045\n",
      "Page 1307/2045\n",
      "Page 1308/2045\n",
      "Page 1309/2045\n",
      "Page 1310/2045\n",
      "Page 1311/2045\n",
      "Page 1312/2045\n",
      "Page 1313/2045\n",
      "Page 1314/2045\n",
      "Page 1315/2045\n",
      "Page 1316/2045\n",
      "Page 1317/2045\n",
      "Page 1318/2045\n",
      "Page 1319/2045\n",
      "Page 1320/2045\n",
      "Page 1321/2045\n",
      "Page 1322/2045\n",
      "Page 1323/2045\n",
      "Page 1324/2045\n",
      "Page 1325/2045\n",
      "Page 1326/2045\n",
      "Page 1327/2045\n",
      "Page 1328/2045\n",
      "Page 1329/2045\n",
      "Page 1330/2045\n",
      "Page 1331/2045\n",
      "Page 1332/2045\n",
      "Page 1333/2045\n",
      "NOT PAGENUM ['ALBERTUS MAGNUS)']\n",
      "--ALBERTUS MAGNUS)--\n",
      "Assuming company name\n",
      "Page 1334/2045\n",
      "Page 1335/2045\n",
      "Page 1336/2045\n",
      "Page 1337/2045\n",
      "Page 1338/2045\n",
      "Page 1339/2045\n",
      "NOT PAGENUM ['ALBRANDSWAARD']\n",
      "--                                      ALBRANDSWAARD--\n",
      "Assuming location\n",
      "Page 1340/2045\n",
      "Page 1341/2045\n",
      "Page 1342/2045\n",
      "Page 1343/2045\n",
      "Page 1344/2045\n",
      "Page 1345/2045\n",
      "Page 1346/2045\n",
      "Page 1347/2045\n",
      "Page 1348/2045\n",
      "Page 1349/2045\n",
      "Page 1350/2045\n",
      "Page 1351/2045\n",
      "Page 1352/2045\n",
      "Page 1353/2045\n",
      "Page 1354/2045\n",
      "Page 1355/2045\n",
      "Page 1356/2045\n",
      "Page 1357/2045\n",
      "Page 1358/2045\n",
      "Page 1359/2045\n",
      "Page 1360/2045\n",
      "Page 1361/2045\n",
      "Page 1362/2045\n",
      "Page 1363/2045\n",
      "Page 1364/2045\n",
      "Page 1365/2045\n",
      "Page 1366/2045\n",
      "Page 1367/2045\n",
      "Page 1368/2045\n",
      "Page 1369/2045\n",
      "Page 1370/2045\n",
      "Page 1371/2045\n",
      "Page 1372/2045\n",
      "Page 1373/2045\n",
      "Page 1374/2045\n",
      "Page 1375/2045\n",
      "Page 1376/2045\n",
      "Page 1377/2045\n",
      "Page 1378/2045\n",
      "Page 1379/2045\n",
      "Page 1380/2045\n",
      "Page 1381/2045\n",
      "Page 1382/2045\n",
      "Page 1383/2045\n",
      "Page 1384/2045\n",
      "Page 1385/2045\n",
      "Page 1386/2045\n",
      "Page 1387/2045\n",
      "Page 1388/2045\n",
      "Page 1389/2045\n",
      "Page 1390/2045\n",
      "Page 1391/2045\n",
      "Page 1392/2045\n",
      "Page 1393/2045\n",
      "Page 1394/2045\n",
      "Page 1395/2045\n",
      "Page 1396/2045\n",
      "Page 1397/2045\n",
      "Page 1398/2045\n",
      "Page 1399/2045\n",
      "Page 1400/2045\n",
      "Page 1401/2045\n",
      "NOT PAGENUM ['ALBRANDSWAARD']\n",
      "--                                                            ALBRANDSWAARD--\n",
      "Assuming location\n",
      "Page 1402/2045\n",
      "Page 1403/2045\n",
      "Page 1404/2045\n",
      "Page 1405/2045\n",
      "Page 1406/2045\n",
      "Page 1407/2045\n",
      "Page 1408/2045\n",
      "Page 1409/2045\n",
      "Page 1410/2045\n",
      "Page 1411/2045\n",
      "Page 1412/2045\n",
      "Page 1413/2045\n",
      "Page 1414/2045\n",
      "Page 1415/2045\n",
      "Page 1416/2045\n",
      "Page 1417/2045\n",
      "Page 1418/2045\n",
      "Page 1419/2045\n",
      "Page 1420/2045\n",
      "Page 1421/2045\n",
      "Page 1422/2045\n",
      "Page 1423/2045\n",
      "Page 1424/2045\n",
      "Page 1425/2045\n",
      "Page 1426/2045\n",
      "Page 1427/2045\n",
      "Page 1428/2045\n",
      "Page 1429/2045\n",
      "Page 1430/2045\n",
      "Page 1431/2045\n",
      "Page 1432/2045\n",
      "Page 1433/2045\n",
      "Page 1434/2045\n",
      "NOT PAGENUM ['ALBRANDSWAARD']\n",
      "--                                                     ALBRANDSWAARD--\n",
      "Assuming location\n",
      "Page 1435/2045\n",
      "Page 1436/2045\n",
      "Page 1437/2045\n",
      "Page 1438/2045\n",
      "Page 1439/2045\n",
      "Page 1440/2045\n",
      "Page 1441/2045\n",
      "Page 1442/2045\n",
      "Page 1443/2045\n",
      "Page 1444/2045\n",
      "Page 1445/2045\n",
      "Page 1446/2045\n",
      "Page 1447/2045\n",
      "Page 1448/2045\n",
      "Page 1449/2045\n",
      "Page 1450/2045\n",
      "Page 1451/2045\n",
      "Page 1452/2045\n",
      "Page 1453/2045\n",
      "Page 1454/2045\n",
      "NOT PAGENUM ['V.D. GENEESKUNDE']\n",
      "--V.D. GENEESKUNDE--\n",
      "Assuming company name\n",
      "Page 1455/2045\n",
      "Page 1456/2045\n",
      "Page 1457/2045\n",
      "Page 1458/2045\n",
      "Page 1459/2045\n",
      "Page 1460/2045\n",
      "Page 1461/2045\n",
      "Page 1462/2045\n",
      "Page 1463/2045\n",
      "Page 1464/2045\n",
      "Page 1465/2045\n",
      "Page 1466/2045\n",
      "Page 1467/2045\n",
      "Page 1468/2045\n",
      "NOT PAGENUM ['ARTIS MAGISTRA']\n",
      "--ARTIS MAGISTRA--\n",
      "Assuming company name\n",
      "Page 1469/2045\n",
      "Page 1470/2045\n",
      "NOT PAGENUM ['ALBRANDSWAARD']\n",
      "--                                                                      ALBRANDSWAARD--\n",
      "Assuming location\n",
      "Page 1471/2045\n",
      "Page 1472/2045\n",
      "Page 1473/2045\n",
      "Page 1474/2045\n",
      "Page 1475/2045\n",
      "Page 1476/2045\n",
      "Page 1477/2045\n",
      "Page 1478/2045\n",
      "NOT PAGENUM ['NOORDWEST-NED.']\n",
      "--NOORDWEST-NED.--\n",
      "Assuming company name\n",
      "Page 1479/2045\n",
      "Page 1480/2045\n",
      "NOT PAGENUM ['WESTERKWARTIER']\n",
      "--                                                                                           WESTERKWARTIER--\n",
      "Assuming location\n",
      "NOT PAGENUM ['VRAAGSTUKKEN']\n",
      "--VRAAGSTUKKEN--\n",
      "Assuming company name\n",
      "Page 1481/2045\n",
      "NOT PAGENUM ['THERAPIE']\n",
      "--THERAPIE--\n",
      "Assuming company name\n",
      "NOT PAGENUM ['GRONDSLAG']\n",
      "--GRONDSLAG--\n",
      "Assuming company name\n",
      "Page 1482/2045\n",
      "Page 1483/2045\n",
      "Page 1484/2045\n",
      "Page 1485/2045\n",
      "Page 1486/2045\n",
      "Page 1487/2045\n",
      "NOT PAGENUM ['CULTUURHISTOR.STUDIES']\n",
      "--CULTUURHISTOR.STUDIES--\n",
      "Assuming company name\n",
      "Page 1488/2045\n",
      "Page 1489/2045\n",
      "Page 1490/2045\n",
      "NOT PAGENUM ['ONDERWIJS']\n",
      "--ONDERWIJS--\n",
      "Assuming company name\n",
      "Page 1491/2045\n",
      "Page 1492/2045\n",
      "NOT PAGENUM ['\"HET ORANJE KRUI']\n",
      "--\"HET ORANJE KRUI--\n",
      "Assuming company name\n",
      "Page 1493/2045\n",
      "NOT PAGENUM ['UITERLIJKE VERZORGING']\n",
      "--UITERLIJKE VERZORGING--\n",
      "Assuming company name\n",
      "Page 1494/2045\n",
      "NOT PAGENUM ['ACTIVITEITENBEGELEIDI']\n",
      "--ACTIVITEITENBEGELEIDI--\n",
      "Assuming company name\n",
      "Page 1495/2045\n",
      "Page 1496/2045\n",
      "Page 1497/2045\n",
      "Page 1498/2045\n",
      "Page 1499/2045\n",
      "Page 1500/2045\n",
      "Page 1501/2045\n",
      "Page 1502/2045\n",
      "Page 1503/2045\n",
      "NOT PAGENUM ['ROTTERDAM']\n",
      "--ROTTERDAM--\n",
      "Assuming company name\n",
      "NOT PAGENUM ['NEDERLAND']\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "--NEDERLAND--\n",
      "Assuming company name\n",
      "Page 1504/2045\n",
      "Page 1505/2045\n",
      "Page 1506/2045\n",
      "Page 1507/2045\n",
      "NOT PAGENUM ['MIERDEN)']\n",
      "--MIERDEN)--\n",
      "Assuming company name\n",
      "Page 1508/2045\n",
      "NOT PAGENUM ['SPECIALISES FRANC']\n",
      "--SPECIALISES FRANC--\n",
      "Assuming company name\n",
      "Page 1509/2045\n",
      "Page 1510/2045\n",
      "NOT PAGENUM ['GEMEENTE CAST']\n",
      "--GEMEENTE CAST--\n",
      "Assuming company name\n",
      "Page 1511/2045\n",
      "Page 1512/2045\n",
      "Page 1513/2045\n",
      "Page 1514/2045\n",
      "Page 1515/2045\n",
      "Page 1516/2045\n",
      "Page 1517/2045\n",
      "Page 1518/2045\n",
      "Page 1519/2045\n",
      "Page 1520/2045\n",
      "Page 1521/2045\n",
      "Page 1522/2045\n",
      "Page 1523/2045\n",
      "Page 1524/2045\n",
      "Page 1525/2045\n",
      "Page 1526/2045\n",
      "Page 1527/2045\n",
      "Page 1528/2045\n",
      "Page 1529/2045\n",
      "Page 1530/2045\n",
      "Page 1531/2045\n",
      "Page 1532/2045\n",
      "Page 1533/2045\n",
      "Page 1534/2045\n",
      "Page 1535/2045\n",
      "NOT PAGENUM ['ALBRANDSWAARD']\n",
      "--                                             ALBRANDSWAARD--\n",
      "Assuming location\n",
      "Page 1536/2045\n",
      "Page 1537/2045\n",
      "Page 1538/2045\n",
      "Page 1539/2045\n",
      "NOT PAGENUM ['LTD']\n",
      "--LTD--\n",
      "Assuming company name\n",
      "Page 1540/2045\n",
      "Page 1541/2045\n",
      "Page 1542/2045\n",
      "Page 1543/2045\n",
      "Page 1544/2045\n",
      "Page 1545/2045\n",
      "Page 1546/2045\n",
      "Page 1547/2045\n",
      "Page 1548/2045\n",
      "Page 1549/2045\n",
      "Page 1550/2045\n",
      "Page 1551/2045\n",
      "Page 1552/2045\n",
      "Page 1553/2045\n",
      "Page 1554/2045\n",
      "Page 1555/2045\n",
      "Page 1556/2045\n",
      "Page 1557/2045\n",
      "Page 1558/2045\n",
      "Page 1559/2045\n",
      "Page 1560/2045\n",
      "Page 1561/2045\n",
      "Page 1562/2045\n",
      "Page 1563/2045\n",
      "Page 1564/2045\n",
      "Page 1565/2045\n",
      "Page 1566/2045\n",
      "Page 1567/2045\n",
      "Page 1568/2045\n",
      "Page 1569/2045\n",
      "Page 1570/2045\n",
      "Page 1571/2045\n",
      "Page 1572/2045\n",
      "Page 1573/2045\n",
      "Page 1574/2045\n",
      "Page 1575/2045\n",
      "Page 1576/2045\n",
      "Page 1577/2045\n",
      "Page 1578/2045\n",
      "Page 1579/2045\n",
      "Page 1580/2045\n",
      "Page 1581/2045\n",
      "Page 1582/2045\n",
      "NOT PAGENUM ['STUKENBROCK']\n",
      "--                                                       STUKENBROCK--\n",
      "Assuming location\n",
      "Page 1583/2045\n",
      "Page 1584/2045\n",
      "Page 1585/2045\n",
      "Page 1586/2045\n",
      "Page 1587/2045\n",
      "Page 1588/2045\n",
      "Page 1589/2045\n",
      "Page 1590/2045\n",
      "Page 1591/2045\n",
      "Page 1592/2045\n",
      "Page 1593/2045\n",
      "Page 1594/2045\n",
      "Page 1595/2045\n",
      "Page 1596/2045\n",
      "Page 1597/2045\n",
      "Page 1598/2045\n",
      "Page 1599/2045\n",
      "Page 1600/2045\n",
      "Page 1601/2045\n",
      "Page 1602/2045\n",
      "Page 1603/2045\n",
      "Page 1604/2045\n",
      "Page 1605/2045\n",
      "Page 1606/2045\n",
      "Page 1607/2045\n",
      "Page 1608/2045\n",
      "Page 1609/2045\n",
      "Page 1610/2045\n",
      "Page 1611/2045\n",
      "Page 1612/2045\n",
      "Page 1613/2045\n",
      "Page 1614/2045\n",
      "Page 1615/2045\n",
      "Page 1616/2045\n",
      "Page 1617/2045\n",
      "Page 1618/2045\n",
      "Page 1619/2045\n",
      "Page 1620/2045\n",
      "Page 1621/2045\n",
      "Page 1622/2045\n",
      "Page 1623/2045\n",
      "Page 1624/2045\n",
      "Page 1625/2045\n",
      "Page 1626/2045\n",
      "Page 1627/2045\n",
      "Page 1628/2045\n",
      "Page 1629/2045\n",
      "Page 1630/2045\n",
      "Page 1631/2045\n",
      "Page 1632/2045\n",
      "Page 1633/2045\n",
      "Page 1634/2045\n",
      "Page 1635/2045\n",
      "Page 1636/2045\n",
      "Page 1637/2045\n",
      "Page 1638/2045\n",
      "Page 1639/2045\n",
      "Page 1640/2045\n",
      "Page 1641/2045\n",
      "Page 1642/2045\n",
      "Page 1643/2045\n",
      "Page 1644/2045\n",
      "Page 1645/2045\n",
      "Page 1646/2045\n",
      "Page 1647/2045\n",
      "Page 1648/2045\n",
      "Page 1649/2045\n",
      "Page 1650/2045\n",
      "Page 1651/2045\n",
      "Page 1652/2045\n",
      "Page 1653/2045\n",
      "Page 1654/2045\n",
      "Page 1655/2045\n",
      "Page 1656/2045\n",
      "Page 1657/2045\n",
      "Page 1658/2045\n",
      "Page 1659/2045\n",
      "Page 1660/2045\n",
      "Page 1661/2045\n",
      "Page 1662/2045\n",
      "Page 1663/2045\n",
      "Page 1664/2045\n",
      "Page 1665/2045\n",
      "Page 1666/2045\n",
      "Page 1667/2045\n",
      "Page 1668/2045\n",
      "Page 1669/2045\n",
      "Page 1670/2045\n",
      "Page 1671/2045\n",
      "Page 1672/2045\n",
      "Page 1673/2045\n",
      "Page 1674/2045\n",
      "Page 1675/2045\n",
      "Page 1676/2045\n",
      "Page 1677/2045\n",
      "Page 1678/2045\n",
      "Page 1679/2045\n",
      "Page 1680/2045\n",
      "Page 1681/2045\n",
      "Page 1682/2045\n",
      "Page 1683/2045\n",
      "Page 1684/2045\n",
      "Page 1685/2045\n",
      "Page 1686/2045\n",
      "Page 1687/2045\n",
      "Page 1688/2045\n",
      "Page 1689/2045\n",
      "Page 1690/2045\n",
      "Page 1691/2045\n",
      "Page 1692/2045\n",
      "Page 1693/2045\n",
      "Page 1694/2045\n",
      "Page 1695/2045\n",
      "Page 1696/2045\n",
      "Page 1697/2045\n",
      "Page 1698/2045\n",
      "Page 1699/2045\n",
      "Page 1700/2045\n",
      "Page 1701/2045\n",
      "Page 1702/2045\n",
      "Page 1703/2045\n",
      "NOT PAGENUM ['SMALLINGERLND']\n",
      "--                                                SMALLINGERLND--\n",
      "Assuming location\n",
      "Page 1704/2045\n",
      "Page 1705/2045\n",
      "Page 1706/2045\n",
      "Page 1707/2045\n",
      "Page 1708/2045\n",
      "Page 1709/2045\n",
      "Page 1710/2045\n",
      "Page 1711/2045\n",
      "Page 1712/2045\n",
      "Page 1713/2045\n",
      "Page 1714/2045\n",
      "Page 1715/2045\n",
      "Page 1716/2045\n",
      "Page 1717/2045\n",
      "Page 1718/2045\n",
      "Page 1719/2045\n",
      "Page 1720/2045\n",
      "Page 1721/2045\n",
      "Page 1722/2045\n",
      "Page 1723/2045\n",
      "Page 1724/2045\n",
      "Page 1725/2045\n",
      "Page 1726/2045\n",
      "Page 1727/2045\n",
      "Page 1728/2045\n",
      "Page 1729/2045\n",
      "Page 1730/2045\n",
      "Page 1731/2045\n",
      "Page 1732/2045\n",
      "Page 1733/2045\n",
      "Page 1734/2045\n",
      "Page 1735/2045\n",
      "Page 1736/2045\n",
      "Page 1737/2045\n",
      "Page 1738/2045\n",
      "Page 1739/2045\n",
      "Page 1740/2045\n",
      "Page 1741/2045\n",
      "Page 1742/2045\n",
      "Page 1743/2045\n",
      "Page 1744/2045\n",
      "Page 1745/2045\n",
      "Page 1746/2045\n",
      "Page 1747/2045\n",
      "Page 1748/2045\n",
      "Page 1749/2045\n",
      "Page 1750/2045\n",
      "Page 1751/2045\n",
      "Page 1752/2045\n",
      "Page 1753/2045\n",
      "Page 1754/2045\n",
      "Page 1755/2045\n",
      "Page 1756/2045\n",
      "Page 1757/2045\n",
      "Page 1758/2045\n",
      "Page 1759/2045\n",
      "Page 1760/2045\n",
      "Page 1761/2045\n",
      "Page 1762/2045\n",
      "Page 1763/2045\n",
      "Page 1764/2045\n",
      "Page 1765/2045\n",
      "Page 1766/2045\n",
      "Page 1767/2045\n",
      "Page 1768/2045\n",
      "Page 1769/2045\n",
      "Page 1770/2045\n",
      "Page 1771/2045\n",
      "Page 1772/2045\n",
      "Page 1773/2045\n",
      "Page 1774/2045\n",
      "Page 1775/2045\n",
      "Page 1776/2045\n",
      "Page 1777/2045\n",
      "Page 1778/2045\n",
      "Page 1779/2045\n",
      "Page 1780/2045\n",
      "Page 1781/2045\n",
      "Page 1782/2045\n",
      "Page 1783/2045\n",
      "Page 1784/2045\n",
      "Page 1785/2045\n",
      "Page 1786/2045\n",
      "Page 1787/2045\n",
      "Page 1788/2045\n",
      "Page 1789/2045\n",
      "Page 1790/2045\n",
      "Page 1791/2045\n",
      "Page 1792/2045\n",
      "Page 1793/2045\n",
      "Page 1794/2045\n",
      "Page 1795/2045\n",
      "Page 1796/2045\n",
      "Page 1797/2045\n",
      "Page 1798/2045\n",
      "Page 1799/2045\n",
      "Page 1800/2045\n",
      "Page 1801/2045\n",
      "Page 1802/2045\n",
      "Page 1803/2045\n",
      "Page 1804/2045\n",
      "Page 1805/2045\n",
      "Page 1806/2045\n",
      "Page 1807/2045\n",
      "Page 1808/2045\n",
      "Page 1809/2045\n",
      "Page 1810/2045\n",
      "Page 1811/2045\n",
      "Page 1812/2045\n",
      "Page 1813/2045\n",
      "Page 1814/2045\n",
      "Page 1815/2045\n",
      "Page 1816/2045\n",
      "Page 1817/2045\n",
      "Page 1818/2045\n",
      "Page 1819/2045\n",
      "Page 1820/2045\n",
      "Page 1821/2045\n",
      "Page 1822/2045\n",
      "Page 1823/2045\n",
      "Page 1824/2045\n",
      "Page 1825/2045\n",
      "Page 1826/2045\n",
      "Page 1827/2045\n",
      "Page 1828/2045\n",
      "Page 1829/2045\n",
      "Page 1830/2045\n",
      "Page 1831/2045\n",
      "Page 1832/2045\n",
      "Page 1833/2045\n",
      "Page 1834/2045\n",
      "Page 1835/2045\n",
      "Page 1836/2045\n",
      "Page 1837/2045\n",
      "Page 1838/2045\n",
      "Page 1839/2045\n",
      "Page 1840/2045\n",
      "Page 1841/2045\n",
      "Page 1842/2045\n",
      "Page 1843/2045\n",
      "Page 1844/2045\n",
      "Page 1845/2045\n",
      "Page 1846/2045\n",
      "Page 1847/2045\n",
      "Page 1848/2045\n",
      "Page 1849/2045\n",
      "Page 1850/2045\n",
      "Page 1851/2045\n",
      "Page 1852/2045\n",
      "Page 1853/2045\n",
      "Page 1854/2045\n",
      "Page 1855/2045\n",
      "Page 1856/2045\n",
      "Page 1857/2045\n",
      "Page 1858/2045\n",
      "Page 1859/2045\n",
      "Page 1860/2045\n",
      "Page 1861/2045\n",
      "Page 1862/2045\n",
      "Page 1863/2045\n",
      "Page 1864/2045\n",
      "Page 1865/2045\n",
      "Page 1866/2045\n",
      "Page 1867/2045\n",
      "Page 1868/2045\n",
      "Page 1869/2045\n",
      "Page 1870/2045\n",
      "Page 1871/2045\n",
      "Page 1872/2045\n",
      "Page 1873/2045\n",
      "Page 1874/2045\n",
      "Page 1875/2045\n",
      "Page 1876/2045\n",
      "Page 1877/2045\n",
      "Page 1878/2045\n",
      "Page 1879/2045\n",
      "Page 1880/2045\n",
      "Page 1881/2045\n",
      "Page 1882/2045\n",
      "Page 1883/2045\n",
      "Page 1884/2045\n",
      "Page 1885/2045\n",
      "Page 1886/2045\n",
      "Page 1887/2045\n",
      "Page 1888/2045\n",
      "Page 1889/2045\n",
      "Page 1890/2045\n",
      "Page 1891/2045\n",
      "Page 1892/2045\n",
      "Page 1893/2045\n",
      "Page 1894/2045\n",
      "Page 1895/2045\n",
      "NOT PAGENUM ['APELDOORN,AMERSFOORT,ARNHEM.']\n",
      "--APELDOORN,AMERSFOORT,ARNHEM.--\n",
      "Assuming company name\n",
      "Page 1896/2045\n",
      "Page 1897/2045\n",
      "Page 1898/2045\n",
      "Page 1899/2045\n",
      "NOT PAGENUM ['DOMMEL, AA EN MAAS']\n",
      "--DOMMEL, AA EN MAAS--\n",
      "Assuming company name\n",
      "NOT PAGENUM ['STAD EN LAND']\n",
      "--STAD EN LAND--\n",
      "Assuming company name\n",
      "Page 1900/2045\n",
      "Page 1901/2045\n",
      "NOT PAGENUM ['ERFELIJKHEIDSVRAAGSTUKKEN']\n",
      "--ERFELIJKHEIDSVRAAGSTUKKEN--\n",
      "Assuming company name\n",
      "NOT PAGENUM ['HOLLAND']\n",
      "--HOLLAND--\n",
      "Assuming company name\n",
      "NOT PAGENUM ['\"NETHERLANDS AE']\n",
      "--\"NETHERLANDS AE--\n",
      "Assuming company name\n",
      "Page 1902/2045\n",
      "Page 1903/2045\n",
      "Page 1904/2045\n",
      "Page 1905/2045\n",
      "Page 1906/2045\n",
      "Page 1907/2045\n",
      "Page 1908/2045\n",
      "Page 1909/2045\n",
      "Page 1910/2045\n",
      "Page 1911/2045\n",
      "Page 1912/2045\n",
      "Page 1913/2045\n",
      "Page 1914/2045\n",
      "Page 1915/2045\n",
      "Page 1916/2045\n",
      "Page 1917/2045\n",
      "Page 1918/2045\n",
      "Page 1919/2045\n",
      "Page 1920/2045\n",
      "Page 1921/2045\n",
      "Page 1922/2045\n",
      "Page 1923/2045\n",
      "Page 1924/2045\n",
      "Page 1925/2045\n",
      "Page 1926/2045\n",
      "Page 1927/2045\n",
      "Page 1928/2045\n",
      "Page 1929/2045\n",
      "Page 1930/2045\n",
      "Page 1931/2045\n",
      "Page 1932/2045\n",
      "Page 1933/2045\n",
      "Page 1934/2045\n",
      "Page 1935/2045\n",
      "NOT PAGENUM ['SMALLINGERLND']\n",
      "--                                                                              SMALLINGERLND--\n",
      "Assuming location\n",
      "Page 1936/2045\n",
      "Page 1937/2045\n",
      "Page 1938/2045\n",
      "Page 1939/2045\n",
      "Page 1940/2045\n",
      "Page 1941/2045\n",
      "Page 1942/2045\n",
      "Page 1943/2045\n",
      "Page 1944/2045\n",
      "Page 1945/2045\n",
      "Page 1946/2045\n",
      "Page 1947/2045\n",
      "Page 1948/2045\n",
      "Page 1949/2045\n",
      "Page 1950/2045\n",
      "Page 1951/2045\n",
      "Page 1952/2045\n",
      "Page 1953/2045\n",
      "Page 1954/2045\n",
      "Page 1955/2045\n",
      "Page 1956/2045\n",
      "Page 1957/2045\n",
      "Page 1958/2045\n",
      "Page 1959/2045\n",
      "Page 1960/2045\n",
      "Page 1961/2045\n",
      "Page 1962/2045\n",
      "Page 1963/2045\n",
      "Page 1964/2045\n",
      "Page 1965/2045\n",
      "Page 1966/2045\n",
      "Page 1967/2045\n",
      "Page 1968/2045\n",
      "Page 1969/2045\n",
      "Page 1970/2045\n",
      "Page 1971/2045\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Page 1972/2045\n",
      "Page 1973/2045\n",
      "Page 1974/2045\n",
      "Page 1975/2045\n",
      "Page 1976/2045\n",
      "Page 1977/2045\n",
      "Page 1978/2045\n",
      "Page 1979/2045\n",
      "Page 1980/2045\n",
      "Page 1981/2045\n",
      "Page 1982/2045\n",
      "Page 1983/2045\n",
      "Page 1984/2045\n",
      "Page 1985/2045\n",
      "Page 1986/2045\n",
      "Page 1987/2045\n",
      "Page 1988/2045\n",
      "Page 1989/2045\n",
      "Page 1990/2045\n",
      "Page 1991/2045\n",
      "Page 1992/2045\n",
      "Page 1993/2045\n",
      "Page 1994/2045\n",
      "Page 1995/2045\n",
      "Page 1996/2045\n",
      "Page 1997/2045\n",
      "Page 1998/2045\n",
      "Page 1999/2045\n",
      "Page 2000/2045\n",
      "Page 2001/2045\n",
      "Page 2002/2045\n",
      "Page 2003/2045\n",
      "Page 2004/2045\n",
      "Page 2005/2045\n",
      "Page 2006/2045\n",
      "Page 2007/2045\n",
      "Page 2008/2045\n",
      "Page 2009/2045\n",
      "Page 2010/2045\n",
      "Page 2011/2045\n",
      "Page 2012/2045\n",
      "Page 2013/2045\n",
      "Page 2014/2045\n",
      "Page 2015/2045\n",
      "Page 2016/2045\n",
      "Page 2017/2045\n",
      "Page 2018/2045\n",
      "Page 2019/2045\n",
      "Page 2020/2045\n",
      "Page 2021/2045\n",
      "Page 2022/2045\n",
      "Page 2023/2045\n",
      "Page 2024/2045\n",
      "Page 2025/2045\n",
      "Page 2026/2045\n",
      "Page 2027/2045\n",
      "Page 2028/2045\n",
      "Page 2029/2045\n",
      "Page 2030/2045\n",
      "Page 2031/2045\n",
      "Page 2032/2045\n",
      "NOT PAGENUM ['PD']\n",
      "--                                   PD--\n",
      "Assuming location\n",
      "Page 2033/2045\n",
      "Page 2034/2045\n",
      "NOT PAGENUM ['ALBRANDSWAARD']\n",
      "--                                           ALBRANDSWAARD--\n",
      "Assuming location\n",
      "NOT PAGENUM ['ALBRANDSWAARD']\n",
      "--                                           ALBRANDSWAARD--\n",
      "Assuming location\n",
      "Page 2035/2045\n",
      "Page 2036/2045\n",
      "Page 2037/2045\n",
      "Page 2038/2045\n",
      "Page 2039/2045\n",
      "Page 2040/2045\n",
      "Page 2041/2045\n",
      "Page 2042/2045\n",
      "Page 2043/2045\n",
      "Page 2044/2045\n",
      "Page 2045/2045\n",
      "Writing to data-misc/data-economy/now-registry-20200710.csv\n"
     ]
    }
   ],
   "source": [
    "import dateutil.parser\n",
    "from datetime import datetime\n",
    "import pytz\n",
    "import pandas as pd\n",
    "\n",
    "\n",
    "now_registries = outputfolder.glob('now-register-*.pdf')\n",
    "by_date = {}\n",
    "\n",
    "for registry in now_registries:\n",
    "    meta = pdfinfo(registry)\n",
    "    \n",
    "    moddate = meta['ModDate'].strip(\"'\").strip('\"').strip()  # cleanup the string a bit\n",
    "    \n",
    "    moddate = dateutil.parser.parse(moddate)\n",
    "    #moddate = int(f'{moddate.year}{moddate.month:02}{moddate.day:02}')\n",
    "    \n",
    "    by_date[moddate] = registry\n",
    "    \n",
    "\n",
    "output = []\n",
    "    \n",
    "\n",
    "    \n",
    "# walk trough reports old to new\n",
    "for key in sorted(by_date.keys()):\n",
    "    registry_file = by_date[key]\n",
    "    table_start = pdf_find_page_for_text(registry_file, 'VOORSCHOTBEDRAG')\n",
    "    \n",
    "    #print(table_start)\n",
    "    \n",
    "    with open(registry_file, \"rb\") as fh:\n",
    "        pdf = pdftotext.PDF(fh)\n",
    "    \n",
    "    \n",
    "    pagenum = table_start\n",
    "    totalpages = len(pdf) - 2  # skip last few pages, they are colofon so no table data\n",
    "    for page in range(pagenum, totalpages):\n",
    "        print(f'Page {page}/{totalpages - 1}')\n",
    "        columns, data = extract_page(pdf[page])\n",
    "        output = output + data  # concat two lists of lists\n",
    "        \n",
    "    df = pd.DataFrame(output, columns=columns)\n",
    "    outputname = outputfolder / f'now-registry-{key.year}{key.month:02}{key.day:02}.csv'\n",
    "    print(f'Writing to {outputname}')\n",
    "    df.to_csv(outputname)\n"
   ]
  }
 ],
 "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.8.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}