johns_hopkins_csse_daily_reports

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

1,736 rows where country_or_region = "Canada" sorted by day descending

View and edit SQL

country_or_region

  • Canada · 1,736
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
311634 2020-07-04 Canada Alberta     8259 155 7532 572 53.9333 -116.5765 2020-07-05 04:33:46 Alberta, Canada
311690 2020-07-04 Canada British Columbia     2947 177 2608 162 53.7267 -127.6476 2020-07-05 04:33:46 British Columbia, Canada
311742 2020-07-04 Canada Diamond Princess     0 1 0   0.0 0.0 2020-07-05 04:33:46 Diamond Princess, Canada
311771 2020-07-04 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-07-05 04:33:46 Grand Princess, Canada
311885 2020-07-04 Canada Manitoba     325 7 302 16 53.7609 -98.8139 2020-07-05 04:33:46 Manitoba, Canada
311924 2020-07-04 Canada New Brunswick     165 2 162 1 46.5653 -66.4619 2020-07-05 04:33:46 New Brunswick, Canada
311927 2020-07-04 Canada Newfoundland and Labrador     261 3 258 0 53.1355 -57.6604 2020-07-05 04:33:46 Newfoundland and Labrador, Canada
311939 2020-07-04 Canada Northwest Territories     5 0 5 0 64.8255 -124.8457 2020-07-05 04:33:46 Northwest Territories, Canada
311940 2020-07-04 Canada Nova Scotia     1064 63 998 3 44.681999999999995 -63.7443 2020-07-05 04:33:46 Nova Scotia, Canada
311953 2020-07-04 Canada Ontario     37525 2744 32600 2181 51.2538 -85.3232 2020-07-05 04:33:46 Ontario, Canada
311975 2020-07-04 Canada Prince Edward Island     30 0 27 3 46.5107 -63.4168 2020-07-05 04:33:46 Prince Edward Island, Canada
311986 2020-07-04 Canada Quebec     55784 5566 25280 24938 52.9399 -73.5491 2020-07-05 04:33:46 Quebec, Canada
312023 2020-07-04 Canada Saskatchewan     796 14 711 71 52.9399 -106.4509 2020-07-05 04:33:46 Saskatchewan, Canada
312127 2020-07-04 Canada Yukon     11 0 11 0 64.2823 -135.0 2020-07-05 04:33:46 Yukon, Canada
252068 2020-07-03 Canada Alberta     8259 155 7532 572 53.9333 -116.5765 2020-07-04 04:33:51 Alberta, Canada
252124 2020-07-03 Canada British Columbia     2947 177 2608 162 53.7267 -127.6476 2020-07-04 04:33:51 British Columbia, Canada
252176 2020-07-03 Canada Diamond Princess     0 1 0   0.0 0.0 2020-07-04 04:33:51 Diamond Princess, Canada
252205 2020-07-03 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-07-04 04:33:51 Grand Princess, Canada
252319 2020-07-03 Canada Manitoba     325 7 302 16 53.7609 -98.8139 2020-07-04 04:33:51 Manitoba, Canada
252358 2020-07-03 Canada New Brunswick     165 2 161 2 46.5653 -66.4619 2020-07-04 04:33:51 New Brunswick, Canada
252361 2020-07-03 Canada Newfoundland and Labrador     261 3 258 0 53.1355 -57.6604 2020-07-04 04:33:51 Newfoundland and Labrador, Canada
252373 2020-07-03 Canada Northwest Territories     5 0 5 0 64.8255 -124.8457 2020-07-04 04:33:51 Northwest Territories, Canada
252374 2020-07-03 Canada Nova Scotia     1064 63 998 3 44.681999999999995 -63.7443 2020-07-04 04:33:51 Nova Scotia, Canada
252387 2020-07-03 Canada Ontario     37407 2740 32448 2219 51.2538 -85.3232 2020-07-04 04:33:51 Ontario, Canada
252409 2020-07-03 Canada Prince Edward Island     27 0 27 0 46.5107 -63.4168 2020-07-04 04:33:51 Prince Edward Island, Canada
252420 2020-07-03 Canada Quebec     55682 5560 25158 24964 52.9399 -73.5491 2020-07-04 04:33:51 Quebec, Canada
252457 2020-07-03 Canada Saskatchewan     796 14 711 71 52.9399 -106.4509 2020-07-04 04:33:51 Saskatchewan, Canada
252561 2020-07-03 Canada Yukon     11 0 11 0 64.2823 -135.0 2020-07-04 04:33:51 Yukon, Canada
203449 2020-07-02 Canada Alberta     8202 155 7505 542 53.9333 -116.5765 2020-07-03 04:33:54 Alberta, Canada
203505 2020-07-02 Canada British Columbia     2940 177 2603 160 53.7267 -127.6476 2020-07-03 04:33:54 British Columbia, Canada
203557 2020-07-02 Canada Diamond Princess     0 1 0 -1 0.0 0.0 2020-07-03 04:33:54 Diamond Princess, Canada
203586 2020-07-02 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-07-03 04:33:54 Grand Princess, Canada
203700 2020-07-02 Canada Manitoba     325 7 302 16 53.7609 -98.8139 2020-07-03 04:33:54 Manitoba, Canada
203739 2020-07-02 Canada New Brunswick     165 2 160 3 46.5653 -66.4619 2020-07-03 04:33:54 New Brunswick, Canada
203742 2020-07-02 Canada Newfoundland and Labrador     261 3 258 0 53.1355 -57.6604 2020-07-03 04:33:54 Newfoundland and Labrador, Canada
203754 2020-07-02 Canada Northwest Territories     5 0 5 0 64.8255 -124.8457 2020-07-03 04:33:54 Northwest Territories, Canada
203755 2020-07-02 Canada Nova Scotia     1064 63 998 3 44.682 -63.7443 2020-07-03 04:33:54 Nova Scotia, Canada
203768 2020-07-02 Canada Ontario     37242 2737 32255 2250 51.2538 -85.3232 2020-07-03 04:33:54 Ontario, Canada
203790 2020-07-02 Canada Prince Edward Island     27 0 27 0 46.5107 -63.4168 2020-07-03 04:33:54 Prince Edward Island, Canada
203801 2020-07-02 Canada Quebec     55593 5541 25034 25018 52.9399 -73.5491 2020-07-03 04:33:54 Quebec, Canada
203838 2020-07-02 Canada Saskatchewan     795 14 701 80 52.9399 -106.4509 2020-07-03 04:33:54 Saskatchewan, Canada
203943 2020-07-02 Canada Yukon     11 0 11 0 64.2823 -135.0 2020-07-03 04:33:54 Yukon, Canada
159690 2020-07-01 Canada Alberta     8108 154 7407 547 53.9333 -116.5765 2020-07-02 04:33:46 Alberta, Canada
159746 2020-07-01 Canada British Columbia     2916 174 2590 152 53.7267 -127.6476 2020-07-02 04:33:46 British Columbia, Canada
159798 2020-07-01 Canada Diamond Princess     0 1 0 -1 0.0 0.0 2020-07-02 04:33:46 Diamond Princess, Canada
159827 2020-07-01 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-07-02 04:33:46 Grand Princess, Canada
159941 2020-07-01 Canada Manitoba     325 7 300 18 53.7609 -98.8139 2020-07-02 04:33:46 Manitoba, Canada
159980 2020-07-01 Canada New Brunswick     165 2 160 3 46.5653 -66.4619 2020-07-02 04:33:46 New Brunswick, Canada
159983 2020-07-01 Canada Newfoundland and Labrador     261 3 258 0 53.1355 -57.6604 2020-07-02 04:33:46 Newfoundland and Labrador, Canada
159995 2020-07-01 Canada Northwest Territories     5 0 5 0 64.8255 -124.8457 2020-07-02 04:33:46 Northwest Territories, Canada
159996 2020-07-01 Canada Nova Scotia     1063 63 998 2 44.681999999999995 -63.7443 2020-07-02 04:33:46 Nova Scotia, Canada
160009 2020-07-01 Canada Ontario     37085 2734 31995 2356 51.2538 -85.3232 2020-07-02 04:33:46 Ontario, Canada
160031 2020-07-01 Canada Prince Edward Island     27 0 27 0 46.5107 -63.4168 2020-07-02 04:33:46 Prince Edward Island, Canada
160042 2020-07-01 Canada Quebec     55524 5527 24949 25048 52.9399 -73.5491 2020-07-02 04:33:46 Quebec, Canada
160079 2020-07-01 Canada Saskatchewan     785 13 684 88 52.9399 -106.4509 2020-07-02 04:33:46 Saskatchewan, Canada
160184 2020-07-01 Canada Yukon     11 0 11 0 64.2823 -135.0 2020-07-02 04:33:46 Yukon, Canada
325685 2020-06-30 Canada Alberta     8108 154 7407 547 53.9333 -116.5765 2020-07-01 04:33:52 Alberta, Canada
325741 2020-06-30 Canada British Columbia     2916 174 2590 152 53.7267 -127.6476 2020-07-01 04:33:52 British Columbia, Canada
325793 2020-06-30 Canada Diamond Princess     0 1 0 -1 0.0 0.0 2020-07-01 04:33:52 Diamond Princess, Canada
325822 2020-06-30 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-07-01 04:33:52 Grand Princess, Canada
325936 2020-06-30 Canada Manitoba     325 7 300 18 53.7609 -98.8139 2020-07-01 04:33:52 Manitoba, Canada
325975 2020-06-30 Canada New Brunswick     165 2 159 4 46.5653 -66.4619 2020-07-01 04:33:52 New Brunswick, Canada
325978 2020-06-30 Canada Newfoundland and Labrador     261 3 258 0 53.1355 -57.6604 2020-07-01 04:33:52 Newfoundland and Labrador, Canada
325990 2020-06-30 Canada Northwest Territories     5 0 5 0 64.8255 -124.8457 2020-07-01 04:33:52 Northwest Territories, Canada
325991 2020-06-30 Canada Nova Scotia     1062 63 998 1 44.681999999999995 -63.7443 2020-07-01 04:33:52 Nova Scotia, Canada
326004 2020-06-30 Canada Ontario     36961 2730 31870 2361 51.2538 -85.3232 2020-07-01 04:33:52 Ontario, Canada
326026 2020-06-30 Canada Prince Edward Island     27 0 27 0 46.5107 -63.4168 2020-07-01 04:33:52 Prince Edward Island, Canada
326037 2020-06-30 Canada Quebec     55458 5503 24798 25157 52.9399 -73.5491 2020-07-01 04:33:52 Quebec, Canada
326074 2020-06-30 Canada Saskatchewan     785 13 684 88 52.9399 -106.4509 2020-07-01 04:33:52 Saskatchewan, Canada
326179 2020-06-30 Canada Yukon     11 0 11 0 64.2823 -135.0 2020-07-01 04:33:52 Yukon, Canada
49489 2020-06-29 Canada Alberta     8067 154 7354 559 53.9333 -116.5765 2020-06-30 04:33:48 Alberta, Canada
49545 2020-06-29 Canada British Columbia     2904 174 2577 153 53.7267 -127.6476 2020-06-30 04:33:48 British Columbia, Canada
49597 2020-06-29 Canada Diamond Princess     0 1 0 -1 0.0 0.0 2020-06-30 04:33:48 Diamond Princess, Canada
49626 2020-06-29 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-06-30 04:33:48 Grand Princess, Canada
49740 2020-06-29 Canada Manitoba     324 7 300 17 53.7609 -98.8139 2020-06-30 04:33:48 Manitoba, Canada
49779 2020-06-29 Canada New Brunswick     165 2 158 5 46.5653 -66.4619 2020-06-30 04:33:48 New Brunswick, Canada
49782 2020-06-29 Canada Newfoundland and Labrador     261 3 258 0 53.1355 -57.6604 2020-06-30 04:33:48 Newfoundland and Labrador, Canada
49794 2020-06-29 Canada Northwest Territories     5 0 5 0 64.8255 -124.8457 2020-06-30 04:33:48 Northwest Territories, Canada
49795 2020-06-29 Canada Nova Scotia     1061 63 998 0 44.682 -63.7443 2020-06-30 04:33:48 Nova Scotia, Canada
49808 2020-06-29 Canada Ontario     36823 2726 31716 2381 51.2538 -85.3232 2020-06-30 04:33:48 Ontario, Canada
49830 2020-06-29 Canada Prince Edward Island     27 0 27 0 46.5107 -63.4168 2020-06-30 04:33:48 Prince Edward Island, Canada
49841 2020-06-29 Canada Quebec     55390 5485 24602 25303 52.9399 -73.5491 2020-06-30 04:33:48 Quebec, Canada
49878 2020-06-29 Canada Saskatchewan     779 13 679 87 52.9399 -106.4509 2020-06-30 04:33:48 Saskatchewan, Canada
49983 2020-06-29 Canada Yukon     11 0 11 0 64.2823 -135.0 2020-06-30 04:33:48 Yukon, Canada
56195 2020-06-28 Canada Alberta     7996 154 7322 520 53.9333 -116.5765 2020-06-29 04:33:44 Alberta, Canada
56251 2020-06-28 Canada British Columbia     2878 174 2545 159 53.7267 -127.6476 2020-06-29 04:33:44 British Columbia, Canada
56303 2020-06-28 Canada Diamond Princess     0 1 0 -1 0.0 0.0 2020-06-29 04:33:44 Diamond Princess, Canada
56332 2020-06-28 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-06-29 04:33:44 Grand Princess, Canada
56446 2020-06-28 Canada Manitoba     322 7 300 15 53.7609 -98.8139 2020-06-29 04:33:44 Manitoba, Canada
56485 2020-06-28 Canada New Brunswick     165 2 158 5 46.5653 -66.4619 2020-06-29 04:33:44 New Brunswick, Canada
56488 2020-06-28 Canada Newfoundland and Labrador     261 3 258 0 53.1355 -57.6604 2020-06-29 04:33:44 Newfoundland and Labrador, Canada
56500 2020-06-28 Canada Northwest Territories     5 0 5 0 64.8255 -124.8457 2020-06-29 04:33:44 Northwest Territories, Canada
56501 2020-06-28 Canada Nova Scotia     1061 63 998 0 44.681999999999995 -63.7443 2020-06-29 04:33:44 Nova Scotia, Canada
56514 2020-06-28 Canada Ontario     36597 2717 31605 2275 51.2538 -85.3232 2020-06-29 04:33:44 Ontario, Canada
56536 2020-06-28 Canada Prince Edward Island     27 0 27 0 46.5107 -63.4168 2020-06-29 04:33:44 Prince Edward Island, Canada
56547 2020-06-28 Canada Quebec     55079 5448 23786 25845 52.9399 -73.5491 2020-06-29 04:33:44 Quebec, Canada
56584 2020-06-28 Canada Saskatchewan     778 13 661 104 52.9399 -106.4509 2020-06-29 04:33:44 Saskatchewan, Canada
56689 2020-06-28 Canada Yukon     11 0 11 0 64.2823 -135.0 2020-06-29 04:33:44 Yukon, Canada
79646 2020-06-27 Canada Alberta     7957 154 7283 520 53.9333 -116.5765 2020-06-28 04:34:04 Alberta, Canada
79702 2020-06-27 Canada British Columbia     2878 174 2545 159 53.7267 -127.6476 2020-06-28 04:34:04 British Columbia, 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
);
Powered by Datasette · Query took 2377.195ms · Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette