spend2-trust: all: 41 rows where ICB = "NELon" and VTUK = "+"

Along with the standard search boxes, you can focus on a Trust or FT by pressing the tool icon at the top of the Trust column, then press 'Facet by this'.

If a row contains at least one '+' press the entry in the click4more column, then follow the links.

41 rows where ICB = "NELon" and VTUK = "+"

descending

✎ View and edit SQL

This data as json, CSV (advanced)

rowid ▼	Supplier	Sum	Trust	ICB	NHS4Sale	VT	VTUK	HSSF	click4more
2189	SERCO LTD	78581819.52	Barts	NELon		+	+	+	6
2191	LLOYDS PHARMACY	35255856.21	Barts	NELon			+		15
2195	ISS MEDICLEAN LTD	14467517.36	Homerton	NELon		+	+		10
2202	CERNER LTD	10136110.74	Barts	NELon		+	+	+	22
2232	SIEMENS HEALTHCARE LTD	3606406.38	Barts	NELon		+	+	+	40
2235	Lloyds Pharmacy	3344245.74	NELondon	NELon			+		15
2238	INHEALTH LTD	3129522.94	Barts	NELon	+		+		224
2251	SCIENSUS PHARMA SERVICES LTD	2533028.93	Barts	NELon	+		+		84
2252	CERNER LTD	2531914.50	Homerton	NELon		+	+	+	22
2268	PRACTICE PLUS GROUP HOSPITALS LTD	1827101.29	BarkingHR	NELon	+		+		343
2274	NUFFIELD HEALTH	1682947.00	Barts	NELon	+		+		368
2275	DELOITTE LLP	1653606.90	Barts	NELon		+	+	+	155
2299	GE MEDICAL SYSTEMS LTD	1262601.29	BarkingHR	NELon		+	+	+	125
2304	SIEMENS HEALTHCARE LTD	1145567.23	BarkingHR	NELon		+	+	+	40
2311	CIRCLE HEALTH GROUP LTD	1059616.06	Barts	NELon	+	+	+	+	529
2314	CYGNET HEALTH CARE LTD	1032530.75	EastLondon	NELon	+	+	+		54
2326	ALLIANCE MEDICAL LTD	944948.45	BarkingHR	NELon	+		+		134
2342	Price Waterhouse Coopers Llp	724000.00	NELondon	NELon		+	+	+	671
2359	LLOYDS PHARMACY CLINICAL HOMECARE LTD	616527.19	BarkingHR	NELon			+		217
2377	OMNES HEALTHCARE LTD	501720.00	BarkingHR	NELon	+		+		568
2379	Iss Mediclean Limited	501432.00	NELondon	NELon		+	+		844
2381	DELOITTE LLP	495365.51	BarkingHR	NELon		+	+	+	155
2393	ENTSERV UK LTD	480000.00	Barts	NELon		+	+	+	874
2400	SIEMENS HEALTHCARE LTD	455852.00	Homerton	NELon		+	+	+	40
2404	PA CONSULTING SERVICES LTD	441770.00	EastLondon	NELon		+	+	+	599
2407	GE MEDICAL SYSTEMS LTD	423217.19	Barts	NELon		+	+	+	125
2417	LLOYDS PHARMACY CLINICAL HOMECARE LTD	395231.16	Barts	NELon			+		217
2445	SCIENSUS PHARMA SERVICES LTD	318630.00	BarkingHR	NELon	+		+		84
2465	OMNES HEALTHCARE LTD	277098.84	Barts	NELon	+		+		568
2471	Kpmg Llp	267430.00	NELondon	NELon		+	+	+	189
2551	OMNES HEALTHCARE LTD	159563.09	Homerton	NELon	+		+		568
2557	ATOS IT SERVICES UK LTD	155102.28	BarkingHR	NELon		+	+	+	73
2563	CAREHOME SELECTION LTD T/A CHS HEALTHCARE	149880.00	Barts	NELon			+	+	1640
2584	PHOENIX PARTNERSHIP (LEEDS) LTD	134446.73	EastLondon	NELon			+	+	948
2595	KPMG LLP	128540.00	Homerton	NELon		+	+	+	189
2611	KPMG LLP	120350.00	BarkingHR	NELon		+	+	+	189
2711	INHEALTH LTD	79088.10	BarkingHR	NELon	+		+		224
2727	DELOITTE LLP	73200.00	Homerton	NELon		+	+	+	155
2777	CAPITA	60480.00	Barts	NELon	+		+	+	2437
2783	PRICEWATERHOUSECOOPERS	60000.00	Barts	NELon		+	+	+	2454
2828	PRICEWATERHOUSE COOPERS	50000.00	BarkingHR	NELon		+	+	+	2636

Advanced export

JSON shape: default, array, newline-delimited, object

CREATE TABLE "all" (
   [rowid] INTEGER PRIMARY KEY,
   [Supplier] TEXT,
   [Sum] TEXT,
   [Trust] TEXT,
   [ICB] TEXT,
   [NHS4Sale] TEXT,
   [VT] TEXT,
   [VTUK] TEXT,
   [HSSF] TEXT,
   [click4more] TEXT REFERENCES [supp]([ID])
);