cases

13 rows where TotalCases = 155

descending

Link	Date	Country	AreaCode	Area	TotalCases
2020-03-28,Wales,W11000031,Swansea Bay	2020-03-28	Wales	W11000031	Swansea Bay	155
2020-03-29,England,E08000026,Coventry	2020-03-29	England	E08000026	Coventry	155
2020-03-30,England,E08000018,Rotherham	2020-03-30	England	E08000018	Rotherham	155
2020-04-02,England,E06000045,Southampton	2020-04-02	England	E06000045	Southampton	155
2020-04-02,England,E08000017,Doncaster	2020-04-02	England	E08000017	Doncaster	155
2020-04-03,England,E06000039,Slough	2020-04-03	England	E06000039	Slough	155
2020-04-06,England,E06000025,South Gloucestershire	2020-04-06	England	E06000025	South Gloucestershire	155
2020-04-06,England,E06000058,Bournemouth, Christchurch and Poole	2020-04-06	England	E06000058	Bournemouth, Christchurch and Poole	155
2020-04-08,Scotland,S08000017,Dumfries and Galloway	2020-04-08	Scotland	S08000017	Dumfries and Galloway	155
2020-04-18,England,E06000019,Herefordshire, County of	2020-04-18	England	E06000019	Herefordshire, County of	155
2020-05-06,Northern Ireland,N09000005,Derry City and Strabane	2020-05-06	Northern Ireland	N09000005	Derry City and Strabane	155
2020-05-07,Northern Ireland,N09000005,Derry City and Strabane	2020-05-07	Northern Ireland	N09000005	Derry City and Strabane	155
2020-05-08,Northern Ireland,N09000005,Derry City and Strabane	2020-05-08	Northern Ireland	N09000005	Derry City and Strabane	155

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