cases

26 rows where TotalCases = 40

descending

Link	Date	Country	AreaCode	Area	TotalCases
2020-03-15,England,E08000031,Wolverhampton	2020-03-15	England	E08000031	Wolverhampton	40
2020-03-15,England,E09000008,Croydon	2020-03-15	England	E09000008	Croydon	40
2020-03-15,England,E10000012,Essex	2020-03-15	England	E10000012	Essex	40
2020-03-16,England,E09000023,Lewisham	2020-03-16	England	E09000023	Lewisham	40
2020-03-16,England,E09000024,Merton	2020-03-16	England	E09000024	Merton	40
2020-03-17,England,E09000013,Hammersmith and Fulham	2020-03-17	England	E09000013	Hammersmith and Fulham	40
2020-03-17,England,E10000028,Staffordshire	2020-03-17	England	E10000028	Staffordshire	40
2020-03-18,England,E06000039,Slough	2020-03-18	England	E06000039	Slough	40
2020-03-19,England,E08000030,Walsall	2020-03-19	England	E08000030	Walsall	40
2020-03-20,Scotland,S08000024,Lothian	2020-03-20	Scotland	S08000024	Lothian	40
2020-03-22,England,E08000004,Oldham	2020-03-22	England	E08000004	Oldham	40
2020-03-22,England,E08000008,Tameside	2020-03-22	England	E08000008	Tameside	40
2020-03-23,Scotland,S08000019,Forth Valley	2020-03-23	Scotland	S08000019	Forth Valley	40
2020-03-25,England,E06000037,West Berkshire	2020-03-25	England	E06000037	West Berkshire	40
2020-03-25,England,E08000013,St. Helens	2020-03-25	England	E08000013	St. Helens	40
2020-03-26,Scotland,S08000029,Fife	2020-03-26	Scotland	S08000029	Fife	40
2020-03-27,England,E08000011,Knowsley	2020-03-27	England	E08000011	Knowsley	40
2020-03-28,England,E06000007,Warrington	2020-03-28	England	E06000007	Warrington	40
2020-03-28,England,E06000011,East Riding of Yorkshire	2020-03-28	England	E06000011	East Riding of Yorkshire	40
2020-03-29,England,E06000031,Peterborough	2020-03-29	England	E06000031	Peterborough	40
2020-03-29,England,E08000033,Calderdale	2020-03-29	England	E08000033	Calderdale	40
2020-03-30,England,E06000019,Herefordshire, County of	2020-03-30	England	E06000019	Herefordshire, County of	40
2020-04-03,Northern Ireland,N09000006,Fermanagh and Omagh	2020-04-03	Northern Ireland	N09000006	Fermanagh and Omagh	40
2020-04-04,Scotland,S08000026,Shetland	2020-04-04	Scotland	S08000026	Shetland	40
2020-04-05,England,E06000001,Hartlepool	2020-04-05	England	E06000001	Hartlepool	40
2020-04-05,Wales,,Unknown	2020-04-05	Wales		Unknown	40

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