home / nhsadmin

Current General Medical Practitioners (GPs)

Data source: OUseful Databeat

83,108 rows

View and edit SQL

This data as .json

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 Current Care Organisation
1 G0102005 ALLEN EB Y11 QAL FIRCROFT, LONDON ROAD ENGLEFIELD GREEN EGHAM SURREY   TW20 0BS 1974-04-01 00:00:00   A P H81600 1974-04-01 00:00:00 1991-04-01 00:00:00   0  
2 G0102926 ANDERSON MG Y55 Q79 LENSFIELD MEDICAL PRAC. 48 LENSFIELD ROAD CAMBRIDGE     CB2 1EH 1974-04-01 00:00:00   A O D81001 1974-04-01 00:00:00 1991-12-31 00:00:00 01223 651020 0 06H
3 G0105912 ADLER S Y56 Q71 682 FINCHLEY ROAD GOLDERS GREEN LONDON     NW11 7NP 1974-04-01 00:00:00   A O E83600 1974-04-01 00:00:00 1992-07-31 00:00:00 020 84559994 0 07M
4 G0107031 ATTWOOD DC Y54 Q83 GREAT LEVER HEALTH CENTRE RUPERT STREET,GREAT LEVER BOLTON LANCASHIRE   BL3 6RN 1974-04-01 00:00:00   A O P82013 1974-04-01 00:00:00 1991-05-25 00:00:00 01204 462141 0 00T
5 G0107725 ALEXANDER PJ Y01 QDF 10 WEST END SWANLAND HUMBERSIDE     HU14 3PE 1974-04-01 00:00:00   A P B81600 1974-04-01 00:00:00 1994-04-09 00:00:00 0482 633570 0  
6 G0108018 ALLDRIDGE DGE Y57 Q81 OAKFIELD 158 STATION ROAD REDHILL SURREY   RH1 1HF 1974-04-01 00:00:00   A O H81083 1974-04-01 00:00:00 1992-01-02 00:00:00 01737 642207 0 09L
7 G0108324 ANDERSON CF Y54 Q74 THE HEALTH CENTRE LAWSON STREET STOCKTON ON TEES CLEVELAND   TS18 1HU 1974-04-01 00:00:00   A O A81001 1974-04-01 00:00:00 1991-07-01 00:00:00 01642 672351 0 00K
8 G0108867 ANTHONY RAJ Y57 Q82 THE LECKHAMPTON SURGERY LLOYD DAVIES HOUSE 17 MOOREND PARK ROAD CHELTENHAM   GL53 0LA 1974-04-01 00:00:00   A O L84040 1974-04-01 00:00:00 1993-04-27 00:00:00 0242 515363 0 11M
9 G0108922 ASHER PN Y56 Q71 94-96 HOLLOWAY ROAD   LONDON     N7 8JG 1974-04-01 00:00:00   A O F83013 1974-04-01 00:00:00 1995-11-02 00:00:00 01716072323 0  
10 G0109325 ARTHUR RA Y56 Q71 153 CANNON HILL LANE RAYNES PARK WEST WIMBLEDON LONDON   SW20 9DA 1974-04-01 00:00:00   A O H85016 1974-04-01 00:00:00 1992-05-01 00:00:00 020 85425201 0  
11 G0109459 ARMSTRONG JBO Y56 Q71 PORTLAND MEDICAL CENTRE 184 PORTLAND ROAD SOUTH NORWOOD LONDON   SE25 4QB 1974-04-01 00:00:00   A O H83001 1974-04-01 00:00:00 1995-07-27 00:00:00 020 86621233 0 07V
12 G0109497 AVISON JD Y10 QAG 1A ULLSWATER CRESCENT KINGSTON VALE LONDON     SW15 3RG 1974-04-01 00:00:00   A P H84600 1974-04-01 00:00:00 1993-08-01 00:00:00 081 5461190 0  
13 G0109662 ANDREW RA Y54 Q74 FELIX HOUSE SURGERY MIDDLETON LANE MIDDLETON ST.GEORGE DARLINGTON, CO.DURHAM   DL2 1AA 1974-04-01 00:00:00   A O A83070 1974-04-01 00:00:00 1991-09-01 00:00:00 01325 332022 0 00C
14 G0109693 ATKINS G Y55 Q77 139 HAMSTEAD ROAD HANDSWORTH BIRMINGHAM     B20 2BT 1974-04-01 00:00:00   A O M85009 1974-04-01 00:00:00 1991-05-06 00:00:00 0121 5237500 0 05L
15 G0109741 ADDLESTONE GR Y54 Q72 WOODHOUSE HEALTH CENTRE WOODHOUSE STREET LEEDS     LS6 2NS 1974-04-01 00:00:00   A O B86049 1974-04-01 00:00:00 1999-12-06 00:00:00 0113 2953510 0 02V
16 G0109923 ARMOUR AL Y08 QCY 22 STYAN STREET FLEETWOOD LANCASHIRE     FY7 6SX 1974-04-01 00:00:00   A P P81600 1974-04-01 00:00:00 1992-03-31 00:00:00   0  
17 G0110017 ASTON PL Y54 Q75 BUNBURY MEDICAL PRACTICE BUNBURY TARPORLEY CHESHIRE   CW6 9PJ 1974-04-01 00:00:00   A O N81006 1974-04-01 00:00:00 1995-07-31 00:00:00 01829260218 0 02F
18 G0110031 HENNEBRY S Y10 QAR 268 EALING ROAD ALPERTON WEMBLEY MIDDLESEX   HA0 4LL 1974-04-01 00:00:00   A P E84600 1974-04-01 00:00:00 1993-06-30 00:00:00 081 9020116 0  
19 G0110134 ALLEN JP Y54 Q72 THE HEALTH CENTRE BARTHOLOMEW AVENUE GOOLE NORTH HUMBERSIDE   DN14 6AW 1974-04-01 00:00:00   A O B81013 1974-04-01 00:00:00 1995-09-03 00:00:00 01405767711 0 02Y
20 G0110268 ANDERSON PCW Y55 Q76 MYTTON OAK MEDICAL PRACT. MYTTON OAK SURGERY RACECOURSE LANE SHREWSBURY, SHROPSHIRE   SY3 5LZ 1974-04-01 00:00:00   A O M82002 1974-04-01 00:00:00 1995-02-01 00:00:00 0743 362223 0 05N
21 G0110464 ALMOND DL Y55 Q78 PARKFIELD MEDICAL CENTRE THE WALK POTTERS BAR HERTFORDSHIRE   EN6 1QH 1974-04-01 00:00:00   A O E82027 1974-04-01 00:00:00 1995-10-01 00:00:00 01707 291041 0 06N
22 G0110529 ARMOUR AJ Y55 Q78 TASBURGH LODGE SURGERY 30 VICTORIA AVENUE WOODHALL SPA LINCOLNSHIRE   LN10 6TX 1974-04-01 00:00:00   A O C83634 1988-02-01 00:00:00 1993-10-04 00:00:00 0526 352466 0 03T
23 G0110615 AYNSWORTH SH Y57 Q70 THE SURGERY 187 GUDGE HEATH LANE FAREHAM HAMPSHIRE   PO15 6QA 1974-04-01 00:00:00   A O J82033 1974-04-01 00:00:00 1992-07-03 00:00:00 01329 280887 0 10K
24 G0215455 BUTLER I Y54 Q72 RIVERSIDE MEDICAL CENTRE SAVILE ROAD CASTLEFORD WEST YORKSHIRE   WF10 1PH 1974-04-01 00:00:00   A O B87005 1974-04-01 00:00:00 1991-11-04 00:00:00 01977 554831 0 03R
25 G0218616 BROOKES M Y54 Q83 EDENFIELD ROAD SURGERY CUTGATE ROCHDALE LANCASHIRE   OL11 5AQ 1974-04-01 00:00:00   A O P86003 1974-04-01 00:00:00 1991-10-09 00:00:00 01706 344125 0 01D
26 G0218843 BURT JH Y54 Q83 RIBBLESDALE HOUSE MED.CTR MARKET STREET BURY LANCASHIRE   BL9 0BU 1974-04-01 00:00:00   A O P83005 1974-04-01 00:00:00 1992-05-02 00:00:00 0161 7621600 0 00V
27 G0219332 BLAND LW Y57 Q81 76 CHICHESTER DRIVE WEST SALTDEAN BRIGHTON     BN2 8SF 1974-04-01 00:00:00   A O G81667 1974-04-01 00:00:00 1991-06-16 00:00:00 01273 302638 0 09D
28 G0223072 BICKLER GL Y54 Q72 WINDMILL HEALTH CENTRE MILL GREEN VIEW LEEDS     LS14 5JS 1974-04-01 00:00:00   A O B86007 1974-04-01 00:00:00 1991-11-10 00:00:00 0113 2733733 0 03G
29 G0225225 BETOURNAY LW Y55 Q78 MARSHALLS ROAD SURGERY 7 MARSHALLS ROAD RAUNDS, WELLINGBOROUGH NORTHAMPTONSHIRE   NN9 6ET 1974-04-01 00:00:00   A O K83069 1974-04-01 00:00:00 1995-09-02 00:00:00 01933 622349 0 04G
30 G0225328 BLAY ER Y57 Q80 THE SURGERY SCHOOL ROAD PRAZE-AN-BEEBLE CORNWALL   TR14 0LB 1985-08-16 00:00:00   A O L82068 1985-08-16 00:00:00 1992-03-18 00:00:00 01209 831386 0 11N
31 G0225610 BRADFORD P Y54 Q72 GROVE SURGERY CHARLOTTE STREET WAKEFIELD WEST YORKSHIRE   WF1 1UH 1974-04-01 00:00:00   A O B87029 1974-04-01 00:00:00 1991-06-30 00:00:00 01924 784101 0 03R
32 G0225689 BALDWIN LGJ Y57 Q80 ST.GEORGE HEALTH CENTRE BELLEVUE ROAD, ST.GEORGE BRISTOL     BS5 7PH 1974-04-01 00:00:00   A O L81062 1974-04-01 00:00:00 1991-12-31 00:00:00 0117 9612161 0 11H
33 G0226343 BISCOE CA Y57 Q80 THE PENRYN SURGERY SARACEN WAY PENRYN     TR10 8HX 1974-04-01 00:00:00   A O L82006 1974-04-01 00:00:00 1991-04-05 00:00:00 01326 372502 0 11N
34 G0227825 BUCKLEY WEG Y57 Q82 139 ST. GEORGES ROAD CHELTENHAM GLOUCESTERSHIRE     GL50 3EQ 1974-04-01 00:00:00   A O L84003 1974-04-01 00:00:00 1992-04-05 00:00:00 01242 580644 0 11M
35 G0228101 BARRON BM Y57 Q70 36 PARKSTONE ROAD POOLE DORSET     BH15 2PG 1974-04-01 00:00:00   A O J81064 1974-04-01 00:00:00 1992-01-01 00:00:00 01202 670111 0 11J
36 G0228383 BRAY JF Y10 QAD 1 HALING PARK ROAD SOUTH CROYDON SURREY     CR2 6NG 1974-04-01 00:00:00   A P H83600 1974-04-01 00:00:00 1998-07-01 00:00:00 0181 6880479 0  
37 G0228723 BUCKLEY JHM Y09 QAY MIRAMAR 1A TRINITY AVENUE WESTCLIFF-ON-SEA ESSEX   SS0 7PU 1974-04-01 00:00:00   A P F81600 1974-04-01 00:00:00 1991-06-30 00:00:00   0  
38 G0228967 BALL JG Y07 QEN NORTHUMBERLAND HOUSE SURG 437 STOURPORT ROAD KIDDERMINSTER WORCESTERSHIRE   DY11 7BL 1974-04-01 00:00:00   A P M81632 1994-04-02 00:00:00 1994-09-30 00:00:00 0562 745715 0  
39 G0229171 BANTON JG Y55 Q76 THE SURGERY CHURCH WALK EASTWOOD NOTTINGHAM   NG16 3BH 1974-04-01 00:00:00   A O C84002 1974-04-01 00:00:00 1994-06-04 00:00:00 0773 713447 0 04M
40 G0229212 BLACK GS Y54 Q74 2 BETTS AVENUE BENWELL NEWCASTLE UPON TYNE     NE15 6TQ 1974-04-01 00:00:00   A O A86030 1974-04-01 00:00:00 1994-04-04 00:00:00 091 2742767 0 13T
41 G0229449 BULL DW Y55 Q78 ROADE MEDICAL CENTRE 16 LONDON ROAD ROADE NORTHAMPTON   NN7 2NN 1974-04-01 00:00:00   A O K83052 1974-04-01 00:00:00 1992-08-31 00:00:00 01604 863100 1 04G
42 G0229456 BURKE W Y54 Q75 PENKETH HEALTH CENTRE HONITON WAY PENKETH, WARRINGTON CHESHIRE   WA5 2EY 1974-04-01 00:00:00   A O N81020 1974-04-01 00:00:00 1993-10-02 00:00:00 01925 725644 0 02E
43 G0229487 BOURDILLON JL Y55 Q78 BRACKLEY HEALTH CENTRE HALSE ROAD BRACKLEY     NN13 6EJ 1974-04-01 00:00:00   A O K83004 1974-04-01 00:00:00 1993-03-31 00:00:00 01280 703460 0 04G
44 G0229535 BAILEY PB Y57 Q80 STOCKWOOD HEALTH CENTRE HOLLWAY ROAD STOCKWOOD BRISTOL   BS14 8PT 1974-04-01 00:00:00   A O L81009 1974-04-01 00:00:00 1991-04-01 00:00:00 01275 833103 0 11H
45 G0229597 BURNS LJ Y54 Q72 THE SURGERY UPPER WARRENGATE WAKEFIELD WEST YORKSHIRE   WF1 4JZ 1974-04-01 00:00:00   A O B87004 1974-04-01 00:00:00 1993-10-03 00:00:00 0924 371011 0 03R
46 G0229748 BULL MJV Y57 Q82 ST.BARTHOLOMEWS MED.CTR. MANZIL WAY COWLEY ROAD OXFORD   OX4 1XB 1974-04-01 00:00:00   A O K84013 1974-04-01 00:00:00 1992-09-30 00:00:00 0865 242334 0 10Q
47 G0229755 BROMHAM DG W00 Q99 CASTLE SURGERY 1 PRINCE OF WALES DRIVE NEATH WEST-GLAMORGAN     1974-04-01 00:00:00   A O W98006 1974-04-01 00:00:00 1993-10-03 00:00:00 0639 55331 0 7A3
48 G0229786 BILLINGHAM GP Y57 Q82 MERCHISTON 10 SWINDON ROAD STRATTON ST. MARGARET SWINDON, WILTSHIRE   SN3 4QB 1974-04-01 00:00:00   A O J83001 1974-04-01 00:00:00 1991-06-30 00:00:00 01793 823307 0 12D
49 G0229841 BEALE IR Y54 Q74 THE CROFT SPRINGWELL ROAD WREKENTON, GATESHEAD TYNE & WEAR   NE9 7BJ 1974-04-01 00:00:00   A O A85016 1974-04-01 00:00:00 1991-09-30 00:00:00 0191 4876129 0 13T
50 G0230038 BERGER MJ Y54 Q72 HIGHFIELD SURGERY HOLTDALE APPROACH LEEDS     LS16 7ST 1974-04-01 00:00:00   A O B86004 1974-04-01 00:00:00 1998-11-08 00:00:00 0113 2953600 0 03C
51 G0230069 BRACCHI ALC W00 Q99 TUDOR GATE SURGERY TUDOR STREET ABERGAVENNY GWENT   NP7 5DL 1974-04-01 00:00:00   A O W93004 1974-04-01 00:00:00 1995-04-30 00:00:00 0873 715991 0 7A6
52 G0230076 BEWICK JA Y55 Q77 NORTHBROOK HEALTH CENTRE 93 NORTHBROOK ROAD SHIRLEY, SOLIHULL WEST MIDLANDS   B90 3LX 1974-04-01 00:00:00   A O M89015 1974-04-01 00:00:00 1992-03-31 00:00:00 0121 7465000 0 05P
53 G0230124 BATCHELOR PM Y57 Q81 THE FAMILY HEALTH CENTRE STEPGATES CHERTSEY SURREY   KT16 8HY 1974-04-01 00:00:00   A O H81033 1974-04-01 00:00:00 1991-04-05 00:00:00 01932 565655 0 09Y
54 G0230155 BARBOUR J Y54 Q75 MORETON HEALTH CLINIC 8 CHADWICK STREET MORETON WIRRAL   L46 7XA 1974-04-01 00:00:00   A O N85040 1974-04-01 00:00:00 1992-09-30 00:00:00 0151 5220099 0 12F
55 G0230179 BURROW GRF Y02 QCR ENDFIELD HOUSE 4 BEIGHTON ROAD WOODHOUSE SHEFFIELD   S13 7PR 1974-04-01 00:00:00   A P C88600 1974-04-01 00:00:00 1991-12-31 00:00:00   0  
56 G0230186 BOOMLA DF Y56 Q71 PLUMSTEAD HEALTH CENTRE TEWSON ROAD PLUMSTEAD LONDON   SE18 1BB 1974-04-01 00:00:00   A O G83007 1974-04-01 00:00:00 1991-06-30 00:00:00 020 83176300 0 08A
57 G0230351 BURGESS P Y54 Q83 177 MAULDETH ROAD FALLOWFIELD MANCHESTER     M14 6SG 1974-04-01 00:00:00   A O P84017 1974-04-01 00:00:00 1991-08-03 00:00:00 0161 4484500 1 14L
58 G0230526 BROWN DP Y55 Q77 HILLVIEW MEDICAL CENTRE 60 BROMSGROVE ROAD REDDITCH WORCESTERSHIRE   B97 4RN 1974-04-01 00:00:00   A O M81041 2006-09-01 00:00:00   01527 66511 0 05J
59 G0230557 BEGG FM Y54 Q74 THE HEALTH CENTRE BOW STREET GUISBOROUGH CLEVELAND   TS14 7AA 1974-04-01 00:00:00   A O A81005 1974-04-01 00:00:00 1991-07-01 00:00:00 01287 619611 0 00M
60 G0230753 BENNET RB Y55 Q78 19 AMWELL STREET HODDESDON HERTFORDSHIRE     EN11 8TU 1974-04-01 00:00:00   A O E82061 1974-04-01 00:00:00 1993-07-02 00:00:00 01992 464147 0 06K
61 G0230856 BOTTOMLEY DH Y54 Q74 PARKGATE HEALTH CENTRE PARK PLACE DARLINGTON COUNTY DURHAM   DL1 5LW 1974-04-01 00:00:00   A O A83040 1974-04-01 00:00:00 1992-01-05 00:00:00 01325 465646 0 00C
62 G0230863 BAKER GAE Y57 Q82 THE HEALTH CENTRE BOND STREET ENGLEFIELD GREEN SURREY   TW20 0PF 1974-04-01 00:00:00   A O H81047 1974-04-01 00:00:00 1991-04-05 00:00:00 01784 437671 0 11C
63 G0231015 BERRY J Y54 Q74 THE HEALTH CENTRE VICTORIA ROAD HARTLEPOOL CLEVELAND   TS26 8DB 1974-04-01 00:00:00   A O A81007 1974-04-01 00:00:00 1994-04-06 00:00:00 0429 274386 0 00K
64 G0231613 BELL C Y51 Q32 77 PARK STREET WOMBWELL BARNSLEY     S73 0HJ 1974-04-01 00:00:00   A O C85600 1974-04-01 00:00:00 1999-09-27 00:00:00 01226 752161 0  
65 G0231620 BURKHARDT AJ Y57 Q81 BINSCOMBE MEDICAL CENTRE 106 BINSCOMBE GODALMING SURREY   GU7 3PR 1974-04-01 00:00:00   A O H81026 1974-04-01 00:00:00 1994-03-31 00:00:00 01483 415115 0 09N
66 G0231778 BEE BH Y52 Q38 HAVANT HEALTH CENTRE CIVIC CENTRE ROAD HAVANT HAMPSHIRE   PO9 2AZ 1974-04-01 00:00:00   A O J82014 1974-04-01 00:00:00 1991-05-05 00:00:00 023 92475010 0  
67 G0231833 BRUCE JD Y57 Q80 CARNEWATER PRACTICE DENNISON ROAD BODMIN CORNWALL   PL31 2LB 1974-04-01 00:00:00   A O L82009 1974-04-01 00:00:00 1995-03-31 00:00:00 01208 72321 0 11N
68 G0231864 BEARDSWORTH BS Y55 Q78 PRACTICE A HEALTH CENTRE,HILL STREET HINCKLEY LEICESTERSHIRE   LE10 1DS 1974-04-01 00:00:00   A O C82043 1974-04-01 00:00:00 1998-03-29 00:00:00 01455 635362 0 04V
69 G0231905 BOGGIANO P Y54 Q75 BEACONSFIELD SURGERY 1 BEACONSFIELD ROAD WIDNES CHESHIRE   WA8 9LB 1974-04-01 00:00:00   A O N81011 1974-04-01 00:00:00 1997-06-30 00:00:00 0151424 3232 0 01F
70 G0231967 BROWN AL Y54 Q83 ROBERT DARBISHIRE PRACT. RUSHOLME HEALTH CENTRE WALMER STREET,RUSHOLME MANCHESTER   M14 5NP 1974-04-01 00:00:00   A O P84072 1988-11-01 00:00:00 1995-04-30 00:00:00 01612256699 1 14L
71 G0232126 BOVETT EJ Y57 Q70 THE BROWNHILL SURGERY 2 BROWNHILL ROAD CHANDLERS FORD EASTLEIGH, HAMPSHIRE   SO53 2ZB 1974-04-01 00:00:00   A O J82190 1974-04-01 00:00:00 1996-06-30 00:00:00 02380 252414 0 11A
72 G0232171 BARRY TN Y55 Q77 THE SURGERY 2 BATE STREET WALSALL WEST MIDLANDS   WS2 8EL 1974-04-01 00:00:00   A O M91004 1974-04-01 00:00:00 1992-04-01 00:00:00 01922 623755 0 05Y
73 G0232205 BRIMACOMBE L Y54 Q72 23 ABBEY LANE   SHEFFIELD     S8 0BJ 1974-04-01 00:00:00   A O C88046 1974-04-01 00:00:00 1997-06-30 00:00:00 0114 2745360 0 03N
74 G0232229 BEKENN PJ Y55 Q77 THE RIDGEWAY SURGERY 175 THE RIDGEWAY, SEDGLEY DUDLEY WEST MIDLANDS   DY3 3UH 1974-04-01 00:00:00   A O M87007 1974-04-01 00:00:00 1997-05-05 00:00:00 01902 884343 0 05C
75 G0232298 BURNETT PJ Y54 Q74 THE HEALTH CENTRE THORNHILL ROAD PONTELAND NEWCASTLE-UPON-TYNE   NE20 9PZ 1974-04-01 00:00:00   A O A84007 1974-04-01 00:00:00 1996-10-01 00:00:00 01661825513 0 00L
76 G0232449 BURGES DCL Y51 Q34 QUINTON FAMILY PRACTICE 406 QUINTON ROAD WEST QUINTON,BIRMINGHAM     B32 1QG 1974-04-01 00:00:00   A O M85102 1974-04-01 00:00:00 1998-10-08 00:00:00 0121 4216011 0  
77 G0232487 BAKER PR Y54 Q75 CUMBERLAND HOUSE JORDANGATE MACCLESFIELD CHESHIRE   SK10 1EG 1974-04-01 00:00:00   A O N81062 1974-04-01 00:00:00 1992-06-30 00:00:00 01625 428081 0 01C
78 G0232717 BLACK DH Y57 Q70 THE SURGERY 1 ROWNER ROAD GOSPORT HAMPSHIRE   PO13 9UA 1974-04-01 00:00:00   A O J82127 1974-04-01 00:00:00 1991-07-05 00:00:00 023 92794169 0 10K
79 G0232779 BOLTON TW Y55 Q78 THE SURGERY 29 BASSETT ROAD LEIGHTON BUZZARD BEDFORDSHIRE   LU7 7AR 1974-04-01 00:00:00   A O E81003 1974-04-01 00:00:00 1998-01-14 00:00:00 01525 373111 0 06F
80 G0232858 BLANEY JA Y54 Q75 G.P. UNIT ST.CATHERINES HOSPITAL CHURCH ROAD BIRKENHEAD   L42 0LQ 1974-04-01 00:00:00   A O N85041 1974-04-01 00:00:00 1991-09-30 00:00:00 0151 6436700 0 12F
81 G0232872 BAMFORTH M Y51 Q32 THE SURGERY 51 CLARE ROAD HALIFAX WEST YORKSHIRE   HX1 2JP 1974-04-01 00:00:00   A O B84600 1974-04-01 00:00:00 1992-09-30 00:00:00 0844 4773630 0  
82 G0232920 BOOTHBY K Y55 Q79 NORTH STREET MED.PRACTICE 1 NORTH STREET PETERBOROUGH CAMBRIDGESHIRE   PE1 2RA 1974-04-01 00:00:00   A O D81006 1974-04-01 00:00:00 1991-10-04 00:00:00 01733 312525 0  
83 G0232944 BONNER-MORGAN GR Y52 Q37 2 THE GLADE STONELEIGH EPSOM SURREY   KT17 2HB 1974-04-01 00:00:00   A O H81100 1974-04-01 00:00:00 1993-08-15 00:00:00 081 3937788 0  
84 G0233062 BARROWCLIFFE DG Y54 Q72 GREENHILL HEALTH CENTRE 482 LUPTON ROAD SHEFFIELD     S8 7NP 1990-10-08 00:00:00   A O C88653 1997-08-25 00:00:00 2002-04-03 00:00:00 0845 1270271 0  
85 G0233103 BOWEN PD Y57 Q81 THE PARK SURGERY ALBION WAY HORSHAM WEST SUSSEX   RH12 1BG 1974-04-01 00:00:00   A O H82017 1974-04-01 00:00:00 1991-06-30 00:00:00 01403 330266 0 09X
86 G0233172 BELL JR Y54 Q72 THE HEALTH CENTRE STATION AVENUE BRIDLINGTON NORTH HUMBERSIDE   YO16 4LZ 1974-04-01 00:00:00   A O B81014 1974-04-01 00:00:00 1991-08-01 00:00:00 01262 670690 0 02Y
87 G0233309 BLOOMFIELD AE Y56 Q71 ST.JAMES' HEALTH CENTRE ST.JAMES' STREET WALTHAMSTOW     E17 7NH 1974-04-01 00:00:00   A O F86058 1974-04-01 00:00:00 1994-01-16 00:00:00 081 5216138 0 08W
88 G0233354 BODDINGTON DG Y55 Q77 NUNWELL SURGERY 10 PUMP STREET BROMYARD HEREFORDSHIRE   HR7 4BZ 1974-04-01 00:00:00   A O M81048 1974-04-01 00:00:00 1993-07-05 00:00:00 0885 483412 0 05F
89 G0233718 BRUCE RG Y55 Q79 82 VICTORIA ROAD OULTON BROAD LOWESTOFT     NR33 9LU 1974-04-01 00:00:00   A O D83016 1974-04-01 00:00:00 1992-09-04 00:00:00 01502 572369 0 06M
90 G0233952 BINLESS JT Y54 Q83 MARPLE BRIDGE SURGERY TOWN ST, MARPLE BRIDGE STOCKPORT CHESHIRE   SK6 5AA 1974-04-01 00:00:00   A O P88002 1974-04-01 00:00:00 1998-10-09 00:00:00 0161 4271074 0 01W
91 G0234063 BENNETT PMJ Y57 Q81 THE HEALTH CENTRE MADEIRA ROAD WEST BYFLEET SURREY   KT14 6DH 1974-04-01 00:00:00   A O H81036 1974-04-01 00:00:00 1999-09-30 00:00:00 01932 336933 0 09Y
92 G0306380 CLUBB JM Y57 Q82 BURY KNOWLE HEALTH CENTRE 207 LONDON RD, HEADINGTON OXFORD OXFORDSHIRE   OX3 9JA 1974-04-01 00:00:00   A O K84009 2005-09-01 00:00:00   01865 761651 0 10Q
93 G0310161 CLARKE BMG Y55 Q79 201 HAMILTON ROAD FELIXSTOWE SUFFOLK     IP11 7DT 1974-04-01 00:00:00   A O D83048 1974-04-01 00:00:00 1991-05-02 00:00:00 01394 283197 0 06L
94 G0315070 COOK NJ Y12 QD8 590 WELLS ROAD KNOWLE BRISTOL     BS14 9BD 1974-04-01 00:00:00   A P L81654 1991-04-02 00:00:00 1991-12-31 00:00:00   0  
95 G0317993 CARROLL J Y51 Q33 CORBY WILLOWBROOK HTH.CTR COTTINGHAM ROAD CORBY     NN17 2UR 1974-04-01 00:00:00   A O K83001 1974-04-01 00:00:00 1992-09-30 00:00:00 01536 400600 0  
96 G0318736 CREAN JP Y55 Q77 PARK SURGERY 278 STRATFORD ROAD SHIRLEY, SOLIHULL WEST MIDLANDS   B90 3AF 1974-04-01 00:00:00   A O M89011 1974-04-01 00:00:00 1991-12-31 00:00:00 0121 2411700 0  
97 G0318949 CAINES AE Y55 Q77 LEA VILLAGE MEDICAL CTR. 98 LEA VILLAGE KITTS GREEN BIRMINGHAM   B33 9SD 1974-04-01 00:00:00   A O M85776 1991-11-14 00:00:00 1993-12-10 00:00:00 021 7899565 0 13P
98 G0319359 CHISHOLM JA Y55 Q76 THE SURGERY 370-374 NOTTINGHAM ROAD NEWTHORPE,EASTWOOD NOTTINGHAM   NG16 3BH 1974-04-01 00:00:00   A O C84131 1990-02-01 00:00:00 1994-12-01 00:00:00 01773 535511 0 04L
99 G0320041 COAKLEY TRP Y54 Q75 ST.JAMES' HEALTH CENTRE 29 GREAT GEORGE SQUARE LIVERPOOL     L1 5DQ 1974-04-01 00:00:00   A O N82082 1974-04-01 00:00:00 1992-04-02 00:00:00 0151 2953800 0 99A
100 G0320319 CURRIE JI Y54 Q72 8 TINSHILL LANE   LEEDS     LS16 7AP 1974-04-01 00:00:00   A O B86044 1974-04-01 00:00:00 1991-06-30 00:00:00 0113 2303470 0 03C

Next page

CREATE TABLE "egpcur" (
"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,
  "Current Care Organisation" TEXT
)
Powered by Datasette · Query took 298.197ms · Data source: OUseful Databeat