all

Along with the standard search boxes, you can focus on a Trust or FT by pressing the tool icon at the top of the Trust column, then press 'Facet by this'.

If a row contains at least one '+' press the entry in the click4more column, then follow the links.

5 rows where Supplier = "ALLOGA UK LTD"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: ICB

rowid ▼ Supplier Sum Trust ICB NHS4Sale VT VTUK HSSF click4more
181 ALLOGA UK LTD 1121983.19 StHelKnowsley C&M         31
2217 ALLOGA UK LTD 4970107.98 Barts NELon         31
2572 ALLOGA UK LTD 144000.00 Homerton NELon         31
2733 ALLOGA UK LTD 72000.00 BarkingHR NELon         31
3424 ALLOGA UK LTD 940488.00 Lewisham SELon         31

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "all" (
   [rowid] INTEGER PRIMARY KEY,
   [Supplier] TEXT,
   [Sum] TEXT,
   [Trust] TEXT,
   [ICB] TEXT,
   [NHS4Sale] TEXT,
   [VT] TEXT,
   [VTUK] TEXT,
   [HSSF] TEXT,
   [click4more] TEXT REFERENCES [supp]([ID])
);