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.

24 rows where click4more = 29

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Supplier

rowid ▼ Supplier Sum ICB NHS4Sale VT VTUK HSSF click4more
131 SPECSAVERS HEARCARE LTD 371122.29 Bedford         29
232 SPECSAVERS HEARCARE LTD 1455472.41 Bham         29
391 SPECSAVERS HEARCARE LTD 1212322.20 Black         29
601 SPECSAVERS HEARCARE LTD 611087.70 Bristol         29
711 SPECSAVERS HEARCARE LTD 697425.63 Buck         29
833 SPECSAVERS HEARCARE LTD 581492.08 Cambs         29
881 SPECSAVERS HEARCARE LTD 3287366.04 C&M         29
1148 Specsavers Hearcare Ltd 819837.74 Cornwall         29
1231 SPECSAVERS HEARCARE LTD 1699616.64 Coventry         29
1357 SPECSAVERS HEARCARE LTD 2094409.60 Derby         29
1498 SPECSAVERS HEARCARE LTD 977488.94 Devon         29
1716 SPECSAVERS HEARCARE LTD 776824.90 Frim         29
1913 SPECSAVERS HEARCARE LTD 62347.11 Glos         29
2269 SPECSAVERS HEARCARE LTD 2868488.37 GMcr         29
2591 SPECSAVERS HEARCARE LTD 1398657.84 Hants         29
2808 SPECSAVERS HEARCARE LTD 446439.66 Hereford         29
3427 SPECSAVERS HEARCARE LTD 4342994.77 Lancs         29
3637 SPECSAVERS HEARCARE LTD 1976091.84 Lincoln         29
4037 SPECSAVERS HEARCARE LTD 4134628.34 NE&Cumb         29
4617 SPECSAVERS HEARCARE LTD 116963.99 Norfolk         29
4851 SPECSAVERS HEARCARE LTD 608886.21 NWLon         29
5019 SPECSAVERS HEARCARE LTD 1825348.02 SELon         29
5532 SPECSAVERS HEARCARE LTD 1704508.59 Susx         29
6302 SPECSAVERS HEARCARE LTD 680467.37 WYorks         29

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