cases

11 rows where TotalCases = 169

descending

Link	Date	Country	AreaCode	Area	TotalCases
2020-03-21,England,E09000032,Wandsworth	2020-03-21	England	E09000032	Wandsworth	169
2020-03-27,England,E09000014,Haringey	2020-03-27	England	E09000014	Haringey	169
2020-03-27,England,E10000021,Northamptonshire	2020-03-27	England	E10000021	Northamptonshire	169
2020-03-29,England,E09000029,Sutton	2020-03-29	England	E09000029	Sutton	169
2020-04-01,England,E06000035,Medway	2020-04-01	England	E06000035	Medway	169
2020-04-01,Wales,W11000025,Hywel Dda	2020-04-01	Wales	W11000025	Hywel Dda	169
2020-04-02,England,E06000018,Nottingham	2020-04-02	England	E06000018	Nottingham	169
2020-04-04,England,E06000039,Slough	2020-04-04	England	E06000039	Slough	169
2020-04-07,England,E06000011,East Riding of Yorkshire	2020-04-07	England	E06000011	East Riding of Yorkshire	169
2020-05-07,Northern Ireland,N09000004,Causeway Coast and Glens	2020-05-07	Northern Ireland	N09000004	Causeway Coast and Glens	169
2020-05-24,England,E06000012,North East Lincolnshire	2020-05-24	England	E06000012	North East Lincolnshire	169

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