home / nhsadmin

Non-NHS Organisations

Data source: OUseful Databeat

13,909 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 Contact Telephone Number Amended Record Indicator
1 8A001 JORDAN HILL NH Y54 Q72 37 GAWBER ROAD     BARNSLEY SOUTH YORKSHIRE S75 2AN 1996-04-01 00:00:00   R   0
2 8A003 THE GROVE NH Y54 Q72 THURNSCOE BRIDGE LANE THURNSCOE   ROTHERHAM SOUTH YORKSHIRE S63 0SN 1996-04-01 00:00:00   R   0
3 8A005 THURNSCOE HALL NH Y54 Q72 HIGH STREET THURNSCOE   ROTHERHAM SOUTH YORKSHIRE S63 0ST 1996-04-01 00:00:00   R   0
4 8A006 SHAFTESBURY HOUSE NH Y54 Q72 53 MOUNT VERNON ROAD     BARNSLEY SOUTH YORKSHIRE S70 4DJ 1996-04-01 00:00:00   R   0
5 8A007 DEARNE VALLEY NH Y54 Q72 FURLONG ROAD GOLDTHORPE   ROTHERHAM SOUTH YORKSHIRE S63 9PY 1996-04-01 00:00:00   R   0
6 8A008 VALLEY PARK NH Y54 Q72 PARK STREET WOMBWELL   BARNSLEY SOUTH YORKSHIRE S73 0DJ 1996-04-01 00:00:00   R   0
7 8A009 ROCKLEY DENE NH Y54 Q72 PARK ROAD WORSBROUGH   BARNSLEY SOUTH YORKSHIRE S70 5AD 1996-04-01 00:00:00   R   0
8 8A010 PARK GRANGE NH Y54 Q72 NEVILLE AVENUE     BARNSLEY SOUTH YORKSHIRE S70 3HF 1996-04-01 00:00:00   N   0
9 8A011 BOLTON HALL NH Y54 Q72 CARR HEAD LANE BOLTON-UPON-DEARNE   ROTHERHAM SOUTH YORKSHIRE S63 8DA 1996-04-01 00:00:00   R   0
10 8A012 PARKLANDS NH Y54 Q72 PARK STREET WOMBWELL   BARNSLEY SOUTH YORKSHIRE S73 0HQ 1996-04-01 00:00:00   R   0
11 8A013 PROSPECT HOUSE NH (BARNSLEY) Y54 Q72 PROSPECT STREET CUDWORTH   BARNSLEY SOUTH YORKSHIRE S72 8JS 1996-04-01 00:00:00   N   0
12 8A014 DEANSGATE NH Y54 Q72 TOWNGATE MAPPLEWELL   BARNSLEY SOUTH YORKSHIRE S75 6AS 1996-04-01 00:00:00   R   0
13 8A016 HALL STEADS NH Y54 Q72 STACEY CRESCENT GRIMETHORPE   BARNSLEY SOUTH YORKSHIRE S72 7DP 1996-04-01 00:00:00   R   0
14 8A017 CHAPEL VIEW Y54 Q72 SPARK LANE NAPPLEWELL   BARNSLEY SOUTH YORKSHIRE S75 6BN 1996-04-01 00:00:00   R   0
15 8A018 HOYLAND HALL Y54 Q72 MARKET STREET HOYLAND   BARNSLEY SOUTH YORKSHIRE S74 0EX 1996-04-01 00:00:00   R   0
16 8A019 CHERRY TREES NH (BARNSLEY) Y54 Q72 CHERRYS ROAD CUNDY CROSS   BARNSLEY SOUTH YORKSHIRE S71 5QU 1996-04-01 00:00:00   R   0
17 8A020 PARKSIDE Y54 Q72 PARK STREET WOMBWELL   BARNSLEY SOUTH YORKSHIRE S73 0HQ 1996-04-01 00:00:00   N   0
18 8A022 WENSLEY PARK NH Y54 Q72 WENSLEY ROAD NEW LODGE   BARNSLEY SOUTH YORKSHIRE S71 1TJ 1996-04-01 00:00:00   R   0
19 8A023 GALTEE MORE NH Y54 Q72 164 DONCASTER ROAD     BARNSLEY SOUTH YORKSHIRE S70 1UD 1996-04-01 00:00:00   R   0
20 8A024 THE CONIFERS NH Y54 Q72 75 BRAMPTON ROAD WOMBWELL   BARNSLEY SOUTH YORKSHIRE S73 0SS 1996-04-01 00:00:00   R   0
21 8A025 SAXONDALE NH Y54 Q72 CLARKE STREET     BARNSLEY SOUTH YORKSHIRE S75 2TS 1996-04-01 00:00:00   R   0
22 8A027 HAVENFIELD LODGE Y54 Q72 HIGHFIELD ROAD DARFIELD   BARNSLEY SOUTH YORKSHIRE S73 9AY 1996-04-01 00:00:00   R   0
23 8A029 CHERRY TREE EMI UNIT Y54 Q72 CHERRYS ROAD CUNDY CROSS   BARNSLEY SOUTH YORKSHIRE S71 5QU 1996-04-01 00:00:00   R   0
24 8A030 ROYAL COURT NH Y54 Q72 KING STREET HOYLAND   BARNSLEY SOUTH YORKSHIRE S74 9LB 1996-04-01 00:00:00   R   0
25 8A032 BENNFIELD HOUSE NH Y54 Q72 65 KING EDWARD ROAD THORNE   DONCASTER SOUTH YORKSHIRE DN8 4DE 1996-04-01 00:00:00   R   0
26 8A034 JUBILEE HOUSE NH (DONCASTER) Y54 Q72 48 CHURCH ROAD BARNBY DUN   DONCASTER SOUTH YORKSHIRE DN3 1BB 1996-04-01 00:00:00   R   0
27 8A035 OAKLANDS LODGE NH Y54 Q72 82 BAWTRY ROAD BESSACARR   DONCASTER SOUTH YORKSHIRE DN4 7BQ 1996-04-01 00:00:00   R   0
28 8A036 THE OLD RECTORY NH (DONCASTER) Y54 Q72 CHURCH STREET ARMTHORPE   DONCASTER SOUTH YORKSHIRE DN3 3AD 1996-04-01 00:00:00   R   0
29 8A038 SUE RYDER FOUNDATION (DONCASTER) Y54 Q72 HICKLETON HALL HICKLETON   DONCASTER SOUTH YORKSHIRE DN5 7BB 1996-04-01 00:00:00   R   0
30 8A039 ST MARY'S NH (DONCASTER) Y54 Q72 101 THORNE ROAD     DONCASTER SOUTH YORKSHIRE DN1 2JT 1996-04-01 00:00:00   R   0
31 8A040 PARKLANDS NH Y54 Q72 26 ELLISON STREET THORNE   DONCASTER SOUTH YORKSHIRE DN8 5LD 1996-04-01 00:00:00   R   0
32 8A042 ST MARY'S LODGE Y54 Q72 99-101 THORNE ROAD     DONCASTER SOUTH YORKSHIRE DN1 2JT 1996-04-01 00:00:00   R   0
33 8A044 AMETHYST HOUSE Y54 Q72 OLD RECTORY, SHEEPBRIDGE LANE OLD ROSSINGTON   DONCASTER SOUTH YORKSHIRE DN11 0EZ 1996-04-01 00:00:00   R   0
34 8A045 ERNELESTHORE MANOR NH Y54 Q72 COW HOUSE LANE ARMTHORPE   DONCASTER SOUTH YORKSHIRE DN3 3EE 1996-04-01 00:00:00   R   0
35 8A046 THE CEDARS CARE HOME Y54 Q72 CEDAR ROAD BALBY   DONCASTER SOUTH YORKSHIRE DN4 9HU 1996-04-01 00:00:00   R   0
36 8A047 CHAPEL GARTH Y54 Q72 CENTRAL AVENUE BENTLEY   DONCASTER SOUTH YORKSHIRE DN5 0AR 1996-04-01 00:00:00   R   0
37 8A048 EASTFIELD NURSING HOME (DONCASTER) Y54 Q72 MOSS ROAD ASKERN   DONCASTER SOUTH YORKSHIRE DN6 0JZ 1996-04-01 00:00:00   R   0
38 8A049 BENTON HOUSE NH Y54 Q72 GATTISON LANE ROSSINGTON   DONCASTER SOUTH YORKSHIRE DN11 0NQ 1996-04-01 00:00:00   R   0
39 8A050 NIGHTINGALE NH Y54 Q72 5 AVENUE ROAD     DONCASTER SOUTH YORKSHIRE DN2 4AH 1996-04-01 00:00:00   R   0
40 8A051 CEDARS LODGE Y54 Q72 CEDAR ROAD BALBY   DONCASTER SOUTH YORKSHIRE DN4 9HU 1996-04-01 00:00:00   R   0
41 8A052 EARLSTHORPE LODGE Y54 Q72 COW HOUSE LANE     DONCASTER SOUTH YORKSHIRE DN3 3EE 1996-04-01 00:00:00   R   0
42 8A053 THE LAURELS NH (DONCASTER) Y54 Q72 HIGH STREET NORTON   DONCASTER SOUTH YORKSHIRE DN6 9EU 1996-04-01 00:00:00   R   0
43 8A054 WARNFORD HOUSE NH Y54 Q72 TENTER BALK LANE ADWICK-LE-STREET   DONCASTER SOUTH YORKSHIRE DN6 7EE 1996-04-01 00:00:00   R   0
44 8A056 SWALLOW WOOD CHRISTIAN NH Y54 Q72 WATH ROAD     MEXBOROUGH SOUTH YORKSHIRE S64 9RQ 1996-04-01 00:00:00   R   0
45 8A059 MANOR VIEW NH Y54 Q72 19 MANOR ROAD HATFIELD   DONCASTER SOUTH YORKSHIRE DN7 6SA 1996-04-01 00:00:00   R   0
46 8A060 HIGHGROVE NH Y54 Q72 WEST ROAD     MEXBOROUGH SOUTH YORKSHIRE S64 9NL 1996-04-01 00:00:00   R   0
47 8A061 DR ANDERSON LODGE Y54 Q72 EAST LANE STAINFORTH   DONCASTER SOUTH YORKSHIRE DN7 5DY 1996-04-01 00:00:00   R   0
48 8A063 FLOWER PARK NH Y54 Q72 ROSSINGTON STREET DENABY MAIN   DONCASTER SOUTH YORKSHIRE DN12 4TA 1996-04-01 00:00:00   R   0
49 8A065 CHINA COTTAGE Y54 Q72 154 OWSTON ROAD CARCROFT   DONCASTER SOUTH YORKSHIRE DN6 8EA 1996-04-01 00:00:00   R   0
50 8A066 EDLINGTON PARK Y54 Q72 HEADINGLEY WAY EDLINGTON   DONCASTER SOUTH YORKSHIRE DN12 1SB 1996-04-01 00:00:00   N   0
51 8A068 MELTON COURT CARE CENTRE Y54 Q72 62 BLYTH ROAD MALTBY   ROTHERHAM SOUTH YORKSHIRE S66 7LF 1996-04-01 00:00:00   R   0
52 8A070 WEST MELTON LODGE PRIVATE NH Y54 Q72 2 BRAMPTON ROAD WEST MELTON   ROTHERHAM SOUTH YORKSHIRE S63 6AW 1996-04-01 00:00:00   R   0
53 8A072 GRENO HOUSE NH Y54 Q72 64 FITZWILLIAM STREET SWINTON   MEXBOROUGH SOUTH YORKSHIRE S64 8RN 1996-04-01 00:00:00   R   0
54 8A073 WESTFIELD HOUSE Y54 Q72 WESTFIELD ROAD PARKGATE   ROTHERHAM SOUTH YORKSHIRE S62 6EY 1996-04-01 00:00:00   R   0
55 8A074 SWALLOWNEST CARE CENTRE Y54 Q72 CHESTERFIELD ROAD SWALLOWNEST   SHEFFIELD SOUTH YORKSHIRE S26 4TL 1996-04-01 00:00:00   R   0
56 8A075 MEADOWVIEW NH Y54 Q72 RANDERSON DRIVE HIGHTHORNE KILNHURST ROTHERHAM SOUTH YORKSHIRE S62 5UW 1996-04-01 00:00:00   R   0
57 8A076 SWINTON LODGE NH Y55 Q78 WORTLEY AVENUE SWINTON   MEXBOROUGH SOUTH YORKSHIRE SG4 8PT 1996-04-01 00:00:00   R   0
58 8A077 ALEXANDRA NH (ROTHERHAM) Y54 Q72 DONCASTER ROAD THRYBERGH   ROTHERHAM SOUTH YORKSHIRE S65 4AD 1996-04-01 00:00:00   R   0
59 8A079 TODWICK NH Y54 Q72 160 KIVETON LANE TODWICK   SHEFFIELD SOUTH YORKSHIRE S26 1DL 1996-04-01 00:00:00   R   0
60 8A081 ROCKINGHAM HOUSE NH Y54 Q72 ST. ANNS ROAD     ROTHERHAM SOUTH YORKSHIRE S65 1RQ 1996-04-01 00:00:00   R   0
61 8A083 BROOM LANE NH Y54 Q72 174 BROOM LANE     ROTHERHAM SOUTH YORKSHIRE S60 3NW 1996-04-01 00:00:00   R   0
62 8A084 CAMBRON HOUSE NH Y54 Q72 3 FLANDERWELL LANE BRAMLEY   ROTHERHAM SOUTH YORKSHIRE S66 3QL 1996-04-01 00:00:00   R   0
63 8A085 ABBEYHILL NH Y54 Q72 HIGH STREET RAWMARSH   ROTHERHAM SOUTH YORKSHIRE S62 6LT 1996-04-01 00:00:00   R   0
64 8A086 LAUREATE COURT MENTAL NH Y54 Q72 WELLGATE     ROTHERHAM SOUTH YORKSHIRE S60 2NX 1996-04-01 00:00:00   R   0
65 8A088 JOHN STREET MENTAL NH Y54 Q72 6 JOHN STREET THURCROFT   ROTHERHAM SOUTH YORKSHIRE S66 9HJ 1996-04-01 00:00:00   R   0
66 8A089 LADYFIELD NH Y54 Q72 LADYFIELD ROAD KIVETON PARK STATION   SHEFFIELD SOUTH YORKSHIRE S26 6NR 1996-04-01 00:00:00   R   0
67 8A090 LEA GREEN COURT NH Y54 Q74 LEAGREEN COURT     NEWCASTLE UPON TYNE TYNE AND WEAR NE3 3UW 1996-04-01 00:00:00   R   0
68 8A093 BROOMGROVE CONVALESCENT HOME Y54 Q72 30 BROOMGROVE ROAD     SHEFFIELD SOUTH YORKSHIRE S10 2LR 1996-04-01 00:00:00   R   0
69 8A094 CLAREMONT NH (SHEFFIELD) Y54 Q72 401 SANDYGATE ROAD     SHEFFIELD SOUTH YORKSHIRE S10 5UB 1996-04-01 00:00:00   R   0
70 8A095 GLEN NH Y54 Q72 224 ABBEYDALE ROAD SOUTH DORE   SHEFFIELD SOUTH YORKSHIRE S17 3LA 1996-04-01 00:00:00   R   0
71 8A096 LEONARD CHESHIRE FOUNDATION (TOTLEY) Y55 Q76 MICKLEY HALL MICKLEY LANE   SHEFFIELD SOUTH YORKSHIRE S17 4HE 1996-04-01 00:00:00   R   0
72 8A097 NETHERBY GRANGE NH Y54 Q72 27 DORE ROAD     SHEFFIELD SOUTH YORKSHIRE S17 3NA 1996-04-01 00:00:00   R   0
73 8A101 ST LUKE'S HOSPICE (SHEFFIELD) Y54 Q72 LITTLE COMMON LANE     SHEFFIELD SOUTH YORKSHIRE S11 9NE 1996-04-01 00:00:00   R   0
74 8A102 SHARROW HEAD NH Y54 Q72 364 SHARROW LANE     SHEFFIELD SOUTH YORKSHIRE S11 8AU 1996-04-01 00:00:00   R   0
75 8A103 HOLT TIM (DR) Y54 Q72 DALE END SURGERY DANBY   WHITBY NORTH YORKSHIRE YO21 2JE 1996-04-01 00:00:00   N   0
76 8A105 ST ANDREWS NH (SHEFFIELD) Y54 Q72 44-46 KENWOOD ROAD     SHEFFIELD SOUTH YORKSHIRE S7 1NQ 1996-04-01 00:00:00   R   0
77 8A107 KERSAL MOUNT NH Y54 Q72 115 MANCHESTER ROAD     SHEFFIELD SOUTH YORKSHIRE S10 5DN 1996-04-01 00:00:00   R   0
78 8A108 ABBEY GRANGE NH (SHEFFIELD) Y54 Q72 CAMMELL ROAD     SHEFFIELD SOUTH YORKSHIRE S5 6UU 1996-04-01 00:00:00   R   0
79 8A109 BALMORAL CLINIC Y54 Q72 6 BEIGHTON ROAD WOODHOUSE   SHEFFIELD SOUTH YORKSHIRE S13 7PR 1996-04-01 00:00:00   R   0
80 8A111 RIVERDALE NH Y54 Q72 379A FULWOOD ROAD     SHEFFIELD SOUTH YORKSHIRE S10 3GA 1996-04-01 00:00:00   R   0
81 8A112 WESTBOURNE HOUSE NH (SHEFFIELD) Y54 Q72 379 EARL MARSHAL ROAD     SHEFFIELD SOUTH YORKSHIRE S4 8FA 1996-04-01 00:00:00   R   0
82 8A113 ANCHOR HOUSING ASSOCIATION (SHEFFIELD) Y54 Q72 EAGLE HOUSE 43 STALKER LEES ROAD   SHEFFIELD SOUTH YORKSHIRE S11 8NP 1996-04-01 00:00:00   R   0
83 8A115 JASMIN COURT NH Y54 Q72 40 ROE LANE     SHEFFIELD SOUTH YORKSHIRE S3 9AJ 1996-04-01 00:00:00   R   0
84 8A116 NORTHFIELD NH Y54 Q72 2A ROEBUCK ROAD     SHEFFIELD SOUTH YORKSHIRE S6 3GP 1996-04-01 00:00:00   R   0
85 8A118 WOODLAND VIEW NH Y55 Q76 1 LIGHTWOOD LANE     SHEFFIELD SOUTH YORKSHIRE S8 8BG 1996-04-01 00:00:00   R   0
86 8A119 LITTLEDALE NH Y54 Q72 669 PRINCE OF WALES ROAD     SHEFFIELD SOUTH YORKSHIRE S9 4ES 1996-04-01 00:00:00   R   0
87 8A120 SANDILEIGH NH Y54 Q72 90 TAPTON CRESCENT ROAD     SHEFFIELD SOUTH YORKSHIRE S10 5DD 1996-04-01 00:00:00   R   0
88 8A121 NEWFIELD NH Y54 Q72 1 CAT LANE     SHEFFIELD SOUTH YORKSHIRE S2 3AY 1996-04-01 00:00:00   R   0
89 8A122 HUNTER A M (DR) Y54 Q72 4 ST. MARYS     YORK NORTH YORKSHIRE YO30 7DD 1996-04-01 00:00:00   N   0
90 8A123 ST CATHERINES NH Y54 Q72 150-152 BURNGREAVE ROAD     SHEFFIELD SOUTH YORKSHIRE S3 9DH 1996-04-01 00:00:00   R   0
91 8A124 LISTER J Y54 Q72 24 TWENTYWELL LANE     SHEFFIELD SOUTH YORKSHIRE S17 4QD 1996-04-01 00:00:00   R   0
92 8A126 ALEXANDER COURT NH (SHEFFIELD) Y54 Q72 2 LYDGATE COURT     SHEFFIELD SOUTH YORKSHIRE S10 5FJ 1996-04-01 00:00:00   R   0
93 8A127 BELMONT HOUSE NH Y54 Q72 BELMONT DRIVE STOCKSBRIDGE   SHEFFIELD SOUTH YORKSHIRE S36 1AH 1996-04-01 00:00:00   R   0
94 8A128 HADDON COURT NH Y54 Q72 HIGH STREET BEIGHTON   SHEFFIELD SOUTH YORKSHIRE S20 1HE 1996-04-01 00:00:00   R   0
95 8A130 HAZELDENE NH (SHEFFIELD) Y54 Q72 84 POOLE ROAD     SHEFFIELD SOUTH YORKSHIRE S9 4JQ 1996-04-01 00:00:00   R   0
96 8A131 MORRFIELDS NH Y54 Q72 34 COMMONSIDE     SHEFFIELD SOUTH YORKSHIRE S10 1GE 1996-04-01 00:00:00   R   0
97 8A132 SCARSDALE GRANGE NH Y54 Q72 139 DERBYSHIRE LANE     SHEFFIELD SOUTH YORKSHIRE S8 9EQ 1996-04-01 00:00:00   R   0
98 8A133 TAPTON COURT NH Y54 Q72 63 TAPTON CRESCENT ROAD     SHEFFIELD SOUTH YORKSHIRE S10 5DB 1996-04-01 00:00:00   R   0
99 8A134 WARREN PARK NH Y54 Q72 WHITE LANE CHAPELTOWN   SHEFFIELD SOUTH YORKSHIRE S35 2YH 1996-04-01 00:00:00   R   0
100 8A137 DEBDALE SPECIALIST CARE LTD Y55 Q76 THISTLE HILL HALL DEBDALE LANE   MANSFIELD WOODHOUSE NOTTINGHAMSHIRE NG19 7EZ 1996-04-01 00:00:00   R   0

Next page

CREATE TABLE "enonnhs" (
"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
)
Powered by Datasette · Query took 91.642ms · Data source: OUseful Databeat