cases

11 rows where Country = "England" and TotalCases = 135

descending

Link	Date	Country	AreaCode	Area	TotalCases
2020-03-18,England,E10000014,Hampshire	2020-03-18	England	E10000014	Hampshire	135
2020-03-24,England,E10000031,Warwickshire	2020-03-24	England	E10000031	Warwickshire	135
2020-03-27,England,E10000003,Cambridgeshire	2020-03-27	England	E10000003	Cambridgeshire	135
2020-03-29,England,E09000016,Havering	2020-03-29	England	E09000016	Havering	135
2020-04-01,England,E06000057,Northumberland	2020-04-01	England	E06000057	Northumberland	135
2020-04-01,England,E08000037,Gateshead	2020-04-01	England	E08000037	Gateshead	135
2020-04-04,England,E06000025,South Gloucestershire	2020-04-04	England	E06000025	South Gloucestershire	135
2020-04-05,England,E06000058,Bournemouth, Christchurch and Poole	2020-04-05	England	E06000058	Bournemouth, Christchurch and Poole	135
2020-04-05,England,E06000059,Dorset	2020-04-05	England	E06000059	Dorset	135
2020-04-13,England,E06000013,North Lincolnshire	2020-04-13	England	E06000013	North Lincolnshire	135
2020-04-16,England,E06000024,North Somerset	2020-04-16	England	E06000024	North Somerset	135

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