johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
59 rows where country_or_region = "Canada" and deaths = 13 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: recovered, latitude, combined_key
province_or_state 10
country_or_region 1
- Canada · 59 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
185829 | 185829 | 2022-02-13 | Canada | Prince Edward Island | 9969 | 13 | 0 | 46.5107 | -63.4168 | 2022-02-14 04:20:51 | Prince Edward Island, Canada | |||
315675 | 315675 | 2022-02-12 | Canada | Prince Edward Island | 9969 | 13 | 0 | 46.5107 | -63.4168 | 2022-02-13 04:21:00 | Prince Edward Island, Canada | |||
233001 | 233001 | 2022-02-11 | Canada | Prince Edward Island | 9969 | 13 | 0 | 46.5107 | -63.4168 | 2022-02-12 04:21:06 | Prince Edward Island, Canada | |||
1463843 | 1463843 | 2022-02-10 | Canada | Prince Edward Island | 9555 | 13 | 0 | 46.5107 | -63.4168 | 2022-02-11 04:21:09 | Prince Edward Island, Canada | |||
3073804 | 3073804 | 2022-02-09 | Canada | Prince Edward Island | 9104 | 13 | 0 | 46.5107 | -63.4168 | 2022-02-10 04:21:14 | Prince Edward Island, Canada | |||
1960311 | 1960311 | 2022-01-20 | Canada | Northwest Territories | 4508 | 13 | 0 | 64.8255 | -124.8457 | 2022-01-21 04:21:09 | Northwest Territories,Canada | |||
3226206 | 3226206 | 2022-01-19 | Canada | Northwest Territories | 4372 | 13 | 0 | 64.8255 | -124.8457 | 2022-01-20 04:21:07 | Northwest Territories,Canada | |||
3463931 | 3463931 | 2022-01-18 | Canada | Northwest Territories | 4234 | 13 | 0 | 64.8255 | -124.8457 | 2022-01-19 04:21:23 | Northwest Territories,Canada | |||
1471870 | 1471870 | 2022-01-17 | Canada | Northwest Territories | 4055 | 13 | 0 | 64.8255 | -124.8457 | 2022-01-18 04:21:04 | Northwest Territories,Canada | |||
1144691 | 1144691 | 2021-12-01 | Canada | Yukon | 1519 | 13 | 0 | 64.2823 | -135.0 | 2021-12-02 04:22:37 | Yukon, Canada | |||
3401203 | 3401203 | 2021-11-30 | Canada | Yukon | 1514 | 13 | 0 | 64.2823 | -135.0 | 2021-12-01 04:22:29 | Yukon, Canada | |||
149746 | 149746 | 2021-11-29 | Canada | Yukon | 1507 | 13 | 0 | 64.2823 | -135.0 | 2021-11-30 04:22:53 | Yukon, Canada | |||
1231392 | 1231392 | 2021-11-28 | Canada | Yukon | 1475 | 13 | 0 | 64.2823 | -135.0 | 2021-11-29 04:22:30 | Yukon, Canada | |||
1358099 | 1358099 | 2021-11-27 | Canada | Yukon | 1475 | 13 | 0 | 64.2823 | -135.0 | 2021-11-28 04:22:43 | Yukon, Canada | |||
758090 | 758090 | 2021-11-26 | Canada | Yukon | 1475 | 13 | 0 | 64.2823 | -135.0 | 2021-11-27 04:22:45 | Yukon, Canada | |||
1908965 | 1908965 | 2021-10-17 | Canada | Newfoundland and Labrador | 1881 | 13 | 0 | 53.1355 | -57.6604 | 2021-10-18 04:21:10 | Newfoundland and Labrador, Canada | |||
934554 | 934554 | 2021-10-16 | Canada | Newfoundland and Labrador | 1881 | 13 | 0 | 53.1355 | -57.6604 | 2021-10-17 04:21:29 | Newfoundland and Labrador, Canada | |||
2943109 | 2943109 | 2021-10-15 | Canada | Newfoundland and Labrador | 1881 | 13 | 0 | 53.1355 | -57.6604 | 2021-10-16 04:21:15 | Newfoundland and Labrador, Canada | |||
491389 | 491389 | 2021-10-14 | Canada | Newfoundland and Labrador | 1877 | 13 | 0 | 53.1355 | -57.6604 | 2021-10-15 04:21:26 | Newfoundland and Labrador, Canada | |||
633677 | 633677 | 2021-10-13 | Canada | Newfoundland and Labrador | 1873 | 13 | 0 | 53.1355 | -57.6604 | 2021-10-14 04:21:29 | Newfoundland and Labrador, Canada | |||
1491355 | 1491355 | 2021-10-12 | Canada | Newfoundland and Labrador | 1869 | 13 | 0 | 53.1355 | -57.6604 | 2021-10-13 04:20:51 | Newfoundland and Labrador, Canada | |||
1759065 | 1759065 | 2021-01-24 | Canada | New Brunswick | 1124 | 13 | 776 | 335 | 46.5653 | -66.4619 | 2021-01-25 05:22:16 | New Brunswick, Canada | ||
2426672 | 2426672 | 2021-01-23 | Canada | New Brunswick | 1104 | 13 | 762 | 329 | 46.5653 | -66.4619 | 2021-01-24 05:22:35 | New Brunswick, Canada | ||
2466574 | 2466574 | 2021-01-22 | Canada | New Brunswick | 1087 | 13 | 742 | 332 | 46.5653 | -66.4619 | 2021-01-23 05:22:03 | New Brunswick, Canada | ||
435125 | 435125 | 2021-01-21 | Canada | New Brunswick | 1057 | 13 | 719 | 325 | 46.5653 | -66.4619 | 2021-01-22 05:22:10 | New Brunswick, Canada | ||
1093857 | 1093857 | 2021-01-20 | Canada | New Brunswick | 1025 | 13 | 694 | 318 | 46.5653 | -66.4619 | 2021-01-21 05:22:01 | New Brunswick, Canada | ||
907947 | 907947 | 2021-01-19 | Canada | New Brunswick | 1004 | 13 | 674 | 317 | 46.5653 | -66.4619 | 2021-01-20 05:21:54 | New Brunswick, Canada | ||
1996415 | 1996415 | 2020-08-26 | Canada | Manitoba | 1043 | 13 | 622 | 408 | 53.7609 | -98.8139 | 2020-08-27 04:28:15 | Manitoba, Canada | ||
3562339 | 3562339 | 2020-08-25 | Canada | Manitoba | 1018 | 13 | 606 | 399 | 53.7609 | -98.8139 | 2020-08-26 04:28:11 | Manitoba, Canada | ||
303223 | 303223 | 2020-07-01 | Canada | Saskatchewan | 785 | 13 | 684 | 88 | 52.9399 | -106.4509 | 2020-07-02 04:33:46 | Saskatchewan, Canada | ||
2974601 | 2974601 | 2020-06-30 | Canada | Saskatchewan | 785 | 13 | 684 | 88 | 52.9399 | -106.4509 | 2020-07-01 04:33:52 | Saskatchewan, Canada | ||
2633078 | 2633078 | 2020-06-29 | Canada | Saskatchewan | 779 | 13 | 679 | 87 | 52.9399 | -106.4509 | 2020-06-30 04:33:48 | Saskatchewan, Canada | ||
2306641 | 2306641 | 2020-06-28 | Canada | Saskatchewan | 778 | 13 | 661 | 104 | 52.9399 | -106.4509 | 2020-06-29 04:33:44 | Saskatchewan, Canada | ||
2039976 | 2039976 | 2020-06-27 | Canada | Saskatchewan | 777 | 13 | 661 | 103 | 52.9399 | -106.4509 | 2020-06-28 04:34:04 | Saskatchewan, Canada | ||
1136257 | 1136257 | 2020-06-26 | Canada | Saskatchewan | 772 | 13 | 654 | 105 | 52.9399 | -106.4509 | 2020-06-27 04:33:35 | Saskatchewan, Canada | ||
2625244 | 2625244 | 2020-06-25 | Canada | Saskatchewan | 759 | 13 | 648 | 98 | 52.9399 | -106.4509 | 2020-06-26 04:33:43 | Saskatchewan, Canada | ||
2700884 | 2700884 | 2020-06-24 | Canada | Saskatchewan | 757 | 13 | 643 | 101 | 52.9399 | -106.4509 | 2020-06-25 05:26:54 | Saskatchewan, Canada | ||
1522569 | 1522569 | 2020-06-23 | Canada | Saskatchewan | 753 | 13 | 642 | 98 | 52.9399 | -106.4509 | 2020-06-24 04:33:28 | Saskatchewan, Canada | ||
1510763 | 1510763 | 2020-06-22 | Canada | Saskatchewan | 751 | 13 | 643 | 95 | 52.9399 | -106.4509 | 2020-06-23 04:33:22 | Saskatchewan, Canada | ||
3249502 | 3249502 | 2020-06-21 | Canada | Saskatchewan | 746 | 13 | 643 | 90 | 52.9399 | -106.4509 | 2020-06-22 04:33:20 | Saskatchewan, Canada | ||
2438095 | 2438095 | 2020-06-20 | Canada | Saskatchewan | 726 | 13 | 639 | 74 | 52.9399 | -106.4509 | 2020-06-21 04:33:19 | Saskatchewan, Canada | ||
1691673 | 1691673 | 2020-06-19 | Canada | Saskatchewan | 716 | 13 | 636 | 67 | 52.9399 | -106.4509 | 2020-06-20 04:33:19 | Saskatchewan, Canada | ||
3682822 | 3682822 | 2020-06-18 | Canada | Saskatchewan | 708 | 13 | 636 | 59 | 52.9399 | -106.4509 | 2020-06-19 04:33:17 | Saskatchewan, Canada | ||
1196025 | 1196025 | 2020-06-17 | Canada | Saskatchewan | 693 | 13 | 633 | 47 | 52.9399 | -106.4509 | 2020-06-18 04:33:18 | Saskatchewan, Canada | ||
2386788 | 2386788 | 2020-06-16 | Canada | Saskatchewan | 684 | 13 | 631 | 40 | 52.9399 | -106.4509 | 2020-06-17 04:33:21 | Saskatchewan, Canada | ||
287351 | 287351 | 2020-06-15 | Canada | Saskatchewan | 683 | 13 | 629 | 41 | 52.9399 | -106.4509 | 2020-06-16 04:33:09 | Saskatchewan, Canada | ||
1837302 | 1837302 | 2020-06-14 | Canada | Saskatchewan | 665 | 13 | 628 | 24 | 52.9399 | -106.4509 | 2020-06-15 03:33:14 | Saskatchewan, Canada | ||
3061354 | 3061354 | 2020-06-13 | Canada | Saskatchewan | 664 | 13 | 627 | 24 | 52.9399 | -106.4509 | 2020-06-14 03:33:15 | Saskatchewan, Canada | ||
737674 | 737674 | 2020-06-12 | Canada | Saskatchewan | 663 | 13 | 627 | 23 | 52.9399 | -106.4509 | 2020-06-13 03:33:14 | Saskatchewan, Canada | ||
1273644 | 1273644 | 2020-06-11 | Canada | Saskatchewan | 660 | 13 | 626 | 21 | 52.9399 | -106.4509 | 2020-06-12 05:09:52 | Saskatchewan, Canada | ||
2864086 | 2864086 | 2020-06-10 | Canada | Saskatchewan | 658 | 13 | 624 | 21 | 52.9399 | -106.4509 | 2020-06-11 03:33:41 | Saskatchewan, Canada | ||
1210912 | 1210912 | 2020-06-09 | Canada | Saskatchewan | 656 | 13 | 624 | 19 | 52.9399 | -106.4509 | 2020-06-10 04:07:00 | Saskatchewan, Canada | ||
217339 | 217339 | 2020-06-08 | Canada | Saskatchewan | 654 | 13 | 624 | 17 | 52.9399 | -106.4509 | 2020-06-09 03:33:03 | Saskatchewan, Canada | ||
3740464 | 3740464 | 2020-04-03 | Canada | Alberta | 969 | 13 | 0 | 956 | 53.9333 | -116.5765 | 2020-04-03 22:52:30 | Alberta, Canada | ||
3701494 | 3701494 | 2020-04-02 | Canada | Alberta | 969 | 13 | 0 | 956 | 53.9333 | -116.5765 | 4/2/20 23:31 | Alberta, Canada | ||
1132471 | 1132471 | 2020-03-25 | Canada | British Columbia | 617 | 13 | 0 | 604 | 53.7267 | -127.6476 | 2020-03-25 23:37:36 | British Columbia, Canada | ||
1132519 | 1132519 | 2020-03-25 | Canada | Ontario | 1560 | 13 | 0 | 680 | 51.2538 | -85.3232 | 2020-03-25 23:37:36 | Ontario, Canada | ||
1478979 | 1478979 | 2020-03-24 | Canada | British Columbia | 617 | 13 | 0 | 604 | 53.7267 | -127.6476 | 2020-03-24 23:41:36 | British Columbia, Canada | ||
2147037 | 2147037 | 2020-03-23 | Canada | British Columbia | 472 | 13 | 0 | 459 | 53.7267 | -127.6476 | 2020-03-23 23:23:10 | British Columbia, 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]);