cases

24 rows where TotalCases = 77

descending

Link	Date	Country	AreaCode	Area	TotalCases
2020-03-18,England,E09000020,Kensington and Chelsea	2020-03-18	England	E09000020	Kensington and Chelsea	77
2020-03-19,England,E10000016,Kent	2020-03-19	England	E10000016	Kent	77
2020-03-20,England,E09000017,Hillingdon	2020-03-20	England	E09000017	Hillingdon	77
2020-03-21,England,E09000007,Camden	2020-03-21	England	E09000007	Camden	77
2020-03-21,England,E10000025,Oxfordshire	2020-03-21	England	E10000025	Oxfordshire	77
2020-03-22,England,E09000026,Redbridge	2020-03-22	England	E09000026	Redbridge	77
2020-03-22,England,E09000030,Tower Hamlets	2020-03-22	England	E09000030	Tower Hamlets	77
2020-03-24,England,E09000027,Richmond upon Thames	2020-03-24	England	E09000027	Richmond upon Thames	77
2020-03-25,England,E09000021,Kingston upon Thames	2020-03-25	England	E09000021	Kingston upon Thames	77
2020-03-25,England,E10000023,North Yorkshire	2020-03-25	England	E10000023	North Yorkshire	77
2020-03-25,England,E10000029,Suffolk	2020-03-25	England	E10000029	Suffolk	77
2020-03-26,England,E06000032,Luton	2020-03-26	England	E06000032	Luton	77
2020-03-27,England,E06000056,Central Bedfordshire	2020-03-27	England	E06000056	Central Bedfordshire	77
2020-03-28,England,E08000024,Sunderland	2020-03-28	England	E08000024	Sunderland	77
2020-03-28,England,E08000036,Wakefield	2020-03-28	England	E08000036	Wakefield	77
2020-03-30,England,E06000055,Bedford	2020-03-30	England	E06000055	Bedford	77
2020-03-30,England,E06000059,Dorset	2020-03-30	England	E06000059	Dorset	77
2020-03-31,England,E06000011,East Riding of Yorkshire	2020-03-31	England	E06000011	East Riding of Yorkshire	77
2020-03-31,England,E06000058,Bournemouth, Christchurch and Poole	2020-03-31	England	E06000058	Bournemouth, Christchurch and Poole	77
2020-03-31,Scotland,S08000016,Borders	2020-03-31	Scotland	S08000016	Borders	77
2020-04-04,England,E06000036,Bracknell Forest	2020-04-04	England	E06000036	Bracknell Forest	77
2020-04-10,Northern Ireland,N09000005,Derry and Strabane	2020-04-10	Northern Ireland	N09000005	Derry and Strabane	77
2020-05-10,Northern Ireland,N09000006,Fermanagh and Omagh	2020-05-10	Northern Ireland	N09000006	Fermanagh and Omagh	77
2020-05-11,Northern Ireland,N09000006,Fermanagh and Omagh	2020-05-11	Northern Ireland	N09000006	Fermanagh and Omagh	77

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