cases

13 rows where TotalCases = 289

descending

Link	Date	Country	AreaCode	Area	TotalCases
2020-03-27,England,E09000015,Harrow	2020-03-27	England	E09000015	Harrow	289
2020-04-01,England,E09000018,Hounslow	2020-04-01	England	E09000018	Hounslow	289
2020-04-04,England,E10000029,Suffolk	2020-04-04	England	E10000029	Suffolk	289
2020-04-06,Wales,W11000023,Betsi Cadwaladr	2020-04-06	Wales	W11000023	Betsi Cadwaladr	289
2020-04-09,England,E08000011,Knowsley	2020-04-09	England	E08000011	Knowsley	289
2020-04-11,England,E09000027,Richmond upon Thames	2020-04-11	England	E09000027	Richmond upon Thames	289
2020-04-22,England,E06000037,West Berkshire	2020-04-22	England	E06000037	West Berkshire	289
2020-04-22,England,E06000059,Dorset	2020-04-22	England	E06000059	Dorset	289
2020-05-15,Northern Ireland,N09000008,Mid and East Antrim	2020-05-15	Northern Ireland	N09000008	Mid and East Antrim	289
2020-06-05,Northern Ireland,N09000010,Newry, Mourne and Down	2020-06-05	Northern Ireland	N09000010	Newry, Mourne and Down	289
2020-06-06,Northern Ireland,N09000010,Newry, Mourne and Down	2020-06-06	Northern Ireland	N09000010	Newry, Mourne and Down	289
2020-06-07,Northern Ireland,N09000010,Newry, Mourne and Down	2020-06-07	Northern Ireland	N09000010	Newry, Mourne and Down	289
2020-06-08,Northern Ireland,N09000010,Newry, Mourne and Down	2020-06-08	Northern Ireland	N09000010	Newry, Mourne and Down	289

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