cases

22,757 rows sorted by TotalCases

✎ View and edit SQL

This data as json, CSV (advanced)

Link Date Country AreaCode Area TotalCases ▼
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
2020-03-20,England,E08000031,Wolverhampton 2020-03-20 England E08000031 Wolverhampton 87
2020-03-20,England,E09000020,Kensington and Chelsea 2020-03-20 England E09000020 Kensington and Chelsea 87
2020-03-22,England,E09000025,Newham 2020-03-22 England E09000025 Newham 87
2020-03-24,England,E08000035,Leeds 2020-03-24 England E08000035 Leeds 87
2020-03-25,Scotland,S08000032,Lanarkshire 2020-03-25 Scotland S08000032 Lanarkshire 87
2020-03-26,England,E06000018,Nottingham 2020-03-26 England E06000018 Nottingham 87
2020-03-28,England,E06000056,Central Bedfordshire 2020-03-28 England E06000056 Central Bedfordshire 87
2020-03-30,England,E06000040,Windsor and Maidenhead 2020-03-30 England E06000040 Windsor and Maidenhead 87
2020-03-31,England,E06000002,Middlesbrough 2020-03-31 England E06000002 Middlesbrough 87
2020-03-31,England,E06000007,Warrington 2020-03-31 England E06000007 Warrington 87
2020-03-31,England,E06000033,Southend-on-Sea 2020-03-31 England E06000033 Southend-on-Sea 87
2020-04-01,England,E06000037,West Berkshire 2020-04-01 England E06000037 West Berkshire 87
2020-04-01,Scotland,S08000016,Borders 2020-04-01 Scotland S08000016 Borders 87
2020-04-25,Wales,,Outside Wales 2020-04-25 Wales   Outside Wales 87
2020-04-26,Wales,,Outside Wales 2020-04-26 Wales   Outside Wales 87
2020-06-15,England,E06000017,Rutland 2020-06-15 England E06000017 Rutland 87
2020-06-17,Wales,,Unknown 2020-06-17 Wales   Unknown 87
2020-03-18,England,E09000015,Harrow 2020-03-18 England E09000015 Harrow 88
2020-03-22,England,E09000007,Camden 2020-03-22 England E09000007 Camden 88
2020-03-22,England,E09000012,Hackney and City of London 2020-03-22 England E09000012 Hackney and City of London 88
2020-03-23,England,E09000030,Tower Hamlets 2020-03-23 England E09000030 Tower Hamlets 88
2020-03-24,England,E10000003,Cambridgeshire 2020-03-24 England E10000003 Cambridgeshire 88
2020-03-25,England,E08000026,Coventry 2020-03-25 England E08000026 Coventry 88
2020-03-25,England,E10000020,Norfolk 2020-03-25 England E10000020 Norfolk 88
2020-03-25,Scotland,S08000024,Lothian 2020-03-25 Scotland S08000024 Lothian 88
2020-03-26,England,E06000042,Milton Keynes 2020-03-26 England E06000042 Milton Keynes 88
2020-03-29,England,E06000045,Southampton 2020-03-29 England E06000045 Southampton 88
2020-03-29,England,E08000008,Tameside 2020-03-29 England E08000008 Tameside 88
2020-03-29,England,E08000024,Sunderland 2020-03-29 England E08000024 Sunderland 88
2020-03-29,England,E08000036,Wakefield 2020-03-29 England E08000036 Wakefield 88
2020-03-29,Wales,W11000023,Betsi Cadwaladr 2020-03-29 Wales W11000023 Betsi Cadwaladr 88
2020-04-01,England,E06000021,Stoke-on-Trent 2020-04-01 England E06000021 Stoke-on-Trent 88
2020-04-04,England,E06000009,Blackpool 2020-04-04 England E06000009 Blackpool 88
2020-04-06,England,E06000014,York 2020-04-06 England E06000014 York 88
2020-04-27,Wales,,Outside Wales 2020-04-27 Wales   Outside Wales 88
2020-06-24,England,E06000017,Rutland 2020-06-24 England E06000017 Rutland 88
2020-03-16,England,E09000033,Westminster 2020-03-16 England E09000033 Westminster 89
2020-03-18,England,E09000008,Croydon 2020-03-18 England E09000008 Croydon 89
2020-03-21,England,E09000018,Hounslow 2020-03-21 England E09000018 Hounslow 89
2020-03-21,England,E10000002,Buckinghamshire 2020-03-21 England E10000002 Buckinghamshire 89
2020-03-22,England,E10000024,Nottinghamshire 2020-03-22 England E10000024 Nottinghamshire 89
2020-03-23,England,E10000032,West Sussex 2020-03-23 England E10000032 West Sussex 89
2020-03-26,England,E08000007,Stockport 2020-03-26 England E08000007 Stockport 89
2020-03-26,England,E08000016,Barnsley 2020-03-26 England E08000016 Barnsley 89
2020-03-26,England,E10000023,North Yorkshire 2020-03-26 England E10000023 North Yorkshire 89
2020-03-27,England,E06000032,Luton 2020-03-27 England E06000032 Luton 89
2020-03-28,England,E08000005,Rochdale 2020-03-28 England E08000005 Rochdale 89
2020-03-29,England,E08000034,Kirklees 2020-03-29 England E08000034 Kirklees 89
2020-04-06,England,E06000031,Peterborough 2020-04-06 England E06000031 Peterborough 89
2020-04-07,England,E06000005,Darlington 2020-04-07 England E06000005 Darlington 89
2020-04-07,England,E06000022,Bath and North East Somerset 2020-04-07 England E06000022 Bath and North East Somerset 89
2020-04-09,Northern Ireland,N09000001,Antrim and Newtownabbey 2020-04-09 Northern Ireland N09000001 Antrim and Newtownabbey 89
2020-04-12,England,E06000001,Hartlepool 2020-04-12 England E06000001 Hartlepool 89
2020-04-28,Wales,,Outside Wales 2020-04-28 Wales   Outside Wales 89
2020-06-29,England,E06000017,Rutland 2020-06-29 England E06000017 Rutland 89
2020-03-19,England,E10000007,Derbyshire 2020-03-19 England E10000007 Derbyshire 90
2020-03-20,England,E10000012,Essex 2020-03-20 England E10000012 Essex 90
2020-03-21,England,E09000024,Merton 2020-03-21 England E09000024 Merton 90
2020-03-21,Wales,W11000029,Cardiff and Vale 2020-03-21 Wales W11000029 Cardiff and Vale 90
2020-03-23,England,E08000012,Liverpool 2020-03-23 England E08000012 Liverpool 90
2020-03-23,England,E08000030,Walsall 2020-03-23 England E08000030 Walsall 90
2020-03-25,Wales,W11000030,Cwm Taf 2020-03-25 Wales W11000030 Cwm Taf 90
2020-03-26,England,E09000021,Kingston upon Thames 2020-03-26 England E09000021 Kingston upon Thames 90
2020-03-26,England,E10000019,Lincolnshire 2020-03-26 England E10000019 Lincolnshire 90
2020-03-27,England,E06000016,Leicester 2020-03-27 England E06000016 Leicester 90
2020-03-28,Scotland,S08000015,Ayrshire and Arran 2020-03-28 Scotland S08000015 Ayrshire and Arran 90
2020-03-30,England,E06000025,South Gloucestershire 2020-03-30 England E06000025 South Gloucestershire 90
2020-03-31,England,E06000055,Bedford 2020-03-31 England E06000055 Bedford 90
2020-04-08,England,E06000024,North Somerset 2020-04-08 England E06000024 North Somerset 90
2020-04-14,England,E06000012,North East Lincolnshire 2020-04-14 England E06000012 North East Lincolnshire 90
2020-06-18,Wales,,Unknown 2020-06-18 Wales   Unknown 90
2020-06-30,England,E06000017,Rutland 2020-06-30 England E06000017 Rutland 90
2020-03-16,England,E09000028,Southwark 2020-03-16 England E09000028 Southwark 91
2020-03-20,Scotland,S08000031,Greater Glasgow and Clyde 2020-03-20 Scotland S08000031 Greater Glasgow and Clyde 91
2020-03-22,England,E10000018,Leicestershire 2020-03-22 England E10000018 Leicestershire 91
2020-03-23,England,E09000031,Waltham Forest 2020-03-23 England E09000031 Waltham Forest 91
2020-03-27,England,E06000035,Medway 2020-03-27 England E06000035 Medway 91
2020-03-30,England,E06000043,Brighton and Hove 2020-03-30 England E06000043 Brighton and Hove 91
2020-04-01,England,E06000044,Portsmouth 2020-04-01 England E06000044 Portsmouth 91
2020-04-03,Northern Ireland,N09000002,Armagh, Banbridge and Craigavon 2020-04-03 Northern Ireland N09000002 Armagh, Banbridge and Craigavon 91
2020-04-05,England,E06000009,Blackpool 2020-04-05 England E06000009 Blackpool 91
2020-04-08,England,E06000019,Herefordshire, County of 2020-04-08 England E06000019 Herefordshire, County of 91
2020-04-16,England,E06000012,North East Lincolnshire 2020-04-16 England E06000012 North East Lincolnshire 91
2020-07-05,England,E06000017,Rutland 2020-07-05 England E06000017 Rutland 91
2020-03-21,England,E09000020,Kensington and Chelsea 2020-03-21 England E09000020 Kensington and Chelsea 92
2020-03-24,England,E08000027,Dudley 2020-03-24 England E08000027 Dudley 92
2020-03-25,England,E09000027,Richmond upon Thames 2020-03-25 England E09000027 Richmond upon Thames 92

Next page

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