cases

148 rows where Country = "England" and "Date" is on date 2020-04-18

- 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-18,England,E06000001,Hartlepool	2020-04-18	England	E06000001	Hartlepool	150
2020-04-18,England,E06000002,Middlesbrough	2020-04-18	England	E06000002	Middlesbrough	419
2020-04-18,England,E06000003,Redcar and Cleveland	2020-04-18	England	E06000003	Redcar and Cleveland	233
2020-04-18,England,E06000004,Stockton-on-Tees	2020-04-18	England	E06000004	Stockton-on-Tees	285
2020-04-18,England,E06000005,Darlington	2020-04-18	England	E06000005	Darlington	202
2020-04-18,England,E06000006,Halton	2020-04-18	England	E06000006	Halton	286
2020-04-18,England,E06000007,Warrington	2020-04-18	England	E06000007	Warrington	520
2020-04-18,England,E06000008,Blackburn with Darwen	2020-04-18	England	E06000008	Blackburn with Darwen	251
2020-04-18,England,E06000009,Blackpool	2020-04-18	England	E06000009	Blackpool	273
2020-04-18,England,E06000010,Kingston upon Hull, City of	2020-04-18	England	E06000010	Kingston upon Hull, City of	270
2020-04-18,England,E06000011,East Riding of Yorkshire	2020-04-18	England	E06000011	East Riding of Yorkshire	359
2020-04-18,England,E06000012,North East Lincolnshire	2020-04-18	England	E06000012	North East Lincolnshire	102
2020-04-18,England,E06000013,North Lincolnshire	2020-04-18	England	E06000013	North Lincolnshire	210
2020-04-18,England,E06000014,York	2020-04-18	England	E06000014	York	190
2020-04-18,England,E06000015,Derby	2020-04-18	England	E06000015	Derby	444
2020-04-18,England,E06000016,Leicester	2020-04-18	England	E06000016	Leicester	494
2020-04-18,England,E06000018,Nottingham	2020-04-18	England	E06000018	Nottingham	434
2020-04-18,England,E06000019,Herefordshire, County of	2020-04-18	England	E06000019	Herefordshire, County of	155
2020-04-18,England,E06000020,Telford and Wrekin	2020-04-18	England	E06000020	Telford and Wrekin	180
2020-04-18,England,E06000021,Stoke-on-Trent	2020-04-18	England	E06000021	Stoke-on-Trent	305
2020-04-18,England,E06000022,Bath and North East Somerset	2020-04-18	England	E06000022	Bath and North East Somerset	175
2020-04-18,England,E06000023,Bristol, City of	2020-04-18	England	E06000023	Bristol, City of	477
2020-04-18,England,E06000024,North Somerset	2020-04-18	England	E06000024	North Somerset	159
2020-04-18,England,E06000025,South Gloucestershire	2020-04-18	England	E06000025	South Gloucestershire	272
2020-04-18,England,E06000026,Plymouth	2020-04-18	England	E06000026	Plymouth	222
2020-04-18,England,E06000027,Torbay	2020-04-18	England	E06000027	Torbay	133
2020-04-18,England,E06000030,Swindon	2020-04-18	England	E06000030	Swindon	274
2020-04-18,England,E06000031,Peterborough	2020-04-18	England	E06000031	Peterborough	167
2020-04-18,England,E06000032,Luton	2020-04-18	England	E06000032	Luton	531
2020-04-18,England,E06000033,Southend-on-Sea	2020-04-18	England	E06000033	Southend-on-Sea	258
2020-04-18,England,E06000034,Thurrock	2020-04-18	England	E06000034	Thurrock	258
2020-04-18,England,E06000035,Medway	2020-04-18	England	E06000035	Medway	522
2020-04-18,England,E06000036,Bracknell Forest	2020-04-18	England	E06000036	Bracknell Forest	181
2020-04-18,England,E06000037,West Berkshire	2020-04-18	England	E06000037	West Berkshire	248
2020-04-18,England,E06000038,Reading	2020-04-18	England	E06000038	Reading	374
2020-04-18,England,E06000039,Slough	2020-04-18	England	E06000039	Slough	329
2020-04-18,England,E06000040,Windsor and Maidenhead	2020-04-18	England	E06000040	Windsor and Maidenhead	221
2020-04-18,England,E06000041,Wokingham	2020-04-18	England	E06000041	Wokingham	295
2020-04-18,England,E06000042,Milton Keynes	2020-04-18	England	E06000042	Milton Keynes	396
2020-04-18,England,E06000043,Brighton and Hove	2020-04-18	England	E06000043	Brighton and Hove	338
2020-04-18,England,E06000044,Portsmouth	2020-04-18	England	E06000044	Portsmouth	238
2020-04-18,England,E06000045,Southampton	2020-04-18	England	E06000045	Southampton	361
2020-04-18,England,E06000046,Isle of Wight	2020-04-18	England	E06000046	Isle of Wight	73
2020-04-18,England,E06000047,County Durham	2020-04-18	England	E06000047	County Durham	1061
2020-04-18,England,E06000049,Cheshire East	2020-04-18	England	E06000049	Cheshire East	660
2020-04-18,England,E06000050,Cheshire West and Chester	2020-04-18	England	E06000050	Cheshire West and Chester	609
2020-04-18,England,E06000051,Shropshire	2020-04-18	England	E06000051	Shropshire	330
2020-04-18,England,E06000052,Cornwall and Isles of Scilly	2020-04-18	England	E06000052	Cornwall and Isles of Scilly	424
2020-04-18,England,E06000054,Wiltshire	2020-04-18	England	E06000054	Wiltshire	336
2020-04-18,England,E06000055,Bedford	2020-04-18	England	E06000055	Bedford	350
2020-04-18,England,E06000056,Central Bedfordshire	2020-04-18	England	E06000056	Central Bedfordshire	410
2020-04-18,England,E06000057,Northumberland	2020-04-18	England	E06000057	Northumberland	691
2020-04-18,England,E06000058,Bournemouth, Christchurch and Poole	2020-04-18	England	E06000058	Bournemouth, Christchurch and Poole	349
2020-04-18,England,E06000059,Dorset	2020-04-18	England	E06000059	Dorset	251
2020-04-18,England,E08000001,Bolton	2020-04-18	England	E08000001	Bolton	648
2020-04-18,England,E08000002,Bury	2020-04-18	England	E08000002	Bury	488
2020-04-18,England,E08000003,Manchester	2020-04-18	England	E08000003	Manchester	995
2020-04-18,England,E08000004,Oldham	2020-04-18	England	E08000004	Oldham	635
2020-04-18,England,E08000005,Rochdale	2020-04-18	England	E08000005	Rochdale	478
2020-04-18,England,E08000006,Salford	2020-04-18	England	E08000006	Salford	623
2020-04-18,England,E08000007,Stockport	2020-04-18	England	E08000007	Stockport	699
2020-04-18,England,E08000008,Tameside	2020-04-18	England	E08000008	Tameside	419
2020-04-18,England,E08000009,Trafford	2020-04-18	England	E08000009	Trafford	514
2020-04-18,England,E08000010,Wigan	2020-04-18	England	E08000010	Wigan	669
2020-04-18,England,E08000011,Knowsley	2020-04-18	England	E08000011	Knowsley	441
2020-04-18,England,E08000012,Liverpool	2020-04-18	England	E08000012	Liverpool	1220
2020-04-18,England,E08000013,St. Helens	2020-04-18	England	E08000013	St. Helens	541
2020-04-18,England,E08000014,Sefton	2020-04-18	England	E08000014	Sefton	720
2020-04-18,England,E08000015,Wirral	2020-04-18	England	E08000015	Wirral	841
2020-04-18,England,E08000016,Barnsley	2020-04-18	England	E08000016	Barnsley	505
2020-04-18,England,E08000017,Doncaster	2020-04-18	England	E08000017	Doncaster	372
2020-04-18,England,E08000018,Rotherham	2020-04-18	England	E08000018	Rotherham	544
2020-04-18,England,E08000019,Sheffield	2020-04-18	England	E08000019	Sheffield	1751
2020-04-18,England,E08000021,Newcastle upon Tyne	2020-04-18	England	E08000021	Newcastle upon Tyne	780
2020-04-18,England,E08000022,North Tyneside	2020-04-18	England	E08000022	North Tyneside	432
2020-04-18,England,E08000023,South Tyneside	2020-04-18	England	E08000023	South Tyneside	382
2020-04-18,England,E08000024,Sunderland	2020-04-18	England	E08000024	Sunderland	954
2020-04-18,England,E08000025,Birmingham	2020-04-18	England	E08000025	Birmingham	2429
2020-04-18,England,E08000026,Coventry	2020-04-18	England	E08000026	Coventry	551
2020-04-18,England,E08000027,Dudley	2020-04-18	England	E08000027	Dudley	636
2020-04-18,England,E08000028,Sandwell	2020-04-18	England	E08000028	Sandwell	752
2020-04-18,England,E08000029,Solihull	2020-04-18	England	E08000029	Solihull	466
2020-04-18,England,E08000030,Walsall	2020-04-18	England	E08000030	Walsall	730
2020-04-18,England,E08000031,Wolverhampton	2020-04-18	England	E08000031	Wolverhampton	610
2020-04-18,England,E08000032,Bradford	2020-04-18	England	E08000032	Bradford	666
2020-04-18,England,E08000033,Calderdale	2020-04-18	England	E08000033	Calderdale	216
2020-04-18,England,E08000034,Kirklees	2020-04-18	England	E08000034	Kirklees	490
2020-04-18,England,E08000035,Leeds	2020-04-18	England	E08000035	Leeds	1076
2020-04-18,England,E08000036,Wakefield	2020-04-18	England	E08000036	Wakefield	465
2020-04-18,England,E08000037,Gateshead	2020-04-18	England	E08000037	Gateshead	638
2020-04-18,England,E09000002,Barking and Dagenham	2020-04-18	England	E09000002	Barking and Dagenham	448
2020-04-18,England,E09000003,Barnet	2020-04-18	England	E09000003	Barnet	1120
2020-04-18,England,E09000004,Bexley	2020-04-18	England	E09000004	Bexley	601
2020-04-18,England,E09000005,Brent	2020-04-18	England	E09000005	Brent	1262
2020-04-18,England,E09000006,Bromley	2020-04-18	England	E09000006	Bromley	970
2020-04-18,England,E09000007,Camden	2020-04-18	England	E09000007	Camden	534
2020-04-18,England,E09000008,Croydon	2020-04-18	England	E09000008	Croydon	1277
2020-04-18,England,E09000009,Ealing	2020-04-18	England	E09000009	Ealing	971
2020-04-18,England,E09000010,Enfield	2020-04-18	England	E09000010	Enfield	740
2020-04-18,England,E09000011,Greenwich	2020-04-18	England	E09000011	Greenwich	628

Next page

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