This data as json, CSV (advanced)
Link | Date | Country ▲ | AreaCode | Area | TotalCases |
---|---|---|---|---|---|
2020-05-22,England,E10000020,Norfolk | 2020-05-22 | England | E10000020 | Norfolk | 2584 |
2020-05-22,England,E10000021,Northamptonshire | 2020-05-22 | England | E10000021 | Northamptonshire | 2266 |
2020-05-22,England,E10000023,North Yorkshire | 2020-05-22 | England | E10000023 | North Yorkshire | 2083 |
2020-05-22,England,E10000024,Nottinghamshire | 2020-05-22 | England | E10000024 | Nottinghamshire | 2325 |
2020-05-22,England,E10000025,Oxfordshire | 2020-05-22 | England | E10000025 | Oxfordshire | 2730 |
2020-05-22,England,E10000027,Somerset | 2020-05-22 | England | E10000027 | Somerset | 1011 |
2020-05-22,England,E10000028,Staffordshire | 2020-05-22 | England | E10000028 | Staffordshire | 3008 |
2020-05-22,England,E10000029,Suffolk | 2020-05-22 | England | E10000029 | Suffolk | 2353 |
2020-05-22,England,E10000030,Surrey | 2020-05-22 | England | E10000030 | Surrey | 4193 |
2020-05-22,England,E10000031,Warwickshire | 2020-05-22 | England | E10000031 | Warwickshire | 2065 |
2020-05-22,England,E10000032,West Sussex | 2020-05-22 | England | E10000032 | West Sussex | 2394 |
2020-05-22,England,E10000034,Worcestershire | 2020-05-22 | England | E10000034 | Worcestershire | 2096 |
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]) );