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.

8 rows where click4more = 338

✎ View and edit SQL

This data as json, CSV (advanced)

rowid ▼ Supplier Sum ICB NHS4Sale VT VTUK HSSF click4more
10 OUTSIDE CLINIC LTD 2377397.07 Banes         338
614 OUTSIDE CLINIC LTD 387650.15 Bristol         338
765 OUTSIDE CLINIC LTD 159474.00 Buck         338
1277 OUTSIDE CLINIC LTD 150357.55 Coventry         338
1431 OUTSIDE CLINIC LTD 83683.57 Derby         338
1560 OUTSIDE CLINIC LTD 59377.00 Devon         338
2720 OUTSIDE CLINIC LTD 88486.84 Hants         338
3715 OUTSIDE CLINIC LTD 28124.00 Lincoln         338

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])
);