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

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
90 2021-02-27 Canada Repatriated Travellers     13 0 13 0     2021-02-28 05:22:20 Repatriated Travellers, Canada
18895 2021-05-31 Canada Repatriated Travellers     13 0 13 0     2021-06-01 04:23:09 Repatriated Travellers, Canada
22882 2021-05-05 Canada Repatriated Travellers     13 0 13 0     2021-05-06 04:20:38 Repatriated Travellers, Canada
26869 2021-02-08 Canada Repatriated Travellers     13 0 13 0     2021-02-09 05:23:30 Repatriated Travellers, Canada
41810 2021-06-16 Canada Repatriated Travellers     13 0 13 0     2021-06-17 04:22:36 Repatriated Travellers, Canada
45797 2020-12-21 Canada Repatriated Travellers     13 0 13 0     2020-12-22 05:22:33 Repatriated Travellers, Canada
57423 2021-05-20 Canada Repatriated Travellers     13 0 13 0     2021-05-21 04:20:43 Repatriated Travellers, Canada
65176 2021-02-13 Canada Repatriated Travellers     13 0 13 0     2021-02-14 05:23:43 Repatriated Travellers, Canada
80567 2021-05-28 Canada Repatriated Travellers     13 0 13 0     2021-05-29 04:20:41 Repatriated Travellers, Canada
84554 2021-03-17 Canada Repatriated Travellers     13 0 13 0     2021-03-18 05:26:22 Repatriated Travellers, Canada
88541 2021-05-08 Canada Repatriated Travellers     13 0 13 0     2021-05-09 04:20:35 Repatriated Travellers, Canada
107138 2020-12-07 Canada Repatriated Travellers     13 0 13 0     2020-12-08 05:27:42 Repatriated Travellers, Canada
120971 2021-05-09 Canada Repatriated Travellers     13 0 13 0     2021-05-10 04:20:38 Repatriated Travellers, Canada
124958 2021-04-01 Canada Repatriated Travellers     13 0 13 0     2021-04-02 04:20:36 Repatriated Travellers, Canada
128945 2021-05-11 Canada Repatriated Travellers     13 0 13 0     2021-05-12 04:21:29 Repatriated Travellers, Canada
133097 2021-02-28 Canada Repatriated Travellers     13 0 13 0     2021-03-01 05:23:01 Repatriated Travellers, Canada
137439 2021-03-09 Canada Repatriated Travellers     13 0 13 0     2021-03-10 05:24:35 Repatriated Travellers, Canada
141426 2021-01-08 Canada Repatriated Travellers     13 0 13 0     2021-01-09 05:22:18 Repatriated Travellers, Canada
149379 2021-05-24 Canada Repatriated Travellers     13 0 13 0     2021-05-25 04:21:08 Repatriated Travellers, Canada
160625 2020-12-19 Canada Repatriated Travellers     13 0 13 0     2020-12-20 05:27:32 Repatriated Travellers, Canada
164609 2021-03-04 Canada Repatriated Travellers     13 0 13 0     2021-03-05 05:26:29 Repatriated Travellers, Canada
168596 2020-11-24 Canada Repatriated Travellers     13 0 13 0     2020-11-25 05:27:20 Repatriated Travellers, Canada
175893 2020-12-17 Canada Repatriated Travellers     13 0 13 0     2020-12-18 05:28:18 Repatriated Travellers, Canada
206738 2021-01-05 Canada Repatriated Travellers     13 0 13 0     2021-01-06 05:22:16 Repatriated Travellers, Canada
214686 2021-04-04 Canada Repatriated Travellers     13 0 13 0     2021-04-05 04:20:35 Repatriated Travellers, Canada
218673 2020-12-01 Canada Repatriated Travellers     13 0 13 0     2020-12-02 05:27:41 Repatriated Travellers, Canada
222657 2021-01-01 Canada Repatriated Travellers     13 0 13 0     2021-01-02 05:22:33 Repatriated Travellers, Canada
226718 2021-06-21 Canada Repatriated Travellers     13 0 13 0     2021-06-22 04:21:34 Repatriated Travellers, Canada
230705 2021-05-17 Canada Repatriated Travellers     13 0 13 0     2021-05-18 04:20:33 Repatriated Travellers, Canada
234692 2021-06-24 Canada Repatriated Travellers     13 0 13 0     2021-06-25 04:21:33 Repatriated Travellers, Canada
245688 2021-06-06 Canada Repatriated Travellers     13 0 13 0     2021-06-07 04:22:51 Repatriated Travellers, Canada
249675 2020-12-06 Canada Repatriated Travellers     13 0 13 0     2020-12-07 05:26:14 Repatriated Travellers, Canada
253659 2021-03-16 Canada Repatriated Travellers     13 0 13 0     2021-03-17 05:25:07 Repatriated Travellers, Canada
261591 2020-11-25 Canada Repatriated Travellers     13 0 13 0     2020-11-26 05:27:44 Repatriated Travellers, Canada
265575 2020-12-10 Canada Repatriated Travellers     13 0 13 0     2020-12-11 05:26:59 Repatriated Travellers, Canada
272611 2021-06-10 Canada Repatriated Travellers     13 0 13 0     2021-06-11 04:23:20 Repatriated Travellers, Canada
280391 2021-02-10 Canada Repatriated Travellers     13 0 13 0     2021-02-11 05:23:55 Repatriated Travellers, Canada
287694 2021-01-31 Canada Repatriated Travellers     13 0 13 0     2021-02-01 05:22:53 Repatriated Travellers, Canada
291681 2021-02-17 Canada Repatriated Travellers     13 0 13 0     2021-02-18 05:22:58 Repatriated Travellers, Canada
299096 2021-03-06 Canada Repatriated Travellers     13 0 13 0     2021-03-07 05:21:54 Repatriated Travellers, Canada
303083 2021-06-18 Canada Repatriated Travellers     13 0 13 0     2021-06-19 04:22:33 Repatriated Travellers, Canada
307070 2021-01-17 Canada Repatriated Travellers     13 0 13 0     2021-01-18 05:22:34 Repatriated Travellers, Canada
318979 2021-06-13 Canada Repatriated Travellers     13 0 13 0     2021-06-14 04:22:46 Repatriated Travellers, Canada
322966 2021-01-24 Canada Repatriated Travellers     13 0 13 0     2021-01-25 05:22:16 Repatriated Travellers, Canada
334589 2021-04-27 Canada Repatriated Travellers     13 0 13 0     2021-04-28 04:20:32 Repatriated Travellers, Canada
342518 2021-02-20 Canada Repatriated Travellers     13 0 13 0     2021-02-21 05:24:33 Repatriated Travellers, Canada
350041 2021-04-06 Canada Repatriated Travellers     13 0 13 0     2021-04-07 04:20:53 Repatriated Travellers, Canada
354108 2021-04-12 Canada Repatriated Travellers     13 0 13 0     2021-04-13 04:20:37 Repatriated Travellers, Canada
379695 2021-04-15 Canada Repatriated Travellers     13 0 13 0     2021-04-16 04:20:46 Repatriated Travellers, Canada
387146 2021-05-22 Canada Repatriated Travellers     13 0 13 0     2021-05-23 04:20:51 Repatriated Travellers, Canada
402764 2021-03-26 Canada Repatriated Travellers     13 0 13 0     2021-03-27 05:25:04 Repatriated Travellers, Canada
409992 2020-12-02 Canada Repatriated Travellers     13 0 13 0     2020-12-03 05:28:22 Repatriated Travellers, Canada
417945 2021-01-04 Canada Repatriated Travellers     13 0 13 0     2021-01-05 05:21:49 Repatriated Travellers, Canada
421930 2021-03-28 Canada Repatriated Travellers     13 0 13 0     2021-03-29 04:28:35 Repatriated Travellers, Canada
442029 2021-03-20 Canada Repatriated Travellers     13 0 13 0     2021-03-21 05:25:44 Repatriated Travellers, Canada
446016 2020-12-29 Canada Repatriated Travellers     13 0 13 0     2020-12-30 05:22:34 Repatriated Travellers, Canada
459698 2021-02-23 Canada Repatriated Travellers     13 0 13 0     2021-02-24 05:29:16 Repatriated Travellers, Canada
463685 2021-05-19 Canada Repatriated Travellers     13 0 13 0     2021-05-20 04:21:05 Repatriated Travellers, Canada
471640 2021-06-23 Canada Repatriated Travellers     13 0 13 0     2021-06-24 04:21:55 Repatriated Travellers, Canada
483551 2021-04-28 Canada Repatriated Travellers     13 0 13 0     2021-04-29 04:20:55 Repatriated Travellers, Canada
487538 2021-04-23 Canada Repatriated Travellers     13 0 13 0     2021-04-24 04:20:38 Repatriated Travellers, Canada
491606 2020-12-11 Canada Repatriated Travellers     13 0 13 0     2020-12-12 05:26:19 Repatriated Travellers, Canada
495590 2021-04-25 Canada Repatriated Travellers     13 0 13 0     2021-04-26 04:21:04 Repatriated Travellers, Canada
507337 2021-03-24 Canada Repatriated Travellers     13 0 13 0     2021-03-25 05:27:00 Repatriated Travellers, Canada
511324 2021-02-21 Canada Repatriated Travellers     13 0 13 0     2021-02-22 05:24:21 Repatriated Travellers, Canada
522039 2021-05-07 Canada Repatriated Travellers     13 0 13 0     2021-05-08 04:21:04 Repatriated Travellers, Canada
526026 2021-03-15 Canada Repatriated Travellers     13 0 13 0     2021-03-16 05:25:13 Repatriated Travellers, Canada
530013 2020-12-20 Canada Repatriated Travellers     13 0 13 0     2020-12-21 05:27:58 Repatriated Travellers, Canada
540984 2021-02-15 Canada Repatriated Travellers     13 0 13 0     2021-02-16 05:24:38 Repatriated Travellers, Canada
544971 2021-03-19 Canada Repatriated Travellers     13 0 13 0     2021-03-20 05:25:46 Repatriated Travellers, Canada
552928 2021-06-04 Canada Repatriated Travellers     13 0 13 0     2021-06-05 04:23:03 Repatriated Travellers, Canada
560882 2021-01-06 Canada Repatriated Travellers     13 0 13 0     2021-01-07 05:22:03 Repatriated Travellers, Canada
564867 2021-03-07 Canada Repatriated Travellers     13 0 13 0     2021-03-08 05:24:48 Repatriated Travellers, Canada
568854 2021-04-08 Canada Repatriated Travellers     13 0 13 0     2021-04-09 04:21:13 Repatriated Travellers, Canada
572841 2020-12-23 Canada Repatriated Travellers     13 0 13 0     2020-12-24 05:23:04 Repatriated Travellers, Canada
576825 2021-06-07 Canada Repatriated Travellers     13 0 13 0     2021-06-08 04:22:35 Repatriated Travellers, Canada
591733 2021-06-11 Canada Repatriated Travellers     13 0 13 0     2021-06-12 04:22:22 Repatriated Travellers, Canada
598838 2021-02-24 Canada Repatriated Travellers     13 0 13 0     2021-02-25 05:24:57 Repatriated Travellers, Canada
606781 2021-04-19 Canada Repatriated Travellers     13 0 13 0     2021-04-20 04:20:41 Repatriated Travellers, Canada
610768 2021-02-22 Canada Repatriated Travellers     13 0 13 0     2021-02-23 05:23:41 Repatriated Travellers, Canada
618724 2021-06-12 Canada Repatriated Travellers     13 0 13 0     2021-06-13 04:22:44 Repatriated Travellers, Canada
622711 2021-05-29 Canada Repatriated Travellers     13 0 13 0     2021-05-30 04:20:55 Repatriated Travellers, Canada
626698 2021-06-22 Canada Repatriated Travellers     13 0 13 0     2021-06-23 04:21:46 Repatriated Travellers, Canada
630685 2020-11-26 Canada Repatriated Travellers     13 0 13 0     2020-11-27 05:26:53 Repatriated Travellers, Canada
638632 2021-01-14 Canada Repatriated Travellers     13 0 13 0     2021-01-15 05:22:24 Repatriated Travellers, Canada
645969 2020-11-28 Canada Repatriated Travellers     13 0 13 0     2020-11-29 05:25:55 Repatriated Travellers, Canada
661631 2021-03-03 Canada Repatriated Travellers     13 0 13 0     2021-03-04 05:24:24 Repatriated Travellers, Canada
665618 2020-12-22 Canada Repatriated Travellers     13 0 13 0     2020-12-23 05:22:03 Repatriated Travellers, Canada
669602 2021-03-08 Canada Repatriated Travellers     13 0 13 0     2021-03-09 05:28:19 Repatriated Travellers, Canada
673665 2021-06-05 Canada Repatriated Travellers     13 0 13 0     2021-06-06 04:24:03 Repatriated Travellers, Canada
685545 2021-05-12 Canada Repatriated Travellers     13 0 13 0     2021-05-13 04:20:51 Repatriated Travellers, Canada
689532 2021-05-23 Canada Repatriated Travellers     13 0 13 0     2021-05-24 04:20:53 Repatriated Travellers, Canada
701438 2021-03-01 Canada Repatriated Travellers     13 0 13 0     2021-03-02 05:23:30 Repatriated Travellers, Canada
708929 2020-12-13 Canada Repatriated Travellers     13 0 13 0     2020-12-14 05:26:27 Repatriated Travellers, Canada
712913 2021-01-19 Canada Repatriated Travellers     13 0 13 0     2021-01-20 05:21:54 Repatriated Travellers, Canada
716899 2021-02-25 Canada Repatriated Travellers     13 0 13 0     2021-02-26 05:22:40 Repatriated Travellers, Canada
720886 2021-03-21 Canada Repatriated Travellers     13 0 13 0     2021-03-22 05:25:43 Repatriated Travellers, Canada
732626 2021-03-29 Canada Repatriated Travellers     13 0 13 0     2021-03-30 04:26:23 Repatriated Travellers, Canada
754758 2021-01-10 Canada Repatriated Travellers     13 0 13 0     2021-01-11 05:21:50 Repatriated Travellers, Canada
782333 2020-12-26 Canada Repatriated Travellers     13 0 13 0     2020-12-27 05:22:55 Repatriated Travellers, 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]);