johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
114 rows where active = 4 and country_or_region = "Canada" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, combined_key
province_or_state 8
country_or_region 1
- Canada · 114 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1563866 | 1563866 | 2021-06-14 | Canada | Prince Edward Island | 206 | 0 | 202 | 4 | 46.5107 | -63.4168 | 2021-06-15 04:22:22 | Prince Edward Island, Canada | ||
3381149 | 3381149 | 2021-06-13 | Canada | Prince Edward Island | 206 | 0 | 202 | 4 | 46.5107 | -63.4168 | 2021-06-14 04:22:46 | Prince Edward Island, Canada | ||
1736283 | 1736283 | 2021-06-12 | Canada | Prince Edward Island | 206 | 0 | 202 | 4 | 46.5107 | -63.4168 | 2021-06-13 04:22:44 | Prince Edward Island, Canada | ||
3970324 | 3970324 | 2021-06-11 | Canada | Prince Edward Island | 206 | 0 | 202 | 4 | 46.5107 | -63.4168 | 2021-06-12 04:22:22 | Prince Edward Island, Canada | ||
3472075 | 3472075 | 2021-06-08 | Canada | Yukon | 88 | 2 | 82 | 4 | 64.2823 | -135.0 | 2021-06-09 04:23:31 | Yukon, Canada | ||
3145355 | 3145355 | 2021-06-07 | Canada | Prince Edward Island | 204 | 0 | 200 | 4 | 46.5107 | -63.4168 | 2021-06-08 04:22:35 | Prince Edward Island, Canada | ||
825357 | 825357 | 2021-06-06 | Canada | Prince Edward Island | 204 | 0 | 200 | 4 | 46.5107 | -63.4168 | 2021-06-07 04:22:51 | Prince Edward Island, Canada | ||
2585762 | 2585762 | 2021-06-05 | Canada | Prince Edward Island | 204 | 0 | 200 | 4 | 46.5107 | -63.4168 | 2021-06-06 04:24:03 | Prince Edward Island, Canada | ||
2315076 | 2315076 | 2021-06-04 | Canada | Prince Edward Island | 204 | 0 | 200 | 4 | 46.5107 | -63.4168 | 2021-06-05 04:23:03 | Prince Edward Island, Canada | ||
1448361 | 1448361 | 2021-06-03 | Canada | Prince Edward Island | 204 | 0 | 200 | 4 | 46.5107 | -63.4168 | 2021-06-04 04:23:37 | Prince Edward Island, Canada | ||
1708085 | 1708085 | 2021-06-02 | Canada | Prince Edward Island | 204 | 0 | 200 | 4 | 46.5107 | -63.4168 | 2021-06-03 04:23:32 | Prince Edward Island, Canada | ||
2103903 | 2103903 | 2021-06-01 | Canada | Prince Edward Island | 204 | 0 | 200 | 4 | 46.5107 | -63.4168 | 2021-06-02 04:24:34 | Prince Edward Island, Canada | ||
1567884 | 1567884 | 2021-04-22 | Canada | Yukon | 80 | 1 | 75 | 4 | 64.2823 | -135.0 | 2021-04-23 04:20:52 | Yukon, Canada | ||
1203581 | 1203581 | 2021-03-22 | Canada | Prince Edward Island | 144 | 0 | 140 | 4 | 46.5107 | -63.4168 | 2021-03-23 05:26:18 | Prince Edward Island, Canada | ||
3369103 | 3369103 | 2021-03-21 | Canada | Prince Edward Island | 144 | 0 | 140 | 4 | 46.5107 | -63.4168 | 2021-03-22 05:25:43 | Prince Edward Island, Canada | ||
1744313 | 1744313 | 2021-03-20 | Canada | Prince Edward Island | 144 | 0 | 140 | 4 | 46.5107 | -63.4168 | 2021-03-21 05:25:44 | Prince Edward Island, Canada | ||
3420693 | 3420693 | 2021-03-19 | Canada | Prince Edward Island | 144 | 0 | 140 | 4 | 46.5107 | -63.4168 | 2021-03-20 05:25:46 | Prince Edward Island, Canada | ||
3452631 | 3452631 | 2021-03-18 | Canada | Prince Edward Island | 144 | 0 | 140 | 4 | 46.5107 | -63.4168 | 2021-03-19 05:26:09 | Prince Edward Island, Canada | ||
3620855 | 3620855 | 2021-03-17 | Canada | Prince Edward Island | 144 | 0 | 140 | 4 | 46.5107 | -63.4168 | 2021-03-18 05:26:22 | Prince Edward Island, Canada | ||
1857775 | 1857775 | 2021-02-25 | Canada | Northwest Territories | 42 | 0 | 43 | 4 | 64.8255 | -124.8457 | 2021-02-26 05:22:40 | Northwest Territories,Canada | ||
279953 | 279953 | 2021-02-24 | Canada | Northwest Territories | 42 | 0 | 43 | 4 | 64.8255 | -124.8457 | 2021-02-25 05:24:57 | Northwest Territories,Canada | ||
1338050 | 1338050 | 2021-02-15 | Canada | Prince Edward Island | 114 | 0 | 110 | 4 | 46.5107 | -63.4168 | 2021-02-16 05:24:38 | Prince Edward Island, Canada | ||
2283201 | 2283201 | 2021-02-14 | Canada | Prince Edward Island | 114 | 0 | 110 | 4 | 46.5107 | -63.4168 | 2021-02-15 05:24:49 | Prince Edward Island, Canada | ||
2677601 | 2677601 | 2021-02-13 | Canada | Prince Edward Island | 114 | 0 | 110 | 4 | 46.5107 | -63.4168 | 2021-02-14 05:23:43 | Prince Edward Island, Canada | ||
3539234 | 3539234 | 2021-02-12 | Canada | Prince Edward Island | 114 | 0 | 110 | 4 | 46.5107 | -63.4168 | 2021-02-13 05:22:12 | Prince Edward Island, Canada | ||
2637497 | 2637497 | 2021-02-11 | Canada | Prince Edward Island | 114 | 0 | 110 | 4 | 46.5107 | -63.4168 | 2021-02-12 05:23:29 | Prince Edward Island, Canada | ||
3978352 | 3978352 | 2021-02-10 | Canada | Prince Edward Island | 114 | 0 | 110 | 4 | 46.5107 | -63.4168 | 2021-02-11 05:23:55 | Prince Edward Island, Canada | ||
1527672 | 1527672 | 2021-02-09 | Canada | Prince Edward Island | 114 | 0 | 110 | 4 | 46.5107 | -63.4168 | 2021-02-10 05:22:41 | Prince Edward Island, Canada | ||
907949 | 907949 | 2021-01-19 | Canada | Northwest Territories | 30 | 0 | 24 | 4 | 64.8255 | -124.8457 | 2021-01-20 05:21:54 | Northwest Territories,Canada | ||
2864491 | 2864491 | 2021-01-06 | Canada | Prince Edward Island | 97 | 0 | 93 | 4 | 46.5107 | -63.4168 | 2021-01-07 05:22:03 | Prince Edward Island, Canada | ||
3034078 | 3034078 | 2021-01-05 | Canada | Prince Edward Island | 97 | 0 | 93 | 4 | 46.5107 | -63.4168 | 2021-01-06 05:22:16 | Prince Edward Island, Canada | ||
1751048 | 1751048 | 2020-12-14 | Canada | Yukon | 59 | 1 | 54 | 4 | 64.2823 | -135.0 | 2020-12-15 05:26:38 | Yukon, Canada | ||
74865 | 74865 | 2020-12-03 | Canada | Prince Edward Island | 72 | 0 | 68 | 4 | 46.5107 | -63.4168 | 2020-12-04 05:27:27 | Prince Edward Island, Canada | ||
738077 | 738077 | 2020-12-02 | Canada | Prince Edward Island | 72 | 0 | 68 | 4 | 46.5107 | -63.4168 | 2020-12-03 05:28:22 | Prince Edward Island, Canada | ||
2537171 | 2537171 | 2020-12-01 | Canada | Prince Edward Island | 72 | 0 | 68 | 4 | 46.5107 | -63.4168 | 2020-12-02 05:27:41 | Prince Edward Island, Canada | ||
1583940 | 1583940 | 2020-11-30 | Canada | Prince Edward Island | 72 | 0 | 68 | 4 | 46.5107 | -63.4168 | 2020-12-01 05:26:18 | Prince Edward Island, Canada | ||
3566343 | 3566343 | 2020-11-29 | Canada | Prince Edward Island | 72 | 0 | 68 | 4 | 46.5107 | -63.4168 | 2020-11-30 05:26:13 | Prince Edward Island, Canada | ||
2935008 | 2935008 | 2020-11-28 | Canada | Prince Edward Island | 72 | 0 | 68 | 4 | 46.5107 | -63.4168 | 2020-11-29 05:25:55 | Prince Edward Island, Canada | ||
821350 | 821350 | 2020-11-19 | Canada | Yukon | 27 | 1 | 22 | 4 | 64.2823 | -135.0 | 2020-11-20 05:26:28 | Yukon, Canada | ||
3169414 | 3169414 | 2020-11-16 | Canada | Prince Edward Island | 68 | 0 | 64 | 4 | 46.5107 | -63.4168 | 2020-11-17 05:25:54 | Prince Edward Island, Canada | ||
2879982 | 2879982 | 2020-11-15 | Canada | Prince Edward Island | 68 | 0 | 64 | 4 | 46.5107 | -63.4168 | 2020-11-16 05:25:57 | Prince Edward Island, Canada | ||
2914960 | 2914960 | 2020-11-14 | Canada | Prince Edward Island | 68 | 0 | 64 | 4 | 46.5107 | -63.4168 | 2020-11-15 05:26:53 | Prince Edward Island, Canada | ||
2784780 | 2784780 | 2020-11-13 | Canada | Nunavut | 4 | 0 | 0 | 4 | 70.2998 | -83.1076 | 2020-11-14 05:25:37 | Nunavut, Canada | ||
2784782 | 2784782 | 2020-11-13 | Canada | Prince Edward Island | 68 | 0 | 64 | 4 | 46.5107 | -63.4168 | 2020-11-14 05:25:37 | Prince Edward Island, Canada | ||
864547 | 864547 | 2020-11-12 | Canada | Prince Edward Island | 68 | 0 | 64 | 4 | 46.5107 | -63.4168 | 2020-11-13 05:25:30 | Prince Edward Island, Canada | ||
3440592 | 3440592 | 2020-11-11 | Canada | Prince Edward Island | 68 | 0 | 64 | 4 | 46.5107 | -63.4168 | 2020-11-12 05:25:55 | Prince Edward Island, Canada | ||
210012 | 210012 | 2020-10-29 | Canada | Newfoundland and Labrador | 291 | 4 | 283 | 4 | 53.1355 | -57.6604 | 2020-10-30 04:24:49 | Newfoundland and Labrador, Canada | ||
210014 | 210014 | 2020-10-29 | Canada | Nova Scotia | 1102 | 65 | 1033 | 4 | 44.682 | -63.7443 | 2020-10-30 04:24:49 | Nova Scotia, Canada | ||
754074 | 754074 | 2020-10-28 | Canada | Newfoundland and Labrador | 291 | 4 | 283 | 4 | 53.1355 | -57.6604 | 2020-10-29 04:24:49 | Newfoundland and Labrador, Canada | ||
1452359 | 1452359 | 2020-10-27 | Canada | Newfoundland and Labrador | 291 | 4 | 283 | 4 | 53.1355 | -57.6604 | 2020-10-28 04:24:39 | Newfoundland and Labrador, Canada | ||
3480084 | 3480084 | 2020-10-26 | Canada | Northwest Territories | 9 | 0 | 5 | 4 | 64.8255 | -124.8457 | 2020-10-27 04:24:45 | Northwest Territories,Canada | ||
8105 | 8105 | 2020-10-25 | Canada | Northwest Territories | 9 | 0 | 5 | 4 | 64.8255 | -124.8457 | 2020-10-26 04:25:02 | Northwest Territories,Canada | ||
3651342 | 3651342 | 2020-10-24 | Canada | Northwest Territories | 9 | 0 | 5 | 4 | 64.8255 | -124.8457 | 2020-10-25 04:24:36 | Northwest Territories,Canada | ||
1053597 | 1053597 | 2020-10-23 | Canada | Northwest Territories | 9 | 0 | 5 | 4 | 64.8255 | -124.8457 | 2020-10-24 04:24:46 | Northwest Territories,Canada | ||
1053598 | 1053598 | 2020-10-23 | Canada | Nova Scotia | 1097 | 65 | 1028 | 4 | 44.682 | -63.7443 | 2020-10-24 04:24:46 | Nova Scotia, Canada | ||
1177268 | 1177268 | 2020-10-22 | Canada | Nova Scotia | 1097 | 65 | 1028 | 4 | 44.682 | -63.7443 | 2020-10-23 04:24:46 | Nova Scotia, Canada | ||
1026126 | 1026126 | 2020-10-17 | Canada | Nova Scotia | 1095 | 65 | 1024 | 4 | 44.682 | -63.7443 | 2020-10-18 04:24:25 | Nova Scotia, Canada | ||
2856621 | 2856621 | 2020-10-16 | Canada | Nova Scotia | 1093 | 65 | 1024 | 4 | 44.682 | -63.7443 | 2020-10-17 04:24:12 | Nova Scotia, Canada | ||
78862 | 78862 | 2020-10-14 | Canada | Nova Scotia | 1092 | 65 | 1023 | 4 | 44.682 | -63.7443 | 2020-10-15 04:24:28 | Nova Scotia, Canada | ||
3781677 | 3781677 | 2020-10-13 | Canada | Nova Scotia | 1092 | 65 | 1023 | 4 | 44.682 | -63.7443 | 2020-10-14 04:24:05 | Nova Scotia, Canada | ||
2291217 | 2291217 | 2020-10-12 | Canada | Nova Scotia | 1092 | 65 | 1023 | 4 | 44.682 | -63.7443 | 2020-10-13 04:24:02 | Nova Scotia, Canada | ||
3785670 | 3785670 | 2020-10-11 | Canada | Nova Scotia | 1092 | 65 | 1023 | 4 | 44.682 | -63.7443 | 2020-10-12 04:23:45 | Nova Scotia, Canada | ||
2689454 | 2689454 | 2020-10-08 | Canada | Newfoundland and Labrador | 277 | 4 | 269 | 4 | 53.1355 | -57.6604 | 2020-10-09 04:23:59 | Newfoundland and Labrador, Canada | ||
1041596 | 1041596 | 2020-10-07 | Canada | Newfoundland and Labrador | 277 | 4 | 269 | 4 | 53.1355 | -57.6604 | 2020-10-08 04:23:56 | Newfoundland and Labrador, Canada | ||
3117257 | 3117257 | 2020-10-06 | Canada | Newfoundland and Labrador | 277 | 4 | 269 | 4 | 53.1355 | -57.6604 | 2020-10-07 04:23:40 | Newfoundland and Labrador, Canada | ||
3801669 | 3801669 | 2020-10-05 | Canada | Newfoundland and Labrador | 277 | 4 | 269 | 4 | 53.1355 | -57.6604 | 2020-10-06 04:23:33 | Newfoundland and Labrador, Canada | ||
1822559 | 1822559 | 2020-10-04 | Canada | Newfoundland and Labrador | 277 | 4 | 269 | 4 | 53.1355 | -57.6604 | 2020-10-05 04:23:33 | Newfoundland and Labrador, Canada | ||
427111 | 427111 | 2020-09-07 | Canada | Nova Scotia | 1086 | 65 | 1017 | 4 | 44.682 | -63.7443 | 2020-09-08 04:28:25 | Nova Scotia, Canada | ||
813348 | 813348 | 2020-09-05 | Canada | New Brunswick | 192 | 2 | 186 | 4 | 46.5653 | -66.4619 | 2020-09-06 04:28:33 | New Brunswick, Canada | ||
2661548 | 2661548 | 2020-09-04 | Canada | New Brunswick | 192 | 2 | 186 | 4 | 46.5653 | -66.4619 | 2020-09-05 04:28:19 | New Brunswick, Canada | ||
1354088 | 1354088 | 2020-09-03 | Canada | New Brunswick | 192 | 2 | 186 | 4 | 46.5653 | -66.4619 | 2020-09-04 04:28:26 | New Brunswick, Canada | ||
1105325 | 1105325 | 2020-09-02 | Canada | New Brunswick | 192 | 2 | 186 | 4 | 46.5653 | -66.4619 | 2020-09-03 04:28:22 | New Brunswick, Canada | ||
193839 | 193839 | 2020-08-31 | Canada | New Brunswick | 191 | 2 | 185 | 4 | 46.5653 | -66.4619 | 2020-09-01 04:28:31 | New Brunswick, Canada | ||
3931798 | 3931798 | 2020-08-30 | Canada | New Brunswick | 191 | 2 | 185 | 4 | 46.5653 | -66.4619 | 2020-08-31 04:28:27 | New Brunswick, Canada | ||
3562343 | 3562343 | 2020-08-25 | Canada | Nova Scotia | 1080 | 65 | 1011 | 4 | 44.682 | -63.7443 | 2020-08-26 04:28:11 | Nova Scotia, Canada | ||
2991050 | 2991050 | 2020-08-24 | Canada | Prince Edward Island | 44 | 0 | 40 | 4 | 46.5107 | -63.4168 | 2020-08-25 04:28:02 | Prince Edward Island, Canada | ||
2215445 | 2215445 | 2020-08-23 | Canada | Prince Edward Island | 44 | 0 | 40 | 4 | 46.5107 | -63.4168 | 2020-08-24 04:27:56 | Prince Edward Island, Canada | ||
2299227 | 2299227 | 2020-08-22 | Canada | Prince Edward Island | 44 | 0 | 40 | 4 | 46.5107 | -63.4168 | 2020-08-23 04:27:48 | Prince Edward Island, Canada | ||
1479334 | 1479334 | 2020-08-21 | Canada | Prince Edward Island | 44 | 0 | 40 | 4 | 46.5107 | -63.4168 | 2020-08-22 04:27:49 | Prince Edward Island, Canada | ||
3484083 | 3484083 | 2020-08-20 | Canada | Prince Edward Island | 44 | 0 | 40 | 4 | 46.5107 | -63.4168 | 2020-08-21 04:27:41 | Prince Edward Island, Canada | ||
206032 | 206032 | 2020-08-19 | Canada | Prince Edward Island | 44 | 0 | 40 | 4 | 46.5107 | -63.4168 | 2020-08-20 04:27:43 | Prince Edward Island, Canada | ||
3177783 | 3177783 | 2020-08-18 | Canada | Nova Scotia | 1075 | 64 | 1007 | 4 | 44.682 | -63.7443 | 2020-08-19 04:27:00 | Nova Scotia, Canada | ||
3177786 | 3177786 | 2020-08-18 | Canada | Prince Edward Island | 44 | 0 | 40 | 4 | 46.5107 | -63.4168 | 2020-08-19 04:27:00 | Prince Edward Island, Canada | ||
837387 | 837387 | 2020-08-17 | Canada | Nova Scotia | 1075 | 64 | 1007 | 4 | 44.682 | -63.7443 | 2020-08-18 04:27:56 | Nova Scotia, Canada | ||
3793139 | 3793139 | 2020-08-05 | Canada | New Brunswick | 174 | 2 | 168 | 4 | 46.5653 | -66.4619 | 2020-08-06 04:35:02 | New Brunswick, Canada | ||
2740261 | 2740261 | 2020-08-03 | Canada | Newfoundland and Labrador | 266 | 3 | 259 | 4 | 53.1355 | -57.6604 | 2020-08-04 04:41:59 | Newfoundland and Labrador, Canada | ||
2808013 | 2808013 | 2020-08-02 | Canada | Newfoundland and Labrador | 266 | 3 | 259 | 4 | 53.1355 | -57.6604 | 2020-08-03 04:34:35 | Newfoundland and Labrador, Canada | ||
2808028 | 2808028 | 2020-08-02 | Canada | Nova Scotia | 1071 | 64 | 1003 | 4 | 44.681999999999995 | -63.7443 | 2020-08-03 04:34:35 | Nova Scotia, Canada | ||
753581 | 753581 | 2020-08-01 | Canada | Newfoundland and Labrador | 266 | 3 | 259 | 4 | 53.1355 | -57.6604 | 2020-08-02 04:34:47 | Newfoundland and Labrador, Canada | ||
3264746 | 3264746 | 2020-07-31 | Canada | Newfoundland and Labrador | 266 | 3 | 259 | 4 | 53.1355 | -57.6604 | 2020-08-01 04:36:27 | Newfoundland and Labrador, Canada | ||
1928453 | 1928453 | 2020-07-30 | Canada | Newfoundland and Labrador | 266 | 3 | 259 | 4 | 53.1355 | -57.6604 | 2020-07-31 04:35:18 | Newfoundland and Labrador, Canada | ||
2958621 | 2958621 | 2020-07-29 | Canada | Newfoundland and Labrador | 266 | 3 | 259 | 4 | 53.1355 | -57.6604 | 2020-07-30 04:35:05 | Newfoundland and Labrador, Canada | ||
3185237 | 3185237 | 2020-07-28 | Canada | Newfoundland and Labrador | 266 | 3 | 259 | 4 | 53.1355 | -57.6604 | 2020-07-29 04:35:11 | Newfoundland and Labrador, Canada | ||
177288 | 177288 | 2020-07-27 | Canada | Newfoundland and Labrador | 266 | 3 | 259 | 4 | 53.1355 | -57.6604 | 2020-07-28 04:58:43 | Newfoundland and Labrador, Canada | ||
442601 | 442601 | 2020-07-26 | Canada | Newfoundland and Labrador | 266 | 3 | 259 | 4 | 53.1355 | -57.6604 | 2020-07-27 04:35:02 | Newfoundland and Labrador, Canada | ||
121967 | 121967 | 2020-07-19 | Canada | New Brunswick | 169 | 2 | 163 | 4 | 46.5653 | -66.4619 | 2020-07-20 05:34:40 | New Brunswick, Canada | ||
3737647 | 3737647 | 2020-07-12 | Canada | Manitoba | 325 | 7 | 314 | 4 | 53.7609 | -98.8139 | 2020-07-13 04:43:04 | Manitoba, Canada | ||
3436042 | 3436042 | 2020-07-11 | Canada | Manitoba | 325 | 7 | 314 | 4 | 53.7609 | -98.8139 | 2020-07-12 04:34:30 | Manitoba, Canada | ||
3237540 | 3237540 | 2020-07-10 | Canada | Manitoba | 325 | 7 | 314 | 4 | 53.7609 | -98.8139 | 2020-07-11 04:34:26 | Manitoba, Canada | ||
1005525 | 1005525 | 2020-07-09 | Canada | Manitoba | 325 | 7 | 314 | 4 | 53.7609 | -98.8139 | 2020-07-10 04:34:24 | Manitoba, 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]);