This data as json, CSV (advanced)
Link | Date | Country ▲ | AreaCode | Area | TotalCases |
---|---|---|---|---|---|
2020-05-14,England,E10000030,Surrey | 2020-05-14 | England | E10000030 | Surrey | 3963 |
2020-05-14,England,E10000031,Warwickshire | 2020-05-14 | England | E10000031 | Warwickshire | 1894 |
2020-05-14,England,E10000032,West Sussex | 2020-05-14 | England | E10000032 | West Sussex | 2247 |
2020-05-14,England,E10000034,Worcestershire | 2020-05-14 | England | E10000034 | Worcestershire | 1917 |
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]) );