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

5,536 rows where country_or_region = "Canada" sorted by day descending

View and edit SQL

Suggested facets: longitude, combined_key, last_update (date)

country_or_region

  • Canada · 5,536
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
801049 2021-03-01 Canada Alberta     133795 1888 127233 4674 53.9333 -116.5765 2021-03-02 05:23:30 Alberta, Canada
801050 2021-03-01 Canada British Columbia     80672 1363 74776 4533 53.7267 -127.6476 2021-03-02 05:23:30 British Columbia, Canada
801051 2021-03-01 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
801052 2021-03-01 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
801053 2021-03-01 Canada Manitoba     31894 896 29827 1171 53.7609 -98.8139 2021-03-02 05:23:30 Manitoba, Canada
801054 2021-03-01 Canada New Brunswick     1431 27 1367 37 46.5653 -66.4619 2021-03-02 05:23:30 New Brunswick, Canada
801055 2021-03-01 Canada Newfoundland and Labrador     989 6 743 240 53.1355 -57.6604 2021-03-02 05:23:30 Newfoundland and Labrador, Canada
801056 2021-03-01 Canada Northwest Territories     47 0 44 3 64.8255 -124.8457 2021-03-02 05:23:30 Northwest Territories,Canada
801057 2021-03-01 Canada Nova Scotia     1642 65 1542 35 44.682 -63.7443 2021-03-02 05:23:30 Nova Scotia, Canada
801058 2021-03-01 Canada Nunavut     358 1 349 8 70.2998 -83.1076 2021-03-02 05:23:30 Nunavut, Canada
801059 2021-03-01 Canada Ontario     307176 6982 289928 10266 51.2538 -85.3232 2021-03-02 05:23:30 Ontario, Canada
801060 2021-03-01 Canada Prince Edward Island     132 0 114 18 46.5107 -63.4168 2021-03-02 05:23:30 Prince Edward Island, Canada
801061 2021-03-01 Canada Quebec     288353 10399 270364 7590 52.9399 -73.5491 2021-03-02 05:23:30 Quebec, Canada
801062 2021-03-01 Canada Repatriated Travellers     13 0 13 0     2021-03-02 05:23:30 Repatriated Travellers, Canada
801063 2021-03-01 Canada Saskatchewan     28801 385 26865 1551 52.9399 -106.4509 2021-03-02 05:23:30 Saskatchewan, Canada
801064 2021-03-01 Canada Yukon     72 1 71 0 64.2823 -135.0 2021-03-02 05:23:30 Yukon, Canada
1066191 2021-02-28 Canada Alberta     133504 1886 127034 4584 53.9333 -116.5765 2021-03-01 05:23:01 Alberta, Canada
1066192 2021-02-28 Canada British Columbia     79194 1355 73188 4651 53.7267 -127.6476 2021-03-01 05:23:01 British Columbia, Canada
1066193 2021-02-28 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
1066194 2021-02-28 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
1066195 2021-02-28 Canada Manitoba     31859 895 29770 1194 53.7609 -98.8139 2021-03-01 05:23:01 Manitoba, Canada
1066196 2021-02-28 Canada New Brunswick     1430 27 1364 39 46.5653 -66.4619 2021-03-01 05:23:01 New Brunswick, Canada
1066197 2021-02-28 Canada Newfoundland and Labrador     988 6 716 266 53.1355 -57.6604 2021-03-01 05:23:01 Newfoundland and Labrador, Canada
1066198 2021-02-28 Canada Northwest Territories     47 0 44 3 64.8255 -124.8457 2021-03-01 05:23:01 Northwest Territories,Canada
1066199 2021-02-28 Canada Nova Scotia     1641 65 1538 38 44.682 -63.7443 2021-03-01 05:23:01 Nova Scotia, Canada
1066200 2021-02-28 Canada Nunavut     357 1 338 18 70.2998 -83.1076 2021-03-01 05:23:01 Nunavut, Canada
1066201 2021-02-28 Canada Ontario     306057 6975 288968 10114 51.2538 -85.3232 2021-03-01 05:23:01 Ontario, Canada
1066202 2021-02-28 Canada Prince Edward Island     132 0 114 18 46.5107 -63.4168 2021-03-01 05:23:01 Prince Edward Island, Canada
1066203 2021-02-28 Canada Quebec     287740 10393 269530 7817 52.9399 -73.5491 2021-03-01 05:23:01 Quebec, Canada
1066204 2021-02-28 Canada Repatriated Travellers     13 0 13 0     2021-03-01 05:23:01 Repatriated Travellers, Canada
1066205 2021-02-28 Canada Saskatchewan     28647 385 26719 1543 52.9399 -106.4509 2021-03-01 05:23:01 Saskatchewan, Canada
1066206 2021-02-28 Canada Yukon     72 1 71 0 64.2823 -135.0 2021-03-01 05:23:01 Yukon, Canada
744584 2021-02-27 Canada Alberta     133203 1883 126774 4546 53.9333 -116.5765 2021-02-28 05:22:20 Alberta, Canada
744585 2021-02-27 Canada British Columbia     79194 1355 73188 4651 53.7267 -127.6476 2021-02-28 05:22:20 British Columbia, Canada
744586 2021-02-27 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
744587 2021-02-27 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
744588 2021-02-27 Canada Manitoba     31809 893 29708 1208 53.7609 -98.8139 2021-02-28 05:22:20 Manitoba, Canada
744589 2021-02-27 Canada New Brunswick     1430 26 1362 42 46.5653 -66.4619 2021-02-28 05:22:20 New Brunswick, Canada
744590 2021-02-27 Canada Newfoundland and Labrador     981 6 701 274 53.1355 -57.6604 2021-02-28 05:22:20 Newfoundland and Labrador, Canada
744591 2021-02-27 Canada Northwest Territories     47 0 44 3 64.8255 -124.8457 2021-02-28 05:22:20 Northwest Territories,Canada
744592 2021-02-27 Canada Nova Scotia     1638 65 1534 39 44.682 -63.7443 2021-02-28 05:22:20 Nova Scotia, Canada
744593 2021-02-27 Canada Nunavut     356 1 335 20 70.2998 -83.1076 2021-02-28 05:22:20 Nunavut, Canada
744594 2021-02-27 Canada Ontario     304962 6960 287897 10105 51.2538 -85.3232 2021-02-28 05:22:20 Ontario, Canada
744595 2021-02-27 Canada Prince Edward Island     120 0 114 6 46.5107 -63.4168 2021-02-28 05:22:20 Prince Edward Island, Canada
744596 2021-02-27 Canada Quebec     287003 10385 268645 7973 52.9399 -73.5491 2021-02-28 05:22:20 Quebec, Canada
744597 2021-02-27 Canada Repatriated Travellers     13 0 13 0     2021-02-28 05:22:20 Repatriated Travellers, Canada
744598 2021-02-27 Canada Saskatchewan     28506 385 26573 1548 52.9399 -106.4509 2021-02-28 05:22:20 Saskatchewan, Canada
744599 2021-02-27 Canada Yukon     72 1 71 0 64.2823 -135.0 2021-02-28 05:22:20 Yukon, Canada
950728 2021-02-26 Canada Alberta     132788 1877 126406 4505 53.9333 -116.5765 2021-02-27 05:22:28 Alberta, Canada
950729 2021-02-26 Canada British Columbia     79194 1355 73188 4651 53.7267 -127.6476 2021-02-27 05:22:28 British Columbia, Canada
950730 2021-02-26 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
950731 2021-02-26 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
950732 2021-02-26 Canada Manitoba     31721 889 29635 1197 53.7609 -98.8139 2021-02-27 05:22:28 Manitoba, Canada
950733 2021-02-26 Canada New Brunswick     1428 26 1360 42 46.5653 -66.4619 2021-02-27 05:22:28 New Brunswick, Canada
950734 2021-02-26 Canada Newfoundland and Labrador     977 5 682 290 53.1355 -57.6604 2021-02-27 05:22:28 Newfoundland and Labrador, Canada
950735 2021-02-26 Canada Northwest Territories     47 0 44 3 64.8255 -124.8457 2021-02-27 05:22:28 Northwest Territories,Canada
950736 2021-02-26 Canada Nova Scotia     1634 65 1534 35 44.682 -63.7443 2021-02-27 05:22:28 Nova Scotia, Canada
950737 2021-02-26 Canada Nunavut     356 1 329 26 70.2998 -83.1076 2021-02-27 05:22:28 Nunavut, Canada
950738 2021-02-26 Canada Ontario     303815 6943 286831 10041 51.2538 -85.3232 2021-02-27 05:22:28 Ontario, Canada
950739 2021-02-26 Canada Prince Edward Island     120 0 114 6 46.5107 -63.4168 2021-02-27 05:22:28 Prince Edward Island, Canada
950740 2021-02-26 Canada Quebec     286145 10372 267885 7888 52.9399 -73.5491 2021-02-27 05:22:28 Quebec, Canada
950741 2021-02-26 Canada Repatriated Travellers     13 0 13 0     2021-02-27 05:22:28 Repatriated Travellers, Canada
950742 2021-02-26 Canada Saskatchewan     28344 380 26454 1510 52.9399 -106.4509 2021-02-27 05:22:28 Saskatchewan, Canada
950743 2021-02-26 Canada Yukon     72 1 71 0 64.2823 -135.0 2021-02-27 05:22:28 Yukon, Canada
1279684 2021-02-25 Canada Alberta     132432 1874 126074 4484 53.9333 -116.5765 2021-02-26 05:22:40 Alberta, Canada
1279685 2021-02-25 Canada British Columbia     78673 1348 72781 4544 53.7267 -127.6476 2021-02-26 05:22:40 British Columbia, Canada
1279686 2021-02-25 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
1279687 2021-02-25 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
1279688 2021-02-25 Canada Manitoba     31657 888 29563 1206 53.7609 -98.8139 2021-02-26 05:22:40 Manitoba, Canada
1279689 2021-02-25 Canada New Brunswick     1427 26 1351 50 46.5653 -66.4619 2021-02-26 05:22:40 New Brunswick, Canada
1279690 2021-02-25 Canada Newfoundland and Labrador     973 5 630 338 53.1355 -57.6604 2021-02-26 05:22:40 Newfoundland and Labrador, Canada
1279691 2021-02-25 Canada Northwest Territories     47 0 43 4 64.8255 -124.8457 2021-02-26 05:22:40 Northwest Territories,Canada
1279692 2021-02-25 Canada Nova Scotia     1624 65 1532 27 44.682 -63.7443 2021-02-26 05:22:40 Nova Scotia, Canada
1279693 2021-02-25 Canada Nunavut     355 1 329 25 70.2998 -83.1076 2021-02-26 05:22:40 Nunavut, Canada
1279694 2021-02-25 Canada Ontario     302573 6918 285840 9815 51.2538 -85.3232 2021-02-26 05:22:40 Ontario, Canada
1279695 2021-02-25 Canada Prince Edward Island     115 0 114 1 46.5107 -63.4168 2021-02-26 05:22:40 Prince Edward Island, Canada
1279696 2021-02-25 Canada Quebec     285330 10361 266879 8090 52.9399 -73.5491 2021-02-26 05:22:40 Quebec, Canada
1279697 2021-02-25 Canada Repatriated Travellers     13 0 13 0     2021-02-26 05:22:40 Repatriated Travellers, Canada
1279698 2021-02-25 Canada Saskatchewan     28191 380 26318 1493 52.9399 -106.4509 2021-02-26 05:22:40 Saskatchewan, Canada
1279699 2021-02-25 Canada Yukon     72 1 71 0 64.2823 -135.0 2021-02-26 05:22:40 Yukon, Canada
444178 2021-02-24 Canada Alberta     132033 1866 125622 4545 53.9333 -116.5765 2021-02-25 05:24:57 Alberta, Canada
444179 2021-02-24 Canada British Columbia     78278 1338 72219 4721 53.7267 -127.6476 2021-02-25 05:24:57 British Columbia, Canada
444180 2021-02-24 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
444181 2021-02-24 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
444182 2021-02-24 Canada Manitoba     31590 887 29507 1196 53.7609 -98.8139 2021-02-25 05:24:57 Manitoba, Canada
444183 2021-02-24 Canada New Brunswick     1426 26 1335 65 46.5653 -66.4619 2021-02-25 05:24:57 New Brunswick, Canada
444184 2021-02-24 Canada Newfoundland and Labrador     963 5 610 348 53.1355 -57.6604 2021-02-25 05:24:57 Newfoundland and Labrador, Canada
444185 2021-02-24 Canada Northwest Territories     47 0 43 4 64.8255 -124.8457 2021-02-25 05:24:57 Northwest Territories,Canada
444186 2021-02-24 Canada Nova Scotia     1616 65 1530 21 44.682 -63.7443 2021-02-25 05:24:57 Nova Scotia, Canada
444187 2021-02-24 Canada Nunavut     351 1 323 27 70.2998 -83.1076 2021-02-25 05:24:57 Nunavut, Canada
444188 2021-02-24 Canada Ontario     301379 6895 284735 9749 51.2538 -85.3232 2021-02-25 05:24:57 Ontario, Canada
444189 2021-02-24 Canada Prince Edward Island     115 0 114 1 46.5107 -63.4168 2021-02-25 05:24:57 Prince Edward Island, Canada
444190 2021-02-24 Canada Quebec     284472 10346 266138 7988 52.9399 -73.5491 2021-02-25 05:24:57 Quebec, Canada
444191 2021-02-24 Canada Repatriated Travellers     13 0 13 0     2021-02-25 05:24:57 Repatriated Travellers, Canada
444192 2021-02-24 Canada Saskatchewan     27980 379 26176 1425 52.9399 -106.4509 2021-02-25 05:24:57 Saskatchewan, Canada
444193 2021-02-24 Canada Yukon     72 1 71 0 64.2823 -135.0 2021-02-25 05:24:57 Yukon, Canada
1176732 2021-02-23 Canada Alberta     131603 1853 125234 4516 53.9333 -116.5765 2021-02-24 05:29:16 Alberta, Canada
1176733 2021-02-23 Canada British Columbia     77822 1336 71753 4733 53.7267 -127.6476 2021-02-24 05:29:16 British Columbia, Canada
1176734 2021-02-23 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
1176735 2021-02-23 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]);