indicators

13 rows where "Date" is on date 2020-06-25 sorted by Country

View and edit SQL

Date (date)

  • 2020-06-25 · 13
Link Date Country ▼ Indicator Value
2020-06-25 England ConfirmedCases 241523
2020-06-25 England Deaths 38706
2020-06-25 Northern Ireland ConfirmedCases 4868
2020-06-25 Northern Ireland Deaths 548
2020-06-25 Northern Ireland Tests 74436
2020-06-25 Scotland ConfirmedCases 18196
2020-06-25 Scotland Deaths 2482
2020-06-25 Scotland Tests 242510
2020-06-25 UK ConfirmedCases 307980
2020-06-25 UK Deaths 43230
2020-06-25 Wales ConfirmedCases 16333
2020-06-25 Wales Deaths 1509
2020-06-25 Wales Tests 158890

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE "indicators" (
"Date" TEXT,
  "Country" TEXT,
  "Indicator" TEXT,
  "Value" INTEGER
  ,PRIMARY KEY ([Date], [Country], [Indicator])
);
Powered by Datasette · Query took 11.211ms · About: https://github.com/tomwhite/covid-19-uk-data