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.

9 rows where click4more = 1218

✎ View and edit SQL

This data as json, CSV (advanced)

rowid ▼ Supplier Sum ICB NHS4Sale VT VTUK HSSF click4more
318 DATIX LTD 69548.95 Bham       + 1218
1079 DATIX LTD 37986.30 C&M       + 1218
1327 DATIX LTD 25663.57 Coventry       + 1218
1450 DATIX LTD 42746.76 Derby       + 1218
2460 DATIX LTD 72557.69 GMcr       + 1218
3018 DATIX LTD 25089.31 Herts       + 1218
4417 DATIX LTD 62307.60 NELon       + 1218
5122 DATIX LTD 83431.84 SELon       + 1218
6425 DATIX LTD 58169.71 WYorks       + 1218

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