cases

26 rows where TotalCases = 65

View and edit SQL

Suggested facets: Date, Country, Date (date)

Link Date Country AreaCode Area TotalCases
2020-03-15 England E09000032 Wandsworth 65
2020-03-17 England E09000015 Harrow 65
2020-03-18 England E08000031 Wolverhampton 65
2020-03-18 England E10000002 Buckinghamshire 65
2020-03-19 England E09000010 Enfield 65
2020-03-20 England E09000030 Tower Hamlets 65
2020-03-21 England E09000026 Redbridge 65
2020-03-22 England E09000004 Bexley 65
2020-03-22 England E10000021 Northamptonshire 65
2020-03-23 England E10000013 Gloucestershire 65
2020-03-24 England E08000007 Stockport 65
2020-03-24 England E10000023 North Yorkshire 65
2020-03-24 Wales W11000030 Cwm Taf 65
2020-03-25 England E06000044 Portsmouth 65
2020-03-26 England E06000056 Central Bedfordshire 65
2020-03-26 England E08000005 Rochdale 65
2020-03-26 England E08000014 Sefton 65
2020-03-27 England E08000034 Kirklees 65
2020-03-28 England E06000057 Northumberland 65
2020-03-29 England E06000059 Dorset 65
2020-04-01 England E06000020 Telford and Wrekin 65
2020-04-02 Scotland S08000022 Highland 65
2020-04-03 England E06000022 Bath and North East Somerset 65
2020-04-06 Wales W11000024 Powys 65
2020-04-08 England E06000012 North East Lincolnshire 65
2020-04-27 Wales   Unknown 65

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