cases

148 rows where Country = "England" and "Date" is on date 2020-05-08 sorted by TotalCases

View and edit SQL

Date (date)

  • 2020-05-08 · 48

Country

  • England · 48
Link Date Country AreaCode Area TotalCases ▼
2020-05-08 England E08000014 Sefton 1162
2020-05-08 England E08000001 Bolton 1192
2020-05-08 England E08000028 Sandwell 1197
2020-05-08 England E06000050 Cheshire West and Chester 1201
2020-05-08 England E08000030 Walsall 1212
2020-05-08 England E08000007 Stockport 1228
2020-05-08 England E08000021 Newcastle upon Tyne 1229
2020-05-08 England E06000057 Northumberland 1239
2020-05-08 England E09000022 Lambeth 1249
2020-05-08 England E09000009 Ealing 1310
2020-05-08 England E09000028 Southwark 1330
2020-05-08 England E09000006 Bromley 1367
2020-05-08 England E06000049 Cheshire East 1380
2020-05-08 England E10000003 Cambridgeshire 1387
2020-05-08 England E08000015 Wirral 1398
2020-05-08 England E09000003 Barnet 1418
2020-05-08 England E10000019 Lincolnshire 1487
2020-05-08 England E10000018 Leicestershire 1528
2020-05-08 England E08000024 Sunderland 1536
2020-05-08 England E09000005 Brent 1552
2020-05-08 England E08000010 Wigan 1563
2020-05-08 England E10000013 Gloucestershire 1576
2020-05-08 England E10000021 Northamptonshire 1627
2020-05-08 England E08000032 Bradford 1654
2020-05-08 England E09000008 Croydon 1672
2020-05-08 England E10000023 North Yorkshire 1711
2020-05-08 England E08000003 Manchester 1742
2020-05-08 England E10000031 Warwickshire 1752
2020-05-08 England E10000034 Worcestershire 1804
2020-05-08 England E10000024 Nottinghamshire 1849
2020-05-08 England E08000012 Liverpool 1903
2020-05-08 England E10000029 Suffolk 1916
2020-05-08 England E10000032 West Sussex 2058
2020-05-08 England E10000007 Derbyshire 2112
2020-05-08 England E10000025 Oxfordshire 2141
2020-05-08 England E10000020 Norfolk 2191
2020-05-08 England E10000006 Cumbria 2304
2020-05-08 England E06000047 County Durham 2323
2020-05-08 England E08000035 Leeds 2411
2020-05-08 England E10000028 Staffordshire 2538
2020-05-08 England E08000019 Sheffield 2749
2020-05-08 England E10000015 Hertfordshire 3228
2020-05-08 England E08000025 Birmingham 3673
2020-05-08 England E10000030 Surrey 3697
2020-05-08 England E10000014 Hampshire 3997
2020-05-08 England E10000012 Essex 4094
2020-05-08 England E10000017 Lancashire 4206
2020-05-08 England E10000016 Kent 4832

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE "cases" (
"Date" TEXT,
  "Country" TEXT,
  "AreaCode" TEXT,
  "Area" TEXT,
  "TotalCases" INTEGER
  ,PRIMARY KEY ([Date], [Country], [AreaCode], [Area])
);
Powered by Datasette · Query took 65.211ms · About: https://github.com/tomwhite/covid-19-uk-data