This data as json, CSV (advanced)
Link | Date | Country | AreaCode | Area | TotalCases |
---|---|---|---|---|---|
2020-03-30,England,E06000054,Wiltshire | 2020-03-30 | England | E06000054 | Wiltshire | 108 |
2020-03-30,England,E08000005,Rochdale | 2020-03-30 | England | E08000005 | Rochdale | 108 |
2020-03-30,England,E08000034,Kirklees | 2020-03-30 | England | E08000034 | Kirklees | 108 |
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]) );