cases

18 rows where TotalCases = 60

View and edit SQL

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

Link Date Country AreaCode Area TotalCases
2020-03-13 England E09000033 Westminster 60
2020-03-19 Wales W11000029 Cardiff and Vale 60
2020-03-20 England E09000013 Hammersmith and Fulham 60
2020-03-20 England E10000017 Lancashire 60
2020-03-21 England E08000028 Sandwell 60
2020-03-22 England E09000016 Havering 60
2020-03-24 England E08000009 Trafford 60
2020-03-25 England E06000054 Wiltshire 60
2020-03-26 England E08000008 Tameside 60
2020-03-27 England E06000050 Cheshire West and Chester 60
2020-03-28 England E08000001 Bolton 60
2020-03-28 Scotland S08000017 Dumfries and Galloway 60
2020-04-02 England E06000036 Bracknell Forest 60
2020-04-05 Wales W11000024 Powys 60
2020-04-07 England E06000001 Hartlepool 60
2020-04-15 England E06000046 Isle of Wight 60
2020-04-22 Wales   Unknown 60
2020-04-23 Wales   Unknown 60

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