cases

17 rows where TotalCases = 93

descending

Link	Date	Country	AreaCode	Area	TotalCases
2020-03-20,England,E10000016,Kent	2020-03-20	England	E10000016	Kent	93
2020-03-21,England,E09000010,Enfield	2020-03-21	England	E09000010	Enfield	93
2020-03-25,England,E09000002,Barking and Dagenham	2020-03-25	England	E09000002	Barking and Dagenham	93
2020-03-26,England,E06000039,Slough	2020-03-26	England	E06000039	Slough	93
2020-03-26,England,E10000008,Devon	2020-03-26	England	E10000008	Devon	93
2020-03-27,England,E08000009,Trafford	2020-03-27	England	E08000009	Trafford	93
2020-03-28,England,E08000014,Sefton	2020-03-28	England	E08000014	Sefton	93
2020-03-28,Wales,W11000025,Hywel Dda	2020-03-28	Wales	W11000025	Hywel Dda	93
2020-03-29,England,E06000051,Shropshire	2020-03-29	England	E06000051	Shropshire	93
2020-03-31,England,E06000034,Thurrock	2020-03-31	England	E06000034	Thurrock	93
2020-04-02,England,E06000011,East Riding of Yorkshire	2020-04-02	England	E06000011	East Riding of Yorkshire	93
2020-04-02,Scotland,S08000016,Borders	2020-04-02	Scotland	S08000016	Borders	93
2020-04-05,England,E06000008,Blackburn with Darwen	2020-04-05	England	E06000008	Blackburn with Darwen	93
2020-04-09,England,E06000027,Torbay	2020-04-09	England	E06000027	Torbay	93
2020-04-13,England,E06000001,Hartlepool	2020-04-13	England	E06000001	Hartlepool	93
2020-04-29,Wales,,Outside Wales	2020-04-29	Wales		Outside Wales	93
2020-07-11,England,E06000017,Rutland	2020-07-11	England	E06000017	Rutland	93

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