home / nhsadmin

Private Controlled Drug Prescribers

Data source: OUseful Databeat

6,479 rows sorted by Join Parent Date

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
2 Q6100016 VAN NIEROP A Y56 Q71 APARTMENT 35 5 FERRY LANE BRENTFORD     TW8 0AT 2006-04-01 00:00:00   1 Q71 2013-03-20 00:00:00   078 10873506 0
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
4 Q6100054 CARINUS J Y56 Q71 13 WESTERN BEACH 36 HANOVER AVENUE SILVERTOWN LONDON   E16 1DW 2006-04-01 00:00:00   1 Q71 2013-03-20 00:00:00   0795 1351305 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
17 Q6100229 SEYMENOGLU YK Y56 Q71 THE SURGERY 30 WINSTON ROAD NEWINGTON GREEN LONDON   N16 9LT 2006-04-01 00:00:00   1 Q71 2013-03-20 00:00:00 2015-04-20 00:00:00 020 72542864 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
21 Q6100267 HAUGHTON ND Y56 Q71 12 RADDINGTON ROAD LONDON       W10 5TG 2006-04-01 00:00:00   1 Q71 2013-03-20 00:00:00   020 89620635 0
23 Q6100281 NORMAN AR Y56 Q71 2 LOWER SLOANE STREET LONDON       SW1W 8BJ 2006-04-01 00:00:00   1 Q71 2013-03-20 00:00:00   020 78814161 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
32 Q6100377 PENN A Y56 Q71 39 WINDERS ROAD BATTERSEA   LONDON   SW11 3HE 2006-04-01 00:00:00   1 Q71 2013-03-20 00:00:00 2015-04-20 00:00:00 0791 3379923 0
34 Q6100391 DE MAAR L Y56 Q71 BLOSSOMS HEALTHCARE 21-26 GARLICK HILL LONDON LONDON   EC4V 2AU 2006-04-01 00:00:00   1 Q71 2013-03-20 00:00:00   020 74891136 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
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
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
65 Q6100700 LEVINSON C Y56 Q71 121 HARLEY STREET LONDON       W1G 6AX 2006-04-01 00:00:00   1 Q71 2013-03-20 00:00:00   0844 2570345 0
66 Q6100717 LINDALL K Y56 Q71 ROODLANE MEDICAL 60 NEW BROAD STREET LONDON LONDON   EC2M 1JJ 2006-04-01 00:00:00   1 Q71 2013-03-20 00:00:00   0845 4370691 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
78 Q6100834 SHEEHAN PT Y56 Q71 DOCTORCALL 121 HARLEY STREET LONDON LONDON   W1G 6AX 2006-04-01 00:00:00   1 Q71 2013-03-20 00:00:00   0844 2570345 0
85 Q6100906 SANDERS S Y56 Q71 LONDON GENERAL PRACTICE 16 DEVONSHIRE STREET LONDON LONDON   W1G 7AF 2006-04-01 00:00:00   1 Q71 2013-03-20 00:00:00   020 79351000 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
158 Q6101639 ASHFORD R Y56 Q71 MOUNT VERNON CANCER CTRE MOUNT VERNON HOSPITAL NORTHWOOD MIDDLESEX   HA6 2RN 2006-04-01 00:00:00   1 Q71 2013-03-20 00:00:00   01923 844323 0
159 Q6101646 EISSA AA Y56 Q71 DEPT OF OBSTETRICS & GYNE ROYAL FREE HOSPITAL POND STREET LONDON   NW3 2QG 2006-04-01 00:00:00   1 Q71 2013-03-20 00:00:00 2015-04-20 00:00:00 0771 7084861 0
183 Q6101880 TAYLOR J Y56 Q71 SUTTONS MANOR HOSP LONDON ROAD STAPLEFORD TAWNEY ESSEX   RM4 1SR 2006-04-01 00:00:00   1 Q71 2013-03-20 00:00:00   01708 687398 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
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
193 Q6101983 AZIZ E Y56 Q71 6 BARNFIELD WOOD ROAD PARK LANGLEY BECKENHAM KENT   BR3 4JA 2006-04-01 00:00:00   1 Q71 2013-03-20 00:00:00   07970 301703 0
194 Q6101990 ASLAM A Y56 Q71 THE LINEA CLINIC 17 HARLEY STREET   LONDON   W1G 9QH 2006-04-01 00:00:00   1 Q71 2013-03-20 00:00:00 2015-04-20 00:00:00 07875 464222 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
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
200 Q6102056 BOSCOE M Y56 Q71 BRAMBLES BAKERS WOOD DENHAM     UB9 4LU 2006-04-01 00:00:00   1 Q71 2013-03-20 00:00:00 2015-04-20 00:00:00 07831 835508 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
202 Q6102070 CHANDU S Y56 Q71 WESTLANDS REHAB. UNIT 74 KENTON ROAD HARROW     HA1 4AR 2006-04-01 00:00:00   1 Q71 2013-03-20 00:00:00 2015-04-20 00:00:00 020 8070770 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
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
208 Q6102135 JENKINS S Y56 Q71 CROMWELL HOSPITAL CROMWELL ROAD LONDON     SW5 0TU 2006-04-01 00:00:00   1 Q71 2013-03-20 00:00:00 2015-04-20 00:00:00 020 74605916 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
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
216 Q6102214 MORAITES TM Y56 Q71 VICTORIA MEDICENTRE VICTORIA STATION MAIN CONCOURSE LONDON   SW1V 1JT 2006-04-01 00:00:00   1 Q71 2013-03-20 00:00:00   020 78476558 0
218 Q6102238 RAGHOONANAN S Y56 Q71 VICTORIA MEDICENTRE VICTORIA MAINLINE STATION LONDON     SW1V 1JT 2006-04-01 00:00:00   1 Q71 2013-03-20 00:00:00 2015-04-20 00:00:00 020 78285495 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
247 Q6102520 DANIEL R Y56 Q71 HIGHGATE HOSPITAL 17/19 VIEW ROAD HIGHGATE LONDON   N6 4DJ 2006-04-01 00:00:00   1 Q71 2013-03-20 00:00:00 2015-04-20 00:00:00 020 83415163 0
250 Q6102551 ELTON C Y56 Q71 6 FAUNA CLOSE BROCKLEY PARK STANMORE MIDDLESEX   HA7 4PX 2006-04-01 00:00:00   1 Q71 2013-03-20 00:00:00 2015-04-20 00:00:00 07909 900649 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
255 Q6102609 GILL A Y56 Q71 IVF UNIT CROMWELL HOSPITAL CROMWELL ROAD LONDON   SW5 0TU 2006-04-01 00:00:00   1 Q71 2013-03-20 00:00:00 2015-04-20 00:00:00 07968 122880 0
256 Q6102616 GADIR A Y56 Q71 HIGHGATE HOSPITAL 17/19 VIEW ROAD HIGHGATE LONDON   N6 4DJ 2006-04-01 00:00:00   1 Q71 2013-03-20 00:00:00 2015-04-20 00:00:00 020 83475081 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
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
262 Q6102692 HO-ASJOE M Y56 Q71 PPS LTD,AGB 18 AVERY HILL ROAD NEW ELTHAM LONDON   SE9 2BD 2006-04-01 00:00:00   1 Q71 2013-03-20 00:00:00 2015-04-20 00:00:00 07970 252873 0
264 Q6102719 HARRISON S Y56 Q71 DEPT OF ANAESTHETIC WEST MIDDLESEX UNI HOSP       TW7 6AF 2006-04-01 00:00:00   1 Q71 2013-03-20 00:00:00 2015-04-20 00:00:00 07710 202964 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
270 Q6102771 IRVINE S Y56 Q71 8 NICHOLS GREEN MONTPELIER ROAD   LONDON   W5 2QW 2006-04-01 00:00:00   1 Q71 2013-03-20 00:00:00 2015-04-20 00:00:00 07879 628062 0
271 Q6102788 IREGBULEM L Y56 Q71 290 CRICKLEWOOD LANE CHILDS HILL   LONDON   NW2 2PX 2006-04-01 00:00:00   1 Q71 2013-03-20 00:00:00 2015-04-20 00:00:00 020 84589411 0
272 Q6102795 JARMAN P Y56 Q71 HOSPITAL FOR NEUROLOGY & NEUROSURGERY,23 QUEEN SQ   LONDON   WC1N 3BG 2006-04-01 00:00:00   1 Q71 2013-03-20 00:00:00 2015-04-20 00:00:00 07974 572612 0
273 Q6102805 JEMEC B Y56 Q71 PPPS LTD,AGB HOUSE 18 AVERY HILL ROAD NEW ELTHAM LONDON   SE9 2BD 2006-04-01 00:00:00   1 Q71 2013-03-20 00:00:00 2015-04-20 00:00:00 07775 944299 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
276 Q6102836 JAWSWON M Y56 Q71 WOOLASTON HOUSE 25 SOUTHWOOD LANE HIGHGATE LONDON   N6 5ED 2006-04-01 00:00:00   1 Q71 2013-03-20 00:00:00 2015-04-20 00:00:00 07850 559495 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
278 Q6102850 JOOSTE C Y56 Q71 GROUND FLOOR FLAT 12 LANCASTER DRIVE   LONDON   NW3 4HA 2006-04-01 00:00:00   1 Q71 2013-03-20 00:00:00 2015-04-20 00:00:00 07699 115300 0
282 Q6102898 KHAN S Y56 Q71 HIGHGATE HOSPITAL 17/19 VIEW ROAD HIGHGATE LONDON   N6 4DJ 2006-04-01 00:00:00   1 Q71 2013-03-20 00:00:00 2015-04-20 00:00:00 07970 600317 0
283 Q6102908 KOTAK DC Y56 Q71 52 DANEMERE STREET LONDON       SW15 1LT 2006-04-01 00:00:00   1 Q71 2013-03-20 00:00:00   020 87880658 0
287 Q6102946 KYEI-MENSAH A Y56 Q71 WOOLASTON HOUSE 24 SOUTHWOOD LANE HIGHGATE LONDON   N6 5ED 2006-04-01 00:00:00   1 Q71 2013-03-20 00:00:00 2015-04-20 00:00:00 07979 593210 0
288 Q6102953 LAMBIRIS A Y56 Q71 FLAT 1 11A ST JOHNS WOOD HIGH ST   LONDON   NW8 7NG 2006-04-01 00:00:00   1 Q71 2013-03-20 00:00:00 2015-04-20 00:00:00 07659 171255 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
296 Q6103033 LOCK R Y56 Q71 WOOLASTON HOUSE 25 SOUTHWOOD LANE HIGHGATE LONDON   N6 5ED 2006-04-01 00:00:00   1 Q71 2013-03-20 00:00:00 2015-04-20 00:00:00 020 83413422 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
298 Q6103057 MUKHTAR H Y56 Q71 JENNER BUILDING THE WHITTINGTON HOSPITAL HIGHGATE HILL LONDON   N19 5NF 2006-04-01 00:00:00   1 Q71 2013-03-20 00:00:00   07880 716174 0
299 Q6103064 MANEKSHA S Y56 Q71 THE SURGERY 24 HERMISTON AVENUE CROUCH END LONDON   N8 8NL 2006-04-01 00:00:00   1 Q71 2013-03-20 00:00:00 2015-04-20 00:00:00 020 83406832 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
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
309 Q6103174 NATHAN B Y56 Q71 HEATH CLINIC 58 WEST HEATH DRIVE GOLDERS GREEN LONDON   NW11 7QH 2006-04-01 00:00:00   1 Q71 2013-03-20 00:00:00 2015-04-20 00:00:00 07771 655270 0
310 Q6103181 ORNADEL D Y56 Q71 CLEMENTINE CHURCHILL HOSP SUDBURY HILL HARROW MIDDLESEX   HA1 3RX 2006-04-01 00:00:00   1 Q71 2013-03-20 00:00:00 2015-04-20 00:00:00 07976 950675 0
312 Q6103208 OSHOWO A Y56 Q71 DPT OF SURG,WHITTINGTON HOSPITAL,JENNER BUILDING HIGHGATE HILL LONDON   N19 5NF 2006-04-01 00:00:00   1 Q71 2013-03-20 00:00:00 2015-04-20 00:00:00 07950 484970 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
315 Q6103239 PAVLOU S Y56 Q71 CHASE FARM HOSPITAL THE RIDGEWAY ENFIELD MIDDLESEX   EN2 8JL 2006-04-01 00:00:00   1 Q71 2013-03-20 00:00:00 2015-04-20 00:00:00 07768 861633 0
318 Q6103260 PRAKASH J Y56 Q71 112 HARLEY STREET LONDON HARROW     W1G 7JQ 2006-04-01 00:00:00   1 Q71 2013-03-20 00:00:00   07785 237899 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
321 Q6103291 ROSEN P Y56 Q71 HIGHGATE HOSPITAL 17/19 VIEW ROAD HIGHGATE LONDON   N6 4DJ 2006-04-01 00:00:00   1 Q71 2013-03-20 00:00:00   07867 781580 0
323 Q6103318 SAUNDERS P Y56 Q71 9 GLENDOWER MANSIONS GLENDOWER PLACE   LONDON   SW7 3DS 2006-04-01 00:00:00   1 Q71 2013-03-20 00:00:00 2015-04-20 00:00:00 07798 601845 0
324 Q6103325 SALIM F Y56 Q71 95 CLARENCE CLOSE   NEW BARNET HERTFORDSHIRE   EN4 8AD 2006-04-01 00:00:00   1 Q71 2013-03-20 00:00:00 2015-04-20 00:00:00 07919 255495 0
325 Q6103332 SAMAD E Y56 Q71 50 AYLMER ROAD   HIGHGATE LONDON   N2 0PL 2006-04-01 00:00:00   1 Q71 2013-03-20 00:00:00 2015-04-20 00:00:00 07860 650071 0
328 Q6103363 SHIM WONG V Y56 Q71 WOOLASTON HOUSE 25 SOUTHWOOD LANE HIGHGATE LONDON   N6 5ED 2006-04-01 00:00:00   1 Q71 2013-03-20 00:00:00 2015-04-20 00:00:00 0151 5255980 0
329 Q6103370 SINGH S Y56 Q71 SUITE 206 EMBLEM HOUSE LONDON BRIDGE HOSPITAL 27 TOOLEY STREET LONDON   SE1 2PR 2006-04-01 00:00:00   1 Q71 2013-03-20 00:00:00 2015-04-20 00:00:00 020 79353763 0
331 Q6103394 SILVA A Y56 Q71 34 CORRINGWAY   EALING LONDON   W5 3AA 2006-04-01 00:00:00   1 Q71 2013-03-20 00:00:00   07850 093916 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 55.262ms · Data source: OUseful Databeat