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 232
- Ontario 200
- Alberta 191
- Quebec 191
- New Brunswick 189
- Manitoba 187
- Saskatchewan 187
- Newfoundland and Labrador 185
- Prince Edward Island 185
- Nova Scotia 181
- Grand Princess 180
- Northwest Territories 176
- Nunavut 175
- Yukon 174
- Diamond Princess 166
- Recovered 51
- London, ON 34
- Toronto, ON 34
- Montreal, QC 13
- Calgary, Alberta 3
- Edmonton, Alberta 2
country_or_region 1
- Canada · 2,936 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2728770 | 2728770 | 2020-09-15 | Canada | Alberta | 15957 | 254 | 14212 | 1491 | 53.9333 | -116.5765 | 2020-09-16 04:22:53 | Alberta, Canada | ||
2728771 | 2728771 | 2020-09-15 | Canada | British Columbia | 7376 | 219 | 5548 | 1609 | 53.7267 | -127.6476 | 2020-09-16 04:22:53 | British Columbia, Canada | ||
2728772 | 2728772 | 2020-09-15 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-09-16 04:22:53 | Diamond Princess, Canada | ||
2728773 | 2728773 | 2020-09-15 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-09-16 04:22:53 | Grand Princess, Canada | ||
2728774 | 2728774 | 2020-09-15 | Canada | Manitoba | 1466 | 16 | 1181 | 269 | 53.7609 | -98.8139 | 2020-09-16 04:22:53 | Manitoba, Canada | ||
2728775 | 2728775 | 2020-09-15 | Canada | New Brunswick | 194 | 2 | 189 | 3 | 46.5653 | -66.4619 | 2020-09-16 04:22:53 | New Brunswick, Canada | ||
2728776 | 2728776 | 2020-09-15 | Canada | Newfoundland and Labrador | 271 | 3 | 267 | 1 | 53.1355 | -57.6604 | 2020-09-16 04:22:53 | Newfoundland and Labrador, Canada | ||
2728777 | 2728777 | 2020-09-15 | Canada | Northwest Territories | 5 | 0 | 5 | 0 | 64.8255 | -124.8457 | 2020-09-16 04:22:53 | Northwest Territories,Canada | ||
2728778 | 2728778 | 2020-09-15 | Canada | Nova Scotia | 1086 | 65 | 1020 | 1 | 44.682 | -63.7443 | 2020-09-16 04:22:53 | Nova Scotia, Canada | ||
2728779 | 2728779 | 2020-09-15 | Canada | Nunavut | 0 | 0 | 0 | 0 | 70.2998 | -83.1076 | 2020-09-16 04:22:53 | Nunavut, Canada | ||
2728780 | 2728780 | 2020-09-15 | Canada | Ontario | 46318 | 2820 | 42027 | 2268 | 51.2538 | -85.3232 | 2020-09-16 04:22:53 | Ontario, Canada | ||
2728781 | 2728781 | 2020-09-15 | Canada | Prince Edward Island | 57 | 0 | 56 | 1 | 46.5107 | -63.4168 | 2020-09-16 04:22:53 | Prince Edward Island, Canada | ||
2728782 | 2728782 | 2020-09-15 | Canada | Quebec | 65972 | 5803 | 57628 | 2541 | 52.9399 | -73.5491 | 2020-09-16 04:22:53 | Quebec, Canada | ||
2728783 | 2728783 | 2020-09-15 | Canada | Saskatchewan | 1741 | 24 | 1616 | 101 | 52.9399 | -106.4509 | 2020-09-16 04:22:53 | Saskatchewan, Canada | ||
2728784 | 2728784 | 2020-09-15 | Canada | Yukon | 15 | 0 | 15 | 0 | 64.2823 | -135.0 | 2020-09-16 04:22:53 | Yukon, Canada | ||
344042 | 344042 | 2020-09-14 | Canada | Alberta | 15833 | 254 | 14041 | 1538 | 53.9333 | -116.5765 | 2020-09-15 03:22:50 | Alberta, Canada | ||
344043 | 344043 | 2020-09-14 | Canada | British Columbia | 7279 | 219 | 5446 | 1614 | 53.7267 | -127.6476 | 2020-09-15 03:22:50 | British Columbia, Canada | ||
344044 | 344044 | 2020-09-14 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-09-15 03:22:50 | Diamond Princess, Canada | ||
344045 | 344045 | 2020-09-14 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-09-15 03:22:50 | Grand Princess, Canada | ||
344046 | 344046 | 2020-09-14 | Canada | Manitoba | 1449 | 16 | 1176 | 257 | 53.7609 | -98.8139 | 2020-09-15 03:22:50 | Manitoba, Canada | ||
344047 | 344047 | 2020-09-14 | Canada | New Brunswick | 194 | 2 | 189 | 3 | 46.5653 | -66.4619 | 2020-09-15 03:22:50 | New Brunswick, Canada | ||
344048 | 344048 | 2020-09-14 | Canada | Newfoundland and Labrador | 271 | 3 | 267 | 1 | 53.1355 | -57.6604 | 2020-09-15 03:22:50 | Newfoundland and Labrador, Canada | ||
344049 | 344049 | 2020-09-14 | Canada | Northwest Territories | 5 | 0 | 5 | 0 | 64.8255 | -124.8457 | 2020-09-15 03:22:50 | Northwest Territories,Canada | ||
344050 | 344050 | 2020-09-14 | Canada | Nova Scotia | 1086 | 65 | 1020 | 1 | 44.682 | -63.7443 | 2020-09-15 03:22:50 | Nova Scotia, Canada | ||
344051 | 344051 | 2020-09-14 | Canada | Nunavut | 0 | 0 | 0 | 0 | 70.2998 | -83.1076 | 2020-09-15 03:22:50 | Nunavut, Canada | ||
344052 | 344052 | 2020-09-14 | Canada | Ontario | 45959 | 2816 | 41869 | 2171 | 51.2538 | -85.3232 | 2020-09-15 03:22:50 | Ontario, Canada | ||
344053 | 344053 | 2020-09-14 | Canada | Prince Edward Island | 55 | 0 | 47 | 8 | 46.5107 | -63.4168 | 2020-09-15 03:22:50 | Prince Edward Island, Canada | ||
344054 | 344054 | 2020-09-14 | Canada | Quebec | 65651 | 5800 | 57428 | 2423 | 52.9399 | -73.5491 | 2020-09-15 03:22:50 | Quebec, Canada | ||
344055 | 344055 | 2020-09-14 | Canada | Saskatchewan | 1731 | 24 | 1604 | 103 | 52.9399 | -106.4509 | 2020-09-15 03:22:50 | Saskatchewan, Canada | ||
344056 | 344056 | 2020-09-14 | Canada | Yukon | 15 | 0 | 15 | 0 | 64.2823 | -135.0 | 2020-09-15 03:22:50 | Yukon, Canada | ||
2868481 | 2868481 | 2020-09-13 | Canada | Alberta | 15415 | 253 | 13718 | 1444 | 53.9333 | -116.5765 | 2020-09-14 04:26:00 | Alberta, Canada | ||
2868482 | 2868482 | 2020-09-13 | Canada | British Columbia | 6962 | 213 | 5273 | 1476 | 53.7267 | -127.6476 | 2020-09-14 04:26:00 | British Columbia, Canada | ||
2868483 | 2868483 | 2020-09-13 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-09-14 04:26:00 | Diamond Princess, Canada | ||
2868484 | 2868484 | 2020-09-13 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-09-14 04:26:00 | Grand Princess, Canada | ||
2868485 | 2868485 | 2020-09-13 | Canada | Manitoba | 1428 | 16 | 1173 | 239 | 53.7609 | -98.8139 | 2020-09-14 04:26:00 | Manitoba, Canada | ||
2868486 | 2868486 | 2020-09-13 | Canada | New Brunswick | 193 | 2 | 189 | 2 | 46.5653 | -66.4619 | 2020-09-14 04:26:00 | New Brunswick, Canada | ||
2868487 | 2868487 | 2020-09-13 | Canada | Newfoundland and Labrador | 271 | 3 | 267 | 1 | 53.1355 | -57.6604 | 2020-09-14 04:26:00 | Newfoundland and Labrador, Canada | ||
2868488 | 2868488 | 2020-09-13 | Canada | Northwest Territories | 5 | 0 | 5 | 0 | 64.8255 | -124.8457 | 2020-09-14 04:26:00 | Northwest Territories,Canada | ||
2868489 | 2868489 | 2020-09-13 | Canada | Nova Scotia | 1086 | 65 | 1020 | 1 | 44.682 | -63.7443 | 2020-09-14 04:26:00 | Nova Scotia, Canada | ||
2868490 | 2868490 | 2020-09-13 | Canada | Nunavut | 0 | 0 | 0 | 0 | 70.2998 | -83.1076 | 2020-09-14 04:26:00 | Nunavut, Canada | ||
2868491 | 2868491 | 2020-09-13 | Canada | Ontario | 45669 | 2815 | 41675 | 1947 | 51.2538 | -85.3232 | 2020-09-14 04:26:00 | Ontario, Canada | ||
2868492 | 2868492 | 2020-09-13 | Canada | Prince Edward Island | 55 | 0 | 47 | 8 | 46.5107 | -63.4168 | 2020-09-14 04:26:00 | Prince Edward Island, Canada | ||
2868493 | 2868493 | 2020-09-13 | Canada | Quebec | 65374 | 5796 | 57268 | 2310 | 52.9399 | -73.5491 | 2020-09-14 04:26:00 | Quebec, Canada | ||
2868494 | 2868494 | 2020-09-13 | Canada | Saskatchewan | 1726 | 24 | 1603 | 99 | 52.9399 | -106.4509 | 2020-09-14 04:26:00 | Saskatchewan, Canada | ||
2868495 | 2868495 | 2020-09-13 | Canada | Yukon | 15 | 0 | 15 | 0 | 64.2823 | -135.0 | 2020-09-14 04:26:00 | Yukon, Canada | ||
546520 | 546520 | 2020-09-12 | Canada | Alberta | 15415 | 253 | 13718 | 1444 | 53.9333 | -116.5765 | 2020-09-13 04:30:52 | Alberta, Canada | ||
546521 | 546521 | 2020-09-12 | Canada | British Columbia | 6962 | 213 | 5273 | 1476 | 53.7267 | -127.6476 | 2020-09-13 04:30:52 | British Columbia, Canada | ||
546522 | 546522 | 2020-09-12 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-09-13 04:30:52 | Diamond Princess, Canada | ||
546523 | 546523 | 2020-09-12 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-09-13 04:30:52 | Grand Princess, Canada | ||
546524 | 546524 | 2020-09-12 | Canada | Manitoba | 1410 | 16 | 1156 | 238 | 53.7609 | -98.8139 | 2020-09-13 04:30:52 | Manitoba, Canada | ||
546525 | 546525 | 2020-09-12 | Canada | New Brunswick | 193 | 2 | 189 | 2 | 46.5653 | -66.4619 | 2020-09-13 04:30:52 | New Brunswick, Canada | ||
546526 | 546526 | 2020-09-12 | Canada | Newfoundland and Labrador | 271 | 3 | 267 | 1 | 53.1355 | -57.6604 | 2020-09-13 04:30:52 | Newfoundland and Labrador, Canada | ||
546527 | 546527 | 2020-09-12 | Canada | Northwest Territories | 5 | 0 | 5 | 0 | 64.8255 | -124.8457 | 2020-09-13 04:30:52 | Northwest Territories,Canada | ||
546528 | 546528 | 2020-09-12 | Canada | Nova Scotia | 1086 | 65 | 1020 | 1 | 44.682 | -63.7443 | 2020-09-13 04:30:52 | Nova Scotia, Canada | ||
546529 | 546529 | 2020-09-12 | Canada | Nunavut | 0 | 0 | 0 | 0 | 70.2998 | -83.1076 | 2020-09-13 04:30:52 | Nunavut, Canada | ||
546530 | 546530 | 2020-09-12 | Canada | Ontario | 45444 | 2814 | 41585 | 1875 | 51.2538 | -85.3232 | 2020-09-13 04:30:52 | Ontario, Canada | ||
546531 | 546531 | 2020-09-12 | Canada | Prince Edward Island | 55 | 0 | 47 | 8 | 46.5107 | -63.4168 | 2020-09-13 04:30:52 | Prince Edward Island, Canada | ||
546532 | 546532 | 2020-09-12 | Canada | Quebec | 65058 | 5793 | 57054 | 2211 | 52.9399 | -73.5491 | 2020-09-13 04:30:52 | Quebec, Canada | ||
546533 | 546533 | 2020-09-12 | Canada | Saskatchewan | 1709 | 24 | 1602 | 83 | 52.9399 | -106.4509 | 2020-09-13 04:30:52 | Saskatchewan, Canada | ||
546534 | 546534 | 2020-09-12 | Canada | Yukon | 15 | 0 | 15 | 0 | 64.2823 | -135.0 | 2020-09-13 04:30:52 | Yukon, Canada | ||
1444349 | 1444349 | 2020-09-11 | Canada | Alberta | 15415 | 253 | 13718 | 1444 | 53.9333 | -116.5765 | 2020-09-12 04:25:05 | Alberta, Canada | ||
1444350 | 1444350 | 2020-09-11 | Canada | British Columbia | 6962 | 213 | 5273 | 1476 | 53.7267 | -127.6476 | 2020-09-12 04:25:05 | British Columbia, Canada | ||
1444351 | 1444351 | 2020-09-11 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-09-12 04:25:05 | Diamond Princess, Canada | ||
1444352 | 1444352 | 2020-09-11 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-09-12 04:25:05 | Grand Princess, Canada | ||
1444353 | 1444353 | 2020-09-11 | Canada | Manitoba | 1393 | 16 | 1090 | 287 | 53.7609 | -98.8139 | 2020-09-12 04:25:05 | Manitoba, Canada | ||
1444354 | 1444354 | 2020-09-11 | Canada | New Brunswick | 193 | 2 | 189 | 2 | 46.5653 | -66.4619 | 2020-09-12 04:25:05 | New Brunswick, Canada | ||
1444355 | 1444355 | 2020-09-11 | Canada | Newfoundland and Labrador | 270 | 3 | 267 | 0 | 53.1355 | -57.6604 | 2020-09-12 04:25:05 | Newfoundland and Labrador, Canada | ||
1444356 | 1444356 | 2020-09-11 | Canada | Northwest Territories | 5 | 0 | 5 | 0 | 64.8255 | -124.8457 | 2020-09-12 04:25:05 | Northwest Territories,Canada | ||
1444357 | 1444357 | 2020-09-11 | Canada | Nova Scotia | 1086 | 65 | 1019 | 2 | 44.682 | -63.7443 | 2020-09-12 04:25:05 | Nova Scotia, Canada | ||
1444358 | 1444358 | 2020-09-11 | Canada | Nunavut | 0 | 0 | 0 | 0 | 70.2998 | -83.1076 | 2020-09-12 04:25:05 | Nunavut, Canada | ||
1444359 | 1444359 | 2020-09-11 | Canada | Ontario | 45139 | 2813 | 41460 | 1795 | 51.2538 | -85.3232 | 2020-09-12 04:25:05 | Ontario, Canada | ||
1444360 | 1444360 | 2020-09-11 | Canada | Prince Edward Island | 55 | 0 | 47 | 8 | 46.5107 | -63.4168 | 2020-09-12 04:25:05 | Prince Edward Island, Canada | ||
1444361 | 1444361 | 2020-09-11 | Canada | Quebec | 64763 | 5791 | 56843 | 2129 | 52.9399 | -73.5491 | 2020-09-12 04:25:05 | Quebec, Canada | ||
1444362 | 1444362 | 2020-09-11 | Canada | Saskatchewan | 1688 | 24 | 1598 | 66 | 52.9399 | -106.4509 | 2020-09-12 04:25:05 | Saskatchewan, Canada | ||
1444363 | 1444363 | 2020-09-11 | Canada | Yukon | 15 | 0 | 15 | 0 | 64.2823 | -135.0 | 2020-09-12 04:25:05 | Yukon, Canada | ||
1172950 | 1172950 | 2020-09-10 | Canada | Alberta | 15304 | 253 | 13557 | 1494 | 53.9333 | -116.5765 | 2020-09-11 04:46:23 | Alberta, Canada | ||
1172951 | 1172951 | 2020-09-10 | Canada | British Columbia | 6830 | 213 | 5205 | 1412 | 53.7267 | -127.6476 | 2020-09-11 04:46:23 | British Columbia, Canada | ||
1172952 | 1172952 | 2020-09-10 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-09-11 04:46:23 | Diamond Princess, Canada | ||
1172953 | 1172953 | 2020-09-10 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-09-11 04:46:23 | Grand Princess, Canada | ||
1172954 | 1172954 | 2020-09-10 | Canada | Manitoba | 1378 | 16 | 1002 | 360 | 53.7609 | -98.8139 | 2020-09-11 04:46:23 | Manitoba, Canada | ||
1172955 | 1172955 | 2020-09-10 | Canada | New Brunswick | 193 | 2 | 188 | 3 | 46.5653 | -66.4619 | 2020-09-11 04:46:23 | New Brunswick, Canada | ||
1172956 | 1172956 | 2020-09-10 | Canada | Newfoundland and Labrador | 270 | 3 | 266 | 1 | 53.1355 | -57.6604 | 2020-09-11 04:46:23 | Newfoundland and Labrador, Canada | ||
1172957 | 1172957 | 2020-09-10 | Canada | Northwest Territories | 5 | 0 | 5 | 0 | 64.8255 | -124.8457 | 2020-09-11 04:46:23 | Northwest Territories,Canada | ||
1172958 | 1172958 | 2020-09-10 | Canada | Nova Scotia | 1086 | 65 | 1019 | 2 | 44.682 | -63.7443 | 2020-09-11 04:46:23 | Nova Scotia, Canada | ||
1172959 | 1172959 | 2020-09-10 | Canada | Nunavut | 0 | 0 | 0 | 0 | 70.2998 | -83.1076 | 2020-09-11 04:46:23 | Nunavut, Canada | ||
1172960 | 1172960 | 2020-09-10 | Canada | Ontario | 44900 | 2814 | 41317 | 1707 | 51.2538 | -85.3232 | 2020-09-11 04:46:23 | Ontario, Canada | ||
1172961 | 1172961 | 2020-09-10 | Canada | Prince Edward Island | 55 | 0 | 44 | 11 | 46.5107 | -63.4168 | 2020-09-11 04:46:23 | Prince Edward Island, Canada | ||
1172962 | 1172962 | 2020-09-10 | Canada | Quebec | 64457 | 5791 | 56624 | 2042 | 52.9399 | -73.5491 | 2020-09-11 04:46:23 | Quebec, Canada | ||
1172963 | 1172963 | 2020-09-10 | Canada | Saskatchewan | 1676 | 24 | 1593 | 59 | 52.9399 | -106.4509 | 2020-09-11 04:46:23 | Saskatchewan, Canada | ||
1172964 | 1172964 | 2020-09-10 | Canada | Yukon | 15 | 0 | 15 | 0 | 64.2823 | -135.0 | 2020-09-11 04:46:23 | Yukon, Canada | ||
2171315 | 2171315 | 2020-09-09 | Canada | Alberta | 15093 | 247 | 13154 | 1692 | 53.9333 | -116.5765 | 2020-09-10 04:29:01 | Alberta, Canada | ||
2171316 | 2171316 | 2020-09-09 | Canada | British Columbia | 6591 | 213 | 4978 | 1400 | 53.7267 | -127.6476 | 2020-09-10 04:29:01 | British Columbia, Canada | ||
2171317 | 2171317 | 2020-09-09 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-09-10 04:29:01 | Diamond Princess, Canada | ||
2171318 | 2171318 | 2020-09-09 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-09-10 04:29:01 | Grand Princess, Canada | ||
2171319 | 2171319 | 2020-09-09 | Canada | Manitoba | 1365 | 16 | 945 | 404 | 53.7609 | -98.8139 | 2020-09-10 04:29:01 | Manitoba, Canada | ||
2171320 | 2171320 | 2020-09-09 | Canada | New Brunswick | 192 | 2 | 188 | 2 | 46.5653 | -66.4619 | 2020-09-10 04:29:01 | New Brunswick, Canada | ||
2171321 | 2171321 | 2020-09-09 | Canada | Newfoundland and Labrador | 270 | 3 | 266 | 1 | 53.1355 | -57.6604 | 2020-09-10 04:29:01 | Newfoundland and Labrador, Canada | ||
2171322 | 2171322 | 2020-09-09 | Canada | Northwest Territories | 5 | 0 | 5 | 0 | 64.8255 | -124.8457 | 2020-09-10 04:29:01 | Northwest Territories,Canada | ||
2171323 | 2171323 | 2020-09-09 | Canada | Nova Scotia | 1086 | 65 | 1018 | 3 | 44.682 | -63.7443 | 2020-09-10 04:29:01 | Nova Scotia, Canada | ||
2171324 | 2171324 | 2020-09-09 | Canada | Nunavut | 0 | 0 | 0 | 0 | 70.2998 | -83.1076 | 2020-09-10 04:29:01 | 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]);