johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
766 rows where country_or_region = "Canada" and province_or_state = "Repatriated Travellers" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3069789 | 3069789 | 2021-11-23 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-11-24 04:22:14 | Repatriated Travellers, Canada | |||||
3748887 | 3748887 | 2021-11-22 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-11-23 04:22:39 | Repatriated Travellers, Canada | |||||
1014094 | 1014094 | 2021-11-21 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-11-22 04:22:20 | Repatriated Travellers, Canada | |||||
722258 | 722258 | 2021-11-20 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-11-21 04:22:13 | Repatriated Travellers, Canada | |||||
161788 | 161788 | 2021-11-19 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-11-20 04:22:17 | Repatriated Travellers, Canada | |||||
3288675 | 3288675 | 2021-11-18 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-11-19 04:21:40 | Repatriated Travellers, Canada | |||||
447131 | 447131 | 2021-11-17 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-11-18 04:21:33 | Repatriated Travellers, Canada | |||||
3342381 | 3342381 | 2021-11-16 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-11-17 04:21:48 | Repatriated Travellers, Canada | |||||
2287217 | 2287217 | 2021-11-15 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-11-16 04:21:10 | Repatriated Travellers, Canada | |||||
1321991 | 1321991 | 2021-11-14 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-11-15 04:21:36 | Repatriated Travellers, Canada | |||||
686117 | 686117 | 2021-11-13 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-11-14 04:21:31 | Repatriated Travellers, Canada | |||||
714226 | 714226 | 2021-11-12 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-11-13 04:21:38 | Repatriated Travellers, Canada | |||||
28176 | 28176 | 2021-11-11 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-11-12 04:22:01 | Repatriated Travellers, Canada | |||||
2844615 | 2844615 | 2021-11-10 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-11-11 04:21:45 | Repatriated Travellers, Canada | |||||
86885 | 86885 | 2021-11-09 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-11-10 04:21:38 | Repatriated Travellers, Canada | |||||
3639313 | 3639313 | 2021-11-08 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-11-09 04:21:36 | Repatriated Travellers, Canada | |||||
2000421 | 2000421 | 2021-11-07 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-11-08 04:21:43 | Repatriated Travellers, Canada | |||||
495412 | 495412 | 2021-11-06 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-11-07 04:21:53 | Repatriated Travellers, Canada | |||||
3121267 | 3121267 | 2021-11-05 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-11-06 04:21:51 | Repatriated Travellers, Canada | |||||
698165 | 698165 | 2021-11-04 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-11-05 04:21:54 | Repatriated Travellers, Canada | |||||
275943 | 275943 | 2021-11-03 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-11-04 04:22:20 | Repatriated Travellers, Canada | |||||
43468 | 43468 | 2021-11-02 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-11-03 06:22:09 | Repatriated Travellers, Canada | |||||
3511164 | 3511164 | 2021-11-01 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-11-02 04:22:03 | Repatriated Travellers, Canada | |||||
287756 | 287756 | 2021-10-31 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-11-01 04:22:01 | Repatriated Travellers, Canada | |||||
2720762 | 2720762 | 2021-10-30 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-10-31 04:22:08 | Repatriated Travellers, Canada | |||||
566864 | 566864 | 2021-10-29 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-10-30 04:22:03 | Repatriated Travellers, Canada | |||||
4106 | 4106 | 2021-10-28 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-10-29 04:22:03 | Repatriated Travellers, Canada | |||||
534496 | 534496 | 2021-10-27 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-10-28 04:22:08 | Repatriated Travellers, Canada | |||||
3491933 | 3491933 | 2021-10-26 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-10-27 04:22:32 | Repatriated Travellers, Canada | |||||
3793655 | 3793655 | 2021-10-25 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-10-26 04:22:09 | Repatriated Travellers, Canada | |||||
682101 | 682101 | 2021-10-24 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-10-25 04:22:31 | Repatriated Travellers, Canada | |||||
770109 | 770109 | 2021-10-23 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-10-24 04:21:22 | Repatriated Travellers, Canada | |||||
653756 | 653756 | 2021-10-22 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-10-23 04:21:32 | Repatriated Travellers, Canada | |||||
2123503 | 2123503 | 2021-10-21 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-10-22 04:21:14 | Repatriated Travellers, Canada | |||||
443115 | 443115 | 2021-10-20 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-10-21 04:21:18 | Repatriated Travellers, Canada | |||||
597434 | 597434 | 2021-10-19 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-10-20 04:21:00 | Repatriated Travellers, Canada | |||||
2043611 | 2043611 | 2021-10-18 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-10-19 04:20:54 | Repatriated Travellers, Canada | |||||
1908972 | 1908972 | 2021-10-17 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-10-18 04:21:10 | Repatriated Travellers, Canada | |||||
934561 | 934561 | 2021-10-16 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-10-17 04:21:29 | Repatriated Travellers, Canada | |||||
2943116 | 2943116 | 2021-10-15 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-10-16 04:21:15 | Repatriated Travellers, Canada | |||||
491396 | 491396 | 2021-10-14 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-10-15 04:21:26 | Repatriated Travellers, Canada | |||||
633684 | 633684 | 2021-10-13 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-10-14 04:21:29 | Repatriated Travellers, Canada | |||||
1491362 | 1491362 | 2021-10-12 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-10-13 04:20:51 | Repatriated Travellers, Canada | |||||
3007095 | 3007095 | 2021-10-11 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-10-12 04:21:09 | Repatriated Travellers, Canada | |||||
423111 | 423111 | 2021-10-10 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-10-11 04:21:31 | Repatriated Travellers, Canada | |||||
2875968 | 2875968 | 2021-10-09 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-10-10 04:21:38 | Repatriated Travellers, Canada | |||||
2959134 | 2959134 | 2021-10-08 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-10-09 04:21:34 | Repatriated Travellers, Canada | |||||
467172 | 467172 | 2021-10-07 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-10-08 04:21:25 | Repatriated Travellers, Canada | |||||
2458552 | 2458552 | 2021-10-06 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-10-07 04:21:36 | Repatriated Travellers, Canada | |||||
3832246 | 3832246 | 2021-10-05 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-10-06 04:21:33 | Repatriated Travellers, Canada | |||||
986739 | 986739 | 2021-10-04 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-10-05 04:21:27 | Repatriated Travellers, Canada | |||||
1274049 | 1274049 | 2021-10-03 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-10-04 04:21:31 | Repatriated Travellers, Canada | |||||
3927802 | 3927802 | 2021-10-02 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-10-03 04:21:24 | Repatriated Travellers, Canada | |||||
2131782 | 2131782 | 2021-10-01 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-10-02 04:21:25 | Repatriated Travellers, Canada | |||||
2772739 | 2772739 | 2021-09-30 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-10-01 04:21:35 | Repatriated Travellers, Canada | |||||
706195 | 706195 | 2021-09-29 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-09-30 04:21:20 | Repatriated Travellers, Canada | |||||
1334037 | 1334037 | 2021-09-28 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-09-29 04:21:45 | Repatriated Travellers, Canada | |||||
1235406 | 1235406 | 2021-09-27 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-09-28 04:21:28 | Repatriated Travellers, Canada | |||||
2075707 | 2075707 | 2021-09-26 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-09-27 04:21:16 | Repatriated Travellers, Canada | |||||
1724259 | 1724259 | 2021-09-25 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-09-26 04:21:29 | Repatriated Travellers, Canada | |||||
1920979 | 1920979 | 2021-09-24 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-09-25 04:21:31 | Repatriated Travellers, Canada | |||||
601450 | 601450 | 2021-09-23 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-09-24 04:21:44 | Repatriated Travellers, Canada | |||||
3011111 | 3011111 | 2021-09-22 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-09-23 04:21:43 | Repatriated Travellers, Canada | |||||
3757249 | 3757249 | 2021-09-21 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-09-22 04:21:45 | Repatriated Travellers, Canada | |||||
809352 | 809352 | 2021-09-20 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-09-21 04:21:26 | Repatriated Travellers, Canada | |||||
1814551 | 1814551 | 2021-09-19 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-09-20 04:21:22 | Repatriated Travellers, Canada | |||||
16131 | 16131 | 2021-09-18 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-09-19 04:21:34 | Repatriated Travellers, Canada | |||||
2617816 | 2617816 | 2021-09-17 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-09-18 04:21:24 | Repatriated Travellers, Canada | |||||
2808524 | 2808524 | 2021-09-16 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-09-17 04:21:46 | Repatriated Travellers, Canada | |||||
1374269 | 1374269 | 2021-09-15 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-09-16 04:22:19 | Repatriated Travellers, Canada | |||||
2462568 | 2462568 | 2021-09-14 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-09-15 03:22:37 | Repatriated Travellers, Canada | |||||
1385407 | 1385407 | 2021-09-13 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-09-14 04:21:41 | Repatriated Travellers, Canada | |||||
1884776 | 1884776 | 2021-09-12 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-09-13 04:21:15 | Repatriated Travellers, Canada | |||||
3805679 | 3805679 | 2021-09-11 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-09-12 04:21:13 | Repatriated Travellers, Canada | |||||
3448619 | 3448619 | 2021-09-10 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-09-11 04:21:30 | Repatriated Travellers, Canada | |||||
1262565 | 1262565 | 2021-09-09 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-09-10 04:21:20 | Repatriated Travellers, Canada | |||||
2278935 | 2278935 | 2021-09-08 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-09-09 04:21:27 | Repatriated Travellers, Canada | |||||
641714 | 641714 | 2021-09-07 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-09-08 04:21:31 | Repatriated Travellers, Canada | |||||
3193777 | 3193777 | 2021-09-06 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-09-07 04:21:35 | Repatriated Travellers, Canada | |||||
3280645 | 3280645 | 2021-09-05 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-09-06 04:21:22 | Repatriated Travellers, Canada | |||||
249059 | 249059 | 2021-09-04 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-09-05 04:21:33 | Repatriated Travellers, Canada | |||||
3974340 | 3974340 | 2021-09-03 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-09-04 04:21:28 | Repatriated Travellers, Canada | |||||
177802 | 177802 | 2021-09-02 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-09-03 04:21:20 | Repatriated Travellers, Canada | |||||
66837 | 66837 | 2021-09-01 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-09-02 04:21:15 | Repatriated Travellers, Canada | |||||
2067679 | 2067679 | 2021-08-31 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-09-01 04:21:38 | Repatriated Travellers, Canada | |||||
1775133 | 1775133 | 2021-08-30 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-08-31 04:21:46 | Repatriated Travellers, Canada | |||||
3891707 | 3891707 | 2021-08-29 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-08-30 04:21:23 | Repatriated Travellers, Canada | |||||
2792810 | 2792810 | 2021-08-28 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-08-29 04:21:14 | Repatriated Travellers, Canada | |||||
2922969 | 2922969 | 2021-08-27 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-08-28 04:21:28 | Repatriated Travellers, Canada | |||||
1595983 | 1595983 | 2021-08-26 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-08-27 04:21:37 | Repatriated Travellers, Canada | |||||
32192 | 32192 | 2021-08-25 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-08-26 04:21:28 | Repatriated Travellers, Canada | |||||
3105231 | 3105231 | 2021-08-24 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-08-25 04:21:41 | Repatriated Travellers, Canada | |||||
3165402 | 3165402 | 2021-08-23 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-08-24 04:21:19 | Repatriated Travellers, Canada | |||||
2175329 | 2175329 | 2021-08-22 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-08-23 04:21:27 | Repatriated Travellers, Canada | |||||
3555425 | 3555425 | 2021-08-21 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-08-22 04:21:29 | Repatriated Travellers, Canada | |||||
1853767 | 1853767 | 2021-08-20 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-08-21 04:21:38 | Repatriated Travellers, Canada | |||||
511474 | 511474 | 2021-08-19 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-08-20 04:21:33 | Repatriated Travellers, Canada | |||||
2517953 | 2517953 | 2021-08-18 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-08-19 04:21:15 | Repatriated Travellers, Canada | |||||
245045 | 245045 | 2021-08-17 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-08-18 04:21:35 | Repatriated Travellers, Canada | |||||
1604008 | 1604008 | 2021-08-16 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-08-17 04:21:49 | Repatriated Travellers, Canada |
Advanced export
JSON shape: default, array, newline-delimited
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] TEXT, [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]);