cases

11 rows where TotalCases = 1071

descending

Link	Date	Country	AreaCode	Area	TotalCases
2020-04-20,Scotland,S08000030,Tayside	2020-04-20	Scotland	S08000030	Tayside	1071
2020-04-30,England,E08000028,Sandwell	2020-04-30	England	E08000028	Sandwell	1071
2020-05-13,England,E09000032,Wandsworth	2020-05-13	England	E09000032	Wandsworth	1071
2020-05-26,England,E06000051,Shropshire	2020-05-26	England	E06000051	Shropshire	1071
2020-05-27,England,E08000002,Bury	2020-05-27	England	E08000002	Bury	1071
2020-06-02,Wales,W11000025,Hywel Dda	2020-06-02	Wales	W11000025	Hywel Dda	1071
2020-06-03,Wales,W11000025,Hywel Dda	2020-06-03	Wales	W11000025	Hywel Dda	1071
2020-06-04,Scotland,S08000015,Ayrshire and Arran	2020-06-04	Scotland	S08000015	Ayrshire and Arran	1071
2020-06-04,Wales,W11000025,Hywel Dda	2020-06-04	Wales	W11000025	Hywel Dda	1071
2020-07-10,England,E09000018,Hounslow	2020-07-10	England	E09000018	Hounslow	1071
2020-07-14,England,E09000004,Bexley	2020-07-14	England	E09000004	Bexley	1071

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