Skip to content

Instantly share code, notes, and snippets.

@psychemedia
Last active July 7, 2020 10:28
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 1 You must be signed in to fork a gist
  • Save psychemedia/0cfa84e5ad7e9d2d1f13 to your computer and use it in GitHub Desktop.
Save psychemedia/0cfa84e5ad7e9d2d1f13 to your computer and use it in GitHub Desktop.
First play with Care Quality Commission ( CQC ) Register data
Display the source blob
Display the rendered blob
Raw
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
Display the source blob
Display the rendered blob
Raw
{
"metadata": {
"name": "",
"signature": "sha256:24d1f25b41e6aaad90538067b80f0756e0c86dcb30e7ff80dc52b1eb38ee6fbc"
},
"nbformat": 3,
"nbformat_minor": 0,
"worksheets": [
{
"cells": [
{
"cell_type": "heading",
"level": 1,
"metadata": {},
"source": [
"Looking For GP Practice Clusters"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Care Quality Commission (CQC) data - http://www.cqc.org.uk/content/how-get-and-re-use-cqc-information-and-data "
]
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"import pandas as pd"
],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 1
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"!mkdir data\n",
"!wget http://www.cqc.org.uk/sites/default/files/HSCA%20Active%20Locations%20September.xlsx -P data"
],
"language": "python",
"metadata": {},
"outputs": []
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"df=pd.read_excel('data/HSCA Active Locations September.xlsx',skiprows=7)"
],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 3
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"df.columns"
],
"language": "python",
"metadata": {},
"outputs": [
{
"metadata": {},
"output_type": "pyout",
"prompt_number": 5,
"text": [
"Index(['Location ID', 'HSCA start date', 'Care home?', 'Location Name', 'Telephone Number', 'Registered manager (note; where there is more than one manager at a location, only one is included here for ease of presentation. The full list is available if required).', 'Web Address', 'Care homes beds', 'Location Type/Sector', 'Region', 'Local Authority', 'Street Address', 'Address Line 2', 'City', 'County', 'Postal Code', 'Brand ID', 'Brand Name', 'Provider ID', 'Provider Name', 'Provider HSCA start date', 'Provider - Telephone Number', 'Provider - Web Address', 'Provider - Street Address', 'Provider - Address Line 2', 'Provider - City', 'Provider - County', 'Provider - Postal Code', 'Provider Nominated Individual Name', 'Regulated activity - Accommodation and nursing or personal care in the further education sector', 'Regulated activity - Accommodation for persons who require nursing or personal care', 'Regulated activity - Accommodation for persons who require treatment for substance misuse', 'Regulated activity - Assessment or medical treatment for persons detained under the Mental Health Act 1983', 'Regulated activity - Diagnostic and screening procedures', 'Regulated activity - Family planning', 'Regulated activity - Management of supply of blood and blood derived products', 'Regulated activity - Maternity and midwifery services', 'Regulated activity - Nursing care', 'Regulated activity - Personal care', 'Regulated activity - Services in slimming clinics', 'Regulated activity - Surgical procedures', 'Regulated activity - Termination of pregnancies', 'Regulated activity - Transport services, triage and medical advice provided remotely', 'Regulated activity - Treatment of disease, disorder or injury', 'Service type - Acute services with overnight beds', 'Service type - Acute services without overnight beds / listed acute services with or without overnight beds', 'Service type - Ambulance service', 'Service type - Blood and Transplant service', 'Service type - Care home service with nursing', 'Service type - Care home service without nursing', 'Service type - Community based services for people who misuse substances', 'Service type - Community based services for people with a learning disability', 'Service type - Community based services for people with mental health needs', 'Service type - Community health care services - Independent Midwives', 'Service type - Community health care services - Nurses Agency only', 'Service type - Community healthcare service', 'Service type - Dental service', 'Service type - Diagnostic and/or screening service', 'Service type - Diagnostic and/or screening service - single handed sessional providers', 'Service type - Doctors consultation service', 'Service type - Doctors treatment service', 'Service type - Domiciliary care service', 'Service type - Extra Care housing services', 'Service type - Hospice services', 'Service type - Hospice services at home', 'Service type - Hospital services for people with mental health needs, learning disabilities and problems with substance misuse', 'Service type - Hyperbaric Chamber', 'Service type - Long term conditions services', 'Service type - Mobile doctors service', 'Service type - Prison Healthcare Services', 'Service type - Rehabilitation services', 'Service type - Remote clinical advice service', 'Service type - Residential substance misuse treatment and/or rehabilitation service', 'Service type - Shared Lives', 'Service type - Specialist college service', 'Service type - Supported living service', 'Service type - Urgent care services', 'Service user band - Children 0-18 years', 'Service user band - Dementia', 'Service user band - Learning disabilities or autistic spectrum disorder', 'Service user band - Mental Health', 'Service user band - Older People', 'Service user band - People detained under the Mental Health Act', 'Service user band - People who misuse drugs and alcohol', 'Service user band - People with an eating disorder', 'Service user band - Physical Disability', 'Service user band - Sensory Impairment', 'Service user band - Whole Population', 'Service user band - Younger Adults'], dtype='object')"
]
}
],
"prompt_number": 5
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"gp=df[df['Service type - Doctors consultation service']=='Y']"
],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 6
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"gp[:3]"
],
"language": "python",
"metadata": {},
"outputs": [
{
"html": [
"<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>Location ID</th>\n",
" <th>HSCA start date</th>\n",
" <th>Care home?</th>\n",
" <th>Location Name</th>\n",
" <th>Telephone Number</th>\n",
" <th>Registered manager (note; where there is more than one manager at a location, only one is included here for ease of presentation. The full list is available if required).</th>\n",
" <th>Web Address</th>\n",
" <th>Care homes beds</th>\n",
" <th>Location Type/Sector</th>\n",
" <th>Region</th>\n",
" <th>...</th>\n",
" <th>Service user band - Learning disabilities or autistic spectrum disorder</th>\n",
" <th>Service user band - Mental Health</th>\n",
" <th>Service user band - Older People</th>\n",
" <th>Service user band - People detained under the Mental Health Act</th>\n",
" <th>Service user band - People who misuse drugs and alcohol</th>\n",
" <th>Service user band - People with an eating disorder</th>\n",
" <th>Service user band - Physical Disability</th>\n",
" <th>Service user band - Sensory Impairment</th>\n",
" <th>Service user band - Whole Population</th>\n",
" <th>Service user band - Younger Adults</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>41</th>\n",
" <td> 1-1002333348</td>\n",
" <td>2013-10-09</td>\n",
" <td> N</td>\n",
" <td> 10 Harley Street</td>\n",
" <td> 02074678301</td>\n",
" <td> *</td>\n",
" <td> www.doctor4u.co.uk</td>\n",
" <td> 0</td>\n",
" <td> Independent Healthcare Org</td>\n",
" <td> London</td>\n",
" <td>...</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> Y</td>\n",
" <td> NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>46</th>\n",
" <td> 1-1002716537</td>\n",
" <td>2013-10-10</td>\n",
" <td> N</td>\n",
" <td> Surrey Heart Clinic</td>\n",
" <td> 01932504999</td>\n",
" <td> Ohri, Anil</td>\n",
" <td> NaN</td>\n",
" <td> 0</td>\n",
" <td> Independent Healthcare Org</td>\n",
" <td> South East</td>\n",
" <td>...</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> Y</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> Y</td>\n",
" </tr>\n",
" <tr>\n",
" <th>50</th>\n",
" <td> 1-1004459443</td>\n",
" <td>2013-10-14</td>\n",
" <td> N</td>\n",
" <td> Park Health Care Centre</td>\n",
" <td> NaN</td>\n",
" <td> Chowdhury, Golam</td>\n",
" <td> NaN</td>\n",
" <td> 0</td>\n",
" <td> Primary Medical Services</td>\n",
" <td> Yorkshire and The Humber</td>\n",
" <td>...</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> Y</td>\n",
" <td> NaN</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>3 rows \u00d7 89 columns</p>\n",
"</div>"
],
"metadata": {},
"output_type": "pyout",
"prompt_number": 7,
"text": [
" Location ID HSCA start date Care home? Location Name \\\n",
"41 1-1002333348 2013-10-09 N 10 Harley Street \n",
"46 1-1002716537 2013-10-10 N Surrey Heart Clinic \n",
"50 1-1004459443 2013-10-14 N Park Health Care Centre \n",
"\n",
" Telephone Number \\\n",
"41 02074678301 \n",
"46 01932504999 \n",
"50 NaN \n",
"\n",
" Registered manager (note; where there is more than one manager at a location, only one is included here for ease of presentation. The full list is available if required). \\\n",
"41 * \n",
"46 Ohri, Anil \n",
"50 Chowdhury, Golam \n",
"\n",
" Web Address Care homes beds Location Type/Sector \\\n",
"41 www.doctor4u.co.uk 0 Independent Healthcare Org \n",
"46 NaN 0 Independent Healthcare Org \n",
"50 NaN 0 Primary Medical Services \n",
"\n",
" Region ... \\\n",
"41 London ... \n",
"46 South East ... \n",
"50 Yorkshire and The Humber ... \n",
"\n",
" Service user band - Learning disabilities or autistic spectrum disorder \\\n",
"41 NaN \n",
"46 NaN \n",
"50 NaN \n",
"\n",
" Service user band - Mental Health Service user band - Older People \\\n",
"41 NaN NaN \n",
"46 NaN Y \n",
"50 NaN NaN \n",
"\n",
" Service user band - People detained under the Mental Health Act \\\n",
"41 NaN \n",
"46 NaN \n",
"50 NaN \n",
"\n",
" Service user band - People who misuse drugs and alcohol \\\n",
"41 NaN \n",
"46 NaN \n",
"50 NaN \n",
"\n",
" Service user band - People with an eating disorder \\\n",
"41 NaN \n",
"46 NaN \n",
"50 NaN \n",
"\n",
" Service user band - Physical Disability \\\n",
"41 NaN \n",
"46 NaN \n",
"50 NaN \n",
"\n",
" Service user band - Sensory Impairment \\\n",
"41 NaN \n",
"46 NaN \n",
"50 NaN \n",
"\n",
" Service user band - Whole Population Service user band - Younger Adults \n",
"41 Y NaN \n",
"46 NaN Y \n",
"50 Y NaN \n",
"\n",
"[3 rows x 89 columns]"
]
}
],
"prompt_number": 7
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"gpm=gp[['Location ID', 'HSCA start date', 'Care home?', 'Location Name', 'Web Address', 'Care homes beds', 'Location Type/Sector', 'Region', 'Local Authority', 'Street Address', 'City', 'County', 'Postal Code', 'Brand ID', 'Brand Name', 'Provider ID', 'Provider Name']]"
],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 8
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"gpm.groupby('Brand Name').size().order(ascending=False)"
],
"language": "python",
"metadata": {},
"outputs": [
{
"metadata": {},
"output_type": "pyout",
"prompt_number": 12,
"text": [
"Brand Name\n",
"- 9286\n",
"BRAND Virgin 46\n",
"BRAND SSP Health Ltd 38\n",
"BRAND The Practice Surgeries 36\n",
"BRAND Care UK 33\n",
"BRAND Malling Health 29\n",
"BRAND Hurley Clinic Partnership 22\n",
"BRAND IntraHealth Limited 20\n",
"BRAND British Pregnancy Advisory Service 20\n",
"BRAND Aesthetic and Cosmetic Surgery Limited 20\n",
"BRAND BUPA Group 17\n",
"BRAND HCA Hospitals 15\n",
"BRAND The Hospital Medical Group Limited 11\n",
"BRAND Acromas Healthcare 10\n",
"BRAND City Health Care Partnership CIC 9\n",
"BRAND Nuffield Health 6\n",
"BRAND BMI Healthcare 5\n",
"BRAND Priory Group 3\n",
"BRAND Sk:n Ltd 3\n",
"BRAND Spire Healthcare Limited 3\n",
"BRAND InHealth Limited 3\n",
"BRAND Locala 2\n",
"BRAND Peninsula Community Health 2\n",
"BRAND Alliance Medical Limited 1\n",
"BRAND St Andrew's Healthcare 1\n",
"BRAND Turning Point 1\n",
"BRAND Voyage 1\n",
"dtype: int64"
]
}
],
"prompt_number": 12
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"gpm10=gpm.groupby('Provider Name').filter(lambda x: len(x) > 10).groupby('Provider Name').size().order(ascending=False)\n",
"gpm10"
],
"language": "python",
"metadata": {},
"outputs": [
{
"metadata": {},
"output_type": "pyout",
"prompt_number": 51,
"text": [
"Provider Name\n",
"SSP Health Ltd 38\n",
"Malling Health UK Ltd 26\n",
"Hurley Clinic Partnership 22\n",
"Care UK Clinical Services Limited 21\n",
"IntraHealth Limited 20\n",
"Aesthetic and Cosmetic Surgery Limited 20\n",
"British Pregnancy Advisory Service 20\n",
"AT Medics Limited 19\n",
"The Practice Services Limited 19\n",
"The Practice Surgeries Limited 18\n",
"Independent Health Group Limited 17\n",
"Chilvers & McCrea Limited 16\n",
"Lincolnshire Community Health Services NHS Trust 15\n",
"Bupa Occupational Health Limited 14\n",
"East Lancashire Medical Services Limited 13\n",
"The Village Surgery 13\n",
"GTD Primary Care Limited 11\n",
"Fraterdrive Limited 11\n",
"Phoenix Primary Care Ltd 11\n",
"Care UK (Urgent Care) Limited 11\n",
"The Hospital Medical Group Limited 11\n",
"dtype: int64"
]
}
],
"prompt_number": 51
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Quiet a few of these are limited companies - which means we should be able to get a company number for them, and things like a list of current directors, from OpenCorporates."
]
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"#The OpenCorproates reconciliation API is a \"fuzzy lookup\" service...\n",
"import requests, json\n",
"def probeRecon(name):\n",
" ''' Use OpenCorporates reconciliation API to probe a company name '''\n",
" \n",
" url=\"https://opencorporates.com/reconcile/gb\"\n",
" r=requests.get(url,params={'query':name})\n",
" return r,json.loads(r.text)\n",
"\n",
"tmpx,tmpy=probeRecon(\"Malling Health UK Ltd\")"
],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 96
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"#If multiple possible hits are detected from the reconciliation API, we can automatically grapb the best\n",
"def getBestReconResult(results):\n",
" ''' From a set of responses from reconciliation API, return the one with the highest score.\n",
" Note: if there are multiple names with matching high score, any one of them could be returned. '''\n",
" \n",
" best={}\n",
" score=0\n",
" for result in results:\n",
" if result['score']>score:\n",
" score=result['score']\n",
" best=result\n",
" return best"
],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 107
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"#This function will take a company name, look it up via OpenCorporates reconciliation API, and return matches\n",
"\n",
"import requests, json\n",
"\n",
"def ocReconcile(ix,territory='gb'):\n",
" ''' Look up company against OpenCorporates reconciliation API '''\n",
" \n",
" url=\"https://opencorporates.com/reconcile/\"+territory\n",
" r=requests.get(url,params={'query':ix})\n",
" return json.loads(r.text)\n",
"\n",
"\n",
"def ocReconcileBest(ix,territory='gb'):\n",
" ''' Look up company against OpenCorporates reconciliation API and return best match '''\n",
" \n",
" jsondata=ocReconcile(ix,territory)\n",
" best=getBestReconResult(jsondata['result'])\n",
" return best"
],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 105
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"#Use OpenCorporates reconciliation API to get data about providers with multiple CQC locations \n",
"recon={}\n",
"for ix in gpm10.index.values:\n",
" recon[ix]=ocReconcileBest(ix)\n",
"recon"
],
"language": "python",
"metadata": {},
"outputs": [
{
"metadata": {},
"output_type": "pyout",
"prompt_number": 106,
"text": [
"{'Malling Health UK Ltd': {'type': [{'name': 'Organization',\n",
" 'id': '/organization/organization'}],\n",
" 'uri': 'http://opencorporates.com/companies/gb/07034946',\n",
" 'score': 81.0,\n",
" 'name': 'MALLING HEALTH (UK) LIMITED',\n",
" 'id': '/companies/gb/07034946',\n",
" 'match': False},\n",
" 'The Hospital Medical Group Limited': {'type': [{'name': 'Organization',\n",
" 'id': '/organization/organization'}],\n",
" 'uri': 'http://opencorporates.com/companies/gb/02811995',\n",
" 'score': 86.0,\n",
" 'name': 'THE HOSPITAL MEDICAL GROUP LIMITED',\n",
" 'id': '/companies/gb/02811995',\n",
" 'match': False},\n",
" 'GTD Primary Care Limited': {'type': [{'name': 'Organization',\n",
" 'id': '/organization/organization'}],\n",
" 'uri': 'http://opencorporates.com/companies/gb/06504010',\n",
" 'score': 86.0,\n",
" 'name': 'GTD PRIMARY CARE LIMITED',\n",
" 'id': '/companies/gb/06504010',\n",
" 'match': False},\n",
" 'Phoenix Primary Care Ltd': {'type': [{'name': 'Organization',\n",
" 'id': '/organization/organization'}],\n",
" 'uri': 'http://opencorporates.com/companies/gb/06280242',\n",
" 'score': 81.0,\n",
" 'name': 'PHOENIX PRIMARY CARE LIMITED',\n",
" 'id': '/companies/gb/06280242',\n",
" 'match': False},\n",
" 'East Lancashire Medical Services Limited': {'type': [{'name': 'Organization',\n",
" 'id': '/organization/organization'}],\n",
" 'uri': 'http://opencorporates.com/companies/gb/IP30263R',\n",
" 'score': 85.0,\n",
" 'name': 'EAST LANCASHIRE MEDICAL SERVICES LIMITED',\n",
" 'id': '/companies/gb/IP30263R',\n",
" 'match': False},\n",
" 'Care UK Clinical Services Limited': {'type': [{'name': 'Organization',\n",
" 'id': '/organization/organization'}],\n",
" 'uri': 'http://opencorporates.com/companies/gb/03462881',\n",
" 'score': 86.0,\n",
" 'name': 'CARE UK CLINICAL SERVICES LIMITED',\n",
" 'id': '/companies/gb/03462881',\n",
" 'match': False},\n",
" 'Independent Health Group Limited': {'type': [{'name': 'Organization',\n",
" 'id': '/organization/organization'}],\n",
" 'uri': 'http://opencorporates.com/companies/gb/05307845',\n",
" 'score': 86.0,\n",
" 'name': 'INDEPENDENT HEALTH GROUP LIMITED',\n",
" 'id': '/companies/gb/05307845',\n",
" 'match': False},\n",
" 'SSP Health Ltd': {'type': [{'name': 'Organization',\n",
" 'id': '/organization/organization'}],\n",
" 'uri': 'http://opencorporates.com/companies/gb/06359596',\n",
" 'score': 86.0,\n",
" 'name': 'SSP HEALTH LTD',\n",
" 'id': '/companies/gb/06359596',\n",
" 'match': False},\n",
" 'Aesthetic and Cosmetic Surgery Limited': {'type': [{'name': 'Organization',\n",
" 'id': '/organization/organization'}],\n",
" 'uri': 'http://opencorporates.com/companies/gb/08213786',\n",
" 'score': 86.0,\n",
" 'name': 'AESTHETIC AND COSMETIC SURGERY LIMITED',\n",
" 'id': '/companies/gb/08213786',\n",
" 'match': False},\n",
" 'Bupa Occupational Health Limited': {'type': [{'name': 'Organization',\n",
" 'id': '/organization/organization'}],\n",
" 'uri': 'http://opencorporates.com/companies/gb/00631336',\n",
" 'score': 86.0,\n",
" 'name': 'BUPA OCCUPATIONAL HEALTH LIMITED',\n",
" 'id': '/companies/gb/00631336',\n",
" 'match': False},\n",
" 'Fraterdrive Limited': {'type': [{'name': 'Organization',\n",
" 'id': '/organization/organization'}],\n",
" 'uri': 'http://opencorporates.com/companies/gb/01087755',\n",
" 'score': 86.0,\n",
" 'name': 'FRATERDRIVE LIMITED',\n",
" 'id': '/companies/gb/01087755',\n",
" 'match': False},\n",
" 'The Practice Services Limited': {'type': [{'name': 'Organization',\n",
" 'id': '/organization/organization'}],\n",
" 'uri': 'http://opencorporates.com/companies/gb/04354429',\n",
" 'score': 51.0,\n",
" 'name': 'PRACTICE SERVICES LIMITED',\n",
" 'id': '/companies/gb/04354429',\n",
" 'match': False},\n",
" 'IntraHealth Limited': {'type': [{'name': 'Organization',\n",
" 'id': '/organization/organization'}],\n",
" 'uri': 'http://opencorporates.com/companies/gb/03783310',\n",
" 'score': 86.0,\n",
" 'name': 'INTRAHEALTH LIMITED',\n",
" 'id': '/companies/gb/03783310',\n",
" 'match': False},\n",
" 'The Practice Surgeries Limited': {'type': [{'name': 'Organization',\n",
" 'id': '/organization/organization'}],\n",
" 'uri': 'http://opencorporates.com/companies/gb/06545745',\n",
" 'score': 86.0,\n",
" 'name': 'THE PRACTICE SURGERIES LIMITED',\n",
" 'id': '/companies/gb/06545745',\n",
" 'match': False},\n",
" 'Lincolnshire Community Health Services NHS Trust': {},\n",
" 'Chilvers & McCrea Limited': {'type': [{'name': 'Organization',\n",
" 'id': '/organization/organization'}],\n",
" 'uri': 'http://opencorporates.com/companies/gb/04149500',\n",
" 'score': 86.0,\n",
" 'name': 'CHILVERS & MCCREA LIMITED',\n",
" 'id': '/companies/gb/04149500',\n",
" 'match': False},\n",
" 'Hurley Clinic Partnership': {},\n",
" 'The Village Surgery': {'type': [{'name': 'Organization',\n",
" 'id': '/organization/organization'}],\n",
" 'uri': 'http://opencorporates.com/companies/gb/02949574',\n",
" 'score': 71.0,\n",
" 'name': 'THE VILLAGE SURGERY LIMITED',\n",
" 'id': '/companies/gb/02949574',\n",
" 'match': False},\n",
" 'Care UK (Urgent Care) Limited': {'type': [{'name': 'Organization',\n",
" 'id': '/organization/organization'}],\n",
" 'uri': 'http://opencorporates.com/companies/gb/05232967',\n",
" 'score': 86.0,\n",
" 'name': 'CARE UK (URGENT CARE) LIMITED',\n",
" 'id': '/companies/gb/05232967',\n",
" 'match': False},\n",
" 'British Pregnancy Advisory Service': {'type': [{'name': 'Organization',\n",
" 'id': '/organization/organization'}],\n",
" 'uri': 'http://opencorporates.com/companies/gb/01803160',\n",
" 'score': 86.0,\n",
" 'name': 'BRITISH PREGNANCY ADVISORY SERVICE',\n",
" 'id': '/companies/gb/01803160',\n",
" 'match': False},\n",
" 'AT Medics Limited': {'type': [{'name': 'Organization',\n",
" 'id': '/organization/organization'}],\n",
" 'uri': 'http://opencorporates.com/companies/gb/05057581',\n",
" 'score': 86.0,\n",
" 'name': 'AT MEDICS LIMITED',\n",
" 'id': '/companies/gb/05057581',\n",
" 'match': False}}"
]
}
],
"prompt_number": 106
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"#Having got an OpenCorporates ID, we can look up some data about that company via OpenCorporates API\n",
"def getOCdata(cid):\n",
" ''' Get company data from OpenCorproates given OpenCorporates id '''\n",
" \n",
" apiurl='https://api.opencorporates.com/v0.3'\n",
" r=requests.get(apiurl+cid)\n",
" return json.loads(r.text)"
],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 101
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"ocd=getOCdata('/companies/gb/06504010')\n",
"ocd"
],
"language": "python",
"metadata": {},
"outputs": [
{
"metadata": {},
"output_type": "pyout",
"prompt_number": 102,
"text": [
"{'results': {'company': {'company_number': '06504010',\n",
" 'industry_codes': [{'industry_code': {'code_system': 'UK SIC Codes 2007',\n",
" 'uid': '86.21',\n",
" 'title': 'General medical practice activities'}}],\n",
" 'filings': [{'filing': {'opencorporates_url': 'https://opencorporates.com/filings/200735373',\n",
" 'uid': 'ce773aeJxjZRd2YnXi4ohPyU9OSS1OBnHYQJzMFCdxfgMDgwhjIxcjo4gQUxNzQycuzvi0/KLcksqCVCdxFscgA6AQa3xKcmKJkzijIcyYxBKgLIeRgaGJgZGRSZOac35uQWJeZmqxR35pcaqVVYSvj3u4lZVnbmJ6KpTyTq0kUhk3AwMDIxAzATEzELMAMSsQswExOxBzADEnEHMBMTcA3wA0og==',\n",
" 'id': 200735373,\n",
" 'title': 'Annual Return',\n",
" 'date': '2014-02-24'}},\n",
" {'filing': {'opencorporates_url': 'https://opencorporates.com/filings/198789423',\n",
" 'uid': '240a3beJxjZRd2YnXi4ohPyU9OSS1OBnHYQJzMFCdxfgMDA0cjP1Mjn6gwUxMDYycuzvi0/KLcksqCVCdxJkdHJy7W+JTkxBIncUYDmCGJJUA5DiMDQ2NDI0PzJjXn/NyCxLzM1GKP/NLiVCurCF8f93ArK8/cxPRUKOWdWkmkMm4GBgZGIGYCYmYgZgFiViBmA2J2IOYAYk4g5gJibgCBLTQ9',\n",
" 'id': 198789423,\n",
" 'title': 'Annual Accounts',\n",
" 'date': '2013-12-17'}},\n",
" {'filing': {'opencorporates_url': 'https://opencorporates.com/filings/182648196',\n",
" 'uid': '914ae6eJxjZRd2YnXi4ohPyU9OSS1OBnHYQJzMFCdxfgMDgwgjI8uoAEM3U0MDQycuzvi0/KLcksqCVCdxFscgkBBrfEpyYomTOKMhzJjEEqAsh5GBobGBkaFpk5pzfm5BYl5marFHfmlxqpVVhK+Pe7iVlWduYnoqlPJOrSRSGTcDAwMjEDMBMTMQswAxKxCzATE7EHMAMScQcwExNwDbZjSc',\n",
" 'id': 182648196,\n",
" 'title': 'Annual Return',\n",
" 'date': '2013-02-15'}},\n",
" {'filing': {'opencorporates_url': 'https://opencorporates.com/filings/182648197',\n",
" 'uid': '5046e0eJxjZRd2YnXi4ohPyU9OSS1OBnHYQJzMFCdxfgMDA0cjgyAvYx9zUwMLIycuzvi0/KLcksqCVCdxJkdHJy7W+JTkxBIncUYDmCGJJUA5DiMDQ2MDQyPTJjXn/NyCxLzM1GKP/NLiVCurCF8f93ArK8/cxPRUKOWdWkmkMm4GBgZGIGYCYmYgZgFiViBmA2J2IOYAYk4g5gJibgBgnDQO',\n",
" 'id': 182648197,\n",
" 'title': 'Annual Accounts',\n",
" 'date': '2013-01-25'}},\n",
" {'filing': {'opencorporates_url': 'https://opencorporates.com/filings/149222849',\n",
" 'uid': 'cfa40feJxjZRd2YnXi4ohPyU9OSS1OBnHYQJzMFCdxfgMDgwhDEyM//6gQE3NTEycuzvi0/KLcksqCVCdxFscgA0MnLtb4lOTEEidxRkOYMYklQFkOIwNDIwNjA9MmNef83ILEvMzUYo/80uJUK6sIXx/3cCsrz9zE9FQo5Z1aSaQybgYGBkYgZgJiZiBmAWJWIGYDYnYg5gBiTiDmAmJuAP2BNMw=',\n",
" 'id': 149222849,\n",
" 'title': 'Annual Return',\n",
" 'date': '2012-03-05'}},\n",
" {'filing': {'opencorporates_url': 'https://opencorporates.com/filings/149222851',\n",
" 'uid': '99851aeJxjZRd2YnXi4ohPyU9OSS1OBnHYQJzMFCdxfgMDA0cDf1Nz30ADEzNzCycuzvi0/KLcksqCVCdxJkdHJy7W+JTkxBIncUYDmCGJJUA5DiMDQ0NDI0PLJjXn/NyCxLzM1GKP/NLiVCurCF8f93ArK8/cxPRUKOWdWkmkMm4GBgZGIGYCYmYgZgFiViBmA2J2IOYAYk4g5gJibgBsljQg',\n",
" 'id': 149222851,\n",
" 'title': 'Annual Accounts',\n",
" 'date': '2011-12-19'}},\n",
" {'filing': {'opencorporates_url': 'https://opencorporates.com/filings/149222854',\n",
" 'uid': '18e887eJxjZRd2YnXi4ohPyU9OSS1OBnHYQJzMFCdxfgMDA0dDD0vnMAt3E1MDEycuzvi0/KLcksqCVCdxJkdHJy7W+JTkxBIncUYDmCGJJUA5DiMDQ0MDMyOTJjXn/NyCxLzM1GKP/NLiVCurCF8f93ArK8/cxPRUKOWdWkmkMm4GBgZGIGYCYmYgZgFiViBmA2J2IOYAYk4g5gJibgBv2jQk',\n",
" 'id': 149222854,\n",
" 'title': 'Annual Accounts',\n",
" 'date': '2011-06-24'}},\n",
" {'filing': {'opencorporates_url': 'https://opencorporates.com/filings/149222855',\n",
" 'uid': 'dda002eJxjZRd2YnXi4ohPyU9OSS1OBnHYQJzMFCdxfgMDg4gIcy/vYOMoE2NLIycuzvi0/KLcksqCVCdxFscgA0MnLtb4lOTEEidxRkOYMYklQFkOIwNDQwNjA+MmNef83ILEvMzUYo/80uJUK6sIXx/3cCsrz9zE9FQo5Z1aSaQybgYGBkYgZgJiZiBmAWJWIGYDYnYg5gBiTiDmAmJuABQKNOk=',\n",
" 'id': 149222855,\n",
" 'title': 'Annual Return',\n",
" 'date': '2011-03-03'}},\n",
" {'filing': {'opencorporates_url': 'https://opencorporates.com/filings/149222857',\n",
" 'uid': '7305e4eJxjZRd2YnXi4ohPyU9OSS1OBnHYQJzMFCdxfgMDg4gIc0//YGMjE2NLQycuzvi0/KLcksqCVCdxlhBfA6AQa3xKcmKJkzijEcyYxBKgLIeRgaGhgbGBUZOac35uQWJeZmqxR35pcaqVVYSvj3u4lZVnbmJ6KpTyTq0kUhk3AwMDIxAzATEzELMAMSsQswExOxBzADEnEHMBMTcAAgk00Q==',\n",
" 'id': 149222857,\n",
" 'title': 'Termination of appointment of director ',\n",
" 'date': '2011-03-02'}},\n",
" {'filing': {'opencorporates_url': 'https://opencorporates.com/filings/149222859',\n",
" 'uid': 'eb2d87eJxjZRd2YnXi4ohPyU9OSS1OBnHYQJzMFCdxfgMDgwjjCGMzT1cjE0NjSycuzvi0/KLcksqCVCdxFscgA0MnLtb4lOTEEidxRkOYMYklQFkOIwNDAwNjQ4smNef83ILEvMzUYo/80uJUK6sIXx/3cCsrz9zE9FQo5Z1aSaQybgYGBkYgZgJiZiBmAWJWIGYDYnYg5gBiTiDmAmJuANv3NJ0=',\n",
" 'id': 149222859,\n",
" 'title': 'Annual Return',\n",
" 'date': '2010-03-18'}},\n",
" {'filing': {'opencorporates_url': 'https://opencorporates.com/filings/149222860',\n",
" 'uid': '1b6fbdeJxjZRd2YnXi4ohPyU9OSS1OBnHYQJzMFCdxfgMDA8eIUMdIt0BXEwNzUycuzvi0/KLcksqCVCdxJkdHJy7W+JTkxBIncUYDmCGJJUA5DiMDA0tDI0OLJjXn/NyCxLzM1GKP/NLiVCurCF8f93ArK8/cxPRUKOWdWkmkMm4GBgZGIGYCYmYgZgFiViBmA2J2IOYAYk4g5gJibgC1gTSH',\n",
" 'id': 149222860,\n",
" 'title': 'Annual Accounts',\n",
" 'date': '2009-12-18'}},\n",
" {'filing': {'opencorporates_url': 'https://opencorporates.com/filings/149222863',\n",
" 'uid': 'f47825eJxjZRd2YnXi4ohPyU9OSS1OBnHYQJzMFCdxfgMDA0cznzADNxM3EwNTCycuzvi0/KLcksqCVCdxFl93A0MnLtb4lOTEEidxRhOYMYklQFkOIwMDS0NDI4MmNef83ILEvMzUYo/80uJUK6sIXx/3cCsrz9zE9FQo5Z1aSaQybgYGBkYgZgJiZiBmAWJWIGYDYnYg5gBiTiDmAmJuANvyNJ4=',\n",
" 'id': 149222863,\n",
" 'title': 'Particulars of a mortgage or charge',\n",
" 'date': '2009-11-20'}},\n",
" {'filing': {'opencorporates_url': 'https://opencorporates.com/filings/149222865',\n",
" 'uid': '3d0cadeJxjZRd2YnXi4ohPyU9OSS1OBnHYQJzMFCdxfgMDgwjPAEdfl3BLEwMjEycuzvi0/KLcksqCVCdxFkdHA0MnLtb4lOTEEidxRkuYMYklQFkOIwMDS0MDA/MmNef83ILEvMzUYo/80uJUK6sIXx/3cCsrz9zE9FQo5Z1aSaQybgYGBkYgZgJiZiBmAWJWIGYDYnYg5gBiTiDmAmJuAAZ2NNg=',\n",
" 'id': 149222865,\n",
" 'title': 'Change of accounting reference date',\n",
" 'date': '2009-10-07'}},\n",
" {'filing': {'opencorporates_url': 'https://opencorporates.com/filings/149222868',\n",
" 'uid': 'b355a2eJxjZRd2YnXi4ohPyU9OSS1OBnHYQJzMFCdxfgMDgwBXbzdvR293Y3Nzcycuzvi0/KLcksqCVCdxZiMLoAhrfEpyYomTOKMxzJTEEqAkh5GBgaWBmaFBk5pzfm5BYl5marFHfmlxqpVVhK+Pe7iVlWduYnoqlPJOrSRSGTcDAwMjEDMBMTMQswAxKxCzATE7EHMAMScQcwExNwDHOTSN',\n",
" 'id': 149222868,\n",
" 'title': 'Filing dated 2009-06-10',\n",
" 'date': '2009-06-10'}},\n",
" {'filing': {'opencorporates_url': 'https://opencorporates.com/filings/149222871',\n",
" 'uid': 'ff0826eJxjZRd2YnXi4ohPyU9OSS1OBnHYQJzMFCdxfgMDgwgDM2M/C2cXY3MjEycuzvi0/KLcksqCVCdxFmMz40QnLtb4lOTEEidxRkOYMYklQFkOIwMDSwNjI+MmNef83ILEvMzUYo/80uJUK6sIXx/3cCsrz9zE9FQo5Z1aSaQybgYGBkYgZgJiZiBmAWJWIGYDYnYg5gBiTiDmAmJuANgNNJs=',\n",
" 'id': 149222871,\n",
" 'title': 'Companies Annual Return',\n",
" 'date': '2009-03-23'}},\n",
" {'filing': {'opencorporates_url': 'https://opencorporates.com/filings/149222873',\n",
" 'uid': 'adbef8eJxjZRd2YnXi4ohPyU9OSS1OBnHYQJzMFCdxfgMDA0fT4BCPSO8oYxNzCycuzvi0/KLcksqCVCdxFiMLi0QnLtb4lOTEEidxRiOYMYklQFkOIwMDCwMTA/MmNef83ILEvMzUYo/80uJUK6sIXx/3cCsrz9zE9FQo5Z1aSaQybgYGBkYgZgJiZiBmAWJWIGYDYnYg5gBiTiDmAmJuACooNQ8=',\n",
" 'id': 149222873,\n",
" 'title': 'Appointment of Director or Secretary',\n",
" 'date': '2008-04-07'}},\n",
" {'filing': {'opencorporates_url': 'https://opencorporates.com/filings/149222893',\n",
" 'uid': '377ef7eJxjZRd2YnXi4ohPyU9OSS1OBnHYQJzMFCdxfgMDA0fvEFeLiChTYxNzIycuzvi0/KLcksqCVCdxDl9XX33HoJBgJy7W+JTkxBIncUZLmFGJJSAVRgYGFgbGRpZNas75uQWJeZmpxR75pcWpVlYRvj7u4VZWnrmJ6alQyju1kkhl3AwMDIxAzATEzEDMAsSsQMwGxOxAzAHEnEDMBcTcACaFNj0=',\n",
" 'id': 149222893,\n",
" 'title': 'Filing dated 2008-03-29',\n",
" 'date': '2008-03-29'}},\n",
" {'filing': {'opencorporates_url': 'https://opencorporates.com/filings/149222897',\n",
" 'uid': '803fc5eJxjZRd2YnXi4ohPyU9OSS1OBnHYQJzMFCdxfgMDA0dXP0/jSAsjYxNzAycuzvi0/KLcksqCVCdxFiMLi0QnLtb4lOTEEidxRiOYMYklQFkOIwMDCwNjI7MmNef83ILEvMzUYo/80uJUK6sIXx/3cCsrz9zE9FQo5Z1aSaQybgYGBkYgZgJiZiBmAWJWIGYDYnYg5gBiTiDmAmJuAOtyNLc=',\n",
" 'id': 149222897,\n",
" 'title': 'Appointment of Director or Secretary',\n",
" 'date': '2008-03-26'}},\n",
" {'filing': {'opencorporates_url': 'https://opencorporates.com/filings/149222895',\n",
" 'uid': '0b2e1beJxjZRd2YnXi4ohPyU9OSS1OBnHYQJzMFCdxfgMDA0dXP0+jSAtDYxNzAycuzvi0/KLcksqCVCdxFiMLi0QnLtb4lOTEEidxRiOYMYklQFkOIwMDCwNjI7MmNef83ILEvMzUYo/80uJUK6sIXx/3cCsrz9zE9FQo5Z1aSaQybgYGBkYgZgJiZiBmAWJWIGYDYnYg5gBiTiDmAmJuAOoDNLU=',\n",
" 'id': 149222895,\n",
" 'title': 'Appointment of Director or Secretary',\n",
" 'date': '2008-03-26'}},\n",
" {'filing': {'opencorporates_url': 'https://opencorporates.com/filings/149222899',\n",
" 'uid': 'f12a8feJxjZRd2YnXi4ohPyU9OSS1OBnHYQJzMFCdxfmcDM1MDEwNDPQN3YxMzUycuzvi0/KLcksqCVCdxNmfXoBA/Xycu1viU5MQSJ3FGc5hBiSVAeQ4jAwMLA2ND4yY15/zcgsS8zNRij/zS4lQrqwhfH/dwKyvP3MT0VCjlnVpJpDJuBgYGRiBmAmJmIGYBYlYgZgNidiDmAGJOIOYCYm4ASo01KQ==',\n",
" 'id': 149222899,\n",
" 'title': 'Certificate of Incorporation on Change of Name',\n",
" 'date': '2008-03-13'}},\n",
" {'filing': {'opencorporates_url': 'https://opencorporates.com/filings/149222903',\n",
" 'uid': '2292d6eJxjZRd2YnXi4ohPyU9OSS1OBnHYQJzMFCdxfgMDgwhfP0OTiAhTYxMzAycuzvi0/KLcksqCVCdxFiMLi0QnLtb4lOTEEidxRiOYMYklQFkOIwMDCwNjQ8MmNef83ILEvMzUYo/80uJUK6sIXx/3cCsrz9zE9FQo5Z1aSaQybgYGBkYgZgJiZiBmAWJWIGYDYnYg5gBiTiDmAmJuAAZNNNo=',\n",
" 'id': 149222903,\n",
" 'title': 'Appointment of Director or Secretary',\n",
" 'date': '2008-03-11'}},\n",
" {'filing': {'opencorporates_url': 'https://opencorporates.com/filings/149222901',\n",
" 'uid': '040a8ceJxjZRd2YnXi4ohPyU9OSS1OBnHYQJzMFCdxfgMDgwhfP0OXiAhXYxMzAycuzvi0/KLcksqCVCdxFiMLiyQnLtb4lOTEEidxRiOYMYklQFkOIwMDCwNjQ8MmNef83ILEvMzUYo/80uJUK6sIXx/3cCsrz9zE9FQo5Z1aSaQybgYGBkYgZgJiZiBmAWJWIGYDYnYg5gBiTiDmAmJuAB3cNPs=',\n",
" 'id': 149222901,\n",
" 'title': 'Terminating appointment as Director or Secretary',\n",
" 'date': '2008-03-11'}},\n",
" {'filing': {'opencorporates_url': 'https://opencorporates.com/filings/149222904',\n",
" 'uid': 'c2f7b7eJxjZRd2YnXi4ohPyU9OSS1OBnHYQJzMFCdxfgMDgwivIEvfCG8vYxNTIycuzvi0/KLcksqCVCdxFiMLi0QnLtb4lOTEEidxRiOYMYklQFkOIwMDCwMjI4smNef83ILEvMzUYo/80uJUK6sIXx/3cCsrz9zE9FQo5Z1aSaQybgYGBkYgZgJiZiBmAWJWIGYDYnYg5gBiTiDmAmJuACikNQw=',\n",
" 'id': 149222904,\n",
" 'title': 'Appointment of Director or Secretary',\n",
" 'date': '2008-02-28'}},\n",
" {'filing': {'opencorporates_url': 'https://opencorporates.com/filings/149222911',\n",
" 'uid': '07868ceJxjZRd2YnXi4ohPyU9OSS1OBnHYQJzMFCdxfgMDgwivIEufCG9PYxNTQycuzvi0/KLcksqCVCdxZiMLcycu1viU5MQSJ3FGY5gpiSVASQ4jAwMLAyMj8yY15/zcgsS8zNRij/zS4lQrqwhfH/dwKyvP3MT0VCjlnVpJpDJuBgYGRiBmAmJmIGYBYlYgZgNidiDmAGJOIOYCYm4A2M00pg==',\n",
" 'id': 149222911,\n",
" 'title': 'Filing dated 2008-02-27',\n",
" 'date': '2008-02-27'}},\n",
" {'filing': {'opencorporates_url': 'https://opencorporates.com/filings/149222910',\n",
" 'uid': '2b9767eJxjZRd2YnXi4ohPyU9OSS1OBnHYQJzMFCdxfgMDgwivIEu3CG9nYxNTQycuzvi0/KLcksqCVCdxFiMLi0QnLtb4lOTEEidxRiOYMYklQFkOIwMDCwMjI/MmNef83ILEvMzUYo/80uJUK6sIXx/3cCsrz9zE9FQo5Z1aSaQybgYGBkYgZgJiZiBmAWJWIGYDYnYg5gBiTiDmAmJuAB1sNPw=',\n",
" 'id': 149222910,\n",
" 'title': 'Appointment of Director or Secretary',\n",
" 'date': '2008-02-27'}},\n",
" {'filing': {'opencorporates_url': 'https://opencorporates.com/filings/149222909',\n",
" 'uid': 'adc709eJxjZRd2YnXi4ohPyU9OSS1OBnHYQJzMFCdxfgMDgwivIEvnCG9LYxNTQycuzvi0/KLcksqCVCdxFiMLiyQnLtb4lOTEEidxRiOYMYklQFkOIwMDCwMjI/MmNef83ILEvMzUYo/80uJUK6sIXx/3cCsrz9zE9FQo5Z1aSaQybgYGBkYgZgJiZiBmAWJWIGYDYnYg5gBiTiDmAmJuABTENPA=',\n",
" 'id': 149222909,\n",
" 'title': 'Terminating appointment as Director or Secretary',\n",
" 'date': '2008-02-27'}},\n",
" {'filing': {'opencorporates_url': 'https://opencorporates.com/filings/149222907',\n",
" 'uid': '5aec32eJxjZRd2YnXi4ohPyU9OSS1OBnHYQJzMFCdxfgMDgwivIEv3CG8XYxNTQycuzvi0/KLcksqCVCdxFiMLiyQnLtb4lOTEEidxRiOYMYklQFkOIwMDCwMjI/MmNef83ILEvMzUYo/80uJUK6sIXx/3cCsrz9zE9FQo5Z1aSaQybgYGBkYgZgJiZiBmAWJWIGYDYnYg5gBiTiDmAmJuAB96NP8=',\n",
" 'id': 149222907,\n",
" 'title': 'Terminating appointment as Director or Secretary',\n",
" 'date': '2008-02-27'}},\n",
" {'filing': {'opencorporates_url': 'https://opencorporates.com/filings/149222912',\n",
" 'uid': '0ecc3aeJxjZRd2YnXi4ohPyU9OSS1OBnHYQJzMFCdxfj8DM1MDEwNDPQMnYxMTIycuzvi0/KLcksqCVCdxNj/XcE8/Zycu1viU5MQSJ3FGM5hBiSVAeQ4jAwMLAyNDkyY15/zcgsS8zNRij/zS4lQrqwhfH/dwKyvP3MT0VCjlnVpJpDJuBgYGRiBmAmJmIGYBYlYgZgNidiDmAGJOIOYCYm4ASEU1JA==',\n",
" 'id': 149222912,\n",
" 'title': 'Filing dated 2008-02-14',\n",
" 'date': '2008-02-14'}}],\n",
" 'incorporation_date': '2008-02-14',\n",
" 'current_status': 'Active',\n",
" 'name': 'GTD PRIMARY CARE LIMITED',\n",
" 'controlling_entity': None,\n",
" 'updated_at': '2014-09-09T15:51:38+00:00',\n",
" 'financial_summary': None,\n",
" 'retrieved_at': '2014-09-09T15:51:36+00:00',\n",
" 'agent_address': None,\n",
" 'opencorporates_url': 'https://opencorporates.com/companies/gb/06504010',\n",
" 'created_at': '2010-10-22T09:40:24+00:00',\n",
" 'source': {'retrieved_at': '2014-09-09T15:51:36+00:00',\n",
" 'terms': 'UK Crown Copyright',\n",
" 'url': 'http://xmlgw.companieshouse.gov.uk/',\n",
" 'publisher': 'UK Companies House'},\n",
" 'inactive': False,\n",
" 'branch_status': None,\n",
" 'corporate_groupings': [],\n",
" 'agent_name': None,\n",
" 'officers': [{'officer': {'position': 'secretary',\n",
" 'id': 51581121,\n",
" 'start_date': '2008-02-26',\n",
" 'opencorporates_url': 'https://opencorporates.com/officers/51581121',\n",
" 'name': 'DAVID RONALD BECKETT',\n",
" 'end_date': None,\n",
" 'uid': None}},\n",
" {'officer': {'position': 'director',\n",
" 'id': 51581122,\n",
" 'start_date': '2008-03-03',\n",
" 'opencorporates_url': 'https://opencorporates.com/officers/51581122',\n",
" 'name': 'CHRISTINA MARY GREENHOUGH',\n",
" 'end_date': None,\n",
" 'uid': None}},\n",
" {'officer': {'position': 'director',\n",
" 'id': 51581123,\n",
" 'start_date': '2008-03-03',\n",
" 'opencorporates_url': 'https://opencorporates.com/officers/51581123',\n",
" 'name': 'RUSKIN HOWARD HARTLEY',\n",
" 'end_date': None,\n",
" 'uid': None}},\n",
" {'officer': {'position': 'director',\n",
" 'id': 51581124,\n",
" 'start_date': '2008-02-26',\n",
" 'opencorporates_url': 'https://opencorporates.com/officers/51581124',\n",
" 'name': 'BRIAN LEWIS',\n",
" 'end_date': None,\n",
" 'uid': None}},\n",
" {'officer': {'position': 'director',\n",
" 'id': 56924784,\n",
" 'start_date': '2008-03-03',\n",
" 'opencorporates_url': 'https://opencorporates.com/officers/56924784',\n",
" 'name': 'JAG KAPUR',\n",
" 'end_date': '2009-09-10',\n",
" 'uid': None}},\n",
" {'officer': {'position': 'secretary',\n",
" 'id': 101487350,\n",
" 'start_date': '2008-02-14',\n",
" 'opencorporates_url': 'https://opencorporates.com/officers/101487350',\n",
" 'name': ' SWIFT INCORPORATIONS LIMITED',\n",
" 'end_date': '2008-02-26',\n",
" 'uid': None}},\n",
" {'officer': {'position': 'director',\n",
" 'id': 101487351,\n",
" 'start_date': '2008-02-26',\n",
" 'opencorporates_url': 'https://opencorporates.com/officers/101487351',\n",
" 'name': ' GOTODOC LIMITED',\n",
" 'end_date': '2008-02-26',\n",
" 'uid': None}},\n",
" {'officer': {'position': 'director',\n",
" 'id': 101487352,\n",
" 'start_date': '2008-02-14',\n",
" 'opencorporates_url': 'https://opencorporates.com/officers/101487352',\n",
" 'name': ' INSTANT COMPANIES LIMITED',\n",
" 'end_date': '2008-02-26',\n",
" 'uid': None}}],\n",
" 'home_company': None,\n",
" 'jurisdiction_code': 'gb',\n",
" 'dissolution_date': None,\n",
" 'data': {'total_count': 2,\n",
" 'most_recent': [{'datum': {'opencorporates_url': 'https://opencorporates.com/data/3540817',\n",
" 'data_type': 'CompanyAddress',\n",
" 'id': 3540817,\n",
" 'title': 'Company Address',\n",
" 'description': 'THE FORUM, TAMESIDE BUSINESS PARK, DENTON, MANCHESTER, M34 3QS, United Kingdom'}},\n",
" {'datum': {'opencorporates_url': 'https://opencorporates.com/data/3540816',\n",
" 'data_type': 'OfficialRegisterEntry',\n",
" 'id': 3540816,\n",
" 'title': 'UK Data Protection Register entry',\n",
" 'description': 'register id: Z1526596'}}],\n",
" 'url': 'https://opencorporates.com/companies/gb/06504010/data'},\n",
" 'company_type': 'Private Limited Company',\n",
" 'registered_address_in_full': 'THE FORUM TAMESIDE BUSINESS DEVELOPMENT CENTRE, WINDMILL LANE DENTON, MANCHESTER, LANCASHIRE, M34 3QS',\n",
" 'previous_names': [{'company_name': 'FORMRIVER LIMITED',\n",
" 'con_date': '2008-03-17'}],\n",
" 'registry_url': 'http://data.companieshouse.gov.uk/doc/company/06504010'}},\n",
" 'api_version': '0.3'}"
]
}
],
"prompt_number": 102
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"#We can tunnel into the OpenCorporates data to get directors information\n",
"def getCurrentOfficers(ocd):\n",
" ''' Get current officers from OpenCorporates company data '''\n",
" \n",
" curr=[]\n",
" for o in ocd['results']['company']['officers']:\n",
" if o['officer']['end_date']==None:\n",
" curr.append(o)\n",
" return curr\n",
"#getCurrentOfficers(ocd)"
],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 103
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"#Let's see if we can reconcile with some HSCIC codes\n",
"!wget http://systems.hscic.gov.uk/data/ods/datadownloads/data-files/xls/epraccur.zip -P data"
],
"language": "python",
"metadata": {},
"outputs": [
{
"output_type": "stream",
"stream": "stdout",
"text": [
"--2014-09-09 14:09:10-- http://systems.hscic.gov.uk/data/ods/datadownloads/data-files/xls/epraccur.zip\r\n",
"Resolving systems.hscic.gov.uk (systems.hscic.gov.uk)... "
]
},
{
"output_type": "stream",
"stream": "stdout",
"text": [
"194.189.27.101\r\n",
"Connecting to systems.hscic.gov.uk (systems.hscic.gov.uk)|194.189.27.101|:80... connected.\r\n",
"HTTP request sent, awaiting response... "
]
},
{
"output_type": "stream",
"stream": "stdout",
"text": [
"200 OK\r\n",
"Length: 1417281 (1.4M) [application/zip]\r\n",
"Saving to: 'data/epraccur.zip'\r\n",
"\r\n",
"\r",
" 0% [ ] 0 --.-K/s "
]
},
{
"output_type": "stream",
"stream": "stdout",
"text": [
"\r",
" 1% [ ] 22,886 101KB/s "
]
},
{
"output_type": "stream",
"stream": "stdout",
"text": [
"\r",
" 2% [> ] 40,614 93.4KB/s "
]
},
{
"output_type": "stream",
"stream": "stdout",
"text": [
"\r",
"10% [==> ] 143,014 207KB/s "
]
},
{
"output_type": "stream",
"stream": "stdout",
"text": [
"\r",
"18% [======> ] 261,798 281KB/s "
]
},
{
"output_type": "stream",
"stream": "stdout",
"text": [
"\r",
"34% [============> ] 495,270 403KB/s "
]
},
{
"output_type": "stream",
"stream": "stdout",
"text": [
"\r",
"47% [=================> ] 677,214 377KB/s "
]
},
{
"output_type": "stream",
"stream": "stdout",
"text": [
"\r",
"57% [=====================> ] 816,390 408KB/s "
]
},
{
"output_type": "stream",
"stream": "stdout",
"text": [
"\r",
"87% [=================================> ] 1,243,478 561KB/s "
]
},
{
"output_type": "stream",
"stream": "stdout",
"text": [
"\r",
"100%[======================================>] 1,417,281 609KB/s in 2.3s \r\n",
"\r\n",
"2014-09-09 14:09:18 (609 KB/s) - 'data/epraccur.zip' saved [1417281/1417281]\r\n",
"\r\n"
]
}
],
"prompt_number": 13
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"!unzip \"data/epraccur.zip\" -d data"
],
"language": "python",
"metadata": {},
"outputs": [
{
"output_type": "stream",
"stream": "stdout",
"text": [
"Archive: data/epraccur.zip\r\n",
" inflating: data/epraccur.xls "
]
},
{
"output_type": "stream",
"stream": "stdout",
"text": [
"\r\n"
]
}
],
"prompt_number": 14
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"ep=pd.read_excel('data/epraccur.xls',header=None)\n",
"ep.head(3)"
],
"language": "python",
"metadata": {},
"outputs": [
{
"html": [
"<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>0</th>\n",
" <th>1</th>\n",
" <th>2</th>\n",
" <th>3</th>\n",
" <th>4</th>\n",
" <th>5</th>\n",
" <th>6</th>\n",
" <th>7</th>\n",
" <th>8</th>\n",
" <th>9</th>\n",
" <th>...</th>\n",
" <th>16</th>\n",
" <th>17</th>\n",
" <th>18</th>\n",
" <th>19</th>\n",
" <th>20</th>\n",
" <th>21</th>\n",
" <th>22</th>\n",
" <th>23</th>\n",
" <th>24</th>\n",
" <th>25</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td> A81001</td>\n",
" <td> THE DENSHAM SURGERY</td>\n",
" <td> Y54</td>\n",
" <td> Q45</td>\n",
" <td> THE HEALTH CENTRE</td>\n",
" <td> LAWSON STREET</td>\n",
" <td> STOCKTON</td>\n",
" <td> CLEVELAND</td>\n",
" <td> NaN</td>\n",
" <td> TS18 1HU</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td> 01642 672351</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td> 0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td> 4</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td> A81002</td>\n",
" <td> QUEENS PARK MEDICAL CENTRE</td>\n",
" <td> Y54</td>\n",
" <td> Q45</td>\n",
" <td> QUEENS PARK MEDICAL CTR</td>\n",
" <td> FARRER STREET</td>\n",
" <td> STOCKTON ON TEES</td>\n",
" <td> CLEVELAND</td>\n",
" <td> NaN</td>\n",
" <td> TS18 2AW</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td> 01642 679681</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td> 0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td> 4</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td> A81003</td>\n",
" <td> THE HEALTH CENTRE</td>\n",
" <td> Y54</td>\n",
" <td> Q45</td>\n",
" <td> THE HEALTH CENTRE</td>\n",
" <td> VICTORIA ROAD</td>\n",
" <td> HARTLEPOOL</td>\n",
" <td> CLEVELAND</td>\n",
" <td> NaN</td>\n",
" <td> TS26 8DB</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td> 01429 272945</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td> 0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td> 4</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>3 rows \u00d7 26 columns</p>\n",
"</div>"
],
"metadata": {},
"output_type": "pyout",
"prompt_number": 16,
"text": [
" 0 1 2 3 4 \\\n",
"0 A81001 THE DENSHAM SURGERY Y54 Q45 THE HEALTH CENTRE \n",
"1 A81002 QUEENS PARK MEDICAL CENTRE Y54 Q45 QUEENS PARK MEDICAL CTR \n",
"2 A81003 THE HEALTH CENTRE Y54 Q45 THE HEALTH CENTRE \n",
"\n",
" 5 6 7 8 9 ... 16 \\\n",
"0 LAWSON STREET STOCKTON CLEVELAND NaN TS18 1HU ... NaN \n",
"1 FARRER STREET STOCKTON ON TEES CLEVELAND NaN TS18 2AW ... NaN \n",
"2 VICTORIA ROAD HARTLEPOOL CLEVELAND NaN TS26 8DB ... NaN \n",
"\n",
" 17 18 19 20 21 22 23 24 25 \n",
"0 01642 672351 NaN NaN NaN 0 NaN NaN NaN 4 \n",
"1 01642 679681 NaN NaN NaN 0 NaN NaN NaN 4 \n",
"2 01429 272945 NaN NaN NaN 0 NaN NaN NaN 4 \n",
"\n",
"[3 rows x 26 columns]"
]
}
],
"prompt_number": 16
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"virgin=gpm[gpm['Brand Name']=='BRAND Virgin']\n",
"virgin['name']=virgin['Location Name'].str.upper()\n",
"virgin[:3]"
],
"language": "python",
"metadata": {},
"outputs": [
{
"html": [
"<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>Location ID</th>\n",
" <th>HSCA start date</th>\n",
" <th>Care home?</th>\n",
" <th>Location Name</th>\n",
" <th>Web Address</th>\n",
" <th>Care homes beds</th>\n",
" <th>Location Type/Sector</th>\n",
" <th>Region</th>\n",
" <th>Local Authority</th>\n",
" <th>Street Address</th>\n",
" <th>City</th>\n",
" <th>County</th>\n",
" <th>Postal Code</th>\n",
" <th>Brand ID</th>\n",
" <th>Brand Name</th>\n",
" <th>Provider ID</th>\n",
" <th>Provider Name</th>\n",
" <th>name</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>328 </th>\n",
" <td> 1-1051403692</td>\n",
" <td>2014-03-06</td>\n",
" <td> N</td>\n",
" <td> Lyme Regis Medical Centre</td>\n",
" <td> NaN</td>\n",
" <td> 0</td>\n",
" <td> Independent Healthcare Org</td>\n",
" <td> South West</td>\n",
" <td> Dorset</td>\n",
" <td> Lyme Regis Medical Centre</td>\n",
" <td> Lyme Regis</td>\n",
" <td> Dorset</td>\n",
" <td> DT7 3LS</td>\n",
" <td> BD231</td>\n",
" <td> BRAND Virgin</td>\n",
" <td> 1-325698686</td>\n",
" <td> VH Doctors Limited</td>\n",
" <td> LYME REGIS MEDICAL CENTRE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7818 </th>\n",
" <td> 1-1213929971</td>\n",
" <td>2014-03-06</td>\n",
" <td> N</td>\n",
" <td> East Park Practice</td>\n",
" <td> NaN</td>\n",
" <td> 0</td>\n",
" <td> Independent Healthcare Org</td>\n",
" <td> Yorkshire and The Humber</td>\n",
" <td> Kingston upon Hull, City of</td>\n",
" <td> The Park Healthcare Centre</td>\n",
" <td> Hull</td>\n",
" <td> North Humberside</td>\n",
" <td> HU9 3JA</td>\n",
" <td> BD231</td>\n",
" <td> BRAND Virgin</td>\n",
" <td> 1-325698686</td>\n",
" <td> VH Doctors Limited</td>\n",
" <td> EAST PARK PRACTICE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18328</th>\n",
" <td> 1-145049431</td>\n",
" <td>2011-01-24</td>\n",
" <td> N</td>\n",
" <td> Oldham Integrated Care Centre</td>\n",
" <td> www.assurablackpoolllp.co.uk</td>\n",
" <td> 0</td>\n",
" <td> Independent Healthcare Org</td>\n",
" <td> North West</td>\n",
" <td> Oldham</td>\n",
" <td> New Radcliffe Street</td>\n",
" <td> Oldham</td>\n",
" <td> Lancashire</td>\n",
" <td> OL1 1NL</td>\n",
" <td> BD231</td>\n",
" <td> BRAND Virgin</td>\n",
" <td> 1-132191719</td>\n",
" <td> Virgin Care Blackpool LLP</td>\n",
" <td> OLDHAM INTEGRATED CARE CENTRE</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"metadata": {},
"output_type": "pyout",
"prompt_number": 29,
"text": [
" Location ID HSCA start date Care home? Location Name \\\n",
"328 1-1051403692 2014-03-06 N Lyme Regis Medical Centre \n",
"7818 1-1213929971 2014-03-06 N East Park Practice \n",
"18328 1-145049431 2011-01-24 N Oldham Integrated Care Centre \n",
"\n",
" Web Address Care homes beds \\\n",
"328 NaN 0 \n",
"7818 NaN 0 \n",
"18328 www.assurablackpoolllp.co.uk 0 \n",
"\n",
" Location Type/Sector Region \\\n",
"328 Independent Healthcare Org South West \n",
"7818 Independent Healthcare Org Yorkshire and The Humber \n",
"18328 Independent Healthcare Org North West \n",
"\n",
" Local Authority Street Address City \\\n",
"328 Dorset Lyme Regis Medical Centre Lyme Regis \n",
"7818 Kingston upon Hull, City of The Park Healthcare Centre Hull \n",
"18328 Oldham New Radcliffe Street Oldham \n",
"\n",
" County Postal Code Brand ID Brand Name Provider ID \\\n",
"328 Dorset DT7 3LS BD231 BRAND Virgin 1-325698686 \n",
"7818 North Humberside HU9 3JA BD231 BRAND Virgin 1-325698686 \n",
"18328 Lancashire OL1 1NL BD231 BRAND Virgin 1-132191719 \n",
"\n",
" Provider Name name \n",
"328 VH Doctors Limited LYME REGIS MEDICAL CENTRE \n",
"7818 VH Doctors Limited EAST PARK PRACTICE \n",
"18328 Virgin Care Blackpool LLP OLDHAM INTEGRATED CARE CENTRE "
]
}
],
"prompt_number": 29
},
{
"cell_type": "code",
"collapsed": false,
"input": [],
"language": "python",
"metadata": {},
"outputs": []
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"virgin_merge_test1=pd.merge(virgin,ep, left_on=['name','Postal Code'],right_on=[1,9])\n",
"virgin_merge_test1[['Location ID','Location Name','Postal Code','name',9,0,4]]"
],
"language": "python",
"metadata": {},
"outputs": [
{
"html": [
"<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>Location ID</th>\n",
" <th>Location Name</th>\n",
" <th>Postal Code</th>\n",
" <th>name</th>\n",
" <th>9</th>\n",
" <th>0</th>\n",
" <th>4</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td> 1-1051403692</td>\n",
" <td> Lyme Regis Medical Centre</td>\n",
" <td> DT7 3LS</td>\n",
" <td> LYME REGIS MEDICAL CENTRE</td>\n",
" <td> DT7 3LS</td>\n",
" <td> Y03661</td>\n",
" <td> LYME REGIS MEDICAL CENTRE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td> 1-1213929971</td>\n",
" <td> East Park Practice</td>\n",
" <td> HU9 3JA</td>\n",
" <td> EAST PARK PRACTICE</td>\n",
" <td> HU9 3JA</td>\n",
" <td> B81645</td>\n",
" <td> EAST PARK PRACTICE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td> 1-318228148</td>\n",
" <td> Reading Walk-in Health Centre</td>\n",
" <td> RG1 7QA</td>\n",
" <td> READING WALK-IN HEALTH CENTRE</td>\n",
" <td> RG1 7QA</td>\n",
" <td> Y02476</td>\n",
" <td> READING WALK-IN HTH CTR</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td> 1-375358006</td>\n",
" <td> Riverside Surgery</td>\n",
" <td> DN20 8AS</td>\n",
" <td> RIVERSIDE SURGERY</td>\n",
" <td> DN20 8AS</td>\n",
" <td> B81109</td>\n",
" <td> RIVERSIDE SURGERY</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td> 1-582112768</td>\n",
" <td> Meadow Dale Group Practice</td>\n",
" <td> HX3 5SX</td>\n",
" <td> MEADOW DALE GROUP PRACTICE</td>\n",
" <td> HX3 5SX</td>\n",
" <td> Y03112</td>\n",
" <td> 120 NURSERY LANE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td> 1-604026780</td>\n",
" <td> Langbaurgh NHS Medical Centre</td>\n",
" <td> TS10 1SR</td>\n",
" <td> LANGBAURGH NHS MEDICAL CENTRE</td>\n",
" <td> TS10 1SR</td>\n",
" <td> Y02880</td>\n",
" <td> COATHAM HEALTH VILLAGE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td> 1-639388631</td>\n",
" <td> Hartlepool NHS Healthcare Centre</td>\n",
" <td> TS24 7PW</td>\n",
" <td> HARTLEPOOL NHS HEALTHCARE CENTRE</td>\n",
" <td> TS24 7PW</td>\n",
" <td> Y02496</td>\n",
" <td> HARTLEPOOL NHS H/CARE CTR</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"metadata": {},
"output_type": "pyout",
"prompt_number": 27,
"text": [
" Location ID Location Name Postal Code \\\n",
"0 1-1051403692 Lyme Regis Medical Centre DT7 3LS \n",
"1 1-1213929971 East Park Practice HU9 3JA \n",
"2 1-318228148 Reading Walk-in Health Centre RG1 7QA \n",
"3 1-375358006 Riverside Surgery DN20 8AS \n",
"4 1-582112768 Meadow Dale Group Practice HX3 5SX \n",
"5 1-604026780 Langbaurgh NHS Medical Centre TS10 1SR \n",
"6 1-639388631 Hartlepool NHS Healthcare Centre TS24 7PW \n",
"\n",
" name 9 0 \\\n",
"0 LYME REGIS MEDICAL CENTRE DT7 3LS Y03661 \n",
"1 EAST PARK PRACTICE HU9 3JA B81645 \n",
"2 READING WALK-IN HEALTH CENTRE RG1 7QA Y02476 \n",
"3 RIVERSIDE SURGERY DN20 8AS B81109 \n",
"4 MEADOW DALE GROUP PRACTICE HX3 5SX Y03112 \n",
"5 LANGBAURGH NHS MEDICAL CENTRE TS10 1SR Y02880 \n",
"6 HARTLEPOOL NHS HEALTHCARE CENTRE TS24 7PW Y02496 \n",
"\n",
" 4 \n",
"0 LYME REGIS MEDICAL CENTRE \n",
"1 EAST PARK PRACTICE \n",
"2 READING WALK-IN HTH CTR \n",
"3 RIVERSIDE SURGERY \n",
"4 120 NURSERY LANE \n",
"5 COATHAM HEALTH VILLAGE \n",
"6 HARTLEPOOL NHS H/CARE CTR "
]
}
],
"prompt_number": 27
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"#There were 46 Virgin centres listed on the CQC site - how many have we got in the merge set?\n",
"len(virgin_merge_test1['Location Name'].unique())"
],
"language": "python",
"metadata": {},
"outputs": [
{
"metadata": {},
"output_type": "pyout",
"prompt_number": 39,
"text": [
"7"
]
}
],
"prompt_number": 39
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"virgin_merge_test2=pd.merge(virgin,ep, left_on=['Postal Code'],right_on=[9])\n",
"virgin_merge_test2[['Location ID','Location Name','Street Address','Postal Code','name',1,9,0,4]]"
],
"language": "python",
"metadata": {},
"outputs": [
{
"html": [
"<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>Location ID</th>\n",
" <th>Location Name</th>\n",
" <th>Street Address</th>\n",
" <th>Postal Code</th>\n",
" <th>name</th>\n",
" <th>1</th>\n",
" <th>9</th>\n",
" <th>0</th>\n",
" <th>4</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0 </th>\n",
" <td> 1-1051403692</td>\n",
" <td> Lyme Regis Medical Centre</td>\n",
" <td> Lyme Regis Medical Centre</td>\n",
" <td> DT7 3LS</td>\n",
" <td> LYME REGIS MEDICAL CENTRE</td>\n",
" <td> THE LYME PRACTICE</td>\n",
" <td> DT7 3LS</td>\n",
" <td> J81088</td>\n",
" <td> THE LYME PRACTICE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1 </th>\n",
" <td> 1-1051403692</td>\n",
" <td> Lyme Regis Medical Centre</td>\n",
" <td> Lyme Regis Medical Centre</td>\n",
" <td> DT7 3LS</td>\n",
" <td> LYME REGIS MEDICAL CENTRE</td>\n",
" <td> LYME MEDICAL CENTRE</td>\n",
" <td> DT7 3LS</td>\n",
" <td> Y03445</td>\n",
" <td> LYME COMMUNITY CARE CNTRE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2 </th>\n",
" <td> 1-1051403692</td>\n",
" <td> Lyme Regis Medical Centre</td>\n",
" <td> Lyme Regis Medical Centre</td>\n",
" <td> DT7 3LS</td>\n",
" <td> LYME REGIS MEDICAL CENTRE</td>\n",
" <td> LYME REGIS MEDICAL CENTRE</td>\n",
" <td> DT7 3LS</td>\n",
" <td> Y03661</td>\n",
" <td> LYME REGIS MEDICAL CENTRE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3 </th>\n",
" <td> 1-1213929971</td>\n",
" <td> East Park Practice</td>\n",
" <td> The Park Healthcare Centre</td>\n",
" <td> HU9 3JA</td>\n",
" <td> EAST PARK PRACTICE</td>\n",
" <td> DR AE OGUNBA AND PARTNERS</td>\n",
" <td> HU9 3JA</td>\n",
" <td> B81001</td>\n",
" <td> PARK HEALTH CENTRE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4 </th>\n",
" <td> 1-1213929971</td>\n",
" <td> East Park Practice</td>\n",
" <td> The Park Healthcare Centre</td>\n",
" <td> HU9 3JA</td>\n",
" <td> EAST PARK PRACTICE</td>\n",
" <td> DR GM CHOWDHURY'S PRACTICE</td>\n",
" <td> HU9 3JA</td>\n",
" <td> B81066</td>\n",
" <td> PARK HEALTH CENTRE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5 </th>\n",
" <td> 1-1213929971</td>\n",
" <td> East Park Practice</td>\n",
" <td> The Park Healthcare Centre</td>\n",
" <td> HU9 3JA</td>\n",
" <td> EAST PARK PRACTICE</td>\n",
" <td> DR RD YAGNIK'S PRACTICE</td>\n",
" <td> HU9 3JA</td>\n",
" <td> B81097</td>\n",
" <td> PARK HEALTH CENTRE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6 </th>\n",
" <td> 1-1213929971</td>\n",
" <td> East Park Practice</td>\n",
" <td> The Park Healthcare Centre</td>\n",
" <td> HU9 3JA</td>\n",
" <td> EAST PARK PRACTICE</td>\n",
" <td> EAST PARK PRACTICE</td>\n",
" <td> HU9 3JA</td>\n",
" <td> B81645</td>\n",
" <td> EAST PARK PRACTICE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7 </th>\n",
" <td> 1-1213929971</td>\n",
" <td> East Park Practice</td>\n",
" <td> The Park Healthcare Centre</td>\n",
" <td> HU9 3JA</td>\n",
" <td> EAST PARK PRACTICE</td>\n",
" <td> ASSURA ER LLP HULL DERMATOLOGY</td>\n",
" <td> HU9 3JA</td>\n",
" <td> Y03508</td>\n",
" <td> PARK HEALTH CENTRE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8 </th>\n",
" <td> 1-145049431</td>\n",
" <td> Oldham Integrated Care Centre</td>\n",
" <td> New Radcliffe Street</td>\n",
" <td> OL1 1NL</td>\n",
" <td> OLDHAM INTEGRATED CARE CENTRE</td>\n",
" <td> THE CHOWDHURY PRACTICE</td>\n",
" <td> OL1 1NL</td>\n",
" <td> P85003</td>\n",
" <td> INTEGRATED CARE CENTRE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9 </th>\n",
" <td> 1-145049431</td>\n",
" <td> Oldham Integrated Care Centre</td>\n",
" <td> New Radcliffe Street</td>\n",
" <td> OL1 1NL</td>\n",
" <td> OLDHAM INTEGRATED CARE CENTRE</td>\n",
" <td> OLDHAM FAMILY PRACTICE</td>\n",
" <td> OL1 1NL</td>\n",
" <td> P85007</td>\n",
" <td> 1ST FLOOR INTEGRATED C C</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10 </th>\n",
" <td> 1-145049431</td>\n",
" <td> Oldham Integrated Care Centre</td>\n",
" <td> New Radcliffe Street</td>\n",
" <td> OL1 1NL</td>\n",
" <td> OLDHAM INTEGRATED CARE CENTRE</td>\n",
" <td> TREWINARD PRACTICE</td>\n",
" <td> OL1 1NL</td>\n",
" <td> P85601</td>\n",
" <td> INTEGRATED CARE CENTRE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11 </th>\n",
" <td> 1-145049431</td>\n",
" <td> Oldham Integrated Care Centre</td>\n",
" <td> New Radcliffe Street</td>\n",
" <td> OL1 1NL</td>\n",
" <td> OLDHAM INTEGRATED CARE CENTRE</td>\n",
" <td> PERKINS PRACTICE</td>\n",
" <td> OL1 1NL</td>\n",
" <td> P85608</td>\n",
" <td> INTEGRATED CARE CENTRE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12 </th>\n",
" <td> 1-145049431</td>\n",
" <td> Oldham Integrated Care Centre</td>\n",
" <td> New Radcliffe Street</td>\n",
" <td> OL1 1NL</td>\n",
" <td> OLDHAM INTEGRATED CARE CENTRE</td>\n",
" <td> OLDHAM PCT WALK IN CENTRE</td>\n",
" <td> OL1 1NL</td>\n",
" <td> Y00665</td>\n",
" <td> INTEGRATED CARE CENTRE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>13 </th>\n",
" <td> 1-145049431</td>\n",
" <td> Oldham Integrated Care Centre</td>\n",
" <td> New Radcliffe Street</td>\n",
" <td> OL1 1NL</td>\n",
" <td> OLDHAM INTEGRATED CARE CENTRE</td>\n",
" <td> THE DURU PRACTICE</td>\n",
" <td> OL1 1NL</td>\n",
" <td> Y01124</td>\n",
" <td> INTEGRATED CARE CENTRE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14 </th>\n",
" <td> 1-145049431</td>\n",
" <td> Oldham Integrated Care Centre</td>\n",
" <td> New Radcliffe Street</td>\n",
" <td> OL1 1NL</td>\n",
" <td> OLDHAM INTEGRATED CARE CENTRE</td>\n",
" <td> PENNINE MSK PARTNERSHIP</td>\n",
" <td> OL1 1NL</td>\n",
" <td> Y01634</td>\n",
" <td> OLDHAM INTERGRATED CC</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15 </th>\n",
" <td> 1-145049431</td>\n",
" <td> Oldham Integrated Care Centre</td>\n",
" <td> New Radcliffe Street</td>\n",
" <td> OL1 1NL</td>\n",
" <td> OLDHAM INTEGRATED CARE CENTRE</td>\n",
" <td> LINDLEY HOUSE HEALTH CENTRE</td>\n",
" <td> OL1 1NL</td>\n",
" <td> Y02875</td>\n",
" <td> INTEGRATED CARE CENTRE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16 </th>\n",
" <td> 1-145049431</td>\n",
" <td> Oldham Integrated Care Centre</td>\n",
" <td> New Radcliffe Street</td>\n",
" <td> OL1 1NL</td>\n",
" <td> OLDHAM INTEGRATED CARE CENTRE</td>\n",
" <td> SEXUAL HEALTH OLDHAM</td>\n",
" <td> OL1 1NL</td>\n",
" <td> Y03547</td>\n",
" <td> INTEGRATED CARE CENTRE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17 </th>\n",
" <td> 1-145049431</td>\n",
" <td> Oldham Integrated Care Centre</td>\n",
" <td> New Radcliffe Street</td>\n",
" <td> OL1 1NL</td>\n",
" <td> OLDHAM INTEGRATED CARE CENTRE</td>\n",
" <td> OLDHAM DERMATOLOGY SERVICE</td>\n",
" <td> OL1 1NL</td>\n",
" <td> Y03699</td>\n",
" <td> DERMATOLOGY SERVICE (O/M)</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18 </th>\n",
" <td> 1-145049431</td>\n",
" <td> Oldham Integrated Care Centre</td>\n",
" <td> New Radcliffe Street</td>\n",
" <td> OL1 1NL</td>\n",
" <td> OLDHAM INTEGRATED CARE CENTRE</td>\n",
" <td> LEARNING ASSESSMENT AND NEUROCARE CENTRE</td>\n",
" <td> OL1 1NL</td>\n",
" <td> Y04692</td>\n",
" <td> INTEGRATED CARE CENTRE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>19 </th>\n",
" <td> 1-145283366</td>\n",
" <td> The Vertis Centre</td>\n",
" <td> Upper Ground Floor</td>\n",
" <td> B97 4AJ</td>\n",
" <td> THE VERTIS CENTRE</td>\n",
" <td> THE DOW SURGERY</td>\n",
" <td> B97 4AJ</td>\n",
" <td> M81020</td>\n",
" <td> THE DOW SURGERY</td>\n",
" </tr>\n",
" <tr>\n",
" <th>20 </th>\n",
" <td> 1-145283386</td>\n",
" <td> Princess Of Wales Community Hospital</td>\n",
" <td> Stourbridge Road</td>\n",
" <td> B61 0BB</td>\n",
" <td> PRINCESS OF WALES COMMUNITY HOSPITAL</td>\n",
" <td> COMMUNITY HOSP WARDS (POWCH)</td>\n",
" <td> B61 0BB</td>\n",
" <td> Y01830</td>\n",
" <td> STOURBRIDGE ROAD</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21 </th>\n",
" <td> 1-145283386</td>\n",
" <td> Princess Of Wales Community Hospital</td>\n",
" <td> Stourbridge Road</td>\n",
" <td> B61 0BB</td>\n",
" <td> PRINCESS OF WALES COMMUNITY HOSPITAL</td>\n",
" <td> COMM HW (POWCH PALL CARE)</td>\n",
" <td> B61 0BB</td>\n",
" <td> Y01831</td>\n",
" <td> STOURBRIDGE ROAD</td>\n",
" </tr>\n",
" <tr>\n",
" <th>22 </th>\n",
" <td> 1-145283386</td>\n",
" <td> Princess Of Wales Community Hospital</td>\n",
" <td> Stourbridge Road</td>\n",
" <td> B61 0BB</td>\n",
" <td> PRINCESS OF WALES COMMUNITY HOSPITAL</td>\n",
" <td> R&amp;B ADMISSION PREVENTION TEAM</td>\n",
" <td> B61 0BB</td>\n",
" <td> Y04276</td>\n",
" <td> PRINCESS OF WALES COM HSP</td>\n",
" </tr>\n",
" <tr>\n",
" <th>23 </th>\n",
" <td> 1-145283386</td>\n",
" <td> Princess Of Wales Community Hospital</td>\n",
" <td> Stourbridge Road</td>\n",
" <td> B61 0BB</td>\n",
" <td> PRINCESS OF WALES COMMUNITY HOSPITAL</td>\n",
" <td> REDDITCH &amp; BROMSGROVE COMMUNITY NURSES</td>\n",
" <td> B61 0BB</td>\n",
" <td> Y04277</td>\n",
" <td> PRINCESS OF WALES COM HSP</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24 </th>\n",
" <td> 1-145283386</td>\n",
" <td> Princess Of Wales Community Hospital</td>\n",
" <td> Stourbridge Road</td>\n",
" <td> B61 0BB</td>\n",
" <td> PRINCESS OF WALES COMMUNITY HOSPITAL</td>\n",
" <td> REDDITCH &amp; BROMSGROVE COUNTYWIDE NURSES</td>\n",
" <td> B61 0BB</td>\n",
" <td> Y04278</td>\n",
" <td> PRINCESS OF WALES COM HSP</td>\n",
" </tr>\n",
" <tr>\n",
" <th>25 </th>\n",
" <td> 1-145283386</td>\n",
" <td> Princess Of Wales Community Hospital</td>\n",
" <td> Stourbridge Road</td>\n",
" <td> B61 0BB</td>\n",
" <td> PRINCESS OF WALES COMMUNITY HOSPITAL</td>\n",
" <td> RB PALL</td>\n",
" <td> B61 0BB</td>\n",
" <td> Y04337</td>\n",
" <td> R&amp;B PALLIATIVE CARE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>26 </th>\n",
" <td> 1-145283386</td>\n",
" <td> Princess Of Wales Community Hospital</td>\n",
" <td> Stourbridge Road</td>\n",
" <td> B61 0BB</td>\n",
" <td> PRINCESS OF WALES COMMUNITY HOSPITAL</td>\n",
" <td> R&amp;B OA CMHT</td>\n",
" <td> B61 0BB</td>\n",
" <td> Y04523</td>\n",
" <td> R&amp;B OA CMHT NEW HAVEN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27 </th>\n",
" <td> 1-145283386</td>\n",
" <td> Princess Of Wales Community Hospital</td>\n",
" <td> Stourbridge Road</td>\n",
" <td> B61 0BB</td>\n",
" <td> PRINCESS OF WALES COMMUNITY HOSPITAL</td>\n",
" <td> BROM CMHT</td>\n",
" <td> B61 0BB</td>\n",
" <td> Y04525</td>\n",
" <td> B CMHT NEWBROOK, POWCH</td>\n",
" </tr>\n",
" <tr>\n",
" <th>28 </th>\n",
" <td> 1-145283386</td>\n",
" <td> Princess Of Wales Community Hospital</td>\n",
" <td> Stourbridge Road</td>\n",
" <td> B61 0BB</td>\n",
" <td> PRINCESS OF WALES COMMUNITY HOSPITAL</td>\n",
" <td> EIN</td>\n",
" <td> B61 0BB</td>\n",
" <td> Y04565</td>\n",
" <td> EI NORTH SERVICE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>29 </th>\n",
" <td> 1-145503153</td>\n",
" <td> Kidderminster Treatment Centre</td>\n",
" <td> Bewdley Road</td>\n",
" <td> DY11 6RJ</td>\n",
" <td> KIDDERMINSTER TREATMENT CENTRE</td>\n",
" <td> CAMHS KIDDERMINSTER</td>\n",
" <td> DY11 6RJ</td>\n",
" <td> M81642</td>\n",
" <td> KIDDERMINSTER HOSPITAL</td>\n",
" </tr>\n",
" <tr>\n",
" <th>...</th>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>107</th>\n",
" <td> 1-677085054</td>\n",
" <td> Virgin Care Services</td>\n",
" <td> Sterling Street Medical Centre</td>\n",
" <td> DN31 3AE</td>\n",
" <td> VIRGIN CARE SERVICES</td>\n",
" <td> VIRGINCARE NORTH EAST LINCOLNSHIRE</td>\n",
" <td> DN31 3AE</td>\n",
" <td> Y04465</td>\n",
" <td> STIRLING MEDICAL CENTRE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>108</th>\n",
" <td> 1-679514695</td>\n",
" <td> Finch Road GP Practice</td>\n",
" <td> Finch Road Surgery</td>\n",
" <td> B19 1HS</td>\n",
" <td> FINCH ROAD GP PRACTICE</td>\n",
" <td> FINCH ROAD PRIMARY CARE CENTRE</td>\n",
" <td> B19 1HS</td>\n",
" <td> M85154</td>\n",
" <td> FINCH RD PRIMARY CARE CTR</td>\n",
" </tr>\n",
" <tr>\n",
" <th>109</th>\n",
" <td> 1-679514695</td>\n",
" <td> Finch Road GP Practice</td>\n",
" <td> Finch Road Surgery</td>\n",
" <td> B19 1HS</td>\n",
" <td> FINCH ROAD GP PRACTICE</td>\n",
" <td> HOB TPCT-DIABETES CARE</td>\n",
" <td> B19 1HS</td>\n",
" <td> Y00385</td>\n",
" <td> FINCH RD PRIMARY CARE CTR</td>\n",
" </tr>\n",
" <tr>\n",
" <th>110</th>\n",
" <td> 1-679514695</td>\n",
" <td> Finch Road GP Practice</td>\n",
" <td> Finch Road Surgery</td>\n",
" <td> B19 1HS</td>\n",
" <td> FINCH ROAD GP PRACTICE</td>\n",
" <td> FINCH ROAD SURGERY</td>\n",
" <td> B19 1HS</td>\n",
" <td> Y02963</td>\n",
" <td> FINCH ROAD SURGERY</td>\n",
" </tr>\n",
" <tr>\n",
" <th>111</th>\n",
" <td> 1-679851397</td>\n",
" <td> Anchor Centre GP Practice</td>\n",
" <td> Simon House</td>\n",
" <td> CV1 5FX</td>\n",
" <td> ANCHOR CENTRE GP PRACTICE</td>\n",
" <td> SWANSWELL MEDICAL CENTRE</td>\n",
" <td> CV1 5FX</td>\n",
" <td> M86621</td>\n",
" <td> SWANSWELL MEDICAL CENTRE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>112</th>\n",
" <td> 1-679851397</td>\n",
" <td> Anchor Centre GP Practice</td>\n",
" <td> Simon House</td>\n",
" <td> CV1 5FX</td>\n",
" <td> ANCHOR CENTRE GP PRACTICE</td>\n",
" <td> THE ANCHOR CENTRE</td>\n",
" <td> CV1 5FX</td>\n",
" <td> Y00060</td>\n",
" <td> SIMON HOUSE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>113</th>\n",
" <td> 1-679851773</td>\n",
" <td> Broad Lane GP Practice</td>\n",
" <td> 684 Broad Lane</td>\n",
" <td> CV5 7BB</td>\n",
" <td> BROAD LANE GP PRACTICE</td>\n",
" <td> BROAD LANE GP SURGERY</td>\n",
" <td> CV5 7BB</td>\n",
" <td> M86608</td>\n",
" <td> BROAD LANE SURGERY</td>\n",
" </tr>\n",
" <tr>\n",
" <th>114</th>\n",
" <td> 1-679851773</td>\n",
" <td> Broad Lane GP Practice</td>\n",
" <td> 684 Broad Lane</td>\n",
" <td> CV5 7BB</td>\n",
" <td> BROAD LANE GP PRACTICE</td>\n",
" <td> BROAD LANE SURGERY</td>\n",
" <td> CV5 7BB</td>\n",
" <td> Y02857</td>\n",
" <td> 684 BROAD LANE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>115</th>\n",
" <td> 1-679928232</td>\n",
" <td> Coventry GP and Walk In Centre</td>\n",
" <td> City of Coventry Health Centre</td>\n",
" <td> CV1 4FS</td>\n",
" <td> COVENTRY GP AND WALK IN CENTRE</td>\n",
" <td> HILLFIELDS HEALTH CENTRE - 1</td>\n",
" <td> CV1 4FS</td>\n",
" <td> M86005</td>\n",
" <td> CITY OF COVENTRY HC</td>\n",
" </tr>\n",
" <tr>\n",
" <th>116</th>\n",
" <td> 1-679928232</td>\n",
" <td> Coventry GP and Walk In Centre</td>\n",
" <td> City of Coventry Health Centre</td>\n",
" <td> CV1 4FS</td>\n",
" <td> COVENTRY GP AND WALK IN CENTRE</td>\n",
" <td> PRIORY GATE PRACTICE</td>\n",
" <td> CV1 4FS</td>\n",
" <td> M86012</td>\n",
" <td> CITY OF COVENTRY HLTH CTR</td>\n",
" </tr>\n",
" <tr>\n",
" <th>117</th>\n",
" <td> 1-679928232</td>\n",
" <td> Coventry GP and Walk In Centre</td>\n",
" <td> City of Coventry Health Centre</td>\n",
" <td> CV1 4FS</td>\n",
" <td> COVENTRY GP AND WALK IN CENTRE</td>\n",
" <td> CITY OF COVENTRY HEALTH CENTRE</td>\n",
" <td> CV1 4FS</td>\n",
" <td> M86617</td>\n",
" <td> CITY OF COVENTRY HTH CTR</td>\n",
" </tr>\n",
" <tr>\n",
" <th>118</th>\n",
" <td> 1-679928232</td>\n",
" <td> Coventry GP and Walk In Centre</td>\n",
" <td> City of Coventry Health Centre</td>\n",
" <td> CV1 4FS</td>\n",
" <td> COVENTRY GP AND WALK IN CENTRE</td>\n",
" <td> C&amp;WPT OOH SERVICE</td>\n",
" <td> CV1 4FS</td>\n",
" <td> M86639</td>\n",
" <td> 1ST FLOOR ROOM 018</td>\n",
" </tr>\n",
" <tr>\n",
" <th>119</th>\n",
" <td> 1-679928232</td>\n",
" <td> Coventry GP and Walk In Centre</td>\n",
" <td> City of Coventry Health Centre</td>\n",
" <td> CV1 4FS</td>\n",
" <td> COVENTRY GP AND WALK IN CENTRE</td>\n",
" <td> CHILD AND FAMILY SERVICES</td>\n",
" <td> CV1 4FS</td>\n",
" <td> Y00992</td>\n",
" <td> 1ST FLOOR PAYBODY BLDG</td>\n",
" </tr>\n",
" <tr>\n",
" <th>120</th>\n",
" <td> 1-679928232</td>\n",
" <td> Coventry GP and Walk In Centre</td>\n",
" <td> City of Coventry Health Centre</td>\n",
" <td> CV1 4FS</td>\n",
" <td> COVENTRY GP AND WALK IN CENTRE</td>\n",
" <td> MERIDIAN PRACTICE</td>\n",
" <td> CV1 4FS</td>\n",
" <td> Y00996</td>\n",
" <td> CITY OF COVENTRY H.C.</td>\n",
" </tr>\n",
" <tr>\n",
" <th>121</th>\n",
" <td> 1-679928232</td>\n",
" <td> Coventry GP and Walk In Centre</td>\n",
" <td> City of Coventry Health Centre</td>\n",
" <td> CV1 4FS</td>\n",
" <td> COVENTRY GP AND WALK IN CENTRE</td>\n",
" <td> COMMUNITY DERMATOLOGY SERVICE</td>\n",
" <td> CV1 4FS</td>\n",
" <td> Y00997</td>\n",
" <td> CITY OF COVENTRY HTH CTR</td>\n",
" </tr>\n",
" <tr>\n",
" <th>122</th>\n",
" <td> 1-679928232</td>\n",
" <td> Coventry GP and Walk In Centre</td>\n",
" <td> City of Coventry Health Centre</td>\n",
" <td> CV1 4FS</td>\n",
" <td> COVENTRY GP AND WALK IN CENTRE</td>\n",
" <td> COMMUNITY ENT SERVICE</td>\n",
" <td> CV1 4FS</td>\n",
" <td> Y01130</td>\n",
" <td> CITY OF COVENTRY HTH CTR</td>\n",
" </tr>\n",
" <tr>\n",
" <th>123</th>\n",
" <td> 1-679928232</td>\n",
" <td> Coventry GP and Walk In Centre</td>\n",
" <td> City of Coventry Health Centre</td>\n",
" <td> CV1 4FS</td>\n",
" <td> COVENTRY GP AND WALK IN CENTRE</td>\n",
" <td> COMMUNITY GYNAECOLOGY SERVICE</td>\n",
" <td> CV1 4FS</td>\n",
" <td> Y01168</td>\n",
" <td> CITY OF COVENTRY HTH CTR</td>\n",
" </tr>\n",
" <tr>\n",
" <th>124</th>\n",
" <td> 1-679928232</td>\n",
" <td> Coventry GP and Walk In Centre</td>\n",
" <td> City of Coventry Health Centre</td>\n",
" <td> CV1 4FS</td>\n",
" <td> COVENTRY GP AND WALK IN CENTRE</td>\n",
" <td> INTEGRATED SEXUAL HEALTH SERVICE</td>\n",
" <td> CV1 4FS</td>\n",
" <td> Y01667</td>\n",
" <td> CITY OF COVENTRY HTH CTR</td>\n",
" </tr>\n",
" <tr>\n",
" <th>125</th>\n",
" <td> 1-679928232</td>\n",
" <td> Coventry GP and Walk In Centre</td>\n",
" <td> City of Coventry Health Centre</td>\n",
" <td> CV1 4FS</td>\n",
" <td> COVENTRY GP AND WALK IN CENTRE</td>\n",
" <td> COMMUNITY OPHTHALMOLOGY SERV</td>\n",
" <td> CV1 4FS</td>\n",
" <td> Y02318</td>\n",
" <td> CITY OF COVENTRY HTH CTR</td>\n",
" </tr>\n",
" <tr>\n",
" <th>126</th>\n",
" <td> 1-679928232</td>\n",
" <td> Coventry GP and Walk In Centre</td>\n",
" <td> City of Coventry Health Centre</td>\n",
" <td> CV1 4FS</td>\n",
" <td> COVENTRY GP AND WALK IN CENTRE</td>\n",
" <td> COVENTRY NHS HEALTHCARE CTR</td>\n",
" <td> CV1 4FS</td>\n",
" <td> Y02613</td>\n",
" <td> CITY OF COVENTRY HTH CTR</td>\n",
" </tr>\n",
" <tr>\n",
" <th>127</th>\n",
" <td> 1-679928232</td>\n",
" <td> Coventry GP and Walk In Centre</td>\n",
" <td> City of Coventry Health Centre</td>\n",
" <td> CV1 4FS</td>\n",
" <td> COVENTRY GP AND WALK IN CENTRE</td>\n",
" <td> CAMHS - COVENTRY</td>\n",
" <td> CV1 4FS</td>\n",
" <td> Y03110</td>\n",
" <td> 4TH FLOOR COVENTRY HC</td>\n",
" </tr>\n",
" <tr>\n",
" <th>128</th>\n",
" <td> 1-679928232</td>\n",
" <td> Coventry GP and Walk In Centre</td>\n",
" <td> City of Coventry Health Centre</td>\n",
" <td> CV1 4FS</td>\n",
" <td> COVENTRY GP AND WALK IN CENTRE</td>\n",
" <td> COVENTRY CMHT</td>\n",
" <td> CV1 4FS</td>\n",
" <td> Y03557</td>\n",
" <td> SWANSWELL POINT</td>\n",
" </tr>\n",
" <tr>\n",
" <th>129</th>\n",
" <td> 1-679928569</td>\n",
" <td> Deer Park</td>\n",
" <td> Deer Park Medical Centre</td>\n",
" <td> OX28 5YT</td>\n",
" <td> DEER PARK</td>\n",
" <td> DEER PARK MEDICAL CENTRE</td>\n",
" <td> OX28 5YT</td>\n",
" <td> K84622</td>\n",
" <td> DEER PARK MEDICAL CENTRE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>130</th>\n",
" <td> 1-679928946</td>\n",
" <td> Kingsheath GP Practice</td>\n",
" <td> North Oval</td>\n",
" <td> NN5 7LN</td>\n",
" <td> KINGSHEATH GP PRACTICE</td>\n",
" <td> KINGS HEATH HEALTH CARE CENTRE</td>\n",
" <td> NN5 7LN</td>\n",
" <td> Y00028</td>\n",
" <td> NORTH OVAL</td>\n",
" </tr>\n",
" <tr>\n",
" <th>131</th>\n",
" <td> 1-679989614</td>\n",
" <td> Lingsbrook GP Practice</td>\n",
" <td> Weston Flavell Centre, Billingbrook Road</td>\n",
" <td> NN3 8DW</td>\n",
" <td> LINGSBROOK GP PRACTICE</td>\n",
" <td> MOLLA &amp; KESANI</td>\n",
" <td> NN3 8DW</td>\n",
" <td> K83033</td>\n",
" <td> WESTON FAVELL HEALTH CTR</td>\n",
" </tr>\n",
" <tr>\n",
" <th>132</th>\n",
" <td> 1-679989614</td>\n",
" <td> Lingsbrook GP Practice</td>\n",
" <td> Weston Flavell Centre, Billingbrook Road</td>\n",
" <td> NN3 8DW</td>\n",
" <td> LINGSBROOK GP PRACTICE</td>\n",
" <td> LINGS BROOK PRACTICE</td>\n",
" <td> NN3 8DW</td>\n",
" <td> K83074</td>\n",
" <td> LINGS BROOK PRACTICE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>133</th>\n",
" <td> 1-679989614</td>\n",
" <td> Lingsbrook GP Practice</td>\n",
" <td> Weston Flavell Centre, Billingbrook Road</td>\n",
" <td> NN3 8DW</td>\n",
" <td> LINGSBROOK GP PRACTICE</td>\n",
" <td> JAMEEL</td>\n",
" <td> NN3 8DW</td>\n",
" <td> K83076</td>\n",
" <td> WESTON FAVELL HEALTH CTR</td>\n",
" </tr>\n",
" <tr>\n",
" <th>134</th>\n",
" <td> 1-679989614</td>\n",
" <td> Lingsbrook GP Practice</td>\n",
" <td> Weston Flavell Centre, Billingbrook Road</td>\n",
" <td> NN3 8DW</td>\n",
" <td> LINGSBROOK GP PRACTICE</td>\n",
" <td> DRS LAKHA &amp; ABBAS</td>\n",
" <td> NN3 8DW</td>\n",
" <td> K83618</td>\n",
" <td> WESTON FAVELL P/C CENTRE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>135</th>\n",
" <td> 1-714016472</td>\n",
" <td> Kingstanding Community Practice</td>\n",
" <td> Warren Farm Road</td>\n",
" <td> B44 0PU</td>\n",
" <td> KINGSTANDING COMMUNITY PRACTICE</td>\n",
" <td> URGENT CARE CENTRE</td>\n",
" <td> B44 0PU</td>\n",
" <td> Y01176</td>\n",
" <td> WARREN FARM HEALTH CENTRE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>136</th>\n",
" <td> 1-714016472</td>\n",
" <td> Kingstanding Community Practice</td>\n",
" <td> Warren Farm Road</td>\n",
" <td> B44 0PU</td>\n",
" <td> KINGSTANDING COMMUNITY PRACTICE</td>\n",
" <td> THE KINGSTANDING COMMUNITY PRACTICE</td>\n",
" <td> B44 0PU</td>\n",
" <td> Y02988</td>\n",
" <td> WARREN FARM HEALTH CENTRE</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>137 rows \u00d7 9 columns</p>\n",
"</div>"
],
"metadata": {},
"output_type": "pyout",
"prompt_number": 108,
"text": [
" Location ID Location Name \\\n",
"0 1-1051403692 Lyme Regis Medical Centre \n",
"1 1-1051403692 Lyme Regis Medical Centre \n",
"2 1-1051403692 Lyme Regis Medical Centre \n",
"3 1-1213929971 East Park Practice \n",
"4 1-1213929971 East Park Practice \n",
"5 1-1213929971 East Park Practice \n",
"6 1-1213929971 East Park Practice \n",
"7 1-1213929971 East Park Practice \n",
"8 1-145049431 Oldham Integrated Care Centre \n",
"9 1-145049431 Oldham Integrated Care Centre \n",
"10 1-145049431 Oldham Integrated Care Centre \n",
"11 1-145049431 Oldham Integrated Care Centre \n",
"12 1-145049431 Oldham Integrated Care Centre \n",
"13 1-145049431 Oldham Integrated Care Centre \n",
"14 1-145049431 Oldham Integrated Care Centre \n",
"15 1-145049431 Oldham Integrated Care Centre \n",
"16 1-145049431 Oldham Integrated Care Centre \n",
"17 1-145049431 Oldham Integrated Care Centre \n",
"18 1-145049431 Oldham Integrated Care Centre \n",
"19 1-145283366 The Vertis Centre \n",
"20 1-145283386 Princess Of Wales Community Hospital \n",
"21 1-145283386 Princess Of Wales Community Hospital \n",
"22 1-145283386 Princess Of Wales Community Hospital \n",
"23 1-145283386 Princess Of Wales Community Hospital \n",
"24 1-145283386 Princess Of Wales Community Hospital \n",
"25 1-145283386 Princess Of Wales Community Hospital \n",
"26 1-145283386 Princess Of Wales Community Hospital \n",
"27 1-145283386 Princess Of Wales Community Hospital \n",
"28 1-145283386 Princess Of Wales Community Hospital \n",
"29 1-145503153 Kidderminster Treatment Centre \n",
".. ... ... \n",
"107 1-677085054 Virgin Care Services \n",
"108 1-679514695 Finch Road GP Practice \n",
"109 1-679514695 Finch Road GP Practice \n",
"110 1-679514695 Finch Road GP Practice \n",
"111 1-679851397 Anchor Centre GP Practice \n",
"112 1-679851397 Anchor Centre GP Practice \n",
"113 1-679851773 Broad Lane GP Practice \n",
"114 1-679851773 Broad Lane GP Practice \n",
"115 1-679928232 Coventry GP and Walk In Centre \n",
"116 1-679928232 Coventry GP and Walk In Centre \n",
"117 1-679928232 Coventry GP and Walk In Centre \n",
"118 1-679928232 Coventry GP and Walk In Centre \n",
"119 1-679928232 Coventry GP and Walk In Centre \n",
"120 1-679928232 Coventry GP and Walk In Centre \n",
"121 1-679928232 Coventry GP and Walk In Centre \n",
"122 1-679928232 Coventry GP and Walk In Centre \n",
"123 1-679928232 Coventry GP and Walk In Centre \n",
"124 1-679928232 Coventry GP and Walk In Centre \n",
"125 1-679928232 Coventry GP and Walk In Centre \n",
"126 1-679928232 Coventry GP and Walk In Centre \n",
"127 1-679928232 Coventry GP and Walk In Centre \n",
"128 1-679928232 Coventry GP and Walk In Centre \n",
"129 1-679928569 Deer Park \n",
"130 1-679928946 Kingsheath GP Practice \n",
"131 1-679989614 Lingsbrook GP Practice \n",
"132 1-679989614 Lingsbrook GP Practice \n",
"133 1-679989614 Lingsbrook GP Practice \n",
"134 1-679989614 Lingsbrook GP Practice \n",
"135 1-714016472 Kingstanding Community Practice \n",
"136 1-714016472 Kingstanding Community Practice \n",
"\n",
" Street Address Postal Code \\\n",
"0 Lyme Regis Medical Centre DT7 3LS \n",
"1 Lyme Regis Medical Centre DT7 3LS \n",
"2 Lyme Regis Medical Centre DT7 3LS \n",
"3 The Park Healthcare Centre HU9 3JA \n",
"4 The Park Healthcare Centre HU9 3JA \n",
"5 The Park Healthcare Centre HU9 3JA \n",
"6 The Park Healthcare Centre HU9 3JA \n",
"7 The Park Healthcare Centre HU9 3JA \n",
"8 New Radcliffe Street OL1 1NL \n",
"9 New Radcliffe Street OL1 1NL \n",
"10 New Radcliffe Street OL1 1NL \n",
"11 New Radcliffe Street OL1 1NL \n",
"12 New Radcliffe Street OL1 1NL \n",
"13 New Radcliffe Street OL1 1NL \n",
"14 New Radcliffe Street OL1 1NL \n",
"15 New Radcliffe Street OL1 1NL \n",
"16 New Radcliffe Street OL1 1NL \n",
"17 New Radcliffe Street OL1 1NL \n",
"18 New Radcliffe Street OL1 1NL \n",
"19 Upper Ground Floor B97 4AJ \n",
"20 Stourbridge Road B61 0BB \n",
"21 Stourbridge Road B61 0BB \n",
"22 Stourbridge Road B61 0BB \n",
"23 Stourbridge Road B61 0BB \n",
"24 Stourbridge Road B61 0BB \n",
"25 Stourbridge Road B61 0BB \n",
"26 Stourbridge Road B61 0BB \n",
"27 Stourbridge Road B61 0BB \n",
"28 Stourbridge Road B61 0BB \n",
"29 Bewdley Road DY11 6RJ \n",
".. ... ... \n",
"107 Sterling Street Medical Centre DN31 3AE \n",
"108 Finch Road Surgery B19 1HS \n",
"109 Finch Road Surgery B19 1HS \n",
"110 Finch Road Surgery B19 1HS \n",
"111 Simon House CV1 5FX \n",
"112 Simon House CV1 5FX \n",
"113 684 Broad Lane CV5 7BB \n",
"114 684 Broad Lane CV5 7BB \n",
"115 City of Coventry Health Centre CV1 4FS \n",
"116 City of Coventry Health Centre CV1 4FS \n",
"117 City of Coventry Health Centre CV1 4FS \n",
"118 City of Coventry Health Centre CV1 4FS \n",
"119 City of Coventry Health Centre CV1 4FS \n",
"120 City of Coventry Health Centre CV1 4FS \n",
"121 City of Coventry Health Centre CV1 4FS \n",
"122 City of Coventry Health Centre CV1 4FS \n",
"123 City of Coventry Health Centre CV1 4FS \n",
"124 City of Coventry Health Centre CV1 4FS \n",
"125 City of Coventry Health Centre CV1 4FS \n",
"126 City of Coventry Health Centre CV1 4FS \n",
"127 City of Coventry Health Centre CV1 4FS \n",
"128 City of Coventry Health Centre CV1 4FS \n",
"129 Deer Park Medical Centre OX28 5YT \n",
"130 North Oval NN5 7LN \n",
"131 Weston Flavell Centre, Billingbrook Road NN3 8DW \n",
"132 Weston Flavell Centre, Billingbrook Road NN3 8DW \n",
"133 Weston Flavell Centre, Billingbrook Road NN3 8DW \n",
"134 Weston Flavell Centre, Billingbrook Road NN3 8DW \n",
"135 Warren Farm Road B44 0PU \n",
"136 Warren Farm Road B44 0PU \n",
"\n",
" name \\\n",
"0 LYME REGIS MEDICAL CENTRE \n",
"1 LYME REGIS MEDICAL CENTRE \n",
"2 LYME REGIS MEDICAL CENTRE \n",
"3 EAST PARK PRACTICE \n",
"4 EAST PARK PRACTICE \n",
"5 EAST PARK PRACTICE \n",
"6 EAST PARK PRACTICE \n",
"7 EAST PARK PRACTICE \n",
"8 OLDHAM INTEGRATED CARE CENTRE \n",
"9 OLDHAM INTEGRATED CARE CENTRE \n",
"10 OLDHAM INTEGRATED CARE CENTRE \n",
"11 OLDHAM INTEGRATED CARE CENTRE \n",
"12 OLDHAM INTEGRATED CARE CENTRE \n",
"13 OLDHAM INTEGRATED CARE CENTRE \n",
"14 OLDHAM INTEGRATED CARE CENTRE \n",
"15 OLDHAM INTEGRATED CARE CENTRE \n",
"16 OLDHAM INTEGRATED CARE CENTRE \n",
"17 OLDHAM INTEGRATED CARE CENTRE \n",
"18 OLDHAM INTEGRATED CARE CENTRE \n",
"19 THE VERTIS CENTRE \n",
"20 PRINCESS OF WALES COMMUNITY HOSPITAL \n",
"21 PRINCESS OF WALES COMMUNITY HOSPITAL \n",
"22 PRINCESS OF WALES COMMUNITY HOSPITAL \n",
"23 PRINCESS OF WALES COMMUNITY HOSPITAL \n",
"24 PRINCESS OF WALES COMMUNITY HOSPITAL \n",
"25 PRINCESS OF WALES COMMUNITY HOSPITAL \n",
"26 PRINCESS OF WALES COMMUNITY HOSPITAL \n",
"27 PRINCESS OF WALES COMMUNITY HOSPITAL \n",
"28 PRINCESS OF WALES COMMUNITY HOSPITAL \n",
"29 KIDDERMINSTER TREATMENT CENTRE \n",
".. ... \n",
"107 VIRGIN CARE SERVICES \n",
"108 FINCH ROAD GP PRACTICE \n",
"109 FINCH ROAD GP PRACTICE \n",
"110 FINCH ROAD GP PRACTICE \n",
"111 ANCHOR CENTRE GP PRACTICE \n",
"112 ANCHOR CENTRE GP PRACTICE \n",
"113 BROAD LANE GP PRACTICE \n",
"114 BROAD LANE GP PRACTICE \n",
"115 COVENTRY GP AND WALK IN CENTRE \n",
"116 COVENTRY GP AND WALK IN CENTRE \n",
"117 COVENTRY GP AND WALK IN CENTRE \n",
"118 COVENTRY GP AND WALK IN CENTRE \n",
"119 COVENTRY GP AND WALK IN CENTRE \n",
"120 COVENTRY GP AND WALK IN CENTRE \n",
"121 COVENTRY GP AND WALK IN CENTRE \n",
"122 COVENTRY GP AND WALK IN CENTRE \n",
"123 COVENTRY GP AND WALK IN CENTRE \n",
"124 COVENTRY GP AND WALK IN CENTRE \n",
"125 COVENTRY GP AND WALK IN CENTRE \n",
"126 COVENTRY GP AND WALK IN CENTRE \n",
"127 COVENTRY GP AND WALK IN CENTRE \n",
"128 COVENTRY GP AND WALK IN CENTRE \n",
"129 DEER PARK \n",
"130 KINGSHEATH GP PRACTICE \n",
"131 LINGSBROOK GP PRACTICE \n",
"132 LINGSBROOK GP PRACTICE \n",
"133 LINGSBROOK GP PRACTICE \n",
"134 LINGSBROOK GP PRACTICE \n",
"135 KINGSTANDING COMMUNITY PRACTICE \n",
"136 KINGSTANDING COMMUNITY PRACTICE \n",
"\n",
" 1 9 0 \\\n",
"0 THE LYME PRACTICE DT7 3LS J81088 \n",
"1 LYME MEDICAL CENTRE DT7 3LS Y03445 \n",
"2 LYME REGIS MEDICAL CENTRE DT7 3LS Y03661 \n",
"3 DR AE OGUNBA AND PARTNERS HU9 3JA B81001 \n",
"4 DR GM CHOWDHURY'S PRACTICE HU9 3JA B81066 \n",
"5 DR RD YAGNIK'S PRACTICE HU9 3JA B81097 \n",
"6 EAST PARK PRACTICE HU9 3JA B81645 \n",
"7 ASSURA ER LLP HULL DERMATOLOGY HU9 3JA Y03508 \n",
"8 THE CHOWDHURY PRACTICE OL1 1NL P85003 \n",
"9 OLDHAM FAMILY PRACTICE OL1 1NL P85007 \n",
"10 TREWINARD PRACTICE OL1 1NL P85601 \n",
"11 PERKINS PRACTICE OL1 1NL P85608 \n",
"12 OLDHAM PCT WALK IN CENTRE OL1 1NL Y00665 \n",
"13 THE DURU PRACTICE OL1 1NL Y01124 \n",
"14 PENNINE MSK PARTNERSHIP OL1 1NL Y01634 \n",
"15 LINDLEY HOUSE HEALTH CENTRE OL1 1NL Y02875 \n",
"16 SEXUAL HEALTH OLDHAM OL1 1NL Y03547 \n",
"17 OLDHAM DERMATOLOGY SERVICE OL1 1NL Y03699 \n",
"18 LEARNING ASSESSMENT AND NEUROCARE CENTRE OL1 1NL Y04692 \n",
"19 THE DOW SURGERY B97 4AJ M81020 \n",
"20 COMMUNITY HOSP WARDS (POWCH) B61 0BB Y01830 \n",
"21 COMM HW (POWCH PALL CARE) B61 0BB Y01831 \n",
"22 R&B ADMISSION PREVENTION TEAM B61 0BB Y04276 \n",
"23 REDDITCH & BROMSGROVE COMMUNITY NURSES B61 0BB Y04277 \n",
"24 REDDITCH & BROMSGROVE COUNTYWIDE NURSES B61 0BB Y04278 \n",
"25 RB PALL B61 0BB Y04337 \n",
"26 R&B OA CMHT B61 0BB Y04523 \n",
"27 BROM CMHT B61 0BB Y04525 \n",
"28 EIN B61 0BB Y04565 \n",
"29 CAMHS KIDDERMINSTER DY11 6RJ M81642 \n",
".. ... ... ... \n",
"107 VIRGINCARE NORTH EAST LINCOLNSHIRE DN31 3AE Y04465 \n",
"108 FINCH ROAD PRIMARY CARE CENTRE B19 1HS M85154 \n",
"109 HOB TPCT-DIABETES CARE B19 1HS Y00385 \n",
"110 FINCH ROAD SURGERY B19 1HS Y02963 \n",
"111 SWANSWELL MEDICAL CENTRE CV1 5FX M86621 \n",
"112 THE ANCHOR CENTRE CV1 5FX Y00060 \n",
"113 BROAD LANE GP SURGERY CV5 7BB M86608 \n",
"114 BROAD LANE SURGERY CV5 7BB Y02857 \n",
"115 HILLFIELDS HEALTH CENTRE - 1 CV1 4FS M86005 \n",
"116 PRIORY GATE PRACTICE CV1 4FS M86012 \n",
"117 CITY OF COVENTRY HEALTH CENTRE CV1 4FS M86617 \n",
"118 C&WPT OOH SERVICE CV1 4FS M86639 \n",
"119 CHILD AND FAMILY SERVICES CV1 4FS Y00992 \n",
"120 MERIDIAN PRACTICE CV1 4FS Y00996 \n",
"121 COMMUNITY DERMATOLOGY SERVICE CV1 4FS Y00997 \n",
"122 COMMUNITY ENT SERVICE CV1 4FS Y01130 \n",
"123 COMMUNITY GYNAECOLOGY SERVICE CV1 4FS Y01168 \n",
"124 INTEGRATED SEXUAL HEALTH SERVICE CV1 4FS Y01667 \n",
"125 COMMUNITY OPHTHALMOLOGY SERV CV1 4FS Y02318 \n",
"126 COVENTRY NHS HEALTHCARE CTR CV1 4FS Y02613 \n",
"127 CAMHS - COVENTRY CV1 4FS Y03110 \n",
"128 COVENTRY CMHT CV1 4FS Y03557 \n",
"129 DEER PARK MEDICAL CENTRE OX28 5YT K84622 \n",
"130 KINGS HEATH HEALTH CARE CENTRE NN5 7LN Y00028 \n",
"131 MOLLA & KESANI NN3 8DW K83033 \n",
"132 LINGS BROOK PRACTICE NN3 8DW K83074 \n",
"133 JAMEEL NN3 8DW K83076 \n",
"134 DRS LAKHA & ABBAS NN3 8DW K83618 \n",
"135 URGENT CARE CENTRE B44 0PU Y01176 \n",
"136 THE KINGSTANDING COMMUNITY PRACTICE B44 0PU Y02988 \n",
"\n",
" 4 \n",
"0 THE LYME PRACTICE \n",
"1 LYME COMMUNITY CARE CNTRE \n",
"2 LYME REGIS MEDICAL CENTRE \n",
"3 PARK HEALTH CENTRE \n",
"4 PARK HEALTH CENTRE \n",
"5 PARK HEALTH CENTRE \n",
"6 EAST PARK PRACTICE \n",
"7 PARK HEALTH CENTRE \n",
"8 INTEGRATED CARE CENTRE \n",
"9 1ST FLOOR INTEGRATED C C \n",
"10 INTEGRATED CARE CENTRE \n",
"11 INTEGRATED CARE CENTRE \n",
"12 INTEGRATED CARE CENTRE \n",
"13 INTEGRATED CARE CENTRE \n",
"14 OLDHAM INTERGRATED CC \n",
"15 INTEGRATED CARE CENTRE \n",
"16 INTEGRATED CARE CENTRE \n",
"17 DERMATOLOGY SERVICE (O/M) \n",
"18 INTEGRATED CARE CENTRE \n",
"19 THE DOW SURGERY \n",
"20 STOURBRIDGE ROAD \n",
"21 STOURBRIDGE ROAD \n",
"22 PRINCESS OF WALES COM HSP \n",
"23 PRINCESS OF WALES COM HSP \n",
"24 PRINCESS OF WALES COM HSP \n",
"25 R&B PALLIATIVE CARE \n",
"26 R&B OA CMHT NEW HAVEN \n",
"27 B CMHT NEWBROOK, POWCH \n",
"28 EI NORTH SERVICE \n",
"29 KIDDERMINSTER HOSPITAL \n",
".. ... \n",
"107 STIRLING MEDICAL CENTRE \n",
"108 FINCH RD PRIMARY CARE CTR \n",
"109 FINCH RD PRIMARY CARE CTR \n",
"110 FINCH ROAD SURGERY \n",
"111 SWANSWELL MEDICAL CENTRE \n",
"112 SIMON HOUSE \n",
"113 BROAD LANE SURGERY \n",
"114 684 BROAD LANE \n",
"115 CITY OF COVENTRY HC \n",
"116 CITY OF COVENTRY HLTH CTR \n",
"117 CITY OF COVENTRY HTH CTR \n",
"118 1ST FLOOR ROOM 018 \n",
"119 1ST FLOOR PAYBODY BLDG \n",
"120 CITY OF COVENTRY H.C. \n",
"121 CITY OF COVENTRY HTH CTR \n",
"122 CITY OF COVENTRY HTH CTR \n",
"123 CITY OF COVENTRY HTH CTR \n",
"124 CITY OF COVENTRY HTH CTR \n",
"125 CITY OF COVENTRY HTH CTR \n",
"126 CITY OF COVENTRY HTH CTR \n",
"127 4TH FLOOR COVENTRY HC \n",
"128 SWANSWELL POINT \n",
"129 DEER PARK MEDICAL CENTRE \n",
"130 NORTH OVAL \n",
"131 WESTON FAVELL HEALTH CTR \n",
"132 LINGS BROOK PRACTICE \n",
"133 WESTON FAVELL HEALTH CTR \n",
"134 WESTON FAVELL P/C CENTRE \n",
"135 WARREN FARM HEALTH CENTRE \n",
"136 WARREN FARM HEALTH CENTRE \n",
"\n",
"[137 rows x 9 columns]"
]
}
],
"prompt_number": 108
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"#There were 46 Virgin centres listed on the CQC site - how many have we got in the merge set?\n",
"len(virgin_merge_test2['Location Name'].unique())"
],
"language": "python",
"metadata": {},
"outputs": [
{
"metadata": {},
"output_type": "pyout",
"prompt_number": 37,
"text": [
"37"
]
}
],
"prompt_number": 37
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"virgin[['Provider Name','Location ID','Location Name','Street Address','Postal Code']]"
],
"language": "python",
"metadata": {},
"outputs": [
{
"html": [
"<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>Provider Name</th>\n",
" <th>Location ID</th>\n",
" <th>Location Name</th>\n",
" <th>Street Address</th>\n",
" <th>Postal Code</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>328 </th>\n",
" <td> VH Doctors Limited</td>\n",
" <td> 1-1051403692</td>\n",
" <td> Lyme Regis Medical Centre</td>\n",
" <td> Lyme Regis Medical Centre</td>\n",
" <td> DT7 3LS</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7818 </th>\n",
" <td> VH Doctors Limited</td>\n",
" <td> 1-1213929971</td>\n",
" <td> East Park Practice</td>\n",
" <td> The Park Healthcare Centre</td>\n",
" <td> HU9 3JA</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18328</th>\n",
" <td> Virgin Care Blackpool LLP</td>\n",
" <td> 1-145049431</td>\n",
" <td> Oldham Integrated Care Centre</td>\n",
" <td> New Radcliffe Street</td>\n",
" <td> OL1 1NL</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18422</th>\n",
" <td> Virgin Care Vertis LLP</td>\n",
" <td> 1-145283366</td>\n",
" <td> The Vertis Centre</td>\n",
" <td> Upper Ground Floor</td>\n",
" <td> B97 4AJ</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18423</th>\n",
" <td> Virgin Care Vertis LLP</td>\n",
" <td> 1-145283386</td>\n",
" <td> Princess Of Wales Community Hospital</td>\n",
" <td> Stourbridge Road</td>\n",
" <td> B61 0BB</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18455</th>\n",
" <td> Virgin Care Wyre Forest LLP</td>\n",
" <td> 1-145503153</td>\n",
" <td> Kidderminster Treatment Centre</td>\n",
" <td> Bewdley Road</td>\n",
" <td> DY11 6RJ</td>\n",
" </tr>\n",
" <tr>\n",
" <th>19121</th>\n",
" <td> Peninsula Health LLP</td>\n",
" <td> 1-149321981</td>\n",
" <td> Peninsula Health Birkenhead Medical Building</td>\n",
" <td> 2nd Floor Birkenhead Medical Building</td>\n",
" <td> CH41 8DB</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21936</th>\n",
" <td> Virgin Care Macclesfield LLP</td>\n",
" <td> 1-188720285</td>\n",
" <td> Spire Regency Hospital</td>\n",
" <td> West Street</td>\n",
" <td> SK11 8DW</td>\n",
" </tr>\n",
" <tr>\n",
" <th>25696</th>\n",
" <td> Virgin Care Cambridge LLP</td>\n",
" <td> 1-201621036</td>\n",
" <td> Nuffield Road Medical Practice</td>\n",
" <td> Nuffield Road</td>\n",
" <td> CB4 1GL</td>\n",
" </tr>\n",
" <tr>\n",
" <th>28494</th>\n",
" <td> Virgin Care Vertis LLP</td>\n",
" <td> 1-227856719</td>\n",
" <td> The Alexandra Hospital</td>\n",
" <td> Woodrow Drive</td>\n",
" <td> B98 7UB</td>\n",
" </tr>\n",
" <tr>\n",
" <th>30657</th>\n",
" <td> Virgin Care Coventry LLP</td>\n",
" <td> 1-301391094</td>\n",
" <td> Summerfield GP and Urgent Care Centre</td>\n",
" <td> 134 Heath Street</td>\n",
" <td> B18 7AL</td>\n",
" </tr>\n",
" <tr>\n",
" <th>31425</th>\n",
" <td> Assura Reading LLP</td>\n",
" <td> 1-318228148</td>\n",
" <td> Reading Walk-in Health Centre</td>\n",
" <td> 1st Floor</td>\n",
" <td> RG1 7QA</td>\n",
" </tr>\n",
" <tr>\n",
" <th>32339</th>\n",
" <td> VH Doctors Limited</td>\n",
" <td> 1-348027749</td>\n",
" <td> VH Doctors Ltd</td>\n",
" <td> Lynton House</td>\n",
" <td> WC1H 9LT</td>\n",
" </tr>\n",
" <tr>\n",
" <th>32489</th>\n",
" <td> North Lancashire Doctors Limited</td>\n",
" <td> 1-352858943</td>\n",
" <td> Queen Victoria Centre Morecambe</td>\n",
" <td> Thornton Road</td>\n",
" <td> LA4 5NN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>32985</th>\n",
" <td> Virgin Care East Riding LLP</td>\n",
" <td> 1-375358006</td>\n",
" <td> Riverside Surgery</td>\n",
" <td> Barnard Avenue</td>\n",
" <td> DN20 8AS</td>\n",
" </tr>\n",
" <tr>\n",
" <th>32989</th>\n",
" <td> Virgin Care East Riding LLP</td>\n",
" <td> 1-375458032</td>\n",
" <td> Central Surgery</td>\n",
" <td> King Street</td>\n",
" <td> DN18 5ER</td>\n",
" </tr>\n",
" <tr>\n",
" <th>32990</th>\n",
" <td> Virgin Care East Riding LLP</td>\n",
" <td> 1-375458072</td>\n",
" <td> Ironstone Centre</td>\n",
" <td> West Street</td>\n",
" <td> DN15 6HX</td>\n",
" </tr>\n",
" <tr>\n",
" <th>33285</th>\n",
" <td> Virgin Care Wandle LLP</td>\n",
" <td> 1-390977846</td>\n",
" <td> Croydon Urgent Care Centre</td>\n",
" <td> 530 London Road</td>\n",
" <td> CR7 7YE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>34601</th>\n",
" <td> Virgin Care Blackpool LLP</td>\n",
" <td> 1-446510115</td>\n",
" <td> Moor Park Health and Leisure</td>\n",
" <td> Moor Park Health and Leisure Centre</td>\n",
" <td> FY2 0JG</td>\n",
" </tr>\n",
" <tr>\n",
" <th>40947</th>\n",
" <td> Virgin Care Provider Services Limited</td>\n",
" <td> 1-552207793</td>\n",
" <td> Sexual Health Milton Keynes</td>\n",
" <td> 18 Crown Walk</td>\n",
" <td> MK9 3AH</td>\n",
" </tr>\n",
" <tr>\n",
" <th>43944</th>\n",
" <td> Virgin Care Leeds LLP</td>\n",
" <td> 1-582065001</td>\n",
" <td> Virgin Care Leeds LLP</td>\n",
" <td> The Meadow Dale Group Practice</td>\n",
" <td> HX5 0EE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>43953</th>\n",
" <td> Virgin Care Leeds LLP</td>\n",
" <td> 1-582112768</td>\n",
" <td> Meadow Dale Group Practice</td>\n",
" <td> Nursery Lane</td>\n",
" <td> HX3 5SX</td>\n",
" </tr>\n",
" <tr>\n",
" <th>43997</th>\n",
" <td> Virgin Care Leeds LLP</td>\n",
" <td> 1-582399283</td>\n",
" <td> Meadow Dale Group Practice</td>\n",
" <td> Ground floor</td>\n",
" <td> HX6 3AD</td>\n",
" </tr>\n",
" <tr>\n",
" <th>44635</th>\n",
" <td> Virgin Care Chelmsford LLP</td>\n",
" <td> 1-596529441</td>\n",
" <td> North Chelmsford NHS Healthcare Centre</td>\n",
" <td> North Chelmsford NHS Healthcare Centre</td>\n",
" <td> CM2 5EF</td>\n",
" </tr>\n",
" <tr>\n",
" <th>44672</th>\n",
" <td> Virgin Care Services Limited</td>\n",
" <td> 1-600018110</td>\n",
" <td> Meadow Dale Group Practice</td>\n",
" <td> Ground floor, Rosemount House</td>\n",
" <td> HX5 0EE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>44673</th>\n",
" <td> Virgin Care Services Limited</td>\n",
" <td> 1-600018746</td>\n",
" <td> Virgin Care Services Limited</td>\n",
" <td> The Meadow Dale Group Practice</td>\n",
" <td> HX3 5SX</td>\n",
" </tr>\n",
" <tr>\n",
" <th>44708</th>\n",
" <td> Virgin Care Stockton LLP</td>\n",
" <td> 1-604026076</td>\n",
" <td> Stockton NHS Healthcare Centre</td>\n",
" <td> High Newton Road</td>\n",
" <td> TS19 8RH</td>\n",
" </tr>\n",
" <tr>\n",
" <th>44709</th>\n",
" <td> Virgin Care Stockton LLP</td>\n",
" <td> 1-604026780</td>\n",
" <td> Langbaurgh NHS Medical Centre</td>\n",
" <td> Coatham Health Village</td>\n",
" <td> TS10 1SR</td>\n",
" </tr>\n",
" <tr>\n",
" <th>44891</th>\n",
" <td> VH Doctors Limited</td>\n",
" <td> 1-619613982</td>\n",
" <td> VH Doctors Ltd - Purfleet Care Centre</td>\n",
" <td> Purfleet Care Centre</td>\n",
" <td> RM19 1SX</td>\n",
" </tr>\n",
" <tr>\n",
" <th>45026</th>\n",
" <td> Virgin Care Leicestershire LLP</td>\n",
" <td> 1-631450642</td>\n",
" <td> Leicester City Assist Service</td>\n",
" <td> 1A Clyde Street</td>\n",
" <td> LE1 2BG</td>\n",
" </tr>\n",
" <tr>\n",
" <th>45090</th>\n",
" <td> Virgin Care Hartlepool LLP</td>\n",
" <td> 1-639388631</td>\n",
" <td> Hartlepool NHS Healthcare Centre</td>\n",
" <td> One Life Hartlepool</td>\n",
" <td> TS24 7PW</td>\n",
" </tr>\n",
" <tr>\n",
" <th>45264</th>\n",
" <td> Virgin Care East Riding LLP</td>\n",
" <td> 1-659419411</td>\n",
" <td> Story street medical practice and walk in centre</td>\n",
" <td> Wilberforce Health Centre</td>\n",
" <td> HU1 3AS</td>\n",
" </tr>\n",
" <tr>\n",
" <th>45265</th>\n",
" <td> Virgin Care East Riding LLP</td>\n",
" <td> 1-659430334</td>\n",
" <td> Northpoint Medical Practice</td>\n",
" <td> Bransholme Health Centre</td>\n",
" <td> HU7 4DW</td>\n",
" </tr>\n",
" <tr>\n",
" <th>45455</th>\n",
" <td> Virgin Care Services Limited</td>\n",
" <td> 1-677057619</td>\n",
" <td> Ironstone Medical Centre</td>\n",
" <td> West Street</td>\n",
" <td> DN15 6HX</td>\n",
" </tr>\n",
" <tr>\n",
" <th>45456</th>\n",
" <td> Virgin Care Services Limited</td>\n",
" <td> 1-677085054</td>\n",
" <td> Virgin Care Services</td>\n",
" <td> Sterling Street Medical Centre</td>\n",
" <td> DN31 3AE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>45493</th>\n",
" <td> Virgin Care Coventry LLP</td>\n",
" <td> 1-679514695</td>\n",
" <td> Finch Road GP Practice</td>\n",
" <td> Finch Road Surgery</td>\n",
" <td> B19 1HS</td>\n",
" </tr>\n",
" <tr>\n",
" <th>45498</th>\n",
" <td> Virgin Care Coventry LLP</td>\n",
" <td> 1-679851397</td>\n",
" <td> Anchor Centre GP Practice</td>\n",
" <td> Simon House</td>\n",
" <td> CV1 5FX</td>\n",
" </tr>\n",
" <tr>\n",
" <th>45499</th>\n",
" <td> Virgin Care Coventry LLP</td>\n",
" <td> 1-679851773</td>\n",
" <td> Broad Lane GP Practice</td>\n",
" <td> 684 Broad Lane</td>\n",
" <td> CV5 7BB</td>\n",
" </tr>\n",
" <tr>\n",
" <th>45500</th>\n",
" <td> Virgin Care Coventry LLP</td>\n",
" <td> 1-679928232</td>\n",
" <td> Coventry GP and Walk In Centre</td>\n",
" <td> City of Coventry Health Centre</td>\n",
" <td> CV1 4FS</td>\n",
" </tr>\n",
" <tr>\n",
" <th>45501</th>\n",
" <td> Virgin Care Coventry LLP</td>\n",
" <td> 1-679928569</td>\n",
" <td> Deer Park</td>\n",
" <td> Deer Park Medical Centre</td>\n",
" <td> OX28 5YT</td>\n",
" </tr>\n",
" <tr>\n",
" <th>45503</th>\n",
" <td> Virgin Care Coventry LLP</td>\n",
" <td> 1-679928946</td>\n",
" <td> Kingsheath GP Practice</td>\n",
" <td> North Oval</td>\n",
" <td> NN5 7LN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>45504</th>\n",
" <td> Virgin Care Coventry LLP</td>\n",
" <td> 1-679989614</td>\n",
" <td> Lingsbrook GP Practice</td>\n",
" <td> Weston Flavell Centre, Billingbrook Road</td>\n",
" <td> NN3 8DW</td>\n",
" </tr>\n",
" <tr>\n",
" <th>45505</th>\n",
" <td> Virgin Care Coventry LLP</td>\n",
" <td> 1-680020809</td>\n",
" <td> Stone Road</td>\n",
" <td> Stone Road IA Unit</td>\n",
" <td> B15 2HH</td>\n",
" </tr>\n",
" <tr>\n",
" <th>45851</th>\n",
" <td> Virgin Care Vertis LLP</td>\n",
" <td> 1-714016472</td>\n",
" <td> Kingstanding Community Practice</td>\n",
" <td> Warren Farm Road</td>\n",
" <td> B44 0PU</td>\n",
" </tr>\n",
" <tr>\n",
" <th>46400</th>\n",
" <td> North Lancashire Doctors Limited</td>\n",
" <td> 1-791314789</td>\n",
" <td> Royal Lancaster Infirmary</td>\n",
" <td> Royal Lancaster Infirmary</td>\n",
" <td> LA1 4RP</td>\n",
" </tr>\n",
" <tr>\n",
" <th>47138</th>\n",
" <td> Virgin Care Liverpool LLP</td>\n",
" <td> 1-906745991</td>\n",
" <td> Birkenhead Medical Building</td>\n",
" <td> Birkenhead Medical Centre</td>\n",
" <td> CH41 8DB</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"metadata": {},
"output_type": "pyout",
"prompt_number": 45,
"text": [
" Provider Name Location ID \\\n",
"328 VH Doctors Limited 1-1051403692 \n",
"7818 VH Doctors Limited 1-1213929971 \n",
"18328 Virgin Care Blackpool LLP 1-145049431 \n",
"18422 Virgin Care Vertis LLP 1-145283366 \n",
"18423 Virgin Care Vertis LLP 1-145283386 \n",
"18455 Virgin Care Wyre Forest LLP 1-145503153 \n",
"19121 Peninsula Health LLP 1-149321981 \n",
"21936 Virgin Care Macclesfield LLP 1-188720285 \n",
"25696 Virgin Care Cambridge LLP 1-201621036 \n",
"28494 Virgin Care Vertis LLP 1-227856719 \n",
"30657 Virgin Care Coventry LLP 1-301391094 \n",
"31425 Assura Reading LLP 1-318228148 \n",
"32339 VH Doctors Limited 1-348027749 \n",
"32489 North Lancashire Doctors Limited 1-352858943 \n",
"32985 Virgin Care East Riding LLP 1-375358006 \n",
"32989 Virgin Care East Riding LLP 1-375458032 \n",
"32990 Virgin Care East Riding LLP 1-375458072 \n",
"33285 Virgin Care Wandle LLP 1-390977846 \n",
"34601 Virgin Care Blackpool LLP 1-446510115 \n",
"40947 Virgin Care Provider Services Limited 1-552207793 \n",
"43944 Virgin Care Leeds LLP 1-582065001 \n",
"43953 Virgin Care Leeds LLP 1-582112768 \n",
"43997 Virgin Care Leeds LLP 1-582399283 \n",
"44635 Virgin Care Chelmsford LLP 1-596529441 \n",
"44672 Virgin Care Services Limited 1-600018110 \n",
"44673 Virgin Care Services Limited 1-600018746 \n",
"44708 Virgin Care Stockton LLP 1-604026076 \n",
"44709 Virgin Care Stockton LLP 1-604026780 \n",
"44891 VH Doctors Limited 1-619613982 \n",
"45026 Virgin Care Leicestershire LLP 1-631450642 \n",
"45090 Virgin Care Hartlepool LLP 1-639388631 \n",
"45264 Virgin Care East Riding LLP 1-659419411 \n",
"45265 Virgin Care East Riding LLP 1-659430334 \n",
"45455 Virgin Care Services Limited 1-677057619 \n",
"45456 Virgin Care Services Limited 1-677085054 \n",
"45493 Virgin Care Coventry LLP 1-679514695 \n",
"45498 Virgin Care Coventry LLP 1-679851397 \n",
"45499 Virgin Care Coventry LLP 1-679851773 \n",
"45500 Virgin Care Coventry LLP 1-679928232 \n",
"45501 Virgin Care Coventry LLP 1-679928569 \n",
"45503 Virgin Care Coventry LLP 1-679928946 \n",
"45504 Virgin Care Coventry LLP 1-679989614 \n",
"45505 Virgin Care Coventry LLP 1-680020809 \n",
"45851 Virgin Care Vertis LLP 1-714016472 \n",
"46400 North Lancashire Doctors Limited 1-791314789 \n",
"47138 Virgin Care Liverpool LLP 1-906745991 \n",
"\n",
" Location Name \\\n",
"328 Lyme Regis Medical Centre \n",
"7818 East Park Practice \n",
"18328 Oldham Integrated Care Centre \n",
"18422 The Vertis Centre \n",
"18423 Princess Of Wales Community Hospital \n",
"18455 Kidderminster Treatment Centre \n",
"19121 Peninsula Health Birkenhead Medical Building \n",
"21936 Spire Regency Hospital \n",
"25696 Nuffield Road Medical Practice \n",
"28494 The Alexandra Hospital \n",
"30657 Summerfield GP and Urgent Care Centre \n",
"31425 Reading Walk-in Health Centre \n",
"32339 VH Doctors Ltd \n",
"32489 Queen Victoria Centre Morecambe \n",
"32985 Riverside Surgery \n",
"32989 Central Surgery \n",
"32990 Ironstone Centre \n",
"33285 Croydon Urgent Care Centre \n",
"34601 Moor Park Health and Leisure \n",
"40947 Sexual Health Milton Keynes \n",
"43944 Virgin Care Leeds LLP \n",
"43953 Meadow Dale Group Practice \n",
"43997 Meadow Dale Group Practice \n",
"44635 North Chelmsford NHS Healthcare Centre \n",
"44672 Meadow Dale Group Practice \n",
"44673 Virgin Care Services Limited \n",
"44708 Stockton NHS Healthcare Centre \n",
"44709 Langbaurgh NHS Medical Centre \n",
"44891 VH Doctors Ltd - Purfleet Care Centre \n",
"45026 Leicester City Assist Service \n",
"45090 Hartlepool NHS Healthcare Centre \n",
"45264 Story street medical practice and walk in centre \n",
"45265 Northpoint Medical Practice \n",
"45455 Ironstone Medical Centre \n",
"45456 Virgin Care Services \n",
"45493 Finch Road GP Practice \n",
"45498 Anchor Centre GP Practice \n",
"45499 Broad Lane GP Practice \n",
"45500 Coventry GP and Walk In Centre \n",
"45501 Deer Park \n",
"45503 Kingsheath GP Practice \n",
"45504 Lingsbrook GP Practice \n",
"45505 Stone Road \n",
"45851 Kingstanding Community Practice \n",
"46400 Royal Lancaster Infirmary \n",
"47138 Birkenhead Medical Building \n",
"\n",
" Street Address Postal Code \n",
"328 Lyme Regis Medical Centre DT7 3LS \n",
"7818 The Park Healthcare Centre HU9 3JA \n",
"18328 New Radcliffe Street OL1 1NL \n",
"18422 Upper Ground Floor B97 4AJ \n",
"18423 Stourbridge Road B61 0BB \n",
"18455 Bewdley Road DY11 6RJ \n",
"19121 2nd Floor Birkenhead Medical Building CH41 8DB \n",
"21936 West Street SK11 8DW \n",
"25696 Nuffield Road CB4 1GL \n",
"28494 Woodrow Drive B98 7UB \n",
"30657 134 Heath Street B18 7AL \n",
"31425 1st Floor RG1 7QA \n",
"32339 Lynton House WC1H 9LT \n",
"32489 Thornton Road LA4 5NN \n",
"32985 Barnard Avenue DN20 8AS \n",
"32989 King Street DN18 5ER \n",
"32990 West Street DN15 6HX \n",
"33285 530 London Road CR7 7YE \n",
"34601 Moor Park Health and Leisure Centre FY2 0JG \n",
"40947 18 Crown Walk MK9 3AH \n",
"43944 The Meadow Dale Group Practice HX5 0EE \n",
"43953 Nursery Lane HX3 5SX \n",
"43997 Ground floor HX6 3AD \n",
"44635 North Chelmsford NHS Healthcare Centre CM2 5EF \n",
"44672 Ground floor, Rosemount House HX5 0EE \n",
"44673 The Meadow Dale Group Practice HX3 5SX \n",
"44708 High Newton Road TS19 8RH \n",
"44709 Coatham Health Village TS10 1SR \n",
"44891 Purfleet Care Centre RM19 1SX \n",
"45026 1A Clyde Street LE1 2BG \n",
"45090 One Life Hartlepool TS24 7PW \n",
"45264 Wilberforce Health Centre HU1 3AS \n",
"45265 Bransholme Health Centre HU7 4DW \n",
"45455 West Street DN15 6HX \n",
"45456 Sterling Street Medical Centre DN31 3AE \n",
"45493 Finch Road Surgery B19 1HS \n",
"45498 Simon House CV1 5FX \n",
"45499 684 Broad Lane CV5 7BB \n",
"45500 City of Coventry Health Centre CV1 4FS \n",
"45501 Deer Park Medical Centre OX28 5YT \n",
"45503 North Oval NN5 7LN \n",
"45504 Weston Flavell Centre, Billingbrook Road NN3 8DW \n",
"45505 Stone Road IA Unit B15 2HH \n",
"45851 Warren Farm Road B44 0PU \n",
"46400 Royal Lancaster Infirmary LA1 4RP \n",
"47138 Birkenhead Medical Centre CH41 8DB "
]
}
],
"prompt_number": 45
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"virginco={}\n",
"for v in virgin['Provider Name'].unique().tolist():\n",
" virginco[v]=ocReconcileBest(v)\n",
"virginco"
],
"language": "python",
"metadata": {},
"outputs": [
{
"metadata": {},
"output_type": "pyout",
"prompt_number": 111,
"text": [
"{'Virgin Care East Riding LLP': {'type': [{'name': 'Organization',\n",
" 'id': '/organization/organization'}],\n",
" 'uri': 'http://opencorporates.com/companies/gb/OC322010',\n",
" 'score': 85.0,\n",
" 'name': 'VIRGIN CARE EAST RIDING LLP',\n",
" 'id': '/companies/gb/OC322010',\n",
" 'match': False},\n",
" 'Assura Reading LLP': {'type': [{'name': 'Organization',\n",
" 'id': '/organization/organization'}],\n",
" 'uri': 'http://opencorporates.com/companies/gb/OC336595',\n",
" 'score': 85.0,\n",
" 'name': 'ASSURA READING LLP',\n",
" 'id': '/companies/gb/OC336595',\n",
" 'match': False},\n",
" 'Virgin Care Wandle LLP': {'type': [{'name': 'Organization',\n",
" 'id': '/organization/organization'}],\n",
" 'uri': 'http://opencorporates.com/companies/gb/OC338798',\n",
" 'score': 85.0,\n",
" 'name': 'VIRGIN CARE WANDLE LLP',\n",
" 'id': '/companies/gb/OC338798',\n",
" 'match': False},\n",
" 'Virgin Care Vertis LLP': {'type': [{'name': 'Organization',\n",
" 'id': '/organization/organization'}],\n",
" 'uri': 'http://opencorporates.com/companies/gb/OC326636',\n",
" 'score': 85.0,\n",
" 'name': 'VIRGIN CARE VERTIS LLP',\n",
" 'id': '/companies/gb/OC326636',\n",
" 'match': False},\n",
" 'Virgin Care Leeds LLP': {'type': [{'name': 'Organization',\n",
" 'id': '/organization/organization'}],\n",
" 'uri': 'http://opencorporates.com/companies/gb/OC337207',\n",
" 'score': 85.0,\n",
" 'name': 'VIRGIN CARE LEEDS LLP',\n",
" 'id': '/companies/gb/OC337207',\n",
" 'match': False},\n",
" 'Virgin Care Liverpool LLP': {'type': [{'name': 'Organization',\n",
" 'id': '/organization/organization'}],\n",
" 'uri': 'http://opencorporates.com/companies/gb/OC320467',\n",
" 'score': 85.0,\n",
" 'name': 'VIRGIN CARE LIVERPOOL LLP',\n",
" 'id': '/companies/gb/OC320467',\n",
" 'match': False},\n",
" 'Virgin Care Cambridge LLP': {'type': [{'name': 'Organization',\n",
" 'id': '/organization/organization'}],\n",
" 'uri': 'http://opencorporates.com/companies/gb/OC337660',\n",
" 'score': 85.0,\n",
" 'name': 'VIRGIN CARE CAMBRIDGE LLP',\n",
" 'id': '/companies/gb/OC337660',\n",
" 'match': False},\n",
" 'Virgin Care Services Limited': {'type': [{'name': 'Organization',\n",
" 'id': '/organization/organization'}],\n",
" 'uri': 'http://opencorporates.com/companies/gb/07557877',\n",
" 'score': 86.0,\n",
" 'name': 'VIRGIN CARE SERVICES LIMITED',\n",
" 'id': '/companies/gb/07557877',\n",
" 'match': False},\n",
" 'Virgin Care Coventry LLP': {'type': [{'name': 'Organization',\n",
" 'id': '/organization/organization'}],\n",
" 'uri': 'http://opencorporates.com/companies/gb/OC338351',\n",
" 'score': 85.0,\n",
" 'name': 'VIRGIN CARE COVENTRY LLP',\n",
" 'id': '/companies/gb/OC338351',\n",
" 'match': False},\n",
" 'VH Doctors Limited': {'type': [{'name': 'Organization',\n",
" 'id': '/organization/organization'}],\n",
" 'uri': 'http://opencorporates.com/companies/gb/07087850',\n",
" 'score': 86.0,\n",
" 'name': 'VH DOCTORS LIMITED',\n",
" 'id': '/companies/gb/07087850',\n",
" 'match': False},\n",
" 'Virgin Care Leicestershire LLP': {'type': [{'name': 'Organization',\n",
" 'id': '/organization/organization'}],\n",
" 'uri': 'http://opencorporates.com/companies/gb/OC337208',\n",
" 'score': 85.0,\n",
" 'name': 'VIRGIN CARE LEICESTERSHIRE LLP',\n",
" 'id': '/companies/gb/OC337208',\n",
" 'match': False},\n",
" 'North Lancashire Doctors Limited': {'type': [{'name': 'Organization',\n",
" 'id': '/organization/organization'}],\n",
" 'uri': 'http://opencorporates.com/companies/gb/07178590',\n",
" 'score': 86.0,\n",
" 'name': 'NORTH LANCASHIRE DOCTORS LIMITED',\n",
" 'id': '/companies/gb/07178590',\n",
" 'match': False},\n",
" 'Virgin Care Macclesfield LLP': {'type': [{'name': 'Organization',\n",
" 'id': '/organization/organization'}],\n",
" 'uri': 'http://opencorporates.com/companies/gb/OC322654',\n",
" 'score': 85.0,\n",
" 'name': 'VIRGIN CARE MACCLESFIELD LLP',\n",
" 'id': '/companies/gb/OC322654',\n",
" 'match': False},\n",
" 'Virgin Care Blackpool LLP': {'type': [{'name': 'Organization',\n",
" 'id': '/organization/organization'}],\n",
" 'uri': 'http://opencorporates.com/companies/gb/OC333037',\n",
" 'score': 85.0,\n",
" 'name': 'VIRGIN CARE BLACKPOOL LLP',\n",
" 'id': '/companies/gb/OC333037',\n",
" 'match': False},\n",
" 'Virgin Care Provider Services Limited': {'type': [{'name': 'Organization',\n",
" 'id': '/organization/organization'}],\n",
" 'uri': 'http://opencorporates.com/companies/gb/07645492',\n",
" 'score': 86.0,\n",
" 'name': 'VIRGIN CARE PROVIDER SERVICES LIMITED',\n",
" 'id': '/companies/gb/07645492',\n",
" 'match': False},\n",
" 'Peninsula Health LLP': {'type': [{'name': 'Organization',\n",
" 'id': '/organization/organization'}],\n",
" 'uri': 'http://opencorporates.com/companies/gb/OC327017',\n",
" 'score': 85.0,\n",
" 'name': 'PENINSULA HEALTH LLP',\n",
" 'id': '/companies/gb/OC327017',\n",
" 'match': False},\n",
" 'Virgin Care Stockton LLP': {'type': [{'name': 'Organization',\n",
" 'id': '/organization/organization'}],\n",
" 'uri': 'http://opencorporates.com/companies/gb/OC338425',\n",
" 'score': 85.0,\n",
" 'name': 'VIRGIN CARE STOCKTON LLP',\n",
" 'id': '/companies/gb/OC338425',\n",
" 'match': False},\n",
" 'Virgin Care Wyre Forest LLP': {'type': [{'name': 'Organization',\n",
" 'id': '/organization/organization'}],\n",
" 'uri': 'http://opencorporates.com/companies/gb/OC333038',\n",
" 'score': 85.0,\n",
" 'name': 'VIRGIN CARE WYRE FOREST LLP',\n",
" 'id': '/companies/gb/OC333038',\n",
" 'match': False},\n",
" 'Virgin Care Chelmsford LLP': {'type': [{'name': 'Organization',\n",
" 'id': '/organization/organization'}],\n",
" 'uri': 'http://opencorporates.com/companies/gb/OC337209',\n",
" 'score': 85.0,\n",
" 'name': 'VIRGIN CARE CHELMSFORD LLP',\n",
" 'id': '/companies/gb/OC337209',\n",
" 'match': False},\n",
" 'Virgin Care Hartlepool LLP': {'type': [{'name': 'Organization',\n",
" 'id': '/organization/organization'}],\n",
" 'uri': 'http://opencorporates.com/companies/gb/OC338356',\n",
" 'score': 85.0,\n",
" 'name': 'VIRGIN CARE HARTLEPOOL LLP',\n",
" 'id': '/companies/gb/OC338356',\n",
" 'match': False}}"
]
}
],
"prompt_number": 111
},
{
"cell_type": "code",
"collapsed": false,
"input": [],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 45
},
{
"cell_type": "code",
"collapsed": false,
"input": [],
"language": "python",
"metadata": {},
"outputs": []
}
],
"metadata": {}
}
]
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment