cases

9 rows where TotalCases = 397

descending

Link	Date	Country	AreaCode	Area	TotalCases
2020-03-29,Wales,W11000029,Cardiff and Vale	2020-03-29	Wales	W11000029	Cardiff and Vale	397
2020-04-04,England,E08000028,Sandwell	2020-04-04	England	E08000028	Sandwell	397
2020-04-08,England,E09000029,Sutton	2020-04-08	England	E09000029	Sutton	397
2020-04-09,England,E08000032,Bradford	2020-04-09	England	E08000032	Bradford	397
2020-04-14,Scotland,S08000029,Fife	2020-04-14	Scotland	S08000029	Fife	397
2020-04-19,England,E08000023,South Tyneside	2020-04-19	England	E08000023	South Tyneside	397
2020-05-02,England,E06000024,North Somerset	2020-05-02	England	E06000024	North Somerset	397
2020-05-05,Northern Ireland,N09000002,Armagh City, Banbridge and Craigavon	2020-05-05	Northern Ireland	N09000002	Armagh City, Banbridge and Craigavon	397
2020-06-23,England,E06000040,Windsor and Maidenhead	2020-06-23	England	E06000040	Windsor and Maidenhead	397

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