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,020
- Ontario 993
- Alberta 985
- Quebec 985
- New Brunswick 983
- Manitoba 981
- Saskatchewan 981
- Newfoundland and Labrador 979
- Prince Edward Island 979
- Nova Scotia 975
- Grand Princess 974
- Northwest Territories 970
- Nunavut 969
- Yukon 968
- Diamond Princess 960
- Repatriated Travellers 725
- Recovered 51
- London, ON 29
- Toronto, ON 29
- Montreal, QC 9
- Calgary, Alberta 2
- Edmonton, Alberta 1
country_or_region 1
- Canada · 15,548 ✖
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active ▼ | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
315664 | 315664 | 2022-02-12 | Canada | Alberta | 514165 | 3741 | 0 | 53.9333 | -116.5765 | 2022-02-13 04:21:00 | Alberta, Canada | |||
315665 | 315665 | 2022-02-12 | Canada | British Columbia | 338585 | 2747 | 0 | 53.7267 | -127.6476 | 2022-02-13 04:21:00 | British Columbia, Canada | |||
315666 | 315666 | 2022-02-12 | Canada | Diamond Princess | 0 | 1 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | |||
315667 | 315667 | 2022-02-12 | Canada | Grand Princess | 13 | 0 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | |||
315668 | 315668 | 2022-02-12 | Canada | Manitoba | 125844 | 1619 | 0 | 53.7609 | -98.8139 | 2022-02-13 04:21:00 | Manitoba, Canada | |||
315669 | 315669 | 2022-02-12 | Canada | New Brunswick | 32610 | 286 | 0 | 46.5653 | -66.4619 | 2022-02-13 04:21:00 | New Brunswick, Canada | |||
315670 | 315670 | 2022-02-12 | Canada | Newfoundland and Labrador | 19954 | 52 | 0 | 53.1355 | -57.6604 | 2022-02-13 04:21:00 | Newfoundland and Labrador, Canada | |||
315671 | 315671 | 2022-02-12 | Canada | Northwest Territories | 7343 | 17 | 0 | 64.8255 | -124.8457 | 2022-02-13 04:21:00 | Northwest Territories,Canada | |||
315672 | 315672 | 2022-02-12 | Canada | Nova Scotia | 41716 | 167 | 0 | 44.681999999999995 | -63.7443 | 2022-02-13 04:21:00 | Nova Scotia, Canada | |||
315673 | 315673 | 2022-02-12 | Canada | Nunavut | 2114 | 5 | 0 | 70.2998 | -83.1076 | 2022-02-13 04:21:00 | Nunavut, Canada | |||
315674 | 315674 | 2022-02-12 | Canada | Ontario | 1084904 | 12075 | 0 | 51.2538 | -85.3232 | 2022-02-13 04:21:00 | Ontario, Canada | |||
315675 | 315675 | 2022-02-12 | Canada | Prince Edward Island | 9969 | 13 | 0 | 46.5107 | -63.4168 | 2022-02-13 04:21:00 | Prince Edward Island, Canada | |||
315676 | 315676 | 2022-02-12 | Canada | Quebec | 896970 | 13684 | 0 | 52.9399 | -73.5491 | 2022-02-13 04:21:00 | Quebec, Canada | |||
315677 | 315677 | 2022-02-12 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-02-13 04:21:00 | Repatriated Travellers, Canada | |||||
315678 | 315678 | 2022-02-12 | Canada | Saskatchewan | 125780 | 1054 | 0 | 52.9399 | -106.4509 | 2022-02-13 04:21:00 | Saskatchewan, Canada | |||
315679 | 315679 | 2022-02-12 | Canada | Yukon | 3302 | 20 | 0 | 64.2823 | -135.0 | 2022-02-13 04:21:00 | Yukon, Canada | |||
319680 | 319680 | 2022-10-30 | Canada | Alberta | 612693 | 5011 | 0 | 53.9333 | -116.5765 | 2022-10-31 04:21:36 | Alberta, Canada | |||
319681 | 319681 | 2022-10-30 | Canada | British Columbia | 387451 | 4485 | 0 | 53.7267 | -127.6476 | 2022-10-31 04:21:36 | British Columbia, Canada | |||
319682 | 319682 | 2022-10-30 | Canada | Diamond Princess | 0 | 1 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | |||
319683 | 319683 | 2022-10-30 | Canada | Grand Princess | 13 | 0 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | |||
319684 | 319684 | 2022-10-30 | Canada | Manitoba | 151319 | 2211 | 0 | 53.7609 | -98.8139 | 2022-10-31 04:21:36 | Manitoba, Canada | |||
319685 | 319685 | 2022-10-30 | Canada | New Brunswick | 80126 | 585 | 0 | 46.5653 | -66.4619 | 2022-10-31 04:21:36 | New Brunswick, Canada | |||
319686 | 319686 | 2022-10-30 | Canada | Newfoundland and Labrador | 52552 | 254 | 0 | 53.1355 | -57.6604 | 2022-10-31 04:21:36 | Newfoundland and Labrador, Canada | |||
319687 | 319687 | 2022-10-30 | Canada | Northwest Territories | 11511 | 22 | 0 | 64.8255 | -124.8457 | 2022-10-31 04:21:36 | Northwest Territories,Canada | |||
319688 | 319688 | 2022-10-30 | Canada | Nova Scotia | 129705 | 583 | 0 | 44.682 | -63.7443 | 2022-10-31 04:21:36 | Nova Scotia, Canada | |||
319689 | 319689 | 2022-10-30 | Canada | Nunavut | 3531 | 7 | 0 | 70.2998 | -83.1076 | 2022-10-31 04:21:36 | Nunavut, Canada | |||
319690 | 319690 | 2022-10-30 | Canada | Ontario | 1506871 | 14770 | 0 | 51.2538 | -85.3232 | 2022-10-31 04:21:36 | Ontario, Canada | |||
319691 | 319691 | 2022-10-30 | Canada | Prince Edward Island | 53408 | 66 | 0 | 46.5107 | -63.4168 | 2022-10-31 04:21:36 | Prince Edward Island, Canada | |||
319692 | 319692 | 2022-10-30 | Canada | Quebec | 1227249 | 17041 | 0 | 52.9399 | -73.5491 | 2022-10-31 04:21:36 | Quebec, Canada | |||
319693 | 319693 | 2022-10-30 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-10-31 04:21:36 | Repatriated Travellers, Canada | |||||
319694 | 319694 | 2022-10-30 | Canada | Saskatchewan | 146888 | 1604 | 0 | 52.9399 | -106.4509 | 2022-10-31 04:21:36 | Saskatchewan, Canada | |||
319695 | 319695 | 2022-10-30 | Canada | Yukon | 4954 | 32 | 0 | 64.2823 | -135.0 | 2022-10-31 04:21:36 | Yukon, Canada | |||
327654 | 327654 | 2022-12-27 | Canada | Alberta | 622428 | 5351 | 0 | 53.9333 | -116.5765 | 2022-12-28 04:21:04 | Alberta, Canada | |||
327655 | 327655 | 2022-12-27 | Canada | British Columbia | 391897 | 4806 | 0 | 53.7267 | -127.6476 | 2022-12-28 04:21:04 | British Columbia, Canada | |||
327656 | 327656 | 2022-12-27 | Canada | Diamond Princess | 0 | 1 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | |||
327657 | 327657 | 2022-12-27 | Canada | Grand Princess | 13 | 0 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | |||
327658 | 327658 | 2022-12-27 | Canada | Manitoba | 153507 | 2331 | 0 | 53.7609 | -98.8139 | 2022-12-28 04:21:04 | Manitoba, Canada | |||
327659 | 327659 | 2022-12-27 | Canada | New Brunswick | 84891 | 635 | 0 | 46.5653 | -66.4619 | 2022-12-28 04:21:04 | New Brunswick, Canada | |||
327660 | 327660 | 2022-12-27 | Canada | Newfoundland and Labrador | 53914 | 288 | 0 | 53.1355 | -57.6604 | 2022-12-28 04:21:04 | Newfoundland and Labrador, Canada | |||
327661 | 327661 | 2022-12-27 | Canada | Northwest Territories | 11511 | 22 | 0 | 64.8255 | -124.8457 | 2022-12-28 04:21:04 | Northwest Territories,Canada | |||
327662 | 327662 | 2022-12-27 | Canada | Nova Scotia | 134483 | 674 | 0 | 44.682 | -63.7443 | 2022-12-28 04:21:04 | Nova Scotia, Canada | |||
327663 | 327663 | 2022-12-27 | Canada | Nunavut | 3531 | 7 | 0 | 70.2998 | -83.1076 | 2022-12-28 04:21:04 | Nunavut, Canada | |||
327664 | 327664 | 2022-12-27 | Canada | Ontario | 1552652 | 15514 | 0 | 51.2538 | -85.3232 | 2022-12-28 04:21:04 | Ontario, Canada | |||
327665 | 327665 | 2022-12-27 | Canada | Prince Edward Island | 55319 | 82 | 0 | 46.5107 | -63.4168 | 2022-12-28 04:21:04 | Prince Edward Island, Canada | |||
327666 | 327666 | 2022-12-27 | Canada | Quebec | 1280200 | 17628 | 0 | 52.9399 | -73.5491 | 2022-12-28 04:21:04 | Quebec, Canada | |||
327667 | 327667 | 2022-12-27 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-12-28 04:21:04 | Repatriated Travellers, Canada | |||||
327668 | 327668 | 2022-12-27 | Canada | Saskatchewan | 150942 | 1781 | 0 | 52.9399 | -106.4509 | 2022-12-28 04:21:04 | Saskatchewan, Canada | |||
327669 | 327669 | 2022-12-27 | Canada | Yukon | 4989 | 32 | 0 | 64.2823 | -135.0 | 2022-12-28 04:21:04 | Yukon, Canada | |||
335684 | 335684 | 2022-03-18 | Canada | Alberta | 534285 | 4023 | 0 | 53.9333 | -116.5765 | 2022-03-19 04:20:47 | Alberta, Canada | |||
335685 | 335685 | 2022-03-18 | Canada | British Columbia | 353578 | 2966 | 0 | 53.7267 | -127.6476 | 2022-03-19 04:20:47 | British Columbia, Canada | |||
335686 | 335686 | 2022-03-18 | Canada | Diamond Princess | 0 | 1 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | |||
335687 | 335687 | 2022-03-18 | Canada | Grand Princess | 13 | 0 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | |||
335688 | 335688 | 2022-03-18 | Canada | Manitoba | 133928 | 1726 | 0 | 53.7609 | -98.8139 | 2022-03-19 04:20:47 | Manitoba, Canada | |||
335689 | 335689 | 2022-03-18 | Canada | New Brunswick | 42320 | 320 | 0 | 46.5653 | -66.4619 | 2022-03-19 04:20:47 | New Brunswick, Canada | |||
335690 | 335690 | 2022-03-18 | Canada | Newfoundland and Labrador | 32113 | 82 | 0 | 53.1355 | -57.6604 | 2022-03-19 04:20:47 | Newfoundland and Labrador, Canada | |||
335691 | 335691 | 2022-03-18 | Canada | Northwest Territories | 9843 | 20 | 0 | 64.8255 | -124.8457 | 2022-03-19 04:20:47 | Northwest Territories,Canada | |||
335692 | 335692 | 2022-03-18 | Canada | Nova Scotia | 48471 | 218 | 0 | 44.681999999999995 | -63.7443 | 2022-03-19 04:20:47 | Nova Scotia, Canada | |||
335693 | 335693 | 2022-03-18 | Canada | Nunavut | 3331 | 5 | 0 | 70.2998 | -83.1076 | 2022-03-19 04:20:47 | Nunavut, Canada | |||
335694 | 335694 | 2022-03-18 | Canada | Ontario | 1144461 | 12313 | 0 | 51.2538 | -85.3232 | 2022-03-19 04:20:47 | Ontario, Canada | |||
335695 | 335695 | 2022-03-18 | Canada | Prince Edward Island | 21307 | 16 | 0 | 46.5107 | -63.4168 | 2022-03-19 04:20:47 | Prince Edward Island, Canada | |||
335696 | 335696 | 2022-03-18 | Canada | Quebec | 942280 | 14245 | 0 | 52.9399 | -73.5491 | 2022-03-19 04:20:47 | Quebec, Canada | |||
335697 | 335697 | 2022-03-18 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-03-19 04:20:47 | Repatriated Travellers, Canada | |||||
335698 | 335698 | 2022-03-18 | Canada | Saskatchewan | 130133 | 1176 | 0 | 52.9399 | -106.4509 | 2022-03-19 04:20:47 | Saskatchewan, Canada | |||
335699 | 335699 | 2022-03-18 | Canada | Yukon | 3628 | 23 | 0 | 64.2823 | -135.0 | 2022-03-19 04:20:47 | Yukon, Canada | |||
339681 | 339681 | 2020-03-21 | Canada | British Columbia | 424 | 10 | 4 | 53.7267 | -127.6476 | 2020-03-21T21:13:30 | ||||
339688 | 339688 | 2020-03-21 | Canada | Ontario | 919 | 2 | 6 | 51.2538 | -85.3232 | 2020-03-21T21:13:30 | ||||
339714 | 339714 | 2020-03-21 | Canada | Alberta | 195 | 1 | 0 | 53.9333 | -116.5765 | 2020-03-21T02:43:03 | ||||
339718 | 339718 | 2020-03-21 | Canada | Quebec | 557 | 5 | 0 | 52.9399 | -73.5491 | 2020-03-21T21:13:30 | ||||
339809 | 339809 | 2020-03-21 | Canada | Saskatchewan | 26 | 0 | 0 | 52.9399 | -106.4509 | 2020-03-21T02:43:03 | ||||
339817 | 339817 | 2020-03-21 | Canada | Nova Scotia | 21 | 0 | 0 | 44.682 | -63.7443 | 2020-03-21T21:13:30 | ||||
339823 | 339823 | 2020-03-21 | Canada | Manitoba | 18 | 0 | 0 | 53.7609 | -98.8139 | 2020-03-21T17:43:03 | ||||
339828 | 339828 | 2020-03-21 | Canada | New Brunswick | 17 | 0 | 0 | 46.5653 | -66.4619 | 2020-03-21T21:13:30 | ||||
339844 | 339844 | 2020-03-21 | Canada | Grand Princess | 10 | 0 | 0 | 37.6489 | -122.6655 | 2020-03-20T03:13:18 | ||||
339855 | 339855 | 2020-03-21 | Canada | Newfoundland and Labrador | 6 | 0 | 0 | 53.1355 | -57.6604 | 2020-03-21T21:13:29 | ||||
339880 | 339880 | 2020-03-21 | Canada | Prince Edward Island | 2 | 0 | 0 | 46.5107 | -63.4168 | 2020-03-19T18:43:03 | ||||
339892 | 339892 | 2020-03-21 | Canada | Northwest Territories | 1 | 0 | 0 | 64.8255 | -124.8457 | 2020-03-21T21:13:30 | ||||
348044 | 348044 | 2022-12-14 | Canada | Alberta | 621512 | 5308 | 0 | 53.9333 | -116.5765 | 2022-12-15 04:20:58 | Alberta, Canada | |||
348045 | 348045 | 2022-12-14 | Canada | British Columbia | 390626 | 4715 | 0 | 53.7267 | -127.6476 | 2022-12-15 04:20:58 | British Columbia, Canada | |||
348046 | 348046 | 2022-12-14 | Canada | Diamond Princess | 0 | 1 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | |||
348047 | 348047 | 2022-12-14 | Canada | Grand Princess | 13 | 0 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | |||
348048 | 348048 | 2022-12-14 | Canada | Manitoba | 153194 | 2301 | 0 | 53.7609 | -98.8139 | 2022-12-15 04:20:58 | Manitoba, Canada | |||
348049 | 348049 | 2022-12-14 | Canada | New Brunswick | 83425 | 621 | 0 | 46.5653 | -66.4619 | 2022-12-15 04:20:58 | New Brunswick, Canada | |||
348050 | 348050 | 2022-12-14 | Canada | Newfoundland and Labrador | 53635 | 278 | 0 | 53.1355 | -57.6604 | 2022-12-15 04:20:58 | Newfoundland and Labrador, Canada | |||
348051 | 348051 | 2022-12-14 | Canada | Northwest Territories | 11511 | 22 | 0 | 64.8255 | -124.8457 | 2022-12-15 04:20:58 | Northwest Territories,Canada | |||
348052 | 348052 | 2022-12-14 | Canada | Nova Scotia | 133406 | 666 | 0 | 44.682 | -63.7443 | 2022-12-15 04:20:58 | Nova Scotia, Canada | |||
348053 | 348053 | 2022-12-14 | Canada | Nunavut | 3531 | 7 | 0 | 70.2998 | -83.1076 | 2022-12-15 04:20:58 | Nunavut, Canada | |||
348054 | 348054 | 2022-12-14 | Canada | Ontario | 1543526 | 15378 | 0 | 51.2538 | -85.3232 | 2022-12-15 04:20:58 | Ontario, Canada | |||
348055 | 348055 | 2022-12-14 | Canada | Prince Edward Island | 55111 | 81 | 0 | 46.5107 | -63.4168 | 2022-12-15 04:20:58 | Prince Edward Island, Canada | |||
348056 | 348056 | 2022-12-14 | Canada | Quebec | 1267561 | 17497 | 0 | 52.9399 | -73.5491 | 2022-12-15 04:20:58 | Quebec, Canada | |||
348057 | 348057 | 2022-12-14 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-12-15 04:20:58 | Repatriated Travellers, Canada | |||||
348058 | 348058 | 2022-12-14 | Canada | Saskatchewan | 150003 | 1750 | 0 | 52.9399 | -106.4509 | 2022-12-15 04:20:58 | Saskatchewan, Canada | |||
348059 | 348059 | 2022-12-14 | Canada | Yukon | 4989 | 32 | 0 | 64.2823 | -135.0 | 2022-12-15 04:20:58 | Yukon, Canada | |||
356074 | 356074 | 2022-03-11 | Canada | Alberta | 530761 | 4003 | 0 | 53.9333 | -116.5765 | 2022-03-12 04:20:50 | Alberta, Canada | |||
356075 | 356075 | 2022-03-11 | Canada | British Columbia | 352039 | 2935 | 0 | 53.7267 | -127.6476 | 2022-03-12 04:20:50 | British Columbia, Canada | |||
356076 | 356076 | 2022-03-11 | Canada | Diamond Princess | 0 | 1 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | |||
356077 | 356077 | 2022-03-11 | Canada | Grand Princess | 13 | 0 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | |||
356078 | 356078 | 2022-03-11 | Canada | Manitoba | 132681 | 1710 | 0 | 53.7609 | -98.8139 | 2022-03-12 04:20:50 | Manitoba, Canada | |||
356079 | 356079 | 2022-03-11 | Canada | New Brunswick | 41512 | 317 | 0 | 46.5653 | -66.4619 | 2022-03-12 04:20:50 | New Brunswick, Canada | |||
356080 | 356080 | 2022-03-11 | Canada | Newfoundland and Labrador | 29365 | 76 | 0 | 53.1355 | -57.6604 | 2022-03-12 04:20:50 | Newfoundland and Labrador, Canada | |||
356081 | 356081 | 2022-03-11 | Canada | Northwest Territories | 9514 | 20 | 0 | 64.8255 | -124.8457 | 2022-03-12 04:20:50 | 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]);