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 recovered
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state 22
- British Columbia 1,054
- Ontario 1,022
- Alberta 1,013
- Quebec 1,013
- New Brunswick 1,011
- Manitoba 1,009
- Saskatchewan 1,009
- Newfoundland and Labrador 1,007
- Prince Edward Island 1,007
- Nova Scotia 1,003
- Grand Princess 1,002
- Northwest Territories 998
- Yukon 996
- Nunavut 994
- Diamond Princess 980
- Repatriated Travellers 755
- Recovered 51
- London, ON 34
- Toronto, ON 34
- Montreal, QC 11
- Calgary, Alberta 2
- Edmonton, Alberta 1
country_or_region 1
- Canada · 16,006 ✖
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered ▼ | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
90889 | 90889 | 2022-07-23 | Canada | Alberta | 592767 | 4652 | 0 | 53.9333 | -116.5765 | 2022-07-24 04:20:47 | Alberta, Canada | |||
90890 | 90890 | 2022-07-23 | Canada | British Columbia | 377372 | 3855 | 0 | 53.7267 | -127.6476 | 2022-07-24 04:20:47 | British Columbia, Canada | |||
90891 | 90891 | 2022-07-23 | Canada | Diamond Princess | 0 | 1 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | |||
90892 | 90892 | 2022-07-23 | Canada | Grand Princess | 13 | 0 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | |||
90893 | 90893 | 2022-07-23 | Canada | Manitoba | 146024 | 2056 | 0 | 53.7609 | -98.8139 | 2022-07-24 04:20:47 | Manitoba, Canada | |||
90894 | 90894 | 2022-07-23 | Canada | New Brunswick | 70541 | 438 | 0 | 46.5653 | -66.4619 | 2022-07-24 04:20:47 | New Brunswick, Canada | |||
90895 | 90895 | 2022-07-23 | Canada | Newfoundland and Labrador | 48954 | 200 | 0 | 53.1355 | -57.6604 | 2022-07-24 04:20:47 | Newfoundland and Labrador, Canada | |||
90896 | 90896 | 2022-07-23 | Canada | Northwest Territories | 11511 | 22 | 0 | 64.8255 | -124.8457 | 2022-07-24 04:20:47 | Northwest Territories,Canada | |||
90897 | 90897 | 2022-07-23 | Canada | Nova Scotia | 111769 | 461 | 0 | 44.682 | -63.7443 | 2022-07-24 04:20:47 | Nova Scotia, Canada | |||
90898 | 90898 | 2022-07-23 | Canada | Nunavut | 3531 | 7 | 0 | 70.2998 | -83.1076 | 2022-07-24 04:20:47 | Nunavut, Canada | |||
90899 | 90899 | 2022-07-23 | Canada | Ontario | 1372956 | 13615 | 0 | 51.2538 | -85.3232 | 2022-07-24 04:20:47 | Ontario, Canada | |||
90900 | 90900 | 2022-07-23 | Canada | Prince Edward Island | 44852 | 48 | 0 | 46.5107 | -63.4168 | 2022-07-24 04:20:47 | Prince Edward Island, Canada | |||
90901 | 90901 | 2022-07-23 | Canada | Quebec | 1136337 | 15864 | 0 | 52.9399 | -73.5491 | 2022-07-24 04:20:47 | Quebec, Canada | |||
90902 | 90902 | 2022-07-23 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-07-24 04:20:47 | Repatriated Travellers, Canada | |||||
90903 | 90903 | 2022-07-23 | Canada | Saskatchewan | 140291 | 1438 | 0 | 52.9399 | -106.4509 | 2022-07-24 04:20:47 | Saskatchewan, Canada | |||
90904 | 90904 | 2022-07-23 | Canada | Yukon | 4599 | 26 | 0 | 64.2823 | -135.0 | 2022-07-24 04:20:47 | Yukon, Canada | |||
98186 | 98186 | 2020-08-04 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-08-05 04:34:43 | Diamond Princess, Canada | ||
98394 | 98394 | 2020-08-04 | Canada | Nunavut | 0 | 0 | 0 | 0 | 70.2998 | -83.1076 | 2020-08-05 04:34:43 | Nunavut, Canada | ||
98920 | 98920 | 2020-03-04 | Canada | Montreal, QC | 10 | 0 | 0 | 45.5017 | -73.5673 | 2020-02-28T05:23:07 | ||||
99073 | 99073 | 2022-01-14 | Canada | Alberta | 436495 | 3380 | 0 | 53.9333 | -116.5765 | 2022-01-15 04:21:07 | Alberta, Canada | |||
99074 | 99074 | 2022-01-14 | Canada | British Columbia | 293521 | 2468 | 0 | 53.7267 | -127.6476 | 2022-01-15 04:21:07 | British Columbia, Canada | |||
99075 | 99075 | 2022-01-14 | Canada | Diamond Princess | 0 | 1 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | |||
99076 | 99076 | 2022-01-14 | Canada | Grand Princess | 13 | 0 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | |||
99077 | 99077 | 2022-01-14 | Canada | Manitoba | 107838 | 1443 | 0 | 53.7609 | -98.8139 | 2022-01-15 04:21:07 | Manitoba, Canada | |||
99078 | 99078 | 2022-01-14 | Canada | New Brunswick | 21979 | 182 | 0 | 46.5653 | -66.4619 | 2022-01-15 04:21:07 | New Brunswick, Canada | |||
99079 | 99079 | 2022-01-14 | Canada | Newfoundland and Labrador | 12092 | 24 | 0 | 53.1355 | -57.6604 | 2022-01-15 04:21:07 | Newfoundland and Labrador, Canada | |||
99080 | 99080 | 2022-01-14 | Canada | Northwest Territories | 3741 | 12 | 0 | 64.8255 | -124.8457 | 2022-01-15 04:21:07 | Northwest Territories,Canada | |||
99081 | 99081 | 2022-01-14 | Canada | Nova Scotia | 28736 | 117 | 0 | 44.681999999999995 | -63.7443 | 2022-01-15 04:21:07 | Nova Scotia, Canada | |||
99082 | 99082 | 2022-01-14 | Canada | Nunavut | 1055 | 4 | 0 | 70.2998 | -83.1076 | 2022-01-15 04:21:07 | Nunavut, Canada | |||
99083 | 99083 | 2022-01-14 | Canada | Ontario | 960570 | 10522 | 0 | 51.2538 | -85.3232 | 2022-01-15 04:21:07 | Ontario, Canada | |||
99084 | 99084 | 2022-01-14 | Canada | Prince Edward Island | 3861 | 2 | 0 | 46.5107 | -63.4168 | 2022-01-15 04:21:07 | Prince Edward Island, Canada | |||
99085 | 99085 | 2022-01-14 | Canada | Quebec | 783101 | 12193 | 0 | 52.9399 | -73.5491 | 2022-01-15 04:21:07 | Quebec, Canada | |||
99086 | 99086 | 2022-01-14 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-01-15 04:21:07 | Repatriated Travellers, Canada | |||||
99087 | 99087 | 2022-01-14 | Canada | Saskatchewan | 97545 | 961 | 0 | 52.9399 | -106.4509 | 2022-01-15 04:21:07 | Saskatchewan, Canada | |||
99088 | 99088 | 2022-01-14 | Canada | Yukon | 2638 | 15 | 0 | 64.2823 | -135.0 | 2022-01-15 04:21:07 | Yukon, Canada | |||
103089 | 103089 | 2021-08-15 | Canada | Alberta | 238939 | 2332 | 0 | 53.9333 | -116.5765 | 2021-08-16 04:21:31 | Alberta, Canada | |||
103090 | 103090 | 2021-08-15 | Canada | British Columbia | 155079 | 1779 | 0 | 53.7267 | -127.6476 | 2021-08-16 04:21:31 | British Columbia, Canada | |||
103091 | 103091 | 2021-08-15 | Canada | Diamond Princess | 0 | 1 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | |||
103092 | 103092 | 2021-08-15 | Canada | Grand Princess | 13 | 0 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | |||
103093 | 103093 | 2021-08-15 | Canada | Manitoba | 57972 | 1185 | 0 | 53.7609 | -98.8139 | 2021-08-16 04:21:31 | Manitoba, Canada | |||
103094 | 103094 | 2021-08-15 | Canada | New Brunswick | 2490 | 46 | 0 | 46.5653 | -66.4619 | 2021-08-16 04:21:31 | New Brunswick, Canada | |||
103095 | 103095 | 2021-08-15 | Canada | Newfoundland and Labrador | 1447 | 7 | 0 | 53.1355 | -57.6604 | 2021-08-16 04:21:31 | Newfoundland and Labrador, Canada | |||
103096 | 103096 | 2021-08-15 | Canada | Northwest Territories | 133 | 0 | 0 | 64.8255 | -124.8457 | 2021-08-16 04:21:31 | Northwest Territories,Canada | |||
103097 | 103097 | 2021-08-15 | Canada | Nova Scotia | 5919 | 93 | 0 | 44.681999999999995 | -63.7443 | 2021-08-16 04:21:31 | Nova Scotia, Canada | |||
103098 | 103098 | 2021-08-15 | Canada | Nunavut | 657 | 4 | 0 | 70.2998 | -83.1076 | 2021-08-16 04:21:31 | Nunavut, Canada | |||
103099 | 103099 | 2021-08-15 | Canada | Ontario | 560008 | 9418 | 0 | 51.2538 | -85.3232 | 2021-08-16 04:21:31 | Ontario, Canada | |||
103100 | 103100 | 2021-08-15 | Canada | Prince Edward Island | 214 | 0 | 0 | 46.5107 | -63.4168 | 2021-08-16 04:21:31 | Prince Edward Island, Canada | |||
103101 | 103101 | 2021-08-15 | Canada | Quebec | 381587 | 11242 | 0 | 52.9399 | -73.5491 | 2021-08-16 04:21:31 | Quebec, Canada | |||
103102 | 103102 | 2021-08-15 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-08-16 04:21:31 | Repatriated Travellers, Canada | |||||
103103 | 103103 | 2021-08-15 | Canada | Saskatchewan | 51305 | 586 | 0 | 52.9399 | -106.4509 | 2021-08-16 04:21:31 | Saskatchewan, Canada | |||
103104 | 103104 | 2021-08-15 | Canada | Yukon | 647 | 8 | 0 | 64.2823 | -135.0 | 2021-08-16 04:21:31 | Yukon, Canada | |||
107073 | 107073 | 2020-02-15 | Canada | British Columbia | 4 | 0 | 0 | 53.7267 | -127.6476 | 2020-02-07T05:43:03 | ||||
107078 | 107078 | 2020-02-15 | Canada | Toronto, ON | 2 | 0 | 0 | 43.6532 | -79.3832 | 2020-02-04T00:13:06 | ||||
107216 | 107216 | 2021-06-19 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
114110 | 114110 | 2020-05-08 | Canada | Alberta | 6098 | 115 | 0 | 5983 | 53.9333 | -116.5765 | 2020-05-09 02:32:35 | Alberta, Canada | ||
114118 | 114118 | 2020-05-08 | Canada | British Columbia | 2315 | 127 | 0 | 2188 | 53.7267 | -127.6476 | 2020-05-09 02:32:35 | British Columbia, Canada | ||
114124 | 114124 | 2020-05-08 | Canada | Diamond Princess | 1 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-05-09 02:32:35 | Diamond Princess, Canada | ||
114133 | 114133 | 2020-05-08 | Canada | Grand Princess | 13 | 0 | 0 | 13 | 37.6489 | 0.0 | 2020-05-09 02:32:35 | Grand Princess, Canada | ||
114155 | 114155 | 2020-05-08 | Canada | Manitoba | 284 | 7 | 0 | 277 | 53.7609 | -98.8139 | 2020-05-09 02:32:35 | Manitoba, Canada | ||
114159 | 114159 | 2020-05-08 | Canada | New Brunswick | 120 | 0 | 0 | 120 | 46.5653 | -66.4619 | 2020-05-09 02:32:35 | New Brunswick, Canada | ||
114162 | 114162 | 2020-05-08 | Canada | Newfoundland and Labrador | 260 | 3 | 0 | 258 | 53.1355 | -57.6604 | 2020-05-09 02:32:35 | Newfoundland and Labrador, Canada | ||
114166 | 114166 | 2020-05-08 | Canada | Northwest Territories | 5 | 0 | 0 | 5 | 64.8255 | -124.8457 | 2020-05-09 02:32:35 | Northwest Territories, Canada | ||
114167 | 114167 | 2020-05-08 | Canada | Nova Scotia | 1008 | 46 | 0 | 962 | 44.681999999999995 | -63.7443 | 2020-05-09 02:32:35 | Nova Scotia, Canada | ||
114168 | 114168 | 2020-05-08 | Canada | Nunavut | 0 | 0 | 0 | 0 | 70.2998 | -83.1076 | 2020-05-09 02:32:35 | Nunavut, Canada | ||
114169 | 114169 | 2020-05-08 | Canada | Ontario | 20740 | 1540 | 0 | 19161 | 51.2538 | -85.3232 | 2020-05-09 02:32:35 | Ontario, Canada | ||
114170 | 114170 | 2020-05-08 | Canada | Prince Edward Island | 27 | 0 | 0 | 27 | 46.5107 | -63.4168 | 2020-05-09 02:32:35 | Prince Edward Island, Canada | ||
114173 | 114173 | 2020-05-08 | Canada | Quebec | 36972 | 3569 | 0 | 33403 | 52.9399 | -73.5491 | 2020-05-09 02:32:35 | Quebec, Canada | ||
114181 | 114181 | 2020-05-08 | Canada | Saskatchewan | 544 | 6 | 0 | 537 | 52.9399 | -106.4509 | 2020-05-09 02:32:35 | Saskatchewan, Canada | ||
114198 | 114198 | 2020-05-08 | Canada | Yukon | 11 | 0 | 0 | 11 | 64.2823 | -135.0 | 2020-05-09 02:32:35 | Yukon, Canada | ||
114499 | 114499 | 2022-09-06 | Canada | Alberta | 602434 | 4790 | 0 | 53.9333 | -116.5765 | 2022-09-07 04:20:59 | Alberta, Canada | |||
114500 | 114500 | 2022-09-06 | Canada | British Columbia | 382436 | 4145 | 0 | 53.7267 | -127.6476 | 2022-09-07 04:20:59 | British Columbia, Canada | |||
114501 | 114501 | 2022-09-06 | Canada | Diamond Princess | 0 | 1 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | |||
114502 | 114502 | 2022-09-06 | Canada | Grand Princess | 13 | 0 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | |||
114503 | 114503 | 2022-09-06 | Canada | Manitoba | 148428 | 2115 | 0 | 53.7609 | -98.8139 | 2022-09-07 04:20:59 | Manitoba, Canada | |||
114504 | 114504 | 2022-09-06 | Canada | New Brunswick | 75152 | 466 | 0 | 46.5653 | -66.4619 | 2022-09-07 04:20:59 | New Brunswick, Canada | |||
114505 | 114505 | 2022-09-06 | Canada | Newfoundland and Labrador | 51111 | 227 | 0 | 53.1355 | -57.6604 | 2022-09-07 04:20:59 | Newfoundland and Labrador, Canada | |||
114506 | 114506 | 2022-09-06 | Canada | Northwest Territories | 11511 | 22 | 0 | 64.8255 | -124.8457 | 2022-09-07 04:20:59 | Northwest Territories,Canada | |||
114507 | 114507 | 2022-09-06 | Canada | Nova Scotia | 121380 | 496 | 0 | 44.682 | -63.7443 | 2022-09-07 04:20:59 | Nova Scotia, Canada | |||
114508 | 114508 | 2022-09-06 | Canada | Nunavut | 3531 | 7 | 0 | 70.2998 | -83.1076 | 2022-09-07 04:20:59 | Nunavut, Canada | |||
114509 | 114509 | 2022-09-06 | Canada | Ontario | 1437426 | 14127 | 0 | 51.2538 | -85.3232 | 2022-09-07 04:20:59 | Ontario, Canada | |||
114510 | 114510 | 2022-09-06 | Canada | Prince Edward Island | 50594 | 54 | 0 | 46.5107 | -63.4168 | 2022-09-07 04:20:59 | Prince Edward Island, Canada | |||
114511 | 114511 | 2022-09-06 | Canada | Quebec | 1181744 | 16420 | 0 | 52.9399 | -73.5491 | 2022-09-07 04:20:59 | Quebec, Canada | |||
114512 | 114512 | 2022-09-06 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-09-07 04:20:59 | Repatriated Travellers, Canada | |||||
114513 | 114513 | 2022-09-06 | Canada | Saskatchewan | 141815 | 1479 | 0 | 52.9399 | -106.4509 | 2022-09-07 04:20:59 | Saskatchewan, Canada | |||
114514 | 114514 | 2022-09-06 | Canada | Yukon | 4851 | 30 | 0 | 64.2823 | -135.0 | 2022-09-07 04:20:59 | Yukon, Canada | |||
121779 | 121779 | 2020-07-19 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-07-20 05:34:40 | Diamond Princess, Canada | ||
121986 | 121986 | 2020-07-19 | Canada | Nunavut | 0 | 0 | 0 | 0 | 70.2998 | -83.1076 | 2020-07-20 05:34:40 | Nunavut, 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 | ||
122479 | 122479 | 2020-11-18 | Canada | Nunavut | 68 | 0 | 0 | 68 | 70.2998 | -83.1076 | 2020-11-19 05:25:23 | Nunavut, 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 |
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]);