cases

10 rows where TotalCases = 418

descending

Link	Date	Country	AreaCode	Area	TotalCases
2020-03-31,England,E10000007,Derbyshire	2020-03-31	England	E10000007	Derbyshire	418
2020-04-10,England,E08000032,Bradford	2020-04-10	England	E08000032	Bradford	418
2020-04-11,England,E08000026,Coventry	2020-04-11	England	E08000026	Coventry	418
2020-04-14,England,E08000013,St. Helens	2020-04-14	England	E08000013	St. Helens	418
2020-04-16,England,E06000015,Derby	2020-04-16	England	E06000015	Derby	418
2020-04-28,England,E06000030,Swindon	2020-04-28	England	E06000030	Swindon	418
2020-04-28,England,E06000039,Slough	2020-04-28	England	E06000039	Slough	418
2020-05-10,England,E06000001,Hartlepool	2020-05-10	England	E06000001	Hartlepool	418
2020-05-19,Northern Ireland,N09000007,Lisburn and Castlereagh	2020-05-19	Northern Ireland	N09000007	Lisburn and Castlereagh	418
2020-06-22,England,E06000046,Isle of Wight	2020-06-22	England	E06000046	Isle of Wight	418

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