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 Sum = "42000.00"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Trust, ICB

rowid ▼ Supplier Sum Trust ICB NHS4Sale VT VTUK HSSF click4more
1650 Jmu Services Ltd 42000.00 LivWomens C&M         2241
1651 SIRIUS MEDICAL SYSTEMS BV 42000.00 Warrington C&M         2817
2878 AFFINA ORGANISATION DEVELOPMENT LTD 42000.00 Barts NELon         2813
2879 INGLETON WOOD CHARTERED SURVEYORS 42000.00 Barts NELon         2815
2880 PREMIER IT GROUP LTD 42000.00 Barts NELon         2816
4597 IC INTELLIGENCE LTD 42000.00 GSST SELon         2814

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