cases

10 rows where TotalCases = 274

descending

Link	Date	Country	AreaCode	Area	TotalCases
2020-03-28,England,E09000033,Westminster	2020-03-28	England	E09000033	Westminster	274
2020-04-01,England,E10000013,Gloucestershire	2020-04-01	England	E10000013	Gloucestershire	274
2020-04-18,England,E06000030,Swindon	2020-04-18	England	E06000030	Swindon	274
2020-04-20,England,E06000059,Dorset	2020-04-20	England	E06000059	Dorset	274
2020-04-21,England,E06000003,Redcar and Cleveland	2020-04-21	England	E06000003	Redcar and Cleveland	274
2020-06-15,Scotland,S08000017,Dumfries and Galloway	2020-06-15	Scotland	S08000017	Dumfries and Galloway	274
2020-06-16,Scotland,S08000017,Dumfries and Galloway	2020-06-16	Scotland	S08000017	Dumfries and Galloway	274
2020-06-17,Scotland,S08000017,Dumfries and Galloway	2020-06-17	Scotland	S08000017	Dumfries and Galloway	274
2020-06-18,Scotland,S08000017,Dumfries and Galloway	2020-06-18	Scotland	S08000017	Dumfries and Galloway	274
2020-07-14,England,E06000027,Torbay	2020-07-14	England	E06000027	Torbay	274

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