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.

16 rows where click4more = 143

✎ View and edit SQL

This data as json, CSV (advanced)

rowid ▼ Supplier Sum ICB NHS4Sale VT VTUK HSSF click4more
146 FIRST DATABANK UK LTD 221667.07 Bedford         143
394 FIRST DATABANK UK LTD 1086536.88 Black         143
905 FIRST DATABANK UK LTD 1026866.74 C&M         143
1250 FIRST DATABANK UK LTD 383010.12 Coventry         143
1393 FIRST DATABANK UK LTD 394346.16 Derby         143
1739 FIRST DATABANK UK LTD 296263.08 Frim         143
1859 FIRST DATABANK UK LTD 210024.00 Glos         143
2397 FIRST DATABANK UK LTD 239409.06 GMcr         143
2629 FIRST DATABANK UK LTD 634098.12 Hants         143
4123 FIRST DATABANK UK LTD 219367.68 NE&Cumb         143
4502 FIRST DATABANK UK LTD 297767.03 Nhamp         143
4725 FIRST DATABANK UK LTD 385849.76 Nott         143
4841 FIRST DATABANK UK LTD 861064.37 NWLon         143
5387 FIRST DATABANK UK LTD 447903.35 Staff         143
5550 FIRST DATABANK UK LTD 627279.12 Susx         143
6068 FIRST DATABANK UK LTD 454052.14 SYorks         143

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