daily_reports (view)

⚠️ This table has been renamed. Use johns_hopkins_csse_daily_reports instead.

Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

34 rows where country_or_region = "Canada" and province_or_state = "Toronto, ON" sorted by day descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: confirmed, recovered, last_update, day (date), last_update (date)

province_or_state 1

  • Toronto, ON · 34 ✖

country_or_region 1

  • Canada · 34 ✖
day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
2020-03-08 Canada Toronto, ON     28 0 3   43.6532 -79.3832 2020-03-08T21:33:02  
2020-03-07 Canada Toronto, ON     27 0 3   43.6532 -79.3832 2020-03-07T03:53:03  
2020-03-06 Canada Toronto, ON     24 0 2   43.6532 -79.3832 2020-03-06T20:53:02  
2020-03-05 Canada Toronto, ON     21 0 2   43.6532 -79.3832 2020-03-05T17:53:03  
2020-03-04 Canada Toronto, ON     19 0 2   43.6532 -79.3832 2020-03-03T20:03:08  
2020-03-03 Canada Toronto, ON     19 0 2   43.6532 -79.3832 2020-03-03T20:03:08  
2020-03-02 Canada Toronto, ON     17 0 2   43.6532 -79.3832 2020-03-02T20:53:02  
2020-03-01 Canada Toronto, ON     14 0 2   43.6532 -79.3832 2020-03-01T23:33:03  
2020-02-29 Canada Toronto, ON     10 0 2   43.6532 -79.3832 2020-02-29T23:23:13  
2020-02-28 Canada Toronto, ON     5 0 2   43.6532 -79.3832 2020-02-27T22:43:02  
2020-02-27 Canada Toronto, ON     5 0 2   43.6532 -79.3832 2020-02-27T22:43:02  
2020-02-26 Canada Toronto, ON     3 0 2   43.6532 -79.3832 2020-02-24T14:43:03  
2020-02-25 Canada Toronto, ON     3 0 2   43.6532 -79.3832 2020-02-24T14:43:03  
2020-02-24 Canada Toronto, ON     3 0 2   43.6532 -79.3832 2020-02-24T14:43:03  
2020-02-23 Canada Toronto, ON     2 0 2   43.6532 -79.3832 2020-02-21T05:23:04  
2020-02-22 Canada Toronto, ON     2 0 2   43.6532 -79.3832 2020-02-21T05:23:04  
2020-02-21 Canada Toronto, ON     2 0 2   43.6532 -79.3832 2020-02-21T05:23:04  
2020-02-20 Canada Toronto, ON     2 0 0   43.6532 -79.3832 2020-02-04T00:13:06  
2020-02-19 Canada Toronto, ON     2 0 0   43.6532 -79.3832 2020-02-04T00:13:06  
2020-02-18 Canada Toronto, ON     2 0 0   43.6532 -79.3832 2020-02-04T00:13:06  
2020-02-17 Canada Toronto, ON     2 0 0   43.6532 -79.3832 2020-02-04T00:13:06  
2020-02-16 Canada Toronto, ON     2 0 0   43.6532 -79.3832 2020-02-04T00:13:06  
2020-02-15 Canada Toronto, ON     2 0 0   43.6532 -79.3832 2020-02-04T00:13:06  
2020-02-14 Canada Toronto, ON     2 0 0   43.6532 -79.3832 2020-02-04T00:13:06  
2020-02-13 Canada Toronto, ON     2 0 0   43.6532 -79.3832 2020-02-04T00:13:06  
2020-02-12 Canada Toronto, ON     2 0 0   43.6532 -79.3832 2020-02-04T00:13:06  
2020-02-11 Canada Toronto, ON     2 0 0   43.6532 -79.3832 2020-02-04T00:13:06  
2020-02-10 Canada Toronto, ON     2 0 0   43.6532 -79.3832 2020-02-04T00:13:06  
2020-02-09 Canada Toronto, ON     2 0 0   43.6532 -79.3832 2020-02-04T00:13:06  
2020-02-08 Canada Toronto, ON     2 0 0   43.6532 -79.3832 2020-02-04T00:13:06  
2020-02-07 Canada Toronto, ON     2 0 0   43.6532 -79.3832 2020-02-04T00:13:06  
2020-02-06 Canada Toronto, ON     2 0 0   43.6532 -79.3832 2020-02-04T00:13:06  
2020-02-05 Canada Toronto, ON     2 0 0   43.6532 -79.3832 2020-02-04T00:13:06  
2020-02-04 Canada Toronto, ON     2 0 0   43.6532 -79.3832 2020-02-04T00:13:06  

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;