home / spend2-trust

hssf

Name shown on Health Systems Support Framework (HSSF), Parent, HQ country, number of HSSF topics accredited, number of Trusts and FTs with spending, number of UK violations, number of US violations, link to the company entry on the supp table.

The number of Trusts or FTs with spending can exceed what is shown on the linked item in supp, as other companies may be related. Search the HSSF external page using the hssf_name to find the topics for which a company is accredited.

3 rows where Viols_US = 2

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: HQ, Trusts, supp_ID

hssf_ID ▼ hssf_name Parent HQ hssf_accred Trusts Viols_UK Viols_US supp_ID
13 Allscripts Healthcare (IT) UK Limited Allscripts Healthcare Solutions Inc. US 2 2   2 522
22 BearingPoint Limited none, but BearingPoint in Netherlands Netherlands 1     2
175 Public Consulting Group UK Limited PUBLIC CONSULTING GROUP US 10     2

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE "hssf" (
   [hssf_ID] INTEGER PRIMARY KEY,
   [hssf_name] TEXT,
   [Parent] TEXT,
   [HQ] TEXT,
   [hssf_accred] TEXT,
   [Trusts] TEXT,
   [Viols_UK] TEXT,
   [Viols_US] TEXT,
   [supp_ID] TEXT REFERENCES [supp]([ID])
);
Powered by Datasette · Queries took 9.097ms