johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
16,227 rows where country_or_region = "Canada" sorted by latitude
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state 22
- British Columbia 1,067
- Ontario 1,035
- Alberta 1,026
- Quebec 1,026
- New Brunswick 1,024
- Manitoba 1,022
- Saskatchewan 1,022
- Newfoundland and Labrador 1,020
- Prince Edward Island 1,020
- Nova Scotia 1,016
- Grand Princess 1,015
- Northwest Territories 1,011
- Nunavut 1,010
- Yukon 1,009
- Diamond Princess 1,001
- Repatriated Travellers 614
- Recovered 51
- London, ON 34
- Toronto, ON 34
- Montreal, QC 13
- Calgary, Alberta 3
- Edmonton, Alberta 2
country_or_region 1
- Canada · 16,075 ✖
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude ▼ | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||
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 | |||||
1073670 | 1073670 | 2022-12-28 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-12-29 04:21:01 | Repatriated Travellers, Canada | |||||
1077685 | 1077685 | 2021-12-09 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-12-10 04:22:28 | Repatriated Travellers, Canada | |||||
1081701 | 1081701 | 2021-05-14 | Canada | Repatriated Travellers | 13 | 0 | 13 | 0 | 2021-05-15 04:20:58 | Repatriated Travellers, Canada | ||||
1085836 | 1085836 | 2022-08-09 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-08-10 04:20:57 | Repatriated Travellers, Canada | |||||
1089851 | 1089851 | 2021-03-03 | Canada | Repatriated Travellers | 13 | 0 | 13 | 0 | 2021-03-04 05:24:24 | Repatriated Travellers, Canada | ||||
1093865 | 1093865 | 2021-01-20 | Canada | Repatriated Travellers | 13 | 0 | 13 | 0 | 2021-01-21 05:22:01 | Repatriated Travellers, Canada | ||||
1097879 | 1097879 | 2022-08-03 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-08-04 04:20:58 | Repatriated Travellers, Canada | |||||
1109335 | 1109335 | 2022-05-21 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-05-22 04:20:52 | Repatriated Travellers, Canada | |||||
1113350 | 1113350 | 2022-01-11 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-01-12 04:21:44 | Repatriated Travellers, Canada | |||||
1117366 | 1117366 | 2021-08-06 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-08-07 04:21:30 | Repatriated Travellers, Canada | |||||
1125370 | 1125370 | 2021-06-18 | Canada | Repatriated Travellers | 13 | 0 | 13 | 0 | 2021-06-19 04:22:33 | Repatriated Travellers, Canada | ||||
1136662 | 1136662 | 2021-01-01 | Canada | Repatriated Travellers | 13 | 0 | 13 | 0 | 2021-01-02 05:22:33 | Repatriated Travellers, Canada | ||||
1140673 | 1140673 | 2022-01-23 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-01-24 04:21:12 | Repatriated Travellers, Canada | |||||
1144689 | 1144689 | 2021-12-01 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-12-02 04:22:37 | Repatriated Travellers, Canada | |||||
1148706 | 1148706 | 2022-12-12 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-12-13 04:21:01 | Repatriated Travellers, Canada | |||||
1152898 | 1152898 | 2021-02-18 | Canada | Repatriated Travellers | 13 | 0 | 13 | 0 | 2021-02-19 05:24:16 | Repatriated Travellers, Canada | ||||
1156913 | 1156913 | 2022-04-29 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-04-30 04:21:05 | Repatriated Travellers, Canada | |||||
1160929 | 1160929 | 2022-08-18 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-08-19 04:20:54 | Repatriated Travellers, Canada | |||||
1164944 | 1164944 | 2021-07-04 | Canada | Repatriated Travellers | 13 | 0 | 13 | 0 | 2021-07-05 04:21:28 | Repatriated Travellers, Canada | ||||
1168959 | 1168959 | 2022-05-20 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-05-21 04:20:58 | Repatriated Travellers, Canada | |||||
1184506 | 1184506 | 2022-05-18 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-05-19 04:20:54 | Repatriated Travellers, Canada | |||||
1188521 | 1188521 | 2021-05-31 | Canada | Repatriated Travellers | 13 | 0 | 13 | 0 | 2021-06-01 04:23:09 | Repatriated Travellers, Canada | ||||
1199568 | 1199568 | 2022-07-06 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-07-07 04:20:55 | Repatriated Travellers, Canada | |||||
1203583 | 1203583 | 2021-03-22 | Canada | Repatriated Travellers | 13 | 0 | 13 | 0 | 2021-03-23 05:26:18 | Repatriated Travellers, Canada | ||||
1211313 | 1211313 | 2022-07-11 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-07-12 04:20:51 | Repatriated Travellers, Canada | |||||
1215328 | 1215328 | 2022-01-08 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-01-09 04:21:46 | Repatriated Travellers, Canada | |||||
1219344 | 1219344 | 2021-03-27 | Canada | Repatriated Travellers | 13 | 0 | 13 | 0 | 2021-03-28 05:28:10 | Repatriated Travellers, Canada | ||||
1223359 | 1223359 | 2022-04-14 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-04-15 04:20:57 | Repatriated Travellers, Canada | |||||
1227374 | 1227374 | 2022-01-24 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-01-25 04:21:05 | Repatriated Travellers, Canada | |||||
1231390 | 1231390 | 2021-11-28 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-11-29 04:22:30 | Repatriated Travellers, Canada | |||||
1235406 | 1235406 | 2021-09-27 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-09-28 04:21:28 | Repatriated Travellers, Canada | |||||
1239422 | 1239422 | 2022-11-28 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-11-29 04:21:05 | Repatriated Travellers, Canada | |||||
1250518 | 1250518 | 2022-08-23 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-08-24 04:20:46 | Repatriated Travellers, Canada | |||||
1254533 | 1254533 | 2021-12-20 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-12-21 03:21:27 | Repatriated Travellers, Canada | |||||
1258549 | 1258549 | 2021-12-18 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-12-19 04:21:11 | Repatriated Travellers, Canada | |||||
1262565 | 1262565 | 2021-09-09 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-09-10 04:21:20 | Repatriated Travellers, Canada | |||||
1274049 | 1274049 | 2021-10-03 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-10-04 04:21:31 | Repatriated Travellers, Canada | |||||
1281750 | 1281750 | 2022-01-05 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-01-06 04:22:09 | Repatriated Travellers, Canada | |||||
1285766 | 1285766 | 2022-01-04 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-01-05 04:21:59 | Repatriated Travellers, Canada | |||||
1289782 | 1289782 | 2021-03-29 | Canada | Repatriated Travellers | 13 | 0 | 13 | 0 | 2021-03-30 04:26:23 | Repatriated Travellers, Canada | ||||
1293796 | 1293796 | 2022-02-05 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-02-06 04:21:00 | Repatriated Travellers, Canada | |||||
1297813 | 1297813 | 2022-02-17 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-02-18 04:21:04 | Repatriated Travellers, Canada | |||||
1301828 | 1301828 | 2021-04-01 | Canada | Repatriated Travellers | 13 | 0 | 13 | 0 | 2021-04-02 04:20:36 | Repatriated Travellers, Canada | ||||
1305931 | 1305931 | 2021-07-27 | Canada | Repatriated Travellers | 13 | 0 | 13 | 0 | 2021-07-28 04:21:39 | Repatriated Travellers, Canada | ||||
1309945 | 1309945 | 2021-05-26 | Canada | Repatriated Travellers | 13 | 0 | 13 | 0 | 2021-05-27 04:20:59 | Repatriated Travellers, Canada | ||||
1313960 | 1313960 | 2022-05-27 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-05-28 04:21:07 | Repatriated Travellers, Canada | |||||
1317975 | 1317975 | 2022-01-26 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-01-27 04:21:19 | Repatriated Travellers, Canada | |||||
1321991 | 1321991 | 2021-11-14 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-11-15 04:21:36 | Repatriated Travellers, Canada | |||||
1326008 | 1326008 | 2022-04-26 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-04-27 04:20:52 | Repatriated Travellers, Canada | |||||
1330023 | 1330023 | 2021-07-24 | Canada | Repatriated Travellers | 13 | 0 | 13 | 0 | 2021-07-25 04:22:12 | 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]);