cases

23 rows where TotalCases = 72

View and edit SQL

Suggested facets: Date, Area, Date (date)

Country

TotalCases

Link Date Country AreaCode Area TotalCases
2020-03-19 England E08000031 Wolverhampton 72
2020-03-20 England E09000014 Haringey 72
2020-03-20 England E10000024 Nottinghamshire 72
2020-03-20 Wales W11000029 Cardiff and Vale 72
2020-03-21 England E09000013 Hammersmith and Fulham 72
2020-03-21 England E09000019 Islington 72
2020-03-22 England E08000012 Liverpool 72
2020-03-24 England E08000006 Salford 72
2020-03-24 England E08000026 Coventry 72
2020-03-24 England E10000029 Suffolk 72
2020-03-27 England E08000032 Bradford 72
2020-03-30 England E06000002 Middlesbrough 72
2020-03-30 England E06000033 Southend-on-Sea 72
2020-03-31 England E06000004 Stockton-on-Tees 72
2020-04-02 England E06000020 Telford and Wrekin 72
2020-04-03 Scotland S08000022 Highland 72
2020-04-04 England E06000024 North Somerset 72
2020-04-05 England E06000019 Herefordshire, County of 72
2020-04-08 England E06000027 Torbay 72
2020-05-13 Wales   Unknown 72
2020-05-14 Wales   Unknown 72
2020-05-15 Wales   Unknown 72
2020-05-27 England E06000017 Rutland 72

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