cases

24 rows where TotalCases = 107

descending

Link	Date	Country	AreaCode	Area	TotalCases
2020-03-23,England,E09000020,Kensington and Chelsea	2020-03-23	England	E09000020	Kensington and Chelsea	107
2020-03-23,England,E10000025,Oxfordshire	2020-03-23	England	E10000025	Oxfordshire	107
2020-03-24,England,E09000026,Redbridge	2020-03-24	England	E09000026	Redbridge	107
2020-03-25,England,E09000029,Sutton	2020-03-25	England	E09000029	Sutton	107
2020-03-26,England,E08000026,Coventry	2020-03-26	England	E08000026	Coventry	107
2020-03-27,England,E10000019,Lincolnshire	2020-03-27	England	E10000019	Lincolnshire	107
2020-03-27,England,E10000023,North Yorkshire	2020-03-27	England	E10000023	North Yorkshire	107
2020-03-27,Scotland,S08000030,Tayside	2020-03-27	Scotland	S08000030	Tayside	107
2020-03-28,England,E08000007,Stockport	2020-03-28	England	E08000007	Stockport	107
2020-03-28,England,E09000021,Kingston upon Thames	2020-03-28	England	E09000021	Kingston upon Thames	107
2020-03-29,England,E06000018,Nottingham	2020-03-29	England	E06000018	Nottingham	107
2020-03-29,England,E06000047,County Durham	2020-03-29	England	E06000047	County Durham	107
2020-03-30,England,E06000016,Leicester	2020-03-30	England	E06000016	Leicester	107
2020-04-01,England,E06000025,South Gloucestershire	2020-04-01	England	E06000025	South Gloucestershire	107
2020-04-02,England,E06000040,Windsor and Maidenhead	2020-04-02	England	E06000040	Windsor and Maidenhead	107
2020-04-02,England,E06000059,Dorset	2020-04-02	England	E06000059	Dorset	107
2020-04-06,England,E08000033,Calderdale	2020-04-06	England	E08000033	Calderdale	107
2020-04-07,England,E06000009,Blackpool	2020-04-07	England	E06000009	Blackpool	107
2020-04-09,England,E06000031,Peterborough	2020-04-09	England	E06000031	Peterborough	107
2020-04-13,Wales,W11000024,Powys	2020-04-13	Wales	W11000024	Powys	107
2020-04-14,England,E06000027,Torbay	2020-04-14	England	E06000027	Torbay	107
2020-04-20,England,E06000012,North East Lincolnshire	2020-04-20	England	E06000012	North East Lincolnshire	107
2020-05-08,Wales,,Outside Wales	2020-05-08	Wales		Outside Wales	107
2020-05-09,Wales,,Outside Wales	2020-05-09	Wales		Outside Wales	107

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