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.

4 rows where HQ = "France"

✎ View and edit SQL

This data as json, CSV (advanced)

ID ▼ Supplier Sum - Sum Parent HQ NHS4Sale VT VTUK HSSF
24 Veolia Energy & Utility Services Uk Plc 25959268.47 Veolia Environnement Sa France   https://tinyurl.com/vtveolia https://tinyurl.com/vtukveolia  
366 Veolia Energy And Utility Service Uk Pcs 1742751.44 Veolia Environnement Sa France   https://tinyurl.com/vtveolia https://tinyurl.com/vtukveolia  
678 VEOLIA WATER TECHNOLOGIES 706871.68 Veolia Environnement Sa France   https://tinyurl.com/vtveolia https://tinyurl.com/vtukveolia  
2596 VEOLIA ES (UK) LTD 52362.56 Veolia Environnement Sa France   https://tinyurl.com/vtveolia https://tinyurl.com/vtukveolia  

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