supp
5 rows where VTUK = "https://tinyurl.com/vtukcapita"
This data as json, CSV (advanced)
ID ▼ | Supplier | Sum - Sum | Parent | HQ | NHS4Sale | VT | VTUK | HSSF |
---|---|---|---|---|---|---|---|---|
246 | Capita Resourcing Ltd | 2886634.77 | CAPITA PLC | UK | https://tinyurl.com/n4scapita | https://tinyurl.com/vtukcapita | https://tinyurl.com/hssfx | |
510 | Capita Property And Infrastructure Ltd | 1131367.81 | CAPITA PLC | UK | https://tinyurl.com/n4scapita | https://tinyurl.com/vtukcapita | https://tinyurl.com/hssfx | |
1526 | Capita Business Services Ltd | 173635.33 | CAPITA PLC | UK | https://tinyurl.com/n4scapita | https://tinyurl.com/vtukcapita | https://tinyurl.com/hssfx | |
2211 | CAPITA IB SOLUTIONS LTD | 76942.42 | CAPITA PLC | UK | https://tinyurl.com/n4scapita | https://tinyurl.com/vtukcapita | https://tinyurl.com/hssfx | |
2437 | CAPITA | 60480.00 | CAPITA PLC | UK | https://tinyurl.com/n4scapita | https://tinyurl.com/vtukcapita | https://tinyurl.com/hssfx |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "supp" ( [ID] INTEGER PRIMARY KEY, [Supplier] TEXT, [Sum - Sum] TEXT, [Parent] TEXT, [HQ] TEXT, [NHS4Sale] TEXT, [VT] TEXT, [VTUK] TEXT, [HSSF] TEXT );