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 active
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state 22
- British Columbia 1,013
- Ontario 987
- Quebec 979
- Alberta 978
- New Brunswick 976
- Saskatchewan 975
- Manitoba 974
- Prince Edward Island 973
- Newfoundland and Labrador 972
- Nova Scotia 969
- Grand Princess 967
- Nunavut 964
- Northwest Territories 963
- Yukon 963
- Diamond Princess 954
- Repatriated Travellers 720
- Recovered 51
- London, ON 29
- Toronto, ON 29
- Montreal, QC 9
- Calgary, Alberta 2
- Edmonton, Alberta 1
country_or_region 1
- Canada · 15,448 ✖
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active ▼ | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
356082 | 356082 | 2022-03-11 | Canada | Nova Scotia | 48471 | 218 | 0 | 44.681999999999995 | -63.7443 | 2022-03-12 04:20:50 | Nova Scotia, Canada | |||
356083 | 356083 | 2022-03-11 | Canada | Nunavut | 3265 | 5 | 0 | 70.2998 | -83.1076 | 2022-03-12 04:20:50 | Nunavut, Canada | |||
356084 | 356084 | 2022-03-11 | Canada | Ontario | 1135292 | 12227 | 0 | 51.2538 | -85.3232 | 2022-03-12 04:20:50 | Ontario, Canada | |||
356085 | 356085 | 2022-03-11 | Canada | Prince Edward Island | 19703 | 16 | 0 | 46.5107 | -63.4168 | 2022-03-12 04:20:50 | Prince Edward Island, Canada | |||
356086 | 356086 | 2022-03-11 | Canada | Quebec | 934620 | 14154 | 0 | 52.9399 | -73.5491 | 2022-03-12 04:20:50 | Quebec, Canada | |||
356087 | 356087 | 2022-03-11 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-03-12 04:20:50 | Repatriated Travellers, Canada | |||||
356088 | 356088 | 2022-03-11 | Canada | Saskatchewan | 129301 | 1148 | 0 | 52.9399 | -106.4509 | 2022-03-12 04:20:50 | Saskatchewan, Canada | |||
356089 | 356089 | 2022-03-11 | Canada | Yukon | 3555 | 23 | 0 | 64.2823 | -135.0 | 2022-03-12 04:20:50 | Yukon, Canada | |||
360090 | 360090 | 2022-05-07 | Canada | Alberta | 570806 | 4321 | 0 | 53.9333 | -116.5765 | 2022-05-08 04:20:49 | Alberta, Canada | |||
360091 | 360091 | 2022-05-07 | Canada | British Columbia | 365577 | 3226 | 0 | 53.7267 | -127.6476 | 2022-05-08 04:20:49 | British Columbia, Canada | |||
360092 | 360092 | 2022-05-07 | Canada | Diamond Princess | 0 | 1 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | |||
360093 | 360093 | 2022-05-07 | Canada | Grand Princess | 13 | 0 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | |||
360094 | 360094 | 2022-05-07 | Canada | Manitoba | 141973 | 1819 | 0 | 53.7609 | -98.8139 | 2022-05-08 04:20:49 | Manitoba, Canada | |||
360095 | 360095 | 2022-05-07 | Canada | New Brunswick | 62148 | 399 | 0 | 46.5653 | -66.4619 | 2022-05-08 04:20:49 | New Brunswick, Canada | |||
360096 | 360096 | 2022-05-07 | Canada | Newfoundland and Labrador | 44529 | 168 | 0 | 53.1355 | -57.6604 | 2022-05-08 04:20:49 | Newfoundland and Labrador, Canada | |||
360097 | 360097 | 2022-05-07 | Canada | Northwest Territories | 11373 | 22 | 0 | 64.8255 | -124.8457 | 2022-05-08 04:20:49 | Northwest Territories,Canada | |||
360098 | 360098 | 2022-05-07 | Canada | Nova Scotia | 89262 | 336 | 0 | 44.682 | -63.7443 | 2022-05-08 04:20:49 | Nova Scotia, Canada | |||
360099 | 360099 | 2022-05-07 | Canada | Nunavut | 3531 | 7 | 0 | 70.2998 | -83.1076 | 2022-05-08 04:20:49 | Nunavut, Canada | |||
360100 | 360100 | 2022-05-07 | Canada | Ontario | 1288468 | 12962 | 0 | 51.2538 | -85.3232 | 2022-05-08 04:20:49 | Ontario, Canada | |||
360101 | 360101 | 2022-05-07 | Canada | Prince Edward Island | 35433 | 26 | 0 | 46.5107 | -63.4168 | 2022-05-08 04:20:49 | Prince Edward Island, Canada | |||
360102 | 360102 | 2022-05-07 | Canada | Quebec | 1051190 | 15137 | 0 | 52.9399 | -73.5491 | 2022-05-08 04:20:49 | Quebec, Canada | |||
360103 | 360103 | 2022-05-07 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-05-08 04:20:49 | Repatriated Travellers, Canada | |||||
360104 | 360104 | 2022-05-07 | Canada | Saskatchewan | 136792 | 1323 | 0 | 52.9399 | -106.4509 | 2022-05-08 04:20:49 | Saskatchewan, Canada | |||
360105 | 360105 | 2022-05-07 | Canada | Yukon | 4262 | 25 | 0 | 64.2823 | -135.0 | 2022-05-08 04:20:49 | Yukon, Canada | |||
371944 | 371944 | 2022-09-13 | Canada | Alberta | 603501 | 4832 | 0 | 53.9333 | -116.5765 | 2022-09-14 04:20:44 | Alberta, Canada | |||
371945 | 371945 | 2022-09-13 | Canada | British Columbia | 383054 | 4183 | 0 | 53.7267 | -127.6476 | 2022-09-14 04:20:44 | British Columbia, Canada | |||
371946 | 371946 | 2022-09-13 | Canada | Diamond Princess | 0 | 1 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | |||
371947 | 371947 | 2022-09-13 | Canada | Grand Princess | 13 | 0 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | |||
371948 | 371948 | 2022-09-13 | Canada | Manitoba | 148903 | 2118 | 0 | 53.7609 | -98.8139 | 2022-09-14 04:20:44 | Manitoba, Canada | |||
371949 | 371949 | 2022-09-13 | Canada | New Brunswick | 75741 | 472 | 0 | 46.5653 | -66.4619 | 2022-09-14 04:20:44 | New Brunswick, Canada | |||
371950 | 371950 | 2022-09-13 | Canada | Newfoundland and Labrador | 51329 | 231 | 0 | 53.1355 | -57.6604 | 2022-09-14 04:20:44 | Newfoundland and Labrador, Canada | |||
371951 | 371951 | 2022-09-13 | Canada | Northwest Territories | 11511 | 22 | 0 | 64.8255 | -124.8457 | 2022-09-14 04:20:44 | Northwest Territories,Canada | |||
371952 | 371952 | 2022-09-13 | Canada | Nova Scotia | 122458 | 504 | 0 | 44.682 | -63.7443 | 2022-09-14 04:20:44 | Nova Scotia, Canada | |||
371953 | 371953 | 2022-09-13 | Canada | Nunavut | 3531 | 7 | 0 | 70.2998 | -83.1076 | 2022-09-14 04:20:44 | Nunavut, Canada | |||
371954 | 371954 | 2022-09-13 | Canada | Ontario | 1445103 | 14216 | 0 | 51.2538 | -85.3232 | 2022-09-14 04:20:44 | Ontario, Canada | |||
371955 | 371955 | 2022-09-13 | Canada | Prince Edward Island | 51050 | 56 | 0 | 46.5107 | -63.4168 | 2022-09-14 04:20:44 | Prince Edward Island, Canada | |||
371956 | 371956 | 2022-09-13 | Canada | Quebec | 1187101 | 16494 | 0 | 52.9399 | -73.5491 | 2022-09-14 04:20:44 | Quebec, Canada | |||
371957 | 371957 | 2022-09-13 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-09-14 04:20:44 | Repatriated Travellers, Canada | |||||
371958 | 371958 | 2022-09-13 | Canada | Saskatchewan | 141815 | 1479 | 0 | 52.9399 | -106.4509 | 2022-09-14 04:20:44 | Saskatchewan, Canada | |||
371959 | 371959 | 2022-09-13 | Canada | Yukon | 4863 | 31 | 0 | 64.2823 | -135.0 | 2022-09-14 04:20:44 | Yukon, Canada | |||
383971 | 383971 | 2022-09-23 | Canada | Alberta | 605757 | 4872 | 0 | 53.9333 | -116.5765 | 2022-09-24 04:21:40 | Alberta, Canada | |||
383972 | 383972 | 2022-09-23 | Canada | British Columbia | 384266 | 4253 | 0 | 53.7267 | -127.6476 | 2022-09-24 04:21:40 | British Columbia, Canada | |||
383973 | 383973 | 2022-09-23 | Canada | Diamond Princess | 0 | 1 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | |||
383974 | 383974 | 2022-09-23 | Canada | Grand Princess | 13 | 0 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | |||
383975 | 383975 | 2022-09-23 | Canada | Manitoba | 149622 | 2143 | 0 | 53.7609 | -98.8139 | 2022-09-24 04:21:40 | Manitoba, Canada | |||
383976 | 383976 | 2022-09-23 | Canada | New Brunswick | 76902 | 480 | 0 | 46.5653 | -66.4619 | 2022-09-24 04:21:40 | New Brunswick, Canada | |||
383977 | 383977 | 2022-09-23 | Canada | Newfoundland and Labrador | 51580 | 236 | 0 | 53.1355 | -57.6604 | 2022-09-24 04:21:40 | Newfoundland and Labrador, Canada | |||
383978 | 383978 | 2022-09-23 | Canada | Northwest Territories | 11511 | 22 | 0 | 64.8255 | -124.8457 | 2022-09-24 04:21:40 | Northwest Territories,Canada | |||
383979 | 383979 | 2022-09-23 | Canada | Nova Scotia | 124511 | 531 | 0 | 44.682 | -63.7443 | 2022-09-24 04:21:40 | Nova Scotia, Canada | |||
383980 | 383980 | 2022-09-23 | Canada | Nunavut | 3531 | 7 | 0 | 70.2998 | -83.1076 | 2022-09-24 04:21:40 | Nunavut, Canada | |||
383981 | 383981 | 2022-09-23 | Canada | Ontario | 1459908 | 14349 | 0 | 51.2538 | -85.3232 | 2022-09-24 04:21:40 | Ontario, Canada | |||
383982 | 383982 | 2022-09-23 | Canada | Prince Edward Island | 51410 | 59 | 0 | 46.5107 | -63.4168 | 2022-09-24 04:21:40 | Prince Edward Island, Canada | |||
383983 | 383983 | 2022-09-23 | Canada | Quebec | 1194787 | 16727 | 0 | 52.9399 | -73.5491 | 2022-09-24 04:21:40 | Quebec, Canada | |||
383984 | 383984 | 2022-09-23 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-09-24 04:21:40 | Repatriated Travellers, Canada | |||||
383985 | 383985 | 2022-09-23 | Canada | Saskatchewan | 143747 | 1507 | 0 | 52.9399 | -106.4509 | 2022-09-24 04:21:40 | Saskatchewan, Canada | |||
383986 | 383986 | 2022-09-23 | Canada | Yukon | 4888 | 31 | 0 | 64.2823 | -135.0 | 2022-09-24 04:21:40 | Yukon, Canada | |||
396012 | 396012 | 2022-10-07 | Canada | Alberta | 607289 | 4905 | 0 | 53.9333 | -116.5765 | 2022-10-08 04:22:56 | Alberta, Canada | |||
396013 | 396013 | 2022-10-07 | Canada | British Columbia | 385599 | 4321 | 0 | 53.7267 | -127.6476 | 2022-10-08 04:22:56 | British Columbia, Canada | |||
396014 | 396014 | 2022-10-07 | Canada | Diamond Princess | 0 | 1 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | |||
396015 | 396015 | 2022-10-07 | Canada | Grand Princess | 13 | 0 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | |||
396016 | 396016 | 2022-10-07 | Canada | Manitoba | 150213 | 2177 | 0 | 53.7609 | -98.8139 | 2022-10-08 04:22:56 | Manitoba, Canada | |||
396017 | 396017 | 2022-10-07 | Canada | New Brunswick | 78056 | 490 | 0 | 46.5653 | -66.4619 | 2022-10-08 04:22:56 | New Brunswick, Canada | |||
396018 | 396018 | 2022-10-07 | Canada | Newfoundland and Labrador | 51955 | 243 | 0 | 53.1355 | -57.6604 | 2022-10-08 04:22:56 | Newfoundland and Labrador, Canada | |||
396019 | 396019 | 2022-10-07 | Canada | Northwest Territories | 11511 | 22 | 0 | 64.8255 | -124.8457 | 2022-10-08 04:22:56 | Northwest Territories,Canada | |||
396020 | 396020 | 2022-10-07 | Canada | Nova Scotia | 126598 | 544 | 0 | 44.682 | -63.7443 | 2022-10-08 04:22:56 | Nova Scotia, Canada | |||
396021 | 396021 | 2022-10-07 | Canada | Nunavut | 3531 | 7 | 0 | 70.2998 | -83.1076 | 2022-10-08 04:22:56 | Nunavut, Canada | |||
396022 | 396022 | 2022-10-07 | Canada | Ontario | 1477931 | 14495 | 0 | 51.2538 | -85.3232 | 2022-10-08 04:22:56 | Ontario, Canada | |||
396023 | 396023 | 2022-10-07 | Canada | Prince Edward Island | 52047 | 61 | 0 | 46.5107 | -63.4168 | 2022-10-08 04:22:56 | Prince Edward Island, Canada | |||
396024 | 396024 | 2022-10-07 | Canada | Quebec | 1207016 | 16836 | 0 | 52.9399 | -73.5491 | 2022-10-08 04:22:56 | Quebec, Canada | |||
396025 | 396025 | 2022-10-07 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-10-08 04:22:56 | Repatriated Travellers, Canada | |||||
396026 | 396026 | 2022-10-07 | Canada | Saskatchewan | 143747 | 1507 | 0 | 52.9399 | -106.4509 | 2022-10-08 04:22:56 | Saskatchewan, Canada | |||
396027 | 396027 | 2022-10-07 | Canada | Yukon | 4923 | 31 | 0 | 64.2823 | -135.0 | 2022-10-08 04:22:56 | Yukon, Canada | |||
404041 | 404041 | 2021-12-07 | Canada | Alberta | 337420 | 3268 | 0 | 53.9333 | -116.5765 | 2021-12-08 04:22:46 | Alberta, Canada | |||
404042 | 404042 | 2021-12-07 | Canada | British Columbia | 220856 | 2363 | 0 | 53.7267 | -127.6476 | 2021-12-08 04:22:46 | British Columbia, Canada | |||
404043 | 404043 | 2021-12-07 | Canada | Diamond Princess | 0 | 1 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | |||
404044 | 404044 | 2021-12-07 | Canada | Grand Princess | 13 | 0 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | |||
404045 | 404045 | 2021-12-07 | Canada | Manitoba | 68938 | 1338 | 0 | 53.7609 | -98.8139 | 2021-12-08 04:22:46 | Manitoba, Canada | |||
404046 | 404046 | 2021-12-07 | Canada | New Brunswick | 8938 | 136 | 0 | 46.5653 | -66.4619 | 2021-12-08 04:22:46 | New Brunswick, Canada | |||
404047 | 404047 | 2021-12-07 | Canada | Newfoundland and Labrador | 2071 | 18 | 0 | 53.1355 | -57.6604 | 2021-12-08 04:22:46 | Newfoundland and Labrador, Canada | |||
404048 | 404048 | 2021-12-07 | Canada | Northwest Territories | 2069 | 12 | 0 | 64.8255 | -124.8457 | 2021-12-08 04:22:46 | Northwest Territories,Canada | |||
404049 | 404049 | 2021-12-07 | Canada | Nova Scotia | 8448 | 110 | 0 | 44.681999999999995 | -63.7443 | 2021-12-08 04:22:46 | Nova Scotia, Canada | |||
404050 | 404050 | 2021-12-07 | Canada | Nunavut | 675 | 4 | 0 | 70.2998 | -83.1076 | 2021-12-08 04:22:46 | Nunavut, Canada | |||
404051 | 404051 | 2021-12-07 | Canada | Ontario | 631591 | 10036 | 0 | 51.2538 | -85.3232 | 2021-12-08 04:22:46 | Ontario, Canada | |||
404052 | 404052 | 2021-12-07 | Canada | Prince Edward Island | 397 | 0 | 0 | 46.5107 | -63.4168 | 2021-12-08 04:22:46 | Prince Edward Island, Canada | |||
404053 | 404053 | 2021-12-07 | Canada | Quebec | 457058 | 11594 | 0 | 52.9399 | -73.5491 | 2021-12-08 04:22:46 | Quebec, Canada | |||
404054 | 404054 | 2021-12-07 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-12-08 04:22:46 | Repatriated Travellers, Canada | |||||
404055 | 404055 | 2021-12-07 | Canada | Saskatchewan | 81462 | 934 | 0 | 52.9399 | -106.4509 | 2021-12-08 04:22:46 | Saskatchewan, Canada | |||
404056 | 404056 | 2021-12-07 | Canada | Yukon | 1556 | 14 | 0 | 64.2823 | -135.0 | 2021-12-08 04:22:46 | Yukon, Canada | |||
415876 | 415876 | 2020-01-26 | Canada | Ontario | 3 | 0 | 0 | 51.2538 | -85.3232 | 1/26/20 16:00 | ||||
419083 | 419083 | 2022-09-18 | Canada | Alberta | 604578 | 4848 | 0 | 53.9333 | -116.5765 | 2022-09-19 04:21:49 | Alberta, Canada | |||
419084 | 419084 | 2022-09-18 | Canada | British Columbia | 383628 | 4216 | 0 | 53.7267 | -127.6476 | 2022-09-19 04:21:49 | British Columbia, Canada | |||
419085 | 419085 | 2022-09-18 | Canada | Diamond Princess | 0 | 1 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | |||
419086 | 419086 | 2022-09-18 | Canada | Grand Princess | 13 | 0 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | |||
419087 | 419087 | 2022-09-18 | Canada | Manitoba | 149245 | 2137 | 0 | 53.7609 | -98.8139 | 2022-09-19 04:21:49 | Manitoba, Canada | |||
419088 | 419088 | 2022-09-18 | Canada | New Brunswick | 76316 | 476 | 0 | 46.5653 | -66.4619 | 2022-09-19 04:21:49 | New Brunswick, Canada | |||
419089 | 419089 | 2022-09-18 | Canada | Newfoundland and Labrador | 51446 | 235 | 0 | 53.1355 | -57.6604 | 2022-09-19 04:21:49 | Newfoundland and Labrador, Canada | |||
419090 | 419090 | 2022-09-18 | Canada | Northwest Territories | 11511 | 22 | 0 | 64.8255 | -124.8457 | 2022-09-19 04:21:49 | Northwest Territories,Canada | |||
419091 | 419091 | 2022-09-18 | Canada | Nova Scotia | 123549 | 518 | 0 | 44.682 | -63.7443 | 2022-09-19 04:21:49 | Nova Scotia, Canada | |||
419092 | 419092 | 2022-09-18 | Canada | Nunavut | 3531 | 7 | 0 | 70.2998 | -83.1076 | 2022-09-19 04:21:49 | Nunavut, Canada | |||
419093 | 419093 | 2022-09-18 | Canada | Ontario | 1450985 | 14283 | 0 | 51.2538 | -85.3232 | 2022-09-19 04:21:49 | 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]);