cases

10 rows where TotalCases = 216

descending

Link	Date	Country	AreaCode	Area	TotalCases
2020-03-25,England,E09000006,Bromley	2020-03-25	England	E09000006	Bromley	216
2020-03-25,England,E10000007,Derbyshire	2020-03-25	England	E10000007	Derbyshire	216
2020-04-01,England,E10000023,North Yorkshire	2020-04-01	England	E10000023	North Yorkshire	216
2020-04-02,England,E08000014,Sefton	2020-04-02	England	E08000014	Sefton	216
2020-04-03,Wales,W11000023,Betsi Cadwaladr	2020-04-03	Wales	W11000023	Betsi Cadwaladr	216
2020-04-05,England,E09000021,Kingston upon Thames	2020-04-05	England	E09000021	Kingston upon Thames	216
2020-04-09,England,E06000043,Brighton and Hove	2020-04-09	England	E06000043	Brighton and Hove	216
2020-04-18,England,E08000033,Calderdale	2020-04-18	England	E08000033	Calderdale	216
2020-04-24,England,E06000022,Bath and North East Somerset	2020-04-24	England	E06000022	Bath and North East Somerset	216
2020-05-26,Northern Ireland,N09000004,Causeway Coast and Glens	2020-05-26	Northern Ireland	N09000004	Causeway Coast and Glens	216

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