cases

19 rows where TotalCases = 162

descending

Link	Date	Country	AreaCode	Area	TotalCases
2020-03-21,England,E10000015,Hertfordshire	2020-03-21	England	E10000015	Hertfordshire	162
2020-03-27,England,E08000028,Sandwell	2020-03-27	England	E08000028	Sandwell	162
2020-03-27,England,E08000030,Walsall	2020-03-27	England	E08000030	Walsall	162
2020-03-27,Wales,W11000030,Cwm Taf	2020-03-27	Wales	W11000030	Cwm Taf	162
2020-03-30,England,E08000006,Salford	2020-03-30	England	E08000006	Salford	162
2020-04-03,England,E08000008,Tameside	2020-04-03	England	E08000008	Tameside	162
2020-04-04,England,E06000054,Wiltshire	2020-04-04	England	E06000054	Wiltshire	162
2020-04-09,England,E06000044,Portsmouth	2020-04-09	England	E06000044	Portsmouth	162
2020-04-13,England,E06000010,Kingston upon Hull, City of	2020-04-13	England	E06000010	Kingston upon Hull, City of	162
2020-04-13,England,E06000026,Plymouth	2020-04-13	England	E06000026	Plymouth	162
2020-04-17,England,E06000020,Telford and Wrekin	2020-04-17	England	E06000020	Telford and Wrekin	162
2020-04-19,England,E06000001,Hartlepool	2020-04-19	England	E06000001	Hartlepool	162
2020-05-05,Northern Ireland,N09000004,Causeway Coast and Glens	2020-05-05	Northern Ireland	N09000004	Causeway Coast and Glens	162
2020-05-13,Northern Ireland,N09000005,Derry City and Strabane	2020-05-13	Northern Ireland	N09000005	Derry City and Strabane	162
2020-05-14,Northern Ireland,N09000005,Derry City and Strabane	2020-05-14	Northern Ireland	N09000005	Derry City and Strabane	162
2020-05-15,Northern Ireland,N09000005,Derry City and Strabane	2020-05-15	Northern Ireland	N09000005	Derry City and Strabane	162
2020-05-16,Northern Ireland,N09000005,Derry City and Strabane	2020-05-16	Northern Ireland	N09000005	Derry City and Strabane	162
2020-05-17,England,E06000012,North East Lincolnshire	2020-05-17	England	E06000012	North East Lincolnshire	162
2020-05-17,Northern Ireland,N09000005,Derry City and Strabane	2020-05-17	Northern Ireland	N09000005	Derry City and Strabane	162

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