This data as json, CSV (advanced)
Link | Date | Country ▼ | AreaCode | Area | TotalCases |
---|---|---|---|---|---|
2020-07-01,England,E08000025,Birmingham | 2020-07-01 | England | E08000025 | Birmingham | 4767 |
2020-07-01,England,E08000026,Coventry | 2020-07-01 | England | E08000026 | Coventry | 1316 |
2020-07-01,England,E08000027,Dudley | 2020-07-01 | England | E08000027 | Dudley | 1296 |
2020-07-01,England,E08000028,Sandwell | 2020-07-01 | England | E08000028 | Sandwell | 1622 |
2020-07-01,England,E08000030,Walsall | 2020-07-01 | England | E08000030 | Walsall | 1451 |
2020-07-01,England,E08000031,Wolverhampton | 2020-07-01 | England | E08000031 | Wolverhampton | 1372 |
2020-07-01,England,E08000032,Bradford | 2020-07-01 | England | E08000032 | Bradford | 4122 |
2020-07-01,England,E08000033,Calderdale | 2020-07-01 | England | E08000033 | Calderdale | 657 |
2020-07-01,England,E08000034,Kirklees | 2020-07-01 | England | E08000034 | Kirklees | 1967 |
2020-07-01,England,E08000035,Leeds | 2020-07-01 | England | E08000035 | Leeds | 3589 |
2020-07-01,England,E08000036,Wakefield | 2020-07-01 | England | E08000036 | Wakefield | 1615 |
2020-07-01,England,E08000037,Gateshead | 2020-07-01 | England | E08000037 | Gateshead | 1272 |
2020-07-01,England,E09000002,Barking and Dagenham | 2020-07-01 | England | E09000002 | Barking and Dagenham | 708 |
2020-07-01,England,E09000003,Barnet | 2020-07-01 | England | E09000003 | Barnet | 1586 |
2020-07-01,England,E09000004,Bexley | 2020-07-01 | England | E09000004 | Bexley | 1046 |
2020-07-01,England,E09000005,Brent | 2020-07-01 | England | E09000005 | Brent | 1731 |
2020-07-01,England,E09000007,Camden | 2020-07-01 | England | E09000007 | Camden | 701 |
2020-07-01,England,E09000008,Croydon | 2020-07-01 | England | E09000008 | Croydon | 1846 |
2020-07-01,England,E09000009,Ealing | 2020-07-01 | England | E09000009 | Ealing | 1551 |
2020-07-01,England,E09000010,Enfield | 2020-07-01 | England | E09000010 | Enfield | 1176 |
2020-07-01,England,E09000012,Hackney and City of London | 2020-07-01 | England | E09000012 | Hackney and City of London | 804 |
2020-07-01,England,E09000013,Hammersmith and Fulham | 2020-07-01 | England | E09000013 | Hammersmith and Fulham | 752 |
2020-07-01,England,E09000014,Haringey | 2020-07-01 | England | E09000014 | Haringey | 743 |
2020-07-01,England,E09000016,Havering | 2020-07-01 | England | E09000016 | Havering | 932 |
2020-07-01,England,E09000017,Hillingdon | 2020-07-01 | England | E09000017 | Hillingdon | 1085 |
2020-07-01,England,E09000018,Hounslow | 2020-07-01 | England | E09000018 | Hounslow | 1056 |
2020-07-01,England,E09000019,Islington | 2020-07-01 | England | E09000019 | Islington | 546 |
2020-07-01,England,E09000021,Kingston upon Thames | 2020-07-01 | England | E09000021 | Kingston upon Thames | 733 |
2020-07-01,England,E09000022,Lambeth | 2020-07-01 | England | E09000022 | Lambeth | 1351 |
2020-07-01,England,E09000024,Merton | 2020-07-01 | England | E09000024 | Merton | 933 |
2020-07-01,England,E09000025,Newham | 2020-07-01 | England | E09000025 | Newham | 1265 |
2020-07-01,England,E09000026,Redbridge | 2020-07-01 | England | E09000026 | Redbridge | 1104 |
2020-07-01,England,E09000027,Richmond upon Thames | 2020-07-01 | England | E09000027 | Richmond upon Thames | 532 |
2020-07-01,England,E09000028,Southwark | 2020-07-01 | England | E09000028 | Southwark | 1434 |
2020-07-01,England,E09000029,Sutton | 2020-07-01 | England | E09000029 | Sutton | 999 |
2020-07-01,England,E09000031,Waltham Forest | 2020-07-01 | England | E09000031 | Waltham Forest | 1011 |
2020-07-01,England,E09000033,Westminster | 2020-07-01 | England | E09000033 | Westminster | 776 |
2020-07-01,England,E10000002,Buckinghamshire | 2020-07-01 | England | E10000002 | Buckinghamshire | 1660 |
2020-07-01,England,E10000003,Cambridgeshire | 2020-07-01 | England | E10000003 | Cambridgeshire | 2190 |
2020-07-01,England,E10000006,Cumbria | 2020-07-01 | England | E10000006 | Cumbria | 2664 |
2020-07-01,England,E10000007,Derbyshire | 2020-07-01 | England | E10000007 | Derbyshire | 3316 |
2020-07-01,England,E10000008,Devon | 2020-07-01 | England | E10000008 | Devon | 1188 |
2020-07-01,England,E10000011,East Sussex | 2020-07-01 | England | E10000011 | East Sussex | 1483 |
2020-07-01,England,E10000012,Essex | 2020-07-01 | England | E10000012 | Essex | 5362 |
2020-07-01,England,E10000013,Gloucestershire | 2020-07-01 | England | E10000013 | Gloucestershire | 1825 |
2020-07-01,England,E10000014,Hampshire | 2020-07-01 | England | E10000014 | Hampshire | 4994 |
2020-07-01,England,E10000015,Hertfordshire | 2020-07-01 | England | E10000015 | Hertfordshire | 4076 |
2020-07-01,England,E10000016,Kent | 2020-07-01 | England | E10000016 | Kent | 7601 |
2020-07-01,England,E10000017,Lancashire | 2020-07-01 | England | E10000017 | Lancashire | 6607 |
2020-07-01,England,E10000018,Leicestershire | 2020-07-01 | England | E10000018 | Leicestershire | 2966 |
2020-07-01,England,E10000019,Lincolnshire | 2020-07-01 | England | E10000019 | Lincolnshire | 2417 |
2020-07-01,England,E10000021,Northamptonshire | 2020-07-01 | England | E10000021 | Northamptonshire | 3122 |
2020-07-01,England,E10000023,North Yorkshire | 2020-07-01 | England | E10000023 | North Yorkshire | 2512 |
2020-07-01,England,E10000024,Nottinghamshire | 2020-07-01 | England | E10000024 | Nottinghamshire | 2938 |
2020-07-01,England,E10000025,Oxfordshire | 2020-07-01 | England | E10000025 | Oxfordshire | 3082 |
2020-07-01,England,E10000027,Somerset | 2020-07-01 | England | E10000027 | Somerset | 1278 |
2020-07-01,England,E10000028,Staffordshire | 2020-07-01 | England | E10000028 | Staffordshire | 3642 |
2020-07-01,England,E10000029,Suffolk | 2020-07-01 | England | E10000029 | Suffolk | 2610 |
2020-07-01,England,E10000030,Surrey | 2020-07-01 | England | E10000030 | Surrey | 4558 |
2020-07-01,England,E10000031,Warwickshire | 2020-07-01 | England | E10000031 | Warwickshire | 2455 |
2020-07-01,England,E10000032,West Sussex | 2020-07-01 | England | E10000032 | West Sussex | 2687 |
2020-07-01,England,E10000034,Worcestershire | 2020-07-01 | England | E10000034 | Worcestershire | 2346 |
2020-07-01,Northern Ireland,,Not Known | 2020-07-01 | Northern Ireland | Not Known | 347 | |
2020-07-01,Northern Ireland,N09000001,Antrim and Newtownabbey | 2020-07-01 | Northern Ireland | N09000001 | Antrim and Newtownabbey | 414 |
2020-07-01,Northern Ireland,N09000002,Armagh City, Banbridge and Craigavon | 2020-07-01 | Northern Ireland | N09000002 | Armagh City, Banbridge and Craigavon | 542 |
2020-07-01,Northern Ireland,N09000003,Belfast | 2020-07-01 | Northern Ireland | N09000003 | Belfast | 1327 |
2020-07-01,Northern Ireland,N09000004,Causeway Coast and Glens | 2020-07-01 | Northern Ireland | N09000004 | Causeway Coast and Glens | 250 |
2020-07-01,Northern Ireland,N09000005,Derry City and Strabane | 2020-07-01 | Northern Ireland | N09000005 | Derry City and Strabane | 177 |
2020-07-01,Northern Ireland,N09000006,Fermanagh and Omagh | 2020-07-01 | Northern Ireland | N09000006 | Fermanagh and Omagh | 86 |
2020-07-01,Northern Ireland,N09000007,Lisburn and Castlereagh | 2020-07-01 | Northern Ireland | N09000007 | Lisburn and Castlereagh | 456 |
2020-07-01,Northern Ireland,N09000008,Mid and East Antrim | 2020-07-01 | Northern Ireland | N09000008 | Mid and East Antrim | 334 |
2020-07-01,Northern Ireland,N09000009,Mid Ulster | 2020-07-01 | Northern Ireland | N09000009 | Mid Ulster | 257 |
2020-07-01,Northern Ireland,N09000010,Newry, Mourne and Down | 2020-07-01 | Northern Ireland | N09000010 | Newry, Mourne and Down | 294 |
2020-07-01,Northern Ireland,N09000011,Ards and North Down | 2020-07-01 | Northern Ireland | N09000011 | Ards and North Down | 396 |
2020-07-01,Scotland,S08000015,Ayrshire and Arran | 2020-07-01 | Scotland | S08000015 | Ayrshire and Arran | 1255 |
2020-07-01,Scotland,S08000016,Borders | 2020-07-01 | Scotland | S08000016 | Borders | 345 |
2020-07-01,Scotland,S08000017,Dumfries and Galloway | 2020-07-01 | Scotland | S08000017 | Dumfries and Galloway | 291 |
2020-07-01,Scotland,S08000019,Forth Valley | 2020-07-01 | Scotland | S08000019 | Forth Valley | 1070 |
2020-07-01,Scotland,S08000020,Grampian | 2020-07-01 | Scotland | S08000020 | Grampian | 1421 |
2020-07-01,Scotland,S08000022,Highland | 2020-07-01 | Scotland | S08000022 | Highland | 375 |
2020-07-01,Scotland,S08000024,Lothian | 2020-07-01 | Scotland | S08000024 | Lothian | 3151 |
2020-07-01,Scotland,S08000025,Orkney | 2020-07-01 | Scotland | S08000025 | Orkney | 9 |
2020-07-01,Scotland,S08000026,Shetland | 2020-07-01 | Scotland | S08000026 | Shetland | 54 |
2020-07-01,Scotland,S08000028,Western Isles | 2020-07-01 | Scotland | S08000028 | Western Isles | 7 |
2020-07-01,Scotland,S08000029,Fife | 2020-07-01 | Scotland | S08000029 | Fife | 930 |
2020-07-01,Scotland,S08000030,Tayside | 2020-07-01 | Scotland | S08000030 | Tayside | 1769 |
2020-07-01,Scotland,S08000031,Greater Glasgow and Clyde | 2020-07-01 | Scotland | S08000031 | Greater Glasgow and Clyde | 4858 |
2020-07-01,Scotland,S08000032,Lanarkshire | 2020-07-01 | Scotland | S08000032 | Lanarkshire | 2724 |
2020-07-01,Wales,,Outside Wales | 2020-07-01 | Wales | Outside Wales | 135 | |
2020-07-01,Wales,,Unknown | 2020-07-01 | Wales | Unknown | 136 | |
2020-07-01,Wales,W11000023,Betsi Cadwaladr | 2020-07-01 | Wales | W11000023 | Betsi Cadwaladr | 4248 |
2020-07-01,Wales,W11000024,Powys | 2020-07-01 | Wales | W11000024 | Powys | 322 |
2020-07-01,Wales,W11000025,Hywel Dda | 2020-07-01 | Wales | W11000025 | Hywel Dda | 1145 |
2020-07-01,Wales,W11000028,Aneurin Bevan | 2020-07-01 | Wales | W11000028 | Aneurin Bevan | 2692 |
2020-07-01,Wales,W11000029,Cardiff and Vale | 2020-07-01 | Wales | W11000029 | Cardiff and Vale | 3039 |
2020-07-01,Wales,W11000030,Cwm Taf | 2020-07-01 | Wales | W11000030 | Cwm Taf | 2961 |
2020-07-01,Wales,W11000031,Swansea Bay | 2020-07-01 | Wales | W11000031 | Swansea Bay | 1947 |
JSON shape: default, array, newline-delimited, object
CREATE TABLE "cases" ( "Date" TEXT, "Country" TEXT, "AreaCode" TEXT, "Area" TEXT, "TotalCases" INTEGER ,PRIMARY KEY ([Date], [Country], [AreaCode], [Area]) );