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 HQ = "Canada"

✎ View and edit SQL

This data as json, CSV (advanced)

ID ▼ Supplier Sum - Sum Parent HQ NHS4Sale VT VTUK HSSF
7 PULSE HEALTHCARE LTD 75221755.57 Mr Gerald Schwartz Canada        
600 PULSE HEALTHCARE L 6207713 849403.51 Mr Gerald Schwartz Canada        
842 PULSE HEALTHCARE LIMITED 502311.60 Mr Gerald Schwartz Canada        

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