cases

38 rows where TotalCases = 22

descending

Link	Date	Country	AreaCode	Area	TotalCases
2020-03-11,England,E09000009,Ealing	2020-03-11	England	E09000009	Ealing	22
2020-03-11,England,E10000008,Devon	2020-03-11	England	E10000008	Devon	22
2020-03-12,England,E08000025,Birmingham	2020-03-12	England	E08000025	Birmingham	22
2020-03-13,England,E06000039,Slough	2020-03-13	England	E06000039	Slough	22
2020-03-14,England,E09000018,Hounslow	2020-03-14	England	E09000018	Hounslow	22
2020-03-14,England,E09000030,Tower Hamlets	2020-03-14	England	E09000030	Tower Hamlets	22
2020-03-15,England,E08000030,Walsall	2020-03-15	England	E08000030	Walsall	22
2020-03-16,England,E10000034,Worcestershire	2020-03-16	England	E10000034	Worcestershire	22
2020-03-17,England,E08000028,Sandwell	2020-03-17	England	E08000028	Sandwell	22
2020-03-17,England,E09000031,Waltham Forest	2020-03-17	England	E09000031	Waltham Forest	22
2020-03-18,England,E06000023,Bristol, City of	2020-03-18	England	E06000023	Bristol, City of	22
2020-03-18,England,E06000054,Wiltshire	2020-03-18	England	E06000054	Wiltshire	22
2020-03-18,England,E08000008,Tameside	2020-03-18	England	E08000008	Tameside	22
2020-03-18,England,E08000021,Newcastle upon Tyne	2020-03-18	England	E08000021	Newcastle upon Tyne	22
2020-03-18,England,E08000035,Leeds	2020-03-18	England	E08000035	Leeds	22
2020-03-19,England,E08000004,Oldham	2020-03-19	England	E08000004	Oldham	22
2020-03-19,England,E10000023,North Yorkshire	2020-03-19	England	E10000023	North Yorkshire	22
2020-03-21,England,E08000016,Barnsley	2020-03-21	England	E08000016	Barnsley	22
2020-03-22,England,E06000034,Thurrock	2020-03-22	England	E06000034	Thurrock	22
2020-03-22,England,E06000037,West Berkshire	2020-03-22	England	E06000037	West Berkshire	22
2020-03-22,England,E10000027,Somerset	2020-03-22	England	E10000027	Somerset	22
2020-03-23,Wales,W11000023,Betsi Cadwaladr	2020-03-23	Wales	W11000023	Betsi Cadwaladr	22
2020-03-24,England,E06000058,Bournemouth, Christchurch and Poole	2020-03-24	England	E06000058	Bournemouth, Christchurch and Poole	22
2020-03-25,England,E06000027,Torbay	2020-03-25	England	E06000027	Torbay	22
2020-03-25,England,E06000030,Swindon	2020-03-25	England	E06000030	Swindon	22
2020-03-25,England,E06000031,Peterborough	2020-03-25	England	E06000031	Peterborough	22
2020-03-25,Scotland,S08000022,Highland	2020-03-25	Scotland	S08000022	Highland	22
2020-03-26,England,E06000007,Warrington	2020-03-26	England	E06000007	Warrington	22
2020-03-26,Northern Ireland,N09000002,Armagh, Banbridge and Craigavon	2020-03-26	Northern Ireland	N09000002	Armagh, Banbridge and Craigavon	22
2020-03-26,Northern Ireland,N09000011,North Down and Ards	2020-03-26	Northern Ireland	N09000011	North Down and Ards	22
2020-03-27,Wales,,Unknown	2020-03-27	Wales		Unknown	22
2020-03-28,England,E06000008,Blackburn with Darwen	2020-03-28	England	E06000008	Blackburn with Darwen	22
2020-03-28,England,E06000012,North East Lincolnshire	2020-03-28	England	E06000012	North East Lincolnshire	22
2020-03-28,Wales,,Unknown	2020-03-28	Wales		Unknown	22
2020-03-28,Wales,W11000024,Powys	2020-03-28	Wales	W11000024	Powys	22
2020-03-30,Northern Ireland,None,Unknown	2020-03-30	Northern Ireland		Unknown	22
2020-04-10,Northern Ireland,None,Unknown	2020-04-10	Northern Ireland		Unknown	22
2020-04-23,England,E06000017,Rutland	2020-04-23	England	E06000017	Rutland	22

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