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 22
- British Columbia 666
- Ontario 634
- Alberta 625
- Quebec 625
- New Brunswick 623
- Manitoba 621
- Saskatchewan 621
- Newfoundland and Labrador 619
- Prince Edward Island 619
- Nova Scotia 615
- Grand Princess 614
- Northwest Territories 610
- Nunavut 609
- Yukon 608
- Diamond Princess 600
- Repatriated Travellers 365
- Recovered 51
- London, ON 34
- Toronto, ON 34
- Montreal, QC 13
- Calgary, Alberta 3
- Edmonton, Alberta 2
country_or_region 1
- Canada · 9,811 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3069776 | 3069776 | 2021-11-23 | Canada | Alberta | 333004 | 3227 | 0 | 53.9333 | -116.5765 | 2021-11-24 04:22:14 | Alberta, Canada | |||
3069777 | 3069777 | 2021-11-23 | Canada | British Columbia | 216012 | 2304 | 0 | 53.7267 | -127.6476 | 2021-11-24 04:22:14 | British Columbia, Canada | |||
3069778 | 3069778 | 2021-11-23 | Canada | Diamond Princess | 0 | 1 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | |||
3069779 | 3069779 | 2021-11-23 | Canada | Grand Princess | 13 | 0 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | |||
3069780 | 3069780 | 2021-11-23 | Canada | Manitoba | 66952 | 1296 | 0 | 53.7609 | -98.8139 | 2021-11-24 04:22:14 | Manitoba, Canada | |||
3069781 | 3069781 | 2021-11-23 | Canada | New Brunswick | 7806 | 123 | 0 | 46.5653 | -66.4619 | 2021-11-24 04:22:14 | New Brunswick, Canada | |||
3069782 | 3069782 | 2021-11-23 | Canada | Newfoundland and Labrador | 2038 | 17 | 0 | 53.1355 | -57.6604 | 2021-11-24 04:22:14 | Newfoundland and Labrador, 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 | |||
3069784 | 3069784 | 2021-11-23 | Canada | Nova Scotia | 8100 | 107 | 0 | 44.681999999999995 | -63.7443 | 2021-11-24 04:22:14 | Nova Scotia, Canada | |||
3069785 | 3069785 | 2021-11-23 | Canada | Nunavut | 674 | 4 | 0 | 70.2998 | -83.1076 | 2021-11-24 04:22:14 | Nunavut, Canada | |||
3069786 | 3069786 | 2021-11-23 | Canada | Ontario | 618248 | 9974 | 0 | 51.2538 | -85.3232 | 2021-11-24 04:22:14 | Ontario, Canada | |||
3069787 | 3069787 | 2021-11-23 | Canada | Prince Edward Island | 345 | 0 | 0 | 46.5107 | -63.4168 | 2021-11-24 04:22:14 | Prince Edward Island, Canada | |||
3069788 | 3069788 | 2021-11-23 | Canada | Quebec | 440461 | 11565 | 0 | 52.9399 | -73.5491 | 2021-11-24 04:22:14 | Quebec, Canada | |||
3069789 | 3069789 | 2021-11-23 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-11-24 04:22:14 | Repatriated Travellers, Canada | |||||
3069790 | 3069790 | 2021-11-23 | Canada | Saskatchewan | 80481 | 914 | 0 | 52.9399 | -106.4509 | 2021-11-24 04:22:14 | Saskatchewan, Canada | |||
3069791 | 3069791 | 2021-11-23 | Canada | Yukon | 1446 | 12 | 0 | 64.2823 | -135.0 | 2021-11-24 04:22:14 | Yukon, Canada | |||
3748874 | 3748874 | 2021-11-22 | Canada | Alberta | 332751 | 3217 | 0 | 53.9333 | -116.5765 | 2021-11-23 04:22:39 | Alberta, Canada | |||
3748875 | 3748875 | 2021-11-22 | Canada | British Columbia | 215688 | 2303 | 0 | 53.7267 | -127.6476 | 2021-11-23 04:22:39 | British Columbia, Canada | |||
3748876 | 3748876 | 2021-11-22 | Canada | Diamond Princess | 0 | 1 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | |||
3748877 | 3748877 | 2021-11-22 | Canada | Grand Princess | 13 | 0 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | |||
3748878 | 3748878 | 2021-11-22 | Canada | Manitoba | 66826 | 1292 | 0 | 53.7609 | -98.8139 | 2021-11-23 04:22:39 | Manitoba, Canada | |||
3748879 | 3748879 | 2021-11-22 | Canada | New Brunswick | 7731 | 122 | 0 | 46.5653 | -66.4619 | 2021-11-23 04:22:39 | New Brunswick, Canada | |||
3748880 | 3748880 | 2021-11-22 | Canada | Newfoundland and Labrador | 2038 | 17 | 0 | 53.1355 | -57.6604 | 2021-11-23 04:22:39 | Newfoundland and Labrador, 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 | |||
3748882 | 3748882 | 2021-11-22 | Canada | Nova Scotia | 8072 | 107 | 0 | 44.681999999999995 | -63.7443 | 2021-11-23 04:22:39 | Nova Scotia, Canada | |||
3748883 | 3748883 | 2021-11-22 | Canada | Nunavut | 674 | 4 | 0 | 70.2998 | -83.1076 | 2021-11-23 04:22:39 | Nunavut, Canada | |||
3748884 | 3748884 | 2021-11-22 | Canada | Ontario | 617474 | 9968 | 0 | 51.2538 | -85.3232 | 2021-11-23 04:22:39 | Ontario, Canada | |||
3748885 | 3748885 | 2021-11-22 | Canada | Prince Edward Island | 345 | 0 | 0 | 46.5107 | -63.4168 | 2021-11-23 04:22:39 | Prince Edward Island, Canada | |||
3748886 | 3748886 | 2021-11-22 | Canada | Quebec | 439762 | 11560 | 0 | 52.9399 | -73.5491 | 2021-11-23 04:22:39 | Quebec, Canada | |||
3748887 | 3748887 | 2021-11-22 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-11-23 04:22:39 | Repatriated Travellers, Canada | |||||
3748888 | 3748888 | 2021-11-22 | Canada | Saskatchewan | 80413 | 912 | 0 | 52.9399 | -106.4509 | 2021-11-23 04:22:39 | Saskatchewan, Canada | |||
3748889 | 3748889 | 2021-11-22 | Canada | Yukon | 1426 | 12 | 0 | 64.2823 | -135.0 | 2021-11-23 04:22:39 | Yukon, Canada | |||
1014081 | 1014081 | 2021-11-21 | Canada | Alberta | 331626 | 3211 | 0 | 53.9333 | -116.5765 | 2021-11-22 04:22:20 | Alberta, Canada | |||
1014082 | 1014082 | 2021-11-21 | Canada | British Columbia | 214636 | 2293 | 0 | 53.7267 | -127.6476 | 2021-11-22 04:22:20 | British Columbia, Canada | |||
1014083 | 1014083 | 2021-11-21 | Canada | Diamond Princess | 0 | 1 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | |||
1014084 | 1014084 | 2021-11-21 | Canada | Grand Princess | 13 | 0 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | |||
1014085 | 1014085 | 2021-11-21 | Canada | Manitoba | 66378 | 1285 | 0 | 53.7609 | -98.8139 | 2021-11-22 04:22:20 | Manitoba, Canada | |||
1014086 | 1014086 | 2021-11-21 | Canada | New Brunswick | 7669 | 122 | 0 | 46.5653 | -66.4619 | 2021-11-22 04:22:20 | New Brunswick, Canada | |||
1014087 | 1014087 | 2021-11-21 | Canada | Newfoundland and Labrador | 2035 | 17 | 0 | 53.1355 | -57.6604 | 2021-11-22 04:22:20 | Newfoundland and Labrador, 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 | |||
1014089 | 1014089 | 2021-11-21 | Canada | Nova Scotia | 8012 | 106 | 0 | 44.681999999999995 | -63.7443 | 2021-11-22 04:22:20 | Nova Scotia, Canada | |||
1014090 | 1014090 | 2021-11-21 | Canada | Nunavut | 674 | 4 | 0 | 70.2998 | -83.1076 | 2021-11-22 04:22:20 | Nunavut, Canada | |||
1014091 | 1014091 | 2021-11-21 | Canada | Ontario | 616894 | 9967 | 0 | 51.2538 | -85.3232 | 2021-11-22 04:22:20 | Ontario, Canada | |||
1014092 | 1014092 | 2021-11-21 | Canada | Prince Edward Island | 328 | 0 | 0 | 46.5107 | -63.4168 | 2021-11-22 04:22:20 | Prince Edward Island, Canada | |||
1014093 | 1014093 | 2021-11-21 | Canada | Quebec | 439070 | 11558 | 0 | 52.9399 | -73.5491 | 2021-11-22 04:22:20 | Quebec, Canada | |||
1014094 | 1014094 | 2021-11-21 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-11-22 04:22:20 | Repatriated Travellers, Canada | |||||
1014095 | 1014095 | 2021-11-21 | Canada | Saskatchewan | 80340 | 911 | 0 | 52.9399 | -106.4509 | 2021-11-22 04:22:20 | Saskatchewan, Canada | |||
1014096 | 1014096 | 2021-11-21 | Canada | Yukon | 1381 | 12 | 0 | 64.2823 | -135.0 | 2021-11-22 04:22:20 | Yukon, Canada | |||
722245 | 722245 | 2021-11-20 | Canada | Alberta | 331626 | 3211 | 0 | 53.9333 | -116.5765 | 2021-11-21 04:22:13 | Alberta, Canada | |||
722246 | 722246 | 2021-11-20 | Canada | British Columbia | 214636 | 2293 | 0 | 53.7267 | -127.6476 | 2021-11-21 04:22:13 | British Columbia, Canada | |||
722247 | 722247 | 2021-11-20 | Canada | Diamond Princess | 0 | 1 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | |||
722248 | 722248 | 2021-11-20 | Canada | Grand Princess | 13 | 0 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | |||
722249 | 722249 | 2021-11-20 | Canada | Manitoba | 66378 | 1285 | 0 | 53.7609 | -98.8139 | 2021-11-21 04:22:13 | Manitoba, Canada | |||
722250 | 722250 | 2021-11-20 | Canada | New Brunswick | 7579 | 122 | 0 | 46.5653 | -66.4619 | 2021-11-21 04:22:13 | New Brunswick, Canada | |||
722251 | 722251 | 2021-11-20 | Canada | Newfoundland and Labrador | 2035 | 17 | 0 | 53.1355 | -57.6604 | 2021-11-21 04:22:13 | Newfoundland and Labrador, 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 | |||
722253 | 722253 | 2021-11-20 | Canada | Nova Scotia | 8012 | 106 | 0 | 44.681999999999995 | -63.7443 | 2021-11-21 04:22:13 | Nova Scotia, Canada | |||
722254 | 722254 | 2021-11-20 | Canada | Nunavut | 674 | 4 | 0 | 70.2998 | -83.1076 | 2021-11-21 04:22:13 | Nunavut, Canada | |||
722255 | 722255 | 2021-11-20 | Canada | Ontario | 616283 | 9964 | 0 | 51.2538 | -85.3232 | 2021-11-21 04:22:13 | Ontario, Canada | |||
722256 | 722256 | 2021-11-20 | Canada | Prince Edward Island | 328 | 0 | 0 | 46.5107 | -63.4168 | 2021-11-21 04:22:13 | Prince Edward Island, Canada | |||
722257 | 722257 | 2021-11-20 | Canada | Quebec | 438363 | 11555 | 0 | 52.9399 | -73.5491 | 2021-11-21 04:22:13 | Quebec, Canada | |||
722258 | 722258 | 2021-11-20 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-11-21 04:22:13 | Repatriated Travellers, Canada | |||||
722259 | 722259 | 2021-11-20 | Canada | Saskatchewan | 80278 | 910 | 0 | 52.9399 | -106.4509 | 2021-11-21 04:22:13 | Saskatchewan, Canada | |||
722260 | 722260 | 2021-11-20 | Canada | Yukon | 1381 | 12 | 0 | 64.2823 | -135.0 | 2021-11-21 04:22:13 | Yukon, Canada | |||
161775 | 161775 | 2021-11-19 | Canada | Alberta | 331626 | 3211 | 0 | 53.9333 | -116.5765 | 2021-11-20 04:22:17 | Alberta, Canada | |||
161776 | 161776 | 2021-11-19 | Canada | British Columbia | 214636 | 2293 | 0 | 53.7267 | -127.6476 | 2021-11-20 04:22:17 | British Columbia, Canada | |||
161777 | 161777 | 2021-11-19 | Canada | Diamond Princess | 0 | 1 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | |||
161778 | 161778 | 2021-11-19 | Canada | Grand Princess | 13 | 0 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | |||
161779 | 161779 | 2021-11-19 | Canada | Manitoba | 66378 | 1285 | 0 | 53.7609 | -98.8139 | 2021-11-20 04:22:17 | Manitoba, Canada | |||
161780 | 161780 | 2021-11-19 | Canada | New Brunswick | 7512 | 122 | 0 | 46.5653 | -66.4619 | 2021-11-20 04:22:17 | New Brunswick, Canada | |||
161781 | 161781 | 2021-11-19 | Canada | Newfoundland and Labrador | 2035 | 17 | 0 | 53.1355 | -57.6604 | 2021-11-20 04:22:17 | Newfoundland and Labrador, 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 | |||
161783 | 161783 | 2021-11-19 | Canada | Nova Scotia | 8012 | 106 | 0 | 44.681999999999995 | -63.7443 | 2021-11-20 04:22:17 | Nova Scotia, Canada | |||
161784 | 161784 | 2021-11-19 | Canada | Nunavut | 674 | 4 | 0 | 70.2998 | -83.1076 | 2021-11-20 04:22:17 | Nunavut, Canada | |||
161785 | 161785 | 2021-11-19 | Canada | Ontario | 615556 | 9959 | 0 | 51.2538 | -85.3232 | 2021-11-20 04:22:17 | Ontario, Canada | |||
161786 | 161786 | 2021-11-19 | Canada | Prince Edward Island | 328 | 0 | 0 | 46.5107 | -63.4168 | 2021-11-20 04:22:17 | Prince Edward Island, Canada | |||
161787 | 161787 | 2021-11-19 | Canada | Quebec | 437548 | 11552 | 0 | 52.9399 | -73.5491 | 2021-11-20 04:22:17 | Quebec, Canada | |||
161788 | 161788 | 2021-11-19 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-11-20 04:22:17 | Repatriated Travellers, Canada | |||||
161789 | 161789 | 2021-11-19 | Canada | Saskatchewan | 80025 | 908 | 0 | 52.9399 | -106.4509 | 2021-11-20 04:22:17 | Saskatchewan, Canada | |||
161790 | 161790 | 2021-11-19 | Canada | Yukon | 1381 | 12 | 0 | 64.2823 | -135.0 | 2021-11-20 04:22:17 | Yukon, Canada | |||
3288662 | 3288662 | 2021-11-18 | Canada | Alberta | 331214 | 3209 | 0 | 53.9333 | -116.5765 | 2021-11-19 04:21:40 | Alberta, Canada | |||
3288663 | 3288663 | 2021-11-18 | Canada | British Columbia | 214150 | 2290 | 0 | 53.7267 | -127.6476 | 2021-11-19 04:21:40 | British Columbia, Canada | |||
3288664 | 3288664 | 2021-11-18 | Canada | Diamond Princess | 0 | 1 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | |||
3288665 | 3288665 | 2021-11-18 | Canada | Grand Princess | 13 | 0 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | |||
3288666 | 3288666 | 2021-11-18 | Canada | Manitoba | 66184 | 1281 | 0 | 53.7609 | -98.8139 | 2021-11-19 04:21:40 | Manitoba, Canada | |||
3288667 | 3288667 | 2021-11-18 | Canada | New Brunswick | 7422 | 122 | 0 | 46.5653 | -66.4619 | 2021-11-19 04:21:40 | New Brunswick, Canada | |||
3288668 | 3288668 | 2021-11-18 | Canada | Newfoundland and Labrador | 2031 | 17 | 0 | 53.1355 | -57.6604 | 2021-11-19 04:21:40 | Newfoundland and Labrador, 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 | |||
3288670 | 3288670 | 2021-11-18 | Canada | Nova Scotia | 7985 | 105 | 0 | 44.681999999999995 | -63.7443 | 2021-11-19 04:21:40 | Nova Scotia, Canada | |||
3288671 | 3288671 | 2021-11-18 | Canada | Nunavut | 674 | 4 | 0 | 70.2998 | -83.1076 | 2021-11-19 04:21:40 | Nunavut, Canada | |||
3288672 | 3288672 | 2021-11-18 | Canada | Ontario | 614880 | 9955 | 0 | 51.2538 | -85.3232 | 2021-11-19 04:21:40 | Ontario, Canada | |||
3288673 | 3288673 | 2021-11-18 | Canada | Prince Edward Island | 328 | 0 | 0 | 46.5107 | -63.4168 | 2021-11-19 04:21:40 | Prince Edward Island, Canada | |||
3288674 | 3288674 | 2021-11-18 | Canada | Quebec | 436803 | 11550 | 0 | 52.9399 | -73.5491 | 2021-11-19 04:21:40 | Quebec, Canada | |||
3288675 | 3288675 | 2021-11-18 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-11-19 04:21:40 | Repatriated Travellers, Canada | |||||
3288676 | 3288676 | 2021-11-18 | Canada | Saskatchewan | 79936 | 905 | 0 | 52.9399 | -106.4509 | 2021-11-19 04:21:40 | Saskatchewan, Canada | |||
3288677 | 3288677 | 2021-11-18 | Canada | Yukon | 1349 | 12 | 0 | 64.2823 | -135.0 | 2021-11-19 04:21:40 | Yukon, Canada | |||
447118 | 447118 | 2021-11-17 | Canada | Alberta | 330831 | 3204 | 0 | 53.9333 | -116.5765 | 2021-11-18 04:21:33 | Alberta, Canada | |||
447119 | 447119 | 2021-11-17 | Canada | British Columbia | 213682 | 2281 | 0 | 53.7267 | -127.6476 | 2021-11-18 04:21:33 | British Columbia, Canada | |||
447120 | 447120 | 2021-11-17 | Canada | Diamond Princess | 0 | 1 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | |||
447121 | 447121 | 2021-11-17 | Canada | Grand Princess | 13 | 0 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, 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]);