hssf
3 rows where Viols_US = 2
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
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]) );