cases

7 rows where TotalCases = 473

descending

Link	Date	Country	AreaCode	Area	TotalCases
2020-04-03,England,E10000021,Northamptonshire	2020-04-03	England	E10000021	Northamptonshire	473
2020-04-12,England,E08000037,Gateshead	2020-04-12	England	E08000037	Gateshead	473
2020-04-25,England,E06000038,Reading	2020-04-25	England	E06000038	Reading	473
2020-05-02,England,E06000039,Slough	2020-05-02	England	E06000039	Slough	473
2020-05-08,England,E06000006,Halton	2020-05-08	England	E06000006	Halton	473
2020-05-20,England,E06000020,Telford and Wrekin	2020-05-20	England	E06000020	Telford and Wrekin	473
2020-06-30,England,E06000037,West Berkshire	2020-06-30	England	E06000037	West Berkshire	473

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