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.

1 row where HQ = "South Africa"

✎ View and edit SQL

This data as json, CSV (advanced)

ID ▼ Supplier Sum - Sum Parent HQ NHS4Sale VT VTUK HSSF
134 ALLIANCE MEDICAL LTD 5428403.55 Life Healthcare Group Holdings Ltd South Africa https://tinyurl.com/nhs4alliancemed   https://tinyurl.com/vtukalliancemed  

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