May 22 - STP to ICB.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "cdd934b7",
   "metadata": {},
   "source": [
    "## Notebook to check EPD structure changes"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "caa93662",
   "metadata": {},
   "source": [
    "Load required libraries"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "id": "30775d75",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "pd.set_option('display.max_colwidth', None)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "f12146f5",
   "metadata": {},
   "source": [
    "### Load EPD data April 22  \n",
    "Get\n",
    "1) DF of unique STP code / STP name  \n",
    "2) DF of unique PCO code / PCO name"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "id": "c41d9f1a",
   "metadata": {},
   "outputs": [],
   "source": [
    "dfApr = pd.read_csv('epd_202204.csv')\n",
    "dfSTP = dfApr[['STP_CODE', 'STP_NAME']].drop_duplicates()\n",
    "dfCCG = dfApr[['STP_CODE', 'STP_NAME', 'PCO_NAME', 'PCO_CODE']].drop_duplicates()\n",
    "del dfApr"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "c9b5c281",
   "metadata": {},
   "source": [
    "### Load EPD data May 22  \n",
    "Get\n",
    "1) DF of unique ICB code / ICB name  \n",
    "2) DF of unique PCO code / PCO name"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "id": "0f431e5d",
   "metadata": {},
   "outputs": [],
   "source": [
    "dfMay = pd.read_csv('epd_202205.csv')\n",
    "dfICB = dfMay[['ICB_CODE', 'ICB_NAME']].drop_duplicates()\n",
    "dfSICBL = dfMay[['ICB_CODE', 'ICB_NAME', 'PCO_NAME', 'PCO_CODE']].drop_duplicates()\n",
    "del dfMay"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "32aaeb86",
   "metadata": {},
   "source": [
    "## Merge STP to ICB\n",
    "Merge STP DF with ICB DF "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "id": "5ed46ef6",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>STP_CODE</th>\n",
       "      <th>STP_NAME</th>\n",
       "      <th>ICB_CODE</th>\n",
       "      <th>ICB_NAME</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>QMM</td>\n",
       "      <td>NORFOLK &amp; WAVENEY H&amp;C PARTNERSHIP STP</td>\n",
       "      <td>QMM</td>\n",
       "      <td>NHS NORFOLK AND WAVENEY INTEGRATED CARE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>QYG</td>\n",
       "      <td>CHESHIRE &amp; MERSEYSIDE STP</td>\n",
       "      <td>QYG</td>\n",
       "      <td>NHS CHESHIRE AND MERSEYSIDE INTEGRATED C</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>QOQ</td>\n",
       "      <td>HUMBER, COAST &amp; VALE STP</td>\n",
       "      <td>QOQ</td>\n",
       "      <td>NHS HUMBER AND NORTH YORKSHIRE INTEGRATE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>QK1</td>\n",
       "      <td>LEICESTER, LEICESTERSHIRE &amp; RUTLAND STP</td>\n",
       "      <td>QK1</td>\n",
       "      <td>NHS LEICESTER, LEICESTERSHIRE AND RUTLAN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>QU9</td>\n",
       "      <td>BUCKS, OXFORDSHIRE &amp; BERKSHIRE WEST STP</td>\n",
       "      <td>QU9</td>\n",
       "      <td>NHS BUCKINGHAMSHIRE, OXFORDSHIRE AND BER</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>QUY</td>\n",
       "      <td>BRISTOL, N SOMERSET &amp; S GLOUCS STP</td>\n",
       "      <td>QUY</td>\n",
       "      <td>NHS BRISTOL, NORTH SOMERSET AND SOUTH GL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>QOP</td>\n",
       "      <td>GREATER MANCHESTER HSC PARTNERSHIP STP</td>\n",
       "      <td>QOP</td>\n",
       "      <td>NHS GREATER MANCHESTER INTEGRATED CARE B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>QWE</td>\n",
       "      <td>SW LONDON HEALTH &amp; CARE PARTNERSHIP STP</td>\n",
       "      <td>QWE</td>\n",
       "      <td>NHS SOUTH WEST LONDON INTEGRATED CARE BO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>QE1</td>\n",
       "      <td>HEALTHIER LANCASHIRE &amp; SOUTH CUMBRIA STP</td>\n",
       "      <td>QE1</td>\n",
       "      <td>NHS LANCASHIRE AND SOUTH CUMBRIA INTEGRA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>QHM</td>\n",
       "      <td>CUMBRIA &amp; NORTH EAST STP</td>\n",
       "      <td>QHM</td>\n",
       "      <td>NHS NORTH EAST AND NORTH CUMBRIA INTEGRA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>QRL</td>\n",
       "      <td>HAMPSHIRE &amp; THE ISLE OF WIGHT STP</td>\n",
       "      <td>QRL</td>\n",
       "      <td>NHS HAMPSHIRE AND ISLE OF WIGHT INTEGRAT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>QUA</td>\n",
       "      <td>THE BLACK COUNTRY &amp; WEST BIRMINGHAM STP</td>\n",
       "      <td>QUA</td>\n",
       "      <td>NHS BLACK COUNTRY INTEGRATED CARE BOARD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>QHG</td>\n",
       "      <td>BEDFORDSHIRE, LUTON &amp; MILTON KEYNES STP</td>\n",
       "      <td>QHG</td>\n",
       "      <td>NHS BEDFORDSHIRE, LUTON AND MILTON KEYNE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>QXU</td>\n",
       "      <td>SURREY HEARTLANDS H&amp;C PARTNERSHIP STP</td>\n",
       "      <td>QXU</td>\n",
       "      <td>NHS SURREY HEARTLANDS INTEGRATED CARE BO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>QRV</td>\n",
       "      <td>NW LONDON HEALTH &amp; CARE PARTNERSHIP STP</td>\n",
       "      <td>QRV</td>\n",
       "      <td>NHS NORTH WEST LONDON INTEGRATED CARE BO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>QMJ</td>\n",
       "      <td>NORTH LONDON PARTNERS IN H&amp;C STP</td>\n",
       "      <td>QMJ</td>\n",
       "      <td>NHS NORTH CENTRAL LONDON INTEGRATED CARE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>QUE</td>\n",
       "      <td>CAMBRIDGESHIRE &amp; PETERBOROUGH STP</td>\n",
       "      <td>QUE</td>\n",
       "      <td>NHS CAMBRIDGESHIRE AND PETERBOROUGH INTE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>QT6</td>\n",
       "      <td>CORNWALL &amp; SCILLY ISLES HSC P/SHIP STP</td>\n",
       "      <td>QT6</td>\n",
       "      <td>NHS CORNWALL AND THE ISLES OF SCILLY INT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>QMF</td>\n",
       "      <td>EAST LONDON HEALTH &amp; CARE P/SHIP STP</td>\n",
       "      <td>QMF</td>\n",
       "      <td>NHS NORTH EAST LONDON INTEGRATED CARE BO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>QWO</td>\n",
       "      <td>W YORKSHIRE &amp; HARROGATE H&amp;C P/SHIP STP</td>\n",
       "      <td>QWO</td>\n",
       "      <td>NHS WEST YORKSHIRE INTEGRATED CARE BOARD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>QKK</td>\n",
       "      <td>OUR HEALTHIER SOUTH EAST LONDON STP</td>\n",
       "      <td>QKK</td>\n",
       "      <td>NHS SOUTH EAST LONDON INTEGRATED CARE BO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>QVV</td>\n",
       "      <td>DORSET STP</td>\n",
       "      <td>QVV</td>\n",
       "      <td>NHS DORSET INTEGRATED CARE BOARD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>QWU</td>\n",
       "      <td>COVENTRY &amp; WARWICKSHIRE STP</td>\n",
       "      <td>QWU</td>\n",
       "      <td>NHS COVENTRY AND WARWICKSHIRE INTEGRATED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>QNC</td>\n",
       "      <td>STAFFORDSHIRE &amp; STOKE ON TRENT STP</td>\n",
       "      <td>QNC</td>\n",
       "      <td>NHS STAFFORDSHIRE AND STOKE-ON-TRENT INT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>QNX</td>\n",
       "      <td>SUSSEX &amp; EAST SURREY STP</td>\n",
       "      <td>QNX</td>\n",
       "      <td>NHS SUSSEX INTEGRATED CARE BOARD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>QKS</td>\n",
       "      <td>KENT &amp; MEDWAY STP</td>\n",
       "      <td>QKS</td>\n",
       "      <td>NHS KENT AND MEDWAY INTEGRATED CARE BOAR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>QNQ</td>\n",
       "      <td>FRIMLEY HEALTH &amp; CARE ICS STP</td>\n",
       "      <td>QNQ</td>\n",
       "      <td>NHS FRIMLEY INTEGRATED CARE BOARD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>QJK</td>\n",
       "      <td>DEVON STP</td>\n",
       "      <td>QJK</td>\n",
       "      <td>NHS DEVON INTEGRATED CARE BOARD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>QM7</td>\n",
       "      <td>HERTFORDSHIRE &amp; WEST ESSEX STP</td>\n",
       "      <td>QM7</td>\n",
       "      <td>NHS HERTFORDSHIRE AND WEST ESSEX INTEGRA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>QH8</td>\n",
       "      <td>MID AND SOUTH ESSEX STP</td>\n",
       "      <td>QH8</td>\n",
       "      <td>NHS MID AND SOUTH ESSEX INTEGRATED CARE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>QPM</td>\n",
       "      <td>NORTHAMPTONSHIRE STP</td>\n",
       "      <td>QPM</td>\n",
       "      <td>NHS NORTHAMPTONSHIRE INTEGRATED CARE BOA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>QT1</td>\n",
       "      <td>NOTTINGHAM &amp; NOTTINGHAMSHIRE H&amp;C STP</td>\n",
       "      <td>QT1</td>\n",
       "      <td>NHS NOTTINGHAM AND NOTTINGHAMSHIRE INTEG</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>QGH</td>\n",
       "      <td>HEREFORDSHIRE &amp; WORCESTERSHIRE STP</td>\n",
       "      <td>QGH</td>\n",
       "      <td>NHS HEREFORDSHIRE AND WORCESTERSHIRE INT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>QSL</td>\n",
       "      <td>SOMERSET STP</td>\n",
       "      <td>QSL</td>\n",
       "      <td>NHS SOMERSET INTEGRATED CARE BOARD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>QOX</td>\n",
       "      <td>BATH &amp; NE SOMERSET, SWINDON &amp; WILTS STP</td>\n",
       "      <td>QOX</td>\n",
       "      <td>NHS BATH AND NORTH EAST SOMERSET, SWINDO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>QJM</td>\n",
       "      <td>LINCOLNSHIRE STP</td>\n",
       "      <td>QJM</td>\n",
       "      <td>NHS LINCOLNSHIRE INTEGRATED CARE BOARD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>QR1</td>\n",
       "      <td>GLOUCESTERSHIRE STP</td>\n",
       "      <td>QR1</td>\n",
       "      <td>NHS GLOUCESTERSHIRE INTEGRATED CARE BOAR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>QJ2</td>\n",
       "      <td>JOINED UP CARE DERBYSHIRE STP</td>\n",
       "      <td>QJ2</td>\n",
       "      <td>NHS DERBY AND DERBYSHIRE INTEGRATED CARE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>QHL</td>\n",
       "      <td>BIRMINGHAM &amp; SOLIHULL STP</td>\n",
       "      <td>QHL</td>\n",
       "      <td>NHS BIRMINGHAM AND SOLIHULL INTEGRATED C</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>QF7</td>\n",
       "      <td>SOUTH YORKSHIRE &amp; BASSETLAW STP</td>\n",
       "      <td>QF7</td>\n",
       "      <td>NHS SOUTH YORKSHIRE INTEGRATED CARE BOAR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>QJG</td>\n",
       "      <td>SUFFOLK &amp; NORTH EAST ESSEX STP</td>\n",
       "      <td>QJG</td>\n",
       "      <td>NHS SUFFOLK AND NORTH EAST ESSEX INTEGRA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>QOC</td>\n",
       "      <td>SHROPSHIRE &amp; TELFORD &amp; WREKIN STP</td>\n",
       "      <td>QOC</td>\n",
       "      <td>NHS SHROPSHIRE, TELFORD AND WREKIN INTEG</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>-</td>\n",
       "      <td>UNIDENTIFIED</td>\n",
       "      <td>-</td>\n",
       "      <td>UNIDENTIFIED</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   STP_CODE                                  STP_NAME ICB_CODE  \\\n",
       "0       QMM     NORFOLK & WAVENEY H&C PARTNERSHIP STP      QMM   \n",
       "1       QYG                 CHESHIRE & MERSEYSIDE STP      QYG   \n",
       "2       QOQ                  HUMBER, COAST & VALE STP      QOQ   \n",
       "3       QK1   LEICESTER, LEICESTERSHIRE & RUTLAND STP      QK1   \n",
       "4       QU9   BUCKS, OXFORDSHIRE & BERKSHIRE WEST STP      QU9   \n",
       "5       QUY        BRISTOL, N SOMERSET & S GLOUCS STP      QUY   \n",
       "6       QOP    GREATER MANCHESTER HSC PARTNERSHIP STP      QOP   \n",
       "7       QWE   SW LONDON HEALTH & CARE PARTNERSHIP STP      QWE   \n",
       "8       QE1  HEALTHIER LANCASHIRE & SOUTH CUMBRIA STP      QE1   \n",
       "9       QHM                  CUMBRIA & NORTH EAST STP      QHM   \n",
       "10      QRL         HAMPSHIRE & THE ISLE OF WIGHT STP      QRL   \n",
       "11      QUA   THE BLACK COUNTRY & WEST BIRMINGHAM STP      QUA   \n",
       "12      QHG   BEDFORDSHIRE, LUTON & MILTON KEYNES STP      QHG   \n",
       "13      QXU     SURREY HEARTLANDS H&C PARTNERSHIP STP      QXU   \n",
       "14      QRV   NW LONDON HEALTH & CARE PARTNERSHIP STP      QRV   \n",
       "15      QMJ          NORTH LONDON PARTNERS IN H&C STP      QMJ   \n",
       "16      QUE         CAMBRIDGESHIRE & PETERBOROUGH STP      QUE   \n",
       "17      QT6    CORNWALL & SCILLY ISLES HSC P/SHIP STP      QT6   \n",
       "18      QMF      EAST LONDON HEALTH & CARE P/SHIP STP      QMF   \n",
       "19      QWO    W YORKSHIRE & HARROGATE H&C P/SHIP STP      QWO   \n",
       "20      QKK       OUR HEALTHIER SOUTH EAST LONDON STP      QKK   \n",
       "21      QVV                                DORSET STP      QVV   \n",
       "22      QWU               COVENTRY & WARWICKSHIRE STP      QWU   \n",
       "23      QNC        STAFFORDSHIRE & STOKE ON TRENT STP      QNC   \n",
       "24      QNX                  SUSSEX & EAST SURREY STP      QNX   \n",
       "25      QKS                         KENT & MEDWAY STP      QKS   \n",
       "26      QNQ             FRIMLEY HEALTH & CARE ICS STP      QNQ   \n",
       "27      QJK                                 DEVON STP      QJK   \n",
       "28      QM7            HERTFORDSHIRE & WEST ESSEX STP      QM7   \n",
       "29      QH8                   MID AND SOUTH ESSEX STP      QH8   \n",
       "30      QPM                      NORTHAMPTONSHIRE STP      QPM   \n",
       "31      QT1      NOTTINGHAM & NOTTINGHAMSHIRE H&C STP      QT1   \n",
       "32      QGH        HEREFORDSHIRE & WORCESTERSHIRE STP      QGH   \n",
       "33      QSL                              SOMERSET STP      QSL   \n",
       "34      QOX   BATH & NE SOMERSET, SWINDON & WILTS STP      QOX   \n",
       "35      QJM                          LINCOLNSHIRE STP      QJM   \n",
       "36      QR1                       GLOUCESTERSHIRE STP      QR1   \n",
       "37      QJ2             JOINED UP CARE DERBYSHIRE STP      QJ2   \n",
       "38      QHL                 BIRMINGHAM & SOLIHULL STP      QHL   \n",
       "39      QF7           SOUTH YORKSHIRE & BASSETLAW STP      QF7   \n",
       "40      QJG            SUFFOLK & NORTH EAST ESSEX STP      QJG   \n",
       "41      QOC         SHROPSHIRE & TELFORD & WREKIN STP      QOC   \n",
       "42        -                              UNIDENTIFIED        -   \n",
       "\n",
       "                                    ICB_NAME  \n",
       "0   NHS NORFOLK AND WAVENEY INTEGRATED CARE   \n",
       "1   NHS CHESHIRE AND MERSEYSIDE INTEGRATED C  \n",
       "2   NHS HUMBER AND NORTH YORKSHIRE INTEGRATE  \n",
       "3   NHS LEICESTER, LEICESTERSHIRE AND RUTLAN  \n",
       "4   NHS BUCKINGHAMSHIRE, OXFORDSHIRE AND BER  \n",
       "5   NHS BRISTOL, NORTH SOMERSET AND SOUTH GL  \n",
       "6   NHS GREATER MANCHESTER INTEGRATED CARE B  \n",
       "7   NHS SOUTH WEST LONDON INTEGRATED CARE BO  \n",
       "8   NHS LANCASHIRE AND SOUTH CUMBRIA INTEGRA  \n",
       "9   NHS NORTH EAST AND NORTH CUMBRIA INTEGRA  \n",
       "10  NHS HAMPSHIRE AND ISLE OF WIGHT INTEGRAT  \n",
       "11   NHS BLACK COUNTRY INTEGRATED CARE BOARD  \n",
       "12  NHS BEDFORDSHIRE, LUTON AND MILTON KEYNE  \n",
       "13  NHS SURREY HEARTLANDS INTEGRATED CARE BO  \n",
       "14  NHS NORTH WEST LONDON INTEGRATED CARE BO  \n",
       "15  NHS NORTH CENTRAL LONDON INTEGRATED CARE  \n",
       "16  NHS CAMBRIDGESHIRE AND PETERBOROUGH INTE  \n",
       "17  NHS CORNWALL AND THE ISLES OF SCILLY INT  \n",
       "18  NHS NORTH EAST LONDON INTEGRATED CARE BO  \n",
       "19  NHS WEST YORKSHIRE INTEGRATED CARE BOARD  \n",
       "20  NHS SOUTH EAST LONDON INTEGRATED CARE BO  \n",
       "21          NHS DORSET INTEGRATED CARE BOARD  \n",
       "22  NHS COVENTRY AND WARWICKSHIRE INTEGRATED  \n",
       "23  NHS STAFFORDSHIRE AND STOKE-ON-TRENT INT  \n",
       "24          NHS SUSSEX INTEGRATED CARE BOARD  \n",
       "25  NHS KENT AND MEDWAY INTEGRATED CARE BOAR  \n",
       "26         NHS FRIMLEY INTEGRATED CARE BOARD  \n",
       "27           NHS DEVON INTEGRATED CARE BOARD  \n",
       "28  NHS HERTFORDSHIRE AND WEST ESSEX INTEGRA  \n",
       "29  NHS MID AND SOUTH ESSEX INTEGRATED CARE   \n",
       "30  NHS NORTHAMPTONSHIRE INTEGRATED CARE BOA  \n",
       "31  NHS NOTTINGHAM AND NOTTINGHAMSHIRE INTEG  \n",
       "32  NHS HEREFORDSHIRE AND WORCESTERSHIRE INT  \n",
       "33        NHS SOMERSET INTEGRATED CARE BOARD  \n",
       "34  NHS BATH AND NORTH EAST SOMERSET, SWINDO  \n",
       "35    NHS LINCOLNSHIRE INTEGRATED CARE BOARD  \n",
       "36  NHS GLOUCESTERSHIRE INTEGRATED CARE BOAR  \n",
       "37  NHS DERBY AND DERBYSHIRE INTEGRATED CARE  \n",
       "38  NHS BIRMINGHAM AND SOLIHULL INTEGRATED C  \n",
       "39  NHS SOUTH YORKSHIRE INTEGRATED CARE BOAR  \n",
       "40  NHS SUFFOLK AND NORTH EAST ESSEX INTEGRA  \n",
       "41  NHS SHROPSHIRE, TELFORD AND WREKIN INTEG  \n",
       "42                              UNIDENTIFIED  "
      ]
     },
     "execution_count": 45,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_merge = pd.merge(dfSTP, dfICB, left_on='STP_CODE', right_on='ICB_CODE')\n",
    "df_merge"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "ef221b21",
   "metadata": {},
   "source": [
    "All old STP names have corresponding ICB name with identical CODE."
   ]
  },
  {
   "cell_type": "markdown",
   "id": "318f1e10",
   "metadata": {},
   "source": [
    "### Check counts of STP / ICB and merge are the same"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "id": "2d0a9d46",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "43"
      ]
     },
     "execution_count": 46,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(dfSTP.index)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "id": "e2ee14ce",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "43"
      ]
     },
     "execution_count": 47,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(dfICB.index)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "id": "bd842d48",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "43"
      ]
     },
     "execution_count": 48,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(df_merge.index)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "99286be8",
   "metadata": {},
   "source": [
    "Count of all 3 are identical. No new/removed ICB / STP codes."
   ]
  },
  {
   "cell_type": "markdown",
   "id": "d901645f",
   "metadata": {},
   "source": [
    "---"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "b2ba8cd7",
   "metadata": {},
   "source": [
    "### Merge on PCO code May 22 onto April 22"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "id": "0d23d078",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>PCO_NAME_x</th>\n",
       "      <th>PCO_CODE</th>\n",
       "      <th>PCO_NAME_y</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>NORFOLK AND WAVENEY CCG</td>\n",
       "      <td>26A00</td>\n",
       "      <td>NHS NORFOLK AND WAVENEY ICB - 26A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>KNOWSLEY CCG</td>\n",
       "      <td>01J00</td>\n",
       "      <td>NHS CHESHIRE AND MERSEYSIDE ICB - 01J</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>VALE OF YORK CCG</td>\n",
       "      <td>03Q00</td>\n",
       "      <td>NHS HUMBER AND NORTH YORKSHIRE ICB - 03Q</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>SOUTH SEFTON CCG</td>\n",
       "      <td>01T00</td>\n",
       "      <td>NHS CHESHIRE AND MERSEYSIDE ICB - 01T</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>CHESHIRE CCG</td>\n",
       "      <td>27D00</td>\n",
       "      <td>NHS CHESHIRE AND MERSEYSIDE ICB - 27D</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>WEST LEICESTERSHIRE CCG</td>\n",
       "      <td>04V00</td>\n",
       "      <td>NHS LEICESTER, LEICESTERSHIRE AND RUTLAN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>ST HELENS CCG</td>\n",
       "      <td>01X00</td>\n",
       "      <td>NHS CHESHIRE AND MERSEYSIDE ICB - 01X</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>BERKSHIRE WEST CCG</td>\n",
       "      <td>15A00</td>\n",
       "      <td>NHS BUCKINGHAMSHIRE, OXFORDSHIRE AND BER</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>BRISTOL, NORTH SOMERSET &amp; S GLOS CCG</td>\n",
       "      <td>15C00</td>\n",
       "      <td>NHS BRISTOL, NORTH SOMERSET AND SOUTH GL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>BURY CCG</td>\n",
       "      <td>00V00</td>\n",
       "      <td>NHS GREATER MANCHESTER ICB - 00V</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>SOUTH WEST LONDON CCG</td>\n",
       "      <td>36L00</td>\n",
       "      <td>NHS SOUTH WEST LONDON ICB - 36L</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>MORECAMBE BAY CCG</td>\n",
       "      <td>01K00</td>\n",
       "      <td>NHS LANCASHIRE AND SOUTH CUMBRIA ICB - 0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>NORTHUMBERLAND CCG</td>\n",
       "      <td>00L00</td>\n",
       "      <td>NHS NORTH EAST AND NORTH CUMBRIA ICB - 0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>HAMPSHIRE,SOUTHAMPTON &amp;ISLE OF WIGHT CCG</td>\n",
       "      <td>D9Y0V</td>\n",
       "      <td>NHS HAMPSHIRE AND ISLE OF WIGHT ICB - D9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>BLACK COUNTRY AND WEST BIRMINGHAM CCG</td>\n",
       "      <td>D2P2L</td>\n",
       "      <td>NHS BLACK COUNTRY ICB - D2P2L</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>BEDFORDSHIRE, LUTON &amp; MILTON KEYNES CCG</td>\n",
       "      <td>M1J4Y</td>\n",
       "      <td>NHS BEDFORDSHIRE, LUTON AND MILTON KEYNE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>LIVERPOOL CCG</td>\n",
       "      <td>99A00</td>\n",
       "      <td>NHS CHESHIRE AND MERSEYSIDE ICB - 99A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>SOUTHPORT AND FORMBY CCG</td>\n",
       "      <td>01V00</td>\n",
       "      <td>NHS CHESHIRE AND MERSEYSIDE ICB - 01V</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>SURREY HEARTLANDS CCG</td>\n",
       "      <td>92A00</td>\n",
       "      <td>NHS SURREY HEARTLANDS  ICB - 92A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>OXFORDSHIRE CCG</td>\n",
       "      <td>10Q00</td>\n",
       "      <td>NHS BUCKINGHAMSHIRE, OXFORDSHIRE AND BER</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>FYLDE &amp; WYRE CCG</td>\n",
       "      <td>02M00</td>\n",
       "      <td>NHS LANCASHIRE AND SOUTH CUMBRIA ICB - 0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>NORTH WEST LONDON CCG</td>\n",
       "      <td>W2U3Z</td>\n",
       "      <td>NHS NORTH WEST LONDON ICB - W2U3Z</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>LCWUCC</td>\n",
       "      <td>NKB00</td>\n",
       "      <td>LONDON CENTRAL AND WEST UNSCHEDULED CARE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>NORTH CENTRAL LONDON CCG</td>\n",
       "      <td>93C00</td>\n",
       "      <td>NHS NORTH CENTRAL LONDON ICB - 93C</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>GREENBROOK HEALTHCARE</td>\n",
       "      <td>AD900</td>\n",
       "      <td>GREENBROOK HEALTHCARE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>NORTH TYNESIDE CCG</td>\n",
       "      <td>99C00</td>\n",
       "      <td>NHS NORTH EAST AND NORTH CUMBRIA ICB - 9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>EAST LANCASHIRE CCG</td>\n",
       "      <td>01A00</td>\n",
       "      <td>NHS LANCASHIRE AND SOUTH CUMBRIA ICB - 0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>CAMBRIDGESHIRE AND PETERBOROUGH CCG</td>\n",
       "      <td>06H00</td>\n",
       "      <td>NHS CAMBRIDGESHIRE AND PETERBOROUGH ICB</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>BLACKBURN WITH DARWEN CCG</td>\n",
       "      <td>00Q00</td>\n",
       "      <td>NHS LANCASHIRE AND SOUTH CUMBRIA ICB - 0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>BLACKPOOL CCG</td>\n",
       "      <td>00R00</td>\n",
       "      <td>NHS LANCASHIRE AND SOUTH CUMBRIA ICB - 0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>CHORLEY AND SOUTH RIBBLE CCG</td>\n",
       "      <td>00X00</td>\n",
       "      <td>NHS LANCASHIRE AND SOUTH CUMBRIA ICB - 0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>BOLTON CCG</td>\n",
       "      <td>00T00</td>\n",
       "      <td>NHS GREATER MANCHESTER ICB - 00T</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>WEST LANCASHIRE CCG</td>\n",
       "      <td>02G00</td>\n",
       "      <td>NHS LANCASHIRE AND SOUTH CUMBRIA ICB - 0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>PDS MEDICAL LTD</td>\n",
       "      <td>NV600</td>\n",
       "      <td>PDS MEDICAL LTD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>NORTHUMBRIA H/CARE NHS FOUNDATION TRUST</td>\n",
       "      <td>RTF00</td>\n",
       "      <td>NORTHUMBRIA HEALTHCARE NHS FOUNDATION TR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>KERNOW CCG</td>\n",
       "      <td>11N00</td>\n",
       "      <td>NHS CORNWALL AND THE ISLES OF SCILLY ICB</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>NTH TEES&amp;HARTLEPOOL NHS FOUNDATION TRUST</td>\n",
       "      <td>RVW00</td>\n",
       "      <td>NORTH TEES AND HARTLEPOOL NHS FOUNDATION</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>SOUTH TEES HOSP NHS FOUNDATION TRUST</td>\n",
       "      <td>RTR00</td>\n",
       "      <td>SOUTH TEES HOSPITALS NHS FOUNDATION TRUS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>REDCAR AND CLEVELAND LOCAL AUTHORITY</td>\n",
       "      <td>11300</td>\n",
       "      <td>REDCAR AND CLEVELAND BOROUGH COUNCIL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>NORTH EAST LONDON CCG</td>\n",
       "      <td>A3A8R</td>\n",
       "      <td>NHS NORTH EAST LONDON ICB - A3A8R</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>KIRKLEES CCG</td>\n",
       "      <td>X2C4Y</td>\n",
       "      <td>NHS WEST YORKSHIRE ICB - X2C4Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>SIRONA CARE AND HEALTH CIC</td>\n",
       "      <td>NLX00</td>\n",
       "      <td>SIRONA CARE AND HEALTH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>SOUTH EAST LONDON CCG</td>\n",
       "      <td>72Q00</td>\n",
       "      <td>NHS SOUTH EAST LONDON ICB - 72Q</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>DORSET CCG</td>\n",
       "      <td>11J00</td>\n",
       "      <td>NHS DORSET ICB - 11J</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>SOUTH TYNESIDE AND SUNDERLAND NHS FT</td>\n",
       "      <td>R0B00</td>\n",
       "      <td>SOUTH TYNESIDE AND SUNDERLAND NHS FOUNDA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>SOUTH TYNESIDE CCG</td>\n",
       "      <td>00N00</td>\n",
       "      <td>NHS NORTH EAST AND NORTH CUMBRIA ICB - 0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>SOMERSET SURGICAL SERVICES</td>\n",
       "      <td>NFH00</td>\n",
       "      <td>SOMERSET SURGICAL SERVICES HQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>WESTON HOSPICECARE</td>\n",
       "      <td>DLD00</td>\n",
       "      <td>WESTON HOSPICECARE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>WIGAN BOROUGH CCG</td>\n",
       "      <td>02H00</td>\n",
       "      <td>NHS GREATER MANCHESTER ICB - 02H</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>TRAFFORD CCG</td>\n",
       "      <td>02A00</td>\n",
       "      <td>NHS GREATER MANCHESTER ICB - 02A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>HALTON CCG</td>\n",
       "      <td>01F00</td>\n",
       "      <td>NHS CHESHIRE AND MERSEYSIDE ICB - 01F</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>BUCKINGHAMSHIRE CCG</td>\n",
       "      <td>14Y00</td>\n",
       "      <td>NHS BUCKINGHAMSHIRE, OXFORDSHIRE AND BER</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>COVENTRY AND WARWICKSHIRE CCG</td>\n",
       "      <td>B2M3M</td>\n",
       "      <td>NHS COVENTRY AND WARWICKSHIRE ICB - B2M3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>SE STAFFS &amp; SEISDON PENINSULAR CCG</td>\n",
       "      <td>05Q00</td>\n",
       "      <td>NHS STAFFORDSHIRE AND STOKE-ON-TRENT ICB</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>HCRG CARE SERVICES LTD</td>\n",
       "      <td>NDA00</td>\n",
       "      <td>HCRG CARE SERVICES LTD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>HCRG CARE LTD</td>\n",
       "      <td>NQT00</td>\n",
       "      <td>HCRG CARE LTD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>ISIGHT</td>\n",
       "      <td>NCR00</td>\n",
       "      <td>ISIGHT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>BRISTOL, N SOMERSET &amp; S GLOUCS STP</td>\n",
       "      <td>QUY00</td>\n",
       "      <td>NHS BRISTOL, NORTH SOMERSET AND SOUTH GL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>UNIVERSITY HOSPITALS PLYMOUTH NHS TRUST</td>\n",
       "      <td>RK900</td>\n",
       "      <td>UNIVERSITY HOSPITALS PLYMOUTH NHS TRUST</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>BRISDOC HEALTHCARE SERVICES LTD</td>\n",
       "      <td>NBP00</td>\n",
       "      <td>BRISDOC HEALTHCARE SERVICES LTD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>PSYCHIATRY-UK</td>\n",
       "      <td>DQT00</td>\n",
       "      <td>PSYCHIATRY-UK</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>CANNOCK CHASE CCG</td>\n",
       "      <td>04Y00</td>\n",
       "      <td>NHS STAFFORDSHIRE AND STOKE-ON-TRENT ICB</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62</th>\n",
       "      <td>LEEDS CCG</td>\n",
       "      <td>15F00</td>\n",
       "      <td>NHS WEST YORKSHIRE ICB - 15F</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63</th>\n",
       "      <td>WEST SUSSEX CCG</td>\n",
       "      <td>70F00</td>\n",
       "      <td>NHS SUSSEX ICB - 70F</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64</th>\n",
       "      <td>KENT AND MEDWAY CCG</td>\n",
       "      <td>91Q00</td>\n",
       "      <td>NHS KENT AND MEDWAY ICB - 91Q</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>FRIMLEY CCG</td>\n",
       "      <td>D4U1Y</td>\n",
       "      <td>NHS FRIMLEY ICB - D4U1Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>66</th>\n",
       "      <td>OLDHAM CCG</td>\n",
       "      <td>00Y00</td>\n",
       "      <td>NHS GREATER MANCHESTER ICB - 00Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>67</th>\n",
       "      <td>MANCHESTER CCG</td>\n",
       "      <td>14L00</td>\n",
       "      <td>NHS GREATER MANCHESTER ICB - 14L</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68</th>\n",
       "      <td>NORTH CUMBRIA CCG</td>\n",
       "      <td>01H00</td>\n",
       "      <td>NHS NORTH EAST AND NORTH CUMBRIA ICB - 0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69</th>\n",
       "      <td>GTD HEALTHCARE IUCC</td>\n",
       "      <td>NW000</td>\n",
       "      <td>GTD HEALTHCARE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>HEYWOOD, MIDDLETON &amp; ROCHDALE CCG</td>\n",
       "      <td>01D00</td>\n",
       "      <td>NHS GREATER MANCHESTER ICB - 01D</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>DEVON CCG</td>\n",
       "      <td>15N00</td>\n",
       "      <td>NHS DEVON ICB - 15N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>LEICESTER CITY CCG</td>\n",
       "      <td>04C00</td>\n",
       "      <td>NHS LEICESTER, LEICESTERSHIRE AND RUTLAN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>HERTS VALLEYS CCG</td>\n",
       "      <td>06N00</td>\n",
       "      <td>NHS HERTFORDSHIRE AND WEST ESSEX ICB - 0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>SOUTHEND CCG</td>\n",
       "      <td>99G00</td>\n",
       "      <td>NHS MID AND SOUTH ESSEX ICB - 99G</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>NORTHAMPTONSHIRE CCG</td>\n",
       "      <td>78H00</td>\n",
       "      <td>NHS NORTHAMPTONSHIRE ICB - 78H</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>NOTTINGHAM AND NOTTINGHAMSHIRE CCG</td>\n",
       "      <td>52R00</td>\n",
       "      <td>NHS NOTTINGHAM AND NOTTINGHAMSHIRE ICB -</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>HEREFORDSHIRE AND WORCESTERSHIRE CCG</td>\n",
       "      <td>18C00</td>\n",
       "      <td>NHS HEREFORDSHIRE AND WORCESTERSHIRE ICB</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>BRADFORD DISTRICT AND CRAVEN CCG</td>\n",
       "      <td>36J00</td>\n",
       "      <td>NHS WEST YORKSHIRE ICB - 36J</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79</th>\n",
       "      <td>SOMERSET CCG</td>\n",
       "      <td>11X00</td>\n",
       "      <td>NHS SOMERSET ICB - 11X</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>BANES SWINDON AND WILTSHIRE CCG</td>\n",
       "      <td>92G00</td>\n",
       "      <td>NHS BATH AND NORTH EAST SOMERSET, SWINDO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81</th>\n",
       "      <td>MID ESSEX CCG</td>\n",
       "      <td>06Q00</td>\n",
       "      <td>NHS MID AND SOUTH ESSEX ICB - 06Q</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>SOMERSET NHS FOUNDATION TRUST</td>\n",
       "      <td>RH500</td>\n",
       "      <td>SOMERSET NHS FOUNDATION TRUST</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>SUNDERLAND CCG</td>\n",
       "      <td>00P00</td>\n",
       "      <td>NHS NORTH EAST AND NORTH CUMBRIA ICB - 0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>LINCOLNSHIRE CCG</td>\n",
       "      <td>71E00</td>\n",
       "      <td>NHS LINCOLNSHIRE ICB - 71E</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>PORTSMOUTH CCG</td>\n",
       "      <td>10R00</td>\n",
       "      <td>NHS HAMPSHIRE AND ISLE OF WIGHT ICB - 10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>86</th>\n",
       "      <td>HULL CCG</td>\n",
       "      <td>03F00</td>\n",
       "      <td>NHS HUMBER AND NORTH YORKSHIRE ICB - 03F</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>87</th>\n",
       "      <td>EAST RIDING OF YORKSHIRE CCG</td>\n",
       "      <td>02Y00</td>\n",
       "      <td>NHS HUMBER AND NORTH YORKSHIRE ICB - 02Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88</th>\n",
       "      <td>TEES VALLEY CCG</td>\n",
       "      <td>16C00</td>\n",
       "      <td>NHS NORTH EAST AND NORTH CUMBRIA ICB - 1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89</th>\n",
       "      <td>NORTH YORKSHIRE CCG</td>\n",
       "      <td>42D00</td>\n",
       "      <td>NHS HUMBER AND NORTH YORKSHIRE ICB - 42D</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>DUDLEY GROUP NHS FOUNDATION TRUST</td>\n",
       "      <td>RNA00</td>\n",
       "      <td>THE DUDLEY GROUP NHS FOUNDATION TRUST</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91</th>\n",
       "      <td>SANDWELL AND WEST BIRMINGHAM HPLS TRUST</td>\n",
       "      <td>RXK00</td>\n",
       "      <td>SANDWELL AND WEST BIRMINGHAM HOSPITALS N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>GLOUCESTERSHIRE CCG</td>\n",
       "      <td>11M00</td>\n",
       "      <td>NHS GLOUCESTERSHIRE ICB - 11M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93</th>\n",
       "      <td>BLACK COUNTRY HEALTHCARE NHS FT</td>\n",
       "      <td>RQ400</td>\n",
       "      <td>BLACK COUNTRY HEALTHCARE NHS YORK AND SC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>THE ROYAL WOLVERHAMPTON NHS TRUST</td>\n",
       "      <td>RL400</td>\n",
       "      <td>THE ROYAL WOLVERHAMPTON NHS TRUST</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>THE BLACK COUNTRY &amp; WEST BIRMINGHAM STP</td>\n",
       "      <td>QUA00</td>\n",
       "      <td>NHS BLACK COUNTRY INTEGRATED CARE BOARD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>COVENTRY &amp; WARWICKSHIRE P/SHIP NHS TRUST</td>\n",
       "      <td>RYG00</td>\n",
       "      <td>COVENTRY AND WARWICKSHIRE PARTNERSHIP NH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97</th>\n",
       "      <td>SUNDERLAND CITY COUNCIL</td>\n",
       "      <td>11000</td>\n",
       "      <td>SUNDERLAND CITY COUNCIL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>98</th>\n",
       "      <td>DERBY &amp; DERBYSHIRE CCG</td>\n",
       "      <td>15M00</td>\n",
       "      <td>NHS DERBY AND DERBYSHIRE ICB - 15M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99</th>\n",
       "      <td>COUNTY DURHAM CCG</td>\n",
       "      <td>84H00</td>\n",
       "      <td>NHS NORTH EAST AND NORTH CUMBRIA ICB - 8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>100</th>\n",
       "      <td>BIRMINGHAM AND SOLIHULL CCG</td>\n",
       "      <td>15E00</td>\n",
       "      <td>NHS BIRMINGHAM AND SOLIHULL ICB - 15E</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101</th>\n",
       "      <td>SALFORD CCG</td>\n",
       "      <td>01G00</td>\n",
       "      <td>NHS GREATER MANCHESTER ICB - 01G</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>102</th>\n",
       "      <td>MANCHESTER UNIVERSITY NHS FT</td>\n",
       "      <td>R0A00</td>\n",
       "      <td>MANCHESTER UNIVERSITY NHS FOUNDATION TRU</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>103</th>\n",
       "      <td>NEWCASTLE GATESHEAD CCG</td>\n",
       "      <td>13T00</td>\n",
       "      <td>NHS NORTH EAST AND NORTH CUMBRIA ICB - 1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>104</th>\n",
       "      <td>SHEFFIELD CCG</td>\n",
       "      <td>03N00</td>\n",
       "      <td>NHS SOUTH YORKSHIRE ICB - 03N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>105</th>\n",
       "      <td>ROTHERHAM CCG</td>\n",
       "      <td>03L00</td>\n",
       "      <td>NHS SOUTH YORKSHIRE ICB - 03L</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>106</th>\n",
       "      <td>WEST ESSEX CCG</td>\n",
       "      <td>07H00</td>\n",
       "      <td>NHS HERTFORDSHIRE AND WEST ESSEX ICB - 0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>107</th>\n",
       "      <td>CUMBRIA &amp; NORTH EAST STP</td>\n",
       "      <td>QHM00</td>\n",
       "      <td>NHS NORTH EAST AND NORTH CUMBRIA INTEGRA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>108</th>\n",
       "      <td>CUMBRIA,NORTHUMBERLAND,TYNE&amp;WEAR NHS FT</td>\n",
       "      <td>RX400</td>\n",
       "      <td>CUMBRIA,NORTHUMBERLAND,TYNE AND WEAR NHS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>109</th>\n",
       "      <td>DARLINGTON BOROUGH COUNCIL</td>\n",
       "      <td>11700</td>\n",
       "      <td>DARLINGTON BOROUGH COUNCIL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>110</th>\n",
       "      <td>DURHAM COUNTY COUNCIL</td>\n",
       "      <td>11600</td>\n",
       "      <td>DURHAM COUNTY COUNCIL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>111</th>\n",
       "      <td>GATESHEAD COUNCIL</td>\n",
       "      <td>10600</td>\n",
       "      <td>GATESHEAD METROPOLITAN BOROUGH COUNCIL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>112</th>\n",
       "      <td>MIDDLESBROUGH COUNCIL</td>\n",
       "      <td>11200</td>\n",
       "      <td>MIDDLESBROUGH BOROUGH COUNCIL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>113</th>\n",
       "      <td>HARTLEPOOL LOCAL AUTHORITY</td>\n",
       "      <td>11100</td>\n",
       "      <td>HARTLEPOOL BOROUGH COUNCIL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>114</th>\n",
       "      <td>HUMANKIND</td>\n",
       "      <td>AJ600</td>\n",
       "      <td>HUMANKIND</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115</th>\n",
       "      <td>NEWCASTLE CITY COUNCIL</td>\n",
       "      <td>10700</td>\n",
       "      <td>NEWCASTLE CITY COUNCIL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>116</th>\n",
       "      <td>WARRINGTON CCG</td>\n",
       "      <td>02E00</td>\n",
       "      <td>NHS CHESHIRE AND MERSEYSIDE ICB - 02E</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>117</th>\n",
       "      <td>EAST LEICESTERSHIRE AND RUTLAND CCG</td>\n",
       "      <td>03W00</td>\n",
       "      <td>NHS LEICESTER, LEICESTERSHIRE AND RUTLAN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>118</th>\n",
       "      <td>STOCKPORT CCG</td>\n",
       "      <td>01W00</td>\n",
       "      <td>NHS GREATER MANCHESTER ICB - 01W</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>119</th>\n",
       "      <td>HOMERTON UNIV HPL NHS FOUNDATION TRUST</td>\n",
       "      <td>RQX00</td>\n",
       "      <td>HOMERTON UNIVERSITY HOSPITAL NHS FOUNDAT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>120</th>\n",
       "      <td>LIVI</td>\n",
       "      <td>DYX00</td>\n",
       "      <td>LIVI</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>121</th>\n",
       "      <td>EAST AND NORTH HERTFORDSHIRE CCG</td>\n",
       "      <td>06K00</td>\n",
       "      <td>NHS HERTFORDSHIRE AND WEST ESSEX ICB - 0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>122</th>\n",
       "      <td>ST GEORGE'S UNIV HOSPS FOUNDATION NHST</td>\n",
       "      <td>RJ700</td>\n",
       "      <td>ST GEORGE'S UNIVERSITY HOSPITALS NHS FOU</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>123</th>\n",
       "      <td>SW LONDON HEALTH &amp; CARE PARTNERSHIP STP</td>\n",
       "      <td>QWE00</td>\n",
       "      <td>NHS SOUTH WEST LONDON INTEGRATED CARE BO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>124</th>\n",
       "      <td>BOLTON NHS FT</td>\n",
       "      <td>RMC00</td>\n",
       "      <td>BOLTON NHS FOUNDATION TRUST</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>125</th>\n",
       "      <td>WAKEFIELD CCG</td>\n",
       "      <td>03R00</td>\n",
       "      <td>NHS WEST YORKSHIRE ICB - 03R</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>126</th>\n",
       "      <td>STOKE ON TRENT CCG</td>\n",
       "      <td>05W00</td>\n",
       "      <td>NHS STAFFORDSHIRE AND STOKE-ON-TRENT ICB</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>127</th>\n",
       "      <td>CALDERDALE CCG</td>\n",
       "      <td>02T00</td>\n",
       "      <td>NHS WEST YORKSHIRE ICB - 02T</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>128</th>\n",
       "      <td>BRADFORD DISTRICT CARE NHS FT</td>\n",
       "      <td>RCE00</td>\n",
       "      <td>BRADFORD DISTRICT CARE NHS YORK AND SCAR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>129</th>\n",
       "      <td>WIRRAL CCG</td>\n",
       "      <td>12F00</td>\n",
       "      <td>NHS CHESHIRE AND MERSEYSIDE ICB - 12F</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>130</th>\n",
       "      <td>EAST SUSSEX CCG</td>\n",
       "      <td>97R00</td>\n",
       "      <td>NHS SUSSEX ICB - 97R</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>131</th>\n",
       "      <td>DEVON STP</td>\n",
       "      <td>QJK00</td>\n",
       "      <td>NHS DEVON INTEGRATED CARE BOARD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132</th>\n",
       "      <td>EDP DRUG AND ALCOHOL SERVICES</td>\n",
       "      <td>DWA00</td>\n",
       "      <td>EDP DRUG AND ALCOHOL SERVICES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>133</th>\n",
       "      <td>ROYAL DEVON UNIVERSITY HEALTHCARE NHSFT</td>\n",
       "      <td>RH800</td>\n",
       "      <td>ROYAL DEVON UNIVERSITY HEALTHCARE NHSFT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>134</th>\n",
       "      <td>LIVEWELL SOUTHWEST</td>\n",
       "      <td>NR500</td>\n",
       "      <td>LIVEWELL SOUTHWEST</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>135</th>\n",
       "      <td>SENTINEL HEALTHCARE SOUTHWEST CIC</td>\n",
       "      <td>NWE00</td>\n",
       "      <td>SENTINEL HEALTHCARE SOUTHWEST COMMUNITY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>136</th>\n",
       "      <td>WIRRAL COMMUNITY NHS FOUNDATION TRUST</td>\n",
       "      <td>RY700</td>\n",
       "      <td>WIRRAL COMMUNITY HEALTH AND CARE NHS FOU</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>137</th>\n",
       "      <td>SOUTH WESTERN AMBULANCE SERVICE NHS FT</td>\n",
       "      <td>RYF00</td>\n",
       "      <td>SOUTH WESTERN AMBULANCE SERVICE NHS FOUN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>138</th>\n",
       "      <td>TORBAY AND SOUTH DEVON NHS FOUNDATION TR</td>\n",
       "      <td>RA900</td>\n",
       "      <td>TORBAY AND SOUTH DEVON NHS FOUNDATION TR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>139</th>\n",
       "      <td>BARNSLEY CCG</td>\n",
       "      <td>02P00</td>\n",
       "      <td>NHS SOUTH YORKSHIRE ICB - 02P</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>140</th>\n",
       "      <td>BASSETLAW CCG</td>\n",
       "      <td>02Q00</td>\n",
       "      <td>NHS NOTTINGHAM AND NOTTINGHAMSHIRE ICB -</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>141</th>\n",
       "      <td>SOUTH CENTRAL AMBULANCE SERVICE NHS FT</td>\n",
       "      <td>RYE00</td>\n",
       "      <td>SOUTH CENTRAL AMBULANCE SERVICE NHS FOUN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>142</th>\n",
       "      <td>BRIGHTON &amp; HOVE CCG</td>\n",
       "      <td>09D00</td>\n",
       "      <td>NHS SUSSEX ICB - 09D</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>143</th>\n",
       "      <td>BASILDON AND BRENTWOOD CCG</td>\n",
       "      <td>99E00</td>\n",
       "      <td>NHS MID AND SOUTH ESSEX ICB - 99E</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>144</th>\n",
       "      <td>CASTLE POINT AND ROCHFORD CCG</td>\n",
       "      <td>99F00</td>\n",
       "      <td>NHS MID AND SOUTH ESSEX ICB - 99F</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>145</th>\n",
       "      <td>IPSWICH AND EAST SUFFOLK CCG</td>\n",
       "      <td>06L00</td>\n",
       "      <td>NHS SUFFOLK AND NORTH EAST ESSEX ICB - 0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>146</th>\n",
       "      <td>NORTH EAST ESSEX CCG</td>\n",
       "      <td>06T00</td>\n",
       "      <td>NHS SUFFOLK AND NORTH EAST ESSEX ICB - 0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>147</th>\n",
       "      <td>MEDWAY COMMUNITY HEALTHCARE CIC</td>\n",
       "      <td>NQ700</td>\n",
       "      <td>MEDWAY COMMUNITY HEALTHCARE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>148</th>\n",
       "      <td>KENT COMMUNITY HEALTH NHS FT</td>\n",
       "      <td>RYY00</td>\n",
       "      <td>KENT COMMUNITY HEALTH NHS FOUNDATION TRU</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>149</th>\n",
       "      <td>RDASH NHS FOUNDATION TRUST</td>\n",
       "      <td>RXE00</td>\n",
       "      <td>ROTHERHAM DONCASTER AND SOUTH HUMBER NHS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150</th>\n",
       "      <td>WHITSTABLE MEDICAL PRACTICE</td>\n",
       "      <td>ACH00</td>\n",
       "      <td>WHITSTABLE MEDICAL PRACTICE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>151</th>\n",
       "      <td>NEW HAYESBANK CLINICS</td>\n",
       "      <td>AC600</td>\n",
       "      <td>NEW HAYESBANK SURGERY CLINICS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>152</th>\n",
       "      <td>SYDENHAM HOUSE MEDICAL CENTRE</td>\n",
       "      <td>AAX00</td>\n",
       "      <td>SYDENHAM HOUSE MEDICAL PRACTICE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>153</th>\n",
       "      <td>SELLINDGE PRACTICE LIMITED</td>\n",
       "      <td>NNS00</td>\n",
       "      <td>SELLINDGE PRACTICE LTD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>154</th>\n",
       "      <td>THE HERNE BAY OPHTHALMOLOGY CLINIC</td>\n",
       "      <td>AC200</td>\n",
       "      <td>THE HERNE BAY OPHTHALMOLOGY CLINIC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>155</th>\n",
       "      <td>EAST STAFFORDSHIRE CCG</td>\n",
       "      <td>05D00</td>\n",
       "      <td>NHS STAFFORDSHIRE AND STOKE-ON-TRENT ICB</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>156</th>\n",
       "      <td>TAMESIDE AND GLOSSOP CCG</td>\n",
       "      <td>01Y00</td>\n",
       "      <td>NHS GREATER MANCHESTER ICB - 01Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>157</th>\n",
       "      <td>CHANGE, GROW, LIVE</td>\n",
       "      <td>NMS00</td>\n",
       "      <td>CHANGE, GROW, LIVE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>158</th>\n",
       "      <td>WEST SUFFOLK CCG</td>\n",
       "      <td>07K00</td>\n",
       "      <td>NHS SUFFOLK AND NORTH EAST ESSEX ICB - 0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>159</th>\n",
       "      <td>CONS EYE SURGEONS PARTNERSHIP (CANT) LLP</td>\n",
       "      <td>AER00</td>\n",
       "      <td>CONSULTANT EYE SURGEONS PARTNERSHIP (CAN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>160</th>\n",
       "      <td>NORTH STAFFS COMBINED HEALTHCARE TRUST</td>\n",
       "      <td>RLY00</td>\n",
       "      <td>NORTH STAFFORDSHIRE COMBINED HEALTHCARE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>161</th>\n",
       "      <td>NORTH STAFFORDSHIRE CCG</td>\n",
       "      <td>05G00</td>\n",
       "      <td>NHS STAFFORDSHIRE AND STOKE-ON-TRENT ICB</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>162</th>\n",
       "      <td>STOCKPORT METROPOLITAN BOROUGH COUNCIL</td>\n",
       "      <td>31000</td>\n",
       "      <td>STOCKPORT METROPOLITAN BOROUGH COUNCIL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>163</th>\n",
       "      <td>THURROCK CCG</td>\n",
       "      <td>07G00</td>\n",
       "      <td>NHS MID AND SOUTH ESSEX ICB - 07G</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>164</th>\n",
       "      <td>LINCOLNSHIRE COMM HEALTH SERV NHS TRUST</td>\n",
       "      <td>RY500</td>\n",
       "      <td>LINCOLNSHIRE COMMUNITY HEALTH SERVICES N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>165</th>\n",
       "      <td>RAMSAY HEALTHCARE UK OPERATIONS LIMITED</td>\n",
       "      <td>NVC00</td>\n",
       "      <td>RAMSAY HEALTHCARE UK OPERATIONS LIMITED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>166</th>\n",
       "      <td>EAST SUFFOLK AND NORTH ESSEX NHS FT</td>\n",
       "      <td>RDE00</td>\n",
       "      <td>EAST SUFFOLK AND NORTH ESSEX NHS FOUNDAT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>167</th>\n",
       "      <td>ESSEX PARTNERSHIP UNIVERSITY NHS FT</td>\n",
       "      <td>R1L00</td>\n",
       "      <td>ESSEX PARTNERSHIP UNIVERSITY NHS FOUNDAT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>168</th>\n",
       "      <td>BEDFORDSHIRE, LUTON &amp; MILTON KEYNES STP</td>\n",
       "      <td>QHG00</td>\n",
       "      <td>NHS BEDFORDSHIRE, LUTON AND MILTON KEYNE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>169</th>\n",
       "      <td>STAFFORD AND SURROUNDS CCG</td>\n",
       "      <td>05V00</td>\n",
       "      <td>NHS STAFFORDSHIRE AND STOKE-ON-TRENT ICB</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>170</th>\n",
       "      <td>NORTH CUMBRIA INTEGRATED CARE NHS FT</td>\n",
       "      <td>RNN00</td>\n",
       "      <td>NORTH CUMBRIA INTEGRATED CARE NHS FOUNDA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>171</th>\n",
       "      <td>STAFFORDSHIRE &amp; STOKE ON TRENT STP</td>\n",
       "      <td>QNC00</td>\n",
       "      <td>NHS STAFFORDSHIRE AND STOKE-ON-TRENT INT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>172</th>\n",
       "      <td>NORTH EAST AMBULANCE SERVICE NHS FT</td>\n",
       "      <td>RX600</td>\n",
       "      <td>NORTH EAST AMBULANCE SERVICE NHS FOUNDAT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>173</th>\n",
       "      <td>DONCASTER CCG</td>\n",
       "      <td>02X00</td>\n",
       "      <td>NHS SOUTH YORKSHIRE ICB - 02X</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>174</th>\n",
       "      <td>NORTH LINCOLNSHIRE CCG</td>\n",
       "      <td>03K00</td>\n",
       "      <td>NHS HUMBER AND NORTH YORKSHIRE ICB - 03K</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>175</th>\n",
       "      <td>NORTH EAST LINCOLNSHIRE CCG</td>\n",
       "      <td>03H00</td>\n",
       "      <td>NHS HUMBER AND NORTH YORKSHIRE ICB - 03H</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>176</th>\n",
       "      <td>NORTH YORKSHIRE COUNTY COUNCIL</td>\n",
       "      <td>21800</td>\n",
       "      <td>NORTH YORKSHIRE COUNTY COUNCIL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>177</th>\n",
       "      <td>MERSEY CARE NHS FOUNDATION TRUST</td>\n",
       "      <td>RW400</td>\n",
       "      <td>MERSEY CARE NHS FOUNDATION TRUST</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>178</th>\n",
       "      <td>LIVERPOOL UNIVERSITY HOSPITALS NHS FT</td>\n",
       "      <td>REM00</td>\n",
       "      <td>LIVERPOOL UNIVERSITY HOSPITALS NHS FOUND</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>179</th>\n",
       "      <td>NORFOLK COMMUNITY HLTH &amp; CARE NHS TRUST</td>\n",
       "      <td>RY300</td>\n",
       "      <td>NORFOLK COMMUNITY HEALTH AND CARE NHS TR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>180</th>\n",
       "      <td>CAMBRIDGESHIRE &amp; PETERBOROUGH STP</td>\n",
       "      <td>QUE00</td>\n",
       "      <td>NHS CAMBRIDGESHIRE AND PETERBOROUGH INTE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181</th>\n",
       "      <td>GREATER PRESTON CCG</td>\n",
       "      <td>01E00</td>\n",
       "      <td>NHS LANCASHIRE AND SOUTH CUMBRIA ICB - 0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>182</th>\n",
       "      <td>LONDON AMBULANCE SERVICE NHS TRUST</td>\n",
       "      <td>RRU00</td>\n",
       "      <td>LONDON AMBULANCE SERVICE NHS TRUST</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>183</th>\n",
       "      <td>LONDON NORTH WEST HEALTHCARE NHS TRUST</td>\n",
       "      <td>R1K00</td>\n",
       "      <td>LONDON NORTH WEST UNIVERSITY HEALTHCARE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>184</th>\n",
       "      <td>MILLENNIUM HEALTH LTD</td>\n",
       "      <td>DE500</td>\n",
       "      <td>MILLENNIUM HEALTH LTD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>185</th>\n",
       "      <td>LLR PROVIDER COMPANY LTD</td>\n",
       "      <td>DAY00</td>\n",
       "      <td>LLR PROVIDER COMPANY LTD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>186</th>\n",
       "      <td>LEICESTER, LEICESTERSHIRE &amp; RUTLAND STP</td>\n",
       "      <td>QK100</td>\n",
       "      <td>NHS LEICESTER, LEICESTERSHIRE AND RUTLAN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>187</th>\n",
       "      <td>BERKSHIRE HEALTHCARE NHS FT</td>\n",
       "      <td>RWX00</td>\n",
       "      <td>BERKSHIRE HEALTHCARE NHS FOUNDATION TRUS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>188</th>\n",
       "      <td>SOLENT MEDICAL SERVICES LTD</td>\n",
       "      <td>NNC00</td>\n",
       "      <td>SOLENT MEDICAL SERVICES LIMITED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>189</th>\n",
       "      <td>THE SOLENT NHS TRUST</td>\n",
       "      <td>R1C00</td>\n",
       "      <td>SOLENT NHS TRUST</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>190</th>\n",
       "      <td>THE SOCIETY OF ST JAMES</td>\n",
       "      <td>DEC00</td>\n",
       "      <td>THE SOCIETY OF ST JAMES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>191</th>\n",
       "      <td>SHROPSHIRE, TELFORD AND WREKIN CCG</td>\n",
       "      <td>M2L0M</td>\n",
       "      <td>NHS SHROPSHIRE, TELFORD AND WREKIN ICB -</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>192</th>\n",
       "      <td>ST JOSEPH'S HOSPICE</td>\n",
       "      <td>DL000</td>\n",
       "      <td>ST JOSEPH'S HOSPICE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>193</th>\n",
       "      <td>TURNING POINT</td>\n",
       "      <td>NKI00</td>\n",
       "      <td>TURNING POINT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194</th>\n",
       "      <td>PRACTICE BASED CLINICAL SERVICES LIMITED</td>\n",
       "      <td>AWH00</td>\n",
       "      <td>PRACTICE BASED CLINICAL SERVICES LIMITED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>195</th>\n",
       "      <td>TOWER HAMLETS TOBACCO CESSATION SERVICE</td>\n",
       "      <td>DKH00</td>\n",
       "      <td>TOWER HAMLETS TOBACCO CESSATION SERVICE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>196</th>\n",
       "      <td>FRAMEWORK</td>\n",
       "      <td>DMH00</td>\n",
       "      <td>FRAMEWORK</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>197</th>\n",
       "      <td>NORTHAMPTONSHIRE STP</td>\n",
       "      <td>QPM00</td>\n",
       "      <td>NHS NORTHAMPTONSHIRE INTEGRATED CARE BOA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>198</th>\n",
       "      <td>CTRL &amp; N W LONDON NHS FOUNDATION TRUST</td>\n",
       "      <td>RV300</td>\n",
       "      <td>CENTRA AND NORTH WEST LONDON NHS FOUNDAT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199</th>\n",
       "      <td>NOTTINGHAM &amp; NOTTINGHAMSHIRE H&amp;C STP</td>\n",
       "      <td>QT100</td>\n",
       "      <td>NHS NOTTINGHAM AND NOTTINGHAMSHIRE INTEG</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>200</th>\n",
       "      <td>SUFFOLK GP FEDERATION</td>\n",
       "      <td>NDL00</td>\n",
       "      <td>SUFFOLK GP FEDERATION</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>201</th>\n",
       "      <td>SUFFOLK COUNTY COUNCIL</td>\n",
       "      <td>60900</td>\n",
       "      <td>SUFFOLK COUNTY COUNCIL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>202</th>\n",
       "      <td>SUFFOLK &amp; NORTH EAST ESSEX STP</td>\n",
       "      <td>QJG00</td>\n",
       "      <td>NHS SUFFOLK AND NORTH EAST ESSEX INTEGRA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>203</th>\n",
       "      <td>CHESHIRE &amp; WIRRAL P/S NHS FOUNDATION TR</td>\n",
       "      <td>RXA00</td>\n",
       "      <td>CHESHIRE &amp; WIRRAL PARTNERSHIP NHS FOUNDA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>204</th>\n",
       "      <td>BRIDGEWATER COMM HEALTHCARE NHS TRUST</td>\n",
       "      <td>RY200</td>\n",
       "      <td>BRIDGEWATER COMMUNITY HEALTHCARE NHS FOU</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>205</th>\n",
       "      <td>THE ROTHERHAM NHS FOUNDATION TRUST</td>\n",
       "      <td>RFR00</td>\n",
       "      <td>THE ROTHERHAM NHS FOUNDATION TRUST</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>206</th>\n",
       "      <td>SOUTH YORKSHIRE &amp; BASSETLAW STP</td>\n",
       "      <td>QF700</td>\n",
       "      <td>NHS SOUTH YORKSHIRE INTEGRATED CARE BOAR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>207</th>\n",
       "      <td>SHEFFIELD CHILDREN'S NHS FT</td>\n",
       "      <td>RCU00</td>\n",
       "      <td>SHEFFIELD CHILDREN'S NHS FOUNDATION TRUS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>208</th>\n",
       "      <td>CONNECT HEALTH LIMITED</td>\n",
       "      <td>NMG00</td>\n",
       "      <td>CONNECT HEALTH LIMITED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>209</th>\n",
       "      <td>COASTAL HEALTH GP PROVIDER ORGANISATION</td>\n",
       "      <td>DR300</td>\n",
       "      <td>COASTAL HEALTH GP PROVIDER ORGANISATION</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>210</th>\n",
       "      <td>NORFOLK &amp; WAVENEY H&amp;C PARTNERSHIP STP</td>\n",
       "      <td>QMM00</td>\n",
       "      <td>NHS NORFOLK AND WAVENEY INTEGRATED CARE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>211</th>\n",
       "      <td>SHROPSHIRE COMMUNITY HEALTH NHS TRUST</td>\n",
       "      <td>R1D00</td>\n",
       "      <td>SHROPSHIRE COMMUNITY HEALTH NHS TRUST</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>212</th>\n",
       "      <td>SHROPSHIRE &amp; TELFORD &amp; WREKIN STP</td>\n",
       "      <td>QOC00</td>\n",
       "      <td>NHS SHROPSHIRE, TELFORD AND WREKIN INTEG</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>213</th>\n",
       "      <td>NORTH MIDDLESEX UNIVERSITY HPL NHS TRUST</td>\n",
       "      <td>RAP00</td>\n",
       "      <td>NORTH MIDDLESEX UNIVERSITY HOSPITAL NHS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>214</th>\n",
       "      <td>WE ARE WITH YOU</td>\n",
       "      <td>NI300</td>\n",
       "      <td>WE ARE WITH YOU</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>215</th>\n",
       "      <td>WESTMINSTER DRUG PROJECT</td>\n",
       "      <td>ARG00</td>\n",
       "      <td>WESTMINISTER DRUG PROJECT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>216</th>\n",
       "      <td>CENTRAL LONDON COMMUNITY HC NHS TRUST</td>\n",
       "      <td>RYX00</td>\n",
       "      <td>CENTRAL LONDON COMMUNITY HEALTHCARE NHS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>217</th>\n",
       "      <td>CIRCLE</td>\n",
       "      <td>NV300</td>\n",
       "      <td>CIRCLE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>218</th>\n",
       "      <td>VOCARE</td>\n",
       "      <td>NLO00</td>\n",
       "      <td>VOCARE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>219</th>\n",
       "      <td>UNIDENTIFIED</td>\n",
       "      <td>-</td>\n",
       "      <td>UNIDENTIFIED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>220</th>\n",
       "      <td>BROMLEY HEALTHCARE CIC LTD</td>\n",
       "      <td>NQV00</td>\n",
       "      <td>BROMLEY HEALTHCARE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>221</th>\n",
       "      <td>BMI HEALTHCARE</td>\n",
       "      <td>NT400</td>\n",
       "      <td>BMI HEALTHCARE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>222</th>\n",
       "      <td>GUY'S &amp; ST THOMAS' NHS FOUNDATION TRUST</td>\n",
       "      <td>RJ100</td>\n",
       "      <td>GUY'S AND ST THOMAS' NHS FOUNDATION TRUS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>223</th>\n",
       "      <td>DMC COMMUNITY OUTPATIENT SERVICES</td>\n",
       "      <td>NCN00</td>\n",
       "      <td>DMC COMMUNITY OUTPATIENT SERVICES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>224</th>\n",
       "      <td>FORWARD TRUST</td>\n",
       "      <td>DG300</td>\n",
       "      <td>THE FORWARD TRUST</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>225</th>\n",
       "      <td>CONCORDIA COMMUNITY OUTPATIENTS LTD</td>\n",
       "      <td>NHT00</td>\n",
       "      <td>CONCORDIA COMMUNITY OUTPATIENTS LTD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>226</th>\n",
       "      <td>KING'S COLLEGE HPL NHS FOUNDATION TRUST</td>\n",
       "      <td>RJZ00</td>\n",
       "      <td>KING'S COLLEGE HOSPITAL NHS FOUNDATION T</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>227</th>\n",
       "      <td>OMNES HEALTHCARE LTD</td>\n",
       "      <td>DXV00</td>\n",
       "      <td>OMNES HEALTHCARE LTD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>228</th>\n",
       "      <td>OXLEAS NHS FOUNDATION TRUST</td>\n",
       "      <td>RPG00</td>\n",
       "      <td>OXLEAS NHS FOUNDATION TRUST</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>229</th>\n",
       "      <td>LEWISHAM AND GREENWICH NHS TRUST</td>\n",
       "      <td>RJ200</td>\n",
       "      <td>LEWISHAM AND GREENWICH NHS TRUST</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>230</th>\n",
       "      <td>NEW MEDICAL SYSTEMS LIMITED</td>\n",
       "      <td>ACG00</td>\n",
       "      <td>NEW MEDICAL SYSTEMS LIMITED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>231</th>\n",
       "      <td>OUR HEALTHIER SOUTH EAST LONDON STP</td>\n",
       "      <td>QKK00</td>\n",
       "      <td>NHS SOUTH EAST LONDON INTEGRATED CARE BO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>232</th>\n",
       "      <td>NHS PRACTITIONER HEALTH PROGRAMME</td>\n",
       "      <td>AT000</td>\n",
       "      <td>NHS PRACTITIONER HEALTH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>233</th>\n",
       "      <td>YORKSHIRE AMBULANCE SERVICE NHS TRUST</td>\n",
       "      <td>RX800</td>\n",
       "      <td>YORKSHIRE AMBULANCE SERVICE NHS TRUST</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>234</th>\n",
       "      <td>BIRMINGHAM COMMUNITY HC FOUNDATION TRUST</td>\n",
       "      <td>RYW00</td>\n",
       "      <td>BIRMINGHAM COMMUNITY HEALTHCARE NHS FOUN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>235</th>\n",
       "      <td>HEALTHHARMONIE</td>\n",
       "      <td>NO000</td>\n",
       "      <td>HEALTHHARMONIE LIMITED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>236</th>\n",
       "      <td>BIRMINGHAM WOMANS &amp; CHILDRENS NHS FT</td>\n",
       "      <td>RQ300</td>\n",
       "      <td>BIRMINGHAM WOMEN'S AND CHILDREN'S NHS FO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>237</th>\n",
       "      <td>AIREDALE NHS FOUNDATION TRUST</td>\n",
       "      <td>RCF00</td>\n",
       "      <td>AIREDALE NHS FOUNDATION TRUST</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>238</th>\n",
       "      <td>YORK &amp; SCARBOROUGH TH NHSFT</td>\n",
       "      <td>RCB00</td>\n",
       "      <td>YORK AND SCARBOROUGH TEACHING HOSPITALS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>239</th>\n",
       "      <td>GLOUCESTERSHIRE HEALTH AND CARE NHS FT</td>\n",
       "      <td>RTQ00</td>\n",
       "      <td>GLOUCESTERSHIRE HEALTH AND CARE NHS FOUN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>240</th>\n",
       "      <td>TETBURY HOSPITAL TRUST LTD</td>\n",
       "      <td>AAH00</td>\n",
       "      <td>TETBURY HOSPITAL TRUST LTD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>241</th>\n",
       "      <td>UNIVERSITY HOSPITALS OF MORECAMBE BAY</td>\n",
       "      <td>RTX00</td>\n",
       "      <td>UNIVERSITY HOSPITALS OF MORECAMBE BAY NH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>242</th>\n",
       "      <td>ISLE OF WIGHT NHS TRUST</td>\n",
       "      <td>R1F00</td>\n",
       "      <td>ISLE OF WIGHT NHS TRUST</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>243</th>\n",
       "      <td>STOCKTON ON TEES LOCAL AUTHORITY</td>\n",
       "      <td>11400</td>\n",
       "      <td>STOCKTON-ON-TEES BOROUGH COUNCIL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>244</th>\n",
       "      <td>START</td>\n",
       "      <td>GDV00</td>\n",
       "      <td>START</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>245</th>\n",
       "      <td>CITY HEALTH CARE PARTNERSHIP CIC</td>\n",
       "      <td>NNF00</td>\n",
       "      <td>CITY HEALTH CARE PARTNERSHIP CIC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>246</th>\n",
       "      <td>KIRKLEES COUNCIL</td>\n",
       "      <td>21100</td>\n",
       "      <td>KIRKLEES COUNCIL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>247</th>\n",
       "      <td>LIVES</td>\n",
       "      <td>GCV00</td>\n",
       "      <td>LIVES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>248</th>\n",
       "      <td>GREAT WESTERN HPL NHS FOUNDATION TRUST</td>\n",
       "      <td>RN300</td>\n",
       "      <td>GREAT WESTERN HOSPITALS NHS FOUNDATION T</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>249</th>\n",
       "      <td>WILTSHIRE HEALTH AND CARE LLP</td>\n",
       "      <td>AXG00</td>\n",
       "      <td>WILTSHIRE HEALTH &amp; CARE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>250</th>\n",
       "      <td>GLOUCESTERSHIRE CARE SERVICES NHS TRUST</td>\n",
       "      <td>R1J00</td>\n",
       "      <td>GLOUCESTERSHIRE CARE SERVICES NHS TRUST</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>251</th>\n",
       "      <td>BATH &amp; NE SOMERSET, SWINDON &amp; WILTS STP</td>\n",
       "      <td>QOX00</td>\n",
       "      <td>NHS BATH AND NORTH EAST SOMERSET, SWINDO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>252</th>\n",
       "      <td>PRACTICE PLUS GROUP</td>\n",
       "      <td>NTP00</td>\n",
       "      <td>PRACTICE PLUS GROUP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>253</th>\n",
       "      <td>ASHFORD &amp; ST PETER'S HOSPITALS NHS FT</td>\n",
       "      <td>RTK00</td>\n",
       "      <td>ASHFORD &amp; ST PETER'S HOSPITALS NHS FOUND</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>254</th>\n",
       "      <td>CRANSTOUN</td>\n",
       "      <td>DLA00</td>\n",
       "      <td>CRANSTOUN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>255</th>\n",
       "      <td>WEST BERKSHIRE COUNCIL</td>\n",
       "      <td>61500</td>\n",
       "      <td>WEST BERKSHIRE COUNCIL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>256</th>\n",
       "      <td>CSH SURREY</td>\n",
       "      <td>NTV00</td>\n",
       "      <td>CSH SURREY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>257</th>\n",
       "      <td>SURREY AND BORDERS PARTNERSHIP NHS FT</td>\n",
       "      <td>RXX00</td>\n",
       "      <td>SURREY AND BORDERS PARTNERSHIP NHS FOUND</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>258</th>\n",
       "      <td>EPSOM &amp; ST HELIER UNIV HPLS NHS TRUST</td>\n",
       "      <td>RVR00</td>\n",
       "      <td>EPSOM AND ST HELIER UNIVERSITY HOSPITALS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>259</th>\n",
       "      <td>SOUTH WARWICKSHIRE NHS FOUNDATION TRUST</td>\n",
       "      <td>RJC00</td>\n",
       "      <td>SOUTH WARWICKSHIRE NHS FOUNDATION TRUST</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>260</th>\n",
       "      <td>MIDLANDS P/SHIP NHS FOUNDATION TRUST</td>\n",
       "      <td>RRE00</td>\n",
       "      <td>MIDLANDS PARTNERSHIP NHS FOUNDATION TRUS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>261</th>\n",
       "      <td>LANCASTER HOUSE CONSULTING</td>\n",
       "      <td>NLE00</td>\n",
       "      <td>LANCASTER HOUSE CONSULTING DIAGNOSTICS S</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>262</th>\n",
       "      <td>COMMUNITAS CLINICS LTD</td>\n",
       "      <td>NLG00</td>\n",
       "      <td>COMMUNITAS CLINICS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>263</th>\n",
       "      <td>WEST LONDON NHS TRUST</td>\n",
       "      <td>RKL00</td>\n",
       "      <td>WEST LONDON NHS TRUST</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>264</th>\n",
       "      <td>NW LONDON HEALTH &amp; CARE PARTNERSHIP STP</td>\n",
       "      <td>QRV00</td>\n",
       "      <td>NHS NORTH WEST LONDON INTEGRATED CARE BO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>265</th>\n",
       "      <td>WEST SUFFOLK NHS FOUNDATION TRUST</td>\n",
       "      <td>RGR00</td>\n",
       "      <td>WEST SUFFOLK NHS FOUNDATION TRUST</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>266</th>\n",
       "      <td>HERTFORDSHIRE COMMUNITY NHS TRUST</td>\n",
       "      <td>RY400</td>\n",
       "      <td>HERTFORDSHIRE COMMUNITY NHS TRUST</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>267</th>\n",
       "      <td>EAST LANCASHIRE MEDICAL SERVICES LTD</td>\n",
       "      <td>AC000</td>\n",
       "      <td>EAST LANCASHIRE MEDICAL SERVICES LTD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>268</th>\n",
       "      <td>HARROGATE &amp; DISTRICT FOUNDATION TRUST</td>\n",
       "      <td>RCD00</td>\n",
       "      <td>HARROGATE AND DISTRICT NHS FOUNDATION TR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>269</th>\n",
       "      <td>HEALTHIER LANCASHIRE &amp; SOUTH CUMBRIA STP</td>\n",
       "      <td>QE100</td>\n",
       "      <td>NHS LANCASHIRE AND SOUTH CUMBRIA INTEGRA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>270</th>\n",
       "      <td>LANCASHIRE &amp; SOUTH CUMBRIA NHS FT</td>\n",
       "      <td>RW500</td>\n",
       "      <td>LANCASHIRE &amp; SOUTH CUMBRIA NHS FOUNDATIO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>271</th>\n",
       "      <td>DELPHI MEDICAL LTD</td>\n",
       "      <td>AKQ00</td>\n",
       "      <td>DELPHI MEDICAL LTD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>272</th>\n",
       "      <td>COMMUNITY HEALTH &amp; EYECARE</td>\n",
       "      <td>AAV00</td>\n",
       "      <td>COMMUNITY HEALTH &amp; EYECARE LIMITED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>273</th>\n",
       "      <td>HEREFORDSHIRE&amp;WORCESTERSHIRE H&amp;C NHS T</td>\n",
       "      <td>R1A00</td>\n",
       "      <td>HEREFORDSHIRE AND WORCESTERSHIRE HEALTH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>274</th>\n",
       "      <td>WYE VALLEY NHS TRUST</td>\n",
       "      <td>RLQ00</td>\n",
       "      <td>WYE VALLEY NHS TRUST</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>275</th>\n",
       "      <td>BIRMINGHAM &amp; SOLIHULL STP</td>\n",
       "      <td>QHL00</td>\n",
       "      <td>NHS BIRMINGHAM AND SOLIHULL INTEGRATED C</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>276</th>\n",
       "      <td>WWL NHS FOUNDATION TRUST</td>\n",
       "      <td>RRF00</td>\n",
       "      <td>WRIGHTINGTON, WIGAN AND LEIGH NHS FOUNDA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>277</th>\n",
       "      <td>WIGAN COUNCIL</td>\n",
       "      <td>31300</td>\n",
       "      <td>WIGAN METROPOLITAN BOROUGH COUNCIL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>278</th>\n",
       "      <td>NOTTINGHAM CITYCARE PARTNERSHIP</td>\n",
       "      <td>NR300</td>\n",
       "      <td>NOTTINGHAM CITYCARE PARTNERSHIP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>279</th>\n",
       "      <td>NOTTINGHAMSHIRE HEALTHCARE NHS F TRUST</td>\n",
       "      <td>RHA00</td>\n",
       "      <td>NOTTINGHAMSHIRE HEALTHCARE NHS FOUNDATIO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>280</th>\n",
       "      <td>SHERWOOD FOREST HOSPITALS NHS TRUST</td>\n",
       "      <td>RK500</td>\n",
       "      <td>SHERWOOD FOREST HOSPITALS NHS FOUNDATION</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>281</th>\n",
       "      <td>BURY COUNCIL</td>\n",
       "      <td>30500</td>\n",
       "      <td>BURY METROPOLITAN BOROUGH COUNCIL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>282</th>\n",
       "      <td>GREATER MANCHESTER MENTAL HEALTH NHS FT</td>\n",
       "      <td>RXV00</td>\n",
       "      <td>GREATER MANCHESTER MENTAL HEALTH NHS FOU</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>283</th>\n",
       "      <td>GREATER MANCHESTER HSC PARTNERSHIP STP</td>\n",
       "      <td>QOP00</td>\n",
       "      <td>NHS GREATER MANCHESTER INTEGRATED CARE B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>284</th>\n",
       "      <td>EAST KENT HOSPITALS UNIVERSITY NHS FT</td>\n",
       "      <td>RVV00</td>\n",
       "      <td>EAST KENT HOSPITALS UNIVERSITY NHS FOUND</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>285</th>\n",
       "      <td>FAVESRHAM MEDICAL PRACTICE MIU</td>\n",
       "      <td>AQM00</td>\n",
       "      <td>FAVERSHAM MEDICAL PRACTICE MIU</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>286</th>\n",
       "      <td>DORSET STP</td>\n",
       "      <td>QVV00</td>\n",
       "      <td>NHS DORSET INTEGRATED CARE BOARD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>287</th>\n",
       "      <td>INTEGRATED CARE 24 LTD</td>\n",
       "      <td>NVE00</td>\n",
       "      <td>INTEGRATED CARE 24 LTD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>288</th>\n",
       "      <td>KENT &amp; MEDWAY STP</td>\n",
       "      <td>QKS00</td>\n",
       "      <td>NHS KENT AND MEDWAY INTEGRATED CARE BOAR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>289</th>\n",
       "      <td>BUCKINGHAMSHIRE HOSPITALS NHS TRUST</td>\n",
       "      <td>RXQ00</td>\n",
       "      <td>BUCKINGHAMSHIRE HEALTHCARE NHS TRUST</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>290</th>\n",
       "      <td>OXFORD HEALTH NHS FOUNDATION TRUST</td>\n",
       "      <td>RNU00</td>\n",
       "      <td>OXFORD HEALTH NHS FOUNDATION TRUST</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>291</th>\n",
       "      <td>BUCKS, OXFORDSHIRE &amp; BERKSHIRE WEST STP</td>\n",
       "      <td>QU900</td>\n",
       "      <td>NHS BUCKINGHAMSHIRE, OXFORDSHIRE AND BER</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>292</th>\n",
       "      <td>INHEALTH LIMITED</td>\n",
       "      <td>NV100</td>\n",
       "      <td>INHEALTH LIMITED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>293</th>\n",
       "      <td>OPEROSE HEALTH (GROUP) UK LIMITED</td>\n",
       "      <td>NX100</td>\n",
       "      <td>OPEROSE HEALTH (GROUP) UK LIMITED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>294</th>\n",
       "      <td>PRIMARY EYECARE SERVICES LTD</td>\n",
       "      <td>AFW00</td>\n",
       "      <td>PRIMARY EYECARE SERVICES LTD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>295</th>\n",
       "      <td>PENNINE MSK PARTNERSHIP LTD</td>\n",
       "      <td>NLF00</td>\n",
       "      <td>PENNINE MUSCULOSKELETAL PARTNERSHIP (ICA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>296</th>\n",
       "      <td>CHESHIRE &amp; MERSEYSIDE STP</td>\n",
       "      <td>QYG00</td>\n",
       "      <td>NHS CHESHIRE AND MERSEYSIDE INTEGRATED C</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>297</th>\n",
       "      <td>MID AND SOUTH ESSEX STP</td>\n",
       "      <td>QH800</td>\n",
       "      <td>NHS MID AND SOUTH ESSEX INTEGRATED CARE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>298</th>\n",
       "      <td>WARRINGTON BOROUGH COUNCIL</td>\n",
       "      <td>32200</td>\n",
       "      <td>WARRINGTON BOROUGH COUNCIL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>299</th>\n",
       "      <td>WARRINGTON &amp; HALTON TEACHING HOSP NHSFT</td>\n",
       "      <td>RWW00</td>\n",
       "      <td>WARRINGTON AND HALTON TEACHING HOSPITALS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>300</th>\n",
       "      <td>NORTH EAST LINCOLNSHIRE COUNCIL</td>\n",
       "      <td>21600</td>\n",
       "      <td>NORTH EAST LINCOLNSHIRE COUNCIL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>301</th>\n",
       "      <td>DERBYSHIRE COMM HLTH SERVICES NHS TRUST</td>\n",
       "      <td>RY800</td>\n",
       "      <td>DERBYSHIRE COMMUNITY HEALTH SERVICES NHS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>302</th>\n",
       "      <td>LINCOLNSHIRE &amp; DISTRICTS MED SERVICES</td>\n",
       "      <td>NBF00</td>\n",
       "      <td>LINCOLNSHIRE AND DISTRICTS MEDICAL SERVI</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>303</th>\n",
       "      <td>JOINED UP CARE DERBYSHIRE STP</td>\n",
       "      <td>QJ200</td>\n",
       "      <td>NHS DERBY AND DERBYSHIRE INTEGRATED CARE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>304</th>\n",
       "      <td>DERBYSHIRE HEALTHCARE NHS FT</td>\n",
       "      <td>RXM00</td>\n",
       "      <td>DERBYSHIRE HEALTHCARE NHS FOUNDATION TRU</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>305</th>\n",
       "      <td>THE NEWCASTLE UPON TYNE HPL NHS FOUND TR</td>\n",
       "      <td>RTD00</td>\n",
       "      <td>THE NEWCASTLE UPON TYNE HOSPITALS NHS FO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>306</th>\n",
       "      <td>EAST SUSSEX HEALTHCARE NHS TRUST</td>\n",
       "      <td>RXC00</td>\n",
       "      <td>EAST SUSSEX HEALTHCARE NHS TRUST</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>307</th>\n",
       "      <td>HERE</td>\n",
       "      <td>NWX00</td>\n",
       "      <td>HERE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>308</th>\n",
       "      <td>SOUTH DOWNS HEALTH AND CARE LTD</td>\n",
       "      <td>DKL00</td>\n",
       "      <td>SOUTH DOWNS HEALTH AND CARE LTD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>309</th>\n",
       "      <td>SOUTH EAST COAST AMBULANCE SERVICE NHSFT</td>\n",
       "      <td>RYD00</td>\n",
       "      <td>SOUTH EAST COAST AMBULANCE SERVICE NHS F</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>310</th>\n",
       "      <td>SUSSEX COMMUNITY DERMATOLOGY SERVICE</td>\n",
       "      <td>NYG00</td>\n",
       "      <td>SUSSEX COMMUNITY DERMATOLOGY SERVICE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>311</th>\n",
       "      <td>ST MICHAELS HOSPICE</td>\n",
       "      <td>ARD00</td>\n",
       "      <td>ST MICHAEL'S HOSPICE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>312</th>\n",
       "      <td>ST WILFRID'S HOSPICE</td>\n",
       "      <td>ARF00</td>\n",
       "      <td>ST WILFRID'S HOSPICE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>313</th>\n",
       "      <td>SUSSEX COMMUNITY NHS FOUNDATION TRUST</td>\n",
       "      <td>RDR00</td>\n",
       "      <td>SUSSEX COMMUNITY NHS FOUNDATION TRUST</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>314</th>\n",
       "      <td>SUSSEX &amp; EAST SURREY STP</td>\n",
       "      <td>QNX00</td>\n",
       "      <td>NHS SUSSEX INTEGRATED CARE BOARD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>315</th>\n",
       "      <td>UNIVERSITY HOSPITALS SUSSEX NHS FT</td>\n",
       "      <td>RYR00</td>\n",
       "      <td>UNIVERSITY HOSPITALS SUSSEX NHS FOUNDATI</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>316</th>\n",
       "      <td>THE SUSSEX BEACON</td>\n",
       "      <td>AE800</td>\n",
       "      <td>THE SUSSEX BEACON</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>317</th>\n",
       "      <td>ABOUT HEALTH</td>\n",
       "      <td>NPR00</td>\n",
       "      <td>ABOUT HEALTH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>318</th>\n",
       "      <td>COUNTESS MOUNTBATTEN HOSPICE</td>\n",
       "      <td>GAX00</td>\n",
       "      <td>COUNTESS MOUNTBATTEN HOSPICE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>319</th>\n",
       "      <td>HAMPSHIRE &amp; THE ISLE OF WIGHT STP</td>\n",
       "      <td>QRL00</td>\n",
       "      <td>NHS HAMPSHIRE AND ISLE OF WIGHT INTEGRAT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>320</th>\n",
       "      <td>LEEDS CITY COUNCIL</td>\n",
       "      <td>21200</td>\n",
       "      <td>LEEDS CITY COUNCIL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>321</th>\n",
       "      <td>ONE MEDICAL GROUP LIMITED</td>\n",
       "      <td>AXT00</td>\n",
       "      <td>ONE MEDICAL GROUP LIMITED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>322</th>\n",
       "      <td>LEEDS COMMUNITY HEALTHCARE NHS TRUST</td>\n",
       "      <td>RY600</td>\n",
       "      <td>LEEDS COMMUNITY HEALTHCARE NHS TRUST</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>323</th>\n",
       "      <td>NOVUS HEALTH LTD</td>\n",
       "      <td>NQH00</td>\n",
       "      <td>NOVUS HEALTH LTD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>324</th>\n",
       "      <td>LOCALA COMMUNITY PARTNERSHIPS CIC</td>\n",
       "      <td>NL800</td>\n",
       "      <td>LOCALA COMMUNITY PARTNERSHIPS CIC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>325</th>\n",
       "      <td>W YORKSHIRE &amp; HARROGATE H&amp;C P/SHIP STP</td>\n",
       "      <td>QWO00</td>\n",
       "      <td>NHS WEST YORKSHIRE INTEGRATED CARE BOARD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>326</th>\n",
       "      <td>PHOENIX HEALTH SOLUTIONS LTD</td>\n",
       "      <td>NEQ00</td>\n",
       "      <td>PHOENIX HEALTH SOLUTIONS LIMITED HQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>327</th>\n",
       "      <td>SPECTRUM COMMUNITY HEALTH</td>\n",
       "      <td>NL100</td>\n",
       "      <td>SPECTRUM COMMUNITY HEALTH - CIC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>328</th>\n",
       "      <td>HEREFORDSHIRE &amp; WORCESTERSHIRE STP</td>\n",
       "      <td>QGH00</td>\n",
       "      <td>NHS HEREFORDSHIRE AND WORCESTERSHIRE INT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>329</th>\n",
       "      <td>SURREY HEARTLANDS H&amp;C PARTNERSHIP STP</td>\n",
       "      <td>QXU00</td>\n",
       "      <td>NHS SURREY HEARTLANDS INTEGRATED CARE BO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>330</th>\n",
       "      <td>HUMBER TEACHING NHS FOUNDATION TRUST</td>\n",
       "      <td>RV900</td>\n",
       "      <td>HUMBER TEACHING NHS FOUNDATION TRUST</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>331</th>\n",
       "      <td>HUMBER, COAST &amp; VALE STP</td>\n",
       "      <td>QOQ00</td>\n",
       "      <td>NHS HUMBER AND NORTH YORKSHIRE INTEGRATE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>332</th>\n",
       "      <td>NAVIGO HEALTH &amp; SOCIAL CARE CIC</td>\n",
       "      <td>NQL00</td>\n",
       "      <td>NAVIGO HEALTH AND SOCIAL CARE CIC</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                   PCO_NAME_x PCO_CODE  \\\n",
       "0                     NORFOLK AND WAVENEY CCG    26A00   \n",
       "1                                KNOWSLEY CCG    01J00   \n",
       "2                            VALE OF YORK CCG    03Q00   \n",
       "3                            SOUTH SEFTON CCG    01T00   \n",
       "4                                CHESHIRE CCG    27D00   \n",
       "5                     WEST LEICESTERSHIRE CCG    04V00   \n",
       "6                               ST HELENS CCG    01X00   \n",
       "7                          BERKSHIRE WEST CCG    15A00   \n",
       "8        BRISTOL, NORTH SOMERSET & S GLOS CCG    15C00   \n",
       "9                                    BURY CCG    00V00   \n",
       "10                      SOUTH WEST LONDON CCG    36L00   \n",
       "11                          MORECAMBE BAY CCG    01K00   \n",
       "12                         NORTHUMBERLAND CCG    00L00   \n",
       "13   HAMPSHIRE,SOUTHAMPTON &ISLE OF WIGHT CCG    D9Y0V   \n",
       "14      BLACK COUNTRY AND WEST BIRMINGHAM CCG    D2P2L   \n",
       "15    BEDFORDSHIRE, LUTON & MILTON KEYNES CCG    M1J4Y   \n",
       "16                              LIVERPOOL CCG    99A00   \n",
       "17                   SOUTHPORT AND FORMBY CCG    01V00   \n",
       "18                      SURREY HEARTLANDS CCG    92A00   \n",
       "19                            OXFORDSHIRE CCG    10Q00   \n",
       "20                           FYLDE & WYRE CCG    02M00   \n",
       "21                      NORTH WEST LONDON CCG    W2U3Z   \n",
       "22                                     LCWUCC    NKB00   \n",
       "23                   NORTH CENTRAL LONDON CCG    93C00   \n",
       "24                      GREENBROOK HEALTHCARE    AD900   \n",
       "25                         NORTH TYNESIDE CCG    99C00   \n",
       "26                        EAST LANCASHIRE CCG    01A00   \n",
       "27        CAMBRIDGESHIRE AND PETERBOROUGH CCG    06H00   \n",
       "28                  BLACKBURN WITH DARWEN CCG    00Q00   \n",
       "29                              BLACKPOOL CCG    00R00   \n",
       "30               CHORLEY AND SOUTH RIBBLE CCG    00X00   \n",
       "31                                 BOLTON CCG    00T00   \n",
       "32                        WEST LANCASHIRE CCG    02G00   \n",
       "33                            PDS MEDICAL LTD    NV600   \n",
       "34    NORTHUMBRIA H/CARE NHS FOUNDATION TRUST    RTF00   \n",
       "35                                 KERNOW CCG    11N00   \n",
       "36   NTH TEES&HARTLEPOOL NHS FOUNDATION TRUST    RVW00   \n",
       "37       SOUTH TEES HOSP NHS FOUNDATION TRUST    RTR00   \n",
       "38       REDCAR AND CLEVELAND LOCAL AUTHORITY    11300   \n",
       "39                      NORTH EAST LONDON CCG    A3A8R   \n",
       "40                               KIRKLEES CCG    X2C4Y   \n",
       "41                 SIRONA CARE AND HEALTH CIC    NLX00   \n",
       "42                      SOUTH EAST LONDON CCG    72Q00   \n",
       "43                                 DORSET CCG    11J00   \n",
       "44       SOUTH TYNESIDE AND SUNDERLAND NHS FT    R0B00   \n",
       "45                         SOUTH TYNESIDE CCG    00N00   \n",
       "46                 SOMERSET SURGICAL SERVICES    NFH00   \n",
       "47                         WESTON HOSPICECARE    DLD00   \n",
       "48                          WIGAN BOROUGH CCG    02H00   \n",
       "49                               TRAFFORD CCG    02A00   \n",
       "50                                 HALTON CCG    01F00   \n",
       "51                        BUCKINGHAMSHIRE CCG    14Y00   \n",
       "52              COVENTRY AND WARWICKSHIRE CCG    B2M3M   \n",
       "53         SE STAFFS & SEISDON PENINSULAR CCG    05Q00   \n",
       "54                     HCRG CARE SERVICES LTD    NDA00   \n",
       "55                              HCRG CARE LTD    NQT00   \n",
       "56                                     ISIGHT    NCR00   \n",
       "57         BRISTOL, N SOMERSET & S GLOUCS STP    QUY00   \n",
       "58    UNIVERSITY HOSPITALS PLYMOUTH NHS TRUST    RK900   \n",
       "59            BRISDOC HEALTHCARE SERVICES LTD    NBP00   \n",
       "60                              PSYCHIATRY-UK    DQT00   \n",
       "61                          CANNOCK CHASE CCG    04Y00   \n",
       "62                                  LEEDS CCG    15F00   \n",
       "63                            WEST SUSSEX CCG    70F00   \n",
       "64                        KENT AND MEDWAY CCG    91Q00   \n",
       "65                                FRIMLEY CCG    D4U1Y   \n",
       "66                                 OLDHAM CCG    00Y00   \n",
       "67                             MANCHESTER CCG    14L00   \n",
       "68                          NORTH CUMBRIA CCG    01H00   \n",
       "69                        GTD HEALTHCARE IUCC    NW000   \n",
       "70          HEYWOOD, MIDDLETON & ROCHDALE CCG    01D00   \n",
       "71                                  DEVON CCG    15N00   \n",
       "72                         LEICESTER CITY CCG    04C00   \n",
       "73                          HERTS VALLEYS CCG    06N00   \n",
       "74                               SOUTHEND CCG    99G00   \n",
       "75                       NORTHAMPTONSHIRE CCG    78H00   \n",
       "76         NOTTINGHAM AND NOTTINGHAMSHIRE CCG    52R00   \n",
       "77       HEREFORDSHIRE AND WORCESTERSHIRE CCG    18C00   \n",
       "78           BRADFORD DISTRICT AND CRAVEN CCG    36J00   \n",
       "79                               SOMERSET CCG    11X00   \n",
       "80            BANES SWINDON AND WILTSHIRE CCG    92G00   \n",
       "81                              MID ESSEX CCG    06Q00   \n",
       "82              SOMERSET NHS FOUNDATION TRUST    RH500   \n",
       "83                             SUNDERLAND CCG    00P00   \n",
       "84                           LINCOLNSHIRE CCG    71E00   \n",
       "85                             PORTSMOUTH CCG    10R00   \n",
       "86                                   HULL CCG    03F00   \n",
       "87               EAST RIDING OF YORKSHIRE CCG    02Y00   \n",
       "88                            TEES VALLEY CCG    16C00   \n",
       "89                        NORTH YORKSHIRE CCG    42D00   \n",
       "90          DUDLEY GROUP NHS FOUNDATION TRUST    RNA00   \n",
       "91    SANDWELL AND WEST BIRMINGHAM HPLS TRUST    RXK00   \n",
       "92                        GLOUCESTERSHIRE CCG    11M00   \n",
       "93            BLACK COUNTRY HEALTHCARE NHS FT    RQ400   \n",
       "94          THE ROYAL WOLVERHAMPTON NHS TRUST    RL400   \n",
       "95    THE BLACK COUNTRY & WEST BIRMINGHAM STP    QUA00   \n",
       "96   COVENTRY & WARWICKSHIRE P/SHIP NHS TRUST    RYG00   \n",
       "97                    SUNDERLAND CITY COUNCIL    11000   \n",
       "98                     DERBY & DERBYSHIRE CCG    15M00   \n",
       "99                          COUNTY DURHAM CCG    84H00   \n",
       "100               BIRMINGHAM AND SOLIHULL CCG    15E00   \n",
       "101                               SALFORD CCG    01G00   \n",
       "102              MANCHESTER UNIVERSITY NHS FT    R0A00   \n",
       "103                   NEWCASTLE GATESHEAD CCG    13T00   \n",
       "104                             SHEFFIELD CCG    03N00   \n",
       "105                             ROTHERHAM CCG    03L00   \n",
       "106                            WEST ESSEX CCG    07H00   \n",
       "107                  CUMBRIA & NORTH EAST STP    QHM00   \n",
       "108   CUMBRIA,NORTHUMBERLAND,TYNE&WEAR NHS FT    RX400   \n",
       "109                DARLINGTON BOROUGH COUNCIL    11700   \n",
       "110                     DURHAM COUNTY COUNCIL    11600   \n",
       "111                         GATESHEAD COUNCIL    10600   \n",
       "112                     MIDDLESBROUGH COUNCIL    11200   \n",
       "113                HARTLEPOOL LOCAL AUTHORITY    11100   \n",
       "114                                 HUMANKIND    AJ600   \n",
       "115                    NEWCASTLE CITY COUNCIL    10700   \n",
       "116                            WARRINGTON CCG    02E00   \n",
       "117       EAST LEICESTERSHIRE AND RUTLAND CCG    03W00   \n",
       "118                             STOCKPORT CCG    01W00   \n",
       "119    HOMERTON UNIV HPL NHS FOUNDATION TRUST    RQX00   \n",
       "120                                      LIVI    DYX00   \n",
       "121          EAST AND NORTH HERTFORDSHIRE CCG    06K00   \n",
       "122    ST GEORGE'S UNIV HOSPS FOUNDATION NHST    RJ700   \n",
       "123   SW LONDON HEALTH & CARE PARTNERSHIP STP    QWE00   \n",
       "124                             BOLTON NHS FT    RMC00   \n",
       "125                             WAKEFIELD CCG    03R00   \n",
       "126                        STOKE ON TRENT CCG    05W00   \n",
       "127                            CALDERDALE CCG    02T00   \n",
       "128             BRADFORD DISTRICT CARE NHS FT    RCE00   \n",
       "129                                WIRRAL CCG    12F00   \n",
       "130                           EAST SUSSEX CCG    97R00   \n",
       "131                                 DEVON STP    QJK00   \n",
       "132             EDP DRUG AND ALCOHOL SERVICES    DWA00   \n",
       "133   ROYAL DEVON UNIVERSITY HEALTHCARE NHSFT    RH800   \n",
       "134                        LIVEWELL SOUTHWEST    NR500   \n",
       "135         SENTINEL HEALTHCARE SOUTHWEST CIC    NWE00   \n",
       "136     WIRRAL COMMUNITY NHS FOUNDATION TRUST    RY700   \n",
       "137    SOUTH WESTERN AMBULANCE SERVICE NHS FT    RYF00   \n",
       "138  TORBAY AND SOUTH DEVON NHS FOUNDATION TR    RA900   \n",
       "139                              BARNSLEY CCG    02P00   \n",
       "140                             BASSETLAW CCG    02Q00   \n",
       "141    SOUTH CENTRAL AMBULANCE SERVICE NHS FT    RYE00   \n",
       "142                       BRIGHTON & HOVE CCG    09D00   \n",
       "143                BASILDON AND BRENTWOOD CCG    99E00   \n",
       "144             CASTLE POINT AND ROCHFORD CCG    99F00   \n",
       "145              IPSWICH AND EAST SUFFOLK CCG    06L00   \n",
       "146                      NORTH EAST ESSEX CCG    06T00   \n",
       "147           MEDWAY COMMUNITY HEALTHCARE CIC    NQ700   \n",
       "148              KENT COMMUNITY HEALTH NHS FT    RYY00   \n",
       "149                RDASH NHS FOUNDATION TRUST    RXE00   \n",
       "150               WHITSTABLE MEDICAL PRACTICE    ACH00   \n",
       "151                     NEW HAYESBANK CLINICS    AC600   \n",
       "152             SYDENHAM HOUSE MEDICAL CENTRE    AAX00   \n",
       "153                SELLINDGE PRACTICE LIMITED    NNS00   \n",
       "154        THE HERNE BAY OPHTHALMOLOGY CLINIC    AC200   \n",
       "155                    EAST STAFFORDSHIRE CCG    05D00   \n",
       "156                  TAMESIDE AND GLOSSOP CCG    01Y00   \n",
       "157                        CHANGE, GROW, LIVE    NMS00   \n",
       "158                          WEST SUFFOLK CCG    07K00   \n",
       "159  CONS EYE SURGEONS PARTNERSHIP (CANT) LLP    AER00   \n",
       "160    NORTH STAFFS COMBINED HEALTHCARE TRUST    RLY00   \n",
       "161                   NORTH STAFFORDSHIRE CCG    05G00   \n",
       "162    STOCKPORT METROPOLITAN BOROUGH COUNCIL    31000   \n",
       "163                              THURROCK CCG    07G00   \n",
       "164   LINCOLNSHIRE COMM HEALTH SERV NHS TRUST    RY500   \n",
       "165   RAMSAY HEALTHCARE UK OPERATIONS LIMITED    NVC00   \n",
       "166       EAST SUFFOLK AND NORTH ESSEX NHS FT    RDE00   \n",
       "167       ESSEX PARTNERSHIP UNIVERSITY NHS FT    R1L00   \n",
       "168   BEDFORDSHIRE, LUTON & MILTON KEYNES STP    QHG00   \n",
       "169                STAFFORD AND SURROUNDS CCG    05V00   \n",
       "170      NORTH CUMBRIA INTEGRATED CARE NHS FT    RNN00   \n",
       "171        STAFFORDSHIRE & STOKE ON TRENT STP    QNC00   \n",
       "172       NORTH EAST AMBULANCE SERVICE NHS FT    RX600   \n",
       "173                             DONCASTER CCG    02X00   \n",
       "174                    NORTH LINCOLNSHIRE CCG    03K00   \n",
       "175               NORTH EAST LINCOLNSHIRE CCG    03H00   \n",
       "176            NORTH YORKSHIRE COUNTY COUNCIL    21800   \n",
       "177          MERSEY CARE NHS FOUNDATION TRUST    RW400   \n",
       "178     LIVERPOOL UNIVERSITY HOSPITALS NHS FT    REM00   \n",
       "179   NORFOLK COMMUNITY HLTH & CARE NHS TRUST    RY300   \n",
       "180         CAMBRIDGESHIRE & PETERBOROUGH STP    QUE00   \n",
       "181                       GREATER PRESTON CCG    01E00   \n",
       "182        LONDON AMBULANCE SERVICE NHS TRUST    RRU00   \n",
       "183    LONDON NORTH WEST HEALTHCARE NHS TRUST    R1K00   \n",
       "184                     MILLENNIUM HEALTH LTD    DE500   \n",
       "185                  LLR PROVIDER COMPANY LTD    DAY00   \n",
       "186   LEICESTER, LEICESTERSHIRE & RUTLAND STP    QK100   \n",
       "187               BERKSHIRE HEALTHCARE NHS FT    RWX00   \n",
       "188               SOLENT MEDICAL SERVICES LTD    NNC00   \n",
       "189                      THE SOLENT NHS TRUST    R1C00   \n",
       "190                   THE SOCIETY OF ST JAMES    DEC00   \n",
       "191        SHROPSHIRE, TELFORD AND WREKIN CCG    M2L0M   \n",
       "192                       ST JOSEPH'S HOSPICE    DL000   \n",
       "193                             TURNING POINT    NKI00   \n",
       "194  PRACTICE BASED CLINICAL SERVICES LIMITED    AWH00   \n",
       "195   TOWER HAMLETS TOBACCO CESSATION SERVICE    DKH00   \n",
       "196                                 FRAMEWORK    DMH00   \n",
       "197                      NORTHAMPTONSHIRE STP    QPM00   \n",
       "198    CTRL & N W LONDON NHS FOUNDATION TRUST    RV300   \n",
       "199      NOTTINGHAM & NOTTINGHAMSHIRE H&C STP    QT100   \n",
       "200                     SUFFOLK GP FEDERATION    NDL00   \n",
       "201                    SUFFOLK COUNTY COUNCIL    60900   \n",
       "202            SUFFOLK & NORTH EAST ESSEX STP    QJG00   \n",
       "203   CHESHIRE & WIRRAL P/S NHS FOUNDATION TR    RXA00   \n",
       "204     BRIDGEWATER COMM HEALTHCARE NHS TRUST    RY200   \n",
       "205        THE ROTHERHAM NHS FOUNDATION TRUST    RFR00   \n",
       "206           SOUTH YORKSHIRE & BASSETLAW STP    QF700   \n",
       "207               SHEFFIELD CHILDREN'S NHS FT    RCU00   \n",
       "208                    CONNECT HEALTH LIMITED    NMG00   \n",
       "209   COASTAL HEALTH GP PROVIDER ORGANISATION    DR300   \n",
       "210     NORFOLK & WAVENEY H&C PARTNERSHIP STP    QMM00   \n",
       "211     SHROPSHIRE COMMUNITY HEALTH NHS TRUST    R1D00   \n",
       "212         SHROPSHIRE & TELFORD & WREKIN STP    QOC00   \n",
       "213  NORTH MIDDLESEX UNIVERSITY HPL NHS TRUST    RAP00   \n",
       "214                           WE ARE WITH YOU    NI300   \n",
       "215                  WESTMINSTER DRUG PROJECT    ARG00   \n",
       "216     CENTRAL LONDON COMMUNITY HC NHS TRUST    RYX00   \n",
       "217                                    CIRCLE    NV300   \n",
       "218                                    VOCARE    NLO00   \n",
       "219                              UNIDENTIFIED        -   \n",
       "220                BROMLEY HEALTHCARE CIC LTD    NQV00   \n",
       "221                            BMI HEALTHCARE    NT400   \n",
       "222   GUY'S & ST THOMAS' NHS FOUNDATION TRUST    RJ100   \n",
       "223         DMC COMMUNITY OUTPATIENT SERVICES    NCN00   \n",
       "224                             FORWARD TRUST    DG300   \n",
       "225       CONCORDIA COMMUNITY OUTPATIENTS LTD    NHT00   \n",
       "226   KING'S COLLEGE HPL NHS FOUNDATION TRUST    RJZ00   \n",
       "227                      OMNES HEALTHCARE LTD    DXV00   \n",
       "228               OXLEAS NHS FOUNDATION TRUST    RPG00   \n",
       "229          LEWISHAM AND GREENWICH NHS TRUST    RJ200   \n",
       "230               NEW MEDICAL SYSTEMS LIMITED    ACG00   \n",
       "231       OUR HEALTHIER SOUTH EAST LONDON STP    QKK00   \n",
       "232         NHS PRACTITIONER HEALTH PROGRAMME    AT000   \n",
       "233     YORKSHIRE AMBULANCE SERVICE NHS TRUST    RX800   \n",
       "234  BIRMINGHAM COMMUNITY HC FOUNDATION TRUST    RYW00   \n",
       "235                            HEALTHHARMONIE    NO000   \n",
       "236      BIRMINGHAM WOMANS & CHILDRENS NHS FT    RQ300   \n",
       "237             AIREDALE NHS FOUNDATION TRUST    RCF00   \n",
       "238               YORK & SCARBOROUGH TH NHSFT    RCB00   \n",
       "239    GLOUCESTERSHIRE HEALTH AND CARE NHS FT    RTQ00   \n",
       "240                TETBURY HOSPITAL TRUST LTD    AAH00   \n",
       "241     UNIVERSITY HOSPITALS OF MORECAMBE BAY    RTX00   \n",
       "242                   ISLE OF WIGHT NHS TRUST    R1F00   \n",
       "243          STOCKTON ON TEES LOCAL AUTHORITY    11400   \n",
       "244                                     START    GDV00   \n",
       "245          CITY HEALTH CARE PARTNERSHIP CIC    NNF00   \n",
       "246                          KIRKLEES COUNCIL    21100   \n",
       "247                                     LIVES    GCV00   \n",
       "248    GREAT WESTERN HPL NHS FOUNDATION TRUST    RN300   \n",
       "249             WILTSHIRE HEALTH AND CARE LLP    AXG00   \n",
       "250   GLOUCESTERSHIRE CARE SERVICES NHS TRUST    R1J00   \n",
       "251   BATH & NE SOMERSET, SWINDON & WILTS STP    QOX00   \n",
       "252                       PRACTICE PLUS GROUP    NTP00   \n",
       "253     ASHFORD & ST PETER'S HOSPITALS NHS FT    RTK00   \n",
       "254                                 CRANSTOUN    DLA00   \n",
       "255                    WEST BERKSHIRE COUNCIL    61500   \n",
       "256                                CSH SURREY    NTV00   \n",
       "257     SURREY AND BORDERS PARTNERSHIP NHS FT    RXX00   \n",
       "258     EPSOM & ST HELIER UNIV HPLS NHS TRUST    RVR00   \n",
       "259   SOUTH WARWICKSHIRE NHS FOUNDATION TRUST    RJC00   \n",
       "260      MIDLANDS P/SHIP NHS FOUNDATION TRUST    RRE00   \n",
       "261                LANCASTER HOUSE CONSULTING    NLE00   \n",
       "262                    COMMUNITAS CLINICS LTD    NLG00   \n",
       "263                     WEST LONDON NHS TRUST    RKL00   \n",
       "264   NW LONDON HEALTH & CARE PARTNERSHIP STP    QRV00   \n",
       "265         WEST SUFFOLK NHS FOUNDATION TRUST    RGR00   \n",
       "266         HERTFORDSHIRE COMMUNITY NHS TRUST    RY400   \n",
       "267      EAST LANCASHIRE MEDICAL SERVICES LTD    AC000   \n",
       "268     HARROGATE & DISTRICT FOUNDATION TRUST    RCD00   \n",
       "269  HEALTHIER LANCASHIRE & SOUTH CUMBRIA STP    QE100   \n",
       "270         LANCASHIRE & SOUTH CUMBRIA NHS FT    RW500   \n",
       "271                        DELPHI MEDICAL LTD    AKQ00   \n",
       "272                COMMUNITY HEALTH & EYECARE    AAV00   \n",
       "273    HEREFORDSHIRE&WORCESTERSHIRE H&C NHS T    R1A00   \n",
       "274                      WYE VALLEY NHS TRUST    RLQ00   \n",
       "275                 BIRMINGHAM & SOLIHULL STP    QHL00   \n",
       "276                  WWL NHS FOUNDATION TRUST    RRF00   \n",
       "277                             WIGAN COUNCIL    31300   \n",
       "278           NOTTINGHAM CITYCARE PARTNERSHIP    NR300   \n",
       "279    NOTTINGHAMSHIRE HEALTHCARE NHS F TRUST    RHA00   \n",
       "280       SHERWOOD FOREST HOSPITALS NHS TRUST    RK500   \n",
       "281                              BURY COUNCIL    30500   \n",
       "282   GREATER MANCHESTER MENTAL HEALTH NHS FT    RXV00   \n",
       "283    GREATER MANCHESTER HSC PARTNERSHIP STP    QOP00   \n",
       "284     EAST KENT HOSPITALS UNIVERSITY NHS FT    RVV00   \n",
       "285            FAVESRHAM MEDICAL PRACTICE MIU    AQM00   \n",
       "286                                DORSET STP    QVV00   \n",
       "287                    INTEGRATED CARE 24 LTD    NVE00   \n",
       "288                         KENT & MEDWAY STP    QKS00   \n",
       "289       BUCKINGHAMSHIRE HOSPITALS NHS TRUST    RXQ00   \n",
       "290        OXFORD HEALTH NHS FOUNDATION TRUST    RNU00   \n",
       "291   BUCKS, OXFORDSHIRE & BERKSHIRE WEST STP    QU900   \n",
       "292                          INHEALTH LIMITED    NV100   \n",
       "293         OPEROSE HEALTH (GROUP) UK LIMITED    NX100   \n",
       "294              PRIMARY EYECARE SERVICES LTD    AFW00   \n",
       "295               PENNINE MSK PARTNERSHIP LTD    NLF00   \n",
       "296                 CHESHIRE & MERSEYSIDE STP    QYG00   \n",
       "297                   MID AND SOUTH ESSEX STP    QH800   \n",
       "298                WARRINGTON BOROUGH COUNCIL    32200   \n",
       "299   WARRINGTON & HALTON TEACHING HOSP NHSFT    RWW00   \n",
       "300           NORTH EAST LINCOLNSHIRE COUNCIL    21600   \n",
       "301   DERBYSHIRE COMM HLTH SERVICES NHS TRUST    RY800   \n",
       "302     LINCOLNSHIRE & DISTRICTS MED SERVICES    NBF00   \n",
       "303             JOINED UP CARE DERBYSHIRE STP    QJ200   \n",
       "304              DERBYSHIRE HEALTHCARE NHS FT    RXM00   \n",
       "305  THE NEWCASTLE UPON TYNE HPL NHS FOUND TR    RTD00   \n",
       "306          EAST SUSSEX HEALTHCARE NHS TRUST    RXC00   \n",
       "307                                      HERE    NWX00   \n",
       "308           SOUTH DOWNS HEALTH AND CARE LTD    DKL00   \n",
       "309  SOUTH EAST COAST AMBULANCE SERVICE NHSFT    RYD00   \n",
       "310      SUSSEX COMMUNITY DERMATOLOGY SERVICE    NYG00   \n",
       "311                       ST MICHAELS HOSPICE    ARD00   \n",
       "312                      ST WILFRID'S HOSPICE    ARF00   \n",
       "313     SUSSEX COMMUNITY NHS FOUNDATION TRUST    RDR00   \n",
       "314                  SUSSEX & EAST SURREY STP    QNX00   \n",
       "315        UNIVERSITY HOSPITALS SUSSEX NHS FT    RYR00   \n",
       "316                         THE SUSSEX BEACON    AE800   \n",
       "317                              ABOUT HEALTH    NPR00   \n",
       "318              COUNTESS MOUNTBATTEN HOSPICE    GAX00   \n",
       "319         HAMPSHIRE & THE ISLE OF WIGHT STP    QRL00   \n",
       "320                        LEEDS CITY COUNCIL    21200   \n",
       "321                 ONE MEDICAL GROUP LIMITED    AXT00   \n",
       "322      LEEDS COMMUNITY HEALTHCARE NHS TRUST    RY600   \n",
       "323                          NOVUS HEALTH LTD    NQH00   \n",
       "324         LOCALA COMMUNITY PARTNERSHIPS CIC    NL800   \n",
       "325    W YORKSHIRE & HARROGATE H&C P/SHIP STP    QWO00   \n",
       "326              PHOENIX HEALTH SOLUTIONS LTD    NEQ00   \n",
       "327                 SPECTRUM COMMUNITY HEALTH    NL100   \n",
       "328        HEREFORDSHIRE & WORCESTERSHIRE STP    QGH00   \n",
       "329     SURREY HEARTLANDS H&C PARTNERSHIP STP    QXU00   \n",
       "330      HUMBER TEACHING NHS FOUNDATION TRUST    RV900   \n",
       "331                  HUMBER, COAST & VALE STP    QOQ00   \n",
       "332           NAVIGO HEALTH & SOCIAL CARE CIC    NQL00   \n",
       "\n",
       "                                   PCO_NAME_y  \n",
       "0           NHS NORFOLK AND WAVENEY ICB - 26A  \n",
       "1       NHS CHESHIRE AND MERSEYSIDE ICB - 01J  \n",
       "2    NHS HUMBER AND NORTH YORKSHIRE ICB - 03Q  \n",
       "3       NHS CHESHIRE AND MERSEYSIDE ICB - 01T  \n",
       "4       NHS CHESHIRE AND MERSEYSIDE ICB - 27D  \n",
       "5    NHS LEICESTER, LEICESTERSHIRE AND RUTLAN  \n",
       "6       NHS CHESHIRE AND MERSEYSIDE ICB - 01X  \n",
       "7    NHS BUCKINGHAMSHIRE, OXFORDSHIRE AND BER  \n",
       "8    NHS BRISTOL, NORTH SOMERSET AND SOUTH GL  \n",
       "9            NHS GREATER MANCHESTER ICB - 00V  \n",
       "10            NHS SOUTH WEST LONDON ICB - 36L  \n",
       "11   NHS LANCASHIRE AND SOUTH CUMBRIA ICB - 0  \n",
       "12   NHS NORTH EAST AND NORTH CUMBRIA ICB - 0  \n",
       "13   NHS HAMPSHIRE AND ISLE OF WIGHT ICB - D9  \n",
       "14              NHS BLACK COUNTRY ICB - D2P2L  \n",
       "15   NHS BEDFORDSHIRE, LUTON AND MILTON KEYNE  \n",
       "16      NHS CHESHIRE AND MERSEYSIDE ICB - 99A  \n",
       "17      NHS CHESHIRE AND MERSEYSIDE ICB - 01V  \n",
       "18           NHS SURREY HEARTLANDS  ICB - 92A  \n",
       "19   NHS BUCKINGHAMSHIRE, OXFORDSHIRE AND BER  \n",
       "20   NHS LANCASHIRE AND SOUTH CUMBRIA ICB - 0  \n",
       "21          NHS NORTH WEST LONDON ICB - W2U3Z  \n",
       "22   LONDON CENTRAL AND WEST UNSCHEDULED CARE  \n",
       "23         NHS NORTH CENTRAL LONDON ICB - 93C  \n",
       "24                      GREENBROOK HEALTHCARE  \n",
       "25   NHS NORTH EAST AND NORTH CUMBRIA ICB - 9  \n",
       "26   NHS LANCASHIRE AND SOUTH CUMBRIA ICB - 0  \n",
       "27   NHS CAMBRIDGESHIRE AND PETERBOROUGH ICB   \n",
       "28   NHS LANCASHIRE AND SOUTH CUMBRIA ICB - 0  \n",
       "29   NHS LANCASHIRE AND SOUTH CUMBRIA ICB - 0  \n",
       "30   NHS LANCASHIRE AND SOUTH CUMBRIA ICB - 0  \n",
       "31           NHS GREATER MANCHESTER ICB - 00T  \n",
       "32   NHS LANCASHIRE AND SOUTH CUMBRIA ICB - 0  \n",
       "33                            PDS MEDICAL LTD  \n",
       "34   NORTHUMBRIA HEALTHCARE NHS FOUNDATION TR  \n",
       "35   NHS CORNWALL AND THE ISLES OF SCILLY ICB  \n",
       "36   NORTH TEES AND HARTLEPOOL NHS FOUNDATION  \n",
       "37   SOUTH TEES HOSPITALS NHS FOUNDATION TRUS  \n",
       "38       REDCAR AND CLEVELAND BOROUGH COUNCIL  \n",
       "39          NHS NORTH EAST LONDON ICB - A3A8R  \n",
       "40             NHS WEST YORKSHIRE ICB - X2C4Y  \n",
       "41                     SIRONA CARE AND HEALTH  \n",
       "42            NHS SOUTH EAST LONDON ICB - 72Q  \n",
       "43                       NHS DORSET ICB - 11J  \n",
       "44   SOUTH TYNESIDE AND SUNDERLAND NHS FOUNDA  \n",
       "45   NHS NORTH EAST AND NORTH CUMBRIA ICB - 0  \n",
       "46              SOMERSET SURGICAL SERVICES HQ  \n",
       "47                         WESTON HOSPICECARE  \n",
       "48           NHS GREATER MANCHESTER ICB - 02H  \n",
       "49           NHS GREATER MANCHESTER ICB - 02A  \n",
       "50      NHS CHESHIRE AND MERSEYSIDE ICB - 01F  \n",
       "51   NHS BUCKINGHAMSHIRE, OXFORDSHIRE AND BER  \n",
       "52   NHS COVENTRY AND WARWICKSHIRE ICB - B2M3  \n",
       "53   NHS STAFFORDSHIRE AND STOKE-ON-TRENT ICB  \n",
       "54                     HCRG CARE SERVICES LTD  \n",
       "55                              HCRG CARE LTD  \n",
       "56                                     ISIGHT  \n",
       "57   NHS BRISTOL, NORTH SOMERSET AND SOUTH GL  \n",
       "58    UNIVERSITY HOSPITALS PLYMOUTH NHS TRUST  \n",
       "59            BRISDOC HEALTHCARE SERVICES LTD  \n",
       "60                              PSYCHIATRY-UK  \n",
       "61   NHS STAFFORDSHIRE AND STOKE-ON-TRENT ICB  \n",
       "62               NHS WEST YORKSHIRE ICB - 15F  \n",
       "63                       NHS SUSSEX ICB - 70F  \n",
       "64              NHS KENT AND MEDWAY ICB - 91Q  \n",
       "65                    NHS FRIMLEY ICB - D4U1Y  \n",
       "66           NHS GREATER MANCHESTER ICB - 00Y  \n",
       "67           NHS GREATER MANCHESTER ICB - 14L  \n",
       "68   NHS NORTH EAST AND NORTH CUMBRIA ICB - 0  \n",
       "69                             GTD HEALTHCARE  \n",
       "70           NHS GREATER MANCHESTER ICB - 01D  \n",
       "71                        NHS DEVON ICB - 15N  \n",
       "72   NHS LEICESTER, LEICESTERSHIRE AND RUTLAN  \n",
       "73   NHS HERTFORDSHIRE AND WEST ESSEX ICB - 0  \n",
       "74          NHS MID AND SOUTH ESSEX ICB - 99G  \n",
       "75             NHS NORTHAMPTONSHIRE ICB - 78H  \n",
       "76   NHS NOTTINGHAM AND NOTTINGHAMSHIRE ICB -  \n",
       "77   NHS HEREFORDSHIRE AND WORCESTERSHIRE ICB  \n",
       "78               NHS WEST YORKSHIRE ICB - 36J  \n",
       "79                     NHS SOMERSET ICB - 11X  \n",
       "80   NHS BATH AND NORTH EAST SOMERSET, SWINDO  \n",
       "81          NHS MID AND SOUTH ESSEX ICB - 06Q  \n",
       "82              SOMERSET NHS FOUNDATION TRUST  \n",
       "83   NHS NORTH EAST AND NORTH CUMBRIA ICB - 0  \n",
       "84                 NHS LINCOLNSHIRE ICB - 71E  \n",
       "85   NHS HAMPSHIRE AND ISLE OF WIGHT ICB - 10  \n",
       "86   NHS HUMBER AND NORTH YORKSHIRE ICB - 03F  \n",
       "87   NHS HUMBER AND NORTH YORKSHIRE ICB - 02Y  \n",
       "88   NHS NORTH EAST AND NORTH CUMBRIA ICB - 1  \n",
       "89   NHS HUMBER AND NORTH YORKSHIRE ICB - 42D  \n",
       "90      THE DUDLEY GROUP NHS FOUNDATION TRUST  \n",
       "91   SANDWELL AND WEST BIRMINGHAM HOSPITALS N  \n",
       "92              NHS GLOUCESTERSHIRE ICB - 11M  \n",
       "93   BLACK COUNTRY HEALTHCARE NHS YORK AND SC  \n",
       "94          THE ROYAL WOLVERHAMPTON NHS TRUST  \n",
       "95    NHS BLACK COUNTRY INTEGRATED CARE BOARD  \n",
       "96   COVENTRY AND WARWICKSHIRE PARTNERSHIP NH  \n",
       "97                    SUNDERLAND CITY COUNCIL  \n",
       "98         NHS DERBY AND DERBYSHIRE ICB - 15M  \n",
       "99   NHS NORTH EAST AND NORTH CUMBRIA ICB - 8  \n",
       "100     NHS BIRMINGHAM AND SOLIHULL ICB - 15E  \n",
       "101          NHS GREATER MANCHESTER ICB - 01G  \n",
       "102  MANCHESTER UNIVERSITY NHS FOUNDATION TRU  \n",
       "103  NHS NORTH EAST AND NORTH CUMBRIA ICB - 1  \n",
       "104             NHS SOUTH YORKSHIRE ICB - 03N  \n",
       "105             NHS SOUTH YORKSHIRE ICB - 03L  \n",
       "106  NHS HERTFORDSHIRE AND WEST ESSEX ICB - 0  \n",
       "107  NHS NORTH EAST AND NORTH CUMBRIA INTEGRA  \n",
       "108  CUMBRIA,NORTHUMBERLAND,TYNE AND WEAR NHS  \n",
       "109                DARLINGTON BOROUGH COUNCIL  \n",
       "110                     DURHAM COUNTY COUNCIL  \n",
       "111    GATESHEAD METROPOLITAN BOROUGH COUNCIL  \n",
       "112             MIDDLESBROUGH BOROUGH COUNCIL  \n",
       "113                HARTLEPOOL BOROUGH COUNCIL  \n",
       "114                                 HUMANKIND  \n",
       "115                    NEWCASTLE CITY COUNCIL  \n",
       "116     NHS CHESHIRE AND MERSEYSIDE ICB - 02E  \n",
       "117  NHS LEICESTER, LEICESTERSHIRE AND RUTLAN  \n",
       "118          NHS GREATER MANCHESTER ICB - 01W  \n",
       "119  HOMERTON UNIVERSITY HOSPITAL NHS FOUNDAT  \n",
       "120                                      LIVI  \n",
       "121  NHS HERTFORDSHIRE AND WEST ESSEX ICB - 0  \n",
       "122  ST GEORGE'S UNIVERSITY HOSPITALS NHS FOU  \n",
       "123  NHS SOUTH WEST LONDON INTEGRATED CARE BO  \n",
       "124               BOLTON NHS FOUNDATION TRUST  \n",
       "125              NHS WEST YORKSHIRE ICB - 03R  \n",
       "126  NHS STAFFORDSHIRE AND STOKE-ON-TRENT ICB  \n",
       "127              NHS WEST YORKSHIRE ICB - 02T  \n",
       "128  BRADFORD DISTRICT CARE NHS YORK AND SCAR  \n",
       "129     NHS CHESHIRE AND MERSEYSIDE ICB - 12F  \n",
       "130                      NHS SUSSEX ICB - 97R  \n",
       "131           NHS DEVON INTEGRATED CARE BOARD  \n",
       "132             EDP DRUG AND ALCOHOL SERVICES  \n",
       "133   ROYAL DEVON UNIVERSITY HEALTHCARE NHSFT  \n",
       "134                        LIVEWELL SOUTHWEST  \n",
       "135  SENTINEL HEALTHCARE SOUTHWEST COMMUNITY   \n",
       "136  WIRRAL COMMUNITY HEALTH AND CARE NHS FOU  \n",
       "137  SOUTH WESTERN AMBULANCE SERVICE NHS FOUN  \n",
       "138  TORBAY AND SOUTH DEVON NHS FOUNDATION TR  \n",
       "139             NHS SOUTH YORKSHIRE ICB - 02P  \n",
       "140  NHS NOTTINGHAM AND NOTTINGHAMSHIRE ICB -  \n",
       "141  SOUTH CENTRAL AMBULANCE SERVICE NHS FOUN  \n",
       "142                      NHS SUSSEX ICB - 09D  \n",
       "143         NHS MID AND SOUTH ESSEX ICB - 99E  \n",
       "144         NHS MID AND SOUTH ESSEX ICB - 99F  \n",
       "145  NHS SUFFOLK AND NORTH EAST ESSEX ICB - 0  \n",
       "146  NHS SUFFOLK AND NORTH EAST ESSEX ICB - 0  \n",
       "147               MEDWAY COMMUNITY HEALTHCARE  \n",
       "148  KENT COMMUNITY HEALTH NHS FOUNDATION TRU  \n",
       "149  ROTHERHAM DONCASTER AND SOUTH HUMBER NHS  \n",
       "150               WHITSTABLE MEDICAL PRACTICE  \n",
       "151             NEW HAYESBANK SURGERY CLINICS  \n",
       "152           SYDENHAM HOUSE MEDICAL PRACTICE  \n",
       "153                    SELLINDGE PRACTICE LTD  \n",
       "154        THE HERNE BAY OPHTHALMOLOGY CLINIC  \n",
       "155  NHS STAFFORDSHIRE AND STOKE-ON-TRENT ICB  \n",
       "156          NHS GREATER MANCHESTER ICB - 01Y  \n",
       "157                        CHANGE, GROW, LIVE  \n",
       "158  NHS SUFFOLK AND NORTH EAST ESSEX ICB - 0  \n",
       "159  CONSULTANT EYE SURGEONS PARTNERSHIP (CAN  \n",
       "160  NORTH STAFFORDSHIRE COMBINED HEALTHCARE   \n",
       "161  NHS STAFFORDSHIRE AND STOKE-ON-TRENT ICB  \n",
       "162    STOCKPORT METROPOLITAN BOROUGH COUNCIL  \n",
       "163         NHS MID AND SOUTH ESSEX ICB - 07G  \n",
       "164  LINCOLNSHIRE COMMUNITY HEALTH SERVICES N  \n",
       "165   RAMSAY HEALTHCARE UK OPERATIONS LIMITED  \n",
       "166  EAST SUFFOLK AND NORTH ESSEX NHS FOUNDAT  \n",
       "167  ESSEX PARTNERSHIP UNIVERSITY NHS FOUNDAT  \n",
       "168  NHS BEDFORDSHIRE, LUTON AND MILTON KEYNE  \n",
       "169  NHS STAFFORDSHIRE AND STOKE-ON-TRENT ICB  \n",
       "170  NORTH CUMBRIA INTEGRATED CARE NHS FOUNDA  \n",
       "171  NHS STAFFORDSHIRE AND STOKE-ON-TRENT INT  \n",
       "172  NORTH EAST AMBULANCE SERVICE NHS FOUNDAT  \n",
       "173             NHS SOUTH YORKSHIRE ICB - 02X  \n",
       "174  NHS HUMBER AND NORTH YORKSHIRE ICB - 03K  \n",
       "175  NHS HUMBER AND NORTH YORKSHIRE ICB - 03H  \n",
       "176            NORTH YORKSHIRE COUNTY COUNCIL  \n",
       "177          MERSEY CARE NHS FOUNDATION TRUST  \n",
       "178  LIVERPOOL UNIVERSITY HOSPITALS NHS FOUND  \n",
       "179  NORFOLK COMMUNITY HEALTH AND CARE NHS TR  \n",
       "180  NHS CAMBRIDGESHIRE AND PETERBOROUGH INTE  \n",
       "181  NHS LANCASHIRE AND SOUTH CUMBRIA ICB - 0  \n",
       "182        LONDON AMBULANCE SERVICE NHS TRUST  \n",
       "183  LONDON NORTH WEST UNIVERSITY HEALTHCARE   \n",
       "184                     MILLENNIUM HEALTH LTD  \n",
       "185                  LLR PROVIDER COMPANY LTD  \n",
       "186  NHS LEICESTER, LEICESTERSHIRE AND RUTLAN  \n",
       "187  BERKSHIRE HEALTHCARE NHS FOUNDATION TRUS  \n",
       "188           SOLENT MEDICAL SERVICES LIMITED  \n",
       "189                          SOLENT NHS TRUST  \n",
       "190                   THE SOCIETY OF ST JAMES  \n",
       "191  NHS SHROPSHIRE, TELFORD AND WREKIN ICB -  \n",
       "192                       ST JOSEPH'S HOSPICE  \n",
       "193                             TURNING POINT  \n",
       "194  PRACTICE BASED CLINICAL SERVICES LIMITED  \n",
       "195   TOWER HAMLETS TOBACCO CESSATION SERVICE  \n",
       "196                                 FRAMEWORK  \n",
       "197  NHS NORTHAMPTONSHIRE INTEGRATED CARE BOA  \n",
       "198  CENTRA AND NORTH WEST LONDON NHS FOUNDAT  \n",
       "199  NHS NOTTINGHAM AND NOTTINGHAMSHIRE INTEG  \n",
       "200                     SUFFOLK GP FEDERATION  \n",
       "201                    SUFFOLK COUNTY COUNCIL  \n",
       "202  NHS SUFFOLK AND NORTH EAST ESSEX INTEGRA  \n",
       "203  CHESHIRE & WIRRAL PARTNERSHIP NHS FOUNDA  \n",
       "204  BRIDGEWATER COMMUNITY HEALTHCARE NHS FOU  \n",
       "205        THE ROTHERHAM NHS FOUNDATION TRUST  \n",
       "206  NHS SOUTH YORKSHIRE INTEGRATED CARE BOAR  \n",
       "207  SHEFFIELD CHILDREN'S NHS FOUNDATION TRUS  \n",
       "208                    CONNECT HEALTH LIMITED  \n",
       "209   COASTAL HEALTH GP PROVIDER ORGANISATION  \n",
       "210  NHS NORFOLK AND WAVENEY INTEGRATED CARE   \n",
       "211     SHROPSHIRE COMMUNITY HEALTH NHS TRUST  \n",
       "212  NHS SHROPSHIRE, TELFORD AND WREKIN INTEG  \n",
       "213  NORTH MIDDLESEX UNIVERSITY HOSPITAL NHS   \n",
       "214                           WE ARE WITH YOU  \n",
       "215                 WESTMINISTER DRUG PROJECT  \n",
       "216  CENTRAL LONDON COMMUNITY HEALTHCARE NHS   \n",
       "217                                    CIRCLE  \n",
       "218                                    VOCARE  \n",
       "219                              UNIDENTIFIED  \n",
       "220                        BROMLEY HEALTHCARE  \n",
       "221                            BMI HEALTHCARE  \n",
       "222  GUY'S AND ST THOMAS' NHS FOUNDATION TRUS  \n",
       "223         DMC COMMUNITY OUTPATIENT SERVICES  \n",
       "224                         THE FORWARD TRUST  \n",
       "225       CONCORDIA COMMUNITY OUTPATIENTS LTD  \n",
       "226  KING'S COLLEGE HOSPITAL NHS FOUNDATION T  \n",
       "227                      OMNES HEALTHCARE LTD  \n",
       "228               OXLEAS NHS FOUNDATION TRUST  \n",
       "229          LEWISHAM AND GREENWICH NHS TRUST  \n",
       "230               NEW MEDICAL SYSTEMS LIMITED  \n",
       "231  NHS SOUTH EAST LONDON INTEGRATED CARE BO  \n",
       "232                   NHS PRACTITIONER HEALTH  \n",
       "233     YORKSHIRE AMBULANCE SERVICE NHS TRUST  \n",
       "234  BIRMINGHAM COMMUNITY HEALTHCARE NHS FOUN  \n",
       "235                    HEALTHHARMONIE LIMITED  \n",
       "236  BIRMINGHAM WOMEN'S AND CHILDREN'S NHS FO  \n",
       "237             AIREDALE NHS FOUNDATION TRUST  \n",
       "238  YORK AND SCARBOROUGH TEACHING HOSPITALS   \n",
       "239  GLOUCESTERSHIRE HEALTH AND CARE NHS FOUN  \n",
       "240                TETBURY HOSPITAL TRUST LTD  \n",
       "241  UNIVERSITY HOSPITALS OF MORECAMBE BAY NH  \n",
       "242                   ISLE OF WIGHT NHS TRUST  \n",
       "243          STOCKTON-ON-TEES BOROUGH COUNCIL  \n",
       "244                                     START  \n",
       "245          CITY HEALTH CARE PARTNERSHIP CIC  \n",
       "246                          KIRKLEES COUNCIL  \n",
       "247                                     LIVES  \n",
       "248  GREAT WESTERN HOSPITALS NHS FOUNDATION T  \n",
       "249                   WILTSHIRE HEALTH & CARE  \n",
       "250   GLOUCESTERSHIRE CARE SERVICES NHS TRUST  \n",
       "251  NHS BATH AND NORTH EAST SOMERSET, SWINDO  \n",
       "252                       PRACTICE PLUS GROUP  \n",
       "253  ASHFORD & ST PETER'S HOSPITALS NHS FOUND  \n",
       "254                                 CRANSTOUN  \n",
       "255                    WEST BERKSHIRE COUNCIL  \n",
       "256                                CSH SURREY  \n",
       "257  SURREY AND BORDERS PARTNERSHIP NHS FOUND  \n",
       "258  EPSOM AND ST HELIER UNIVERSITY HOSPITALS  \n",
       "259   SOUTH WARWICKSHIRE NHS FOUNDATION TRUST  \n",
       "260  MIDLANDS PARTNERSHIP NHS FOUNDATION TRUS  \n",
       "261  LANCASTER HOUSE CONSULTING DIAGNOSTICS S  \n",
       "262                        COMMUNITAS CLINICS  \n",
       "263                     WEST LONDON NHS TRUST  \n",
       "264  NHS NORTH WEST LONDON INTEGRATED CARE BO  \n",
       "265         WEST SUFFOLK NHS FOUNDATION TRUST  \n",
       "266         HERTFORDSHIRE COMMUNITY NHS TRUST  \n",
       "267      EAST LANCASHIRE MEDICAL SERVICES LTD  \n",
       "268  HARROGATE AND DISTRICT NHS FOUNDATION TR  \n",
       "269  NHS LANCASHIRE AND SOUTH CUMBRIA INTEGRA  \n",
       "270  LANCASHIRE & SOUTH CUMBRIA NHS FOUNDATIO  \n",
       "271                        DELPHI MEDICAL LTD  \n",
       "272        COMMUNITY HEALTH & EYECARE LIMITED  \n",
       "273  HEREFORDSHIRE AND WORCESTERSHIRE HEALTH   \n",
       "274                      WYE VALLEY NHS TRUST  \n",
       "275  NHS BIRMINGHAM AND SOLIHULL INTEGRATED C  \n",
       "276  WRIGHTINGTON, WIGAN AND LEIGH NHS FOUNDA  \n",
       "277        WIGAN METROPOLITAN BOROUGH COUNCIL  \n",
       "278           NOTTINGHAM CITYCARE PARTNERSHIP  \n",
       "279  NOTTINGHAMSHIRE HEALTHCARE NHS FOUNDATIO  \n",
       "280  SHERWOOD FOREST HOSPITALS NHS FOUNDATION  \n",
       "281         BURY METROPOLITAN BOROUGH COUNCIL  \n",
       "282  GREATER MANCHESTER MENTAL HEALTH NHS FOU  \n",
       "283  NHS GREATER MANCHESTER INTEGRATED CARE B  \n",
       "284  EAST KENT HOSPITALS UNIVERSITY NHS FOUND  \n",
       "285            FAVERSHAM MEDICAL PRACTICE MIU  \n",
       "286          NHS DORSET INTEGRATED CARE BOARD  \n",
       "287                    INTEGRATED CARE 24 LTD  \n",
       "288  NHS KENT AND MEDWAY INTEGRATED CARE BOAR  \n",
       "289      BUCKINGHAMSHIRE HEALTHCARE NHS TRUST  \n",
       "290        OXFORD HEALTH NHS FOUNDATION TRUST  \n",
       "291  NHS BUCKINGHAMSHIRE, OXFORDSHIRE AND BER  \n",
       "292                          INHEALTH LIMITED  \n",
       "293         OPEROSE HEALTH (GROUP) UK LIMITED  \n",
       "294              PRIMARY EYECARE SERVICES LTD  \n",
       "295  PENNINE MUSCULOSKELETAL PARTNERSHIP (ICA  \n",
       "296  NHS CHESHIRE AND MERSEYSIDE INTEGRATED C  \n",
       "297  NHS MID AND SOUTH ESSEX INTEGRATED CARE   \n",
       "298                WARRINGTON BOROUGH COUNCIL  \n",
       "299  WARRINGTON AND HALTON TEACHING HOSPITALS  \n",
       "300           NORTH EAST LINCOLNSHIRE COUNCIL  \n",
       "301  DERBYSHIRE COMMUNITY HEALTH SERVICES NHS  \n",
       "302  LINCOLNSHIRE AND DISTRICTS MEDICAL SERVI  \n",
       "303  NHS DERBY AND DERBYSHIRE INTEGRATED CARE  \n",
       "304  DERBYSHIRE HEALTHCARE NHS FOUNDATION TRU  \n",
       "305  THE NEWCASTLE UPON TYNE HOSPITALS NHS FO  \n",
       "306          EAST SUSSEX HEALTHCARE NHS TRUST  \n",
       "307                                      HERE  \n",
       "308           SOUTH DOWNS HEALTH AND CARE LTD  \n",
       "309  SOUTH EAST COAST AMBULANCE SERVICE NHS F  \n",
       "310      SUSSEX COMMUNITY DERMATOLOGY SERVICE  \n",
       "311                      ST MICHAEL'S HOSPICE  \n",
       "312                      ST WILFRID'S HOSPICE  \n",
       "313     SUSSEX COMMUNITY NHS FOUNDATION TRUST  \n",
       "314          NHS SUSSEX INTEGRATED CARE BOARD  \n",
       "315  UNIVERSITY HOSPITALS SUSSEX NHS FOUNDATI  \n",
       "316                         THE SUSSEX BEACON  \n",
       "317                              ABOUT HEALTH  \n",
       "318              COUNTESS MOUNTBATTEN HOSPICE  \n",
       "319  NHS HAMPSHIRE AND ISLE OF WIGHT INTEGRAT  \n",
       "320                        LEEDS CITY COUNCIL  \n",
       "321                 ONE MEDICAL GROUP LIMITED  \n",
       "322      LEEDS COMMUNITY HEALTHCARE NHS TRUST  \n",
       "323                          NOVUS HEALTH LTD  \n",
       "324         LOCALA COMMUNITY PARTNERSHIPS CIC  \n",
       "325  NHS WEST YORKSHIRE INTEGRATED CARE BOARD  \n",
       "326       PHOENIX HEALTH SOLUTIONS LIMITED HQ  \n",
       "327           SPECTRUM COMMUNITY HEALTH - CIC  \n",
       "328  NHS HEREFORDSHIRE AND WORCESTERSHIRE INT  \n",
       "329  NHS SURREY HEARTLANDS INTEGRATED CARE BO  \n",
       "330      HUMBER TEACHING NHS FOUNDATION TRUST  \n",
       "331  NHS HUMBER AND NORTH YORKSHIRE INTEGRATE  \n",
       "332         NAVIGO HEALTH AND SOCIAL CARE CIC  "
      ]
     },
     "execution_count": 49,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_merge_pco = pd.merge(dfCCG[['PCO_NAME', 'PCO_CODE']], dfSICBL[['PCO_NAME', 'PCO_CODE']], on='PCO_CODE')\n",
    "pd.set_option('display.max_rows', None)\n",
    "pd.set_option('display.max_colwidth', None)\n",
    "df_merge_pco"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "427c6e6a",
   "metadata": {},
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "id": "ede6bd39",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "339"
      ]
     },
     "execution_count": 50,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(dfCCG.index)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "id": "be3f2a99",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "343"
      ]
     },
     "execution_count": 51,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(dfSICBL.index)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "id": "7d2486f1",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "333"
      ]
     },
     "execution_count": 52,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(df_merge_pco.index)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "b399284b",
   "metadata": {},
   "source": [
    "Small number of none matched PCO_codes April 22 to May 22. Majority match - 333."
   ]
  },
  {
   "cell_type": "markdown",
   "id": "bb4470f8",
   "metadata": {},
   "source": [
    "### Show none matching from April 22 data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "id": "c4c9eac6",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>STP_CODE</th>\n",
       "      <th>STP_NAME</th>\n",
       "      <th>PCO_NAME</th>\n",
       "      <th>PCO_CODE</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2158473</th>\n",
       "      <td>QMF</td>\n",
       "      <td>EAST LONDON HEALTH &amp; CARE P/SHIP STP</td>\n",
       "      <td>BARTS HEALTH NHS TRUST</td>\n",
       "      <td>R1H00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4452231</th>\n",
       "      <td>QKS</td>\n",
       "      <td>KENT &amp; MEDWAY STP</td>\n",
       "      <td>KINGSNORTH MEDICAL SERVICES LTD</td>\n",
       "      <td>ACV00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4472001</th>\n",
       "      <td>QKS</td>\n",
       "      <td>KENT &amp; MEDWAY STP</td>\n",
       "      <td>ONE ASHFORD HEALTHCARE LTD</td>\n",
       "      <td>AVQ00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7298698</th>\n",
       "      <td>QK1</td>\n",
       "      <td>LEICESTER, LEICESTERSHIRE &amp; RUTLAND STP</td>\n",
       "      <td>NORTH CHARNWOOD GP NETWORK LTD</td>\n",
       "      <td>DA800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7899459</th>\n",
       "      <td>QJG</td>\n",
       "      <td>SUFFOLK &amp; NORTH EAST ESSEX STP</td>\n",
       "      <td>PROVIDE</td>\n",
       "      <td>NQA00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10062033</th>\n",
       "      <td>QWO</td>\n",
       "      <td>W YORKSHIRE &amp; HARROGATE H&amp;C P/SHIP STP</td>\n",
       "      <td>LEEDS AND YORK PARTNERSHIP NHS FT</td>\n",
       "      <td>RGD00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         STP_CODE                                 STP_NAME  \\\n",
       "2158473       QMF     EAST LONDON HEALTH & CARE P/SHIP STP   \n",
       "4452231       QKS                        KENT & MEDWAY STP   \n",
       "4472001       QKS                        KENT & MEDWAY STP   \n",
       "7298698       QK1  LEICESTER, LEICESTERSHIRE & RUTLAND STP   \n",
       "7899459       QJG           SUFFOLK & NORTH EAST ESSEX STP   \n",
       "10062033      QWO   W YORKSHIRE & HARROGATE H&C P/SHIP STP   \n",
       "\n",
       "                                   PCO_NAME PCO_CODE  \n",
       "2158473              BARTS HEALTH NHS TRUST    R1H00  \n",
       "4452231     KINGSNORTH MEDICAL SERVICES LTD    ACV00  \n",
       "4472001          ONE ASHFORD HEALTHCARE LTD    AVQ00  \n",
       "7298698      NORTH CHARNWOOD GP NETWORK LTD    DA800  \n",
       "7899459                             PROVIDE    NQA00  \n",
       "10062033  LEEDS AND YORK PARTNERSHIP NHS FT    RGD00  "
      ]
     },
     "execution_count": 54,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dfCCG[~dfCCG['PCO_CODE'].isin(dfSICBL['PCO_CODE'])].dropna()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "b8cc99ab",
   "metadata": {},
   "source": [
    "### Show none matching from May 22 data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 55,
   "id": "4badafe3",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ICB_CODE</th>\n",
       "      <th>ICB_NAME</th>\n",
       "      <th>PCO_NAME</th>\n",
       "      <th>PCO_CODE</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>805472</th>\n",
       "      <td>QHG</td>\n",
       "      <td>NHS BEDFORDSHIRE, LUTON AND MILTON KEYNE</td>\n",
       "      <td>EAST LONDON NHS FOUNDATION TRUST</td>\n",
       "      <td>RWK00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1533462</th>\n",
       "      <td>QSL</td>\n",
       "      <td>NHS SOMERSET INTEGRATED CARE BOARD</td>\n",
       "      <td>ST MARGARETS HOSPICE</td>\n",
       "      <td>AJ300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3290263</th>\n",
       "      <td>QOX</td>\n",
       "      <td>NHS BATH AND NORTH EAST SOMERSET, SWINDO</td>\n",
       "      <td>ROYAL UNITED HOSPITALS BATH NHS FOUNDATI</td>\n",
       "      <td>RD100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10607247</th>\n",
       "      <td>QJM</td>\n",
       "      <td>NHS LINCOLNSHIRE INTEGRATED CARE BOARD</td>\n",
       "      <td>NHS LINCOLNSHIRE INTEGRATED CARE BOARD</td>\n",
       "      <td>QJM00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11191701</th>\n",
       "      <td>QKS</td>\n",
       "      <td>NHS KENT AND MEDWAY INTEGRATED CARE BOAR</td>\n",
       "      <td>CHARING PRACTICE LTD</td>\n",
       "      <td>ACD00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11953361</th>\n",
       "      <td>QNX</td>\n",
       "      <td>NHS SUSSEX INTEGRATED CARE BOARD</td>\n",
       "      <td>FIRST COMMUNITY HEALTH AND CARE CIC</td>\n",
       "      <td>NDJ00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12185571</th>\n",
       "      <td>QJ2</td>\n",
       "      <td>NHS DERBY AND DERBYSHIRE INTEGRATED CARE</td>\n",
       "      <td>CHESTERFIELD ROYAL HOSPITAL NHS FOUNDATI</td>\n",
       "      <td>RFS00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13456908</th>\n",
       "      <td>QWO</td>\n",
       "      <td>NHS WEST YORKSHIRE INTEGRATED CARE BOARD</td>\n",
       "      <td>THE GRANGE MEDICAL CENTRE HQ</td>\n",
       "      <td>AJ800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13649223</th>\n",
       "      <td>QYG</td>\n",
       "      <td>NHS CHESHIRE AND MERSEYSIDE INTEGRATED C</td>\n",
       "      <td>EAST CHESHIRE NHS TRUST</td>\n",
       "      <td>RJN00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16308378</th>\n",
       "      <td>QH8</td>\n",
       "      <td>NHS MID AND SOUTH ESSEX INTEGRATED CARE</td>\n",
       "      <td>MID AND SOUTH ESSEX NHS FOUNDATION TRUST</td>\n",
       "      <td>RAJ00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         ICB_CODE                                  ICB_NAME  \\\n",
       "805472        QHG  NHS BEDFORDSHIRE, LUTON AND MILTON KEYNE   \n",
       "1533462       QSL        NHS SOMERSET INTEGRATED CARE BOARD   \n",
       "3290263       QOX  NHS BATH AND NORTH EAST SOMERSET, SWINDO   \n",
       "10607247      QJM    NHS LINCOLNSHIRE INTEGRATED CARE BOARD   \n",
       "11191701      QKS  NHS KENT AND MEDWAY INTEGRATED CARE BOAR   \n",
       "11953361      QNX          NHS SUSSEX INTEGRATED CARE BOARD   \n",
       "12185571      QJ2  NHS DERBY AND DERBYSHIRE INTEGRATED CARE   \n",
       "13456908      QWO  NHS WEST YORKSHIRE INTEGRATED CARE BOARD   \n",
       "13649223      QYG  NHS CHESHIRE AND MERSEYSIDE INTEGRATED C   \n",
       "16308378      QH8  NHS MID AND SOUTH ESSEX INTEGRATED CARE    \n",
       "\n",
       "                                          PCO_NAME PCO_CODE  \n",
       "805472            EAST LONDON NHS FOUNDATION TRUST    RWK00  \n",
       "1533462                       ST MARGARETS HOSPICE    AJ300  \n",
       "3290263   ROYAL UNITED HOSPITALS BATH NHS FOUNDATI    RD100  \n",
       "10607247    NHS LINCOLNSHIRE INTEGRATED CARE BOARD    QJM00  \n",
       "11191701                      CHARING PRACTICE LTD    ACD00  \n",
       "11953361       FIRST COMMUNITY HEALTH AND CARE CIC    NDJ00  \n",
       "12185571  CHESTERFIELD ROYAL HOSPITAL NHS FOUNDATI    RFS00  \n",
       "13456908              THE GRANGE MEDICAL CENTRE HQ    AJ800  \n",
       "13649223                   EAST CHESHIRE NHS TRUST    RJN00  \n",
       "16308378  MID AND SOUTH ESSEX NHS FOUNDATION TRUST    RAJ00  "
      ]
     },
     "execution_count": 55,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dfSICBL[~dfSICBL['PCO_CODE'].isin(dfCCG['PCO_CODE'])].dropna()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "9d892e25",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "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.9.12"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}