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 day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state 21
- British Columbia 152
- Ontario 120
- Alberta 111
- Quebec 111
- New Brunswick 109
- Manitoba 107
- Saskatchewan 107
- Newfoundland and Labrador 105
- Prince Edward Island 105
- Nova Scotia 101
- Grand Princess 100
- Northwest Territories 96
- Nunavut 95
- Yukon 94
- Diamond Princess 86
- Recovered 51
- London, ON 34
- Toronto, ON 34
- Montreal, QC 13
- Calgary, Alberta 3
- Edmonton, Alberta 2
country_or_region 1
- Canada · 1,736 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2039585 | 2039585 | 2020-06-27 | Canada | Alberta | 7957 | 154 | 7283 | 520 | 53.9333 | -116.5765 | 2020-06-28 04:34:04 | Alberta, Canada | ||
2039641 | 2039641 | 2020-06-27 | Canada | British Columbia | 2878 | 174 | 2545 | 159 | 53.7267 | -127.6476 | 2020-06-28 04:34:04 | British Columbia, Canada | ||
2039693 | 2039693 | 2020-06-27 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-06-28 04:34:04 | Diamond Princess, Canada | ||
2039722 | 2039722 | 2020-06-27 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-06-28 04:34:04 | Grand Princess, Canada | ||
2039836 | 2039836 | 2020-06-27 | Canada | Manitoba | 322 | 7 | 300 | 15 | 53.7609 | -98.8139 | 2020-06-28 04:34:04 | Manitoba, Canada | ||
2039875 | 2039875 | 2020-06-27 | Canada | New Brunswick | 165 | 2 | 154 | 9 | 46.5653 | -66.4619 | 2020-06-28 04:34:04 | New Brunswick, Canada | ||
2039878 | 2039878 | 2020-06-27 | Canada | Newfoundland and Labrador | 261 | 3 | 258 | 0 | 53.1355 | -57.6604 | 2020-06-28 04:34:04 | Newfoundland and Labrador, Canada | ||
2039890 | 2039890 | 2020-06-27 | Canada | Northwest Territories | 5 | 0 | 5 | 0 | 64.8255 | -124.8457 | 2020-06-28 04:34:04 | Northwest Territories, Canada | ||
2039891 | 2039891 | 2020-06-27 | Canada | Nova Scotia | 1061 | 63 | 998 | 0 | 44.681999999999995 | -63.7443 | 2020-06-28 04:34:04 | Nova Scotia, Canada | ||
2039892 | 2039892 | 2020-06-27 | Canada | Nunavut | 0 | 0 | 0 | 0 | 70.2998 | -83.1076 | 2020-06-28 04:34:04 | Nunavut, Canada | ||
2039905 | 2039905 | 2020-06-27 | Canada | Ontario | 35012 | 2652 | 31404 | 2207 | 51.2538 | -85.3232 | 2020-06-28 04:34:04 | Ontario, Canada | ||
2039927 | 2039927 | 2020-06-27 | Canada | Prince Edward Island | 27 | 0 | 27 | 0 | 46.5107 | -63.4168 | 2020-06-28 04:34:04 | Prince Edward Island, Canada | ||
2039938 | 2039938 | 2020-06-27 | Canada | Quebec | 55176 | 5611 | 23786 | 25779 | 52.9399 | -73.5491 | 2020-06-28 04:34:04 | Quebec, Canada | ||
2039976 | 2039976 | 2020-06-27 | Canada | Saskatchewan | 777 | 13 | 661 | 103 | 52.9399 | -106.4509 | 2020-06-28 04:34:04 | Saskatchewan, Canada | ||
2040081 | 2040081 | 2020-06-27 | Canada | Yukon | 11 | 0 | 11 | 0 | 64.2823 | -135.0 | 2020-06-28 04:34:04 | Yukon, Canada | ||
1135866 | 1135866 | 2020-06-26 | Canada | Alberta | 7888 | 154 | 7225 | 509 | 53.9333 | -116.5765 | 2020-06-27 04:33:35 | Alberta, Canada | ||
1135922 | 1135922 | 2020-06-26 | Canada | British Columbia | 2878 | 174 | 2545 | 159 | 53.7267 | -127.6476 | 2020-06-27 04:33:35 | British Columbia, Canada | ||
1135974 | 1135974 | 2020-06-26 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-06-27 04:33:35 | Diamond Princess, Canada | ||
1136003 | 1136003 | 2020-06-26 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-06-27 04:33:35 | Grand Princess, Canada | ||
1136117 | 1136117 | 2020-06-26 | Canada | Manitoba | 318 | 7 | 300 | 11 | 53.7609 | -98.8139 | 2020-06-27 04:33:35 | Manitoba, Canada | ||
1136156 | 1136156 | 2020-06-26 | Canada | New Brunswick | 165 | 2 | 150 | 13 | 46.5653 | -66.4619 | 2020-06-27 04:33:35 | New Brunswick, Canada | ||
1136159 | 1136159 | 2020-06-26 | Canada | Newfoundland and Labrador | 261 | 3 | 258 | 0 | 53.1355 | -57.6604 | 2020-06-27 04:33:35 | Newfoundland and Labrador, Canada | ||
1136171 | 1136171 | 2020-06-26 | Canada | Northwest Territories | 5 | 0 | 5 | 0 | 64.8255 | -124.8457 | 2020-06-27 04:33:35 | Northwest Territories, Canada | ||
1136172 | 1136172 | 2020-06-26 | Canada | Nova Scotia | 1061 | 63 | 998 | 0 | 44.681999999999995 | -63.7443 | 2020-06-27 04:33:35 | Nova Scotia, Canada | ||
1136173 | 1136173 | 2020-06-26 | Canada | Nunavut | 0 | 0 | 0 | 0 | 70.2998 | -83.1076 | 2020-06-27 04:33:35 | Nunavut, Canada | ||
1136186 | 1136186 | 2020-06-26 | Canada | Ontario | 34776 | 2644 | 31210 | 2235 | 51.2538 | -85.3232 | 2020-06-27 04:33:35 | Ontario, Canada | ||
1136208 | 1136208 | 2020-06-26 | Canada | Prince Edward Island | 27 | 0 | 27 | 0 | 46.5107 | -63.4168 | 2020-06-27 04:33:35 | Prince Edward Island, Canada | ||
1136219 | 1136219 | 2020-06-26 | Canada | Quebec | 55088 | 5607 | 23786 | 25695 | 52.9399 | -73.5491 | 2020-06-27 04:33:35 | Quebec, Canada | ||
1136257 | 1136257 | 2020-06-26 | Canada | Saskatchewan | 772 | 13 | 654 | 105 | 52.9399 | -106.4509 | 2020-06-27 04:33:35 | Saskatchewan, Canada | ||
1136362 | 1136362 | 2020-06-26 | Canada | Yukon | 11 | 0 | 11 | 0 | 64.2823 | -135.0 | 2020-06-27 04:33:35 | Yukon, Canada | ||
2624853 | 2624853 | 2020-06-25 | Canada | Alberta | 7851 | 154 | 7191 | 506 | 53.9333 | -116.5765 | 2020-06-26 04:33:43 | Alberta, Canada | ||
2624909 | 2624909 | 2020-06-25 | Canada | British Columbia | 2869 | 173 | 2517 | 179 | 53.7267 | -127.6476 | 2020-06-26 04:33:43 | British Columbia, Canada | ||
2624961 | 2624961 | 2020-06-25 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-06-26 04:33:43 | Diamond Princess, Canada | ||
2624990 | 2624990 | 2020-06-25 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-06-26 04:33:43 | Grand Princess, Canada | ||
2625104 | 2625104 | 2020-06-25 | Canada | Manitoba | 316 | 7 | 294 | 15 | 53.7609 | -98.8139 | 2020-06-26 04:33:43 | Manitoba, Canada | ||
2625143 | 2625143 | 2020-06-25 | Canada | New Brunswick | 165 | 2 | 149 | 14 | 46.5653 | -66.4619 | 2020-06-26 04:33:43 | New Brunswick, Canada | ||
2625146 | 2625146 | 2020-06-25 | Canada | Newfoundland and Labrador | 261 | 3 | 258 | 0 | 53.1355 | -57.6604 | 2020-06-26 04:33:43 | Newfoundland and Labrador, Canada | ||
2625158 | 2625158 | 2020-06-25 | Canada | Northwest Territories | 5 | 0 | 5 | 0 | 64.8255 | -124.8457 | 2020-06-26 04:33:43 | Northwest Territories, Canada | ||
2625159 | 2625159 | 2020-06-25 | Canada | Nova Scotia | 1061 | 63 | 998 | 0 | 44.681999999999995 | -63.7443 | 2020-06-26 04:33:43 | Nova Scotia, Canada | ||
2625160 | 2625160 | 2020-06-25 | Canada | Nunavut | 0 | 0 | 0 | 0 | 70.2998 | -83.1076 | 2020-06-26 04:33:43 | Nunavut, Canada | ||
2625173 | 2625173 | 2020-06-25 | Canada | Ontario | 34595 | 2641 | 30972 | 2371 | 51.2538 | -85.3232 | 2020-06-26 04:33:43 | Ontario, Canada | ||
2625195 | 2625195 | 2020-06-25 | Canada | Prince Edward Island | 27 | 0 | 27 | 0 | 46.5107 | -63.4168 | 2020-06-26 04:33:43 | Prince Edward Island, Canada | ||
2625206 | 2625206 | 2020-06-25 | Canada | Quebec | 55003 | 5604 | 23786 | 25613 | 52.9399 | -73.5491 | 2020-06-26 04:33:43 | Quebec, Canada | ||
2625244 | 2625244 | 2020-06-25 | Canada | Saskatchewan | 759 | 13 | 648 | 98 | 52.9399 | -106.4509 | 2020-06-26 04:33:43 | Saskatchewan, Canada | ||
2625349 | 2625349 | 2020-06-25 | Canada | Yukon | 11 | 0 | 11 | 0 | 64.2823 | -135.0 | 2020-06-26 04:33:43 | Yukon, Canada | ||
2700493 | 2700493 | 2020-06-24 | Canada | Alberta | 7825 | 153 | 7134 | 538 | 53.9333 | -116.5765 | 2020-06-25 05:26:54 | Alberta, Canada | ||
2700549 | 2700549 | 2020-06-24 | Canada | British Columbia | 2849 | 171 | 2516 | 162 | 53.7267 | -127.6476 | 2020-06-25 05:26:54 | British Columbia, Canada | ||
2700601 | 2700601 | 2020-06-24 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-06-25 05:26:54 | Diamond Princess, Canada | ||
2700630 | 2700630 | 2020-06-24 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-06-25 05:26:54 | Grand Princess, Canada | ||
2700744 | 2700744 | 2020-06-24 | Canada | Manitoba | 315 | 7 | 293 | 15 | 53.7609 | -98.8139 | 2020-06-25 05:26:54 | Manitoba, Canada | ||
2700783 | 2700783 | 2020-06-24 | Canada | New Brunswick | 165 | 2 | 147 | 16 | 46.5653 | -66.4619 | 2020-06-25 05:26:54 | New Brunswick, Canada | ||
2700786 | 2700786 | 2020-06-24 | Canada | Newfoundland and Labrador | 261 | 3 | 258 | 0 | 53.1355 | -57.6604 | 2020-06-25 05:26:54 | Newfoundland and Labrador, Canada | ||
2700798 | 2700798 | 2020-06-24 | Canada | Northwest Territories | 5 | 0 | 5 | 0 | 64.8255 | -124.8457 | 2020-06-25 05:26:54 | Northwest Territories, Canada | ||
2700799 | 2700799 | 2020-06-24 | Canada | Nova Scotia | 1061 | 63 | 998 | 0 | 44.681999999999995 | -63.7443 | 2020-06-25 05:26:54 | Nova Scotia, Canada | ||
2700800 | 2700800 | 2020-06-24 | Canada | Nunavut | 0 | 0 | 0 | 0 | 70.2998 | -83.1076 | 2020-06-25 05:26:54 | Nunavut, Canada | ||
2700813 | 2700813 | 2020-06-24 | Canada | Ontario | 34440 | 2631 | 30778 | 2393 | 51.2538 | -85.3232 | 2020-06-25 05:26:54 | Ontario, Canada | ||
2700835 | 2700835 | 2020-06-24 | Canada | Prince Edward Island | 27 | 0 | 27 | 0 | 46.5107 | -63.4168 | 2020-06-25 05:26:54 | Prince Edward Island, Canada | ||
2700846 | 2700846 | 2020-06-24 | Canada | Quebec | 54913 | 5597 | 23710 | 25606 | 52.9399 | -73.5491 | 2020-06-25 05:26:54 | Quebec, Canada | ||
2700884 | 2700884 | 2020-06-24 | Canada | Saskatchewan | 757 | 13 | 643 | 101 | 52.9399 | -106.4509 | 2020-06-25 05:26:54 | Saskatchewan, Canada | ||
2700989 | 2700989 | 2020-06-24 | Canada | Yukon | 11 | 0 | 11 | 0 | 64.2823 | -135.0 | 2020-06-25 05:26:54 | Yukon, Canada | ||
1522178 | 1522178 | 2020-06-23 | Canada | Alberta | 7781 | 153 | 7096 | 532 | 53.9333 | -116.5765 | 2020-06-24 04:33:28 | Alberta, Canada | ||
1522234 | 1522234 | 2020-06-23 | Canada | British Columbia | 2835 | 170 | 2491 | 174 | 53.7267 | -127.6476 | 2020-06-24 04:33:28 | British Columbia, Canada | ||
1522286 | 1522286 | 2020-06-23 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-06-24 04:33:28 | Diamond Princess, Canada | ||
1522315 | 1522315 | 2020-06-23 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-06-24 04:33:28 | Grand Princess, Canada | ||
1522429 | 1522429 | 2020-06-23 | Canada | Manitoba | 314 | 7 | 293 | 14 | 53.7609 | -98.8139 | 2020-06-24 04:33:28 | Manitoba, Canada | ||
1522468 | 1522468 | 2020-06-23 | Canada | New Brunswick | 165 | 2 | 143 | 20 | 46.5653 | -66.4619 | 2020-06-24 04:33:28 | New Brunswick, Canada | ||
1522471 | 1522471 | 2020-06-23 | Canada | Newfoundland and Labrador | 261 | 3 | 258 | 0 | 53.1355 | -57.6604 | 2020-06-24 04:33:28 | Newfoundland and Labrador, Canada | ||
1522483 | 1522483 | 2020-06-23 | Canada | Northwest Territories | 5 | 0 | 5 | 0 | 64.8255 | -124.8457 | 2020-06-24 04:33:28 | Northwest Territories, Canada | ||
1522484 | 1522484 | 2020-06-23 | Canada | Nova Scotia | 1061 | 63 | 998 | 0 | 44.681999999999995 | -63.7443 | 2020-06-24 04:33:28 | Nova Scotia, Canada | ||
1522485 | 1522485 | 2020-06-23 | Canada | Nunavut | 0 | 0 | 0 | 0 | 70.2998 | -83.1076 | 2020-06-24 04:33:28 | Nunavut, Canada | ||
1522498 | 1522498 | 2020-06-23 | Canada | Ontario | 34272 | 2619 | 30538 | 2443 | 51.2538 | -85.3232 | 2020-06-24 04:33:28 | Ontario, Canada | ||
1522520 | 1522520 | 2020-06-23 | Canada | Prince Edward Island | 27 | 0 | 27 | 0 | 46.5107 | -63.4168 | 2020-06-24 04:33:28 | Prince Edward Island, Canada | ||
1522531 | 1522531 | 2020-06-23 | Canada | Quebec | 54824 | 5582 | 23620 | 25622 | 52.9399 | -73.5491 | 2020-06-24 04:33:28 | Quebec, Canada | ||
1522569 | 1522569 | 2020-06-23 | Canada | Saskatchewan | 753 | 13 | 642 | 98 | 52.9399 | -106.4509 | 2020-06-24 04:33:28 | Saskatchewan, Canada | ||
1522674 | 1522674 | 2020-06-23 | Canada | Yukon | 11 | 0 | 11 | 0 | 64.2823 | -135.0 | 2020-06-24 04:33:28 | Yukon, Canada | ||
1510372 | 1510372 | 2020-06-22 | Canada | Alberta | 7736 | 153 | 7041 | 542 | 53.9333 | -116.5765 | 2020-06-23 04:33:22 | Alberta, Canada | ||
1510428 | 1510428 | 2020-06-22 | Canada | British Columbia | 2822 | 169 | 2471 | 182 | 53.7267 | -127.6476 | 2020-06-23 04:33:22 | British Columbia, Canada | ||
1510480 | 1510480 | 2020-06-22 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-06-23 04:33:22 | Diamond Princess, Canada | ||
1510509 | 1510509 | 2020-06-22 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-06-23 04:33:22 | Grand Princess, Canada | ||
1510623 | 1510623 | 2020-06-22 | Canada | Manitoba | 314 | 7 | 293 | 14 | 53.7609 | -98.8139 | 2020-06-23 04:33:22 | Manitoba, Canada | ||
1510662 | 1510662 | 2020-06-22 | Canada | New Brunswick | 164 | 2 | 135 | 27 | 46.5653 | -66.4619 | 2020-06-23 04:33:22 | New Brunswick, Canada | ||
1510665 | 1510665 | 2020-06-22 | Canada | Newfoundland and Labrador | 261 | 3 | 258 | 0 | 53.1355 | -57.6604 | 2020-06-23 04:33:22 | Newfoundland and Labrador, Canada | ||
1510677 | 1510677 | 2020-06-22 | Canada | Northwest Territories | 5 | 0 | 5 | 0 | 64.8255 | -124.8457 | 2020-06-23 04:33:22 | Northwest Territories, Canada | ||
1510678 | 1510678 | 2020-06-22 | Canada | Nova Scotia | 1061 | 63 | 998 | 0 | 44.681999999999995 | -63.7443 | 2020-06-23 04:33:22 | Nova Scotia, Canada | ||
1510679 | 1510679 | 2020-06-22 | Canada | Nunavut | 0 | 0 | 0 | 0 | 70.2998 | -83.1076 | 2020-06-23 04:33:22 | Nunavut, Canada | ||
1510692 | 1510692 | 2020-06-22 | Canada | Ontario | 34109 | 2609 | 30320 | 2432 | 51.2538 | -85.3232 | 2020-06-23 04:33:22 | Ontario, Canada | ||
1510714 | 1510714 | 2020-06-22 | Canada | Prince Edward Island | 27 | 0 | 27 | 0 | 46.5107 | -63.4168 | 2020-06-23 04:33:22 | Prince Edward Island, Canada | ||
1510725 | 1510725 | 2020-06-22 | Canada | Quebec | 54730 | 5569 | 23506 | 25655 | 52.9399 | -73.5491 | 2020-06-23 04:33:22 | Quebec, Canada | ||
1510763 | 1510763 | 2020-06-22 | Canada | Saskatchewan | 751 | 13 | 643 | 95 | 52.9399 | -106.4509 | 2020-06-23 04:33:22 | Saskatchewan, Canada | ||
1510868 | 1510868 | 2020-06-22 | Canada | Yukon | 11 | 0 | 11 | 0 | 64.2823 | -135.0 | 2020-06-23 04:33:22 | Yukon, Canada | ||
3249111 | 3249111 | 2020-06-21 | Canada | Alberta | 7704 | 152 | 7018 | 534 | 53.9333 | -116.5765 | 2020-06-22 04:33:20 | Alberta, Canada | ||
3249167 | 3249167 | 2020-06-21 | Canada | British Columbia | 2790 | 168 | 2444 | 178 | 53.7267 | -127.6476 | 2020-06-22 04:33:20 | British Columbia, Canada | ||
3249219 | 3249219 | 2020-06-21 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-06-22 04:33:20 | Diamond Princess, Canada | ||
3249248 | 3249248 | 2020-06-21 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-06-22 04:33:20 | Grand Princess, Canada | ||
3249362 | 3249362 | 2020-06-21 | Canada | Manitoba | 313 | 7 | 293 | 13 | 53.7609 | -98.8139 | 2020-06-22 04:33:20 | Manitoba, Canada | ||
3249401 | 3249401 | 2020-06-21 | Canada | New Brunswick | 164 | 2 | 135 | 27 | 46.5653 | -66.4619 | 2020-06-22 04:33:20 | New Brunswick, Canada | ||
3249404 | 3249404 | 2020-06-21 | Canada | Newfoundland and Labrador | 261 | 3 | 258 | 0 | 53.1355 | -57.6604 | 2020-06-22 04:33:20 | Newfoundland and Labrador, Canada | ||
3249416 | 3249416 | 2020-06-21 | Canada | Northwest Territories | 5 | 0 | 5 | 0 | 64.8255 | -124.8457 | 2020-06-22 04:33:20 | Northwest Territories, Canada | ||
3249417 | 3249417 | 2020-06-21 | Canada | Nova Scotia | 1061 | 62 | 998 | 1 | 44.681999999999995 | -63.7443 | 2020-06-22 04:33:20 | Nova Scotia, Canada | ||
3249418 | 3249418 | 2020-06-21 | Canada | Nunavut | 0 | 0 | 0 | 0 | 70.2998 | -83.1076 | 2020-06-22 04:33:20 | 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]);