cases

10 rows where TotalCases = 211

descending

Link	Date	Country	AreaCode	Area	TotalCases
2020-03-28,England,E09000024,Merton	2020-03-28	England	E09000024	Merton	211
2020-03-29,England,E09000018,Hounslow	2020-03-29	England	E09000018	Hounslow	211
2020-03-29,England,E10000021,Northamptonshire	2020-03-29	England	E10000021	Northamptonshire	211
2020-03-31,England,E06000015,Derby	2020-03-31	England	E06000015	Derby	211
2020-03-31,England,E09000029,Sutton	2020-03-31	England	E09000029	Sutton	211
2020-04-03,Wales,W11000025,Hywel Dda	2020-04-03	Wales	W11000025	Hywel Dda	211
2020-04-05,England,E06000018,Nottingham	2020-04-05	England	E06000018	Nottingham	211
2020-04-10,England,E06000025,South Gloucestershire	2020-04-10	England	E06000025	South Gloucestershire	211
2020-04-22,Scotland,S08000022,Highland	2020-04-22	Scotland	S08000022	Highland	211
2020-05-20,Northern Ireland,N09000009,Mid Ulster	2020-05-20	Northern Ireland	N09000009	Mid Ulster	211

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