home / spend1-icb

all

Along with the standard search boxes, you can focus on an ICB by pressing the tool icon at the top of the ICB column, then press 'Facet by this'.

For info on the parent company, or on any fields marked '+', press the entry in the click4more column, then follow any links.

13 rows where click4more = 497

✎ View and edit SQL

This data as json, CSV (advanced)

rowid ▼ Supplier Sum ICB NHS4Sale VT VTUK HSSF click4more
288 HEALTHCARE GATEWAY LTD 191811.67 Bham         497
645 HEALTHCARE GATEWAY LTD 117661.88 Bristol         497
1002 HEALTHCARE GATEWAY LTD 123013.24 C&M         497
2521 HEALTHCARE GATEWAY LTD 28204.78 GMcr         497
2954 HEALTHCARE GATEWAY LTD 136494.11 Herts         497
3265 HEALTHCARE GATEWAY LTD 416140.51 Kent         497
3488 HEALTHCARE GATEWAY LTD 241347.22 Lancs         497
3955 HEALTHCARE GATEWAY LTD 169209.28 NCLon         497
4185 HEALTHCARE GATEWAY LTD 81782.93 NE&Cumb         497
4350 HEALTHCARE GATEWAY LTD 262706.77 NELon         497
4516 HEALTHCARE GATEWAY LTD 209259.69 Nhamp         497
5870 HEALTHCARE GATEWAY LTD -105222.22 SWLon         497
6172 HEALTHCARE GATEWAY LTD 42190.70 SYorks         497

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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])
);
Powered by Datasette · Queries took 25.284ms