home / nhsadmin

Archived GP Practices

Data source: OUseful Databeat

4,071 rows

View and edit SQL

This data as .json

Suggested facets: National Grouping, Address Line 5, Organisation Sub-Type Code, Left Parent Date, Amended Record Indicator, Practice Type

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 Practice Type
1 603698 NO NAME HELD W00 QW1 GWENT FHSA         CF1 3PY 1991-04-01 00:00:00 1995-03-31 00:00:00 C Z         0 0
2 608698 NO NAME HELD W00 QW5 WEST GLAM FHSA         CF1 3PY 1991-04-01 00:00:00 1995-03-31 00:00:00 C Z         0 0
3 A81010 HART LODGE Y51 Q30 HART LODGE JONES ROAD,WEST VIEW HARTLEPOOL CLEVELAND   TS24 9BD 1974-04-01 00:00:00 2012-09-30 00:00:00 C B 5D9 2001-04-01 00:00:00 2012-09-30 00:00:00 01429 267573 0 4
4 A81050 NO NAME HELD Y01 QDP THE SURGERY 12 HARRIS STREET MIDDLESBROUGH     TS1 5EF 1974-04-01 00:00:00 1998-12-27 00:00:00 C Z       01642 246261 0 0
5 A81055 DR BK LAL'S PRACTICE Y51 Q30 THE HEALTH CENTRE COATHAM ROAD REDCAR CLEVELAND   TS10 1RP 1974-04-01 00:00:00 2012-09-30 00:00:00 C B 5QR 2006-10-01 00:00:00 2012-09-30 00:00:00 01642 483806 0 0
6 A81059 NO NAME HELD Y01 QDP THE SURGERY 7 BRIERTON LANE SHOPS HARTLEPOOL CLEVELAND   TS25 4BX 1974-04-01 00:00:00 1991-05-31 00:00:00 C Z         0 0
7 A81061 HAQUE SAZMI Y51 Q30 THE HEALTH CENTRE LAWSON STREET STOCKTON-ON-TEES CLEVELAND   TS18 1HU 1974-04-01 00:00:00 2012-09-30 00:00:00 C B 5E1 2001-04-01 00:00:00 2012-09-30 00:00:00 01642 607435 0 0
8 A81062 NO NAME HELD Y01 QDP THE MEDICAL CENTRE HALL CLOSE MARSKE BY THE SEA REDCAR   TS11 6BW 1974-04-01 00:00:00 1996-05-31 00:00:00 C Z       01642 486321 0 0
9 A81068 GRANGE HOUSE SURGERY Y51 Q30 GRANGE HOUSE SURGERY 22 GRANGE ROAD HARTLEPOOL     TS26 8JB 1985-08-19 00:00:00 2012-09-30 00:00:00 C B 5D9 2001-04-01 00:00:00 2012-09-30 00:00:00 01429 272679 0 4
10 A81071 MILLENNIUM SURGERY Y51 Q30 MILLENNIUM SURGERY WEST VIEW ROAD HARTLEPOOL     TS24 9LJ 2000-02-07 00:00:00 2012-09-30 00:00:00 C B 5D9 2001-04-01 00:00:00 2012-09-30 00:00:00 01429 869911 0 4
11 A81601 NO NAME HELD Y01 QDP 201 NORMANBY ROAD SOUTH BANK MIDDLESBROUGH     TS6 6SR 1974-04-01 00:00:00 1996-03-31 00:00:00 C Z       01642 454888 0 0
12 A81603 NO NAME HELD Y01 QDP PARKWAY SURGERY PARKWAY CENTRE COULBY NEWHAM MIDDLESBROUGH   TS8 0TJ 1986-03-03 00:00:00 1998-06-30 00:00:00 C Z       01642 590401 0 0
13 A81606 NO NAME HELD Y01 Q30 433 NORTON ROAD NORTON STOCKTON CLEVELAND   TS20 2QQ 1974-04-01 00:00:00 2000-02-29 00:00:00 C B   2002-10-01 00:00:00 2002-10-01 00:00:00 01642 533616 0 0
14 A81607 NO NAME HELD Y01 QDP 2 NOLAN HOUSE QUEENS PARK STOCKTON CLEVELAND   TS18 2AX 1974-04-01 00:00:00 1995-10-02 00:00:00 C Z       01642607939 0 0
15 A81615 NO NAME HELD Y01 QDP 109 PARK ROAD HARTLEPOOL CLEVELAND     TS26 9HR 1988-06-01 00:00:00 1998-02-28 00:00:00 C Z       01429 861213 0 0
16 A81616 DR C PARKASH'S PRACTICE Y51 Q30 CLEVELAND HOUSE 8 VICTORIA ROAD HARTLEPOOL CLEVELAND   TS24 7SD 1988-08-15 00:00:00 2012-09-30 00:00:00 C B   2002-10-01 00:00:00 2012-09-30 00:00:00 01429 272735 0 0
17 A81617 NO NAME HELD Y01 QDP 180 HIGH STREET MARSKE-BY-THE-SEA REDCAR CLEVELAND   TS11 7NB 1988-09-06 00:00:00 1991-10-28 00:00:00 C Z         0 0
18 A81619 NO NAME HELD Y01 QDP THE HEALTH CENTRE QUEENSWAY BILLINGHAM CLEVELAND   TS23 2LA 1988-10-01 00:00:00 1991-07-01 00:00:00 C Z         0 0
19 A81620 DR CHOUDHURY Y51 Q30 THE HEALTH CENTRE QUEENSWAY BILLINGHAM CLEVELAND   TS23 2LA 1988-10-01 00:00:00 2012-09-30 00:00:00 C B 5E1 2001-04-01 00:00:00 2012-09-30 00:00:00 01642 532003 0 4
20 A81624 NO NAME HELD Y01 QDP 83A PENRITH ROAD PARK END MIDDLESBOROUGH     TS3 7JA 1991-02-18 00:00:00 1996-08-31 00:00:00 C Z       01642 300645 0 0
21 A81625 ERIMUS PRACTICE Y51 Q30 QUEENS COURT SURGERY 7 HARRIS STREET MIDDLESBROUGH     TS1 5EF 1991-12-01 00:00:00 2012-09-30 00:00:00 C B 5KM 2002-04-01 00:00:00 2012-09-30 00:00:00 01642 253234 0 0
22 A81626 NO NAME HELD Y01 QDP 25 BRIDGE ROAD STOCKTON CLEVELAND     TS18 3AB 1992-02-01 00:00:00 1996-02-01 00:00:00 C Z       01642 607238 0 0
23 A81627 BARLEY FIELDS MEDICAL CENTRE Y51 Q30 BARLEY FIELDS MEDICAL CTR 30 MYTON ROAD INGLEBY BARWICK STOCKTON ON TEES   TS17 0WG 1994-01-01 00:00:00 2012-09-30 00:00:00 C B 5E1 2001-04-01 00:00:00 2012-09-30 00:00:00 01642 765789 0 4
24 A81628 NO NAME HELD Y01 QDP 254 BIRCHINGTON AVENUE WHALEHILL,ESTON MIDDLESBROUGH     TS6 8BL 1997-11-17 00:00:00 1998-06-22 00:00:00 C Z       01642 461337 0 0
25 A82001 ATKINSON HEALTH CENTRE (MANGAL) Y51 Q31 ATKINSON HEALTH CENTRE MARKET STREET BARROW IN FURNESS CUMBRIA   LA14 2LR 1974-04-01 00:00:00 2012-09-30 00:00:00 C B 5NE 2006-10-01 00:00:00 2012-09-30 00:00:00 01229 821556 0 0
26 A82042 FLATT WALKS SURGERY Y51 Q31 FLATT WALKS SURG,3 CASTLE MEADOWS,CATHERINE ST WHITEHAVEN CUMBRIA   CA28 7QE 1974-04-01 00:00:00 2012-09-30 00:00:00 C B 5NE 2006-10-01 00:00:00 2012-09-30 00:00:00 01946 692173 0 4
27 A82056 THE LAKES MEDICAL PRACTICE 2 Y51 Q31 PENRITH HEALTH CENTRE BRIDGE LANE PENRITH CUMBRIA   CA11 8HW 1974-04-01 00:00:00 2012-09-30 00:00:00 C B 5NE 2006-10-01 00:00:00 2012-09-30 00:00:00 01768 214345 0 0
28 A82061 PARKSTILE SURGERY Y51 Q31 PARKSTILE SURGERY CHURCH STREET BROUGHTON-IN-FURNESS CUMBRIA   LA20 6HL 1974-04-01 00:00:00 2012-09-30 00:00:00 C B 5NE 2006-10-01 00:00:00 2012-09-30 00:00:00 01229 716337 0 0
29 A82069 NO NAME HELD Y01 QDK THE HEALTH CENTRE SILVER STREET KIRKBY STEPHEN CUMBRIA   CA17 4RB 1974-04-01 00:00:00 1994-06-30 00:00:00 C Z         0 0
30 A82500 NO NAME HELD Y01 QDK THE SHIEL 4 SOUTH LIDDLE STREET NEWCASTLETON ROXBURGHSHIRE   TD9 0RN 1974-04-01 00:00:00 1992-03-31 00:00:00 C Z         0 0
31 A82502 DR CGM FERNIE'S PRACTICE Y51 Q31 THE SURGERY BOWHOLM CANONBIE     DG14 0UX 1991-01-14 00:00:00 2012-09-30 00:00:00 C B 5NE 2006-10-01 00:00:00 2012-09-30 00:00:00 013873 71313 0 0
32 A82607 FITZ ROAD SURGERY Y51 Q31 FITZ ROAD SURGERY COCKERMOUTH HPL,ISEL ROAD COCKERMOUTH CUMBRIA   CA13 9HT 1974-04-01 00:00:00 2012-09-30 00:00:00 C B 5NE 2006-10-01 00:00:00 2012-09-30 00:00:00 01900 705780 0 0
33 A82609 DR GW STITT'S PRACTICE Y51 Q31 6 WARWICK SQUARE CARLISLE   CUMBRIA   CA1 1LB 1974-04-01 00:00:00 2012-09-30 00:00:00 C B 5NE 2006-10-01 00:00:00 2012-09-30 00:00:00 01228 25041 0 4
34 A82614 SOLWAY VIEW PRACTICE Y51 Q31 WEST STREET HEALTH CENTRE WEST STREET ASPATRIA CUMBRIA   CA7 3HH 1974-04-01 00:00:00 2012-09-30 00:00:00 C B 5NE 2006-10-01 00:00:00 2012-09-30 00:00:00 01697 320224 0 4
35 A82615 SEDBERGH HEALTH CENTRE (LOCUM) Y51 Q31 THE HEALTH CENTRE LOFTUS HILL SEDBERGH CUMBRIA   LA10 5RX 1974-04-01 00:00:00 2012-09-30 00:00:00 C B 5NE 2006-10-01 00:00:00 2012-09-30 00:00:00 01539 620239 0 0
36 A82616 ULVERSTON Y51 Q31 THE HEALTH CENTRE VICTORIA ROAD ULVERSTON CUMBRIA   LA12 0EW 1974-04-01 00:00:00 2012-09-30 00:00:00 C B 5NE 2006-10-01 00:00:00 2012-09-30 00:00:00 01229 583238 0 0
37 A82618 LONGTOWN MEDICAL CENTRE Y51 Q31 THE SURGERY LONGTOWN MEDICAL CENTRE MOOR ROAD, LONGTOWN     CA6 5XA 1974-04-01 00:00:00 2012-09-30 00:00:00 C B 5NE 2006-10-01 00:00:00 2012-09-30 00:00:00 01228 791328 0 0
38 A82622 SEDBERGH SCHOOL MED CTR Y51 Q31 SEDBERGH SCHOOL MED CTR SEDBERGH CUMBRIA     LA10 5SQ 1974-04-01 00:00:00 2012-09-30 00:00:00 C B 5NE 2006-10-01 00:00:00 2012-09-30 00:00:00 01539 622224 0 4
39 A82624 WINDERMERE HEALTH CENTRE Y51 Q31 WINDERMERE HEALTH CENTRE GOODLEY DALE WINDERMERE CUMBRIA   LA23 2EG 1974-04-01 00:00:00 2012-09-30 00:00:00 C B 5NE 2006-10-01 00:00:00 2012-09-30 00:00:00 01539442496 0 0
40 A82625 PENNY BRIDGE SURGERY Y51 Q31 THE CROFT PENNY BRIDGE NR. ULVERSTON CUMBRIA   LA12 7TD 1974-04-01 00:00:00 2012-09-30 00:00:00 C B 5NE 2006-10-01 00:00:00 2012-09-30 00:00:00 01229 861249 0 4
41 A82627 RAWLINSON STREET SURGERY Y51 Q31 128 RAWLINSON STREET BARROW-IN-FURNESS CUMBRIA     LA14 2DG 1974-04-01 00:00:00 2012-09-30 00:00:00 C B 5NE 2006-10-01 00:00:00 2012-09-30 00:00:00 01229 820221 0 0
42 A82630 ATKINSON HEALTH CENTRE (RATHI) Y51 Q31 ATKINSON HEALTH CENTRE MARKET STREET BARROW IN FURNESS CUMBRIA   LA14 2LR 1974-04-01 00:00:00 2012-09-30 00:00:00 C B 5NE 2006-10-01 00:00:00 2012-09-30 00:00:00 01229 821030 0 0
43 A82632 WARWICK ROAD SURGERY Y51 Q31 GROSVENOR HOUSE SURGERY GROSVENOR HS, WARWICK SQR CARLISLE     CA1 1LB 1974-04-01 00:00:00 2012-09-30 00:00:00 C B 5NE 2006-10-01 00:00:00 2012-09-30 00:00:00 01228 536561 0 4
44 A82634 NO NAME HELD Y08 QC4 ATKINSON HEALTH CENTRE MARKET STREET BARROW IN FURNESS CUMBRIA   LA14 2LR 1974-04-01 00:00:00 1992-09-30 00:00:00 C Z         0 0
45 A82636 OUTGANG BARN SURGERY Y51 Q31 OUTGANG BARN SURGERY OUTGANG ROAD, ASPATRIA WIGTON CUMBRIA   CA7 3HW 1987-01-16 00:00:00 2012-09-30 00:00:00 C B 5NE 2006-10-01 00:00:00 2012-09-30 00:00:00 01697 320367 0 0
46 A82644 NO NAME HELD Y08 QC4 ST MARY'S HOSP.IN FURNESS FORD PARK ULVERSTON CUMBRIA   LA15 8AB 1989-06-01 00:00:00 1993-11-30 00:00:00 C Z       0229 53072 0 0
47 A82645 THE SURGERY (KARAMCHANDANI) Y51 Q31 28-30 HARTINGTON STREET BARROW-IN-FURNESS CUMBRIA     LA14 5SL 1989-04-10 00:00:00 2012-09-30 00:00:00 C B 5NE 2006-10-01 00:00:00 2012-09-30 00:00:00 01229 870170 0 0
48 A82648 ANN BURROW THOMAS HTH CTR Y51 Q31 ANN BURROW THOMAS HTH CTR SOUTH WILLIAM STREET WORKINGTON CUMBRIA   CA14 2ED 1991-02-01 00:00:00 2012-09-30 00:00:00 C B 5NE 2006-10-01 00:00:00 2012-09-30 00:00:00 01900 605258 0 0
49 A82649 HOAD VIEW SURGERY LTD Y51 Q31 ULVERSTON COMM.HEALTH CTR STANLEY STREET ULVERSTON CUMBRIA   LA12 7BT 1991-05-01 00:00:00 2012-09-30 00:00:00 C B 5NE 2006-10-01 00:00:00 2012-09-30 00:00:00 01229 484070 0 0
50 A82652 ATKINSON HEALTH CENTRE (PAI) Y51 Q31 ATKINSON HEALTH CENTRE MARKET STREET BARROW IN FURNESS CUMBRIA   LA14 2LR 1994-02-15 00:00:00 2012-09-30 00:00:00 C B 5NE 2006-10-01 00:00:00 2012-09-30 00:00:00 01229 821669 0 0
51 A82653 NO NAME HELD Y08 QC4 OUR LADIES HIGH SCHOOL MORECAMBE ROAD LANCASTER     LA1 2RX 1997-12-24 00:00:00 1998-01-02 00:00:00 C Z         0 0
52 A83056 DR AK BHAGAT'S PRACTICE Y51 Q30 THE SURGERY CIVIC CENTRE PLACE SHILDON CO.DURHAM   DL4 1AH 1974-04-01 00:00:00 2012-09-30 00:00:00 C B   2002-10-01 00:00:00 2012-09-30 00:00:00 01388 772408 0 0
53 A83059 TRIMDON PRACTICE Y51 Q30 GROSVENOR HOUSE MED.PRACT GROSVENOR TERRACE TRIMDON COLLIERY CO DURHAM   TS29 6DH 1974-04-01 00:00:00 2012-09-30 00:00:00 C B 5ND 2006-10-01 00:00:00 2012-09-30 00:00:00 01429 880284 0 0
54 A83090 WILKINSON M Y01 QDJ 63 GROSVENOR WAY CHAPEL PARK   NEWCASTLE UPON TYNE TYNE AND WEAR NE5 1RU 1991-04-01 00:00:00 1999-04-02 00:00:00 C B 4DP19 1999-04-01 00:00:00 1999-04-02 00:00:00   1 0
55 A83607 NO NAME HELD Y01 QDE PARKGATE HEALTH CENTRE PARK PLACE DARLINGTON COUNTY DURHAM   DL1 5LW 1985-01-01 00:00:00 1996-10-31 00:00:00 C Z       0325 359585 0 0
56 A83608 DR AK BANERJEE'S PRACTICE Y51 Q30 RED HOUSE 4 WHEATBOTTOM CROOK CO.DURHAM   DL15 9HB 1974-04-01 00:00:00 2012-09-30 00:00:00 C B 5ND 2006-10-01 00:00:00 2012-09-30 00:00:00 01388 762537 0 0
57 A83609 CRAGHEAD MEDICAL CENTRE Y51 Q30 CRAGHEAD MEDICAL CENTRE THE MIDDLES, CRAGHEAD STANLEY COUNTY DURHAM   DH9 6AN 1974-04-01 00:00:00 2012-09-30 00:00:00 C B 5ND 2006-10-01 00:00:00 2012-09-30 00:00:00 01207 232698 0 0
58 A83613 FAMILY PLANNING WILLINGTON Y51 Q30 WILLINGTON HEALTH CENTRE CHAPEL STREET WILLINGTON,CROOK CO. DURHAM   DL15 0EQ 1974-04-01 00:00:00 2012-09-30 00:00:00 C B 5ND 2006-10-01 00:00:00 2012-09-30 00:00:00 01388 746468 0 0
59 A83614 NO NAME HELD Y01 QDE 15 DENE VIEW BURNOPFIELD NEWCASTLE UPON TYNE     NE16 6QA 1974-04-01 00:00:00 1998-03-31 00:00:00 C Z       01207 70215 0 0
60 A83621 DR PRACTICE DARLINGTON PCT Y51 Q30 THE CIVIC SURGERY PARKGATE HEALTH CENTRE PARK PLACE, DARLINGTON CO. DURHAM   DL1 5LW 1974-04-01 00:00:00 2012-09-30 00:00:00 C B 5J9 2002-04-01 00:00:00 2012-09-30 00:00:00 01325 359585 0 0
61 A83625 NO NAME HELD Y01 QDE 4 CHURCH STREET WINGATE CO.DURHAM     TS28 5AQ 1988-01-01 00:00:00 1993-06-30 00:00:00 C Z       0429 838217 0 0
62 A83631 DR JW CHARTERS' PRACTICE Y51 Q30 UNIVERSITY OF DURHAM STUDENT HEALTH CENTRE 42 OLD ELVET DURHAM   DH1 3JF 1991-07-01 00:00:00 2012-09-30 00:00:00 C B   2002-10-01 00:00:00 2012-09-30 00:00:00 0191 3865081 0 0
63 A83633 DR SR CHOUDHARY'S PRACTICE Y51 Q30 BLACKHILLS SURGERY 16 BLACKHILLS ROAD HORDEN, PETERLEE CO.DURHAM   SR8 4DW 1992-08-01 00:00:00 2012-09-30 00:00:00 C B 5ND 2006-10-01 00:00:00 2012-09-30 00:00:00 0191 5183646 0 0
64 A83639 DRS PARTHASARATHY & PARTHASARATHY Y51 Q30 16 FRONT STREET ANNFIELD PLAIN STANLEY COUNTY DURHAM   DH9 8HY 1998-04-01 00:00:00 2012-09-30 00:00:00 C B 5ND 2006-10-01 00:00:00 2012-09-30 00:00:00 01207 214849 0 0
65 A83640 DR JM RICHMOND'S PRACTICE Y51 Q30 102 CHAYTOR ROAD BRIDGEHILL CONSETT CO.DURHAM   DH8 8QU 2000-04-06 00:00:00 2012-09-30 00:00:00 C B 5ND 2006-10-01 00:00:00 2012-09-30 00:00:00 01733 210255 0 0
66 A83646 DURHAM DALES MEDICAL PRACTICE Y51 Q30 DURHAM DALES MED PRACTICE 178 NEWGATE STREET BISHOP AUCKLAND CO.DURHAM   DL14 7EJ 2002-10-01 00:00:00 2012-09-30 00:00:00 C B 5ND 2006-10-01 00:00:00 2012-09-30 00:00:00 01388 609876 0 0
67 A84001 BONDICAR MEDICAL PRACTICE Y51 Q30 THE HEALTH CENTRE THOROTON STREET BLYTH NORTHUMBERLAND   NE24 1DX 1974-04-01 00:00:00 2012-09-30 00:00:00 C B TAC 2002-04-01 00:00:00 2012-09-30 00:00:00 01670 396500 0 0
68 A84004 DUNELM Y51 Q30 DUNELM 1 DELAVAL AVENUE SEATON DELAVAL WHITLEY BAY,TYNE & WEAR   NE25 0EF 1974-04-01 00:00:00 2012-09-30 00:00:00 C B TAC 2002-04-01 00:00:00 2012-09-30 00:00:00 0191 2371148 0 0
69 A84010 DR I CRAFT'S PRACTICE Y51 Q30 13 ALBION TERRACE LYNEMOUTH MORPETH NORTHUMBERLAND   NE61 5SY 1974-04-01 00:00:00 2012-09-30 00:00:00 C B TAC 2002-04-01 00:00:00 2012-09-30 00:00:00 01670 860212 0 0
70 A84019 NEWBIGGIN HEALTH CENTRE Y51 Q30 NEWBIGGIN HEALTH CENTRE BUTELAND TERRACE NEWBIGGIN BY THE SEA NORTHUMBERLAND   NE64 6NS 1974-04-01 00:00:00 2012-09-30 00:00:00 C B TAC 2002-04-01 00:00:00 2012-09-30 00:00:00 01670 816921 0 0
71 A84046 CRAMLINGTON HEALTH CENTRE Y51 Q30 CRAMLINGTON HEALTH CENTRE FORUM WAY,CIVIC PRECINCT CRAMLINGTON NORTHUMBERLAND   NE23 6QN 1974-04-01 00:00:00 2012-09-30 00:00:00 C B TAC 2002-04-01 00:00:00 2012-09-30 00:00:00 01670 714581 0 0
72 A84049 NURSERY PARK MED. GROUP Y51 Q30 NURSERY PARK MED. GROUP NURSERY PARK ROAD ASHINGTON NORTHUMBERLAND   NE63 0HP 1999-04-01 00:00:00 2012-09-30 00:00:00 C B TAC 2002-04-01 00:00:00 2012-09-30 00:00:00 01670 528100 0 0
73 A84603 NO NAME HELD Y01 QDM THE HEALTH CENTRE ALLENDALE HEXHAM NORTHUMBERLAND   NE48 2DE 1974-04-01 00:00:00 1997-03-31 00:00:00 C Z       01434 683280 0 0
74 A84606 NURSERY PARK MED. GROUP Y51 Q30 THE HEALTH CENTRE BUTELAND TERRACE NEWBIGGIN BY THE SEA NORTHUMBERLAND   NE64 6NS 1974-04-01 00:00:00 2012-09-30 00:00:00 C B TAC 2002-04-01 00:00:00 2012-09-30 00:00:00 01670 816996 0 0
75 A84612 NO NAME HELD Y01 Q30 CRAMLINGTON HEALTH CENTRE FORUM WAY,CIVIC PRECINCT CRAMLINGTON NORTHUMBERLAND   NE23 6QN 1990-03-01 00:00:00 1997-04-05 00:00:00 C B   2002-10-01 00:00:00 2002-10-01 00:00:00 01670 712210 0 0
76 A84615 NO NAME HELD Y01 Q30 WESTBOURNE MEDICAL CENTRE WESTBOURNE TERRACE SEATON DELAVAL WHITLEY BAY   NE25 0BE 1992-01-01 00:00:00 2000-08-31 00:00:00 C B TAC 2002-10-01 00:00:00 2002-10-01 00:00:00 0191 2372244 0 0
77 A84616 NO NAME HELD Y01 QDM CRAMLINGTON HEALTH CENTRE FORUM WAY, CIVIC PRECINCT CRAMLINGTON NORTHUMBERLAND   NE23 6QN 1993-10-01 00:00:00 1997-03-31 00:00:00 C Z       01670 736593 0 0
78 A84617 THE HARBOUR SUITE Y51 Q30 THE HARBOUR SUITE BLYTH COMMUNITY HOSPITAL THOROTON STREET,BLYTH NORTHUMBERLAND   NE24 1DX 1997-07-01 00:00:00 2012-09-30 00:00:00 C B TAC 2002-04-01 00:00:00 2012-09-30 00:00:00 01670 396550 0 0
79 A85606 NO NAME HELD Y01 QDG CHIRTON HOUSE RAVENSWORTH ROAD DUNSTON, GATESHEAD TYNE & WEAR   NE11 9AD 1974-04-01 00:00:00 1993-07-31 00:00:00 C Z       091 4604148 0 0
80 A85607 NO NAME HELD Y01 QDG 12 NORTH STREET WINLATON TYNE & WEAR     NE21 6BX 1974-04-01 00:00:00 1996-11-03 00:00:00 C Z       0191 4148874 0 0
81 A85613 NO NAME HELD Y01 QDG 4 HAVELOCK TERRACE BENSHAM GATESHEAD TYNE & WEAR   NE8 1QU 1987-12-12 00:00:00 1997-01-31 00:00:00 C Z       01914772824 0 0
82 A85615 DR MTA CHANDNANI'S PRACTICE Y51 Q30 GATESHEAD HEALTH CENTRE PRINCE CONSORT ROAD GATESHEAD TYNE & WEAR   NE8 1NB 1990-11-01 00:00:00 2012-09-30 00:00:00 C B   2002-10-01 00:00:00 2012-09-30 00:00:00 01914783550 0 0
83 A85618 BEDE GP PRACTICE Y51 Q30 THE BEDE CENTRE OLD FOLD ROAD GATESHEAD     NE10 0DJ 2002-11-01 00:00:00 2012-09-30 00:00:00 C B 5KF 2002-11-01 00:00:00 2012-09-30 00:00:00 0191 4335800 0 0
84 A86001 SHIELDFIELD HEALTH CENTRE Y51 Q30 SHIELDFIELD HEALTH CENTRE STODDART STREET SHIELDFIELD NEWCASTLE UPON TYNE   NE2 1AL 1974-04-01 00:00:00 2012-09-30 00:00:00 C B 5D7 2001-04-01 00:00:00 2012-09-30 00:00:00 0191 2324872 0 0
85 A86014 NO NAME HELD Y01 QDJ THE ELSWICK HEALTH CENTRE MELDON STREET NEWCASTLE     NE4 6SH 1974-04-01 00:00:00 1992-02-28 00:00:00 C Z         0 0
86 A86019 NO NAME HELD Y01 QDJ MEDICAL CENTRE 495 WELBECK ROAD WALKER NEWCASTLE   NE6 2PB 1974-04-01 00:00:00 1997-09-30 00:00:00 C Z       01912656393 0 0
87 A86032 GRAINGER MEDICAL GROUP Y51 Q30 ELSWICK HEALTH CENTRE MELDON STREET, ELSWICK NEWCASTLE UPON TYNE TYNE & WEAR   NE4 6SH 1974-04-01 00:00:00 2012-09-30 00:00:00 C B 5D7 2001-04-01 00:00:00 2012-09-30 00:00:00 0191 2986060 0 0
88 A86034 ARMSTRONG ROAD HEALTH CENTRE Y51 Q30 ARMSTRONG ROAD HEALTH CTR 460 ARMSTRONG ROAD NEWCASTLE-UPON-TYNE     NE15 6BY 1974-04-01 00:00:00 2012-09-30 00:00:00 C B 5D7 2001-04-01 00:00:00 2012-09-30 00:00:00 0191 2280960 0 0
89 A86604 NO NAME HELD Y01 QDJ 24 HAWTHORN ROAD NEWCASTLE       NE3 4DE 1974-04-01 00:00:00 1998-09-06 00:00:00 C Z       0191 2859904 0 0
90 A86605 NO NAME HELD Y01 Q30 THE SURGERY 1 WALNUT PLACE MONTAGU ESTATE NEWCASTLE   NE3 4QS 1974-04-01 00:00:00 1998-03-31 00:00:00 C B   2002-10-01 00:00:00 2002-10-01 00:00:00 0191 2853816 0 0
91 A86606 DR SK RAJ'S PRACTICE Y51 Q30 55 UNION HALL ROAD LEMINGTON NEWCASTLE     NE15 8BP 1974-04-01 00:00:00 2012-09-30 00:00:00 C B   2002-10-01 00:00:00 2012-09-30 00:00:00 0191 2674894 0 0
92 A86607 ELSWICK HEALTH CENTRE Y51 Q30 ELSWICK SURGERY ELSWICK CLINIC MELDON STREET, ELSWICK NEWCASTLE-UPON-TYNE   NE4 6SH 1974-04-01 00:00:00 2012-09-30 00:00:00 C B 5D7 2001-04-01 00:00:00 2012-09-30 00:00:00 0191 2734102 0 0
93 A86608 DR JD MOOR'S PRACTICE Y51 Q30 6 WINGROVE ROAD NEWCASTLE       NE4 9BQ 1987-07-01 00:00:00 2012-09-30 00:00:00 C B   2002-10-01 00:00:00 2012-09-30 00:00:00 0191 2731418 0 0
94 A86609 NO NAME HELD Y01 QDJ BLAKELAW HEALTH CLINIC SPRINGFIELD ROAD BLAKELAW NEWCASTLE   NE5 3DS 1974-04-01 00:00:00 1996-02-29 00:00:00 C Z       0191 2863038 0 0
95 A86610 NO NAME HELD Y01 QDJ 55 EDGEFIELD AVENUE FAWDON NEWCASTLE     NE3 3AA 1974-04-01 00:00:00 1994-06-30 00:00:00 C Z       091 2852039 0 0
96 A86612 REGNARD CFB Y51 Q30 ST. OSWALDS HOSPICE REGENT AVENUE GOSFORTH NEWCASTLE   NE3 1EE 1986-07-01 00:00:00 2012-09-30 00:00:00 C B 5D7 2002-04-01 00:00:00 2012-09-30 00:00:00 0191 2850063 0 0
97 A86614 NO NAME HELD Y01 QDJ 452 DENTON ROAD   NEWCASTLE     NE15 7HD 1974-04-01 00:00:00 1993-03-31 00:00:00 C Z         0 0
98 A86616 NO NAME HELD Y01 QDJ 5 ROTHBURY TERRACE HEATON NEWCASTLE-UPON-TYNE     NE6 5YP 1991-07-01 00:00:00 1996-07-31 00:00:00 C Z       0191 2655089 0 0
99 A86617 HEALTH AUTHORITY LOCUM Y51 Q30 CHAPEL PARK MEDICAL CTR. HARTBURN DRIVE CHAPEL PARK ESTATE NEWCASTLE UPON TYNE   NE5 1TD 1994-10-01 00:00:00 2012-09-30 00:00:00 C B 5D7 2001-04-01 00:00:00 2012-09-30 00:00:00 0191 2671416 0 0
100 A86618 WELBECK ROAD MEDICAL CENTRE Y51 Q30 MEDICAL CENTRE 495 WELBECK ROAD WALKER NEWCASTLE UPON TYNE   NE6 2PB 1995-02-01 00:00:00 2012-09-30 00:00:00 C B 5D7 2001-04-01 00:00:00 2012-09-30 00:00:00 0191 2243794 0 0

Next page

CREATE TABLE "epracarc" (
"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,
  "Practice Type" INTEGER
)
Powered by Datasette · Query took 66.112ms · Data source: OUseful Databeat