cases

12 rows where TotalCases = 1255

View and edit SQL

Suggested facets: Date, Country, AreaCode, Area, Date (date)

Link Date Country AreaCode Area TotalCases
2020-05-09 England E09000022 Lambeth 1255
2020-06-06 England E08000037 Gateshead 1255
2020-06-10 England E06000007 Warrington 1255
2020-06-10 England E09000015 Harrow 1255
2020-06-26 England E08000002 Bury 1255
2020-06-29 England E06000015 Derby 1255
2020-06-29 Scotland S08000015 Ayrshire and Arran 1255
2020-06-30 Scotland S08000015 Ayrshire and Arran 1255
2020-07-01 Scotland S08000015 Ayrshire and Arran 1255
2020-07-02 Scotland S08000015 Ayrshire and Arran 1255
2020-07-11 England E06000054 Wiltshire 1255
2020-07-18 England E06000056 Central Bedfordshire 1255

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