cases

8 rows where TotalCases = 1175

descending

Link	Date	Country	AreaCode	Area	TotalCases
2020-04-01,England,E08000025,Birmingham	2020-04-01	England	E08000025	Birmingham	1175
2020-04-24,England,E10000013,Gloucestershire	2020-04-24	England	E10000013	Gloucestershire	1175
2020-04-24,Wales,W11000023,Betsi Cadwaladr	2020-04-24	Wales	W11000023	Betsi Cadwaladr	1175
2020-05-05,England,E08000021,Newcastle upon Tyne	2020-05-05	England	E08000021	Newcastle upon Tyne	1175
2020-05-28,England,E06000007,Warrington	2020-05-28	England	E06000007	Warrington	1175
2020-06-13,England,E09000023,Lewisham	2020-06-13	England	E09000023	Lewisham	1175
2020-06-21,England,E08000013,St. Helens	2020-06-21	England	E08000013	St. Helens	1175
2020-06-30,England,E09000010,Enfield	2020-06-30	England	E09000010	Enfield	1175

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