all
5 rows where click4more = 86
This data as json, CSV (advanced)
rowid ▼ | Supplier | Sum | ICB | NHS4Sale | VT | VTUK | HSSF | click4more |
---|---|---|---|---|---|---|---|---|
694 | HEALTHSHARE LTD | 1588505.76 | Buck | 86 | ||||
3041 | HEALTHSHARE LTD | 2293316.58 | Humber | 86 | ||||
3211 | HEALTHSHARE LTD | 1733775.83 | Kent | 86 | ||||
4808 | HEALTHSHARE LTD | 5037627.50 | NWLon | 86 | ||||
5672 | HEALTHSHARE LTD | 1649781.96 | SWLon | 86 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "all" ( [rowid] INTEGER PRIMARY KEY, [Supplier] TEXT, [Sum] TEXT, [ICB] TEXT, [NHS4Sale] TEXT, [VT] TEXT, [VTUK] TEXT, [HSSF] TEXT, [click4more] TEXT REFERENCES [supp]([ID]) );