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.

6 rows where click4more = 90

✎ View and edit SQL

This data as json, CSV (advanced)

rowid ▼ Supplier Sum ICB NHS4Sale VT VTUK HSSF click4more
381 BRITISH PREGNANCY ADVISORY SERVICE 3431953.91 Black         90
883 BRITISH PREGNANCY ADVISORY SERVICE 2978180.44 C&M         90
1229 BRITISH PREGNANCY ADVISORY SERVICE 2075281.92 Coventry         90
1379 BRITISH PREGNANCY ADVISORY SERVICE 644252.66 Derby         90
1608 BRITISH PREGNANCY ADVISORY SERVICE 984184.39 Dorset         90
6273 BRITISH PREGNANCY ADVISORY SERVICE 1664134.63 WYorks         90

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