cases

5 rows where Country = "England" and TotalCases = 345

descending

Link	Date	Country	AreaCode	Area	TotalCases
2020-04-06,England,E10000023,North Yorkshire	2020-04-06	England	E10000023	North Yorkshire	345
2020-04-26,England,E06000059,Dorset	2020-04-26	England	E06000059	Dorset	345
2020-05-18,England,E06000046,Isle of Wight	2020-05-18	England	E06000046	Isle of Wight	345
2020-07-23,England,E06000022,Bath and North East Somerset	2020-07-23	England	E06000022	Bath and North East Somerset	345
2020-07-25,England,E06000022,Bath and North East Somerset	2020-07-25	England	E06000022	Bath and North East Somerset	345

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