cases

134 rows where "Date" is on date 2020-03-16 sorted by TotalCases

View and edit SQL

Country

Date (date)

  • 2020-03-16 · 34
Link Date Country AreaCode Area TotalCases ▼
2020-03-16 England E09000019 Islington 37
2020-03-16 England E10000025 Oxfordshire 37
2020-03-16 England E09000006 Bromley 39
2020-03-16 England E10000008 Devon 39
2020-03-16 England E09000023 Lewisham 40
2020-03-16 England E09000024 Merton 40
2020-03-16 England E10000024 Nottinghamshire 41
2020-03-16 England E08000031 Wolverhampton 44
2020-03-16 England E10000006 Cumbria 44
2020-03-16 Scotland S08000031 Greater Glasgow and Clyde 44
2020-03-16 England E10000012 Essex 45
2020-03-16 England E10000016 Kent 46
2020-03-16 England E08000019 Sheffield 49
2020-03-16 England E09000015 Harrow 51
2020-03-16 England E09000009 Ealing 52
2020-03-16 England E10000002 Buckinghamshire 52
2020-03-16 England E09000008 Croydon 53
2020-03-16 England E09000005 Brent 56
2020-03-16 England E09000020 Kensington and Chelsea 62
2020-03-16 England E10000007 Derbyshire 62
2020-03-16 England E09000003 Barnet 63
2020-03-16 England E10000015 Hertfordshire 68
2020-03-16 England E08000025 Birmingham 70
2020-03-16 England E10000030 Surrey 75
2020-03-16 England E09000032 Wandsworth 78
2020-03-16 Wales W11000028 Aneurin Bevan 82
2020-03-16 England E09000022 Lambeth 84
2020-03-16 England E09000033 Westminster 89
2020-03-16 England E09000028 Southwark 91
2020-03-16 England E10000014 Hampshire 103
2020-03-16 Scotland S08000017 Dumfries and Galloway NaN
2020-03-16 Scotland S08000022 Highland NaN
2020-03-16 Scotland S08000025 Orkney NaN
2020-03-16 Scotland S08000028 Western Isles NaN

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 52.345ms · About: https://github.com/tomwhite/covid-19-uk-data