cases

149 rows where Country = "England" and "Date" is on date 2020-04-22

- remove filter - Date Country AreaCode Area TotalCases

= != contains ends with starts with > ≥ < ≤ like not like glob in not in array contains date is null is not null is blank is not blank

- remove filter - Date Country AreaCode Area TotalCases

= != contains ends with starts with > ≥ < ≤ like not like glob in not in array contains date is null is not null is blank is not blank

- column - Date Country AreaCode Area TotalCases

= != contains ends with starts with > ≥ < ≤ like not like glob in not in array contains date is null is not null is blank is not blank

Sort... Sort by Date Sort by Country Sort by AreaCode Sort by Area Sort by TotalCases

descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Date (date)

Link	Date	Country	AreaCode	Area	TotalCases
2020-04-22,England,E06000001,Hartlepool	2020-04-22	England	E06000001	Hartlepool	196
2020-04-22,England,E06000002,Middlesbrough	2020-04-22	England	E06000002	Middlesbrough	496
2020-04-22,England,E06000003,Redcar and Cleveland	2020-04-22	England	E06000003	Redcar and Cleveland	292
2020-04-22,England,E06000004,Stockton-on-Tees	2020-04-22	England	E06000004	Stockton-on-Tees	348
2020-04-22,England,E06000005,Darlington	2020-04-22	England	E06000005	Darlington	247
2020-04-22,England,E06000006,Halton	2020-04-22	England	E06000006	Halton	329
2020-04-22,England,E06000007,Warrington	2020-04-22	England	E06000007	Warrington	638
2020-04-22,England,E06000008,Blackburn with Darwen	2020-04-22	England	E06000008	Blackburn with Darwen	296
2020-04-22,England,E06000009,Blackpool	2020-04-22	England	E06000009	Blackpool	367
2020-04-22,England,E06000010,Kingston upon Hull, City of	2020-04-22	England	E06000010	Kingston upon Hull, City of	356
2020-04-22,England,E06000011,East Riding of Yorkshire	2020-04-22	England	E06000011	East Riding of Yorkshire	459
2020-04-22,England,E06000012,North East Lincolnshire	2020-04-22	England	E06000012	North East Lincolnshire	116
2020-04-22,England,E06000013,North Lincolnshire	2020-04-22	England	E06000013	North Lincolnshire	268
2020-04-22,England,E06000014,York	2020-04-22	England	E06000014	York	249
2020-04-22,England,E06000015,Derby	2020-04-22	England	E06000015	Derby	494
2020-04-22,England,E06000016,Leicester	2020-04-22	England	E06000016	Leicester	597
2020-04-22,England,E06000017,Rutland	2020-04-22	England	E06000017	Rutland	21
2020-04-22,England,E06000018,Nottingham	2020-04-22	England	E06000018	Nottingham	553
2020-04-22,England,E06000019,Herefordshire, County of	2020-04-22	England	E06000019	Herefordshire, County of	224
2020-04-22,England,E06000020,Telford and Wrekin	2020-04-22	England	E06000020	Telford and Wrekin	225
2020-04-22,England,E06000021,Stoke-on-Trent	2020-04-22	England	E06000021	Stoke-on-Trent	377
2020-04-22,England,E06000022,Bath and North East Somerset	2020-04-22	England	E06000022	Bath and North East Somerset	202
2020-04-22,England,E06000023,Bristol, City of	2020-04-22	England	E06000023	Bristol, City of	571
2020-04-22,England,E06000024,North Somerset	2020-04-22	England	E06000024	North Somerset	203
2020-04-22,England,E06000025,South Gloucestershire	2020-04-22	England	E06000025	South Gloucestershire	342
2020-04-22,England,E06000026,Plymouth	2020-04-22	England	E06000026	Plymouth	306
2020-04-22,England,E06000027,Torbay	2020-04-22	England	E06000027	Torbay	184
2020-04-22,England,E06000030,Swindon	2020-04-22	England	E06000030	Swindon	334
2020-04-22,England,E06000031,Peterborough	2020-04-22	England	E06000031	Peterborough	218
2020-04-22,England,E06000032,Luton	2020-04-22	England	E06000032	Luton	576
2020-04-22,England,E06000033,Southend-on-Sea	2020-04-22	England	E06000033	Southend-on-Sea	288
2020-04-22,England,E06000034,Thurrock	2020-04-22	England	E06000034	Thurrock	288
2020-04-22,England,E06000035,Medway	2020-04-22	England	E06000035	Medway	580
2020-04-22,England,E06000036,Bracknell Forest	2020-04-22	England	E06000036	Bracknell Forest	205
2020-04-22,England,E06000037,West Berkshire	2020-04-22	England	E06000037	West Berkshire	289
2020-04-22,England,E06000038,Reading	2020-04-22	England	E06000038	Reading	437
2020-04-22,England,E06000039,Slough	2020-04-22	England	E06000039	Slough	361
2020-04-22,England,E06000040,Windsor and Maidenhead	2020-04-22	England	E06000040	Windsor and Maidenhead	237
2020-04-22,England,E06000041,Wokingham	2020-04-22	England	E06000041	Wokingham	358
2020-04-22,England,E06000042,Milton Keynes	2020-04-22	England	E06000042	Milton Keynes	455
2020-04-22,England,E06000043,Brighton and Hove	2020-04-22	England	E06000043	Brighton and Hove	386
2020-04-22,England,E06000044,Portsmouth	2020-04-22	England	E06000044	Portsmouth	283
2020-04-22,England,E06000045,Southampton	2020-04-22	England	E06000045	Southampton	426
2020-04-22,England,E06000046,Isle of Wight	2020-04-22	England	E06000046	Isle of Wight	84
2020-04-22,England,E06000047,County Durham	2020-04-22	England	E06000047	County Durham	1315
2020-04-22,England,E06000049,Cheshire East	2020-04-22	England	E06000049	Cheshire East	788
2020-04-22,England,E06000050,Cheshire West and Chester	2020-04-22	England	E06000050	Cheshire West and Chester	726
2020-04-22,England,E06000051,Shropshire	2020-04-22	England	E06000051	Shropshire	410
2020-04-22,England,E06000052,Cornwall and Isles of Scilly	2020-04-22	England	E06000052	Cornwall and Isles of Scilly	467
2020-04-22,England,E06000054,Wiltshire	2020-04-22	England	E06000054	Wiltshire	399
2020-04-22,England,E06000055,Bedford	2020-04-22	England	E06000055	Bedford	401
2020-04-22,England,E06000056,Central Bedfordshire	2020-04-22	England	E06000056	Central Bedfordshire	485
2020-04-22,England,E06000057,Northumberland	2020-04-22	England	E06000057	Northumberland	833
2020-04-22,England,E06000058,Bournemouth, Christchurch and Poole	2020-04-22	England	E06000058	Bournemouth, Christchurch and Poole	390
2020-04-22,England,E06000059,Dorset	2020-04-22	England	E06000059	Dorset	289
2020-04-22,England,E08000001,Bolton	2020-04-22	England	E08000001	Bolton	792
2020-04-22,England,E08000002,Bury	2020-04-22	England	E08000002	Bury	558
2020-04-22,England,E08000003,Manchester	2020-04-22	England	E08000003	Manchester	1167
2020-04-22,England,E08000004,Oldham	2020-04-22	England	E08000004	Oldham	738
2020-04-22,England,E08000005,Rochdale	2020-04-22	England	E08000005	Rochdale	569
2020-04-22,England,E08000006,Salford	2020-04-22	England	E08000006	Salford	718
2020-04-22,England,E08000007,Stockport	2020-04-22	England	E08000007	Stockport	824
2020-04-22,England,E08000008,Tameside	2020-04-22	England	E08000008	Tameside	477
2020-04-22,England,E08000009,Trafford	2020-04-22	England	E08000009	Trafford	601
2020-04-22,England,E08000010,Wigan	2020-04-22	England	E08000010	Wigan	863
2020-04-22,England,E08000011,Knowsley	2020-04-22	England	E08000011	Knowsley	519
2020-04-22,England,E08000012,Liverpool	2020-04-22	England	E08000012	Liverpool	1387
2020-04-22,England,E08000013,St. Helens	2020-04-22	England	E08000013	St. Helens	666
2020-04-22,England,E08000014,Sefton	2020-04-22	England	E08000014	Sefton	825
2020-04-22,England,E08000015,Wirral	2020-04-22	England	E08000015	Wirral	982
2020-04-22,England,E08000016,Barnsley	2020-04-22	England	E08000016	Barnsley	605
2020-04-22,England,E08000017,Doncaster	2020-04-22	England	E08000017	Doncaster	467
2020-04-22,England,E08000018,Rotherham	2020-04-22	England	E08000018	Rotherham	647
2020-04-22,England,E08000019,Sheffield	2020-04-22	England	E08000019	Sheffield	1983
2020-04-22,England,E08000021,Newcastle upon Tyne	2020-04-22	England	E08000021	Newcastle upon Tyne	891
2020-04-22,England,E08000022,North Tyneside	2020-04-22	England	E08000022	North Tyneside	499
2020-04-22,England,E08000023,South Tyneside	2020-04-22	England	E08000023	South Tyneside	470
2020-04-22,England,E08000024,Sunderland	2020-04-22	England	E08000024	Sunderland	1119
2020-04-22,England,E08000025,Birmingham	2020-04-22	England	E08000025	Birmingham	2746
2020-04-22,England,E08000026,Coventry	2020-04-22	England	E08000026	Coventry	647
2020-04-22,England,E08000027,Dudley	2020-04-22	England	E08000027	Dudley	702
2020-04-22,England,E08000028,Sandwell	2020-04-22	England	E08000028	Sandwell	854
2020-04-22,England,E08000029,Solihull	2020-04-22	England	E08000029	Solihull	538
2020-04-22,England,E08000030,Walsall	2020-04-22	England	E08000030	Walsall	854
2020-04-22,England,E08000031,Wolverhampton	2020-04-22	England	E08000031	Wolverhampton	723
2020-04-22,England,E08000032,Bradford	2020-04-22	England	E08000032	Bradford	822
2020-04-22,England,E08000033,Calderdale	2020-04-22	England	E08000033	Calderdale	255
2020-04-22,England,E08000034,Kirklees	2020-04-22	England	E08000034	Kirklees	585
2020-04-22,England,E08000035,Leeds	2020-04-22	England	E08000035	Leeds	1413
2020-04-22,England,E08000036,Wakefield	2020-04-22	England	E08000036	Wakefield	558
2020-04-22,England,E08000037,Gateshead	2020-04-22	England	E08000037	Gateshead	761
2020-04-22,England,E09000002,Barking and Dagenham	2020-04-22	England	E09000002	Barking and Dagenham	493
2020-04-22,England,E09000003,Barnet	2020-04-22	England	E09000003	Barnet	1193
2020-04-22,England,E09000004,Bexley	2020-04-22	England	E09000004	Bexley	670
2020-04-22,England,E09000005,Brent	2020-04-22	England	E09000005	Brent	1336
2020-04-22,England,E09000006,Bromley	2020-04-22	England	E09000006	Bromley	1026
2020-04-22,England,E09000007,Camden	2020-04-22	England	E09000007	Camden	564
2020-04-22,England,E09000008,Croydon	2020-04-22	England	E09000008	Croydon	1369
2020-04-22,England,E09000009,Ealing	2020-04-22	England	E09000009	Ealing	1046
2020-04-22,England,E09000010,Enfield	2020-04-22	England	E09000010	Enfield	834

Next page

CREATE TABLE "cases" (
"Date" TEXT,
  "Country" TEXT,
  "AreaCode" TEXT,
  "Area" TEXT,
  "TotalCases" INTEGER
  ,PRIMARY KEY ([Date], [Country], [AreaCode], [Area])
);