cases

20 rows where TotalCases = 138

View and edit SQL

Suggested facets: Date, Area, Date (date)

Country

TotalCases

  • 138 · 20
Link Date Country AreaCode Area TotalCases
2020-03-28 England E08000026 Coventry 138
2020-03-31 Wales W11000023 Betsi Cadwaladr 138
2020-04-01 England E06000045 Southampton 138
2020-04-02 England E06000054 Wiltshire 138
2020-04-02 England E08000011 Knowsley 138
2020-04-07 England E06000037 West Berkshire 138
2020-04-14 England E06000020 Telford and Wrekin 138
2020-04-27 England E06000012 North East Lincolnshire 138
2020-07-04 Wales   Unknown 138
2020-07-05 Wales   Unknown 138
2020-07-06 Wales   Unknown 138
2020-07-07 Wales   Unknown 138
2020-07-08 Wales   Unknown 138
2020-07-09 Wales   Unknown 138
2020-07-10 Wales   Unknown 138
2020-07-11 Wales   Unknown 138
2020-07-12 Wales   Unknown 138
2020-07-13 Wales   Unknown 138
2020-07-14 Wales   Unknown 138
2020-07-15 Wales   Unknown 138

Advanced export

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

CSV options:

CREATE TABLE "cases" (
"Date" TEXT,
  "Country" TEXT,
  "AreaCode" TEXT,
  "Area" TEXT,
  "TotalCases" INTEGER
  ,PRIMARY KEY ([Date], [Country], [AreaCode], [Area])
);
Powered by Datasette · Query took 181.378ms · About: https://github.com/tomwhite/covid-19-uk-data