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

View and edit SQL

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

country_or_region

  • Canada · 7,376
Link rowid day country_or_region province_or_state admin2 fips confirmed ▼ deaths recovered active latitude longitude last_update combined_key
79 2021-02-27 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
7123 2020-06-04 Canada Diamond Princess     0 1 0 -1 0.0 0.0 2020-06-05 02:33:06 Diamond Princess, Canada
7293 2020-06-04 Canada Nunavut     0 0 0 0 70.2998 -83.1076 2020-06-05 02:33:06 Nunavut, Canada
7710 2020-08-11 Canada Diamond Princess     0 1 0   0.0 0.0 2020-08-12 04:27:29 Diamond Princess, Canada
7717 2020-08-11 Canada Nunavut     0 0 0 0 70.2998 -83.1076 2020-08-12 04:27:29 Nunavut, Canada
11662 2020-09-27 Canada Diamond Princess     0 1 0   0.0 0.0 2020-09-28 04:23:00 Diamond Princess, Canada
11669 2020-09-27 Canada Nunavut     0 0 0 0 70.2998 -83.1076 2020-09-28 04:23:00 Nunavut, Canada
18583 2020-05-12 Canada Nunavut     0 0 0 0 70.2998 -83.1076 2020-05-13 03:32:26 Nunavut, Canada
18590 2020-05-12 Canada Recovered     0 0 34055 -34055 0.0 0.0 2020-05-13 03:32:26 Recovered, Canada
18884 2021-05-31 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
22871 2021-05-05 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
26858 2021-02-08 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
33556 2020-04-13 Canada Nunavut     0 0 0 0 70.2998 -83.1076 2020-04-13 23:15:25 Nunavut, Canada
33563 2020-04-13 Canada Recovered     0 0 7758 -7758 0.0 0.0 2020-04-13 23:15:25 Recovered, Canada
33853 2020-11-20 Canada Diamond Princess     0 1 0   0.0 0.0 2020-11-21 05:25:51 Diamond Princess, Canada
37825 2020-09-20 Canada Diamond Princess     0 1 0   0.0 0.0 2020-09-21 04:23:00 Diamond Princess, Canada
37832 2020-09-20 Canada Nunavut     0 0 0 0 70.2998 -83.1076 2020-09-21 04:23:00 Nunavut, Canada
41799 2021-06-16 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
45786 2020-12-21 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
49759 2020-09-04 Canada Diamond Princess     0 1 0   0.0 0.0 2020-09-05 04:28:19 Diamond Princess, Canada
49766 2020-09-04 Canada Nunavut     0 0 0 0 70.2998 -83.1076 2020-09-05 04:28:19 Nunavut, Canada
56796 2020-06-05 Canada Diamond Princess     0 1 0 -1 0.0 0.0 2020-06-06 02:33:00 Diamond Princess, Canada
56974 2020-06-05 Canada Nunavut     0 0 0 0 70.2998 -83.1076 2020-06-06 02:33:00 Nunavut, Canada
57412 2021-05-20 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
64515 2020-06-22 Canada Diamond Princess     0 1 0 -1 0.0 0.0 2020-06-23 04:33:22 Diamond Princess, Canada
64714 2020-06-22 Canada Nunavut     0 0 0 0 70.2998 -83.1076 2020-06-23 04:33:22 Nunavut, Canada
65165 2021-02-13 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
69152 2020-11-14 Canada Diamond Princess     0 1 0   0.0 0.0 2020-11-15 05:26:53 Diamond Princess, Canada
76241 2020-03-28 Canada Diamond Princess     0 1 0 0 0.0 0.0 3/28/20 23:10 Diamond Princess, Canada
76284 2020-03-28 Canada Nunavut     0 0 0 0 70.2998 -83.1076 3/28/20 23:10 Nunavut, Canada
76291 2020-03-28 Canada Recovered     0 0 466 0 0.0 0.0 3/28/20 23:10 Recovered, Canada
76573 2020-11-15 Canada Diamond Princess     0 1 0   0.0 0.0 2020-11-16 05:25:57 Diamond Princess, Canada
80556 2021-05-28 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
84543 2021-03-17 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
88530 2021-05-08 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
95631 2020-03-30 Canada Diamond Princess     0 1 0 0 0.0 0.0 3/30/20 22:58 Diamond Princess, Canada
95674 2020-03-30 Canada Nunavut     0 0 0 0 70.2998 -83.1076 3/30/20 22:58 Nunavut, Canada
95681 2020-03-30 Canada Recovered     0 0 466 0 0.0 0.0 3/30/20 22:58 Recovered, Canada
99064 2020-03-26 Canada Diamond Princess     0 1 0 0 0.0 0.0 2020-03-26 23:53:11 Diamond Princess, Canada
99107 2020-03-26 Canada Nunavut     0 0 0 0 70.2998 -83.1076 2020-03-26 23:53:11 Nunavut, Canada
99114 2020-03-26 Canada Recovered     0 0 184 0 0.0 0.0 2020-03-26 23:53:11 Recovered, Canada
99393 2020-11-17 Canada Diamond Princess     0 1 0   0.0 0.0 2020-11-18 05:40:31 Diamond Princess, Canada
106477 2020-06-13 Canada Diamond Princess     0 1 0 -1 0.0 0.0 2020-06-14 03:33:15 Diamond Princess, Canada
106676 2020-06-13 Canada Nunavut     0 0 0 0 70.2998 -83.1076 2020-06-14 03:33:15 Nunavut, Canada
107127 2020-12-07 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-08 05:27:42 Diamond Princess, Canada
113634 2020-04-07 Canada Diamond Princess     0 1 0 0 0.0 0.0 2020-04-07 23:11:15 Diamond Princess, Canada
113678 2020-04-07 Canada Nunavut     0 0 0 0 70.2998 -83.1076 2020-04-07 23:11:15 Nunavut, Canada
113685 2020-04-07 Canada Recovered     0 0 3791 0 0.0 0.0 2020-04-07 23:11:15 Recovered, Canada
116765 2020-04-20 Canada Nunavut     0 0 0 0 70.2998 -83.1076 2020-04-20 23:44:34 Nunavut, Canada
116772 2020-04-20 Canada Recovered     0 0 12543 -12543 0.0 0.0 2020-04-20 23:44:34 Recovered, Canada
120221 2020-07-05 Canada Diamond Princess     0 1 0   0.0 0.0 2020-07-06 04:33:57 Diamond Princess, Canada
120420 2020-07-05 Canada Nunavut     0 0 0 0 70.2998 -83.1076 2020-07-06 04:33:57 Nunavut, Canada
120960 2021-05-09 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
124947 2021-04-01 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
128934 2021-05-11 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
133086 2021-02-28 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
137428 2021-03-09 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
141415 2021-01-08 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
145389 2020-10-27 Canada Diamond Princess     0 1 0   0.0 0.0 2020-10-28 04:24:39 Diamond Princess, Canada
145396 2020-10-27 Canada Nunavut     0 0 0 0 70.2998 -83.1076 2020-10-28 04:24:39 Nunavut, Canada
149368 2021-05-24 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
153443 2020-10-02 Canada Diamond Princess     0 1 0   0.0 0.0 2020-10-03 04:23:40 Diamond Princess, Canada
153450 2020-10-02 Canada Nunavut     0 0 0 0 70.2998 -83.1076 2020-10-03 04:23:40 Nunavut, Canada
160315 2020-05-01 Canada Nunavut     0 0 0 0 70.2998 -83.1076 2020-05-02 02:32:27 Nunavut, Canada
160322 2020-05-01 Canada Recovered     0 0 22764 -22764 0.0 0.0 2020-05-02 02:32:27 Recovered, Canada
160614 2020-12-19 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-20 05:27:32 Diamond Princess, Canada
164598 2021-03-04 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
168585 2020-11-24 Canada Diamond Princess     0 1 0   0.0 0.0 2020-11-25 05:27:20 Diamond Princess, Canada
175566 2020-05-16 Canada Nunavut     0 0 0 0 70.2998 -83.1076 2020-05-17 02:32:32 Nunavut, Canada
175882 2020-12-17 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-18 05:28:18 Diamond Princess, Canada
179855 2020-08-29 Canada Diamond Princess     0 1 0   0.0 0.0 2020-08-30 04:28:22 Diamond Princess, Canada
179862 2020-08-29 Canada Nunavut     0 0 0 0 70.2998 -83.1076 2020-08-30 04:28:22 Nunavut, Canada
183814 2020-10-07 Canada Diamond Princess     0 1 0   0.0 0.0 2020-10-08 04:23:56 Diamond Princess, Canada
183821 2020-10-07 Canada Nunavut     0 0 0 0 70.2998 -83.1076 2020-10-08 04:23:56 Nunavut, Canada
191070 2020-07-31 Canada Diamond Princess     0 1 0   0.0 0.0 2020-08-01 04:36:27 Diamond Princess, Canada
191278 2020-07-31 Canada Nunavut     0 0 0 0 70.2998 -83.1076 2020-08-01 04:36:27 Nunavut, Canada
194954 2020-06-01 Canada Nunavut     0 0 0 0 70.2998 -83.1076 2020-06-02 02:33:08 Nunavut, Canada
195371 2020-10-04 Canada Diamond Princess     0 1 0   0.0 0.0 2020-10-05 04:23:33 Diamond Princess, Canada
195378 2020-10-04 Canada Nunavut     0 0 0 0 70.2998 -83.1076 2020-10-05 04:23:33 Nunavut, Canada
199566 2020-10-12 Canada Diamond Princess     0 1 0   0.0 0.0 2020-10-13 04:24:02 Diamond Princess, Canada
199573 2020-10-12 Canada Nunavut     0 0 0 0 70.2998 -83.1076 2020-10-13 04:24:02 Nunavut, Canada
206384 2020-04-30 Canada Diamond Princess     0 1 0 -1 0.0 0.0 2020-05-01 02:32:28 Diamond Princess, Canada
206428 2020-04-30 Canada Nunavut     0 0 0 0 70.2998 -83.1076 2020-05-01 02:32:28 Nunavut, Canada
206435 2020-04-30 Canada Recovered     0 0 21424 -21424 0.0 0.0 2020-05-01 02:32:28 Recovered, Canada
206727 2021-01-05 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
210701 2020-09-18 Canada Diamond Princess     0 1 0   0.0 0.0 2020-09-19 04:22:00 Diamond Princess, Canada
210708 2020-09-18 Canada Nunavut     0 0 0 0 70.2998 -83.1076 2020-09-19 04:22:00 Nunavut, Canada
214675 2021-04-04 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
218662 2020-12-01 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-02 05:27:41 Diamond Princess, Canada
222646 2021-01-01 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
226707 2021-06-21 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
230694 2021-05-17 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
234681 2021-06-24 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
241781 2020-06-20 Canada Diamond Princess     0 1 0 -1 0.0 0.0 2020-06-21 04:33:19 Diamond Princess, Canada
241980 2020-06-20 Canada Nunavut     0 0 0 0 70.2998 -83.1076 2020-06-21 04:33:19 Nunavut, Canada
245336 2020-04-28 Canada Diamond Princess     0 1 0 -1 0.0 0.0 2020-04-29 02:32:29 Diamond Princess, Canada
245380 2020-04-28 Canada Nunavut     0 0 0 0 70.2998 -83.1076 2020-04-29 02:32:29 Nunavut, Canada
245387 2020-04-28 Canada Recovered     0 0 19231 -19231 0.0 0.0 2020-04-29 02:32:29 Recovered, Canada
245677 2021-06-06 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
249664 2020-12-06 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-07 05:26:14 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]);