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.

15 rows where click4more = 27

✎ View and edit SQL

This data as json, CSV (advanced)

rowid ▼ Supplier Sum ICB NHS4Sale VT VTUK HSSF click4more
213 OPTEGRA UK LTD 4070479.61 Bham         27
386 OPTEGRA UK LTD 1793331.85 Black         27
898 OPTEGRA UK LTD 1302931.08 C&M         27
1384 OPTEGRA UK LTD 488427.14 Derby         27
1717 OPTEGRA UK LTD 727925.57 Frim         27
2246 OPTEGRA UK LTD 14459015.25 GMcr         27
2561 OPTEGRA UK LTD 4125979.34 Hants         27
3243 OPTEGRA UK LTD 591007.61 Kent         27
3877 OPTEGRA UK LTD 1869106.42 NCLon         27
4455 OPTEGRA UK LTD 33129.03 NELon         27
4824 OPTEGRA UK LTD 1306528.67 NWLon         27
5413 OPTEGRA UK LTD 29760.55 Staff         27
5523 OPTEGRA UK LTD 2460465.47 Susx         27
5888 OPTEGRA UK LTD 2095612.43 SyHrt         27
6247 OPTEGRA UK LTD 3829794.56 WYorks         27

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