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

213 rows where country_or_region = "Canada" and province_or_state = "Repatriated Travellers" sorted by day descending

View and edit SQL

Suggested facets: day (date), last_update (date)

province_or_state

  • Repatriated Travellers · 213

country_or_region

  • Canada · 213
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
234692 2021-06-24 Canada Repatriated Travellers     13 0 13 0     2021-06-25 04:21:33 Repatriated Travellers, Canada
471640 2021-06-23 Canada Repatriated Travellers     13 0 13 0     2021-06-24 04:21:55 Repatriated Travellers, Canada
626698 2021-06-22 Canada Repatriated Travellers     13 0 13 0     2021-06-23 04:21:46 Repatriated Travellers, Canada
226718 2021-06-21 Canada Repatriated Travellers     13 0 13 0     2021-06-22 04:21:34 Repatriated Travellers, Canada
1472240 2021-06-20 Canada Repatriated Travellers     13 0 13 0     2021-06-21 04:21:41 Repatriated Travellers, Canada
1303481 2021-06-19 Canada Repatriated Travellers     13 0 13 0     2021-06-20 04:21:48 Repatriated Travellers, Canada
303083 2021-06-18 Canada Repatriated Travellers     13 0 13 0     2021-06-19 04:22:33 Repatriated Travellers, Canada
885913 2021-06-17 Canada Repatriated Travellers     13 0 13 0     2021-06-18 04:22:16 Repatriated Travellers, Canada
41810 2021-06-16 Canada Repatriated Travellers     13 0 13 0     2021-06-17 04:22:36 Repatriated Travellers, Canada
1704632 2021-06-15 Canada Repatriated Travellers     13 0 13 0     2021-06-16 04:22:32 Repatriated Travellers, Canada
1660903 2021-06-14 Canada Repatriated Travellers     13 0 13 0     2021-06-15 04:22:22 Repatriated Travellers, Canada
318979 2021-06-13 Canada Repatriated Travellers     13 0 13 0     2021-06-14 04:22:46 Repatriated Travellers, Canada
618724 2021-06-12 Canada Repatriated Travellers     13 0 13 0     2021-06-13 04:22:44 Repatriated Travellers, Canada
591733 2021-06-11 Canada Repatriated Travellers     13 0 13 0     2021-06-12 04:22:22 Repatriated Travellers, Canada
272611 2021-06-10 Canada Repatriated Travellers     13 0 13 0     2021-06-11 04:23:20 Repatriated Travellers, Canada
1637669 2021-06-09 Canada Repatriated Travellers     13 0 13 0     2021-06-10 04:23:17 Repatriated Travellers, Canada
1744282 2021-06-08 Canada Repatriated Travellers     13 0 13 0     2021-06-09 04:23:31 Repatriated Travellers, Canada
576825 2021-06-07 Canada Repatriated Travellers     13 0 13 0     2021-06-08 04:22:35 Repatriated Travellers, Canada
245688 2021-06-06 Canada Repatriated Travellers     13 0 13 0     2021-06-07 04:22:51 Repatriated Travellers, Canada
673665 2021-06-05 Canada Repatriated Travellers     13 0 13 0     2021-06-06 04:24:03 Repatriated Travellers, Canada
552928 2021-06-04 Canada Repatriated Travellers     13 0 13 0     2021-06-05 04:23:03 Repatriated Travellers, Canada
1460325 2021-06-03 Canada Repatriated Travellers     13 0 13 0     2021-06-04 04:23:37 Repatriated Travellers, Canada
1399318 2021-06-02 Canada Repatriated Travellers     13 0 13 0     2021-06-03 04:23:32 Repatriated Travellers, Canada
1708665 2021-06-01 Canada Repatriated Travellers     13 0 13 0     2021-06-02 04:24:34 Repatriated Travellers, Canada
18895 2021-05-31 Canada Repatriated Travellers     13 0 13 0     2021-06-01 04:23:09 Repatriated Travellers, Canada
1497288 2021-05-30 Canada Repatriated Travellers     13 0 13 0     2021-05-31 03:08:59 Repatriated Travellers, Canada
622711 2021-05-29 Canada Repatriated Travellers     13 0 13 0     2021-05-30 04:20:55 Repatriated Travellers, Canada
80567 2021-05-28 Canada Repatriated Travellers     13 0 13 0     2021-05-29 04:20:41 Repatriated Travellers, Canada
1425842 2021-05-27 Canada Repatriated Travellers     13 0 13 0     2021-05-28 04:20:36 Repatriated Travellers, Canada
1548810 2021-05-26 Canada Repatriated Travellers     13 0 13 0     2021-05-27 04:20:59 Repatriated Travellers, Canada
1200386 2021-05-25 Canada Repatriated Travellers     13 0 13 0     2021-05-26 04:20:35 Repatriated Travellers, Canada
149379 2021-05-24 Canada Repatriated Travellers     13 0 13 0     2021-05-25 04:21:08 Repatriated Travellers, Canada
689532 2021-05-23 Canada Repatriated Travellers     13 0 13 0     2021-05-24 04:20:53 Repatriated Travellers, Canada
387146 2021-05-22 Canada Repatriated Travellers     13 0 13 0     2021-05-23 04:20:51 Repatriated Travellers, Canada
969461 2021-05-21 Canada Repatriated Travellers     13 0 13 0     2021-05-22 04:20:45 Repatriated Travellers, Canada
57423 2021-05-20 Canada Repatriated Travellers     13 0 13 0     2021-05-21 04:20:43 Repatriated Travellers, Canada
463685 2021-05-19 Canada Repatriated Travellers     13 0 13 0     2021-05-20 04:21:05 Repatriated Travellers, Canada
1275641 2021-05-18 Canada Repatriated Travellers     13 0 13 0     2021-05-19 04:20:42 Repatriated Travellers, Canada
230705 2021-05-17 Canada Repatriated Travellers     13 0 13 0     2021-05-18 04:20:33 Repatriated Travellers, Canada
1158920 2021-05-16 Canada Repatriated Travellers     13 0 13 0     2021-05-17 04:20:34 Repatriated Travellers, Canada
1008476 2021-05-15 Canada Repatriated Travellers     13 0 13 0     2021-05-16 04:20:49 Repatriated Travellers, Canada
804588 2021-05-14 Canada Repatriated Travellers     13 0 13 0     2021-05-15 04:20:58 Repatriated Travellers, Canada
1192416 2021-05-13 Canada Repatriated Travellers     13 0 13 0     2021-05-14 04:20:41 Repatriated Travellers, Canada
685545 2021-05-12 Canada Repatriated Travellers     13 0 13 0     2021-05-13 04:20:51 Repatriated Travellers, Canada
128945 2021-05-11 Canada Repatriated Travellers     13 0 13 0     2021-05-12 04:21:29 Repatriated Travellers, Canada
1256950 2021-05-10 Canada Repatriated Travellers     13 0 13 0     2021-05-11 04:20:41 Repatriated Travellers, Canada
120971 2021-05-09 Canada Repatriated Travellers     13 0 13 0     2021-05-10 04:20:38 Repatriated Travellers, Canada
88541 2021-05-08 Canada Repatriated Travellers     13 0 13 0     2021-05-09 04:20:35 Repatriated Travellers, Canada
522039 2021-05-07 Canada Repatriated Travellers     13 0 13 0     2021-05-08 04:21:04 Repatriated Travellers, Canada
1684663 2021-05-06 Canada Repatriated Travellers     13 0 13 0     2021-05-07 04:20:40 Repatriated Travellers, Canada
22882 2021-05-05 Canada Repatriated Travellers     13 0 13 0     2021-05-06 04:20:38 Repatriated Travellers, Canada
1330824 2021-05-04 Canada Repatriated Travellers     13 0 13 0     2021-05-05 04:20:43 Repatriated Travellers, Canada
1035411 2021-05-03 Canada Repatriated Travellers     13 0 13 0     2021-05-04 04:20:34 Repatriated Travellers, Canada
913601 2021-05-02 Canada Repatriated Travellers     13 0 13 0     2021-05-03 04:20:39 Repatriated Travellers, Canada
1756567 2021-05-01 Canada Repatriated Travellers     13 0 13 0     2021-05-02 04:20:48 Repatriated Travellers, Canada
1456338 2021-04-30 Canada Repatriated Travellers     13 0 13 0     2021-05-01 04:20:47 Repatriated Travellers, Canada
1614152 2021-04-29 Canada Repatriated Travellers     13 0 13 0     2021-04-30 04:21:03 Repatriated Travellers, Canada
483551 2021-04-28 Canada Repatriated Travellers     13 0 13 0     2021-04-29 04:20:55 Repatriated Travellers, Canada
334589 2021-04-27 Canada Repatriated Travellers     13 0 13 0     2021-04-28 04:20:32 Repatriated Travellers, Canada
1357634 2021-04-26 Canada Repatriated Travellers     13 0 13 0     2021-04-27 04:20:52 Repatriated Travellers, Canada
495590 2021-04-25 Canada Repatriated Travellers     13 0 13 0     2021-04-26 04:21:04 Repatriated Travellers, Canada
1112189 2021-04-24 Canada Repatriated Travellers     13 0 13 0     2021-04-25 04:20:32 Repatriated Travellers, Canada
487538 2021-04-23 Canada Repatriated Travellers     13 0 13 0     2021-04-24 04:20:38 Repatriated Travellers, Canada
1169923 2021-04-22 Canada Repatriated Travellers     13 0 13 0     2021-04-23 04:20:52 Repatriated Travellers, Canada
1403394 2021-04-21 Canada Repatriated Travellers     13 0 13 0     2021-04-22 04:20:53 Repatriated Travellers, Canada
1712652 2021-04-20 Canada Repatriated Travellers     13 0 13 0     2021-04-21 04:21:14 Repatriated Travellers, Canada
606781 2021-04-19 Canada Repatriated Travellers     13 0 13 0     2021-04-20 04:20:41 Repatriated Travellers, Canada
917588 2021-04-18 Canada Repatriated Travellers     13 0 13 0     2021-04-19 04:20:57 Repatriated Travellers, Canada
1318899 2021-04-17 Canada Repatriated Travellers     13 0 13 0     2021-04-18 04:20:41 Repatriated Travellers, Canada
988591 2021-04-16 Canada Repatriated Travellers     13 0 13 0     2021-04-17 04:20:40 Repatriated Travellers, Canada
379695 2021-04-15 Canada Repatriated Travellers     13 0 13 0     2021-04-16 04:20:46 Repatriated Travellers, Canada
905645 2021-04-14 Canada Repatriated Travellers     13 0 13 0     2021-04-15 04:20:54 Repatriated Travellers, Canada
1078872 2021-04-13 Canada Repatriated Travellers     13 0 13 0     2021-04-14 04:20:41 Repatriated Travellers, Canada
354108 2021-04-12 Canada Repatriated Travellers     13 0 13 0     2021-04-13 04:20:37 Repatriated Travellers, Canada
1180557 2021-04-11 Canada Repatriated Travellers     13 0 13 0     2021-04-12 04:21:00 Repatriated Travellers, Canada
1188429 2021-04-10 Canada Repatriated Travellers     13 0 13 0     2021-04-11 04:20:56 Repatriated Travellers, Canada
1692615 2021-04-09 Canada Repatriated Travellers     13 0 13 0     2021-04-10 04:20:59 Repatriated Travellers, Canada
568854 2021-04-08 Canada Repatriated Travellers     13 0 13 0     2021-04-09 04:21:13 Repatriated Travellers, Canada
1345673 2021-04-07 Canada Repatriated Travellers     13 0 13 0     2021-04-08 04:21:13 Repatriated Travellers, Canada
350041 2021-04-06 Canada Repatriated Travellers     13 0 13 0     2021-04-07 04:20:53 Repatriated Travellers, Canada
1043366 2021-04-05 Canada Repatriated Travellers     13 0 13 0     2021-04-06 04:20:32 Repatriated Travellers, Canada
214686 2021-04-04 Canada Repatriated Travellers     13 0 13 0     2021-04-05 04:20:35 Repatriated Travellers, Canada
1700645 2021-04-03 Canada Repatriated Travellers     13 0 13 0     2021-04-04 04:20:49 Repatriated Travellers, Canada
953334 2021-04-02 Canada Repatriated Travellers     13 0 13 0     2021-04-03 04:20:44 Repatriated Travellers, Canada
124958 2021-04-01 Canada Repatriated Travellers     13 0 13 0     2021-04-02 04:20:36 Repatriated Travellers, Canada
1515850 2021-03-31 Canada Repatriated Travellers     13 0 13 0     2021-04-01 04:27:05 Repatriated Travellers, Canada
1716639 2021-03-30 Canada Repatriated Travellers     13 0 13 0     2021-03-31 04:26:25 Repatriated Travellers, Canada
732626 2021-03-29 Canada Repatriated Travellers     13 0 13 0     2021-03-30 04:26:23 Repatriated Travellers, Canada
421930 2021-03-28 Canada Repatriated Travellers     13 0 13 0     2021-03-29 04:28:35 Repatriated Travellers, Canada
1732321 2021-03-27 Canada Repatriated Travellers     13 0 13 0     2021-03-28 05:28:10 Repatriated Travellers, Canada
402764 2021-03-26 Canada Repatriated Travellers     13 0 13 0     2021-03-27 05:25:04 Repatriated Travellers, Canada
1353647 2021-03-25 Canada Repatriated Travellers     13 0 13 0     2021-03-26 05:26:55 Repatriated Travellers, Canada
507337 2021-03-24 Canada Repatriated Travellers     13 0 13 0     2021-03-25 05:27:00 Repatriated Travellers, Canada
1590254 2021-03-23 Canada Repatriated Travellers     13 0 13 0     2021-03-24 05:25:40 Repatriated Travellers, Canada
839646 2021-03-22 Canada Repatriated Travellers     13 0 13 0     2021-03-23 05:26:18 Repatriated Travellers, Canada
720886 2021-03-21 Canada Repatriated Travellers     13 0 13 0     2021-03-22 05:25:43 Repatriated Travellers, Canada
442029 2021-03-20 Canada Repatriated Travellers     13 0 13 0     2021-03-21 05:25:44 Repatriated Travellers, Canada
544971 2021-03-19 Canada Repatriated Travellers     13 0 13 0     2021-03-20 05:25:46 Repatriated Travellers, Canada
1349660 2021-03-18 Canada Repatriated Travellers     13 0 13 0     2021-03-19 05:26:09 Repatriated Travellers, Canada
84554 2021-03-17 Canada Repatriated Travellers     13 0 13 0     2021-03-18 05:26:22 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]);