johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
16,227 rows where country_or_region = "Canada" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state 22
- British Columbia 1,065
- Ontario 1,035
- Alberta 1,026
- Quebec 1,026
- Manitoba 1,022
- New Brunswick 1,022
- Saskatchewan 1,022
- Newfoundland and Labrador 1,020
- Nova Scotia 1,016
- Nunavut 1,004
- Yukon 1,004
- Diamond Princess 1,001
- Prince Edward Island 1,000
- Northwest Territories 999
- Grand Princess 991
- Repatriated Travellers 747
- Recovered 49
- London, ON 32
- Toronto, ON 32
- Montreal, QC 11
- Calgary, Alberta 2
- Edmonton, Alberta 1
latitude 21 ✖
country_or_region 1
- Canada · 16,127 ✖
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths ▼ | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
98392 | 98392 | 2020-08-04 | Canada | Northwest Territories | 5 | 0 | 5 | 0 | 64.8255 | -124.8457 | 2020-08-05 04:34:43 | Northwest Territories, Canada | ||
98394 | 98394 | 2020-08-04 | Canada | Nunavut | 0 | 0 | 0 | 0 | 70.2998 | -83.1076 | 2020-08-05 04:34:43 | Nunavut, Canada | ||
98430 | 98430 | 2020-08-04 | Canada | Prince Edward Island | 36 | 0 | 36 | 0 | 46.5107 | -63.4168 | 2020-08-05 04:34:43 | Prince Edward Island, Canada | ||
98584 | 98584 | 2020-08-04 | Canada | Yukon | 14 | 0 | 11 | 3 | 64.2823 | -135.0 | 2020-08-05 04:34:43 | Yukon, Canada | ||
98763 | 98763 | 2020-08-04 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-07-13 12:34:33 | Grand Princess, Canada | ||
98858 | 98858 | 2020-03-04 | Canada | Toronto, ON | 19 | 0 | 2 | 43.6532 | -79.3832 | 2020-03-03T20:03:08 | ||||
98866 | 98866 | 2020-03-04 | Canada | British Columbia | 12 | 0 | 3 | 49.2827 | -123.1207 | 2020-03-04T04:23:05 | ||||
98920 | 98920 | 2020-03-04 | Canada | Montreal, QC | 10 | 0 | 0 | 45.5017 | -73.5673 | 2020-02-28T05:23:07 | ||||
98921 | 98921 | 2020-03-04 | Canada | London, ON | 1 | 0 | 1 | 42.9849 | -81.2453 | 2020-02-12T18:53:03 | ||||
99076 | 99076 | 2022-01-14 | Canada | Grand Princess | 13 | 0 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | |||
99086 | 99086 | 2022-01-14 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-01-15 04:21:07 | Repatriated Travellers, Canada | |||||
103092 | 103092 | 2021-08-15 | Canada | Grand Princess | 13 | 0 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | |||
103096 | 103096 | 2021-08-15 | Canada | Northwest Territories | 133 | 0 | 0 | 64.8255 | -124.8457 | 2021-08-16 04:21:31 | Northwest Territories,Canada | |||
103100 | 103100 | 2021-08-15 | Canada | Prince Edward Island | 214 | 0 | 0 | 46.5107 | -63.4168 | 2021-08-16 04:21:31 | Prince Edward Island, Canada | |||
103102 | 103102 | 2021-08-15 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-08-16 04:21:31 | Repatriated Travellers, Canada | |||||
107073 | 107073 | 2020-02-15 | Canada | British Columbia | 4 | 0 | 0 | 53.7267 | -127.6476 | 2020-02-07T05:43:03 | ||||
107078 | 107078 | 2020-02-15 | Canada | Toronto, ON | 2 | 0 | 0 | 43.6532 | -79.3832 | 2020-02-04T00:13:06 | ||||
107087 | 107087 | 2020-02-15 | Canada | London, ON | 1 | 0 | 1 | 42.9849 | -81.2453 | 2020-02-12T18:53:03 | ||||
107217 | 107217 | 2021-06-19 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | ||
107221 | 107221 | 2021-06-19 | Canada | Northwest Territories | 128 | 0 | 128 | 0 | 64.8255 | -124.8457 | 2021-06-20 04:21:48 | Northwest Territories,Canada | ||
107225 | 107225 | 2021-06-19 | Canada | Prince Edward Island | 206 | 0 | 206 | 0 | 46.5107 | -63.4168 | 2021-06-20 04:21:48 | Prince Edward Island, Canada | ||
107227 | 107227 | 2021-06-19 | Canada | Repatriated Travellers | 13 | 0 | 13 | 0 | 2021-06-20 04:21:48 | Repatriated Travellers, Canada | ||||
114133 | 114133 | 2020-05-08 | Canada | Grand Princess | 13 | 0 | 0 | 13 | 37.6489 | 0.0 | 2020-05-09 02:32:35 | Grand Princess, Canada | ||
114159 | 114159 | 2020-05-08 | Canada | New Brunswick | 120 | 0 | 0 | 120 | 46.5653 | -66.4619 | 2020-05-09 02:32:35 | New Brunswick, Canada | ||
114166 | 114166 | 2020-05-08 | Canada | Northwest Territories | 5 | 0 | 0 | 5 | 64.8255 | -124.8457 | 2020-05-09 02:32:35 | Northwest Territories, Canada | ||
114168 | 114168 | 2020-05-08 | Canada | Nunavut | 0 | 0 | 0 | 0 | 70.2998 | -83.1076 | 2020-05-09 02:32:35 | Nunavut, Canada | ||
114170 | 114170 | 2020-05-08 | Canada | Prince Edward Island | 27 | 0 | 0 | 27 | 46.5107 | -63.4168 | 2020-05-09 02:32:35 | Prince Edward Island, Canada | ||
114175 | 114175 | 2020-05-08 | Canada | Recovered | 0 | 0 | 30239 | 0 | 0.0 | 0.0 | 2020-05-09 02:32:35 | Recovered, Canada | ||
114198 | 114198 | 2020-05-08 | Canada | Yukon | 11 | 0 | 0 | 11 | 64.2823 | -135.0 | 2020-05-09 02:32:35 | Yukon, Canada | ||
114502 | 114502 | 2022-09-06 | Canada | Grand Princess | 13 | 0 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | |||
114512 | 114512 | 2022-09-06 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-09-07 04:20:59 | Repatriated Travellers, Canada | |||||
121984 | 121984 | 2020-07-19 | Canada | Northwest Territories | 5 | 0 | 5 | 0 | 64.8255 | -124.8457 | 2020-07-20 05:34:40 | Northwest Territories, Canada | ||
121986 | 121986 | 2020-07-19 | Canada | Nunavut | 0 | 0 | 0 | 0 | 70.2998 | -83.1076 | 2020-07-20 05:34:40 | Nunavut, Canada | ||
122022 | 122022 | 2020-07-19 | Canada | Prince Edward Island | 36 | 0 | 29 | 7 | 46.5107 | -63.4168 | 2020-07-20 05:34:40 | Prince Edward Island, Canada | ||
122175 | 122175 | 2020-07-19 | Canada | Yukon | 13 | 0 | 11 | 2 | 64.2823 | -135.0 | 2020-07-20 05:34:40 | Yukon, Canada | ||
122356 | 122356 | 2020-07-19 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-07-13 12:34:33 | Grand Princess, Canada | ||
122473 | 122473 | 2020-11-18 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-11-19 05:25:23 | Grand Princess, Canada | ||
122477 | 122477 | 2020-11-18 | Canada | Northwest Territories | 15 | 0 | 10 | 5 | 64.8255 | -124.8457 | 2020-11-19 05:25:23 | Northwest Territories,Canada | ||
122479 | 122479 | 2020-11-18 | Canada | Nunavut | 68 | 0 | 0 | 68 | 70.2998 | -83.1076 | 2020-11-19 05:25:23 | Nunavut, Canada | ||
122481 | 122481 | 2020-11-18 | Canada | Prince Edward Island | 68 | 0 | 65 | 3 | 46.5107 | -63.4168 | 2020-11-19 05:25:23 | Prince Edward Island, Canada | ||
126483 | 126483 | 2022-01-09 | Canada | Grand Princess | 13 | 0 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | |||
126491 | 126491 | 2022-01-09 | Canada | Prince Edward Island | 2463 | 0 | 0 | 46.5107 | -63.4168 | 2022-01-10 04:22:07 | Prince Edward Island, Canada | |||
126493 | 126493 | 2022-01-09 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-01-10 04:22:07 | Repatriated Travellers, Canada | |||||
130500 | 130500 | 2022-10-04 | Canada | Grand Princess | 13 | 0 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | |||
130510 | 130510 | 2022-10-04 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-10-05 04:23:06 | Repatriated Travellers, Canada | |||||
137357 | 137357 | 2020-04-29 | Canada | Grand Princess | 13 | 0 | 0 | 13 | 37.6489 | 0.0 | 2020-04-30 02:32:27 | Grand Princess, Canada | ||
137383 | 137383 | 2020-04-29 | Canada | New Brunswick | 118 | 0 | 0 | 118 | 46.5653 | -66.4619 | 2020-04-30 02:32:27 | New Brunswick, Canada | ||
137390 | 137390 | 2020-04-29 | Canada | Northwest Territories | 5 | 0 | 0 | 5 | 64.8255 | -124.8457 | 2020-04-30 02:32:27 | Northwest Territories, Canada | ||
137392 | 137392 | 2020-04-29 | Canada | Nunavut | 0 | 0 | 0 | 0 | 70.2998 | -83.1076 | 2020-04-30 02:32:27 | Nunavut, Canada | ||
137394 | 137394 | 2020-04-29 | Canada | Prince Edward Island | 27 | 0 | 0 | 27 | 46.5107 | -63.4168 | 2020-04-30 02:32:27 | Prince Edward Island, Canada | ||
137399 | 137399 | 2020-04-29 | Canada | Recovered | 0 | 0 | 20327 | 0 | 0.0 | 0.0 | 2020-04-30 02:32:27 | Recovered, Canada | ||
137422 | 137422 | 2020-04-29 | Canada | Yukon | 11 | 0 | 0 | 11 | 64.2823 | -135.0 | 2020-04-30 02:32:27 | Yukon, Canada | ||
137721 | 137721 | 2021-12-04 | Canada | Grand Princess | 13 | 0 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | |||
137729 | 137729 | 2021-12-04 | Canada | Prince Edward Island | 372 | 0 | 0 | 46.5107 | -63.4168 | 2021-12-05 04:22:25 | Prince Edward Island, Canada | |||
137731 | 137731 | 2021-12-04 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-12-05 04:22:25 | Repatriated Travellers, Canada | |||||
141738 | 141738 | 2022-07-09 | Canada | Grand Princess | 13 | 0 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | |||
141748 | 141748 | 2022-07-09 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-07-10 04:20:54 | Repatriated Travellers, Canada | |||||
145742 | 145742 | 2020-08-15 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-08-16 04:27:42 | Grand Princess, Canada | ||
145746 | 145746 | 2020-08-15 | Canada | Northwest Territories | 5 | 0 | 5 | 0 | 64.8255 | -124.8457 | 2020-08-16 04:27:42 | Northwest Territories,Canada | ||
145748 | 145748 | 2020-08-15 | Canada | Nunavut | 0 | 0 | 0 | 0 | 70.2998 | -83.1076 | 2020-08-16 04:27:42 | Nunavut, Canada | ||
145750 | 145750 | 2020-08-15 | Canada | Prince Edward Island | 41 | 0 | 36 | 5 | 46.5107 | -63.4168 | 2020-08-16 04:27:42 | Prince Edward Island, Canada | ||
145753 | 145753 | 2020-08-15 | Canada | Yukon | 15 | 0 | 15 | 0 | 64.2823 | -135.0 | 2020-08-16 04:27:42 | Yukon, Canada | ||
149734 | 149734 | 2021-11-29 | Canada | Grand Princess | 13 | 0 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | |||
149742 | 149742 | 2021-11-29 | Canada | Prince Edward Island | 372 | 0 | 0 | 46.5107 | -63.4168 | 2021-11-30 04:22:53 | Prince Edward Island, Canada | |||
149744 | 149744 | 2021-11-29 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-11-30 04:22:53 | Repatriated Travellers, Canada | |||||
153750 | 153750 | 2021-01-08 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | ||
153754 | 153754 | 2021-01-08 | Canada | Northwest Territories | 24 | 0 | 24 | 0 | 64.8255 | -124.8457 | 2021-01-09 05:22:18 | Northwest Territories,Canada | ||
153758 | 153758 | 2021-01-08 | Canada | Prince Edward Island | 102 | 0 | 94 | 8 | 46.5107 | -63.4168 | 2021-01-09 05:22:18 | Prince Edward Island, Canada | ||
153760 | 153760 | 2021-01-08 | Canada | Repatriated Travellers | 13 | 0 | 13 | 0 | 2021-01-09 05:22:18 | Repatriated Travellers, Canada | ||||
157763 | 157763 | 2022-03-29 | Canada | Grand Princess | 13 | 0 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | |||
157773 | 157773 | 2022-03-29 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-03-30 04:20:45 | Repatriated Travellers, Canada | |||||
161778 | 161778 | 2021-11-19 | Canada | Grand Princess | 13 | 0 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | |||
161786 | 161786 | 2021-11-19 | Canada | Prince Edward Island | 328 | 0 | 0 | 46.5107 | -63.4168 | 2021-11-20 04:22:17 | Prince Edward Island, Canada | |||
161788 | 161788 | 2021-11-19 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-11-20 04:22:17 | Repatriated Travellers, Canada | |||||
165795 | 165795 | 2022-06-21 | Canada | Grand Princess | 13 | 0 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | |||
165805 | 165805 | 2022-06-21 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-06-22 04:20:54 | Repatriated Travellers, Canada | |||||
169810 | 169810 | 2021-04-16 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | ||
169814 | 169814 | 2021-04-16 | Canada | Northwest Territories | 43 | 0 | 48 | 1 | 64.8255 | -124.8457 | 2021-04-17 04:20:40 | Northwest Territories,Canada | ||
169818 | 169818 | 2021-04-16 | Canada | Prince Edward Island | 165 | 0 | 159 | 6 | 46.5107 | -63.4168 | 2021-04-17 04:20:40 | Prince Edward Island, Canada | ||
169820 | 169820 | 2021-04-16 | Canada | Repatriated Travellers | 13 | 0 | 13 | 0 | 2021-04-17 04:20:40 | Repatriated Travellers, Canada | ||||
177302 | 177302 | 2020-07-27 | Canada | Northwest Territories | 5 | 0 | 5 | 0 | 64.8255 | -124.8457 | 2020-07-28 04:58:43 | Northwest Territories, Canada | ||
177304 | 177304 | 2020-07-27 | Canada | Nunavut | 0 | 0 | 0 | 0 | 70.2998 | -83.1076 | 2020-07-28 04:58:43 | Nunavut, Canada | ||
177340 | 177340 | 2020-07-27 | Canada | Prince Edward Island | 36 | 0 | 34 | 2 | 46.5107 | -63.4168 | 2020-07-28 04:58:43 | Prince Edward Island, Canada | ||
177493 | 177493 | 2020-07-27 | Canada | Yukon | 14 | 0 | 11 | 3 | 64.2823 | -135.0 | 2020-07-28 04:58:43 | Yukon, Canada | ||
177675 | 177675 | 2020-07-27 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-07-13 12:34:33 | Grand Princess, Canada | ||
177792 | 177792 | 2021-09-02 | Canada | Grand Princess | 13 | 0 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | |||
177800 | 177800 | 2021-09-02 | Canada | Prince Edward Island | 233 | 0 | 0 | 46.5107 | -63.4168 | 2021-09-03 04:21:20 | Prince Edward Island, Canada | |||
177802 | 177802 | 2021-09-02 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-09-03 04:21:20 | Repatriated Travellers, Canada | |||||
181806 | 181806 | 2021-02-21 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | ||
181810 | 181810 | 2021-02-21 | Canada | Northwest Territories | 42 | 0 | 39 | 8 | 64.8255 | -124.8457 | 2021-02-22 05:24:21 | Northwest Territories,Canada | ||
181814 | 181814 | 2021-02-21 | Canada | Prince Edward Island | 114 | 0 | 112 | 2 | 46.5107 | -63.4168 | 2021-02-22 05:24:21 | Prince Edward Island, Canada | ||
181816 | 181816 | 2021-02-21 | Canada | Repatriated Travellers | 13 | 0 | 13 | 0 | 2021-02-22 05:24:21 | Repatriated Travellers, Canada | ||||
185821 | 185821 | 2022-02-13 | Canada | Grand Princess | 13 | 0 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | |||
185831 | 185831 | 2022-02-13 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-02-14 04:20:51 | Repatriated Travellers, Canada | |||||
189836 | 189836 | 2021-01-11 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | ||
189840 | 189840 | 2021-01-11 | Canada | Northwest Territories | 24 | 0 | 24 | 0 | 64.8255 | -124.8457 | 2021-01-12 05:22:15 | Northwest Territories,Canada | ||
189844 | 189844 | 2021-01-11 | Canada | Prince Edward Island | 102 | 0 | 94 | 8 | 46.5107 | -63.4168 | 2021-01-12 05:22:15 | Prince Edward Island, Canada | ||
189846 | 189846 | 2021-01-11 | Canada | Repatriated Travellers | 13 | 0 | 13 | 0 | 2021-01-12 05:22:15 | Repatriated Travellers, Canada | ||||
193837 | 193837 | 2020-08-31 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-09-01 04:28:31 | Grand Princess, Canada | ||
193841 | 193841 | 2020-08-31 | Canada | Northwest Territories | 5 | 0 | 5 | 0 | 64.8255 | -124.8457 | 2020-09-01 04:28:31 | Northwest Territories,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]);