cases

12 rows where TotalCases = 161

descending

Link	Date	Country	AreaCode	Area	TotalCases
2020-03-19,England,E08000025,Birmingham	2020-03-19	England	E08000025	Birmingham	161
2020-03-21,England,E09000005,Brent	2020-03-21	England	E09000005	Brent	161
2020-03-24,England,E10000017,Lancashire	2020-03-24	England	E10000017	Lancashire	161
2020-03-26,England,E09000011,Greenwich	2020-03-26	England	E09000011	Greenwich	161
2020-03-26,England,E09000018,Hounslow	2020-03-26	England	E09000018	Hounslow	161
2020-03-30,England,E09000027,Richmond upon Thames	2020-03-30	England	E09000027	Richmond upon Thames	161
2020-04-01,England,E06000049,Cheshire East	2020-04-01	England	E06000049	Cheshire East	161
2020-04-01,Wales,W11000023,Betsi Cadwaladr	2020-04-01	Wales	W11000023	Betsi Cadwaladr	161
2020-04-02,England,E08000010,Wigan	2020-04-02	England	E08000010	Wigan	161
2020-04-15,England,E06000036,Bracknell Forest	2020-04-15	England	E06000036	Bracknell Forest	161
2020-04-28,England,E06000046,Isle of Wight	2020-04-28	England	E06000046	Isle of Wight	161
2020-05-16,England,E06000012,North East Lincolnshire	2020-05-16	England	E06000012	North East Lincolnshire	161

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