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

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
3144 2020-10-26 Canada Diamond Princess     0 1 0   0.0 0.0 2020-10-27 04:24:45 Diamond Princess, Canada
13746 2020-07-17 Canada Diamond Princess     0 1 0   0.0 0.0 2020-07-18 04:34:45 Diamond Princess, Canada
14408 2021-04-30 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
21511 2020-10-13 Canada Diamond Princess     0 1 0   0.0 0.0 2020-10-14 04:24:05 Diamond Princess, Canada
28725 2020-11-23 Canada Diamond Princess     0 1 0   0.0 0.0 2020-11-24 05:27:31 Diamond Princess, Canada
32705 2021-04-12 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
36678 2020-10-27 Canada Diamond Princess     0 1 0   0.0 0.0 2020-10-28 04:24:39 Diamond Princess, Canada
43932 2020-07-30 Canada Diamond Princess     0 1 0   0.0 0.0 2020-07-31 04:35:18 Diamond Princess, Canada
47834 2020-12-19 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-20 05:27:32 Diamond Princess, Canada
55344 2021-03-16 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
59328 2020-12-07 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-08 05:27:42 Diamond Princess, Canada
66468 2020-07-05 Canada Diamond Princess     0 1 0   0.0 0.0 2020-07-06 04:33:57 Diamond Princess, Canada
67089 2020-02-27 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  
67118 2020-02-27 Canada London, ON     1 0 1   42.9849 -81.2453 2020-02-12T18:53:03  
67222 2021-05-29 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
71206 2021-05-05 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
78464 2020-07-27 Canada Diamond Princess     0 1 0   0.0 0.0 2020-07-28 04:58:43 Diamond Princess, Canada
79117 2020-10-28 Canada Diamond Princess     0 1 0   0.0 0.0 2020-10-29 04:24:49 Diamond Princess, Canada
83083 2020-09-16 Canada Diamond Princess     0 1 0   0.0 0.0 2020-09-17 04:22:00 Diamond Princess, Canada
87043 2020-10-09 Canada Diamond Princess     0 1 0   0.0 0.0 2020-10-10 04:23:57 Diamond Princess, Canada
91016 2020-12-06 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-07 05:26:14 Diamond Princess, Canada
94997 2020-11-18 Canada Diamond Princess     0 1 0   0.0 0.0 2020-11-19 05:25:23 Diamond Princess, Canada
98977 2021-05-23 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
106244 2020-08-08 Canada Diamond Princess     0 1 0   0.0 0.0 2020-08-09 04:34:54 Diamond Princess, Canada
106908 2020-11-29 Canada Diamond Princess     0 1 0   0.0 0.0 2020-11-30 05:26:13 Diamond Princess, Canada
110878 2020-08-11 Canada Diamond Princess     0 1 0   0.0 0.0 2020-08-12 04:27:29 Diamond Princess, Canada
118101 2020-07-18 Canada Diamond Princess     0 1 0   0.0 0.0 2020-07-19 04:34:58 Diamond Princess, Canada
118752 2020-08-20 Canada Diamond Princess     0 1 0   0.0 0.0 2020-08-21 04:27:41 Diamond Princess, Canada
122718 2021-04-05 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
126676 2020-02-28 Canada British Columbia     7 0 3   53.7267 -127.6476 2020-02-27T03:33:06  
126681 2020-02-28 Canada Toronto, ON     5 0 2   43.6532 -79.3832 2020-02-27T22:43:02  
126709 2020-02-28 Canada Montreal, QC     1 0 0   45.5017 -73.5673 2020-02-28T05:23:07  
126710 2020-02-28 Canada London, ON     1 0 1   42.9849 -81.2453 2020-02-12T18:53:03  
126816 2020-03-14 Canada Ontario     79 0 4   51.2538 -85.3232 2020-03-14T13:13:25  
126824 2020-03-14 Canada British Columbia     64 1 4   53.7267 -127.6476 2020-03-14T00:13:05  
126853 2020-03-14 Canada Alberta     29 0 0   53.9333 -116.5765 2020-03-14T00:13:05  
126880 2020-03-14 Canada Quebec     17 0 0   52.9399 -73.5491 2020-03-13T13:33:03  
126922 2020-03-14 Canada Manitoba     4 0 0   53.7609 -98.8139 2020-03-14T00:13:05  
126938 2020-03-14 Canada Saskatchewan     2 0 0   52.9399 -106.4509 2020-03-14T00:13:05  
126957 2020-03-14 Canada New Brunswick     1 0 0   46.5653 -66.4619 2020-03-11T23:13:06  
133662 2020-07-04 Canada Diamond Princess     0 1 0   0.0 0.0 2020-07-05 04:33:46 Diamond Princess, Canada
134278 2020-02-10 Canada British Columbia     4 0 0   53.7267 -127.6476 2020-02-07T05:43:03  
134283 2020-02-10 Canada Toronto, ON     2 0 0   43.6532 -79.3832 2020-02-04T00:13:06  
134291 2020-02-10 Canada London, ON     1 0 0   42.9849 -81.2453 2020-02-04T00:03:11  
134372 2020-10-05 Canada Diamond Princess     0 1 0   0.0 0.0 2020-10-06 04:23:33 Diamond Princess, Canada
138345 2020-11-13 Canada Diamond Princess     0 1 0   0.0 0.0 2020-11-14 05:25:37 Diamond Princess, Canada
142325 2021-02-03 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
146309 2021-02-09 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
150268 2020-03-02 Canada Toronto, ON     17 0 2   43.6532 -79.3832 2020-03-02T20:53:02  
150279 2020-03-02 Canada British Columbia     8 0 3   49.2827 -123.1207 2020-02-29T23:23:13  
150319 2020-03-02 Canada Montreal, QC     1 0 0   45.5017 -73.5673 2020-02-28T05:23:07  
150320 2020-03-02 Canada London, ON     1 0 1   42.9849 -81.2453 2020-02-12T18:53:03  
150436 2021-03-25 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
158183 2021-06-05 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
162167 2021-01-25 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
166120 2020-02-16 Canada British Columbia     4 0 0   53.7267 -127.6476 2020-02-07T05:43:03  
166125 2020-02-16 Canada Toronto, ON     2 0 0   43.6532 -79.3832 2020-02-04T00:13:06  
166134 2020-02-16 Canada London, ON     1 0 1   42.9849 -81.2453 2020-02-12T18:53:03  
166228 2021-02-24 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
170201 2020-09-02 Canada Diamond Princess     0 1 0   0.0 0.0 2020-09-03 04:28:22 Diamond Princess, Canada
187396 2021-01-30 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
191369 2020-08-17 Canada Diamond Princess     0 1 0   0.0 0.0 2020-08-18 04:27:56 Diamond Princess, Canada
195302 2020-02-11 Canada British Columbia     4 0 0   53.7267 -127.6476 2020-02-07T05:43:03  
195307 2020-02-11 Canada Toronto, ON     2 0 0   43.6532 -79.3832 2020-02-04T00:13:06  
195315 2020-02-11 Canada London, ON     1 0 0   42.9849 -81.2453 2020-02-04T00:03:11  
195408 2021-05-28 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
202813 2021-05-24 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
210077 2020-08-04 Canada Diamond Princess     0 1 0   0.0 0.0 2020-08-05 04:34:43 Diamond Princess, Canada
210740 2021-02-17 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
214724 2021-06-13 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
218708 2021-02-15 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
222692 2021-06-14 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
226676 2021-01-29 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
230649 2020-08-18 Canada Diamond Princess     0 1 0   0.0 0.0 2020-08-19 04:27:00 Diamond Princess, Canada
241549 2020-07-10 Canada Diamond Princess     0 1 0   0.0 0.0 2020-07-11 04:34:26 Diamond Princess, Canada
242198 2020-11-22 Canada Diamond Princess     0 1 0   0.0 0.0 2020-11-23 05:25:26 Diamond Princess, Canada
253171 2020-07-22 Canada Diamond Princess     0 1 0   0.0 0.0 2020-07-23 05:15:04 Diamond Princess, Canada
253834 2021-03-20 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
257807 2020-08-31 Canada Diamond Princess     0 1 0   0.0 0.0 2020-09-01 04:28:31 Diamond Princess, Canada
261778 2020-12-15 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-16 05:28:04 Diamond Princess, Canada
265739 2020-03-04 Canada Toronto, ON     19 0 2   43.6532 -79.3832 2020-03-03T20:03:08  
265747 2020-03-04 Canada British Columbia     12 0 3   49.2827 -123.1207 2020-03-04T04:23:05  
265801 2020-03-04 Canada Montreal, QC     1 0 0   45.5017 -73.5673 2020-02-28T05:23:07  
265802 2020-03-04 Canada London, ON     1 0 1   42.9849 -81.2453 2020-02-12T18:53:03  
265910 2020-11-02 Canada Diamond Princess     0 1 0   0.0 0.0 2020-11-03 06:00:16 Diamond Princess, Canada
269887 2021-04-02 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
277310 2021-02-14 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
281294 2021-06-12 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
285278 2020-12-03 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-04 05:27:27 Diamond Princess, Canada
289259 2021-03-30 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
293243 2021-01-10 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
297214 2020-09-09 Canada Diamond Princess     0 1 0   0.0 0.0 2020-09-10 04:29:01 Diamond Princess, Canada
301166 2020-03-05 Canada Toronto, ON     21 0 2   43.6532 -79.3832 2020-03-05T17:53:03  
301177 2020-03-05 Canada British Columbia     13 0 3   49.2827 -123.1207 2020-03-05T04:43:03  
301214 2020-03-05 Canada Montreal, QC     2 0 0   45.5017 -73.5673 2020-03-05T14:03:04  
301238 2020-03-05 Canada London, ON     1 0 1   42.9849 -81.2453 2020-02-12T18:53:03  
304785 2021-03-21 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
308769 2021-03-02 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
312753 2021-01-16 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond 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]);