indicators

14 rows where "Date" is on date 2020-04-12 sorted by Indicator

View and edit SQL

Date (date)

  • 2020-04-12 · 14
Link Date Country Indicator ▼ Value
2020-04-12 England ConfirmedCases 78432
2020-04-12 Northern Ireland ConfirmedCases 1916
2020-04-12 Scotland ConfirmedCases 5912
2020-04-12 UK ConfirmedCases 84279
2020-04-12 Wales ConfirmedCases 6159
2020-04-12 England Deaths 11276
2020-04-12 Northern Ireland Deaths 159
2020-04-12 Scotland Deaths 566
2020-04-12 UK Deaths 12294
2020-04-12 Wales Deaths 497
2020-04-12 Northern Ireland Tests 11111
2020-04-12 Scotland Tests 31114
2020-04-12 UK Tests 282279
2020-04-12 Wales Tests 18982

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