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.

8 rows where click4more = 522

✎ View and edit SQL

This data as json, CSV (advanced)

rowid ▼ Supplier Sum ICB NHS4Sale VT VTUK HSSF click4more
3132 ADVANTAGE HEALTHCARE LTD 59397.50 Humber         522
3270 ADVANTAGE HEALTHCARE LTD 377241.38 Kent         522
3906 ADVANTAGE HEALTHCARE LTD 671728.05 NCLon         522
4187 ADVANTAGE HEALTHCARE LTD 78416.64 NE&Cumb         522
4871 ADVANTAGE HEALTHCARE LTD 341316.64 NWLon         522
5079 ADVANTAGE HEALTHCARE LTD 227303.39 SELon         522
5284 ADVANTAGE HEALTHCARE LTD 25077.85 Shrop         522
5814 ADVANTAGE HEALTHCARE LTD 46342.50 SWLon         522

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