This data as json, CSV (advanced)
Link | Date | Country ▼ | Indicator | Value |
---|---|---|---|---|
2020-06-20,England,ConfirmedCases | 2020-06-20 | England | ConfirmedCases | 238061 |
2020-06-20,England,Deaths | 2020-06-20 | England | Deaths | 38208 |
2020-06-20,Northern Ireland,ConfirmedCases | 2020-06-20 | Northern Ireland | ConfirmedCases | 4856 |
2020-06-20,Northern Ireland,Deaths | 2020-06-20 | Northern Ireland | Deaths | 545 |
2020-06-20,Northern Ireland,Tests | 2020-06-20 | Northern Ireland | Tests | 69718 |
2020-06-20,Scotland,ConfirmedCases | 2020-06-20 | Scotland | ConfirmedCases | 18130 |
2020-06-20,Scotland,Deaths | 2020-06-20 | Scotland | Deaths | 2472 |
2020-06-20,Scotland,Tests | 2020-06-20 | Scotland | Tests | 228083 |
2020-06-20,UK,ConfirmedCases | 2020-06-20 | UK | ConfirmedCases | 303110 |
2020-06-20,UK,Deaths | 2020-06-20 | UK | Deaths | 42698 |
2020-06-20,Wales,ConfirmedCases | 2020-06-20 | Wales | ConfirmedCases | 15963 |
2020-06-20,Wales,Deaths | 2020-06-20 | Wales | Deaths | 1486 |
2020-06-20,Wales,Tests | 2020-06-20 | Wales | Tests | 146933 |
JSON shape: default, array, newline-delimited, object
CREATE TABLE "indicators" ( "Date" TEXT, "Country" TEXT, "Indicator" TEXT, "Value" INTEGER ,PRIMARY KEY ([Date], [Country], [Indicator]) );