home / nhsadmin

Current Medical Practices and Prescribing Cost Centres

Data source: OUseful Databeat

13,469 rows

View and edit SQL

This data as .json

Suggested facets: National Grouping, Status Code, Organisation Sub-Type code, Left Provider/Purchaser Date, Amended Record Indicator, Prescribing Setting

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 Commissioner Join Provider/Purchaser Date Left Provider/Purchaser Date Contact Telephone Number Amended Record Indicator Provider/Purchaser Prescribing Setting
1 A81001 THE DENSHAM SURGERY Y54 Q74 THE HEALTH CENTRE LAWSON STREET STOCKTON-ON-TEES CLEVELAND   TS18 1HU 1974-04-01 00:00:00   A B 00K 2013-04-01 00:00:00   01642 672351 0 00K 4
2 A81002 QUEENS PARK MEDICAL CENTRE Y54 Q74 QUEENS PARK MEDICAL CTR FARRER STREET STOCKTON ON TEES CLEVELAND   TS18 2AW 1974-04-01 00:00:00   A B 00K 2013-04-01 00:00:00   01642 679681 0 00K 4
3 A81003 VICTORIA MEDICAL PRACTICE Y54 Q74 THE HEALTH CENTRE VICTORIA ROAD HARTLEPOOL CLEVELAND   TS26 8DB 1974-04-01 00:00:00   D B 00K 2013-04-01 00:00:00   01429 272945 0 00K 4
4 A81004 WOODLANDS ROAD SURGERY Y54 Q74 6 WOODLANDS ROAD   MIDDLESBROUGH CLEVELAND   TS1 3BE 1974-04-01 00:00:00   A B 00M 2013-04-01 00:00:00   01642 247982 0 00M 4
5 A81005 SPRINGWOOD SURGERY Y54 Q74 SPRINGWOOD SURGERY RECTORY LANE GUISBOROUGH     TS14 7DJ 1974-04-01 00:00:00   A B 00M 2013-04-01 00:00:00   01287 619611 0 00M 4
6 A81006 TENNANT STREET MEDICAL PRACTICE Y54 Q74 TENNANT ST MEDICAL CENTRE TENNANT STREET STOCKTON-ON-TEES CLEVELAND   TS18 2AT 1974-04-01 00:00:00   A B 00K 2013-04-01 00:00:00   01642 613331 0 00K 4
7 A81007 BANKHOUSE SURGERY Y54 Q74 ONE LIFE HARTLEPOOL PARK ROAD HARTLEPOOL CLEVELAND   TS24 7PW 1974-04-01 00:00:00   A B 00K 2013-04-01 00:00:00   01429 274800 0 00K 4
8 A81008 ALBERT HOUSE CLINIC Y54 Q74 LOW GRANGE HEALTH VILLAGE NORMANBY ROAD MIDDLESBROUGH CLEVELAND   TS6 6TD 1974-04-01 00:00:00   D B 00M 2013-04-01 00:00:00   01642 466776 1 00M 4
9 A81009 VILLAGE MEDICAL CENTRE Y54 Q74 THE VILLAGE MEDICAL CTR 400/404 LINTHORPE ROAD MIDDLESBROUGH CLEVELAND   TS5 6HF 1974-04-01 00:00:00   A B 00M 2013-04-01 00:00:00   01642 851122 0 00M 4
10 A81011 CHADWICK PRACTICE Y54 Q74 ONE LIFE HARTLEPOOL PARK ROAD HARTLEPOOL CLEVELAND   TS24 7PW 1974-04-01 00:00:00   A B 00K 2013-04-01 00:00:00   01429 234646 0 00K 4
11 A81012 WESTBOURNE MEDICAL CENTRE Y54 Q74 WESTBOURNE MEDICAL CENTRE 7 TRINITY MEWS,N. ORMESBY MIDDLESBROUGH     TS3 6AL 1974-04-01 00:00:00   A B 00M 2013-04-01 00:00:00   01642 277000 0 00M 4
12 A81013 BROTTON SURGERY Y54 Q74 BROTTON SURGERY ALFORD ROAD,BROTTON SALTBURN BY SEA     TS12 2FF 1974-04-01 00:00:00   A B 00M 2013-04-01 00:00:00   01287 676215 0 00M 4
13 A81014 QUEENSTREE PRACTICE Y54 Q74 THE HEALTH CENTRE QUEENSWAY BILLINGHAM CLEVELAND   TS23 2LA 1974-04-01 00:00:00   A B 00K 2013-04-01 00:00:00   01642 553389 0 00K 4
14 A81015 LAGAN SURGERY Y54 Q74 LAGAN SURGERY 20 KIRKLEATHAM STREET REDCAR CLEVELAND   TS10 1TZ 1974-04-01 00:00:00   A B 00M 2013-04-01 00:00:00   01642 488128 0 00M 4
15 A81016 PARK SURGERY Y54 Q74 PARK SURGERY, ONE LIFE LINTHORPE ROAD MIDDLESBROUGH CLEVELAND   TS1 3QY 1974-04-01 00:00:00   A B 00M 2013-04-01 00:00:00   0300 1112300 0 00M 4
16 A81017 WOODBRIDGE PRACTICE Y54 Q74 THE HEALTH CENTRE TRENCHARD AVE, THORNABY STOCKTON ON TEES CLEVELAND   TS17 0EE 1974-04-01 00:00:00   A B 00K 2013-04-01 00:00:00   01642 762636 0 00K 4
17 A81018 BENTLEY MEDICAL PRACTICE Y54 Q74 REDCAR PRIMARY CARE HOSP WEST DYKE ROAD REDCAR CLEVELAND   TS10 4NW 1974-04-01 00:00:00   A B 00M 2013-04-01 00:00:00   01642 470444 0 00M 4
18 A81019 CROSSFELL HEALTH CENTRE Y54 Q74 CROSSFELL ROAD BERWICK HILLS MIDDLESBROUGH CLEVELAND   TS3 7RL 1974-04-01 00:00:00   A B 00M 2013-04-01 00:00:00   01642 296777 0 00M 4
19 A81020 MARTONSIDE MEDICAL CENTRE Y54 Q74 MARTONSIDE MEDICAL CENTRE 1A MARTONSIDE WAY MIDDLESBROUGH CLEVELAND   TS4 3BU 1974-04-01 00:00:00   A B 00M 2013-04-01 00:00:00   01642 812266 0 00M 4
20 A81021 NORMANBY MEDICAL CENTRE Y54 Q74 NORMANBY MEDICAL CENTRE LOW GRANGE HV,NORMANBY RD MIDDLESBROUGH CLEVELAND   TS6 6TD 1974-04-01 00:00:00   A B 00M 2013-04-01 00:00:00   01642 511660 0 00M 4
21 A81022 HILLSIDE PRACTICE Y54 Q74 HILLSIDE PRACTICE WINDERMERE DRIVE,SKELTON SALTBURN BY THE SEA CLEVELAND   TS12 2TG 1974-04-01 00:00:00   A B 00M 2013-04-01 00:00:00   01287 650430 0 00M 4
22 A81023 THE ENDEAVOUR PRACTICE Y54 Q74 THE HEALTH CENTRE 20 CLEVELAND SQUARE MIDDLESBROUGH CLEVELAND   TS1 2NX 1974-04-01 00:00:00   A B 00M 2013-04-01 00:00:00   01642 242192 0 00M 4
23 A81025 THE DOVECOT SURGERY Y54 Q74 THE HEALTH CENTRE LAWSON STREET STOCKTON ON TEES CLEVELAND   TS18 1HU 1974-04-01 00:00:00   A B 00K 2013-04-01 00:00:00   01642 676520 0 00K 4
24 A81026 THE LINTHORPE SURGERY Y54 Q74 378 LINTHORPE ROAD MIDDLESBROUGH CLEVELAND     TS5 6HA 1974-04-01 00:00:00   A B 00M 2013-04-01 00:00:00   01642 856066 0 00M 4
25 A81027 YARM MEDICAL PRACTICE Y54 Q74 YARM MEDICAL PRACTICE MULBERRY HOUSE 1 WORSALL ROAD YARM, CLEVELAND   TS15 9DD 1974-04-01 00:00:00   A B 00K 2013-04-01 00:00:00   01642 745800 0 00K 4
26 A81029 PROSPECT SURGERY Y54 Q74 THE HEALTH CENTRE PO BOX 101E 20 CLEVELAND SQUARE MIDDLESBROUGH   TS1 2NX 1974-04-01 00:00:00   A B 00M 2013-04-01 00:00:00   01642 210220 0 00M 4
27 A81030 BOROUGH ROAD & NUNTHORPE MEDICAL GROUP Y54 Q74 167A BOROUGH ROAD MIDDLESBROUGH       TS1 3RY 1974-04-01 00:00:00   A B 00M 2013-04-01 00:00:00   01642 243668 0 00M 4
28 A81031 HAVELOCK GRANGE PRACTICE Y54 Q74 ONE LIFE HARTLEPOOL PARK ROAD HARTLEPOOL CLEVELAND   TS24 7PW 1974-04-01 00:00:00   A B 00K 2013-04-01 00:00:00   01429 272000 0 00K 4
29 A81032 THE GARTH Y54 Q74 THE GARTH SURGERY RECTORY LANE GUISBOROUGH CLEVELAND   TS14 7DJ 1974-04-01 00:00:00   A B 00M 2013-04-01 00:00:00   01287 632206 0 00M 4
30 A81033 OAKFIELD MEDICAL PRACTICE Y54 Q74 OAKFIELDS MED PRACTICE 1 TRINITY MEWS,N. ORMESBY MIDDLESBROUGH     TS3 6AL 1974-04-01 00:00:00   A B 00M 2013-04-01 00:00:00   01642 244990 0 00M 4
31 A81034 THORNABY & BARWICK MEDICAL GROUP Y54 Q74 THORNABY HEALTH CENTRE TRENCHARD AVE, THORNABY STOCKTON ON TEES CLEVELAND   TS17 0EE 1974-04-01 00:00:00   A B 00K 2013-04-01 00:00:00   01642 762921 0 00K 4
32 A81035 NEWLANDS MEDICAL CENTRE Y54 Q74 NEWLANDS MEDICAL CENTRE BOROUGH ROAD MIDDLESBROUGH CLEVELAND   TS1 3RX 1974-04-01 00:00:00   A B 00M 2013-04-01 00:00:00   01642 247029 0 00M 4
33 A81036 NORTON MEDICAL CENTRE Y54 Q74 NORTON MEDICAL CENTRE BILLINGHAM ROAD, NORTON STOCKTON-ON-TEES CLEVELAND   TS20 2UZ 1974-04-01 00:00:00   A B 00K 2013-04-01 00:00:00   01642 745350 0 00K 4
34 A81037 THE ERIMUS PRACTICE Y54 Q74 THE CLEVELAND HEALTH CTR 20 CLEVELAND SQUARE MIDDLESBROUGH     TS1 2NX 1974-04-01 00:00:00   A B 00M 2013-04-01 00:00:00   01642 242746 0 00M 4
35 A81038 HIRSEL MEDICAL CENTRE Y54 Q74 HIRSEL MEDICAL CENTRE 5 TRINITY MEWS, N.ORMESBY MIDDLESBROUGH CLEVELAND   TS3 6AL 1974-04-01 00:00:00   A B 00M 2013-04-01 00:00:00   01642 242880 0 00M 4
36 A81039 EAGLESCLIFFE MEDICAL PRACTICE Y54 Q74 EAGLESCLIFFE MED PRACTICE SUNNINGDALE DRIVE EAGLESCLIFFE STOCKTON-ON-TEES   TS16 9EA 1974-04-01 00:00:00   A B 00K 2013-04-01 00:00:00   01642 780113 0 00K 4
37 A81040 MARSH HOUSE MEDICAL PRACTICE Y54 Q74 ABBEY HEALTH CENTRE FINCHALE AVENUE BILLINGHAM CLEVELAND   TS23 2DG 1974-04-01 00:00:00   A B 00K 2013-04-01 00:00:00   01642 561282 0 00K 4
38 A81041 HART MEDICAL PRACTICE Y54 Q74 HART MEDICAL PRACTICE SURGERY LANE HARTLEPOOL CLEVELAND   TS24 9DN 1974-04-01 00:00:00   A B 00K 2013-04-01 00:00:00   01429 282700 0 00K 4
39 A81042 SOUTH GRANGE MEDICAL GROUP PRACTICE Y54 Q74 SOUTH GRANGE MEDICAL CTR. TRUNK ROAD, ESTON MIDDLESBROUGH CLEVELAND   TS6 9QG 1974-04-01 00:00:00   A B 00M 2013-04-01 00:00:00   01642 467001 1 00M 4
40 A81043 THE MANOR HOUSE SURGERY Y54 Q74 THE MANOR HOUSE SURGERY BRAIDWOOD ROAD, NORMANBY MIDDLESBROUGH CLEVELAND   TS6 0HA 1974-04-01 00:00:00   A B 00M 2013-04-01 00:00:00   01642 374788 0 00M 4
41 A81044 MCKENZIE HOUSE SURGERY Y54 Q74 MCKENZIE HOUSE 17 KENDAL ROAD HARTLEPOOL CLEVELAND   TS25 1QU 1974-04-01 00:00:00   A B 00K 2013-04-01 00:00:00   01429 230000 0 00K 4
42 A81045 THE COATHAM ROAD SURGERY Y54 Q74 THE COATHAM SURGERY COATHAM HEALTH VILLAGE REDCAR CLEVELAND   TS10 1SR 1974-04-01 00:00:00   A B 00M 2013-04-01 00:00:00   01642 483638 0 00M 4
43 A81046 WOODLANDS FAMILY MEDICAL CENTRE Y54 Q74 WOODLANDS FAMILY MED. CTR 106 YARM LANE STOCKTON-ON-TEES CLEVELAND   TS18 1YE 1974-04-01 00:00:00   A B 00K 2013-04-01 00:00:00   01642 607398 0 00K 4
44 A81047 MARSKE MEDICAL CENTRE Y54 Q74 THE MEDICAL CENTRE HALL CLOSE MARSKE-BY-THE-SEA REDCAR,CLEVELAND   TS11 6BW 1974-04-01 00:00:00   A B 00M 2013-04-01 00:00:00   01642 482725 0 00M 4
45 A81048 ZETLAND MEDICAL PRACTICE Y54 Q74 WINDY HILL LANE MARSKE BY THE SEA REDCAR CLEVELAND   TS11 7BL 1974-04-01 00:00:00   A B 00M 2013-04-01 00:00:00   01642 477133 0 00M 4
46 A81049 KINGS MEDICAL CENTRE Y54 Q74 KINGS MEDICAL CENTRE 3 TRINITY MEWS,N.ORMESBY MIDDLESBROUGH     TS3 6AL 1974-04-01 00:00:00   A B 00M 2013-04-01 00:00:00   01642 244766 0 00M 4
47 A81051 CAMBRIDGE MEDICAL GROUP Y54 Q74 THE CAMBRIDGE MED. GROUP 10A CAMBRIDGE ROAD LINTHORPE, MIDDLESBROUGH CLEVELAND   TS5 5NN 1974-04-01 00:00:00   A B 00M 2013-04-01 00:00:00   01642 851177 0 00M 4
48 A81052 THE GREEN HOUSE SURGERY Y54 Q74 REDCAR PRIMARY CARE HOSP WEST DYKE ROAD REDCAR CLEVELAND   TS10 4NW 1974-04-01 00:00:00   A B 00M 2013-04-01 00:00:00   01642 475157 0 00M 4
49 A81053 WOODSIDE SURGERY Y54 Q74 WOODSIDE SURGERY 6 HIGH STREET,LOFTUS SALTBURN-BY-THE-SEA CLEVELAND   TS13 4HW 1974-04-01 00:00:00   A B 00M 2013-04-01 00:00:00   01287 640385 0 00M 4
50 A81054 THE SALTSCAR SURGERY Y54 Q74 THE SALTSCAR SURGERY 22 KIRKLEATHAM STREET REDCAR CLEVELAND   TS10 1UA 1974-04-01 00:00:00   A B 00M 2013-04-01 00:00:00   01642 471388 0 00M 4
51 A81056 MELROSE SURGERY Y54 Q74 38 MELROSE AVENUE BILLINGHAM CLEVELAND     TS23 2JW 1974-04-01 00:00:00   A B 00K 2013-04-01 00:00:00   01642 553055 0 00K 4
52 A81057 KINGSWAY MEDICAL CENTRE Y54 Q74 KINGSWAY MEDICAL CENTRE KINGSWAY BILLINGHAM CLEVELAND   TS23 2LS 1974-04-01 00:00:00   A B 00K 2013-04-01 00:00:00   01642 554967 0 00K 4
53 A81058 COULBY MEDICAL PRACTICE Y54 Q74 COULBY MEDICAL PRACTICE CROPTON WAY,COULBY NEWHAM MIDDLESBROUGH     TS8 0TL 1974-04-01 00:00:00   A B 00M 2013-04-01 00:00:00   01642 746800 0 00M 4
54 A81060 THE KOH PRACTICE Y54 Q74 THE HEALTH CENTRE VICTORIA ROAD HARTLEPOOL CLEVELAND   TS26 8DB 1974-04-01 00:00:00   A B 00K 2013-04-01 00:00:00   01429 273191 0 00K 4
55 A81063 THE HEADLAND MEDICAL CENTRE Y54 Q74 THE HEADLAND MEDICAL CTR 2 GROVE STREET HARTLEPOOL     TS24 0NZ 1974-04-01 00:00:00   A B 00K 2013-04-01 00:00:00   01429 222170 0 00K 4
56 A81064 THE DISCOVERY PRACTICE Y54 Q74 CLEVELAND HEALTH CENTRE 20 CLEVELAND SQUARE CLEVELAND CENTRE MIDDLESBROUGH   TS1 2NX 1974-04-01 00:00:00   A B 00M 2013-04-01 00:00:00   01642 245069 0 00M 4
57 A81065 THE ESTON SURGERY Y54 Q74 LOW GRANGE HEALTH VILLAGE NORMANBY ROAD ESTON CLEVELAND   TS6 6TD 1974-04-01 00:00:00   A B 00M 2013-04-01 00:00:00   01642 511567 0 00M 4
58 A81066 PARK LANE SURGERY Y54 Q74 PARK LANE SURGERY STILLINGTON STOCKTON ON TEES CLEVELAND   TS21 1JS 1974-04-01 00:00:00   A B 00K 2013-04-01 00:00:00   01740 631001 0 00K 4
59 A81067 ALMA MEDICAL CENTRE Y54 Q74 ALMA MEDICAL CENTRE NOLAN PLACE STOCKTON-ON-TEES     TS18 2BP 1974-04-01 00:00:00   A B 00K 2013-04-01 00:00:00   01642 607248 0 00K 4
60 A81069 RAINBOW SURGERY Y54 Q74 REDCAR PRIMARY CARE HOSP WEST DYKE ROAD REDCAR CLEVELAND   TS10 4NW 1974-04-01 00:00:00 2017-01-31 00:00:00 C B 00M 2013-04-01 00:00:00 2017-01-31 00:00:00 01642 475222 0 00M 4
61 A81070 WYNYARD ROAD PRIMARY CARE CENTRE Y54 Q74 WYNYARD ROAD PCC WYNYARD ROAD HARTLEPOOL     TS25 3DQ 1987-10-01 00:00:00   A B 00K 2013-04-01 00:00:00   01429 223195 0 00K 4
62 A81602 DR RASOOL Y54 Q74 ABBEY HEALTH CENTRE FINCHALE AVENUE BILLINGHAM CLEVELAND   TS23 2DG 1974-04-01 00:00:00   A B 00K 2013-04-01 00:00:00   01642 360033 0 00K 4
63 A81605 PARK AVENUE SURGERY Y54 Q74 PARK AVENUE SURGERY 13 PARK AVENUE REDCAR CLEVELAND   TS10 3LA 1974-04-01 00:00:00 2017-03-31 00:00:00 C B 00M 2013-04-01 00:00:00 2017-03-31 00:00:00 01642 470692 1 00M 4
64 A81608 ELM TREE SURGERY Y54 Q74 51 WESTBURY STREET THORNABY STOCKTON-ON-TEES CLEVELAND   TS17 6NP 1974-04-01 00:00:00   A B 00K 2013-04-01 00:00:00   01642 616663 0 00K 4
65 A81609 TENNANT STREET MEDICAL PRACTICE Y54 Q74 THE SURGERY TENNANT STREET STOCKTON-ON-TEES CLEVELAND   TS18 2AT 1974-04-01 00:00:00   D B 00K 2013-04-01 00:00:00   01642 676906 0 00K 4
66 A81610 THE ROSEBERRY PRACTICE Y54 Q74 ABBEY HEALTH CENTRE FINCHALE AVENUE BILLINGHAM CLEVELAND   TS23 2DG 1974-04-01 00:00:00   A B 00K 2013-04-01 00:00:00   01642 552700 0 00K 4
67 A81611 PARKWAY MEDICAL CENTRE Y54 Q74 PARKWAY MEDICAL CENTRE CROPTON WAY,COULBY NEWHAM MIDDLESBROUGH     TS8 0TL 1974-04-01 00:00:00   A B 00M 2013-04-01 00:00:00   01642 270033 0 00M 4
68 A81612 THE PATEL PRACTICE Y54 Q74 THE SURGERY STATION LANE SEATON CAREW HARTLEPOOL, CLEVELAND   TS25 1AX 1974-04-01 00:00:00   A B 00K 2013-04-01 00:00:00   01429 278827 0 00K 4
69 A81613 JOURNEE MEDICAL PRACTICE Y54 Q74 THE HEALTH CENTRE VICTORIA ROAD HARTLEPOOL CLEVELAND   TS26 8DB 1986-02-01 00:00:00   D B 00K 2013-04-01 00:00:00   01429 262095 0 00K 4
70 A81618 HUNTCLIFF SURGERY Y54 Q74 HUNTCLIFF SURGERY BATH STREET SALTBURN-BY-THE-SEA     TS12 1BJ 1988-10-01 00:00:00   A B 00M 2013-04-01 00:00:00   01287 622207 0 00M 4
71 A81621 THORNTREE SURGERY Y54 Q74 THORNTREE SURGERY 11 BERESFORD BUILDINGS MIDDLESBROUGH CLEVELAND   TS3 9NB 1988-10-17 00:00:00   A B 00M 2013-04-01 00:00:00   0300 1112300 0 00M 4
72 A81622 GLADSTONE HOUSE SURGERY Y54 Q74 VICTORIA ROAD HEALTH CENTRE HARTLEPOOL     TS26 8DF 1989-01-09 00:00:00   A B 00K 2013-04-01 00:00:00   01429 297290 0 00K 4
73 A81623 NORTH SHORE MEDICAL PRACTICE Y54 Q74 ENDURANCE HOUSE CLARENCE STREET STOCKTON ON TEES CLEVELAND   TS18 2EP 1989-06-19 00:00:00   D B 00K 2013-04-01 00:00:00   01642 602222 0 00K 4
74 A81629 RIVERSIDE MEDICAL PRACTICE Y54 Q74 RIVERSIDE MEDICAL PRACT. ALMA STREET STOCKTON-ON-TEES CLEVELAND   TS18 2AP 1998-02-01 00:00:00   A B 00K 2013-04-01 00:00:00   01642 604117 0 00K 4
75 A81630 FULCRUM MEDICAL PRACTICE Y54 Q74 FULCRUM MEDICAL PRACTICE ACKLAM ROAD, ACKLAM MIDDLESBROUGH     TS5 4EQ 2001-04-01 00:00:00   A B 00M 2013-04-01 00:00:00   01642 354550 0 112 4
76 A81631 WEST VIEW MILLENIUM SURGERY A Y54 Q74 WEST VIEW MILLENNIUM SURG WEST VIEW ROAD HARTLEPOOL CLEVELAND   TS24 9LJ 2002-02-01 00:00:00   A B 00K 2013-04-01 00:00:00   01429 890400 0 00K 4
77 A81632 LAWSON STREET PRACTICE Y54 Q74 THE HEALTH CENTRE LAWSON STREET STOCKTON-ON-TEES CLEVELAND   TS18 1HU 2002-03-04 00:00:00   A B 00K 2016-09-01 00:00:00   01642 633561 0 00K 4
78 A81633 HAVEN MEDICAL PRACTICE Y54 Q74 HAVEN MEDICAL PRACTICE 7 HARRIS STREET MIDDLESBROUGH     TS1 5EF 2002-10-01 00:00:00   A B 00M 2013-04-01 00:00:00   01642 251053 0 00M 4
79 A81634 THE ARRIVAL PRACTICE Y54 Q74 THE ARRIVAL PRACTICE ENDURANCE HSE,CLARENCE ST STOCKTON ON TEES     TS18 2EP 2003-04-01 00:00:00   A B 00K 2013-04-01 00:00:00   01642 615415 0 00K 4
80 A82003 ULVERSTON HEALTH CENTRE (MURRAY) Y54 Q84 ULVERSTON COMM.HEALTH CTR STANLEY STREET ULVERSTON CUMBRIA   LA12 7BT 1974-04-01 00:00:00   A B 01K 2017-04-01 00:00:00   01229 484141 1 01K 4
81 A82004 ALSTON MEDICAL PRACTICE Y54 Q74 THE SURGERY COTTAGE HOSPITAL ALSTON CUMBRIA   CA9 3QX 1974-04-01 00:00:00   A B 01H 2013-04-01 00:00:00   01434 381214 0 01H 4
82 A82005 AMBLESIDE HEALTH CENTRE Y54 Q84 AMBLESIDE HEALTH CENTRE RYDAL ROAD AMBLESIDE CUMBRIA   LA22 9BP 1974-04-01 00:00:00   A B 01K 2017-04-01 00:00:00   01539 432693 1 01K 4
83 A82006 APPLEBY MEDICAL PRACTICE Y54 Q74 THE RIVERSIDE BUILDING CHAPEL STREET APPLEBY CUMBRIA   CA16 6QR 1974-04-01 00:00:00   A B 01H 2013-04-01 00:00:00   01768 351584 0 01H 4
84 A82007 DUKE STREET SURGERY Y54 Q84 4 DUKE STREET BARROW IN FURNESS CUMBRIA     LA14 1LF 1974-04-01 00:00:00   A B 01K 2017-04-01 00:00:00   01229 820068 1 01K 4
85 A82008 NORWOOD MEDICAL CENTRE Y54 Q84 NORWOOD MEDICAL CENTRE 99 ABBEY ROAD BARROW-IN-FURNESS CUMBRIA   LA14 5ES 1974-04-01 00:00:00   A B 01K 2017-04-01 00:00:00   01229 402525 1 01K 4
86 A82009 BRIDGEGATE MEDICAL CENTRE Y54 Q84 BRIDGEGATE MEDICAL CENTRE WINCHESTER STREET BARROW-IN-FURNESS CUMBRIA   LA13 9SH 1974-04-01 00:00:00   A B 01K 2017-04-01 00:00:00   01229 820304 1 01K 4
87 A82010 ABBEY ROAD SURGERY Y54 Q84 243 ABBEY ROAD BARROW-IN-FURNESS CUMBRIA     LA14 5JY 1974-04-01 00:00:00   A B 01K 2017-04-01 00:00:00   01229 821599 1 01K 4
88 A82011 HARTINGTON STREET MEDICAL PRACTICE Y54 Q74 36-38 HARTINGTON STREET   BARROW-IN-FURNESS CUMBRIA   LA14 5SL 1974-04-01 00:00:00 2016-05-31 00:00:00 C B 01H 2013-04-01 00:00:00 2016-05-31 00:00:00 01229 820554 0 01H 4
89 A82012 BRAMPTON MEDICAL PRACTICE Y54 Q74 BRAMPTON MEDICAL PRACTICE 4 MARKET PLACE, BRAMPTON CARLISLE CUMBRIA   CA8 1NL 1974-04-01 00:00:00   A B 01H 2013-04-01 00:00:00   01697 72551 0 01H 4
90 A82013 UPPER EDEN MEDICAL PRACTICE Y54 Q74 THE MEDICAL CENTRE BROUGH KIRKBY STEPHEN CUMBRIA   CA17 4AY 1974-04-01 00:00:00   A B 01H 2013-04-01 00:00:00   01768 341294 0 01H 4
91 A82014 CALDBECK SURGERY Y54 Q74 CALDBECK SURGERY FRIAR ROW,CALDBECK WIGTON CUMBRIA   CA7 8DS 1974-04-01 00:00:00   A B 01H 2013-04-01 00:00:00   01697 478254 0 01H 4
92 A82015 WARWICK ROAD SURGERY Y54 Q74 WARWICK ROAD SURGERY 65 WARWICK ROAD CARLISLE CUMBRIA   CA1 1EB 1974-04-01 00:00:00   A B 01H 2013-04-01 00:00:00   01228 536303 0 01H 4
93 A82016 CARLISLE HEALTHCARE Y54 Q74 ST.PAUL'S MEDICAL CENTRE ST.PAUL'S SQUARE CARLISLE CUMBRIA   CA1 1DG 1974-04-01 00:00:00   A B 01H 2013-04-01 00:00:00   01228 588121 0 01H 4
94 A82017 BRUNSWICK HOUSE MEDICAL GROUP Y54 Q74 BRUNSWICK HOUSE MED GROUP 1 BRUNSWICK STREET CARLISLE CUMBRIA   CA1 1ED 1974-04-01 00:00:00   D B 01H 2013-04-01 00:00:00   01228 515808 0 01H 4
95 A82018 SPENCER ST SURGERY Y54 Q74 SPENCER STREET SURGERY 10 SPENCER STREET CARLISLE CUMBRIA   CA1 1BP 1974-04-01 00:00:00   A B 01H 2013-04-01 00:00:00   01228 529171 0 01H 4
96 A82019 FUSEHILL MEDICAL PRACTICE Y54 Q74 FUSEHILL MEDICAL CENTRE FUSEHILL STREET CARLISLE CUMBRIA   CA1 2HE 1974-04-01 00:00:00   A B 01H 2013-04-01 00:00:00   01228 527559 0 01H 4
97 A82020 EDEN MEDICAL GROUP Y54 Q74 THE EDEN MEDICAL GROUP PORT ROAD CARLISLE CUMBRIA   CA2 7AJ 1974-04-01 00:00:00   A B 01H 2013-04-01 00:00:00   01228 524477 0 01H 4
98 A82021 CASTLEGATE AND DERWENT SURGERY Y54 Q74 COCKERMOUTH HEALTH CENTRE ISEL ROAD COCKERMOUTH CUMBRIA   CA13 9HT 1974-04-01 00:00:00   A B 01H 2013-04-01 00:00:00   01900 705750 0 01H 4
99 A82022 DALSTON MEDICAL GROUP Y54 Q74 DALSTON MEDICAL GROUP THE SURGERY,TOWNSEND ROAD DALSTON CARLISLE   CA5 7PZ 1974-04-01 00:00:00   A B 01H 2013-04-01 00:00:00   01228 710451 0 01H 4
100 A82023 DISTINGTON SURGERY Y54 Q74 THE SURGERY HINNINGS ROAD, DISTINGTON WORKINGTON CUMBRIA   CA14 5UR 1974-04-01 00:00:00   A B 01H 2013-04-01 00:00:00   01946 830207 0 01H 4

Next page

CREATE TABLE "epraccur" (
"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,
  "Commissioner" TEXT,
  "Join Provider/Purchaser Date" TIMESTAMP,
  "Left Provider/Purchaser Date" TIMESTAMP,
  "Contact Telephone Number" TEXT,
  "Amended Record Indicator" INTEGER,
  "Provider/Purchaser" TEXT,
  "Prescribing Setting" INTEGER
)
Powered by Datasette · Query took 50.648ms · Data source: OUseful Databeat