cases

28 rows where TotalCases = 55

descending

Link	Date	Country	AreaCode	Area	TotalCases
2020-03-14,England,E09000020,Kensington and Chelsea	2020-03-14	England	E09000020	Kensington and Chelsea	55
2020-03-14,England,E09000022,Lambeth	2020-03-14	England	E09000022	Lambeth	55
2020-03-15,England,E08000025,Birmingham	2020-03-15	England	E08000025	Birmingham	55
2020-03-17,England,E10000012,Essex	2020-03-17	England	E10000012	Essex	55
2020-03-18,England,E09000018,Hounslow	2020-03-18	England	E09000018	Hounslow	55
2020-03-19,England,E09000012,Hackney and City of London	2020-03-19	England	E09000012	Hackney and City of London	55
2020-03-20,England,E09000026,Redbridge	2020-03-20	England	E09000026	Redbridge	55
2020-03-20,England,E09000031,Waltham Forest	2020-03-20	England	E09000031	Waltham Forest	55
2020-03-21,England,E09000004,Bexley	2020-03-21	England	E09000004	Bexley	55
2020-03-23,England,E08000007,Stockport	2020-03-23	England	E08000007	Stockport	55
2020-03-24,England,E06000054,Wiltshire	2020-03-24	England	E06000054	Wiltshire	55
2020-03-26,England,E08000015,Wirral	2020-03-26	England	E08000015	Wirral	55
2020-03-26,England,E08000017,Doncaster	2020-03-26	England	E08000017	Doncaster	55
2020-03-26,England,E08000034,Kirklees	2020-03-26	England	E08000034	Kirklees	55
2020-03-27,England,E06000057,Northumberland	2020-03-27	England	E06000057	Northumberland	55
2020-03-28,England,E06000037,West Berkshire	2020-03-28	England	E06000037	West Berkshire	55
2020-03-28,England,E06000038,Reading	2020-03-28	England	E06000038	Reading	55
2020-03-28,England,E10000027,Somerset	2020-03-28	England	E10000027	Somerset	55
2020-03-29,England,E06000002,Middlesbrough	2020-03-29	England	E06000002	Middlesbrough	55
2020-03-30,England,E06000003,Redcar and Cleveland	2020-03-30	England	E06000003	Redcar and Cleveland	55
2020-03-30,England,E06000020,Telford and Wrekin	2020-03-30	England	E06000020	Telford and Wrekin	55
2020-04-01,England,E06000019,Herefordshire, County of	2020-04-01	England	E06000019	Herefordshire, County of	55
2020-04-01,England,E06000030,Swindon	2020-04-01	England	E06000030	Swindon	55
2020-04-02,Northern Ireland,N09000010,Newry, Mourne and Down	2020-04-02	Northern Ireland	N09000010	Newry, Mourne and Down	55
2020-04-04,England,E06000005,Darlington	2020-04-04	England	E06000005	Darlington	55
2020-04-04,Wales,W11000024,Powys	2020-04-04	Wales	W11000024	Powys	55
2020-04-12,England,E06000046,Isle of Wight	2020-04-12	England	E06000046	Isle of Wight	55
2020-04-18,Wales,,Unknown	2020-04-18	Wales		Unknown	55

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