home / nhsadmin

Private Controlled Drug Prescribers

Data source: OUseful Databeat

6,479 rows sorted by National Grouping

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
161 Q6101660 MURRAY C Y51 Q35 THE PRIORY HOSPITAL STUMP LANE CHELMSFORD ESSEX   CM1 7SJ 2006-04-01 00:00:00   1 Q79 2015-04-01 00:00:00   01245 244702 0
169 Q6101749 KAUBE H Y51 Q35 THE PRIORY HOSPITAL STUMP LANE CHELMSFORD ESSEX   CM1 7SJ 2006-04-01 00:00:00   1 Q79 2015-04-01 00:00:00   01245 244702 0
170 Q6101756 ABOU EL FADL S Y51 Q35 THE PRIORY HOSPITAL STUMP LANE CHELMSFORD ESSEX   CM1 7SJ 2006-04-01 00:00:00   1 Q79 2015-04-01 00:00:00   01245 244702 0
172 Q6101770 CHALONER J Y51 Q35 THE PRIORY HOSPITAL STUMP LANE CHELMSFORD ESSEX   CM1 7SJ 2006-04-01 00:00:00   1 Q79 2015-04-01 00:00:00   01245 244702 0
173 Q6101787 DURANI S Y51 Q35 THE PRIORY HOSPITAL STUMP LANE CHELMSFORD ESSEX   CM1 7SJ 2006-04-01 00:00:00   1 Q79 2015-04-01 00:00:00   01245 244702 0
174 Q6101794 FLECHTNER M Y51 Q35 THE PRIORY HOSPITAL STUMP LANE CHELMSFORD ESSEX   CM1 7SJ 2006-04-01 00:00:00   1 Q79 2015-04-01 00:00:00   01245 244702 0
175 Q6101804 GRAHAME P Y51 Q35 THE PRIORY HOSPITAL STUMP LANE CHELMSFORD ESSEX   CM1 7SJ 2006-04-01 00:00:00   1 Q79 2015-04-01 00:00:00   01245 244702 0
176 Q6101811 GUIRGUIS W Y51 Q35 THE PRIORY HOSPITAL STUMP LANE CHELMSFORD ESSEX   CM1 7SJ 2006-04-01 00:00:00   1 Q79 2015-04-01 00:00:00   01245 244702 0
177 Q6101828 KARKI C Y51 Q35 THE PRIORY HOSPITAL STUMP LANE CHELMSFORD ESSEX   CM1 7SJ 2006-04-01 00:00:00   1 Q79 2015-04-01 00:00:00   01245 244702 0
181 Q6101866 SARATHCHANDRA C Y51 Q35 THE PRIORY HOSPITAL STUMP LANE CHELMSFORD ESSEX   CM1 7SJ 2006-04-01 00:00:00   1 Q79 2015-04-01 00:00:00   01245 244702 0
184 Q6101897 UPADHYAYA AK Y51 Q35 THE PRIORY HOSPITAL STUMP LANE CHELMSFORD ESSEX   CM1 7SJ 2006-04-01 00:00:00   1 Q79 2015-04-01 00:00:00   01245 244702 0
185 Q6101907 YOUSIF E Y51 Q35 THE PRIORY HOSPITAL STUMP LANE CHELMSFORD ESSEX   CM1 7SJ 2006-04-01 00:00:00   1 Q79 2015-04-01 00:00:00   01245 244702 0
363 Q6103758 BHATTACHARJEE J Y51 Q32 CYGNET HOSPITAL 23 RIPON ROAD HARROGATE NORTH YORKSHIRE   HG1 2JL 2006-04-01 00:00:00   1 Q72 2015-04-01 00:00:00   01423 500599 0
379 Q6103916 HOLMAN C Y51 Q32 THE RETREAT HESLINGTON ROAD YORK     YO10 5BN 2006-04-01 00:00:00   1 Q72 2015-04-01 00:00:00   01904 412551 0
380 Q6103923 MITCHELL S Y51 Q32 THE RETREAT HESLINGTON ROAD YORK     YO10 5BN 2006-04-01 00:00:00   1 Q72 2015-04-01 00:00:00   01904 412551 0
381 Q6103930 SMITH G Y51 Q32 THE RETREAT HESLINGTON ROAD YORK     YO10 5BN 2006-04-01 00:00:00   1 Q72 2015-04-01 00:00:00   01904 412551 0
383 Q6103954 BLAKEBOROUGH A Y51 Q32 THE RETREAT HESLINGTON ROAD YORK     YO10 5BN 2006-04-01 00:00:00   1 Q72 2015-04-01 00:00:00   01904 412551 0
384 Q6103961 BLAKEBOROUGH J Y51 Q32 THE RETREAT HESLINGTON ROAD YORK     YO10 5BN 2006-04-01 00:00:00   1 Q72 2015-04-01 00:00:00   01904 412551 0
398 Q6104106 POOL RW Y51 Q33 HEALTHLINC HSE INDE HOSP CLIFF ROAD,WELTON LINCOLN     LN2 3JN 2006-04-01 00:00:00   1 Q78 2015-04-01 00:00:00   01673 862000 0
399 Q6104113 TRAVERS RF Y51 Q33 HEALTHLINC HSE INDE HOSP CLIFF ROAD,WELTON LINCOLN     LN2 3JN 2006-04-01 00:00:00   1 Q78 2015-04-01 00:00:00   01673 862000 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
629 Q6106500 ANDREWS D Y51 Q33 THE LINCOLN NUFFIELD HOSP NETTLEHAM ROAD LINCOLN     LN2 1QU 2006-04-01 00:00:00   1 Q78 2015-04-01 00:00:00   01522 578000 0
631 Q6106524 HUTTON I Y51 Q33 THE LINCOLN NUFFIELD HOSP NETTLEHAM ROAD LINCOLN     LN2 1QU 2006-04-01 00:00:00   1 Q78 2015-04-01 00:00:00   01522 578000 0
632 Q6106531 HYDE ID Y51 Q33 THE LINCOLN NUFFIELD HOSP NETTLEHAM ROAD LINCOLN     LN2 1QU 2006-04-01 00:00:00   1 Q78 2015-04-01 00:00:00   01522 578000 0
633 Q6106548 MORRIS EW Y51 Q33 THE LINCOLN NUFFIELD HOSP NETTLEHAM ROAD LINCOLN     LN2 1QU 2006-04-01 00:00:00   1 Q78 2015-04-01 00:00:00   01522 578000 0
634 Q6106555 WILKINSON JM Y51 Q33 THE LINCOLN NUFFIELD HOSP NETTLEHAM ROAD LINCOLN     LN2 1QU 2006-04-01 00:00:00   1 Q78 2015-04-01 00:00:00   01522 578000 0
719 Q6107422 SMITH RH Y51 Q32 FLAT 2 27 COLLEGIATE CRESCENT SHEFFIELD     S10 2BJ 2006-04-06 00:00:00   1 Q72 2015-04-01 00:00:00   0114 2686924 0
783 Q6108069 SYDENHAM DJ Y51 Q35 THE SURGERY HEXTON ROAD BARTON-LE-CLAY BEDS   MK45 4TA 2006-05-29 00:00:00   1 Q78 2015-04-01 00:00:00   01582 528701 0
828 Q6108526 FREEMAN CA Y51 Q35 HOUGHTON CLOSE SURGERY 1 HOUGHTON CLOSE AMPTHILL BEDS   MK45 2TG 2006-05-22 00:00:00   1 Q78 2015-04-01 00:00:00   01525 402641 0
911 Q6109376 SERAFI S Y51 Q34 CORNWALL HOUSE SANDY LANE NEWCASTLE UNDER LYME     ST5 0LZ 2006-05-22 00:00:00   1 Q76 2015-04-01 00:00:00   01782 338132 0
921 Q6109479 HOSKING G Y51 Q32 THORNBURY HOSPITAL 312 FULWOOD ROAD SHEFFIELD     S10 3BR 2006-05-19 00:00:00   1 Q72 2015-04-01 00:00:00   0114 2661133 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
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
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
1135 Q6111674 MATHEW K Y51 Q35 THE PRIORY HOSPITAL STUMP LANE CHELMSFORD ESSEX   CM1 7SJ 2006-06-26 00:00:00   1 Q79 2015-04-01 00:00:00   01245 244702 0
1238 Q6112716 RADIA M Y51 Q33 WOODVIEW MEDICAL CENTRE HOLMCROSS ROAD,THORPLANDS NORTHAMPTON     NN3 8AW 2006-07-01 00:00:00   1 Q78 2015-04-01 00:00:00   01604 670780 0
1240 Q6112730 KHONG TK Y51 Q33 PASLEY ROAD HEALTH CTR PASLEY ROAD LEICESTER     LE2 9BU 2006-07-01 00:00:00   1 Q78 2015-04-01 00:00:00   0116 2958430 0
1241 Q6112747 WHITE TJ Y51 Q33 14 CLARENCE AVENUE   NORTHAMPTON     NN2 6NZ 2006-07-01 00:00:00   1 Q78 2015-04-01 00:00:00   01604 716736 0
1243 Q6112761 FREEMAN RF Y51 Q33 THE CRESCENT MEDICAL CTR 2 THE CRESCENT NORTHAMPTON     NN1 4SB 2006-07-01 00:00:00   1 Q78 2015-04-01 00:00:00   01604 713434 0
1246 Q6112792 HOUSTON AJD Y51 Q33 1 VICARAGE ROAD YARDLEY GOBION TOWCESTER NORTHANTS   NN12 7UN 2006-07-01 00:00:00   1 Q78 2015-04-01 00:00:00   01908 542657 0
1249 Q6112826 WILLIAMS KR Y51 Q33 WILLOWBROOK HEALTH CENTRE COTTINGHAM ROAD CORBY     NN17 2UR 2006-07-07 00:00:00   1 Q78 2015-04-01 00:00:00   01536 204154 0
1250 Q6112833 PALMER DA Y51 Q33 THE MEDICAL CENTRE FOREST GATE ROAD CORBY     NN17 1TR 2006-07-07 00:00:00   1 Q78 2015-04-01 00:00:00   01536 202507 0
1314 Q6113504 BENGTSON K Y51 Q35 ST HELENA HPL,MYLAND HALL BARNCROFT CLOSE,HIGHWOODS COLCHESTER     CO4 4FS 2006-07-01 00:00:00   1 Q79 2015-04-01 00:00:00   01206 845566 0
1322 Q6113580 KROEBER T Y51 Q35 FARLEIGH HOSPICE NORTH COURT RD BROOMFIELD CHELMSFORD ESSEX   CM1 7FH 2006-07-07 00:00:00   1 Q79 2015-04-01 00:00:00   01245 457300 0
1323 Q6113597 OAKLEY K Y51 Q35 FARLEIGH HOSPICE NORTH COURT RD BROOMFIELD CHELMSFORD ESSEX   CM1 7FH 2006-07-07 00:00:00   1 Q79 2015-04-01 00:00:00   01245 457300 0
1324 Q6113607 SATHYAJITH B Y51 Q35 FARLEIGH HOSPICE NORTH COURT RD BROOMFIELD CHELMSFORD ESSEX   CM1 7FH 2006-07-07 00:00:00   1 Q79 2015-04-01 00:00:00   01245 457300 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
1363 Q6114024 HODGE RJ Y51 Q35 ABBEY ROAD SURGERY 63 ABBEY ROAD WALTHAM CROSS HERTFORDSHIRE   EN8 7LJ 2006-07-10 00:00:00   1 Q78 2015-04-01 00:00:00   0844 4771788 0
1364 Q6114031 NEVILLE WT Y51 Q35 ABBEY ROAD SURGERY 63 ABBEY ROAD WALTHAM CROSS HERTFORDSHIRE   EN8 7LJ 2006-07-10 00:00:00   1 Q78 2015-04-01 00:00:00   0844 4771788 0
1365 Q6114048 RAHMAN SMM Y51 Q35 ABBEY ROAD SURGERY 63 ABBEY ROAD WALTHAM CROSS HERTFORDSHIRE   EN8 7LJ 2006-07-10 00:00:00   1 Q78 2015-04-01 00:00:00   0844 4771788 0
1366 Q6114055 VASINIUC L Y51 Q35 ABBEY ROAD SURGERY 63 ABBEY ROAD WALTHAM CROSS HERTFORDSHIRE   EN8 7LJ 2006-07-10 00:00:00   1 Q78 2015-04-01 00:00:00   0844 4771788 0
1367 Q6114062 ALLY L Y51 Q35 ABBEY ROAD SURGERY 63 ABBEY ROAD WALTHAM CROSS HERTFORDSHIRE   EN8 7LJ 2006-07-10 00:00:00   1 Q78 2015-04-01 00:00:00   0844 4771788 0
1441 Q6114842 WALSH AC Y51 Q35 SHORTSTOWN SURGERY 2 QUANTRELLE COURT SHORTSTOWN BEDFORDSHIRE   MK42 0UF 2006-08-06 00:00:00   1 Q78 2015-04-01 00:00:00   01234 743000 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
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
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
2247 Q6123116 DAY MJI Y51 Q35 DOVERCOURT 50 TILSWORTH ROAD STANBRIDGE BEDS   LU7 9JA 2006-10-01 00:00:00   1 Q78 2015-04-01 00:00:00   01525 210657 0
2265 Q6123295 GULLICK DL Y51 Q35 1 HEATHBROW ROAD WELWYN HERTFORDSHIRE     AL6 0QG 2006-10-01 00:00:00   1 Q78 2015-04-01 00:00:00   01438 714016 0
2324 Q6123903 ABBATT R Y51 Q33 DENTON VILLAGE SURGERY ORCHARD LANE, DENTON NORTHAMPTON     NN7 1HT 2006-10-01 00:00:00   1 Q78 2015-04-01 00:00:00   01604 890313 0
2343 Q6124100 WALSH DA Y51 Q32 PRIORY MEDICAL GROUP CLEMENTHORPE HEALTH CTR CHERRY STREET, YORK     YO23 1AP 2006-10-01 00:00:00   1 Q72 2015-04-01 00:00:00   01904 646898 0
2344 Q6124117 FROST PR Y51 Q32 PRIORY MEDICAL GROUP FULFORD SURGERY 2 FULFORD PARK, YORK     YO10 4QE 2006-10-01 00:00:00   1 Q72 2015-04-01 00:00:00   01904 625566 0
2345 Q6124124 FISHER RH Y51 Q32 PRIORY MEDICAL GROUP PRIORY MEDICAL CENTRE CORNLANDS ROAD, ACOMB YORK   YO24 3WX 2006-10-01 00:00:00   1 Q72 2015-04-01 00:00:00   01904 781423 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
2375 Q6124430 RAUBITSCHEK EE Y51 Q32 WINDSET HIGH WOODSIDE CONONLEY, KEIGHLEY     BD20 8PE 2006-10-01 00:00:00   1 Q72 2015-04-01 00:00:00   07711 893986 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
2405 Q6124739 AHMED S Y51 Q34 SOMERSET SURGERY SOMERSET ROAD HANLEY, STOKE ON TRENT     ST1 2BH 2006-11-01 00:00:00   1 Q76 2015-04-01 00:00:00   01782 212192 0
2452 Q6125204 BUCHANAN JM Y51 Q32 PORTER BROOK MEDICAL CTR 9 SUNDERLAND STREET SHEFFIELD     S11 8HN 2006-11-03 00:00:00   1 Q72 2015-04-01 00:00:00   0845 1245567 0
2496 Q6125644 MACKIE AP Y51 Q32 PORTER BROOK MEDICAL CTR 9 SUNDERLAND STREET SHEFFIELD     S11 8HN 2006-11-03 00:00:00   1 Q72 2015-04-01 00:00:00   0845 1245567 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
2568 Q6126377 LITTLEMORE AJ Y51 Q35 GROVE LODGE SURGERY 72 QUEENSWAY HOLLAND ON SEA ESSEX   CO15 5JU 2006-12-01 00:00:00   1 Q79 2015-04-01 00:00:00   01255 815550 0
2578 Q6126470 TAYLOR NP Y51 Q32 DR MOSS & PARTNERS 23-30 KINGS ROAD HARROGATE NORTH YORKSHIRE   HG1 5JP 2006-12-01 00:00:00   1 Q72 2015-04-01 00:00:00   01423 560261 0
2627 Q6126968 MCARDLE J Y51 Q32 FONTELL HOUSE CLIFFORD WETHERBY     LS23 6JQ 2007-01-07 00:00:00   1 Q72 2015-04-01 00:00:00   01937 843405 0
2631 Q6127000 NEWCOMBE CP Y51 Q32 16 FAIRFAX COURT ACOMB ROAD YORK NORTH YORKSHIRE   YO24 4HS 2007-01-01 00:00:00   1 Q72 2015-04-01 00:00:00   01904 781296 0
2644 Q6127134 POSKITT VJ Y51 Q32 DR MOSS & PARTNERS 23-30 KINGS ROAD HARROGATE NORTH YORKSHIRE   HG1 5JP 2006-12-01 00:00:00   1 Q72 2015-04-01 00:00:00   01423 560261 0
2647 Q6127165 RIYADH MA Y51 Q35 LITTLE GABLES PETERBOROUGH DISTRICT HPL THORPE ROAD PETERBOROUGH   PE3 6DA 2007-02-01 00:00:00   1 Q79 2015-04-01 00:00:00   01733 318171 0
2687 Q6127567 GIBSON JA Y51 Q31 LONGFORD STREET GROUP PRACTICE LONGFORD STREET HEYWOOD   OL10 4NH 2007-02-01 00:00:00   1 Q73 2015-04-01 00:00:00   01706 621417 0
2700 Q6127691 WALDRUM CI Y51 Q33 2 THE CRESCENT KINGSLEY NORTHAMPTON     NN1 4SB 2007-02-01 00:00:00   1 Q78 2015-04-01 00:00:00   01604 701434 0
2704 Q6127732 SHEORAN R Y51 Q32 CYGNET HOSPITAL BIERLEY BIERLEY LANE BIERLEY BRADFORD   BD4 6AD 2007-02-01 00:00:00   1 Q72 2015-04-01 00:00:00   01274 686767 0
2808 Q6128771 KELVIN MG Y51 Q35 MOUNT FARM SURGERY LAWSON PLACE BURY ST EDMUNDS SUFFOLK   IP32 7EW 2007-03-01 00:00:00   1 Q79 2015-04-01 00:00:00   01284 716112 0
2816 Q6128850 NUAMAH F Y51 Q35 THE PRIORY HOSPITAL STUMP LANE CHELMSFORD ESSEX   CM1 7SJ 2007-03-26 00:00:00   1 Q79 2015-04-01 00:00:00   01245 244702 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 50.062ms · Data source: OUseful Databeat