cases

10 rows where TotalCases = 1067

descending

Link	Date	Country	AreaCode	Area	TotalCases
2020-03-31,England,E08000025,Birmingham	2020-03-31	England	E08000025	Birmingham	1067
2020-04-14,England,E09000028,Southwark	2020-04-14	England	E09000028	Southwark	1067
2020-04-25,England,E08000015,Wirral	2020-04-25	England	E08000015	Wirral	1067
2020-05-07,England,E08000018,Rotherham	2020-05-07	England	E08000018	Rotherham	1067
2020-05-23,England,E06000021,Stoke-on-Trent	2020-05-23	England	E06000021	Stoke-on-Trent	1067
2020-05-31,Wales,W11000025,Hywel Dda	2020-05-31	Wales	W11000025	Hywel Dda	1067
2020-06-12,England,E09000026,Redbridge	2020-06-12	England	E09000026	Redbridge	1067
2020-07-08,England,E09000018,Hounslow	2020-07-08	England	E09000018	Hounslow	1067
2020-07-10,England,E06000008,Blackburn with Darwen	2020-07-10	England	E06000008	Blackburn with Darwen	1067
2020-07-12,England,E09000004,Bexley	2020-07-12	England	E09000004	Bexley	1067

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