cases

13 rows where TotalCases = 338

descending

Link	Date	Country	AreaCode	Area	TotalCases
2020-03-31,England,E09000033,Westminster	2020-03-31	England	E09000033	Westminster	338
2020-04-01,England,E10000031,Warwickshire	2020-04-01	England	E10000031	Warwickshire	338
2020-04-04,England,E08000024,Sunderland	2020-04-04	England	E08000024	Sunderland	338
2020-04-05,England,E08000015,Wirral	2020-04-05	England	E08000015	Wirral	338
2020-04-10,England,E08000016,Barnsley	2020-04-10	England	E08000016	Barnsley	338
2020-04-18,England,E06000043,Brighton and Hove	2020-04-18	England	E06000043	Brighton and Hove	338
2020-04-28,England,E06000005,Darlington	2020-04-28	England	E06000005	Darlington	338
2020-06-01,Scotland,S08000022,Highland	2020-06-01	Scotland	S08000022	Highland	338
2020-06-02,Scotland,S08000022,Highland	2020-06-02	Scotland	S08000022	Highland	338
2020-06-04,Scotland,S08000022,Highland	2020-06-04	Scotland	S08000022	Highland	338
2020-06-05,Scotland,S08000022,Highland	2020-06-05	Scotland	S08000022	Highland	338
2020-07-09,England,E06000022,Bath and North East Somerset	2020-07-09	England	E06000022	Bath and North East Somerset	338
2020-07-20,Wales,W11000024,Powys	2020-07-20	Wales	W11000024	Powys	338

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