hssf
4 rows where HQ = "US" and Trusts = 3
This data as json, CSV (advanced)
Suggested facets: Viols_UK, Viols_US
hssf_ID ▼ | hssf_name | Parent | HQ | hssf_accred | Trusts | Viols_UK | Viols_US | supp_ID |
---|---|---|---|---|---|---|---|---|
76 | GE Healthcare Finnamore Ltd | General Electric Company | US | 14 | 3 | 5 | 105 | 294 |
106 | InterSystems | INTERSYSTEMS CORPORATION | US | 3 | 3 | 1494 | ||
109 | IQVIA | US | 13 | 3 | 1763 | |||
160 | PA Consulting Group | Jacobs Engineering Group Inc. | US | 18 | 3 | 1 | 61 | 482 |
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]) );