home / nhsadmin

Private Controlled Drug Prescribers

Data source: OUseful Databeat

6,479 rows sorted by High Level Health Geography

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
3262 Q6133388 THOMPSON JJ Y51 Q30 THE BELLINGHAM PRACTICE BELLINGHAM HEXHAM     NE48 2HE 2007-12-11 00:00:00   1 Q74 2015-04-01 00:00:00   01434 202203 0
3266 Q6133443 ALLEN JS Y51 Q30 MARINE MEDICAL GROUP THE HEALTH CENTRE THOROTON STREET BLYTH   NE24 1DX 2007-12-12 00:00:00   1 Q74 2015-04-01 00:00:00   01670 396520 0
3270 Q6133481 WESTGARTH D Y51 Q30 STATION MEDICAL GROUP GATACRE STREET BLYTH     NE24 1HD 2007-12-13 00:00:00   1 Q74 2015-04-01 00:00:00   01670 396540 0
4000 Q6140973 STAFFORD KP Y51 Q30 HOUGHTON MEDICAL GROUP THE HEALTH CTR,CHURCH ST HOUGHTON-LE-SPRING TYNE & WEAR   DH4 4DN 2009-07-14 00:00:00   1 Q74 2015-04-01 00:00:00   0191 5842154 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
3374 Q6134561 ROWLAND BJ Y51 Q31 TTP COUNSELLING CENTRE HOLLY HOUSE, SANKEY ST. WARRINGTON     WA1 1SL 2008-03-03 00:00:00   1 Q75 2015-04-01 00:00:00   01925 405040 0
3492 Q6135799 WINDGASSEN E Y51 Q31 KEMPLE VIEW PSYCHIAT SERV LONGSIGHT ROAD LANGHO, BLACKBURN     BB6 8AD 2008-04-01 00:00:00   1 Q73 2015-04-01 00:00:00   01254 243000 0
3495 Q6135830 LIM P Y51 Q31 KEMPLE VIEW LONGSIGHT ROAD LANGHO, BLACKBURN     BB6 8AD 2008-04-01 00:00:00   1 Q73 2015-04-01 00:00:00   01254 243000 0
3876 Q6139700 FOULKES AG Y51 Q31 31 ST HELENS ROAD   ORMSKIRK LANCASHIRE   L39 4QW 2009-04-02 00:00:00   1 Q73 2015-04-01 00:00:00   07967 838590 0
3885 Q6139793 GREENE MK Y51 Q31 C/O EMERGENCY DEPT., WEST CUMBERLAND HOSPITAL WHITEHAVEN     CA28 8DG 2009-04-02 00:00:00   1 Q73 2015-04-01 00:00:00   01946 693181 0
4079 Q6141802 HMP LANCASTER CASTLE Y51 Q31 THE CASTLE LANCASTER       LA1 1YL 2009-10-01 00:00:00   1 Q73 2015-04-01 00:00:00   01524 565066 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
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
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
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
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
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
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
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
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
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
2833 Q6129026 HARFORD-CROSS M Y51 Q32 ASHFIELD HOUSE KIRBY MALZEARD RIPON     HG4 3SE 2007-05-01 00:00:00   1 Q72 2015-04-01 00:00:00   01765 658298 0
2834 Q6129033 HIGSON RH Y51 Q32 THE SURGERY MARKET PLACE MASHAM, RIPON     HG4 4DZ 2007-05-01 00:00:00   1 Q72 2015-04-01 00:00:00   01765 689317 0
2835 Q6129040 HARFORD-CROSS ES Y51 Q32 THE SURGERY MARKET PLACE MASHAM, RIPON     HG4 4DZ 2007-05-01 00:00:00   1 Q72 2015-04-01 00:00:00   01765 689317 0
2940 Q6130093 OGUNBA A Y51 Q32 PARK HEALTH CENTRE HOLDERNESS ROAD HULL     HU9 3JA 2007-05-29 00:00:00   1 Q72 2015-04-01 00:00:00   01482 711112 0
3036 Q6131063 COURTIS TA Y51 Q32 YORK GARRISON MEDICAL CTR IMPHAL BARRACKS YORK     YO10 4HD 2007-07-11 00:00:00   1 Q72 2015-04-01 00:00:00   01904 662676 0
3037 Q6131070 NICOLL D Y51 Q32 YORK GARRISON MEDICAL CTR IMPHAL BARRACKS YORK     YO10 4HD 2007-07-11 00:00:00   1 Q72 2015-04-01 00:00:00   01904 662676 0
3042 Q6131128 SLOAN ME Y51 Q32 251 CHESTERFIELD ROAD   SHEFFIELD     S8 0RT 2007-07-12 00:00:00   1 Q72 2015-04-01 00:00:00   0845 1272001 0
3043 Q6131135 SHIRT DJW Y51 Q32 251 CHESTERFIELD ROAD   SHEFFIELD     S8 0RT 2007-07-12 00:00:00   1 Q72 2015-04-01 00:00:00   0845 1272001 0
3044 Q6131142 GREENSTREET D Y51 Q32 251 CHESTERFIELD ROAD   SHEFFIELD     S8 0RT 2007-07-12 00:00:00   1 Q72 2015-04-01 00:00:00   0845 1272001 0
3049 Q6131197 ALLEN JP Y51 Q32 DYNELEY HOUSE SURGERY NEWMARKET STREET SKIPTON NORTH YORKSHIRE   BD23 2HZ 2007-07-16 00:00:00   1 Q72 2015-04-01 00:00:00   01756 799311 0
3050 Q6131207 BUNDOCK AD Y51 Q32 DYNELEY HOUSE SURGERY NEWMARKET STREET SKIPTON NORTH YORKSHIRE   BD23 2HZ 2007-07-16 00:00:00   1 Q72 2015-04-01 00:00:00   01756 799311 0
3052 Q6131221 PRING R Y51 Q32 DYNELEY HOUSE SURGERY NEWMARKET STREET SKIPTON NORTH YORKSHIRE   BD23 2HZ 2007-07-16 00:00:00   1 Q72 2015-04-01 00:00:00   01756 799311 0
3054 Q6131245 WOODHOUSE BA Y51 Q32 DYNELEY HOUSE SURGERY NEWMARKET STREET SKIPTON NORTH YORKSHIRE   BD23 2HZ 2007-07-16 00:00:00   1 Q72 2015-04-01 00:00:00   01756 799311 0
3082 Q6131544 WALTERS PL Y51 Q32 MEDICAL CENTRE DISHFORTH AIRFIELD TOPCLIFFE, THIRSK NORTH YORKSHIRE   YO7 3EZ 2007-08-08 00:00:00   1 Q72 2015-04-01 00:00:00   01423 320601 0
3144 Q6132174 TAYLOR SC Y51 Q32 GARRISON MEDICAL CENTRE DUCHESS OF KENT HOSPITAL HORNE RD, CATTERICK GARRISON, NORTH YORKSHIRE   DL9 4DF 2007-09-28 00:00:00   1 Q72 2015-04-01 00:00:00   01748 873138 0
3410 Q6134925 ROPER DJ Y51 Q32 SPRINGHEAD MEDICAL CENTRE 376 WILLERBY ROAD HULL     HU5 5JT 2008-04-02 00:00:00   1 Q72 2015-04-01 00:00:00   01482 352263 0
3435 Q6135177 HAWKSLEY OJ Y51 Q32 MEDICAL CENTRE ALLENBROOK BARRACKS TOPCLIFFE, THIRSK NORTH YORKSHIRE   YO7 3SF 2008-04-21 00:00:00   1 Q72 2015-04-01 00:00:00   01845 595293 0
3464 Q6135490 BROOK O Y51 Q32 KINGSWOOD SURGERY 14 WETHERBY ROAD HARROGATE     HG2 7ST 2008-05-15 00:00:00   1 Q72 2015-04-01 00:00:00   01423 887733 0
3508 Q6135964 GLOVER RE Y51 Q32 KINGSWOOD SURGERY 14 WETHERBY ROAD HARROGATE NORTH YORKSHIRE   HG2 7SA 2008-06-15 00:00:00   1 Q72 2015-04-01 00:00:00   01423 887733 0
3509 Q6135971 STANWORTH AW Y51 Q32 KINGSWOOD SURGERY 14 WETHERBY ROAD HARROGATE NORTH YORKSHIRE   HG2 7SA 2008-06-15 00:00:00   1 Q72 2015-04-01 00:00:00   01423 887733 0
3510 Q6135988 SCOTT CL Y51 Q32 KINGSWOOD SURGERY 14 WETHERBY ROAD HARROGATE NORTH YORKSHIRE   HG2 7SA 2008-06-15 00:00:00   1 Q72 2015-04-01 00:00:00   01423 887733 0
3841 Q6139353 MARSHALL PR Y51 Q32 MEDICAL CENTRE RAF MENWITH HILL HARROGATE NORTH YORKSHIRE   HG3 2RF 2009-03-02 00:00:00   1 Q72 2015-04-01 00:00:00   01423 777885 0
4245 Q6143529 HUGHES TRJ Y51 Q32 THE KIRKBYMOORSIDE SURG TINLEY GARTH KIRKBYMOORSIDE NORTH YORKSHIRE   YO62 6AR 2010-04-01 00:00:00   1 Q72 2015-04-01 00:00:00   01751 431254 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
4343 Q6144609 INGRAM AJ Y51 Q32 CLARO BARRACKS   RIPON NORTH YORKSHIRE   HG4 2RD 2010-07-01 00:00:00   1 Q72 2015-04-01 00:00:00   01765 632281 0
4543 Q6146649 MILLS EJ Y51 Q32 YORK HOUSE 107 HESTLINGTON ROAD YORK     YO10 5BN 2011-02-14 00:00:00   1 Q72 2015-04-01 00:00:00   01904 412666 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
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
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

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 73.605ms · Data source: OUseful Databeat