cases

5 rows where Date = "2020-03-07" and TotalCases = 3

descending

Link	Date	Country	AreaCode	Area	TotalCases
2020-03-07,England,E06000018,Nottingham	2020-03-07	England	E06000018	Nottingham	3
2020-03-07,England,E06000023,Bristol, City of	2020-03-07	England	E06000023	Bristol, City of	3
2020-03-07,England,E08000001,Bolton	2020-03-07	England	E08000001	Bolton	3
2020-03-07,England,E09000023,Lewisham	2020-03-07	England	E09000023	Lewisham	3
2020-03-07,England,E09000029,Sutton	2020-03-07	England	E09000029	Sutton	3

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