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
101 Q6101062 CHAPPLE D 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
102 Q6101079 CHAVE H 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
103 Q6101086 COCKROFT 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
104 Q6101093 COLE 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
105 Q6101103 COLLINS 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
106 Q6101110 COX C 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
107 Q6101127 COX D 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
108 Q6101134 DOCHERTY P 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
109 Q6101141 DONNISON P 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
110 Q6101158 DOWNIE I 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
111 Q6101165 DUGGAL K 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
112 Q6101172 DUNN 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
113 Q6101189 FINNIS D 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
114 Q6101196 FLOOD T 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
115 Q6101206 FLOWERDEW 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
116 Q6101213 FOUNTAIN 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
117 Q6101220 GARRETT W 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
118 Q6101237 GUY P 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
119 Q6101244 HENNING V 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
120 Q6101251 HOBBY 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
121 Q6101268 HORLOCK N 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
122 Q6101275 IVESON T Y57 Q82 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
123 Q6101282 JUKES 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
124 Q6101299 JONES T Y57 Q82 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
125 Q6101309 LINTIN D 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
126 Q6101316 MARIGOLD J Y57 Q82 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
127 Q6101323 MCCALLUM D 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
128 Q6101330 MCINTOSH G 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
129 Q6101347 MCKENNA D 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
130 Q6101354 METCALF K 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
131 Q6101361 MURRAY D 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
132 Q6101378 ONSLOW 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
133 Q6101385 RANABOLDO C 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
134 Q6101392 RAUH P 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
135 Q6101402 ROSSI T 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
136 Q6101419 RUSHFORTH G 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
137 Q6101426 SCOTT 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
138 Q6101433 SHERGILL G 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
139 Q6101440 SWAYNE P 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
140 Q6101457 TANNER 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
141 Q6101464 TIERNAN E 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
142 Q6101471 TODD G 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
143 Q6101488 VERDIN 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
144 Q6101495 VYAS S Y57 Q82 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
145 Q6101505 WALTER 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
146 Q6101512 WARLEY A Y57 Q82 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
147 Q6101529 WHITWORTH I 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
148 Q6101536 WILLIAMS 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
149 Q6101543 WRIGHT I 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
150 Q6101550 HASLAM RJ Y54 Q73 THE PRIORY HOSPITAL RAPPAX ROAD HALE CHESHIRE   WA15 0NX 2006-04-01 00:00:00   1 Q73 2015-04-01 00:00:00   0161 9040050 0
151 Q6101567 OLDHAM JFML Y57 Q81 ALPHA HOSPITAL REDDING WAY KNAPHILL, WOKING SURREY   GU21 2QS 2006-04-01 00:00:00   1 Q81 2015-04-01 00:00:00   01483 795100 0
152 Q6101574 TADROS AN Y57 Q70 OPHTHALMOLOGY DEPARTMENT DORSET COUNTY HOSPITAL WILLIAMS AVENUE DORSET   DT1 2JY 2006-04-01 00:00:00   1 Q70 2013-04-01 00:00:00   01305 255387 0
153 Q6101581 MCNEILLY RA Y57 Q81 THE OLD SCHOOL BRIGHTLING ROBERTSBRIDGE SUSSEX   TN32 5HH 2006-04-01 00:00:00   1 Q81 2015-04-01 00:00:00   07881 610075 0
154 Q6101598 BAGLEY G Y57 Q81 THE PRIORY GRANGE TOTTINGWORTH PARK BROAD OAK, HEATHFIELD EAST SUSSEX   TN21 8UN 2006-04-01 00:00:00   1 Q81 2015-04-01 00:00:00   01435 864545 0
155 Q6101608 ROGERS MC Y57 Q81 HEATHFIELD SURGERY 96-98 HIGH STREET HEATHFIELD EAST SUSSEX   TN21 8JD 2006-04-01 00:00:00   1 Q81 2015-04-01 00:00:00   01435 864999 0
156 Q6101615 ALMEIDA JH Y57 Q81 THE PRIORY GRANGE TOTTINGWORTH PARK BROAD OAK, HEATHFIELD EAST SUSSEX   TN21 8UN 2006-04-01 00:00:00   1 Q81 2015-04-01 00:00:00   01435 864545 0
157 Q6101622 MCDONOGH B Y57 Q81 MILNWOOD 13 NORTH PARADE HORSHAM     RH12 2BT 2006-04-01 00:00:00   1 Q81 2015-04-01 00:00:00   01403 258351 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
160 Q6101653 JACKSON G Y55 Q79 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
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
162 Q6101677 ANDERSSON C Y55 Q79 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
163 Q6101684 BHADRINATH B Y55 Q79 THE PRIORY HOSPITAL STUMP LANE CHELMSFORD ESSEX   CM1 7SJ 2006-04-01 00:00:00   1 Q79 2015-04-01 00:00:00 2017-02-28 00:00:00 01245 244702 1
164 Q6101691 CAVISTON P Y55 Q79 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
165 Q6101701 DANIELS O Y55 Q79 THE PRIORY HOSPITAL STUMP LANE CHELMSFORD ESSEX   CM1 7SJ 2006-04-01 00:00:00   1 Q79 2015-04-01 00:00:00 2017-02-28 00:00:00 01245 244702 1
166 Q6101718 KLIJNSMA M Y55 Q79 THE PRIORY HOSPITAL STUMP LANE CHELMSFORD ESSEX   CM1 7SJ 2006-04-01 00:00:00   1 Q79 2015-04-01 00:00:00   01245 244729 0
167 Q6101725 MAYER C Y55 Q79 THE PRIORY HOSPITAL STUMP LANE CHELMSFORD ESSEX   CM1 7SJ 2006-04-01 00:00:00   1 Q79 2015-04-01 00:00:00 2017-02-28 00:00:00 01245 244702 1
168 Q6101732 WEBSTER P Y55 Q79 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
171 Q6101763 ACHARYYA S Y55 Q79 THE PRIORY HOSPITAL STUMP LANE CHELMSFORD ESSEX   CM1 7SJ 2006-04-01 00:00:00   1 Q79 2015-04-01 00:00:00 2017-02-28 00:00:00 01245 244702 1
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
178 Q6101835 LITTLEJOHN R Y55 Q79 THE PRIORY HOSPITAL STUMP LANE CHELMSFORD ESSEX   CM1 7SJ 2006-04-01 00:00:00   1 Q79 2015-04-01 00:00:00   01245 345345 1
179 Q6101842 O'FLYNN RR Y55 Q79 FOCUS 12 82 RISBYGATE ST BURY ST EDMUNDS SUFFOLK   IP33 3AQ 2006-04-01 00:00:00   1 Q79 2016-04-18 00:00:00   01284 701702 1
180 Q6101859 ROSSOUW T Y55 Q79 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
182 Q6101873 SENEVIRATNA K Y55 Q79 THE PRIORY HOSPITAL STUMP LANE CHELMSFORD ESSEX   CM1 7SJ 2006-04-01 00:00:00   1 Q79 2015-04-01 00:00:00 2017-02-28 00:00:00 01245 244702 1
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
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
186 Q6101914 ANDROULAKAKIS A Y56 Q71 FLAT 504 PENINSULA APARTMENTS 4 PRAED STREET LONDON   W2 1JE 2006-04-01 00:00:00   1 Q71 2013-04-01 00:00:00   07745 900313 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
189 Q6101945 ADAMO C Y56 Q71 THE HARLEY MEDICAL GROUP 11 QUEEN ANNE STREET   LONDON   W1G 9LJ 2006-04-01 00:00:00   1 Q71 2013-04-01 00:00:00   0774 6484510 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
191 Q6101969 AL-BASRI I Y57 Q82 SAFA HOUSE CHURCH LANE WEXHAM SLOUGH   SL3 6LH 2006-04-01 00:00:00   1 Q82 2015-04-01 00:00:00   07887 647611 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
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
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

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