johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
91 rows where country_or_region = "Canada" and deaths = 12 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: recovered, last_update (date)
province_or_state 6
country_or_region 1
- Canada · 91 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1362111 | 1362111 | 2022-02-08 | Canada | Prince Edward Island | 9104 | 12 | 0 | 46.5107 | -63.4168 | 2022-02-09 04:21:04 | Prince Edward Island, Canada | |||
70849 | 70849 | 2022-02-07 | Canada | Prince Edward Island | 8764 | 12 | 0 | 46.5107 | -63.4168 | 2022-02-08 04:21:15 | Prince Edward Island, Canada | |||
554544 | 554544 | 2022-01-16 | Canada | Northwest Territories | 3741 | 12 | 0 | 64.8255 | -124.8457 | 2022-01-17 04:21:08 | Northwest Territories,Canada | |||
3840265 | 3840265 | 2022-01-15 | Canada | Northwest Territories | 3741 | 12 | 0 | 64.8255 | -124.8457 | 2022-01-16 04:21:12 | Northwest Territories,Canada | |||
99080 | 99080 | 2022-01-14 | Canada | Northwest Territories | 3741 | 12 | 0 | 64.8255 | -124.8457 | 2022-01-15 04:21:07 | Northwest Territories,Canada | |||
3687235 | 3687235 | 2022-01-13 | Canada | Northwest Territories | 3587 | 12 | 0 | 64.8255 | -124.8457 | 2022-01-14 04:21:54 | Northwest Territories,Canada | |||
3612819 | 3612819 | 2022-01-12 | Canada | Northwest Territories | 3467 | 12 | 0 | 64.8255 | -124.8457 | 2022-01-13 08:00:09 | Northwest Territories,Canada | |||
1113344 | 1113344 | 2022-01-11 | Canada | Northwest Territories | 3322 | 12 | 0 | 64.8255 | -124.8457 | 2022-01-12 04:21:44 | Northwest Territories,Canada | |||
1692072 | 1692072 | 2022-01-10 | Canada | Northwest Territories | 3107 | 12 | 0 | 64.8255 | -124.8457 | 2022-01-11 04:22:01 | Northwest Territories,Canada | |||
126487 | 126487 | 2022-01-09 | Canada | Northwest Territories | 2801 | 12 | 0 | 64.8255 | -124.8457 | 2022-01-10 04:22:07 | Northwest Territories,Canada | |||
1215322 | 1215322 | 2022-01-08 | Canada | Northwest Territories | 2801 | 12 | 0 | 64.8255 | -124.8457 | 2022-01-09 04:21:46 | Northwest Territories,Canada | |||
1389415 | 1389415 | 2022-01-07 | Canada | Northwest Territories | 2801 | 12 | 0 | 64.8255 | -124.8457 | 2022-01-08 04:21:53 | Northwest Territories,Canada | |||
2609802 | 2609802 | 2022-01-06 | Canada | Northwest Territories | 2652 | 12 | 0 | 64.8255 | -124.8457 | 2022-01-07 04:22:09 | Northwest Territories,Canada | |||
1281744 | 1281744 | 2022-01-05 | Canada | Northwest Territories | 2495 | 12 | 0 | 64.8255 | -124.8457 | 2022-01-06 04:22:09 | Northwest Territories,Canada | |||
1285760 | 1285760 | 2022-01-04 | Canada | Northwest Territories | 2419 | 12 | 0 | 64.8255 | -124.8457 | 2022-01-05 04:21:59 | Northwest Territories,Canada | |||
1700104 | 1700104 | 2022-01-03 | Canada | Northwest Territories | 2229 | 12 | 0 | 64.8255 | -124.8457 | 2022-01-04 04:22:17 | Northwest Territories,Canada | |||
3519187 | 3519187 | 2022-01-02 | Canada | Northwest Territories | 2229 | 12 | 0 | 64.8255 | -124.8457 | 2022-01-03 02:22:25 | Northwest Territories,Canada | |||
2167317 | 2167317 | 2022-01-01 | Canada | Northwest Territories | 2229 | 12 | 0 | 64.8255 | -124.8457 | 2022-01-02 04:20:52 | Northwest Territories,Canada | |||
2776748 | 2776748 | 2021-12-31 | Canada | Northwest Territories | 2229 | 12 | 0 | 64.8255 | -124.8457 | 2022-01-01 04:22:14 | Northwest Territories,Canada | |||
3998405 | 3998405 | 2021-12-30 | Canada | Northwest Territories | 2187 | 12 | 0 | 64.8255 | -124.8457 | 2021-12-31 04:21:50 | Northwest Territories,Canada | |||
1668212 | 1668212 | 2021-12-29 | Canada | Northwest Territories | 2090 | 12 | 0 | 64.8255 | -124.8457 | 2021-12-30 04:21:25 | Northwest Territories,Canada | |||
1432321 | 1432321 | 2021-12-28 | Canada | Northwest Territories | 2090 | 12 | 0 | 64.8255 | -124.8457 | 2021-12-29 03:21:43 | Northwest Territories,Canada | |||
730282 | 730282 | 2021-12-27 | Canada | Northwest Territories | 2090 | 12 | 0 | 64.8255 | -124.8457 | 2021-12-28 04:21:47 | Northwest Territories,Canada | |||
2111454 | 2111454 | 2021-12-26 | Canada | Northwest Territories | 2090 | 12 | 0 | 64.8255 | -124.8457 | 2021-12-27 04:21:58 | Northwest Territories,Canada | |||
3604826 | 3604826 | 2021-12-25 | Canada | Northwest Territories | 2090 | 12 | 0 | 64.8255 | -124.8457 | 2021-12-26 04:21:50 | Northwest Territories,Canada | |||
2963144 | 2963144 | 2021-12-24 | Canada | Northwest Territories | 2090 | 12 | 0 | 64.8255 | -124.8457 | 2021-12-25 04:21:37 | Northwest Territories,Canada | |||
3816176 | 3816176 | 2021-12-23 | Canada | Northwest Territories | 2090 | 12 | 0 | 64.8255 | -124.8457 | 2021-12-24 04:21:34 | Northwest Territories,Canada | |||
798184 | 798184 | 2021-12-22 | Canada | Northwest Territories | 2090 | 12 | 0 | 64.8255 | -124.8457 | 2021-12-23 04:21:21 | Northwest Territories,Canada | |||
3828224 | 3828224 | 2021-12-21 | Canada | Northwest Territories | 2083 | 12 | 0 | 64.8255 | -124.8457 | 2021-12-22 04:21:54 | Northwest Territories,Canada | |||
1254527 | 1254527 | 2021-12-20 | Canada | Northwest Territories | 2082 | 12 | 0 | 64.8255 | -124.8457 | 2021-12-21 03:21:27 | Northwest Territories,Canada | |||
2903470 | 2903470 | 2021-12-19 | Canada | Northwest Territories | 2082 | 12 | 0 | 64.8255 | -124.8457 | 2021-12-20 04:21:43 | Northwest Territories,Canada | |||
1258543 | 1258543 | 2021-12-18 | Canada | Northwest Territories | 2082 | 12 | 0 | 64.8255 | -124.8457 | 2021-12-19 04:21:11 | Northwest Territories,Canada | |||
2398571 | 2398571 | 2021-12-17 | Canada | Northwest Territories | 2082 | 12 | 0 | 64.8255 | -124.8457 | 2021-12-18 02:22:20 | Northwest Territories,Canada | |||
1716109 | 1716109 | 2021-12-16 | Canada | Northwest Territories | 2082 | 12 | 0 | 64.8255 | -124.8457 | 2021-12-17 04:22:14 | Northwest Territories,Canada | |||
3495943 | 3495943 | 2021-12-15 | Canada | Northwest Territories | 2076 | 12 | 0 | 64.8255 | -124.8457 | 2021-12-16 04:22:11 | Northwest Territories,Canada | |||
2087728 | 2087728 | 2021-12-14 | Canada | Northwest Territories | 2071 | 12 | 0 | 64.8255 | -124.8457 | 2021-12-15 03:22:16 | Northwest Territories,Canada | |||
782145 | 782145 | 2021-12-13 | Canada | Northwest Territories | 2071 | 12 | 0 | 64.8255 | -124.8457 | 2021-12-14 04:22:38 | Northwest Territories,Canada | |||
1660180 | 1660180 | 2021-12-12 | Canada | Northwest Territories | 2070 | 12 | 0 | 64.8255 | -124.8457 | 2021-12-13 04:22:02 | Northwest Territories,Canada | |||
1664196 | 1664196 | 2021-12-11 | Canada | Northwest Territories | 2070 | 12 | 0 | 64.8255 | -124.8457 | 2021-12-12 04:22:12 | Northwest Territories,Canada | |||
3655348 | 3655348 | 2021-12-10 | Canada | Northwest Territories | 2070 | 12 | 0 | 64.8255 | -124.8457 | 2021-12-11 04:22:45 | Northwest Territories,Canada | |||
1077679 | 1077679 | 2021-12-09 | Canada | Northwest Territories | 2069 | 12 | 0 | 64.8255 | -124.8457 | 2021-12-10 04:22:28 | Northwest Territories,Canada | |||
550528 | 550528 | 2021-12-08 | Canada | Northwest Territories | 2069 | 12 | 0 | 64.8255 | -124.8457 | 2021-12-09 04:22:49 | Northwest Territories,Canada | |||
404048 | 404048 | 2021-12-07 | Canada | Northwest Territories | 2069 | 12 | 0 | 64.8255 | -124.8457 | 2021-12-08 04:22:46 | Northwest Territories,Canada | |||
1030130 | 1030130 | 2021-12-06 | Canada | Northwest Territories | 2069 | 12 | 0 | 64.8255 | -124.8457 | 2021-12-07 04:22:34 | Northwest Territories,Canada | |||
1740293 | 1740293 | 2021-12-05 | Canada | Northwest Territories | 2069 | 12 | 0 | 64.8255 | -124.8457 | 2021-12-06 04:22:34 | Northwest Territories,Canada | |||
137725 | 137725 | 2021-12-04 | Canada | Northwest Territories | 2069 | 12 | 0 | 64.8255 | -124.8457 | 2021-12-05 04:22:25 | Northwest Territories,Canada | |||
2195378 | 2195378 | 2021-12-03 | Canada | Northwest Territories | 2068 | 12 | 0 | 64.8255 | -124.8457 | 2021-12-04 04:22:18 | Northwest Territories,Canada | |||
84 | 84 | 2021-12-02 | Canada | Northwest Territories | 2068 | 12 | 0 | 64.8255 | -124.8457 | 2021-12-03 04:23:05 | Northwest Territories,Canada | |||
1144683 | 1144683 | 2021-12-01 | Canada | Northwest Territories | 2063 | 12 | 0 | 64.8255 | -124.8457 | 2021-12-02 04:22:37 | Northwest Territories,Canada | |||
3401195 | 3401195 | 2021-11-30 | Canada | Northwest Territories | 2060 | 12 | 0 | 64.8255 | -124.8457 | 2021-12-01 04:22:29 | Northwest Territories,Canada | |||
149738 | 149738 | 2021-11-29 | Canada | Northwest Territories | 2059 | 12 | 0 | 64.8255 | -124.8457 | 2021-11-30 04:22:53 | Northwest Territories,Canada | |||
1231384 | 1231384 | 2021-11-28 | Canada | Northwest Territories | 2059 | 12 | 0 | 64.8255 | -124.8457 | 2021-11-29 04:22:30 | Northwest Territories,Canada | |||
1358091 | 1358091 | 2021-11-27 | Canada | Northwest Territories | 2059 | 12 | 0 | 64.8255 | -124.8457 | 2021-11-28 04:22:43 | Northwest Territories,Canada | |||
758082 | 758082 | 2021-11-26 | Canada | Northwest Territories | 2059 | 12 | 0 | 64.8255 | -124.8457 | 2021-11-27 04:22:45 | Northwest Territories,Canada | |||
1802499 | 1802499 | 2021-11-25 | Canada | Northwest Territories | 2059 | 12 | 0 | 64.8255 | -124.8457 | 2021-11-26 04:22:33 | Northwest Territories,Canada | |||
1802507 | 1802507 | 2021-11-25 | Canada | Yukon | 1469 | 12 | 0 | 64.2823 | -135.0 | 2021-11-26 04:22:33 | Yukon, Canada | |||
903933 | 903933 | 2021-11-24 | Canada | Northwest Territories | 2057 | 12 | 0 | 64.8255 | -124.8457 | 2021-11-25 04:22:33 | Northwest Territories,Canada | |||
903941 | 903941 | 2021-11-24 | Canada | Yukon | 1454 | 12 | 0 | 64.2823 | -135.0 | 2021-11-25 04:22:33 | Yukon, Canada | |||
3069783 | 3069783 | 2021-11-23 | Canada | Northwest Territories | 2055 | 12 | 0 | 64.8255 | -124.8457 | 2021-11-24 04:22:14 | Northwest Territories,Canada | |||
3069791 | 3069791 | 2021-11-23 | Canada | Yukon | 1446 | 12 | 0 | 64.2823 | -135.0 | 2021-11-24 04:22:14 | Yukon, Canada | |||
3748881 | 3748881 | 2021-11-22 | Canada | Northwest Territories | 2044 | 12 | 0 | 64.8255 | -124.8457 | 2021-11-23 04:22:39 | Northwest Territories,Canada | |||
3748889 | 3748889 | 2021-11-22 | Canada | Yukon | 1426 | 12 | 0 | 64.2823 | -135.0 | 2021-11-23 04:22:39 | Yukon, Canada | |||
1014088 | 1014088 | 2021-11-21 | Canada | Northwest Territories | 2036 | 12 | 0 | 64.8255 | -124.8457 | 2021-11-22 04:22:20 | Northwest Territories,Canada | |||
1014096 | 1014096 | 2021-11-21 | Canada | Yukon | 1381 | 12 | 0 | 64.2823 | -135.0 | 2021-11-22 04:22:20 | Yukon, Canada | |||
722252 | 722252 | 2021-11-20 | Canada | Northwest Territories | 2036 | 12 | 0 | 64.8255 | -124.8457 | 2021-11-21 04:22:13 | Northwest Territories,Canada | |||
722260 | 722260 | 2021-11-20 | Canada | Yukon | 1381 | 12 | 0 | 64.2823 | -135.0 | 2021-11-21 04:22:13 | Yukon, Canada | |||
161782 | 161782 | 2021-11-19 | Canada | Northwest Territories | 2032 | 12 | 0 | 64.8255 | -124.8457 | 2021-11-20 04:22:17 | Northwest Territories,Canada | |||
161790 | 161790 | 2021-11-19 | Canada | Yukon | 1381 | 12 | 0 | 64.2823 | -135.0 | 2021-11-20 04:22:17 | Yukon, Canada | |||
3288669 | 3288669 | 2021-11-18 | Canada | Northwest Territories | 2032 | 12 | 0 | 64.8255 | -124.8457 | 2021-11-19 04:21:40 | Northwest Territories,Canada | |||
3288677 | 3288677 | 2021-11-18 | Canada | Yukon | 1349 | 12 | 0 | 64.2823 | -135.0 | 2021-11-19 04:21:40 | Yukon, Canada | |||
447125 | 447125 | 2021-11-17 | Canada | Northwest Territories | 2029 | 12 | 0 | 64.8255 | -124.8457 | 2021-11-18 04:21:33 | Northwest Territories,Canada | |||
3342375 | 3342375 | 2021-11-16 | Canada | Northwest Territories | 2028 | 12 | 0 | 64.8255 | -124.8457 | 2021-11-17 04:21:48 | Northwest Territories,Canada | |||
2287211 | 2287211 | 2021-11-15 | Canada | Northwest Territories | 2021 | 12 | 0 | 64.8255 | -124.8457 | 2021-11-16 04:21:10 | Northwest Territories,Canada | |||
1321985 | 1321985 | 2021-11-14 | Canada | Northwest Territories | 2001 | 12 | 0 | 64.8255 | -124.8457 | 2021-11-15 04:21:36 | Northwest Territories,Canada | |||
686111 | 686111 | 2021-11-13 | Canada | Northwest Territories | 2001 | 12 | 0 | 64.8255 | -124.8457 | 2021-11-14 04:21:31 | Northwest Territories,Canada | |||
714220 | 714220 | 2021-11-12 | Canada | Northwest Territories | 1951 | 12 | 0 | 64.8255 | -124.8457 | 2021-11-13 04:21:38 | Northwest Territories,Canada | |||
28170 | 28170 | 2021-11-11 | Canada | Northwest Territories | 1951 | 12 | 0 | 64.8255 | -124.8457 | 2021-11-12 04:22:01 | Northwest Territories,Canada | |||
2844609 | 2844609 | 2021-11-10 | Canada | Northwest Territories | 1951 | 12 | 0 | 64.8255 | -124.8457 | 2021-11-11 04:21:45 | Northwest Territories,Canada | |||
237010 | 237010 | 2021-01-18 | Canada | New Brunswick | 973 | 12 | 656 | 305 | 46.5653 | -66.4619 | 2021-01-19 05:22:15 | New Brunswick, Canada | ||
3503127 | 3503127 | 2021-01-17 | Canada | New Brunswick | 947 | 12 | 642 | 293 | 46.5653 | -66.4619 | 2021-01-18 05:22:34 | New Brunswick, Canada | ||
3101210 | 3101210 | 2021-01-16 | Canada | New Brunswick | 911 | 12 | 631 | 268 | 46.5653 | -66.4619 | 2021-01-17 05:22:17 | New Brunswick, Canada | ||
3515172 | 3515172 | 2021-01-15 | Canada | New Brunswick | 884 | 12 | 615 | 257 | 46.5653 | -66.4619 | 2021-01-16 05:22:40 | New Brunswick, Canada | ||
3879345 | 3879345 | 2021-01-14 | Canada | New Brunswick | 859 | 12 | 600 | 247 | 46.5653 | -66.4619 | 2021-01-15 05:22:24 | New Brunswick, Canada | ||
3307972 | 3307972 | 2021-01-13 | Canada | New Brunswick | 836 | 12 | 593 | 231 | 46.5653 | -66.4619 | 2021-01-14 05:22:32 | New Brunswick, Canada | ||
2991043 | 2991043 | 2020-08-24 | Canada | Manitoba | 993 | 12 | 586 | 395 | 53.7609 | -98.8139 | 2020-08-25 04:28:02 | Manitoba, Canada | ||
2215438 | 2215438 | 2020-08-23 | Canada | Manitoba | 944 | 12 | 576 | 356 | 53.7609 | -98.8139 | 2020-08-24 04:27:56 | Manitoba, Canada | ||
2299220 | 2299220 | 2020-08-22 | Canada | Manitoba | 872 | 12 | 570 | 290 | 53.7609 | -98.8139 | 2020-08-23 04:27:48 | Manitoba, Canada | ||
1479327 | 1479327 | 2020-08-21 | Canada | Manitoba | 830 | 12 | 553 | 265 | 53.7609 | -98.8139 | 2020-08-22 04:27:49 | Manitoba, Canada | ||
3484076 | 3484076 | 2020-08-20 | Canada | Manitoba | 796 | 12 | 537 | 247 | 53.7609 | -98.8139 | 2020-08-21 04:27:41 | Manitoba, Canada | ||
206025 | 206025 | 2020-08-19 | Canada | Manitoba | 763 | 12 | 528 | 223 | 53.7609 | -98.8139 | 2020-08-20 04:27:43 | Manitoba, Canada | ||
1199227 | 1199227 | 2020-04-22 | Canada | Nova Scotia | 772 | 12 | 0 | 760 | 44.681999999999995 | -63.7443 | 2020-04-22 23:38:42 | Nova Scotia, 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]);