cases

14 rows where TotalCases = 101

descending

Link	Date	Country	AreaCode	Area	TotalCases
2020-03-20,England,E10000007,Derbyshire	2020-03-20	England	E10000007	Derbyshire	101
2020-03-21,England,E09000006,Bromley	2020-03-21	England	E09000006	Bromley	101
2020-03-22,England,E10000002,Buckinghamshire	2020-03-22	England	E10000002	Buckinghamshire	101
2020-03-27,England,E09000021,Kingston upon Thames	2020-03-27	England	E09000021	Kingston upon Thames	101
2020-03-28,England,E06000016,Leicester	2020-03-28	England	E06000016	Leicester	101
2020-03-28,England,E08000018,Rotherham	2020-03-28	England	E08000018	Rotherham	101
2020-03-31,England,E06000025,South Gloucestershire	2020-03-31	England	E06000025	South Gloucestershire	101
2020-03-31,England,E08000002,Bury	2020-03-31	England	E08000002	Bury	101
2020-04-03,England,E08000023,South Tyneside	2020-04-03	England	E08000023	South Tyneside	101
2020-04-07,England,E06000014,York	2020-04-07	England	E06000014	York	101
2020-04-09,England,E06000013,North Lincolnshire	2020-04-09	England	E06000013	North Lincolnshire	101
2020-04-09,England,E06000024,North Somerset	2020-04-09	England	E06000024	North Somerset	101
2020-04-12,England,E06000027,Torbay	2020-04-12	England	E06000027	Torbay	101
2020-04-14,England,E06000001,Hartlepool	2020-04-14	England	E06000001	Hartlepool	101

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