cases

12 rows where TotalCases = 1158

descending

Link	Date	Country	AreaCode	Area	TotalCases
2020-05-20,England,E08000027,Dudley	2020-05-20	England	E08000027	Dudley	1158
2020-05-28,England,E06000021,Stoke-on-Trent	2020-05-28	England	E06000021	Stoke-on-Trent	1158
2020-05-31,England,E09000023,Lewisham	2020-05-31	England	E09000023	Lewisham	1158
2020-06-01,England,E06000051,Shropshire	2020-06-01	England	E06000051	Shropshire	1158
2020-06-04,England,E06000032,Luton	2020-06-04	England	E06000032	Luton	1158
2020-06-06,England,E08000009,Trafford	2020-06-06	England	E08000009	Trafford	1158
2020-06-29,England,E06000018,Nottingham	2020-06-29	England	E06000018	Nottingham	1158
2020-07-08,England,E09000032,Wandsworth	2020-07-08	England	E09000032	Wandsworth	1158
2020-07-08,Wales,W11000025,Hywel Dda	2020-07-08	Wales	W11000025	Hywel Dda	1158
2020-07-09,Wales,W11000025,Hywel Dda	2020-07-09	Wales	W11000025	Hywel Dda	1158
2020-07-10,Wales,W11000025,Hywel Dda	2020-07-10	Wales	W11000025	Hywel Dda	1158
2020-07-11,Wales,W11000025,Hywel Dda	2020-07-11	Wales	W11000025	Hywel Dda	1158

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