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.

40 rows where click4more = 3

✎ View and edit SQL

This data as json, CSV (advanced)

rowid ▼ Supplier Sum ICB NHS4Sale VT VTUK HSSF click4more
17 SPAMEDICA LTD 1156111.28 Banes         3
100 SPAMEDICA LTD 3581807.28 Bedford         3
209 SPAMEDICA LTD 7918907.47 Bham         3
374 SPAMEDICA LTD 12398116.57 Black         3
580 SPAMEDICA LTD 3337392.94 Bristol         3
682 SPAMEDICA LTD 6091473.98 Buck         3
826 SPAMEDICA LTD 1250000.00 Cambs         3
866 SPAMEDICA LTD 21752547.82 C&M         3
1220 SPAMEDICA LTD 8680069.15 Coventry         3
1339 SPAMEDICA LTD 7648992.31 Derby         3
1481 SPAMEDICA LTD 4813418.44 Devon         3
1590 SPAMEDICA LTD 5981272.12 Dorset         3
1708 SPAMEDICA LTD 1902446.89 Frim         3
1812 SPAMEDICA LTD 1331770.86 Glos         3
2243 SPAMEDICA LTD 22871955.67 GMcr         3
2560 SPAMEDICA LTD 4180004.75 Hants         3
2803 SPAMEDICA LTD 1108262.79 Hereford         3
2879 SPAMEDICA LTD 2444120.13 Herts         3
3033 SPAMEDICA LTD 5367080.92 Humber         3
3198 SPAMEDICA LTD 3511017.19 Kent         3
3415 SPAMEDICA LTD 19934427.21 Lancs         3
3627 SPAMEDICA LTD 4658314.79 Lincoln         3
3729 SPAMEDICA LTD 8819689.06 MSEsx         3
3901 SPAMEDICA LTD 762973.92 NCLon         3
4021 SPAMEDICA LTD 19426082.92 NE&Cumb         3
4284 SPAMEDICA LTD 5690842.15 NELon         3
4485 SPAMEDICA LTD 1168257.82 Nhamp         3
4564 SPAMEDICA LTD 3222905.01 Norfolk         3
4687 SPAMEDICA LTD 2905142.90 Nott         3
4817 SPAMEDICA LTD 1678867.32 NWLon         3
5006 SPAMEDICA LTD 4410756.89 SELon         3
5206 SPAMEDICA LTD 1670021.91 Shrop         3
5297 SPAMEDICA LTD 741016.58 Somer         3
5358 SPAMEDICA LTD 8689138.70 Staff         3
5439 SPAMEDICA LTD 631778.71 Suffolk         3
5516 SPAMEDICA LTD 5380227.83 Susx         3
5669 SPAMEDICA LTD 2275535.89 SWLon         3
5895 SPAMEDICA LTD 1367064.03 SyHrt         3
6011 SPAMEDICA LTD 9749353.76 SYorks         3
6231 SPAMEDICA LTD 13597288.39 WYorks         3

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 20.069ms