cases

20 rows where TotalCases = 261

View and edit SQL

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

Link Date Country AreaCode Area TotalCases
2020-03-24 England E09000005 Brent 261
2020-03-31 England E08000031 Wolverhampton 261
2020-03-31 England E09000030 Tower Hamlets 261
2020-04-02 England E09000004 Bexley 261
2020-04-03 England E08000014 Sefton 261
2020-04-11 Scotland S08000020 Grampian 261
2020-05-06 England E06000046 Isle of Wight 261
2020-05-07 Northern Ireland N09000011 Ards and North Down 261
2020-05-19 Northern Ireland N09000010 Newry, Mourne and Down 261
2020-06-04 Scotland S08000017 Dumfries and Galloway 261
2020-06-05 Scotland S08000017 Dumfries and Galloway 261
2020-06-06 Scotland S08000017 Dumfries and Galloway 261
2020-06-07 Scotland S08000017 Dumfries and Galloway 261
2020-06-08 Scotland S08000017 Dumfries and Galloway 261
2020-06-09 Scotland S08000017 Dumfries and Galloway 261
2020-06-10 Scotland S08000017 Dumfries and Galloway 261
2020-06-11 Scotland S08000017 Dumfries and Galloway 261
2020-06-12 Scotland S08000017 Dumfries and Galloway 261
2020-06-13 Scotland S08000017 Dumfries and Galloway 261
2020-06-14 Scotland S08000017 Dumfries and Galloway 261

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