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.

10 rows where click4more = 238

✎ View and edit SQL

This data as json, CSV (advanced)

rowid ▼ Supplier Sum ICB NHS4Sale VT VTUK HSSF click4more
206 REDCENTRIC SOLUTIONS LTD -40792.32 Bedford         238
226 REDCENTRIC SOLUTIONS LTD 1768274.00 Bham         238
417 REDCENTRIC SOLUTIONS LTD 520022.52 Black         238
863 REDCENTRIC SOLUTIONS LTD -23249.88 Cambs         238
2841 REDCENTRIC SOLUTIONS LTD 123120.00 Hereford         238
2891 REDCENTRIC SOLUTIONS LTD 859706.88 Herts         238
3979 REDCENTRIC SOLUTIONS LTD 68879.97 NCLon         238
5223 REDCENTRIC SOLUTIONS LTD 332695.38 Shrop         238
6073 REDCENTRIC SOLUTIONS LTD 421599.80 SYorks         238
6294 REDCENTRIC SOLUTIONS LTD 888791.80 WYorks         238

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