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 355
- Ontario 323
- Alberta 314
- Quebec 314
- New Brunswick 312
- Manitoba 310
- Saskatchewan 310
- Newfoundland and Labrador 308
- Prince Edward Island 308
- Nova Scotia 304
- Grand Princess 303
- Northwest Territories 299
- Nunavut 298
- Yukon 297
- Diamond Princess 289
- Repatriated Travellers 54
- Recovered 51
- London, ON 34
- Toronto, ON 34
- Montreal, QC 13
- Calgary, Alberta 3
- Edmonton, Alberta 2
country_or_region 1
- Canada · 4,835 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3101205 | 3101205 | 2021-01-16 | Canada | Alberta | 116087 | 1417 | 101957 | 12713 | 53.9333 | -116.5765 | 2021-01-17 05:22:17 | Alberta, Canada | ||
3101206 | 3101206 | 2021-01-16 | Canada | British Columbia | 60117 | 1047 | 53115 | 5955 | 53.7267 | -127.6476 | 2021-01-17 05:22:17 | British Columbia, Canada | ||
3101207 | 3101207 | 2021-01-16 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
3101208 | 3101208 | 2021-01-16 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | ||
3101209 | 3101209 | 2021-01-16 | Canada | Manitoba | 27322 | 761 | 23575 | 2986 | 53.7609 | -98.8139 | 2021-01-17 05:22:17 | Manitoba, 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 | ||
3101211 | 3101211 | 2021-01-16 | Canada | Newfoundland and Labrador | 395 | 4 | 383 | 8 | 53.1355 | -57.6604 | 2021-01-17 05:22:17 | Newfoundland and Labrador, Canada | ||
3101212 | 3101212 | 2021-01-16 | Canada | Northwest Territories | 25 | 0 | 24 | 1 | 64.8255 | -124.8457 | 2021-01-17 05:22:17 | Northwest Territories,Canada | ||
3101213 | 3101213 | 2021-01-16 | Canada | Nova Scotia | 1554 | 65 | 1459 | 30 | 44.682 | -63.7443 | 2021-01-17 05:22:17 | Nova Scotia, Canada | ||
3101214 | 3101214 | 2021-01-16 | Canada | Nunavut | 266 | 1 | 265 | 0 | 70.2998 | -83.1076 | 2021-01-17 05:22:17 | Nunavut, Canada | ||
3101215 | 3101215 | 2021-01-16 | Canada | Ontario | 241478 | 5340 | 207001 | 26704 | 51.2538 | -85.3232 | 2021-01-17 05:22:17 | Ontario, Canada | ||
3101216 | 3101216 | 2021-01-16 | Canada | Prince Edward Island | 103 | 0 | 95 | 8 | 46.5107 | -63.4168 | 2021-01-17 05:22:17 | Prince Edward Island, Canada | ||
3101217 | 3101217 | 2021-01-16 | Canada | Quebec | 242336 | 9096 | 210364 | 22876 | 52.9399 | -73.5491 | 2021-01-17 05:22:17 | Quebec, Canada | ||
3101218 | 3101218 | 2021-01-16 | Canada | Repatriated Travellers | 13 | 0 | 13 | 0 | 2021-01-17 05:22:17 | Repatriated Travellers, Canada | ||||
3101219 | 3101219 | 2021-01-16 | Canada | Saskatchewan | 19985 | 212 | 15730 | 4043 | 52.9399 | -106.4509 | 2021-01-17 05:22:17 | Saskatchewan, Canada | ||
3101220 | 3101220 | 2021-01-16 | Canada | Yukon | 70 | 1 | 67 | 2 | 64.2823 | -135.0 | 2021-01-17 05:22:17 | Yukon, Canada | ||
3515167 | 3515167 | 2021-01-15 | Canada | Alberta | 115370 | 1402 | 101779 | 12189 | 53.9333 | -116.5765 | 2021-01-16 05:22:40 | Alberta, Canada | ||
3515168 | 3515168 | 2021-01-15 | Canada | British Columbia | 60117 | 1047 | 53115 | 5955 | 53.7267 | -127.6476 | 2021-01-16 05:22:40 | British Columbia, Canada | ||
3515169 | 3515169 | 2021-01-15 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
3515170 | 3515170 | 2021-01-15 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | ||
3515171 | 3515171 | 2021-01-15 | Canada | Manitoba | 27145 | 760 | 23478 | 2907 | 53.7609 | -98.8139 | 2021-01-16 05:22:40 | Manitoba, 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 | ||
3515173 | 3515173 | 2021-01-15 | Canada | Newfoundland and Labrador | 395 | 4 | 383 | 8 | 53.1355 | -57.6604 | 2021-01-16 05:22:40 | Newfoundland and Labrador, Canada | ||
3515174 | 3515174 | 2021-01-15 | Canada | Northwest Territories | 25 | 0 | 24 | 1 | 64.8255 | -124.8457 | 2021-01-16 05:22:40 | Northwest Territories,Canada | ||
3515175 | 3515175 | 2021-01-15 | Canada | Nova Scotia | 1550 | 65 | 1453 | 32 | 44.682 | -63.7443 | 2021-01-16 05:22:40 | Nova Scotia, Canada | ||
3515176 | 3515176 | 2021-01-15 | Canada | Nunavut | 266 | 1 | 265 | 0 | 70.2998 | -83.1076 | 2021-01-16 05:22:40 | Nunavut, Canada | ||
3515177 | 3515177 | 2021-01-15 | Canada | Ontario | 238798 | 5289 | 203593 | 27232 | 51.2538 | -85.3232 | 2021-01-16 05:22:40 | Ontario, Canada | ||
3515178 | 3515178 | 2021-01-15 | Canada | Prince Edward Island | 103 | 0 | 95 | 8 | 46.5107 | -63.4168 | 2021-01-16 05:22:40 | Prince Edward Island, Canada | ||
3515179 | 3515179 | 2021-01-15 | Canada | Quebec | 240410 | 9051 | 207934 | 23425 | 52.9399 | -73.5491 | 2021-01-16 05:22:40 | Quebec, Canada | ||
3515180 | 3515180 | 2021-01-15 | Canada | Repatriated Travellers | 13 | 0 | 13 | 0 | 2021-01-16 05:22:40 | Repatriated Travellers, Canada | ||||
3515181 | 3515181 | 2021-01-15 | Canada | Saskatchewan | 19715 | 210 | 15495 | 4010 | 52.9399 | -106.4509 | 2021-01-16 05:22:40 | Saskatchewan, Canada | ||
3515182 | 3515182 | 2021-01-15 | Canada | Yukon | 70 | 1 | 67 | 2 | 64.2823 | -135.0 | 2021-01-16 05:22:40 | Yukon, Canada | ||
3879340 | 3879340 | 2021-01-14 | Canada | Alberta | 114585 | 1389 | 100762 | 12434 | 53.9333 | -116.5765 | 2021-01-15 05:22:24 | Alberta, Canada | ||
3879341 | 3879341 | 2021-01-14 | Canada | British Columbia | 59608 | 1038 | 52605 | 5965 | 53.7267 | -127.6476 | 2021-01-15 05:22:24 | British Columbia, Canada | ||
3879342 | 3879342 | 2021-01-14 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
3879343 | 3879343 | 2021-01-14 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | ||
3879344 | 3879344 | 2021-01-14 | Canada | Manitoba | 26954 | 755 | 23313 | 2886 | 53.7609 | -98.8139 | 2021-01-15 05:22:24 | Manitoba, 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 | ||
3879346 | 3879346 | 2021-01-14 | Canada | Newfoundland and Labrador | 394 | 4 | 383 | 7 | 53.1355 | -57.6604 | 2021-01-15 05:22:24 | Newfoundland and Labrador, Canada | ||
3879347 | 3879347 | 2021-01-14 | Canada | Northwest Territories | 24 | 0 | 24 | 0 | 64.8255 | -124.8457 | 2021-01-15 05:22:24 | Northwest Territories,Canada | ||
3879348 | 3879348 | 2021-01-14 | Canada | Nova Scotia | 1548 | 65 | 1451 | 32 | 44.682 | -63.7443 | 2021-01-15 05:22:24 | Nova Scotia, Canada | ||
3879349 | 3879349 | 2021-01-14 | Canada | Nunavut | 266 | 1 | 265 | 0 | 70.2998 | -83.1076 | 2021-01-15 05:22:24 | Nunavut, Canada | ||
3879350 | 3879350 | 2021-01-14 | Canada | Ontario | 235627 | 5189 | 200157 | 27699 | 51.2538 | -85.3232 | 2021-01-15 05:22:24 | Ontario, Canada | ||
3879351 | 3879351 | 2021-01-14 | Canada | Prince Edward Island | 103 | 0 | 95 | 8 | 46.5107 | -63.4168 | 2021-01-15 05:22:24 | Prince Edward Island, Canada | ||
3879352 | 3879352 | 2021-01-14 | Canada | Quebec | 238528 | 9005 | 204741 | 24782 | 52.9399 | -73.5491 | 2021-01-15 05:22:24 | Quebec, Canada | ||
3879353 | 3879353 | 2021-01-14 | Canada | Repatriated Travellers | 13 | 0 | 13 | 0 | 2021-01-15 05:22:24 | Repatriated Travellers, Canada | ||||
3879354 | 3879354 | 2021-01-14 | Canada | Saskatchewan | 19333 | 206 | 15264 | 3859 | 52.9399 | -106.4509 | 2021-01-15 05:22:24 | Saskatchewan, Canada | ||
3879355 | 3879355 | 2021-01-14 | Canada | Yukon | 70 | 1 | 67 | 2 | 64.2823 | -135.0 | 2021-01-15 05:22:24 | Yukon, Canada | ||
3307967 | 3307967 | 2021-01-13 | Canada | Alberta | 113618 | 1368 | 99412 | 12838 | 53.9333 | -116.5765 | 2021-01-14 05:22:32 | Alberta, Canada | ||
3307968 | 3307968 | 2021-01-13 | Canada | British Columbia | 59072 | 1031 | 51893 | 6148 | 53.7267 | -127.6476 | 2021-01-14 05:22:32 | British Columbia, Canada | ||
3307969 | 3307969 | 2021-01-13 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
3307970 | 3307970 | 2021-01-13 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | ||
3307971 | 3307971 | 2021-01-13 | Canada | Manitoba | 26695 | 753 | 23014 | 2928 | 53.7609 | -98.8139 | 2021-01-14 05:22:32 | Manitoba, 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 | ||
3307973 | 3307973 | 2021-01-13 | Canada | Newfoundland and Labrador | 393 | 4 | 383 | 6 | 53.1355 | -57.6604 | 2021-01-14 05:22:32 | Newfoundland and Labrador, Canada | ||
3307974 | 3307974 | 2021-01-13 | Canada | Northwest Territories | 24 | 0 | 24 | 0 | 64.8255 | -124.8457 | 2021-01-14 05:22:32 | Northwest Territories,Canada | ||
3307975 | 3307975 | 2021-01-13 | Canada | Nova Scotia | 1542 | 65 | 1447 | 30 | 44.682 | -63.7443 | 2021-01-14 05:22:32 | Nova Scotia, Canada | ||
3307976 | 3307976 | 2021-01-13 | Canada | Nunavut | 266 | 1 | 265 | 0 | 70.2998 | -83.1076 | 2021-01-14 05:22:32 | Nunavut, Canada | ||
3307977 | 3307977 | 2021-01-13 | Canada | Ontario | 232659 | 5127 | 196687 | 28020 | 51.2538 | -85.3232 | 2021-01-14 05:22:32 | Ontario, Canada | ||
3307978 | 3307978 | 2021-01-13 | Canada | Prince Edward Island | 103 | 0 | 95 | 8 | 46.5107 | -63.4168 | 2021-01-14 05:22:32 | Prince Edward Island, Canada | ||
3307979 | 3307979 | 2021-01-13 | Canada | Quebec | 236581 | 8950 | 202166 | 25465 | 52.9399 | -73.5491 | 2021-01-14 05:22:32 | Quebec, Canada | ||
3307980 | 3307980 | 2021-01-13 | Canada | Repatriated Travellers | 13 | 0 | 13 | 0 | 2021-01-14 05:22:32 | Repatriated Travellers, Canada | ||||
3307981 | 3307981 | 2021-01-13 | Canada | Saskatchewan | 19021 | 206 | 15063 | 3748 | 52.9399 | -106.4509 | 2021-01-14 05:22:32 | Saskatchewan, Canada | ||
3307982 | 3307982 | 2021-01-13 | Canada | Yukon | 70 | 1 | 63 | 6 | 64.2823 | -135.0 | 2021-01-14 05:22:32 | Yukon, Canada | ||
774112 | 774112 | 2021-01-12 | Canada | Alberta | 112743 | 1345 | 98178 | 13220 | 53.9333 | -116.5765 | 2021-01-13 05:22:15 | Alberta, Canada | ||
774113 | 774113 | 2021-01-12 | Canada | British Columbia | 58553 | 1019 | 51144 | 6390 | 53.7267 | -127.6476 | 2021-01-13 05:22:15 | British Columbia, Canada | ||
774114 | 774114 | 2021-01-12 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
774115 | 774115 | 2021-01-12 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | ||
774116 | 774116 | 2021-01-12 | Canada | Manitoba | 26540 | 748 | 22692 | 3100 | 53.7609 | -98.8139 | 2021-01-13 05:22:15 | Manitoba, Canada | ||
774117 | 774117 | 2021-01-12 | Canada | New Brunswick | 817 | 11 | 586 | 220 | 46.5653 | -66.4619 | 2021-01-13 05:22:15 | New Brunswick, Canada | ||
774118 | 774118 | 2021-01-12 | Canada | Newfoundland and Labrador | 393 | 4 | 382 | 7 | 53.1355 | -57.6604 | 2021-01-13 05:22:15 | Newfoundland and Labrador, Canada | ||
774119 | 774119 | 2021-01-12 | Canada | Northwest Territories | 24 | 0 | 24 | 0 | 64.8255 | -124.8457 | 2021-01-13 05:22:15 | Northwest Territories,Canada | ||
774120 | 774120 | 2021-01-12 | Canada | Nova Scotia | 1534 | 65 | 1442 | 27 | 44.682 | -63.7443 | 2021-01-13 05:22:15 | Nova Scotia, Canada | ||
774121 | 774121 | 2021-01-12 | Canada | Nunavut | 266 | 1 | 265 | 0 | 70.2998 | -83.1076 | 2021-01-13 05:22:15 | Nunavut, Canada | ||
774122 | 774122 | 2021-01-12 | Canada | Ontario | 229405 | 5053 | 193191 | 28344 | 51.2538 | -85.3232 | 2021-01-13 05:22:15 | Ontario, Canada | ||
774123 | 774123 | 2021-01-12 | Canada | Prince Edward Island | 103 | 0 | 95 | 8 | 46.5107 | -63.4168 | 2021-01-13 05:22:15 | Prince Edward Island, Canada | ||
774124 | 774124 | 2021-01-12 | Canada | Quebec | 234567 | 8886 | 199920 | 25761 | 52.9399 | -73.5491 | 2021-01-13 05:22:15 | Quebec, Canada | ||
774125 | 774125 | 2021-01-12 | Canada | Repatriated Travellers | 13 | 0 | 13 | 0 | 2021-01-13 05:22:15 | Repatriated Travellers, Canada | ||||
774126 | 774126 | 2021-01-12 | Canada | Saskatchewan | 18774 | 204 | 14814 | 3752 | 52.9399 | -106.4509 | 2021-01-13 05:22:15 | Saskatchewan, Canada | ||
774127 | 774127 | 2021-01-12 | Canada | Yukon | 70 | 1 | 63 | 6 | 64.2823 | -135.0 | 2021-01-13 05:22:15 | Yukon, Canada | ||
189833 | 189833 | 2021-01-11 | Canada | Alberta | 112091 | 1307 | 96867 | 13917 | 53.9333 | -116.5765 | 2021-01-12 05:22:15 | Alberta, Canada | ||
189834 | 189834 | 2021-01-11 | Canada | British Columbia | 58107 | 1010 | 50541 | 6556 | 53.7267 | -127.6476 | 2021-01-12 05:22:15 | British Columbia, Canada | ||
189835 | 189835 | 2021-01-11 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
189836 | 189836 | 2021-01-11 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | ||
189837 | 189837 | 2021-01-11 | Canada | Manitoba | 26450 | 741 | 22295 | 3414 | 53.7609 | -98.8139 | 2021-01-12 05:22:15 | Manitoba, Canada | ||
189838 | 189838 | 2021-01-11 | Canada | New Brunswick | 800 | 9 | 586 | 205 | 46.5653 | -66.4619 | 2021-01-12 05:22:15 | New Brunswick, Canada | ||
189839 | 189839 | 2021-01-11 | Canada | Newfoundland and Labrador | 393 | 4 | 381 | 8 | 53.1355 | -57.6604 | 2021-01-12 05:22:15 | Newfoundland and Labrador, Canada | ||
189840 | 189840 | 2021-01-11 | Canada | Northwest Territories | 24 | 0 | 24 | 0 | 64.8255 | -124.8457 | 2021-01-12 05:22:15 | Northwest Territories,Canada | ||
189841 | 189841 | 2021-01-11 | Canada | Nova Scotia | 1533 | 65 | 1442 | 26 | 44.682 | -63.7443 | 2021-01-12 05:22:15 | Nova Scotia, Canada | ||
189842 | 189842 | 2021-01-11 | Canada | Nunavut | 266 | 1 | 265 | 0 | 70.2998 | -83.1076 | 2021-01-12 05:22:15 | Nunavut, Canada | ||
189843 | 189843 | 2021-01-11 | Canada | Ontario | 226241 | 5012 | 190042 | 28794 | 51.2538 | -85.3232 | 2021-01-12 05:22:15 | Ontario, Canada | ||
189844 | 189844 | 2021-01-11 | Canada | Prince Edward Island | 102 | 0 | 94 | 8 | 46.5107 | -63.4168 | 2021-01-12 05:22:15 | Prince Edward Island, Canada | ||
189845 | 189845 | 2021-01-11 | Canada | Quebec | 232383 | 8840 | 197938 | 25605 | 52.9399 | -73.5491 | 2021-01-12 05:22:15 | Quebec, Canada | ||
189846 | 189846 | 2021-01-11 | Canada | Repatriated Travellers | 13 | 0 | 13 | 0 | 2021-01-12 05:22:15 | Repatriated Travellers, Canada | ||||
189847 | 189847 | 2021-01-11 | Canada | Saskatchewan | 18526 | 199 | 14588 | 3735 | 52.9399 | -106.4509 | 2021-01-12 05:22:15 | Saskatchewan, Canada | ||
189848 | 189848 | 2021-01-11 | Canada | Yukon | 70 | 1 | 63 | 6 | 64.2823 | -135.0 | 2021-01-12 05:22:15 | Yukon, Canada | ||
2625636 | 2625636 | 2021-01-10 | Canada | Alberta | 111452 | 1284 | 96052 | 14116 | 53.9333 | -116.5765 | 2021-01-11 05:21:50 | Alberta, Canada | ||
2625637 | 2625637 | 2021-01-10 | Canada | British Columbia | 56632 | 988 | 48205 | 7439 | 53.7267 | -127.6476 | 2021-01-11 05:21:50 | British Columbia, Canada | ||
2625638 | 2625638 | 2021-01-10 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
2625639 | 2625639 | 2021-01-10 | Canada | Grand Princess | 13 | 0 | 13 | 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]);