cases

15 rows where TotalCases = 337

descending

Link	Date	Country	AreaCode	Area	TotalCases
2020-04-09,England,E09000002,Barking and Dagenham	2020-04-09	England	E09000002	Barking and Dagenham	337
2020-04-10,England,E09000019,Islington	2020-04-10	England	E09000019	Islington	337
2020-04-12,Scotland,S08000019,Forth Valley	2020-04-12	Scotland	S08000019	Forth Valley	337
2020-04-13,England,E08000022,North Tyneside	2020-04-13	England	E08000022	North Tyneside	337
2020-04-13,England,E09000021,Kingston upon Thames	2020-04-13	England	E09000021	Kingston upon Thames	337
2020-04-16,England,E09000027,Richmond upon Thames	2020-04-16	England	E09000027	Richmond upon Thames	337
2020-04-17,England,E06000055,Bedford	2020-04-17	England	E06000055	Bedford	337
2020-04-30,England,E06000033,Southend-on-Sea	2020-04-30	England	E06000033	Southend-on-Sea	337
2020-05-22,Northern Ireland,N09000011,Ards and North Down	2020-05-22	Northern Ireland	N09000011	Ards and North Down	337
2020-05-27,Scotland,S08000022,Highland	2020-05-27	Scotland	S08000022	Highland	337
2020-05-28,Scotland,S08000022,Highland	2020-05-28	Scotland	S08000022	Highland	337
2020-05-29,Scotland,S08000022,Highland	2020-05-29	Scotland	S08000022	Highland	337
2020-05-30,Scotland,S08000022,Highland	2020-05-30	Scotland	S08000022	Highland	337
2020-05-31,Scotland,S08000022,Highland	2020-05-31	Scotland	S08000022	Highland	337
2020-07-08,England,E06000022,Bath and North East Somerset	2020-07-08	England	E06000022	Bath and North East Somerset	337

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