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/vtrelx"

✎ View and edit SQL

This data as json, CSV (advanced)

ID ▼ Supplier Sum - Sum Parent HQ NHS4Sale VT VTUK HSSF
1669 ELSEVIER 142054.00       https://tinyurl.com/vtrelx   https://tinyurl.com/hssfx
2983 ELSEVIER LTD 36487.00       https://tinyurl.com/vtrelx   https://tinyurl.com/hssfx
3495 ELSEVIER BV 25728.00       https://tinyurl.com/vtrelx   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
);