cases

17 rows where TotalCases = 90

View and edit SQL

Suggested facets: Date, Country, Date (date)

Link Date Country AreaCode Area TotalCases
2020-03-19 England E10000007 Derbyshire 90
2020-03-20 England E10000012 Essex 90
2020-03-21 England E09000024 Merton 90
2020-03-21 Wales W11000029 Cardiff and Vale 90
2020-03-23 England E08000012 Liverpool 90
2020-03-23 England E08000030 Walsall 90
2020-03-25 Wales W11000030 Cwm Taf 90
2020-03-26 England E09000021 Kingston upon Thames 90
2020-03-26 England E10000019 Lincolnshire 90
2020-03-27 England E06000016 Leicester 90
2020-03-28 Scotland S08000015 Ayrshire and Arran 90
2020-03-30 England E06000025 South Gloucestershire 90
2020-03-31 England E06000055 Bedford 90
2020-04-08 England E06000024 North Somerset 90
2020-04-14 England E06000012 North East Lincolnshire 90
2020-06-18 Wales   Unknown 90
2020-06-30 England E06000017 Rutland 90

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