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

7,376 rows where country_or_region = "Canada" sorted by day descending

View and edit SQL

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

country_or_region

  • Canada · 7,376
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
234679 2021-06-24 Canada Alberta     231641 2293 227768 1580 53.9333 -116.5765 2021-06-25 04:21:33 Alberta, Canada
234680 2021-06-24 Canada British Columbia     147346 1747 144466 1133 53.7267 -127.6476 2021-06-25 04:21:33 British Columbia, Canada
234681 2021-06-24 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
234682 2021-06-24 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
234683 2021-06-24 Canada Manitoba     55692 1134 52843 1715 53.7609 -98.8139 2021-06-25 04:21:33 Manitoba, Canada
234684 2021-06-24 Canada New Brunswick     2322 45 2236 41 46.5653 -66.4619 2021-06-25 04:21:33 New Brunswick, Canada
234685 2021-06-24 Canada Newfoundland and Labrador     1384 7 1366 11 53.1355 -57.6604 2021-06-25 04:21:33 Newfoundland and Labrador, Canada
234686 2021-06-24 Canada Northwest Territories     128 0 128 0 64.8255 -124.8457 2021-06-25 04:21:33 Northwest Territories,Canada
234687 2021-06-24 Canada Nova Scotia     5798 92 5647 59 44.682 -63.7443 2021-06-25 04:21:33 Nova Scotia, Canada
234688 2021-06-24 Canada Nunavut     657 4 653 0 70.2998 -83.1076 2021-06-25 04:21:33 Nunavut, Canada
234689 2021-06-24 Canada Ontario     550848 9068 538533 3247 51.2538 -85.3232 2021-06-25 04:21:33 Ontario, Canada
234690 2021-06-24 Canada Prince Edward Island     206 0 206 0 46.5107 -63.4168 2021-06-25 04:21:33 Prince Edward Island, Canada
234691 2021-06-24 Canada Quebec     374318 11202 361952 1164 52.9399 -73.5491 2021-06-25 04:21:33 Quebec, Canada
234692 2021-06-24 Canada Repatriated Travellers     13 0 13 0     2021-06-25 04:21:33 Repatriated Travellers, Canada
234693 2021-06-24 Canada Saskatchewan     48590 565 47420 605 52.9399 -106.4509 2021-06-25 04:21:33 Saskatchewan, Canada
234694 2021-06-24 Canada Yukon     242 4 135 103 64.2823 -135.0 2021-06-25 04:21:33 Yukon, Canada
471627 2021-06-23 Canada Alberta     231568 2292 227600 1676 53.9333 -116.5765 2021-06-24 04:21:55 Alberta, Canada
471628 2021-06-23 Canada British Columbia     147271 1744 144383 1144 53.7267 -127.6476 2021-06-24 04:21:55 British Columbia, Canada
471629 2021-06-23 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
471630 2021-06-23 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
471631 2021-06-23 Canada Manitoba     55589 1132 52668 1789 53.7609 -98.8139 2021-06-24 04:21:55 Manitoba, Canada
471632 2021-06-23 Canada New Brunswick     2320 45 2231 44 46.5653 -66.4619 2021-06-24 04:21:55 New Brunswick, Canada
471633 2021-06-23 Canada Newfoundland and Labrador     1384 7 1360 17 53.1355 -57.6604 2021-06-24 04:21:55 Newfoundland and Labrador, Canada
471634 2021-06-23 Canada Northwest Territories     128 0 128 0 64.8255 -124.8457 2021-06-24 04:21:55 Northwest Territories,Canada
471635 2021-06-23 Canada Nova Scotia     5793 92 5641 60 44.682 -63.7443 2021-06-24 04:21:55 Nova Scotia, Canada
471636 2021-06-23 Canada Nunavut     657 4 653 0 70.2998 -83.1076 2021-06-24 04:21:55 Nunavut, Canada
471637 2021-06-23 Canada Ontario     550542 9061 538183 3298 51.2538 -85.3232 2021-06-24 04:21:55 Ontario, Canada
471638 2021-06-23 Canada Prince Edward Island     206 0 206 0 46.5107 -63.4168 2021-06-24 04:21:55 Prince Edward Island, Canada
471639 2021-06-23 Canada Quebec     374222 11198 361840 1184 52.9399 -73.5491 2021-06-24 04:21:55 Quebec, Canada
471640 2021-06-23 Canada Repatriated Travellers     13 0 13 0     2021-06-24 04:21:55 Repatriated Travellers, Canada
471641 2021-06-23 Canada Saskatchewan     48537 565 47365 607 52.9399 -106.4509 2021-06-24 04:21:55 Saskatchewan, Canada
471642 2021-06-23 Canada Yukon     224 3 122 99 64.2823 -135.0 2021-06-24 04:21:55 Yukon, Canada
626685 2021-06-22 Canada Alberta     231476 2290 227413 1773 53.9333 -116.5765 2021-06-23 04:21:46 Alberta, Canada
626686 2021-06-22 Canada British Columbia     147187 1743 144263 1181 53.7267 -127.6476 2021-06-23 04:21:46 British Columbia, Canada
626687 2021-06-22 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
626688 2021-06-22 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
626689 2021-06-22 Canada Manitoba     55467 1129 52478 1860 53.7609 -98.8139 2021-06-23 04:21:46 Manitoba, Canada
626690 2021-06-22 Canada New Brunswick     2319 45 2224 50 46.5653 -66.4619 2021-06-23 04:21:46 New Brunswick, Canada
626691 2021-06-22 Canada Newfoundland and Labrador     1384 7 1360 17 53.1355 -57.6604 2021-06-23 04:21:46 Newfoundland and Labrador, Canada
626692 2021-06-22 Canada Northwest Territories     128 0 128 0 64.8255 -124.8457 2021-06-23 04:21:46 Northwest Territories,Canada
626693 2021-06-22 Canada Nova Scotia     5793 92 5627 74 44.682 -63.7443 2021-06-23 04:21:46 Nova Scotia, Canada
626694 2021-06-22 Canada Nunavut     657 4 653 0 70.2998 -83.1076 2021-06-23 04:21:46 Nunavut, Canada
626695 2021-06-22 Canada Ontario     550239 9047 537644 3548 51.2538 -85.3232 2021-06-23 04:21:46 Ontario, Canada
626696 2021-06-22 Canada Prince Edward Island     206 0 206 0 46.5107 -63.4168 2021-06-23 04:21:46 Prince Edward Island, Canada
626697 2021-06-22 Canada Quebec     374095 11195 361675 1225 52.9399 -73.5491 2021-06-23 04:21:46 Quebec, Canada
626698 2021-06-22 Canada Repatriated Travellers     13 0 13 0     2021-06-23 04:21:46 Repatriated Travellers, Canada
626699 2021-06-22 Canada Saskatchewan     48505 565 47301 639 52.9399 -106.4509 2021-06-23 04:21:46 Saskatchewan, Canada
626700 2021-06-22 Canada Yukon     220 3 125 92 64.2823 -135.0 2021-06-23 04:21:46 Yukon, Canada
226705 2021-06-21 Canada Alberta     231419 2292 227124 2003 53.9333 -116.5765 2021-06-22 04:21:34 Alberta, Canada
226706 2021-06-21 Canada British Columbia     147131 1743 144153 1235 53.7267 -127.6476 2021-06-22 04:21:34 British Columbia, Canada
226707 2021-06-21 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
226708 2021-06-21 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
226709 2021-06-21 Canada Manitoba     55405 1125 52205 2075 53.7609 -98.8139 2021-06-22 04:21:34 Manitoba, Canada
226710 2021-06-21 Canada New Brunswick     2318 45 2218 55 46.5653 -66.4619 2021-06-22 04:21:34 New Brunswick, Canada
226711 2021-06-21 Canada Newfoundland and Labrador     1383 7 1350 26 53.1355 -57.6604 2021-06-22 04:21:34 Newfoundland and Labrador, Canada
226712 2021-06-21 Canada Northwest Territories     128 0 128 0 64.8255 -124.8457 2021-06-22 04:21:34 Northwest Territories,Canada
226713 2021-06-21 Canada Nova Scotia     5791 90 5622 79 44.682 -63.7443 2021-06-22 04:21:34 Nova Scotia, Canada
226714 2021-06-21 Canada Nunavut     657 4 645 8 70.2998 -83.1076 2021-06-22 04:21:34 Nunavut, Canada
226715 2021-06-21 Canada Ontario     550084 9037 537340 3707 51.2538 -85.3232 2021-06-22 04:21:34 Ontario, Canada
226716 2021-06-21 Canada Prince Edward Island     206 0 206 0 46.5107 -63.4168 2021-06-22 04:21:34 Prince Edward Island, Canada
226717 2021-06-21 Canada Quebec     374011 11191 361521 1299 52.9399 -73.5491 2021-06-22 04:21:34 Quebec, Canada
226718 2021-06-21 Canada Repatriated Travellers     13 0 13 0     2021-06-22 04:21:34 Repatriated Travellers, Canada
226719 2021-06-21 Canada Saskatchewan     48490 565 47214 711 52.9399 -106.4509 2021-06-22 04:21:34 Saskatchewan, Canada
226720 2021-06-21 Canada Yukon     187 3 100 84 64.2823 -135.0 2021-06-22 04:21:34 Yukon, Canada
1472227 2021-06-20 Canada Alberta     231359 2290 226942 2127 53.9333 -116.5765 2021-06-21 04:21:41 Alberta, Canada
1472228 2021-06-20 Canada British Columbia     146902 1740 143748 1414 53.7267 -127.6476 2021-06-21 04:21:41 British Columbia, Canada
1472229 2021-06-20 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
1472230 2021-06-20 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
1472231 2021-06-20 Canada Manitoba     55331 1124 52041 2166 53.7609 -98.8139 2021-06-21 04:21:41 Manitoba, Canada
1472232 2021-06-20 Canada New Brunswick     2318 45 2216 57 46.5653 -66.4619 2021-06-21 04:21:41 New Brunswick, Canada
1472233 2021-06-20 Canada Newfoundland and Labrador     1383 7 1350 26 53.1355 -57.6604 2021-06-21 04:21:41 Newfoundland and Labrador, Canada
1472234 2021-06-20 Canada Northwest Territories     128 0 128 0 64.8255 -124.8457 2021-06-21 04:21:41 Northwest Territories,Canada
1472235 2021-06-20 Canada Nova Scotia     5791 90 5618 -457 44.682 -63.7443 2021-06-21 04:21:41 Nova Scotia, Canada
1472236 2021-06-20 Canada Nunavut     657 4 645 8 70.2998 -83.1076 2021-06-21 04:21:41 Nunavut, Canada
1472237 2021-06-20 Canada Ontario     549553 8997 536374 4182 51.2538 -85.3232 2021-06-21 04:21:41 Ontario, Canada
1472238 2021-06-20 Canada Prince Edward Island     206 0 206 0 46.5107 -63.4168 2021-06-21 04:21:41 Prince Edward Island, Canada
1472239 2021-06-20 Canada Quebec     373921 11191 361352 1378 52.9399 -73.5491 2021-06-21 04:21:41 Quebec, Canada
1472240 2021-06-20 Canada Repatriated Travellers     13 0 13 0     2021-06-21 04:21:41 Repatriated Travellers, Canada
1472241 2021-06-20 Canada Saskatchewan     48441 563 47135 743 52.9399 -106.4509 2021-06-21 04:21:41 Saskatchewan, Canada
1472242 2021-06-20 Canada Yukon     187 3 100 84 64.2823 -135.0 2021-06-21 04:21:41 Yukon, Canada
1303468 2021-06-19 Canada Alberta     231259 2289 226800 2170 53.9333 -116.5765 2021-06-20 04:21:48 Alberta, Canada
1303469 2021-06-19 Canada British Columbia     146902 1740 143748 1414 53.7267 -127.6476 2021-06-20 04:21:48 British Columbia, Canada
1303470 2021-06-19 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
1303471 2021-06-19 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
1303472 2021-06-19 Canada Manitoba     55238 1118 51813 2307 53.7609 -98.8139 2021-06-20 04:21:48 Manitoba, Canada
1303473 2021-06-19 Canada New Brunswick     2316 45 2215 56 46.5653 -66.4619 2021-06-20 04:21:48 New Brunswick, Canada
1303474 2021-06-19 Canada Newfoundland and Labrador     1383 7 1350 26 53.1355 -57.6604 2021-06-20 04:21:48 Newfoundland and Labrador, Canada
1303475 2021-06-19 Canada Northwest Territories     128 0 128 0 64.8255 -124.8457 2021-06-20 04:21:48 Northwest Territories,Canada
1303476 2021-06-19 Canada Nova Scotia     5789 90 5611 88 44.682 -63.7443 2021-06-20 04:21:48 Nova Scotia, Canada
1303477 2021-06-19 Canada Nunavut     657 4 645 8 70.2998 -83.1076 2021-06-20 04:21:48 Nunavut, Canada
1303478 2021-06-19 Canada Ontario     549324 8994 536047 4283 51.2538 -85.3232 2021-06-20 04:21:48 Ontario, Canada
1303479 2021-06-19 Canada Prince Edward Island     206 0 206 0 46.5107 -63.4168 2021-06-20 04:21:48 Prince Edward Island, Canada
1303480 2021-06-19 Canada Quebec     373818 11189 361160 1469 52.9399 -73.5491 2021-06-20 04:21:48 Quebec, Canada
1303481 2021-06-19 Canada Repatriated Travellers     13 0 13 0     2021-06-20 04:21:48 Repatriated Travellers, Canada
1303482 2021-06-19 Canada Saskatchewan     48381 562 47059 760 52.9399 -106.4509 2021-06-20 04:21:48 Saskatchewan, Canada
1303483 2021-06-19 Canada Yukon     187 3 100 84 64.2823 -135.0 2021-06-20 04:21:48 Yukon, Canada
303070 2021-06-18 Canada Alberta     231132 2283 226513 2336 53.9333 -116.5765 2021-06-19 04:22:33 Alberta, Canada
303071 2021-06-18 Canada British Columbia     146902 1740 143748 1414 53.7267 -127.6476 2021-06-19 04:22:33 British Columbia, Canada
303072 2021-06-18 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
303073 2021-06-18 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] INTEGER,
   [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]);