cases

27 rows where TotalCases = 78

descending

Link	Date	Country	AreaCode	Area	TotalCases
2020-03-16,England,E09000032,Wandsworth	2020-03-16	England	E09000032	Wandsworth	78
2020-03-20,England,E09000011,Greenwich	2020-03-20	England	E09000011	Greenwich	78
2020-03-20,England,E10000002,Buckinghamshire	2020-03-20	England	E10000002	Buckinghamshire	78
2020-03-23,England,E09000029,Sutton	2020-03-23	England	E09000029	Sutton	78
2020-03-25,England,E08000006,Salford	2020-03-25	England	E08000006	Salford	78
2020-03-25,England,E10000008,Devon	2020-03-25	England	E10000008	Devon	78
2020-03-26,England,E08000029,Solihull	2020-03-26	England	E08000029	Solihull	78
2020-03-27,England,E06000049,Cheshire East	2020-03-27	England	E06000049	Cheshire East	78
2020-03-28,England,E06000044,Portsmouth	2020-03-28	England	E06000044	Portsmouth	78
2020-03-28,England,E08000017,Doncaster	2020-03-28	England	E08000017	Doncaster	78
2020-03-29,England,E08000002,Bury	2020-03-29	England	E08000002	Bury	78
2020-03-30,England,E06000041,Wokingham	2020-03-30	England	E06000041	Wokingham	78
2020-03-30,England,E06000057,Northumberland	2020-03-30	England	E06000057	Northumberland	78
2020-04-02,England,E06000006,Halton	2020-04-02	England	E06000006	Halton	78
2020-04-02,England,E06000026,Plymouth	2020-04-02	England	E06000026	Plymouth	78
2020-04-05,England,E06000014,York	2020-04-05	England	E06000014	York	78
2020-04-06,England,E06000005,Darlington	2020-04-06	England	E06000005	Darlington	78
2020-04-07,Northern Ireland,N09000001,Antrim and Newtownabbey	2020-04-07	Northern Ireland	N09000001	Antrim and Newtownabbey	78
2020-04-11,England,E06000012,North East Lincolnshire	2020-04-11	England	E06000012	North East Lincolnshire	78
2020-05-12,Northern Ireland,N09000006,Fermanagh and Omagh	2020-05-12	Northern Ireland	N09000006	Fermanagh and Omagh	78
2020-05-13,Northern Ireland,N09000006,Fermanagh and Omagh	2020-05-13	Northern Ireland	N09000006	Fermanagh and Omagh	78
2020-05-14,Northern Ireland,N09000006,Fermanagh and Omagh	2020-05-14	Northern Ireland	N09000006	Fermanagh and Omagh	78
2020-05-15,Northern Ireland,N09000006,Fermanagh and Omagh	2020-05-15	Northern Ireland	N09000006	Fermanagh and Omagh	78
2020-05-16,Northern Ireland,N09000006,Fermanagh and Omagh	2020-05-16	Northern Ireland	N09000006	Fermanagh and Omagh	78
2020-05-17,Northern Ireland,N09000006,Fermanagh and Omagh	2020-05-17	Northern Ireland	N09000006	Fermanagh and Omagh	78
2020-05-18,Northern Ireland,N09000006,Fermanagh and Omagh	2020-05-18	Northern Ireland	N09000006	Fermanagh and Omagh	78
2020-06-01,England,E06000017,Rutland	2020-06-01	England	E06000017	Rutland	78

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