hssf

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

The number of ICBs 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.

CREATE TABLE "hssf" (
   [hssf_ID] INTEGER PRIMARY KEY,
   [hssf_name] TEXT,
   [Parent] TEXT,
   [HQ] TEXT,
   [hssf_accred] TEXT,
   [ICBs] TEXT,
   [Viols_UK] TEXT,
   [Viols_US] TEXT,
   [supp_ID] TEXT REFERENCES [supp]([ID])
);