supp

All suppliers, their total income across Trusts, Parent, HQ country, and external links to NHS For Sale, the Violation Trackers for the UK and US, and the Health Systems Support Framework.

3 rows where VT = "https://tinyurl.com/vtroche"

✎ View and edit SQL

This data as json, CSV (advanced)

ID ▼ Supplier Sum - Sum Parent HQ NHS4Sale VT VTUK HSSF
16 Roche Diagnostics Ltd 37530850.93 Roche Holding Ag Switzerland   https://tinyurl.com/vtroche   https://tinyurl.com/hssfx
19 Roche Products Ltd 33128790.25 Roche Holding Ag Switzerland   https://tinyurl.com/vtroche   https://tinyurl.com/hssfx
966 Roche Products Limited 405678.00 Roche Holding Ag Switzerland   https://tinyurl.com/vtroche   https://tinyurl.com/hssfx

Advanced export

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

CSV options: 

CREATE TABLE "supp" (
   [ID] INTEGER PRIMARY KEY,
   [Supplier] TEXT,
   [Sum - Sum] TEXT,
   [Parent] TEXT,
   [HQ] TEXT,
   [NHS4Sale] TEXT,
   [VT] TEXT,
   [VTUK] TEXT,
   [HSSF] TEXT
);