This data as json, CSV (advanced)
Link | Date | Country | AreaCode | Area | TotalCases |
---|---|---|---|---|---|
2020-03-05,England,E08000003,Manchester | 2020-03-05 | England | E08000003 | Manchester | 4 |
2020-03-05,England,E09000017,Hillingdon | 2020-03-05 | England | E09000017 | Hillingdon | 4 |
2020-03-05,England,E09000033,Westminster | 2020-03-05 | England | E09000033 | Westminster | 4 |
2020-03-05,England,E10000006,Cumbria | 2020-03-05 | England | E10000006 | Cumbria | 4 |
2020-03-05,England,E10000016,Kent | 2020-03-05 | England | E10000016 | Kent | 4 |
2020-03-05,England,E10000017,Lancashire | 2020-03-05 | England | E10000017 | Lancashire | 4 |
2020-03-05,England,E10000028,Staffordshire | 2020-03-05 | England | E10000028 | Staffordshire | 4 |
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]) );