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

country_or_region

  • Canada · 6,528
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
913588 2021-05-02 Canada Alberta     194898 2086 169892 22920 53.9333 -116.5765 2021-05-03 04:20:39 Alberta, Canada
913589 2021-05-02 Canada British Columbia     129482 1581 119785 8116 53.7267 -127.6476 2021-05-03 04:20:39 British Columbia, Canada
913590 2021-05-02 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
913591 2021-05-02 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
913592 2021-05-02 Canada Manitoba     39274 978 35756 2540 53.7609 -98.8139 2021-05-03 04:20:39 Manitoba, Canada
913593 2021-05-02 Canada New Brunswick     1939 37 1765 137 46.5653 -66.4619 2021-05-03 04:20:39 New Brunswick, Canada
913594 2021-05-02 Canada Newfoundland and Labrador     1099 6 1038 55 53.1355 -57.6604 2021-05-03 04:20:39 Newfoundland and Labrador, Canada
913595 2021-05-02 Canada Northwest Territories     57 0 51 6 64.8255 -124.8457 2021-05-03 04:20:39 Northwest Territories,Canada
913596 2021-05-02 Canada Nova Scotia     2708 67 1819 822 44.682 -63.7443 2021-05-03 04:20:39 Nova Scotia, Canada
913597 2021-05-02 Canada Nunavut     520 4 436 80 70.2998 -83.1076 2021-05-03 04:20:39 Nunavut, Canada
913598 2021-05-02 Canada Ontario     477138 8070 436048 33020 51.2538 -85.3232 2021-05-03 04:20:39 Ontario, Canada
913599 2021-05-02 Canada Prince Edward Island     177 0 166 11 46.5107 -63.4168 2021-05-03 04:20:39 Prince Edward Island, Canada
913600 2021-05-02 Canada Quebec     351880 10942 331513 9425 52.9399 -73.5491 2021-05-03 04:20:39 Quebec, Canada
913601 2021-05-02 Canada Repatriated Travellers     13 0 13 0     2021-05-03 04:20:39 Repatriated Travellers, Canada
913602 2021-05-02 Canada Saskatchewan     41599 495 38667 2437 52.9399 -106.4509 2021-05-03 04:20:39 Saskatchewan, Canada
913603 2021-05-02 Canada Yukon     81 2 79 0 64.2823 -135.0 2021-05-03 04:20:39 Yukon, Canada
1756554 2021-05-01 Canada Alberta     193167 2083 168580 22504 53.9333 -116.5765 2021-05-02 04:20:48 Alberta, Canada
1756555 2021-05-01 Canada British Columbia     129482 1581 119785 8116 53.7267 -127.6476 2021-05-02 04:20:48 British Columbia, Canada
1756556 2021-05-01 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
1756557 2021-05-01 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
1756558 2021-05-01 Canada Manitoba     38995 976 35551 2468 53.7609 -98.8139 2021-05-02 04:20:48 Manitoba, Canada
1756559 2021-05-01 Canada New Brunswick     1933 36 1755 142 46.5653 -66.4619 2021-05-02 04:20:48 New Brunswick, Canada
1756560 2021-05-01 Canada Newfoundland and Labrador     1081 6 1038 37 53.1355 -57.6604 2021-05-02 04:20:48 Newfoundland and Labrador, Canada
1756561 2021-05-01 Canada Northwest Territories     57 0 51 6 64.8255 -124.8457 2021-05-02 04:20:48 Northwest Territories,Canada
1756562 2021-05-01 Canada Nova Scotia     2575 67 1795 713 44.682 -63.7443 2021-05-02 04:20:48 Nova Scotia, Canada
1756563 2021-05-01 Canada Nunavut     509 4 432 73 70.2998 -83.1076 2021-05-02 04:20:48 Nunavut, Canada
1756564 2021-05-01 Canada Ontario     474595 8062 433460 33073 51.2538 -85.3232 2021-05-02 04:20:48 Ontario, Canada
1756565 2021-05-01 Canada Prince Edward Island     177 0 166 11 46.5107 -63.4168 2021-05-02 04:20:48 Prince Edward Island, Canada
1756566 2021-05-01 Canada Quebec     350874 10933 330362 9579 52.9399 -73.5491 2021-05-02 04:20:48 Quebec, Canada
1756567 2021-05-01 Canada Repatriated Travellers     13 0 13 0     2021-05-02 04:20:48 Repatriated Travellers, Canada
1756568 2021-05-01 Canada Saskatchewan     41360 494 38414 2452 52.9399 -106.4509 2021-05-02 04:20:48 Saskatchewan, Canada
1756569 2021-05-01 Canada Yukon     81 2 79 0 64.2823 -135.0 2021-05-02 04:20:48 Yukon, Canada
1456325 2021-04-30 Canada Alberta     190734 2082 166824 21828 53.9333 -116.5765 2021-05-01 04:20:47 Alberta, Canada
1456326 2021-04-30 Canada British Columbia     129482 1581 119785 8116 53.7267 -127.6476 2021-05-01 04:20:47 British Columbia, Canada
1456327 2021-04-30 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
1456328 2021-04-30 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
1456329 2021-04-30 Canada Manitoba     38729 974 35380 2375 53.7609 -98.8139 2021-05-01 04:20:47 Manitoba, Canada
1456330 2021-04-30 Canada New Brunswick     1915 36 1751 128 46.5653 -66.4619 2021-05-01 04:20:47 New Brunswick, Canada
1456331 2021-04-30 Canada Newfoundland and Labrador     1076 6 1033 37 53.1355 -57.6604 2021-05-01 04:20:47 Newfoundland and Labrador, Canada
1456332 2021-04-30 Canada Northwest Territories     57 0 51 6 64.8255 -124.8457 2021-05-01 04:20:47 Northwest Territories,Canada
1456333 2021-04-30 Canada Nova Scotia     2427 67 1771 589 44.682 -63.7443 2021-05-01 04:20:47 Nova Scotia, Canada
1456334 2021-04-30 Canada Nunavut     501 4 430 67 70.2998 -83.1076 2021-05-01 04:20:47 Nunavut, Canada
1456335 2021-04-30 Canada Ontario     472291 8050 430586 33655 51.2538 -85.3232 2021-05-01 04:20:47 Ontario, Canada
1456336 2021-04-30 Canada Prince Edward Island     177 0 166 11 46.5107 -63.4168 2021-05-01 04:20:47 Prince Edward Island, Canada
1456337 2021-04-30 Canada Quebec     349773 10926 329174 9673 52.9399 -73.5491 2021-05-01 04:20:47 Quebec, Canada
1456338 2021-04-30 Canada Repatriated Travellers     13 0 13 0     2021-05-01 04:20:47 Repatriated Travellers, Canada
1456339 2021-04-30 Canada Saskatchewan     41098 491 38181 2426 52.9399 -106.4509 2021-05-01 04:20:47 Saskatchewan, Canada
1456340 2021-04-30 Canada Yukon     81 2 79 0 64.2823 -135.0 2021-05-01 04:20:47 Yukon, Canada
1614139 2021-04-29 Canada Alberta     188727 2075 165267 21385 53.9333 -116.5765 2021-04-30 04:21:03 Alberta, Canada
1614140 2021-04-29 Canada British Columbia     128742 1577 118937 8228 53.7267 -127.6476 2021-04-30 04:21:03 British Columbia, Canada
1614141 2021-04-29 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
1614142 2021-04-29 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
1614143 2021-04-29 Canada Manitoba     38439 973 35203 2263 53.7609 -98.8139 2021-04-30 04:21:03 Manitoba, Canada
1614144 2021-04-29 Canada New Brunswick     1900 36 1745 119 46.5653 -66.4619 2021-04-30 04:21:03 New Brunswick, Canada
1614145 2021-04-29 Canada Newfoundland and Labrador     1068 6 1031 31 53.1355 -57.6604 2021-04-30 04:21:03 Newfoundland and Labrador, Canada
1614146 2021-04-29 Canada Northwest Territories     57 0 51 6 64.8255 -124.8457 2021-04-30 04:21:03 Northwest Territories,Canada
1614147 2021-04-29 Canada Nova Scotia     2360 67 1745 548 44.682 -63.7443 2021-04-30 04:21:03 Nova Scotia, Canada
1614148 2021-04-29 Canada Nunavut     490 4 425 61 70.2998 -83.1076 2021-04-30 04:21:03 Nunavut, Canada
1614149 2021-04-29 Canada Ontario     468485 8024 426425 34036 51.2538 -85.3232 2021-04-30 04:21:03 Ontario, Canada
1614150 2021-04-29 Canada Prince Edward Island     177 0 166 11 46.5107 -63.4168 2021-04-30 04:21:03 Prince Edward Island, Canada
1614151 2021-04-29 Canada Quebec     348732 10913 327865 9954 52.9399 -73.5491 2021-04-30 04:21:03 Quebec, Canada
1614152 2021-04-29 Canada Repatriated Travellers     13 0 13 0     2021-04-30 04:21:03 Repatriated Travellers, Canada
1614153 2021-04-29 Canada Saskatchewan     40824 487 37929 2408 52.9399 -106.4509 2021-04-30 04:21:03 Saskatchewan, Canada
1614154 2021-04-29 Canada Yukon     81 2 79 0 64.2823 -135.0 2021-04-30 04:21:03 Yukon, Canada
483538 2021-04-28 Canada Alberta     186679 2073 163668 20938 53.9333 -116.5765 2021-04-29 04:20:55 Alberta, Canada
483539 2021-04-28 Canada British Columbia     127889 1576 118057 8256 53.7267 -127.6476 2021-04-29 04:20:55 British Columbia, Canada
483540 2021-04-28 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
483541 2021-04-28 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
483542 2021-04-28 Canada Manitoba     38211 971 35034 2206 53.7609 -98.8139 2021-04-29 04:20:55 Manitoba, Canada
483543 2021-04-28 Canada New Brunswick     1890 36 1731 123 46.5653 -66.4619 2021-04-29 04:20:55 New Brunswick, Canada
483544 2021-04-28 Canada Newfoundland and Labrador     1066 6 1029 31 53.1355 -57.6604 2021-04-29 04:20:55 Newfoundland and Labrador, Canada
483545 2021-04-28 Canada Northwest Territories     57 0 51 6 64.8255 -124.8457 2021-04-29 04:20:55 Northwest Territories,Canada
483546 2021-04-28 Canada Nova Scotia     2290 67 1734 489 44.682 -63.7443 2021-04-29 04:20:55 Nova Scotia, Canada
483547 2021-04-28 Canada Nunavut     478 4 424 50 70.2998 -83.1076 2021-04-29 04:20:55 Nunavut, Canada
483548 2021-04-28 Canada Ontario     463770 7980 420930 34860 51.2538 -85.3232 2021-04-29 04:20:55 Ontario, Canada
483549 2021-04-28 Canada Prince Edward Island     177 0 166 11 46.5107 -63.4168 2021-04-29 04:20:55 Prince Edward Island, Canada
483550 2021-04-28 Canada Quebec     347690 10908 326834 9948 52.9399 -73.5491 2021-04-29 04:20:55 Quebec, Canada
483551 2021-04-28 Canada Repatriated Travellers     13 0 13 0     2021-04-29 04:20:55 Repatriated Travellers, Canada
483552 2021-04-28 Canada Saskatchewan     40614 486 37685 2443 52.9399 -106.4509 2021-04-29 04:20:55 Saskatchewan, Canada
483553 2021-04-28 Canada Yukon     81 2 79 0 64.2823 -135.0 2021-04-29 04:20:55 Yukon, Canada
334576 2021-04-27 Canada Alberta     184840 2067 162052 20721 53.9333 -116.5765 2021-04-28 04:20:32 Alberta, Canada
334577 2021-04-27 Canada British Columbia     127048 1571 117150 8327 53.7267 -127.6476 2021-04-28 04:20:32 British Columbia, Canada
334578 2021-04-27 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
334579 2021-04-27 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
334580 2021-04-27 Canada Manitoba     38025 968 34884 2173 53.7609 -98.8139 2021-04-28 04:20:32 Manitoba, Canada
334581 2021-04-27 Canada New Brunswick     1882 36 1708 138 46.5653 -66.4619 2021-04-28 04:20:32 New Brunswick, Canada
334582 2021-04-27 Canada Newfoundland and Labrador     1062 6 1028 28 53.1355 -57.6604 2021-04-28 04:20:32 Newfoundland and Labrador, Canada
334583 2021-04-27 Canada Northwest Territories     57 0 49 8 64.8255 -124.8457 2021-04-28 04:20:32 Northwest Territories,Canada
334584 2021-04-27 Canada Nova Scotia     2215 67 1729 419 44.682 -63.7443 2021-04-28 04:20:32 Nova Scotia, Canada
334585 2021-04-27 Canada Nunavut     472 4 419 49 70.2998 -83.1076 2021-04-28 04:20:32 Nunavut, Canada
334586 2021-04-27 Canada Ontario     459790 7946 416751 35093 51.2538 -85.3232 2021-04-28 04:20:32 Ontario, Canada
334587 2021-04-27 Canada Prince Edward Island     177 0 166 11 46.5107 -63.4168 2021-04-28 04:20:32 Prince Edward Island, Canada
334588 2021-04-27 Canada Quebec     346596 10898 325691 10007 52.9399 -73.5491 2021-04-28 04:20:32 Quebec, Canada
334589 2021-04-27 Canada Repatriated Travellers     13 0 13 0     2021-04-28 04:20:32 Repatriated Travellers, Canada
334590 2021-04-27 Canada Saskatchewan     40401 482 37401 2518 52.9399 -106.4509 2021-04-28 04:20:32 Saskatchewan, Canada
334591 2021-04-27 Canada Yukon     81 2 79 0 64.2823 -135.0 2021-04-28 04:20:32 Yukon, Canada
1357621 2021-04-26 Canada Alberta     183301 2074 160617 20610 53.9333 -116.5765 2021-04-27 04:20:52 Alberta, Canada
1357622 2021-04-26 Canada British Columbia     126249 1571 116241 8437 53.7267 -127.6476 2021-04-27 04:20:52 British Columbia, Canada
1357623 2021-04-26 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
1357624 2021-04-26 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]);