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 298
- Ontario 266
- Alberta 257
- Quebec 257
- New Brunswick 255
- Manitoba 253
- Saskatchewan 253
- Newfoundland and Labrador 251
- Prince Edward Island 251
- Nova Scotia 247
- Grand Princess 246
- Northwest Territories 242
- Nunavut 241
- Yukon 240
- Diamond Princess 232
- Recovered 51
- London, ON 34
- Toronto, ON 34
- Montreal, QC 13
- Calgary, Alberta 3
- Edmonton, Alberta 2
country_or_region 1
- Canada · 3,926 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2701276 | 2701276 | 2020-11-20 | Canada | Alberta | 43952 | 462 | 32835 | 10655 | 53.9333 | -116.5765 | 2020-11-21 05:25:51 | Alberta, Canada | ||
2701277 | 2701277 | 2020-11-20 | Canada | British Columbia | 25474 | 331 | 18021 | 7122 | 53.7267 | -127.6476 | 2020-11-21 05:25:51 | British Columbia, Canada | ||
2701278 | 2701278 | 2020-11-20 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-11-21 05:25:51 | Diamond Princess, Canada | ||
2701279 | 2701279 | 2020-11-20 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-11-21 05:25:51 | Grand Princess, Canada | ||
2701280 | 2701280 | 2020-11-20 | Canada | Manitoba | 12919 | 207 | 4851 | 7861 | 53.7609 | -98.8139 | 2020-11-21 05:25:51 | Manitoba, Canada | ||
2701281 | 2701281 | 2020-11-20 | Canada | New Brunswick | 401 | 6 | 344 | 51 | 46.5653 | -66.4619 | 2020-11-21 05:25:51 | New Brunswick, Canada | ||
2701282 | 2701282 | 2020-11-20 | Canada | Newfoundland and Labrador | 311 | 4 | 294 | 13 | 53.1355 | -57.6604 | 2020-11-21 05:25:51 | Newfoundland and Labrador, Canada | ||
2701283 | 2701283 | 2020-11-20 | Canada | Northwest Territories | 15 | 0 | 10 | 5 | 64.8255 | -124.8457 | 2020-11-21 05:25:51 | Northwest Territories,Canada | ||
2701284 | 2701284 | 2020-11-20 | Canada | Nova Scotia | 1160 | 65 | 1067 | 28 | 44.682 | -63.7443 | 2020-11-21 05:25:51 | Nova Scotia, Canada | ||
2701285 | 2701285 | 2020-11-20 | Canada | Nunavut | 82 | 0 | 0 | 82 | 70.2998 | -83.1076 | 2020-11-21 05:25:51 | Nunavut, Canada | ||
2701286 | 2701286 | 2020-11-20 | Canada | Ontario | 104667 | 3451 | 89280 | 11526 | 51.2538 | -85.3232 | 2020-11-21 05:25:51 | Ontario, Canada | ||
2701287 | 2701287 | 2020-11-20 | Canada | Prince Edward Island | 68 | 0 | 65 | 3 | 46.5107 | -63.4168 | 2020-11-21 05:25:51 | Prince Edward Island, Canada | ||
2701288 | 2701288 | 2020-11-20 | Canada | Quebec | 130821 | 6850 | 111326 | 12645 | 52.9399 | -73.5491 | 2020-11-21 05:25:51 | Quebec, Canada | ||
2701289 | 2701289 | 2020-11-20 | Canada | Saskatchewan | 5804 | 33 | 3626 | 2145 | 52.9399 | -106.4509 | 2020-11-21 05:25:51 | Saskatchewan, Canada | ||
2701290 | 2701290 | 2020-11-20 | Canada | Yukon | 29 | 1 | 22 | 6 | 64.2823 | -135.0 | 2020-11-21 05:25:51 | Yukon, Canada | ||
821336 | 821336 | 2020-11-19 | Canada | Alberta | 42797 | 451 | 31964 | 10382 | 53.9333 | -116.5765 | 2020-11-20 05:26:28 | Alberta, Canada | ||
821337 | 821337 | 2020-11-19 | Canada | British Columbia | 24960 | 321 | 17710 | 6929 | 53.7267 | -127.6476 | 2020-11-20 05:26:28 | British Columbia, Canada | ||
821338 | 821338 | 2020-11-19 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-11-20 05:26:28 | Diamond Princess, Canada | ||
821339 | 821339 | 2020-11-19 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-11-20 05:26:28 | Grand Princess, Canada | ||
821340 | 821340 | 2020-11-19 | Canada | Manitoba | 12482 | 198 | 4655 | 7629 | 53.7609 | -98.8139 | 2020-11-20 05:26:28 | Manitoba, Canada | ||
821341 | 821341 | 2020-11-19 | Canada | New Brunswick | 392 | 6 | 343 | 43 | 46.5653 | -66.4619 | 2020-11-20 05:26:28 | New Brunswick, Canada | ||
821342 | 821342 | 2020-11-19 | Canada | Newfoundland and Labrador | 308 | 4 | 294 | 10 | 53.1355 | -57.6604 | 2020-11-20 05:26:28 | Newfoundland and Labrador, Canada | ||
821343 | 821343 | 2020-11-19 | Canada | Northwest Territories | 15 | 0 | 10 | 5 | 64.8255 | -124.8457 | 2020-11-20 05:26:28 | Northwest Territories,Canada | ||
821344 | 821344 | 2020-11-19 | Canada | Nova Scotia | 1155 | 65 | 1067 | 23 | 44.682 | -63.7443 | 2020-11-20 05:26:28 | Nova Scotia, Canada | ||
821345 | 821345 | 2020-11-19 | Canada | Nunavut | 72 | 0 | 0 | 72 | 70.2998 | -83.1076 | 2020-11-20 05:26:28 | Nunavut, Canada | ||
821346 | 821346 | 2020-11-19 | Canada | Ontario | 103029 | 3443 | 87814 | 11562 | 51.2538 | -85.3232 | 2020-11-20 05:26:28 | Ontario, Canada | ||
821347 | 821347 | 2020-11-19 | Canada | Prince Edward Island | 68 | 0 | 65 | 3 | 46.5107 | -63.4168 | 2020-11-20 05:26:28 | Prince Edward Island, Canada | ||
821348 | 821348 | 2020-11-19 | Canada | Quebec | 129674 | 6824 | 109800 | 13050 | 52.9399 | -73.5491 | 2020-11-20 05:26:28 | Quebec, Canada | ||
821349 | 821349 | 2020-11-19 | Canada | Saskatchewan | 5651 | 32 | 3553 | 2066 | 52.9399 | -106.4509 | 2020-11-20 05:26:28 | Saskatchewan, Canada | ||
821350 | 821350 | 2020-11-19 | Canada | Yukon | 27 | 1 | 22 | 4 | 64.2823 | -135.0 | 2020-11-20 05:26:28 | Yukon, Canada | ||
122470 | 122470 | 2020-11-18 | Canada | Alberta | 41692 | 443 | 31192 | 10057 | 53.9333 | -116.5765 | 2020-11-19 05:25:23 | Alberta, Canada | ||
122471 | 122471 | 2020-11-18 | Canada | British Columbia | 24422 | 320 | 17241 | 6861 | 53.7267 | -127.6476 | 2020-11-19 05:25:23 | British Columbia, Canada | ||
122472 | 122472 | 2020-11-18 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-11-19 05:25:23 | Diamond Princess, Canada | ||
122473 | 122473 | 2020-11-18 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-11-19 05:25:23 | Grand Princess, Canada | ||
122474 | 122474 | 2020-11-18 | Canada | Manitoba | 12007 | 190 | 4432 | 7385 | 53.7609 | -98.8139 | 2020-11-19 05:25:23 | Manitoba, Canada | ||
122475 | 122475 | 2020-11-18 | Canada | New Brunswick | 388 | 6 | 342 | 40 | 46.5653 | -66.4619 | 2020-11-19 05:25:23 | New Brunswick, Canada | ||
122476 | 122476 | 2020-11-18 | Canada | Newfoundland and Labrador | 307 | 4 | 294 | 9 | 53.1355 | -57.6604 | 2020-11-19 05:25:23 | Newfoundland and Labrador, Canada | ||
122477 | 122477 | 2020-11-18 | Canada | Northwest Territories | 15 | 0 | 10 | 5 | 64.8255 | -124.8457 | 2020-11-19 05:25:23 | Northwest Territories,Canada | ||
122478 | 122478 | 2020-11-18 | Canada | Nova Scotia | 1154 | 65 | 1065 | 24 | 44.682 | -63.7443 | 2020-11-19 05:25:23 | Nova Scotia, Canada | ||
122479 | 122479 | 2020-11-18 | Canada | Nunavut | 68 | 0 | 0 | 68 | 70.2998 | -83.1076 | 2020-11-19 05:25:23 | Nunavut, Canada | ||
122480 | 122480 | 2020-11-18 | Canada | Ontario | 101550 | 3415 | 86366 | 11676 | 51.2538 | -85.3232 | 2020-11-19 05:25:23 | Ontario, Canada | ||
122481 | 122481 | 2020-11-18 | Canada | Prince Edward Island | 68 | 0 | 65 | 3 | 46.5107 | -63.4168 | 2020-11-19 05:25:23 | Prince Edward Island, Canada | ||
122482 | 122482 | 2020-11-18 | Canada | Quebec | 128366 | 6796 | 108625 | 12945 | 52.9399 | -73.5491 | 2020-11-19 05:25:23 | Quebec, Canada | ||
122483 | 122483 | 2020-11-18 | Canada | Saskatchewan | 5553 | 32 | 3422 | 2099 | 52.9399 | -106.4509 | 2020-11-19 05:25:23 | Saskatchewan, Canada | ||
122484 | 122484 | 2020-11-18 | Canada | Yukon | 25 | 1 | 22 | 2 | 64.2823 | -135.0 | 2020-11-19 05:25:23 | Yukon, Canada | ||
3338358 | 3338358 | 2020-11-17 | Canada | Alberta | 40962 | 432 | 30462 | 10068 | 53.9333 | -116.5765 | 2020-11-18 05:40:31 | Alberta, Canada | ||
3338359 | 3338359 | 2020-11-17 | Canada | British Columbia | 23662 | 310 | 16763 | 6589 | 53.7267 | -127.6476 | 2020-11-18 05:40:31 | British Columbia, Canada | ||
3338360 | 3338360 | 2020-11-17 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-11-18 05:40:31 | Diamond Princess, Canada | ||
3338361 | 3338361 | 2020-11-17 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-11-18 05:40:31 | Grand Princess, Canada | ||
3338362 | 3338362 | 2020-11-17 | Canada | Manitoba | 11608 | 179 | 4324 | 7105 | 53.7609 | -98.8139 | 2020-11-18 05:40:31 | Manitoba, Canada | ||
3338363 | 3338363 | 2020-11-17 | Canada | New Brunswick | 379 | 6 | 341 | 32 | 46.5653 | -66.4619 | 2020-11-18 05:40:31 | New Brunswick, Canada | ||
3338364 | 3338364 | 2020-11-17 | Canada | Newfoundland and Labrador | 305 | 4 | 292 | 9 | 53.1355 | -57.6604 | 2020-11-18 05:40:31 | Newfoundland and Labrador, Canada | ||
3338365 | 3338365 | 2020-11-17 | Canada | Northwest Territories | 15 | 0 | 10 | 5 | 64.8255 | -124.8457 | 2020-11-18 05:40:31 | Northwest Territories,Canada | ||
3338366 | 3338366 | 2020-11-17 | Canada | Nova Scotia | 1151 | 65 | 1062 | 24 | 44.682 | -63.7443 | 2020-11-18 05:40:31 | Nova Scotia, Canada | ||
3338367 | 3338367 | 2020-11-17 | Canada | Nunavut | 58 | 0 | 0 | 58 | 70.2998 | -83.1076 | 2020-11-18 05:40:31 | Nunavut, Canada | ||
3338368 | 3338368 | 2020-11-17 | Canada | Ontario | 100085 | 3383 | 84843 | 11939 | 51.2538 | -85.3232 | 2020-11-18 05:40:31 | Ontario, Canada | ||
3338369 | 3338369 | 2020-11-17 | Canada | Prince Edward Island | 68 | 0 | 65 | 3 | 46.5107 | -63.4168 | 2020-11-18 05:40:31 | Prince Edward Island, Canada | ||
3338370 | 3338370 | 2020-11-17 | Canada | Quebec | 127162 | 6759 | 107326 | 13077 | 52.9399 | -73.5491 | 2020-11-18 05:40:31 | Quebec, Canada | ||
3338371 | 3338371 | 2020-11-17 | Canada | Saskatchewan | 5422 | 31 | 3336 | 2055 | 52.9399 | -106.4509 | 2020-11-18 05:40:31 | Saskatchewan, Canada | ||
3338372 | 3338372 | 2020-11-17 | Canada | Yukon | 24 | 1 | 22 | 1 | 64.2823 | -135.0 | 2020-11-18 05:40:31 | Yukon, Canada | ||
3169403 | 3169403 | 2020-11-16 | Canada | Alberta | 40189 | 427 | 29731 | 10031 | 53.9333 | -116.5765 | 2020-11-17 05:25:54 | Alberta, Canada | ||
3169404 | 3169404 | 2020-11-16 | Canada | British Columbia | 22945 | 299 | 16367 | 6279 | 53.7267 | -127.6476 | 2020-11-17 05:25:54 | British Columbia, Canada | ||
3169405 | 3169405 | 2020-11-16 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-11-17 05:25:54 | Diamond Princess, Canada | ||
3169406 | 3169406 | 2020-11-16 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-11-17 05:25:54 | Grand Princess, Canada | ||
3169407 | 3169407 | 2020-11-16 | Canada | Manitoba | 11339 | 172 | 4156 | 7011 | 53.7609 | -98.8139 | 2020-11-17 05:25:54 | Manitoba, Canada | ||
3169408 | 3169408 | 2020-11-16 | Canada | New Brunswick | 375 | 6 | 341 | 28 | 46.5653 | -66.4619 | 2020-11-17 05:25:54 | New Brunswick, Canada | ||
3169409 | 3169409 | 2020-11-16 | Canada | Newfoundland and Labrador | 303 | 4 | 289 | 10 | 53.1355 | -57.6604 | 2020-11-17 05:25:54 | Newfoundland and Labrador, Canada | ||
3169410 | 3169410 | 2020-11-16 | Canada | Northwest Territories | 15 | 0 | 10 | 5 | 64.8255 | -124.8457 | 2020-11-17 05:25:54 | Northwest Territories,Canada | ||
3169411 | 3169411 | 2020-11-16 | Canada | Nova Scotia | 1146 | 65 | 1058 | 23 | 44.682 | -63.7443 | 2020-11-17 05:25:54 | Nova Scotia, Canada | ||
3169412 | 3169412 | 2020-11-16 | Canada | Nunavut | 24 | 0 | 0 | 24 | 70.2998 | -83.1076 | 2020-11-17 05:25:54 | Nunavut, Canada | ||
3169413 | 3169413 | 2020-11-16 | Canada | Ontario | 98832 | 3371 | 83427 | 11933 | 51.2538 | -85.3232 | 2020-11-17 05:25:54 | Ontario, Canada | ||
3169414 | 3169414 | 2020-11-16 | Canada | Prince Edward Island | 68 | 0 | 64 | 4 | 46.5107 | -63.4168 | 2020-11-17 05:25:54 | Prince Edward Island, Canada | ||
3169415 | 3169415 | 2020-11-16 | Canada | Quebec | 126036 | 6728 | 105998 | 13310 | 52.9399 | -73.5491 | 2020-11-17 05:25:54 | Quebec, Canada | ||
3169416 | 3169416 | 2020-11-16 | Canada | Saskatchewan | 5182 | 31 | 3223 | 1928 | 52.9399 | -106.4509 | 2020-11-17 05:25:54 | Saskatchewan, Canada | ||
3169417 | 3169417 | 2020-11-16 | Canada | Yukon | 24 | 1 | 22 | 1 | 64.2823 | -135.0 | 2020-11-17 05:25:54 | Yukon, Canada | ||
2879971 | 2879971 | 2020-11-15 | Canada | Alberta | 39329 | 407 | 29304 | 9618 | 53.9333 | -116.5765 | 2020-11-16 05:25:57 | Alberta, Canada | ||
2879972 | 2879972 | 2020-11-15 | Canada | British Columbia | 20986 | 290 | 15117 | 5579 | 53.7267 | -127.6476 | 2020-11-16 05:25:57 | British Columbia, Canada | ||
2879973 | 2879973 | 2020-11-15 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-11-16 05:25:57 | Diamond Princess, Canada | ||
2879974 | 2879974 | 2020-11-15 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-11-16 05:25:57 | Grand Princess, Canada | ||
2879975 | 2879975 | 2020-11-15 | Canada | Manitoba | 10947 | 162 | 4070 | 6715 | 53.7609 | -98.8139 | 2020-11-16 05:25:57 | Manitoba, Canada | ||
2879976 | 2879976 | 2020-11-15 | Canada | New Brunswick | 367 | 6 | 339 | 22 | 46.5653 | -66.4619 | 2020-11-16 05:25:57 | New Brunswick, Canada | ||
2879977 | 2879977 | 2020-11-15 | Canada | Newfoundland and Labrador | 303 | 4 | 289 | 10 | 53.1355 | -57.6604 | 2020-11-16 05:25:57 | Newfoundland and Labrador, Canada | ||
2879978 | 2879978 | 2020-11-15 | Canada | Northwest Territories | 15 | 0 | 10 | 5 | 64.8255 | -124.8457 | 2020-11-16 05:25:57 | Northwest Territories,Canada | ||
2879979 | 2879979 | 2020-11-15 | Canada | Nova Scotia | 1144 | 65 | 1058 | 21 | 44.682 | -63.7443 | 2020-11-16 05:25:57 | Nova Scotia, Canada | ||
2879980 | 2879980 | 2020-11-15 | Canada | Nunavut | 18 | 0 | 0 | 18 | 70.2998 | -83.1076 | 2020-11-16 05:25:57 | Nunavut, Canada | ||
2879981 | 2879981 | 2020-11-15 | Canada | Ontario | 97447 | 3361 | 82137 | 11826 | 51.2538 | -85.3232 | 2020-11-16 05:25:57 | Ontario, Canada | ||
2879982 | 2879982 | 2020-11-15 | Canada | Prince Edward Island | 68 | 0 | 64 | 4 | 46.5107 | -63.4168 | 2020-11-16 05:25:57 | Prince Edward Island, Canada | ||
2879983 | 2879983 | 2020-11-15 | Canada | Quebec | 125011 | 6703 | 104848 | 13460 | 52.9399 | -73.5491 | 2020-11-16 05:25:57 | Quebec, Canada | ||
2879984 | 2879984 | 2020-11-15 | Canada | Saskatchewan | 5001 | 31 | 3163 | 1807 | 52.9399 | -106.4509 | 2020-11-16 05:25:57 | Saskatchewan, Canada | ||
2879985 | 2879985 | 2020-11-15 | Canada | Yukon | 24 | 1 | 22 | 1 | 64.2823 | -135.0 | 2020-11-16 05:25:57 | Yukon, Canada | ||
2914949 | 2914949 | 2020-11-14 | Canada | Alberta | 38338 | 401 | 28321 | 9616 | 53.9333 | -116.5765 | 2020-11-15 05:26:53 | Alberta, Canada | ||
2914950 | 2914950 | 2020-11-14 | Canada | British Columbia | 20986 | 290 | 15117 | 5579 | 53.7267 | -127.6476 | 2020-11-15 05:26:53 | British Columbia, Canada | ||
2914951 | 2914951 | 2020-11-14 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-11-15 05:26:53 | Diamond Princess, Canada | ||
2914952 | 2914952 | 2020-11-14 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-11-15 05:26:53 | Grand Princess, Canada | ||
2914953 | 2914953 | 2020-11-14 | Canada | Manitoba | 10453 | 152 | 3891 | 6410 | 53.7609 | -98.8139 | 2020-11-15 05:26:53 | Manitoba, Canada | ||
2914954 | 2914954 | 2020-11-14 | Canada | New Brunswick | 364 | 6 | 339 | 19 | 46.5653 | -66.4619 | 2020-11-15 05:26:53 | New Brunswick, Canada | ||
2914955 | 2914955 | 2020-11-14 | Canada | Newfoundland and Labrador | 301 | 4 | 289 | 8 | 53.1355 | -57.6604 | 2020-11-15 05:26:53 | Newfoundland and Labrador, Canada | ||
2914956 | 2914956 | 2020-11-14 | Canada | Northwest Territories | 15 | 0 | 10 | 5 | 64.8255 | -124.8457 | 2020-11-15 05:26:53 | Northwest Territories,Canada | ||
2914957 | 2914957 | 2020-11-14 | Canada | Nova Scotia | 1142 | 65 | 1056 | 21 | 44.682 | -63.7443 | 2020-11-15 05:26:53 | Nova Scotia, Canada | ||
2914958 | 2914958 | 2020-11-14 | Canada | Nunavut | 8 | 0 | 0 | 8 | 70.2998 | -83.1076 | 2020-11-15 05:26:53 | 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]);