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.

7 rows where click4more = 593

✎ View and edit SQL

This data as json, CSV (advanced)

rowid ▼ Supplier Sum ICB NHS4Sale VT VTUK HSSF click4more
1434 FONTHILL CARE (HARRY PARK) LTD 76555.00 Derby         593
2895 FONTHILL CARE (HARRY PARK) LTD 648785.67 Herts         593
3941 FONTHILL CARE (HARRY PARK) LTD 277000.00 NCLon         593
4357 FONTHILL CARE (HARRY PARK) LTD 242372.42 NELon         593
4897 FONTHILL CARE (HARRY PARK) LTD 175247.82 NWLon         593
5609 FONTHILL CARE (HARRY PARK) LTD 97667.14 Susx         593
5822 FONTHILL CARE (HARRY PARK) LTD 39200.00 SWLon         593

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