This data as json, CSV (advanced)
Link | Date | Country | AreaCode | Area | TotalCases ▼ |
---|---|---|---|---|---|
2020-07-19,England,E08000035,Leeds | 2020-07-19 | England | E08000035 | Leeds | 3730 |
2020-07-19,England,E10000028,Staffordshire | 2020-07-19 | England | E10000028 | Staffordshire | 3781 |
2020-07-19,England,E08000019,Sheffield | 2020-07-19 | England | E08000019 | Sheffield | 4133 |
2020-07-19,England,E10000015,Hertfordshire | 2020-07-19 | England | E10000015 | Hertfordshire | 4209 |
2020-07-19,Wales,W11000023,Betsi Cadwaladr | 2020-07-19 | Wales | W11000023 | Betsi Cadwaladr | 4426 |
2020-07-19,England,E06000016,Leicester | 2020-07-19 | England | E06000016 | Leicester | 4645 |
2020-07-19,England,E08000032,Bradford | 2020-07-19 | England | E08000032 | Bradford | 4653 |
2020-07-19,England,E10000030,Surrey | 2020-07-19 | England | E10000030 | Surrey | 4653 |
2020-07-19,Scotland,S08000031,Greater Glasgow and Clyde | 2020-07-19 | Scotland | S08000031 | Greater Glasgow and Clyde | 4912 |
2020-07-19,England,E08000025,Birmingham | 2020-07-19 | England | E08000025 | Birmingham | 5034 |
2020-07-19,England,E10000014,Hampshire | 2020-07-19 | England | E10000014 | Hampshire | 5055 |
2020-07-19,England,E10000012,Essex | 2020-07-19 | England | E10000012 | Essex | 5567 |
2020-07-19,England,E10000017,Lancashire | 2020-07-19 | England | E10000017 | Lancashire | 6897 |
2020-07-19,England,E10000016,Kent | 2020-07-19 | England | E10000016 | Kent | 7953 |
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]) );