cases

14 rows where TotalCases = 1164

descending

Link	Date	Country	AreaCode	Area	TotalCases
2020-04-28,England,E10000023,North Yorkshire	2020-04-28	England	E10000023	North Yorkshire	1164
2020-04-30,England,E08000015,Wirral	2020-04-30	England	E08000015	Wirral	1164
2020-05-27,England,E06000007,Warrington	2020-05-27	England	E06000007	Warrington	1164
2020-06-02,England,E08000005,Rochdale	2020-06-02	England	E08000005	Rochdale	1164
2020-06-06,England,E08000002,Bury	2020-06-06	England	E08000002	Bury	1164
2020-06-08,England,E10000008,Devon	2020-06-08	England	E10000008	Devon	1164
2020-06-16,England,E06000031,Peterborough	2020-06-16	England	E06000031	Peterborough	1164
2020-07-02,England,E06000018,Nottingham	2020-07-02	England	E06000018	Nottingham	1164
2020-07-11,England,E09000032,Wandsworth	2020-07-11	England	E09000032	Wandsworth	1164
2020-07-16,Wales,W11000025,Hywel Dda	2020-07-16	Wales	W11000025	Hywel Dda	1164
2020-07-17,Wales,W11000025,Hywel Dda	2020-07-17	Wales	W11000025	Hywel Dda	1164
2020-07-18,Wales,W11000025,Hywel Dda	2020-07-18	Wales	W11000025	Hywel Dda	1164
2020-07-19,Wales,W11000025,Hywel Dda	2020-07-19	Wales	W11000025	Hywel Dda	1164
2020-07-20,Wales,W11000025,Hywel Dda	2020-07-20	Wales	W11000025	Hywel Dda	1164

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