home / nhsadmin

Archived GPs

Data source: OUseful Databeat

7,610 rows

View and edit SQL

This data as .json

Suggested facets: National Grouping, 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 Contact Telephone Number Amended Record Indicator
1 G0107275 ANGEL AM Y10 QAJ NIGHTINGALE HOUSE 105 NIGHTINGALE LANE BALHAM LONDON   SW12 8NB 1974-04-01 00:00:00 1996-04-17 00:00:00 C P H85681 1991-04-03 00:00:00 1996-04-17 00:00:00 0181 6733495 0
2 G0108180 ANDERSEN HJ Y10 QAH 123 EVELINA ROAD DULWICH LONDON     SE15 3HD 1974-04-01 00:00:00 1995-06-11 00:00:00 C P G85601 1974-04-01 00:00:00 1995-06-11 00:00:00 071 6393126 0
3 G0108348 ANDERSON AB Y07 QD9 260 LICHFIELD ROAD SUTTON COLDFIELD WEST MIDLANDS     B74 2UH 1974-04-01 00:00:00 1991-08-09 00:00:00 C P M85601 1974-04-01 00:00:00 1991-08-09 00:00:00   0
4 G0108953 ADDERLEY DJ Y53 Q36 THE SURGERY BELMONT GROVE EAST LEWISHAM LONDON   SE13 5BG 1974-04-01 00:00:00 1992-03-31 00:00:00 C O G85003 1974-04-01 00:00:00 1992-03-31 00:00:00 020 88528357 0
5 G0109590 ANTHONY JR Y53 Q36 143 INGREBOURNE GARDENS CRANHAM UPMINSTER ESSEX   RM14 1BJ 1974-04-01 00:00:00 2003-02-28 00:00:00 C O F82006 1974-04-01 00:00:00 2003-02-28 00:00:00 01708 228888 0
6 G0109772 ALBRIGHT SW Y07 QD9 NECHELLS GREEN HEALTH CTR 64 DENBY CLOSE NECHELLS BIRMINGHAM   B7 4PF 1974-04-01 00:00:00 1992-06-30 00:00:00 C O M85004 1974-04-01 00:00:00 1992-06-30 00:00:00 0121 6783932 0
7 G0109806 ASTILL PH Y51 Q33 THE STEWART MEDICAL CTR 15 HARTINGTON ROAD BUXTON DERBYSHIRE   SK17 6JP 1974-04-01 00:00:00 1991-10-13 00:00:00 C O C81034 1974-04-01 00:00:00 1991-10-13 00:00:00 01298 22338 0
8 G0109930 ANFILOGOFF ME Y53 Q36 143 INGREBOURNE GARDENS CRANHAM UPMINSTER ESSEX   RM14 1BJ 1974-04-01 00:00:00 1996-06-30 00:00:00 C O F82006 1974-04-01 00:00:00 1996-06-30 00:00:00 01708 228888 0
9 G0110062 AHSAN SM Y53 Q36 98A SOUTHGATE ROAD   LONDON     N1 3JB 1974-04-01 00:00:00 1991-12-31 00:00:00 C O F84041 1974-04-01 00:00:00 1991-12-31 00:00:00 020 77042233 0
10 G0110158 AIRLIE I Y51 Q30 CRUDDAS PARK SURGERY 178 WESTMORLAND ROAD CRUDDAS PARK NEWCASTLE UPON TYNE   NE4 7JT 1974-04-01 00:00:00 1994-07-03 00:00:00 C O A86017 1974-04-01 00:00:00 1994-07-03 00:00:00 091 2739148 0
11 G0110361 ANDERSON RG Y51 Q35 THE SURGERY 2 FRANKLINS WAY WICKFORD ESSEX   SS11 8AU 1974-04-01 00:00:00 1994-03-31 00:00:00 C O F81036 1974-04-01 00:00:00 1994-03-31 00:00:00 0268 733020 0
12 G0110691 ARCHER AR Y52 Q37 AMHERST MEDICAL PRACTICE 21 ST BOTOLPHS ROAD SEVENOAKS KENT   TN13 3AQ 1974-04-01 00:00:00 1995-09-01 00:00:00 C O G82013 1974-04-01 00:00:00 1995-09-01 00:00:00 01732459255 0
13 G0110701 ALLAN JM Y51 Q31 SANDY LANE HEALTH CENTRE SANDY LANE SKELMERSDALE LANCASHIRE   WN8 8LA 1974-04-01 00:00:00 1994-06-30 00:00:00 C O P81102 1974-04-01 00:00:00 1994-06-30 00:00:00 0695 23279 0
14 G0201265 BALLON L Y51 Q31 LEVENSHULME HEALTH CENTRE DUNSTABLE STREET MANCHESTER     M19 3BX 1974-04-01 00:00:00 1991-04-01 00:00:00 C O P84016 1974-04-01 00:00:00 1991-04-01 00:00:00 0161 2254033 0
15 G0205582 BENNETT NO Y51 Q31 THE HEALTH CENTRE BEECH HALL STREET BEECH HILL WIGAN   WN6 7HX 1974-04-01 00:00:00 1991-04-01 00:00:00 C O P92010 1974-04-01 00:00:00 1991-04-01 00:00:00 01942 821899 0
16 G0217433 BASSETT JM Y10 QA3 38 ROLAND WAY   LONDON     SW7 3RE 1974-04-01 00:00:00 1991-04-01 00:00:00 C P E87604 1974-04-01 00:00:00 1991-04-01 00:00:00   0
17 G0219741 BLACK H Y51 Q32 347 OAKWOOD LANE   LEEDS     LS8 3HA 1974-04-01 00:00:00 1992-06-30 00:00:00 C O B86022 1974-04-01 00:00:00 1992-06-30 00:00:00 0113 2953750 0
18 G0220378 BERNAYS MA Y11 QAN 2 PARKLANDS ROAD CHICHESTER WEST SUSSEX     PO19 3DT 1974-04-01 00:00:00 1992-06-12 00:00:00 C P H82600 1974-04-01 00:00:00 1992-06-12 00:00:00   0
19 G0224523 BARNETT DB Y51 Q31 171 CHILDWALL VALLEY ROAD   LIVERPOOL     L16 1LA 1974-04-01 00:00:00 1992-02-08 00:00:00 C O N82079 1974-04-01 00:00:00 1992-02-08 00:00:00 0151 7333224 0
20 G0225483 BROMAN SM Y51 Q31 WEST GORTON MEDICAL CTR. 6A WENLOCK WAY WEST GORTON MANCHESTER   M12 5LH 1974-04-01 00:00:00 1992-06-30 00:00:00 C O P84052 1974-04-01 00:00:00 1992-06-30 00:00:00 0161 2235226 0
21 G0225517 BOFFA PS Y53 Q36 23 BROOM ROAD SHIRLEY CROYDON SURREY   CR0 8NG 1974-04-01 00:00:00 1992-01-30 00:00:00 C O H83030 1974-04-01 00:00:00 1992-01-30 00:00:00 020 87775511 0
22 G0225706 BELLEW MP Y51 Q31 THE RYAN MEDICAL CTR. ST MARY'S ROAD BAMBER BRIDGE PRESTON   PR5 6TE 1974-04-01 00:00:00 1993-12-31 00:00:00 C O P81082 1974-04-01 00:00:00 1993-12-31 00:00:00 0772 35136 0
23 G0226068 BENSON H Y53 Q36 THE SURGERY 37 HIGH ROAD TOTTENHAM     N15 6DS 1974-04-01 00:00:00 1993-06-04 00:00:00 C O F85071 1974-04-01 00:00:00 1993-06-04 00:00:00 020 88096445 0
24 G0226288 BAIN AHW Y53 Q36 THE STH.LEWISHAM HTH.CTR. 50 CONISBOROUGH CRESCENT CATFORD LONDON   SE6 2SP 1974-04-01 00:00:00 1992-06-01 00:00:00 C O G85005 1974-04-01 00:00:00 1992-06-01 00:00:00 020 30492580 0
25 G0226680 BAKER CL Y53 Q36 31 BRIDGE AVENUE HAMMERSMITH LONDON     W6 9JA 1974-04-01 00:00:00 1995-12-25 00:00:00 C O E85033 1974-04-01 00:00:00 1995-12-25 00:00:00 01817485246 0
26 G0227708 BARR AE Y53 Q36 321 THE DRIVE CRANBROOK ILFORD ESSEX   IG1 3PW 1974-04-01 00:00:00 1993-06-11 00:00:00 C O F86084 1974-04-01 00:00:00 1993-06-11 00:00:00 020 85544211 0
27 G0229023 BRILL AM Y01 QDH 116 STAINBECK LANE   LEEDS     LS7 3QS 1974-04-01 00:00:00 1991-09-30 00:00:00 C P B86603 1974-04-01 00:00:00 1991-09-30 00:00:00   0
28 G0229061 BURNETT NT Y08 QDA 140 WIGAN ROAD BRYN ASHTON-IN-MAKERFIELD NR.WIGAN   WN4 9ST 1974-04-01 00:00:00 1996-02-29 00:00:00 C P P92600 1974-04-01 00:00:00 1996-02-29 00:00:00 01942727269 0
29 G0229236 BOWEN RW W00 QW3 ST.THOMAS SURGERY RIFLEMAN LANE ST.THOMAS GREEN HAVERFORDWEST DYFED   SA73 1QX 1974-04-01 00:00:00 1991-09-30 00:00:00 C O W92002 1974-04-01 00:00:00 1991-09-30 00:00:00 01437 762162 0
30 G0229308 BOOTH CJ Y52 Q38 66 WESTWOOD ROAD TILEHURST READING BERKSHIRE   RG3 5PP 1974-04-01 00:00:00 1994-01-31 00:00:00 C O K81056 1974-04-01 00:00:00 1994-01-31 00:00:00 0734 427421 0
31 G0229391 BIRRELL WL Y53 Q36 148 FOREST ROAD   WALTHAMSTOW     E17 6JQ 1974-04-01 00:00:00 1995-05-28 00:00:00 C O F86602 1974-04-01 00:00:00 1995-05-28 00:00:00 01815204533 0
32 G0229470 BRYSON JR Y51 Q31 COLNE HEALTH CENTRE MARKET STREET COLNE LANCASHIRE   BB8 0LJ 1974-04-01 00:00:00 1995-05-16 00:00:00 C O P81025 1974-04-01 00:00:00 1995-05-16 00:00:00 01282862451 0
33 G0229607 BURKE JBG Y53 Q36 THE MILLWAY SURGERY 30 MILLWAY MILL HILL LONDON   NW7 3RD 1974-04-01 00:00:00 1994-04-04 00:00:00 C O E83016 1974-04-01 00:00:00 1994-04-04 00:00:00 020 89590888 0
34 G0229676 BARRY JFL Y53 Q36 MORNINGTON SURGERY 433 NEW CROSS ROAD NEW CROSS LONDON   SE14 6TD 1974-04-01 00:00:00 1993-04-30 00:00:00 C O G85008 1974-04-01 00:00:00 1993-04-30 00:00:00 081 6928299 0
35 G0229968 BENNETT M Y51 Q34 190 ASTON LANE HANDSWORTH BIRMINGHAM     B20 3HE 1974-04-01 00:00:00 1994-02-28 00:00:00 C O M85100 1974-04-01 00:00:00 1994-02-28 00:00:00 0845 6750562 0
36 G0230409 BIRCH JS Y51 Q32 PEMBROKE HOUSE 32 ALBERT ROAD CLEETHORPES SOUTH HUMBERSIDE   DN35 8LU 1974-04-01 00:00:00 1994-08-09 00:00:00 C O B81003 1974-04-01 00:00:00 1994-08-09 00:00:00 0472 691033 0
37 G0230423 BARBER PJ Y51 Q34 SWAN MEDICAL CENTRE 17 WILLARD ROAD SOUTH YARDLEY BIRMINGHAM   B25 8AB 1974-04-01 00:00:00 1994-11-30 00:00:00 C O M85011 1974-04-01 00:00:00 1994-11-30 00:00:00 021 7060216 0
38 G0230650 BAUM G Y53 Q36 MASWELL PARK HEALTH CTR. HOUNSLOW AVENUE HOUNSLOW MIDDLESEX   TW3 2DY 1974-04-01 00:00:00 1998-11-16 00:00:00 C O E85600 1974-04-01 00:00:00 1998-11-16 00:00:00 020 86303476 0
39 G0230870 BARNETT TJ Y12 QDW 92 HINTON WOOD AVENUE HIGHCLIFFE CHRISTCHURCH DORSET   BH23 5AJ 1974-04-01 00:00:00 1995-03-31 00:00:00 C P J81601 1974-04-01 00:00:00 1995-03-31 00:00:00 0425 273344 0
40 G0230997 BOOTHMAN J Y51 Q31 153 GARSTANG ROAD FULWOOD PRESTON     PR2 3BH 1974-04-01 00:00:00 1992-02-14 00:00:00 C O P81103 1974-04-01 00:00:00 1992-02-14 00:00:00 01772 645665 0
41 G0231163 BOULTON M Y51 Q32 MANSTON SURGERY 72-76 AUSTHORPE ROAD LEEDS     LS15 8DZ 1974-04-01 00:00:00 1993-04-07 00:00:00 C O B86009 1974-04-01 00:00:00 1993-04-07 00:00:00 0113 2645455 0
42 G0231235 BROWN EWJ Y52 Q37 84 KING STREET MAIDSTONE KENT     ME14 1DZ 1974-04-01 00:00:00 1992-04-05 00:00:00 C O G82031 1974-04-01 00:00:00 1992-04-05 00:00:00 01622 756721 0
43 G0231486 BURDON AT Y51 Q30 29 ROSEWORTH AVENUE GOSFORTH NEWCASTLE     NE3 1HS 1974-04-01 00:00:00 1993-10-31 00:00:00 C O A86006 1974-04-01 00:00:00 1993-10-31 00:00:00 091 2858035 0
44 G0231606 BOND GA Y51 Q35 VANGE HEALTH CENTRE SOUTHVIEW ROAD VANGE, BASILDON ESSEX   SS16 4HD 1974-04-01 00:00:00 1993-01-01 00:00:00 C O F81006 1974-04-01 00:00:00 1993-01-01 00:00:00 0268 533151 0
45 G0232009 BUTCHER RM Y52 Q37 THE SQUARE MED PRACTICE HIGH STREET GODALMING SURREY   GU7 1AZ 1974-04-01 00:00:00 1994-08-07 00:00:00 C O H81021 1974-04-01 00:00:00 1994-08-07 00:00:00 0483 415141 0
46 G0232023 BULLOCK J Y51 Q34 RESERVOIR ROAD SURGERY 157-159 RESERVOIR ROAD ERDINGTON BIRMINGHAM   B23 6DN 1974-04-01 00:00:00 1995-04-03 00:00:00 C O M85070 1974-04-01 00:00:00 1995-04-03 00:00:00 021 3730601 0
47 G0232157 BASIL A V W00 QW4 PLAS MEDDYG STATION ROAD RUTHIN CLWYD   LL15 1BP 1974-04-01 00:00:00 1993-01-01 00:00:00 C O W91002 1974-04-01 00:00:00 1993-01-01 00:00:00 08242 2255 0
48 G0232243 BAKER PM Y51 Q33 THE MEDICAL CENTRE LOUGHBOROUGH UNIVERSITY OF TECHNOLOGY LEICESTERSHIRE   LE11 3TU 1974-04-01 00:00:00 1992-10-01 00:00:00 C O C82111 1974-04-01 00:00:00 1992-10-01 00:00:00 01509 222062 0
49 G0232267 BROWN NG Y07 QD9 454 HAGLEY ROAD WEST OLDBURY WEST MIDLANDS     B68 0DL 1974-04-01 00:00:00 1993-04-02 00:00:00 C O M85101 1974-04-01 00:00:00 1993-04-02 00:00:00 021 4226938 0
50 G0232494 BALFOUR-LYNN LP Y53 Q36 7 KIDDERPORE GARDENS   LONDON     NW3 7SS 1974-04-01 00:00:00 1998-05-04 00:00:00 C O F83602 1974-04-01 00:00:00 1998-05-04 00:00:00 020 74315991 0
51 G0232614 BASTIN AC Y52 Q39 THE SURGERY CHURCH STREET YETMINSTER SHERBORNE   DT9 6LG 1974-04-01 00:00:00 2000-03-31 00:00:00 C O J81017 1974-04-01 00:00:00 2000-03-31 00:00:00 01935 872530 0
52 G0232621 BURKE RA Y53 Q36 THE SURGERY 37 HIGH ROAD TOTTENHAM     N15 6DS 1974-04-01 00:00:00 1995-04-06 00:00:00 C O F85071 1974-04-01 00:00:00 1995-04-06 00:00:00 081 8096445 0
53 G0233110 BLAKE HV Y11 QAM 4 ALBION STREET   LEWES     BN7 2ND 1974-04-01 00:00:00 1993-04-08 00:00:00 C P G81067 1974-04-01 00:00:00 1993-04-08 00:00:00   0
54 G0233220 BROWN GT Y07 QD9 454 HAGLEY ROAD WEST OLDBURY WEST MIDLANDS     B68 0DL 1974-04-01 00:00:00 1993-04-02 00:00:00 C P M85101 1974-04-01 00:00:00 1993-04-02 00:00:00 021 4226938 0
55 G0233756 BRYANS SA Y53 Q36 13 PIMLICO ROAD   LONDON     SW1W 8NA 1974-04-01 00:00:00 1991-10-01 00:00:00 C O E87005 1974-04-01 00:00:00 1991-10-01 00:00:00 020 75908000 0
56 G0233770 BEVERIDGE K Y51 Q30 HARBINSON HOUSE FRONT STREET, SEDGEFIELD STOCKTON-ON-TEES CLEVELAND   TS21 3BN 1974-04-01 00:00:00 1995-02-01 00:00:00 C O A83054 1974-04-01 00:00:00 1995-02-01 00:00:00 01740 620300 0
57 G0234018 BRACEWELL BF W00 QW4 CLARENCE HOUSE 14 RUSSELL ROAD RHYL CLWYD   LL18 3BY 1974-04-01 00:00:00 1996-08-03 00:00:00 C O W91003 1974-04-01 00:00:00 1996-08-03 00:00:00 01745 350680 0
58 G0312125 CROMBIE DL Y51 Q34 LORDSWOOD HSE MED.G/PRACT 54 LORDSWOOD ROAD HARBORNE BIRMINGHAM   B17 9DB 1974-04-01 00:00:00 1992-11-21 00:00:00 C O M85028 1974-04-01 00:00:00 1992-11-21 00:00:00 0121 4262030 0
59 G0316442 CURRAN MJ Y10 QAH 75 CLAPHAM ROAD   LONDON     SW9 0HY 1974-04-01 00:00:00 1994-01-12 00:00:00 C P G85604 1974-04-01 00:00:00 1994-01-12 00:00:00 071 7356981 0
60 G0316686 CONNOLLY CM Y51 Q31 ISLINGTON HOUSE 3 ISLINGTON SQUARE LIVERPOOL     L6 8DD 1974-04-01 00:00:00 1993-05-01 00:00:00 C O N82081 1974-04-01 00:00:00 1993-05-01 00:00:00 051 2070848 0
61 G0318406 CONNORS TB Y51 Q33 THE SURGERY, THE SANDS LONG CLAWSON MELTON MOWBRAY LEICESTERSHIRE   LE14 4PA 1974-04-01 00:00:00 1992-11-11 00:00:00 C O C82016 1974-04-01 00:00:00 1992-11-11 00:00:00 01664 822214 0
62 G0319689 CROWN IW Y53 Q36 105 BELLENDEN ROAD DULWICH LONDON     SE15 4QY 1974-04-01 00:00:00 1993-08-28 00:00:00 C O G85031 1974-04-01 00:00:00 1993-08-28 00:00:00 071 6399622 0
63 G0320704 CALLER M Y53 Q36 42-44 QUEENSTOWN ROAD BATTERSEA LONDON     SW8 3RY 1974-04-01 00:00:00 1994-02-26 00:00:00 C O H85003 1974-04-01 00:00:00 1994-02-26 00:00:00 071 6229295 0
64 G0320780 CARRUTHERS GB Y10 QA3 55 WIMPOLE STREET   LONDON     W1M 7DF 1974-04-01 00:00:00 1994-12-21 00:00:00 C P E87607 1974-04-01 00:00:00 1994-12-21 00:00:00 071 4864646 0
65 G0321310 CAMAC JC Y51 Q33 SWADLINCOTE SURGERY DARKLANDS RD, SWADLINCOTE BURTON-ON-TRENT STAFFORDSHIRE   DE11 0PQ 1974-04-01 00:00:00 1992-03-31 00:00:00 C O C81032 1974-04-01 00:00:00 1992-03-31 00:00:00 01283 551717 0
66 G0322115 CARR JD Y51 Q32 THE NEW SURGERY WILFRID TERRACE BRANCH ROAD LOWER WORTLEY,LEEDS   LS12 5NR 1974-04-01 00:00:00 1997-02-04 00:00:00 C O B86604 1974-04-01 00:00:00 1997-02-04 00:00:00 0113 2310326 0
67 G0322304 CRESSWELL EA Y51 Q31 FAILSWORTH HEALTH CENTRE ASHTON ROAD WEST FAILSWORTH MANCHESTER   M35 0HN 1974-04-01 00:00:00 1992-01-06 00:00:00 C O P85008 1974-04-01 00:00:00 1992-01-06 00:00:00 0161 6826297 0
68 G0322490 COWAN DL Y10 QA3 1 GREAT WESTERN ROAD   LONDON     W9 3NW 1974-04-01 00:00:00 1994-10-16 00:00:00 C P E87608 1974-04-01 00:00:00 1994-10-16 00:00:00 071 2869697 0
69 G0322720 CRAIG DS Y02 QCL 30 EVINGTON LANE   LEICESTER     LE5 5PN 1974-04-01 00:00:00 1993-11-22 00:00:00 C P C82601 1974-04-01 00:00:00 1993-11-22 00:00:00 0116 2736249 0
70 G0323549 CREE JA Y53 Q36 LANE END HOUSE 25 EDGWAREBURY LANE EDGWARE MIDDLESEX   HA8 8LJ 1974-04-01 00:00:00 1994-04-01 00:00:00 C O E83053 1990-10-01 00:00:00 1994-04-01 00:00:00 081 9584233 0
71 G0323611 CALLANDER WH Y51 Q32 THE GREAT HORTON MED.CTR. 3 PATERNOSTER LANE GREAT HORTON BRADFORD   BD7 3EE 1974-04-01 00:00:00 1993-06-30 00:00:00 C O B83055 1990-04-09 00:00:00 1993-06-30 00:00:00 0274 502905 0
72 G0323941 CARNE SJ Y53 Q36 THE GROVE HEALTH CENTRE 95 GOLDHAWK ROAD SHEPHERDS BUSH LONDON   W12 8EJ 1974-04-01 00:00:00 1992-01-03 00:00:00 C O E85016 1974-04-01 00:00:00 1992-01-03 00:00:00 020 33156655 0
73 G0324320 CHARKIN LA Y53 Q36 ST JOHN'S WOOD MED PRACT 22 ST ANN'S TERRACE ST JOHN'S WOOD LONDON   NW8 6PJ 1974-04-01 00:00:00 1995-10-01 00:00:00 C O E87609 1974-04-01 00:00:00 1995-10-01 00:00:00 0844 4778590 0
74 G0324519 CHAPMAN PJL Y51 Q31 HEALD GREEN HEALTH CENTRE FINNEY LANE HEALD GREEN CHEADLE,CHESHIRE   SK8 3JD 1974-04-01 00:00:00 1993-06-30 00:00:00 C O P88023 1974-04-01 00:00:00 1993-06-30 00:00:00 0161 4368384 0
75 G0325338 CHAPMAN JB Y52 Q37 INGLESIDE SURGERY 34 MAIDSTONE ROAD BOROUGH GREEN KENT   TN15 8BE 1974-04-01 00:00:00 1992-01-03 00:00:00 C O G82120 1974-04-01 00:00:00 1992-01-03 00:00:00 01732 883161 0
76 G0325534 CHILDS DR Y52 Q39 BURNHAM MEDICAL CENTRE LOVE LANE BURNHAM-ON-SEA SOMERSET   TA8 1EU 1974-04-01 00:00:00 1994-02-02 00:00:00 C O L85016 1974-04-01 00:00:00 1994-02-02 00:00:00 0278 782283 0
77 G0326250 CHASE NBA Y53 Q36 55 LITTLE HEATH ROAD BEXLEYHEATH KENT     DA7 5HL 1974-04-01 00:00:00 1994-04-30 00:00:00 C O G83033 1974-04-01 00:00:00 1994-04-30 00:00:00 0844 5769016 0
78 G0326401 CHALMERS RB Y51 Q35 THE OLD RECTORY 18 CASTLE STREET SAFFRON WALDEN ESSEX   CB10 1BP 1974-04-01 00:00:00 1991-07-01 00:00:00 C O F81015 1974-04-01 00:00:00 1991-07-01 00:00:00 01799 522327 0
79 G0326463 CLARK R Y51 Q31 AWBURN HOUSE MOTTRAM MOOR MOTTRAM, VIA HYDE CHESHIRE   SK14 6LA 1974-04-01 00:00:00 1998-09-06 00:00:00 C O P89004 1974-04-01 00:00:00 1998-09-06 00:00:00 01457763263 0
80 G0326535 COUNIHAN RG Y53 Q36 14 ELSENHAM STREET SOUTHFIELDS LONDON     SW18 5NS 1974-04-01 00:00:00 1998-10-02 00:00:00 C O H85007 1974-04-01 00:00:00 1998-10-02 00:00:00 0181 9461403 0
81 G0327244 CRAIG A Y51 Q32 GIRLINGTON PRACTICE 252 GIRLINGTON ROAD BRADFORD     BD8 9PB 1974-04-01 00:00:00 1992-01-18 00:00:00 C O B83012 1974-04-01 00:00:00 1992-01-18 00:00:00 01274 484111 0
82 G0327275 CRANE JL Y53 Q36 AYLESBURY HEALTH CENTRE THURLOW STREET WALWORTH LONDON   SE17 2UN 1974-04-01 00:00:00 1995-05-28 00:00:00 C O G85012 1974-04-01 00:00:00 1995-05-28 00:00:00 071 7032205 0
83 G0327282 CROSS AF Y53 Q36 DYSART SURGERY 13 RAVENSBOURNE ROAD BROMLEY KENT   BR1 1HN 1974-04-01 00:00:00 1993-12-31 00:00:00 C O G84002 1974-04-01 00:00:00 1993-12-31 00:00:00 081 4640718 0
84 G0327347 CRAWFORD WA Y52 Q37 THE SURGERY CLIFF STREET RAMSGATE KENT   CT11 9HU 1974-04-01 00:00:00 1993-03-02 00:00:00 C O G82046 1974-04-01 00:00:00 1993-03-02 00:00:00 01843 591758 0
85 G0327433 CUMBERBATCH JB Y53 Q36 127 TRINITY ROAD TOOTING LONDON     SW17 7HJ 1974-04-01 00:00:00 1996-06-30 00:00:00 C O H85005 1974-04-01 00:00:00 1996-06-30 00:00:00 020 86723331 0
86 G0327608 CHITNIS JG Y51 Q34 THE CASTLE PRACTICE 2 HAWTHORNE ROAD CASTLE BROMWICH BIRMINGHAM   B36 0HH 1974-04-01 00:00:00 1997-01-05 00:00:00 C O M89026 1974-04-01 00:00:00 1997-01-05 00:00:00 01217472422 0
87 G0327684 COOKE ED Y53 Q36 NIGHTINGALE PRACTICE 10 KENNINGHALL ROAD CLAPTON LONDON   E5 8BY 1974-04-01 00:00:00 1995-03-31 00:00:00 C O F84018 1974-04-01 00:00:00 1995-03-31 00:00:00 01819858388 0
88 G0327976 COHEN C Y01 QDN PALLION HEALTH CENTRE HYLTON ROAD SUNDERLAND     SR4 7XF 1974-04-01 00:00:00 1991-04-07 00:00:00 C P A89601 1974-04-01 00:00:00 1991-04-07 00:00:00   0
89 G0328056 CANNON WJ Y53 Q36 ERITH HEALTH CENTRE QUEEN STREET ERITH KENT   DA8 1TT 1974-04-01 00:00:00 1995-08-02 00:00:00 C O G83048 1974-04-01 00:00:00 1995-08-02 00:00:00 01322334237 0
90 G0328128 COURY JC Y52 Q38 66 WESTWOOD ROAD TILEHURST READING BERKSHIRE   RG3 5PP 1974-04-01 00:00:00 1993-07-31 00:00:00 C O K81056 1974-04-01 00:00:00 1993-07-31 00:00:00 0118 9427421 0
91 G0403108 DEANE A Y10 QA3 12 THURLOE STREET   LONDON     SW7 2ST 1974-04-01 00:00:00 1991-08-22 00:00:00 C P E87610 1974-04-01 00:00:00 1991-08-22 00:00:00   0
92 G0403380 DE KEYSER GM Y51 Q32 THE HEALTH CENTRE CORPORATION STREET MORLEY LEEDS   LS27 9NB 1974-04-01 00:00:00 1993-03-31 00:00:00 C O B86067 1974-04-01 00:00:00 1993-03-31 00:00:00 0113 2951600 0
93 G0409960 DOOHAN J Y51 Q31 1079 ROCHDALE ROAD BLACKLEY MANCHESTER     M9 1AJ 1974-04-01 00:00:00 1993-09-06 00:00:00 C O P84019 1974-04-01 00:00:00 1993-09-06 00:00:00 0844 8151573 0
94 G0410250 DEWSBURY E Y07 QEA QUEENSWOOD NURSING HOME TAMWORTH ROAD KERESLEY END COVENTRY   CV7 8JG 1974-04-01 00:00:00 1996-03-31 00:00:00 C P M86600 1974-04-01 00:00:00 1996-03-31 00:00:00 01203 688225 0
95 G0414357 DESMOND M Y51 Q31 PARK HOUSE SURGERY 55 HIGHER PARR STREET ST. HELENS MERSEYSIDE   WA9 1BP 1974-04-01 00:00:00 1991-06-30 00:00:00 C O N83023 1974-04-01 00:00:00 1991-06-30 00:00:00 01744 752521 0
96 G0415107 DIPPIE THP Y51 Q34 JAMES PRESTON HEALTH CTR. 61 HOLLAND ROAD SUTTON COLDFIELD WEST MIDLANDS   B72 1RQ 1974-04-01 00:00:00 1991-04-30 00:00:00 C O M85033 1974-04-01 00:00:00 1991-04-30 00:00:00 0121 3542032 0
97 G0415145 DINERSTEIN MI Y08 QC6 THE SURGERY 53 LEICESTER ROAD SALFORD     M7 4AS 1974-04-01 00:00:00 1991-06-30 00:00:00 C P P87602 1974-04-01 00:00:00 1991-06-30 00:00:00   0
98 G0415176 DANIELS EP Y07 QD9 213 WORLDS END LANE QUINTON BIRMINGHAM     B32 2RY 1974-04-01 00:00:00 1991-09-30 00:00:00 C P M85607 1974-04-01 00:00:00 1991-09-30 00:00:00   0
99 G0415358 DAVIES JOAN V Y52 Q39 THE OLD BANKHOUSE CHURCH LANE BLANDFORD FORUM DORSET   DT11 7AE 1974-04-01 00:00:00 1992-04-03 00:00:00 C O J81031 1974-04-01 00:00:00 1992-04-03 00:00:00 01258 453171 0
100 G0415554 DAVIES M W00 QW3 1 UPPER PARK STREET LLANELLI DYFED     SA15 3YN 1974-04-01 00:00:00 1995-12-01 00:00:00 C O W92011 1974-04-01 00:00:00 1995-12-01 00:00:00 01554773747 0

Next page

CREATE TABLE "egparc" (
"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,
  "Contact Telephone Number" TEXT,
  "Amended Record Indicator" INTEGER
)
Powered by Datasette · Query took 26.929ms · Data source: OUseful Databeat