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 rowid descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state 22
- British Columbia 1,061
- Ontario 1,029
- Alberta 1,020
- Quebec 1,019
- New Brunswick 1,018
- Manitoba 1,016
- Saskatchewan 1,015
- Newfoundland and Labrador 1,014
- Prince Edward Island 1,013
- Nova Scotia 1,010
- Grand Princess 1,009
- Northwest Territories 1,005
- Nunavut 1,004
- Yukon 1,002
- Diamond Princess 995
- Repatriated Travellers 760
- Recovered 51
- London, ON 34
- Toronto, ON 34
- Montreal, QC 13
- Calgary, Alberta 3
- Edmonton, Alberta 2
country_or_region 1
- Canada · 16,127 ✖
Link | rowid ▲ | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3978351 | 3978351 | 2021-02-10 | Canada | Ontario | 285018 | 6596 | 267422 | 12301 | 51.2538 | -85.3232 | 2021-02-11 05:23:55 | Ontario, Canada | ||
3978350 | 3978350 | 2021-02-10 | Canada | Nunavut | 300 | 1 | 293 | 6 | 70.2998 | -83.1076 | 2021-02-11 05:23:55 | Nunavut, Canada | ||
3978349 | 3978349 | 2021-02-10 | Canada | Nova Scotia | 1588 | 65 | 1514 | 9 | 44.682 | -63.7443 | 2021-02-11 05:23:55 | Nova Scotia, Canada | ||
3978348 | 3978348 | 2021-02-10 | Canada | Northwest Territories | 34 | 0 | 36 | 3 | 64.8255 | -124.8457 | 2021-02-11 05:23:55 | Northwest Territories,Canada | ||
3978347 | 3978347 | 2021-02-10 | Canada | Newfoundland and Labrador | 510 | 4 | 393 | 113 | 53.1355 | -57.6604 | 2021-02-11 05:23:55 | Newfoundland and Labrador, Canada | ||
3978346 | 3978346 | 2021-02-10 | Canada | New Brunswick | 1375 | 21 | 1178 | 176 | 46.5653 | -66.4619 | 2021-02-11 05:23:55 | New Brunswick, Canada | ||
3978345 | 3978345 | 2021-02-10 | Canada | Manitoba | 30417 | 859 | 27985 | 1573 | 53.7609 | -98.8139 | 2021-02-11 05:23:55 | Manitoba, Canada | ||
3978344 | 3978344 | 2021-02-10 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | ||
3978343 | 3978343 | 2021-02-10 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
3978342 | 3978342 | 2021-02-10 | Canada | British Columbia | 71856 | 1269 | 66167 | 4420 | 53.7267 | -127.6476 | 2021-02-11 05:23:55 | British Columbia, Canada | ||
3978341 | 3978341 | 2021-02-10 | Canada | Alberta | 127570 | 1728 | 120136 | 5706 | 53.9333 | -116.5765 | 2021-02-11 05:23:55 | Alberta, Canada | ||
3974342 | 3974342 | 2021-09-03 | Canada | Yukon | 694 | 8 | 0 | 64.2823 | -135.0 | 2021-09-04 04:21:28 | Yukon, Canada | |||
3974341 | 3974341 | 2021-09-03 | Canada | Saskatchewan | 55396 | 610 | 0 | 52.9399 | -106.4509 | 2021-09-04 04:21:28 | Saskatchewan, Canada | |||
3974340 | 3974340 | 2021-09-03 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-09-04 04:21:28 | Repatriated Travellers, Canada | |||||
3974339 | 3974339 | 2021-09-03 | Canada | Quebec | 391363 | 11291 | 0 | 52.9399 | -73.5491 | 2021-09-04 04:21:28 | Quebec, Canada | |||
3974338 | 3974338 | 2021-09-03 | Canada | Prince Edward Island | 233 | 0 | 0 | 46.5107 | -63.4168 | 2021-09-04 04:21:28 | Prince Edward Island, Canada | |||
3974337 | 3974337 | 2021-09-03 | Canada | Ontario | 573220 | 9536 | 0 | 51.2538 | -85.3232 | 2021-09-04 04:21:28 | Ontario, Canada | |||
3974336 | 3974336 | 2021-09-03 | Canada | Nunavut | 658 | 4 | 0 | 70.2998 | -83.1076 | 2021-09-04 04:21:28 | Nunavut, Canada | |||
3974335 | 3974335 | 2021-09-03 | Canada | Nova Scotia | 6047 | 94 | 0 | 44.681999999999995 | -63.7443 | 2021-09-04 04:21:28 | Nova Scotia, Canada | |||
3974334 | 3974334 | 2021-09-03 | Canada | Northwest Territories | 486 | 1 | 0 | 64.8255 | -124.8457 | 2021-09-04 04:21:28 | Northwest Territories,Canada | |||
3974333 | 3974333 | 2021-09-03 | Canada | Newfoundland and Labrador | 1491 | 7 | 0 | 53.1355 | -57.6604 | 2021-09-04 04:21:28 | Newfoundland and Labrador, Canada | |||
3974332 | 3974332 | 2021-09-03 | Canada | New Brunswick | 2798 | 46 | 0 | 46.5653 | -66.4619 | 2021-09-04 04:21:28 | New Brunswick, Canada | |||
3974331 | 3974331 | 2021-09-03 | Canada | Manitoba | 58845 | 1192 | 0 | 53.7609 | -98.8139 | 2021-09-04 04:21:28 | Manitoba, Canada | |||
3974330 | 3974330 | 2021-09-03 | Canada | Grand Princess | 13 | 0 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | |||
3974329 | 3974329 | 2021-09-03 | Canada | Diamond Princess | 0 | 1 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | |||
3974328 | 3974328 | 2021-09-03 | Canada | British Columbia | 168325 | 1827 | 0 | 53.7267 | -127.6476 | 2021-09-04 04:21:28 | British Columbia, Canada | |||
3974327 | 3974327 | 2021-09-03 | Canada | Alberta | 256985 | 2390 | 0 | 53.9333 | -116.5765 | 2021-09-04 04:21:28 | Alberta, Canada | |||
3970328 | 3970328 | 2021-06-11 | Canada | Yukon | 98 | 2 | 82 | 14 | 64.2823 | -135.0 | 2021-06-12 04:22:22 | Yukon, Canada | ||
3970327 | 3970327 | 2021-06-11 | Canada | Saskatchewan | 47769 | 554 | 46311 | 899 | 52.9399 | -106.4509 | 2021-06-12 04:22:22 | Saskatchewan, Canada | ||
3970326 | 3970326 | 2021-06-11 | Canada | Repatriated Travellers | 13 | 0 | 13 | 0 | 2021-06-12 04:22:22 | Repatriated Travellers, Canada | ||||
3970325 | 3970325 | 2021-06-11 | Canada | Quebec | 373150 | 11167 | 359421 | 2562 | 52.9399 | -73.5491 | 2021-06-12 04:22:22 | Quebec, Canada | ||
3970324 | 3970324 | 2021-06-11 | Canada | Prince Edward Island | 206 | 0 | 202 | 4 | 46.5107 | -63.4168 | 2021-06-12 04:22:22 | Prince Edward Island, Canada | ||
3970323 | 3970323 | 2021-06-11 | Canada | Ontario | 543395 | 8935 | 531275 | 6014 | 51.2538 | -85.3232 | 2021-06-12 04:22:22 | Ontario, Canada | ||
3970322 | 3970322 | 2021-06-11 | Canada | Nunavut | 654 | 4 | 644 | 6 | 70.2998 | -83.1076 | 2021-06-12 04:22:22 | Nunavut, Canada | ||
3970321 | 3970321 | 2021-06-11 | Canada | Nova Scotia | 5726 | 89 | 5497 | 143 | 44.682 | -63.7443 | 2021-06-12 04:22:22 | Nova Scotia, Canada | ||
3970320 | 3970320 | 2021-06-11 | Canada | Northwest Territories | 128 | 0 | 128 | 0 | 64.8255 | -124.8457 | 2021-06-12 04:22:22 | Northwest Territories,Canada | ||
3970319 | 3970319 | 2021-06-11 | Canada | Newfoundland and Labrador | 1368 | 7 | 1303 | 58 | 53.1355 | -57.6604 | 2021-06-12 04:22:22 | Newfoundland and Labrador, Canada | ||
3970318 | 3970318 | 2021-06-11 | Canada | New Brunswick | 2284 | 44 | 2142 | 98 | 46.5653 | -66.4619 | 2021-06-12 04:22:22 | New Brunswick, Canada | ||
3970317 | 3970317 | 2021-06-11 | Canada | Manitoba | 53872 | 1089 | 49293 | 3490 | 53.7609 | -98.8139 | 2021-06-12 04:22:22 | Manitoba, Canada | ||
3970316 | 3970316 | 2021-06-11 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | ||
3970315 | 3970315 | 2021-06-11 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
3970314 | 3970314 | 2021-06-11 | Canada | British Columbia | 146176 | 1730 | 142526 | 1920 | 53.7267 | -127.6476 | 2021-06-12 04:22:22 | British Columbia, Canada | ||
3970313 | 3970313 | 2021-06-11 | Canada | Alberta | 230119 | 2265 | 224325 | 3529 | 53.9333 | -116.5765 | 2021-06-12 04:22:22 | Alberta, Canada | ||
3966313 | 3966313 | 2022-07-05 | Canada | Yukon | 4495 | 26 | 0 | 64.2823 | -135.0 | 2022-07-06 04:20:58 | Yukon, Canada | |||
3966312 | 3966312 | 2022-07-05 | Canada | Saskatchewan | 139663 | 1403 | 0 | 52.9399 | -106.4509 | 2022-07-06 04:20:58 | Saskatchewan, Canada | |||
3966311 | 3966311 | 2022-07-05 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-07-06 04:20:58 | Repatriated Travellers, Canada | |||||
3966310 | 3966310 | 2022-07-05 | Canada | Quebec | 1096171 | 15617 | 0 | 52.9399 | -73.5491 | 2022-07-06 04:20:58 | Quebec, Canada | |||
3966309 | 3966309 | 2022-07-05 | Canada | Prince Edward Island | 41876 | 35 | 0 | 46.5107 | -63.4168 | 2022-07-06 04:20:58 | Prince Edward Island, Canada | |||
3966308 | 3966308 | 2022-07-05 | Canada | Ontario | 1345639 | 13434 | 0 | 51.2538 | -85.3232 | 2022-07-06 04:20:58 | Ontario, Canada | |||
3966307 | 3966307 | 2022-07-05 | Canada | Nunavut | 3531 | 7 | 0 | 70.2998 | -83.1076 | 2022-07-06 04:20:58 | Nunavut, Canada | |||
3966306 | 3966306 | 2022-07-05 | Canada | Nova Scotia | 106707 | 428 | 0 | 44.682 | -63.7443 | 2022-07-06 04:20:58 | Nova Scotia, Canada | |||
3966305 | 3966305 | 2022-07-05 | Canada | Northwest Territories | 11499 | 22 | 0 | 64.8255 | -124.8457 | 2022-07-06 04:20:58 | Northwest Territories,Canada | |||
3966304 | 3966304 | 2022-07-05 | Canada | Newfoundland and Labrador | 48179 | 193 | 0 | 53.1355 | -57.6604 | 2022-07-06 04:20:58 | Newfoundland and Labrador, Canada | |||
3966303 | 3966303 | 2022-07-05 | Canada | New Brunswick | 68493 | 429 | 0 | 46.5653 | -66.4619 | 2022-07-06 04:20:58 | New Brunswick, Canada | |||
3966302 | 3966302 | 2022-07-05 | Canada | Manitoba | 145498 | 2043 | 0 | 53.7609 | -98.8139 | 2022-07-06 04:20:58 | Manitoba, Canada | |||
3966301 | 3966301 | 2022-07-05 | Canada | Grand Princess | 13 | 0 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | |||
3966300 | 3966300 | 2022-07-05 | Canada | Diamond Princess | 0 | 1 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | |||
3966299 | 3966299 | 2022-07-05 | Canada | British Columbia | 374594 | 3747 | 0 | 53.7267 | -127.6476 | 2022-07-06 04:20:58 | British Columbia, Canada | |||
3966298 | 3966298 | 2022-07-05 | Canada | Alberta | 588691 | 4621 | 0 | 53.9333 | -116.5765 | 2022-07-06 04:20:58 | Alberta, Canada | |||
3962298 | 3962298 | 2021-03-10 | Canada | Yukon | 72 | 1 | 71 | 0 | 64.2823 | -135.0 | 2021-03-11 05:25:48 | Yukon, Canada | ||
3962297 | 3962297 | 2021-03-10 | Canada | Saskatchewan | 30028 | 401 | 28244 | 1384 | 52.9399 | -106.4509 | 2021-03-11 05:25:48 | Saskatchewan, Canada | ||
3962296 | 3962296 | 2021-03-10 | Canada | Repatriated Travellers | 13 | 0 | 13 | 0 | 2021-03-11 05:25:48 | Repatriated Travellers, Canada | ||||
3962295 | 3962295 | 2021-03-10 | Canada | Quebec | 294366 | 10503 | 277185 | 6678 | 52.9399 | -73.5491 | 2021-03-11 05:25:48 | Quebec, Canada | ||
3962294 | 3962294 | 2021-03-10 | Canada | Prince Edward Island | 143 | 0 | 115 | 28 | 46.5107 | -63.4168 | 2021-03-11 05:25:48 | Prince Edward Island, Canada | ||
3962293 | 3962293 | 2021-03-10 | Canada | Ontario | 317087 | 7099 | 299822 | 10984 | 51.2538 | -85.3232 | 2021-03-11 05:25:48 | Ontario, Canada | ||
3962292 | 3962292 | 2021-03-10 | Canada | Nunavut | 381 | 1 | 358 | 22 | 70.2998 | -83.1076 | 2021-03-11 05:25:48 | Nunavut, Canada | ||
3962291 | 3962291 | 2021-03-10 | Canada | Nova Scotia | 1665 | 65 | 1576 | 24 | 44.682 | -63.7443 | 2021-03-11 05:25:48 | Nova Scotia, Canada | ||
3962290 | 3962290 | 2021-03-10 | Canada | Northwest Territories | 42 | 0 | 46 | 1 | 64.8255 | -124.8457 | 2021-03-11 05:25:48 | Northwest Territories,Canada | ||
3962289 | 3962289 | 2021-03-10 | Canada | Newfoundland and Labrador | 1010 | 6 | 926 | 78 | 53.1355 | -57.6604 | 2021-03-11 05:25:48 | Newfoundland and Labrador, Canada | ||
3962288 | 3962288 | 2021-03-10 | Canada | New Brunswick | 1460 | 29 | 1396 | 35 | 46.5653 | -66.4619 | 2021-03-11 05:25:48 | New Brunswick, Canada | ||
3962287 | 3962287 | 2021-03-10 | Canada | Manitoba | 32421 | 908 | 30328 | 1185 | 53.7609 | -98.8139 | 2021-03-11 05:25:48 | Manitoba, Canada | ||
3962286 | 3962286 | 2021-03-10 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | ||
3962285 | 3962285 | 2021-03-10 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
3962284 | 3962284 | 2021-03-10 | Canada | British Columbia | 85650 | 1394 | 79309 | 4947 | 53.7267 | -127.6476 | 2021-03-11 05:25:48 | British Columbia, Canada | ||
3962283 | 3962283 | 2021-03-10 | Canada | Alberta | 136773 | 1928 | 130382 | 4463 | 53.9333 | -116.5765 | 2021-03-11 05:25:48 | Alberta, Canada | ||
3958284 | 3958284 | 2021-06-26 | Canada | Yukon | 264 | 4 | 152 | 108 | 64.2823 | -135.0 | 2021-06-27 04:21:39 | Yukon, Canada | ||
3958283 | 3958283 | 2021-06-26 | Canada | Saskatchewan | 48706 | 566 | 47543 | 597 | 52.9399 | -106.4509 | 2021-06-27 04:21:39 | Saskatchewan, Canada | ||
3958282 | 3958282 | 2021-06-26 | Canada | Repatriated Travellers | 13 | 0 | 13 | 0 | 2021-06-27 04:21:39 | Repatriated Travellers, Canada | ||||
3958281 | 3958281 | 2021-06-26 | Canada | Quebec | 374872 | 11202 | 362130 | 1540 | 52.9399 | -73.5491 | 2021-06-27 04:21:39 | Quebec, Canada | ||
3958280 | 3958280 | 2021-06-26 | Canada | Prince Edward Island | 206 | 0 | 206 | 0 | 46.5107 | -63.4168 | 2021-06-27 04:21:39 | Prince Edward Island, Canada | ||
3958279 | 3958279 | 2021-06-26 | Canada | Ontario | 548125 | 9114 | 539256 | 3024 | 51.2538 | -85.3232 | 2021-06-27 04:21:39 | Ontario, Canada | ||
3958278 | 3958278 | 2021-06-26 | Canada | Nunavut | 657 | 4 | 653 | 0 | 70.2998 | -83.1076 | 2021-06-27 04:21:39 | Nunavut, Canada | ||
3958277 | 3958277 | 2021-06-26 | Canada | Nova Scotia | 5825 | 92 | 5671 | 62 | 44.682 | -63.7443 | 2021-06-27 04:21:39 | Nova Scotia, Canada | ||
3958276 | 3958276 | 2021-06-26 | Canada | Northwest Territories | 128 | 0 | 128 | 0 | 64.8255 | -124.8457 | 2021-06-27 04:21:39 | Northwest Territories,Canada | ||
3958275 | 3958275 | 2021-06-26 | Canada | Newfoundland and Labrador | 1384 | 7 | 1366 | 11 | 53.1355 | -57.6604 | 2021-06-27 04:21:39 | Newfoundland and Labrador, Canada | ||
3958274 | 3958274 | 2021-06-26 | Canada | New Brunswick | 2324 | 45 | 2245 | 34 | 46.5653 | -66.4619 | 2021-06-27 04:21:39 | New Brunswick, Canada | ||
3958273 | 3958273 | 2021-06-26 | Canada | Manitoba | 55879 | 1138 | 53227 | 1514 | 53.7609 | -98.8139 | 2021-06-27 04:21:39 | Manitoba, Canada | ||
3958272 | 3958272 | 2021-06-26 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | ||
3958271 | 3958271 | 2021-06-26 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
3958270 | 3958270 | 2021-06-26 | Canada | British Columbia | 147418 | 1749 | 144554 | 1115 | 53.7267 | -127.6476 | 2021-06-27 04:21:39 | British Columbia, Canada | ||
3958269 | 3958269 | 2021-06-26 | Canada | Alberta | 231641 | 2293 | 227768 | 1580 | 53.9333 | -116.5765 | 2021-06-27 04:21:39 | Alberta, Canada | ||
3954270 | 3954270 | 2021-05-11 | Canada | Yukon | 84 | 2 | 80 | 2 | 64.2823 | -135.0 | 2021-05-12 04:21:29 | Yukon, Canada | ||
3954269 | 3954269 | 2021-05-11 | Canada | Saskatchewan | 43490 | 506 | 40911 | 2064 | 52.9399 | -106.4509 | 2021-05-12 04:21:29 | Saskatchewan, Canada | ||
3954268 | 3954268 | 2021-05-11 | Canada | Repatriated Travellers | 13 | 0 | 13 | 0 | 2021-05-12 04:21:29 | Repatriated Travellers, Canada | ||||
3954267 | 3954267 | 2021-05-11 | Canada | Quebec | 360134 | 11002 | 340637 | 8495 | 52.9399 | -73.5491 | 2021-05-12 04:21:29 | Quebec, Canada | ||
3954266 | 3954266 | 2021-05-11 | Canada | Prince Edward Island | 187 | 0 | 179 | 8 | 46.5107 | -63.4168 | 2021-05-12 04:21:29 | Prince Edward Island, Canada | ||
3954265 | 3954265 | 2021-05-11 | Canada | Ontario | 505056 | 8342 | 470083 | 26939 | 51.2538 | -85.3232 | 2021-05-12 04:21:29 | Ontario, Canada | ||
3954264 | 3954264 | 2021-05-11 | Canada | Nunavut | 586 | 4 | 507 | 75 | 70.2998 | -83.1076 | 2021-05-12 04:21:29 | Nunavut, Canada | ||
3954263 | 3954263 | 2021-05-11 | Canada | Nova Scotia | 4152 | 71 | 2490 | 1591 | 44.682 | -63.7443 | 2021-05-12 04:21:29 | Nova Scotia, Canada | ||
3954262 | 3954262 | 2021-05-11 | Canada | Northwest Territories | 112 | 0 | 57 | 61 | 64.8255 | -124.8457 | 2021-05-12 04:21:29 | Northwest Territories,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]);