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.

12 rows where click4more = 108

✎ View and edit SQL

This data as json, CSV (advanced)

rowid ▼ Supplier Sum ICB NHS4Sale VT VTUK HSSF click4more
110 HC ONE LTD 1234589.60 Bedford         108
446 HC ONE LTD 206330.27 Black         108
916 HC ONE LTD 740677.39 C&M         108
2027 HC ONE LTD 6210.71 Glos         108
2259 HC ONE LTD 4837779.56 GMcr         108
3173 HC ONE LTD 3392.88 Humber         108
4247 HC ONE LTD 26373.70 NE&Cumb         108
4706 HC ONE LTD 675501.98 Nott         108
4931 HC ONE LTD 62057.83 NWLon         108
5024 HC ONE LTD 1202397.39 SELon         108
6128 HC ONE LTD 111221.57 SYorks         108
6348 HC ONE LTD 311142.73 WYorks         108

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