cases

20 rows where TotalCases = 74

descending

Link	Date	Country	AreaCode	Area	TotalCases
2020-03-17,England,E09000008,Croydon	2020-03-17	England	E09000008	Croydon	74
2020-03-19,England,E09000024,Merton	2020-03-19	England	E09000024	Merton	74
2020-03-19,England,E10000012,Essex	2020-03-19	England	E10000012	Essex	74
2020-03-21,England,E09000012,Hackney and City of London	2020-03-21	England	E09000012	Hackney and City of London	74
2020-03-25,England,E08000007,Stockport	2020-03-25	England	E08000007	Stockport	74
2020-03-26,Scotland,S08000015,Ayrshire and Arran	2020-03-26	Scotland	S08000015	Ayrshire and Arran	74
2020-03-27,England,E06000052,Cornwall and Isles of Scilly	2020-03-27	England	E06000052	Cornwall and Isles of Scilly	74
2020-03-28,England,E06000040,Windsor and Maidenhead	2020-03-28	England	E06000040	Windsor and Maidenhead	74
2020-03-28,England,E08000034,Kirklees	2020-03-28	England	E08000034	Kirklees	74
2020-03-30,Scotland,S08000017,Dumfries and Galloway	2020-03-30	Scotland	S08000017	Dumfries and Galloway	74
2020-04-01,England,E06000003,Redcar and Cleveland	2020-04-01	England	E06000003	Redcar and Cleveland	74
2020-04-02,England,E08000033,Calderdale	2020-04-02	England	E08000033	Calderdale	74
2020-04-03,England,E06000009,Blackpool	2020-04-03	England	E06000009	Blackpool	74
2020-04-03,England,E06000030,Swindon	2020-04-03	England	E06000030	Swindon	74
2020-04-04,England,E06000014,York	2020-04-04	England	E06000014	York	74
2020-04-07,England,E06000013,North Lincolnshire	2020-04-07	England	E06000013	North Lincolnshire	74
2020-04-19,England,E06000046,Isle of Wight	2020-04-19	England	E06000046	Isle of Wight	74
2020-05-06,Northern Ireland,N09000006,Fermanagh and Omagh	2020-05-06	Northern Ireland	N09000006	Fermanagh and Omagh	74
2020-05-17,Wales,,Unknown	2020-05-17	Wales		Unknown	74
2020-05-29,England,E06000017,Rutland	2020-05-29	England	E06000017	Rutland	74

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