cases

39 rows where TotalCases = 35

View and edit SQL

Suggested facets: Date, Country, Date (date)

Link Date Country AreaCode Area TotalCases
2020-03-11 England E09000028 Southwark 35
2020-03-14 England E10000007 Derbyshire 35
2020-03-15 England E08000019 Sheffield 35
2020-03-15 England E10000008 Devon 35
2020-03-16 England E06000039 Slough 35
2020-03-16 England E10000028 Staffordshire 35
2020-03-17 England E09000025 Newham 35
2020-03-17 England E10000031 Warwickshire 35
2020-03-18 England E10000018 Leicestershire 35
2020-03-19 England E08000003 Manchester 35
2020-03-19 England E08000007 Stockport 35
2020-03-19 England E08000012 Liverpool 35
2020-03-19 England E10000020 Norfolk 35
2020-03-19 England E10000021 Northamptonshire 35
2020-03-19 Scotland S08000024 Lothian 35
2020-03-20 England E08000021 Newcastle upon Tyne 35
2020-03-20 England E08000035 Leeds 35
2020-03-20 England E09000021 Kingston upon Thames 35
2020-03-21 England E06000054 Wiltshire 35
2020-03-21 England E08000004 Oldham 35
2020-03-22 England E06000032 Luton 35
2020-03-22 England E06000052 Cornwall and Isles of Scilly 35
2020-03-22 England E10000019 Lincolnshire 35
2020-03-23 England E08000005 Rochdale 35
2020-03-24 England E06000045 Southampton 35
2020-03-24 England E08000002 Bury 35
2020-03-24 England E08000014 Sefton 35
2020-03-24 England E08000017 Doncaster 35
2020-03-24 England E08000032 Bradford 35
2020-03-25 England E06000038 Reading 35
2020-03-25 England E10000027 Somerset 35
2020-03-26 England E06000022 Bath and North East Somerset 35
2020-03-26 England E06000033 Southend-on-Sea 35
2020-03-28 Scotland S08000016 Borders 35
2020-03-29 England E06000019 Herefordshire, County of 35
2020-03-29 England E06000036 Bracknell Forest 35
2020-03-30 Wales W11000024 Powys 35
2020-04-03 Northern Ireland N09000005 Derry and Strabane 35
2020-04-08 Northern Ireland N09000004 Causeway Coast and Glens 35

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