cases

10 rows where TotalCases = 106

descending

Link	Date	Country	AreaCode	Area	TotalCases
2020-03-17,Wales,W11000028,Aneurin Bevan	2020-03-17	Wales	W11000028	Aneurin Bevan	106
2020-03-19,England,E08000019,Sheffield	2020-03-19	England	E08000019	Sheffield	106
2020-03-24,England,E08000030,Walsall	2020-03-24	England	E08000030	Walsall	106
2020-03-24,England,E09000030,Tower Hamlets	2020-03-24	England	E09000030	Tower Hamlets	106
2020-03-28,England,E08000009,Trafford	2020-03-28	England	E08000009	Trafford	106
2020-03-29,England,E08000032,Bradford	2020-03-29	England	E08000032	Bradford	106
2020-03-30,England,E06000052,Cornwall and Isles of Scilly	2020-03-30	England	E06000052	Cornwall and Isles of Scilly	106
2020-04-03,England,E06000044,Portsmouth	2020-04-03	England	E06000044	Portsmouth	106
2020-04-08,England,E06000036,Bracknell Forest	2020-04-08	England	E06000036	Bracknell Forest	106
2020-04-15,Northern Ireland,N09000009,Mid Ulster	2020-04-15	Northern Ireland	N09000009	Mid Ulster	106

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