⚠️ 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,216 rows where country_or_region = "Canada" sorted by last_update

View and edit SQL

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

country_or_region

  • Canada · 7,216
Link rowid day country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update ▼ combined_key
1528085 2020-01-26 Canada Ontario     1 0 0   51.2538 -85.3232 1/26/20 16:00  
1136412 2020-01-27 Canada Ontario     1 0 0   51.2538 -85.3232 1/27/20 23:59  
844947 2020-01-28 Canada Ontario     1 0 0   51.2538 -85.3232 1/28/20 23:00  
844948 2020-01-28 Canada British Columbia     1 0 0   53.7267 -127.6476 1/28/20 23:00  
1230293 2020-01-29 Canada Ontario     1 0 0   51.2538 -85.3232 1/29/20 19:30  
1230294 2020-01-29 Canada British Columbia     1 0 0   53.7267 -127.6476 1/29/20 19:30  
324631 2020-01-30 Canada Ontario     2 0 0   51.2538 -85.3232 1/30/20 16:00  
324632 2020-01-30 Canada British Columbia     1 0 0   53.7267 -127.6476 1/30/20 16:00  
1548847 2020-01-31 Canada Ontario     2 0 0   51.2538 -85.3232 1/31/2020 23:59  
1548855 2020-01-31 Canada British Columbia     1 0 0   53.7267 -127.6476 1/31/2020 23:59  
1124410 2020-02-01 Canada Ontario     3 0 0   51.2538 -85.3232 2/1/2020 18:12  
1124417 2020-02-01 Canada British Columbia     1 0 0   53.7267 -127.6476 2/1/2020 18:12  
647064 2020-02-03 Canada Ontario     3 0 0   51.2538 -85.3232 2020-02-01T18:12:49  
647076 2020-02-03 Canada British Columbia     1 0 0   53.7267 -127.6476 2020-02-01T18:12:49  
1617092 2020-02-04 Canada British Columbia     1 0 0   53.7267 -127.6476 2020-02-01T18:12:49  
1649257 2020-02-02 Canada Ontario     3 0 0   51.2538 -85.3232 2020-02-01T18:12:49  
1649267 2020-02-02 Canada British Columbia     1 0 0   53.7267 -127.6476 2020-02-01T18:12:49  
134291 2020-02-10 Canada London, ON     1 0 0   42.9849 -81.2453 2020-02-04T00:03:11  
195315 2020-02-11 Canada London, ON     1 0 0   42.9849 -81.2453 2020-02-04T00:03:11  
515437 2020-02-08 Canada London, ON     1 0 0   42.9849 -81.2453 2020-02-04T00:03:11  
1203903 2020-02-07 Canada London, ON     1 0 0   42.9849 -81.2453 2020-02-04T00:03:11  
1430718 2020-02-06 Canada London, ON     1 0 0   42.9849 -81.2453 2020-02-04T00:03:11  
1512095 2020-02-09 Canada London, ON     1 0 0   42.9849 -81.2453 2020-02-04T00:03:11  
1617093 2020-02-04 Canada London, ON     1 0 0   42.9849 -81.2453 2020-02-04T00:03:11  
1649198 2020-02-05 Canada London, ON     1 0 0   42.9849 -81.2453 2020-02-04T00:03:11  
134283 2020-02-10 Canada Toronto, ON     2 0 0   43.6532 -79.3832 2020-02-04T00:13:06  
166125 2020-02-16 Canada Toronto, ON     2 0 0   43.6532 -79.3832 2020-02-04T00:13:06  
195307 2020-02-11 Canada Toronto, ON     2 0 0   43.6532 -79.3832 2020-02-04T00:13:06  
515430 2020-02-08 Canada Toronto, ON     2 0 0   43.6532 -79.3832 2020-02-04T00:13:06  
863149 2020-02-14 Canada Toronto, ON     2 0 0   43.6532 -79.3832 2020-02-04T00:13:06  
1073550 2020-02-19 Canada Toronto, ON     2 0 0   43.6532 -79.3832 2020-02-04T00:13:06  
1073628 2020-02-18 Canada Toronto, ON     2 0 0   43.6532 -79.3832 2020-02-04T00:13:06  
1169911 2020-02-15 Canada Toronto, ON     2 0 0   43.6532 -79.3832 2020-02-04T00:13:06  
1203896 2020-02-07 Canada Toronto, ON     2 0 0   43.6532 -79.3832 2020-02-04T00:13:06  
1281572 2020-02-13 Canada Toronto, ON     2 0 0   43.6532 -79.3832 2020-02-04T00:13:06  
1318474 2020-02-20 Canada Toronto, ON     2 0 0   43.6532 -79.3832 2020-02-04T00:13:06  
1430708 2020-02-06 Canada Toronto, ON     2 0 0   43.6532 -79.3832 2020-02-04T00:13:06  
1485271 2020-02-17 Canada Toronto, ON     2 0 0   43.6532 -79.3832 2020-02-04T00:13:06  
1512087 2020-02-09 Canada Toronto, ON     2 0 0   43.6532 -79.3832 2020-02-04T00:13:06  
1563729 2020-02-12 Canada Toronto, ON     2 0 0   43.6532 -79.3832 2020-02-04T00:13:06  
1617082 2020-02-04 Canada Toronto, ON     2 0 0   43.6532 -79.3832 2020-02-04T00:13:06  
1649188 2020-02-05 Canada Toronto, ON     2 0 0   43.6532 -79.3832 2020-02-04T00:13:06  
1430707 2020-02-06 Canada British Columbia     2 0 0   53.7267 -127.6476 2020-02-05T17:33:03  
1649187 2020-02-05 Canada British Columbia     2 0 0   53.7267 -127.6476 2020-02-05T17:33:03  
134278 2020-02-10 Canada British Columbia     4 0 0   53.7267 -127.6476 2020-02-07T05:43:03  
166120 2020-02-16 Canada British Columbia     4 0 0   53.7267 -127.6476 2020-02-07T05:43:03  
195302 2020-02-11 Canada British Columbia     4 0 0   53.7267 -127.6476 2020-02-07T05:43:03  
515424 2020-02-08 Canada British Columbia     4 0 0   53.7267 -127.6476 2020-02-07T05:43:03  
863144 2020-02-14 Canada British Columbia     4 0 0   53.7267 -127.6476 2020-02-07T05:43:03  
1169906 2020-02-15 Canada British Columbia     4 0 0   53.7267 -127.6476 2020-02-07T05:43:03  
1203890 2020-02-07 Canada British Columbia     4 0 0   53.7267 -127.6476 2020-02-07T05:43:03  
1281567 2020-02-13 Canada British Columbia     4 0 0   53.7267 -127.6476 2020-02-07T05:43:03  
1512081 2020-02-09 Canada British Columbia     4 0 0   53.7267 -127.6476 2020-02-07T05:43:03  
1563724 2020-02-12 Canada British Columbia     4 0 0   53.7267 -127.6476 2020-02-07T05:43:03  
67118 2020-02-27 Canada London, ON     1 0 1   42.9849 -81.2453 2020-02-12T18:53:03  
126710 2020-02-28 Canada London, ON     1 0 1   42.9849 -81.2453 2020-02-12T18:53:03  
150320 2020-03-02 Canada London, ON     1 0 1   42.9849 -81.2453 2020-02-12T18:53:03  
166134 2020-02-16 Canada London, ON     1 0 1   42.9849 -81.2453 2020-02-12T18:53:03  
265802 2020-03-04 Canada London, ON     1 0 1   42.9849 -81.2453 2020-02-12T18:53:03  
301238 2020-03-05 Canada London, ON     1 0 1   42.9849 -81.2453 2020-02-12T18:53:03  
646980 2020-03-03 Canada London, ON     1 0 1   42.9849 -81.2453 2020-02-12T18:53:03  
863158 2020-02-14 Canada London, ON     1 0 1   42.9849 -81.2453 2020-02-12T18:53:03  
889739 2020-02-23 Canada London, ON     1 0 1   42.9849 -81.2453 2020-02-12T18:53:03  
966463 2020-02-24 Canada London, ON     1 0 1   42.9849 -81.2453 2020-02-12T18:53:03  
1073560 2020-02-19 Canada London, ON     1 0 1   42.9849 -81.2453 2020-02-12T18:53:03  
1073637 2020-02-18 Canada London, ON     1 0 1   42.9849 -81.2453 2020-02-12T18:53:03  
1073814 2020-03-07 Canada London, ON     1 0 1   42.9849 -81.2453 2020-02-12T18:53:03  
1085357 2020-03-01 Canada London, ON     1 0 1   42.9849 -81.2453 2020-02-12T18:53:03  
1169920 2020-02-15 Canada London, ON     1 0 1   42.9849 -81.2453 2020-02-12T18:53:03  
1250405 2020-03-06 Canada London, ON     1 0 1   42.9849 -81.2453 2020-02-12T18:53:03  
1281581 2020-02-13 Canada London, ON     1 0 1   42.9849 -81.2453 2020-02-12T18:53:03  
1318483 2020-02-20 Canada London, ON     1 0 1   42.9849 -81.2453 2020-02-12T18:53:03  
1371622 2020-02-22 Canada London, ON     1 0 1   42.9849 -81.2453 2020-02-12T18:53:03  
1430912 2020-03-08 Canada London, ON     1 0 1   42.9849 -81.2453 2020-02-12T18:53:03  
1450928 2020-02-29 Canada London, ON     1 0 1   42.9849 -81.2453 2020-02-12T18:53:03  
1485280 2020-02-17 Canada London, ON     1 0 1   42.9849 -81.2453 2020-02-12T18:53:03  
1536134 2020-02-26 Canada London, ON     1 0 1   42.9849 -81.2453 2020-02-12T18:53:03  
1563737 2020-02-12 Canada London, ON     1 0 1   42.9849 -81.2453 2020-02-12T18:53:03  
1649120 2020-02-21 Canada London, ON     1 0 1   42.9849 -81.2453 2020-02-12T18:53:03  
1713758 2020-02-25 Canada London, ON     1 0 1   42.9849 -81.2453 2020-02-12T18:53:03  
1073543 2020-02-19 Canada British Columbia     5 0 0   53.7267 -127.6476 2020-02-17T08:03:07  
1073621 2020-02-18 Canada British Columbia     5 0 0   53.7267 -127.6476 2020-02-17T08:03:07  
1318466 2020-02-20 Canada British Columbia     5 0 0   53.7267 -127.6476 2020-02-17T08:03:07  
1485264 2020-02-17 Canada British Columbia     5 0 0   53.7267 -127.6476 2020-02-17T08:03:07  
889721 2020-02-23 Canada British Columbia     6 0 0   53.7267 -127.6476 2020-02-21T05:23:04  
889729 2020-02-23 Canada Toronto, ON     2 0 2   43.6532 -79.3832 2020-02-21T05:23:04  
966444 2020-02-24 Canada British Columbia     6 0 0   53.7267 -127.6476 2020-02-21T05:23:04  
1371604 2020-02-22 Canada British Columbia     6 0 0   53.7267 -127.6476 2020-02-21T05:23:04  
1371612 2020-02-22 Canada Toronto, ON     2 0 2   43.6532 -79.3832 2020-02-21T05:23:04  
1649101 2020-02-21 Canada British Columbia     6 0 0   53.7267 -127.6476 2020-02-21T05:23:04  
1649110 2020-02-21 Canada Toronto, ON     2 0 2   43.6532 -79.3832 2020-02-21T05:23:04  
966448 2020-02-24 Canada Toronto, ON     3 0 2   43.6532 -79.3832 2020-02-24T14:43:03  
1536113 2020-02-26 Canada Toronto, ON     3 0 2   43.6532 -79.3832 2020-02-24T14:43:03  
1713743 2020-02-25 Canada Toronto, ON     3 0 2   43.6532 -79.3832 2020-02-24T14:43:03  
1536107 2020-02-26 Canada British Columbia     7 0 0   53.7267 -127.6476 2020-02-25T02:23:05  
1713738 2020-02-25 Canada British Columbia     7 0 0   53.7267 -127.6476 2020-02-25T02:23:05  
67089 2020-02-27 Canada British Columbia     7 0 3   53.7267 -127.6476 2020-02-27T03:33:06  
126676 2020-02-28 Canada British Columbia     7 0 3   53.7267 -127.6476 2020-02-27T03:33:06  
67093 2020-02-27 Canada Toronto, ON     5 0 2   43.6532 -79.3832 2020-02-27T22:43:02  
126681 2020-02-28 Canada Toronto, ON     5 0 2   43.6532 -79.3832 2020-02-27T22:43:02  

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