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 Parent = "Aurelius Group"

✎ View and edit SQL

This data as json, CSV (advanced)

ID ▼ Supplier Sum - Sum Parent HQ NHS4Sale VT VTUK HSSF
11 LLOYDS PHARMACY LTD 52086106.74 Aurelius Group DE-UK-SE-ES     https://tinyurl.com/vtuklloyds  
15 LLOYDS PHARMACY 38600101.95 Aurelius Group DE-UK-SE-ES     https://tinyurl.com/vtuklloyds  
199 LLOYDSPHARMACY CLINICAL HOMECARE 3677810.70 Aurelius Group DE-UK-SE-ES     https://tinyurl.com/vtuklloyds  
217 LLOYDS PHARMACY CLINICAL HOMECARE LTD 3330623.36 Aurelius Group DE-UK-SE-ES     https://tinyurl.com/vtuklloyds  

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