⚠️ 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,296 rows where country_or_region = "Canada" sorted by day descending

View and edit SQL

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

country_or_region

  • Canada · 7,296
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
168223 2021-06-19 Canada Alberta     231259 2289 226800 2170 53.9333 -116.5765 2021-06-20 04:21:48 Alberta, Canada
168224 2021-06-19 Canada British Columbia     146902 1740 143748 1414 53.7267 -127.6476 2021-06-20 04:21:48 British Columbia, Canada
168225 2021-06-19 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
168226 2021-06-19 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
168227 2021-06-19 Canada Manitoba     55238 1118 51813 2307 53.7609 -98.8139 2021-06-20 04:21:48 Manitoba, Canada
168228 2021-06-19 Canada New Brunswick     2316 45 2215 56 46.5653 -66.4619 2021-06-20 04:21:48 New Brunswick, Canada
168229 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
168230 2021-06-19 Canada Northwest Territories     128 0 128 0 64.8255 -124.8457 2021-06-20 04:21:48 Northwest Territories,Canada
168231 2021-06-19 Canada Nova Scotia     5789 90 5611 88 44.682 -63.7443 2021-06-20 04:21:48 Nova Scotia, Canada
168232 2021-06-19 Canada Nunavut     657 4 645 8 70.2998 -83.1076 2021-06-20 04:21:48 Nunavut, Canada
168233 2021-06-19 Canada Ontario     549324 8994 536047 4283 51.2538 -85.3232 2021-06-20 04:21:48 Ontario, Canada
168234 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
168235 2021-06-19 Canada Quebec     373818 11189 361160 1469 52.9399 -73.5491 2021-06-20 04:21:48 Quebec, Canada
168236 2021-06-19 Canada Repatriated Travellers     13 0 13 0     2021-06-20 04:21:48 Repatriated Travellers, Canada
168237 2021-06-19 Canada Saskatchewan     48381 562 47059 760 52.9399 -106.4509 2021-06-20 04:21:48 Saskatchewan, Canada
168238 2021-06-19 Canada Yukon     187 3 100 84 64.2823 -135.0 2021-06-20 04:21:48 Yukon, Canada
685748 2021-06-18 Canada Alberta     231132 2283 226513 2336 53.9333 -116.5765 2021-06-19 04:22:33 Alberta, Canada
685749 2021-06-18 Canada British Columbia     146902 1740 143748 1414 53.7267 -127.6476 2021-06-19 04:22:33 British Columbia, Canada
685750 2021-06-18 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
685751 2021-06-18 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
685752 2021-06-18 Canada Manitoba     55098 1115 51547 2436 53.7609 -98.8139 2021-06-19 04:22:33 Manitoba, Canada
685753 2021-06-18 Canada New Brunswick     2311 45 2211 55 46.5653 -66.4619 2021-06-19 04:22:33 New Brunswick, Canada
685754 2021-06-18 Canada Newfoundland and Labrador     1383 7 1350 26 53.1355 -57.6604 2021-06-19 04:22:33 Newfoundland and Labrador, Canada
685755 2021-06-18 Canada Northwest Territories     128 0 128 0 64.8255 -124.8457 2021-06-19 04:22:33 Northwest Territories,Canada
685756 2021-06-18 Canada Nova Scotia     5784 90 5601 93 44.682 -63.7443 2021-06-19 04:22:33 Nova Scotia, Canada
685757 2021-06-18 Canada Nunavut     657 4 645 8 70.2998 -83.1076 2021-06-19 04:22:33 Nunavut, Canada
685758 2021-06-18 Canada Ontario     549048 8986 535668 4394 51.2538 -85.3232 2021-06-19 04:22:33 Ontario, Canada
685759 2021-06-18 Canada Prince Edward Island     206 0 206 0 46.5107 -63.4168 2021-06-19 04:22:33 Prince Edward Island, Canada
685760 2021-06-18 Canada Quebec     373658 11180 360973 1505 52.9399 -73.5491 2021-06-19 04:22:33 Quebec, Canada
685761 2021-06-18 Canada Repatriated Travellers     13 0 13 0     2021-06-19 04:22:33 Repatriated Travellers, Canada
685762 2021-06-18 Canada Saskatchewan     48327 562 47002 763 52.9399 -106.4509 2021-06-19 04:22:33 Saskatchewan, Canada
685763 2021-06-18 Canada Yukon     145 3 91 51 64.2823 -135.0 2021-06-19 04:22:33 Yukon, Canada
957805 2021-06-17 Canada Alberta     231008 2280 226257 2471 53.9333 -116.5765 2021-06-18 04:22:16 Alberta, Canada
957806 2021-06-17 Canada British Columbia     146794 1739 143579 1476 53.7267 -127.6476 2021-06-18 04:22:16 British Columbia, Canada
957807 2021-06-17 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
957808 2021-06-17 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
957809 2021-06-17 Canada Manitoba     54915 1112 51271 2532 53.7609 -98.8139 2021-06-18 04:22:16 Manitoba, Canada
957810 2021-06-17 Canada New Brunswick     2309 45 2202 62 46.5653 -66.4619 2021-06-18 04:22:16 New Brunswick, Canada
957811 2021-06-17 Canada Newfoundland and Labrador     1383 7 1340 36 53.1355 -57.6604 2021-06-18 04:22:16 Newfoundland and Labrador, Canada
957812 2021-06-17 Canada Northwest Territories     128 0 128 0 64.8255 -124.8457 2021-06-18 04:22:16 Northwest Territories,Canada
957813 2021-06-17 Canada Nova Scotia     5773 90 5586 97 44.682 -63.7443 2021-06-18 04:22:16 Nova Scotia, Canada
957814 2021-06-17 Canada Nunavut     657 4 645 8 70.2998 -83.1076 2021-06-18 04:22:16 Nunavut, Canada
957815 2021-06-17 Canada Ontario     548745 8984 535219 4542 51.2538 -85.3232 2021-06-18 04:22:16 Ontario, Canada
957816 2021-06-17 Canada Prince Edward Island     206 0 206 0 46.5107 -63.4168 2021-06-18 04:22:16 Prince Edward Island, Canada
957817 2021-06-17 Canada Quebec     373531 11178 360779 1574 52.9399 -73.5491 2021-06-18 04:22:16 Quebec, Canada
957818 2021-06-17 Canada Repatriated Travellers     13 0 13 0     2021-06-18 04:22:16 Repatriated Travellers, Canada
957819 2021-06-17 Canada Saskatchewan     48220 561 46907 752 52.9399 -106.4509 2021-06-18 04:22:16 Saskatchewan, Canada
957820 2021-06-17 Canada Yukon     145 3 91 51 64.2823 -135.0 2021-06-18 04:22:16 Yukon, Canada
1281172 2021-06-16 Canada Alberta     230858 2278 225941 2639 53.9333 -116.5765 2021-06-17 04:22:36 Alberta, Canada
1281173 2021-06-16 Canada British Columbia     146674 1738 143449 1487 53.7267 -127.6476 2021-06-17 04:22:36 British Columbia, Canada
1281174 2021-06-16 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
1281175 2021-06-16 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
1281176 2021-06-16 Canada Manitoba     54739 1111 50829 2799 53.7609 -98.8139 2021-06-17 04:22:36 Manitoba, Canada
1281177 2021-06-16 Canada New Brunswick     2305 45 2201 59 46.5653 -66.4619 2021-06-17 04:22:36 New Brunswick, Canada
1281178 2021-06-16 Canada Newfoundland and Labrador     1382 7 1336 39 53.1355 -57.6604 2021-06-17 04:22:36 Newfoundland and Labrador, Canada
1281179 2021-06-16 Canada Northwest Territories     128 0 128 0 64.8255 -124.8457 2021-06-17 04:22:36 Northwest Territories,Canada
1281180 2021-06-16 Canada Nova Scotia     5759 90 5577 92 44.682 -63.7443 2021-06-17 04:22:36 Nova Scotia, Canada
1281181 2021-06-16 Canada Nunavut     657 4 645 8 70.2998 -83.1076 2021-06-17 04:22:36 Nunavut, Canada
1281182 2021-06-16 Canada Ontario     548388 8976 534694 4718 51.2538 -85.3232 2021-06-17 04:22:36 Ontario, Canada
1281183 2021-06-16 Canada Prince Edward Island     206 0 206 0 46.5107 -63.4168 2021-06-17 04:22:36 Prince Edward Island, Canada
1281184 2021-06-16 Canada Quebec     373370 11177 360587 1606 52.9399 -73.5491 2021-06-17 04:22:36 Quebec, Canada
1281185 2021-06-16 Canada Repatriated Travellers     13 0 13 0     2021-06-17 04:22:36 Repatriated Travellers, Canada
1281186 2021-06-16 Canada Saskatchewan     48125 562 46837 726 52.9399 -106.4509 2021-06-17 04:22:36 Saskatchewan, Canada
1281187 2021-06-16 Canada Yukon     120 3 86 46 64.2823 -135.0 2021-06-17 04:22:36 Yukon, Canada
681762 2021-06-15 Canada Alberta     230705 2274 225627 2804 53.9333 -116.5765 2021-06-16 04:22:32 Alberta, Canada
681763 2021-06-15 Canada British Columbia     146561 1734 143299 1528 53.7267 -127.6476 2021-06-16 04:22:32 British Columbia, Canada
681764 2021-06-15 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
681765 2021-06-15 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
681766 2021-06-15 Canada Manitoba     54596 1104 50520 2972 53.7609 -98.8139 2021-06-16 04:22:32 Manitoba, Canada
681767 2021-06-15 Canada New Brunswick     2302 45 2171 86 46.5653 -66.4619 2021-06-16 04:22:32 New Brunswick, Canada
681768 2021-06-15 Canada Newfoundland and Labrador     1381 7 1329 45 53.1355 -57.6604 2021-06-16 04:22:32 Newfoundland and Labrador, Canada
681769 2021-06-15 Canada Northwest Territories     128 0 128 0 64.8255 -124.8457 2021-06-16 04:22:32 Northwest Territories,Canada
681770 2021-06-15 Canada Nova Scotia     5751 90 5564 97 44.682 -63.7443 2021-06-16 04:22:32 Nova Scotia, Canada
681771 2021-06-15 Canada Nunavut     657 4 645 8 70.2998 -83.1076 2021-06-16 04:22:32 Nunavut, Canada
681772 2021-06-15 Canada Ontario     547959 8944 534007 5008 51.2538 -85.3232 2021-06-16 04:22:32 Ontario, Canada
681773 2021-06-15 Canada Prince Edward Island     206 0 206 0 46.5107 -63.4168 2021-06-16 04:22:32 Prince Edward Island, Canada
681774 2021-06-15 Canada Quebec     373217 11177 360410 1630 52.9399 -73.5491 2021-06-16 04:22:32 Quebec, Canada
681775 2021-06-15 Canada Repatriated Travellers     13 0 13 0     2021-06-16 04:22:32 Repatriated Travellers, Canada
681776 2021-06-15 Canada Saskatchewan     48043 560 46761 722 52.9399 -106.4509 2021-06-16 04:22:32 Saskatchewan, Canada
681777 2021-06-15 Canada Yukon     120 3 86 31 64.2823 -135.0 2021-06-16 04:22:32 Yukon, Canada
372316 2021-06-14 Canada Alberta     230578 2270 225219 3089 53.9333 -116.5765 2021-06-15 04:22:22 Alberta, Canada
372317 2021-06-14 Canada British Columbia     146453 1734 143147 1572 53.7267 -127.6476 2021-06-15 04:22:22 British Columbia, Canada
372318 2021-06-14 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
372319 2021-06-14 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
372320 2021-06-14 Canada Manitoba     54481 1102 50268 3111 53.7609 -98.8139 2021-06-15 04:22:22 Manitoba, Canada
372321 2021-06-14 Canada New Brunswick     2299 45 2163 91 46.5653 -66.4619 2021-06-15 04:22:22 New Brunswick, Canada
372322 2021-06-14 Canada Newfoundland and Labrador     1379 7 1329 43 53.1355 -57.6604 2021-06-15 04:22:22 Newfoundland and Labrador, Canada
372323 2021-06-14 Canada Northwest Territories     128 0 128 0 64.8255 -124.8457 2021-06-15 04:22:22 Northwest Territories,Canada
372324 2021-06-14 Canada Nova Scotia     5749 90 5535 124 44.682 -63.7443 2021-06-15 04:22:22 Nova Scotia, Canada
372325 2021-06-14 Canada Nunavut     657 4 644 9 70.2998 -83.1076 2021-06-15 04:22:22 Nunavut, Canada
372326 2021-06-14 Canada Ontario     547657 8936 533335 5386 51.2538 -85.3232 2021-06-15 04:22:22 Ontario, Canada
372327 2021-06-14 Canada Prince Edward Island     206 0 202 4 46.5107 -63.4168 2021-06-15 04:22:22 Prince Edward Island, Canada
372328 2021-06-14 Canada Quebec     373112 11173 360194 1745 52.9399 -73.5491 2021-06-15 04:22:22 Quebec, Canada
372329 2021-06-14 Canada Repatriated Travellers     13 0 13 0     2021-06-15 04:22:22 Repatriated Travellers, Canada
372330 2021-06-14 Canada Saskatchewan     47996 556 46666 774 52.9399 -106.4509 2021-06-15 04:22:22 Saskatchewan, Canada
372331 2021-06-14 Canada Yukon     107 3 85 19 64.2823 -135.0 2021-06-15 04:22:22 Yukon, Canada
1223132 2021-06-13 Canada Alberta     230463 2270 225013 3180 53.9333 -116.5765 2021-06-14 04:22:46 Alberta, Canada
1223133 2021-06-13 Canada British Columbia     146176 1730 142526 1920 53.7267 -127.6476 2021-06-14 04:22:46 British Columbia, Canada
1223134 2021-06-13 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
1223135 2021-06-13 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]);