cases

7 rows where TotalCases = 1145

descending

Link	Date	Country	AreaCode	Area	TotalCases
2020-04-20,England,E10000034,Worcestershire	2020-04-20	England	E10000034	Worcestershire	1145
2020-04-23,England,E10000031,Warwickshire	2020-04-23	England	E10000031	Warwickshire	1145
2020-05-04,England,E08000007,Stockport	2020-05-04	England	E08000007	Stockport	1145
2020-05-19,England,E08000026,Coventry	2020-05-19	England	E08000026	Coventry	1145
2020-06-04,England,E08000013,St. Helens	2020-06-04	England	E08000013	St. Helens	1145
2020-06-30,Wales,W11000025,Hywel Dda	2020-06-30	Wales	W11000025	Hywel Dda	1145
2020-07-01,Wales,W11000025,Hywel Dda	2020-07-01	Wales	W11000025	Hywel Dda	1145

Advanced export

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

CREATE TABLE "cases" (
"Date" TEXT,
  "Country" TEXT,
  "AreaCode" TEXT,
  "Area" TEXT,
  "TotalCases" INTEGER
  ,PRIMARY KEY ([Date], [Country], [AreaCode], [Area])
);