cases

11 rows where "Date" is on date 2020-03-09 and TotalCases = 1

descending

Link	Date	Country	AreaCode	Area	TotalCases
2020-03-09,England,E06000004,Stockton-on-Tees	2020-03-09	England	E06000004	Stockton-on-Tees	1
2020-03-09,England,E06000007,Warrington	2020-03-09	England	E06000007	Warrington	1
2020-03-09,England,E06000024,North Somerset	2020-03-09	England	E06000024	North Somerset	1
2020-03-09,England,E06000044,Portsmouth	2020-03-09	England	E06000044	Portsmouth	1
2020-03-09,England,E06000047,County Durham	2020-03-09	England	E06000047	County Durham	1
2020-03-09,England,E08000005,Rochdale	2020-03-09	England	E08000005	Rochdale	1
2020-03-09,England,E08000014,Sefton	2020-03-09	England	E08000014	Sefton	1
2020-03-09,England,E08000034,Kirklees	2020-03-09	England	E08000034	Kirklees	1
2020-03-09,England,E09000025,Newham	2020-03-09	England	E09000025	Newham	1
2020-03-09,Wales,,Unknown	2020-03-09	Wales		Unknown	1
2020-03-09,Wales,W11000028,Aneurin Bevan	2020-03-09	Wales	W11000028	Aneurin Bevan	1

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