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 active
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
315677 | 315677 | 2022-02-12 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-02-13 04:21:00 | Repatriated Travellers, Canada | |||||
319693 | 319693 | 2022-10-30 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-10-31 04:21:36 | Repatriated Travellers, Canada | |||||
327667 | 327667 | 2022-12-27 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-12-28 04:21:04 | Repatriated Travellers, Canada | |||||
335697 | 335697 | 2022-03-18 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-03-19 04:20:47 | Repatriated Travellers, Canada | |||||
348057 | 348057 | 2022-12-14 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-12-15 04:20:58 | Repatriated Travellers, Canada | |||||
356087 | 356087 | 2022-03-11 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-03-12 04:20:50 | Repatriated Travellers, Canada | |||||
360103 | 360103 | 2022-05-07 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-05-08 04:20:49 | Repatriated Travellers, Canada | |||||
371957 | 371957 | 2022-09-13 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-09-14 04:20:44 | Repatriated Travellers, Canada | |||||
383984 | 383984 | 2022-09-23 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-09-24 04:21:40 | Repatriated Travellers, Canada | |||||
396025 | 396025 | 2022-10-07 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-10-08 04:22:56 | Repatriated Travellers, Canada | |||||
404054 | 404054 | 2021-12-07 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-12-08 04:22:46 | Repatriated Travellers, Canada | |||||
419096 | 419096 | 2022-09-18 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-09-19 04:21:49 | Repatriated Travellers, Canada | |||||
423111 | 423111 | 2021-10-10 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-10-11 04:21:31 | Repatriated Travellers, Canada | |||||
431118 | 431118 | 2022-11-03 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-11-04 04:22:11 | Repatriated Travellers, Canada | |||||
443115 | 443115 | 2021-10-20 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-10-21 04:21:18 | Repatriated Travellers, Canada | |||||
447131 | 447131 | 2021-11-17 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-11-18 04:21:33 | Repatriated Travellers, Canada | |||||
451148 | 451148 | 2022-12-21 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-12-22 04:20:56 | Repatriated Travellers, Canada | |||||
459140 | 459140 | 2022-02-02 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-02-03 04:21:21 | Repatriated Travellers, Canada | |||||
463157 | 463157 | 2022-05-02 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-05-03 04:21:00 | Repatriated Travellers, Canada | |||||
467172 | 467172 | 2021-10-07 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-10-08 04:21:25 | Repatriated Travellers, Canada | |||||
475203 | 475203 | 2022-06-26 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-06-27 04:21:00 | Repatriated Travellers, Canada | |||||
479351 | 479351 | 2022-11-08 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-11-09 04:21:22 | Repatriated Travellers, Canada | |||||
487381 | 487381 | 2022-11-25 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-11-26 04:21:11 | Repatriated Travellers, Canada | |||||
491396 | 491396 | 2021-10-14 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-10-15 04:21:26 | Repatriated Travellers, Canada | |||||
495412 | 495412 | 2021-11-06 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-11-07 04:21:53 | Repatriated Travellers, Canada | |||||
499429 | 499429 | 2022-04-02 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-04-03 04:20:48 | Repatriated Travellers, Canada | |||||
503445 | 503445 | 2022-12-17 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-12-18 04:21:03 | Repatriated Travellers, Canada | |||||
507460 | 507460 | 2021-08-14 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-08-15 04:21:41 | Repatriated Travellers, Canada | |||||
511474 | 511474 | 2021-08-19 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-08-20 04:21:33 | Repatriated Travellers, Canada | |||||
515489 | 515489 | 2022-10-15 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-10-16 04:22:39 | Repatriated Travellers, Canada | |||||
534496 | 534496 | 2021-10-27 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-10-28 04:22:08 | Repatriated Travellers, Canada | |||||
538513 | 538513 | 2022-10-26 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-10-27 04:22:01 | Repatriated Travellers, Canada | |||||
542529 | 542529 | 2022-12-15 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-12-16 04:21:01 | Repatriated Travellers, Canada | |||||
550534 | 550534 | 2021-12-08 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-12-09 04:22:49 | Repatriated Travellers, Canada | |||||
554550 | 554550 | 2022-01-16 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-01-17 04:21:08 | Repatriated Travellers, Canada | |||||
558567 | 558567 | 2022-06-16 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-06-17 04:20:56 | Repatriated Travellers, Canada | |||||
566864 | 566864 | 2021-10-29 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-10-30 04:22:03 | Repatriated Travellers, Canada | |||||
574593 | 574593 | 2022-02-25 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-02-26 04:21:12 | Repatriated Travellers, Canada | |||||
589404 | 589404 | 2021-08-08 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-08-09 04:21:24 | Repatriated Travellers, Canada | |||||
593419 | 593419 | 2022-07-01 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-07-02 04:21:16 | Repatriated Travellers, Canada | |||||
597434 | 597434 | 2021-10-19 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-10-20 04:21:00 | Repatriated Travellers, Canada | |||||
601450 | 601450 | 2021-09-23 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-09-24 04:21:44 | Repatriated Travellers, Canada | |||||
617623 | 617623 | 2022-11-05 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-11-06 04:21:24 | Repatriated Travellers, Canada | |||||
621639 | 621639 | 2022-05-22 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-05-26 04:20:50 | Repatriated Travellers, Canada | |||||
629669 | 629669 | 2022-07-12 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-07-13 04:20:58 | Repatriated Travellers, Canada | |||||
633684 | 633684 | 2021-10-13 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-10-14 04:21:29 | Repatriated Travellers, Canada | |||||
641714 | 641714 | 2021-09-07 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-09-08 04:21:31 | Repatriated Travellers, Canada | |||||
649742 | 649742 | 2021-08-09 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-08-10 04:21:27 | Repatriated Travellers, Canada | |||||
653756 | 653756 | 2021-10-22 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-10-23 04:21:32 | Repatriated Travellers, Canada | |||||
658075 | 658075 | 2022-05-13 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-05-14 04:20:48 | Repatriated Travellers, Canada | |||||
670060 | 670060 | 2022-07-21 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-07-22 04:21:15 | Repatriated Travellers, Canada | |||||
674076 | 674076 | 2022-07-30 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-07-31 04:21:02 | Repatriated Travellers, Canada | |||||
682101 | 682101 | 2021-10-24 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-10-25 04:22:31 | Repatriated Travellers, Canada | |||||
686117 | 686117 | 2021-11-13 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-11-14 04:21:31 | Repatriated Travellers, Canada | |||||
690134 | 690134 | 2022-12-23 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-12-24 04:21:02 | Repatriated Travellers, Canada | |||||
694150 | 694150 | 2022-03-17 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-03-18 04:20:55 | Repatriated Travellers, Canada | |||||
698165 | 698165 | 2021-11-04 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-11-05 04:21:54 | Repatriated Travellers, Canada | |||||
706195 | 706195 | 2021-09-29 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-09-30 04:21:20 | Repatriated Travellers, Canada | |||||
710211 | 710211 | 2022-11-01 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-11-02 04:22:09 | Repatriated Travellers, Canada | |||||
714226 | 714226 | 2021-11-12 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-11-13 04:21:38 | Repatriated Travellers, Canada | |||||
718243 | 718243 | 2022-12-04 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-12-02 18:21:06 | Repatriated Travellers, Canada | |||||
722258 | 722258 | 2021-11-20 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-11-21 04:22:13 | Repatriated Travellers, Canada | |||||
730288 | 730288 | 2021-12-27 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-12-28 04:21:47 | Repatriated Travellers, Canada | |||||
746105 | 746105 | 2022-04-23 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-04-24 04:20:56 | Repatriated Travellers, Canada | |||||
758088 | 758088 | 2021-11-26 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-11-27 04:22:45 | Repatriated Travellers, Canada | |||||
770109 | 770109 | 2021-10-23 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-10-24 04:21:22 | Repatriated Travellers, Canada | |||||
782151 | 782151 | 2021-12-13 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-12-14 04:22:38 | Repatriated Travellers, Canada | |||||
794175 | 794175 | 2022-10-24 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-10-25 04:21:53 | Repatriated Travellers, Canada | |||||
798190 | 798190 | 2021-12-22 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-12-23 04:21:21 | Repatriated Travellers, Canada | |||||
809352 | 809352 | 2021-09-20 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-09-21 04:21:26 | Repatriated Travellers, Canada | |||||
833388 | 833388 | 2022-12-02 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-12-02 18:21:06 | Repatriated Travellers, Canada | |||||
849360 | 849360 | 2022-11-02 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-11-03 04:22:05 | Repatriated Travellers, Canada | |||||
853376 | 853376 | 2022-09-30 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-10-01 04:23:01 | Repatriated Travellers, Canada | |||||
868560 | 868560 | 2022-12-11 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-12-12 04:21:01 | Repatriated Travellers, Canada | |||||
876025 | 876025 | 2022-03-27 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-03-28 04:20:33 | Repatriated Travellers, Canada | |||||
880041 | 880041 | 2022-08-05 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-08-06 04:20:56 | Repatriated Travellers, Canada | |||||
895908 | 895908 | 2022-07-24 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-07-25 04:20:51 | Repatriated Travellers, Canada | |||||
899924 | 899924 | 2022-07-22 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-07-23 04:20:53 | Repatriated Travellers, Canada | |||||
903939 | 903939 | 2021-11-24 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-11-25 04:22:33 | Repatriated Travellers, Canada | |||||
911969 | 911969 | 2022-10-29 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-10-30 04:22:14 | Repatriated Travellers, Canada | |||||
919445 | 919445 | 2022-03-08 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-03-09 04:20:59 | Repatriated Travellers, Canada | |||||
934561 | 934561 | 2021-10-16 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-10-17 04:21:29 | Repatriated Travellers, Canada | |||||
938578 | 938578 | 2022-06-25 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-06-26 04:21:02 | Repatriated Travellers, Canada | |||||
942594 | 942594 | 2022-02-28 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-03-01 04:21:09 | Repatriated Travellers, Canada | |||||
946610 | 946610 | 2022-06-14 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-06-15 04:20:54 | Repatriated Travellers, Canada | |||||
950626 | 950626 | 2022-03-12 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-03-13 04:20:49 | Repatriated Travellers, Canada | |||||
958656 | 958656 | 2022-07-19 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-07-20 04:20:59 | Repatriated Travellers, Canada | |||||
962672 | 962672 | 2022-09-09 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-09-10 04:21:10 | Repatriated Travellers, Canada | |||||
970680 | 970680 | 2022-06-01 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-06-02 05:20:39 | Repatriated Travellers, Canada | |||||
978709 | 978709 | 2022-02-01 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-02-02 04:21:09 | Repatriated Travellers, Canada | |||||
986739 | 986739 | 2021-10-04 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-10-05 04:21:27 | Repatriated Travellers, Canada | |||||
990755 | 990755 | 2022-08-16 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-08-17 04:20:59 | Repatriated Travellers, Canada | |||||
1014094 | 1014094 | 2021-11-21 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-11-22 04:22:20 | Repatriated Travellers, Canada | |||||
1018111 | 1018111 | 2022-12-24 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-12-25 04:21:04 | Repatriated Travellers, Canada | |||||
1022127 | 1022127 | 2022-11-04 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-11-05 04:21:52 | Repatriated Travellers, Canada | |||||
1030136 | 1030136 | 2021-12-06 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-12-07 04:22:34 | Repatriated Travellers, Canada | |||||
1049599 | 1049599 | 2022-11-06 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-11-07 04:21:26 | Repatriated Travellers, Canada | |||||
1057610 | 1057610 | 2022-02-23 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-02-24 04:21:14 | Repatriated Travellers, Canada | |||||
1065638 | 1065638 | 2022-07-28 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-07-29 04:20:45 | Repatriated Travellers, Canada | |||||
1069654 | 1069654 | 2022-08-07 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-08-08 04:21:08 | 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]);