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.

2 rows where HQ = "US" and Parent = "Jacobs Engineering Group Inc."

✎ View and edit SQL

This data as json, CSV (advanced)

ID ▼ Supplier Sum - Sum Parent HQ NHS4Sale VT VTUK HSSF
482 PA CONSULTING GROUP 1232604.00 Jacobs Engineering Group Inc. US   https://tinyurl.com/vtjacobs-sol https://tinyurl.com/vtukjacobs-sol https://tinyurl.com/hssfx
599 PA CONSULTING SERVICES LTD 850081.00 Jacobs Engineering Group Inc. US   https://tinyurl.com/vtjacobs-sol https://tinyurl.com/vtukjacobs-sol 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
);