cases

33 rows where TotalCases = 32

View and edit SQL

Suggested facets: Date, Date (date)

TotalCases

Link Date Country AreaCode Area TotalCases
2020-03-11 England E10000015 Hertfordshire 32
2020-03-12 England E10000002 Buckinghamshire 32
2020-03-14 England E10000008 Devon 32
2020-03-15 England E09000014 Haringey 32
2020-03-15 England E09000019 Islington 32
2020-03-15 England E10000006 Cumbria 32
2020-03-16 England E09000011 Greenwich 32
2020-03-16 England E09000013 Hammersmith and Fulham 32
2020-03-16 England E09000017 Hillingdon 32
2020-03-16 Wales W11000031 Swansea Bay 32
2020-03-18 England E08000030 Walsall 32
2020-03-18 England E10000013 Gloucestershire 32
2020-03-18 England E10000020 Norfolk 32
2020-03-20 England E08000009 Trafford 32
2020-03-21 England E06000040 Windsor and Maidenhead 32
2020-03-21 England E06000042 Milton Keynes 32
2020-03-21 England E06000052 Cornwall and Isles of Scilly 32
2020-03-22 England E06000049 Cheshire East 32
2020-03-22 England E06000056 Central Bedfordshire 32
2020-03-22 Wales W11000030 Cwm Taf 32
2020-03-24 England E06000055 Bedford 32
2020-03-24 Wales W11000023 Betsi Cadwaladr 32
2020-03-25 England E08000022 North Tyneside 32
2020-03-27 England E06000007 Warrington 32
2020-03-27 England E06000031 Peterborough 32
2020-03-27 England E08000037 Gateshead 32
2020-03-31 Northern Ireland N09000008 Mid and East Antrim 32
2020-04-01 Northern Ireland N09000006 Fermanagh and Omagh 32
2020-04-01 Wales   Unknown 32
2020-04-03 Wales   Outside Wales 32
2020-04-04 Wales   Outside Wales 32
2020-04-07 Northern Ireland N09000004 Causeway Coast and Glens 32
2020-05-03 England E06000017 Rutland 32

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