cases

9 rows where TotalCases = 866

descending

Link	Date	Country	AreaCode	Area	TotalCases
2020-04-09,Wales,W11000030,Cwm Taf	2020-04-09	Wales	W11000030	Cwm Taf	866
2020-05-01,Scotland,S08000020,Grampian	2020-05-01	Scotland	S08000020	Grampian	866
2020-05-18,England,E06000015,Derby	2020-05-18	England	E06000015	Derby	866
2020-05-19,England,E08000023,South Tyneside	2020-05-19	England	E08000023	South Tyneside	866
2020-05-20,England,E09000016,Havering	2020-05-20	England	E09000016	Havering	866
2020-05-27,England,E06000002,Middlesbrough	2020-05-27	England	E06000002	Middlesbrough	866
2020-06-06,England,E06000024,North Somerset	2020-06-06	England	E06000024	North Somerset	866
2020-07-20,England,E06000042,Milton Keynes	2020-07-20	England	E06000042	Milton Keynes	866
2020-07-21,England,E06000019,Herefordshire, County of	2020-07-21	England	E06000019	Herefordshire, County of	866

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