all

Along with the standard search boxes, you can focus on an ICB by pressing the tool icon at the top of the ICB column, then press 'Facet by this'.

For info on the parent company, or on any fields marked '+', press the entry in the click4more column, then follow any links.

18 rows where click4more = 141

✎ View and edit SQL

This data as json, CSV (advanced)

rowid ▼ Supplier Sum ICB NHS4Sale VT VTUK HSSF click4more
770 BARCHESTER HEALTHCARE HOMES LTD 125925.43 Buck         141
1065 BARCHESTER HEALTHCARE HOMES LTD 49425.04 C&M         141
1439 BARCHESTER HEALTHCARE HOMES LTD 62681.19 Derby         141
1544 BARCHESTER HEALTHCARE HOMES LTD 115200.00 Devon         141
2444 BARCHESTER HEALTHCARE HOMES LTD 92834.35 GMcr         141
2568 BARCHESTER HEALTHCARE HOMES LTD 2943783.32 Hants         141
3047 BARCHESTER HEALTHCARE HOMES LTD 1296517.43 Humber         141
3325 BARCHESTER HEALTHCARE HOMES LTD 126154.10 Kent         141
3587 BARCHESTER HEALTHCARE HOMES LTD -88320.00 Lancs         141
3843 BARCHESTER HEALTHCARE HOMES LTD 35004.91 MSEsx         141
3968 BARCHESTER HEALTHCARE HOMES LTD 93494.72 NCLon         141
4045 BARCHESTER HEALTHCARE HOMES LTD 2694869.41 NE&Cumb         141
4471 BARCHESTER HEALTHCARE HOMES LTD -85272.00 NELon         141
4512 BARCHESTER HEALTHCARE HOMES LTD 231774.48 Nhamp         141
4772 BARCHESTER HEALTHCARE HOMES LTD 54499.93 Nott         141
4926 BARCHESTER HEALTHCARE HOMES LTD 74724.63 NWLon         141
5171 BARCHESTER HEALTHCARE HOMES LTD 30356.57 SELon         141
5502 BARCHESTER HEALTHCARE HOMES LTD 29717.43 Suffolk         141

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "all" (
   [rowid] INTEGER PRIMARY KEY,
   [Supplier] TEXT,
   [Sum] TEXT,
   [ICB] TEXT,
   [NHS4Sale] TEXT,
   [VT] TEXT,
   [VTUK] TEXT,
   [HSSF] TEXT,
   [click4more] TEXT REFERENCES [supp]([ID])
);