supp
2 rows where HQ = "Denmark"
This data as json, CSV (advanced)
ID ▼ | Supplier | Sum - Sum | Parent | HQ | NHS4Sale | VT | VTUK | HSSF |
---|---|---|---|---|---|---|---|---|
10 | ISS MEDICLEAN LTD | 56767730.73 | Iss Global A/S | Denmark | https://tinyurl.com/vtiss | https://tinyurl.com/vtukiss | ||
844 | Iss Mediclean Limited | 501432.00 | Iss Global A/S | Denmark | https://tinyurl.com/vtiss | https://tinyurl.com/vtukiss |
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 );