cases

14 rows where TotalCases = 259

View and edit SQL

Suggested facets: Country, Date (date)

Link Date Country AreaCode Area TotalCases
2020-03-25 England E10000016 Kent 259
2020-03-29 England E10000024 Nottinghamshire 259
2020-03-30 Wales W11000030 Cwm Taf 259
2020-04-05 England E08000018 Rotherham 259
2020-04-06 England E06000057 Northumberland 259
2020-04-08 Scotland S08000019 Forth Valley 259
2020-04-13 England E06000011 East Riding of Yorkshire 259
2020-04-26 Scotland S08000016 Borders 259
2020-05-01 Scotland S08000022 Highland 259
2020-05-02 England E06000036 Bracknell Forest 259
2020-05-04 Northern Ireland N09000008 Mid and East Antrim 259
2020-05-06 Northern Ireland N09000011 Ards and North Down 259
2020-05-18 Northern Ireland N09000010 Newry, Mourne and Down 259
2020-05-20 England E06000027 Torbay 259

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