cases

41 rows where TotalCases = 25

descending

Link	Date	Country	AreaCode	Area	TotalCases
2020-03-11,England,E09000003,Barnet	2020-03-11	England	E09000003	Barnet	25
2020-03-12,England,E09000007,Camden	2020-03-12	England	E09000007	Camden	25
2020-03-12,England,E09000009,Ealing	2020-03-12	England	E09000009	Ealing	25
2020-03-12,England,E10000025,Oxfordshire	2020-03-12	England	E10000025	Oxfordshire	25
2020-03-12,Wales,W11000031,Swansea Bay	2020-03-12	Wales	W11000031	Swansea Bay	25
2020-03-13,England,E10000006,Cumbria	2020-03-13	England	E10000006	Cumbria	25
2020-03-14,Scotland,S08000024,Lothian	2020-03-14	Scotland	S08000024	Lothian	25
2020-03-15,England,E09000030,Tower Hamlets	2020-03-15	England	E09000030	Tower Hamlets	25
2020-03-16,England,E09000004,Bexley	2020-03-16	England	E09000004	Bexley	25
2020-03-17,England,E10000021,Northamptonshire	2020-03-17	England	E10000021	Northamptonshire	25
2020-03-18,England,E06000018,Nottingham	2020-03-18	England	E06000018	Nottingham	25
2020-03-18,England,E10000029,Suffolk	2020-03-18	England	E10000029	Suffolk	25
2020-03-18,Scotland,S08000032,Lanarkshire	2020-03-18	Scotland	S08000032	Lanarkshire	25
2020-03-19,England,E06000040,Windsor and Maidenhead	2020-03-19	England	E06000040	Windsor and Maidenhead	25
2020-03-19,England,E08000009,Trafford	2020-03-19	England	E08000009	Trafford	25
2020-03-20,England,E08000004,Oldham	2020-03-20	England	E08000004	Oldham	25
2020-03-20,England,E10000011,East Sussex	2020-03-20	England	E10000011	East Sussex	25
2020-03-21,Wales,W11000030,Cwm Taf	2020-03-21	Wales	W11000030	Cwm Taf	25
2020-03-22,England,E06000051,Shropshire	2020-03-22	England	E06000051	Shropshire	25
2020-03-22,England,E06000059,Dorset	2020-03-22	England	E06000059	Dorset	25
2020-03-22,England,E08000005,Rochdale	2020-03-22	England	E08000005	Rochdale	25
2020-03-22,Scotland,S08000015,Ayrshire and Arran	2020-03-22	Scotland	S08000015	Ayrshire and Arran	25
2020-03-23,England,E06000038,Reading	2020-03-23	England	E06000038	Reading	25
2020-03-23,England,E06000041,Wokingham	2020-03-23	England	E06000041	Wokingham	25
2020-03-23,England,E08000024,Sunderland	2020-03-23	England	E08000024	Sunderland	25
2020-03-24,England,E06000011,East Riding of Yorkshire	2020-03-24	England	E06000011	East Riding of Yorkshire	25
2020-03-24,England,E06000033,Southend-on-Sea	2020-03-24	England	E06000033	Southend-on-Sea	25
2020-03-24,England,E08000010,Wigan	2020-03-24	England	E08000010	Wigan	25
2020-03-24,Scotland,S08000029,Fife	2020-03-24	Scotland	S08000029	Fife	25
2020-03-25,England,E06000021,Stoke-on-Trent	2020-03-25	England	E06000021	Stoke-on-Trent	25
2020-03-26,England,E06000004,Stockton-on-Tees	2020-03-26	England	E06000004	Stockton-on-Tees	25
2020-03-26,England,E06000019,Herefordshire, County of	2020-03-26	England	E06000019	Herefordshire, County of	25
2020-03-26,England,E06000020,Telford and Wrekin	2020-03-26	England	E06000020	Telford and Wrekin	25
2020-03-27,England,E06000006,Halton	2020-03-27	England	E06000006	Halton	25
2020-03-27,England,E06000024,North Somerset	2020-03-27	England	E06000024	North Somerset	25
2020-03-27,Northern Ireland,N09000011,North Down and Ards	2020-03-27	Northern Ireland	N09000011	North Down and Ards	25
2020-03-29,England,E06000009,Blackpool	2020-03-29	England	E06000009	Blackpool	25
2020-03-29,England,E06000012,North East Lincolnshire	2020-03-29	England	E06000012	North East Lincolnshire	25
2020-03-29,Wales,W11000024,Powys	2020-03-29	Wales	W11000024	Powys	25
2020-03-31,Wales,,Outside Wales	2020-03-31	Wales		Outside Wales	25
2020-04-02,England,E06000001,Hartlepool	2020-04-02	England	E06000001	Hartlepool	25

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