cases

14 rows where TotalCases = 342

descending

Link	Date	Country	AreaCode	Area	TotalCases
2020-04-03,England,E10000018,Leicestershire	2020-04-03	England	E10000018	Leicestershire	342
2020-04-07,Wales,W11000023,Betsi Cadwaladr	2020-04-07	Wales	W11000023	Betsi Cadwaladr	342
2020-04-08,England,E08000013,St. Helens	2020-04-08	England	E08000013	St. Helens	342
2020-04-11,England,E08000034,Kirklees	2020-04-11	England	E08000034	Kirklees	342
2020-04-13,England,E06000018,Nottingham	2020-04-13	England	E06000018	Nottingham	342
2020-04-22,England,E06000025,South Gloucestershire	2020-04-22	England	E06000025	South Gloucestershire	342
2020-04-29,England,E06000034,Thurrock	2020-04-29	England	E06000034	Thurrock	342
2020-05-14,Northern Ireland,None,Not Known	2020-05-14	Northern Ireland		Not Known	342
2020-05-28,England,E06000036,Bracknell Forest	2020-05-28	England	E06000036	Bracknell Forest	342
2020-05-31,Northern Ireland,None,Not Known	2020-05-31	Northern Ireland		Not Known	342
2020-06-01,Northern Ireland,None,Not Known	2020-06-01	Northern Ireland		Not Known	342
2020-06-02,Northern Ireland,None,Not Known	2020-06-02	Northern Ireland		Not Known	342
2020-06-05,Northern Ireland,None,Not Known	2020-06-05	Northern Ireland		Not Known	342
2020-07-19,England,E06000022,Bath and North East Somerset	2020-07-19	England	E06000022	Bath and North East Somerset	342

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