This data as json, CSV (advanced)
Link | Date | Country ▼ | AreaCode | Area | TotalCases |
---|---|---|---|---|---|
2020-05-14,Scotland,S08000015,Ayrshire and Arran | 2020-05-14 | Scotland | S08000015 | Ayrshire and Arran | 952 |
2020-05-14,Scotland,S08000016,Borders | 2020-05-14 | Scotland | S08000016 | Borders | 298 |
2020-05-14,Scotland,S08000017,Dumfries and Galloway | 2020-05-14 | Scotland | S08000017 | Dumfries and Galloway | 255 |
2020-05-14,Scotland,S08000019,Forth Valley | 2020-05-14 | Scotland | S08000019 | Forth Valley | 863 |
2020-05-14,Scotland,S08000020,Grampian | 2020-05-14 | Scotland | S08000020 | Grampian | 1142 |
2020-05-14,Scotland,S08000022,Highland | 2020-05-14 | Scotland | S08000022 | Highland | 328 |
2020-05-14,Scotland,S08000024,Lothian | 2020-05-14 | Scotland | S08000024 | Lothian | 2459 |
2020-05-14,Scotland,S08000025,Orkney | 2020-05-14 | Scotland | S08000025 | Orkney | 7 |
2020-05-14,Scotland,S08000026,Shetland | 2020-05-14 | Scotland | S08000026 | Shetland | 54 |
2020-05-14,Scotland,S08000028,Western Isles | 2020-05-14 | Scotland | S08000028 | Western Isles | 6 |
2020-05-14,Scotland,S08000029,Fife | 2020-05-14 | Scotland | S08000029 | Fife | 823 |
2020-05-14,Scotland,S08000030,Tayside | 2020-05-14 | Scotland | S08000030 | Tayside | 1540 |
2020-05-14,Scotland,S08000031,Greater Glasgow and Clyde | 2020-05-14 | Scotland | S08000031 | Greater Glasgow and Clyde | 3628 |
2020-05-14,Scotland,S08000032,Lanarkshire | 2020-05-14 | Scotland | S08000032 | Lanarkshire | 1762 |
2020-05-14,Wales,,Outside Wales | 2020-05-14 | Wales | Outside Wales | 115 | |
2020-05-14,Wales,,Unknown | 2020-05-14 | Wales | Unknown | 72 | |
2020-05-14,Wales,W11000023,Betsi Cadwaladr | 2020-05-14 | Wales | W11000023 | Betsi Cadwaladr | 2197 |
2020-05-14,Wales,W11000024,Powys | 2020-05-14 | Wales | W11000024 | Powys | 248 |
2020-05-14,Wales,W11000025,Hywel Dda | 2020-05-14 | Wales | W11000025 | Hywel Dda | 944 |
2020-05-14,Wales,W11000028,Aneurin Bevan | 2020-05-14 | Wales | W11000028 | Aneurin Bevan | 2398 |
2020-05-14,Wales,W11000029,Cardiff and Vale | 2020-05-14 | Wales | W11000029 | Cardiff and Vale | 2507 |
2020-05-14,Wales,W11000030,Cwm Taf | 2020-05-14 | Wales | W11000030 | Cwm Taf | 2218 |
2020-05-14,Wales,W11000031,Swansea Bay | 2020-05-14 | Wales | W11000031 | Swansea Bay | 1783 |
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]) );