cases

16 rows where TotalCases = 94

descending

Link	Date	Country	AreaCode	Area	TotalCases
2020-03-17,England,E08000025,Birmingham	2020-03-17	England	E08000025	Birmingham	94
2020-03-17,England,E10000030,Surrey	2020-03-17	England	E10000030	Surrey	94
2020-03-22,England,E09000014,Haringey	2020-03-22	England	E09000014	Haringey	94
2020-03-23,England,E10000034,Worcestershire	2020-03-23	England	E10000034	Worcestershire	94
2020-03-27,England,E06000023,Bristol, City of	2020-03-27	England	E06000023	Bristol, City of	94
2020-03-28,England,E06000047,County Durham	2020-03-28	England	E06000047	County Durham	94
2020-03-28,Scotland,S08000019,Forth Valley	2020-03-28	Scotland	S08000019	Forth Valley	94
2020-03-29,England,E06000050,Cheshire West and Chester	2020-03-29	England	E06000050	Cheshire West and Chester	94
2020-03-29,England,E08000017,Doncaster	2020-03-29	England	E08000017	Doncaster	94
2020-03-29,Scotland,S08000019,Forth Valley	2020-03-29	Scotland	S08000019	Forth Valley	94
2020-03-30,England,E08000002,Bury	2020-03-30	England	E08000002	Bury	94
2020-03-31,England,E06000040,Windsor and Maidenhead	2020-03-31	England	E06000040	Windsor and Maidenhead	94
2020-04-04,England,E08000033,Calderdale	2020-04-04	England	E08000033	Calderdale	94
2020-04-23,England,E06000046,Isle of Wight	2020-04-23	England	E06000046	Isle of Wight	94
2020-04-30,Wales,,Outside Wales	2020-04-30	Wales		Outside Wales	94
2020-07-15,England,E06000017,Rutland	2020-07-15	England	E06000017	Rutland	94

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