This data as json, CSV (advanced)
Link | Date | Country ▼ | AreaCode | Area | TotalCases |
---|---|---|---|---|---|
2020-07-09,England,E10000011,East Sussex | 2020-07-09 | England | E10000011 | East Sussex | 1522 |
2020-07-09,England,E10000012,Essex | 2020-07-09 | England | E10000012 | Essex | 5462 |
2020-07-09,England,E10000013,Gloucestershire | 2020-07-09 | England | E10000013 | Gloucestershire | 1837 |
2020-07-09,England,E10000014,Hampshire | 2020-07-09 | England | E10000014 | Hampshire | 5018 |
2020-07-09,England,E10000015,Hertfordshire | 2020-07-09 | England | E10000015 | Hertfordshire | 4159 |
2020-07-09,England,E10000016,Kent | 2020-07-09 | England | E10000016 | Kent | 7759 |
2020-07-09,England,E10000017,Lancashire | 2020-07-09 | England | E10000017 | Lancashire | 6740 |
2020-07-09,England,E10000018,Leicestershire | 2020-07-09 | England | E10000018 | Leicestershire | 3087 |
2020-07-09,England,E10000019,Lincolnshire | 2020-07-09 | England | E10000019 | Lincolnshire | 2451 |
2020-07-09,England,E10000020,Norfolk | 2020-07-09 | England | E10000020 | Norfolk | 2861 |
2020-07-09,England,E10000021,Northamptonshire | 2020-07-09 | England | E10000021 | Northamptonshire | 3251 |
2020-07-09,England,E10000023,North Yorkshire | 2020-07-09 | England | E10000023 | North Yorkshire | 2531 |
2020-07-09,England,E10000024,Nottinghamshire | 2020-07-09 | England | E10000024 | Nottinghamshire | 2970 |
2020-07-09,England,E10000025,Oxfordshire | 2020-07-09 | England | E10000025 | Oxfordshire | 3125 |
2020-07-09,England,E10000027,Somerset | 2020-07-09 | England | E10000027 | Somerset | 1288 |
2020-07-09,England,E10000028,Staffordshire | 2020-07-09 | England | E10000028 | Staffordshire | 3724 |
2020-07-09,England,E10000030,Surrey | 2020-07-09 | England | E10000030 | Surrey | 4616 |
2020-07-09,England,E10000031,Warwickshire | 2020-07-09 | England | E10000031 | Warwickshire | 2498 |
2020-07-09,England,E10000032,West Sussex | 2020-07-09 | England | E10000032 | West Sussex | 2711 |
2020-07-09,England,E10000034,Worcestershire | 2020-07-09 | England | E10000034 | Worcestershire | 2368 |
2020-07-09,Scotland,S08000015,Ayrshire and Arran | 2020-07-09 | Scotland | S08000015 | Ayrshire and Arran | 1257 |
2020-07-09,Scotland,S08000016,Borders | 2020-07-09 | Scotland | S08000016 | Borders | 345 |
2020-07-09,Scotland,S08000017,Dumfries and Galloway | 2020-07-09 | Scotland | S08000017 | Dumfries and Galloway | 296 |
2020-07-09,Scotland,S08000019,Forth Valley | 2020-07-09 | Scotland | S08000019 | Forth Valley | 1085 |
2020-07-09,Scotland,S08000020,Grampian | 2020-07-09 | Scotland | S08000020 | Grampian | 1427 |
2020-07-09,Scotland,S08000022,Highland | 2020-07-09 | Scotland | S08000022 | Highland | 376 |
2020-07-09,Scotland,S08000024,Lothian | 2020-07-09 | Scotland | S08000024 | Lothian | 3159 |
2020-07-09,Scotland,S08000025,Orkney | 2020-07-09 | Scotland | S08000025 | Orkney | 9 |
2020-07-09,Scotland,S08000026,Shetland | 2020-07-09 | Scotland | S08000026 | Shetland | 54 |
2020-07-09,Scotland,S08000028,Western Isles | 2020-07-09 | Scotland | S08000028 | Western Isles | 7 |
2020-07-09,Scotland,S08000029,Fife | 2020-07-09 | Scotland | S08000029 | Fife | 932 |
2020-07-09,Scotland,S08000030,Tayside | 2020-07-09 | Scotland | S08000030 | Tayside | 1772 |
2020-07-09,Scotland,S08000031,Greater Glasgow and Clyde | 2020-07-09 | Scotland | S08000031 | Greater Glasgow and Clyde | 4865 |
2020-07-09,Scotland,S08000032,Lanarkshire | 2020-07-09 | Scotland | S08000032 | Lanarkshire | 2731 |
2020-07-09,Wales,,Outside Wales | 2020-07-09 | Wales | Outside Wales | 136 | |
2020-07-09,Wales,,Unknown | 2020-07-09 | Wales | Unknown | 138 | |
2020-07-09,Wales,W11000023,Betsi Cadwaladr | 2020-07-09 | Wales | W11000023 | Betsi Cadwaladr | 4326 |
2020-07-09,Wales,W11000024,Powys | 2020-07-09 | Wales | W11000024 | Powys | 325 |
2020-07-09,Wales,W11000025,Hywel Dda | 2020-07-09 | Wales | W11000025 | Hywel Dda | 1158 |
2020-07-09,Wales,W11000028,Aneurin Bevan | 2020-07-09 | Wales | W11000028 | Aneurin Bevan | 2705 |
2020-07-09,Wales,W11000029,Cardiff and Vale | 2020-07-09 | Wales | W11000029 | Cardiff and Vale | 3057 |
2020-07-09,Wales,W11000030,Cwm Taf | 2020-07-09 | Wales | W11000030 | Cwm Taf | 2986 |
2020-07-09,Wales,W11000031,Swansea Bay | 2020-07-09 | Wales | W11000031 | Swansea Bay | 1961 |
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]) );