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.

6 rows where Supplier = "CANON MEDICAL SYSTEMS LTD"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: ICB

rowid ▼ Supplier Sum Trust ICB NHS4Sale VT VTUK HSSF click4more
753 CANON MEDICAL SYSTEMS LTD 184255.20 Warrington C&M         116
2273 CANON MEDICAL SYSTEMS LTD 1760622.48 Barts NELon         116
2500 CANON MEDICAL SYSTEMS LTD 216828.56 Homerton NELon         116
2794 CANON MEDICAL SYSTEMS LTD 57687.28 BarkingHR NELon         116
3979 CANON MEDICAL SYSTEMS LTD 156360.00 Lewisham SELon         116
4929 CANON MEDICAL SYSTEMS LTD 25999.80 GSST SELon         116

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