cases

14 rows where TotalCases = 184

View and edit SQL

Suggested facets: Date, Country, Date (date)

Link Date Country AreaCode Area TotalCases
2020-03-29 Scotland S08000032 Lanarkshire 184
2020-03-31 England E08000018 Rotherham 184
2020-03-31 England E10000023 North Yorkshire 184
2020-04-01 England E08000014 Sefton 184
2020-04-04 England E08000005 Rochdale 184
2020-04-11 England E06000044 Portsmouth 184
2020-04-16 England E06000005 Darlington 184
2020-04-16 Scotland S08000022 Highland 184
2020-04-17 England E06000014 York 184
2020-04-19 England E06000036 Bracknell Forest 184
2020-04-20 England E06000019 Herefordshire, County of 184
2020-04-21 England E06000001 Hartlepool 184
2020-04-22 England E06000027 Torbay 184
2020-06-07 England E06000012 North East Lincolnshire 184

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