This data as json, CSV (advanced)
Link | Date | Country ▼ | AreaCode | Area | TotalCases |
---|---|---|---|---|---|
2020-07-24,England,E06000033,Southend-on-Sea | 2020-07-24 | England | E06000033 | Southend-on-Sea | 701 |
2020-07-24,England,E06000050,Cheshire West and Chester | 2020-07-24 | England | E06000050 | Cheshire West and Chester | 2019 |
2020-07-24,England,E06000058,Bournemouth, Christchurch and Poole | 2020-07-24 | England | E06000058 | Bournemouth, Christchurch and Poole | 825 |
2020-07-24,England,E08000003,Manchester | 2020-07-24 | England | E08000003 | Manchester | 3113 |
2020-07-24,England,E08000028,Sandwell | 2020-07-24 | England | E08000028 | Sandwell | 1796 |
2020-07-24,England,E08000032,Bradford | 2020-07-24 | England | E08000032 | Bradford | 4780 |
2020-07-24,England,E08000033,Calderdale | 2020-07-24 | England | E08000033 | Calderdale | 795 |
2020-07-24,England,E08000036,Wakefield | 2020-07-24 | England | E08000036 | Wakefield | 1807 |
2020-07-24,England,E10000016,Kent | 2020-07-24 | England | E10000016 | Kent | 8029 |
2020-07-24,England,E10000024,Nottinghamshire | 2020-07-24 | England | E10000024 | Nottinghamshire | 3037 |
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]) );