cases

13 rows where Date = "2020-03-01" and TotalCases = 1

descending

Link	Date	Country	AreaCode	Area	TotalCases
2020-03-01,England,E06000010,Kingston upon Hull, City of	2020-03-01	England	E06000010	Kingston upon Hull, City of	1
2020-03-01,England,E06000054,Wiltshire	2020-03-01	England	E06000054	Wiltshire	1
2020-03-01,England,E08000001,Bolton	2020-03-01	England	E08000001	Bolton	1
2020-03-01,England,E08000007,Stockport	2020-03-01	England	E08000007	Stockport	1
2020-03-01,England,E08000015,Wirral	2020-03-01	England	E08000015	Wirral	1
2020-03-01,England,E08000019,Sheffield	2020-03-01	England	E08000019	Sheffield	1
2020-03-01,England,E08000025,Birmingham	2020-03-01	England	E08000025	Birmingham	1
2020-03-01,England,E08000030,Walsall	2020-03-01	England	E08000030	Walsall	1
2020-03-01,England,E09000002,Barking and Dagenham	2020-03-01	England	E09000002	Barking and Dagenham	1
2020-03-01,England,E09000006,Bromley	2020-03-01	England	E09000006	Bromley	1
2020-03-01,England,E09000032,Wandsworth	2020-03-01	England	E09000032	Wandsworth	1
2020-03-01,England,E10000018,Leicestershire	2020-03-01	England	E10000018	Leicestershire	1
2020-03-01,Wales,W11000031,Swansea Bay	2020-03-01	Wales	W11000031	Swansea Bay	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])
);