home / nhsadmin

Private Controlled Drug Prescribers

Data source: OUseful Databeat

6,479 rows

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
1 Q6100009 LIEBERMAN S Y57 Q70 WARBY HOSPITAL ODIHAM ROAD HARTLEY WINTNEY HAMPSHIRE   RG27 8BS 2006-04-01 00:00:00   1 Q70 2013-04-01 00:00:00   01252 845826 0
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
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
7 Q6100092 EVANS DM Y57 Q82 THE HAND CLINIC OAKLEY GREEN WINDSOR BERKSHIRE   SL4 4LH 2006-04-01 00:00:00   1 Q82 2015-04-01 00:00:00   01753 831333 0
8 Q6100119 SAMMUT DP Y57 Q82 THE HAND CLINIC OAKLEY GREEN WINDSOR BERKSHIRE   SL4 4LH 2006-04-01 00:00:00   1 Q82 2015-04-01 00:00:00   01753 831333 0
9 Q6100126 ARMSTRONG AP Y57 Q82 THE HAND CLINIC OAKLEY GREEN WINDSOR BERKSHIRE   SL4 4LH 2006-04-01 00:00:00   1 Q82 2015-04-01 00:00:00   01753 831333 0
10 Q6100133 MARTIN DL Y57 Q82 THE HAND CLINIC OAKLEY GREEN WINDSOR BERKSHIRE   SL4 4LH 2006-04-01 00:00:00   1 Q82 2015-04-01 00:00:00   01753 831333 0
11 Q6100140 MACAULAY AJ Y57 Q82 CARDINAL CLINIC OAKLEY GREEN ROAD WINDSOR     SL4 5UL 2006-04-01 00:00:00   1 Q82 2015-04-01 00:00:00   01753 869755 0
12 Q6100171 ESPIE JT Y54 Q74 CAMBIAN VICTORIA HOUSE BARTON STREET DARLINGTON COUNTY DURHAM   DL1 2LN 2006-04-01 00:00:00   1 Q74 2015-04-01 00:00:00   01325 385240 0
13 Q6100188 ESPIE PJ Y54 Q74 AFFINITY HEALTHCARE MIDDLETON ST GEORGE HOSP DARLINGTON CO DURHAM   DL2 1TS 2006-04-01 00:00:00   1 Q74 2015-04-01 00:00:00   01325 333192 0
14 Q6100195 CHRISTIE JS Y54 Q74 AFFINITY HEALTHCARE MIDDLETON ST GEORGE HOSP DARLINGTON CO DURHAM   DL2 1TS 2006-04-01 00:00:00   1 Q74 2015-04-01 00:00:00   01325 333192 0
15 Q6100205 KENNEDY AR Y54 Q74 AFFINITY HEALTHCARE MIDDLETON ST GEORGE HOSP DARLINGTON CO DURHAM   DL2 1TS 2006-04-01 00:00:00   1 Q74 2015-04-01 00:00:00   01325 333192 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
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
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
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
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
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
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
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
30 Q6100353 COFFEY IW Y55 Q78 ISHAM HOUSE ST ANDREWS HOSPITAL NORTHAMPTON     NN1 5DG 2006-04-01 00:00:00   1 Q78 2015-04-01 00:00:00   01604 616186 0
31 Q6100360 HEZSELTINE D Y54 Q72 3 HEATHER COURT SHAW WOOD WAY DONCASTER     DN2 5YL 2006-04-01 00:00:00   1 Q72 2015-04-01 00:00:00   01302 329666 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
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
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
35 Q6100401 CANTOPHER TGA Y57 Q81 THE PRIORY HOSPITAL CHOBHAM ROAD KNAPHILL, WOKING SURREY   GU21 2QF 2006-04-01 00:00:00   1 Q81 2015-04-01 00:00:00   01483 489211 0
36 Q6100418 MICHAEL LA Y54 Q73 599 WILMSLOW ROAD DIDSBURY MANCHESTER     M20 3QD 2006-04-01 00:00:00   1 Q73 2015-04-01 00:00:00   0161 4451952 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
50 Q6100559 BROWN K Y55 Q76 THE FAMILY MEDICAL CENTRE 171 CARLTON ROAD NOTTINGHAM     NG3 2FW 2006-04-01 00:00:00   1 Q76 2015-04-01 00:00:00 2016-05-31 00:00:00 0115 9504068 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
53 Q6100580 SATHANANTHAN D Y55 Q76 THE FAMILY MEDICAL CENTRE 171 CARLTON ROAD NOTTINGHAM     NG3 2FW 2006-04-01 00:00:00   1 Q76 2015-04-01 00:00:00 2016-05-31 00:00:00 0115 9504068 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
55 Q6100607 SOOD N Y55 Q76 THE FAMILY MEDICAL CENTRE 171 CARLTON ROAD NOTTINGHAM     NG3 2FW 2006-04-01 00:00:00   1 Q76 2015-04-01 00:00:00 2016-05-31 00:00:00 0115 9504068 0
56 Q6100614 DAY J Y55 Q76 THE FAMILY MEDICAL CENTRE 171 CARLTON ROAD NOTTINGHAM     NG3 2FW 2006-04-01 00:00:00   1 Q76 2015-04-01 00:00:00 2016-05-31 00:00:00 0115 9504068 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
58 Q6100638 ARDEN-JONES J Y55 Q76 THE FAMILY MEDICAL CENTRE 171 CARLTON ROAD NOTTINGHAM     NG3 2FW 2006-04-01 00:00:00   1 Q76 2015-04-01 00:00:00 2016-05-31 00:00:00 0115 9504068 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
62 Q6100676 LATCHMAN PJ Y56 Q71 THE DIAGNOSTIC CLINIC 50 NEW CAVENDISH STREET LONDON     W1G 8TL 2006-04-01 00:00:00   1 Q71 2013-04-01 00:00:00   020 70094650 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
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
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
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
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
82 Q6100872 VAN DEN BOSSCHE T Y56 Q71 DOCTORCALL CLINIC 121 HARLEY STREET LONDON LONDON   W1G 6AX 2006-04-01 00:00:00   1 Q71 2013-04-01 00:00:00   0844 2570345 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
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
86 Q6100913 ADAM S Y52 Q39 CAPIO NEW HALL HOSPITAL BODENHAM SALISBURY     SP5 4EY 2006-04-01 00:00:00   1 Q82 2015-04-01 00:00:00   01722 422333 0
87 Q6100920 BROWN KRM Y52 Q39 CAPIO NEW HALL HOSPITAL BODENHAM SALISBURY     SP5 4EY 2006-04-01 00:00:00   1 Q82 2015-04-01 00:00:00   01722 422333 0
88 Q6100937 PERRING MA Y56 Q71 19 MILFORD HOUSE 7 QUEEN ANNE STREET   LONDON   W1G 9HN 2006-04-01 00:00:00   1 Q71 2013-04-01 00:00:00   020 74367713 0
89 Q6100944 WIGMORE L Y52 Q39 CAPIO NEW HALL HOSPITAL BODENHAM SALISBURY     SP5 4EY 2006-04-01 00:00:00   1 Q82 2015-04-01 00:00:00   01722 422333 0
90 Q6100951 ABBAS S Y52 Q39 CAPIO NEW HALL HOSPITAL BODENHAM SALISBURY     SP5 4EY 2006-04-01 00:00:00   1 Q82 2015-04-01 00:00:00   01722 422333 0
91 Q6100968 AERTSSEN A Y52 Q39 CAPIO NEW HALL HOSPITAL BODENHAM SALISBURY     SP5 4EY 2006-04-01 00:00:00   1 Q82 2015-04-01 00:00:00   01722 422333 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
93 Q6100982 BARRETT R Y52 Q39 CAPIO NEW HALL HOSPITAL BODENHAM SALISBURY     SP5 4EY 2006-04-01 00:00:00   1 Q82 2015-04-01 00:00:00   01722 422333 0
94 Q6100999 BEAUMONT A Y52 Q39 CAPIO NEW HALL HOSPITAL BODENHAM SALISBURY     SP5 4EY 2006-04-01 00:00:00   1 Q82 2015-04-01 00:00:00   01722 422333 0
95 Q6101000 BIGGART S Y52 Q39 CAPIO NEW HALL HOSPITAL BODENHAM SALISBURY     SP5 4EY 2006-04-01 00:00:00   1 Q82 2015-04-01 00:00:00   01722 422333 0
96 Q6101017 BROCKBANK M Y52 Q39 CAPIO NEW HALL HOSPITAL BODENHAM SALISBURY     SP5 4EY 2006-04-01 00:00:00   1 Q82 2015-04-01 00:00:00   01722 422333 0
97 Q6101024 CADIER M Y52 Q39 CAPIO NEW HALL HOSPITAL BODENHAM SALISBURY     SP5 4EY 2006-04-01 00:00:00   1 Q82 2015-04-01 00:00:00   01722 422333 0
98 Q6101031 CAMPBELL A Y52 Q39 CAPIO NEW HALL HOSPITAL BODENHAM SALISBURY     SP5 4EY 2006-04-01 00:00:00   1 Q82 2015-04-01 00:00:00   01722 422333 0
99 Q6101048 CARTY N Y57 Q82 CAPIO NEW HALL HOSPITAL BODENHAM SALISBURY     SP5 4EY 2006-04-01 00:00:00   1 Q82 2015-04-01 00:00:00 2016-08-01 00:00:00 01722 422333 0
100 Q6101055 CARVELL J Y52 Q39 CAPIO NEW HALL HOSPITAL BODENHAM SALISBURY     SP5 4EY 2006-04-01 00:00:00   1 Q82 2015-04-01 00:00:00   01722 422333 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 122.435ms · Data source: OUseful Databeat