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 717
- Ontario 685
- Alberta 676
- Quebec 676
- New Brunswick 674
- Manitoba 672
- Saskatchewan 672
- Newfoundland and Labrador 670
- Prince Edward Island 670
- Nova Scotia 666
- Grand Princess 665
- Northwest Territories 661
- Nunavut 660
- Yukon 659
- Diamond Princess 651
- Repatriated Travellers 416
- Recovered 51
- London, ON 34
- Toronto, ON 34
- Montreal, QC 13
- Calgary, Alberta 3
- Edmonton, Alberta 2
country_or_region 1
- Canada · 10,627 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3687228 | 3687228 | 2022-01-13 | Canada | Alberta | 430332 | 3375 | 0 | 53.9333 | -116.5765 | 2022-01-14 04:21:54 | Alberta, Canada | |||
3687229 | 3687229 | 2022-01-13 | Canada | British Columbia | 291246 | 2462 | 0 | 53.7267 | -127.6476 | 2022-01-14 04:21:54 | British Columbia, Canada | |||
3687230 | 3687230 | 2022-01-13 | Canada | Diamond Princess | 0 | 1 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | |||
3687231 | 3687231 | 2022-01-13 | Canada | Grand Princess | 13 | 0 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | |||
3687232 | 3687232 | 2022-01-13 | Canada | Manitoba | 106627 | 1438 | 0 | 53.7609 | -98.8139 | 2022-01-14 04:21:54 | Manitoba, Canada | |||
3687233 | 3687233 | 2022-01-13 | Canada | New Brunswick | 21553 | 178 | 0 | 46.5653 | -66.4619 | 2022-01-14 04:21:54 | New Brunswick, Canada | |||
3687234 | 3687234 | 2022-01-13 | Canada | Newfoundland and Labrador | 11617 | 23 | 0 | 53.1355 | -57.6604 | 2022-01-14 04:21:54 | Newfoundland and Labrador, Canada | |||
3687235 | 3687235 | 2022-01-13 | Canada | Northwest Territories | 3587 | 12 | 0 | 64.8255 | -124.8457 | 2022-01-14 04:21:54 | Northwest Territories,Canada | |||
3687236 | 3687236 | 2022-01-13 | Canada | Nova Scotia | 28194 | 117 | 0 | 44.681999999999995 | -63.7443 | 2022-01-14 04:21:54 | Nova Scotia, Canada | |||
3687237 | 3687237 | 2022-01-13 | Canada | Nunavut | 1048 | 4 | 0 | 70.2998 | -83.1076 | 2022-01-14 04:21:54 | Nunavut, Canada | |||
3687238 | 3687238 | 2022-01-13 | Canada | Ontario | 949419 | 10480 | 0 | 51.2538 | -85.3232 | 2022-01-14 04:21:54 | Ontario, Canada | |||
3687239 | 3687239 | 2022-01-13 | Canada | Prince Edward Island | 3427 | 0 | 0 | 46.5107 | -63.4168 | 2022-01-14 04:21:54 | Prince Edward Island, Canada | |||
3687240 | 3687240 | 2022-01-13 | Canada | Quebec | 766926 | 12125 | 0 | 52.9399 | -73.5491 | 2022-01-14 04:21:54 | Quebec, Canada | |||
3687241 | 3687241 | 2022-01-13 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-01-14 04:21:54 | Repatriated Travellers, Canada | |||||
3687242 | 3687242 | 2022-01-13 | Canada | Saskatchewan | 96115 | 961 | 0 | 52.9399 | -106.4509 | 2022-01-14 04:21:54 | Saskatchewan, Canada | |||
3687243 | 3687243 | 2022-01-13 | Canada | Yukon | 2571 | 15 | 0 | 64.2823 | -135.0 | 2022-01-14 04:21:54 | Yukon, Canada | |||
3612812 | 3612812 | 2022-01-12 | Canada | Alberta | 424322 | 3367 | 0 | 53.9333 | -116.5765 | 2022-01-13 08:00:09 | Alberta, Canada | |||
3612813 | 3612813 | 2022-01-12 | Canada | British Columbia | 288692 | 2455 | 0 | 53.7267 | -127.6476 | 2022-01-13 08:00:09 | British Columbia, Canada | |||
3612814 | 3612814 | 2022-01-12 | Canada | Diamond Princess | 0 | 1 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | |||
3612815 | 3612815 | 2022-01-12 | Canada | Grand Princess | 13 | 0 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | |||
3612816 | 3612816 | 2022-01-12 | Canada | Manitoba | 105406 | 1429 | 0 | 53.7609 | -98.8139 | 2022-01-13 08:00:09 | Manitoba, Canada | |||
3612817 | 3612817 | 2022-01-12 | Canada | New Brunswick | 21249 | 174 | 0 | 46.5653 | -66.4619 | 2022-01-13 08:00:09 | New Brunswick, Canada | |||
3612818 | 3612818 | 2022-01-12 | Canada | Newfoundland and Labrador | 10931 | 23 | 0 | 53.1355 | -57.6604 | 2022-01-13 08:00:09 | Newfoundland and Labrador, Canada | |||
3612819 | 3612819 | 2022-01-12 | Canada | Northwest Territories | 3467 | 12 | 0 | 64.8255 | -124.8457 | 2022-01-13 08:00:09 | Northwest Territories,Canada | |||
3612820 | 3612820 | 2022-01-12 | Canada | Nova Scotia | 27357 | 115 | 0 | 44.681999999999995 | -63.7443 | 2022-01-13 08:00:09 | Nova Scotia, Canada | |||
3612821 | 3612821 | 2022-01-12 | Canada | Nunavut | 1036 | 4 | 0 | 70.2998 | -83.1076 | 2022-01-13 08:00:09 | Nunavut, Canada | |||
3612822 | 3612822 | 2022-01-12 | Canada | Ontario | 938924 | 10445 | 0 | 51.2538 | -85.3232 | 2022-01-13 08:00:09 | Ontario, Canada | |||
3612823 | 3612823 | 2022-01-12 | Canada | Prince Edward Island | 3427 | 0 | 0 | 46.5107 | -63.4168 | 2022-01-13 08:00:09 | Prince Edward Island, Canada | |||
3612824 | 3612824 | 2022-01-12 | Canada | Quebec | 758575 | 12080 | 0 | 52.9399 | -73.5491 | 2022-01-13 08:00:09 | Quebec, Canada | |||
3612825 | 3612825 | 2022-01-12 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-01-13 08:00:09 | Repatriated Travellers, Canada | |||||
3612826 | 3612826 | 2022-01-12 | Canada | Saskatchewan | 95174 | 961 | 0 | 52.9399 | -106.4509 | 2022-01-13 08:00:09 | Saskatchewan, Canada | |||
3612827 | 3612827 | 2022-01-12 | Canada | Yukon | 2515 | 15 | 0 | 64.2823 | -135.0 | 2022-01-13 08:00:09 | Yukon, Canada | |||
1113337 | 1113337 | 2022-01-11 | Canada | Alberta | 417533 | 3352 | 0 | 53.9333 | -116.5765 | 2022-01-12 04:21:44 | Alberta, Canada | |||
1113338 | 1113338 | 2022-01-11 | Canada | British Columbia | 286080 | 2449 | 0 | 53.7267 | -127.6476 | 2022-01-12 04:21:44 | British Columbia, Canada | |||
1113339 | 1113339 | 2022-01-11 | Canada | Diamond Princess | 0 | 1 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | |||
1113340 | 1113340 | 2022-01-11 | Canada | Grand Princess | 13 | 0 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | |||
1113341 | 1113341 | 2022-01-11 | Canada | Manitoba | 103935 | 1426 | 0 | 53.7609 | -98.8139 | 2022-01-12 04:21:44 | Manitoba, Canada | |||
1113342 | 1113342 | 2022-01-11 | Canada | New Brunswick | 20890 | 173 | 0 | 46.5653 | -66.4619 | 2022-01-12 04:21:44 | New Brunswick, Canada | |||
1113343 | 1113343 | 2022-01-11 | Canada | Newfoundland and Labrador | 10201 | 23 | 0 | 53.1355 | -57.6604 | 2022-01-12 04:21:44 | Newfoundland and Labrador, Canada | |||
1113344 | 1113344 | 2022-01-11 | Canada | Northwest Territories | 3322 | 12 | 0 | 64.8255 | -124.8457 | 2022-01-12 04:21:44 | Northwest Territories,Canada | |||
1113345 | 1113345 | 2022-01-11 | Canada | Nova Scotia | 26741 | 114 | 0 | 44.681999999999995 | -63.7443 | 2022-01-12 04:21:44 | Nova Scotia, Canada | |||
1113346 | 1113346 | 2022-01-11 | Canada | Nunavut | 1033 | 4 | 0 | 70.2998 | -83.1076 | 2022-01-12 04:21:44 | Nunavut, Canada | |||
1113347 | 1113347 | 2022-01-11 | Canada | Ontario | 927308 | 10399 | 0 | 51.2538 | -85.3232 | 2022-01-12 04:21:44 | Ontario, Canada | |||
1113348 | 1113348 | 2022-01-11 | Canada | Prince Edward Island | 2893 | 0 | 0 | 46.5107 | -63.4168 | 2022-01-12 04:21:44 | Prince Edward Island, Canada | |||
1113349 | 1113349 | 2022-01-11 | Canada | Quebec | 749865 | 12028 | 0 | 52.9399 | -73.5491 | 2022-01-12 04:21:44 | Quebec, Canada | |||
1113350 | 1113350 | 2022-01-11 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-01-12 04:21:44 | Repatriated Travellers, Canada | |||||
1113351 | 1113351 | 2022-01-11 | Canada | Saskatchewan | 94079 | 961 | 0 | 52.9399 | -106.4509 | 2022-01-12 04:21:44 | Saskatchewan, Canada | |||
1113352 | 1113352 | 2022-01-11 | Canada | Yukon | 2322 | 15 | 0 | 64.2823 | -135.0 | 2022-01-12 04:21:44 | Yukon, Canada | |||
1692065 | 1692065 | 2022-01-10 | Canada | Alberta | 412829 | 3344 | 0 | 53.9333 | -116.5765 | 2022-01-11 04:22:01 | Alberta, Canada | |||
1692066 | 1692066 | 2022-01-10 | Canada | British Columbia | 283841 | 2446 | 0 | 53.7267 | -127.6476 | 2022-01-11 04:22:01 | British Columbia, Canada | |||
1692067 | 1692067 | 2022-01-10 | Canada | Diamond Princess | 0 | 1 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | |||
1692068 | 1692068 | 2022-01-10 | Canada | Grand Princess | 13 | 0 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | |||
1692069 | 1692069 | 2022-01-10 | Canada | Manitoba | 101933 | 1427 | 0 | 53.7609 | -98.8139 | 2022-01-11 04:22:01 | Manitoba, Canada | |||
1692070 | 1692070 | 2022-01-10 | Canada | New Brunswick | 20699 | 172 | 0 | 46.5653 | -66.4619 | 2022-01-11 04:22:01 | New Brunswick, Canada | |||
1692071 | 1692071 | 2022-01-10 | Canada | Newfoundland and Labrador | 9451 | 23 | 0 | 53.1355 | -57.6604 | 2022-01-11 04:22:01 | Newfoundland and Labrador, Canada | |||
1692072 | 1692072 | 2022-01-10 | Canada | Northwest Territories | 3107 | 12 | 0 | 64.8255 | -124.8457 | 2022-01-11 04:22:01 | Northwest Territories,Canada | |||
1692073 | 1692073 | 2022-01-10 | Canada | Nova Scotia | 25925 | 112 | 0 | 44.681999999999995 | -63.7443 | 2022-01-11 04:22:01 | Nova Scotia, Canada | |||
1692074 | 1692074 | 2022-01-10 | Canada | Nunavut | 1028 | 4 | 0 | 70.2998 | -83.1076 | 2022-01-11 04:22:01 | Nunavut, Canada | |||
1692075 | 1692075 | 2022-01-10 | Canada | Ontario | 917091 | 10378 | 0 | 51.2538 | -85.3232 | 2022-01-11 04:22:01 | Ontario, Canada | |||
1692076 | 1692076 | 2022-01-10 | Canada | Prince Edward Island | 2893 | 0 | 0 | 46.5107 | -63.4168 | 2022-01-11 04:22:01 | Prince Edward Island, Canada | |||
1692077 | 1692077 | 2022-01-10 | Canada | Quebec | 739292 | 11966 | 0 | 52.9399 | -73.5491 | 2022-01-11 04:22:01 | Quebec, Canada | |||
1692078 | 1692078 | 2022-01-10 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-01-11 04:22:01 | Repatriated Travellers, Canada | |||||
1692079 | 1692079 | 2022-01-10 | Canada | Saskatchewan | 92940 | 961 | 0 | 52.9399 | -106.4509 | 2022-01-11 04:22:01 | Saskatchewan, Canada | |||
1692080 | 1692080 | 2022-01-10 | Canada | Yukon | 2322 | 15 | 0 | 64.2823 | -135.0 | 2022-01-11 04:22:01 | Yukon, Canada | |||
126480 | 126480 | 2022-01-09 | Canada | Alberta | 395252 | 3338 | 0 | 53.9333 | -116.5765 | 2022-01-10 04:22:07 | Alberta, Canada | |||
126481 | 126481 | 2022-01-09 | Canada | British Columbia | 276875 | 2439 | 0 | 53.7267 | -127.6476 | 2022-01-10 04:22:07 | British Columbia, Canada | |||
126482 | 126482 | 2022-01-09 | Canada | Diamond Princess | 0 | 1 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | |||
126483 | 126483 | 2022-01-09 | Canada | Grand Princess | 13 | 0 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | |||
126484 | 126484 | 2022-01-09 | Canada | Manitoba | 94850 | 1408 | 0 | 53.7609 | -98.8139 | 2022-01-10 04:22:07 | Manitoba, Canada | |||
126485 | 126485 | 2022-01-09 | Canada | New Brunswick | 20479 | 172 | 0 | 46.5653 | -66.4619 | 2022-01-10 04:22:07 | New Brunswick, Canada | |||
126486 | 126486 | 2022-01-09 | Canada | Newfoundland and Labrador | 8316 | 21 | 0 | 53.1355 | -57.6604 | 2022-01-10 04:22:07 | Newfoundland and Labrador, Canada | |||
126487 | 126487 | 2022-01-09 | Canada | Northwest Territories | 2801 | 12 | 0 | 64.8255 | -124.8457 | 2022-01-10 04:22:07 | Northwest Territories,Canada | |||
126488 | 126488 | 2022-01-09 | Canada | Nova Scotia | 23265 | 111 | 0 | 44.681999999999995 | -63.7443 | 2022-01-10 04:22:07 | Nova Scotia, Canada | |||
126489 | 126489 | 2022-01-09 | Canada | Nunavut | 977 | 4 | 0 | 70.2998 | -83.1076 | 2022-01-10 04:22:07 | Nunavut, Canada | |||
126490 | 126490 | 2022-01-09 | Canada | Ontario | 907342 | 10366 | 0 | 51.2538 | -85.3232 | 2022-01-10 04:22:07 | Ontario, Canada | |||
126491 | 126491 | 2022-01-09 | Canada | Prince Edward Island | 2463 | 0 | 0 | 46.5107 | -63.4168 | 2022-01-10 04:22:07 | Prince Edward Island, Canada | |||
126492 | 126492 | 2022-01-09 | Canada | Quebec | 728285 | 11917 | 0 | 52.9399 | -73.5491 | 2022-01-10 04:22:07 | Quebec, Canada | |||
126493 | 126493 | 2022-01-09 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-01-10 04:22:07 | Repatriated Travellers, Canada | |||||
126494 | 126494 | 2022-01-09 | Canada | Saskatchewan | 91860 | 961 | 0 | 52.9399 | -106.4509 | 2022-01-10 04:22:07 | Saskatchewan, Canada | |||
126495 | 126495 | 2022-01-09 | Canada | Yukon | 2125 | 15 | 0 | 64.2823 | -135.0 | 2022-01-10 04:22:07 | Yukon, Canada | |||
1215315 | 1215315 | 2022-01-08 | Canada | Alberta | 395252 | 3338 | 0 | 53.9333 | -116.5765 | 2022-01-09 04:21:46 | Alberta, Canada | |||
1215316 | 1215316 | 2022-01-08 | Canada | British Columbia | 276875 | 2439 | 0 | 53.7267 | -127.6476 | 2022-01-09 04:21:46 | British Columbia, Canada | |||
1215317 | 1215317 | 2022-01-08 | Canada | Diamond Princess | 0 | 1 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | |||
1215318 | 1215318 | 2022-01-08 | Canada | Grand Princess | 13 | 0 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | |||
1215319 | 1215319 | 2022-01-08 | Canada | Manitoba | 94850 | 1408 | 0 | 53.7609 | -98.8139 | 2022-01-09 04:21:46 | Manitoba, Canada | |||
1215320 | 1215320 | 2022-01-08 | Canada | New Brunswick | 20278 | 171 | 0 | 46.5653 | -66.4619 | 2022-01-09 04:21:46 | New Brunswick, Canada | |||
1215321 | 1215321 | 2022-01-08 | Canada | Newfoundland and Labrador | 7949 | 21 | 0 | 53.1355 | -57.6604 | 2022-01-09 04:21:46 | Newfoundland and Labrador, Canada | |||
1215322 | 1215322 | 2022-01-08 | Canada | Northwest Territories | 2801 | 12 | 0 | 64.8255 | -124.8457 | 2022-01-09 04:21:46 | Northwest Territories,Canada | |||
1215323 | 1215323 | 2022-01-08 | Canada | Nova Scotia | 23265 | 111 | 0 | 44.681999999999995 | -63.7443 | 2022-01-09 04:21:46 | Nova Scotia, Canada | |||
1215324 | 1215324 | 2022-01-08 | Canada | Nunavut | 977 | 4 | 0 | 70.2998 | -83.1076 | 2022-01-09 04:21:46 | Nunavut, Canada | |||
1215325 | 1215325 | 2022-01-08 | Canada | Ontario | 898661 | 10345 | 0 | 51.2538 | -85.3232 | 2022-01-09 04:21:46 | Ontario, Canada | |||
1215326 | 1215326 | 2022-01-08 | Canada | Prince Edward Island | 2463 | 0 | 0 | 46.5107 | -63.4168 | 2022-01-09 04:21:46 | Prince Edward Island, Canada | |||
1215327 | 1215327 | 2022-01-08 | Canada | Quebec | 712357 | 11873 | 0 | 52.9399 | -73.5491 | 2022-01-09 04:21:46 | Quebec, Canada | |||
1215328 | 1215328 | 2022-01-08 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-01-09 04:21:46 | Repatriated Travellers, Canada | |||||
1215329 | 1215329 | 2022-01-08 | Canada | Saskatchewan | 90765 | 961 | 0 | 52.9399 | -106.4509 | 2022-01-09 04:21:46 | Saskatchewan, Canada | |||
1215330 | 1215330 | 2022-01-08 | Canada | Yukon | 2125 | 15 | 0 | 64.2823 | -135.0 | 2022-01-09 04:21:46 | Yukon, Canada | |||
1389408 | 1389408 | 2022-01-07 | Canada | Alberta | 395252 | 3338 | 0 | 53.9333 | -116.5765 | 2022-01-08 04:21:53 | Alberta, Canada | |||
1389409 | 1389409 | 2022-01-07 | Canada | British Columbia | 276875 | 2439 | 0 | 53.7267 | -127.6476 | 2022-01-08 04:21:53 | British Columbia, Canada | |||
1389410 | 1389410 | 2022-01-07 | Canada | Diamond Princess | 0 | 1 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | |||
1389411 | 1389411 | 2022-01-07 | Canada | Grand Princess | 13 | 0 | 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]);