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.

9 rows where click4more = 103

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Supplier

rowid ▼ Supplier Sum ICB NHS4Sale VT VTUK HSSF click4more
275 ROSS AUTO ENGINEERING LTD 306943.50 Bham         103
1173 Ross Auto Engineering Ltd 305212.92 Cornwall         103
2295 ROSS AUTO ENGINEERING LTD 981986.52 GMcr         103
2683 ROSS AUTO ENGINEERING LTD 260758.80 Hants         103
3220 ROSS AUTO ENGINEERING LTD 997736.43 Kent         103
4704 ROSS AUTO ENGINEERING LTD 760548.87 Nott         103
5527 ROSS AUTO ENGINEERING LTD 1897186.63 Susx         103
5886 ROSS AUTO ENGINEERING LTD 2430453.86 SyHrt         103
6268 ROSS AUTO ENGINEERING LTD 1911600.27 WYorks         103

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