supp
4 rows where VT = "https://tinyurl.com/vtpwc1"
This data as json, CSV (advanced)
ID ▼ | Supplier | Sum - Sum | Parent | HQ | NHS4Sale | VT | VTUK | HSSF |
---|---|---|---|---|---|---|---|---|
277 | PRICEWATERHOUSECOOPERS LLP | 2621121.40 | https://tinyurl.com/vtpwc1 | https://tinyurl.com/vtukpwc1 | https://tinyurl.com/hssfx | |||
671 | Price Waterhouse Coopers Llp | 724000.00 | https://tinyurl.com/vtpwc1 | https://tinyurl.com/vtukpwc1 | https://tinyurl.com/hssfx | |||
2454 | PRICEWATERHOUSECOOPERS | 60000.00 | https://tinyurl.com/vtpwc1 | https://tinyurl.com/vtukpwc1 | https://tinyurl.com/hssfx | |||
2636 | PRICEWATERHOUSE COOPERS | 50000.00 | https://tinyurl.com/vtpwc1 | https://tinyurl.com/vtukpwc1 | 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 );