home / nhsadmin

Private Controlled Drug Prescribers

Data source: OUseful Databeat

6,479 rows sorted by Address Line 2

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
3 Q6100023 BARNARD M Y56 Q71 82A SYDNEY ROAD   LONDON     W13 9EY 2006-04-01 00:00:00   1 Q71 2013-03-20 00:00:00   079 63827461 0
5 Q6100061 SITHOLE K Y56 Q71 5 CRYSTAL WAY   CHADWELL HEATH ESSEX   RM9 1UE 2006-04-01 00:00:00   1 Q71 2013-03-20 00:00:00 2015-04-20 00:00:00 020 85989279 0
6 Q6100078 NAQVI AT Y56 Q71 183 DUDDENHILL LANE     LONDON   NW10 1AU 2006-04-01 00:00:00   1 Q71 2013-04-01 00:00:00   01992 624732 0
20 Q6100250 SCURR MJ Y56 Q71 21 LOWER SLOANE STREET     LONDON   SW1 8BJ 2006-04-01 00:00:00   1 Q71 2013-03-20 00:00:00   020 89620635 0
29 Q6100346 GAYNER JR Y56 Q71 6 SLOANE SQUARE     LONDON   SW1W 8EE 2006-04-01 00:00:00   1 Q71 2013-03-20 00:00:00   020 77303700 0
33 Q6100384 MANSFIELD PJ Y55 Q76 21 BREWERS WHARF   NEWARK ON TRENT NOTTINGHAMSHIRE   NG24 1ET 2006-04-01 00:00:00   1 Q76 2015-04-01 00:00:00 2016-05-31 00:00:00 01636 704071 0
37 Q6100425 UGBOMA KJ Y56 Q71 27 WIMPOLE STREET     LONDON   W1G 8GN 2006-04-01 00:00:00   1 Q71 2013-04-01 00:00:00   020 72244419 0
38 Q6100432 GILL A Y56 Q71 113-115 HARLEY STREET     LONDON   W1G 6AP 2006-04-01 00:00:00   1 Q71 2013-03-20 00:00:00   020 74875050 0
39 Q6100449 KRAFT T Y56 Q71 80 HARLEY STREET     LONDON   W1G 7HL 2006-04-01 00:00:00   1 Q71 2013-04-01 00:00:00   020 75802692 0
40 Q6100456 SAWYER CN Y56 Q71 48 WIMPOLE STREET     LONDON   W1G 8SF 2006-04-01 00:00:00   1 Q71 2013-03-20 00:00:00   020 79354357 0
41 Q6100463 KHALIQUE S Y56 Q71 48 WIMPOLE STREET     LONDON   W1G 8SF 2006-04-01 00:00:00   1 Q71 2013-03-20 00:00:00   020 79354357 0
42 Q6100470 ABOKARSH K Y56 Q71 16 WIMPOLE STREET     LONDON   W1G 9SZ 2006-04-01 00:00:00   1 Q71 2013-04-01 00:00:00   020 72916666 0
43 Q6100487 BLUM C Y56 Q71 16 WIMPOLE STREET     LONDON   W1G 9SZ 2006-04-01 00:00:00   1 Q71 2013-04-01 00:00:00   020 72916666 0
44 Q6100494 CHANDRA J Y56 Q71 16 WIMPOLE STREET     LONDON   W1G 9SZ 2006-04-01 00:00:00   1 Q71 2013-04-01 00:00:00   020 72916666 0
45 Q6100504 DAVENPORT-JONES C Y56 Q71 16 WIMPOLE STREET     LONDON   W1G 9SZ 2006-04-01 00:00:00   1 Q71 2013-04-01 00:00:00   020 72916666 0
46 Q6100511 DI-FAZIO L Y56 Q71 16 WIMPOLE STREET     LONDON   W1G 9SZ 2006-04-01 00:00:00   1 Q71 2013-04-01 00:00:00   020 72916666 0
47 Q6100528 ECCLES ND Y56 Q71 16 WIMPOLE STREET     LONDON   W1G 9SZ 2006-04-01 00:00:00   1 Q71 2013-04-01 00:00:00   020 72916666 0
48 Q6100535 GARSIN MJ Y56 Q71 16 WIMPOLE STREET     LONDON   W1G 9SZ 2006-04-01 00:00:00   1 Q71 2013-04-01 00:00:00   020 72916666 0
49 Q6100542 GILES A Y56 Q71 16 WIMPOLE STREET     LONDON   W1G 9SZ 2006-04-01 00:00:00   1 Q71 2013-04-01 00:00:00   020 72916666 0
51 Q6100566 GINSBERG A Y56 Q71 16 WIMPOLE STREET     LONDON   W1G 9SZ 2006-04-01 00:00:00   1 Q71 2013-04-01 00:00:00   020 72916666 0
52 Q6100573 HAMAD W Y56 Q71 16 WIMPOLE STREET     LONDON   W1G 9SZ 2006-04-01 00:00:00   1 Q71 2013-04-01 00:00:00   020 72916666 0
54 Q6100597 HART R Y56 Q71 16 WIMPOLE STREET     LONDON   W1G 9SZ 2006-04-01 00:00:00   1 Q71 2013-04-01 00:00:00   020 72916666 0
57 Q6100621 HARRIOTT J Y56 Q71 16 WIMPOLE STREET     LONDON   W1G 9SZ 2006-04-01 00:00:00   1 Q71 2013-04-01 00:00:00   020 72916666 0
59 Q6100645 HEATON J Y56 Q71 16 WIMPOLE STREET     LONDON   W1G 9SZ 2006-04-01 00:00:00   1 Q71 2013-04-01 00:00:00   020 72916666 0
60 Q6100652 HELMY S Y56 Q71 16 WIMPOLE STREET     LONDON   W1G 9SZ 2006-04-01 00:00:00   1 Q71 2013-04-01 00:00:00   020 72916666 0
61 Q6100669 HOLMES S Y56 Q71 16 WIMPOLE STREET     LONDON   W1G 9SZ 2006-04-01 00:00:00   1 Q71 2013-03-20 00:00:00 2015-04-20 00:00:00 020 72916666 0
63 Q6100683 LAVERGNE R Y56 Q71 16 WIMPOLE STREET     LONDON   W1G 9SZ 2006-04-01 00:00:00   1 Q71 2013-04-01 00:00:00   020 72916666 0
64 Q6100690 LECHELT MJ Y56 Q71 16 WIMPOLE STREET     LONDON   W1G 9SZ 2006-04-01 00:00:00   1 Q71 2013-04-01 00:00:00   020 72916666 0
67 Q6100724 LINDSTEDT MJ Y56 Q71 16 WIMPOLE STREET     LONDON   W1G 9SZ 2006-04-01 00:00:00   1 Q71 2013-04-01 00:00:00   020 72916666 0
68 Q6100731 MALLETT PJ Y56 Q71 16 WIMPOLE STREET     LONDON   W1G 9SZ 2006-04-01 00:00:00   1 Q71 2013-04-01 00:00:00   020 72916666 0
69 Q6100748 MARKS C Y56 Q71 16 WIMPOLE STREET     LONDON   W1G 9SZ 2006-04-01 00:00:00   1 Q71 2013-04-01 00:00:00   020 72916666 0
70 Q6100755 MASON G Y56 Q71 16 WIMPOLE STREET     LONDON   W1G 9SZ 2006-04-01 00:00:00   1 Q71 2013-04-01 00:00:00   020 72916666 0
71 Q6100762 MILOJEVIC ND Y56 Q71 16 WIMPOLE STREET     LONDON   W1G 9SZ 2006-04-01 00:00:00   1 Q71 2013-04-01 00:00:00   020 72916666 0
72 Q6100779 MUHAMMAD H Y56 Q71 16 WIMPOLE STREET     LONDON   W1G 9SZ 2006-04-01 00:00:00   1 Q71 2013-04-01 00:00:00   020 72916666 0
73 Q6100786 REDDY A Y56 Q71 16 WIMPOLE STREET     LONDON   W1G 9SZ 2006-04-01 00:00:00   1 Q71 2013-04-01 00:00:00   020 72916666 0
74 Q6100793 RUF MJ Y56 Q71 16 WIMPOLE STREET     LONDON   W1G 9SZ 2006-04-01 00:00:00   1 Q71 2013-04-01 00:00:00   020 72916666 0
75 Q6100803 RUSTIN J Y56 Q71 16 WIMPOLE STREET     LONDON   W1G 9SZ 2006-04-01 00:00:00   1 Q71 2013-03-20 00:00:00 2015-04-20 00:00:00 020 72916666 0
76 Q6100810 SAMSON G Y56 Q71 16 WIMPOLE STREET     LONDON   W1G 9SZ 2006-04-01 00:00:00   1 Q71 2013-04-01 00:00:00   020 72916666 0
77 Q6100827 SEN MJ Y56 Q71 16 WIMPOLE STREET     LONDON   W1G 9SZ 2006-04-01 00:00:00   1 Q71 2013-04-01 00:00:00   020 72916666 0
79 Q6100841 THEXTON PJ Y56 Q71 16 WIMPOLE STREET     LONDON   W1G 9SZ 2006-04-01 00:00:00   1 Q71 2013-04-01 00:00:00   020 72916666 0
80 Q6100858 TOBIAS T Y56 Q71 16 WIMPOLE STREET     LONDON   W1G 9SZ 2006-04-01 00:00:00   1 Q71 2013-04-01 00:00:00   020 72916666 0
81 Q6100865 TOBIAS E Y56 Q71 16 WIMPOLE STREET     LONDON   W1G 9SZ 2006-04-01 00:00:00   1 Q71 2013-04-01 00:00:00   020 72916666 0
83 Q6100889 WAHBA A Y56 Q71 16 WIMPOLE STREET     LONDON   W1G 9SZ 2006-04-01 00:00:00   1 Q71 2013-04-01 00:00:00   020 72916666 0
84 Q6100896 WHITTON T Y56 Q71 16 WIMPOLE STREET     LONDON   W1G 9SZ 2006-04-01 00:00:00   1 Q71 2013-04-01 00:00:00   020 72916666 0
92 Q6100975 YOUNIS F Y56 Q71 129 HARLEY STREET     LONDON   W1G 6BA 2006-04-01 00:00:00   1 Q71 2013-03-20 00:00:00 2015-04-20 00:00:00 020 74874897 0
187 Q6101921 AGYARE K Y56 Q71 14 BELL CLOSE   PINNER MIDDLESEX   HA5 2AQ 2006-04-01 00:00:00   1 Q71 2013-03-20 00:00:00 2015-04-20 00:00:00 07884 432611 0
188 Q6101938 ASHBY P Y56 Q71 51 HARLEY STREET     LONDON   W1G 8QQ 2006-04-01 00:00:00   1 Q71 2013-04-01 00:00:00   07659 800800 0
190 Q6101952 AHMAD K Y56 Q71 28 VIEWFIELD ROAD     LONDON   SW18 5JE 2006-04-01 00:00:00   1 Q71 2013-03-20 00:00:00 2015-04-20 00:00:00 07890 260350 0
192 Q6101976 ALEXANDRIDIS I Y56 Q71 111 HARLEY STREET     LONDON   W1G 6AW 2006-04-01 00:00:00   1 Q71 2013-03-20 00:00:00   020 74868055 0
195 Q6102001 BABBEL B Y56 Q71 59 STATION ROAD   HOUNSLOW     TW3 2AE 2006-04-01 00:00:00   1 Q71 2013-03-20 00:00:00 2015-04-20 00:00:00 07971 555253 0
196 Q6102018 BLEEHEN S Y56 Q71 152 HARLEY STREET     LONDON   W1G 7LH 2006-04-01 00:00:00   1 Q71 2013-04-01 00:00:00   07778 183073 0
197 Q6102025 BREARLEY S Y56 Q71 WHIPPS CROSS HOSPITAL     LONDON   E11 1NR 2006-04-01 00:00:00   1 Q71 2013-03-20 00:00:00   07770 981609 0
198 Q6102032 BRANLEY H Y56 Q71 14 FASSE WAY   EALING LONDON   W13 0BZ 2006-04-01 00:00:00   1 Q71 2013-03-20 00:00:00 2015-04-20 00:00:00 07976 239704 0
199 Q6102049 BROOKES J Y56 Q71 37 SWAINS LANE     LONDON   N6 6QL 2006-04-01 00:00:00   1 Q71 2013-03-20 00:00:00   07802 713366 0
201 Q6102063 BACARESE-HAMILTON I Y56 Q71 8 BEECH DRIVE   EAST FINCHLEY LONDON   N2 9NY 2006-04-01 00:00:00   1 Q71 2013-03-20 00:00:00   07702 311383 0
203 Q6102087 BROADFIELD J Y56 Q71 22 HAYNE ROAD   BECKINGHAM KENT   BR3 4JA 2006-04-01 00:00:00   1 Q71 2013-03-20 00:00:00 2015-04-20 00:00:00 07802 708517 0
204 Q6102094 CAJANO P Y56 Q71 21 MURIESTON WOOD   LIVINGSTON     EH54 9EE 2006-04-01 00:00:00   1 Q71 2013-03-20 00:00:00 2015-04-20 00:00:00 01506 417722 0
205 Q6102104 CASON A Y57 Q81 25 EMBERTCOURT ROAD   THAMES DITTON SURREY   KT7 0LH 2006-04-01 00:00:00   1 Q81 2015-04-01 00:00:00   07905 955813 0
206 Q6102111 CHANDRA M Y56 Q71 92 COLIN GARDENS   THE HYDE LONDON   NW9 6ER 2006-04-01 00:00:00   1 Q71 2013-03-20 00:00:00 2015-04-20 00:00:00 07879 428463 0
207 Q6102128 MAYOU BJ Y56 Q71 1A DUKE OF YORK SQUARE   LONDON     SW3 4LY 2006-04-01 00:00:00   1 Q71 2013-03-20 00:00:00 2015-04-20 00:00:00 020 78245555 0
209 Q6102142 CHAKRABARTI P Y56 Q71 15 COURTLANDS CLOSE   RUISLIP MIDDLESEX   HA4 8AX 2006-04-01 00:00:00   1 Q71 2013-03-20 00:00:00 2015-04-20 00:00:00 07860 796242 0
211 Q6102166 CHANTARASAK D Y56 Q71 13 BIRCH PARK   HARROW MIDDLESEX   HA3 6SP 2006-04-01 00:00:00   1 Q71 2013-03-20 00:00:00 2015-04-20 00:00:00 07768 428171 0
213 Q6102180 CHARLAMBIDES C Y57 Q81 17 CHADWICK PLACE   SURBITON SURREY   KT6 5RE 2006-04-01 00:00:00   1 Q81 2015-04-01 00:00:00   07764 683266 0
214 Q6102197 CHAYYA C Y56 Q71 4 OXFORD AVENUE   SOUTHGATE LONDON   N14 5AF 2006-04-01 00:00:00   1 Q71 2013-03-20 00:00:00 2015-04-20 00:00:00 07798 925085 0
241 Q6102465 CHAN C Y56 Q71 5 MONTHOLME ROAD     LONDON   SW11 6HX 2006-04-01 00:00:00   1 Q71 2013-03-20 00:00:00 2015-04-20 00:00:00 07771 861983 0
242 Q6102472 CHITRA G Y55 Q79 1 GLENSIDE   CHIGWELL ESSEX   IG7 5RE 2006-04-01 00:00:00   1 Q79 2015-04-01 00:00:00   07944 273396 0
243 Q6102489 COHEN A Y55 Q78 33 TURPINS RIDE   WELWYN HERTFORDSHIRE   AL6 0QU 2006-04-01 00:00:00   1 Q78 2015-04-01 00:00:00   07930 600730 0
251 Q6102568 EVANS P Y56 Q71 15 STOTT CLOSE   WANDSWORTH LONDON   SW18 2TG 2006-04-01 00:00:00   1 Q71 2013-03-20 00:00:00   020 88467016 0
252 Q6102575 FITZWILLIAMS B Y56 Q71 46 PENTON PLACE   KENNINGTON LONDON   SE17 3JT 2006-04-01 00:00:00   1 Q71 2013-03-20 00:00:00 2015-04-20 00:00:00 07976 951888 0
253 Q6102582 FARID N Y56 Q71 115 WALTON AVENUE   SOUTH HARROW MIDDLESEX   HA2 8RA 2006-04-01 00:00:00   1 Q71 2013-03-20 00:00:00 2015-04-20 00:00:00 07808 402744 0
258 Q6102630 GRANT D Y56 Q71 4 LINDEN LEA     LONDON   N2 0RG 2006-04-01 00:00:00   1 Q71 2013-03-20 00:00:00   07796 017606 0
260 Q6102661 HADI N Y57 Q81 2 BRIDLEWAY CLOSE   EWELL SURREY   KT17 3DY 2006-04-01 00:00:00   1 Q81 2015-04-01 00:00:00   07931 734530 0
261 Q6102678 HASSANAIEN M Y56 Q71 25 ST DUNSTANS AVENUE   ACTON LONDON   W3 6QD 2006-04-01 00:00:00   1 Q71 2013-03-20 00:00:00   07976 401291 0
263 Q6102702 HAZARIKA E Y57 Q80 12 GROVE HILL   TOPSHAM DEVON   EX3 0EG 2006-04-01 00:00:00   1 Q80 2015-04-01 00:00:00   0779 0197762 0
265 Q6102726 HUSAIN A Y57 Q81 5 TYPHOON ROAD   WEST MALLING KENT   ME19 4TJ 2006-04-01 00:00:00   1 Q81 2015-04-01 00:00:00   07900 600827 0
267 Q6102740 HIGGS B Y55 Q78 73 WOODLAND DRIVE   WATFORD HERTFORDSHIRE   WD17 3BY 2006-04-01 00:00:00   1 Q78 2015-04-01 00:00:00   0771 1037148 0
268 Q6102757 HASHEMI M Y56 Q71 17 HIGHCROFT GARDENS     LONDON   NW11 0LY 2006-04-01 00:00:00   1 Q71 2013-03-20 00:00:00 2015-04-20 00:00:00 0793 0377980 0
274 Q6102812 JESUTHASAN M Y56 Q71 1B BRACKENDALE     LONDON   N21 3DH 2006-04-01 00:00:00   1 Q71 2013-03-20 00:00:00   07748 837596 0
275 Q6102829 JASANI M Y56 Q71 46 STAINFORTH ROAD   NEWBURN PARK ESSEX   IG2 7EH 2006-04-01 00:00:00   1 Q71 2013-03-20 00:00:00 2015-04-20 00:00:00 020 85903838 0
277 Q6102843 JAWAD M Y56 Q71 83 SYDENHAM HILL     LONDON   SE26 6TQ 2006-04-01 00:00:00   1 Q71 2013-03-20 00:00:00 2015-04-20 00:00:00 07971 833459 0
279 Q6102867 KAZZAZI N Y54 Q72 9 WINTERSATT DRIVE   DONCASTER     DN4 5PT 2006-04-01 00:00:00   1 Q72 2015-04-01 00:00:00   07711 941743 0
281 Q6102881 KAVOUNI A Y56 Q71 129 HARLEY STREET     LONDON   W1G 6BG 2006-04-01 00:00:00   1 Q71 2013-04-01 00:00:00   020 74869040 0
286 Q6102939 KRISS S Y56 Q71 72 DARNOUTH ROAD     LONDON   NW2 4HA 2006-04-01 00:00:00   1 Q71 2013-04-01 00:00:00   07976 619536 0
290 Q6102977 LIGGINS S Y55 Q77 21 MORECROFT DRIVE   WARWICK     CV34 6NU 2006-04-01 00:00:00   1 Q77 2015-04-01 00:00:00   07837 101087 0
292 Q6102991 LOZEWICZ S Y56 Q71 2B OAKHILL AVENUE   HAMPSTEAD LONDON   NW3 7RE 2006-04-01 00:00:00   1 Q71 2013-03-20 00:00:00 2015-04-20 00:00:00 07930 886822 0
294 Q6103019 LAVY J Y56 Q71 97 MUSWELL HILL ROAD     LONDON   N10 3HT 2006-04-01 00:00:00   1 Q71 2013-03-20 00:00:00 2015-04-20 00:00:00 07803 580889 0
295 Q6103026 LEADER GL Y56 Q71 3 HILLCOURT AVENUE     LONDON   N12 8EY 2006-04-01 00:00:00   1 Q71 2013-03-20 00:00:00   0777 5566284 0
297 Q6103040 MOUSTAFA A Y56 Q71 68 DERWENT ROAD     LONDON   N13 4PX 2006-04-01 00:00:00   1 Q71 2013-03-20 00:00:00 2015-04-20 00:00:00 07778 518177 0
300 Q6103071 MASCARENHAS L Y56 Q71 73 BEAUVAL ROAD   DULWICH LONDON   SE22 8UH 2006-04-01 00:00:00   1 Q71 2013-03-20 00:00:00   07762 575361 0
301 Q6103088 MARCHANT W Y56 Q71 72 ADDISON WAY   HAMPSTEAD GARDEN SUBURB LONDON   NW11 6QS 2006-04-01 00:00:00   1 Q71 2013-03-20 00:00:00 2015-04-20 00:00:00 07949 247454 0
302 Q6103095 MAHABEER N Y56 Q71 2 STABLE CLOSE   KINGSTON UPON THAMES SURREY   KT2 5PJ 2006-04-01 00:00:00   1 Q71 2013-03-20 00:00:00 2015-04-20 00:00:00 07766 483968 0
303 Q6103105 MORRIS N Y56 Q71 15 DOLLIS PARK     LONDON   N3 1HJ 2006-04-01 00:00:00   1 Q71 2013-03-20 00:00:00 2015-04-20 00:00:00 07831 589325 0
305 Q6103129 MATHUR P Y56 Q71 5 OSIER CRESCENT     LONDON   N10 1QQ 2006-04-01 00:00:00   1 Q71 2013-03-20 00:00:00 2015-04-20 00:00:00 07769 831854 0
306 Q6103143 MELEAGROS L Y56 Q71 24 LANDRA GARDENS     LONDON   N21 1RT 2006-04-01 00:00:00   1 Q71 2013-03-20 00:00:00   07798 836713 0
307 Q6103150 MOUNIR A Y56 Q71 10 HELDMAN CLOSE   HOUNSLOW     TW3 2PA 2006-04-01 00:00:00   1 Q71 2013-04-01 00:00:00   07739 159191 0
308 Q6103167 MURRAY D Y56 Q71 8 THE CAUSEWAY   EAST FINCHLEY LONDON   N2 0PR 2006-04-01 00:00:00   1 Q71 2013-03-20 00:00:00 2015-04-20 00:00:00 07866 451480 0
311 Q6103198 OLAITAN A Y56 Q71 81 HARLEY STREET     LONDON   W1A 3PP 2006-04-01 00:00:00   1 Q71 2013-04-01 00:00:00   07957 230482 0
314 Q6103222 PATEL K Y56 Q71 8 VICTORIA AVENUE   FINCHLEY LONDON   N3 1BD 2006-04-01 00:00:00   1 Q71 2013-03-20 00:00:00   07770 916776 0
316 Q6103246 PARIKH A Y56 Q71 99 HARLEY STREET     LONDON   W1G 6AQ 2006-04-01 00:00:00   1 Q71 2013-04-01 00:00:00   07957 570019 0
320 Q6103284 REES J Y56 Q71 41 ALLINGTON ROAD   HENDON LONDON   NW4 3EA 2006-04-01 00:00:00   1 Q71 2013-03-20 00:00:00   020 78373611 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 158.319ms · Data source: OUseful Databeat