all
2 rows where click4more = 43
This data as json, CSV (advanced)
rowid ▼ | Supplier | Sum | ICB | NHS4Sale | VT | VTUK | HSSF | click4more |
---|---|---|---|---|---|---|---|---|
3863 | LONDON CENTRAL & WEST UNSCHEDULED CARE COLLABORATIVE | 21031326.97 | NCLon | 43 | ||||
4806 | LONDON CENTRAL & WEST UNSCHEDULED CARE COLLABORATIVE | 5837214.31 | NWLon | 43 |
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]) );