This data as json, CSV (advanced)
Link | Date | Country | AreaCode | Area | TotalCases ▼ |
---|---|---|---|---|---|
2020-03-12,Scotland,S08000015,Ayrshire and Arran | 2020-03-12 | Scotland | S08000015 | Ayrshire and Arran | NaN |
2020-03-12,Scotland,S08000016,Borders | 2020-03-12 | Scotland | S08000016 | Borders | NaN |
2020-03-12,Scotland,S08000017,Dumfries and Galloway | 2020-03-12 | Scotland | S08000017 | Dumfries and Galloway | NaN |
2020-03-12,Scotland,S08000029,Fife | 2020-03-12 | Scotland | S08000029 | Fife | NaN |
2020-03-12,Scotland,S08000022,Highland | 2020-03-12 | Scotland | S08000022 | Highland | NaN |
2020-03-12,Scotland,S08000025,Orkney | 2020-03-12 | Scotland | S08000025 | Orkney | NaN |
2020-03-12,Scotland,S08000030,Tayside | 2020-03-12 | Scotland | S08000030 | Tayside | NaN |
2020-03-12,Scotland,S08000028,Western Isles | 2020-03-12 | Scotland | S08000028 | Western Isles | NaN |
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]) );