cases

45 rows where TotalCases = 86

✎ View and edit SQL

This data as json, CSV (advanced)

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

Link Date Country AreaCode Area TotalCases
2020-03-21,England,E09000017,Hillingdon 2020-03-21 England E09000017 Hillingdon 86
2020-03-22,England,E09000013,Hammersmith and Fulham 2020-03-22 England E09000013 Hammersmith and Fulham 86
2020-03-22,England,E10000031,Warwickshire 2020-03-22 England E10000031 Warwickshire 86
2020-03-24,England,E08000021,Newcastle upon Tyne 2020-03-24 England E08000021 Newcastle upon Tyne 86
2020-03-24,England,E09000016,Havering 2020-03-24 England E09000016 Havering 86
2020-03-27,Northern Ireland,N09000003,Belfast 2020-03-27 Northern Ireland N09000003 Belfast 86
2020-03-28,England,E06000049,Cheshire East 2020-03-28 England E06000049 Cheshire East 86
2020-03-28,England,E08000032,Bradford 2020-03-28 England E08000032 Bradford 86
2020-03-31,Scotland,S08000020,Grampian 2020-03-31 Scotland S08000020 Grampian 86
2020-04-01,England,E06000011,East Riding of Yorkshire 2020-04-01 England E06000011 East Riding of Yorkshire 86
2020-04-03,England,E08000033,Calderdale 2020-04-03 England E08000033 Calderdale 86
2020-04-04,England,E06000020,Telford and Wrekin 2020-04-04 England E06000020 Telford and Wrekin 86
2020-04-04,England,E06000030,Swindon 2020-04-04 England E06000030 Swindon 86
2020-04-07,England,E06000019,Herefordshire, County of 2020-04-07 England E06000019 Herefordshire, County of 86
2020-04-24,Wales,,Outside Wales 2020-04-24 Wales   Outside Wales 86
2020-06-05,Northern Ireland,N09000006,Fermanagh and Omagh 2020-06-05 Northern Ireland N09000006 Fermanagh and Omagh 86
2020-06-06,Northern Ireland,N09000006,Fermanagh and Omagh 2020-06-06 Northern Ireland N09000006 Fermanagh and Omagh 86
2020-06-07,Northern Ireland,N09000006,Fermanagh and Omagh 2020-06-07 Northern Ireland N09000006 Fermanagh and Omagh 86
2020-06-08,Northern Ireland,N09000006,Fermanagh and Omagh 2020-06-08 Northern Ireland N09000006 Fermanagh and Omagh 86
2020-06-09,Northern Ireland,N09000006,Fermanagh and Omagh 2020-06-09 Northern Ireland N09000006 Fermanagh and Omagh 86
2020-06-10,Northern Ireland,N09000006,Fermanagh and Omagh 2020-06-10 Northern Ireland N09000006 Fermanagh and Omagh 86
2020-06-11,Northern Ireland,N09000006,Fermanagh and Omagh 2020-06-11 Northern Ireland N09000006 Fermanagh and Omagh 86
2020-06-12,Northern Ireland,N09000006,Fermanagh and Omagh 2020-06-12 Northern Ireland N09000006 Fermanagh and Omagh 86
2020-06-13,Northern Ireland,N09000006,Fermanagh and Omagh 2020-06-13 Northern Ireland N09000006 Fermanagh and Omagh 86
2020-06-14,England,E06000017,Rutland 2020-06-14 England E06000017 Rutland 86
2020-06-14,Northern Ireland,N09000006,Fermanagh and Omagh 2020-06-14 Northern Ireland N09000006 Fermanagh and Omagh 86
2020-06-15,Northern Ireland,N09000006,Fermanagh and Omagh 2020-06-15 Northern Ireland N09000006 Fermanagh and Omagh 86
2020-06-15,Wales,,Unknown 2020-06-15 Wales   Unknown 86
2020-06-16,Northern Ireland,N09000006,Fermanagh and Omagh 2020-06-16 Northern Ireland N09000006 Fermanagh and Omagh 86
2020-06-16,Wales,,Unknown 2020-06-16 Wales   Unknown 86
2020-06-17,Northern Ireland,N09000006,Fermanagh and Omagh 2020-06-17 Northern Ireland N09000006 Fermanagh and Omagh 86
2020-06-18,Northern Ireland,N09000006,Fermanagh and Omagh 2020-06-18 Northern Ireland N09000006 Fermanagh and Omagh 86
2020-06-19,Northern Ireland,N09000006,Fermanagh and Omagh 2020-06-19 Northern Ireland N09000006 Fermanagh and Omagh 86
2020-06-20,Northern Ireland,N09000006,Fermanagh and Omagh 2020-06-20 Northern Ireland N09000006 Fermanagh and Omagh 86
2020-06-21,Northern Ireland,N09000006,Fermanagh and Omagh 2020-06-21 Northern Ireland N09000006 Fermanagh and Omagh 86
2020-06-22,Northern Ireland,N09000006,Fermanagh and Omagh 2020-06-22 Northern Ireland N09000006 Fermanagh and Omagh 86
2020-06-23,Northern Ireland,N09000006,Fermanagh and Omagh 2020-06-23 Northern Ireland N09000006 Fermanagh and Omagh 86
2020-06-24,Northern Ireland,N09000006,Fermanagh and Omagh 2020-06-24 Northern Ireland N09000006 Fermanagh and Omagh 86
2020-06-25,Northern Ireland,N09000006,Fermanagh and Omagh 2020-06-25 Northern Ireland N09000006 Fermanagh and Omagh 86
2020-06-26,Northern Ireland,N09000006,Fermanagh and Omagh 2020-06-26 Northern Ireland N09000006 Fermanagh and Omagh 86
2020-06-27,Northern Ireland,N09000006,Fermanagh and Omagh 2020-06-27 Northern Ireland N09000006 Fermanagh and Omagh 86
2020-06-28,Northern Ireland,N09000006,Fermanagh and Omagh 2020-06-28 Northern Ireland N09000006 Fermanagh and Omagh 86
2020-06-29,Northern Ireland,N09000006,Fermanagh and Omagh 2020-06-29 Northern Ireland N09000006 Fermanagh and Omagh 86
2020-06-30,Northern Ireland,N09000006,Fermanagh and Omagh 2020-06-30 Northern Ireland N09000006 Fermanagh and Omagh 86
2020-07-01,Northern Ireland,N09000006,Fermanagh and Omagh 2020-07-01 Northern Ireland N09000006 Fermanagh and Omagh 86

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