cases

6 rows where TotalCases = 264

descending

Link	Date	Country	AreaCode	Area	TotalCases
2020-03-27,England,E10000007,Derbyshire	2020-03-27	England	E10000007	Derbyshire	264
2020-03-30,England,E09000010,Enfield	2020-03-30	England	E09000010	Enfield	264
2020-03-30,England,E10000021,Northamptonshire	2020-03-30	England	E10000021	Northamptonshire	264
2020-03-31,England,E09000012,Hackney and City of London	2020-03-31	England	E09000012	Hackney and City of London	264
2020-04-08,England,E09000027,Richmond upon Thames	2020-04-08	England	E09000027	Richmond upon Thames	264
2020-05-25,England,E06000027,Torbay	2020-05-25	England	E06000027	Torbay	264

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