home / nhsadmin

Private Controlled Drug Prescribers

Data source: OUseful Databeat

6,479 rows sorted by Address Line 1

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
3700 Q6137928 ROBERTS A Y57 Q81   19 STATION ROAD WHYTELEAFE SURREY   CR3 0EP 2008-11-06 00:00:00   1 Q81 2015-04-01 00:00:00   01883 624181 0
3954 Q6140519 WOOD DJC Y57 Q82   70 GREGORIES ROAD BEACONSFIELD BUCKINGHAMSHIRE   HP9 1PS 2009-06-10 00:00:00   1 Q82 2015-04-01 00:00:00   01494 671571 0
977 Q6110037 5HX PRIVATE CD DENTIST Y56 Q71 1 ARMSTRONG WAY   SOUTHALL MIDDLESEX   UB2 4SA 2006-06-01 00:00:00   1 Q71 2013-03-20 00:00:00 2014-06-30 00:00:00 020 33139303 0
4684 Q6148081 RAHMAN TA Y57 Q81 1 CECIL SQUARE   MARGATE KENT   CT9 1BD 2011-08-11 00:00:00   1 Q81 2015-04-01 00:00:00   01843 232222 0
1131 Q6111636 5PR PRIVATE CD DENTIST Y55 Q79 1 COMMON LANE NORTH   BECCLES SUFFOLK   NR34 9BN 2006-07-01 00:00:00   1 Q79 2015-04-01 00:00:00 2015-06-30 00:00:00 01493 856156 0
391 Q6104034 GEORGE CJ Y57 Q81 1 CREVEQUER CHAMBERS 35 HIGH STREET RAINHAM     ME8 7HS 2006-04-01 00:00:00   1 Q81 2015-04-01 00:00:00   01634 231333 0
5351 Q6154905 CHITNAVIS BP Y56 Q71 1 FLOOR ST OLAF HOUSE LONDON BRIDGE HOSPITAL 27-29 TOOLEY STREET LONDON   SE1 2PR 2013-11-25 00:00:00   1 Q71 2013-03-20 00:00:00   0207 2342643 0
710 Q6107336 PORTER RJ Y57 Q81 1 FRANCIS ROAD LINDFIELD   WEST SUSSEX   RH16 2JB 2006-04-01 00:00:00   1 Q81 2015-04-01 00:00:00   01444 483953 0
1048 Q6110769 PATEL M Y56 Q71 1 GLEBE STREET   LONDON     W4 2BD 2006-06-12 00:00:00   1 Q71 2013-03-20 00:00:00 2015-04-20 00:00:00 020 87474800 0
1049 Q6110776 GARDINER C Y56 Q71 1 GLEBE STREET   LONDON     W4 2BD 2006-06-12 00:00:00   1 Q71 2013-03-20 00:00:00 2015-04-20 00:00:00 020 87474800 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
3901 Q6139951 RAY-CHOUDHURI AP Y55 Q76 1 HALL DRIVE   WORKSOP NOTTINGHAMSHIRE   S80 3GB 2009-04-20 00:00:00   1 Q76 2015-04-01 00:00:00 2016-06-01 00:00:00 01909 474154 0
1161 Q6111935 5H1 PRIVATE CD DENTIST Y56 Q71 1 HAMMERSMITH BROADWAY LONDON EALING     W6 9DL 2006-06-01 00:00:00   1 Q71 2013-03-20 00:00:00 2014-06-30 00:00:00 020 88466767 0
799 Q6108227 BIADENE G Y56 Q71 1 HANWAY PLACE   LONDON     W1T 1HA 2006-06-01 00:00:00   1 Q71 2013-03-20 00:00:00 2015-04-20 00:00:00 020 76360366 0
6327 Q6164816 COLASANTI A Y56 Q71 1 HARROWES MEADE   ESGWARE     HA8 8RR 2016-11-16 00:00:00   1 Q71 2013-03-20 00:00:00   07917 134230 0
2486 Q6125541 BARKER J Y56 Q71 1 HAYWARD HOUSE     LONDON   E17 9LP 2006-11-13 00:00:00   1 Q71 2013-03-20 00:00:00 2015-04-20 00:00:00 020 85202184 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
6168 Q6163121 CHAWLA M Y55 Q76 1 HOLMFIELD COURT HOLMFIELD RD, STONEYGATE LEICESTER BURTON-ON-TRENT   LE2 1SD 2016-05-31 00:00:00   1 Q76 2016-05-31 00:00:00   01623 499010 0
4630 Q6147530 HAYTON DM Y55 Q79 1 HUNTINGDON ROAD   CAMBRIDGE     CB3 0DB 2011-06-06 00:00:00   1 Q79 2015-04-01 00:00:00 2017-02-28 00:00:00 01223 277449 1
5804 Q6159450 KATHURIA BS Y54 Q73 1 KNIGHTSBRIDGE CLOSE   WILMSLOW CHESHIRE   SK9 2GQ 2015-05-13 00:00:00   1 Q73 2015-05-13 00:00:00   07976 607167 0
6456 Q6166131 PRICE K Y55 Q78 1 LEAFIELDS HOUGHTON REGIS DUNSTABLE BEDFORDSHIRE   LU5 5LT 2017-04-05 00:00:00   7 Q78 2017-04-05 00:00:00   07404 180381 1
3726 Q6138194 ALEFOUNDER H Y55 Q79 1 LEAS ROAD   COLCHESTER ESSEX   CO2 9PH 2008-12-01 00:00:00   1 Q79 2015-04-01 00:00:00 2017-02-28 00:00:00 01206 364537 1
6052 Q6161947 CRONIN JW Y56 Q71 1 LIME TREE HOUSE CROFT STREET   LONDON   SE8 5DS 2016-02-15 00:00:00   1 Q71 2013-03-20 00:00:00   0770 3302041 0
1429 Q6114701 RALPH HI Y54 Q73 1 MANLEY PARK AVENUE   SALFORD     M7 4BZ 2006-07-14 00:00:00   1 Q73 2015-04-01 00:00:00 2015-11-03 00:00:00 0161 7089436 0
3179 Q6132521 5A3 PRIVATE CD DENTIST Y57 Q80 1 MONARCH COURT EMERALD PARK EMERSONS GREEN SOUTH GLOUCESTERSHIRE   BS16 7FH 2007-09-01 00:00:00   1 Q80 2015-04-01 00:00:00   0117 3300229 0
2318 Q6123848 WARREN JS Y56 Q71 1 NIGHTINGALE ROAD EDMONTON LONDON     N9 8AJ 2006-10-10 00:00:00   1 Q71 2013-03-20 00:00:00 2015-04-20 00:00:00 08444 778933 0
4123 Q6142243 JACOBS L Y55 Q79 1 NORTH STREET   PETERBOROUGH     PE1 2RA 2009-11-25 00:00:00   1 Q79 2015-04-01 00:00:00 2017-02-28 00:00:00 01733 312525 1
4524 Q6146450 FRYER JM Y54 Q73 1 OAKLEAF CLOSE GOOSNARGH PRESTON LANCASHIRE   PR3 2DQ 2011-01-25 00:00:00   1 Q73 2015-04-01 00:00:00 2015-10-27 00:00:00 01772 865175 0
1888 Q6119421 EVANS D Y57 Q81 1 ONSLOW ROAD   HOVE     BN3 6TA 2006-08-01 00:00:00   1 Q81 2015-04-01 00:00:00   01273 502379 0
6240 Q6163891 DENTON O Y55 Q77 1 PARK AVENUE   SOLIHULL WEST MIDLANDS   B91 3EJ 2016-07-28 00:00:00   1 Q77 2016-07-28 00:00:00   01675 489489 0
6241 Q6163901 DENTON A Y55 Q77 1 PARK AVENUE   SOLIHULL WEST MIDLANDS   B91 3EJ 2016-07-28 00:00:00   1 Q77 2016-07-28 00:00:00   01675 489489 0
465 Q6104797 COBB JPH Y56 Q71 1 PARK CLOSE KNIGHTSBRIDGE LONDON     SW1X 7PQ 2006-04-01 00:00:00   1 Q71 2013-04-01 00:00:00   020 75896466 0
1922 Q6119775 5AN PRIVATE CD DENTIST Y54 Q72 1 PRINCE ALBERT GARDENS GRIMSBY NORTH EAST LINCOLNSHIRE     DN31 3HT 2006-08-01 00:00:00   1 Q72 2015-04-01 00:00:00 2016-09-30 00:00:00 01472 302876 0
4946 Q6150736 ANDREWS PD Y57 Q82 1 RIFLES, MEDICAL CENTRE BEACHLEY BARRACKS CHEPSTOW GLOUCESTERSHIRE   NP16 7YG 2012-06-11 00:00:00   1 Q82 2015-04-01 00:00:00   01291 645299 0
1660 Q6117096 YATES FW Y54 Q73 1 RIVINGTON LANE HEADLESS CROSS, ANDERTON CHORLEY LANCASHIRE   PR6 9HQ 2006-07-27 00:00:00   1 Q73 2015-04-01 00:00:00 2014-12-31 00:00:00 01257 483042 0
3544 Q6136336 ROSEN M Y54 Q75 1 SPRAY STREET ST HELENS & KNOWSLEY HOSP       WA10 2NN 2008-08-01 00:00:00   1 Q75 2015-04-01 00:00:00   01744 22006 0
1133 Q6111650 5EM PRIVATE CD DENTIST Y55 Q76 1 STANDARD COURT PARK ROW NOTTINGHAM     NG1 6GN 2006-07-01 00:00:00   1 Q76 2015-04-01 00:00:00 2013-10-31 00:00:00 0115 9123344 0
2661 Q6127309 MISTRY HG Y56 Q71 1 STREATFIELD ROAD KENTON HARROW MIDDLESEX   HA3 9BP 2007-01-18 00:00:00   1 Q71 2013-03-20 00:00:00 2015-04-20 00:00:00 020 89070381 0
1553 Q6115991 5P6 PRIVATE CD DENTIST Y57 Q81 1 THE CAUSEWAY GORING-BY-SEA WORTHING WEST SUSSEX   BN12 6BT 2006-07-01 00:00:00   1 Q81 2015-04-01 00:00:00 2016-06-30 00:00:00 01903 708400 0
3814 Q6139085 SCRATCHERD JA Y54 Q74 1 THE CREST DINNINGTON NEWCASTLE UPON TYNE     NE13 7LU 2009-02-06 00:00:00   1 Q74 2015-04-01 00:00:00 2015-07-31 00:00:00 07730963173 0
1828 Q6118808 REDMAN JH Y57 Q81 1 THE GATEHOUSE SHORTS REACH THE ESPLENADE,ROCHESTER KENT   ME1 1QP 2006-08-07 00:00:00   1 Q81 2015-04-01 00:00:00   01634 843142 0
5201 Q6153306 HALLMARK BW Y57 Q80 1 THE LAWN BUDLEIGH MEDICAL CENTRE BUDLEIGH SALTERTON DEVON   EX9 6LS 2013-03-25 00:00:00   1 Q80 2015-04-01 00:00:00   01395 441200 0
6420 Q6165769 OSNER BG Y55 Q78 1 THE OAKS SCHOOL LANE LUTON     LU4 9GS 2017-02-20 00:00:00   7 Q78 2017-02-20 00:00:00   07512 772365 1
6421 Q6165776 BOSHOFF C Y55 Q78 1 THE OAKS SCHOOL LANE LUTON     LU4 9GS 2017-02-20 00:00:00   7 Q78 2017-02-20 00:00:00   07512 772396 1
1246 Q6112792 HOUSTON AJD Y51 Q33 1 VICARAGE ROAD YARDLEY GOBION TOWCESTER NORTHANTS   NN12 7UN 2006-07-01 00:00:00   1 Q78 2015-04-01 00:00:00   01908 542657 0
897 Q6109235 PERRY J Y57 Q82 1 WHEELERS CLOSE   PEWSEY WILTSHIRE   SN9 5HZ 2006-07-01 00:00:00   1 Q82 2015-04-01 00:00:00   01672 564578 0
3027 Q6130976 CHAPMAN WA Y57 Q81 1 YALDHAM COTTAGES KEMSING ROAD WROTHAM KENT   TN15 6NN 2007-06-16 00:00:00   1 Q81 2015-04-01 00:00:00   07885 951895 0
1456 Q6114990 HARRIS S Y55 Q76 1 YEW CLOSE PRIVATE ROAD SHERWOOD NOTTINGHAM   NG5 4EL 2006-07-01 00:00:00   1 Q76 2015-04-01 00:00:00   0115 9606678 0
4489 Q6146106 TURNER R Y51 Q35 1-2 CONNAUGHT CLOSE CONNAUGHT GARDENS EAST CLACTON-ON-SEA     CO15 6HZ 2010-12-01 00:00:00   1 Q79 2015-04-01 00:00:00   07710 498039 0
2603 Q6126724 REZA H Y56 Q71 1-6 CARLTON PARADE   ORPINGTON KENT   BR6 0JB 2006-12-18 00:00:00   1 Q71 2013-03-20 00:00:00   01689 892300 0
462 Q6104766 DYMOND GS Y56 Q71 10 BENTINCK MANSIONS BENTINCK STREET LONDON     W1U 2ER 2006-04-01 00:00:00   1 Q71 2013-03-20 00:00:00   020 79357678 0
2702 Q6127718 DAWSON PJ Y54 Q75 10 BRIDGE CLINIC MORLEY BRIDGE HOUSE DUNHAM ON THE HILL CHESTER   CH2 4JT 2007-02-05 00:00:00   1 Q75 2015-04-01 00:00:00   01244 530332 0
4633 Q6147561 GHETAU E Y54 Q75 10 DARKIE MEADOW BUNBURY   CHESHIRE   CW6 9RB 2011-07-01 00:00:00   1 Q75 2016-11-01 00:00:00   07549 093164 0
834 Q6108588 COOPER BS Y56 Q71 10 DEVONSHIRE PLACE     LONDON   W1G 6HS 2006-05-03 00:00:00   1 Q71 2013-03-20 00:00:00 2015-04-20 00:00:00 020 79359335 0
2888 Q6129576 PRADHAN AM Y55 Q79 10 ELEVEN ACRE RISE LOUGHTON CHELMSFORD     IG10 1AN 2007-05-01 00:00:00   1 Q79 2015-04-01 00:00:00 2017-02-28 00:00:00 0780 2947435 1
2065 Q6121262 HARLEY SCL Y55 Q79 10 FONNEREAU ROAD IPSWICH       IP7 3JP 2006-09-01 00:00:00   1 Q79 2015-04-01 00:00:00 2017-02-28 00:00:00 01473 217592 1
466 Q6104807 KAY LA Y56 Q71 10 HARLEY STREET LONDON LONDON     W1G 9PF 2006-04-01 00:00:00   1 Q71 2013-03-20 00:00:00   020 74678336 0
839 Q6108636 PHILLIPS KD Y56 Q71 10 HARLEY STREET LONDON LONDON     W1G 9PF 2006-06-01 00:00:00   1 Q71 2013-04-01 00:00:00   020 88680338 0
905 Q6109314 BOYDE TRC Y56 Q71 10 HARLEY STREET   LONDON     W1G 9PF 2006-06-01 00:00:00   1 Q71 2013-03-20 00:00:00 2015-04-20 00:00:00 020 78200098 0
949 Q6109754 NEMETH CH Y56 Q71 10 HARLEY STREET   LONDON     W1G 9PF 2006-06-01 00:00:00   1 Q71 2013-03-20 00:00:00 2015-04-20 00:00:00 020 72862669 0
1939 Q6119964 BASQUILLE JG Y56 Q71 10 HARLEY STREET     LONDON   W1G 9PF 2006-08-18 00:00:00   1 Q71 2013-03-20 00:00:00   020 72860652 0
1968 Q6120261 HAIG J Y56 Q71 10 HARLEY STREET LONDON LONDON     W1G 9PF 2006-08-23 00:00:00   1 Q71 2013-04-01 00:00:00   07929 545712 0
2163 Q6122270 NEWMAN JH Y56 Q71 10 HARLEY STREET   LONDON     W1N 1AA 2006-09-14 00:00:00   1 Q71 2013-03-20 00:00:00   020 74678300 0
2376 Q6124447 COLE P Y56 Q71 10 HARLEY STREET LONDON       W1G 9PF 2006-10-19 00:00:00   1 Q71 2013-04-01 00:00:00   07768 726287 0
3633 Q6137241 BESTER P Y56 Q71 10 HARLEY STREET LONDON LONDON     W1G 9PF 2008-08-26 00:00:00   1 Q71 2013-03-20 00:00:00   020 74678396 0
3987 Q6140849 GREWAL P Y56 Q71 10 HARLEY STREET LONDON       W1G 9PF 2009-06-29 00:00:00   1 Q71 2013-03-20 00:00:00   07799 106348 0
4458 Q6145789 DIMITRIOU C Y56 Q71 10 HARLEY STREET LONDON       W1G 9PF 2010-10-07 00:00:00   1 Q71 2013-03-20 00:00:00   020 74678300 0
4696 Q6148201 CONTELL FN Y56 Q71 10 HARLEY STREET     LONDON   W1G 9PF 2011-08-19 00:00:00   1 Q71 2013-03-20 00:00:00   020 71250114 0
4844 Q6149697 DOSANI S Y56 Q71 10 HARLEY STREET LONDON HOUNSLOW     W1G 9PF 2012-01-23 00:00:00   1 Q71 2013-03-20 00:00:00 2015-04-20 00:00:00 020 74678301 0
5851 Q6159924 ABDELGHANI MI Y56 Q71 10 HARLEY STREET     LONDON   W1G 9PF 2015-06-26 00:00:00   1 Q71 2013-03-20 00:00:00   020 74671536 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
5188 Q6153179 CLARK A Y54 Q74 10 HILL MEADOWS HIGH SHINCLIFFE DURHAM     DH1 2PE 2013-02-20 00:00:00   1 Q74 2015-04-01 00:00:00   0191 3865663 0
6266 Q6164153 FOWLES LC Y55 Q78 10 LONGLEES MAPLE CROSS RICKMANSWORTH HERTFORDSHIRE   WD3 9UQ 2016-09-09 00:00:00   7 Q78 2016-09-09 00:00:00   07753 612422 0
5952 Q6160946 MILLER R Y55 Q79 10 ORCHARD ROAD   MALDON ESSEX   CM9 6EP 2015-10-01 00:00:00   7 Q79 2015-10-01 00:00:00 2017-02-28 00:00:00 07818 058687 1
5825 Q6159663 LEWIS LB Y55 Q79 10 PARADE WALK   SHOEBURYNESS ESSEX   SS3 9GE 2015-07-01 00:00:00   1 Q79 2015-07-01 00:00:00   0773 9539344 0
822 Q6108454 GORDON A Y56 Q71 10 PRINCES MEWS NOTTING HILL LONDON     W2 4NX 2006-06-01 00:00:00   1 Q71 2013-04-01 00:00:00   020 72435536 0
3797 Q6138912 BARLEY M Y57 Q81 10 QUEEN ALEXANDRA AVE   HOVE     BN3 6XH 2009-01-22 00:00:00   1 Q81 2015-04-01 00:00:00   01273 506360 0
2114 Q6121767 CURRY S Y56 Q71 10 RIVERINE LODGE OLD LODGE WAY STANMORE MIDDLESEX   HA7 3BE 2006-09-07 00:00:00   1 Q71 2013-03-20 00:00:00 2015-04-20 00:00:00 020 89549972 0
5237 Q6153708 THOMAS M Y57 Q80 10 SILVERDALE ROAD   CHORLTON MANCHESTER   M21 0SH 2013-06-26 00:00:00   1 Q80 2015-04-01 00:00:00   0161 8818176 0
3347 Q6134286 WOOTLIFF AB Y56 Q71 10 ST.REGIS HEIGHTS FIRECREST DRIVE   LONDON   NW3 7NE 2008-02-06 00:00:00   1 Q71 2013-03-20 00:00:00 2015-04-20 00:00:00 020 74331440 0
5417 Q6155573 GRIESZ-BRISSON M Y56 Q71 100 HARLEY STREET     LONDON   W1G 7JA 2014-03-04 00:00:00   1 Q71 2013-03-20 00:00:00   020 74867010 0
5598 Q6157393 GRIMWOOD JW Y55 Q79 100 PAGET ROAD TRUMPINGTON CAMBRIDGE     CB2 9JH 2014-08-28 00:00:00   7 Q79 2015-04-01 00:00:00 2017-02-28 00:00:00 07776 256257 1
1200 Q6112338 SMITH RR Y55 Q77 100 YEWTREE LANE   SOLIHULL WEST MIDLANDS   B91 2RA 2006-07-07 00:00:00   1 Q77 2015-04-01 00:00:00   0121 7058787 0
1201 Q6112345 NAYLOR CR Y55 Q77 100 YEWTREE LANE   SOLIHULL WEST MIDLANDS   B91 2RA 2006-07-07 00:00:00   1 Q77 2015-04-01 00:00:00   0121 7058787 0
1202 Q6112352 LALL GS Y55 Q77 100 YEWTREE LANE   SOLIHULL WEST MIDLANDS   B91 2RA 2006-07-07 00:00:00   1 Q77 2015-04-01 00:00:00   0121 7058787 0
1203 Q6112369 CROFT JA Y55 Q77 100 YEWTREE LANE   SOLIHULL WEST MIDLANDS   B91 2RA 2006-07-07 00:00:00   1 Q77 2015-04-01 00:00:00   0121 7058787 0
5518 Q6156598 ALI Z Y54 Q73 101 DOWNHAM CRESCENT PRESTWICH MANCHESTER     M25 0BG 2014-06-27 00:00:00   1 Q73 2015-04-01 00:00:00 2015-07-15 00:00:00 07968 828729 0
801 Q6108241 COXON AY Y56 Q71 101 HARLEY STREET LONDON LONDON     W1G 6AH 2006-06-01 00:00:00   1 Q71 2013-03-20 00:00:00   020 74862534 0
5590 Q6157317 GOULD D Y56 Q71 101 HARLEY STREET     LONDON   W1G 6AH 2014-08-26 00:00:00   1 Q71 2013-03-20 00:00:00   020 75639865 0
4160 Q6142614 HASAN MR Y57 Q80 101 SOUTHWAY DRIVE   YEOVIL SOMERSET   BA21 3EB 2010-01-12 00:00:00   1 Q80 2015-04-01 00:00:00   01935 426602 0
5190 Q6153193 GREENE K Y54 Q74 102 MAIN STREET   ST BEES CUMBRIA   CA27 0AD 2013-02-27 00:00:00   1 Q74 2015-04-01 00:00:00   01946 824302 0
6410 Q6165666 OATES J Y54 Q75 103 POWDER MILL ROAD LATCHFORD WARRINGTON CHESHIRE   WA4 1GB 2017-02-07 00:00:00   1 Q75 2017-02-07 00:00:00   07545 475189 1
1717 Q6117687 RIDHA MH Y56 Q71 104 EDGWARE ROAD     LONDON   W2 2EA 2006-08-01 00:00:00   1 Q71 2013-04-01 00:00:00   020 77238711 0
2499 Q6125675 BIALAS I Y56 Q71 104 HARLEY STREET LONDON HAMMERSMITH BRIDGE ROAD     W1G 7JD 2006-11-13 00:00:00   1 Q71 2013-03-20 00:00:00   020 79356554 0
6244 Q6163932 ALAM K Y56 Q71 104 HARLEY STREET     LONDON   W1G 7JD 2016-08-11 00:00:00   1 Q71 2013-03-20 00:00:00   020 79356554 0
4865 Q6149903 O'NEILL R Y55 Q79 105 CHAPEL STREET   BILLERICAY ESSEX   CM12 9LR 2012-02-01 00:00:00   1 Q79 2015-04-01 00:00:00   01277 658895 0
1142 Q6111746 JONES EM Y56 Q71 1052-1054 HIGH ROAD CHADWELL HEATH       RM6 4BB 2006-07-01 00:00:00   1 Q71 2013-03-20 00:00:00 2015-04-20 00:00:00 020 85990040 0
4979 Q6151067 ABOTHER M Y56 Q71 1052-1054 HIGH ROAD CHADWELL HEATH ROMFORD ESSEX   RM6 4BB 2012-06-21 00:00:00   1 Q71 2013-03-20 00:00:00   020 85990040 0
461 Q6104759 FITZGERALD-O'CONNOR AF Y56 Q71 106 HARLEY STREET   LONDON     W1G 6JE 2006-04-01 00:00:00   1 Q71 2013-04-01 00:00:00   020 79350646 0
6130 Q6162735 ABBAS M Y56 Q71 107-109 GLOUCESTER ROAD     LONDON   SW7 4SS 2016-05-03 00:00:00   3 Q71 2013-03-20 00:00:00   020 73734445 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.903ms · Data source: OUseful Databeat