home / nhsadmin

Dental Surgeries

Data source: OUseful Databeat

10,410 rows

✎ View and edit SQL

This data as .json

Suggested facets: National Grouping, Status Code, Organisation Sub-Type 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 Status Code Organisation Sub-Type Code Parent Organisation Code Join Parent Date Left Parent Date Amended Record Indicator
1 1 V00002 DENTAL SURGERY Y52 Q37 DENTAL SURGERY 22 MARTYRS AVENUE CRAWLEY WEST SUSSEX   RH11 7RZ 2008-04-01 00:00:00 2009-03-31 00:00:00 C D 5P6 2008-04-01 00:00:00 2009-03-31 00:00:00 0
2 2 V00003 CRABTREE ROAD DENTAL PRACTICE Y57 Q81 CRABTREE ROAD DENTAL PRACTICE 25 CRABTREE ROAD CRAWLEY WEST SUSSEX   RH11 7HL 2006-04-01 00:00:00   A D 14G 2015-04-01 00:00:00   0
3 3 V00004 DENTAL SURGERY Y57 Q81 DENTAL SURGERY WOODCROFT BEPTON ROAD MIDHURST WEST SUSSEX GU29 9HH 2006-04-01 00:00:00   A D 14G 2015-04-01 00:00:00   0
4 4 V00005 DENTAL SURGERY Y57 Q81 DENTAL SURGERY 31 WICK STREET WICK LITTLEHAMPTON WEST SUSSEX BN17 7JJ 2006-04-01 00:00:00   A D 14G 2015-04-01 00:00:00   0
5 5 V00006 DENTAL SURGERY Y57 Q81 DENTAL SURGERY 43 BUSTICLE LANE SOMPTING LANCING WEST SUSSEX BN15 0DJ 2006-04-01 00:00:00   A D 14G 2015-04-01 00:00:00   0
6 6 V00007 CRAWLEY DENTAL CLINIC Y57 Q81 CRAWLEY DENTAL CLINIC 158 BUCKSWOOD DRIVE CRAWLEY WEST SUSSEX   RH11 8JF 2006-04-01 00:00:00   A D 14G 2015-04-01 00:00:00   0
7 7 V00008 28 THE PLANTATION Y52 Q37 28 THE PLANTATION WORTHING WEST SUSSEX     BN13 2AJ 2006-04-01 00:00:00 2012-09-30 00:00:00 C D 5P6 2006-10-01 00:00:00 2012-09-30 00:00:00 0
8 8 V00009 LITTLE LONDON DENTAL SURGERY Y57 Q81 LITTLE LONDON DENTAL SURGERY 31 LITTLE LONDON CHICHESTER WEST SUSSEX   PO19 1PL 2006-04-01 00:00:00   A D 14G 2015-04-01 00:00:00   0
9 9 V00010 OKEHAMPTON DENTAL CARE Y57 Q80 OKEHAMPTON DENTAL CARE 6 STATION ROAD OAKHAMPTON DEVON   EX20 1DZ 2006-04-01 00:00:00   A D 14F 2015-04-01 00:00:00   0
10 10 V00011 SEA ROAD DENTAL PRACTICE Y57 Q81 SEA ROAD DENTAL PRACTICE 104 SEA ROAD EAST PRESTON LITTLEHAMPTON WEST SUSSEX BN16 1NP 2006-04-01 00:00:00   A D 14G 2015-04-01 00:00:00   0
11 11 V00012 STIRLING HOUSE DENTAL SURGERY Y52 Q37 STIRLING HOUSE DENTAL SURGERY DELLING LANE BOSHAM CHICHESTER WEST SUSSEX PO18 8NN 2006-06-01 00:00:00 2008-03-31 00:00:00 C D 5P6 2006-10-01 00:00:00 2008-03-31 00:00:00 0
12 12 V00013 2 MALLARD WAY Y57 Q81 2 MALLARD WAY HENFIELD WEST SUSSEX     BN5 9HF 2006-04-01 00:00:00   A D 14G 2015-04-01 00:00:00   0
13 13 V00014 FITZALAN DENTAL SURGERY Y57 Q81 FITZALAN DENTAL SURGERY FITZALAN MEDICAL CENTRE FITZALAN ROAD LITTLEHAMPTON WEST SUSSEX BN17 5JR 2006-04-01 00:00:00   A D 14G 2015-04-01 00:00:00   0
14 14 V00015 HARVESTFIELD Y57 Q81 HARVESTFIELD LONDON ROAD EAST GRINSTEAD WEST SUSSEX   RH19 1QD 2006-04-01 00:00:00   A D 14G 2015-04-01 00:00:00   0
15 15 V00016 WHITE HOUSE DENTAL SURGERY Y57 Q81 WHITE HOUSE DENTAL SURGERY BELMONT STREET BOGNOR REGIS WEST SUSSEX   PO21 1LG 2006-04-01 00:00:00   A D 14G 2015-04-01 00:00:00   0
16 16 V00018 DENTAL PRACTICE Y57 Q81 DENTAL PRACTICE RUDGWICK MEDICAL CENTRE STATION ROAD RUDGWICK HORSHAM RH12 3HB 2006-04-01 00:00:00   A D 14G 2015-04-01 00:00:00   0
17 17 V00019 DENTAL SURGERY Y57 Q81 DENTAL SURGERY 28 WORTHING ROAD HORSHAM WEST SUSSEX   RH12 1SL 2006-04-01 00:00:00   A D 14G 2015-04-01 00:00:00   0
18 18 V00020 THE GALLERY 2 DENTAL PRACTICE Y52 Q37 THE GALLERY 2 DENTAL PRACTICE 5 HIGH STREET CUCKFIELD HAYWARDS HEATH WEST SUSSEX RH17 5EN 2006-06-01 00:00:00 2008-03-31 00:00:00 C D 5P6 2006-10-01 00:00:00 2008-03-31 00:00:00 0
19 19 V00021 DENTAL SURGERY Y57 Q81 DENTAL SURGERY 4 HIGH STREET STEYNING WEST SUSSEX   BN44 3GG 2006-04-01 00:00:00   A D 14G 2015-04-01 00:00:00   0
20 20 V00022 DENTAL SURGERY W00 Q99 DENTAL SURGERY 24 UPLANDS CRESCENT UPLANDS SWANSEA WEST GLAMORGAN SA2 0PB 2006-04-01 00:00:00   A D 7A3 2009-10-01 00:00:00   0
21 21 V00023 DENTAL SURGERY Y55 Q78 DENTAL SURGERY 88 PENRYN AVENUE FISHERMEAD MILTON KEYNES BUCKINGHAMSHIRE MK6 2BG 2006-04-01 00:00:00   A D 14D 2015-04-01 00:00:00   0
22 22 V00024 20 LIVERPOOL GARDENS Y57 Q81 20 LIVERPOOL GARDENS WORTHING WEST SUSSEX     BN11 1RY 2006-04-01 00:00:00   A D 14G 2015-04-01 00:00:00   0
23 23 V00025 55 PERRYMOUNT ROAD Y57 Q81 55 PERRYMOUNT ROAD HAYWARDS HEATH WEST SUSSEX     RH16 3BN 2006-04-01 00:00:00   A D 14G 2015-04-01 00:00:00   0
24 24 V00026 BROADFIELD DENTAL CENTRE Y57 Q81 BROADFIELD DENTAL CENTRE 2ND FLOOR BARTON HOUSE BROADFIELD BARTON CRAWLEY WEST SUSSEX RH11 9BA 2006-04-01 00:00:00   A D 14G 2015-04-01 00:00:00   0
25 25 V00028 YEOVIL DENTAL PRACTICE Y57 Q80 YEOVIL DENTAL PRACTICE 10 SHERBORNE ROAD YEOVIL SOMERSET   BA21 4HD 2006-04-01 00:00:00   A D 14F 2015-04-01 00:00:00   0
26 26 V00029 ADP Y57 Q70 ADP OAKFIELD DENTAL PRACTICE 3 SALISBURY ROAD FARNBOROUGH HAMPSHIRE GU14 7AN 2006-04-01 00:00:00   A D 13N 2013-04-01 00:00:00   0
27 27 V00030 DENTAL SURGERY Y57 Q81 DENTAL SURGERY 18E CITY WAY ROCHESTER KENT   ME1 2AB 2006-04-01 00:00:00   A D 14G 2015-04-01 00:00:00   0
28 28 V00032 DENTAL SURGERY Y54 Q74 DENTAL SURGERY 61 ROMAN ROAD MIDDLESBROUGH CLEVELAND   TS5 5PH 2006-04-01 00:00:00   A D 13X 2015-04-01 00:00:00   0
29 29 V00033 DENTAL SURGERY Y55 Q58 DENTAL SURGERY 93 - 95 QUEENSWAY STEVENAGE HERTFORDSHIRE   SG1 1EA 2006-04-01 00:00:00 2014-03-31 00:00:00 C D 12Y 2013-04-01 00:00:00 2014-03-31 00:00:00 0
30 30 V00034 TRAFALGAR DENTAL PRACTICE Y57 Q70 TRAFALGAR DENTAL PRACTICE ROWNER HEALTH CENTRE 143 ROWNER LANE GOSPORT HAMPSHIRE PO13 9SP 2006-04-01 00:00:00   A D 13N 2013-04-01 00:00:00   0
31 31 V00035 TRAFALGAR CLINIC Y57 Q70 TRAFALGAR CLINIC 9 CHEVRON BUSINESS PARK LIME KILN LANE HOLBURY SOUTHAMPTON SO45 2QL 2006-04-01 00:00:00   A D 13N 2013-04-01 00:00:00   0
32 32 V00037 BRINNINGTON HEALTH CENTRE Y54 Q83 BRINNINGTON HEALTH CENTRE BRINNINGTON ROAD STOCKPORT CHESHIRE   SK5 8BS 2006-04-01 00:00:00   A D 14J 2016-04-14 00:00:00   0
33 33 V00038 COMMUNITY DENTAL SERVICES Y51 Q31 COMMUNITY DENTAL SERVICES HAZEL GROVE CLINIC 253 LONDON ROAD HAZEL GROVE STOCKPORT SK7 4PW 2006-04-01 00:00:00 2007-04-30 00:00:00 C D 5F7 2006-04-01 00:00:00 2007-04-30 00:00:00 0
34 34 V00039 BEAUFORT DENTAL PRACTICE W00 Q99 BEAUFORT DENTAL PRACTICE 2 BANK BUILDINGS BEAUFORT STREET CRICKHOWELL POWYS NP8 1AD 2006-04-01 00:00:00   A D 7A7 2009-10-01 00:00:00   0
35 35 V00040 DENTAL SURGERY Y56 Q71 DENTAL SURGERY 61 THE MARKET SQUARE LONDON     N9 0TZ 2006-04-01 00:00:00   A D 13R 2013-04-01 00:00:00   0
36 36 V00041 DENTAL SURGERY Y55 Q78 DENTAL SURGERY 34 LAVENDER ROAD LEICESTER LEICESTERSHIRE   LE3 1AL 2006-04-01 00:00:00   A D 14D 2015-04-01 00:00:00   0
37 37 V00042 DENTAL SURGERY Y57 Q69 DENTAL SURGERY 137 HIGH STREET SLOUGH BERKSHIRE   SL1 1DN 2006-04-01 00:00:00 2014-10-31 00:00:00 C D 13M 2013-04-01 00:00:00 2014-10-31 00:00:00 0
38 38 V00043 DENTAL ACCESS CENTRE Y57 Q82 DENTAL ACCESS CENTRE UPTON HOSPITAL ALBERT STREET SLOUGH BERKSHIRE SL1 2BJ 2006-04-01 00:00:00   A D 14H 2015-04-01 00:00:00   0
39 39 V00044 DHIMAN DENTAL Y56 Q71 DHIMAN DENTAL 169 PERCY ROAD TWICKENHAM MIDDLESEX   TW2 6JS 2006-04-01 00:00:00   A D 13R 2013-04-01 00:00:00   0
40 40 V00045 PURITY Y55 Q77 PURITY 74 DIXONS GREEN ROAD DUDLEY WEST MIDLANDS   DY2 7DJ 2006-04-01 00:00:00   A D 14C 2015-04-01 00:00:00   0
41 41 V00046 DENTAL SURGERY Y57 Q81 DENTAL SURGERY 108 ASHDOWN DRIVE CRAWLEY WEST SUSSEX   RH10 5EX 2006-04-01 00:00:00   A D 14G 2015-04-01 00:00:00   0
42 42 V00048 DENTAL SURGERY Y56 Q71 DENTAL SURGERY 224 - 226 WHITECHAPEL ROAD LONDON     E1 1BJ 2006-04-01 00:00:00   A D 13R 2013-04-01 00:00:00   0
43 43 V00049 ABBEYDALE ROAD DENTAL SURGERY Y54 Q72 ABBEYDALE ROAD DENTAL SURGERY 4 - 6 ABBEYDALE ROAD SHEFFIELD SOUTH YORKSHIRE   S7 1FD 2006-04-01 00:00:00   A D 13V 2015-04-01 00:00:00   0
44 44 V00050 NORFOLK PARK DENTAL SURGERY Y54 Q72 NORFOLK PARK DENTAL SURGERY 5 SAMUEL ROAD SHEFFIELD SOUTH YORKSHIRE   S2 3UA 2006-04-01 00:00:00   A D 13V 2015-04-01 00:00:00   0
45 45 V00051 21 COMMERCIAL STREET Y53 Q36 21 COMMERCIAL STREET LONDON       E1 6BD 2007-10-01 00:00:00 2009-06-30 00:00:00 C D 5C4 2007-10-01 00:00:00 2009-06-30 00:00:00 0
46 46 V00052 DENTAL SURGERY Y55 Q76 DENTAL SURGERY 278 DERBY ROAD NOTTINGHAM NOTTINGHAMSHIRE   NG7 1PZ 2006-04-01 00:00:00   A D 14A 2015-04-01 00:00:00   0
47 47 V00053 CHURCH VIEW DENTAL PRACTICE Y55 Q76 CHURCH VIEW DENTAL PRACTICE 22 CHURCH STREET EASTWOOD NOTTINGHAM NOTTINGHAMSHIRE NG16 3HS 2006-04-01 00:00:00   A D 14A 2015-04-01 00:00:00   0
48 48 V00054 COMMUNITY DENTAL CLINIC Y57 Q82 COMMUNITY DENTAL CLINIC W BERKSHIRE COMMUNITY HOSPITAL BENHAM HILL LONDON ROAD THATCHAM, BERKSHIRE RG18 3AS 2006-04-01 00:00:00   A D 14H 2015-04-01 00:00:00   0
49 49 V00055 THE HOLLIES DENTAL SURGERY Y51 Q34 THE HOLLIES DENTAL SURGERY 123 HAGLEY ROAD STOURBRIDGE WEST MIDLANDS   DY8 1RD 2006-04-01 00:00:00 2011-02-08 00:00:00 C D 5PE 2006-10-01 00:00:00 2011-02-08 00:00:00 0
50 50 V00056 THE SURGERY Y57 Q82 THE SURGERY 35 HIGH STREET BANBURY OXFORDSHIRE   OX16 5ER 2006-04-01 00:00:00   A D 14H 2015-04-01 00:00:00   0
51 51 V00057 24 EASTGATE STREET Y55 Q76 24 EASTGATE STREET STAFFORD STAFFORDSHIRE     ST16 2LZ 2006-04-01 00:00:00   A D 14A 2015-04-01 00:00:00   0
52 52 V00058 380 BROAD LANE Y54 Q72 380 BROAD LANE LEEDS WEST YORKSHIRE     LS13 2HS 2006-04-01 00:00:00   A D 13V 2015-04-01 00:00:00   0
53 53 V00059 THE DENTAL CLINIC Y44 Q38 THE DENTAL CLINIC CARISBROOKE HEALTH CENTRE 22 CARISBROOKE HIGH STREET CARISBROOKE ISLE OF WIGHT PO30 1NR 2006-04-01 00:00:00 2006-04-02 00:00:00 C D 5DG 2006-04-01 00:00:00 2006-04-02 00:00:00 0
54 54 V00060 DENTAL SURGERY Y54 Q83 DENTAL SURGERY 14 KING STREET LEIGH LANCASHIRE   WN7 4LR 2006-04-01 00:00:00   A D 14J 2016-04-14 00:00:00   0
55 55 V00062 244 TANKERTON ROAD Y57 Q81 244 TANKERTON ROAD WHITSTABLE KENT     CT5 2AY 2006-04-01 00:00:00   A D 14G 2015-04-01 00:00:00   0
56 56 V00063 CROFTON PARK DENTAL PRACTICE Y56 Q71 CROFTON PARK DENTAL PRACTICE 18 BROCKLEY GROVE CROFTON PARK LONDON   SE4 1QY 2006-04-01 00:00:00   A D 13R 2013-04-01 00:00:00   0
57 57 V00064 DENTAL SURGERY Y54 Q83 DENTAL SURGERY 301 MOSTON LANE MANCHESTER LANCASHIRE   M40 9NL 2006-04-01 00:00:00   A D 14J 2016-04-14 00:00:00   0
58 58 V00065 WESTBROOK DENTAL PRACTICE Y54 Q75 WESTBROOK DENTAL PRACTICE WESTBROOK CENTRE WESTBROOK WARRINGTON CHESHIRE WA5 8UG 2006-04-01 00:00:00   A D 13Y 2015-04-01 00:00:00   0
59 59 V00066 STONE DENTAL CARE Y55 Q76 STONE DENTAL CARE 10 HIGH STREET STONE STAFFORDSHIRE   ST15 8AW 2006-04-01 00:00:00   A D 14A 2015-04-01 00:00:00   0
60 60 V00067 DIXON AND PLAHE DENTAL CARE CENT Y54 Q74 DIXON AND PLAHE DENTAL CARE CENT 32 QUEEN STREET REDCAR CLEVELAND   TS10 1BD 2006-04-01 00:00:00   A D 13X 2015-04-01 00:00:00   0
61 61 V00068 ELSTON AND ELSTON Y54 Q74 ELSTON AND ELSTON 28 COATHAM ROAD REDCAR CLEVELAND   TS10 1RS 2006-04-01 00:00:00   A D 13X 2015-04-01 00:00:00   0
62 62 V00069 BURNSIDE AND CARTER Y54 Q74 BURNSIDE AND CARTER 27 WEST ROAD LOFTUS SALTBURN BY THE SEA CLEVELAND TS13 4RP 2006-04-01 00:00:00   A D 13X 2015-04-01 00:00:00   0
63 63 V00070 UNIT 2 Y54 Q74 UNIT 2 ROSEBERRY SHOPPING CENTRE, ROSEBERRY ROAD, REDCAR,   TS10 4NY 2006-04-01 00:00:00   A D 13X 2015-04-01 00:00:00   0
64 64 V00071 DENTAL SURGERY Y54 Q74 DENTAL SURGERY 1 HIGHCLIFFE VIEW WESTGATE GUISBOROUGH CLEVELAND TS14 6AY 2006-04-01 00:00:00   A D 13X 2015-04-01 00:00:00   0
65 65 V00072 DENTAL SURGERY Y54 Q74 DENTAL SURGERY 171 HIGH STREET SKELTON IN CLEVELAND SALTBURN BY THE SEA CLEVELAND TS12 2LF 2006-04-01 00:00:00   A D 13X 2015-04-01 00:00:00   0
66 66 V00073 15 PARK AVENUE Y54 Q74 15 PARK AVENUE REDCAR CLEVELAND     TS10 3LA 2006-04-01 00:00:00   A D 13X 2015-04-01 00:00:00   0
67 67 V00074 ANDREWS AND LYNE Y51 Q30 ANDREWS AND LYNE 16 THE WYND MARSKE BY THE SEA REDCAR CLEVELAND TS11 7LA 2006-04-01 00:00:00 2006-10-01 00:00:00 C D 5QR 2006-10-01 00:00:00 2006-10-01 00:00:00 0
68 68 V00075 DENTAL SURGERY Y54 Q74 DENTAL SURGERY 83 85 CHURCH STREET GUISBOROUGH CLEVELAND   TS14 6HG 2006-04-01 00:00:00   A D 13X 2015-04-01 00:00:00   0
69 69 V00076 DENTAL CENTRE Y51 Q30 DENTAL CENTRE 54 LORD STREET REDCAR CLEVELAND   TS10 3HS 2006-04-01 00:00:00 2007-06-30 00:00:00 C D 5QR 2006-10-01 00:00:00 2007-06-30 00:00:00 0
70 70 V00077 MALPASS DENTAL PRACTICE Y54 Q74 MALPASS DENTAL PRACTICE 11 DUNDAS STREET SALTBURN BY THE SEA CLEVELAND   TS12 1AH 2006-04-01 00:00:00   A D 13X 2015-04-01 00:00:00   0
71 71 V00078 ROSEBERRY DENTAL SURGERY Y54 Q74 ROSEBERRY DENTAL SURGERY 118 WESTGATE GUISBOROUGH CLEVELAND   TS14 6AW 2006-04-01 00:00:00   A D 13X 2015-04-01 00:00:00   0
72 72 V00079 MR C J BANKS DENTAL CARE Y41 Q30 MR C J BANKS DENTAL CARE 106 HIGH STREET MARSKE BY THE SEA REDCAR CLEVELAND TS11 7BA 2006-04-01 00:00:00 2006-09-01 00:00:00 C D 5KN 2006-04-01 00:00:00 2006-09-01 00:00:00 0
73 73 V00081 ORTHODONTIC CLINIC Y54 Q74 ORTHODONTIC CLINIC 34 - 36 BAKER STREET MIDDLESBROUGH CLEVELAND   TS1 2LH 2006-04-01 00:00:00 2016-03-31 00:00:00 C D 13X 2016-03-17 00:00:00 2016-03-31 00:00:00 0
74 74 V00082 DENTAL SURGERY Y54 Q74 DENTAL SURGERY 222 LINTHORPE ROAD MIDDLESBROUGH CLEVELAND   TS1 3QW 2006-04-01 00:00:00   A D 13X 2015-04-01 00:00:00   0
75 75 V00083 GENIX HEALTHCARE Y54 Q74 GENIX HEALTHCARE 226 LINTHORPE ROAD MIDDLESBROUGH CLEVELAND   TS1 3QW 2006-04-01 00:00:00   A D 13X 2015-04-01 00:00:00   0
76 76 V00085 AVENUE DENTAL CARE Y54 Q74 AVENUE DENTAL CARE 94 THE AVENUE NUNTHORPE MIDDLESBROUGH CLEVELAND TS7 0AP 2006-04-01 00:00:00   A D 13X 2015-04-01 00:00:00   0
77 77 V00086 KERRUISH AND ASSOCIATES Y51 Q30 KERRUISH AND ASSOCIATES 103 NORMANBY ROAD MIDDLESBROUGH CLEVELAND   TS6 6SF 2006-04-01 00:00:00 2008-12-31 00:00:00 C D 5QR 2006-10-01 00:00:00 2008-12-31 00:00:00 0
78 78 V00087 DENIS R STUBLEY AND ASSOCIATES D Y51 Q30 DENIS R STUBLEY AND ASSOCIATES D 282 ACKLAM ROAD MIDDLESBROUGH CLEVELAND   TS5 8AA 2006-04-01 00:00:00 2006-04-01 00:00:00 C D 5KM 2006-04-01 00:00:00 2006-04-01 00:00:00 0
79 79 V00088 THE DENTAL CENTRE Y54 Q74 THE DENTAL CENTRE 153 MARTON ROAD MIDDLESBROUGH CLEVELAND   TS4 2EN 2006-04-01 00:00:00   A D 13X 2015-04-01 00:00:00   0
80 80 V00089 HARRISON KENEFEC AND MELLOR Y51 Q30 HARRISON KENEFEC AND MELLOR 312 LINTHORPE ROAD MIDDLESBROUGH CLEVELAND   TS1 3QX 2006-04-01 00:00:00 2008-03-31 00:00:00 C D 5KM 2006-04-01 00:00:00 2008-03-31 00:00:00 0
81 81 V00091 OSGODBY DENTAL CENTRE Y54 Q74 OSGODBY DENTAL CENTRE 131 - 133 ACKLAM ROAD MIDDLESBROUGH CLEVELAND   TS5 5HR 2006-04-01 00:00:00   A D 13X 2015-04-01 00:00:00   0
82 82 V00093 DENTAL SURGERY Y51 Q30 DENTAL SURGERY 16 STOKESLEY ROAD MARTON IN CLEVELAND MIDDLESBROUGH CLEVELAND TS7 8DX 2006-04-01 00:00:00 2010-09-05 00:00:00 C D 5KM 2006-04-01 00:00:00 2010-09-05 00:00:00 0
83 83 V00094 DENTAL SURGERY Y54 Q74 DENTAL SURGERY UNIT C PARKWAY CENTRE COULBY NEWHAM MIDDLESBROUGH TS8 0TJ 2006-04-01 00:00:00   A D 13X 2015-04-01 00:00:00   0
84 84 V00095 DENTAL SURGERY Y54 Q74 DENTAL SURGERY 2-4 CARGO FLEET LANE MIDDLESBROUGH CLEVELAND   TS3 0LW 2006-04-01 00:00:00   A D 13X 2015-04-01 00:00:00   0
85 85 V00096 NUNTHORPE DENTAL PRACTICE Y51 Q30 NUNTHORPE DENTAL PRACTICE DENTAL SURGERY 99 GUISBOROUGH ROAD NUNTHORPE MIDDLESBROUGH TS7 0JS 2006-04-01 00:00:00 2008-03-31 00:00:00 C D 5QR 2006-10-01 00:00:00 2008-03-31 00:00:00 0
86 86 V00097 DENTAL SURGERY Y54 Q74 DENTAL SURGERY 18 THE VIEWLEY CENTRE HEMLINGTON MIDDLESBROUGH CLEVELAND TS8 9JH 2006-04-01 00:00:00   A D 13X 2015-04-01 00:00:00   0
87 87 V00098 SELECT DENTAL CARE Y54 Q74 SELECT DENTAL CARE 125 - 129 BOROUGH ROAD MIDDLESBROUGH CLEVELAND   TS1 3AN 2006-04-01 00:00:00   A D 13X 2015-04-01 00:00:00   0
88 88 V00100 THE DENTAL PRACTICE Y54 Q74 THE DENTAL PRACTICE 4 GRANGE ROAD HARTLEPOOL CLEVELAND   TS26 8JA 2006-04-01 00:00:00   A D 13X 2015-04-01 00:00:00   0
89 89 V00101 ELLIOTT&MCCARTHY DENTAL SURGERY Y54 Q74 ELLIOTT&MCCARTHY DENTAL SURGERY 86 WILTSHIRE WAY HARTLEPOOL CLEVELAND   TS26 0TB 2006-04-01 00:00:00   A D 13X 2015-04-01 00:00:00   0
90 90 V00102 MISS J MATHIESONS DENTAL SURGERY Y54 Q74 MISS J MATHIESONS DENTAL SURGERY 22 VICTORIA ROAD HARTLEPOOL CLEVELAND   TS26 8DD 2006-04-01 00:00:00   A D 13X 2015-04-01 00:00:00   0
91 91 V00103 GRACE DENTAL CARE Y54 Q74 GRACE DENTAL CARE 60 AVENUE ROAD HARTLEPOOL CLEVELAND   TS24 8AT 2006-04-01 00:00:00   A D 13X 2015-04-01 00:00:00   0
92 92 V00104 DENTAL SURGERY Y54 Q74 DENTAL SURGERY 223 STOCKTON ROAD HARTLEPOOL CLEVELAND   TS25 1RR 2006-04-01 00:00:00   A D 13X 2015-04-01 00:00:00   0
93 93 V00105 ORANGE GROVE HOUSE YZZ QZZ ORANGE GROVE HOUSE ORCHARD ROAD PORT ERIN ISLE OF MAN   IM9 6DJ 2006-04-01 00:00:00   A D YK1 2006-04-01 00:00:00   0
94 94 V00106 FLEMINGS' DENTAL SURGEONS Y51 Q30 FLEMINGS' DENTAL SURGEONS 115A YORK ROAD HARTLEPOOL CLEVELAND   TS26 9DL 2006-04-01 00:00:00 2013-01-11 00:00:00 C D 5D9 2006-04-01 00:00:00 2013-01-11 00:00:00 0
95 95 V00107 DENTAL SURGERY Y51 Q30 DENTAL SURGERY 434 CATCOTE ROAD HARTLEPOOL CLEVELAND   TS25 2LS 2006-04-01 00:00:00 2009-03-31 00:00:00 C D 5D9 2006-04-01 00:00:00 2009-03-31 00:00:00 0
96 96 V00108 DENTAL CARE Y51 Q30 DENTAL CARE 64 ELIZABETH WAY HARTLEPOOL CLEVELAND   TS25 2AX 2006-04-01 00:00:00 2006-04-02 00:00:00 C D 5D9 2006-04-01 00:00:00 2006-04-02 00:00:00 0
97 97 V00109 FLEMINGS' DENTAL SURGEONS Y54 Q74 FLEMINGS' DENTAL SURGEONS 34 VICTORIA ROAD HARTLEPOOL CLEVELAND   TS26 8DD 2006-04-01 00:00:00   A D 13X 2015-04-01 00:00:00   0
98 98 V00110 FLEMINGS' DENTAL SURGEONS Y54 Q45 FLEMINGS' DENTAL SURGEONS 29 NORTHGATE HARTLEPOOL CLEVELAND   TS24 0JT 2006-04-01 00:00:00 2014-03-31 00:00:00 C D 12H 2013-04-01 00:00:00 2014-03-31 00:00:00 0
99 99 V00113 MELCOMBE AVENUE DENTAL PRACTICE Y57 Q70 MELCOMBE AVENUE DENTAL PRACTICE 3 MELCOMBE AVENUE WEYMOUTH DORSET   DT4 7TB 2006-04-01 00:00:00   A D 13N 2013-04-01 00:00:00   0
100 100 V00114 BISHOPTON LANE DENTAL PRACTICE Y54 Q74 BISHOPTON LANE DENTAL PRACTICE 21 BISHOPTON LANE STOCKTON ON TEES CLEVELAND   TS18 1PS 2006-04-01 00:00:00   A D 13X 2015-04-01 00:00:00   0

Next page

CREATE TABLE "egdpprac" (
"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" TEXT,
  "Postcode" TEXT,
  "Open Date" TIMESTAMP,
  "Close Date" TIMESTAMP,
  "Status Code" TEXT,
  "Organisation Sub-Type Code" TEXT,
  "Parent Organisation Code" TEXT,
  "Join Parent Date" TIMESTAMP,
  "Left Parent Date" TIMESTAMP,
  "Amended Record Indicator" INTEGER
)
Powered by Datasette · Query took 62.773ms · Data source: OUseful Databeat