johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
4,928 rows where country_or_region = "Canada" sorted by day descending
This data as json, yaml, copyable, CSV (advanced)
Suggested facets: latitude, longitude, combined_key, day (date), last_update (date)
province_or_state
- British Columbia 361
- Ontario 329
- Alberta 320
- Quebec 320
- New Brunswick 318
- Manitoba 316
- Saskatchewan 316
- Newfoundland and Labrador 314
- Prince Edward Island 314
- Nova Scotia 310
- Grand Princess 309
- Northwest Territories 305
- Nunavut 304
- Yukon 303
- Diamond Princess 295
- Repatriated Travellers 60
- Recovered 51
- London, ON 34
- Toronto, ON 34
- Montreal, QC 10
- Calgary, Alberta 3
- Edmonton, Alberta 2
country_or_region
- Canada · 4,928 ✖
| Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 89444 | 89444 | 2021-01-22 | Canada | Alberta | 119757 | 1512 | 108258 | 9987 | 53.9333 | -116.5765 | 2021-01-23 05:22:03 | Alberta, Canada | ||
| 89445 | 89445 | 2021-01-22 | Canada | British Columbia | 63484 | 1128 | 56455 | 5901 | 53.7267 | -127.6476 | 2021-01-23 05:22:03 | British Columbia, Canada | ||
| 89446 | 89446 | 2021-01-22 | Canada | Diamond Princess | 0 | 1 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | |||
| 89447 | 89447 | 2021-01-22 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | ||
| 89448 | 89448 | 2021-01-22 | Canada | Manitoba | 28260 | 795 | 24204 | 3261 | 53.7609 | -98.8139 | 2021-01-23 05:22:03 | Manitoba, Canada | ||
| 89449 | 89449 | 2021-01-22 | Canada | New Brunswick | 1087 | 13 | 742 | 332 | 46.5653 | -66.4619 | 2021-01-23 05:22:03 | New Brunswick, Canada | ||
| 89450 | 89450 | 2021-01-22 | Canada | Newfoundland and Labrador | 398 | 4 | 384 | 10 | 53.1355 | -57.6604 | 2021-01-23 05:22:03 | Newfoundland and Labrador, Canada | ||
| 89451 | 89451 | 2021-01-22 | Canada | Northwest Territories | 31 | 0 | 24 | 7 | 64.8255 | -124.8457 | 2021-01-23 05:22:03 | Northwest Territories,Canada | ||
| 89452 | 89452 | 2021-01-22 | Canada | Nova Scotia | 1570 | 65 | 1483 | 22 | 44.682 | -63.7443 | 2021-01-23 05:22:03 | Nova Scotia, Canada | ||
| 89453 | 89453 | 2021-01-22 | Canada | Nunavut | 267 | 1 | 265 | 1 | 70.2998 | -83.1076 | 2021-01-23 05:22:03 | Nunavut, Canada | ||
| 89454 | 89454 | 2021-01-22 | Canada | Ontario | 255074 | 5724 | 225605 | 23745 | 51.2538 | -85.3232 | 2021-01-23 05:22:03 | Ontario, Canada | ||
| 89455 | 89455 | 2021-01-22 | Canada | Prince Edward Island | 110 | 0 | 103 | 7 | 46.5107 | -63.4168 | 2021-01-23 05:22:03 | Prince Edward Island, Canada | ||
| 89456 | 89456 | 2021-01-22 | Canada | Quebec | 250491 | 9142 | 223367 | 17982 | 52.9399 | -73.5491 | 2021-01-23 05:22:03 | Quebec, Canada | ||
| 89457 | 89457 | 2021-01-22 | Canada | Repatriated Travellers | 13 | 0 | 13 | 0 | 2021-01-23 05:22:03 | Repatriated Travellers, Canada | ||||
| 89458 | 89458 | 2021-01-22 | Canada | Saskatchewan | 21643 | 247 | 18200 | 3196 | 52.9399 | -106.4509 | 2021-01-23 05:22:03 | Saskatchewan, Canada | ||
| 89459 | 89459 | 2021-01-22 | Canada | Yukon | 70 | 1 | 69 | 0 | 64.2823 | -135.0 | 2021-01-23 05:22:03 | Yukon, Canada | ||
| 302350 | 302350 | 2021-01-21 | Canada | Alberta | 119114 | 1500 | 107358 | 10256 | 53.9333 | -116.5765 | 2021-01-22 05:22:10 | Alberta, Canada | ||
| 302351 | 302351 | 2021-01-21 | Canada | British Columbia | 62976 | 1119 | 56010 | 5847 | 53.7267 | -127.6476 | 2021-01-22 05:22:10 | British Columbia, Canada | ||
| 302352 | 302352 | 2021-01-21 | Canada | Diamond Princess | 0 | 1 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | |||
| 302353 | 302353 | 2021-01-21 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | ||
| 302354 | 302354 | 2021-01-21 | Canada | Manitoba | 28089 | 793 | 24091 | 3205 | 53.7609 | -98.8139 | 2021-01-22 05:22:10 | Manitoba, Canada | ||
| 302355 | 302355 | 2021-01-21 | Canada | New Brunswick | 1057 | 13 | 719 | 325 | 46.5653 | -66.4619 | 2021-01-22 05:22:10 | New Brunswick, Canada | ||
| 302356 | 302356 | 2021-01-21 | Canada | Newfoundland and Labrador | 397 | 4 | 384 | 9 | 53.1355 | -57.6604 | 2021-01-22 05:22:10 | Newfoundland and Labrador, Canada | ||
| 302357 | 302357 | 2021-01-21 | Canada | Northwest Territories | 31 | 0 | 24 | 7 | 64.8255 | -124.8457 | 2021-01-22 05:22:10 | Northwest Territories,Canada | ||
| 302358 | 302358 | 2021-01-21 | Canada | Nova Scotia | 1565 | 65 | 1479 | 21 | 44.682 | -63.7443 | 2021-01-22 05:22:10 | Nova Scotia, Canada | ||
| 302359 | 302359 | 2021-01-21 | Canada | Nunavut | 266 | 1 | 265 | 0 | 70.2998 | -83.1076 | 2021-01-22 05:22:10 | Nunavut, Canada | ||
| 302360 | 302360 | 2021-01-21 | Canada | Ontario | 252542 | 5632 | 222391 | 24519 | 51.2538 | -85.3232 | 2021-01-22 05:22:10 | Ontario, Canada | ||
| 302361 | 302361 | 2021-01-21 | Canada | Prince Edward Island | 110 | 0 | 103 | 7 | 46.5107 | -63.4168 | 2021-01-22 05:22:10 | Prince Edward Island, Canada | ||
| 302362 | 302362 | 2021-01-21 | Canada | Quebec | 248860 | 9142 | 221327 | 18391 | 52.9399 | -73.5491 | 2021-01-22 05:22:10 | Quebec, Canada | ||
| 302363 | 302363 | 2021-01-21 | Canada | Repatriated Travellers | 13 | 0 | 13 | 0 | 2021-01-22 05:22:10 | Repatriated Travellers, Canada | ||||
| 302364 | 302364 | 2021-01-21 | Canada | Saskatchewan | 21338 | 239 | 18000 | 3099 | 52.9399 | -106.4509 | 2021-01-22 05:22:10 | Saskatchewan, Canada | ||
| 302365 | 302365 | 2021-01-21 | Canada | Yukon | 70 | 1 | 69 | 0 | 64.2823 | -135.0 | 2021-01-22 05:22:10 | Yukon, Canada | ||
| 893402 | 893402 | 2021-01-20 | Canada | Alberta | 118436 | 1484 | 106387 | 10565 | 53.9333 | -116.5765 | 2021-01-21 05:22:01 | Alberta, Canada | ||
| 893403 | 893403 | 2021-01-20 | Canada | British Columbia | 62412 | 1104 | 55564 | 5744 | 53.7267 | -127.6476 | 2021-01-21 05:22:01 | British Columbia, Canada | ||
| 893404 | 893404 | 2021-01-20 | Canada | Diamond Princess | 0 | 1 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | |||
| 893405 | 893405 | 2021-01-20 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | ||
| 893406 | 893406 | 2021-01-20 | Canada | Manitoba | 27893 | 788 | 23968 | 3137 | 53.7609 | -98.8139 | 2021-01-21 05:22:01 | Manitoba, Canada | ||
| 893407 | 893407 | 2021-01-20 | Canada | New Brunswick | 1025 | 13 | 694 | 318 | 46.5653 | -66.4619 | 2021-01-21 05:22:01 | New Brunswick, Canada | ||
| 893408 | 893408 | 2021-01-20 | Canada | Newfoundland and Labrador | 396 | 4 | 384 | 8 | 53.1355 | -57.6604 | 2021-01-21 05:22:01 | Newfoundland and Labrador, Canada | ||
| 893409 | 893409 | 2021-01-20 | Canada | Northwest Territories | 31 | 0 | 24 | 7 | 64.8255 | -124.8457 | 2021-01-21 05:22:01 | Northwest Territories,Canada | ||
| 893410 | 893410 | 2021-01-20 | Canada | Nova Scotia | 1564 | 65 | 1476 | 23 | 44.682 | -63.7443 | 2021-01-21 05:22:01 | Nova Scotia, Canada | ||
| 893411 | 893411 | 2021-01-20 | Canada | Nunavut | 266 | 1 | 265 | 0 | 70.2998 | -83.1076 | 2021-01-21 05:22:01 | Nunavut, Canada | ||
| 893412 | 893412 | 2021-01-20 | Canada | Ontario | 249753 | 5587 | 219231 | 24935 | 51.2538 | -85.3232 | 2021-01-21 05:22:01 | Ontario, Canada | ||
| 893413 | 893413 | 2021-01-20 | Canada | Prince Edward Island | 110 | 0 | 103 | 7 | 46.5107 | -63.4168 | 2021-01-21 05:22:01 | Prince Edward Island, Canada | ||
| 893414 | 893414 | 2021-01-20 | Canada | Quebec | 247236 | 9142 | 219592 | 18502 | 52.9399 | -73.5491 | 2021-01-21 05:22:01 | Quebec, Canada | ||
| 893415 | 893415 | 2021-01-20 | Canada | Repatriated Travellers | 13 | 0 | 13 | 0 | 2021-01-21 05:22:01 | Repatriated Travellers, Canada | ||||
| 893416 | 893416 | 2021-01-20 | Canada | Saskatchewan | 21112 | 226 | 17184 | 3702 | 52.9399 | -106.4509 | 2021-01-21 05:22:01 | Saskatchewan, Canada | ||
| 893417 | 893417 | 2021-01-20 | Canada | Yukon | 70 | 1 | 69 | 0 | 64.2823 | -135.0 | 2021-01-21 05:22:01 | Yukon, Canada | ||
| 321969 | 321969 | 2021-01-19 | Canada | Alberta | 117767 | 1463 | 105208 | 11096 | 53.9333 | -116.5765 | 2021-01-20 05:21:54 | Alberta, Canada | ||
| 321970 | 321970 | 2021-01-19 | Canada | British Columbia | 61912 | 1090 | 55099 | 5723 | 53.7267 | -127.6476 | 2021-01-20 05:21:54 | British Columbia, Canada | ||
| 321971 | 321971 | 2021-01-19 | Canada | Diamond Princess | 0 | 1 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | |||
| 321972 | 321972 | 2021-01-19 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | ||
| 321973 | 321973 | 2021-01-19 | Canada | Manitoba | 27740 | 783 | 23869 | 3088 | 53.7609 | -98.8139 | 2021-01-20 05:21:54 | Manitoba, Canada | ||
| 321974 | 321974 | 2021-01-19 | Canada | New Brunswick | 1004 | 13 | 674 | 317 | 46.5653 | -66.4619 | 2021-01-20 05:21:54 | New Brunswick, Canada | ||
| 321975 | 321975 | 2021-01-19 | Canada | Newfoundland and Labrador | 396 | 4 | 384 | 8 | 53.1355 | -57.6604 | 2021-01-20 05:21:54 | Newfoundland and Labrador, Canada | ||
| 321976 | 321976 | 2021-01-19 | Canada | Northwest Territories | 28 | 0 | 24 | 4 | 64.8255 | -124.8457 | 2021-01-20 05:21:54 | Northwest Territories,Canada | ||
| 321977 | 321977 | 2021-01-19 | Canada | Nova Scotia | 1561 | 65 | 1474 | 22 | 44.682 | -63.7443 | 2021-01-20 05:21:54 | Nova Scotia, Canada | ||
| 321978 | 321978 | 2021-01-19 | Canada | Nunavut | 266 | 1 | 265 | 0 | 70.2998 | -83.1076 | 2021-01-20 05:21:54 | Nunavut, Canada | ||
| 321979 | 321979 | 2021-01-19 | Canada | Ontario | 247144 | 5501 | 215872 | 25771 | 51.2538 | -85.3232 | 2021-01-20 05:21:54 | Ontario, Canada | ||
| 321980 | 321980 | 2021-01-19 | Canada | Prince Edward Island | 110 | 0 | 103 | 7 | 46.5107 | -63.4168 | 2021-01-20 05:21:54 | Prince Edward Island, Canada | ||
| 321981 | 321981 | 2021-01-19 | Canada | Quebec | 245734 | 9142 | 217575 | 19017 | 52.9399 | -73.5491 | 2021-01-20 05:21:54 | Quebec, Canada | ||
| 321982 | 321982 | 2021-01-19 | Canada | Repatriated Travellers | 13 | 0 | 13 | 0 | 2021-01-20 05:21:54 | Repatriated Travellers, Canada | ||||
| 321983 | 321983 | 2021-01-19 | Canada | Saskatchewan | 20871 | 225 | 16490 | 4156 | 52.9399 | -106.4509 | 2021-01-20 05:21:54 | Saskatchewan, Canada | ||
| 321984 | 321984 | 2021-01-19 | Canada | Yukon | 70 | 1 | 69 | 0 | 64.2823 | -135.0 | 2021-01-20 05:21:54 | Yukon, Canada | ||
| 573955 | 573955 | 2021-01-18 | Canada | Alberta | 117311 | 1447 | 103941 | 11923 | 53.9333 | -116.5765 | 2021-01-19 05:22:15 | Alberta, Canada | ||
| 573956 | 573956 | 2021-01-18 | Canada | British Columbia | 61447 | 1078 | 54656 | 5713 | 53.7267 | -127.6476 | 2021-01-19 05:22:15 | British Columbia, Canada | ||
| 573957 | 573957 | 2021-01-18 | Canada | Diamond Princess | 0 | 1 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | |||
| 573958 | 573958 | 2021-01-18 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | ||
| 573959 | 573959 | 2021-01-18 | Canada | Manitoba | 27629 | 773 | 23748 | 3108 | 53.7609 | -98.8139 | 2021-01-19 05:22:15 | Manitoba, Canada | ||
| 573960 | 573960 | 2021-01-18 | Canada | New Brunswick | 973 | 12 | 656 | 305 | 46.5653 | -66.4619 | 2021-01-19 05:22:15 | New Brunswick, Canada | ||
| 573961 | 573961 | 2021-01-18 | Canada | Newfoundland and Labrador | 396 | 4 | 383 | 9 | 53.1355 | -57.6604 | 2021-01-19 05:22:15 | Newfoundland and Labrador, Canada | ||
| 573962 | 573962 | 2021-01-18 | Canada | Northwest Territories | 25 | 0 | 24 | 1 | 64.8255 | -124.8457 | 2021-01-19 05:22:15 | Northwest Territories,Canada | ||
| 573963 | 573963 | 2021-01-18 | Canada | Nova Scotia | 1557 | 65 | 1467 | 25 | 44.682 | -63.7443 | 2021-01-19 05:22:15 | Nova Scotia, Canada | ||
| 573964 | 573964 | 2021-01-18 | Canada | Nunavut | 266 | 1 | 265 | 0 | 70.2998 | -83.1076 | 2021-01-19 05:22:15 | Nunavut, Canada | ||
| 573965 | 573965 | 2021-01-18 | Canada | Ontario | 244883 | 5442 | 212811 | 26630 | 51.2538 | -85.3232 | 2021-01-19 05:22:15 | Ontario, Canada | ||
| 573966 | 573966 | 2021-01-18 | Canada | Prince Edward Island | 108 | 0 | 98 | 10 | 46.5107 | -63.4168 | 2021-01-19 05:22:15 | Prince Edward Island, Canada | ||
| 573967 | 573967 | 2021-01-18 | Canada | Quebec | 244348 | 9087 | 215325 | 19936 | 52.9399 | -73.5491 | 2021-01-19 05:22:15 | Quebec, Canada | ||
| 573968 | 573968 | 2021-01-18 | Canada | Repatriated Travellers | 13 | 0 | 13 | 0 | 2021-01-19 05:22:15 | Repatriated Travellers, Canada | ||||
| 573969 | 573969 | 2021-01-18 | Canada | Saskatchewan | 20562 | 219 | 16078 | 4265 | 52.9399 | -106.4509 | 2021-01-19 05:22:15 | Saskatchewan, Canada | ||
| 573970 | 573970 | 2021-01-18 | Canada | Yukon | 70 | 1 | 69 | 0 | 64.2823 | -135.0 | 2021-01-19 05:22:15 | Yukon, Canada | ||
| 538518 | 538518 | 2021-01-17 | Canada | Alberta | 116837 | 1436 | 103167 | 12234 | 53.9333 | -116.5765 | 2021-01-18 05:22:34 | Alberta, Canada | ||
| 538519 | 538519 | 2021-01-17 | Canada | British Columbia | 60117 | 1047 | 53115 | 5955 | 53.7267 | -127.6476 | 2021-01-18 05:22:34 | British Columbia, Canada | ||
| 538520 | 538520 | 2021-01-17 | Canada | Diamond Princess | 0 | 1 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | |||
| 538521 | 538521 | 2021-01-17 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | ||
| 538522 | 538522 | 2021-01-17 | Canada | Manitoba | 27511 | 769 | 23661 | 3081 | 53.7609 | -98.8139 | 2021-01-18 05:22:34 | Manitoba, Canada | ||
| 538523 | 538523 | 2021-01-17 | Canada | New Brunswick | 947 | 12 | 642 | 293 | 46.5653 | -66.4619 | 2021-01-18 05:22:34 | New Brunswick, Canada | ||
| 538524 | 538524 | 2021-01-17 | Canada | Newfoundland and Labrador | 396 | 4 | 383 | 9 | 53.1355 | -57.6604 | 2021-01-18 05:22:34 | Newfoundland and Labrador, Canada | ||
| 538525 | 538525 | 2021-01-17 | Canada | Northwest Territories | 25 | 0 | 24 | 1 | 64.8255 | -124.8457 | 2021-01-18 05:22:34 | Northwest Territories,Canada | ||
| 538526 | 538526 | 2021-01-17 | Canada | Nova Scotia | 1558 | 65 | 1464 | 29 | 44.682 | -63.7443 | 2021-01-18 05:22:34 | Nova Scotia, Canada | ||
| 538527 | 538527 | 2021-01-17 | Canada | Nunavut | 266 | 1 | 265 | 0 | 70.2998 | -83.1076 | 2021-01-18 05:22:34 | Nunavut, Canada | ||
| 538528 | 538528 | 2021-01-17 | Canada | Ontario | 242339 | 5418 | 210004 | 26917 | 51.2538 | -85.3232 | 2021-01-18 05:22:34 | Ontario, Canada | ||
| 538529 | 538529 | 2021-01-17 | Canada | Prince Edward Island | 103 | 0 | 95 | 8 | 46.5107 | -63.4168 | 2021-01-18 05:22:34 | Prince Edward Island, Canada | ||
| 538530 | 538530 | 2021-01-17 | Canada | Quebec | 242714 | 9055 | 213008 | 20651 | 52.9399 | -73.5491 | 2021-01-18 05:22:34 | Quebec, Canada | ||
| 538531 | 538531 | 2021-01-17 | Canada | Repatriated Travellers | 13 | 0 | 13 | 0 | 2021-01-18 05:22:34 | Repatriated Travellers, Canada | ||||
| 538532 | 538532 | 2021-01-17 | Canada | Saskatchewan | 20272 | 215 | 15936 | 4121 | 52.9399 | -106.4509 | 2021-01-18 05:22:34 | Saskatchewan, Canada | ||
| 538533 | 538533 | 2021-01-17 | Canada | Yukon | 70 | 1 | 67 | 2 | 64.2823 | -135.0 | 2021-01-18 05:22:34 | Yukon, Canada | ||
| 619306 | 619306 | 2021-01-16 | Canada | Alberta | 116087 | 1417 | 101957 | 12713 | 53.9333 | -116.5765 | 2021-01-17 05:22:17 | Alberta, Canada | ||
| 619307 | 619307 | 2021-01-16 | Canada | British Columbia | 60117 | 1047 | 53115 | 5955 | 53.7267 | -127.6476 | 2021-01-17 05:22:17 | British Columbia, Canada | ||
| 619308 | 619308 | 2021-01-16 | Canada | Diamond Princess | 0 | 1 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | |||
| 619309 | 619309 | 2021-01-16 | 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] INTEGER,
[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]);