hssf
1 row where supp_ID = 72
This data as json, CSV (advanced)
hssf_ID ▼ | hssf_name | Parent | HQ | hssf_accred | ICBs | Viols_UK | Viols_US | supp_ID |
---|---|---|---|---|---|---|---|---|
66 | Egton Medical Information Systems Ltd | UnitedHealth (Optum) | US | 5 | 30 | 366 | 72 |
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, [ICBs] TEXT, [Viols_UK] TEXT, [Viols_US] TEXT, [supp_ID] TEXT REFERENCES [supp]([ID]) );