cases

27 rows where TotalCases = 41

View and edit SQL

Suggested facets: Country, AreaCode, Date (date)

Link Date Country AreaCode Area TotalCases
2020-03-14 England E10000002 Buckinghamshire 41
2020-03-16 England E10000024 Nottinghamshire 41
2020-03-17 England E09000007 Camden 41
2020-03-17 England E10000008 Devon 41
2020-03-20 England E09000016 Havering 41
2020-03-20 England E10000013 Gloucestershire 41
2020-03-20 Scotland S08000032 Lanarkshire 41
2020-03-21 England E08000035 Leeds 41
2020-03-21 England E10000023 North Yorkshire 41
2020-03-22 England E06000023 Bristol, City of 41
2020-03-22 England E06000054 Wiltshire 41
2020-03-23 England E06000052 Cornwall and Isles of Scilly 41
2020-03-24 England E06000043 Brighton and Hove 41
2020-03-24 England E06000049 Cheshire East 41
2020-03-24 Scotland S08000015 Ayrshire and Arran 41
2020-03-25 England E06000045 Southampton 41
2020-03-27 England E06000026 Plymouth 41
2020-03-27 Scotland S08000029 Fife 41
2020-03-28 England E06000002 Middlesbrough 41
2020-03-28 England E06000003 Redcar and Cleveland 41
2020-03-28 England E06000022 Bath and North East Somerset 41
2020-03-29 Scotland S08000022 Highland 41
2020-03-30 Northern Ireland N09000010 Newry, Mourne and Down 41
2020-04-01 England E06000013 North Lincolnshire 41
2020-04-05 Scotland S08000026 Shetland 41
2020-04-06 Scotland S08000026 Shetland 41
2020-04-06 Wales   Unknown 41

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