hssf
4 rows where HQ = "UK" and hssf_accred = 7
This data as json, CSV (advanced)
Suggested facets: Trusts, Viols_US, supp_ID
| hssf_ID ▼ | hssf_name | Parent | HQ | hssf_accred | Trusts | Viols_UK | Viols_US | supp_ID |
|---|---|---|---|---|---|---|---|---|
| 25 | Bramble Hub Limited | Richard Archer, Bramble Effect Limited | UK | 7 | ||||
| 65 | Edge Health Ltd | Robert Edward Bramley-Harker, George Octavius William Batchelor | UK | 7 | 1 | 1612 | ||
| 81 | Health Innovation Network | UK | 7 | |||||
| 206 | System C Healthcare Ltd | ASCLEPIUS TOPCO LIMITED | UK | 7 | 5 | 71 | 81 |
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]) );