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.

38 rows where click4more = 2

✎ View and edit SQL

This data as json, CSV (advanced)

rowid ▼ Supplier Sum ICB NHS4Sale VT VTUK HSSF click4more
4 CIRCLE HEALTH GROUP LTD 10725181.80 Banes + + + + 2
96 CIRCLE HEALTH GROUP LTD 9667095.83 Bedford + + + + 2
210 CIRCLE HEALTH GROUP LTD 6576234.08 Bham + + + + 2
382 CIRCLE HEALTH GROUP LTD 2296289.54 Black + + + + 2
595 CIRCLE HEALTH GROUP LTD 833672.37 Bristol + + + + 2
680 CIRCLE HEALTH GROUP LTD 17166966.06 Buck + + + + 2
889 CIRCLE HEALTH GROUP LTD 1748636.98 C&M + + + + 2
1221 CIRCLE HEALTH GROUP LTD 8077960.56 Coventry + + + + 2
1352 CIRCLE HEALTH GROUP LTD 2479841.72 Derby + + + + 2
1588 CIRCLE HEALTH GROUP LTD 7313840.85 Dorset + + + + 2
1707 CIRCLE HEALTH GROUP LTD 1957511.76 Frim + + + + 2
1830 CIRCLE HEALTH GROUP LTD 528969.42 Glos + + + + 2
2241 CIRCLE HEALTH GROUP LTD 28987185.92 GMcr + + + + 2
2553 CIRCLE HEALTH GROUP LTD 7890143.34 Hants + + + + 2
2799 CIRCLE HEALTH GROUP LTD 2447031.56 Hereford + + + + 2
2871 CIRCLE HEALTH GROUP LTD 7806558.32 Herts + + + + 2
3037 CIRCLE HEALTH GROUP LTD 3065795.75 Humber + + + + 2
3190 CIRCLE HEALTH GROUP LTD 9521921.75 Kent + + + + 2
3412 CIRCLE HEALTH GROUP LTD 21564096.51 Lancs + + + + 2
3596 CIRCLE HEALTH GROUP LTD 231084.82 Leic + + + + 2
3623 CIRCLE HEALTH GROUP LTD 8461175.08 Lincoln + + + + 2
3736 CIRCLE HEALTH GROUP LTD 2885720.83 MSEsx + + + + 2
3869 CIRCLE HEALTH GROUP LTD 5226900.30 NCLon + + + + 2
4023 CIRCLE HEALTH GROUP LTD 16187540.22 NE&Cumb + + + + 2
4276 CIRCLE HEALTH GROUP LTD 14119384.33 NELon + + + + 2
4473 CIRCLE HEALTH GROUP LTD 13892050.99 Nhamp + + + + 2
4573 CIRCLE HEALTH GROUP LTD 912790.85 Norfolk + + + + 2
4678 CIRCLE HEALTH GROUP LTD 12245325.80 Nott + + + + 2
4800 CIRCLE HEALTH GROUP LTD 14411550.79 NWLon + + + + 2
4995 CIRCLE HEALTH GROUP LTD 21413276.31 SELon + + + + 2
5224 CIRCLE HEALTH GROUP LTD 310000.00 Shrop + + + + 2
5376 CIRCLE HEALTH GROUP LTD 862348.00 Staff + + + + 2
5430 CIRCLE HEALTH GROUP LTD 1598346.34 Suffolk + + + + 2
5513 CIRCLE HEALTH GROUP LTD 5865961.07 Susx + + + + 2
5675 CIRCLE HEALTH GROUP LTD 1392578.35 SWLon + + + + 2
5899 CIRCLE HEALTH GROUP LTD 984979.62 SyHrt + + + + 2
6031 CIRCLE HEALTH GROUP LTD 1588570.95 SYorks + + + + 2
6236 CIRCLE HEALTH GROUP LTD 8421765.09 WYorks + + + + 2

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