home / nhsadmin

Private Controlled Drug Prescribers

Data source: OUseful Databeat

6,479 rows sorted by Name

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
3480 Q6135665 12L PRIVATE CD DENTIST Y54 Q75 REGATTA PLACE BRUNSWICK BUSINESS PARK SUMMERS ROAD LIVERPOOL   L3 4BL 2008-06-01 00:00:00   1 Q75 2015-04-01 00:00:00   0151 2854802 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
2092 Q6121547 5A4 PRIVATE CD DENTIST Y56 Q71 ST GEORGES HOSPITAL 117 SUTTONS LANE HORNCHURCH ESSEX   RM12 6RS 2006-09-01 00:00:00   1 Q71 2013-03-20 00:00:00 2014-06-30 00:00:00 01708 465266 0
2280 Q6123460 5A5 PRIVATE CD DENTIST Y56 Q71 HOLLYFIELD HOUSE 22 HOLLYFIELD ROAD SURBITON SURREY   KT5 9AL 2006-09-01 00:00:00   1 Q71 2013-03-20 00:00:00 2014-06-30 00:00:00 020 8339800 0
4529 Q6146508 5A7 PRIVATE CD DENTIST Y56 Q71 1ST FLOOR SUMMIT HOUSE, GLEBE WAY WEST WICKHAM     BR4 0RJ 2011-01-01 00:00:00   1 Q71 2013-03-20 00:00:00 2014-06-30 00:00:00 01689 880701 0
4477 Q6145985 5A8 PRIVATE CD DENTIST Y56 Q71 31-37 GREENWICH PARK ST   GREENWICH LONDON   SE10 9LR 2010-11-10 00:00:00   1 Q71 2013-03-20 00:00:00 2014-06-30 00:00:00 020 82936700 0
3026 Q6130969 5A9 PRIVATE CD DENTIST Y56 Q71 WESTGATE HOUSE ECH, BURNT OAK BROADWAY EDGWARE MIDDLESEX   HA8 0AD 2007-07-01 00:00:00   1 Q71 2013-03-20 00:00:00 2014-06-30 00:00:00 020 89522381 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
3030 Q6131001 5AT PRIVATE CD DENTIST Y56 Q71 KIRK HOUSE 97-109 HIGH STREET YIEWSLEY, WEST DRAYTON MIDDLESEX   UB7 7HJ 2007-06-01 00:00:00   1 Q71 2013-03-20 00:00:00 2014-06-30 00:00:00 01895 452000 0
2122 Q6121846 5C1 PRIVATE CD DENTIST Y56 Q71 HOLBROOK HOUSE COCKFOSTERS ROAD BARNET HERTFORDSHIRE   EN4 0DR 2006-09-01 00:00:00   1 Q71 2013-03-20 00:00:00 2014-06-30 00:00:00 020 82725726 0
2093 Q6121554 5C2 PRIVATE CD DENTIST Y56 Q71 THE CLOCK HOUSE EAST STREET BARKING ESSEX   IG11 8EY 2006-09-01 00:00:00   1 Q71 2013-03-20 00:00:00 2014-06-30 00:00:00 020 85326385 0
2081 Q6121420 5C3 PRIVATE CD DENTIST Y56 Q71 ST.LEONARDS   NUTTALL STREET LONDON   N1 5LZ 2006-09-01 00:00:00   1 Q71 2013-03-20 00:00:00 2014-06-30 00:00:00 020 76834000 0
2082 Q6121437 5C4 PRIVATE CD DENTIST Y56 Q71 ANEURIN BEVAN HOUSE 81-91 COMMERCIAL ROAD   LONDON   E1 1RD 2006-09-01 00:00:00   1 Q71 2013-03-20 00:00:00 2014-06-30 00:00:00 020 70925000 0
2085 Q6121468 5C5 PRIVATE CD DENTIST Y56 Q71 WAREHOUSE K 2 WESTERN GATEWAY ROYAL VICTORIA DOCK LONDON   E16 1DR 2006-09-01 00:00:00   1 Q71 2013-03-20 00:00:00 2014-06-30 00:00:00 020 70596900 0
3535 Q6136240 5C9 PRIVATE CD DENTIST Y56 Q71 ST ANN'S HOSPITAL ST ANN'S ROAD TOTTENHAM LONDON   N15 3TH 2008-07-07 00:00:00   1 Q71 2013-03-20 00:00:00 2014-06-30 00:00:00 020 84426854 0
2267 Q6123312 5CC PRIVATE CD DENTIST Y54 Q73 GUIDE BUSINESS CENTRE SCHOOL LANE BLACKBURN     BB1 2QH 2006-10-01 00:00:00   1 Q73 2015-11-01 00:00:00 2015-12-17 00:00:00 01254 267000 0
2178 Q6122421 5CN PRIVATE CD DENTIST Y55 Q77 VAUGHAN BUILDING RUCKHALL LANE, BELMONT HEREFORD     HR2 9RP 2006-09-01 00:00:00   1 Q77 2015-04-01 00:00:00 2013-10-31 00:00:00 01432 344344 0
4004 Q6141015 5D700 PRIVATE CD DENTIST Y54 Q74 BEVAN HSE,1 ESH PLAZA SIR B ROBSON WAY,GREAT PK NEWCASTLE UPON TYNE     NE13 9BA 2009-07-27 00:00:00   1 Q74 2015-04-01 00:00:00 2014-05-31 00:00:00 0191 2172500 0
981 Q6110075 5D8 PRIVATE CD DENTIST Y54 Q74 12 HEDLEY CT ORION BS PK TYNE TUNNEL TRADING EST NORTH SHIELDS TYNE & WEAR   NE29 7ST 2006-06-01 00:00:00   1 Q74 2015-04-01 00:00:00 2014-05-31 00:00:00 0191 2919292 0
4954 Q6150815 5D9 PRIVATE CD DENTIST Y54 Q74 RIVERSIDE HOUSE HIGH FORCE ROAD RIVERSIDE PARK MIDDLESBROUGH   TS2 1RH 2012-06-15 00:00:00   1 Q74 2015-04-01 00:00:00 2014-05-31 00:00:00 01642 746908 0
2127 Q6121891 5E1 PRIVATE CD DENTIST Y54 Q74 TOWR HOUSE TEESDALE SOUTH THORNABY PLACE, THORNABY STOCKTON ON TEES   TS17 6SF 2006-09-01 00:00:00   1 Q74 2015-04-01 00:00:00 2014-05-31 00:00:00 01642 352297 0
2048 Q6121066 5EF PRIVATE CD DENTIST Y54 Q72 HEALTH PLACE WRAWBY ROAD BRIGG NORTH LINCOLNSHIRE   DN20 8GS 2006-09-01 00:00:00   1 Q72 2015-04-01 00:00:00 2016-09-30 00:00:00 01652 601248 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
2285 Q6123518 5ET PRIVATE CD DENTIST Y54 Q51 RETFORD HOSPITAL NORTH ROAD RETFORD NOTTINGHAMSHIRE   DN22 7XF 2006-10-04 00:00:00 2014-08-31 00:00:00 1 Q51 2013-04-01 00:00:00 2014-08-31 00:00:00 01777 274400 0
1635 Q6116844 5F1 PRIVATE CD DENTIST Y57 Q80 BUILDING ONE BREST ROAD PLYMOUTH     PL6 5QZ 2006-07-07 00:00:00   1 Q80 2015-04-01 00:00:00 2014-07-31 00:00:00 01752 434111 0
2058 Q6121176 5FE PRIVATE CD DENTIST Y57 Q70 ST JAMES' HOSPITAL LOCKSWAY ROAD, MILTON PORTSMOUTH HAMPSHIRE   PO4 8LD 2006-08-30 00:00:00   1 Q70 2013-04-01 00:00:00 2013-10-31 00:00:00 02392 822444 0
2464 Q6125321 5FL PRIVATE CD DENTIST Y57 Q82 TRUST HQ,ST MARTIN'S HOSP CLARA CROSS LANE BATH     BA2 5RP 2006-11-01 00:00:00   1 Q82 2015-04-01 00:00:00 2013-11-30 00:00:00 01225 831800 0
2212 Q6122768 5FX PRIVATE CD DENTIST Y52 Q39 TRUST HEADQUARTERS PRIORY HEALTH CENTRE GLASTONBURY ROAD WELLS   BA5 1XL 2006-09-01 00:00:00   1 Q80 2015-04-01 00:00:00   01749 836500 0
2255 Q6123192 5GC PRIVATE CD DENTIST Y55 Q78 NIGHTINGALE HOUSE 94 INKERMAN STREET LUTON     LU1 1JD 2006-10-01 00:00:00   1 Q78 2015-04-01 00:00:00 2013-12-31 00:00:00 01582 532016 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
2363 Q6124306 5H8 PRIVATE CD DENTIST Y54 Q51 OAK HOUSE MOORHEAD WAY, BRAMLEY ROTHERHAM NOTTINGHAMSHIRE   S66 1YY 2006-10-16 00:00:00 2014-08-31 00:00:00 1 Q51 2013-04-01 00:00:00 2014-08-31 00:00:00 01709 302000 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
990 Q6110161 5HY PRIVATE CD DENTIST Y56 Q71 SOVEREIGN COURT 15-21 STAINES ROAD HOUNSLOW MIDDLESEX   TW3 3HR 2006-05-01 00:00:00   1 Q71 2013-03-20 00:00:00 2014-06-30 00:00:00 020 86301000 0
2580 Q6126494 5J2 PRIVATE CD DENTIST Y54 Q75 930-932 BIRCHWOOD BLVD MILLENNIUM PARK,BIRCHWOOD WARRINGTON MACCLESFIELD   WA3 7QN 2006-12-01 00:00:00   1 Q75 2015-04-01 00:00:00 2013-10-31 00:00:00 01925 843600 0
4310 Q6144252 5J9 PRIVATE CD DENTIST Y54 Q74 DR PIPER HOUSE KING STREET DARLINGTON COUNTY DURHAM   DL3 6JL 2010-05-21 00:00:00   1 Q74 2015-04-01 00:00:00 2014-05-31 00:00:00 0191 3011300 0
4161 Q6142621 5JE PRIVATE CD DENTIST Y54 Q51 KENDRAY HOSPITAL DONCASTER ROAD   SOUTH YORKSHIRE   S70 3RD 2010-01-01 00:00:00 2014-08-31 00:00:00 1 Q51 2013-04-01 00:00:00 2014-08-31 00:00:00 01226 434242 0
1274 Q6113085 5K3 PRIVATE CD DENTIST Y57 Q82 N.SWINDON DISTRICT CENTRE THAMESDOWN DRIVE SWINDON     SN25 4AN 2006-07-01 00:00:00   1 Q82 2015-04-01 00:00:00 2013-11-30 00:00:00 01793 708700 0
2116 Q6121781 5K5 PRIVATE CD DENTIST Y56 Q71 BRENT TEACHING PCT WEMBLEY CTR HEALTH & CARE 116 CHAPLIN ROAD WEMBLEY, MIDDLESEX   HA0 4UZ 2006-09-01 00:00:00   1 Q71 2013-03-20 00:00:00 2014-06-30 00:00:00 020 87957430 0
2073 Q6121341 5K7 PRIVATE CD DENTIST Y56 Q71 4TH FLOOR, EAST WING ST PANCRAS HOSPITAL 4 ST PANCRAS WAY LONDON   NW1 0PE 2006-09-01 00:00:00   1 Q71 2013-03-20 00:00:00 2014-06-30 00:00:00 020 33173500 0
2007 Q6120656 5K9 PRIVATE CD DENTIST Y56 Q71 LEON HOUSE 233 HIGH STREET CROYDON KENT   CR0 9XT 2006-08-01 00:00:00   1 Q71 2013-03-20 00:00:00 2014-06-30 00:00:00 020 82746000 0
3824 Q6139188 5KF00 PRIVATE CD DENTIST Y54 Q74 TEAM VIEW,5TH AVE BUS PK TEAM VALLEY TRADING EST GATESHEAD     NE11 0NB 2009-02-16 00:00:00   1 Q74 2015-04-01 00:00:00 2014-05-31 00:00:00 0191 4915713 0
2377 Q6124454 5KL PRIVATE CD DENTIST Y54 Q74 PEMBERTON HSE COLIMA AVE SUNDERLAND ENTERPRISE PK SUNDERLAND TYNE & WEAR   SR5 3XB 2006-10-01 00:00:00   1 Q74 2015-04-01 00:00:00 2014-05-31 00:00:00 0191 5297000 0
4374 Q6144922 5KM00 PRIVATE CD DENTIST Y54 Q74 RIVERSIDE HOUSE H/FORCE ROAD,RIVERSIDE PK MIDDLESBROUGH     TS2 1RH 2010-07-28 00:00:00   1 Q74 2015-04-01 00:00:00 2014-05-31 00:00:00 01642 352533 0
2057 Q6121169 5L1 PRIVATE CD DENTIST Y57 Q70 OAKLEY ROAD MILLBROOK SOUTHAMPTON HAMPSHIRE   SO16 4GX 2006-08-30 00:00:00   1 Q70 2013-04-01 00:00:00 2013-10-31 00:00:00 02380 296904 0
1532 Q6115771 5L3 PRIVATE CD DENTIST Y57 Q81 TRUST HEADQUARTERS 7-8 AMBLEY GREEN GILLINGHAM BUSINESS PARK KENT   ME8 0NJ 2006-07-01 00:00:00   1 Q81 2015-04-01 00:00:00 2014-03-31 00:00:00 01634 382777 0
1929 Q6119847 5LA PRIVATE CD DENTIST Y56 Q71 PRESCRIBING AND CPD TEAM ST CHARLES HOSPITAL COURTFIELD HSE, EXMOOR ST LONDON   W10 6DZ 2006-08-17 00:00:00   1 Q71 2013-03-20 00:00:00 2014-06-30 00:00:00 020 83836204 0
978 Q6110044 5LC PRIVATE CD DENTIST Y56 Q71 15 MARYLEBONE ROAD   LONDON     NW1 5JD 2006-06-01 00:00:00   1 Q71 2013-03-20 00:00:00 2014-06-30 00:00:00 020 71508000 0
4917 Q6150437 5LE PRIVATE CD DENTIST Y56 Q71 160 TOOLEY STREET     LONDON   SE1 2TZ 2012-04-23 00:00:00   1 Q71 2013-03-20 00:00:00 2014-06-30 00:00:00 020 75250400 0
1427 Q6114684 5LG PRIVATE CD DENTIST Y56 Q71 WIMBLEDON BRIDGE HOUSE 3RD FLOOR, HARTFIELD ROAD WIMBLEDON LONDON   SW19 3RU 2006-07-14 00:00:00   1 Q71 2013-03-20 00:00:00 2014-06-30 00:00:00 020 88127600 0
2258 Q6123226 5LQ PRIVATE CD DENTIST Y57 Q81 LEVEL 4, LANCHESTER HOUSE TRAFALGAR PLACE BRIGHTON MIDDLESE   BN1 4FU 2006-10-01 00:00:00   1 Q81 2015-04-01 00:00:00 2016-06-30 00:00:00 01273 574699 0
1565 Q6116129 5M1 PRIVATE CD DENTIST Y55 Q77 TRIPLEX HOUSE ECKERSALL RD,KINGS NORTON BIRMINGHAM     B38 8SS 2006-07-01 00:00:00   1 Q77 2015-04-01 00:00:00 2014-05-31 00:00:00 0121 4658000 0
2590 Q6126597 5M2 PRIVATE CD DENTIST Y55 Q76 WILLIAM FARR HOUSE MYTTON OAK ROAD SHREWSBURY SHROPSHIRE   SY3 8XL 2006-12-01 00:00:00   1 Q76 2015-04-01 00:00:00   01743 261469 0
2170 Q6122342 5M6 PRIVATE CD DENTIST Y56 Q71 THAMES HOUSE 180 HIGH STREET TEDDINGTON MIDDLESEX   TW11 8HU 2006-09-01 00:00:00   1 Q71 2013-03-20 00:00:00 2014-06-30 00:00:00 020 89733000 0
1507 Q6115520 5M7 PRIVATE CD DENTIST Y56 Q71 NELSON HOSPITAL KINGSTON ROAD RAYNES PARK LONDON   SW20 8DB 2006-07-01 00:00:00   1 Q71 2013-03-20 00:00:00 2014-06-30 00:00:00 020 82510565 0
3338 Q6134190 5M8 PRIVATE CD DENTIST Y57 Q80 WAVERLEY HOUSE OLD CHURCH ROAD CLEVEDON NORTH SOMERSET   BS21 6NN 2008-02-11 00:00:00   1 Q80 2015-04-01 00:00:00   01275 546708 0
2286 Q6123525 5MD PRIVATE CD DENTIST Y55 Q77 CHRISTCHURCH HOUSE GREYFRIARS LANE COVENTRY     CV1 2GQ 2006-10-01 00:00:00   1 Q77 2015-04-01 00:00:00 2013-10-31 00:00:00 024 76553344 0
3213 Q6132875 5MK PRIVATE CD DENTIST Y55 Q76 HALESFIELD 6 TELFORD SHROPSHIRE     TF7 4BF 2007-11-01 00:00:00   1 Q76 2015-04-01 00:00:00   01952 580300 0
4761 Q6148854 5N2 PRIVATE CD DENTIST Y54 Q72 BROAD LEA HOUSE BRADLEY BUSINESS PARK DYSON WOOD WAY, BRADLEY HUDDERSFIELD   HD2 1GZ 2011-10-28 00:00:00   1 Q72 2015-04-01 00:00:00 2014-01-31 00:00:00 01484 464000 0
2291 Q6123570 5N4 PRIVATE CD DENTIST Y54 Q51 722 PRINCE OF WALES ROAD   SHEFFIELD NOTTINGHAMSHIRE   S9 4EU 2006-10-04 00:00:00 2014-08-31 00:00:00 1 Q51 2013-04-01 00:00:00 2014-08-31 00:00:00 0114 3051000 0
1331 Q6113683 5N5 PRIVATE CD DENTIST Y54 Q51 WHITE ROSE HOUSE TEN POUND WALK DONCASTER     DN4 5DJ 2006-07-01 00:00:00 2014-08-31 00:00:00 1 Q51 2013-04-01 00:00:00 2014-08-31 00:00:00 01302 565656 0
2454 Q6125228 5N7 PRIVATE CD DENTIST Y55 Q76 DERWENT COURT 1 STUART STREET DERBY     DE1 2FZ 2006-11-01 00:00:00   1 Q76 2015-04-01 00:00:00 2013-10-31 00:00:00 01332 224000 0
2103 Q6121657 5N8 PRIVATE CD DENTIST Y55 Q76 BIRCH HSE,RANSOMWOOD B/PK SOUTHWELL ROAD WEST MANSFIELD NOTTINGHAMSHIRE   NG21 0HJ 2006-09-05 00:00:00   1 Q76 2015-04-01 00:00:00 2013-10-31 00:00:00 01623 673427 0
1132 Q6111643 5NA PRIVATE CD DENTIST Y56 Q71 BECKETTS HOUSE 2-14 ILFORD HILL ILFORD ESSEX   IG1 2QX 2006-07-01 00:00:00   1 Q71 2013-03-20 00:00:00 2014-06-30 00:00:00 020 84785151 0
2086 Q6121475 5NC PRIVATE CD DENTIST Y56 Q71 KIRKDALE HOUSE 7 KIRKDALE ROAD LEYTONSTONE LONDON   E11 1HP 2006-09-01 00:00:00   1 Q71 2013-03-20 00:00:00 2014-06-30 00:00:00 020 84308000 0
3401 Q6134839 5ND PRIVATE CD DENTIST Y54 Q74 JOHN SNOW HOUSE DURHAM UNIV SCIENCE PARK DURHAM     DH1 3YG 2008-03-18 00:00:00   1 Q74 2015-04-01 00:00:00 2014-05-31 00:00:00 0191 3011300 0
1710 Q6117618 5NE PRIVATE CD DENTIST Y54 Q74 WAVELL DRIVE ROSEHILL BUSINESS PARK CARLISLE PENRITH   CA1 2SE 2006-07-07 00:00:00   1 Q74 2015-04-01 00:00:00 2014-05-31 00:00:00 01228 603500 0
2632 Q6127017 5NF PRIVATE CD DENTIST Y54 Q73 DERBY ROAD   WESHAM,PRESTON LANCASHIRE   PR4 3AL 2007-01-08 00:00:00   1 Q73 2015-11-01 00:00:00 2015-12-17 00:00:00 01253 303157 0
2124 Q6121860 5NG PRIVATE CD DENTIST Y54 Q73 JUBILEE HOUSE LANCASHIRE E/PRISE BUS PK CENTURION WAY LEYLAND   PR26 6TR 2006-09-01 00:00:00   1 Q73 2015-11-01 00:00:00 2015-12-17 00:00:00 01772 644400 0
1160 Q6111928 5NH PRIVATE CD DENTIST Y54 Q73 4TH FL,3 PICCADILLY PLACE LONDON ROAD MANCHESTER     M1 3BN 2006-07-01 00:00:00   1 Q73 2015-04-01 00:00:00   0113 8255216 0
3627 Q6137186 5NK PRIVATE CD DENTIST Y54 Q75 OLD MARKET HOUSE HAMILTON STREET BIRKENHEAD     CH41 5FL 2008-09-01 00:00:00   1 Q75 2015-04-01 00:00:00 2013-10-31 00:00:00 0151 6510011 0
2414 Q6124825 5NL PRIVATE CD DENTIST Y54 Q75 MONTROSE BUSINESS PARK UNIT 2 , TATTERSALL WAY LIVERPOOL     L7 9NB 2006-10-26 00:00:00   1 Q75 2015-04-01 00:00:00 2013-08-31 00:00:00 0151 3008093 0
2088 Q6121499 5NN PRIVATE CD DENTIST Y54 Q75 1829 BUILDING COUNTESS OF CHESTER HEALTH PARK, LIVERPOOL ROAD, CHESTER   CH2 1HJ 2006-09-01 00:00:00   1 Q75 2015-04-01 00:00:00 2013-10-31 00:00:00 01244 650363 0
2089 Q6121516 5NP PRIVATE CD DENTIST Y54 Q75 UNIVERSAL HOUSE ERF WAY, OFF POCHIN WAY MIDDLEWICH CHESHIRE   CW10 0QJ 2006-09-01 00:00:00   1 Q75 2015-04-01 00:00:00 2013-10-31 00:00:00 01606 275303 0
2760 Q6128290 5NX PRIVATE CD DENTIST Y54 Q72 THE MALTINGS SILVESTER SQUARE SILVESTER STREET, HULL     HU1 3HA 2007-02-01 00:00:00   1 Q72 2015-04-01 00:00:00 2016-09-30 00:00:00 01482 344897 0
2861 Q6129301 5NY PRIVATE CD DENTIST Y54 Q72 DOUGLAS MILL BOWLING OLD LANE BRADFORD     BD5 7JR 2007-05-01 00:00:00   1 Q72 2015-04-01 00:00:00 2014-01-31 00:00:00 0845 1115000 0
4047 Q6141486 5P1 PRIVATE CD DENTIST Y55 Q79 HARCOURT HOUSE HARCOURT AVENUE SOUTHEN ON SEA ESSEX   SS2 6HE 2009-09-17 00:00:00   1 Q79 2015-04-01 00:00:00 2015-12-31 00:00:00 01702 224600 0
2123 Q6121853 5P2 PRIVATE CD DENTIST Y55 Q78 BEDFORDSHIRE PCT GILBERT HITCHCOCK HOUSE 21 KIMBOLTON ROAD BEDFORD   MK40 2AW 2006-09-01 00:00:00   1 Q78 2015-04-01 00:00:00 2013-12-31 00:00:00 01525 631153 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
3590 Q6136800 5P7 PRIVATE CD DENTIST Y57 Q81 36-38 FRIARS WALK LEWES EAST SUSSEX     BN7 2BA 2008-07-30 00:00:00   1 Q81 2015-04-01 00:00:00 2016-06-30 00:00:00 01273 485300 0
1613 Q6116624 5P9 PRIVATE CD DENTIST Y57 Q81 WHARF HOUSE MEDWAY WHARF ROAD TONBRIDGE KENT   TN9 1RE 2006-07-01 00:00:00   1 Q81 2015-04-01 00:00:00 2014-03-31 00:00:00 01732 375200 0
2384 Q6124526 5PA PRIVATE CD DENTIST Y55 Q78 LAKESIDE HOUSE 4 SMITH WAY, GROVE PARK ENDERBY, LEICESTER     LE19 1SS 2006-10-01 00:00:00   1 Q78 2015-04-01 00:00:00 2014-03-31 00:00:00 0116 2957500 0
2402 Q6124708 5PC PRIVATE CD DENTIST Y55 Q78 ST JOHN'S HOUSE 30 EAST STREET LEICESTER     LE1 6NB 2006-10-25 00:00:00   1 Q78 2015-04-01 00:00:00 2014-03-31 00:00:00 0116 2951400 0
1362 Q6114017 5PD PRIVATE CD DENTIST Y55 Q78 FRANCIS CRICK HOUSE SUMMERHOUSE RD,MOULTON PK NORTHAMPTON HERTFORDSHIRE   NN3 6BF 2006-07-01 00:00:00   1 Q78 2015-04-01 00:00:00 2013-12-31 00:00:00 01604 651100 0
3001 Q6130701 5PE PRIVATE CD DENTIST Y55 Q77 DUDLEY PCT HEADQUARTERS ST JOHN'S HOUSE UNION STREET, DUDLEY WEST MIDLANDS   DY2 8PP 2007-06-01 00:00:00   1 Q77 2015-04-01 00:00:00 2014-05-31 00:00:00 01384 366111 0
2290 Q6123563 5PG PRIVATE CD DENTIST Y55 Q77 WATERLINKS HOUSE RICHARD STREET BIRMINGHAM     B7 4AA 2006-10-01 00:00:00   1 Q77 2015-04-01 00:00:00 2014-05-31 00:00:00 0121 3809199 0
4011 Q6141091 5PH PRIVATE CD DENTIST Y55 Q76 MORSTON HOUSE THE MIDWAY NEWCASTLE-UNDER-LYME STAFFORDSHIRE   ST5 1QG 2009-07-31 00:00:00   1 Q76 2015-04-01 00:00:00   0845 6026772 0
2254 Q6123185 5PJ PRIVATE CD DENTIST Y55 Q76 HERBERT MINTON BUILDING 79 LONDON ROAD,STOKE STOKE ON TRENT STAFFORDSHIRE   ST4 7PZ 2006-10-01 00:00:00   1 Q76 2015-04-01 00:00:00   01782 744444 0
1205 Q6112383 5PK PRIVATE CD DENTIST Y55 Q76 ANGLESEY HOUSE TOWERS BUSINESS PARK RUGELEY     WS15 1UZ 2006-07-01 00:00:00   1 Q76 2015-04-01 00:00:00   01889 571700 0
1892 Q6119469 5PM PRIVATE CD DENTIST Y55 Q77 WESTGATE HOUSE MARKET STREET WARWICK     CV34 4DE 2006-08-01 00:00:00   1 Q77 2015-04-01 00:00:00 2013-10-31 00:00:00 01926 493491 0
3298 Q6133773 5PN PRIVATE CD DENTIST Y55 Q79 2ND FLOOR, TOWN HALL BRIDGE STREET PETERBOROUGH     PE1 1FA 2008-01-07 00:00:00   1 Q79 2015-04-01 00:00:00 2015-06-30 00:00:00 01733 758500 0
3277 Q6133553 5PP PRIVATE CD DENTIST Y55 Q79 LOCKTON HOUSE CLARENDON ROAD CAMBRIDGE     CB2 8FH 2007-12-18 00:00:00   1 Q79 2015-04-01 00:00:00 2015-06-30 00:00:00 01223 725400 0
1950 Q6120089 5PQ PRIVATE CD DENTIST Y55 Q79 LAKESIDE 400, OLD CHAPEL WAY BROADLAND BUSINESS PARK THORPE ST ANDREW, NORWICH   NR7 0WG 2006-08-01 00:00:00   1 Q79 2015-04-01 00:00:00 2015-06-30 00:00:00 01603 257000 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
3529 Q6136185 5PT PRIVATE CD DENTIST Y55 Q79 RUSHBROOK HOUSE PAPER MILL LANE, BRAMFORD IPSWICH     IP8 4DE 2008-06-19 00:00:00   1 Q79 2015-04-01 00:00:00 2015-06-30 00:00:00 01473 770000 0
1278 Q6113126 5PV PRIVATE CD DENTIST Y55 Q79 BUILDING 4, SPENCER CLOSE ST.MARGARET'S HOSPITAL THE PLAIN, EPPING ESSEX   CM16 6TN 2006-07-08 00:00:00   1 Q79 2015-04-01 00:00:00 2015-12-31 00:00:00 01992 566140 0
4152 Q6142535 5PX PRIVATE CD DENTIST Y55 Q79 SWIFT HOUSE,HEDGEROWS BUSINESS PK,COLCHESTER RD CHELMSFORD ESSEX   CM2 5PF 2010-01-05 00:00:00   1 Q79 2015-04-01 00:00:00 2015-12-31 00:00:00 01245 398727 0
2059 Q6121190 5QC PRIVATE CD DENTIST Y57 Q70 OMEGA HOUSE 112 SOUTHAMPTON ROAD EASTLEIGH HAMPSHIRE   SO50 5PB 2006-08-30 00:00:00   1 Q70 2013-04-01 00:00:00 2013-10-31 00:00:00 01256 332288 0
1907 Q6119610 5QD PRIVATE CD DENTIST Y57 Q82 VERNEY HOUSE GATEHOUSE ROAD AYLESBURY BUCKINGHAMSHIRE   HP18 9ET 2006-08-01 00:00:00   1 Q82 2015-04-01 00:00:00 2013-12-31 00:00:00 01296 310101 0
1915 Q6119706 5QF PRIVATE CD DENTIST Y57 Q82 57-59 BATH ROAD READING BERKSHIRE     RG30 2BA 2006-08-17 00:00:00   1 Q82 2015-04-01 00:00:00 2013-12-31 00:00:00 0118 9503094 0
1760 Q6118114 5QG PRIVATE CD DENTIST Y57 Q82 KING EDWARD V11 HOSPITAL ST LEONARDS ROAD WINDSOR BERKSHIRE   SL4 3DP 2006-08-04 00:00:00   1 Q82 2015-04-01 00:00:00 2013-12-31 00:00:00 01753 621435 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 84.306ms · Data source: OUseful Databeat