cases

7 rows where TotalCases = 417

descending

Link	Date	Country	AreaCode	Area	TotalCases
2020-03-31,England,E10000028,Staffordshire	2020-03-31	England	E10000028	Staffordshire	417
2020-04-02,England,E10000021,Northamptonshire	2020-04-02	England	E10000021	Northamptonshire	417
2020-04-04,England,E09000033,Westminster	2020-04-04	England	E09000033	Westminster	417
2020-04-06,England,E09000011,Greenwich	2020-04-06	England	E09000011	Greenwich	417
2020-04-13,England,E08000016,Barnsley	2020-04-13	England	E08000016	Barnsley	417
2020-04-19,England,E06000056,Central Bedfordshire	2020-04-19	England	E06000056	Central Bedfordshire	417
2020-06-18,England,E06000046,Isle of Wight	2020-06-18	England	E06000046	Isle of Wight	417

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