This data as json, CSV (advanced)
Link | Date | Country | Indicator ▼ | Value |
---|---|---|---|---|
2020-04-17,England,ConfirmedCases | 2020-04-17 | England | ConfirmedCases | 98119 |
2020-04-17,Northern Ireland,ConfirmedCases | 2020-04-17 | Northern Ireland | ConfirmedCases | 2569 |
2020-04-17,Scotland,ConfirmedCases | 2020-04-17 | Scotland | ConfirmedCases | 7409 |
2020-04-17,UK,ConfirmedCases | 2020-04-17 | UK | ConfirmedCases | 108692 |
2020-04-17,Wales,ConfirmedCases | 2020-04-17 | Wales | ConfirmedCases | 7797 |
2020-04-17,England,Deaths | 2020-04-17 | England | Deaths | 15449 |
2020-04-17,Northern Ireland,Deaths | 2020-04-17 | Northern Ireland | Deaths | 214 |
2020-04-17,Scotland,Deaths | 2020-04-17 | Scotland | Deaths | 837 |
2020-04-17,UK,Deaths | 2020-04-17 | UK | Deaths | 16892 |
2020-04-17,Wales,Deaths | 2020-04-17 | Wales | Deaths | 668 |
2020-04-17,Northern Ireland,Tests | 2020-04-17 | Northern Ireland | Tests | 13754 |
2020-04-17,Scotland,Tests | 2020-04-17 | Scotland | Tests | 36637 |
2020-04-17,UK,Tests | 2020-04-17 | UK | Tests | 341551 |
2020-04-17,Wales,Tests | 2020-04-17 | Wales | Tests | 23384 |
JSON shape: default, array, newline-delimited, object
CREATE TABLE "indicators" ( "Date" TEXT, "Country" TEXT, "Indicator" TEXT, "Value" INTEGER ,PRIMARY KEY ([Date], [Country], [Indicator]) );