cases

17 rows where TotalCases = 254

descending

Link	Date	Country	AreaCode	Area	TotalCases
2020-03-27,England,E09000033,Westminster	2020-03-27	England	E09000033	Westminster	254
2020-04-01,Scotland,S08000030,Tayside	2020-04-01	Scotland	S08000030	Tayside	254
2020-04-02,England,E08000026,Coventry	2020-04-02	England	E08000026	Coventry	254
2020-04-04,Scotland,S08000015,Ayrshire and Arran	2020-04-04	Scotland	S08000015	Ayrshire and Arran	254
2020-04-19,England,E06000037,West Berkshire	2020-04-19	England	E06000037	West Berkshire	254
2020-04-25,England,E06000020,Telford and Wrekin	2020-04-25	England	E06000020	Telford and Wrekin	254
2020-04-25,England,E06000024,North Somerset	2020-04-25	England	E06000024	North Somerset	254
2020-04-25,England,E06000040,Windsor and Maidenhead	2020-04-25	England	E06000040	Windsor and Maidenhead	254
2020-05-05,Scotland,S08000017,Dumfries and Galloway	2020-05-05	Scotland	S08000017	Dumfries and Galloway	254
2020-05-06,Scotland,S08000017,Dumfries and Galloway	2020-05-06	Scotland	S08000017	Dumfries and Galloway	254
2020-05-07,Scotland,S08000017,Dumfries and Galloway	2020-05-07	Scotland	S08000017	Dumfries and Galloway	254
2020-05-13,England,E06000027,Torbay	2020-05-13	England	E06000027	Torbay	254
2020-05-13,Scotland,S08000017,Dumfries and Galloway	2020-05-13	Scotland	S08000017	Dumfries and Galloway	254
2020-05-14,Northern Ireland,N09000010,Newry, Mourne and Down	2020-05-14	Northern Ireland	N09000010	Newry, Mourne and Down	254
2020-05-15,Northern Ireland,N09000010,Newry, Mourne and Down	2020-05-15	Northern Ireland	N09000010	Newry, Mourne and Down	254
2020-05-16,Northern Ireland,N09000010,Newry, Mourne and Down	2020-05-16	Northern Ireland	N09000010	Newry, Mourne and Down	254
2020-05-17,Northern Ireland,N09000010,Newry, Mourne and Down	2020-05-17	Northern Ireland	N09000010	Newry, Mourne and Down	254

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