This data as json, CSV (advanced)
Link | Date | Country ▲ | AreaCode | Area | TotalCases |
---|---|---|---|---|---|
2020-05-20,England,E10000018,Leicestershire | 2020-05-20 | England | E10000018 | Leicestershire | 2023 |
2020-05-20,England,E10000019,Lincolnshire | 2020-05-20 | England | E10000019 | Lincolnshire | 1914 |
2020-05-20,England,E10000020,Norfolk | 2020-05-20 | England | E10000020 | Norfolk | 2541 |
2020-05-20,England,E10000021,Northamptonshire | 2020-05-20 | England | E10000021 | Northamptonshire | 2170 |
2020-05-20,England,E10000023,North Yorkshire | 2020-05-20 | England | E10000023 | North Yorkshire | 2035 |
2020-05-20,England,E10000024,Nottinghamshire | 2020-05-20 | England | E10000024 | Nottinghamshire | 2237 |
2020-05-20,England,E10000025,Oxfordshire | 2020-05-20 | England | E10000025 | Oxfordshire | 2674 |
2020-05-20,England,E10000027,Somerset | 2020-05-20 | England | E10000027 | Somerset | 971 |
2020-05-20,England,E10000028,Staffordshire | 2020-05-20 | England | E10000028 | Staffordshire | 2946 |
2020-05-20,England,E10000029,Suffolk | 2020-05-20 | England | E10000029 | Suffolk | 2291 |
2020-05-20,England,E10000030,Surrey | 2020-05-20 | England | E10000030 | Surrey | 4148 |
2020-05-20,England,E10000031,Warwickshire | 2020-05-20 | England | E10000031 | Warwickshire | 2024 |
2020-05-20,England,E10000032,West Sussex | 2020-05-20 | England | E10000032 | West Sussex | 2360 |
2020-05-20,England,E10000034,Worcestershire | 2020-05-20 | England | E10000034 | Worcestershire | 2055 |
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]) );