cases

25 rows where TotalCases = 70

View and edit SQL

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

Link Date Country AreaCode Area TotalCases
2020-03-14 England E09000033 Westminster 70
2020-03-16 England E08000025 Birmingham 70
2020-03-17 England E09000003 Barnet 70
2020-03-20 England E10000031 Warwickshire 70
2020-03-21 England E10000034 Worcestershire 70
2020-03-22 England E09000031 Waltham Forest 70
2020-03-23 England E09000002 Barking and Dagenham 70
2020-03-23 England E09000016 Havering 70
2020-03-24 Scotland S08000024 Lothian 70
2020-03-25 England E08000009 Trafford 70
2020-03-26 England E06000044 Portsmouth 70
2020-03-27 England E08000015 Wirral 70
2020-03-29 England E06000055 Bedford 70
2020-03-30 Scotland S08000029 Fife 70
2020-03-31 Northern Ireland N09000007 Lisburn and Castlereagh 70
2020-04-01 England E08000023 South Tyneside 70
2020-04-01 Northern Ireland N09000002 Armagh, Banbridge and Craigavon 70
2020-04-03 England E06000014 York 70
2020-04-03 England E06000036 Bracknell Forest 70
2020-04-06 Northern Ireland N09000001 Antrim and Newtownabbey 70
2020-04-08 Northern Ireland N09000008 Mid and East Antrim 70
2020-04-19 Wales   Outside Wales 70
2020-05-03 Northern Ireland N09000006 Fermanagh and Omagh 70
2020-05-12 Wales   Unknown 70
2020-05-25 England E06000017 Rutland 70

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