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 last_update descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: last_update (date)
day (date) >30 ✖
- 2020-03-26 16
- 2020-03-27 16
- 2020-03-28 16
- 2020-03-29 16
- 2020-03-30 16
- 2020-03-31 16
- 2020-04-01 16
- 2020-04-02 16
- 2020-04-03 16
- 2020-04-04 16
- 2020-04-05 16
- 2020-04-06 16
- 2020-04-07 16
- 2020-04-08 16
- 2020-04-09 16
- 2020-04-10 16
- 2020-04-11 16
- 2020-04-27 16
- 2020-04-28 16
- 2020-04-29 16
- 2020-04-30 16
- 2020-05-01 16
- 2020-05-02 16
- 2020-05-03 16
- 2020-05-04 16
- 2020-05-05 16
- 2020-05-06 16
- 2020-05-07 16
- 2020-05-08 16
- 2020-05-09 16
- …
province_or_state 22
- British Columbia 1,067
- Ontario 1,035
- Alberta 1,026
- Quebec 1,026
- New Brunswick 1,024
- Manitoba 1,022
- Saskatchewan 1,022
- Newfoundland and Labrador 1,020
- Prince Edward Island 1,020
- Nova Scotia 1,016
- Grand Princess 1,015
- Northwest Territories 1,011
- Nunavut 1,010
- Yukon 1,009
- Diamond Princess 1,001
- Repatriated Travellers 766
- Recovered 51
- London, ON 34
- Toronto, ON 34
- Montreal, QC 13
- Calgary, Alberta 3
- Edmonton, Alberta 2
country_or_region 1
- Canada · 16,227 ✖
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update ▲ | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3627320 | 3627320 | 2020-04-06 | Canada | Alberta | 1250 | 23 | 0 | 1227 | 53.9333 | -116.5765 | 4/6/20 23:28 | Alberta, Canada | ||
3627328 | 3627328 | 2020-04-06 | Canada | British Columbia | 1266 | 38 | 0 | 1228 | 53.7267 | -127.6476 | 4/6/20 23:28 | British Columbia, Canada | ||
3627334 | 3627334 | 2020-04-06 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 4/6/20 23:28 | Diamond Princess, Canada | ||
3627343 | 3627343 | 2020-04-06 | Canada | Grand Princess | 13 | 0 | 0 | 13 | 37.6489 | 0.0 | 4/6/20 23:28 | Grand Princess, Canada | ||
3627365 | 3627365 | 2020-04-06 | Canada | Manitoba | 203 | 2 | 0 | 201 | 53.7609 | -98.8139 | 4/6/20 23:28 | Manitoba, Canada | ||
3627369 | 3627369 | 2020-04-06 | Canada | New Brunswick | 103 | 0 | 0 | 103 | 46.5653 | -66.4619 | 4/6/20 23:28 | New Brunswick, Canada | ||
3627372 | 3627372 | 2020-04-06 | Canada | Newfoundland and Labrador | 226 | 2 | 0 | 225 | 53.1355 | -57.6604 | 4/6/20 23:28 | Newfoundland and Labrador, Canada | ||
3627376 | 3627376 | 2020-04-06 | Canada | Northwest Territories | 5 | 0 | 0 | 5 | 64.8255 | -124.8457 | 4/6/20 23:28 | ,Northwest Territories,Canada | ||
3627377 | 3627377 | 2020-04-06 | Canada | Nova Scotia | 293 | 0 | 0 | 293 | 44.682 | -63.7443 | 4/6/20 23:28 | Nova Scotia, Canada | ||
3627378 | 3627378 | 2020-04-06 | Canada | Nunavut | 0 | 0 | 0 | 0 | 70.2998 | -83.1076 | 4/6/20 23:28 | Nunavut, Canada | ||
3627379 | 3627379 | 2020-04-06 | Canada | Ontario | 5922 | 132 | 0 | 4197 | 51.2538 | -85.3232 | 4/6/20 23:28 | Ontario, Canada | ||
3627380 | 3627380 | 2020-04-06 | Canada | Prince Edward Island | 22 | 0 | 0 | 22 | 46.5107 | -63.4168 | 4/6/20 23:28 | Prince Edward Island, Canada | ||
3627383 | 3627383 | 2020-04-06 | Canada | Quebec | 9538 | 302 | 0 | 9236 | 52.9399 | -73.5491 | 4/6/20 23:28 | Quebec, Canada | ||
3627385 | 3627385 | 2020-04-06 | Canada | Recovered | 0 | 0 | 3256 | 0 | 0.0 | 0.0 | 4/6/20 23:28 | Recovered, Canada | ||
3627391 | 3627391 | 2020-04-06 | Canada | Saskatchewan | 253 | 3 | 0 | 246 | 52.9399 | -106.4509 | 4/6/20 23:28 | Saskatchewan, Canada | ||
3627408 | 3627408 | 2020-04-06 | Canada | Yukon | 6 | 0 | 0 | 6 | 64.2823 | -135.0 | 4/6/20 23:28 | ,Yukon,Canada | ||
1750652 | 1750652 | 2020-04-04 | Canada | Alberta | 1075 | 18 | 0 | 1057 | 53.9333 | -116.5765 | 4/4/20 23:40 | Alberta, Canada | ||
1750660 | 1750660 | 2020-04-04 | Canada | British Columbia | 1203 | 38 | 0 | 1165 | 53.7267 | -127.6476 | 4/4/20 23:40 | British Columbia, Canada | ||
1750666 | 1750666 | 2020-04-04 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 4/4/20 23:40 | Diamond Princess, Canada | ||
1750675 | 1750675 | 2020-04-04 | Canada | Grand Princess | 13 | 0 | 0 | 13 | 37.6489 | 0.0 | 4/4/20 23:40 | Grand Princess, Canada | ||
1750697 | 1750697 | 2020-04-04 | Canada | Manitoba | 182 | 2 | 0 | 180 | 53.7609 | -98.8139 | 4/4/20 23:40 | Manitoba, Canada | ||
1750701 | 1750701 | 2020-04-04 | Canada | New Brunswick | 91 | 0 | 0 | 91 | 46.5653 | -66.4619 | 4/4/20 23:40 | New Brunswick, Canada | ||
1750704 | 1750704 | 2020-04-04 | Canada | Newfoundland and Labrador | 195 | 1 | 0 | 194 | 53.1355 | -57.6604 | 4/4/20 23:40 | Newfoundland and Labrador, Canada | ||
1750708 | 1750708 | 2020-04-04 | Canada | Northwest Territories | 4 | 0 | 0 | 4 | 64.8255 | -124.8457 | 4/4/20 23:40 | ,Northwest Territories,Canada | ||
1750709 | 1750709 | 2020-04-04 | Canada | Nova Scotia | 236 | 0 | 0 | 236 | 44.682 | -63.7443 | 4/4/20 23:40 | Nova Scotia, Canada | ||
1750710 | 1750710 | 2020-04-04 | Canada | Nunavut | 0 | 0 | 0 | 0 | 70.2998 | -83.1076 | 4/4/20 23:40 | Nunavut, Canada | ||
1750711 | 1750711 | 2020-04-04 | Canada | Ontario | 5123 | 94 | 0 | 3536 | 51.2538 | -85.3232 | 4/4/20 23:40 | Ontario, Canada | ||
1750712 | 1750712 | 2020-04-04 | Canada | Prince Edward Island | 22 | 0 | 0 | 22 | 46.5107 | -63.4168 | 4/4/20 23:40 | Prince Edward Island, Canada | ||
1750715 | 1750715 | 2020-04-04 | Canada | Quebec | 8029 | 203 | 0 | 7826 | 52.9399 | -73.5491 | 4/4/20 23:40 | Quebec, Canada | ||
1750717 | 1750717 | 2020-04-04 | Canada | Recovered | 0 | 0 | 2577 | 0 | 0.0 | 0.0 | 4/4/20 23:40 | Recovered, Canada | ||
1750722 | 1750722 | 2020-04-04 | Canada | Saskatchewan | 231 | 3 | 0 | 217 | 52.9399 | -106.4509 | 4/4/20 23:40 | Saskatchewan, Canada | ||
1750739 | 1750739 | 2020-04-04 | Canada | Yukon | 6 | 0 | 0 | 6 | 64.2823 | -135.0 | 4/4/20 23:40 | ,Yukon,Canada | ||
3701494 | 3701494 | 2020-04-02 | Canada | Alberta | 969 | 13 | 0 | 956 | 53.9333 | -116.5765 | 4/2/20 23:31 | Alberta, Canada | ||
3701502 | 3701502 | 2020-04-02 | Canada | British Columbia | 1121 | 31 | 0 | 1090 | 53.7267 | -127.6476 | 4/2/20 23:31 | British Columbia, Canada | ||
3701508 | 3701508 | 2020-04-02 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 4/2/20 23:31 | Diamond Princess, Canada | ||
3701516 | 3701516 | 2020-04-02 | Canada | Grand Princess | 13 | 0 | 0 | 13 | 37.6489 | 0.0 | 4/2/20 23:31 | Grand Princess, Canada | ||
3701538 | 3701538 | 2020-04-02 | Canada | Manitoba | 167 | 1 | 0 | 166 | 53.7609 | -98.8139 | 4/2/20 23:31 | Manitoba, Canada | ||
3701542 | 3701542 | 2020-04-02 | Canada | New Brunswick | 91 | 0 | 0 | 91 | 46.5653 | -66.4619 | 4/2/20 23:31 | New Brunswick, Canada | ||
3701545 | 3701545 | 2020-04-02 | Canada | Newfoundland and Labrador | 183 | 1 | 0 | 182 | 53.1355 | -57.6604 | 4/2/20 23:31 | Newfoundland and Labrador, Canada | ||
3701549 | 3701549 | 2020-04-02 | Canada | Northwest Territories | 2 | 0 | 0 | 2 | 64.8255 | -124.8457 | 4/2/20 23:31 | ,Northwest Territories,Canada | ||
3701550 | 3701550 | 2020-04-02 | Canada | Nova Scotia | 193 | 0 | 0 | 193 | 44.682 | -63.7443 | 4/2/20 23:31 | Nova Scotia, Canada | ||
3701551 | 3701551 | 2020-04-02 | Canada | Nunavut | 0 | 0 | 0 | 0 | 70.2998 | -83.1076 | 4/2/20 23:31 | Nunavut, Canada | ||
3701552 | 3701552 | 2020-04-02 | Canada | Ontario | 4316 | 53 | 0 | 2740 | 51.2538 | -85.3232 | 4/2/20 23:31 | Ontario, Canada | ||
3701553 | 3701553 | 2020-04-02 | Canada | Prince Edward Island | 22 | 0 | 0 | 22 | 46.5107 | -63.4168 | 4/2/20 23:31 | Prince Edward Island, Canada | ||
3701556 | 3701556 | 2020-04-02 | Canada | Quebec | 6453 | 121 | 0 | 6332 | 52.9399 | -73.5491 | 4/2/20 23:31 | Quebec, Canada | ||
3701558 | 3701558 | 2020-04-02 | Canada | Recovered | 0 | 0 | 1735 | 0 | 0.0 | 0.0 | 4/2/20 23:31 | Recovered, Canada | ||
3701563 | 3701563 | 2020-04-02 | Canada | Saskatchewan | 206 | 3 | 0 | 203 | 52.9399 | -106.4509 | 4/2/20 23:31 | Saskatchewan, Canada | ||
3701580 | 3701580 | 2020-04-02 | Canada | Yukon | 6 | 0 | 0 | 6 | 64.2823 | -135.0 | 4/2/20 23:31 | ,Yukon,Canada | ||
1872343 | 1872343 | 2020-03-30 | Canada | Alberta | 661 | 3 | 0 | 658 | 53.9333 | -116.5765 | 3/30/20 22:58 | Alberta, Canada | ||
1872351 | 1872351 | 2020-03-30 | Canada | British Columbia | 970 | 19 | 0 | 951 | 53.7267 | -127.6476 | 3/30/20 22:58 | British Columbia, Canada | ||
1872357 | 1872357 | 2020-03-30 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 3/30/20 22:58 | Diamond Princess, Canada | ||
1872365 | 1872365 | 2020-03-30 | Canada | Grand Princess | 13 | 0 | 0 | 13 | 0.0 | 0.0 | 3/30/20 22:58 | Grand Princess, Canada | ||
1872387 | 1872387 | 2020-03-30 | Canada | Manitoba | 96 | 1 | 0 | 95 | 53.7609 | -98.8139 | 3/30/20 22:58 | Manitoba, Canada | ||
1872391 | 1872391 | 2020-03-30 | Canada | New Brunswick | 68 | 0 | 0 | 68 | 46.5653 | -66.4619 | 3/30/20 22:58 | New Brunswick, Canada | ||
1872394 | 1872394 | 2020-03-30 | Canada | Newfoundland and Labrador | 148 | 1 | 0 | 147 | 53.1355 | -57.6604 | 3/30/20 22:58 | Newfoundland and Labrador, Canada | ||
1872398 | 1872398 | 2020-03-30 | Canada | Northwest Territories | 1 | 0 | 0 | 1 | 64.8255 | -124.8457 | 3/30/20 22:58 | ,Northwest Territories,Canada | ||
1872399 | 1872399 | 2020-03-30 | Canada | Nova Scotia | 127 | 0 | 0 | 127 | 44.682 | -63.7443 | 3/30/20 22:58 | Nova Scotia, Canada | ||
1872400 | 1872400 | 2020-03-30 | Canada | Nunavut | 0 | 0 | 0 | 0 | 70.2998 | -83.1076 | 3/30/20 22:58 | Nunavut, Canada | ||
1872401 | 1872401 | 2020-03-30 | Canada | Ontario | 3044 | 23 | 0 | 1675 | 51.2538 | -85.3232 | 3/30/20 22:58 | Ontario, Canada | ||
1872402 | 1872402 | 2020-03-30 | Canada | Prince Edward Island | 18 | 0 | 0 | 18 | 46.5107 | -63.4168 | 3/30/20 22:58 | Prince Edward Island, Canada | ||
1872405 | 1872405 | 2020-03-30 | Canada | Quebec | 4153 | 67 | 0 | 4086 | 52.9399 | -73.5491 | 3/30/20 22:58 | Quebec, Canada | ||
1872407 | 1872407 | 2020-03-30 | Canada | Recovered | 0 | 0 | 466 | 0 | 0.0 | 0.0 | 3/30/20 22:58 | Recovered, Canada | ||
1872412 | 1872412 | 2020-03-30 | Canada | Saskatchewan | 175 | 2 | 0 | 154 | 52.9399 | -106.4509 | 3/30/20 22:58 | Saskatchewan, Canada | ||
1872429 | 1872429 | 2020-03-30 | Canada | Yukon | 4 | 0 | 0 | 4 | 64.2823 | -135.0 | 3/30/20 22:58 | ,Yukon,Canada | ||
2875580 | 2875580 | 2020-03-29 | Canada | Alberta | 621 | 2 | 0 | 619 | 53.9333 | -116.5765 | 3/29/20 23:13 | Alberta, Canada | ||
2875588 | 2875588 | 2020-03-29 | Canada | British Columbia | 884 | 17 | 0 | 867 | 53.7267 | -127.6476 | 3/29/20 23:13 | British Columbia, Canada | ||
2875594 | 2875594 | 2020-03-29 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 3/29/20 23:13 | Diamond Princess, Canada | ||
2875602 | 2875602 | 2020-03-29 | Canada | Grand Princess | 13 | 0 | 0 | 13 | 0.0 | 0.0 | 3/29/20 23:13 | Grand Princess, Canada | ||
2875624 | 2875624 | 2020-03-29 | Canada | Manitoba | 72 | 1 | 0 | 71 | 53.7609 | -98.8139 | 3/29/20 23:13 | Manitoba, Canada | ||
2875628 | 2875628 | 2020-03-29 | Canada | New Brunswick | 66 | 0 | 0 | 66 | 46.5653 | -66.4619 | 3/29/20 23:13 | New Brunswick, Canada | ||
2875631 | 2875631 | 2020-03-29 | Canada | Newfoundland and Labrador | 135 | 0 | 0 | 135 | 53.1355 | -57.6604 | 3/29/20 23:13 | Newfoundland and Labrador, Canada | ||
2875635 | 2875635 | 2020-03-29 | Canada | Northwest Territories | 1 | 0 | 0 | 1 | 64.8255 | -124.8457 | 3/29/20 23:13 | ,Northwest Territories,Canada | ||
2875636 | 2875636 | 2020-03-29 | Canada | Nova Scotia | 122 | 0 | 0 | 122 | 44.682 | -63.7443 | 3/29/20 23:13 | Nova Scotia, Canada | ||
2875637 | 2875637 | 2020-03-29 | Canada | Nunavut | 0 | 0 | 0 | 0 | 70.2998 | -83.1076 | 3/29/20 23:13 | Nunavut, Canada | ||
2875638 | 2875638 | 2020-03-29 | Canada | Ontario | 2608 | 23 | 0 | 1334 | 51.2538 | -85.3232 | 3/29/20 23:13 | Ontario, Canada | ||
2875639 | 2875639 | 2020-03-29 | Canada | Prince Edward Island | 11 | 0 | 0 | 11 | 46.5107 | -63.4168 | 3/29/20 23:13 | Prince Edward Island, Canada | ||
2875642 | 2875642 | 2020-03-29 | Canada | Quebec | 3575 | 54 | 0 | 3521 | 52.9399 | -73.5491 | 3/29/20 23:13 | Quebec, Canada | ||
2875644 | 2875644 | 2020-03-29 | Canada | Recovered | 0 | 0 | 466 | 0 | 0.0 | 0.0 | 3/29/20 23:13 | Recovered, Canada | ||
2875649 | 2875649 | 2020-03-29 | Canada | Saskatchewan | 134 | 0 | 0 | 156 | 52.9399 | -106.4509 | 3/29/20 23:13 | Saskatchewan, Canada | ||
2875666 | 2875666 | 2020-03-29 | Canada | Yukon | 4 | 0 | 0 | 4 | 64.2823 | -135.0 | 3/29/20 23:13 | ,Yukon,Canada | ||
3946916 | 3946916 | 2020-03-28 | Canada | Alberta | 542 | 2 | 0 | 540 | 53.9333 | -116.5765 | 3/28/20 23:10 | Alberta, Canada | ||
3946924 | 3946924 | 2020-03-28 | Canada | British Columbia | 884 | 17 | 0 | 867 | 53.7267 | -127.6476 | 3/28/20 23:10 | British Columbia, Canada | ||
3946930 | 3946930 | 2020-03-28 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 3/28/20 23:10 | Diamond Princess, Canada | ||
3946938 | 3946938 | 2020-03-28 | Canada | Grand Princess | 13 | 0 | 0 | 13 | 0.0 | 0.0 | 3/28/20 23:10 | Grand Princess, Canada | ||
3946960 | 3946960 | 2020-03-28 | Canada | Manitoba | 64 | 1 | 0 | 63 | 53.7609 | -98.8139 | 3/28/20 23:10 | Manitoba, Canada | ||
3946964 | 3946964 | 2020-03-28 | Canada | New Brunswick | 51 | 0 | 0 | 51 | 46.5653 | -66.4619 | 3/28/20 23:10 | New Brunswick, Canada | ||
3946967 | 3946967 | 2020-03-28 | Canada | Newfoundland and Labrador | 120 | 0 | 0 | 120 | 53.1355 | -57.6604 | 3/28/20 23:10 | Newfoundland and Labrador, Canada | ||
3946971 | 3946971 | 2020-03-28 | Canada | Northwest Territories | 1 | 0 | 0 | 1 | 64.8255 | -124.8457 | 3/28/20 23:10 | ,Northwest Territories,Canada | ||
3946972 | 3946972 | 2020-03-28 | Canada | Nova Scotia | 110 | 0 | 0 | 110 | 44.682 | -63.7443 | 3/28/20 23:10 | Nova Scotia, Canada | ||
3946973 | 3946973 | 2020-03-28 | Canada | Nunavut | 0 | 0 | 0 | 0 | 70.2998 | -83.1076 | 3/28/20 23:10 | Nunavut, Canada | ||
3946974 | 3946974 | 2020-03-28 | Canada | Ontario | 2369 | 19 | 0 | 1126 | 51.2538 | -85.3232 | 3/28/20 23:10 | Ontario, Canada | ||
3946975 | 3946975 | 2020-03-28 | Canada | Prince Edward Island | 11 | 0 | 0 | 11 | 46.5107 | -63.4168 | 3/28/20 23:10 | Prince Edward Island, Canada | ||
3946978 | 3946978 | 2020-03-28 | Canada | Quebec | 3007 | 43 | 0 | 2964 | 52.9399 | -73.5491 | 3/28/20 23:10 | Quebec, Canada | ||
3946980 | 3946980 | 2020-03-28 | Canada | Recovered | 0 | 0 | 466 | 0 | 0.0 | 0.0 | 3/28/20 23:10 | Recovered, Canada | ||
3946985 | 3946985 | 2020-03-28 | Canada | Saskatchewan | 134 | 0 | 0 | 134 | 52.9399 | -106.4509 | 3/28/20 23:10 | Saskatchewan, Canada | ||
3947002 | 3947002 | 2020-03-28 | Canada | Yukon | 4 | 0 | 0 | 4 | 64.2823 | -135.0 | 3/28/20 23:10 | ,Yukon,Canada | ||
2910579 | 2910579 | 2020-03-22 | Canada | Ontario | 1031 | 5 | 0 | 420 | 51.2538 | -85.3232 | 3/22/20 23:48 | Ontario, Canada | ||
2910580 | 2910580 | 2020-03-22 | Canada | British Columbia | 424 | 10 | 0 | 414 | 53.7267 | -127.6476 | 3/22/20 23:48 | British Columbia, Canada | ||
2910581 | 2910581 | 2020-03-22 | Canada | Alberta | 259 | 1 | 0 | 258 | 53.9333 | -116.5765 | 3/22/20 23:48 | Alberta, Canada | ||
2910582 | 2910582 | 2020-03-22 | Canada | Quebec | 795 | 5 | 0 | 790 | 52.9399 | -73.5491 | 3/22/20 23:48 | Quebec, 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]);