johns_hopkins_csse_daily_reports

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

6,624 rows where country_or_region = "Canada" sorted by day descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: latitude, longitude, combined_key, day (date), last_update (date)

country_or_region

  • Canada · 6,624 ✖
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
1019991 1019991 2021-05-08 Canada Alberta     207157 2108 179894 25155 53.9333 -116.5765 2021-05-09 04:20:35 Alberta, Canada
1019992 1019992 2021-05-08 Canada British Columbia     134341 1602 125799 6940 53.7267 -127.6476 2021-05-09 04:20:35 British Columbia, Canada
1019993 1019993 2021-05-08 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
1019994 1019994 2021-05-08 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
1019995 1019995 2021-05-08 Canada Manitoba     41425 990 37198 3237 53.7609 -98.8139 2021-05-09 04:20:35 Manitoba, Canada
1019996 1019996 2021-05-08 Canada New Brunswick     1996 41 1813 142 46.5653 -66.4619 2021-05-09 04:20:35 New Brunswick, Canada
1019997 1019997 2021-05-08 Canada Newfoundland and Labrador     1133 6 1056 71 53.1355 -57.6604 2021-05-09 04:20:35 Newfoundland and Labrador, Canada
1019998 1019998 2021-05-08 Canada Northwest Territories     105 0 57 48 64.8255 -124.8457 2021-05-09 04:20:35 Northwest Territories,Canada
1019999 1019999 2021-05-08 Canada Nova Scotia     3754 71 2145 1538 44.682 -63.7443 2021-05-09 04:20:35 Nova Scotia, Canada
1020000 1020000 2021-05-08 Canada Nunavut     560 4 482 74 70.2998 -83.1076 2021-05-09 04:20:35 Nunavut, Canada
1020001 1020001 2021-05-08 Canada Ontario     497032 8246 459438 29348 51.2538 -85.3232 2021-05-09 04:20:35 Ontario, Canada
1020002 1020002 2021-05-08 Canada Prince Edward Island     183 0 176 7 46.5107 -63.4168 2021-05-09 04:20:35 Prince Edward Island, Canada
1020003 1020003 2021-05-08 Canada Quebec     357174 10981 337538 8655 52.9399 -73.5491 2021-05-09 04:20:35 Quebec, Canada
1020004 1020004 2021-05-08 Canada Repatriated Travellers     13 0 13 0     2021-05-09 04:20:35 Repatriated Travellers, Canada
1020005 1020005 2021-05-08 Canada Saskatchewan     42964 502 40169 2293 52.9399 -106.4509 2021-05-09 04:20:35 Saskatchewan, Canada
1020006 1020006 2021-05-08 Canada Yukon     82 2 79 1 64.2823 -135.0 2021-05-09 04:20:35 Yukon, Canada
928164 928164 2021-05-07 Canada Alberta     205115 2106 178149 24860 53.9333 -116.5765 2021-05-08 04:21:04 Alberta, Canada
928165 928165 2021-05-07 Canada British Columbia     134341 1602 125799 6940 53.7267 -127.6476 2021-05-08 04:21:04 British Columbia, Canada
928166 928166 2021-05-07 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
928167 928167 2021-05-07 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
928168 928168 2021-05-07 Canada Manitoba     40940 987 36964 2989 53.7609 -98.8139 2021-05-08 04:21:04 Manitoba, Canada
928169 928169 2021-05-07 Canada New Brunswick     1988 40 1807 141 46.5653 -66.4619 2021-05-08 04:21:04 New Brunswick, Canada
928170 928170 2021-05-07 Canada Newfoundland and Labrador     1127 6 1054 67 53.1355 -57.6604 2021-05-08 04:21:04 Newfoundland and Labrador, Canada
928171 928171 2021-05-07 Canada Northwest Territories     105 0 57 48 64.8255 -124.8457 2021-05-08 04:21:04 Northwest Territories,Canada
928172 928172 2021-05-07 Canada Nova Scotia     3591 70 2057 1464 44.682 -63.7443 2021-05-08 04:21:04 Nova Scotia, Canada
928173 928173 2021-05-07 Canada Nunavut     553 4 472 77 70.2998 -83.1076 2021-05-08 04:21:04 Nunavut, Canada
928174 928174 2021-05-07 Canada Ontario     494884 8229 457032 29623 51.2538 -85.3232 2021-05-08 04:21:04 Ontario, Canada
928175 928175 2021-05-07 Canada Prince Edward Island     183 0 176 7 46.5107 -63.4168 2021-05-08 04:21:04 Prince Edward Island, Canada
928176 928176 2021-05-07 Canada Quebec     356216 10974 336505 8737 52.9399 -73.5491 2021-05-08 04:21:04 Quebec, Canada
928177 928177 2021-05-07 Canada Repatriated Travellers     13 0 13 0     2021-05-08 04:21:04 Repatriated Travellers, Canada
928178 928178 2021-05-07 Canada Saskatchewan     42695 502 39954 2239 52.9399 -106.4509 2021-05-08 04:21:04 Saskatchewan, Canada
928179 928179 2021-05-07 Canada Yukon     82 2 79 1 64.2823 -135.0 2021-05-08 04:21:04 Yukon, Canada
622234 622234 2021-05-06 Canada Alberta     203135 2102 176536 24497 53.9333 -116.5765 2021-05-07 04:20:40 Alberta, Canada
622235 622235 2021-05-06 Canada British Columbia     133619 1595 125025 6999 53.7267 -127.6476 2021-05-07 04:20:40 British Columbia, Canada
622236 622236 2021-05-06 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
622237 622237 2021-05-06 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
622238 622238 2021-05-06 Canada Manitoba     40442 986 36724 2732 53.7609 -98.8139 2021-05-07 04:20:40 Manitoba, Canada
622239 622239 2021-05-06 Canada New Brunswick     1980 40 1797 143 46.5653 -66.4619 2021-05-07 04:20:40 New Brunswick, Canada
622240 622240 2021-05-06 Canada Newfoundland and Labrador     1120 6 1052 62 53.1355 -57.6604 2021-05-07 04:20:40 Newfoundland and Labrador, Canada
622241 622241 2021-05-06 Canada Northwest Territories     104 0 57 47 64.8255 -124.8457 2021-05-07 04:20:40 Northwest Territories,Canada
622242 622242 2021-05-06 Canada Nova Scotia     3364 69 1986 1309 44.682 -63.7443 2021-05-07 04:20:40 Nova Scotia, Canada
622243 622243 2021-05-06 Canada Nunavut     552 4 462 86 70.2998 -83.1076 2021-05-07 04:20:40 Nunavut, Canada
622244 622244 2021-05-06 Canada Ontario     491926 8202 453379 30345 51.2538 -85.3232 2021-05-07 04:20:40 Ontario, Canada
622245 622245 2021-05-06 Canada Prince Edward Island     183 0 176 7 46.5107 -63.4168 2021-05-07 04:20:40 Prince Edward Island, Canada
622246 622246 2021-05-06 Canada Quebec     355297 10971 335421 8905 52.9399 -73.5491 2021-05-07 04:20:40 Quebec, Canada
622247 622247 2021-05-06 Canada Repatriated Travellers     13 0 13 0     2021-05-07 04:20:40 Repatriated Travellers, Canada
622248 622248 2021-05-06 Canada Saskatchewan     42376 501 39717 2158 52.9399 -106.4509 2021-05-07 04:20:40 Saskatchewan, Canada
622249 622249 2021-05-06 Canada Yukon     82 2 79 1 64.2823 -135.0 2021-05-07 04:20:40 Yukon, Canada
452747 452747 2021-05-05 Canada Alberta     200924 2102 174666 24156 53.9333 -116.5765 2021-05-06 04:20:38 Alberta, Canada
452748 452748 2021-05-05 Canada British Columbia     132925 1594 124252 7079 53.7267 -127.6476 2021-05-06 04:20:38 British Columbia, Canada
452749 452749 2021-05-05 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
452750 452750 2021-05-05 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
452751 452751 2021-05-05 Canada Manitoba     40085 982 36323 2780 53.7609 -98.8139 2021-05-06 04:20:38 Manitoba, Canada
452752 452752 2021-05-05 Canada New Brunswick     1969 39 1784 146 46.5653 -66.4619 2021-05-06 04:20:38 New Brunswick, Canada
452753 452753 2021-05-05 Canada Newfoundland and Labrador     1114 6 1046 62 53.1355 -57.6604 2021-05-06 04:20:38 Newfoundland and Labrador, Canada
452754 452754 2021-05-05 Canada Northwest Territories     91 0 57 34 64.8255 -124.8457 2021-05-06 04:20:38 Northwest Territories,Canada
452755 452755 2021-05-05 Canada Nova Scotia     3182 69 1910 1203 44.682 -63.7443 2021-05-06 04:20:38 Nova Scotia, Canada
452756 452756 2021-05-05 Canada Nunavut     540 4 454 82 70.2998 -83.1076 2021-05-06 04:20:38 Nunavut, Canada
452757 452757 2021-05-05 Canada Ontario     488535 8173 449670 30692 51.2538 -85.3232 2021-05-06 04:20:38 Ontario, Canada
452758 452758 2021-05-05 Canada Prince Edward Island     183 0 176 7 46.5107 -63.4168 2021-05-06 04:20:38 Prince Edward Island, Canada
452759 452759 2021-05-05 Canada Quebec     354390 10964 334531 8895 52.9399 -73.5491 2021-05-06 04:20:38 Quebec, Canada
452760 452760 2021-05-05 Canada Repatriated Travellers     13 0 13 0     2021-05-06 04:20:38 Repatriated Travellers, Canada
452761 452761 2021-05-05 Canada Saskatchewan     42203 501 39452 2250 52.9399 -106.4509 2021-05-06 04:20:38 Saskatchewan, Canada
452762 452762 2021-05-05 Canada Yukon     82 2 79 1 64.2823 -135.0 2021-05-06 04:20:38 Yukon, Canada
764451 764451 2021-05-04 Canada Alberta     198653 2099 172931 23623 53.9333 -116.5765 2021-05-05 04:20:43 Alberta, Canada
764452 764452 2021-05-04 Canada British Columbia     132353 1597 123383 7373 53.7267 -127.6476 2021-05-05 04:20:43 British Columbia, Canada
764453 764453 2021-05-04 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
764454 764454 2021-05-04 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
764455 764455 2021-05-04 Canada Manitoba     39814 980 36142 2692 53.7609 -98.8139 2021-05-05 04:20:43 Manitoba, Canada
764456 764456 2021-05-04 Canada New Brunswick     1958 38 1778 142 46.5653 -66.4619 2021-05-05 04:20:43 New Brunswick, Canada
764457 764457 2021-05-04 Canada Newfoundland and Labrador     1108 6 1042 60 53.1355 -57.6604 2021-05-05 04:20:43 Newfoundland and Labrador, Canada
764458 764458 2021-05-04 Canada Northwest Territories     77 0 57 20 64.8255 -124.8457 2021-05-05 04:20:43 Northwest Territories,Canada
764459 764459 2021-05-04 Canada Nova Scotia     3007 69 1878 1060 44.682 -63.7443 2021-05-05 04:20:43 Nova Scotia, Canada
764460 764460 2021-05-04 Canada Nunavut     535 4 446 85 70.2998 -83.1076 2021-05-05 04:20:43 Nunavut, Canada
764461 764461 2021-05-04 Canada Ontario     485172 8146 445861 31165 51.2538 -85.3232 2021-05-05 04:20:43 Ontario, Canada
764462 764462 2021-05-04 Canada Prince Edward Island     183 0 176 7 46.5107 -63.4168 2021-05-05 04:20:43 Prince Edward Island, Canada
764463 764463 2021-05-04 Canada Quebec     353475 10959 333624 8892 52.9399 -73.5491 2021-05-05 04:20:43 Quebec, Canada
764464 764464 2021-05-04 Canada Repatriated Travellers     13 0 13 0     2021-05-05 04:20:43 Repatriated Travellers, Canada
764465 764465 2021-05-04 Canada Saskatchewan     42006 499 39202 2305 52.9399 -106.4509 2021-05-05 04:20:43 Saskatchewan, Canada
764466 764466 2021-05-04 Canada Yukon     82 2 79 1 64.2823 -135.0 2021-05-05 04:20:43 Yukon, Canada
802526 802526 2021-05-03 Canada Alberta     196910 2090 171212 23608 53.9333 -116.5765 2021-05-04 04:20:34 Alberta, Canada
802527 802527 2021-05-03 Canada British Columbia     131656 1596 122518 7542 53.7267 -127.6476 2021-05-04 04:20:34 British Columbia, Canada
802528 802528 2021-05-03 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
802529 802529 2021-05-03 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
802530 802530 2021-05-03 Canada Manitoba     39524 979 35952 2593 53.7609 -98.8139 2021-05-04 04:20:34 Manitoba, Canada
802531 802531 2021-05-03 Canada New Brunswick     1954 38 1773 143 46.5653 -66.4619 2021-05-04 04:20:34 New Brunswick, Canada
802532 802532 2021-05-03 Canada Newfoundland and Labrador     1104 6 1038 60 53.1355 -57.6604 2021-05-04 04:20:34 Newfoundland and Labrador, Canada
802533 802533 2021-05-03 Canada Northwest Territories     65 0 56 9 64.8255 -124.8457 2021-05-04 04:20:34 Northwest Territories,Canada
802534 802534 2021-05-03 Canada Nova Scotia     2854 67 1844 943 44.682 -63.7443 2021-05-04 04:20:34 Nova Scotia, Canada
802535 802535 2021-05-03 Canada Nunavut     528 4 439 85 70.2998 -83.1076 2021-05-04 04:20:34 Nunavut, Canada
802536 802536 2021-05-03 Canada Ontario     482447 8109 442002 32336 51.2538 -85.3232 2021-05-04 04:20:34 Ontario, Canada
802537 802537 2021-05-03 Canada Prince Edward Island     177 0 166 11 46.5107 -63.4168 2021-05-04 04:20:34 Prince Edward Island, Canada
802538 802538 2021-05-03 Canada Quebec     352678 10944 332577 9157 52.9399 -73.5491 2021-05-04 04:20:34 Quebec, Canada
802539 802539 2021-05-03 Canada Repatriated Travellers     13 0 13 0     2021-05-04 04:20:34 Repatriated Travellers, Canada
802540 802540 2021-05-03 Canada Saskatchewan     41806 498 38911 2397 52.9399 -106.4509 2021-05-04 04:20:34 Saskatchewan, Canada
802541 802541 2021-05-03 Canada Yukon     82 2 79 1 64.2823 -135.0 2021-05-04 04:20:34 Yukon, Canada
526205 526205 2021-05-02 Canada Alberta     194898 2086 169892 22920 53.9333 -116.5765 2021-05-03 04:20:39 Alberta, Canada
526206 526206 2021-05-02 Canada British Columbia     129482 1581 119785 8116 53.7267 -127.6476 2021-05-03 04:20:39 British Columbia, Canada
526207 526207 2021-05-02 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
526208 526208 2021-05-02 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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]);