johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
766 rows where combined_key = "Repatriated Travellers, Canada" and country_or_region = "Canada" sorted by latitude
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state 1
country_or_region 1
- Canada · 666 ✖
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude ▼ | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
530482 | 530482 | 2021-02-22 | Canada | Repatriated Travellers | 13 | 0 | 13 | 0 | 2021-02-23 05:23:41 | 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 | |||||
562743 | 562743 | 2021-06-22 | Canada | Repatriated Travellers | 13 | 0 | 13 | 0 | 2021-06-23 04:21:46 | 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 | |||||
578608 | 578608 | 2021-07-13 | Canada | Repatriated Travellers | 13 | 0 | 13 | 0 | 2021-07-14 04:21:35 | 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 | |||||
605465 | 605465 | 2021-04-09 | Canada | Repatriated Travellers | 13 | 0 | 13 | 0 | 2021-04-10 04:20:59 | Repatriated Travellers, Canada | ||||
613465 | 613465 | 2021-02-08 | Canada | Repatriated Travellers | 13 | 0 | 13 | 0 | 2021-02-09 05:23:30 | 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 | |||||
625654 | 625654 | 2021-07-10 | Canada | Repatriated Travellers | 13 | 0 | 13 | 0 | 2021-07-11 04:21:43 | 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 | |||||
637700 | 637700 | 2021-03-31 | Canada | Repatriated Travellers | 13 | 0 | 13 | 0 | 2021-04-01 04:27:05 | Repatriated Travellers, Canada | ||||
641714 | 641714 | 2021-09-07 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-09-08 04:21:31 | Repatriated Travellers, Canada | |||||
645728 | 645728 | 2021-05-05 | Canada | Repatriated Travellers | 13 | 0 | 13 | 0 | 2021-05-06 04:20:38 | 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 | |||||
702181 | 702181 | 2021-03-16 | Canada | Repatriated Travellers | 13 | 0 | 13 | 0 | 2021-03-17 05:25:07 | 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 | |||||
726274 | 726274 | 2021-05-22 | Canada | Repatriated Travellers | 13 | 0 | 13 | 0 | 2021-05-23 04:20:51 | Repatriated Travellers, Canada | ||||
730288 | 730288 | 2021-12-27 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-12-28 04:21:47 | Repatriated Travellers, Canada | |||||
738079 | 738079 | 2020-12-02 | Canada | Repatriated Travellers | 13 | 0 | 13 | 0 | 2020-12-03 05:28:22 | Repatriated Travellers, Canada | ||||
742090 | 742090 | 2021-02-20 | Canada | Repatriated Travellers | 13 | 0 | 13 | 0 | 2021-02-21 05:24:33 | 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 | |||||
766098 | 766098 | 2020-12-29 | Canada | Repatriated Travellers | 13 | 0 | 13 | 0 | 2020-12-30 05:22:34 | Repatriated Travellers, Canada | ||||
770109 | 770109 | 2021-10-23 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-10-24 04:21:22 | Repatriated Travellers, Canada | |||||
774125 | 774125 | 2021-01-12 | Canada | Repatriated Travellers | 13 | 0 | 13 | 0 | 2021-01-13 05:22:15 | Repatriated Travellers, Canada | ||||
778137 | 778137 | 2021-07-08 | Canada | Repatriated Travellers | 13 | 0 | 13 | 0 | 2021-07-09 04:21:21 | Repatriated Travellers, Canada | ||||
782151 | 782151 | 2021-12-13 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-12-14 04:22:38 | Repatriated Travellers, Canada | |||||
790160 | 790160 | 2021-02-04 | Canada | Repatriated Travellers | 13 | 0 | 13 | 0 | 2021-02-05 05: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 | |||||
825359 | 825359 | 2021-06-06 | Canada | Repatriated Travellers | 13 | 0 | 13 | 0 | 2021-06-07 04:22:51 | Repatriated Travellers, Canada | ||||
829373 | 829373 | 2021-07-09 | Canada | Repatriated Travellers | 13 | 0 | 13 | 0 | 2021-07-10 04:21:25 | Repatriated Travellers, Canada | ||||
833388 | 833388 | 2022-12-02 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-12-02 18:21:06 | Repatriated Travellers, Canada | |||||
845348 | 845348 | 2020-12-12 | Canada | Repatriated Travellers | 13 | 0 | 13 | 0 | 2020-12-13 05:27:20 | 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 | |||||
860455 | 860455 | 2020-12-11 | Canada | Repatriated Travellers | 13 | 0 | 13 | 0 | 2020-12-12 05:26:19 | 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 | |||||
887896 | 887896 | 2021-04-26 | Canada | Repatriated Travellers | 13 | 0 | 13 | 0 | 2021-04-27 04:20:52 | 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 | |||||
907955 | 907955 | 2021-01-19 | Canada | Repatriated Travellers | 13 | 0 | 13 | 0 | 2021-01-20 05:21:54 | 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 | |||||
923460 | 923460 | 2020-11-26 | Canada | Repatriated Travellers | 13 | 0 | 13 | 0 | 2020-11-27 05:26:53 | Repatriated Travellers, Canada | ||||
927471 | 927471 | 2020-12-21 | Canada | Repatriated Travellers | 13 | 0 | 13 | 0 | 2020-12-22 05:22:33 | 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 | |||||
954641 | 954641 | 2021-04-25 | Canada | Repatriated Travellers | 13 | 0 | 13 | 0 | 2021-04-26 04:21:04 | 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 | |||||
974695 | 974695 | 2021-02-06 | Canada | Repatriated Travellers | 13 | 0 | 13 | 0 | 2021-02-07 05:23:00 | Repatriated Travellers, Canada | ||||
978709 | 978709 | 2022-02-01 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-02-02 04:21:09 | Repatriated Travellers, Canada | |||||
982725 | 982725 | 2021-04-17 | Canada | Repatriated Travellers | 13 | 0 | 13 | 0 | 2021-04-18 04:20:41 | 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 | |||||
998215 | 998215 | 2021-03-01 | Canada | Repatriated Travellers | 13 | 0 | 13 | 0 | 2021-03-02 05:23:30 | Repatriated Travellers, Canada | ||||
1006072 | 1006072 | 2020-12-06 | Canada | Repatriated Travellers | 13 | 0 | 13 | 0 | 2020-12-07 05:26:14 | Repatriated Travellers, Canada | ||||
1010083 | 1010083 | 2020-12-30 | Canada | Repatriated Travellers | 13 | 0 | 13 | 0 | 2020-12-31 05:22:49 | 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 | |||||
1034152 | 1034152 | 2020-12-15 | Canada | Repatriated Travellers | 13 | 0 | 13 | 0 | 2020-12-16 05:28:04 | 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 | |||||
1061625 | 1061625 | 2021-01-04 | Canada | Repatriated Travellers | 13 | 0 | 13 | 0 | 2021-01-05 05: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]);