all
7 rows where click4more = 411
This data as json, CSV (advanced)
rowid ▼ | Supplier | Sum | ICB | NHS4Sale | VT | VTUK | HSSF | click4more |
---|---|---|---|---|---|---|---|---|
83 | WT UK OPCO 4 LTD | 32810.36 | Banes | 411 | ||||
695 | WT UK OPCO 4 LTD | 1426939.74 | Buck | 411 | ||||
1022 | WT UK OPCO 4 LTD | 87029.92 | C&M | 411 | ||||
1651 | WT UK OPCO 4 LTD | 144955.74 | Dorset | 411 | ||||
5485 | WT UK OPCO 4 LTD | 52822.00 | Suffolk | 411 | ||||
5781 | WT UK OPCO 4 LTD | 81973.53 | SWLon | 411 | ||||
5908 | WT UK OPCO 4 LTD | 699109.30 | SyHrt | 411 |
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]) );