cases

11 rows where Date = "2020-03-10" and TotalCases = 3

descending

Link	Date	Country	AreaCode	Area	TotalCases
2020-03-10,England,E06000004,Stockton-on-Tees	2020-03-10	England	E06000004	Stockton-on-Tees	3
2020-03-10,England,E06000014,York	2020-03-10	England	E06000014	York	3
2020-03-10,England,E06000015,Derby	2020-03-10	England	E06000015	Derby	3
2020-03-10,England,E06000045,Southampton	2020-03-10	England	E06000045	Southampton	3
2020-03-10,England,E06000050,Cheshire West and Chester	2020-03-10	England	E06000050	Cheshire West and Chester	3
2020-03-10,England,E08000007,Stockport	2020-03-10	England	E08000007	Stockport	3
2020-03-10,England,E08000032,Bradford	2020-03-10	England	E08000032	Bradford	3
2020-03-10,England,E09000019,Islington	2020-03-10	England	E09000019	Islington	3
2020-03-10,England,E10000027,Somerset	2020-03-10	England	E10000027	Somerset	3
2020-03-10,England,E10000029,Suffolk	2020-03-10	England	E10000029	Suffolk	3
2020-03-10,Wales,W11000029,Cardiff and Vale	2020-03-10	Wales	W11000029	Cardiff and Vale	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])
);