cases

10 rows where Country = "England" and TotalCases = 83

View and edit SQL

Suggested facets: Date, Date (date)

Link Date Country AreaCode Area TotalCases
2020-03-20 England E09000024 Merton 83
2020-03-21 England E09000014 Haringey 83
2020-03-28 England E08000015 Wirral 83
2020-03-30 England E06000034 Thurrock 83
2020-03-30 England E08000037 Gateshead 83
2020-04-02 England E08000023 South Tyneside 83
2020-04-06 England E06000019 Herefordshire, County of 83
2020-04-07 England E06000010 Kingston upon Hull, City of 83
2020-04-11 England E06000001 Hartlepool 83
2020-06-08 England E06000017 Rutland 83

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