cases

10 rows where TotalCases = 150

descending

Link	Date	Country	AreaCode	Area	TotalCases
2020-03-19,England,E10000030,Surrey	2020-03-19	England	E10000030	Surrey	150
2020-03-23,England,E09000023,Lewisham	2020-03-23	England	E09000023	Lewisham	150
2020-03-26,England,E09000014,Haringey	2020-03-26	England	E09000014	Haringey	150
2020-03-31,England,E08000004,Oldham	2020-03-31	England	E08000004	Oldham	150
2020-04-05,England,E06000034,Thurrock	2020-04-05	England	E06000034	Thurrock	150
2020-04-06,England,E10000027,Somerset	2020-04-06	England	E10000027	Somerset	150
2020-04-08,Northern Ireland,N09000007,Lisburn and Castlereagh	2020-04-08	Northern Ireland	N09000007	Lisburn and Castlereagh	150
2020-04-12,England,E06000026,Plymouth	2020-04-12	England	E06000026	Plymouth	150
2020-04-18,England,E06000001,Hartlepool	2020-04-18	England	E06000001	Hartlepool	150
2020-05-07,England,E06000012,North East Lincolnshire	2020-05-07	England	E06000012	North East Lincolnshire	150

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