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.

9 rows where click4more = 209

✎ View and edit SQL

This data as json, CSV (advanced)

rowid ▼ Supplier Sum ICB NHS4Sale VT VTUK HSSF click4more
1243 CONNECT HEALTH PAIN SERVICES LTD 624858.30 Coventry         209
2271 CONNECT HEALTH PAIN SERVICES LTD 2829281.19 GMcr         209
3128 CONNECT HEALTH PAIN SERVICES LTD 69138.40 Humber         209
3457 CONNECT HEALTH PAIN SERVICES LTD 693080.02 Lancs         209
4092 CONNECT HEALTH PAIN SERVICES LTD 450429.66 NE&Cumb         209
5220 CONNECT HEALTH PAIN SERVICES LTD 443079.36 Shrop         209
5569 CONNECT HEALTH PAIN SERVICES LTD 364381.64 Susx         209
6127 CONNECT HEALTH PAIN SERVICES LTD 113368.82 SYorks         209
6507 CONNECT HEALTH PAIN SERVICES LTD -112194.16 WYorks         209

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])
);