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

View and edit SQL

Suggested facets: latitude, longitude, combined_key, day (date), last_update (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 ▼
22061 2020-03-06 Canada Toronto, ON     24 0 2   43.6532 -79.3832 2020-03-06T20:53:02  
22064 2020-03-06 Canada British Columbia     21 0 3   49.2827 -123.1207 2020-03-06T04:43:03  
22120 2020-03-06 Canada Montreal, QC     2 0 0   45.5017 -73.5673 2020-03-05T14:03:04  
22146 2020-03-06 Canada Calgary, Alberta     1 0 0   51.0447 -114.0719 2020-03-06T13:13:34  
22147 2020-03-06 Canada London, ON     1 0 1   42.9849 -81.2453 2020-02-12T18:53:03  
64447 2020-03-17 Canada Ontario     185 1 5   51.2538 -85.3232 2020-03-17T16:53:04  
64473 2020-03-17 Canada British Columbia     103 4 4   53.7267 -127.6476 2020-03-16T19:13:13  
64484 2020-03-17 Canada Alberta     74 0 0   53.9333 -116.5765 2020-03-17T03:13:18  
64485 2020-03-17 Canada Quebec     74 1 0   52.9399 -73.5491 2020-03-17T19:33:03  
64582 2020-03-17 Canada Grand Princess     8 0 0   37.6489 -122.6655 2020-03-17T03:13:18  
64583 2020-03-17 Canada Manitoba     8 0 0   53.7609 -98.8139 2020-03-17T19:33:03  
64584 2020-03-17 Canada New Brunswick     8 0 0   46.5653 -66.4619 2020-03-17T19:33:03  
64588 2020-03-17 Canada Nova Scotia     7 0 0   44.682 -63.7443 2020-03-17T19:33:03  
64589 2020-03-17 Canada Saskatchewan     7 0 0   52.9399 -106.4509 2020-03-16T20:13:20  
64607 2020-03-17 Canada Newfoundland and Labrador     3 0 0   53.1355 -57.6604 2020-03-17T17:53:03  
64631 2020-03-17 Canada Prince Edward Island     1 0 0   46.5107 -63.4168 2020-03-15T02:13:21  
68705 2020-03-01 Canada Toronto, ON     14 0 2   43.6532 -79.3832 2020-03-01T23:33:03  
68713 2020-03-01 Canada British Columbia     8 0 3   49.2827 -123.1207 2020-02-29T23:23:13  
68749 2020-03-01 Canada Montreal, QC     1 0 0   45.5017 -73.5673 2020-02-28T05:23:07  
68750 2020-03-01 Canada London, ON     1 0 1   42.9849 -81.2453 2020-02-12T18:53:03  
72809 2020-02-02 Canada Ontario     3 0 0   51.2538 -85.3232 2020-02-01T18:12:49  
72819 2020-02-02 Canada British Columbia     1 0 0   53.7267 -127.6476 2020-02-01T18:12:49  
72895 2020-03-05 Canada Toronto, ON     21 0 2   43.6532 -79.3832 2020-03-05T17:53:03  
72906 2020-03-05 Canada British Columbia     13 0 3   49.2827 -123.1207 2020-03-05T04:43:03  
72943 2020-03-05 Canada Montreal, QC     2 0 0   45.5017 -73.5673 2020-03-05T14:03:04  
72967 2020-03-05 Canada London, ON     1 0 1   42.9849 -81.2453 2020-02-12T18:53:03  
80289 2020-02-25 Canada British Columbia     7 0 0   53.7267 -127.6476 2020-02-25T02:23:05  
80294 2020-02-25 Canada Toronto, ON     3 0 2   43.6532 -79.3832 2020-02-24T14:43:03  
80309 2020-02-25 Canada London, ON     1 0 1   42.9849 -81.2453 2020-02-12T18:53:03  
153948 2020-01-27 Canada Ontario     1 0 0   51.2538 -85.3232 1/27/20 23:59  
179430 2020-03-19 Canada Ontario     257 1 5   51.2538 -85.3232 2020-03-19T16:43:04  
179436 2020-03-19 Canada British Columbia     231 7 4   53.7267 -127.6476 2020-03-19T03:13:26  
179463 2020-03-19 Canada Quebec     121 3 0   52.9399 -73.5491 2020-03-19T17:43:04  
179464 2020-03-19 Canada Alberta     119 0 0   53.9333 -116.5765 2020-03-19T03:13:26  
179549 2020-03-19 Canada Manitoba     17 0 0   53.7609 -98.8139 2020-03-19T03:13:26  
179551 2020-03-19 Canada Saskatchewan     16 0 0   52.9399 -106.4509 2020-03-19T01:03:51  
179555 2020-03-19 Canada Nova Scotia     14 0 0   44.682 -63.7443 2020-03-19T20:43:03  
179563 2020-03-19 Canada New Brunswick     11 0 0   46.5653 -66.4619 2020-03-18T18:33:03  
179574 2020-03-19 Canada Grand Princess     9 0 0   37.6489 -122.6655 2020-03-18T11:53:04  
179596 2020-03-19 Canada Newfoundland and Labrador     3 0 0   53.1355 -57.6604 2020-03-17T17:53:03  
179608 2020-03-19 Canada Prince Edward Island     2 0 0   46.5107 -63.4168 2020-03-19T18:43:03  
252558 2020-02-07 Canada British Columbia     4 0 0   53.7267 -127.6476 2020-02-07T05:43:03  
252564 2020-02-07 Canada Toronto, ON     2 0 0   43.6532 -79.3832 2020-02-04T00:13:06  
252571 2020-02-07 Canada London, ON     1 0 0   42.9849 -81.2453 2020-02-04T00:03:11  
299490 2020-02-18 Canada British Columbia     5 0 0   53.7267 -127.6476 2020-02-17T08:03:07  
299497 2020-02-18 Canada Toronto, ON     2 0 0   43.6532 -79.3832 2020-02-04T00:13:06  
299506 2020-02-18 Canada London, ON     1 0 1   42.9849 -81.2453 2020-02-12T18:53:03  
306760 2020-03-21 Canada British Columbia     424 10 4   53.7267 -127.6476 2020-03-21T21:13:30  
306767 2020-03-21 Canada Ontario     377 3 6   51.2538 -85.3232 2020-03-21T21:13:30  
306793 2020-03-21 Canada Alberta     195 1 0   53.9333 -116.5765 2020-03-21T02:43:03  
306797 2020-03-21 Canada Quebec     181 5 0   52.9399 -73.5491 2020-03-21T21:13:30  
306888 2020-03-21 Canada Saskatchewan     26 0 0   52.9399 -106.4509 2020-03-21T02:43:03  
306896 2020-03-21 Canada Nova Scotia     21 0 0   44.682 -63.7443 2020-03-21T21:13:30  
306902 2020-03-21 Canada Manitoba     18 0 0   53.7609 -98.8139 2020-03-21T17:43:03  
306907 2020-03-21 Canada New Brunswick     17 0 0   46.5653 -66.4619 2020-03-21T21:13:30  
306923 2020-03-21 Canada Grand Princess     10 0 0   37.6489 -122.6655 2020-03-20T03:13:18  
306934 2020-03-21 Canada Newfoundland and Labrador     6 0 0   53.1355 -57.6604 2020-03-21T21:13:29  
306959 2020-03-21 Canada Prince Edward Island     2 0 0   46.5107 -63.4168 2020-03-19T18:43:03  
306971 2020-03-21 Canada Northwest Territories     1 0 0   64.8255 -124.8457 2020-03-21T21:13:30  
368064 2020-03-15 Canada Ontario     104 0 4   51.2538 -85.3232 2020-03-15T01:53:03  
368076 2020-03-15 Canada British Columbia     73 1 4   53.7267 -127.6476 2020-03-15T01:53:02  
368102 2020-03-15 Canada Alberta     39 0 0   53.9333 -116.5765 2020-03-15T01:53:03  
368120 2020-03-15 Canada Quebec     24 0 0   52.9399 -73.5491 2020-03-15T01:53:02  
368181 2020-03-15 Canada Manitoba     4 0 0   53.7609 -98.8139 2020-03-14T00:13:05  
368197 2020-03-15 Canada New Brunswick     2 0 0   46.5653 -66.4619 2020-03-15T01:53:02  
368198 2020-03-15 Canada Saskatchewan     2 0 0   52.9399 -106.4509 2020-03-14T00:13:05  
368213 2020-03-15 Canada Newfoundland and Labrador     1 0 0   53.1355 -57.6604 2020-03-15T02:13:21  
368214 2020-03-15 Canada Prince Edward Island     1 0 0   46.5107 -63.4168 2020-03-15T02:13:21  
383959 2020-02-01 Canada Ontario     3 0 0   51.2538 -85.3232 2/1/2020 18:12  
383966 2020-02-01 Canada British Columbia     1 0 0   53.7267 -127.6476 2/1/2020 18:12  
399877 2020-02-11 Canada British Columbia     4 0 0   53.7267 -127.6476 2020-02-07T05:43:03  
399882 2020-02-11 Canada Toronto, ON     2 0 0   43.6532 -79.3832 2020-02-04T00:13:06  
399890 2020-02-11 Canada London, ON     1 0 0   42.9849 -81.2453 2020-02-04T00:03:11  
477662 2020-02-04 Canada Toronto, ON     2 0 0   43.6532 -79.3832 2020-02-04T00:13:06  
477672 2020-02-04 Canada British Columbia     1 0 0   53.7267 -127.6476 2020-02-01T18:12:49  
477673 2020-02-04 Canada London, ON     1 0 0   42.9849 -81.2453 2020-02-04T00:03:11  
523902 2020-02-09 Canada British Columbia     4 0 0   53.7267 -127.6476 2020-02-07T05:43:03  
523908 2020-02-09 Canada Toronto, ON     2 0 0   43.6532 -79.3832 2020-02-04T00:13:06  
523916 2020-02-09 Canada London, ON     1 0 0   42.9849 -81.2453 2020-02-04T00:03:11  
527946 2020-02-06 Canada British Columbia     2 0 0   53.7267 -127.6476 2020-02-05T17:33:03  
527947 2020-02-06 Canada Toronto, ON     2 0 0   43.6532 -79.3832 2020-02-04T00:13:06  
527957 2020-02-06 Canada London, ON     1 0 0   42.9849 -81.2453 2020-02-04T00:03:11  
587451 2020-01-30 Canada Ontario     2 0 0   51.2538 -85.3232 1/30/20 16:00  
587452 2020-01-30 Canada British Columbia     1 0 0   53.7267 -127.6476 1/30/20 16:00  
629420 2020-02-26 Canada British Columbia     7 0 0   53.7267 -127.6476 2020-02-25T02:23:05  
629426 2020-02-26 Canada Toronto, ON     3 0 2   43.6532 -79.3832 2020-02-24T14:43:03  
629447 2020-02-26 Canada London, ON     1 0 1   42.9849 -81.2453 2020-02-12T18:53:03  
643162 2020-03-18 Canada Ontario     221 1 5   51.2538 -85.3232 2020-03-18T17:33:06  
643169 2020-03-18 Canada British Columbia     186 7 4   53.7267 -127.6476 2020-03-18T03:33:03  
643197 2020-03-18 Canada Alberta     97 0 0   53.9333 -116.5765 2020-03-18T03:33:03  
643199 2020-03-18 Canada Quebec     94 3 0   52.9399 -73.5491 2020-03-18T17:53:03  
643283 2020-03-18 Canada Manitoba     15 0 0   53.7609 -98.8139 2020-03-18T03:33:03  
643293 2020-03-18 Canada Nova Scotia     12 0 0   44.682 -63.7443 2020-03-18T17:53:03  
643295 2020-03-18 Canada New Brunswick     11 0 0   46.5653 -66.4619 2020-03-18T18:33:03  
643302 2020-03-18 Canada Grand Princess     9 0 0   37.6489 -122.6655 2020-03-18T11:53:04  
643305 2020-03-18 Canada Saskatchewan     8 0 0   52.9399 -106.4509 2020-03-18T11:53:04  
643328 2020-03-18 Canada Newfoundland and Labrador     3 0 0   53.1355 -57.6604 2020-03-17T17:53:03  
643352 2020-03-18 Canada Prince Edward Island     1 0 0   46.5107 -63.4168 2020-03-15T02:13:21  
655318 2020-02-17 Canada British Columbia     5 0 0   53.7267 -127.6476 2020-02-17T08:03:07  
655325 2020-02-17 Canada Toronto, ON     2 0 0   43.6532 -79.3832 2020-02-04T00:13:06  

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]);