cases

19 rows where TotalCases = 46

descending

Link	Date	Country	AreaCode	Area	TotalCases
2020-03-15,England,E09000005,Brent	2020-03-15	England	E09000005	Brent	46
2020-03-16,England,E10000016,Kent	2020-03-16	England	E10000016	Kent	46
2020-03-17,England,E09000011,Greenwich	2020-03-17	England	E09000011	Greenwich	46
2020-03-17,England,E10000025,Oxfordshire	2020-03-17	England	E10000025	Oxfordshire	46
2020-03-22,England,E08000003,Manchester	2020-03-22	England	E08000003	Manchester	46
2020-03-22,England,E10000029,Suffolk	2020-03-22	England	E10000029	Suffolk	46
2020-03-22,Scotland,S08000024,Lothian	2020-03-22	Scotland	S08000024	Lothian	46
2020-03-23,England,E06000040,Windsor and Maidenhead	2020-03-23	England	E06000040	Windsor and Maidenhead	46
2020-03-23,England,E08000004,Oldham	2020-03-23	England	E08000004	Oldham	46
2020-03-24,England,E10000011,East Sussex	2020-03-24	England	E10000011	East Sussex	46
2020-03-25,England,E08000017,Doncaster	2020-03-25	England	E08000017	Doncaster	46
2020-03-26,England,E08000010,Wigan	2020-03-26	England	E08000010	Wigan	46
2020-03-30,England,E06000031,Peterborough	2020-03-30	England	E06000031	Peterborough	46
2020-03-31,England,E06000008,Blackburn with Darwen	2020-03-31	England	E06000008	Blackburn with Darwen	46
2020-04-03,Northern Ireland,N09000008,Mid and East Antrim	2020-04-03	Northern Ireland	N09000008	Mid and East Antrim	46
2020-04-08,Wales,,Outside Wales	2020-04-08	Wales		Outside Wales	46
2020-04-09,England,E06000046,Isle of Wight	2020-04-09	England	E06000046	Isle of Wight	46
2020-04-09,Wales,,Outside Wales	2020-04-09	Wales		Outside Wales	46
2020-05-11,England,E06000017,Rutland	2020-05-11	England	E06000017	Rutland	46

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