cases

10 rows where Country = "England" and TotalCases = 347

descending

Link	Date	Country	AreaCode	Area	TotalCases
2020-03-27,England,E09000032,Wandsworth	2020-03-27	England	E09000032	Wandsworth	347
2020-03-31,England,E08000012,Liverpool	2020-03-31	England	E08000012	Liverpool	347
2020-04-02,England,E08000028,Sandwell	2020-04-02	England	E08000028	Sandwell	347
2020-04-02,England,E09000031,Waltham Forest	2020-04-02	England	E09000031	Waltham Forest	347
2020-04-03,England,E09000018,Hounslow	2020-04-03	England	E09000018	Hounslow	347
2020-04-14,England,E06000056,Central Bedfordshire	2020-04-14	England	E06000056	Central Bedfordshire	347
2020-04-19,England,E06000051,Shropshire	2020-04-19	England	E06000051	Shropshire	347
2020-04-27,England,E06000003,Redcar and Cleveland	2020-04-27	England	E06000003	Redcar and Cleveland	347
2020-04-29,England,E06000019,Herefordshire, County of	2020-04-29	England	E06000019	Herefordshire, County of	347
2020-05-01,England,E08000033,Calderdale	2020-05-01	England	E08000033	Calderdale	347

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