home / nhsadmin

Private Controlled Drug Prescribers

Data source: OUseful Databeat

6,479 rows sorted by Contact Telephone Number

View and edit SQL

This data as .json

Suggested facets: National Grouping, High Level Health Geography, Organisation Sub-Type Code, Parent Organisation Code, Amended Record Indicator

Link rowid Organisation Code Name National Grouping High Level Health Geography Address Line 1 Address Line 2 Address Line 3 Address Line 4 Address Line 5 Postcode Open Date Close Date Organisation Sub-Type Code Parent Organisation Code Join Parent Date Left Parent Date Contact Telephone Number ▼ Amended Record Indicator
746 Q6107697 KAFETZ K Y56 Q71 22 OFFHAM SLOPE     LONDON   N12 7BZ 2006-04-01 00:00:00   1 Q71 2013-03-20 00:00:00   01089 225642 0
1093 Q6111227 DWYER AS Y51 Q32 ST GEMMA'S HOSPICE 329 HARROGATE ROAD MOORTOWN LEEDS   LS17 6QD 2006-06-06 00:00:00   1 Q72 2015-04-01 00:00:00   0113 2185500 0
1094 Q6111234 BENNETT MI Y51 Q32 ST GEMMA'S HOSPICE 329 HARROGATE ROAD MOORTOWN LEEDS   LS17 6QD 2006-06-06 00:00:00   1 Q72 2015-04-01 00:00:00   0113 2185500 0
1095 Q6111241 EDWARDS PJ Y51 Q32 ST GEMMA'S HOSPICE 329 HARROGATE ROAD MOORTOWN LEEDS   LS17 6QD 2006-06-06 00:00:00   1 Q72 2015-04-01 00:00:00   0113 2185500 0
1096 Q6111258 STOCKTON MR Y51 Q32 ST GEMMA'S HOSPICE 329 HARROGATE ROAD MOORTOWN LEEDS   LS17 6QD 2006-06-06 00:00:00   1 Q72 2015-04-01 00:00:00   0113 2185500 0
1097 Q6111265 TAYLOR PM Y51 Q32 ST GEMMA'S HOSPICE 329 HARROGATE ROAD MOORTOWN LEEDS   LS17 6QD 2006-06-06 00:00:00   1 Q72 2015-04-01 00:00:00   0113 2185500 0
1336 Q6113731 PECK RA Y51 Q32 ST GEMMA'S HOSPICE 329 HARROGATE ROAD MOORTOWN LEEDS   LS17 6QD 2006-07-20 00:00:00   1 Q72 2015-04-01 00:00:00   0113 2185500 0
1338 Q6113755 DIXON RE Y51 Q32 ST GEMMA'S HOSPICE 329 HARROGATE ROAD MOORTOWN LEEDS   LS17 6QD 2006-07-20 00:00:00   1 Q72 2015-04-01 00:00:00   0113 2185500 0
1826 Q6118781 SHEPPARD AL Y51 Q32 ST GEMMA'S HOSPICE 329 HARROGATE ROAD MOORTOWN LEEDS   LS17 6QD 2006-08-06 00:00:00   1 Q72 2015-04-01 00:00:00   0113 2185500 0
1977 Q6120357 BROWN EL Y51 Q32 ST GEMMA'S HOSPICE 329 HARROGATE ROAD MOORTOWN LEEDS   LS17 6QD 2006-10-02 00:00:00   1 Q72 2015-04-01 00:00:00   0113 2185500 0
6075 Q6162175 FELDMAN S Y54 Q72 LIVINGCARE HLTH SERVICES TOP FLOOR, EAST PARK MC 5-7 EAST PARK ROAD     LS9 9JD 2016-03-08 00:00:00   1 Q72 2016-03-08 00:00:00   0113 2365962 0
1041 Q6110673 GOULD MI Y54 Q72 2 UPLAND ROAD   LEEDS     LS8 2SQ 2006-06-01 00:00:00   1 Q72 2015-04-01 00:00:00   0113 2401234 0
1165 Q6111973 AL-TIMMAN JKS Y54 Q72 2 UPLAND ROAD   LEEDS     LS8 2SQ 2006-07-01 00:00:00   1 Q72 2015-04-01 00:00:00   0113 2401234 0
2456 Q6125242 WELCH RB Y54 Q72 THE ROOKERY SCOTLAND LANE HORSFORTH, LEEDS     LS18 5HP 2006-11-07 00:00:00   1 Q72 2015-04-01 00:00:00   0113 2582283 0
5029 Q6151562 MORGAN PN Y54 Q72 155 POTTERNEWTON LANE   LEEDS     LS7 3DF 2012-08-13 00:00:00   1 Q72 2015-04-01 00:00:00   0113 2624125 0
4062 Q6141637 BRIDGE MJ Y54 Q72 50 VICTORIA STREET CHAPEL ALLERTON LEEDS     LS7 4PB 2009-08-25 00:00:00   1 Q72 2015-04-01 00:00:00   0113 2665553 0
5631 Q6157726 BASKIND RL Y54 Q72 THE TOWER CLINIC 8 TINSHILL LANE,COOKRIDGE LEEDS     LS16 7AP 2014-10-06 00:00:00   1 Q72 2015-04-01 00:00:00   0113 2672067 0
16 Q6100212 DODWELL DJ Y54 Q72 BUPA HOSPITAL LEEDS JACKSON AVENUE,ROUNDHAY LEEDS     LS8 3BH 2006-04-01 00:00:00   1 Q72 2015-04-01 00:00:00   0113 2693939 0
18 Q6100236 SEBAG-MONTEFIORE D Y54 Q72 BUPA HOSPITAL LEEDS JACKSON AVENUE,ROUNDHAY LEEDS     LS8 3BH 2006-04-01 00:00:00   1 Q72 2015-04-01 00:00:00   0113 2693939 0
19 Q6100243 SIMPSON KH Y54 Q72 BUPA HOSPITAL LEEDS JACKSON AVENUE,ROUNDHAY LEEDS     LS8 3BH 2006-04-01 00:00:00   1 Q72 2015-04-01 00:00:00   0113 2693939 0
22 Q6100274 ASH DV Y54 Q72 BUPA HOSPITAL LEEDS JACKSON AVENUE,ROUNDHAY LEEDS     LS8 3BH 2006-04-01 00:00:00   1 Q72 2015-04-01 00:00:00   0113 2693939 0
24 Q6100298 MELCHER A Y54 Q72 BUPA HOSPITAL LEEDS JACKSON AVENUE,ROUNDHAY LEEDS     LS8 3BH 2006-04-01 00:00:00   1 Q72 2015-04-01 00:00:00   0113 2693939 0
25 Q6100308 PERREN TJ Y54 Q72 BUPA HOSPITAL LEEDS JACKSON AVENUE,ROUNDHAY LEEDS     LS8 1NT 2006-04-01 00:00:00   1 Q72 2015-04-01 00:00:00   0113 2693939 0
26 Q6100315 DICKSON DE Y54 Q72 BUPA HOSPITAL LEEDS JACKSON AVENUE,ROUNDHAY LEEDS     LS8 3BH 2006-04-01 00:00:00   1 Q72 2015-04-01 00:00:00   0113 2693939 0
27 Q6100322 CRELLIN AM Y54 Q72 BUPA HOSPITAL LEEDS JACKSON AVENUE,ROUNDHAY LEEDS     LS8 3BH 2006-04-01 00:00:00   1 Q72 2015-04-01 00:00:00   0113 2693939 0
28 Q6100339 BUSH D Y54 Q72 BUPA HOSPITAL LEEDS JACKSON AVENUE,ROUNDHAY LEEDS     LS8 3BH 2006-04-01 00:00:00   1 Q72 2015-04-01 00:00:00   0113 2693939 0
1917 Q6119720 TAYLOR CM Y54 Q72 SPIRE LEEDS HOSPITAL JACKSON AVENUE, ROUNDHAY LEEDS WEST YORKSHIRE   LS8 1NT 2006-08-12 00:00:00   1 Q72 2015-04-01 00:00:00   0113 2693939 0
1925 Q6119809 WILLIAMS GJ Y54 Q72 SPIRE LEEDS HOSPITAL JACKSON AVENUE, ROUNDHAY LEEDS WEST YORKSHIRE   LS8 1NT 2006-08-18 00:00:00   1 Q72 2015-04-01 00:00:00   0113 2693939 0
4061 Q6141620 TATHAM DP Y54 Q72 79 BIRKDALE DRIVE ALWOODLEY LEEDS     LS17 7RU 2009-08-25 00:00:00   1 Q72 2015-04-01 00:00:00   0113 2695765 0
1031 Q6110570 SELBY PA Y51 Q32 WHEATFIELDS(SUE RYDER) GROVE ROAD HEADINGLEY,LEEDS WEST YORKSHIRE   LS6 2AE 2006-06-06 00:00:00   1 Q72 2015-04-01 00:00:00   0113 2787249 0
1032 Q6110587 BOOTH JA Y51 Q32 WHEATFIELDS(SUE RYDER) GROVE ROAD HEADINGLEY,LEEDS WEST YORKSHIRE   LS6 2AE 2006-06-06 00:00:00   1 Q72 2015-04-01 00:00:00   0113 2787249 0
1033 Q6110594 EDWARDS AS Y51 Q32 WHEATFIELDS(SUE RYDER) GROVE ROAD HEADINGLEY,LEEDS WEST YORKSHIRE   LS6 2AE 2006-06-06 00:00:00   1 Q72 2015-04-01 00:00:00   0113 2787249 0
1034 Q6110604 MCDERMOTT I Y51 Q32 WHEATFIELDS(SUE RYDER) GROVE ROAD HEADINGLEY,LEEDS WEST YORKSHIRE   LS6 2AE 2006-06-06 00:00:00   1 Q72 2015-04-01 00:00:00   0113 2787249 0
1035 Q6110611 RUSSON LJ Y51 Q32 WHEATFIELDS(SUE RYDER) GROVE ROAD HEADINGLEY,LEEDS WEST YORKSHIRE   LS6 2AE 2006-06-06 00:00:00   1 Q72 2015-04-01 00:00:00   0113 2787249 0
1036 Q6110628 SAWERS ADI Y51 Q32 WHEATFIELDS(SUE RYDER) GROVE ROAD HEADINGLEY,LEEDS WEST YORKSHIRE   LS6 2AE 2006-06-06 00:00:00   1 Q72 2015-04-01 00:00:00   0113 2787249 0
1098 Q6111272 URQUHART GN Y51 Q32 WHEATFIELDS(SUE RYDER) GROVE ROAD HEADINGLEY,LEEDS WEST YORKSHIRE   LS6 2AE 2006-06-06 00:00:00   1 Q72 2015-04-01 00:00:00   0113 2787249 0
2400 Q6124681 SONNY C Y51 Q32 SERCO HEALTH PRINCES EXCHANGE PRINCES SQUARE,LEEDS     LS1 4HY 2006-11-01 00:00:00   1 Q72 2015-04-01 00:00:00   0113 2805878 0
3892 Q6139865 BROWNING FSC Y54 Q72 TERRY LUG FARMHOUSE BRAMHAM PARK WETHERBY WEST YORKSHIRE   LS23 6LT 2009-04-06 00:00:00   1 Q72 2015-04-01 00:00:00   0113 2892790 0
4557 Q6146780 OSTLER C Y54 Q72 LEEDS STUDENT MED PRACT. 4 BLENHEIM COURT BLENHEIM WALK LEEDS   LS2 9AE 2011-02-01 00:00:00   1 Q72 2015-04-01 00:00:00   0113 295 448 0
3610 Q6137014 BIRAN LA Y54 Q72 CRAVEN ROAD MEDICAL CTR 60 CRAVEN ROAD LEEDS     LS6 2RX 2008-08-11 00:00:00   1 Q72 2015-04-01 00:00:00   0113 2953530 0
2732 Q6128018 MILLS CA Y54 Q72 RAWDON SURGERY 11 NEW ROAD SIDE, RAWDON LEEDS WEST YORKSHIRE   LS19 6DD 2007-02-12 00:00:00   1 Q72 2015-04-01 00:00:00   0113 2954234 0
5398 Q6155377 GREENWAY J Y54 Q72 LEEDS STUDENT MED PRACT 4 BLENHEIM COURT LEEDS WEST YORKSHIRE   LS2 9AE 2014-02-11 00:00:00   1 Q72 2015-04-01 00:00:00   0113 2954488 0
674 Q6106971 JAMIL FF Y54 Q72 NUFFIELD HOSPITAL LEEDS 2 LEIGHTON STREET LEEDS     LS1 3EB 2006-04-01 00:00:00   1 Q72 2015-04-01 00:00:00   0113 3882000 0
1081 Q6111100 LANE P Y54 Q72 NUFFIELD HOSPITAL LEEDS 2 LEIGHTON STREET LEEDS     LS1 3EB 2006-06-20 00:00:00   1 Q72 2015-04-01 00:00:00   0113 3882000 0
1082 Q6111117 DICKSON D Y54 Q72 NUFFIELD HOSPITAL LEEDS 2 LEIGHTON STREET LEEDS     LS1 3EB 2006-06-20 00:00:00   1 Q72 2015-04-01 00:00:00   0113 3882000 0
1194 Q6112273 WILLIAMS G Y54 Q72 NUFFIELD HOSPITAL LEEDS 2 LEIGHTON STREET LEEDS     LS1 3EB 2006-07-04 00:00:00   1 Q72 2015-04-01 00:00:00   0113 3882000 0
3727 Q6138204 ALEXANDER MS Y54 Q72 NUFFIELD HOSPITAL LEIGHTON STREET LEEDS     LS1 3EB 2008-12-05 00:00:00   1 Q72 2015-04-01 00:00:00   0113 3882107 0
4496 Q6146175 LILY O Y54 Q72 LEEDS TEACHING HOSP TRUST G FLOOR, MARTIN WING GREAT GEORGE STREET LEEDS   LS1 3EX 2011-01-01 00:00:00   1 Q72 2015-04-01 00:00:00   0113 3928232 0
5560 Q6157018 Q63 PRIVATE CD DENTIST Y56 Q71 C/O LONDON REGION NHS ENGLAND,SKIPTON HSE 80 LONDON ROAD     SE1 6LH 2014-06-01 00:00:00   1 Q71 2013-03-20 00:00:00   0113 8070791 1
5561 Q6157025 Q62 PRIVATE CD DENTIST Y56 Q71 C/O LONDON REGION NHS ENGLAND,SKIPTON HSE 80 LONDON ROAD LONDON   SE1 6LH 2014-06-01 00:00:00   1 Q71 2013-03-20 00:00:00   0113 8070791 1
5562 Q6157032 Q61 PRIVATE CD DENTIST Y56 Q71 C/O LONDON REGION NHS ENGLAND,SKIPTON HSE 80 LONDON ROAD LONDON   SE1 6LH 2014-06-01 00:00:00   1 Q71 2013-03-20 00:00:00   0113 8070791 1
5471 Q6156127 Q59 PRIVATE CD DENTIST Y55 Q78 1ST FL WEST, FOSSE HOUSE 4 SMITH WAY, GROVE PARK ENDERBY LEICESTERSHIRE   LE19 1SX 2014-04-01 00:00:00   1 Q78 2015-04-01 00:00:00   0113 8249614 0
6398 Q6165549 SHARMA R Y56 Q71 17 LYNDHURST GARDENS LONDON       NW3 5NS 2017-01-18 00:00:00   1 Q71 2013-03-20 00:00:00   0113 8249663 0
1564 Q6116112 Q55 PRIVATE CD DENTIST Y55 Q76 BIRCH HSE,RANSOM WOOD B/P SOUTHWELL ROAD WEST MANSFIELD NOTTINGHAMSHIRE   NG21 0HJ 2006-07-01 00:00:00   1 Q76 2015-04-01 00:00:00   0113 8249774 0
1923 Q6119782 Q50 PRIVATE CD DENTIST Y54 Q72 UNIT 3, ALPHA COURT MONKS CROSS YORK NORTH YORKSHIRE   YO32 9WN 2006-08-01 00:00:00   1 Q72 2015-04-01 00:00:00   0113 8251857 0
2401 Q6124698 Q52 PRIVATE CD DENTIST Y54 Q72 C/O NHS ENGLAND (W YORKS) 3 LEEDS CITY OFFICE PARK LEEDS WEST YORKSHIRE   LS11 5BD 2006-11-01 00:00:00   1 Q72 2015-04-01 00:00:00   0113 8252700 0
5374 Q6155133 Q64 PRIVATE CD DENTIST Y57 Q82 SANGER HOUSE GLOUCESTER BUSINESS PARK BROCKWORTH GLOUCESTER   GL3 4FE 2013-11-01 00:00:00   1 Q82 2015-04-01 00:00:00   0113 8253499 0
5908 Q6160506 Q56 PRIVATE CD DENTIST Y55 Q79 WEST WING, VICTORIA HOUSE CAPITAL BUSINESS PARK CAMBRIDGE     CB21 5XA 2015-06-01 00:00:00   1 Q79 2015-06-01 00:00:00   0113 8254917 0
1160 Q6111928 5NH PRIVATE CD DENTIST Y54 Q73 4TH FL,3 PICCADILLY PLACE LONDON ROAD MANCHESTER     M1 3BN 2006-07-01 00:00:00   1 Q73 2015-04-01 00:00:00   0113 8255216 0
2521 Q6125905 JAKUBOVIC MO Y51 Q32 UNIVERSITY HEALTH SERVICE 53 GELL STREET SHEFFIELD     S3 7QP 2006-11-17 00:00:00   1 Q72 2015-04-01 00:00:00   0114 2222100 0
2522 Q6125912 PAI S Y51 Q32 UNIVERSITY HEALTH SERVICE 53 GELL STREET SHEFFIELD     S3 7QP 2006-11-17 00:00:00   1 Q72 2015-04-01 00:00:00   0114 2222100 0
2523 Q6125929 LEIGH VF Y51 Q32 UNIVERSITY HEALTH SERVICE 53 GELL STREET SHEFFIELD     S3 7QP 2006-11-17 00:00:00   1 Q72 2015-04-01 00:00:00   0114 2222100 0
2524 Q6125936 OSBORNE MA Y51 Q32 UNIVERSITY HEALTH SERVICE 53 GELL STREET SHEFFIELD     S3 7QP 2006-11-17 00:00:00   1 Q72 2015-04-01 00:00:00   0114 2222100 0
2525 Q6125943 PORTLOCK KM Y51 Q32 UNIVERSITY HEALTH SERVICE 53 GELL STREET SHEFFIELD     S3 7QP 2006-11-17 00:00:00   1 Q72 2015-04-01 00:00:00   0114 2222100 0
2526 Q6125950 KING JA Y51 Q32 UNIVERSITY HEALTH SERVICE 53 GELL STREET SHEFFIELD     S3 7QP 2006-11-17 00:00:00   1 Q72 2015-04-01 00:00:00   0114 2222100 0
2527 Q6125967 SOLTANI H Y51 Q32 UNIVERSITY HEALTH SERVICE 53 GELL STREET SHEFFIELD     S3 7QP 2006-11-17 00:00:00   1 Q72 2015-04-01 00:00:00   0114 2222100 0
2528 Q6125974 JACKSON BJ Y51 Q32 UNIVERSITY HEALTH SERVICE 53 GELL STREET SHEFFIELD     S3 7QP 2006-11-17 00:00:00   1 Q72 2015-04-01 00:00:00   0114 2222100 0
2529 Q6125981 D'MELLO B Y51 Q32 UNIVERSITY HEALTH SERVICE 53 GELL STREET SHEFFIELD     S3 7QP 2006-11-17 00:00:00   1 Q72 2015-04-01 00:00:00   0114 2222100 0
2530 Q6125998 JAMES AF Y51 Q32 UNIVERSITY HEALTH SERVICE 53 GELL STREET SHEFFIELD     S3 7QP 2006-11-17 00:00:00   1 Q72 2015-04-01 00:00:00   0114 2222100 0
2231 Q6122957 HARDISTY CA Y51 Q32 THORNBURY HOSPITAL 312 FULWOOD ROAD SHEFFIELD     S10 3BR 2006-09-18 00:00:00   1 Q72 2015-04-01 00:00:00   0114 2261133 0
5434 Q6155748 ROPER SG Y54 Q72 RIVERDALE E D HOSPITAL 93 RIVERDALE ROAD SHEFFIELD     S10 3FE 2014-03-27 00:00:00   1 Q72 2015-04-01 00:00:00   0114 2302140 0
5049 Q6151775 MACASKILL ND Y54 Q72 60 STUMPERLOWE CRESCENT ROAD,FULWOOD SHEFFIELD     S10 3PR 2012-08-28 00:00:00   1 Q72 2015-04-01 00:00:00   0114 2302755 0
4117 Q6142188 KEEN JA Y54 Q72 PHOENIX FUTURES 229 GRAHAM ROAD SHEFFIELD SOUTH YORKSHIRE   S10 3GS 2009-11-20 00:00:00   1 Q72 2015-04-01 00:00:00 2014-11-30 00:00:00 0114 2308230 0
5248 Q6153825 KANDLER L Y54 Q72 PHOENIX HSE RES/SERVICE 229 GRAHAM ROAD SHEFFIELD SOUTH YORKSHIRE   S10 3GS 2013-06-12 00:00:00   2 Q72 2015-04-01 00:00:00   0114 2308230 0
5653 Q6157946 HORSFIELD TA Y54 Q72 PHOENIX FUTURES 229 GRAHAM ROAD SHEFFIELD SOUTH YORKSHIRE   S10 3GS 2014-09-24 00:00:00   2 Q72 2015-04-01 00:00:00   0114 2308230 0
6080 Q6162223 BOWRY V Y54 Q72 PHOENIX HOUSE 299 GRAHAM RD SHEFFIELD SOUTH YORKSHIRE   S10 3GS 2016-03-10 00:00:00   1 Q72 2016-03-10 00:00:00   0114 2308320 0
4274 Q6143873 REES LB Y51 Q32 FOXHILL MEDICAL CENTRE 363 HALIFAX ROAD SHEFFIELD     S6 1AF 2010-05-01 00:00:00   1 Q72 2015-04-01 00:00:00   0114 2322055 0
5199 Q6153289 VERITY R Y54 Q72 PARKHEAD CONSULTANCY 356 ECCLESALL ROAD SOUTH SHEFFIELD     S11 9PU 2013-03-21 00:00:00   1 Q72 2015-04-01 00:00:00   0114 2361281 0
2357 Q6124241 SPEAR FG Y51 Q32 326 ECCLESALL ROAD SOUTH   SHEFFIELD     S11 9PU 2006-10-16 00:00:00   1 Q72 2015-04-01 00:00:00   0114 2366766 0
542 Q6105602 YARDLEY MPJ Y54 Q72 31 DORE ROAD DORE SHEFFIELD     S17 3NA 2006-04-01 00:00:00   1 Q72 2015-04-01 00:00:00   0114 2369818 0
4750 Q6148744 CHATTERJEE DK Y54 Q72 28 DUNNINC ROAD   SHEFFIELD     S5 0AE 2011-10-20 00:00:00   1 Q72 2015-04-01 00:00:00   0114 2570788 0
2719 Q6127880 WALKER CJ Y54 Q72 KENWOOD PARK CLINIC 28 KENWOOD PARK ROAD SHEFFIELD     S7 1NF 2007-02-08 00:00:00   1 Q72 2015-04-01 00:00:00   0114 2582550 0
734 Q6107570 SHAKER AG Y54 Q72 CARE SHEFFIELD 26 GLEN ROAD SHEFFIELD SOUTH YORKSHIRE   S7 1RA 2006-04-10 00:00:00   1 Q72 2015-04-01 00:00:00   0114 2589716 0
815 Q6108382 THORNTON SJ Y54 Q72 CARE SHEFFIELD 26 GLEN ROAD SHEFFIELD SOUTH YORKSHIRE   S7 1RA 2006-05-04 00:00:00   1 Q72 2015-04-01 00:00:00   0114 2589716 0
880 Q6109046 LOWE P Y54 Q72 CARE SHEFFIELD 26 GLEN ROAD SHEFFIELD SOUTH YORKSHIRE   S7 1RA 2006-05-16 00:00:00   1 Q72 2015-04-01 00:00:00   0114 2589716 0
1820 Q6118729 HAMMADIEH N Y54 Q72 CARE SHEFFIELD 26 GLEN ROAD SHEFFIELD SOUTH YORKSHIRE   S7 1RA 2006-08-08 00:00:00   1 Q72 2015-04-01 00:00:00   0114 2589716 0
3286 Q6133649 RAGUNATH M Y54 Q72 CARE SHEFFIELD 26 GLEN ROAD SHEFFIELD SOUTH YORKSHIRE   S7 1RA 2007-12-20 00:00:00   1 Q72 2015-04-01 00:00:00   0114 2589716 0
4729 Q6148531 SOLOMONSZ FA Y54 Q72 CARE SHEFFIELD 26 GLEN ROAD SHEFFIELD SOUTH YORKSHIRE   S7 1RA 2011-10-01 00:00:00   1 Q72 2015-04-01 00:00:00   0114 2589716 0
4868 Q6149934 MARIKINTI K Y54 Q72 CARE SHEFFIELD 26 GLEN ROAD SHEFFIELD SOUTH YORKSHIRE   S7 1RA 2012-02-15 00:00:00   1 Q72 2015-04-01 00:00:00   0114 2589716 0
5191 Q6153203 SABHARWAL S Y54 Q72 CARE SHEFFIELD LTD 26 GLEN ROAD SHEFFIELD     S7 1RA 2013-03-05 00:00:00   1 Q72 2015-04-01 00:00:00   0114 2589716 0
5369 Q6155085 MOHAMED M Y54 Q72 CARE SHEFFIELD 26 GLEN ROAD SHEFFIELD SOUTH YORKSHIRE   S7 1RA 2013-11-01 00:00:00   1 Q72 2015-04-01 00:00:00   0114 2589716 0
5404 Q6155432 DOWELL K Y54 Q72 CARE SHEFFIELD 26 GLEN ROAD SHEFFIELD SOUTH YORKSHIRE   S7 1RA 2014-01-01 00:00:00   1 Q72 2015-04-01 00:00:00   0114 2589716 0
543 Q6105619 BEARD JD Y54 Q72 C/O CLAREMONT HOSPITAL 401 SANDYGATE ROAD SHEFFIELD     S10 5UB 2006-04-01 00:00:00   1 Q72 2015-04-01 00:00:00   0114 2630330 0
544 Q6105626 GALIMBERTI A Y51 Q32 C/O CLAREMONT HOSPITAL 401 SANDYGATE ROAD SHEFFIELD     S10 5UB 2006-04-01 00:00:00   1 Q72 2015-04-01 00:00:00   0114 2630330 0
550 Q6105688 CHARKRABARTI I Y54 Q72 C/O CLAREMONT HOSPITAL 401 SANDYGATE ROAD SHEFFIELD     S10 5UB 2006-04-01 00:00:00   1 Q72 2015-04-01 00:00:00   0114 2630330 0
1450 Q6114938 EDWARDS ND Y54 Q72 C/O CLAREMONT HOSPITAL 401 SANDYGATE ROAD SHEFFIELD     S10 5UB 2006-08-01 00:00:00   1 Q72 2015-04-01 00:00:00   0114 2630330 0
1452 Q6114952 HASHIM A Y54 Q72 C/O CLAREMONT HOSPITAL 401 SANDYGATE ROAD SHEFFIELD     S10 5UB 2006-08-01 00:00:00   1 Q72 2015-04-01 00:00:00   0114 2630330 0
1453 Q6114969 MAJEED AW Y54 Q72 C/O CLAREMONT HOSPITAL 401 SANDYGATE ROAD SHEFFIELD     S10 5UB 2006-08-01 00:00:00   1 Q72 2015-04-01 00:00:00   0114 2630330 0
1454 Q6114976 CULLEN DR Y51 Q32 C/O CLAREMONT HOSPITAL 401 SANDYGATE ROAD SHEFFIELD     S10 5UB 2006-08-01 00:00:00   1 Q72 2015-04-01 00:00:00   0114 2630330 0
3985 Q6140825 LAGUNDOYE O Y54 Q72 CLAREMONT HOSPITAL 410 SANDYGATE ROAD SHEFFIELD     S10 5UB 2009-06-30 00:00:00   1 Q72 2015-04-01 00:00:00   0114 2630330 0

Next page

CREATE TABLE "epcdp" (
"Organisation Code" TEXT,
  "Name" TEXT,
  "National Grouping" TEXT,
  "High Level Health Geography" TEXT,
  "Address Line 1" TEXT,
  "Address Line 2" TEXT,
  "Address Line 3" TEXT,
  "Address Line 4" TEXT,
  "Address Line 5" REAL,
  "Postcode" TEXT,
  "Open Date" TIMESTAMP,
  "Close Date" TIMESTAMP,
  "Organisation Sub-Type Code" INTEGER,
  "Parent Organisation Code" TEXT,
  "Join Parent Date" TIMESTAMP,
  "Left Parent Date" TIMESTAMP,
  "Contact Telephone Number" TEXT,
  "Amended Record Indicator" INTEGER
)
Powered by Datasette · Query took 76.782ms · Data source: OUseful Databeat