johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
2,265 rows where active = 0 and country_or_region = "Canada" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: longitude, combined_key, day (date), last_update (date)
province_or_state 11
- Diamond Princess 489
- Grand Princess 448
- Nunavut 315
- Northwest Territories 284
- Repatriated Travellers 254
- Yukon 234
- Prince Edward Island 114
- Recovered 51
- Newfoundland and Labrador 40
- Nova Scotia 26
- New Brunswick 10
country_or_region 1
- Canada · 2,265 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
331671 | 331671 | 2021-08-04 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
331672 | 331672 | 2021-08-04 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | ||
331676 | 331676 | 2021-08-04 | Canada | Northwest Territories | 129 | 0 | 129 | 0 | 64.8255 | -124.8457 | 2021-08-05 04:21:51 | Northwest Territories,Canada | ||
331678 | 331678 | 2021-08-04 | Canada | Nunavut | 657 | 4 | 653 | 0 | 70.2998 | -83.1076 | 2021-08-05 04:21:51 | Nunavut, Canada | ||
331680 | 331680 | 2021-08-04 | Canada | Prince Edward Island | 208 | 0 | 208 | 0 | 46.5107 | -63.4168 | 2021-08-05 04:21:51 | Prince Edward Island, Canada | ||
331682 | 331682 | 2021-08-04 | Canada | Repatriated Travellers | 13 | 0 | 13 | 0 | 2021-08-05 04:21:51 | Repatriated Travellers, Canada | ||||
3467942 | 3467942 | 2021-08-03 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
3467943 | 3467943 | 2021-08-03 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | ||
3467947 | 3467947 | 2021-08-03 | Canada | Northwest Territories | 129 | 0 | 128 | 0 | 64.8255 | -124.8457 | 2021-08-04 04:21:25 | Northwest Territories,Canada | ||
3467949 | 3467949 | 2021-08-03 | Canada | Nunavut | 657 | 4 | 653 | 0 | 70.2998 | -83.1076 | 2021-08-04 04:21:25 | Nunavut, Canada | ||
3467951 | 3467951 | 2021-08-03 | Canada | Prince Edward Island | 208 | 0 | 208 | 0 | 46.5107 | -63.4168 | 2021-08-04 04:21:25 | Prince Edward Island, Canada | ||
3467953 | 3467953 | 2021-08-03 | Canada | Repatriated Travellers | 13 | 0 | 13 | 0 | 2021-08-04 04:21:25 | Repatriated Travellers, Canada | ||||
3683216 | 3683216 | 2021-08-02 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
3683217 | 3683217 | 2021-08-02 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | ||
3683221 | 3683221 | 2021-08-02 | Canada | Northwest Territories | 128 | 0 | 128 | 0 | 64.8255 | -124.8457 | 2021-08-03 04:21:39 | Northwest Territories,Canada | ||
3683223 | 3683223 | 2021-08-02 | Canada | Nunavut | 657 | 4 | 653 | 0 | 70.2998 | -83.1076 | 2021-08-03 04:21:39 | Nunavut, Canada | ||
3683225 | 3683225 | 2021-08-02 | Canada | Prince Edward Island | 208 | 0 | 208 | 0 | 46.5107 | -63.4168 | 2021-08-03 04:21:39 | Prince Edward Island, Canada | ||
3683227 | 3683227 | 2021-08-02 | Canada | Repatriated Travellers | 13 | 0 | 13 | 0 | 2021-08-03 04:21:39 | Repatriated Travellers, Canada | ||||
3015115 | 3015115 | 2021-08-01 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
3015116 | 3015116 | 2021-08-01 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | ||
3015120 | 3015120 | 2021-08-01 | Canada | Northwest Territories | 128 | 0 | 128 | 0 | 64.8255 | -124.8457 | 2021-08-02 04:21:36 | Northwest Territories,Canada | ||
3015122 | 3015122 | 2021-08-01 | Canada | Nunavut | 657 | 4 | 653 | 0 | 70.2998 | -83.1076 | 2021-08-02 04:21:36 | Nunavut, Canada | ||
3015124 | 3015124 | 2021-08-01 | Canada | Prince Edward Island | 208 | 0 | 208 | 0 | 46.5107 | -63.4168 | 2021-08-02 04:21:36 | Prince Edward Island, Canada | ||
3015126 | 3015126 | 2021-08-01 | Canada | Repatriated Travellers | 13 | 0 | 13 | 0 | 2021-08-02 04:21:36 | Repatriated Travellers, Canada | ||||
3903738 | 3903738 | 2021-07-31 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
3903739 | 3903739 | 2021-07-31 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | ||
3903743 | 3903743 | 2021-07-31 | Canada | Northwest Territories | 128 | 0 | 128 | 0 | 64.8255 | -124.8457 | 2021-08-01 04:21:50 | Northwest Territories,Canada | ||
3903745 | 3903745 | 2021-07-31 | Canada | Nunavut | 657 | 4 | 653 | 0 | 70.2998 | -83.1076 | 2021-08-01 04:21:50 | Nunavut, Canada | ||
3903747 | 3903747 | 2021-07-31 | Canada | Prince Edward Island | 208 | 0 | 208 | 0 | 46.5107 | -63.4168 | 2021-08-01 04:21:50 | Prince Edward Island, Canada | ||
3903749 | 3903749 | 2021-07-31 | Canada | Repatriated Travellers | 13 | 0 | 13 | 0 | 2021-08-01 04:21:50 | Repatriated Travellers, Canada | ||||
3295943 | 3295943 | 2021-07-30 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
3295944 | 3295944 | 2021-07-30 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | ||
3295948 | 3295948 | 2021-07-30 | Canada | Northwest Territories | 128 | 0 | 128 | 0 | 64.8255 | -124.8457 | 2021-07-31 04:21:35 | Northwest Territories,Canada | ||
3295950 | 3295950 | 2021-07-30 | Canada | Nunavut | 657 | 4 | 653 | 0 | 70.2998 | -83.1076 | 2021-07-31 04:21:35 | Nunavut, Canada | ||
3295952 | 3295952 | 2021-07-30 | Canada | Prince Edward Island | 208 | 0 | 208 | 0 | 46.5107 | -63.4168 | 2021-07-31 04:21:35 | Prince Edward Island, Canada | ||
3295954 | 3295954 | 2021-07-30 | Canada | Repatriated Travellers | 13 | 0 | 13 | 0 | 2021-07-31 04:21:35 | Repatriated Travellers, Canada | ||||
3385154 | 3385154 | 2021-07-29 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
3385155 | 3385155 | 2021-07-29 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | ||
3385159 | 3385159 | 2021-07-29 | Canada | Northwest Territories | 128 | 0 | 128 | 0 | 64.8255 | -124.8457 | 2021-07-30 04:21:34 | Northwest Territories,Canada | ||
3385161 | 3385161 | 2021-07-29 | Canada | Nunavut | 657 | 4 | 653 | 0 | 70.2998 | -83.1076 | 2021-07-30 04:21:34 | Nunavut, Canada | ||
3385163 | 3385163 | 2021-07-29 | Canada | Prince Edward Island | 208 | 0 | 208 | 0 | 46.5107 | -63.4168 | 2021-07-30 04:21:34 | Prince Edward Island, Canada | ||
3385165 | 3385165 | 2021-07-29 | Canada | Repatriated Travellers | 13 | 0 | 13 | 0 | 2021-07-30 04:21:34 | Repatriated Travellers, Canada | ||||
408059 | 408059 | 2021-07-28 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
408060 | 408060 | 2021-07-28 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | ||
408064 | 408064 | 2021-07-28 | Canada | Northwest Territories | 128 | 0 | 128 | 0 | 64.8255 | -124.8457 | 2021-07-29 04:21:33 | Northwest Territories,Canada | ||
408066 | 408066 | 2021-07-28 | Canada | Nunavut | 657 | 4 | 653 | 0 | 70.2998 | -83.1076 | 2021-07-29 04:21:33 | Nunavut, Canada | ||
408068 | 408068 | 2021-07-28 | Canada | Prince Edward Island | 208 | 0 | 208 | 0 | 46.5107 | -63.4168 | 2021-07-29 04:21:33 | Prince Edward Island, Canada | ||
408070 | 408070 | 2021-07-28 | Canada | Repatriated Travellers | 13 | 0 | 13 | 0 | 2021-07-29 04:21:33 | Repatriated Travellers, Canada | ||||
1305920 | 1305920 | 2021-07-27 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
1305921 | 1305921 | 2021-07-27 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | ||
1305925 | 1305925 | 2021-07-27 | Canada | Northwest Territories | 128 | 0 | 128 | 0 | 64.8255 | -124.8457 | 2021-07-28 04:21:39 | Northwest Territories,Canada | ||
1305927 | 1305927 | 2021-07-27 | Canada | Nunavut | 657 | 4 | 653 | 0 | 70.2998 | -83.1076 | 2021-07-28 04:21:39 | Nunavut, Canada | ||
1305929 | 1305929 | 2021-07-27 | Canada | Prince Edward Island | 208 | 0 | 208 | 0 | 46.5107 | -63.4168 | 2021-07-28 04:21:39 | Prince Edward Island, Canada | ||
1305931 | 1305931 | 2021-07-27 | Canada | Repatriated Travellers | 13 | 0 | 13 | 0 | 2021-07-28 04:21:39 | Repatriated Travellers, Canada | ||||
3218063 | 3218063 | 2021-07-26 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
3218064 | 3218064 | 2021-07-26 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | ||
3218068 | 3218068 | 2021-07-26 | Canada | Northwest Territories | 128 | 0 | 128 | 0 | 64.8255 | -124.8457 | 2021-07-27 04:21:18 | Northwest Territories,Canada | ||
3218070 | 3218070 | 2021-07-26 | Canada | Nunavut | 657 | 4 | 653 | 0 | 70.2998 | -83.1076 | 2021-07-27 04:21:18 | Nunavut, Canada | ||
3218072 | 3218072 | 2021-07-26 | Canada | Prince Edward Island | 208 | 0 | 208 | 0 | 46.5107 | -63.4168 | 2021-07-27 04:21:18 | Prince Edward Island, Canada | ||
3218074 | 3218074 | 2021-07-26 | Canada | Repatriated Travellers | 13 | 0 | 13 | 0 | 2021-07-27 04:21:18 | Repatriated Travellers, Canada | ||||
1378272 | 1378272 | 2021-07-25 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
1378273 | 1378273 | 2021-07-25 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | ||
1378277 | 1378277 | 2021-07-25 | Canada | Northwest Territories | 128 | 0 | 128 | 0 | 64.8255 | -124.8457 | 2021-07-26 04:21:28 | Northwest Territories,Canada | ||
1378279 | 1378279 | 2021-07-25 | Canada | Nunavut | 657 | 4 | 653 | 0 | 70.2998 | -83.1076 | 2021-07-26 04:21:28 | Nunavut, Canada | ||
1378281 | 1378281 | 2021-07-25 | Canada | Prince Edward Island | 208 | 0 | 208 | 0 | 46.5107 | -63.4168 | 2021-07-26 04:21:28 | Prince Edward Island, Canada | ||
1378283 | 1378283 | 2021-07-25 | Canada | Repatriated Travellers | 13 | 0 | 13 | 0 | 2021-07-26 04:21:28 | Repatriated Travellers, Canada | ||||
1330012 | 1330012 | 2021-07-24 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
1330013 | 1330013 | 2021-07-24 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | ||
1330017 | 1330017 | 2021-07-24 | Canada | Northwest Territories | 128 | 0 | 128 | 0 | 64.8255 | -124.8457 | 2021-07-25 04:22:12 | Northwest Territories,Canada | ||
1330019 | 1330019 | 2021-07-24 | Canada | Nunavut | 657 | 4 | 653 | 0 | 70.2998 | -83.1076 | 2021-07-25 04:22:12 | Nunavut, Canada | ||
1330021 | 1330021 | 2021-07-24 | Canada | Prince Edward Island | 208 | 0 | 208 | 0 | 46.5107 | -63.4168 | 2021-07-25 04:22:12 | Prince Edward Island, Canada | ||
1330023 | 1330023 | 2021-07-24 | Canada | Repatriated Travellers | 13 | 0 | 13 | 0 | 2021-07-25 04:22:12 | Repatriated Travellers, Canada | ||||
3137316 | 3137316 | 2021-07-23 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
3137317 | 3137317 | 2021-07-23 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | ||
3137321 | 3137321 | 2021-07-23 | Canada | Northwest Territories | 128 | 0 | 128 | 0 | 64.8255 | -124.8457 | 2021-07-24 00:21:36 | Northwest Territories,Canada | ||
3137323 | 3137323 | 2021-07-23 | Canada | Nunavut | 657 | 4 | 653 | 0 | 70.2998 | -83.1076 | 2021-07-24 00:21:36 | Nunavut, Canada | ||
3137325 | 3137325 | 2021-07-23 | Canada | Prince Edward Island | 208 | 0 | 208 | 0 | 46.5107 | -63.4168 | 2021-07-24 00:21:36 | Prince Edward Island, Canada | ||
3137327 | 3137327 | 2021-07-23 | Canada | Repatriated Travellers | 13 | 0 | 13 | 0 | 2021-07-24 00:21:36 | Repatriated Travellers, Canada | ||||
3476076 | 3476076 | 2021-07-22 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
3476077 | 3476077 | 2021-07-22 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | ||
3476081 | 3476081 | 2021-07-22 | Canada | Northwest Territories | 128 | 0 | 128 | 0 | 64.8255 | -124.8457 | 2021-07-23 04:21:29 | Northwest Territories,Canada | ||
3476083 | 3476083 | 2021-07-22 | Canada | Nunavut | 657 | 4 | 653 | 0 | 70.2998 | -83.1076 | 2021-07-23 04:21:29 | Nunavut, Canada | ||
3476085 | 3476085 | 2021-07-22 | Canada | Prince Edward Island | 208 | 0 | 208 | 0 | 46.5107 | -63.4168 | 2021-07-23 04:21:29 | Prince Edward Island, Canada | ||
3476087 | 3476087 | 2021-07-22 | Canada | Repatriated Travellers | 13 | 0 | 13 | 0 | 2021-07-23 04:21:29 | Repatriated Travellers, Canada | ||||
3331295 | 3331295 | 2021-07-21 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
3331296 | 3331296 | 2021-07-21 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | ||
3331300 | 3331300 | 2021-07-21 | Canada | Northwest Territories | 128 | 0 | 128 | 0 | 64.8255 | -124.8457 | 2021-07-22 04:21:19 | Northwest Territories,Canada | ||
3331302 | 3331302 | 2021-07-21 | Canada | Nunavut | 657 | 4 | 653 | 0 | 70.2998 | -83.1076 | 2021-07-22 04:21:19 | Nunavut, Canada | ||
3331304 | 3331304 | 2021-07-21 | Canada | Prince Edward Island | 208 | 0 | 208 | 0 | 46.5107 | -63.4168 | 2021-07-22 04:21:19 | Prince Edward Island, Canada | ||
3331306 | 3331306 | 2021-07-21 | Canada | Repatriated Travellers | 13 | 0 | 13 | 0 | 2021-07-22 04:21:19 | Repatriated Travellers, Canada | ||||
2371276 | 2371276 | 2021-07-20 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
2371277 | 2371277 | 2021-07-20 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | ||
2371281 | 2371281 | 2021-07-20 | Canada | Northwest Territories | 128 | 0 | 128 | 0 | 64.8255 | -124.8457 | 2021-07-21 04:21:40 | Northwest Territories,Canada | ||
2371283 | 2371283 | 2021-07-20 | Canada | Nunavut | 657 | 4 | 653 | 0 | 70.2998 | -83.1076 | 2021-07-21 04:21:40 | Nunavut, Canada | ||
2371285 | 2371285 | 2021-07-20 | Canada | Prince Edward Island | 208 | 0 | 208 | 0 | 46.5107 | -63.4168 | 2021-07-21 04:21:40 | Prince Edward Island, Canada | ||
2371287 | 2371287 | 2021-07-20 | Canada | Repatriated Travellers | 13 | 0 | 13 | 0 | 2021-07-21 04:21:40 | Repatriated Travellers, Canada | ||||
483355 | 483355 | 2021-07-19 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
483356 | 483356 | 2021-07-19 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | ||
483360 | 483360 | 2021-07-19 | Canada | Northwest Territories | 128 | 0 | 128 | 0 | 64.8255 | -124.8457 | 2021-07-20 04:21:48 | Northwest Territories,Canada | ||
483362 | 483362 | 2021-07-19 | Canada | Nunavut | 657 | 4 | 653 | 0 | 70.2998 | -83.1076 | 2021-07-20 04:21:48 | Nunavut, Canada |
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]);