cases

15 rows where TotalCases = 111

descending

Link	Date	Country	AreaCode	Area	TotalCases
2020-03-22,England,E09000010,Enfield	2020-03-22	England	E09000010	Enfield	111
2020-03-22,England,E10000028,Staffordshire	2020-03-22	England	E10000028	Staffordshire	111
2020-03-23,England,E09000025,Newham	2020-03-23	England	E09000025	Newham	111
2020-03-24,England,E10000034,Worcestershire	2020-03-24	England	E10000034	Worcestershire	111
2020-03-26,Scotland,S08000024,Lothian	2020-03-26	Scotland	S08000024	Lothian	111
2020-03-26,Wales,W11000031,Swansea Bay	2020-03-26	Wales	W11000031	Swansea Bay	111
2020-03-31,England,E06000051,Shropshire	2020-03-31	England	E06000051	Shropshire	111
2020-04-03,England,E06000040,Windsor and Maidenhead	2020-04-03	England	E06000040	Windsor and Maidenhead	111
2020-04-04,England,E06000003,Redcar and Cleveland	2020-04-04	England	E06000003	Redcar and Cleveland	111
2020-04-08,England,E06000014,York	2020-04-08	England	E06000014	York	111
2020-04-10,England,E06000031,Peterborough	2020-04-10	England	E06000031	Peterborough	111
2020-04-16,England,E06000027,Torbay	2020-04-16	England	E06000027	Torbay	111
2020-04-16,Northern Ireland,N09000009,Mid Ulster	2020-04-16	Northern Ireland	N09000009	Mid Ulster	111
2020-05-11,Wales,,Outside Wales	2020-05-11	Wales		Outside Wales	111
2020-05-12,Wales,,Outside Wales	2020-05-12	Wales		Outside Wales	111

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