cases

15 rows where TotalCases = 382

descending

Link	Date	Country	AreaCode	Area	TotalCases
2020-03-25,England,E10000030,Surrey	2020-03-25	England	E10000030	Surrey	382
2020-04-03,England,E08000030,Walsall	2020-04-03	England	E08000030	Walsall	382
2020-04-12,England,E06000015,Derby	2020-04-12	England	E06000015	Derby	382
2020-04-13,England,E06000023,Bristol, City of	2020-04-13	England	E06000023	Bristol, City of	382
2020-04-18,England,E08000023,South Tyneside	2020-04-18	England	E08000023	South Tyneside	382
2020-04-19,England,E06000011,East Riding of Yorkshire	2020-04-19	England	E06000011	East Riding of Yorkshire	382
2020-04-19,England,E06000038,Reading	2020-04-19	England	E06000038	Reading	382
2020-04-21,England,E06000054,Wiltshire	2020-04-21	England	E06000054	Wiltshire	382
2020-04-28,England,E06000006,Halton	2020-04-28	England	E06000006	Halton	382
2020-04-28,England,E06000014,York	2020-04-28	England	E06000014	York	382
2020-05-08,England,E06000037,West Berkshire	2020-05-08	England	E06000037	West Berkshire	382
2020-05-08,Northern Ireland,N09000007,Lisburn and Castlereagh	2020-05-08	Northern Ireland	N09000007	Lisburn and Castlereagh	382
2020-05-09,Northern Ireland,N09000007,Lisburn and Castlereagh	2020-05-09	Northern Ireland	N09000007	Lisburn and Castlereagh	382
2020-05-25,Northern Ireland,N09000001,Antrim and Newtownabbey	2020-05-25	Northern Ireland	N09000001	Antrim and Newtownabbey	382
2020-07-14,England,E06000036,Bracknell Forest	2020-07-14	England	E06000036	Bracknell Forest	382

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