home / nhsadmin

Private Controlled Drug Prescribers

Data source: OUseful Databeat

6,479 rows sorted by Postcode

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
2008 Q6120663 GANDER DR Y55 Q78 8 ST PETERS CLOSE ST ALBANS HERTFORDSHIRE     AL1 3ES 2006-08-23 00:00:00   1 Q78 2015-04-01 00:00:00   01727 850584 0
2929 Q6129985 PLATTS A Y55 Q78 PARKBURY HOUSE ST PETERS STREET ST ALBANS HERTFORDSHIRE   AL1 3HD 2007-05-22 00:00:00   1 Q78 2015-04-01 00:00:00   01727 851589 0
3958 Q6140557 SAGE REM Y55 Q78 PARKBURY HOUSE ST PETERS STREET ST ALBANS HERTFORDSHIRE   AL1 3HD 2009-06-01 00:00:00   1 Q78 2015-04-01 00:00:00   0844 4127260 0
4045 Q6141462 MOLEFI-YOURI W Y55 Q78 RYDER CLINIC 24 HALL PLACE GARDENS ST ALBANS HERTFORDSHIRE   AL1 3SF 2009-09-14 00:00:00   1 Q78 2015-04-01 00:00:00   01727 860230 0
4055 Q6141565 DE BANKS P Y55 Q78 RYDER CLINIC,THE ELMS 24 HALL GARDENS ST ALBANS HERTFORDSHIRE   AL1 3SF 2009-09-20 00:00:00   1 Q78 2015-04-01 00:00:00   01727 860230 0
4091 Q6141929 EDWARDS P Y55 Q78 RYDER CLINIC, THE ELMS 24 HALL PLACE GARDENS ST ALBANS HERTS   AL1 3SF 2009-10-16 00:00:00   1 Q78 2015-04-01 00:00:00   01727 860230 0
2069 Q6121303 GODLEE J Y55 Q78 THE HERTFORDSHIRE CLINIC ART SCHOOL YARD THE MALTINGS,ST ALBANS HERTFORDSHIRE   AL1 3YS 2006-08-18 00:00:00   1 Q78 2015-04-01 00:00:00   01727 898162 0
2188 Q6122524 REFAAT RI Y55 Q78 THE HERTFORDSHIRE CLINIC ART SCHOOL YARD THE MALTINGS,ST ALBANS HERTFORDSHIRE   AL1 3YS 2006-09-19 00:00:00   1 Q78 2015-04-01 00:00:00   01727 898164 0
4795 Q6149192 OPPEDIJK G Y55 Q78 55 LANCASTER ROAD   ST ALBANS HERTFORDSHIRE   AL1 4EP 2011-12-07 00:00:00   1 Q78 2015-04-01 00:00:00   01727 753787 0
6032 Q6161741 PARKER JR Y55 Q78 DATS UNIT 2 EXECUTIVE PARK HATFIELD ROAD ST ALBANS   AL1 4TA 2016-02-01 00:00:00   1 Q78 2016-02-01 00:00:00   07703 067765 0
4652 Q6147767 MASANZU R Y55 Q78 PO BOX 1141   ST ALBANS     AL1 9UR 2011-09-01 00:00:00   1 Q78 2015-04-01 00:00:00   07809 616364 0
2954 Q6130237 OATES PE Y55 Q78 LISTER HOUSE THE COMMON HATFIELD HERTSFORDSHIRE   AL10 0NL 2007-05-31 00:00:00   1 Q78 2015-04-01 00:00:00   01707 268822 0
2955 Q6130244 BROOKS RV Y55 Q78 LISTER HOUSE THE COMMON HATFIELD HERTSFORDSHIRE   AL10 0NL 2007-05-31 00:00:00   1 Q78 2015-04-01 00:00:00   01707 268822 0
2956 Q6130251 LEWIS GH Y55 Q78 LISTER HOUSE THE COMMON HATFIELD HERTSFORDSHIRE   AL10 0NL 2007-05-31 00:00:00   1 Q78 2015-04-01 00:00:00   01707 268822 0
2957 Q6130268 RAJARATNAM M Y55 Q78 LISTER HOUSE THE COMMON HATFIELD HERTSFORDSHIRE   AL10 0NL 2007-05-31 00:00:00   1 Q78 2015-04-01 00:00:00   01707 268822 0
2958 Q6130275 MCDOWALL GK Y55 Q78 LISTER HOUSE THE COMMON HATFIELD HERTSFORDSHIRE   AL10 0NL 2007-05-31 00:00:00   1 Q78 2015-04-01 00:00:00   01707 268822 0
2959 Q6130282 MCDOWALL GK Y55 Q78 LISTER HOUSE THE COMMON HATFIELD HERTSFORDSHIRE   AL10 0NL 2007-05-31 00:00:00   1 Q78 2015-04-01 00:00:00   01707 268822 0
2960 Q6130299 LAVELLE RCW Y55 Q78 LISTER HOUSE THE COMMON HATFIELD HERTSFORDSHIRE   AL10 0NL 2007-05-31 00:00:00   1 Q78 2015-04-01 00:00:00   01707 268822 0
2961 Q6130309 KINSLER R Y55 Q78 LISTER HOUSE THE COMMON HATFIELD HERTSFORDSHIRE   AL10 0NL 2007-05-31 00:00:00   1 Q78 2015-04-01 00:00:00   01707 268822 0
3896 Q6139906 GOSNELL V Y55 Q79 68 WALKER GROVE SALISBURY VILLAGE HATFIELD HERTFORDSHIRE   AL10 9PL 2009-04-15 00:00:00   1 Q79 2015-04-01 00:00:00 2017-02-28 00:00:00 07795 995752 1
6091 Q6162340 RUPP S Y57 Q81 129 RADLETT ROAD ST ALBANS       AL2 2LA 2016-03-21 00:00:00   7 Q81 2016-03-21 00:00:00   07879 447304 0
2457 Q6125259 HASELER A Y55 Q78 GRANGE STREET SURGERY 2 GRANGE STREET ST. ALBANS HERTFORDSHIRE   AL3 5NF 2006-11-08 00:00:00   1 Q78 2015-04-01 00:00:00   01727 833550 0
2482 Q6125503 CARRUTHERS G Y55 Q78 GRANGE STREET SURGERY 2 GRANGE STREET ST. ALBANS HERTFORDSHIRE   AL3 5NF 2006-11-13 00:00:00   1 Q78 2015-04-01 00:00:00   01727 833550 0
2483 Q6125510 MARTIN H Y55 Q78 GRANGE STREET SURGERY 2 GRANGE STREET ST. ALBANS HERTFORDSHIRE   AL3 5NF 2006-11-13 00:00:00   1 Q78 2015-04-01 00:00:00   01727 833550 0
2484 Q6125527 ALLISTONE A Y55 Q78 GRANGE STREET SURGERY 2 GRANGE STREET ST. ALBANS HERTFORDSHIRE   AL3 5NF 2006-11-13 00:00:00   1 Q78 2015-04-01 00:00:00   01727 833550 0
2485 Q6125534 DOW I Y55 Q78 GRANGE STREET SURGERY 2 GRANGE STREET ST. ALBANS HERTFORDSHIRE   AL3 5NF 2006-11-13 00:00:00   1 Q78 2015-04-01 00:00:00   01727 833550 0
2544 Q6126133 STEPHENS J Y55 Q78 THE VILLAGE SURGERY AMENBURY LANE HARPENDEN HERTFORDSHIRE   AL5 2BT 2006-11-21 00:00:00   1 Q78 2015-04-01 00:00:00   01582 712021 0
2842 Q6129112 SOLOMONS K Y55 Q78 THE VILLAGE SURGERY AMENBURY LANE HARPENDEN HERTFORDSHIRE   AL5 2BT 2007-04-05 00:00:00   1 Q78 2015-04-01 00:00:00   01582 712021 0
2843 Q6129129 GOODWIN T Y55 Q78 THE VILLAGE SURGERY AMENBURY LANE HARPENDEN HERTFORDSHIRE   AL5 2BT 2007-04-05 00:00:00   1 Q78 2015-04-01 00:00:00   01582 712021 0
2844 Q6129136 INGRAM SD Y55 Q78 THE VILLAGE SURGERY AMENBURY LANE HARPENDEN HERTFORDSHIRE   AL5 2BT 2007-04-05 00:00:00   1 Q78 2015-04-01 00:00:00   01582 712021 0
2845 Q6129143 WALKER R Y55 Q78 THE VILLAGE SURGERY AMENBURY LANE HARPENDEN HERTFORDSHIRE   AL5 2BT 2007-04-05 00:00:00   1 Q78 2015-04-01 00:00:00   01582 712021 0
2846 Q6129150 GILHAM D Y55 Q78 THE VILLAGE SURGERY AMENBURY LANE HARPENDEN HERTFORDSHIRE   AL5 2BT 2007-04-05 00:00:00   1 Q78 2015-04-01 00:00:00   01582 712021 0
2847 Q6129167 GIBBS RJ Y55 Q78 THE VILLAGE SURGERY AMENBURY LANE HARPENDEN HERTFORDSHIRE   AL5 2BT 2007-04-05 00:00:00   1 Q78 2015-04-01 00:00:00   01582 712021 0
2848 Q6129174 O'HARE PA Y55 Q78 THE VILLAGE SURGERY AMENBURY LANE HARPENDEN HERTFORDSHIRE   AL5 2BT 2007-04-05 00:00:00   1 Q78 2015-04-01 00:00:00   01582 712021 0
2263 Q6123271 PICKLES JM Y55 Q78 BUPA HOSPITAL HARPENDEN AMBROSE LANE HARPENDEN HERTFORDSHIRE   AL5 4BP 2006-10-01 00:00:00   1 Q78 2015-04-01 00:00:00   01582 714471 0
2315 Q6123817 WILLIAMS DJ Y55 Q78 BUPA HOSPITAL HARPENDEN AMBROSE LANE HARPENDEN HERTFORDSHIRE   AL5 4BP 2006-10-10 00:00:00   1 Q78 2015-04-01 00:00:00   0800 585112 0
3721 Q6138149 EL-NAGGAR H Y55 Q78 SPIRE HARPENDEN HOSPITAL AMBROSE LANE HARPENDEN HERTFORDSHIRE   AL5 4BP 2008-11-26 00:00:00   1 Q78 2015-04-01 00:00:00   07958 379957 0
4013 Q6141125 MOONCEY S Y55 Q78 AMBROSE LANE   HARPENDEN HERTFORDSHIRE   AL5 4BP 2009-07-27 00:00:00   1 Q78 2015-04-01 00:00:00   01582 763191 0
4322 Q6144379 HERODOTOU N Y55 Q78 SPIRE HARPENDEN HOSPITAL AMBROSE LANE HARPENDEN HERTFORDSHIRE   AL5 4BP 2010-06-10 00:00:00   1 Q78 2015-04-01 00:00:00   01582 763191 0
2225 Q6122892 STRANDERS AP Y55 Q78 DAVENPORT HOUSE SURGERY BOWERS WAY HARPENDEN HERTFORDSHIRE   AL5 4HX 2006-09-22 00:00:00   1 Q78 2015-04-01 00:00:00   01582 767821 0
3861 Q6139559 BARBER-LOMAX CA Y55 Q78 DAVENPORT HOUSE SURGERY BOWERS WAY HARPENDEN HERTFORDSHIRE   AL5 4HX 2009-03-26 00:00:00   1 Q78 2015-04-01 00:00:00   01582 767821 0
3862 Q6139566 CHAFER A Y55 Q78 DAVENPORT HOUSE SURGERY BOWERS WAY HARPENDEN HERTFORDSHIRE   AL5 4HX 2009-03-26 00:00:00   1 Q78 2015-04-01 00:00:00   01582 767821 0
3863 Q6139573 CASHYAP A Y55 Q78 DAVENPORT HOUSE SURGERY BOWERS WAY HARPENDEN HERTFORDSHIRE   AL5 4HX 2009-03-26 00:00:00   1 Q78 2015-04-01 00:00:00   01582 767821 0
3864 Q6139580 LAMB K Y55 Q78 DAVENPORT HOUSE SURGERY BOWERS WAY HARPENDEN HERTFORDSHIRE   AL5 4HX 2009-03-26 00:00:00   1 Q78 2015-04-01 00:00:00   01582 767821 0
3865 Q6139597 SANDLER M Y55 Q78 DAVENPORT HOUSE SURGERY BOWERS WAY HARPENDEN HERTFORDSHIRE   AL5 4HX 2009-03-26 00:00:00   1 Q78 2015-04-01 00:00:00   01582 767821 0
3866 Q6139607 THENUWARA C Y55 Q78 DAVENPORT HOUSE SURGERY BOWERS WAY HARPENDEN HERTFORDSHIRE   AL5 4HX 2009-03-26 00:00:00   1 Q78 2015-04-01 00:00:00   01582 767821 0
3867 Q6139614 WADHWANI S Y55 Q78 DAVENPORT HOUSE SURGERY BOWERS WAY HARPENDEN HERTFORDSHIRE   AL5 4HX 2009-03-26 00:00:00   1 Q78 2015-04-01 00:00:00   01582 767821 0
2265 Q6123295 GULLICK DL Y51 Q35 1 HEATHBROW ROAD WELWYN HERTFORDSHIRE     AL6 0QG 2006-10-01 00:00:00   1 Q78 2015-04-01 00:00:00   01438 714016 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
3663 Q6137540 ABRAHAMS R Y55 Q78 BRIDGE COTTAGE SURGERY 41 HIGH STREET WELWYN HERTFORDSHIRE   AL6 9EF 2008-09-22 00:00:00   1 Q78 2015-04-01 00:00:00   0844 8151413 0
3664 Q6137557 DANSIE N Y55 Q78 BRIDGE COTTAGE SURGERY 41 HIGH STREET WELWYN HERTFORDSHIRE   AL6 9EF 2008-09-22 00:00:00   1 Q78 2015-04-01 00:00:00   0844 8151413 0
3665 Q6137564 NAPIER H Y55 Q78 BRIDGE COTTAGE SURGERY 41 HIGH STREET WELWYN HERTFORDSHIRE   AL6 9EF 2008-09-22 00:00:00   1 Q78 2015-04-01 00:00:00   0844 8151413 0
3666 Q6137571 REED A Y55 Q78 BRIDGE COTTAGE SURGERY 41 HIGH STREET WELWYN HERTFORDSHIRE   AL6 9EF 2008-09-22 00:00:00   1 Q78 2015-04-01 00:00:00   0844 8151413 0
3667 Q6137588 PARDOE C Y55 Q78 BRIDGE COTTAGE SURGERY 41 HIGH STREET WELWYN HERTFORDSHIRE   AL6 9EF 2008-09-22 00:00:00   1 Q78 2015-04-01 00:00:00   0844 8151413 0
3668 Q6137595 ADAMS E Y55 Q78 BRIDGE COTTAGE SURGERY 41 HIGH STREET WELWYN HERTFORDSHIRE   AL6 9EF 2008-09-22 00:00:00   1 Q78 2015-04-01 00:00:00   0844 8151413 0
3669 Q6137605 PATHMANATHAN H Y55 Q78 BRIDGE COTTAGE SURGERY 41 HIGH STREET WELWYN HERTFORDSHIRE   AL6 9EF 2008-09-22 00:00:00   1 Q78 2015-04-01 00:00:00   0844 8151413 0
3670 Q6137612 SOOKUN S Y55 Q78 BRIDGE COTTAGE SURGERY 41 HIGH STREET WELWYN HERTFORDSHIRE   AL6 9EF 2008-09-22 00:00:00   1 Q78 2015-04-01 00:00:00   0844 8151413 0
626 Q6106476 EELES RA Y55 Q78 LITTLE BUSH FARM RABLEY HEATH ROAD WELWYN HERTFORDSHIRE   AL6 9UA 2006-04-01 00:00:00   1 Q78 2015-04-01 00:00:00   0777 0985331 0
2494 Q6125620 MCCLAUGHLIN W Y55 Q78 CAMHS,1ST FLOOR 51 BRIDGE ROAD EAST WELWYN GARDEN CITY HERTFORDSHIRE   AL7 1RJ 2006-11-14 00:00:00   1 Q78 2015-04-01 00:00:00   01707 351800 0
6179 Q6163231 PREECE A Y55 Q78 20 LONGLANDS ROAD   WELWYN GARDEN CITY HERTFORDSHIRE   AL7 3QB 2016-06-13 00:00:00   7 Q78 2016-06-13 00:00:00   07776 114847 0
3279 Q6133577 RULE MJ Y55 Q78 PEARTREE LANE SURGERY 110 PEARTREE LANE WELWYN GARDEN CITY HERTFORDSHIRE   AL7 3UJ 2007-12-18 00:00:00   1 Q78 2015-04-01 00:00:00   01707 329292 0
2257 Q6123219 DENT R Y55 Q78 DEPT OF CHEST MEDICINE QE 11 HOSPITAL,HOWLANDS WELWYN GARDEN CITY HERTFORDSHIRE   AL7 4HQ 2006-10-01 00:00:00   1 Q78 2015-04-01 00:00:00   01707 365510 0
2890 Q6129590 TAKON IE Y55 Q78 QE11 HOSPITAL DEPT OF PAEDIATRICS Q66 WELWYN GARDEN CITY HERTFORDSHIRE   AL7 4HQ 2007-05-03 00:00:00   1 Q78 2015-04-01 00:00:00   01707 328111 0
1433 Q6114749 Q58 PRIVATE CD DENTIST Y55 Q78 CHARTER HOUSE PARKWAY WELWYN GARDEN CITY HERTFORDSHIRE   AL8 6JL 2006-07-10 00:00:00   1 Q78 2015-04-01 00:00:00   01707 390855 0
2674 Q6127433 HANAK B Y55 Q78 THE GARDEN CITY PRACTICE 185 KNIGHTSFIELD WELWYN GARDEN CITY HERTFORDSHIRE   AL8 7QG 2007-01-26 00:00:00   1 Q78 2015-04-01 00:00:00   01707 321166 0
3485 Q6135720 O'BRIEN E Y55 Q77 HOCKLEY MEDICAL PRACTICE 60 LION COURT, CARVER ST HOCKLEY BIRMINGHAM   B1 3AL 2008-05-27 00:00:00   1 Q77 2015-04-01 00:00:00   0121 5541757 0
5300 Q6154369 HAGANS JP Y55 Q77 LIVINGSTONE HOUSE 290 MANSEL RD,SMALL HEATH BIRMINGHAM     B10 9NN 2013-10-02 00:00:00   2 Q77 2015-04-01 00:00:00   0121 7534448 0
4563 Q6146845 FLEMING G Y55 Q77 SPRINGFIELD SURGERY 183 WOODLANDS ROAD SPARKHILL BIRMINGHAM   B11 4ER 2011-03-01 00:00:00   1 Q77 2015-04-01 00:00:00   0845 6740072 0
3893 Q6139872 WALJI MTI Y55 Q77 BALSALL HEATH HEALTH CTR 43 EDWARD ROAD BIRMINGHM     B12 9LP 2009-04-08 00:00:00   1 Q77 2015-04-01 00:00:00   0845 0702697 0
2365 Q6124320 ROBERTS KD Y55 Q77 75 REDDINGS ROAD MOSELEY BIRMINGHAM     B13 8LP 2006-10-11 00:00:00   1 Q77 2015-04-01 00:00:00   0121 4491959 0
1953 Q6120113 SUNGUM-PALIWAL S Y55 Q77 PARKVIEW CLINIC 60 QUEENSBRIDGE ROAD MOSELEY, BIRMINGHAM     B13 8QE 2006-08-17 00:00:00   1 Q77 2015-04-01 00:00:00   0121 2432013 0
4640 Q6147640 SPANNUTH F Y55 Q77 KINGSFIELD MEDICAL CENTRE 146 ALCESTER ROAD SOUTH KINGS HEATH     B14 6AA 2011-06-21 00:00:00   1 Q77 2015-04-01 00:00:00   0121 4442054 0
5875 Q6160173 SONSATI MS Y55 Q77 THE OAKTREE CLINIC 52 FREDERICK ROAD EDGBASTON BIRMINGHAM   B15 1HN 2015-07-15 00:00:00   1 Q77 2015-07-15 00:00:00   0121 3140330 0
1937 Q6119926 MCCOLLUM DH Y55 Q77 22 GEORGE ROAD EDGBASTON BIRMINGHAM WORCESTERSHIRE   B15 1PL 2006-08-01 00:00:00   1 Q77 2015-04-01 00:00:00   0121 5444877 0
4288 Q6144018 ACHINIVU KO Y55 Q77 DEPT OF NEUROPSYCHIATRIST THE BARBERRY 25 VINCENT DR, EDGBASTON BIRMINGHAM   B15 2FG 2010-04-30 00:00:00   1 Q77 2015-04-01 00:00:00   0121 3012280 0
6063 Q6162058 THOMAS R Y55 Q77 THE BARBERRY 25 VINCENT DRIVE BIRMINGHAM     B15 2FG 2016-02-24 00:00:00   1 Q77 2016-02-24 00:00:00   0121 3012002 0
5034 Q6151610 CRABBE JM Y55 Q77 BIRMINGHAM MED FACILITY RCDM,QUEEN ELIZABETH HOSP MINDELSOHN WAY BIRMINGHAM   B15 2WB 2012-08-15 00:00:00   1 Q77 2015-04-01 00:00:00   0121 6272550 0
5811 Q6159522 DHARMADHIKARI AR Y55 Q77 CLINICAL PARTNERS BIRMINGHAM MEDICAL INST 36 HARBONE ROAD EDGBASTON, BIRMINGHAM   B15 3AF 2015-05-15 00:00:00   1 Q77 2015-05-15 00:00:00   020 33269160 0
5781 Q6159223 ASHTON WD Y55 Q77 WEIGHT TO GO LTD 3 VICARAGE ROAD EDGBASTON BIRMINGHAM   B15 3ES 2015-04-09 00:00:00   1 Q77 2015-04-09 00:00:00   0121 6934488 0
5823 Q6159649 LOH CC Y55 Q77 CLINICAL PARTNERS CONSULTING ROOMS B'HAM 38 HARBORNE RD, EDGBASTON BIRMINGHAM   B15 3HE 2015-05-15 00:00:00   1 Q77 2015-05-15 00:00:00   0121 4541390 1
1932 Q6119878 JORDAN JA Y55 Q77 20 CHURCH ROAD   EDGBASTON     B15 3TA 2006-08-14 00:00:00   1 Q77 2015-04-01 00:00:00   0121 4542345 0
4615 Q6147389 KAT H Y55 Q77 CC KAT AESTHETICS 49 SHERBORNE STREET BIRMINGHAM     B16 8FN 2011-05-20 00:00:00   1 Q77 2015-04-01 00:00:00   0845 3731818 0
317 Q6103253 PERSICO M Y55 Q77 19 LIBERTY PLACE SHEEPCOTE STREET BIRMINGHAM     B16 8JB 2006-04-01 00:00:00   1 Q77 2015-04-01 00:00:00   07800 798216 0
2296 Q6123628 JOSEPH M Y55 Q77 CROWN HOUSE 123 HAGLEY ROAD,EDGBASTON BIRMINGHAM     B16 8LD 2006-10-03 00:00:00   1 Q77 2015-04-01 00:00:00   0121 6930001 0
1951 Q6120096 FORREST M Y55 Q77 THE KARIS MEDICAL CENTRE WATERWORKS ROAD EDGBASTON, BIRMINGHAM     B16 9AL 2006-08-17 00:00:00   1 Q77 2015-04-01 00:00:00   07753 745974 0
1952 Q6120106 LAIRD MJ Y55 Q77 THE KARIS MEDICAL CENTRE WATERWORKS ROAD EDGBASTON, BIRMINGHAM     B16 9AL 2006-08-17 00:00:00   1 Q77 2015-04-01 00:00:00   0121 4540047 0
6220 Q6163695 SULTAN RAJPUT K Y55 Q77 PERCEPTIVE HEALTHCARE CIBA BUILDING 146 HAGLEY ROAD BIRMINGHAM   B16 9NX 2016-07-21 00:00:00   1 Q77 2016-07-21 00:00:00   07817 225345 0
1876 Q6119304 Q54 PRIVATE CD DENTIST Y55 Q77 BARTHOLOMEW HOUSE 142 HAGLEY ROAD BIRMINGHAM     B16 9PA 2006-08-01 00:00:00   1 Q77 2015-04-01 00:00:00   0121 2244600 0
2297 Q6123635 BATES GDL Y55 Q77 WOODBOURNE PRIORY HOSP. 21 WOODBOURNE ROAD EDGBASTON, BIRMINGHAM     B17 8BY 2006-10-03 00:00:00   1 Q77 2015-04-01 00:00:00   0121 4344343 0
3038 Q6131087 KAHN A Y55 Q77 WOODBOURNE PRIORY HOSP 21 WOODBOURNE ROAD EDGBASTON BIRMINGHAM   B17 8BY 2007-07-03 00:00:00   1 Q77 2015-04-01 00:00:00   0121 4346103 0
3124 Q6131977 VILLA A Y55 Q77 THE WOODBOURNE PRIORY HOS 21 WOODBOURNE ROAD EDGBASTON BIRMINGHAM   B17 8BY 2007-09-14 00:00:00   1 Q77 2015-04-01 00:00:00   0121 4346103 0
3125 Q6131984 SHARMA P Y55 Q77 THE WOODBOURNE PRIORY HOS 21 WOODBOURNE ROAD EDGBASTON BIRMINGHAM   B17 8BY 2007-09-14 00:00:00   1 Q77 2015-04-01 00:00:00   0121 4346103 0
3143 Q6132167 MURALI V Y55 Q77 THE WOODBOURNE PRIORY HPL 21 WOODBOURNE ROAD EDGBASTON, BIRMINGHAM     B17 8BY 2007-09-20 00:00:00   1 Q77 2015-04-01 00:00:00   0121 4346103 0
3225 Q6132992 BROWNELL LW Y55 Q77 WOODBOURNE PRIORY HOSP 21 WOODBOURNE ROAD EDGBASTON BIRMINGHAM   B17 8BY 2007-11-05 00:00:00   1 Q77 2015-04-01 00:00:00   0121 434663 0
3247 Q6133223 JOSEPH R Y55 Q77 WOODBOURNE PRIORY HOSP 21 WOODBOURNE ROAD EDGBASTON BIRMINGHAM   B17 8BY 2007-11-21 00:00:00   1 Q77 2015-04-01 00:00:00   0121 4346103 0
3354 Q6134358 THACHIL OM Y55 Q77 WOODBOURNE PRIORY HOSP 21 WOODBOURNE ROAD EDGBASTON, BIRMINGHAM     B17 8BY 2008-02-08 00:00:00   1 Q77 2015-04-01 00:00:00   0121 4346103 0
4087 Q6141888 LISTER ES Y55 Q77 WOODBOURNE PRIORY HOSP 21 WOODBOURNE ROAD EDGBASTON, BIRMINGHAM     B17 8BY 2009-10-15 00:00:00   1 Q77 2015-04-01 00:00:00   0121 4346103 0
4088 Q6141895 AI GOMMER O Y55 Q77 WOODBOURNE PRIORY HOSP 21 WOODBOURNE ROAD EDGBASTON, BIRMINGHAM     B17 8BY 2009-10-15 00:00:00   1 Q77 2015-04-01 00:00:00   0121 4346103 0
4089 Q6141905 ROBERTSON DN Y55 Q77 WOODBOURNE PRIORY HOSP 21 WOODBOURNE ROAD EDGBASTON, BIRMINGHAM     B17 8BY 2009-10-15 00:00:00   1 Q77 2015-04-01 00:00:00   0121 4346103 0
4191 Q6142944 NASR AARAK Y55 Q77 WOODBOURNE PRIORY HOSP 21 WOODBOURNE ROAD EDGBASTON, BIRMINGHAM     B17 8BY 2010-02-16 00:00:00   1 Q77 2015-04-01 00:00:00   0121 4344343 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 116.139ms · Data source: OUseful Databeat