cases

10 rows where TotalCases = 213

descending

Link	Date	Country	AreaCode	Area	TotalCases
2020-03-20,England,E08000025,Birmingham	2020-03-20	England	E08000025	Birmingham	213
2020-03-21,England,E10000014,Hampshire	2020-03-21	England	E10000014	Hampshire	213
2020-03-28,England,E10000034,Worcestershire	2020-03-28	England	E10000034	Worcestershire	213
2020-03-31,England,E09000013,Hammersmith and Fulham	2020-03-31	England	E09000013	Hammersmith and Fulham	213
2020-04-03,England,E08000032,Bradford	2020-04-03	England	E08000032	Bradford	213
2020-04-04,England,E06000023,Bristol, City of	2020-04-04	England	E06000023	Bristol, City of	213
2020-04-25,England,E06000027,Torbay	2020-04-25	England	E06000027	Torbay	213
2020-05-25,Northern Ireland,N09000004,Causeway Coast and Glens	2020-05-25	Northern Ireland	N09000004	Causeway Coast and Glens	213
2020-07-20,England,E06000012,North East Lincolnshire	2020-07-20	England	E06000012	North East Lincolnshire	213
2020-07-25,England,E06000012,North East Lincolnshire	2020-07-25	England	E06000012	North East Lincolnshire	213

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