cases

6 rows where Date = "2020-03-06" and TotalCases = 3

descending

Link	Date	Country	AreaCode	Area	TotalCases
2020-03-06,England,E06000058,Bournemouth, Christchurch and Poole	2020-03-06	England	E06000058	Bournemouth, Christchurch and Poole	3
2020-03-06,England,E09000007,Camden	2020-03-06	England	E09000007	Camden	3
2020-03-06,England,E09000013,Hammersmith and Fulham	2020-03-06	England	E09000013	Hammersmith and Fulham	3
2020-03-06,England,E09000024,Merton	2020-03-06	England	E09000024	Merton	3
2020-03-06,England,E10000002,Buckinghamshire	2020-03-06	England	E10000002	Buckinghamshire	3
2020-03-06,England,E10000018,Leicestershire	2020-03-06	England	E10000018	Leicestershire	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])
);