cases

15 rows where TotalCases = 168

View and edit SQL

Suggested facets: Date, Country, Date (date)

Link Date Country AreaCode Area TotalCases
2020-03-20 England E09000028 Southwark 168
2020-03-21 England E08000019 Sheffield 168
2020-03-23 England E10000016 Kent 168
2020-03-24 Wales W11000029 Cardiff and Vale 168
2020-03-26 England E09000012 Hackney and City of London 168
2020-03-26 England E09000017 Hillingdon 168
2020-03-27 England E10000002 Buckinghamshire 168
2020-03-29 England E09000004 Bexley 168
2020-03-31 England E08000029 Solihull 168
2020-04-01 England E06000023 Bristol, City of 168
2020-04-01 England E06000032 Luton 168
2020-04-11 England E06000008 Blackburn with Darwen 168
2020-04-14 Scotland S08000022 Highland 168
2020-04-19 England E06000019 Herefordshire, County of 168
2020-04-20 England E06000024 North Somerset 168

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