cases

5 rows where TotalCases = 1117

descending

Link	Date	Country	AreaCode	Area	TotalCases
2020-05-13,England,E09000023,Lewisham	2020-05-13	England	E09000023	Lewisham	1117
2020-05-23,England,E08000008,Tameside	2020-05-23	England	E08000008	Tameside	1117
2020-06-09,England,E09000032,Wandsworth	2020-06-09	England	E09000032	Wandsworth	1117
2020-06-20,Wales,W11000025,Hywel Dda	2020-06-20	Wales	W11000025	Hywel Dda	1117
2020-06-21,Wales,W11000025,Hywel Dda	2020-06-21	Wales	W11000025	Hywel Dda	1117

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])
);