cases

12 rows where TotalCases = 115

View and edit SQL

Suggested facets: Date, Country, Date (date)

Link Date Country AreaCode Area TotalCases
2020-03-23 England E09000011 Greenwich 115
2020-03-23 England E10000031 Warwickshire 115
2020-03-24 England E08000012 Liverpool 115
2020-03-26 Wales W11000030 Cwm Taf 115
2020-03-27 England E10000029 Suffolk 115
2020-03-29 England E06000039 Slough 115
2020-03-31 England E08000036 Wakefield 115
2020-04-03 England E06000058 Bournemouth, Christchurch and Poole 115
2020-04-04 England E06000037 West Berkshire 115
2020-04-11 England E06000031 Peterborough 115
2020-04-14 Wales W11000024 Powys 115
2020-05-14 Wales   Outside Wales 115

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