This data as json, CSV (advanced)
Link | Date | Country | AreaCode | Area | TotalCases ▼ |
---|---|---|---|---|---|
2020-05-22,Scotland,S08000020,Grampian | 2020-05-22 | Scotland | S08000020 | Grampian | 1223 |
2020-05-22,Scotland,S08000030,Tayside | 2020-05-22 | Scotland | S08000030 | Tayside | 1641 |
2020-05-22,Scotland,S08000032,Lanarkshire | 2020-05-22 | Scotland | S08000032 | Lanarkshire | 1913 |
2020-05-22,Scotland,S08000024,Lothian | 2020-05-22 | Scotland | S08000024 | Lothian | 2634 |
2020-05-22,Scotland,S08000031,Greater Glasgow and Clyde | 2020-05-22 | Scotland | S08000031 | Greater Glasgow and Clyde | 3841 |
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]) );