cases

151 rows where "Date" is on date 2020-06-26

- 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: Country, Date (date)

Link	Date	Country	AreaCode	Area	TotalCases
2020-06-26,England,E06000002,Middlesbrough	2020-06-26	England	E06000002	Middlesbrough	947
2020-06-26,England,E06000003,Redcar and Cleveland	2020-06-26	England	E06000003	Redcar and Cleveland	695
2020-06-26,England,E06000004,Stockton-on-Tees	2020-06-26	England	E06000004	Stockton-on-Tees	943
2020-06-26,England,E06000007,Warrington	2020-06-26	England	E06000007	Warrington	1304
2020-06-26,England,E06000008,Blackburn with Darwen	2020-06-26	England	E06000008	Blackburn with Darwen	960
2020-06-26,England,E06000009,Blackpool	2020-06-26	England	E06000009	Blackpool	1007
2020-06-26,England,E06000010,Kingston upon Hull, City of	2020-06-26	England	E06000010	Kingston upon Hull, City of	1529
2020-06-26,England,E06000011,East Riding of Yorkshire	2020-06-26	England	E06000011	East Riding of Yorkshire	1623
2020-06-26,England,E06000013,North Lincolnshire	2020-06-26	England	E06000013	North Lincolnshire	714
2020-06-26,England,E06000014,York	2020-06-26	England	E06000014	York	895
2020-06-26,England,E06000015,Derby	2020-06-26	England	E06000015	Derby	1245
2020-06-26,England,E06000016,Leicester	2020-06-26	England	E06000016	Leicester	3455
2020-06-26,England,E06000018,Nottingham	2020-06-26	England	E06000018	Nottingham	1152
2020-06-26,England,E06000019,Herefordshire, County of	2020-06-26	England	E06000019	Herefordshire, County of	743
2020-06-26,England,E06000020,Telford and Wrekin	2020-06-26	England	E06000020	Telford and Wrekin	586
2020-06-26,England,E06000021,Stoke-on-Trent	2020-06-26	England	E06000021	Stoke-on-Trent	1409
2020-06-26,England,E06000023,Bristol, City of	2020-06-26	England	E06000023	Bristol, City of	1273
2020-06-26,England,E06000024,North Somerset	2020-06-26	England	E06000024	North Somerset	895
2020-06-26,England,E06000025,South Gloucestershire	2020-06-26	England	E06000025	South Gloucestershire	738
2020-06-26,England,E06000031,Peterborough	2020-06-26	England	E06000031	Peterborough	1241
2020-06-26,England,E06000032,Luton	2020-06-26	England	E06000032	Luton	1353
2020-06-26,England,E06000033,Southend-on-Sea	2020-06-26	England	E06000033	Southend-on-Sea	648
2020-06-26,England,E06000035,Medway	2020-06-26	England	E06000035	Medway	1027
2020-06-26,England,E06000036,Bracknell Forest	2020-06-26	England	E06000036	Bracknell Forest	373
2020-06-26,England,E06000039,Slough	2020-06-26	England	E06000039	Slough	623
2020-06-26,England,E06000040,Windsor and Maidenhead	2020-06-26	England	E06000040	Windsor and Maidenhead	398
2020-06-26,England,E06000041,Wokingham	2020-06-26	England	E06000041	Wokingham	583
2020-06-26,England,E06000042,Milton Keynes	2020-06-26	England	E06000042	Milton Keynes	849
2020-06-26,England,E06000043,Brighton and Hove	2020-06-26	England	E06000043	Brighton and Hove	761
2020-06-26,England,E06000047,County Durham	2020-06-26	England	E06000047	County Durham	3294
2020-06-26,England,E06000049,Cheshire East	2020-06-26	England	E06000049	Cheshire East	2163
2020-06-26,England,E06000050,Cheshire West and Chester	2020-06-26	England	E06000050	Cheshire West and Chester	1904
2020-06-26,England,E06000051,Shropshire	2020-06-26	England	E06000051	Shropshire	1365
2020-06-26,England,E06000054,Wiltshire	2020-06-26	England	E06000054	Wiltshire	1233
2020-06-26,England,E06000055,Bedford	2020-06-26	England	E06000055	Bedford	1221
2020-06-26,England,E06000056,Central Bedfordshire	2020-06-26	England	E06000056	Central Bedfordshire	1200
2020-06-26,England,E06000057,Northumberland	2020-06-26	England	E06000057	Northumberland	1560
2020-06-26,England,E06000058,Bournemouth, Christchurch and Poole	2020-06-26	England	E06000058	Bournemouth, Christchurch and Poole	806
2020-06-26,England,E08000001,Bolton	2020-06-26	England	E08000001	Bolton	1761
2020-06-26,England,E08000002,Bury	2020-06-26	England	E08000002	Bury	1255
2020-06-26,England,E08000003,Manchester	2020-06-26	England	E08000003	Manchester	2791
2020-06-26,England,E08000004,Oldham	2020-06-26	England	E08000004	Oldham	1783
2020-06-26,England,E08000005,Rochdale	2020-06-26	England	E08000005	Rochdale	1487
2020-06-26,England,E08000006,Salford	2020-06-26	England	E08000006	Salford	1287
2020-06-26,England,E08000007,Stockport	2020-06-26	England	E08000007	Stockport	1598
2020-06-26,England,E08000008,Tameside	2020-06-26	England	E08000008	Tameside	1478
2020-06-26,England,E08000010,Wigan	2020-06-26	England	E08000010	Wigan	2109
2020-06-26,England,E08000011,Knowsley	2020-06-26	England	E08000011	Knowsley	968
2020-06-26,England,E08000012,Liverpool	2020-06-26	England	E08000012	Liverpool	2386
2020-06-26,England,E08000013,St. Helens	2020-06-26	England	E08000013	St. Helens	1185
2020-06-26,England,E08000014,Sefton	2020-06-26	England	E08000014	Sefton	1491
2020-06-26,England,E08000015,Wirral	2020-06-26	England	E08000015	Wirral	2013
2020-06-26,England,E08000016,Barnsley	2020-06-26	England	E08000016	Barnsley	1827
2020-06-26,England,E08000017,Doncaster	2020-06-26	England	E08000017	Doncaster	1930
2020-06-26,England,E08000018,Rotherham	2020-06-26	England	E08000018	Rotherham	1799
2020-06-26,England,E08000019,Sheffield	2020-06-26	England	E08000019	Sheffield	3828
2020-06-26,England,E08000022,North Tyneside	2020-06-26	England	E08000022	North Tyneside	910
2020-06-26,England,E08000025,Birmingham	2020-06-26	England	E08000025	Birmingham	4726
2020-06-26,England,E08000026,Coventry	2020-06-26	England	E08000026	Coventry	1309
2020-06-26,England,E08000027,Dudley	2020-06-26	England	E08000027	Dudley	1293
2020-06-26,England,E08000028,Sandwell	2020-06-26	England	E08000028	Sandwell	1614
2020-06-26,England,E08000029,Solihull	2020-06-26	England	E08000029	Solihull	875
2020-06-26,England,E08000031,Wolverhampton	2020-06-26	England	E08000031	Wolverhampton	1359
2020-06-26,England,E08000032,Bradford	2020-06-26	England	E08000032	Bradford	3973
2020-06-26,England,E08000033,Calderdale	2020-06-26	England	E08000033	Calderdale	636
2020-06-26,England,E08000034,Kirklees	2020-06-26	England	E08000034	Kirklees	1864
2020-06-26,England,E08000035,Leeds	2020-06-26	England	E08000035	Leeds	3540
2020-06-26,England,E08000036,Wakefield	2020-06-26	England	E08000036	Wakefield	1596
2020-06-26,England,E09000002,Barking and Dagenham	2020-06-26	England	E09000002	Barking and Dagenham	701
2020-06-26,England,E09000003,Barnet	2020-06-26	England	E09000003	Barnet	1579
2020-06-26,England,E09000004,Bexley	2020-06-26	England	E09000004	Bexley	1040
2020-06-26,England,E09000005,Brent	2020-06-26	England	E09000005	Brent	1724
2020-06-26,England,E09000006,Bromley	2020-06-26	England	E09000006	Bromley	1507
2020-06-26,England,E09000007,Camden	2020-06-26	England	E09000007	Camden	699
2020-06-26,England,E09000008,Croydon	2020-06-26	England	E09000008	Croydon	1843
2020-06-26,England,E09000009,Ealing	2020-06-26	England	E09000009	Ealing	1537
2020-06-26,England,E09000010,Enfield	2020-06-26	England	E09000010	Enfield	1166
2020-06-26,England,E09000012,Hackney and City of London	2020-06-26	England	E09000012	Hackney and City of London	796
2020-06-26,England,E09000016,Havering	2020-06-26	England	E09000016	Havering	926
2020-06-26,England,E09000017,Hillingdon	2020-06-26	England	E09000017	Hillingdon	1069
2020-06-26,England,E09000018,Hounslow	2020-06-26	England	E09000018	Hounslow	1048
2020-06-26,England,E09000022,Lambeth	2020-06-26	England	E09000022	Lambeth	1348
2020-06-26,England,E09000023,Lewisham	2020-06-26	England	E09000023	Lewisham	1187
2020-06-26,England,E09000024,Merton	2020-06-26	England	E09000024	Merton	928
2020-06-26,England,E09000025,Newham	2020-06-26	England	E09000025	Newham	1250
2020-06-26,England,E09000026,Redbridge	2020-06-26	England	E09000026	Redbridge	1088
2020-06-26,England,E09000028,Southwark	2020-06-26	England	E09000028	Southwark	1424
2020-06-26,England,E09000030,Tower Hamlets	2020-06-26	England	E09000030	Tower Hamlets	789
2020-06-26,England,E09000031,Waltham Forest	2020-06-26	England	E09000031	Waltham Forest	999
2020-06-26,England,E09000032,Wandsworth	2020-06-26	England	E09000032	Wandsworth	1141
2020-06-26,England,E09000033,Westminster	2020-06-26	England	E09000033	Westminster	771
2020-06-26,England,E10000002,Buckinghamshire	2020-06-26	England	E10000002	Buckinghamshire	1641
2020-06-26,England,E10000003,Cambridgeshire	2020-06-26	England	E10000003	Cambridgeshire	2179
2020-06-26,England,E10000006,Cumbria	2020-06-26	England	E10000006	Cumbria	2638
2020-06-26,England,E10000007,Derbyshire	2020-06-26	England	E10000007	Derbyshire	3283
2020-06-26,England,E10000008,Devon	2020-06-26	England	E10000008	Devon	1182
2020-06-26,England,E10000011,East Sussex	2020-06-26	England	E10000011	East Sussex	1456
2020-06-26,England,E10000012,Essex	2020-06-26	England	E10000012	Essex	5334
2020-06-26,England,E10000014,Hampshire	2020-06-26	England	E10000014	Hampshire	4985
2020-06-26,England,E10000015,Hertfordshire	2020-06-26	England	E10000015	Hertfordshire	4047

Next page

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