cases

24 rows where TotalCases = 42

descending

Link	Date	Country	AreaCode	Area	TotalCases
2020-03-13,England,E09000032,Wandsworth	2020-03-13	England	E09000032	Wandsworth	42
2020-03-14,England,E09000003,Barnet	2020-03-14	England	E09000003	Barnet	42
2020-03-17,England,E09000012,Hackney and City of London	2020-03-17	England	E09000012	Hackney and City of London	42
2020-03-19,England,E09000004,Bexley	2020-03-19	England	E09000004	Bexley	42
2020-03-19,England,E09000031,Waltham Forest	2020-03-19	England	E09000031	Waltham Forest	42
2020-03-19,Wales,W11000031,Swansea Bay	2020-03-19	Wales	W11000031	Swansea Bay	42
2020-03-20,England,E09000002,Barking and Dagenham	2020-03-20	England	E09000002	Barking and Dagenham	42
2020-03-21,England,E06000018,Nottingham	2020-03-21	England	E06000018	Nottingham	42
2020-03-21,England,E08000003,Manchester	2020-03-21	England	E08000003	Manchester	42
2020-03-22,England,E08000026,Coventry	2020-03-22	England	E08000026	Coventry	42
2020-03-23,England,E06000032,Luton	2020-03-23	England	E06000032	Luton	42
2020-03-23,England,E06000056,Central Bedfordshire	2020-03-23	England	E06000056	Central Bedfordshire	42
2020-03-23,England,E08000016,Barnsley	2020-03-23	England	E08000016	Barnsley	42
2020-03-24,England,E08000005,Rochdale	2020-03-24	England	E08000005	Rochdale	42
2020-03-25,England,E08000032,Bradford	2020-03-25	England	E08000032	Bradford	42
2020-03-26,England,E06000038,Reading	2020-03-26	England	E06000038	Reading	42
2020-03-26,England,E08000001,Bolton	2020-03-26	England	E08000001	Bolton	42
2020-03-26,England,E10000027,Somerset	2020-03-26	England	E10000027	Somerset	42
2020-03-27,England,E06000033,Southend-on-Sea	2020-03-27	England	E06000033	Southend-on-Sea	42
2020-03-30,England,E06000027,Torbay	2020-03-30	England	E06000027	Torbay	42
2020-04-06,Northern Ireland,N09000006,Fermanagh and Omagh	2020-04-06	Northern Ireland	N09000006	Fermanagh and Omagh	42
2020-04-07,Northern Ireland,N09000009,Mid Ulster	2020-04-07	Northern Ireland	N09000009	Mid Ulster	42
2020-04-07,Scotland,S08000026,Shetland	2020-04-07	Scotland	S08000026	Shetland	42
2020-05-07,England,E06000017,Rutland	2020-05-07	England	E06000017	Rutland	42

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