cases

10 rows where TotalCases = 520

descending

Link	Date	Country	AreaCode	Area	TotalCases
2020-03-28,England,E08000019,Sheffield	2020-03-28	England	E08000019	Sheffield	520
2020-04-13,England,E09000029,Sutton	2020-04-13	England	E09000029	Sutton	520
2020-04-14,England,E06000049,Cheshire East	2020-04-14	England	E06000049	Cheshire East	520
2020-04-18,England,E06000007,Warrington	2020-04-18	England	E06000007	Warrington	520
2020-04-21,England,E08000036,Wakefield	2020-04-21	England	E08000036	Wakefield	520
2020-05-08,England,E06000013,North Lincolnshire	2020-05-08	England	E06000013	North Lincolnshire	520
2020-05-18,England,E09000020,Kensington and Chelsea	2020-05-18	England	E09000020	Kensington and Chelsea	520
2020-06-01,England,E09000019,Islington	2020-06-01	England	E09000019	Islington	520
2020-06-10,England,E09000027,Richmond upon Thames	2020-06-10	England	E09000027	Richmond upon Thames	520
2020-06-16,England,E06000034,Thurrock	2020-06-16	England	E06000034	Thurrock	520

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