indicators

descending

Link	Date	Country ▼	Indicator	Value
2020-06-30,England,ConfirmedCases	2020-06-30	England	ConfirmedCases	244316
2020-06-30,England,Deaths	2020-06-30	England	Deaths	39187
2020-06-30,Northern Ireland,ConfirmedCases	2020-06-30	Northern Ireland	ConfirmedCases	4880
2020-06-30,Northern Ireland,Deaths	2020-06-30	Northern Ireland	Deaths	551
2020-06-30,Northern Ireland,Tests	2020-06-30	Northern Ireland	Tests	77906
2020-06-30,Scotland,ConfirmedCases	2020-06-30	Scotland	ConfirmedCases	18251
2020-06-30,Scotland,Deaths	2020-06-30	Scotland	Deaths	2485
2020-06-30,Scotland,Tests	2020-06-30	Scotland	Tests	260336
2020-06-30,UK,ConfirmedCases	2020-06-30	UK	ConfirmedCases	312654
2020-06-30,UK,Deaths	2020-06-30	UK	Deaths	43730
2020-06-30,Wales,ConfirmedCases	2020-06-30	Wales	ConfirmedCases	16598
2020-06-30,Wales,Deaths	2020-06-30	Wales	Deaths	1526
2020-06-30,Wales,Tests	2020-06-30	Wales	Tests	169521

CREATE TABLE "indicators" (
"Date" TEXT,
  "Country" TEXT,
  "Indicator" TEXT,
  "Value" INTEGER
  ,PRIMARY KEY ([Date], [Country], [Indicator])
);