cases

16 rows where TotalCases = 313

descending

Link	Date	Country	AreaCode	Area	TotalCases
2020-04-02,England,E09000011,Greenwich	2020-04-02	England	E09000011	Greenwich	313
2020-04-06,England,E06000050,Cheshire West and Chester	2020-04-06	England	E06000050	Cheshire West and Chester	313
2020-04-09,England,E08000016,Barnsley	2020-04-09	England	E08000016	Barnsley	313
2020-04-13,Scotland,S08000020,Grampian	2020-04-13	Scotland	S08000020	Grampian	313
2020-04-24,England,E06000013,North Lincolnshire	2020-04-24	England	E06000013	North Lincolnshire	313
2020-05-05,Northern Ireland,None,Not Known	2020-05-05	Northern Ireland		Not Known	313
2020-05-07,Scotland,S08000022,Highland	2020-05-07	Scotland	S08000022	Highland	313
2020-05-17,Scotland,S08000016,Borders	2020-05-17	Scotland	S08000016	Borders	313
2020-06-06,Wales,W11000024,Powys	2020-06-06	Wales	W11000024	Powys	313
2020-06-07,Wales,W11000024,Powys	2020-06-07	Wales	W11000024	Powys	313
2020-06-08,Wales,W11000024,Powys	2020-06-08	Wales	W11000024	Powys	313
2020-06-09,Wales,W11000024,Powys	2020-06-09	Wales	W11000024	Powys	313
2020-06-10,Wales,W11000024,Powys	2020-06-10	Wales	W11000024	Powys	313
2020-06-11,Wales,W11000024,Powys	2020-06-11	Wales	W11000024	Powys	313
2020-06-12,Wales,W11000024,Powys	2020-06-12	Wales	W11000024	Powys	313
2020-06-13,Wales,W11000024,Powys	2020-06-13	Wales	W11000024	Powys	313

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