cases

118 rows where TotalCases = 3

View and edit SQL

Country

TotalCases

Link Date Country AreaCode Area TotalCases
2020-03-16 England E08000029 Solihull 3
2020-03-16 Wales   Unknown 3
2020-03-17 England E06000055 Bedford 3
2020-03-17 Wales   Unknown 3
2020-03-18 England E06000020 Telford and Wrekin 3
2020-03-18 England E06000031 Peterborough 3
2020-03-18 England E08000023 South Tyneside 3
2020-03-19 England E06000003 Redcar and Cleveland 3
2020-03-19 England E06000005 Darlington 3
2020-03-20 England E06000001 Hartlepool 3
2020-03-20 England E06000008 Blackburn with Darwen 3
2020-03-20 England E06000046 Isle of Wight 3
2020-03-20 England E08000037 Gateshead 3
2020-03-20 Wales   Outside Wales 3
2020-03-21 England E06000012 North East Lincolnshire 3
2020-03-21 Wales   Outside Wales 3
2020-03-22 Wales   Outside Wales 3
2020-03-26 England E06000017 Rutland 3

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