home / nhsadmin

Care Trusts and Sites

Data source: OUseful Databeat

406 rows

View and edit SQL

This data as .json

Suggested facets: National Grouping, High Level Health Geography, Address Line 3, Address Line 5, Open Date, Close Date, GOR Code

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 Contact Telephone Number Amended Record Indicator GOR Code
1 TAD BRADFORD DISTRICT CARE NHS FOUNDATION TRUST Y54 Q72 NEW MILL VICTORIA ROAD SALTAIRE SHIPLEY WEST YORKSHIRE BD18 3LA 2002-04-01 00:00:00   T   0 D
2 TAD01 MOOR LANE CENTRE Y54 Q72 MOOR LANE   BURLEY IN WHARFEDALE ILKLEY WEST YORKSHIRE LS29 7AJ 2002-04-01 00:00:00       0 D
3 TAD02 AIREDALE CHILD & FAMILY SERVICE Y54 Q72 HILLBROOK MAYFIELD ROAD   KEIGHLEY WEST YORKSHIRE BD20 6LD 2002-04-01 00:00:00       0 D
4 TAD03 CRAVEN CMHT Y54 Q72 SKIPTON GENERAL HOSPITAL KEIGHLEY ROAD   SKIPTON NORTH YORKSHIRE BD23 2RJ 2002-04-01 00:00:00       0 D
5 TAD04 DRUG & ALCOHOL TEAM Y54 Q72 25-27 HENRY STREET     KEIGHLEY WEST YORKSHIRE BD21 3DR 2002-04-01 00:00:00       0 D
6 TAD05 INGROW CENTRE Y54 Q72 KILMAY HOUSE 200 SOUTH STREET   KEIGHLEY WEST YORKSHIRE BD21 1BB 2002-04-01 00:00:00       0 D
7 TAD09 GREYFRIARS WALK Y54 Q72 20 GREYFRIARS WALK     BRADFORD WEST YORKSHIRE BD7 4BD 2002-04-01 00:00:00       0 D
8 TAD10 ABELIA MOUNT Y54 Q72 6-12 ABELIA MOUNT     BRADFORD WEST YORKSHIRE BD7 2TG 2002-04-01 00:00:00       0 D
9 TAD12 COOPER LANE OFFICES Y54 Q72 84 COOPER LANE     BRADFORD WEST YORKSHIRE BD6 3NJ 2002-04-01 00:00:00       0 D
10 TAD14 LAND AT ASHFIELD HOUSE Y54 Q72 THORNTON ROAD   THORNTON BRADFORD WEST YORKSHIRE BD13 3LN 2002-04-01 00:00:00       0 D
11 TAD15 DAISY BANK Y54 Q72 109 DUCKWORTH LANE   DAISY HILL BRADFORD WEST YORKSHIRE BD9 6RL 2002-04-01 00:00:00       0 D
12 TAD16 AIREDALE CENTRE FOR MENTAL HEALTH Y54 Q72 SKIPTON ROAD STEETON   KEIGHLEY WEST YORKSHIRE BD20 6TD 2002-04-01 00:00:00       0 D
13 TAD17 LYNFIELD MOUNT HOSPITAL Y54 Q72 HEIGHTS LANE     BRADFORD WEST YORKSHIRE BD9 6DP 2002-04-01 00:00:00       0 D
14 TAD18 ODSAL HEALTH CENTRE/ THE ELMS Y54 Q72 55 ODSAL ROAD     BRADFORD WEST YORKSHIRE BD6 1PR 2002-04-01 00:00:00       0 D
15 TAD19 POLLITS HOUSE Y54 Q72 POLLITS FARM COOPER LANE   BRADFORD WEST YORKSHIRE BD6 3NJ 2002-04-01 00:00:00       0 D
16 TAD21 BRYAN-SUTHERLAND HOUSE Y54 Q72 COOPER LANE     BRADFORD WEST YORKSHIRE BD6 3NL 2002-04-01 00:00:00       0 D
17 TAD22 SOMERSET HOUSE Y54 Q72 MANOR LANE     SHIPLEY WEST YORKSHIRE BD18 3BP 2002-04-01 00:00:00       0 D
18 TAD23 STONEY RIDGE HOSPITAL Y54 Q72 STONEY RIDGE ROAD     BINGLEY WEST YORKSHIRE BD16 1UL 2002-04-01 00:00:00       0 D
19 TAD25 WADDILOVES Y54 Q72 44 QUEENS ROAD     BRADFORD WEST YORKSHIRE BD8 7BT 2002-04-01 00:00:00       0 D
20 TAD27 PARK VIEW Y54 Q72 SPRING GARDENS LANE     KEIGHLEY WEST YORKSHIRE BD20 6LB 2002-04-01 00:00:00       0 D
21 TAD28 SKIPTON ROAD Y54 Q72 147 SKIPTON ROAD     KEIGHLEY WEST YORKSHIRE BD21 3BG 2002-04-01 00:00:00       0 D
22 TAD29 WALKER HOUSE (3RD FLOOR) Y54 Q72 19-25 SUNBRIDGE ROAD     BRADFORD WEST YORKSHIRE BD1 2AY 2002-04-01 00:00:00       0 D
23 TAD30 OWLET ROAD Y54 Q72 21 OWLET ROAD     SHIPLEY WEST YORKSHIRE BD18 2LU 2002-04-01 00:00:00       0 D
24 TAD31 THE GROVE (COPWOOD) Y54 Q72 15 COPGROVE ROAD     BRADFORD WEST YORKSHIRE BD4 0DJ 2002-04-01 00:00:00       0 D
25 TAD32 FUSION Y54 Q72 WHITEOAK CENTRE 2 FOSTON CLOSE   BRADFORD WEST YORKSHIRE BD2 3QF 2002-04-01 00:00:00       0 D
26 TAD36 MELVILLE HOUSE Y54 Q72 PRESTON STREET     BRADFORD WEST YORKSHIRE BD7 1JP 2002-04-01 00:00:00       0 D
27 TAD37 STRAWBERRY STREET A Y54 Q72 STRAWBERRY STREET     KEIGHLEY WEST YORKSHIRE BD21 3BA 2002-04-01 00:00:00       0 D
28 TAD38 ACRES HOUSE Y54 Q72 BERRY LANE     KEIGHLEY WEST YORKSHIRE BD21 1DN 2002-04-01 00:00:00       0 D
29 TAD39 ACRES HOUSE (TEAM MEET) Y54 Q72 BERRY LANE     KEIGHLEY WEST YORKSHIRE BD21 1DN 2002-04-01 00:00:00       0 D
30 TAD40 BINGLEY VA COMMUNITY CENTRE Y54 Q72 CARDIGAN HOUSE FERNCLIFFE ROAD   BINGLEY WEST YORKSHIRE BD16 2TA 2002-04-01 00:00:00       0 D
31 TAD41 BRIDGE HOUSE Y54 Q72 BAILEY HILLS ROAD     BINGLEY WEST YORKSHIRE BD16 2RJ 2002-04-01 00:00:00       0 D
32 TAD44 FISHER MEDICAL CENTRE (PSYCHOLOGY) Y54 Q72 MILLFIELDS COACH STREET   SKIPTON NORTH YORKSHIRE BD23 1EU 2002-04-01 00:00:00       0 D
33 TAD45 FISHER MEDICAL CENTRE (DR FISK) Y54 Q72 MILLFIELDS COACH STREET   SKIPTON NORTH YORKSHIRE BD23 1EU 2002-04-01 00:00:00       0 D
34 TAD46 HOLMEWOOD Y54 Q72 67 FELL LANE     KEIGHLEY WEST YORKSHIRE BD22 6AB 2002-04-01 00:00:00       0 D
35 TAD54 THE AIREDALE CENTRE FOR MENTAL HEALTH Y54 Q72 SKIPTON ROAD STEETON WITH EASTBURN   KEIGHLEY WEST YORKSHIRE BD20 6TA 2002-04-01 00:00:00       0 D
36 TAD55 1/3 LEGRAMS TERRACE Y54 Q72 FIELDHEAD BUSINESS CENTRE     BRADFORD WEST YORKSHIRE BD7 1LN 2002-04-01 00:00:00       0 D
37 TAD57 48 ASH GROVE Y54 Q72 GREAT HORTON ROAD     BRADFORD WEST YORKSHIRE BD7 1BL 2002-04-01 00:00:00       0 D
38 TAD59 CEMETERY ROAD Y54 Q72 UNIT 1, FOUR LANE BUSINESS PARK CEMETERY ROAD   BRADFORD WEST YORKSHIRE BD8 9RY 2002-04-01 00:00:00       0 D
39 TAD61 UNIT E3 & E4 ENTERPRISE WAY Y54 Q72 BRADFORD ROAD     BRADFORD WEST YORKSHIRE BD10 8EW 2002-04-01 00:00:00       0 D
40 TAD62 FIELDHEAD HOUSE Y54 Q72 UNITS 2/8 FIELDHEAD BUSINESS CENTRE   BRADFORD WEST YORKSHIRE BD7 1LN 2002-04-01 00:00:00       0 D
41 TAD63 HORTON PARK Y54 Q72 99 HORTON PARK AVENUE     BRADFORD WEST YORKSHIRE BD7 3EG 2002-04-01 00:00:00       0 D
42 TAD65 LISTONSHIELS Y54 Q72 BIERLEY LANE     BRADFORD WEST YORKSHIRE BD4 6DN 2002-04-01 00:00:00       0 D
43 TAD66 UNIT 2D REVIVAL INDUSTRIAL ESTATE Y54 Q72 WINDSOR STREET     BRADFORD WEST YORKSHIRE BD4 7AQ 2002-04-01 00:00:00       0 D
44 TAD67 SOUTH AND WEST CMHT FOR OLDER PEOPLE Y54 Q72 HARBOURNE BREARCLIFFE DRIVE   BRADFORD WEST YORKSHIRE BD6 2LE 2002-04-01 00:00:00       0 D
45 TAD68 BRADFORD CITY CMHT FOR OLDER PEOPLE Y54 Q72 WOODWARD COURT KIRKLEES ROAD ALLERTON BRADFORD WEST YORKSHIRE BD15 7YT 2002-04-01 00:00:00       0 D
46 TAD69 NORTH BRADFORD CMHT FOR OLDER PEOPLE Y54 Q72 THACKLEY GRANGE NH TOWN LANE   BRADFORD WEST YORKSHIRE BD10 8LW 2002-04-01 00:00:00       0 D
47 TAD70 BINGLEY CMHT FOR OLDER PEOPLE Y54 Q72 LITTLELANDS COURT LITTLELANDS   BINGLEY WEST YORKSHIRE BD16 1RS 2002-04-01 00:00:00       0 D
48 TAD71 CRAVEN AREA CMHT FOR OLDER PEOPLE Y54 Q72 CASTLEBERGH HOSPITAL GIGGLESWICK   SETTLE NORTH YORKSHIRE BD24 0BN 2002-04-01 00:00:00       0 D
49 TAD72 DAISY HILL HOUSE Y54 Q72 LYNFIELD MOUNT HOSPITAL HEIGHTS LANE   BRADFORD WEST YORKSHIRE BD9 6DP 2002-04-01 00:00:00       0 D
50 TAD73 KEIGHLEY CMHT FOR OLDER PEOPLE Y54 Q72 FLORENCE NIGHTINGALE HOUSE AIREDALE GENERAL HOSPITAL SKIPTON ROAD, STEETON KEIGHLEY WEST YORKSHIRE BD20 6TD 2002-04-01 00:00:00       0 D
51 TAD74 SPRINGS MEDICAL CENTRE (OLD AGE PSYCHIATRY CLINIC) Y54 Q72 SPRINGS LANE     ILKLEY WEST YORKSHIRE LS29 8TH 2005-04-01 00:00:00       0 D
52 TAD75 SHIPLEY HOSPITAL (OLD AGE PSYCHIATRY CLINIC) Y54 Q72 (OLD AGE PSYCHIATRY CLINIC) 98 KIRKGATE   SHIPLEY WEST YORKSHIRE BD18 3LT 2005-04-01 00:00:00       0 D
53 TAD76 BINGLEY HEALTH CENTRE (OLD AGE PSYCHIATRY CLINIC) Y54 Q72 OL AGE PSYCHIATRY CLINIC MYRTLE PLACE   BINGLEY WEST YORKSHIRE BD16 2TL 2005-04-01 00:00:00       0 D
54 TAD77 LING HOUSE MEDICAL CENTRE (OLD AGE PSYCHIATRY CLINIC) Y54 Q72 49 SCOTT STREET     KEIGHLEY WEST YORKSHIRE BD21 2JH 2005-04-01 00:00:00       0 D
55 TAD78 DR GUPTA'S SURGERY (OLD AGE PSYCHIATRY CLINIC) Y54 Q72 3 AIREDALE ROAD     BRADFORD WEST YORKSHIRE BD3 0LR 2005-04-01 00:00:00       0 D
56 TAD79 UNITS 1, 3, 4, AND 6 (MERIDIAN HOUSE) Y54 Q72 MERIDIAN HOUSE BRADFORD ROAD   KEIGHLEY WEST YORKSHIRE BD21 4AJ 2006-04-01 00:00:00       0 D
57 TAD80 7 LEGRAMS TERRACE Y54 Q72 FIELDHEAD BUSINESS CENTRE     BRADFORD WEST YORKSHIRE BD7 1LN 2006-04-01 00:00:00       0 D
58 TAD81 LOW MOOR RESOURCE CENTRE Y54 Q72 COMMON ROAD LOW MOOR   BRADFORD WEST YORKSHIRE BD12 0SD 2006-04-01 00:00:00       0 D
59 TAD82 HOLYBROOK CENTRE Y54 Q72 REDCAR ROAD     BRADFORD WEST YORKSHIRE BD10 0DP 2006-04-01 00:00:00       0 D
60 TAD83 MERCURY QUAYS UNIT 9B Y54 Q72 ASHLEY LANE     SHIPLEY WEST YORKSHIRE BD17 7DB 2006-04-01 00:00:00       0 D
61 TAD84 MERCURY QUAYS UNIT 9F Y54 Q72 ASHLEY LANE     SHIPLEY WEST YORKSHIRE BD17 7DB 2006-04-01 00:00:00       0 D
62 TAD85 GENESIS 5 Y54 Q72 INNOVATION WAY HESLINGTON   YORK NORTH YORKSHIRE YO10 5DQ 2006-04-01 00:00:00       0 D
63 TAD86 REDHILLS Y54 Q72 VOLUNTARY ACTION CUMBRIA REDHILLS LANE REDHILLS PENRITH CUMBRIA CA11 0DT 2006-10-01 00:00:00       0 D
64 TAD88 ABBEYFIELD Y54 Q72 GROVE HOUSE 12 RIDDINGS ROAD   ILKLEY WEST YORKSHIRE LS29 9BF 2006-04-01 00:00:00       0 D
65 TAD89 CENTRAL LIBRARY Y54 Q72 SIGN POSTING SERVICE 1ST FLOOR PRINCES WAY   BRADFORD WEST YORKSHIRE BD1 1NN 2006-04-01 00:00:00       0 D
66 TAD90 IAN CLOUGH HALL Y54 Q72 HALL CLIFFE BAILDON   SHIPLEY WEST YORKSHIRE BD17 6ND 2006-10-01 00:00:00       0 D
67 TAD91 SHIPLEY RESOURCE CENTRE Y54 Q72 123 OTLEY ROAD     SHIPLEY WEST YORKSHIRE BD18 2LZ 2006-04-01 00:00:00       0 D
68 TAD92 PARK ROAD HEALTH CENTRE Y54 Q72 PARK ROAD     BRADFORD WEST YORKSHIRE BD5 0SG 2006-10-01 00:00:00       0 D
69 TAD93 KEIGHLEY RESOURCE CENTRE Y54 Q72 OXFORD STREET     KEIGHLEY WEST YORKSHIRE BD21 1RA 2006-04-01 00:00:00       0 D
70 TAD94 REEVY ROAD Y54 Q72 60 REEVY ROAD WEST     BRADFORD WEST YORKSHIRE BD6 3LH 2006-04-01 00:00:00       0 D
71 TAD95 RIX HOUSE Y54 Q72 24 ARNCLIFFE ROAD     KEIGHLEY WEST YORKSHIRE BD22 6AR 2006-04-01 00:00:00       0 D
72 TAD96 WEAVER COURT Y54 Q72 MOORFIELD PLACE     BRADFORD WEST YORKSHIRE BD10 9TL 2006-04-01 00:00:00       0 D
73 TAD97 OLD PARK ROAD Y54 Q72 51 OLD PARK ROAD     BRADFORD WEST YORKSHIRE BD10 9BG 2006-04-01 00:00:00       0 D
74 TAD98 NORTHFIELD ROAD Y54 Q72 2 NORTHFIELD ROAAD     BRADFORD WEST YORKSHIRE BD6 1RA 2006-10-01 00:00:00       0 D
75 TAD99 11 MOORCROFT DRIVE Y54 Q72 EAST BIERLEY     BRADFORD WEST YORKSHIRE BD4 6NJ 2006-10-01 00:00:00       0 D
76 TADA1 CROSS BANKS Y54 Q72 1 CROSS BANKS     SHIPLEY WEST YORKSHIRE BD18 3RW 2006-10-01 00:00:00       0 D
77 TADA3 AIREDALE FRESH START Y54 Q72 23 TEMPLE STREET     KEIGHLEY WEST YORKSHIRE BD21 2AD 2012-04-01 00:00:00       0 D
78 TADA4 WESTBOURNE GREEN (SCHOOL NURSING) Y54 Q72 WESTBOURNE GREEN MEDICAL CENTRE 50 HEATON ROAD   BRADFORD WEST YORKSHIRE BD8 8RA 2013-04-01 00:00:00       0 D
79 TADA5 THE RIDGE (SCHOOL NURSING) Y54 Q72 THE RIDGE MEDICAL CENTRE COUSEN ROAD   BRADFORD WEST YORKSHIRE BD7 3JX 2013-04-01 00:00:00       0 D
80 TADA6 KINGSWAY (SCHOOL NURSING) Y54 Q72 CANALSIDE HEALTH CARE CENTRE 2 KINGSWAY   BINGLEY WEST YORKSHIRE BD16 4RP 2013-04-01 00:00:00       0 D
81 TADA7 SHIPLEY HEALTH CENTRE (SCHOOL NURSING) Y54 Q72 ALEXANDRA ROAD     SHIPLEY WEST YORKSHIRE BD18 3EG 2013-04-01 00:00:00       0 D
82 TADA8 HAWORTH RD HEALTH CENTRE (SCHOOL NURSING) Y54 Q72 HAWORTH ROAD     BRADFORD WEST YORKSHIRE BD9 6LL 2013-04-01 00:00:00       0 D
83 TADA9 BARKEREND HEALTH CENTRE (SCHOOL NURSING) Y54 Q72 BARKEREND ROAD     BRADFORD WEST YORKSHIRE BD3 8QH 2013-04-01 00:00:00       0 D
84 TADC1 KEIGHLEY HEALTH CENTRE (SCHOOL NURSING) Y54 Q72 OAKWORTH ROAD     KEIGHLEY WEST YORKSHIRE BD21 1SA 2013-04-01 00:00:00       0 D
85 TADC2 HOLMEWOOD HEALTH CENTRE (SCHOOL NURSING) Y54 Q72 HOLME WOOD ROAD     BRADFORD WEST YORKSHIRE BD4 9EJ 2013-04-01 00:00:00       0 D
86 TADC3 BRADFORD SOUTH & WEST CMHT Y54 Q72 BRADFORD DISTRICT CARE TRUST 10-16 ST. MARTINS AVENUE FIELDHEAD BUSINESS CENTRE BRADFORD WEST YORKSHIRE BD7 1LG 2013-04-01 00:00:00       0 D
87 TADC4 CULTURE FUSION Y54 Q72 EARLY INTERVENTION SERVICE 125 THORNTON ROAD   BRADFORD WEST YORKSHIRE BD1 2EP 2013-04-01 00:00:00       0 D
88 TADC5 COMM MENTAL HEALTH (NTH3) Y54 Q72 BRADFORD DISTRICT CARE TRUST SOMERSET HOUSE   SHIPLEY WEST YORKSHIRE BD18 3BP 2013-04-01 00:00:00       0 D
89 TADC6 SAFE HAVEN Y54 Q72 CITY SUBSTANCE MISUSE SERVICE FOUNTAIN HALL FOUNTAIN STREET BRADFORD WEST YORKSHIRE BD1 3RA 2013-04-01 00:00:00       0 D
90 TADC7 CRAVEN IAPT MENTAL HEALTH Y54 Q72 DYNELEY HOUSE SURGERY NEWMARKET STREET   SKIPTON NORTH YORKSHIRE BD23 2HZ 2014-10-01 00:00:00       0 D
91 TADHQ BRADFORD DISTRICT CARE TRUST HQ Y54 Q72 NEW MILL VICTORIA ROAD   SHIPLEY WEST YORKSHIRE BD18 3LD 2003-10-01 00:00:00       0 D
92 TAE MANCHESTER MENTAL HEALTH AND SOCIAL CARE TRUST Y54 Q83 CHORLTON HOUSE 70 MANCHESTER ROAD CHORLTON CUM HARDY MANCHESTER GREATER MANCHESTER M21 9UN 2002-04-01 00:00:00 2016-12-31 00:00:00 T   0 B
93 TAE01 CENTRAL MANCHESTER SITE Y54 Q83 RAWNSLEY BUILDING MANCHESTER ROYAL INFIRMARY OXFORD ROAD MANCHESTER GREATER MANCHESTER M13 9WL 2002-04-01 00:00:00 2016-12-31 00:00:00     0 B
94 TAE02 SOUTH MANCHESTER SITE Y54 Q83 LAUREATE HOUSE WYTHENSHAWE HOSPITAL SOUTHMOOR ROAD MANCHESTER GREATER MANCHESTER M23 9LT 2002-04-01 00:00:00 2016-12-31 00:00:00     0 B
95 TAE03 NORTH MANCHESTER SITE Y54 Q83 PARK HOUSE DELAUNAYS ROAD   MANCHESTER GREATER MANCHESTER M8 5RB 2003-10-01 00:00:00 2016-12-31 00:00:00     0 B
96 TAE04 MANCHESTER MENTAL HEALTH & SOCIAL CARE TRUST HQ Y54 Q83 CHORLTON HOUSE 70 MANCHESTER ROAD CHORLTON CUM HARDY MANCHESTER GREATER MANCHESTER M21 9UN 2003-04-01 00:00:00 2016-12-31 00:00:00     0 B
97 TAE05 MMHSC TRUST Y54 Q83 CHORLTON HOUSE 70 MANCHESTER ROAD CHORLTON CUM HARDY MANCHESTER GREATER MANCHESTER M21 9UN 2004-04-01 00:00:00 2016-12-31 00:00:00     0 B
98 TAE10 GASKELL HOUSE Y54 Q83 SWINTON GROVE     MANCHESTER GREATER MANCHESTER M13 0EU 2003-10-01 00:00:00 2016-12-31 00:00:00     0 B
99 TAE11 ADMIRAL NURSING SERVICE Y54 Q83 6 CAMBRIAN STREET BESWICK   MANCHESTER GREATER MANCHESTER M11 3FY 2003-10-01 00:00:00 2016-12-31 00:00:00     0 B
100 TAE12 CLAYTON HELATH CENTRE Y54 Q83 89 NORTH ROAD     MANCHESTER GREATER MANCHESTER M11 4EJ 2003-10-01 00:00:00 2016-12-31 00:00:00     0 B

Next page

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