cases

6 rows where TotalCases = 455

descending

Link	Date	Country	AreaCode	Area	TotalCases
2020-03-27,England,E08000019,Sheffield	2020-03-27	England	E08000019	Sheffield	455
2020-04-12,England,E09000014,Haringey	2020-04-12	England	E09000014	Haringey	455
2020-04-15,England,E08000009,Trafford	2020-04-15	England	E08000009	Trafford	455
2020-04-22,England,E06000042,Milton Keynes	2020-04-22	England	E06000042	Milton Keynes	455
2020-05-19,England,E06000033,Southend-on-Sea	2020-05-19	England	E06000033	Southend-on-Sea	455
2020-06-27,Northern Ireland,N09000007,Lisburn and Castlereagh	2020-06-27	Northern Ireland	N09000007	Lisburn and Castlereagh	455

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