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

✎ View and edit SQL

This data as json, CSV (advanced)

rowid ▼ Supplier Sum ICB NHS4Sale VT VTUK HSSF click4more
87 PSYCHIATRY UK LLP 28182.92 Banes         244
121 PSYCHIATRY UK LLP 531667.92 Bedford         244
591 PSYCHIATRY UK LLP 1150392.50 Bristol         244
903 PSYCHIATRY UK LLP 1058500.32 C&M         244
1290 PSYCHIATRY UK LLP 54745.02 Coventry         244
1467 PSYCHIATRY UK LLP 25260.15 Derby         244
1576 PSYCHIATRY UK LLP 27715.56 Devon         244
1853 PSYCHIATRY UK LLP 233637.00 Glos         244
3333 PSYCHIATRY UK LLP 105397.60 Kent         244
3805 PSYCHIATRY UK LLP 109076.34 MSEsx         244
4162 PSYCHIATRY UK LLP 121351.58 NE&Cumb         244
4670 PSYCHIATRY UK LLP 25960.46 Norfolk         244
4854 PSYCHIATRY UK LLP 547791.30 NWLon         244
5589 PSYCHIATRY UK LLP 190001.06 Susx         244
6007 PSYCHIATRY UK LLP 25412.53 SyHrt         244
6066 PSYCHIATRY UK LLP 484737.86 SYorks         244

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