johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
25 rows where country_or_region = "Canada" and "last_update" is on date 2020-02-04 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: longitude, day (date)
province_or_state 2
- Toronto, ON 17
- London, ON 8
country_or_region 1
- Canada · 25 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2263502 | 2263502 | 2020-02-20 | Canada | Toronto, ON | 2 | 0 | 0 | 43.6532 | -79.3832 | 2020-02-04T00:13:06 | ||||
1720093 | 1720093 | 2020-02-19 | Canada | Toronto, ON | 2 | 0 | 0 | 43.6532 | -79.3832 | 2020-02-04T00:13:06 | ||||
1783125 | 1783125 | 2020-02-18 | Canada | Toronto, ON | 2 | 0 | 0 | 43.6532 | -79.3832 | 2020-02-04T00:13:06 | ||||
1243399 | 1243399 | 2020-02-17 | Canada | Toronto, ON | 2 | 0 | 0 | 43.6532 | -79.3832 | 2020-02-04T00:13:06 | ||||
1888752 | 1888752 | 2020-02-16 | Canada | Toronto, ON | 2 | 0 | 0 | 43.6532 | -79.3832 | 2020-02-04T00:13:06 | ||||
107078 | 107078 | 2020-02-15 | Canada | Toronto, ON | 2 | 0 | 0 | 43.6532 | -79.3832 | 2020-02-04T00:13:06 | ||||
1192497 | 1192497 | 2020-02-14 | Canada | Toronto, ON | 2 | 0 | 0 | 43.6532 | -79.3832 | 2020-02-04T00:13:06 | ||||
1559704 | 1559704 | 2020-02-13 | Canada | Toronto, ON | 2 | 0 | 0 | 43.6532 | -79.3832 | 2020-02-04T00:13:06 | ||||
2567294 | 2567294 | 2020-02-12 | Canada | Toronto, ON | 2 | 0 | 0 | 43.6532 | -79.3832 | 2020-02-04T00:13:06 | ||||
3197753 | 3197753 | 2020-02-11 | Canada | Toronto, ON | 2 | 0 | 0 | 43.6532 | -79.3832 | 2020-02-04T00:13:06 | ||||
3197761 | 3197761 | 2020-02-11 | Canada | London, ON | 1 | 0 | 0 | 42.9849 | -81.2453 | 2020-02-04T00:03:11 | ||||
3089052 | 3089052 | 2020-02-10 | Canada | Toronto, ON | 2 | 0 | 0 | 43.6532 | -79.3832 | 2020-02-04T00:13:06 | ||||
3089060 | 3089060 | 2020-02-10 | Canada | London, ON | 1 | 0 | 0 | 42.9849 | -81.2453 | 2020-02-04T00:03:11 | ||||
3362421 | 3362421 | 2020-02-09 | Canada | Toronto, ON | 2 | 0 | 0 | 43.6532 | -79.3832 | 2020-02-04T00:13:06 | ||||
3362429 | 3362429 | 2020-02-09 | Canada | London, ON | 1 | 0 | 0 | 42.9849 | -81.2453 | 2020-02-04T00:03:11 | ||||
1366091 | 1366091 | 2020-02-08 | Canada | Toronto, ON | 2 | 0 | 0 | 43.6532 | -79.3832 | 2020-02-04T00:13:06 | ||||
1366098 | 1366098 | 2020-02-08 | Canada | London, ON | 1 | 0 | 0 | 42.9849 | -81.2453 | 2020-02-04T00:03:11 | ||||
3222050 | 3222050 | 2020-02-07 | Canada | Toronto, ON | 2 | 0 | 0 | 43.6532 | -79.3832 | 2020-02-04T00:13:06 | ||||
3222057 | 3222057 | 2020-02-07 | Canada | London, ON | 1 | 0 | 0 | 42.9849 | -81.2453 | 2020-02-04T00:03:11 | ||||
566715 | 566715 | 2020-02-06 | Canada | Toronto, ON | 2 | 0 | 0 | 43.6532 | -79.3832 | 2020-02-04T00:13:06 | ||||
566725 | 566725 | 2020-02-06 | Canada | London, ON | 1 | 0 | 0 | 42.9849 | -81.2453 | 2020-02-04T00:03:11 | ||||
2091708 | 2091708 | 2020-02-05 | Canada | Toronto, ON | 2 | 0 | 0 | 43.6532 | -79.3832 | 2020-02-04T00:13:06 | ||||
2091718 | 2091718 | 2020-02-05 | Canada | London, ON | 1 | 0 | 0 | 42.9849 | -81.2453 | 2020-02-04T00:03:11 | ||||
3471924 | 3471924 | 2020-02-04 | Canada | Toronto, ON | 2 | 0 | 0 | 43.6532 | -79.3832 | 2020-02-04T00:13:06 | ||||
3471935 | 3471935 | 2020-02-04 | Canada | London, ON | 1 | 0 | 0 | 42.9849 | -81.2453 | 2020-02-04T00:03:11 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [johns_hopkins_csse_daily_reports] ( [day] TEXT, [country_or_region] TEXT, [province_or_state] TEXT, [admin2] TEXT, [fips] TEXT, [confirmed] INTEGER, [deaths] INTEGER, [recovered] INTEGER, [active] TEXT, [latitude] TEXT, [longitude] TEXT, [last_update] TEXT, [combined_key] TEXT ); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day] ON [johns_hopkins_csse_daily_reports] ([day]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state] ON [johns_hopkins_csse_daily_reports] ([province_or_state]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region] ON [johns_hopkins_csse_daily_reports] ([country_or_region]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key] ON [johns_hopkins_csse_daily_reports] ([combined_key]);