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.

2 rows where VT = "https://tinyurl.com/vt3Mco"

✎ View and edit SQL

This data as json, CSV (advanced)

ID ▼ Supplier Sum - Sum Parent HQ NHS4Sale VT VTUK HSSF
429 3M UNITED KINGDOM PLC 1426385.40 3m Company US   https://tinyurl.com/vt3Mco   https://tinyurl.com/hssfx
2866 3m United Kingdom Plc (3m Unitek Uk) 40373.13 3m Company US   https://tinyurl.com/vt3Mco   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
);