09.Inserting-Officers-People.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Loading the Officers\n",
    "\n",
    "We have a data file of officers who have a level of control over the company. We need to map these into the system to connect them to the PSC people we are aware of."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/ec2-user/anaconda3/lib/python3.6/site-packages/odo/backends/pandas.py:94: FutureWarning: pandas.tslib is deprecated and will be removed in a future version.\n",
      "You can access NaTType as type(pandas.NaT)\n",
      "  @convert.register((pd.Timestamp, pd.Timedelta), (pd.tslib.NaTType, type(None)))\n"
     ]
    }
   ],
   "source": [
    "import pandas as pd\n",
    "import json\n",
    "from pandas.io.json import json_normalize\n",
    "\n",
    "import blaze as bz"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "First load some sample data and do some tidying up so we don't waste RAM."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "master_path = './data/'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "sample_df = pd.read_csv(master_path+'officers.csv', nrows=10000)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['id', 'company_number', 'jurisdiction_code', 'name', 'title',\n",
       "       'first_name', 'last_name', 'position', 'start_date', 'person_number',\n",
       "       'person_uid', 'end_date', 'current_status', 'occupation', 'nationality',\n",
       "       'country_of_residence', 'partial_date_of_birth', 'type',\n",
       "       'address.in_full', 'address.street_address', 'address.locality',\n",
       "       'address.region', 'address.postal_code', 'address.country',\n",
       "       'retrieved_at', 'source_url'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sample_df.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "id                                                                201499282\n",
       "company_number                                                     05957738\n",
       "jurisdiction_code                                                        gb\n",
       "name                                                      DAVID IAN BROMLEY\n",
       "title                                                                    MR\n",
       "first_name                                                        DAVID IAN\n",
       "last_name                                                           BROMLEY\n",
       "position                                                           director\n",
       "start_date                                                       2010-10-01\n",
       "person_number                                                  115947850001\n",
       "person_uid                                                         11594785\n",
       "end_date                                                                NaN\n",
       "current_status                                                          NaN\n",
       "occupation                                                         DIRECTOR\n",
       "nationality                                                         BRITISH\n",
       "country_of_residence                                         UNITED KINGDOM\n",
       "partial_date_of_birth                                               1970-05\n",
       "type                                                                 Person\n",
       "address.in_full           40 LEA MANOR DRIVE\\nPENN, WOLVERHAMPTON, WEST ...\n",
       "address.street_address                             40 LEA MANOR DRIVE\\nPENN\n",
       "address.locality                                              WOLVERHAMPTON\n",
       "address.region                                                WEST MIDLANDS\n",
       "address.postal_code                                                 WV4 5PJ\n",
       "address.country                                              UNITED KINGDOM\n",
       "retrieved_at                                        2015-12-04 00:00:00 UTC\n",
       "source_url                https://beta.companieshouse.gov.uk/company/059...\n",
       "Name: 1, dtype: object"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sample_df[sample_df.end_date.isnull()].iloc[0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id</th>\n",
       "      <th>company_number</th>\n",
       "      <th>jurisdiction_code</th>\n",
       "      <th>name</th>\n",
       "      <th>title</th>\n",
       "      <th>first_name</th>\n",
       "      <th>last_name</th>\n",
       "      <th>position</th>\n",
       "      <th>start_date</th>\n",
       "      <th>person_number</th>\n",
       "      <th>...</th>\n",
       "      <th>partial_date_of_birth</th>\n",
       "      <th>type</th>\n",
       "      <th>address.in_full</th>\n",
       "      <th>address.street_address</th>\n",
       "      <th>address.locality</th>\n",
       "      <th>address.region</th>\n",
       "      <th>address.postal_code</th>\n",
       "      <th>address.country</th>\n",
       "      <th>retrieved_at</th>\n",
       "      <th>source_url</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>201499282</td>\n",
       "      <td>05957738</td>\n",
       "      <td>gb</td>\n",
       "      <td>DAVID IAN BROMLEY</td>\n",
       "      <td>MR</td>\n",
       "      <td>DAVID IAN</td>\n",
       "      <td>BROMLEY</td>\n",
       "      <td>director</td>\n",
       "      <td>2010-10-01</td>\n",
       "      <td>115947850001</td>\n",
       "      <td>...</td>\n",
       "      <td>1970-05</td>\n",
       "      <td>Person</td>\n",
       "      <td>40 LEA MANOR DRIVE\\nPENN, WOLVERHAMPTON, WEST ...</td>\n",
       "      <td>40 LEA MANOR DRIVE\\nPENN</td>\n",
       "      <td>WOLVERHAMPTON</td>\n",
       "      <td>WEST MIDLANDS</td>\n",
       "      <td>WV4 5PJ</td>\n",
       "      <td>UNITED KINGDOM</td>\n",
       "      <td>2015-12-04 00:00:00 UTC</td>\n",
       "      <td>https://beta.companieshouse.gov.uk/company/059...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>201499298</td>\n",
       "      <td>05957738</td>\n",
       "      <td>gb</td>\n",
       "      <td>DAVID IAN BROMLEY</td>\n",
       "      <td>MR</td>\n",
       "      <td>DAVID IAN</td>\n",
       "      <td>BROMLEY</td>\n",
       "      <td>director</td>\n",
       "      <td>2006-10-05</td>\n",
       "      <td>115947850001</td>\n",
       "      <td>...</td>\n",
       "      <td>1970-05</td>\n",
       "      <td>Person</td>\n",
       "      <td>40 LEA MANOR DRIVE, WOLVERHAMPTON, WV4 5PJ</td>\n",
       "      <td>40 LEA MANOR DRIVE</td>\n",
       "      <td>WOLVERHAMPTON</td>\n",
       "      <td>NaN</td>\n",
       "      <td>WV4 5PJ</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015-12-04 00:00:00 UTC</td>\n",
       "      <td>https://beta.companieshouse.gov.uk/company/059...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>201499319</td>\n",
       "      <td>05957738</td>\n",
       "      <td>gb</td>\n",
       "      <td>SALLY-ANN MICHELLE BROMLEY</td>\n",
       "      <td>MRS</td>\n",
       "      <td>SALLY-ANN MICHELLE</td>\n",
       "      <td>BROMLEY</td>\n",
       "      <td>director</td>\n",
       "      <td>2012-12-21</td>\n",
       "      <td>121484190003</td>\n",
       "      <td>...</td>\n",
       "      <td>1966-08</td>\n",
       "      <td>Person</td>\n",
       "      <td>PENYCASTELL FARM BRYN, PORT TALBOT, WEST GLAMO...</td>\n",
       "      <td>PENYCASTELL FARM BRYN</td>\n",
       "      <td>PORT TALBOT</td>\n",
       "      <td>WEST GLAMORGAN</td>\n",
       "      <td>SA13 2PY</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015-12-04 00:00:00 UTC</td>\n",
       "      <td>https://beta.companieshouse.gov.uk/company/059...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>201499336</td>\n",
       "      <td>05957738</td>\n",
       "      <td>gb</td>\n",
       "      <td>ELIZABETH DAVIES</td>\n",
       "      <td>MS</td>\n",
       "      <td>ELIZABETH</td>\n",
       "      <td>DAVIES</td>\n",
       "      <td>director</td>\n",
       "      <td>2006-10-05</td>\n",
       "      <td>115947860002</td>\n",
       "      <td>...</td>\n",
       "      <td>1962-01</td>\n",
       "      <td>Person</td>\n",
       "      <td>12 PONTYMASON RISE\\nROGERSTONE, NEWPORT, GWENT...</td>\n",
       "      <td>12 PONTYMASON RISE\\nROGERSTONE</td>\n",
       "      <td>NEWPORT</td>\n",
       "      <td>GWENT</td>\n",
       "      <td>NP10 9GJ</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015-12-04 00:00:00 UTC</td>\n",
       "      <td>https://beta.companieshouse.gov.uk/company/059...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>190421889</td>\n",
       "      <td>04066366</td>\n",
       "      <td>gb</td>\n",
       "      <td>RAZAHUSSEIN LALJI MAMDANI</td>\n",
       "      <td>MR</td>\n",
       "      <td>RAZAHUSSEIN LALJI</td>\n",
       "      <td>MAMDANI</td>\n",
       "      <td>director</td>\n",
       "      <td>2011-08-15</td>\n",
       "      <td>71984350001</td>\n",
       "      <td>...</td>\n",
       "      <td>1947-07</td>\n",
       "      <td>Person</td>\n",
       "      <td>PREMIER SUITE, 4 CHURCHILL COURT\\n58 STATION R...</td>\n",
       "      <td>PREMIER SUITE, 4 CHURCHILL COURT\\n58 STATION ROAD</td>\n",
       "      <td>NORTH HARROW</td>\n",
       "      <td>MIDDLESEX</td>\n",
       "      <td>HA2 7ST</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015-12-04 00:00:00 UTC</td>\n",
       "      <td>https://beta.companieshouse.gov.uk/company/040...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 26 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "          id company_number jurisdiction_code                        name  \\\n",
       "1  201499282       05957738                gb           DAVID IAN BROMLEY   \n",
       "2  201499298       05957738                gb           DAVID IAN BROMLEY   \n",
       "3  201499319       05957738                gb  SALLY-ANN MICHELLE BROMLEY   \n",
       "4  201499336       05957738                gb            ELIZABETH DAVIES   \n",
       "9  190421889       04066366                gb   RAZAHUSSEIN LALJI MAMDANI   \n",
       "\n",
       "  title          first_name last_name  position  start_date  person_number  \\\n",
       "1    MR           DAVID IAN   BROMLEY  director  2010-10-01   115947850001   \n",
       "2    MR           DAVID IAN   BROMLEY  director  2006-10-05   115947850001   \n",
       "3   MRS  SALLY-ANN MICHELLE   BROMLEY  director  2012-12-21   121484190003   \n",
       "4    MS           ELIZABETH    DAVIES  director  2006-10-05   115947860002   \n",
       "9    MR   RAZAHUSSEIN LALJI   MAMDANI  director  2011-08-15    71984350001   \n",
       "\n",
       "                         ...                          partial_date_of_birth  \\\n",
       "1                        ...                                        1970-05   \n",
       "2                        ...                                        1970-05   \n",
       "3                        ...                                        1966-08   \n",
       "4                        ...                                        1962-01   \n",
       "9                        ...                                        1947-07   \n",
       "\n",
       "     type                                    address.in_full  \\\n",
       "1  Person  40 LEA MANOR DRIVE\\nPENN, WOLVERHAMPTON, WEST ...   \n",
       "2  Person         40 LEA MANOR DRIVE, WOLVERHAMPTON, WV4 5PJ   \n",
       "3  Person  PENYCASTELL FARM BRYN, PORT TALBOT, WEST GLAMO...   \n",
       "4  Person  12 PONTYMASON RISE\\nROGERSTONE, NEWPORT, GWENT...   \n",
       "9  Person  PREMIER SUITE, 4 CHURCHILL COURT\\n58 STATION R...   \n",
       "\n",
       "                              address.street_address address.locality  \\\n",
       "1                           40 LEA MANOR DRIVE\\nPENN    WOLVERHAMPTON   \n",
       "2                                 40 LEA MANOR DRIVE    WOLVERHAMPTON   \n",
       "3                              PENYCASTELL FARM BRYN      PORT TALBOT   \n",
       "4                     12 PONTYMASON RISE\\nROGERSTONE          NEWPORT   \n",
       "9  PREMIER SUITE, 4 CHURCHILL COURT\\n58 STATION ROAD     NORTH HARROW   \n",
       "\n",
       "   address.region address.postal_code address.country  \\\n",
       "1   WEST MIDLANDS             WV4 5PJ  UNITED KINGDOM   \n",
       "2             NaN             WV4 5PJ             NaN   \n",
       "3  WEST GLAMORGAN            SA13 2PY             NaN   \n",
       "4           GWENT            NP10 9GJ             NaN   \n",
       "9       MIDDLESEX             HA2 7ST             NaN   \n",
       "\n",
       "              retrieved_at                                         source_url  \n",
       "1  2015-12-04 00:00:00 UTC  https://beta.companieshouse.gov.uk/company/059...  \n",
       "2  2015-12-04 00:00:00 UTC  https://beta.companieshouse.gov.uk/company/059...  \n",
       "3  2015-12-04 00:00:00 UTC  https://beta.companieshouse.gov.uk/company/059...  \n",
       "4  2015-12-04 00:00:00 UTC  https://beta.companieshouse.gov.uk/company/059...  \n",
       "9  2015-12-04 00:00:00 UTC  https://beta.companieshouse.gov.uk/company/040...  \n",
       "\n",
       "[5 rows x 26 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sample_df[sample_df.type == 'Person'].head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id</th>\n",
       "      <th>company_number</th>\n",
       "      <th>jurisdiction_code</th>\n",
       "      <th>name</th>\n",
       "      <th>title</th>\n",
       "      <th>first_name</th>\n",
       "      <th>last_name</th>\n",
       "      <th>position</th>\n",
       "      <th>start_date</th>\n",
       "      <th>person_number</th>\n",
       "      <th>...</th>\n",
       "      <th>partial_date_of_birth</th>\n",
       "      <th>type</th>\n",
       "      <th>address.in_full</th>\n",
       "      <th>address.street_address</th>\n",
       "      <th>address.locality</th>\n",
       "      <th>address.region</th>\n",
       "      <th>address.postal_code</th>\n",
       "      <th>address.country</th>\n",
       "      <th>retrieved_at</th>\n",
       "      <th>source_url</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>201499267</td>\n",
       "      <td>05957738</td>\n",
       "      <td>gb</td>\n",
       "      <td>PHOENIX AUDIT LIMITED</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>PHOENIX AUDIT LIMITED</td>\n",
       "      <td>secretary</td>\n",
       "      <td>2006-10-05</td>\n",
       "      <td>99992830001</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Company</td>\n",
       "      <td>35 OXFORD STREET\\nPONTYCYMER, BRIDGEND, CF32 8DD</td>\n",
       "      <td>35 OXFORD STREET\\nPONTYCYMER</td>\n",
       "      <td>BRIDGEND</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CF32 8DD</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015-12-04 00:00:00 UTC</td>\n",
       "      <td>https://beta.companieshouse.gov.uk/company/059...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>190421841</td>\n",
       "      <td>04066366</td>\n",
       "      <td>gb</td>\n",
       "      <td>FATBRAIN.COM LIMITED</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>FATBRAIN.COM LIMITED</td>\n",
       "      <td>secretary</td>\n",
       "      <td>2000-09-06</td>\n",
       "      <td>83435930001</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Company</td>\n",
       "      <td>PREMIER SUITE 4 CHURCHILL COURT\\n58 STATION RO...</td>\n",
       "      <td>PREMIER SUITE 4 CHURCHILL COURT\\n58 STATION ROAD</td>\n",
       "      <td>NORTH HARROW</td>\n",
       "      <td>MIDDLESEX</td>\n",
       "      <td>HA2 7ST</td>\n",
       "      <td>UNITED KINGDOM</td>\n",
       "      <td>2015-12-04 00:00:00 UTC</td>\n",
       "      <td>https://beta.companieshouse.gov.uk/company/040...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>190421851</td>\n",
       "      <td>04066366</td>\n",
       "      <td>gb</td>\n",
       "      <td>FIRST SECRETARIES LIMITED</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>FIRST SECRETARIES LIMITED</td>\n",
       "      <td>secretary</td>\n",
       "      <td>2000-09-06</td>\n",
       "      <td>900000780001</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Company</td>\n",
       "      <td>72 NEW BOND STREET, LONDON, W1S 1RR</td>\n",
       "      <td>72 NEW BOND STREET</td>\n",
       "      <td>LONDON</td>\n",
       "      <td>NaN</td>\n",
       "      <td>W1S 1RR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015-12-04 00:00:00 UTC</td>\n",
       "      <td>https://beta.companieshouse.gov.uk/company/040...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>190421865</td>\n",
       "      <td>04066366</td>\n",
       "      <td>gb</td>\n",
       "      <td>A COMPANY LIMITED</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>+A COMPANY LIMITED</td>\n",
       "      <td>director</td>\n",
       "      <td>2000-09-06</td>\n",
       "      <td>72279610010</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Company</td>\n",
       "      <td>PREMIER SUITE 4 CHURCHILL COURT\\n58 STATION RO...</td>\n",
       "      <td>PREMIER SUITE 4 CHURCHILL COURT\\n58 STATION ROAD</td>\n",
       "      <td>NORTH HARROW</td>\n",
       "      <td>MIDDLESEX</td>\n",
       "      <td>HA2 7ST</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015-12-04 00:00:00 UTC</td>\n",
       "      <td>https://beta.companieshouse.gov.uk/company/040...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>190421877</td>\n",
       "      <td>04066366</td>\n",
       "      <td>gb</td>\n",
       "      <td>FIRST DIRECTORS LIMITED</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>FIRST DIRECTORS LIMITED</td>\n",
       "      <td>director</td>\n",
       "      <td>2000-09-06</td>\n",
       "      <td>900000770001</td>\n",
       "      <td>...</td>\n",
       "      <td>1989-08</td>\n",
       "      <td>Company</td>\n",
       "      <td>72 NEW BOND STREET, LONDON, W1S 1RR</td>\n",
       "      <td>72 NEW BOND STREET</td>\n",
       "      <td>LONDON</td>\n",
       "      <td>NaN</td>\n",
       "      <td>W1S 1RR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015-12-04 00:00:00 UTC</td>\n",
       "      <td>https://beta.companieshouse.gov.uk/company/040...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>207362364</td>\n",
       "      <td>05438136</td>\n",
       "      <td>gb</td>\n",
       "      <td>INCORPORATE SECRETARIAT LIMITED</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>INCORPORATE SECRETARIAT LIMITED</td>\n",
       "      <td>secretary</td>\n",
       "      <td>2005-04-27</td>\n",
       "      <td>900028930001</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Company</td>\n",
       "      <td>4TH FLOOR 3 TENTERDEN STREET\\nHANOVER SQUARE, ...</td>\n",
       "      <td>4TH FLOOR 3 TENTERDEN STREET\\nHANOVER SQUARE</td>\n",
       "      <td>LONDON</td>\n",
       "      <td>NaN</td>\n",
       "      <td>W1S 1TD</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015-12-04 00:00:00 UTC</td>\n",
       "      <td>https://beta.companieshouse.gov.uk/company/054...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>207362418</td>\n",
       "      <td>05438136</td>\n",
       "      <td>gb</td>\n",
       "      <td>INCORPORATE DIRECTORS LIMITED</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>INCORPORATE DIRECTORS LIMITED</td>\n",
       "      <td>director</td>\n",
       "      <td>2005-04-27</td>\n",
       "      <td>900030870001</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Company</td>\n",
       "      <td>4TH FLOOR, 3 TENTERDEN STREET\\nHANOVER SQUARE,...</td>\n",
       "      <td>4TH FLOOR, 3 TENTERDEN STREET\\nHANOVER SQUARE</td>\n",
       "      <td>LONDON</td>\n",
       "      <td>NaN</td>\n",
       "      <td>W1S 1TD</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015-12-04 00:00:00 UTC</td>\n",
       "      <td>https://beta.companieshouse.gov.uk/company/054...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>212181681</td>\n",
       "      <td>SC322354</td>\n",
       "      <td>gb</td>\n",
       "      <td>PATRICIA ELIZABETH BUTLER</td>\n",
       "      <td>NaN</td>\n",
       "      <td>PATRICIA ELIZABETH</td>\n",
       "      <td>BUTLER</td>\n",
       "      <td>secretary</td>\n",
       "      <td>2007-04-26</td>\n",
       "      <td>91946330002</td>\n",
       "      <td>...</td>\n",
       "      <td>1960-08</td>\n",
       "      <td>Person</td>\n",
       "      <td>8 BERNISDALE GARDENS\\nDRUMCHAPEL, GLASGOW, LAN...</td>\n",
       "      <td>8 BERNISDALE GARDENS\\nDRUMCHAPEL</td>\n",
       "      <td>GLASGOW</td>\n",
       "      <td>LANARKSHIRE</td>\n",
       "      <td>G15 8BU</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015-12-04 00:00:00 UTC</td>\n",
       "      <td>https://beta.companieshouse.gov.uk/company/SC3...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>212181694</td>\n",
       "      <td>SC322354</td>\n",
       "      <td>gb</td>\n",
       "      <td>THOMAS BUTLER</td>\n",
       "      <td>NaN</td>\n",
       "      <td>THOMAS</td>\n",
       "      <td>BUTLER</td>\n",
       "      <td>director</td>\n",
       "      <td>2007-04-26</td>\n",
       "      <td>120439080001</td>\n",
       "      <td>...</td>\n",
       "      <td>1961-07</td>\n",
       "      <td>Person</td>\n",
       "      <td>8 BERNISDALE GARDENS, GLASGOW, STRATHCLYDE, G1...</td>\n",
       "      <td>8 BERNISDALE GARDENS</td>\n",
       "      <td>GLASGOW</td>\n",
       "      <td>STRATHCLYDE</td>\n",
       "      <td>G15 8BU</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015-12-04 00:00:00 UTC</td>\n",
       "      <td>https://beta.companieshouse.gov.uk/company/SC3...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>205069123</td>\n",
       "      <td>05149111</td>\n",
       "      <td>gb</td>\n",
       "      <td>CLIFFORD CHANCE SECRETARIES (CCA) LIMITED</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CLIFFORD CHANCE SECRETARIES (CCA) LIMITED</td>\n",
       "      <td>secretary</td>\n",
       "      <td>2004-11-16</td>\n",
       "      <td>83911920002</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Company</td>\n",
       "      <td>10 UPPER BANK STREET, LONDON, E14 5JJ</td>\n",
       "      <td>10 UPPER BANK STREET</td>\n",
       "      <td>LONDON</td>\n",
       "      <td>NaN</td>\n",
       "      <td>E14 5JJ</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015-12-04 00:00:00 UTC</td>\n",
       "      <td>https://beta.companieshouse.gov.uk/company/051...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>205069138</td>\n",
       "      <td>05149111</td>\n",
       "      <td>gb</td>\n",
       "      <td>CLIFFORD CHANCE SECRETARIES LIMITED</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CLIFFORD CHANCE SECRETARIES LIMITED</td>\n",
       "      <td>secretary</td>\n",
       "      <td>2004-06-09</td>\n",
       "      <td>900005620001</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Company</td>\n",
       "      <td>10 UPPER BANK STREET, LONDON, E14 5JJ</td>\n",
       "      <td>10 UPPER BANK STREET</td>\n",
       "      <td>LONDON</td>\n",
       "      <td>NaN</td>\n",
       "      <td>E14 5JJ</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015-12-04 00:00:00 UTC</td>\n",
       "      <td>https://beta.companieshouse.gov.uk/company/051...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>205069156</td>\n",
       "      <td>05149111</td>\n",
       "      <td>gb</td>\n",
       "      <td>JOHN DAVIES</td>\n",
       "      <td>NaN</td>\n",
       "      <td>JOHN</td>\n",
       "      <td>DAVIES</td>\n",
       "      <td>secretary</td>\n",
       "      <td>2007-09-18</td>\n",
       "      <td>115843280001</td>\n",
       "      <td>...</td>\n",
       "      <td>1960-02</td>\n",
       "      <td>Person</td>\n",
       "      <td>ENBROOK PARK SANDGATE, FOLKESTONE, KENT, CT20 ...</td>\n",
       "      <td>ENBROOK PARK SANDGATE</td>\n",
       "      <td>FOLKESTONE</td>\n",
       "      <td>KENT</td>\n",
       "      <td>CT20 3SE</td>\n",
       "      <td>UNITED KINGDOM</td>\n",
       "      <td>2015-12-04 00:00:00 UTC</td>\n",
       "      <td>https://beta.companieshouse.gov.uk/company/051...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>205069167</td>\n",
       "      <td>05149111</td>\n",
       "      <td>gb</td>\n",
       "      <td>VICTORIA HAYNES</td>\n",
       "      <td>NaN</td>\n",
       "      <td>VICTORIA</td>\n",
       "      <td>HAYNES</td>\n",
       "      <td>secretary</td>\n",
       "      <td>2013-10-01</td>\n",
       "      <td>182037440001</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Person</td>\n",
       "      <td>ENBROOK PARK SANDGATE, FOLKESTONE, KENT, CT20 ...</td>\n",
       "      <td>ENBROOK PARK SANDGATE</td>\n",
       "      <td>FOLKESTONE</td>\n",
       "      <td>KENT</td>\n",
       "      <td>CT20 3SE</td>\n",
       "      <td>UNITED KINGDOM</td>\n",
       "      <td>2015-12-04 00:00:00 UTC</td>\n",
       "      <td>https://beta.companieshouse.gov.uk/company/051...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>205069187</td>\n",
       "      <td>05149111</td>\n",
       "      <td>gb</td>\n",
       "      <td>MARK FALCON MILLAR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>MARK FALCON</td>\n",
       "      <td>MILLAR</td>\n",
       "      <td>secretary</td>\n",
       "      <td>2014-09-08</td>\n",
       "      <td>190875400001</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Person</td>\n",
       "      <td>FANUM HOUSE BASING VIEW\\nBASINGSTOKE, HANTS, R...</td>\n",
       "      <td>FANUM HOUSE BASING VIEW\\nBASINGSTOKE</td>\n",
       "      <td>HANTS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>RG21 4EA</td>\n",
       "      <td>UNITED KINGDOM</td>\n",
       "      <td>2015-12-04 00:00:00 UTC</td>\n",
       "      <td>https://beta.companieshouse.gov.uk/company/051...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>205069203</td>\n",
       "      <td>05149111</td>\n",
       "      <td>gb</td>\n",
       "      <td>TAGUMA NGONDONGA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TAGUMA</td>\n",
       "      <td>NGONDONGA</td>\n",
       "      <td>secretary</td>\n",
       "      <td>2012-08-17</td>\n",
       "      <td>171614160001</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Person</td>\n",
       "      <td>FANUM HOUSE BASING VIEW, BASINGSTOKE, HAMPSHIR...</td>\n",
       "      <td>FANUM HOUSE BASING VIEW</td>\n",
       "      <td>BASINGSTOKE</td>\n",
       "      <td>HAMPSHIRE</td>\n",
       "      <td>RG21 4EA</td>\n",
       "      <td>UNITED KINGDOM</td>\n",
       "      <td>2015-12-04 00:00:00 UTC</td>\n",
       "      <td>https://beta.companieshouse.gov.uk/company/051...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>205069220</td>\n",
       "      <td>05149111</td>\n",
       "      <td>gb</td>\n",
       "      <td>ROBERT JAMES SCOTT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ROBERT JAMES</td>\n",
       "      <td>SCOTT</td>\n",
       "      <td>secretary</td>\n",
       "      <td>2014-04-22</td>\n",
       "      <td>187308770001</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Person</td>\n",
       "      <td>FANUM HOUSE BASING VIEW, BASINGSTOKE, HAMPSHIR...</td>\n",
       "      <td>FANUM HOUSE BASING VIEW</td>\n",
       "      <td>BASINGSTOKE</td>\n",
       "      <td>HAMPSHIRE</td>\n",
       "      <td>RG21 4EA</td>\n",
       "      <td>UNITED KINGDOM</td>\n",
       "      <td>2015-12-04 00:00:00 UTC</td>\n",
       "      <td>https://beta.companieshouse.gov.uk/company/051...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>205069370</td>\n",
       "      <td>05149111</td>\n",
       "      <td>gb</td>\n",
       "      <td>DEREK JAMES ELLIOTT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>DEREK JAMES</td>\n",
       "      <td>ELLIOTT</td>\n",
       "      <td>director</td>\n",
       "      <td>2004-10-01</td>\n",
       "      <td>72275690002</td>\n",
       "      <td>...</td>\n",
       "      <td>1969-02</td>\n",
       "      <td>Person</td>\n",
       "      <td>50 WILTON CRESCENT\\nWIMBLEDON, LONDON, SW19 3QS</td>\n",
       "      <td>50 WILTON CRESCENT\\nWIMBLEDON</td>\n",
       "      <td>LONDON</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SW19 3QS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015-12-04 00:00:00 UTC</td>\n",
       "      <td>https://beta.companieshouse.gov.uk/company/051...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>205069386</td>\n",
       "      <td>05149111</td>\n",
       "      <td>gb</td>\n",
       "      <td>JOHN ANDREW GOODSELL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>JOHN ANDREW</td>\n",
       "      <td>GOODSELL</td>\n",
       "      <td>director</td>\n",
       "      <td>2007-09-18</td>\n",
       "      <td>51490510002</td>\n",
       "      <td>...</td>\n",
       "      <td>1959-01</td>\n",
       "      <td>Person</td>\n",
       "      <td>1 ENBROOK PARK, FOLKESTONE, KENT, CT20 3SE</td>\n",
       "      <td>1 ENBROOK PARK</td>\n",
       "      <td>FOLKESTONE</td>\n",
       "      <td>KENT</td>\n",
       "      <td>CT20 3SE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015-12-04 00:00:00 UTC</td>\n",
       "      <td>https://beta.companieshouse.gov.uk/company/051...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>205069404</td>\n",
       "      <td>05149111</td>\n",
       "      <td>gb</td>\n",
       "      <td>NICHOLAS JOHN HEWITT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NICHOLAS JOHN</td>\n",
       "      <td>HEWITT</td>\n",
       "      <td>director</td>\n",
       "      <td>2014-06-26</td>\n",
       "      <td>189107810001</td>\n",
       "      <td>...</td>\n",
       "      <td>1962-03</td>\n",
       "      <td>Person</td>\n",
       "      <td>FANUM HOUSE BASING VIEW, BASINGSTOKE, HAMPSHIR...</td>\n",
       "      <td>FANUM HOUSE BASING VIEW</td>\n",
       "      <td>BASINGSTOKE</td>\n",
       "      <td>HAMPSHIRE</td>\n",
       "      <td>RG21 4EA</td>\n",
       "      <td>UNITED KINGDOM</td>\n",
       "      <td>2015-12-04 00:00:00 UTC</td>\n",
       "      <td>https://beta.companieshouse.gov.uk/company/051...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>205069440</td>\n",
       "      <td>05149111</td>\n",
       "      <td>gb</td>\n",
       "      <td>ROBIN PEVERIL HOOPER</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ROBIN PEVERIL</td>\n",
       "      <td>HOOPER</td>\n",
       "      <td>director</td>\n",
       "      <td>2006-11-24</td>\n",
       "      <td>97001520002</td>\n",
       "      <td>...</td>\n",
       "      <td>1973-07</td>\n",
       "      <td>Person</td>\n",
       "      <td>18 BEAUCLERC ROAD, LONDON, W6 0NS</td>\n",
       "      <td>18 BEAUCLERC ROAD</td>\n",
       "      <td>LONDON</td>\n",
       "      <td>NaN</td>\n",
       "      <td>W6 0NS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015-12-04 00:00:00 UTC</td>\n",
       "      <td>https://beta.companieshouse.gov.uk/company/051...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>205069472</td>\n",
       "      <td>05149111</td>\n",
       "      <td>gb</td>\n",
       "      <td>CHRISTOPHER TREVOR PETER JANSEN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CHRISTOPHER TREVOR PETER</td>\n",
       "      <td>JANSEN</td>\n",
       "      <td>director</td>\n",
       "      <td>2014-01-06</td>\n",
       "      <td>184427650001</td>\n",
       "      <td>...</td>\n",
       "      <td>1970-07</td>\n",
       "      <td>Person</td>\n",
       "      <td>FANUM HOUSE BASING VIEW, BASINGSTOKE, HAMPSHIR...</td>\n",
       "      <td>FANUM HOUSE BASING VIEW</td>\n",
       "      <td>BASINGSTOKE</td>\n",
       "      <td>HAMPSHIRE</td>\n",
       "      <td>RG21 4EA</td>\n",
       "      <td>UNITED KINGDOM</td>\n",
       "      <td>2015-12-04 00:00:00 UTC</td>\n",
       "      <td>https://beta.companieshouse.gov.uk/company/051...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>205069489</td>\n",
       "      <td>05149111</td>\n",
       "      <td>gb</td>\n",
       "      <td>JONATHAN RUSSELL KAYE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>JONATHAN RUSSELL</td>\n",
       "      <td>KAYE</td>\n",
       "      <td>director</td>\n",
       "      <td>2005-11-28</td>\n",
       "      <td>126407230001</td>\n",
       "      <td>...</td>\n",
       "      <td>1973-01</td>\n",
       "      <td>Person</td>\n",
       "      <td>13 KELMSCOTT ROAD, LONDON, SW11 6QX</td>\n",
       "      <td>13 KELMSCOTT ROAD</td>\n",
       "      <td>LONDON</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SW11 6QX</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015-12-04 00:00:00 UTC</td>\n",
       "      <td>https://beta.companieshouse.gov.uk/company/051...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>205069514</td>\n",
       "      <td>05149111</td>\n",
       "      <td>gb</td>\n",
       "      <td>MATTHEW ROBERT LAYTON</td>\n",
       "      <td>NaN</td>\n",
       "      <td>MATTHEW ROBERT</td>\n",
       "      <td>LAYTON</td>\n",
       "      <td>director</td>\n",
       "      <td>2004-06-09</td>\n",
       "      <td>900019870001</td>\n",
       "      <td>...</td>\n",
       "      <td>1961-02</td>\n",
       "      <td>Person</td>\n",
       "      <td>FLAT 49 8 NEW CRANE WHARF\\nNEW CRANE PLACE, LO...</td>\n",
       "      <td>FLAT 49 8 NEW CRANE WHARF\\nNEW CRANE PLACE</td>\n",
       "      <td>LONDON</td>\n",
       "      <td>NaN</td>\n",
       "      <td>E1W 3TX</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015-12-04 00:00:00 UTC</td>\n",
       "      <td>https://beta.companieshouse.gov.uk/company/051...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>205069549</td>\n",
       "      <td>05149111</td>\n",
       "      <td>gb</td>\n",
       "      <td>ROBERT RICHARD LUCAS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ROBERT RICHARD</td>\n",
       "      <td>LUCAS</td>\n",
       "      <td>director</td>\n",
       "      <td>2004-09-29</td>\n",
       "      <td>70329570002</td>\n",
       "      <td>...</td>\n",
       "      <td>1962-08</td>\n",
       "      <td>Person</td>\n",
       "      <td>THE FORGE\\nAYOT ST. LAWRENCE, WELWYN, HERTFORD...</td>\n",
       "      <td>THE FORGE\\nAYOT ST. LAWRENCE</td>\n",
       "      <td>WELWYN</td>\n",
       "      <td>HERTFORDSHIRE</td>\n",
       "      <td>AL6 9BW</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015-12-04 00:00:00 UTC</td>\n",
       "      <td>https://beta.companieshouse.gov.uk/company/051...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>205069688</td>\n",
       "      <td>05149111</td>\n",
       "      <td>gb</td>\n",
       "      <td>DAVID JOHN PUDGE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>DAVID JOHN</td>\n",
       "      <td>PUDGE</td>\n",
       "      <td>director</td>\n",
       "      <td>2004-06-09</td>\n",
       "      <td>900028170001</td>\n",
       "      <td>...</td>\n",
       "      <td>1965-08</td>\n",
       "      <td>Person</td>\n",
       "      <td>20 HERONDALE AVENUE, LONDON, SW18 3JL</td>\n",
       "      <td>20 HERONDALE AVENUE</td>\n",
       "      <td>LONDON</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SW18 3JL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015-12-04 00:00:00 UTC</td>\n",
       "      <td>https://beta.companieshouse.gov.uk/company/051...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>205069751</td>\n",
       "      <td>05149111</td>\n",
       "      <td>gb</td>\n",
       "      <td>SUZANNE DOROTHY WILLIAMS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SUZANNE DOROTHY</td>\n",
       "      <td>WILLIAMS</td>\n",
       "      <td>director</td>\n",
       "      <td>2015-10-01</td>\n",
       "      <td>71960020002</td>\n",
       "      <td>...</td>\n",
       "      <td>1967-09</td>\n",
       "      <td>Person</td>\n",
       "      <td>FANUM HOUSE\\nBASING VIEW, BASINGSTOKE, HAMPSHI...</td>\n",
       "      <td>FANUM HOUSE\\nBASING VIEW</td>\n",
       "      <td>BASINGSTOKE</td>\n",
       "      <td>HAMPSHIRE</td>\n",
       "      <td>RG21 4EA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015-12-04 00:00:00 UTC</td>\n",
       "      <td>https://beta.companieshouse.gov.uk/company/051...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>205069768</td>\n",
       "      <td>05149111</td>\n",
       "      <td>gb</td>\n",
       "      <td>PAUL ANTONY WOOLF</td>\n",
       "      <td>NaN</td>\n",
       "      <td>PAUL ANTONY</td>\n",
       "      <td>WOOLF</td>\n",
       "      <td>director</td>\n",
       "      <td>2005-06-01</td>\n",
       "      <td>78818510001</td>\n",
       "      <td>...</td>\n",
       "      <td>1964-12</td>\n",
       "      <td>Person</td>\n",
       "      <td>18 FAIRFAX ROAD, LONDON, W4 1EW</td>\n",
       "      <td>18 FAIRFAX ROAD</td>\n",
       "      <td>LONDON</td>\n",
       "      <td>NaN</td>\n",
       "      <td>W4 1EW</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015-12-04 00:00:00 UTC</td>\n",
       "      <td>https://beta.companieshouse.gov.uk/company/051...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>235069318</td>\n",
       "      <td>05149111</td>\n",
       "      <td>gb</td>\n",
       "      <td>VICTORIA HAYNES</td>\n",
       "      <td>NaN</td>\n",
       "      <td>VICTORIA</td>\n",
       "      <td>HAYNES</td>\n",
       "      <td>secretary</td>\n",
       "      <td>2013-10-01</td>\n",
       "      <td>182412280001</td>\n",
       "      <td>...</td>\n",
       "      <td>1973-01</td>\n",
       "      <td>Person</td>\n",
       "      <td>ENBROOK PARK SANDGATE, FOLKESTONE, KENT, CT20 ...</td>\n",
       "      <td>ENBROOK PARK SANDGATE</td>\n",
       "      <td>FOLKESTONE</td>\n",
       "      <td>KENT</td>\n",
       "      <td>CT20 3SE</td>\n",
       "      <td>UNITED KINGDOM</td>\n",
       "      <td>2016-05-17 00:00:00 UTC</td>\n",
       "      <td>https://beta.companieshouse.gov.uk/company/051...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>188647611</td>\n",
       "      <td>04264801</td>\n",
       "      <td>gb</td>\n",
       "      <td>OCS CORPORATE SECRETARIES LIMITED</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>OCS CORPORATE SECRETARIES LIMITED</td>\n",
       "      <td>secretary</td>\n",
       "      <td>2001-08-03</td>\n",
       "      <td>900021500001</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Company</td>\n",
       "      <td>MINSHULL HOUSE 67 WELLINGTON ROAD NORTH, STOCK...</td>\n",
       "      <td>MINSHULL HOUSE 67 WELLINGTON ROAD NORTH</td>\n",
       "      <td>STOCKPORT</td>\n",
       "      <td>CHESHIRE</td>\n",
       "      <td>SK4 2LP</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015-12-04 00:00:00 UTC</td>\n",
       "      <td>https://beta.companieshouse.gov.uk/company/042...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>188647622</td>\n",
       "      <td>04264801</td>\n",
       "      <td>gb</td>\n",
       "      <td>ANN DAPHNE RICHARDSON</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ANN DAPHNE</td>\n",
       "      <td>RICHARDSON</td>\n",
       "      <td>secretary</td>\n",
       "      <td>2001-08-09</td>\n",
       "      <td>77561390001</td>\n",
       "      <td>...</td>\n",
       "      <td>1942-03</td>\n",
       "      <td>Person</td>\n",
       "      <td>CHURCHILL HOUSE\\nFURNERS MEAD, HENFIELD, WEST ...</td>\n",
       "      <td>CHURCHILL HOUSE\\nFURNERS MEAD</td>\n",
       "      <td>HENFIELD</td>\n",
       "      <td>WEST SUSSEX</td>\n",
       "      <td>BN5 9JB</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015-12-04 00:00:00 UTC</td>\n",
       "      <td>https://beta.companieshouse.gov.uk/company/042...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9945</th>\n",
       "      <td>201276478</td>\n",
       "      <td>06358334</td>\n",
       "      <td>gb</td>\n",
       "      <td>ANDREW LANE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ANDREW</td>\n",
       "      <td>LANE</td>\n",
       "      <td>director</td>\n",
       "      <td>2007-09-03</td>\n",
       "      <td>124162520002</td>\n",
       "      <td>...</td>\n",
       "      <td>1965-09</td>\n",
       "      <td>Person</td>\n",
       "      <td>256 ACKLAM ROAD, MIDDLESBROUGH, CLEVELAND, TS5...</td>\n",
       "      <td>256 ACKLAM ROAD</td>\n",
       "      <td>MIDDLESBROUGH</td>\n",
       "      <td>CLEVELAND</td>\n",
       "      <td>TS5 8AA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015-12-04 00:00:00 UTC</td>\n",
       "      <td>https://beta.companieshouse.gov.uk/company/063...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9946</th>\n",
       "      <td>193030665</td>\n",
       "      <td>05564976</td>\n",
       "      <td>gb</td>\n",
       "      <td>AMANDA PILLING</td>\n",
       "      <td>NaN</td>\n",
       "      <td>AMANDA</td>\n",
       "      <td>PILLING</td>\n",
       "      <td>secretary</td>\n",
       "      <td>2005-09-15</td>\n",
       "      <td>107634870001</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Person</td>\n",
       "      <td>18 CHURCH LANE\\nWRIGHTINGTON, WIGAN, LANCASHIR...</td>\n",
       "      <td>18 CHURCH LANE\\nWRIGHTINGTON</td>\n",
       "      <td>WIGAN</td>\n",
       "      <td>LANCASHIRE</td>\n",
       "      <td>WN6 9SL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015-12-04 00:00:00 UTC</td>\n",
       "      <td>https://beta.companieshouse.gov.uk/company/055...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9947</th>\n",
       "      <td>193030686</td>\n",
       "      <td>05564976</td>\n",
       "      <td>gb</td>\n",
       "      <td>ADRIAN PILLING</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ADRIAN</td>\n",
       "      <td>PILLING</td>\n",
       "      <td>director</td>\n",
       "      <td>2005-09-15</td>\n",
       "      <td>107634860001</td>\n",
       "      <td>...</td>\n",
       "      <td>1966-09</td>\n",
       "      <td>Person</td>\n",
       "      <td>18 CHURCH LANE\\nWRIGHTINGTON, WIGAN, LANCASHIR...</td>\n",
       "      <td>18 CHURCH LANE\\nWRIGHTINGTON</td>\n",
       "      <td>WIGAN</td>\n",
       "      <td>LANCASHIRE</td>\n",
       "      <td>WN6 9SL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015-12-04 00:00:00 UTC</td>\n",
       "      <td>https://beta.companieshouse.gov.uk/company/055...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9949</th>\n",
       "      <td>207171056</td>\n",
       "      <td>06783554</td>\n",
       "      <td>gb</td>\n",
       "      <td>ANDREA NICOLAOU</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ANDREA</td>\n",
       "      <td>NICOLAOU</td>\n",
       "      <td>secretary</td>\n",
       "      <td>2009-01-12</td>\n",
       "      <td>135684640001</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Person</td>\n",
       "      <td>27 MANDEVILLE ROAD\\nSOUTHGATE, LONDON, N14 7NJ</td>\n",
       "      <td>27 MANDEVILLE ROAD\\nSOUTHGATE</td>\n",
       "      <td>LONDON</td>\n",
       "      <td>NaN</td>\n",
       "      <td>N14 7NJ</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015-12-04 00:00:00 UTC</td>\n",
       "      <td>https://beta.companieshouse.gov.uk/company/067...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9951</th>\n",
       "      <td>207171089</td>\n",
       "      <td>06783554</td>\n",
       "      <td>gb</td>\n",
       "      <td>ANDREAS KOIZI</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ANDREAS</td>\n",
       "      <td>KOIZI</td>\n",
       "      <td>director</td>\n",
       "      <td>2009-01-12</td>\n",
       "      <td>88068780001</td>\n",
       "      <td>...</td>\n",
       "      <td>1964-04</td>\n",
       "      <td>Person</td>\n",
       "      <td>53 VICTORIA ROAD\\nEDMONTON, LONDON, N18 2UG</td>\n",
       "      <td>53 VICTORIA ROAD\\nEDMONTON</td>\n",
       "      <td>LONDON</td>\n",
       "      <td>NaN</td>\n",
       "      <td>N18 2UG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015-12-04 00:00:00 UTC</td>\n",
       "      <td>https://beta.companieshouse.gov.uk/company/067...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9952</th>\n",
       "      <td>207619176</td>\n",
       "      <td>06244841</td>\n",
       "      <td>gb</td>\n",
       "      <td>SECSERVICE24 ADMINISTRATION &amp; MANAGEMENT UK LI...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SECSERVICE24 ADMINISTRATION &amp; MANAGEMENT UK LI...</td>\n",
       "      <td>secretary</td>\n",
       "      <td>2007-05-11</td>\n",
       "      <td>121398070001</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Company</td>\n",
       "      <td>THE MERIDIAN\\n4 COPTHALL HOUSE, STATION SQUARE...</td>\n",
       "      <td>THE MERIDIAN\\n4 COPTHALL HOUSE, STATION SQUARE</td>\n",
       "      <td>COVENTRY</td>\n",
       "      <td>WEST MIDLANDS</td>\n",
       "      <td>CV1 2FL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015-12-04 00:00:00 UTC</td>\n",
       "      <td>https://beta.companieshouse.gov.uk/company/062...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9953</th>\n",
       "      <td>207619194</td>\n",
       "      <td>06244841</td>\n",
       "      <td>gb</td>\n",
       "      <td>GUENTER PLEYER</td>\n",
       "      <td>NaN</td>\n",
       "      <td>GUENTER</td>\n",
       "      <td>PLEYER</td>\n",
       "      <td>director</td>\n",
       "      <td>2007-05-11</td>\n",
       "      <td>121398060001</td>\n",
       "      <td>...</td>\n",
       "      <td>1940-12</td>\n",
       "      <td>Person</td>\n",
       "      <td>SPIELMANNSTR. 18, FRANKFURT AM MAIN, D65934, G...</td>\n",
       "      <td>SPIELMANNSTR. 18</td>\n",
       "      <td>FRANKFURT AM MAIN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>D65934</td>\n",
       "      <td>GERMANY</td>\n",
       "      <td>2015-12-04 00:00:00 UTC</td>\n",
       "      <td>https://beta.companieshouse.gov.uk/company/062...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9954</th>\n",
       "      <td>207619205</td>\n",
       "      <td>06244841</td>\n",
       "      <td>gb</td>\n",
       "      <td>JOERG SCHMIDT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>JOERG</td>\n",
       "      <td>SCHMIDT</td>\n",
       "      <td>director</td>\n",
       "      <td>2007-05-11</td>\n",
       "      <td>121398050001</td>\n",
       "      <td>...</td>\n",
       "      <td>1943-03</td>\n",
       "      <td>Person</td>\n",
       "      <td>ALT GRIESHEIM 19, FRANKFURT AM MAIN, D65933, G...</td>\n",
       "      <td>ALT GRIESHEIM 19</td>\n",
       "      <td>FRANKFURT AM MAIN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>D65933</td>\n",
       "      <td>GERMANY</td>\n",
       "      <td>2015-12-04 00:00:00 UTC</td>\n",
       "      <td>https://beta.companieshouse.gov.uk/company/062...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9955</th>\n",
       "      <td>206963235</td>\n",
       "      <td>04381685</td>\n",
       "      <td>gb</td>\n",
       "      <td>SUZANNE BREWER</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SUZANNE</td>\n",
       "      <td>BREWER</td>\n",
       "      <td>secretary</td>\n",
       "      <td>2002-02-26</td>\n",
       "      <td>900004890001</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Person</td>\n",
       "      <td>SOMERSET HOUSE\\n40-49 PRICE STREET, BIRMINGHAM...</td>\n",
       "      <td>SOMERSET HOUSE\\n40-49 PRICE STREET</td>\n",
       "      <td>BIRMINGHAM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>B2 5DN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015-12-04 00:00:00 UTC</td>\n",
       "      <td>https://beta.companieshouse.gov.uk/company/043...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9956</th>\n",
       "      <td>206963254</td>\n",
       "      <td>04381685</td>\n",
       "      <td>gb</td>\n",
       "      <td>ALLISON JANE DAVIES</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ALLISON JANE</td>\n",
       "      <td>DAVIES</td>\n",
       "      <td>secretary</td>\n",
       "      <td>2002-02-26</td>\n",
       "      <td>80898600002</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Person</td>\n",
       "      <td>CRANNMOOR FARM WROTTESLEY PARK ROAD\\nWROTTESLE...</td>\n",
       "      <td>CRANNMOOR FARM WROTTESLEY PARK ROAD\\nWROTTESLE...</td>\n",
       "      <td>WOLVERHAMPTON</td>\n",
       "      <td>NaN</td>\n",
       "      <td>WV8 2HS</td>\n",
       "      <td>ENGLAND</td>\n",
       "      <td>2015-12-04 00:00:00 UTC</td>\n",
       "      <td>https://beta.companieshouse.gov.uk/company/043...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9960</th>\n",
       "      <td>211204869</td>\n",
       "      <td>05557478</td>\n",
       "      <td>gb</td>\n",
       "      <td>M W DOUGLAS &amp; COMPANY LIMITED</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>M W DOUGLAS &amp; COMPANY LIMITED</td>\n",
       "      <td>secretary</td>\n",
       "      <td>2005-09-08</td>\n",
       "      <td>900007890001</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Company</td>\n",
       "      <td>REGENT HOUSE\\n316 BEULAH HILL, LONDON, SE19 3HP</td>\n",
       "      <td>REGENT HOUSE\\n316 BEULAH HILL</td>\n",
       "      <td>LONDON</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SE19 3HP</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015-12-04 00:00:00 UTC</td>\n",
       "      <td>https://beta.companieshouse.gov.uk/company/055...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9962</th>\n",
       "      <td>211204900</td>\n",
       "      <td>05557478</td>\n",
       "      <td>gb</td>\n",
       "      <td>DOUGLAS NOMINEES LIMITED</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>DOUGLAS NOMINEES LIMITED</td>\n",
       "      <td>director</td>\n",
       "      <td>2005-09-08</td>\n",
       "      <td>900007880001</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Company</td>\n",
       "      <td>REGENT HOUSE\\n316 BEULAH HILL, LONDON, SE19 3HF</td>\n",
       "      <td>REGENT HOUSE\\n316 BEULAH HILL</td>\n",
       "      <td>LONDON</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SE19 3HF</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015-12-04 00:00:00 UTC</td>\n",
       "      <td>https://beta.companieshouse.gov.uk/company/055...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9964</th>\n",
       "      <td>184200209</td>\n",
       "      <td>05522911</td>\n",
       "      <td>gb</td>\n",
       "      <td>MARIA CHRISTINE BRISTOW</td>\n",
       "      <td>NaN</td>\n",
       "      <td>MARIA CHRISTINE</td>\n",
       "      <td>BRISTOW</td>\n",
       "      <td>secretary</td>\n",
       "      <td>2005-07-29</td>\n",
       "      <td>107071450001</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Person</td>\n",
       "      <td>GREENTOPS\\nHEADCORN ROAD SUTTON VALENCE, MAIDS...</td>\n",
       "      <td>GREENTOPS\\nHEADCORN ROAD SUTTON VALENCE</td>\n",
       "      <td>MAIDSTONE</td>\n",
       "      <td>KENT</td>\n",
       "      <td>ME17 3EH</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015-12-04 00:00:00 UTC</td>\n",
       "      <td>https://beta.companieshouse.gov.uk/company/055...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9965</th>\n",
       "      <td>184200226</td>\n",
       "      <td>05522911</td>\n",
       "      <td>gb</td>\n",
       "      <td>TEMPLE SECRETARIES LIMITED</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TEMPLE SECRETARIES LIMITED</td>\n",
       "      <td>secretary</td>\n",
       "      <td>2005-07-29</td>\n",
       "      <td>900001120001</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Company</td>\n",
       "      <td>788-790 FINCHLEY ROAD, LONDON, NW11 7TJ</td>\n",
       "      <td>788-790 FINCHLEY ROAD</td>\n",
       "      <td>LONDON</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NW11 7TJ</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015-12-04 00:00:00 UTC</td>\n",
       "      <td>https://beta.companieshouse.gov.uk/company/055...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9967</th>\n",
       "      <td>184200263</td>\n",
       "      <td>05522911</td>\n",
       "      <td>gb</td>\n",
       "      <td>COMPANY DIRECTORS LIMITED</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>COMPANY DIRECTORS LIMITED</td>\n",
       "      <td>director</td>\n",
       "      <td>2005-07-29</td>\n",
       "      <td>900001110001</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Company</td>\n",
       "      <td>788-790 FINCHLEY ROAD, LONDON, NW11 7TJ</td>\n",
       "      <td>788-790 FINCHLEY ROAD</td>\n",
       "      <td>LONDON</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NW11 7TJ</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015-12-04 00:00:00 UTC</td>\n",
       "      <td>https://beta.companieshouse.gov.uk/company/055...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9968</th>\n",
       "      <td>184200277</td>\n",
       "      <td>05522911</td>\n",
       "      <td>gb</td>\n",
       "      <td>MARK DAVID JACKSON</td>\n",
       "      <td>NaN</td>\n",
       "      <td>MARK DAVID</td>\n",
       "      <td>JACKSON</td>\n",
       "      <td>director</td>\n",
       "      <td>2010-12-13</td>\n",
       "      <td>156645370001</td>\n",
       "      <td>...</td>\n",
       "      <td>1968-12</td>\n",
       "      <td>Person</td>\n",
       "      <td>12 STILEBRIDGE LANE\\nMARDEN, TONBRIDGE, KENT, ...</td>\n",
       "      <td>12 STILEBRIDGE LANE\\nMARDEN</td>\n",
       "      <td>TONBRIDGE</td>\n",
       "      <td>KENT</td>\n",
       "      <td>TN12 9BJ</td>\n",
       "      <td>UK</td>\n",
       "      <td>2015-12-04 00:00:00 UTC</td>\n",
       "      <td>https://beta.companieshouse.gov.uk/company/055...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9969</th>\n",
       "      <td>204690059</td>\n",
       "      <td>06012183</td>\n",
       "      <td>gb</td>\n",
       "      <td>SIKANDAR AYUB</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SIKANDAR</td>\n",
       "      <td>AYUB</td>\n",
       "      <td>secretary</td>\n",
       "      <td>2006-11-28</td>\n",
       "      <td>118371630001</td>\n",
       "      <td>...</td>\n",
       "      <td>1987-11</td>\n",
       "      <td>Person</td>\n",
       "      <td>28 SELBOURNE AVENUE, DEWSBURY, WEST YORKSHIRE,...</td>\n",
       "      <td>28 SELBOURNE AVENUE</td>\n",
       "      <td>DEWSBURY</td>\n",
       "      <td>WEST YORKSHIRE</td>\n",
       "      <td>WF12 9PA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015-12-04 00:00:00 UTC</td>\n",
       "      <td>https://beta.companieshouse.gov.uk/company/060...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9970</th>\n",
       "      <td>204690081</td>\n",
       "      <td>06012183</td>\n",
       "      <td>gb</td>\n",
       "      <td>FORM 10 SECRETARIES FD LTD</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>FORM 10 SECRETARIES FD LTD</td>\n",
       "      <td>secretary</td>\n",
       "      <td>2006-11-28</td>\n",
       "      <td>900015000001</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Company</td>\n",
       "      <td>39A LEICESTER ROAD\\nSALFORD, MANCHESTER, M7 4AS</td>\n",
       "      <td>39A LEICESTER ROAD\\nSALFORD</td>\n",
       "      <td>MANCHESTER</td>\n",
       "      <td>NaN</td>\n",
       "      <td>M7 4AS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015-12-04 00:00:00 UTC</td>\n",
       "      <td>https://beta.companieshouse.gov.uk/company/060...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9971</th>\n",
       "      <td>204690093</td>\n",
       "      <td>06012183</td>\n",
       "      <td>gb</td>\n",
       "      <td>MOHAMMAD AYUB</td>\n",
       "      <td>NaN</td>\n",
       "      <td>MOHAMMAD</td>\n",
       "      <td>AYUB</td>\n",
       "      <td>director</td>\n",
       "      <td>2006-11-28</td>\n",
       "      <td>118371570001</td>\n",
       "      <td>...</td>\n",
       "      <td>1962-08</td>\n",
       "      <td>Person</td>\n",
       "      <td>28 SELBOURNE AVENUE, DEWSBURY, WEST YORKSHIRE,...</td>\n",
       "      <td>28 SELBOURNE AVENUE</td>\n",
       "      <td>DEWSBURY</td>\n",
       "      <td>WEST YORKSHIRE</td>\n",
       "      <td>WF12 9PA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015-12-04 00:00:00 UTC</td>\n",
       "      <td>https://beta.companieshouse.gov.uk/company/060...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9972</th>\n",
       "      <td>204690105</td>\n",
       "      <td>06012183</td>\n",
       "      <td>gb</td>\n",
       "      <td>FORM 10 DIRECTORS FD LTD</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>FORM 10 DIRECTORS FD LTD</td>\n",
       "      <td>director</td>\n",
       "      <td>2006-11-28</td>\n",
       "      <td>900014990001</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Company</td>\n",
       "      <td>39A LEICESTER ROAD\\nSALFORD, MANCHESTER, M7 4AS</td>\n",
       "      <td>39A LEICESTER ROAD\\nSALFORD</td>\n",
       "      <td>MANCHESTER</td>\n",
       "      <td>NaN</td>\n",
       "      <td>M7 4AS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015-12-04 00:00:00 UTC</td>\n",
       "      <td>https://beta.companieshouse.gov.uk/company/060...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9973</th>\n",
       "      <td>212588593</td>\n",
       "      <td>06125942</td>\n",
       "      <td>gb</td>\n",
       "      <td>GO AHEAD SERVICE LIMITED</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>GO AHEAD SERVICE LIMITED</td>\n",
       "      <td>secretary</td>\n",
       "      <td>2007-02-23</td>\n",
       "      <td>900029810001</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Company</td>\n",
       "      <td>69 GREAT HAMPTON STREET, BIRMINGHAM, WEST MIDL...</td>\n",
       "      <td>69 GREAT HAMPTON STREET</td>\n",
       "      <td>BIRMINGHAM</td>\n",
       "      <td>WEST MIDLANDS</td>\n",
       "      <td>B18 6EW</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015-12-04 00:00:00 UTC</td>\n",
       "      <td>https://beta.companieshouse.gov.uk/company/061...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9974</th>\n",
       "      <td>212588609</td>\n",
       "      <td>06125942</td>\n",
       "      <td>gb</td>\n",
       "      <td>ALEXANDER DUBOVOY</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ALEXANDER</td>\n",
       "      <td>DUBOVOY</td>\n",
       "      <td>director</td>\n",
       "      <td>2007-02-23</td>\n",
       "      <td>107358700001</td>\n",
       "      <td>...</td>\n",
       "      <td>1974-01</td>\n",
       "      <td>Person</td>\n",
       "      <td>OSTPREUSENSTR.98, METTMANN, 40822, GERMANY</td>\n",
       "      <td>OSTPREUSENSTR.98</td>\n",
       "      <td>METTMANN</td>\n",
       "      <td>40822</td>\n",
       "      <td>NaN</td>\n",
       "      <td>GERMANY</td>\n",
       "      <td>2015-12-04 00:00:00 UTC</td>\n",
       "      <td>https://beta.companieshouse.gov.uk/company/061...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9975</th>\n",
       "      <td>212588621</td>\n",
       "      <td>06125942</td>\n",
       "      <td>gb</td>\n",
       "      <td>ANDREAS ORTMEYER</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ANDREAS</td>\n",
       "      <td>ORTMEYER</td>\n",
       "      <td>director</td>\n",
       "      <td>2007-02-23</td>\n",
       "      <td>119001820002</td>\n",
       "      <td>...</td>\n",
       "      <td>1967-06</td>\n",
       "      <td>Person</td>\n",
       "      <td>MOORSTR. 260, 48432 RHEINE, GERMANY</td>\n",
       "      <td>MOORSTR. 260</td>\n",
       "      <td>48432 RHEINE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>GERMANY</td>\n",
       "      <td>2015-12-04 00:00:00 UTC</td>\n",
       "      <td>https://beta.companieshouse.gov.uk/company/061...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9983</th>\n",
       "      <td>207819187</td>\n",
       "      <td>05514579</td>\n",
       "      <td>gb</td>\n",
       "      <td>STEINBERG &amp; PARTNERS BUSINESS CONSULTING CORP</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>STEINBERG &amp; PARTNERS BUSINESS CONSULTING CORP</td>\n",
       "      <td>secretary</td>\n",
       "      <td>2005-07-20</td>\n",
       "      <td>900030980001</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Company</td>\n",
       "      <td>SUITE 3\\n95 WILTON ROAD, LONDON, SW1V 1BZ</td>\n",
       "      <td>SUITE 3\\n95 WILTON ROAD</td>\n",
       "      <td>LONDON</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SW1V 1BZ</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015-12-04 00:00:00 UTC</td>\n",
       "      <td>https://beta.companieshouse.gov.uk/company/055...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9984</th>\n",
       "      <td>207819209</td>\n",
       "      <td>05514579</td>\n",
       "      <td>gb</td>\n",
       "      <td>RICHARD ABELE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>RICHARD</td>\n",
       "      <td>ABELE</td>\n",
       "      <td>director</td>\n",
       "      <td>2005-07-20</td>\n",
       "      <td>106509700001</td>\n",
       "      <td>...</td>\n",
       "      <td>1953-03</td>\n",
       "      <td>Person</td>\n",
       "      <td>KRAEMERSTRASSE 17, LUDWIGSBURG, 71642, GERMANY</td>\n",
       "      <td>KRAEMERSTRASSE 17</td>\n",
       "      <td>LUDWIGSBURG</td>\n",
       "      <td>71642</td>\n",
       "      <td>NaN</td>\n",
       "      <td>GERMANY</td>\n",
       "      <td>2015-12-04 00:00:00 UTC</td>\n",
       "      <td>https://beta.companieshouse.gov.uk/company/055...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9986</th>\n",
       "      <td>195700316</td>\n",
       "      <td>06307539</td>\n",
       "      <td>gb</td>\n",
       "      <td>ANNE-MARIE JARNELL-JONES</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ANNE-MARIE</td>\n",
       "      <td>JARNELL-JONES</td>\n",
       "      <td>secretary</td>\n",
       "      <td>2007-07-10</td>\n",
       "      <td>122840780001</td>\n",
       "      <td>...</td>\n",
       "      <td>1971-08</td>\n",
       "      <td>Person</td>\n",
       "      <td>7 BLACKFRIARS, YARM ON TEES, NORTH YORKSHIRE, ...</td>\n",
       "      <td>7 BLACKFRIARS</td>\n",
       "      <td>YARM ON TEES</td>\n",
       "      <td>NORTH YORKSHIRE</td>\n",
       "      <td>TS15 9HQ</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015-12-04 00:00:00 UTC</td>\n",
       "      <td>https://beta.companieshouse.gov.uk/company/063...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9988</th>\n",
       "      <td>195700344</td>\n",
       "      <td>06307539</td>\n",
       "      <td>gb</td>\n",
       "      <td>ANNE-MARIE JARNELL-JONES</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ANNE-MARIE</td>\n",
       "      <td>JARNELL-JONES</td>\n",
       "      <td>director</td>\n",
       "      <td>2007-07-10</td>\n",
       "      <td>122840780001</td>\n",
       "      <td>...</td>\n",
       "      <td>1971-08</td>\n",
       "      <td>Person</td>\n",
       "      <td>7 BLACKFRIARS, YARM ON TEES, NORTH YORKSHIRE, ...</td>\n",
       "      <td>7 BLACKFRIARS</td>\n",
       "      <td>YARM ON TEES</td>\n",
       "      <td>NORTH YORKSHIRE</td>\n",
       "      <td>TS15 9HQ</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015-12-04 00:00:00 UTC</td>\n",
       "      <td>https://beta.companieshouse.gov.uk/company/063...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9993</th>\n",
       "      <td>192495760</td>\n",
       "      <td>03636679</td>\n",
       "      <td>gb</td>\n",
       "      <td>LONDON LAW SECRETARIAL LIMITED</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>LONDON LAW SECRETARIAL LIMITED</td>\n",
       "      <td>secretary</td>\n",
       "      <td>1998-09-23</td>\n",
       "      <td>900001510001</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Company</td>\n",
       "      <td>84 TEMPLE CHAMBERS\\nTEMPLE AVENUE, LONDON, EC4...</td>\n",
       "      <td>84 TEMPLE CHAMBERS\\nTEMPLE AVENUE</td>\n",
       "      <td>LONDON</td>\n",
       "      <td>NaN</td>\n",
       "      <td>EC4Y 0HP</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015-12-04 00:00:00 UTC</td>\n",
       "      <td>https://beta.companieshouse.gov.uk/company/036...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9997</th>\n",
       "      <td>192495830</td>\n",
       "      <td>03636679</td>\n",
       "      <td>gb</td>\n",
       "      <td>LONDON LAW SERVICES LIMITED</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>LONDON LAW SERVICES LIMITED</td>\n",
       "      <td>director</td>\n",
       "      <td>1998-09-23</td>\n",
       "      <td>900001500001</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Company</td>\n",
       "      <td>84 TEMPLE CHAMBERS\\nTEMPLE AVENUE, LONDON, EC4...</td>\n",
       "      <td>84 TEMPLE CHAMBERS\\nTEMPLE AVENUE</td>\n",
       "      <td>LONDON</td>\n",
       "      <td>NaN</td>\n",
       "      <td>EC4Y 0HP</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015-12-04 00:00:00 UTC</td>\n",
       "      <td>https://beta.companieshouse.gov.uk/company/036...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9999</th>\n",
       "      <td>53288738</td>\n",
       "      <td>07375066</td>\n",
       "      <td>gb</td>\n",
       "      <td>ANTHONY LESLIE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ANTHONY</td>\n",
       "      <td>LESLIE</td>\n",
       "      <td>director</td>\n",
       "      <td>2010-09-14</td>\n",
       "      <td>154092280001</td>\n",
       "      <td>...</td>\n",
       "      <td>1964-12</td>\n",
       "      <td>Person</td>\n",
       "      <td>THE HAWTHORNS GREEN MEADOWS\\nHOM GREEN, ROSS-O...</td>\n",
       "      <td>THE HAWTHORNS GREEN MEADOWS\\nHOM GREEN</td>\n",
       "      <td>ROSS-ON-WYE</td>\n",
       "      <td>HEREFORDSHIRE</td>\n",
       "      <td>HR9 7RE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015-12-04 00:00:00 UTC</td>\n",
       "      <td>https://beta.companieshouse.gov.uk/company/073...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5897 rows × 26 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             id company_number jurisdiction_code  \\\n",
       "0     201499267       05957738                gb   \n",
       "5     190421841       04066366                gb   \n",
       "6     190421851       04066366                gb   \n",
       "7     190421865       04066366                gb   \n",
       "8     190421877       04066366                gb   \n",
       "11    207362364       05438136                gb   \n",
       "14    207362418       05438136                gb   \n",
       "16    212181681       SC322354                gb   \n",
       "17    212181694       SC322354                gb   \n",
       "18    205069123       05149111                gb   \n",
       "19    205069138       05149111                gb   \n",
       "20    205069156       05149111                gb   \n",
       "21    205069167       05149111                gb   \n",
       "22    205069187       05149111                gb   \n",
       "23    205069203       05149111                gb   \n",
       "24    205069220       05149111                gb   \n",
       "33    205069370       05149111                gb   \n",
       "34    205069386       05149111                gb   \n",
       "35    205069404       05149111                gb   \n",
       "37    205069440       05149111                gb   \n",
       "39    205069472       05149111                gb   \n",
       "40    205069489       05149111                gb   \n",
       "41    205069514       05149111                gb   \n",
       "43    205069549       05149111                gb   \n",
       "51    205069688       05149111                gb   \n",
       "55    205069751       05149111                gb   \n",
       "56    205069768       05149111                gb   \n",
       "58    235069318       05149111                gb   \n",
       "59    188647611       04264801                gb   \n",
       "60    188647622       04264801                gb   \n",
       "...         ...            ...               ...   \n",
       "9945  201276478       06358334                gb   \n",
       "9946  193030665       05564976                gb   \n",
       "9947  193030686       05564976                gb   \n",
       "9949  207171056       06783554                gb   \n",
       "9951  207171089       06783554                gb   \n",
       "9952  207619176       06244841                gb   \n",
       "9953  207619194       06244841                gb   \n",
       "9954  207619205       06244841                gb   \n",
       "9955  206963235       04381685                gb   \n",
       "9956  206963254       04381685                gb   \n",
       "9960  211204869       05557478                gb   \n",
       "9962  211204900       05557478                gb   \n",
       "9964  184200209       05522911                gb   \n",
       "9965  184200226       05522911                gb   \n",
       "9967  184200263       05522911                gb   \n",
       "9968  184200277       05522911                gb   \n",
       "9969  204690059       06012183                gb   \n",
       "9970  204690081       06012183                gb   \n",
       "9971  204690093       06012183                gb   \n",
       "9972  204690105       06012183                gb   \n",
       "9973  212588593       06125942                gb   \n",
       "9974  212588609       06125942                gb   \n",
       "9975  212588621       06125942                gb   \n",
       "9983  207819187       05514579                gb   \n",
       "9984  207819209       05514579                gb   \n",
       "9986  195700316       06307539                gb   \n",
       "9988  195700344       06307539                gb   \n",
       "9993  192495760       03636679                gb   \n",
       "9997  192495830       03636679                gb   \n",
       "9999   53288738       07375066                gb   \n",
       "\n",
       "                                                   name title  \\\n",
       "0                                 PHOENIX AUDIT LIMITED   NaN   \n",
       "5                                  FATBRAIN.COM LIMITED   NaN   \n",
       "6                             FIRST SECRETARIES LIMITED   NaN   \n",
       "7                                     A COMPANY LIMITED   NaN   \n",
       "8                               FIRST DIRECTORS LIMITED   NaN   \n",
       "11                      INCORPORATE SECRETARIAT LIMITED   NaN   \n",
       "14                        INCORPORATE DIRECTORS LIMITED   NaN   \n",
       "16                            PATRICIA ELIZABETH BUTLER   NaN   \n",
       "17                                        THOMAS BUTLER   NaN   \n",
       "18            CLIFFORD CHANCE SECRETARIES (CCA) LIMITED   NaN   \n",
       "19                  CLIFFORD CHANCE SECRETARIES LIMITED   NaN   \n",
       "20                                          JOHN DAVIES   NaN   \n",
       "21                                      VICTORIA HAYNES   NaN   \n",
       "22                                   MARK FALCON MILLAR   NaN   \n",
       "23                                     TAGUMA NGONDONGA   NaN   \n",
       "24                                   ROBERT JAMES SCOTT   NaN   \n",
       "33                                  DEREK JAMES ELLIOTT   NaN   \n",
       "34                                 JOHN ANDREW GOODSELL   NaN   \n",
       "35                                 NICHOLAS JOHN HEWITT   NaN   \n",
       "37                                 ROBIN PEVERIL HOOPER   NaN   \n",
       "39                      CHRISTOPHER TREVOR PETER JANSEN   NaN   \n",
       "40                                JONATHAN RUSSELL KAYE   NaN   \n",
       "41                                MATTHEW ROBERT LAYTON   NaN   \n",
       "43                                 ROBERT RICHARD LUCAS   NaN   \n",
       "51                                     DAVID JOHN PUDGE   NaN   \n",
       "55                             SUZANNE DOROTHY WILLIAMS   NaN   \n",
       "56                                    PAUL ANTONY WOOLF   NaN   \n",
       "58                                      VICTORIA HAYNES   NaN   \n",
       "59                    OCS CORPORATE SECRETARIES LIMITED   NaN   \n",
       "60                                ANN DAPHNE RICHARDSON   NaN   \n",
       "...                                                 ...   ...   \n",
       "9945                                        ANDREW LANE   NaN   \n",
       "9946                                     AMANDA PILLING   NaN   \n",
       "9947                                     ADRIAN PILLING   NaN   \n",
       "9949                                    ANDREA NICOLAOU   NaN   \n",
       "9951                                      ANDREAS KOIZI   NaN   \n",
       "9952  SECSERVICE24 ADMINISTRATION & MANAGEMENT UK LI...   NaN   \n",
       "9953                                     GUENTER PLEYER   NaN   \n",
       "9954                                      JOERG SCHMIDT   NaN   \n",
       "9955                                     SUZANNE BREWER   NaN   \n",
       "9956                                ALLISON JANE DAVIES   NaN   \n",
       "9960                      M W DOUGLAS & COMPANY LIMITED   NaN   \n",
       "9962                           DOUGLAS NOMINEES LIMITED   NaN   \n",
       "9964                            MARIA CHRISTINE BRISTOW   NaN   \n",
       "9965                         TEMPLE SECRETARIES LIMITED   NaN   \n",
       "9967                          COMPANY DIRECTORS LIMITED   NaN   \n",
       "9968                                 MARK DAVID JACKSON   NaN   \n",
       "9969                                      SIKANDAR AYUB   NaN   \n",
       "9970                         FORM 10 SECRETARIES FD LTD   NaN   \n",
       "9971                                      MOHAMMAD AYUB   NaN   \n",
       "9972                           FORM 10 DIRECTORS FD LTD   NaN   \n",
       "9973                           GO AHEAD SERVICE LIMITED   NaN   \n",
       "9974                                  ALEXANDER DUBOVOY   NaN   \n",
       "9975                                   ANDREAS ORTMEYER   NaN   \n",
       "9983      STEINBERG & PARTNERS BUSINESS CONSULTING CORP   NaN   \n",
       "9984                                      RICHARD ABELE   NaN   \n",
       "9986                           ANNE-MARIE JARNELL-JONES   NaN   \n",
       "9988                           ANNE-MARIE JARNELL-JONES   NaN   \n",
       "9993                     LONDON LAW SECRETARIAL LIMITED   NaN   \n",
       "9997                        LONDON LAW SERVICES LIMITED   NaN   \n",
       "9999                                     ANTHONY LESLIE   NaN   \n",
       "\n",
       "                    first_name  \\\n",
       "0                          NaN   \n",
       "5                          NaN   \n",
       "6                          NaN   \n",
       "7                          NaN   \n",
       "8                          NaN   \n",
       "11                         NaN   \n",
       "14                         NaN   \n",
       "16          PATRICIA ELIZABETH   \n",
       "17                      THOMAS   \n",
       "18                         NaN   \n",
       "19                         NaN   \n",
       "20                        JOHN   \n",
       "21                    VICTORIA   \n",
       "22                 MARK FALCON   \n",
       "23                      TAGUMA   \n",
       "24                ROBERT JAMES   \n",
       "33                 DEREK JAMES   \n",
       "34                 JOHN ANDREW   \n",
       "35               NICHOLAS JOHN   \n",
       "37               ROBIN PEVERIL   \n",
       "39    CHRISTOPHER TREVOR PETER   \n",
       "40            JONATHAN RUSSELL   \n",
       "41              MATTHEW ROBERT   \n",
       "43              ROBERT RICHARD   \n",
       "51                  DAVID JOHN   \n",
       "55             SUZANNE DOROTHY   \n",
       "56                 PAUL ANTONY   \n",
       "58                    VICTORIA   \n",
       "59                         NaN   \n",
       "60                  ANN DAPHNE   \n",
       "...                        ...   \n",
       "9945                    ANDREW   \n",
       "9946                    AMANDA   \n",
       "9947                    ADRIAN   \n",
       "9949                    ANDREA   \n",
       "9951                   ANDREAS   \n",
       "9952                       NaN   \n",
       "9953                   GUENTER   \n",
       "9954                     JOERG   \n",
       "9955                   SUZANNE   \n",
       "9956              ALLISON JANE   \n",
       "9960                       NaN   \n",
       "9962                       NaN   \n",
       "9964           MARIA CHRISTINE   \n",
       "9965                       NaN   \n",
       "9967                       NaN   \n",
       "9968                MARK DAVID   \n",
       "9969                  SIKANDAR   \n",
       "9970                       NaN   \n",
       "9971                  MOHAMMAD   \n",
       "9972                       NaN   \n",
       "9973                       NaN   \n",
       "9974                 ALEXANDER   \n",
       "9975                   ANDREAS   \n",
       "9983                       NaN   \n",
       "9984                   RICHARD   \n",
       "9986                ANNE-MARIE   \n",
       "9988                ANNE-MARIE   \n",
       "9993                       NaN   \n",
       "9997                       NaN   \n",
       "9999                   ANTHONY   \n",
       "\n",
       "                                              last_name   position  \\\n",
       "0                                 PHOENIX AUDIT LIMITED  secretary   \n",
       "5                                  FATBRAIN.COM LIMITED  secretary   \n",
       "6                             FIRST SECRETARIES LIMITED  secretary   \n",
       "7                                    +A COMPANY LIMITED   director   \n",
       "8                               FIRST DIRECTORS LIMITED   director   \n",
       "11                      INCORPORATE SECRETARIAT LIMITED  secretary   \n",
       "14                        INCORPORATE DIRECTORS LIMITED   director   \n",
       "16                                               BUTLER  secretary   \n",
       "17                                               BUTLER   director   \n",
       "18            CLIFFORD CHANCE SECRETARIES (CCA) LIMITED  secretary   \n",
       "19                  CLIFFORD CHANCE SECRETARIES LIMITED  secretary   \n",
       "20                                               DAVIES  secretary   \n",
       "21                                               HAYNES  secretary   \n",
       "22                                               MILLAR  secretary   \n",
       "23                                            NGONDONGA  secretary   \n",
       "24                                                SCOTT  secretary   \n",
       "33                                              ELLIOTT   director   \n",
       "34                                             GOODSELL   director   \n",
       "35                                               HEWITT   director   \n",
       "37                                               HOOPER   director   \n",
       "39                                               JANSEN   director   \n",
       "40                                                 KAYE   director   \n",
       "41                                               LAYTON   director   \n",
       "43                                                LUCAS   director   \n",
       "51                                                PUDGE   director   \n",
       "55                                             WILLIAMS   director   \n",
       "56                                                WOOLF   director   \n",
       "58                                               HAYNES  secretary   \n",
       "59                    OCS CORPORATE SECRETARIES LIMITED  secretary   \n",
       "60                                           RICHARDSON  secretary   \n",
       "...                                                 ...        ...   \n",
       "9945                                               LANE   director   \n",
       "9946                                            PILLING  secretary   \n",
       "9947                                            PILLING   director   \n",
       "9949                                           NICOLAOU  secretary   \n",
       "9951                                              KOIZI   director   \n",
       "9952  SECSERVICE24 ADMINISTRATION & MANAGEMENT UK LI...  secretary   \n",
       "9953                                             PLEYER   director   \n",
       "9954                                            SCHMIDT   director   \n",
       "9955                                             BREWER  secretary   \n",
       "9956                                             DAVIES  secretary   \n",
       "9960                      M W DOUGLAS & COMPANY LIMITED  secretary   \n",
       "9962                           DOUGLAS NOMINEES LIMITED   director   \n",
       "9964                                            BRISTOW  secretary   \n",
       "9965                         TEMPLE SECRETARIES LIMITED  secretary   \n",
       "9967                          COMPANY DIRECTORS LIMITED   director   \n",
       "9968                                            JACKSON   director   \n",
       "9969                                               AYUB  secretary   \n",
       "9970                         FORM 10 SECRETARIES FD LTD  secretary   \n",
       "9971                                               AYUB   director   \n",
       "9972                           FORM 10 DIRECTORS FD LTD   director   \n",
       "9973                           GO AHEAD SERVICE LIMITED  secretary   \n",
       "9974                                            DUBOVOY   director   \n",
       "9975                                           ORTMEYER   director   \n",
       "9983      STEINBERG & PARTNERS BUSINESS CONSULTING CORP  secretary   \n",
       "9984                                              ABELE   director   \n",
       "9986                                      JARNELL-JONES  secretary   \n",
       "9988                                      JARNELL-JONES   director   \n",
       "9993                     LONDON LAW SECRETARIAL LIMITED  secretary   \n",
       "9997                        LONDON LAW SERVICES LIMITED   director   \n",
       "9999                                             LESLIE   director   \n",
       "\n",
       "      start_date  person_number  \\\n",
       "0     2006-10-05    99992830001   \n",
       "5     2000-09-06    83435930001   \n",
       "6     2000-09-06   900000780001   \n",
       "7     2000-09-06    72279610010   \n",
       "8     2000-09-06   900000770001   \n",
       "11    2005-04-27   900028930001   \n",
       "14    2005-04-27   900030870001   \n",
       "16    2007-04-26    91946330002   \n",
       "17    2007-04-26   120439080001   \n",
       "18    2004-11-16    83911920002   \n",
       "19    2004-06-09   900005620001   \n",
       "20    2007-09-18   115843280001   \n",
       "21    2013-10-01   182037440001   \n",
       "22    2014-09-08   190875400001   \n",
       "23    2012-08-17   171614160001   \n",
       "24    2014-04-22   187308770001   \n",
       "33    2004-10-01    72275690002   \n",
       "34    2007-09-18    51490510002   \n",
       "35    2014-06-26   189107810001   \n",
       "37    2006-11-24    97001520002   \n",
       "39    2014-01-06   184427650001   \n",
       "40    2005-11-28   126407230001   \n",
       "41    2004-06-09   900019870001   \n",
       "43    2004-09-29    70329570002   \n",
       "51    2004-06-09   900028170001   \n",
       "55    2015-10-01    71960020002   \n",
       "56    2005-06-01    78818510001   \n",
       "58    2013-10-01   182412280001   \n",
       "59    2001-08-03   900021500001   \n",
       "60    2001-08-09    77561390001   \n",
       "...          ...            ...   \n",
       "9945  2007-09-03   124162520002   \n",
       "9946  2005-09-15   107634870001   \n",
       "9947  2005-09-15   107634860001   \n",
       "9949  2009-01-12   135684640001   \n",
       "9951  2009-01-12    88068780001   \n",
       "9952  2007-05-11   121398070001   \n",
       "9953  2007-05-11   121398060001   \n",
       "9954  2007-05-11   121398050001   \n",
       "9955  2002-02-26   900004890001   \n",
       "9956  2002-02-26    80898600002   \n",
       "9960  2005-09-08   900007890001   \n",
       "9962  2005-09-08   900007880001   \n",
       "9964  2005-07-29   107071450001   \n",
       "9965  2005-07-29   900001120001   \n",
       "9967  2005-07-29   900001110001   \n",
       "9968  2010-12-13   156645370001   \n",
       "9969  2006-11-28   118371630001   \n",
       "9970  2006-11-28   900015000001   \n",
       "9971  2006-11-28   118371570001   \n",
       "9972  2006-11-28   900014990001   \n",
       "9973  2007-02-23   900029810001   \n",
       "9974  2007-02-23   107358700001   \n",
       "9975  2007-02-23   119001820002   \n",
       "9983  2005-07-20   900030980001   \n",
       "9984  2005-07-20   106509700001   \n",
       "9986  2007-07-10   122840780001   \n",
       "9988  2007-07-10   122840780001   \n",
       "9993  1998-09-23   900001510001   \n",
       "9997  1998-09-23   900001500001   \n",
       "9999  2010-09-14   154092280001   \n",
       "\n",
       "                            ...                          \\\n",
       "0                           ...                           \n",
       "5                           ...                           \n",
       "6                           ...                           \n",
       "7                           ...                           \n",
       "8                           ...                           \n",
       "11                          ...                           \n",
       "14                          ...                           \n",
       "16                          ...                           \n",
       "17                          ...                           \n",
       "18                          ...                           \n",
       "19                          ...                           \n",
       "20                          ...                           \n",
       "21                          ...                           \n",
       "22                          ...                           \n",
       "23                          ...                           \n",
       "24                          ...                           \n",
       "33                          ...                           \n",
       "34                          ...                           \n",
       "35                          ...                           \n",
       "37                          ...                           \n",
       "39                          ...                           \n",
       "40                          ...                           \n",
       "41                          ...                           \n",
       "43                          ...                           \n",
       "51                          ...                           \n",
       "55                          ...                           \n",
       "56                          ...                           \n",
       "58                          ...                           \n",
       "59                          ...                           \n",
       "60                          ...                           \n",
       "...                         ...                           \n",
       "9945                        ...                           \n",
       "9946                        ...                           \n",
       "9947                        ...                           \n",
       "9949                        ...                           \n",
       "9951                        ...                           \n",
       "9952                        ...                           \n",
       "9953                        ...                           \n",
       "9954                        ...                           \n",
       "9955                        ...                           \n",
       "9956                        ...                           \n",
       "9960                        ...                           \n",
       "9962                        ...                           \n",
       "9964                        ...                           \n",
       "9965                        ...                           \n",
       "9967                        ...                           \n",
       "9968                        ...                           \n",
       "9969                        ...                           \n",
       "9970                        ...                           \n",
       "9971                        ...                           \n",
       "9972                        ...                           \n",
       "9973                        ...                           \n",
       "9974                        ...                           \n",
       "9975                        ...                           \n",
       "9983                        ...                           \n",
       "9984                        ...                           \n",
       "9986                        ...                           \n",
       "9988                        ...                           \n",
       "9993                        ...                           \n",
       "9997                        ...                           \n",
       "9999                        ...                           \n",
       "\n",
       "      partial_date_of_birth     type  \\\n",
       "0                       NaN  Company   \n",
       "5                       NaN  Company   \n",
       "6                       NaN  Company   \n",
       "7                       NaN  Company   \n",
       "8                   1989-08  Company   \n",
       "11                      NaN  Company   \n",
       "14                      NaN  Company   \n",
       "16                  1960-08   Person   \n",
       "17                  1961-07   Person   \n",
       "18                      NaN  Company   \n",
       "19                      NaN  Company   \n",
       "20                  1960-02   Person   \n",
       "21                      NaN   Person   \n",
       "22                      NaN   Person   \n",
       "23                      NaN   Person   \n",
       "24                      NaN   Person   \n",
       "33                  1969-02   Person   \n",
       "34                  1959-01   Person   \n",
       "35                  1962-03   Person   \n",
       "37                  1973-07   Person   \n",
       "39                  1970-07   Person   \n",
       "40                  1973-01   Person   \n",
       "41                  1961-02   Person   \n",
       "43                  1962-08   Person   \n",
       "51                  1965-08   Person   \n",
       "55                  1967-09   Person   \n",
       "56                  1964-12   Person   \n",
       "58                  1973-01   Person   \n",
       "59                      NaN  Company   \n",
       "60                  1942-03   Person   \n",
       "...                     ...      ...   \n",
       "9945                1965-09   Person   \n",
       "9946                    NaN   Person   \n",
       "9947                1966-09   Person   \n",
       "9949                    NaN   Person   \n",
       "9951                1964-04   Person   \n",
       "9952                    NaN  Company   \n",
       "9953                1940-12   Person   \n",
       "9954                1943-03   Person   \n",
       "9955                    NaN   Person   \n",
       "9956                    NaN   Person   \n",
       "9960                    NaN  Company   \n",
       "9962                    NaN  Company   \n",
       "9964                    NaN   Person   \n",
       "9965                    NaN  Company   \n",
       "9967                    NaN  Company   \n",
       "9968                1968-12   Person   \n",
       "9969                1987-11   Person   \n",
       "9970                    NaN  Company   \n",
       "9971                1962-08   Person   \n",
       "9972                    NaN  Company   \n",
       "9973                    NaN  Company   \n",
       "9974                1974-01   Person   \n",
       "9975                1967-06   Person   \n",
       "9983                    NaN  Company   \n",
       "9984                1953-03   Person   \n",
       "9986                1971-08   Person   \n",
       "9988                1971-08   Person   \n",
       "9993                    NaN  Company   \n",
       "9997                    NaN  Company   \n",
       "9999                1964-12   Person   \n",
       "\n",
       "                                        address.in_full  \\\n",
       "0      35 OXFORD STREET\\nPONTYCYMER, BRIDGEND, CF32 8DD   \n",
       "5     PREMIER SUITE 4 CHURCHILL COURT\\n58 STATION RO...   \n",
       "6                   72 NEW BOND STREET, LONDON, W1S 1RR   \n",
       "7     PREMIER SUITE 4 CHURCHILL COURT\\n58 STATION RO...   \n",
       "8                   72 NEW BOND STREET, LONDON, W1S 1RR   \n",
       "11    4TH FLOOR 3 TENTERDEN STREET\\nHANOVER SQUARE, ...   \n",
       "14    4TH FLOOR, 3 TENTERDEN STREET\\nHANOVER SQUARE,...   \n",
       "16    8 BERNISDALE GARDENS\\nDRUMCHAPEL, GLASGOW, LAN...   \n",
       "17    8 BERNISDALE GARDENS, GLASGOW, STRATHCLYDE, G1...   \n",
       "18                10 UPPER BANK STREET, LONDON, E14 5JJ   \n",
       "19                10 UPPER BANK STREET, LONDON, E14 5JJ   \n",
       "20    ENBROOK PARK SANDGATE, FOLKESTONE, KENT, CT20 ...   \n",
       "21    ENBROOK PARK SANDGATE, FOLKESTONE, KENT, CT20 ...   \n",
       "22    FANUM HOUSE BASING VIEW\\nBASINGSTOKE, HANTS, R...   \n",
       "23    FANUM HOUSE BASING VIEW, BASINGSTOKE, HAMPSHIR...   \n",
       "24    FANUM HOUSE BASING VIEW, BASINGSTOKE, HAMPSHIR...   \n",
       "33      50 WILTON CRESCENT\\nWIMBLEDON, LONDON, SW19 3QS   \n",
       "34           1 ENBROOK PARK, FOLKESTONE, KENT, CT20 3SE   \n",
       "35    FANUM HOUSE BASING VIEW, BASINGSTOKE, HAMPSHIR...   \n",
       "37                    18 BEAUCLERC ROAD, LONDON, W6 0NS   \n",
       "39    FANUM HOUSE BASING VIEW, BASINGSTOKE, HAMPSHIR...   \n",
       "40                  13 KELMSCOTT ROAD, LONDON, SW11 6QX   \n",
       "41    FLAT 49 8 NEW CRANE WHARF\\nNEW CRANE PLACE, LO...   \n",
       "43    THE FORGE\\nAYOT ST. LAWRENCE, WELWYN, HERTFORD...   \n",
       "51                20 HERONDALE AVENUE, LONDON, SW18 3JL   \n",
       "55    FANUM HOUSE\\nBASING VIEW, BASINGSTOKE, HAMPSHI...   \n",
       "56                      18 FAIRFAX ROAD, LONDON, W4 1EW   \n",
       "58    ENBROOK PARK SANDGATE, FOLKESTONE, KENT, CT20 ...   \n",
       "59    MINSHULL HOUSE 67 WELLINGTON ROAD NORTH, STOCK...   \n",
       "60    CHURCHILL HOUSE\\nFURNERS MEAD, HENFIELD, WEST ...   \n",
       "...                                                 ...   \n",
       "9945  256 ACKLAM ROAD, MIDDLESBROUGH, CLEVELAND, TS5...   \n",
       "9946  18 CHURCH LANE\\nWRIGHTINGTON, WIGAN, LANCASHIR...   \n",
       "9947  18 CHURCH LANE\\nWRIGHTINGTON, WIGAN, LANCASHIR...   \n",
       "9949     27 MANDEVILLE ROAD\\nSOUTHGATE, LONDON, N14 7NJ   \n",
       "9951        53 VICTORIA ROAD\\nEDMONTON, LONDON, N18 2UG   \n",
       "9952  THE MERIDIAN\\n4 COPTHALL HOUSE, STATION SQUARE...   \n",
       "9953  SPIELMANNSTR. 18, FRANKFURT AM MAIN, D65934, G...   \n",
       "9954  ALT GRIESHEIM 19, FRANKFURT AM MAIN, D65933, G...   \n",
       "9955  SOMERSET HOUSE\\n40-49 PRICE STREET, BIRMINGHAM...   \n",
       "9956  CRANNMOOR FARM WROTTESLEY PARK ROAD\\nWROTTESLE...   \n",
       "9960    REGENT HOUSE\\n316 BEULAH HILL, LONDON, SE19 3HP   \n",
       "9962    REGENT HOUSE\\n316 BEULAH HILL, LONDON, SE19 3HF   \n",
       "9964  GREENTOPS\\nHEADCORN ROAD SUTTON VALENCE, MAIDS...   \n",
       "9965            788-790 FINCHLEY ROAD, LONDON, NW11 7TJ   \n",
       "9967            788-790 FINCHLEY ROAD, LONDON, NW11 7TJ   \n",
       "9968  12 STILEBRIDGE LANE\\nMARDEN, TONBRIDGE, KENT, ...   \n",
       "9969  28 SELBOURNE AVENUE, DEWSBURY, WEST YORKSHIRE,...   \n",
       "9970    39A LEICESTER ROAD\\nSALFORD, MANCHESTER, M7 4AS   \n",
       "9971  28 SELBOURNE AVENUE, DEWSBURY, WEST YORKSHIRE,...   \n",
       "9972    39A LEICESTER ROAD\\nSALFORD, MANCHESTER, M7 4AS   \n",
       "9973  69 GREAT HAMPTON STREET, BIRMINGHAM, WEST MIDL...   \n",
       "9974         OSTPREUSENSTR.98, METTMANN, 40822, GERMANY   \n",
       "9975                MOORSTR. 260, 48432 RHEINE, GERMANY   \n",
       "9983          SUITE 3\\n95 WILTON ROAD, LONDON, SW1V 1BZ   \n",
       "9984     KRAEMERSTRASSE 17, LUDWIGSBURG, 71642, GERMANY   \n",
       "9986  7 BLACKFRIARS, YARM ON TEES, NORTH YORKSHIRE, ...   \n",
       "9988  7 BLACKFRIARS, YARM ON TEES, NORTH YORKSHIRE, ...   \n",
       "9993  84 TEMPLE CHAMBERS\\nTEMPLE AVENUE, LONDON, EC4...   \n",
       "9997  84 TEMPLE CHAMBERS\\nTEMPLE AVENUE, LONDON, EC4...   \n",
       "9999  THE HAWTHORNS GREEN MEADOWS\\nHOM GREEN, ROSS-O...   \n",
       "\n",
       "                                 address.street_address   address.locality  \\\n",
       "0                          35 OXFORD STREET\\nPONTYCYMER           BRIDGEND   \n",
       "5      PREMIER SUITE 4 CHURCHILL COURT\\n58 STATION ROAD       NORTH HARROW   \n",
       "6                                    72 NEW BOND STREET             LONDON   \n",
       "7      PREMIER SUITE 4 CHURCHILL COURT\\n58 STATION ROAD       NORTH HARROW   \n",
       "8                                    72 NEW BOND STREET             LONDON   \n",
       "11         4TH FLOOR 3 TENTERDEN STREET\\nHANOVER SQUARE             LONDON   \n",
       "14        4TH FLOOR, 3 TENTERDEN STREET\\nHANOVER SQUARE             LONDON   \n",
       "16                     8 BERNISDALE GARDENS\\nDRUMCHAPEL            GLASGOW   \n",
       "17                                 8 BERNISDALE GARDENS            GLASGOW   \n",
       "18                                 10 UPPER BANK STREET             LONDON   \n",
       "19                                 10 UPPER BANK STREET             LONDON   \n",
       "20                                ENBROOK PARK SANDGATE         FOLKESTONE   \n",
       "21                                ENBROOK PARK SANDGATE         FOLKESTONE   \n",
       "22                 FANUM HOUSE BASING VIEW\\nBASINGSTOKE              HANTS   \n",
       "23                              FANUM HOUSE BASING VIEW        BASINGSTOKE   \n",
       "24                              FANUM HOUSE BASING VIEW        BASINGSTOKE   \n",
       "33                        50 WILTON CRESCENT\\nWIMBLEDON             LONDON   \n",
       "34                                       1 ENBROOK PARK         FOLKESTONE   \n",
       "35                              FANUM HOUSE BASING VIEW        BASINGSTOKE   \n",
       "37                                    18 BEAUCLERC ROAD             LONDON   \n",
       "39                              FANUM HOUSE BASING VIEW        BASINGSTOKE   \n",
       "40                                    13 KELMSCOTT ROAD             LONDON   \n",
       "41           FLAT 49 8 NEW CRANE WHARF\\nNEW CRANE PLACE             LONDON   \n",
       "43                         THE FORGE\\nAYOT ST. LAWRENCE             WELWYN   \n",
       "51                                  20 HERONDALE AVENUE             LONDON   \n",
       "55                             FANUM HOUSE\\nBASING VIEW        BASINGSTOKE   \n",
       "56                                      18 FAIRFAX ROAD             LONDON   \n",
       "58                                ENBROOK PARK SANDGATE         FOLKESTONE   \n",
       "59              MINSHULL HOUSE 67 WELLINGTON ROAD NORTH          STOCKPORT   \n",
       "60                        CHURCHILL HOUSE\\nFURNERS MEAD           HENFIELD   \n",
       "...                                                 ...                ...   \n",
       "9945                                    256 ACKLAM ROAD      MIDDLESBROUGH   \n",
       "9946                       18 CHURCH LANE\\nWRIGHTINGTON              WIGAN   \n",
       "9947                       18 CHURCH LANE\\nWRIGHTINGTON              WIGAN   \n",
       "9949                      27 MANDEVILLE ROAD\\nSOUTHGATE             LONDON   \n",
       "9951                         53 VICTORIA ROAD\\nEDMONTON             LONDON   \n",
       "9952     THE MERIDIAN\\n4 COPTHALL HOUSE, STATION SQUARE           COVENTRY   \n",
       "9953                                   SPIELMANNSTR. 18  FRANKFURT AM MAIN   \n",
       "9954                                   ALT GRIESHEIM 19  FRANKFURT AM MAIN   \n",
       "9955                 SOMERSET HOUSE\\n40-49 PRICE STREET         BIRMINGHAM   \n",
       "9956  CRANNMOOR FARM WROTTESLEY PARK ROAD\\nWROTTESLE...      WOLVERHAMPTON   \n",
       "9960                      REGENT HOUSE\\n316 BEULAH HILL             LONDON   \n",
       "9962                      REGENT HOUSE\\n316 BEULAH HILL             LONDON   \n",
       "9964            GREENTOPS\\nHEADCORN ROAD SUTTON VALENCE          MAIDSTONE   \n",
       "9965                              788-790 FINCHLEY ROAD             LONDON   \n",
       "9967                              788-790 FINCHLEY ROAD             LONDON   \n",
       "9968                        12 STILEBRIDGE LANE\\nMARDEN          TONBRIDGE   \n",
       "9969                                28 SELBOURNE AVENUE           DEWSBURY   \n",
       "9970                        39A LEICESTER ROAD\\nSALFORD         MANCHESTER   \n",
       "9971                                28 SELBOURNE AVENUE           DEWSBURY   \n",
       "9972                        39A LEICESTER ROAD\\nSALFORD         MANCHESTER   \n",
       "9973                            69 GREAT HAMPTON STREET         BIRMINGHAM   \n",
       "9974                                   OSTPREUSENSTR.98           METTMANN   \n",
       "9975                                       MOORSTR. 260       48432 RHEINE   \n",
       "9983                            SUITE 3\\n95 WILTON ROAD             LONDON   \n",
       "9984                                  KRAEMERSTRASSE 17        LUDWIGSBURG   \n",
       "9986                                      7 BLACKFRIARS       YARM ON TEES   \n",
       "9988                                      7 BLACKFRIARS       YARM ON TEES   \n",
       "9993                  84 TEMPLE CHAMBERS\\nTEMPLE AVENUE             LONDON   \n",
       "9997                  84 TEMPLE CHAMBERS\\nTEMPLE AVENUE             LONDON   \n",
       "9999             THE HAWTHORNS GREEN MEADOWS\\nHOM GREEN        ROSS-ON-WYE   \n",
       "\n",
       "       address.region address.postal_code address.country  \\\n",
       "0                 NaN            CF32 8DD             NaN   \n",
       "5           MIDDLESEX             HA2 7ST  UNITED KINGDOM   \n",
       "6                 NaN             W1S 1RR             NaN   \n",
       "7           MIDDLESEX             HA2 7ST             NaN   \n",
       "8                 NaN             W1S 1RR             NaN   \n",
       "11                NaN             W1S 1TD             NaN   \n",
       "14                NaN             W1S 1TD             NaN   \n",
       "16        LANARKSHIRE             G15 8BU             NaN   \n",
       "17        STRATHCLYDE             G15 8BU             NaN   \n",
       "18                NaN             E14 5JJ             NaN   \n",
       "19                NaN             E14 5JJ             NaN   \n",
       "20               KENT            CT20 3SE  UNITED KINGDOM   \n",
       "21               KENT            CT20 3SE  UNITED KINGDOM   \n",
       "22                NaN            RG21 4EA  UNITED KINGDOM   \n",
       "23          HAMPSHIRE            RG21 4EA  UNITED KINGDOM   \n",
       "24          HAMPSHIRE            RG21 4EA  UNITED KINGDOM   \n",
       "33                NaN            SW19 3QS             NaN   \n",
       "34               KENT            CT20 3SE             NaN   \n",
       "35          HAMPSHIRE            RG21 4EA  UNITED KINGDOM   \n",
       "37                NaN              W6 0NS             NaN   \n",
       "39          HAMPSHIRE            RG21 4EA  UNITED KINGDOM   \n",
       "40                NaN            SW11 6QX             NaN   \n",
       "41                NaN             E1W 3TX             NaN   \n",
       "43      HERTFORDSHIRE             AL6 9BW             NaN   \n",
       "51                NaN            SW18 3JL             NaN   \n",
       "55          HAMPSHIRE            RG21 4EA             NaN   \n",
       "56                NaN              W4 1EW             NaN   \n",
       "58               KENT            CT20 3SE  UNITED KINGDOM   \n",
       "59           CHESHIRE             SK4 2LP             NaN   \n",
       "60        WEST SUSSEX             BN5 9JB             NaN   \n",
       "...               ...                 ...             ...   \n",
       "9945        CLEVELAND             TS5 8AA             NaN   \n",
       "9946       LANCASHIRE             WN6 9SL             NaN   \n",
       "9947       LANCASHIRE             WN6 9SL             NaN   \n",
       "9949              NaN             N14 7NJ             NaN   \n",
       "9951              NaN             N18 2UG             NaN   \n",
       "9952    WEST MIDLANDS             CV1 2FL             NaN   \n",
       "9953              NaN              D65934         GERMANY   \n",
       "9954              NaN              D65933         GERMANY   \n",
       "9955              NaN              B2 5DN             NaN   \n",
       "9956              NaN             WV8 2HS         ENGLAND   \n",
       "9960              NaN            SE19 3HP             NaN   \n",
       "9962              NaN            SE19 3HF             NaN   \n",
       "9964             KENT            ME17 3EH             NaN   \n",
       "9965              NaN            NW11 7TJ             NaN   \n",
       "9967              NaN            NW11 7TJ             NaN   \n",
       "9968             KENT            TN12 9BJ              UK   \n",
       "9969   WEST YORKSHIRE            WF12 9PA             NaN   \n",
       "9970              NaN              M7 4AS             NaN   \n",
       "9971   WEST YORKSHIRE            WF12 9PA             NaN   \n",
       "9972              NaN              M7 4AS             NaN   \n",
       "9973    WEST MIDLANDS             B18 6EW             NaN   \n",
       "9974            40822                 NaN         GERMANY   \n",
       "9975              NaN                 NaN         GERMANY   \n",
       "9983              NaN            SW1V 1BZ             NaN   \n",
       "9984            71642                 NaN         GERMANY   \n",
       "9986  NORTH YORKSHIRE            TS15 9HQ             NaN   \n",
       "9988  NORTH YORKSHIRE            TS15 9HQ             NaN   \n",
       "9993              NaN            EC4Y 0HP             NaN   \n",
       "9997              NaN            EC4Y 0HP             NaN   \n",
       "9999    HEREFORDSHIRE             HR9 7RE             NaN   \n",
       "\n",
       "                 retrieved_at  \\\n",
       "0     2015-12-04 00:00:00 UTC   \n",
       "5     2015-12-04 00:00:00 UTC   \n",
       "6     2015-12-04 00:00:00 UTC   \n",
       "7     2015-12-04 00:00:00 UTC   \n",
       "8     2015-12-04 00:00:00 UTC   \n",
       "11    2015-12-04 00:00:00 UTC   \n",
       "14    2015-12-04 00:00:00 UTC   \n",
       "16    2015-12-04 00:00:00 UTC   \n",
       "17    2015-12-04 00:00:00 UTC   \n",
       "18    2015-12-04 00:00:00 UTC   \n",
       "19    2015-12-04 00:00:00 UTC   \n",
       "20    2015-12-04 00:00:00 UTC   \n",
       "21    2015-12-04 00:00:00 UTC   \n",
       "22    2015-12-04 00:00:00 UTC   \n",
       "23    2015-12-04 00:00:00 UTC   \n",
       "24    2015-12-04 00:00:00 UTC   \n",
       "33    2015-12-04 00:00:00 UTC   \n",
       "34    2015-12-04 00:00:00 UTC   \n",
       "35    2015-12-04 00:00:00 UTC   \n",
       "37    2015-12-04 00:00:00 UTC   \n",
       "39    2015-12-04 00:00:00 UTC   \n",
       "40    2015-12-04 00:00:00 UTC   \n",
       "41    2015-12-04 00:00:00 UTC   \n",
       "43    2015-12-04 00:00:00 UTC   \n",
       "51    2015-12-04 00:00:00 UTC   \n",
       "55    2015-12-04 00:00:00 UTC   \n",
       "56    2015-12-04 00:00:00 UTC   \n",
       "58    2016-05-17 00:00:00 UTC   \n",
       "59    2015-12-04 00:00:00 UTC   \n",
       "60    2015-12-04 00:00:00 UTC   \n",
       "...                       ...   \n",
       "9945  2015-12-04 00:00:00 UTC   \n",
       "9946  2015-12-04 00:00:00 UTC   \n",
       "9947  2015-12-04 00:00:00 UTC   \n",
       "9949  2015-12-04 00:00:00 UTC   \n",
       "9951  2015-12-04 00:00:00 UTC   \n",
       "9952  2015-12-04 00:00:00 UTC   \n",
       "9953  2015-12-04 00:00:00 UTC   \n",
       "9954  2015-12-04 00:00:00 UTC   \n",
       "9955  2015-12-04 00:00:00 UTC   \n",
       "9956  2015-12-04 00:00:00 UTC   \n",
       "9960  2015-12-04 00:00:00 UTC   \n",
       "9962  2015-12-04 00:00:00 UTC   \n",
       "9964  2015-12-04 00:00:00 UTC   \n",
       "9965  2015-12-04 00:00:00 UTC   \n",
       "9967  2015-12-04 00:00:00 UTC   \n",
       "9968  2015-12-04 00:00:00 UTC   \n",
       "9969  2015-12-04 00:00:00 UTC   \n",
       "9970  2015-12-04 00:00:00 UTC   \n",
       "9971  2015-12-04 00:00:00 UTC   \n",
       "9972  2015-12-04 00:00:00 UTC   \n",
       "9973  2015-12-04 00:00:00 UTC   \n",
       "9974  2015-12-04 00:00:00 UTC   \n",
       "9975  2015-12-04 00:00:00 UTC   \n",
       "9983  2015-12-04 00:00:00 UTC   \n",
       "9984  2015-12-04 00:00:00 UTC   \n",
       "9986  2015-12-04 00:00:00 UTC   \n",
       "9988  2015-12-04 00:00:00 UTC   \n",
       "9993  2015-12-04 00:00:00 UTC   \n",
       "9997  2015-12-04 00:00:00 UTC   \n",
       "9999  2015-12-04 00:00:00 UTC   \n",
       "\n",
       "                                             source_url  \n",
       "0     https://beta.companieshouse.gov.uk/company/059...  \n",
       "5     https://beta.companieshouse.gov.uk/company/040...  \n",
       "6     https://beta.companieshouse.gov.uk/company/040...  \n",
       "7     https://beta.companieshouse.gov.uk/company/040...  \n",
       "8     https://beta.companieshouse.gov.uk/company/040...  \n",
       "11    https://beta.companieshouse.gov.uk/company/054...  \n",
       "14    https://beta.companieshouse.gov.uk/company/054...  \n",
       "16    https://beta.companieshouse.gov.uk/company/SC3...  \n",
       "17    https://beta.companieshouse.gov.uk/company/SC3...  \n",
       "18    https://beta.companieshouse.gov.uk/company/051...  \n",
       "19    https://beta.companieshouse.gov.uk/company/051...  \n",
       "20    https://beta.companieshouse.gov.uk/company/051...  \n",
       "21    https://beta.companieshouse.gov.uk/company/051...  \n",
       "22    https://beta.companieshouse.gov.uk/company/051...  \n",
       "23    https://beta.companieshouse.gov.uk/company/051...  \n",
       "24    https://beta.companieshouse.gov.uk/company/051...  \n",
       "33    https://beta.companieshouse.gov.uk/company/051...  \n",
       "34    https://beta.companieshouse.gov.uk/company/051...  \n",
       "35    https://beta.companieshouse.gov.uk/company/051...  \n",
       "37    https://beta.companieshouse.gov.uk/company/051...  \n",
       "39    https://beta.companieshouse.gov.uk/company/051...  \n",
       "40    https://beta.companieshouse.gov.uk/company/051...  \n",
       "41    https://beta.companieshouse.gov.uk/company/051...  \n",
       "43    https://beta.companieshouse.gov.uk/company/051...  \n",
       "51    https://beta.companieshouse.gov.uk/company/051...  \n",
       "55    https://beta.companieshouse.gov.uk/company/051...  \n",
       "56    https://beta.companieshouse.gov.uk/company/051...  \n",
       "58    https://beta.companieshouse.gov.uk/company/051...  \n",
       "59    https://beta.companieshouse.gov.uk/company/042...  \n",
       "60    https://beta.companieshouse.gov.uk/company/042...  \n",
       "...                                                 ...  \n",
       "9945  https://beta.companieshouse.gov.uk/company/063...  \n",
       "9946  https://beta.companieshouse.gov.uk/company/055...  \n",
       "9947  https://beta.companieshouse.gov.uk/company/055...  \n",
       "9949  https://beta.companieshouse.gov.uk/company/067...  \n",
       "9951  https://beta.companieshouse.gov.uk/company/067...  \n",
       "9952  https://beta.companieshouse.gov.uk/company/062...  \n",
       "9953  https://beta.companieshouse.gov.uk/company/062...  \n",
       "9954  https://beta.companieshouse.gov.uk/company/062...  \n",
       "9955  https://beta.companieshouse.gov.uk/company/043...  \n",
       "9956  https://beta.companieshouse.gov.uk/company/043...  \n",
       "9960  https://beta.companieshouse.gov.uk/company/055...  \n",
       "9962  https://beta.companieshouse.gov.uk/company/055...  \n",
       "9964  https://beta.companieshouse.gov.uk/company/055...  \n",
       "9965  https://beta.companieshouse.gov.uk/company/055...  \n",
       "9967  https://beta.companieshouse.gov.uk/company/055...  \n",
       "9968  https://beta.companieshouse.gov.uk/company/055...  \n",
       "9969  https://beta.companieshouse.gov.uk/company/060...  \n",
       "9970  https://beta.companieshouse.gov.uk/company/060...  \n",
       "9971  https://beta.companieshouse.gov.uk/company/060...  \n",
       "9972  https://beta.companieshouse.gov.uk/company/060...  \n",
       "9973  https://beta.companieshouse.gov.uk/company/061...  \n",
       "9974  https://beta.companieshouse.gov.uk/company/061...  \n",
       "9975  https://beta.companieshouse.gov.uk/company/061...  \n",
       "9983  https://beta.companieshouse.gov.uk/company/055...  \n",
       "9984  https://beta.companieshouse.gov.uk/company/055...  \n",
       "9986  https://beta.companieshouse.gov.uk/company/063...  \n",
       "9988  https://beta.companieshouse.gov.uk/company/063...  \n",
       "9993  https://beta.companieshouse.gov.uk/company/036...  \n",
       "9997  https://beta.companieshouse.gov.uk/company/036...  \n",
       "9999  https://beta.companieshouse.gov.uk/company/073...  \n",
       "\n",
       "[5897 rows x 26 columns]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sample_df[sample_df.title.isnull()]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "From this and further exploring the data there are two \"types\" of officer in the data; people and companies.\n",
    "\n",
    "We will start with how to map People officers into the database. We will also ignore officers who have an \"end date\" as they are no longer actively connected to the company.\n",
    "\n",
    "## People who are officers\n",
    "\n",
    "First we will define a number of functions that can map the data into the node objects that we want to hold for people who are officers."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "def officer_dob(record):\n",
    "    \"Function to create dob string identifier for person\"\n",
    "    record.fillna('')\n",
    "    data = record['partial_date_of_birth']\n",
    "    try:\n",
    "        year, month = data.split('-')\n",
    "        dob_segment = \"{}/{}\".format(str(month).zfill(2), year)\n",
    "        return dob_segment\n",
    "    except (AttributeError, TypeError, ValueError) as e:\n",
    "        return '00/0000'\n",
    "\n",
    "def officer_name_id(record):\n",
    "    \"Function to create name string identifier for person\"\n",
    "    fullname = record['name'].split()\n",
    "    data = {\n",
    "        'first_name': fullname[0],\n",
    "        'last_name': record['last_name'],\n",
    "        'middle_name': ' '.join(fullname[1:-1])\n",
    "    }\n",
    "    try:\n",
    "        name_segment = \"{}_{}_{}\".format(data.get('last_name', '').upper(), \n",
    "                                         data.get('middle_name', '').lower(),\n",
    "                                         data.get('first_name', '').lower())\n",
    "        return name_segment.replace(' ', '-')\n",
    "    except TypeError as e:\n",
    "        return 'NONAME__BLANK'\n",
    "    except AttributeError:\n",
    "        return 'NONAME__BLANK'\n",
    "    \n",
    "def officer_uid(record):\n",
    "    \"Function to create a unique ID for someone from their name and dob\"\n",
    "    components = [officer_name_id(record), officer_dob(record)]\n",
    "    return {'uid': ':'.join(components)}\n",
    "\n",
    "def officer_name(record):\n",
    "    \"Function to create name record of person\"\n",
    "    fullname = record['name'].split()\n",
    "    data = {\n",
    "        'forename': fullname[0].title(),\n",
    "        'surname': record['last_name'].title(),\n",
    "        'middle_name': ' '.join(fullname[1:-1]).title(),\n",
    "        'title': record['title'].title(),\n",
    "        'name': ' '.join([record['title'], record['name']])\n",
    "    }    \n",
    "    try:\n",
    "        name_record = {\n",
    "            'surname': data.get('surname', ''),\n",
    "            'middle_name': data.get('middle_name', ''),\n",
    "            'forename': data.get('forename', ''),\n",
    "            'title': data.get('title', ''),\n",
    "            'name': data.get('name', '').upper()\n",
    "        }\n",
    "        return name_record\n",
    "    except TypeError as e:\n",
    "        return {}\n",
    "    except AttributeError:\n",
    "        return {}\n",
    "\n",
    "def officer_address(record):\n",
    "    \"Function to create a address details for person\"\n",
    "    record.fillna('', inplace=True)\n",
    "    address = record['address.street_address'].split('\\\\n')\n",
    "    address_Line1 = address[0]\n",
    "    address_Line2 = ''\n",
    "    if len(address)>1:\n",
    "        address_Line2 = address[1]\n",
    "\n",
    "    data = {\n",
    "        'address_line_1': address_Line1,\n",
    "        'address_line_2': address_Line2,\n",
    "        'locality': record['address.locality'],\n",
    "        'region': record['address.region'],\n",
    "        'postal_code': record['address.postal_code'],\n",
    "        'country': record['address.country']\n",
    "    }\n",
    "    try:\n",
    "        new_address = {\n",
    "            'address_Line1': data.get('address_line_1', ''),\n",
    "            'address_Line2': data.get('address_line_2', ''),\n",
    "            'address_PostTown': data.get('locality', '').upper(),\n",
    "            'address_POBox': data.get('po_box', ''),\n",
    "            'address_County': data.get('region', '').upper(),\n",
    "            'address_PostCode': data.get('postal_code', '').upper(),\n",
    "            'address_Country': data.get('country', '').upper(),\n",
    "            'address_InFull': record['address.in_full']\n",
    "        }\n",
    "        return new_address\n",
    "    except TypeError as e:\n",
    "        return {'address_Country': \"UNKNOWN\"}\n",
    "    except AttributeError:\n",
    "        return {'address_Country': \"UNKNOWN\"}\n",
    "    \n",
    "def officer_details(record):\n",
    "    \"Function to create a relationship details for person\"\n",
    "    details = {}\n",
    "    details['company_id'] = str(record['company_number'])\n",
    "    details['officer_kind'] = record['position'].upper()\n",
    "    details['nationality'] = record['nationality']\n",
    "    details['ceased_on'] = record['end_date']\n",
    "    details['source_url'] = record['source_url']\n",
    "    details['country_of_residence'] = record['country_of_residence']\n",
    "    details['person_uid'] = str(record['person_uid'])\n",
    "    dob = record['partial_date_of_birth']\n",
    "    try:\n",
    "        year, month = dob.split('-')\n",
    "        details['DOB'] = \"{}/{}\".format(str(month).zfill(2), year)\n",
    "    except (TypeError, ValueError) as e:\n",
    "        pass\n",
    "    return details\n",
    "    \n",
    "\n",
    "def new_officer_record(record):\n",
    "    \"Function to create a new record that is flat\"\n",
    "    uid = officer_uid(record)\n",
    "    address = officer_address(record)\n",
    "    return {**uid, **address, \n",
    "            **officer_details(record), \n",
    "            **officer_name(record)}"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'DOB': '08/1966',\n",
       " 'address_Country': '',\n",
       " 'address_County': 'WEST GLAMORGAN',\n",
       " 'address_InFull': 'PENYCASTELL FARM BRYN, PORT TALBOT, WEST GLAMORGAN, SA13 2PY',\n",
       " 'address_Line1': 'PENYCASTELL FARM BRYN',\n",
       " 'address_Line2': '',\n",
       " 'address_POBox': '',\n",
       " 'address_PostCode': 'SA13 2PY',\n",
       " 'address_PostTown': 'PORT TALBOT',\n",
       " 'ceased_on': '',\n",
       " 'company_id': '05957738',\n",
       " 'country_of_residence': 'ENGLAND',\n",
       " 'forename': 'Sally-Ann',\n",
       " 'middle_name': 'Michelle',\n",
       " 'name': 'MRS SALLY-ANN MICHELLE BROMLEY',\n",
       " 'nationality': 'BRITISH',\n",
       " 'officer_kind': 'DIRECTOR',\n",
       " 'person_uid': '12148419',\n",
       " 'source_url': 'https://beta.companieshouse.gov.uk/company/05957738',\n",
       " 'surname': 'Bromley',\n",
       " 'title': 'Mrs',\n",
       " 'uid': 'BROMLEY_michelle_sally-ann:08/1966'}"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sample_df[sample_df.type == 'Person'].apply(new_officer_record, axis=1).iloc[2]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "We will use the reference objects that we have built before to know how to map countries and nationalities"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "country_code_map = pd.read_pickle('./data/clean_country_code_map.pkl')\n",
    "combined_map = pd.read_pickle('./data/combined_country_map.pkl')\n",
    "nationality_map = pd.read_pickle('./data/nation_map.pkl')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Let's wrap up our processing data into a function that can act on an input dataframe object"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "def officer_etl(original_df):\n",
    "    original_df = original_df[original_df.type == 'Person']\n",
    "    original_df = original_df[original_df.end_date.isnull()]\n",
    "    processed_df = original_df.apply(lambda s: pd.Series(new_officer_record(s)), axis=1)\n",
    "    processed_df['Citizen_of'] = processed_df.nationality.apply(lambda x: nationality_map.get(x.lower(), ''))\n",
    "    processed_df['Registered_in'] = processed_df.address_Country.apply(lambda x: combined_map.get(x.lower(), ''))\n",
    "    processed_df['Resident_in'] = processed_df.country_of_residence.apply(lambda x: combined_map.get(x.lower(), ''))\n",
    "    input_data = [v for k,v in processed_df.T.to_dict().items()]\n",
    "    return input_data"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Example test of action a sample of the data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "8\n",
      "{'DOB': '05/1970', 'address_Country': 'UNITED KINGDOM', 'address_County': 'WEST MIDLANDS', 'address_InFull': '40 LEA MANOR DRIVE\\\\nPENN, WOLVERHAMPTON, WEST MIDLANDS, WV4 5PJ, UNITED KINGDOM', 'address_Line1': '40 LEA MANOR DRIVE', 'address_Line2': 'PENN', 'address_POBox': '', 'address_PostCode': 'WV4 5PJ', 'address_PostTown': 'WOLVERHAMPTON', 'ceased_on': '', 'company_id': '05957738', 'country_of_residence': 'UNITED KINGDOM', 'forename': 'David', 'middle_name': 'Ian', 'name': 'MR DAVID IAN BROMLEY', 'nationality': 'BRITISH', 'officer_kind': 'DIRECTOR', 'person_uid': '11594785', 'source_url': 'https://beta.companieshouse.gov.uk/company/05957738', 'surname': 'Bromley', 'title': 'Mr', 'uid': 'BROMLEY_ian_david:05/1970', 'Citizen_of': 'GB', 'Registered_in': '', 'Resident_in': ''}\n"
     ]
    }
   ],
   "source": [
    "test = officer_etl(sample_df.head(20))\n",
    "print(len(test))\n",
    "print(test[0])"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Looping through all of the data and pushing it into Neo4j"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "from neo4j.v1 import GraphDatabase\n",
    "driver = GraphDatabase.driver(\"bolt://10.0.0.1:7687\", auth=(\"myusername\", \"mypassword\"))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {
    "scrolled": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "1\n",
      "Finished chunk...0.0010879618344008634%\n",
      "2\n",
      "DONE!\n"
     ]
    }
   ],
   "source": [
    "num=0\n",
    "done=0\n",
    "chunks = pd.read_csv(master_path+'officers.csv', chunksize=100000)\n",
    "for chunk in chunks:\n",
    "    input_data = officer_etl(chunk)\n",
    "    num+=1\n",
    "    done+=len(input_data)\n",
    "    print(num)\n",
    "    if len(input_data) > 0:\n",
    "        with driver.session() as session:\n",
    "            session.run((\"UNWIND {list} AS d \"\n",
    "                         \"MERGE (c:Person {uid: d.uid}) \"\n",
    "                         \"ON CREATE SET c.forename=d.forename, \"\n",
    "                         \"c.middle_name=d.middle_name, \"\n",
    "                         \"c.surname=d.surname, \"\n",
    "                         \"c.title=d.title, \"\n",
    "                         \"c.fullname=d.name, \"\n",
    "                         \"c.dob=d.DOB, \"\n",
    "                         \"c.person_uid=d.person_uid, \"\n",
    "                         \"c.nationality=d.nationality, \"\n",
    "                         \"c.address_Line1=d.address_Line1, \"\n",
    "                         \"c.address_Line2=d.address_Line2, \"\n",
    "                         \"c.address_PostTown=d.address_PostTown, \"\n",
    "                         \"c.address_County=d.address_County, \"\n",
    "                         \"c.address_PostCode=d.address_Postcode, \"                 \n",
    "                         \"c.address_Country=d.address_Country, \"                 \n",
    "                         \"c.uri=d.source_url;\"), {\"list\": input_data})\n",
    "\n",
    "        with driver.session() as session:\n",
    "            session.run((\"UNWIND {list} AS d \"\n",
    "                         \"MATCH (c:Person {uid: d.uid}) \"\n",
    "                         \"MERGE (country:Country {code: d.Registered_in}) \"\n",
    "                         \"MERGE (c)-[:REGISTERED_IN]->(country);\"), {\"list\": input_data})\n",
    "\n",
    "        with driver.session() as session:\n",
    "            session.run((\"UNWIND {list} AS d \"\n",
    "                         \"MATCH (c:Person {uid: d.uid}) \"\n",
    "                         \"MERGE (country:Country {code: d.Citizen_of}) \"\n",
    "                         \"MERGE (c)-[:CITIZEN_OF]->(country);\"), {\"list\": input_data})\n",
    "\n",
    "        with driver.session() as session:\n",
    "            session.run((\"UNWIND {list} AS d \"\n",
    "                         \"MATCH (p:Person {uid: d.uid}) \"\n",
    "                         \"SET p:Officer;\"), {\"list\": input_data})    \n",
    "\n",
    "        with driver.session() as session:\n",
    "            session.run((\"UNWIND {list} AS d \"\n",
    "                         \"MATCH (p:Person {uid: d.uid}) \"\n",
    "                         \"MERGE (c:Company {uid: d.company_id}) \"\n",
    "                         \"CREATE (p)-[r:IS_OFFICER_OF {type: d.officer_kind, ceased_on: d.ceased_on}]->(c);\"), {\"list\": input_data})\n",
    "        print(\"Finished chunk...{}%\".format(done/40386527))\n",
    "    else:\n",
    "        print(\"No records in this chunk\")\n",
    "print(\"DONE!\")        "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.1"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}