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 = 330

✎ View and edit SQL

This data as json, CSV (advanced)

rowid ▼ Supplier Sum ICB NHS4Sale VT VTUK HSSF click4more
937 CARNALL FARRAR LTD 386521.67 C&M       + 330
1519 CARNALL FARRAR LTD 429433.92 Devon       + 330
2432 CARNALL FARRAR LTD 117000.00 GMcr       + 330
2631 CARNALL FARRAR LTD 624028.80 Hants       + 330
3895 CARNALL FARRAR LTD 934928.00 NCLon       + 330
4113 CARNALL FARRAR LTD 274606.80 NE&Cumb       + 330
4420 CARNALL FARRAR LTD 61729.73 NELon       + 330
4767 CARNALL FARRAR LTD 66600.00 Nott       + 330
5598 CARNALL FARRAR LTD 138390.00 Susx       + 330
5920 CARNALL FARRAR LTD 444000.00 SyHrt       + 330

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