cases

16 rows where TotalCases = 295

descending

Link	Date	Country	AreaCode	Area	TotalCases
2020-03-31,England,E09000031,Waltham Forest	2020-03-31	England	E09000031	Waltham Forest	295
2020-04-04,England,E08000015,Wirral	2020-04-04	England	E08000015	Wirral	295
2020-04-04,England,E08000026,Coventry	2020-04-04	England	E08000026	Coventry	295
2020-04-06,England,E09000019,Islington	2020-04-06	England	E09000019	Islington	295
2020-04-14,England,E06000038,Reading	2020-04-14	England	E06000038	Reading	295
2020-04-15,England,E06000043,Brighton and Hove	2020-04-15	England	E06000043	Brighton and Hove	295
2020-04-18,England,E06000041,Wokingham	2020-04-18	England	E06000041	Wokingham	295
2020-04-26,England,E06000019,Herefordshire, County of	2020-04-26	England	E06000019	Herefordshire, County of	295
2020-04-30,England,E06000020,Telford and Wrekin	2020-04-30	England	E06000020	Telford and Wrekin	295
2020-05-11,England,E06000046,Isle of Wight	2020-05-11	England	E06000046	Isle of Wight	295
2020-05-12,England,E06000036,Bracknell Forest	2020-05-12	England	E06000036	Bracknell Forest	295
2020-05-13,Northern Ireland,N09000011,Ards and North Down	2020-05-13	Northern Ireland	N09000011	Ards and North Down	295
2020-05-27,Wales,W11000024,Powys	2020-05-27	Wales	W11000024	Powys	295
2020-07-06,Scotland,S08000017,Dumfries and Galloway	2020-07-06	Scotland	S08000017	Dumfries and Galloway	295
2020-07-07,Scotland,S08000017,Dumfries and Galloway	2020-07-07	Scotland	S08000017	Dumfries and Galloway	295
2020-07-08,Scotland,S08000017,Dumfries and Galloway	2020-07-08	Scotland	S08000017	Dumfries and Galloway	295

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