cases

10 rows where TotalCases = 1147

descending

Link	Date	Country	AreaCode	Area	TotalCases
2020-04-20,England,E10000020,Norfolk	2020-04-20	England	E10000020	Norfolk	1147
2020-05-02,England,E08000030,Walsall	2020-05-02	England	E08000030	Walsall	1147
2020-05-25,England,E09000023,Lewisham	2020-05-25	England	E09000023	Lewisham	1147
2020-06-01,England,E10000027,Somerset	2020-06-01	England	E10000027	Somerset	1147
2020-06-05,England,E08000013,St. Helens	2020-06-05	England	E08000013	St. Helens	1147
2020-06-14,England,E09000010,Enfield	2020-06-14	England	E09000010	Enfield	1147
2020-07-03,Wales,W11000025,Hywel Dda	2020-07-03	Wales	W11000025	Hywel Dda	1147
2020-07-04,Wales,W11000025,Hywel Dda	2020-07-04	Wales	W11000025	Hywel Dda	1147
2020-07-15,England,E06000008,Blackburn with Darwen	2020-07-15	England	E06000008	Blackburn with Darwen	1147
2020-07-21,England,E09000026,Redbridge	2020-07-21	England	E09000026	Redbridge	1147

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