indicators

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

View and edit SQL

Date (date)

  • 2020-06-14 · 13
Link Date Country ▼ Indicator Value
2020-06-14 England ConfirmedCases 232835
2020-06-14 England Deaths 37368
2020-06-14 Northern Ireland ConfirmedCases 4834
2020-06-14 Northern Ireland Deaths 541
2020-06-14 Northern Ireland Tests 63583
2020-06-14 Scotland ConfirmedCases 15755
2020-06-14 Scotland Deaths 2448
2020-06-14 Scotland Tests 137638
2020-06-14 UK ConfirmedCases 295889
2020-06-14 UK Deaths 41800
2020-06-14 Wales ConfirmedCases 15500
2020-06-14 Wales Deaths 1464
2020-06-14 Wales Tests 134011

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.759ms · About: https://github.com/tomwhite/covid-19-uk-data