cases

9 rows where "Date" is on date 2020-03-14 and TotalCases = 10

descending

Link	Date	Country	AreaCode	Area	TotalCases
2020-03-14,England,E06000023,Bristol, City of	2020-03-14	England	E06000023	Bristol, City of	10
2020-03-14,England,E06000049,Cheshire East	2020-03-14	England	E06000049	Cheshire East	10
2020-03-14,England,E06000052,Cornwall and Isles of Scilly	2020-03-14	England	E06000052	Cornwall and Isles of Scilly	10
2020-03-14,England,E08000004,Oldham	2020-03-14	England	E08000004	Oldham	10
2020-03-14,England,E10000020,Norfolk	2020-03-14	England	E10000020	Norfolk	10
2020-03-14,England,E10000029,Suffolk	2020-03-14	England	E10000029	Suffolk	10
2020-03-14,Scotland,S08000032,Lanarkshire	2020-03-14	Scotland	S08000032	Lanarkshire	10
2020-03-14,Wales,W11000025,Hywel Dda	2020-03-14	Wales	W11000025	Hywel Dda	10
2020-03-14,Wales,W11000029,Cardiff and Vale	2020-03-14	Wales	W11000029	Cardiff and Vale	10

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