johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
211 rows where country_or_region = "Canada" and deaths = 2 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 10
country_or_region 1
- Canada · 211 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3226210 | 3226210 | 2022-01-19 | Canada | Prince Edward Island | 5112 | 2 | 0 | 46.5107 | -63.4168 | 2022-01-20 04:21:07 | Prince Edward Island, Canada | |||
3463935 | 3463935 | 2022-01-18 | Canada | Prince Edward Island | 4401 | 2 | 0 | 46.5107 | -63.4168 | 2022-01-19 04:21:23 | Prince Edward Island, Canada | |||
1471874 | 1471874 | 2022-01-17 | Canada | Prince Edward Island | 4401 | 2 | 0 | 46.5107 | -63.4168 | 2022-01-18 04:21:04 | Prince Edward Island, Canada | |||
554548 | 554548 | 2022-01-16 | Canada | Prince Edward Island | 3861 | 2 | 0 | 46.5107 | -63.4168 | 2022-01-17 04:21:08 | Prince Edward Island, Canada | |||
3840269 | 3840269 | 2022-01-15 | Canada | Prince Edward Island | 3861 | 2 | 0 | 46.5107 | -63.4168 | 2022-01-16 04:21:12 | Prince Edward Island, Canada | |||
99084 | 99084 | 2022-01-14 | Canada | Prince Edward Island | 3861 | 2 | 0 | 46.5107 | -63.4168 | 2022-01-15 04:21:07 | Prince Edward Island, Canada | |||
1235400 | 1235400 | 2021-09-27 | Canada | Northwest Territories | 918 | 2 | 0 | 64.8255 | -124.8457 | 2021-09-28 04:21:28 | Northwest Territories,Canada | |||
2075701 | 2075701 | 2021-09-26 | Canada | Northwest Territories | 918 | 2 | 0 | 64.8255 | -124.8457 | 2021-09-27 04:21:16 | Northwest Territories,Canada | |||
1724253 | 1724253 | 2021-09-25 | Canada | Northwest Territories | 918 | 2 | 0 | 64.8255 | -124.8457 | 2021-09-26 04:21:29 | Northwest Territories,Canada | |||
1920973 | 1920973 | 2021-09-24 | Canada | Northwest Territories | 882 | 2 | 0 | 64.8255 | -124.8457 | 2021-09-25 04:21:31 | Northwest Territories,Canada | |||
601444 | 601444 | 2021-09-23 | Canada | Northwest Territories | 852 | 2 | 0 | 64.8255 | -124.8457 | 2021-09-24 04:21:44 | Northwest Territories,Canada | |||
3011105 | 3011105 | 2021-09-22 | Canada | Northwest Territories | 834 | 2 | 0 | 64.8255 | -124.8457 | 2021-09-23 04:21:43 | Northwest Territories,Canada | |||
3757243 | 3757243 | 2021-09-21 | Canada | Northwest Territories | 807 | 2 | 0 | 64.8255 | -124.8457 | 2021-09-22 04:21:45 | Northwest Territories,Canada | |||
3381153 | 3381153 | 2021-06-13 | Canada | Yukon | 104 | 2 | 84 | 18 | 64.2823 | -135.0 | 2021-06-14 04:22:46 | Yukon, Canada | ||
1736287 | 1736287 | 2021-06-12 | Canada | Yukon | 98 | 2 | 82 | 14 | 64.2823 | -135.0 | 2021-06-13 04:22:44 | Yukon, Canada | ||
3970328 | 3970328 | 2021-06-11 | Canada | Yukon | 98 | 2 | 82 | 14 | 64.2823 | -135.0 | 2021-06-12 04:22:22 | Yukon, Canada | ||
2716750 | 2716750 | 2021-06-10 | Canada | Yukon | 96 | 2 | 82 | 12 | 64.2823 | -135.0 | 2021-06-11 04:23:20 | Yukon, Canada | ||
522635 | 522635 | 2021-06-09 | Canada | Yukon | 92 | 2 | 82 | 8 | 64.2823 | -135.0 | 2021-06-10 04:23:17 | Yukon, Canada | ||
3472075 | 3472075 | 2021-06-08 | Canada | Yukon | 88 | 2 | 82 | 4 | 64.2823 | -135.0 | 2021-06-09 04:23:31 | Yukon, Canada | ||
3145359 | 3145359 | 2021-06-07 | Canada | Yukon | 87 | 2 | 82 | 3 | 64.2823 | -135.0 | 2021-06-08 04:22:35 | Yukon, Canada | ||
825361 | 825361 | 2021-06-06 | Canada | Yukon | 87 | 2 | 82 | 3 | 64.2823 | -135.0 | 2021-06-07 04:22:51 | Yukon, Canada | ||
2585766 | 2585766 | 2021-06-05 | Canada | Yukon | 87 | 2 | 82 | 3 | 64.2823 | -135.0 | 2021-06-06 04:24:03 | Yukon, Canada | ||
2315080 | 2315080 | 2021-06-04 | Canada | Yukon | 84 | 2 | 82 | 0 | 64.2823 | -135.0 | 2021-06-05 04:23:03 | Yukon, Canada | ||
1448365 | 1448365 | 2021-06-03 | Canada | Yukon | 84 | 2 | 82 | 0 | 64.2823 | -135.0 | 2021-06-04 04:23:37 | Yukon, Canada | ||
1708089 | 1708089 | 2021-06-02 | Canada | Yukon | 84 | 2 | 82 | 0 | 64.2823 | -135.0 | 2021-06-03 04:23:32 | Yukon, Canada | ||
2103907 | 2103907 | 2021-06-01 | Canada | Yukon | 84 | 2 | 82 | 0 | 64.2823 | -135.0 | 2021-06-02 04:24:34 | Yukon, Canada | ||
1188523 | 1188523 | 2021-05-31 | Canada | Yukon | 84 | 2 | 82 | 0 | 64.2823 | -135.0 | 2021-06-01 04:23:09 | Yukon, Canada | ||
3089200 | 3089200 | 2021-05-30 | Canada | Yukon | 84 | 2 | 82 | 0 | 64.2823 | -135.0 | 2021-05-31 03:08:59 | Yukon, Canada | ||
50569 | 50569 | 2021-05-29 | Canada | Yukon | 84 | 2 | 82 | 0 | 64.2823 | -135.0 | 2021-05-30 04:20:55 | Yukon, Canada | ||
20148 | 20148 | 2021-05-28 | Canada | Yukon | 84 | 2 | 82 | 0 | 64.2823 | -135.0 | 2021-05-29 04:20:41 | Yukon, Canada | ||
1806523 | 1806523 | 2021-05-27 | Canada | Yukon | 84 | 2 | 82 | 0 | 64.2823 | -135.0 | 2021-05-28 04:20:36 | Yukon, Canada | ||
1309947 | 1309947 | 2021-05-26 | Canada | Yukon | 84 | 2 | 82 | 0 | 64.2823 | -135.0 | 2021-05-27 04:20:59 | Yukon, Canada | ||
82873 | 82873 | 2021-05-25 | Canada | Yukon | 84 | 2 | 82 | 0 | 64.2823 | -135.0 | 2021-05-26 04:20:35 | Yukon, Canada | ||
1412835 | 1412835 | 2021-05-24 | Canada | Yukon | 84 | 2 | 82 | 0 | 64.2823 | -135.0 | 2021-05-25 04:21:08 | Yukon, Canada | ||
1771121 | 1771121 | 2021-05-23 | Canada | Yukon | 84 | 2 | 82 | 0 | 64.2823 | -135.0 | 2021-05-24 04:20:53 | Yukon, Canada | ||
726276 | 726276 | 2021-05-22 | Canada | Yukon | 84 | 2 | 82 | 0 | 64.2823 | -135.0 | 2021-05-23 04:20:51 | Yukon, Canada | ||
1952291 | 1952291 | 2021-05-21 | Canada | Yukon | 84 | 2 | 82 | 0 | 64.2823 | -135.0 | 2021-05-22 04:20:45 | Yukon, Canada | ||
1912990 | 1912990 | 2021-05-20 | Canada | Yukon | 84 | 2 | 82 | 0 | 64.2823 | -135.0 | 2021-05-21 04:20:43 | Yukon, Canada | ||
2255511 | 2255511 | 2021-05-19 | Canada | Yukon | 84 | 2 | 82 | 0 | 64.2823 | -135.0 | 2021-05-20 04:21:05 | Yukon, Canada | ||
2390549 | 2390549 | 2021-05-18 | Canada | Yukon | 84 | 2 | 82 | 0 | 64.2823 | -135.0 | 2021-05-19 04:20:42 | Yukon, Canada | ||
3574374 | 3574374 | 2021-05-17 | Canada | Yukon | 84 | 2 | 81 | 1 | 64.2823 | -135.0 | 2021-05-18 04:20:33 | Yukon, Canada | ||
2939104 | 2939104 | 2021-05-16 | Canada | Yukon | 84 | 2 | 81 | 1 | 64.2823 | -135.0 | 2021-05-17 04:20:34 | Yukon, Canada | ||
1872734 | 1872734 | 2021-05-15 | Canada | Yukon | 84 | 2 | 81 | 1 | 64.2823 | -135.0 | 2021-05-16 04:20:49 | Yukon, Canada | ||
1081703 | 1081703 | 2021-05-14 | Canada | Yukon | 84 | 2 | 81 | 1 | 64.2823 | -135.0 | 2021-05-15 04:20:58 | Yukon, Canada | ||
3053969 | 3053969 | 2021-05-13 | Canada | Yukon | 84 | 2 | 80 | 2 | 64.2823 | -135.0 | 2021-05-14 04:20:41 | Yukon, Canada | ||
2004439 | 2004439 | 2021-05-12 | Canada | Yukon | 84 | 2 | 80 | 2 | 64.2823 | -135.0 | 2021-05-13 04:20:51 | Yukon, Canada | ||
3954270 | 3954270 | 2021-05-11 | Canada | Yukon | 84 | 2 | 80 | 2 | 64.2823 | -135.0 | 2021-05-12 04:21:29 | Yukon, Canada | ||
2820549 | 2820549 | 2021-05-10 | Canada | Yukon | 82 | 2 | 80 | 0 | 64.2823 | -135.0 | 2021-05-11 04:20:41 | Yukon, Canada | ||
1424881 | 1424881 | 2021-05-09 | Canada | Yukon | 82 | 2 | 79 | 1 | 64.2823 | -135.0 | 2021-05-10 04:20:38 | Yukon, Canada | ||
1551749 | 1551749 | 2021-05-08 | Canada | Yukon | 82 | 2 | 79 | 1 | 64.2823 | -135.0 | 2021-05-09 04:20:35 | Yukon, Canada | ||
2501807 | 2501807 | 2021-05-07 | Canada | Yukon | 82 | 2 | 79 | 1 | 64.2823 | -135.0 | 2021-05-08 04:21:04 | Yukon, Canada | ||
3113263 | 3113263 | 2021-05-06 | Canada | Yukon | 82 | 2 | 79 | 1 | 64.2823 | -135.0 | 2021-05-07 04:20:40 | Yukon, Canada | ||
645730 | 645730 | 2021-05-05 | Canada | Yukon | 82 | 2 | 79 | 1 | 64.2823 | -135.0 | 2021-05-06 04:20:38 | Yukon, Canada | ||
3675430 | 3675430 | 2021-05-04 | Canada | Yukon | 82 | 2 | 79 | 1 | 64.2823 | -135.0 | 2021-05-05 04:20:43 | Yukon, Canada | ||
2760697 | 2760697 | 2021-05-03 | Canada | Yukon | 82 | 2 | 79 | 1 | 64.2823 | -135.0 | 2021-05-04 04:20:34 | Yukon, Canada | ||
2450550 | 2450550 | 2021-05-02 | Canada | Yukon | 81 | 2 | 79 | 0 | 64.2823 | -135.0 | 2021-05-03 04:20:39 | Yukon, Canada | ||
2824563 | 2824563 | 2021-05-01 | Canada | Yukon | 81 | 2 | 79 | 0 | 64.2823 | -135.0 | 2021-05-02 04:20:48 | Yukon, Canada | ||
379971 | 379971 | 2021-04-30 | Canada | Yukon | 81 | 2 | 79 | 0 | 64.2823 | -135.0 | 2021-05-01 04:20:47 | Yukon, Canada | ||
1636094 | 1636094 | 2021-04-29 | Canada | Yukon | 81 | 2 | 79 | 0 | 64.2823 | -135.0 | 2021-04-30 04:21:03 | Yukon, Canada | ||
3393173 | 3393173 | 2021-04-28 | Canada | Yukon | 81 | 2 | 79 | 0 | 64.2823 | -135.0 | 2021-04-29 04:20:55 | Yukon, Canada | ||
3701889 | 3701889 | 2021-04-27 | Canada | Yukon | 81 | 2 | 79 | 0 | 64.2823 | -135.0 | 2021-04-28 04:20:32 | Yukon, Canada | ||
887898 | 887898 | 2021-04-26 | Canada | Yukon | 81 | 2 | 79 | 0 | 64.2823 | -135.0 | 2021-04-27 04:20:52 | Yukon, Canada | ||
1026123 | 1026123 | 2020-10-17 | Canada | New Brunswick | 297 | 2 | 203 | 92 | 46.5653 | -66.4619 | 2020-10-18 04:24:25 | New Brunswick, Canada | ||
2856618 | 2856618 | 2020-10-16 | Canada | New Brunswick | 297 | 2 | 203 | 92 | 46.5653 | -66.4619 | 2020-10-17 04:24:12 | New Brunswick, Canada | ||
786148 | 786148 | 2020-10-15 | Canada | New Brunswick | 292 | 2 | 201 | 89 | 46.5653 | -66.4619 | 2020-10-16 04:24:01 | New Brunswick, Canada | ||
78859 | 78859 | 2020-10-14 | Canada | New Brunswick | 292 | 2 | 200 | 90 | 46.5653 | -66.4619 | 2020-10-15 04:24:28 | New Brunswick, Canada | ||
3781674 | 3781674 | 2020-10-13 | Canada | New Brunswick | 284 | 2 | 200 | 82 | 46.5653 | -66.4619 | 2020-10-14 04:24:05 | New Brunswick, Canada | ||
2291214 | 2291214 | 2020-10-12 | Canada | New Brunswick | 278 | 2 | 200 | 76 | 46.5653 | -66.4619 | 2020-10-13 04:24:02 | New Brunswick, Canada | ||
3785667 | 3785667 | 2020-10-11 | Canada | New Brunswick | 272 | 2 | 199 | 71 | 46.5653 | -66.4619 | 2020-10-12 04:23:45 | New Brunswick, Canada | ||
2601805 | 2601805 | 2020-10-10 | Canada | New Brunswick | 258 | 2 | 199 | 57 | 46.5653 | -66.4619 | 2020-10-11 04:23:46 | New Brunswick, Canada | ||
817338 | 817338 | 2020-10-09 | Canada | New Brunswick | 238 | 2 | 199 | 37 | 46.5653 | -66.4619 | 2020-10-10 04:23:57 | New Brunswick, Canada | ||
2689453 | 2689453 | 2020-10-08 | Canada | New Brunswick | 225 | 2 | 199 | 24 | 46.5653 | -66.4619 | 2020-10-09 04:23:59 | New Brunswick, Canada | ||
1041595 | 1041595 | 2020-10-07 | Canada | New Brunswick | 222 | 2 | 198 | 22 | 46.5653 | -66.4619 | 2020-10-08 04:23:56 | New Brunswick, Canada | ||
3117256 | 3117256 | 2020-10-06 | Canada | New Brunswick | 205 | 2 | 198 | 5 | 46.5653 | -66.4619 | 2020-10-07 04:23:40 | New Brunswick, Canada | ||
3801668 | 3801668 | 2020-10-05 | Canada | New Brunswick | 203 | 2 | 196 | 5 | 46.5653 | -66.4619 | 2020-10-06 04:23:33 | New Brunswick, Canada | ||
1822558 | 1822558 | 2020-10-04 | Canada | New Brunswick | 201 | 2 | 196 | 3 | 46.5653 | -66.4619 | 2020-10-05 04:23:33 | New Brunswick, Canada | ||
2513942 | 2513942 | 2020-10-03 | Canada | New Brunswick | 201 | 2 | 193 | 6 | 46.5653 | -66.4619 | 2020-10-04 04:23:44 | New Brunswick, Canada | ||
3389160 | 3389160 | 2020-10-02 | Canada | New Brunswick | 200 | 2 | 193 | 5 | 46.5653 | -66.4619 | 2020-10-03 04:23:40 | New Brunswick, Canada | ||
2379401 | 2379401 | 2020-10-01 | Canada | New Brunswick | 200 | 2 | 192 | 6 | 46.5653 | -66.4619 | 2020-10-02 04:23:51 | New Brunswick, Canada | ||
1045587 | 1045587 | 2020-09-30 | Canada | New Brunswick | 200 | 2 | 192 | 6 | 46.5653 | -66.4619 | 2020-10-01 04:23:42 | New Brunswick, Canada | ||
966668 | 966668 | 2020-09-29 | Canada | New Brunswick | 200 | 2 | 192 | 6 | 46.5653 | -66.4619 | 2020-09-30 04:23:33 | New Brunswick, Canada | ||
1515165 | 1515165 | 2020-09-28 | Canada | New Brunswick | 200 | 2 | 192 | 6 | 46.5653 | -66.4619 | 2020-09-29 04:23:42 | New Brunswick, Canada | ||
2581753 | 2581753 | 2020-09-27 | Canada | New Brunswick | 200 | 2 | 192 | 6 | 46.5653 | -66.4619 | 2020-09-28 04:23:00 | New Brunswick, Canada | ||
2613805 | 2613805 | 2020-09-26 | Canada | New Brunswick | 200 | 2 | 192 | 6 | 46.5653 | -66.4619 | 2020-09-27 04:23:00 | New Brunswick, Canada | ||
2812520 | 2812520 | 2020-09-25 | Canada | New Brunswick | 200 | 2 | 192 | 6 | 46.5653 | -66.4619 | 2020-09-26 04:23:00 | New Brunswick, Canada | ||
2605797 | 2605797 | 2020-09-24 | Canada | New Brunswick | 199 | 2 | 192 | 5 | 46.5653 | -66.4619 | 2020-09-25 04:23:00 | New Brunswick, Canada | ||
2653540 | 2653540 | 2020-09-23 | Canada | New Brunswick | 197 | 2 | 192 | 3 | 46.5653 | -66.4619 | 2020-09-24 04:23:00 | New Brunswick, Canada | ||
3315989 | 3315989 | 2020-09-22 | Canada | New Brunswick | 196 | 2 | 192 | 2 | 46.5653 | -66.4619 | 2020-09-23 04:23:00 | New Brunswick, Canada | ||
2836588 | 2836588 | 2020-09-21 | Canada | New Brunswick | 196 | 2 | 192 | 2 | 46.5653 | -66.4619 | 2020-09-22 04:23:00 | New Brunswick, Canada | ||
3093193 | 3093193 | 2020-09-20 | Canada | New Brunswick | 194 | 2 | 192 | 0 | 46.5653 | -66.4619 | 2020-09-21 04:23:00 | New Brunswick, Canada | ||
2454543 | 2454543 | 2020-09-19 | Canada | New Brunswick | 194 | 2 | 192 | 0 | 46.5653 | -66.4619 | 2020-09-20 04:22:00 | New Brunswick, Canada | ||
2848612 | 2848612 | 2020-09-18 | Canada | New Brunswick | 194 | 2 | 192 | 0 | 46.5653 | -66.4619 | 2020-09-19 04:22:00 | New Brunswick, Canada | ||
1121361 | 1121361 | 2020-09-17 | Canada | New Brunswick | 194 | 2 | 191 | 1 | 46.5653 | -66.4619 | 2020-09-18 05:05:00 | New Brunswick, Canada | ||
666050 | 666050 | 2020-09-16 | Canada | New Brunswick | 194 | 2 | 189 | 3 | 46.5653 | -66.4619 | 2020-09-17 04:22:00 | New Brunswick, Canada | ||
2728775 | 2728775 | 2020-09-15 | Canada | New Brunswick | 194 | 2 | 189 | 3 | 46.5653 | -66.4619 | 2020-09-16 04:22:53 | New Brunswick, Canada | ||
344047 | 344047 | 2020-09-14 | Canada | New Brunswick | 194 | 2 | 189 | 3 | 46.5653 | -66.4619 | 2020-09-15 03:22:50 | New Brunswick, Canada | ||
2868486 | 2868486 | 2020-09-13 | Canada | New Brunswick | 193 | 2 | 189 | 2 | 46.5653 | -66.4619 | 2020-09-14 04:26:00 | New Brunswick, Canada | ||
546525 | 546525 | 2020-09-12 | Canada | New Brunswick | 193 | 2 | 189 | 2 | 46.5653 | -66.4619 | 2020-09-13 04:30:52 | New Brunswick, Canada | ||
1444354 | 1444354 | 2020-09-11 | Canada | New Brunswick | 193 | 2 | 189 | 2 | 46.5653 | -66.4619 | 2020-09-12 04:25:05 | New Brunswick, Canada | ||
1172955 | 1172955 | 2020-09-10 | Canada | New Brunswick | 193 | 2 | 188 | 3 | 46.5653 | -66.4619 | 2020-09-11 04:46:23 | New Brunswick, 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]);