⚠️ 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

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 2021-05-08 Canada Alberta     207157 2108 179894 25155 53.9333 -116.5765 2021-05-09 04:20:35 Alberta, Canada
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 2021-05-08 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
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 2021-05-08 Canada Manitoba     41425 990 37198 3237 53.7609 -98.8139 2021-05-09 04:20:35 Manitoba, Canada
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 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 2021-05-08 Canada Northwest Territories     105 0 57 48 64.8255 -124.8457 2021-05-09 04:20:35 Northwest Territories,Canada
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 2021-05-08 Canada Nunavut     560 4 482 74 70.2998 -83.1076 2021-05-09 04:20:35 Nunavut, Canada
1020001 2021-05-08 Canada Ontario     497032 8246 459438 29348 51.2538 -85.3232 2021-05-09 04:20:35 Ontario, Canada
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 2021-05-08 Canada Quebec     357174 10981 337538 8655 52.9399 -73.5491 2021-05-09 04:20:35 Quebec, Canada
1020004 2021-05-08 Canada Repatriated Travellers     13 0 13 0     2021-05-09 04:20:35 Repatriated Travellers, Canada
1020005 2021-05-08 Canada Saskatchewan     42964 502 40169 2293 52.9399 -106.4509 2021-05-09 04:20:35 Saskatchewan, Canada
1020006 2021-05-08 Canada Yukon     82 2 79 1 64.2823 -135.0 2021-05-09 04:20:35 Yukon, Canada
928164 2021-05-07 Canada Alberta     205115 2106 178149 24860 53.9333 -116.5765 2021-05-08 04:21:04 Alberta, Canada
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 2021-05-07 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
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 2021-05-07 Canada Manitoba     40940 987 36964 2989 53.7609 -98.8139 2021-05-08 04:21:04 Manitoba, Canada
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 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 2021-05-07 Canada Northwest Territories     105 0 57 48 64.8255 -124.8457 2021-05-08 04:21:04 Northwest Territories,Canada
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 2021-05-07 Canada Nunavut     553 4 472 77 70.2998 -83.1076 2021-05-08 04:21:04 Nunavut, Canada
928174 2021-05-07 Canada Ontario     494884 8229 457032 29623 51.2538 -85.3232 2021-05-08 04:21:04 Ontario, Canada
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 2021-05-07 Canada Quebec     356216 10974 336505 8737 52.9399 -73.5491 2021-05-08 04:21:04 Quebec, Canada
928177 2021-05-07 Canada Repatriated Travellers     13 0 13 0     2021-05-08 04:21:04 Repatriated Travellers, Canada
928178 2021-05-07 Canada Saskatchewan     42695 502 39954 2239 52.9399 -106.4509 2021-05-08 04:21:04 Saskatchewan, Canada
928179 2021-05-07 Canada Yukon     82 2 79 1 64.2823 -135.0 2021-05-08 04:21:04 Yukon, Canada
622234 2021-05-06 Canada Alberta     203135 2102 176536 24497 53.9333 -116.5765 2021-05-07 04:20:40 Alberta, Canada
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 2021-05-06 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
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 2021-05-06 Canada Manitoba     40442 986 36724 2732 53.7609 -98.8139 2021-05-07 04:20:40 Manitoba, Canada
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 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 2021-05-06 Canada Northwest Territories     104 0 57 47 64.8255 -124.8457 2021-05-07 04:20:40 Northwest Territories,Canada
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 2021-05-06 Canada Nunavut     552 4 462 86 70.2998 -83.1076 2021-05-07 04:20:40 Nunavut, Canada
622244 2021-05-06 Canada Ontario     491926 8202 453379 30345 51.2538 -85.3232 2021-05-07 04:20:40 Ontario, Canada
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 2021-05-06 Canada Quebec     355297 10971 335421 8905 52.9399 -73.5491 2021-05-07 04:20:40 Quebec, Canada
622247 2021-05-06 Canada Repatriated Travellers     13 0 13 0     2021-05-07 04:20:40 Repatriated Travellers, Canada
622248 2021-05-06 Canada Saskatchewan     42376 501 39717 2158 52.9399 -106.4509 2021-05-07 04:20:40 Saskatchewan, Canada
622249 2021-05-06 Canada Yukon     82 2 79 1 64.2823 -135.0 2021-05-07 04:20:40 Yukon, Canada
452747 2021-05-05 Canada Alberta     200924 2102 174666 24156 53.9333 -116.5765 2021-05-06 04:20:38 Alberta, Canada
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 2021-05-05 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
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 2021-05-05 Canada Manitoba     40085 982 36323 2780 53.7609 -98.8139 2021-05-06 04:20:38 Manitoba, Canada
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 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 2021-05-05 Canada Northwest Territories     91 0 57 34 64.8255 -124.8457 2021-05-06 04:20:38 Northwest Territories,Canada
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 2021-05-05 Canada Nunavut     540 4 454 82 70.2998 -83.1076 2021-05-06 04:20:38 Nunavut, Canada
452757 2021-05-05 Canada Ontario     488535 8173 449670 30692 51.2538 -85.3232 2021-05-06 04:20:38 Ontario, Canada
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 2021-05-05 Canada Quebec     354390 10964 334531 8895 52.9399 -73.5491 2021-05-06 04:20:38 Quebec, Canada
452760 2021-05-05 Canada Repatriated Travellers     13 0 13 0     2021-05-06 04:20:38 Repatriated Travellers, Canada
452761 2021-05-05 Canada Saskatchewan     42203 501 39452 2250 52.9399 -106.4509 2021-05-06 04:20:38 Saskatchewan, Canada
452762 2021-05-05 Canada Yukon     82 2 79 1 64.2823 -135.0 2021-05-06 04:20:38 Yukon, Canada
764451 2021-05-04 Canada Alberta     198653 2099 172931 23623 53.9333 -116.5765 2021-05-05 04:20:43 Alberta, Canada
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 2021-05-04 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
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 2021-05-04 Canada Manitoba     39814 980 36142 2692 53.7609 -98.8139 2021-05-05 04:20:43 Manitoba, Canada
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 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 2021-05-04 Canada Northwest Territories     77 0 57 20 64.8255 -124.8457 2021-05-05 04:20:43 Northwest Territories,Canada
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 2021-05-04 Canada Nunavut     535 4 446 85 70.2998 -83.1076 2021-05-05 04:20:43 Nunavut, Canada
764461 2021-05-04 Canada Ontario     485172 8146 445861 31165 51.2538 -85.3232 2021-05-05 04:20:43 Ontario, Canada
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 2021-05-04 Canada Quebec     353475 10959 333624 8892 52.9399 -73.5491 2021-05-05 04:20:43 Quebec, Canada
764464 2021-05-04 Canada Repatriated Travellers     13 0 13 0     2021-05-05 04:20:43 Repatriated Travellers, Canada
764465 2021-05-04 Canada Saskatchewan     42006 499 39202 2305 52.9399 -106.4509 2021-05-05 04:20:43 Saskatchewan, Canada
764466 2021-05-04 Canada Yukon     82 2 79 1 64.2823 -135.0 2021-05-05 04:20:43 Yukon, Canada
802526 2021-05-03 Canada Alberta     196910 2090 171212 23608 53.9333 -116.5765 2021-05-04 04:20:34 Alberta, Canada
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 2021-05-03 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
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 2021-05-03 Canada Manitoba     39524 979 35952 2593 53.7609 -98.8139 2021-05-04 04:20:34 Manitoba, Canada
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 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 2021-05-03 Canada Northwest Territories     65 0 56 9 64.8255 -124.8457 2021-05-04 04:20:34 Northwest Territories,Canada
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 2021-05-03 Canada Nunavut     528 4 439 85 70.2998 -83.1076 2021-05-04 04:20:34 Nunavut, Canada
802536 2021-05-03 Canada Ontario     482447 8109 442002 32336 51.2538 -85.3232 2021-05-04 04:20:34 Ontario, Canada
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 2021-05-03 Canada Quebec     352678 10944 332577 9157 52.9399 -73.5491 2021-05-04 04:20:34 Quebec, Canada
802539 2021-05-03 Canada Repatriated Travellers     13 0 13 0     2021-05-04 04:20:34 Repatriated Travellers, Canada
802540 2021-05-03 Canada Saskatchewan     41806 498 38911 2397 52.9399 -106.4509 2021-05-04 04:20:34 Saskatchewan, Canada
802541 2021-05-03 Canada Yukon     82 2 79 1 64.2823 -135.0 2021-05-04 04:20:34 Yukon, Canada
526205 2021-05-02 Canada Alberta     194898 2086 169892 22920 53.9333 -116.5765 2021-05-03 04:20:39 Alberta, Canada
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 2021-05-02 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
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]);