cases

12 rows where TotalCases = 581

descending

Link	Date	Country	AreaCode	Area	TotalCases
2020-03-29,England,E08000019,Sheffield	2020-03-29	England	E08000019	Sheffield	581
2020-04-08,England,E08000003,Manchester	2020-04-08	England	E08000003	Manchester	581
2020-04-16,England,E09000012,Hackney and City of London	2020-04-16	England	E09000012	Hackney and City of London	581
2020-04-17,England,E09000030,Tower Hamlets	2020-04-17	England	E09000030	Tower Hamlets	581
2020-04-17,England,E10000003,Cambridgeshire	2020-04-17	England	E10000003	Cambridgeshire	581
2020-04-18,England,E10000008,Devon	2020-04-18	England	E10000008	Devon	581
2020-04-23,England,E06000018,Nottingham	2020-04-23	England	E06000018	Nottingham	581
2020-04-24,England,E08000029,Solihull	2020-04-24	England	E08000029	Solihull	581
2020-06-14,England,E08000033,Calderdale	2020-06-14	England	E08000033	Calderdale	581
2020-06-16,England,E06000001,Hartlepool	2020-06-16	England	E06000001	Hartlepool	581
2020-06-23,England,E06000041,Wokingham	2020-06-23	England	E06000041	Wokingham	581
2020-06-24,England,E06000020,Telford and Wrekin	2020-06-24	England	E06000020	Telford and Wrekin	581

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