cases

9 rows where TotalCases = 365

descending

Link	Date	Country	AreaCode	Area	TotalCases
2020-04-01,Wales,W11000030,Cwm Taf	2020-04-01	Wales	W11000030	Cwm Taf	365
2020-04-08,England,E09000013,Hammersmith and Fulham	2020-04-08	England	E09000013	Hammersmith and Fulham	365
2020-04-17,England,E08000023,South Tyneside	2020-04-17	England	E08000023	South Tyneside	365
2020-05-02,England,E06000037,West Berkshire	2020-05-02	England	E06000037	West Berkshire	365
2020-05-04,England,E08000033,Calderdale	2020-05-04	England	E08000033	Calderdale	365
2020-05-21,England,E06000046,Isle of Wight	2020-05-21	England	E06000046	Isle of Wight	365
2020-05-23,Northern Ireland,None,Not Known	2020-05-23	Northern Ireland		Not Known	365
2020-05-27,England,E06000040,Windsor and Maidenhead	2020-05-27	England	E06000040	Windsor and Maidenhead	365
2020-06-12,England,E06000036,Bracknell Forest	2020-06-12	England	E06000036	Bracknell Forest	365

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