This data as json, CSV (advanced)
Link | Date | Country | AreaCode ▼ | Area | TotalCases |
---|---|---|---|---|---|
2020-07-12,Scotland,S08000031,Greater Glasgow and Clyde | 2020-07-12 | Scotland | S08000031 | Greater Glasgow and Clyde | 4884 |
2020-07-12,Scotland,S08000032,Lanarkshire | 2020-07-12 | Scotland | S08000032 | Lanarkshire | 2736 |
2020-07-12,Wales,W11000023,Betsi Cadwaladr | 2020-07-12 | Wales | W11000023 | Betsi Cadwaladr | 4355 |
2020-07-12,Wales,W11000024,Powys | 2020-07-12 | Wales | W11000024 | Powys | 327 |
2020-07-12,Wales,W11000025,Hywel Dda | 2020-07-12 | Wales | W11000025 | Hywel Dda | 1159 |
2020-07-12,Wales,W11000028,Aneurin Bevan | 2020-07-12 | Wales | W11000028 | Aneurin Bevan | 2708 |
2020-07-12,Wales,W11000029,Cardiff and Vale | 2020-07-12 | Wales | W11000029 | Cardiff and Vale | 3063 |
2020-07-12,Wales,W11000030,Cwm Taf | 2020-07-12 | Wales | W11000030 | Cwm Taf | 2991 |
2020-07-12,Wales,W11000031,Swansea Bay | 2020-07-12 | Wales | W11000031 | Swansea Bay | 1966 |
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]) );