home / nhsadmin

Independent Sector Healthcare Provider Sites

Data source: OUseful Databeat

10,644 rows

View and edit SQL

This data as .json

Suggested facets: National Grouping, High Level Health Geography, Close Date, Organisation SubType 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 Organisation SubType Code Parent Organisation Code Amended Record Indicator
1 AA401 INTRAHEALTH LTD - PETERLEE Y54 Q74 1ST FLOOR, WILLIAM BROWN CENTRE MANOR WAY   PETERLEE COUNTY DURHAM SR8 5TW 2013-04-01 00:00:00   E AA4 0
2 AA402 ASHFURLONG HEALTH CENTRE Y55 Q77 233 TAMWORTH ROAD     SUTTON COLDFIELD WEST MIDLANDS B75 6DX 2015-10-01 00:00:00   E AA4 0
3 AA403 SUTTON PARK SURGERY Y55 Q77 34 CHESTER ROAD NORTH     SUTTON COLDFIELD WEST MIDLANDS B73 6SP 2015-10-01 00:00:00   E AA4 0
4 AA404 THE OAKS MEDICAL CENTRE Y55 Q77 199 SHADY LANE GREAT BARR   BIRMINGHAM WEST MIDLANDS B44 9ER 2015-10-01 00:00:00   E AA4 0
5 AA405 WARREN FARM URGENT CARE CENTRE Y55 Q77 WARREN FARM ROAD KINGSTANDING   BIRMINGHAM WEST MIDLANDS B44 0PU 2015-10-01 00:00:00   E AA4 0
6 AA406 STOCKLAND GREEN PRIMARY CARE CENTRE Y55 Q77 192 RESERVOIR ROAD ERDINGTON   BIRMINGHAM WEST MIDLANDS B23 6DJ 2015-10-01 00:00:00   E AA4 0
7 AA407 EDEN COURT MEDICAL PRACTICE Y55 Q77 200 TANGMERE DRIVE CASTLE VALE   BIRMINGHAM WEST MIDLANDS B35 6EE 2015-10-01 00:00:00   E AA4 0
8 AA408 HODGE HILL PRIMARY CARE CENTRE Y55 Q77 ROUGHLEA AVENUE HODGE HILL   BIRMINGHAM WEST MIDLANDS B36 8GH 2015-10-01 00:00:00   E AA4 0
9 AA409 CLAYPATH MEDICAL PRACTICE Y54 Q74 26 GILESGATE     DURHAM COUNTY DURHAM DH1 1QW 2015-10-01 00:00:00   E AA4 0
10 AA410 DUNELM MEDICAL PRACTICE - GILESGATE Y54 Q74 SUNDERLAND ROAD     DURHAM COUNTY DURHAM DH1 2QG 2015-10-01 00:00:00   E AA4 0
11 AA411 CHEVELEY PARK MEDICAL CENTRE Y54 Q74 THE LINKS BELMONT   DURHAM COUNTY DURHAM DH1 2UW 2015-10-01 00:00:00   E AA4 0
12 AA412 CHASTLETON MEDICAL GROUP Y54 Q74 NEWTON DRIVE FRAMWELLGATE MOOR   DURHAM COUNTY DURHAM DH1 5BH 2015-10-01 00:00:00   E AA4 0
13 AA413 DUNELM MEDICAL PRACTICE - FRAMWELLGATE MOOR Y54 Q74 50 FRONT STREET FRAMWELLGATE MOOR   DURHAM COUNTY DURHAM DH1 5BL 2015-10-01 00:00:00   E AA4 0
14 AA414 PELTON & FELLROSE MEDICAL GROUP Y54 Q74 THE LAVENDER CENTRE PELTON LANE PELTON CHESTER LE STREET COUNTY DURHAM DH2 1HS 2015-10-01 00:00:00   E AA4 0
15 AA415 FELLROSE SURGERY Y54 Q74 CRAGHEAD ROAD PELTON FELL   CHESTER LE STREET COUNTY DURHAM DH2 2NH 2015-10-01 00:00:00   E AA4 0
16 AA416 CESTRIA HEALTH CENTRE Y54 Q74 WHITEHILL WAY     CHESTER LE STREET COUNTY DURHAM DH2 3DJ 2015-10-01 00:00:00   E AA4 0
17 AA417 MIDDLECHARE MEDICAL GROUP Y54 Q74 MIDDLE CHARE     CHESTER LE STREET COUNTY DURHAM DH3 3QD 2015-10-01 00:00:00   E AA4 0
18 AA419 THE SURGERY Y54 Q74 LOMBARD PLACE GREAT LUMLEY   CHESTER LE STREET COUNTY DURHAM DH3 4LE 2015-10-01 00:00:00   E AA4 0
19 AA420 HOUGHTON MEDICAL GROUP Y54 Q74 CHURCH STREET     HOUGHTON LE SPRING TYNE AND WEAR DH4 4DN 2015-10-01 00:00:00   E AA4 0
20 AA422 GRANGEWOOD SURGERY Y54 Q74 CHESTER ROAD SHINEY ROW   HOUGHTON LE SPRING TYNE AND WEAR DH4 4RB 2015-10-01 00:00:00   E AA4 0
21 AA423 SHINEY ROW SURGERY Y54 Q74 KELSO GROVE     HOUGHTON LE SPRING TYNE AND WEAR DH4 4RW 2015-10-01 00:00:00   E AA4 0
22 AA424 KEPIER MEDICAL PRACTICE Y54 Q74 LEYBURN GROVE     HOUGHTON LE SPRING TYNE AND WEAR DH4 5EQ 2015-10-01 00:00:00   E AA4 0
23 AA425 WEST RAINTON SURGERY Y54 Q74 WOODLAND VIEW WEST RAINTON   HOUGHTON LE SPRING TYNE AND WEAR DH4 6RQ 2015-10-01 00:00:00   E AA4 0
24 AA426 HETTON MEDICAL CENTRE Y54 Q74 FRANCIS WAY HETTON-LE-HOLE   HOUGHTON LE SPRING TYNE AND WEAR DH5 9EZ 2015-10-01 00:00:00   E AA4 0
25 AA427 SHOTTON SURGERY Y54 Q74 STATION ROAD SHOTTON COLLIERY   DURHAM COUNTY DURHAM DH6 2JL 2015-10-01 00:00:00   E AA4 0
26 AA428 THORNLEY ROAD SURGERY Y54 Q74 38 DUNELM ROAD THORNLEY   DURHAM COUNTY DURHAM DH6 3HW 2015-10-01 00:00:00   E AA4 0
27 AA429 WHEATLEY HILL SURGERY Y54 Q74 THORNLEY ROAD WHEATLEY HILL   DURHAM COUNTY DURHAM DH6 3NR 2015-10-01 00:00:00   E AA4 0
28 AA430 THE SURGERY WOODLAND CRESCENT Y54 Q74 182 WOODLAND CRESCENT KELLOE   DURHAM COUNTY DURHAM DH6 4NA 2015-10-01 00:00:00   E AA4 0
29 AA431 BOWBURN MEDICAL PRACTICE Y54 Q74 4 ROMAINE SQUARE BOWBURN   DURHAM COUNTY DURHAM DH6 5AE 2015-10-01 00:00:00   E AA4 0
30 AA432 SACRISTON MEDICAL CENTRE Y54 Q74 FRONT STREET SACRISTON   DURHAM COUNTY DURHAM DH7 6JW 2015-10-01 00:00:00   E AA4 0
31 AA433 DUNELM MEDICAL PRACTICE - BEARPARK Y54 Q74 KELVIN HOUSE 1-2 VICTOR TERRACE BEARPARK DURHAM COUNTY DURHAM DH7 7DG 2015-10-01 00:00:00   E AA4 0
32 AA434 BRANDON LANE SURGERY Y54 Q74 STACKGARTH BRANDON   DURHAM COUNTY DURHAM DH7 8SJ 2015-10-01 00:00:00   E AA4 0
33 AA435 NEASHAM ROAD SURGERY Y54 Q74 186 NEASHAM ROAD     DARLINGTON COUNTY DURHAM DL1 4YL 2015-10-01 00:00:00   E AA4 0
34 AA436 CLIFTON COURT MEDICAL PRACTICE Y54 Q74 VICTORIA ROAD     DARLINGTON COUNTY DURHAM DL1 5JN 2015-10-01 00:00:00   E AA4 0
35 AA437 PARKGATE MEDICAL PRACTICE Y54 Q74 PARK PLACE     DARLINGTON COUNTY DURHAM DL1 5LW 2015-10-01 00:00:00   E AA4 0
36 AA438 WEST CORNFORTH MEDICAL PRACTICE Y54 Q74 READING STREET WEST CORNFORTH   FERRYHILL COUNTY DURHAM DL17 9LH 2015-10-01 00:00:00   E AA4 0
37 AA439 FELIX HOUSE SURGERY Y54 Q74 MIDDLETON LANE MIDDLETON ST GEORGE   DARLINGTON COUNTY DURHAM DL2 1AA 2015-10-01 00:00:00   E AA4 0
38 AA440 BAGSHAW & WILLIAMS Y54 Q74 ROCKLIFFE COURT HURWORTH PLACE   DARLINGTON COUNTY DURHAM DL2 2DS 2015-10-01 00:00:00   E AA4 0
39 AA441 BLACKETTS MEDICAL PRACTICE Y54 Q74 63-65 BONDGATE     DARLINGTON COUNTY DURHAM DL3 7JR 2015-10-01 00:00:00   E AA4 0
40 AA442 MOORLANDS MEDICAL PRACTICE Y54 Q74 139A WILLOW ROAD     DARLINGTON COUNTY DURHAM DL3 9JP 2015-10-01 00:00:00   E AA4 0
41 AA443 BROCKWELL MEDICAL GROUP Y54 Q74 NORTHUMBRIAN ROAD     CRAMLINGTON NORTHUMBERLAND NE23 1XZ 2015-10-01 00:00:00   E AA4 0
42 AA444 THE VILLAGE SURGERY Y54 Q74 DUDLEY LANE     CRAMLINGTON NORTHUMBERLAND NE23 6US 2015-10-01 00:00:00   E AA4 0
43 AA445 NETHERFIELD HOUSE SURGERY Y54 Q74 STATION ROAD SEGHILL   CRAMLINGTON NORTHUMBERLAND NE23 7EF 2015-10-01 00:00:00   E AA4 0
44 AA446 SEATON TERRACE SURGERY Y54 Q74 WESTBOURNE TERRACE SEATON DELAVAL   WHITLEY BAY TYNE AND WEAR NE25 0BE 2015-10-01 00:00:00   E AA4 0
45 AA447 ELSDON AVENUE SURGERY Y54 Q74 ELSDON AVENUE SEATON DELAVAL   WHITLEY BAY TYNE AND WEAR NE25 0BW 2015-10-01 00:00:00   E AA4 0
46 AA448 SEATON SLUICE SURGERY Y54 Q74 COLLYWELL BAY ROAD SEATON SLUICE   WHITLEY BAY TYNE AND WEAR NE26 4QZ 2015-10-01 00:00:00   E AA4 0
47 AA449 VICTORIA ROAD HEALTH CENTRE Y54 Q74 CONCORD VICTORIA ROAD   WASHINGTON TYNE AND WEAR NE37 2PU 2015-10-01 00:00:00   E AA4 0
48 AA450 GALLERIES HEALTH CENTRE Y54 Q74 THE GALLERIES WASHINGTON CENTRE   WASHINGTON TYNE AND WEAR NE38 7NQ 2015-10-01 00:00:00   E AA4 0
49 AA451 INTRAHEALTH BARMSTON MEDICAL CENTRE Y54 Q74 ARMSTRONG ROAD     WASHINGTON TYNE AND WEAR NE38 8JF 2015-10-01 00:00:00   E AA4 0
50 AA452 BONDGATE PRACTICE Y54 Q74 INFIRMARY DRIVE     ALNWICK NORTHUMBERLAND NE66 2NL 2015-10-01 00:00:00   E AA4 0
51 AA453 SEAHOUSES HEALTH CENTRE Y54 Q74 JAMES STREET     SEAHOUSES NORTHUMBERLAND NE68 7XZ 2015-10-01 00:00:00   E AA4 0
52 AA454 MILLENIUM FAMILY PRACTICE Y54 Q74 TRINITIY SQUARE HEALTH CENTRE 24 WEST STREET   GATESHEAD TYNE AND WEAR NE8 1AD 2015-10-01 00:00:00   E AA4 0
53 AA455 BEACON VIEW MEDICAL CENTRE Y54 Q74 BEACON LOUGH ROAD     GATESHEAD TYNE AND WEAR NE9 6YS 2015-10-01 00:00:00   E AA4 0
54 AA456 NEW CITY MEDICAL PRACTICE Y54 Q74 TATHAM STREET HENDON   SUNDERLAND TYNE AND WEAR SR1 2QB 2015-10-01 00:00:00   E AA4 0
55 AA457 HYLTON MEDICAL GROUP - RYHOPE Y54 Q74 RYHOPE HEALTH CENTRE BLACK ROAD RYHOPE SUNDERLAND TYNE AND WEAR SR2 0RY 2015-10-01 00:00:00   E AA4 0
56 AA458 VILLETTE SURGERY Y54 Q74 SUFFOLK STREET     SUNDERLAND TYNE AND WEAR SR2 8AX 2015-10-01 00:00:00   E AA4 0
57 AA459 ASHBURN MEDICAL CENTRE Y54 Q74 74-75 TOWARD ROAD     SUNDERLAND TYNE AND WEAR SR2 8JG 2015-10-01 00:00:00   E AA4 0
58 AA460 COLLIERY MEDICAL GROUP Y54 Q74 SILKSWORTH MEDICAL CENTRE SILKSWORTH ROAD   SUNDERLAND TYNE AND WEAR SR3 2AN 2015-10-01 00:00:00   E AA4 0
59 AA461 THE OLD FORGE SURGERY Y54 Q74 PALLION PARK PALLION   SUNDERLAND TYNE AND WEAR SR4 6QE 2015-10-01 00:00:00   E AA4 0
60 AA462 MILLFIELD MEDICAL CENTRE Y54 Q74 63-83 HYLTON ROAD MILLFIELD   SUNDERLAND TYNE AND WEAR SR4 7AF 2015-10-01 00:00:00   E AA4 0
61 AA463 DR ELSAFY Y54 Q74 215 CHESTER ROAD     SUNDERLAND TYNE AND WEAR SR4 7TU 2015-10-01 00:00:00   E AA4 0
62 AA464 SOUTHWICK HEALTH CENTRE Y54 Q74 THE GREEN SOUTHWICK   SUNDERLAND TYNE AND WEAR SR5 2LT 2015-10-01 00:00:00   E AA4 0
63 AA465 CASTLETOWN MEDICAL CENTRE Y54 Q74 6 THE BROADWAY CASTLETOWN   SUNDERLAND TYNE AND WEAR SR5 3EX 2015-10-01 00:00:00   E AA4 0
64 AA466 ST BEDE MEDICAL CENTRE Y54 Q74 LOWER DUNDAS STREET     SUNDERLAND TYNE AND WEAR SR6 0QQ 2015-10-01 00:00:00   E AA4 0
65 AA467 FULLWELL MEDICAL CENTRE Y54 Q74 EBDON LANE FULWELL   SUNDERLAND TYNE AND WEAR SR6 8DZ 2015-10-01 00:00:00   E AA4 0
66 AA468 ARBROATH HOUSE Y54 Q74 SEASIDE LANE SOUTH EASINGTON COLLIERY   PETERLEE COUNTY DURHAM SR8 3PE 2015-10-01 00:00:00   E AA4 0
67 AA469 SEATON SURGERY Y54 Q74 STATION LANE SEATON CAREW   HARTLEPOOL CLEVELAND TS25 1AX 2015-10-01 00:00:00   E AA4 0
68 AA470 WYNYARD ROAD PRIMARY CARE CENTRE Y54 Q74 WYNYARD ROAD     HARTLEPOOL CLEVELAND TS25 3DQ 2015-10-01 00:00:00   E AA4 0
69 AA471 HARTFIELDS EXTRA CARE VILLAGE Y54 Q74 HARTFIELDS MANOR     HARTLEPOOL CLEVELAND TS26 0US 2015-10-01 00:00:00   E AA4 0
70 AA472 THE MEDICAL CENTRE WINGATE Y54 Q74 FRONT STREET WEST     WINGATE COUNTY DURHAM TS28 5PZ 2015-10-01 00:00:00   E AA4 0
71 AA473 PALLION HEALTH CENTRE Y54 Q74 HYLTON ROAD     SUNDERLAND TYNE AND WEAR SR4 7XF 2015-10-01 00:00:00   E AA4 0
72 AA474 TOWNSIDE Y54 Q83 KNOWSLEY STREET     BURY LANCASHIRE BL9 0SN 2015-10-01 00:00:00   E AA4 0
73 AA475 RADCLIFFE PRIMARY CARE CENTRE Y54 Q83 69 CHURCH STREET WEST RADCLIFFE   MANCHESTER GREATER MANCHESTER M26 2SP 2015-10-01 00:00:00   E AA4 0
74 AA476 MOORSIDE LIBRARY/COMMUNITY CENTRE Y54 Q83 PARKINSON STREET     BURY LANCASHIRE BL9 6NY 2015-10-01 00:00:00   E AA4 0
75 AA477 MOORGATE PRIMARY CARE CENTRE Y54 Q83 22 DERBY WAY     BURY LANCASHIRE BL9 0NJ 2015-10-01 00:00:00   E AA4 0
76 AA478 PRESTWICH HEALTH CENTRE Y54 Q83 FAIRFAX ROAD PRESTWICH   MANCHESTER GREATER MANCHESTER M25 1BT 2015-10-01 00:00:00   E AA4 0
77 AA479 TOTTINGTON HEALTH CENTRE Y54 Q83 MARKET STREET TOTTINGTON   BURY LANCASHIRE BL8 4AD 2015-10-01 00:00:00   E AA4 0
78 AA480 GREENMOUNT MEDICAL CENTRE Y54 Q83 9 BRANDLESHOLME ROAD GREENMOUNT   BURY LANCASHIRE BL8 4DR 2015-10-01 00:00:00   E AA4 0
79 AA481 KNOWSLEY MEDICAL CENTRE Y54 Q83 9-11 KNOWSLEY STREET     BURY LANCASHIRE BL9 0ST 2015-10-01 00:00:00   E AA4 0
80 AA482 LILLY & PARTNERS Y54 Q74 BRIDGE END SURGERY BRIDGE END   CHESTER LE STREET COUNTY DURHAM DH3 3SL 2015-10-01 00:00:00   E AA4 0
81 AA483 HERRINGTON MEDICAL CENTRE Y54 Q74 PHILADELPHIA LANE     HOUGHTON LE SPRING TYNE AND WEAR DH4 4LE 2015-10-01 00:00:00   E AA4 0
82 AA484 SAI MEDICAL PRACTICE Y55 Q77 1 FORRESTER STREET     WALSALL WEST MIDLANDS WS2 9PL 2015-10-01 00:00:00   E AA4 0
83 AA485 WASHWOOD HEATH HEALTH & WELLBEING CENTRE Y55 Q77 4 CLODESHALL ROAD     BIRMINGHAM WEST MIDLANDS B8 3SN 2015-10-01 00:00:00   E AA4 0
84 AA486 WHITTAKER LANE Y54 Q83 DAISY BANK WHITTAKER LANE PRESTWICH MANCHESTER GREATER MANCHESTER M25 1ET 2016-04-01 00:00:00   E AA4 0
85 AA487 ST GABRIELS Y54 Q83 4 BISHOPS ROAD PRESTWICH   MANCHESTER GREATER MANCHESTER M25 0HT 2016-04-01 00:00:00   E AA4 0
86 AA488 DR HUSSAINS Y54 Q84 WALMERSLEY ROAD PRACTICE 110 WALMERSLEY ROAD   BURY LANCASHIRE BL9 6DX 2016-04-01 00:00:00   E AA4 0
87 AA501 COMPASS WELLBEING CIC (STEELS LANE H/C) Y56 Q71 STEELS LANE HEALTH CENTRE 384-388 COMMERCIAL ROAD   LONDON GREATER LONDON E1 0LR 2013-04-01 00:00:00   E AA5 0
88 AA601 ASSISTED CONCEPTION UNIT LTD - LEYTONSTONE Y56 Q71 LEYTONSTONE HOUSE LEYTONSTONE   LONDON GREATER LONDON E11 1GA 2013-04-01 00:00:00   E AA6 0
89 AA602 THE CENTRE FOR REPRODUCTIVE AND GENETIC HEALTH Y56 Q71 THE NEW WING 256 GRAY'S INN ROAD   LONDON GREATER LONDON WC1X 8LD 2013-04-01 00:00:00   E AA6 0
90 AA701 LEYLAND PHYSIOTHERAPY (LEYLAND) Y54 Q84 83 BOW LANE     LEYLAND LANCASHIRE PR25 4YB 2013-04-01 00:00:00   E AA7 0
91 AA801 HOWARD HOUSE DETOXIFICATION UNIT Y57 Q82 190 IFFLEY ROAD     OXFORD OXFORDSHIRE OX4 1SD 2013-04-01 00:00:00   E AA8 0
92 AA901 COTTER LAUBIS PARTNERS (BELLEGROVE SURGERY) Y56 Q71 BELLEGROVE SURGERY 174 BELLEGROVE ROAD   WELLING KENT DA16 3RE 2013-04-01 00:00:00   E AA9 0
93 AA902 COTTER LAUBIS PARTNERS (LAKESIDE HEALTH CENTRE) Y56 Q71 LAKESIDE HEALTH CENTRE YARNTON WAY   LONDON GREATER LONDON SE2 9LH 2013-04-01 00:00:00   E AA9 0
94 AA903 COTTER LAUBIS PARTNERS (ALBION SURGERY) Y56 Q71 ALBION SURGERY 6 PINCOTT ROAD   BEXLEYHEATH KENT DA6 7LP 2013-04-01 00:00:00   E AA9 0
95 AA904 COTTER LAUBIS PARTNERS (BEDSIDE MANOR) Y56 Q71 82 MARLBOROUGH PARK AVENUE     SIDCUP KENT DA15 9DX 2013-04-01 00:00:00   E AA9 0
96 AA905 COTTER LAUBIS PARTNERS (PLAS MEDDYG SURGERY) Y56 Q71 40 PARKHILL ROAD     BEXLEY KENT DA5 1HU 2013-04-01 00:00:00   E AA9 0
97 AA906 COTTER LAUBIS PARTNERS (GOOD HEALTH) Y56 Q71 ERITH HEALTH CENTRE 50 PIER ROAD   ERITH KENT DA8 1RQ 2013-04-01 00:00:00   E AA9 0
98 AAA01 BOOTS - ANTICOAGULATION SERVICE Y55 Q76 234 THE GLADES SHOPPING CENTRE HIGH STREET   BROMLEY KENT BR1 1HD 2013-04-01 00:00:00   E AAA 0
99 AAA02 BOOTS ANTICOAGULATION SERVICE (SUNDERLAND) Y54 Q74 45 THE BRIDGES     SUNDERLAND TYNE AND WEAR SR1 3LF 2013-10-01 00:00:00   E AAA 0
100 AAA03 BOOTS ANTICOAGULATION SERVICE (SOUTH TYNESIDE) Y54 Q74 3 CROWHALL LANE FELLING   GATESHEAD TYNE AND WEAR NE10 9PW 2014-04-01 00:00:00   E AAA 0

Next page

CREATE TABLE "ephpsite" (
"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,
  "Organisation SubType Code" TEXT,
  "Parent Organisation Code" TEXT,
  "Amended Record Indicator" INTEGER
)
Powered by Datasette · Query took 50.136ms · Data source: OUseful Databeat