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.

23 rows where click4more = 695

✎ View and edit SQL

This data as json, CSV (advanced)

rowid ▼ Supplier Sum ICB NHS4Sale VT VTUK HSSF click4more
91 PRESCQIPP CIC 27267.60 Banes         695
339 PRESCQIPP CIC 43022.40 Bham         695
674 PRESCQIPP CIC 29349.60 Bristol         695
773 PRESCQIPP CIC 109457.00 Buck         695
851 PRESCQIPP CIC 112282.80 Cambs         695
1317 PRESCQIPP CIC 29222.40 Coventry         695
1463 PRESCQIPP CIC 30722.40 Derby         695
1569 PRESCQIPP CIC 35002.80 Devon         695
1968 PRESCQIPP CIC 18774.00 Glos         695
2472 PRESCQIPP CIC 58910.40 GMcr         695
2748 PRESCQIPP CIC 52449.60 Hants         695
2983 PRESCQIPP CIC 54653.00 Herts         695
3367 PRESCQIPP CIC 44775.00 Kent         695
3555 PRESCQIPP CIC 49636.80 Lancs         695
4383 PRESCQIPP CIC 126224.40 NELon         695
4642 PRESCQIPP CIC 51822.00 Norfolk         695
4788 PRESCQIPP CIC 34195.20 Nott         695
5142 PRESCQIPP CIC 55880.40 SELon         695
5416 PRESCQIPP CIC 26956.00 Staff         695
5496 PRESCQIPP CIC 33931.20 Suffolk         695
5628 PRESCQIPP CIC 49750.80 Susx         695
6173 PRESCQIPP CIC 40588.80 SYorks         695
6416 PRESCQIPP CIC 69586.80 WYorks         695

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