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.

10 rows where click4more = 326

✎ View and edit SQL

This data as json, CSV (advanced)

rowid ▼ Supplier Sum ICB NHS4Sale VT VTUK HSSF click4more
313 CYGNET BEHAVIOURAL HEALTH LTD 98385.48 Bham + + +   326
1060 CYGNET BEHAVIOURAL HEALTH LTD 51212.00 C&M + + +   326
1278 CYGNET BEHAVIOURAL HEALTH LTD 132699.75 Coventry + + +   326
1547 CYGNET BEHAVIOURAL HEALTH LTD 106702.00 Devon + + +   326
2386 CYGNET BEHAVIOURAL HEALTH LTD 271850.28 GMcr + + +   326
2662 CYGNET BEHAVIOURAL HEALTH LTD 344536.49 Hants + + +   326
3444 CYGNET BEHAVIOURAL HEALTH LTD 1239656.06 Lancs + + +   326
4072 CYGNET BEHAVIOURAL HEALTH LTD 810577.64 NE&Cumb + + +   326
6071 CYGNET BEHAVIOURAL HEALTH LTD 433839.00 SYorks + + +   326
6482 CYGNET BEHAVIOURAL HEALTH LTD 27686.00 WYorks + + +   326

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