cases

22 rows where TotalCases = 50

descending

Link	Date	Country	AreaCode	Area	TotalCases
2020-03-17,England,E09000024,Merton	2020-03-17	England	E09000024	Merton	50
2020-03-18,England,E09000010,Enfield	2020-03-18	England	E09000010	Enfield	50
2020-03-18,England,E10000031,Warwickshire	2020-03-18	England	E10000031	Warwickshire	50
2020-03-19,England,E09000026,Redbridge	2020-03-19	England	E09000026	Redbridge	50
2020-03-20,England,E06000039,Slough	2020-03-20	England	E06000039	Slough	50
2020-03-21,England,E10000013,Gloucestershire	2020-03-21	England	E10000013	Gloucestershire	50
2020-03-22,England,E10000020,Norfolk	2020-03-22	England	E10000020	Norfolk	50
2020-03-23,England,E06000023,Bristol, City of	2020-03-23	England	E06000023	Bristol, City of	50
2020-03-23,England,E08000009,Trafford	2020-03-23	England	E08000009	Trafford	50
2020-03-24,England,E08000018,Rotherham	2020-03-24	England	E08000018	Rotherham	50
2020-03-24,Wales,W11000025,Hywel Dda	2020-03-24	Wales	W11000025	Hywel Dda	50
2020-03-25,England,E08000005,Rochdale	2020-03-25	England	E08000005	Rochdale	50
2020-03-25,Wales,W11000023,Betsi Cadwaladr	2020-03-25	Wales	W11000023	Betsi Cadwaladr	50
2020-03-27,England,E06000059,Dorset	2020-03-27	England	E06000059	Dorset	50
2020-03-27,England,E10000027,Somerset	2020-03-27	England	E10000027	Somerset	50
2020-03-28,England,E06000041,Wokingham	2020-03-28	England	E06000041	Wokingham	50
2020-03-28,England,E08000011,Knowsley	2020-03-28	England	E08000011	Knowsley	50
2020-03-29,England,E06000007,Warrington	2020-03-29	England	E06000007	Warrington	50
2020-03-29,England,E06000011,East Riding of Yorkshire	2020-03-29	England	E06000011	East Riding of Yorkshire	50
2020-03-29,Scotland,S08000016,Borders	2020-03-29	Scotland	S08000016	Borders	50
2020-03-31,England,E06000031,Peterborough	2020-03-31	England	E06000031	Peterborough	50
2020-04-04,England,E06000012,North East Lincolnshire	2020-04-04	England	E06000012	North East Lincolnshire	50

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