cases

15 rows where TotalCases = 335

descending

Link	Date	Country	AreaCode	Area	TotalCases
2020-03-29,England,E10000028,Staffordshire	2020-03-29	England	E10000028	Staffordshire	335
2020-04-02,England,E09000024,Merton	2020-04-02	England	E09000024	Merton	335
2020-04-03,England,E10000013,Gloucestershire	2020-04-03	England	E10000013	Gloucestershire	335
2020-04-04,England,E09000007,Camden	2020-04-04	England	E09000007	Camden	335
2020-04-05,England,E06000047,County Durham	2020-04-05	England	E06000047	County Durham	335
2020-04-08,England,E08000009,Trafford	2020-04-08	England	E08000009	Trafford	335
2020-04-09,England,E08000010,Wigan	2020-04-09	England	E08000010	Wigan	335
2020-04-14,Scotland,S08000020,Grampian	2020-04-14	Scotland	S08000020	Grampian	335
2020-05-07,Northern Ireland,N09000001,Antrim and Newtownabbey	2020-05-07	Northern Ireland	N09000001	Antrim and Newtownabbey	335
2020-05-14,England,E06000040,Windsor and Maidenhead	2020-05-14	England	E06000040	Windsor and Maidenhead	335
2020-05-16,England,E06000046,Isle of Wight	2020-05-16	England	E06000046	Isle of Wight	335
2020-05-22,Scotland,S08000022,Highland	2020-05-22	Scotland	S08000022	Highland	335
2020-05-23,Scotland,S08000022,Highland	2020-05-23	Scotland	S08000022	Highland	335
2020-05-24,Scotland,S08000022,Highland	2020-05-24	Scotland	S08000022	Highland	335
2020-05-25,Scotland,S08000022,Highland	2020-05-25	Scotland	S08000022	Highland	335

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