johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
63 rows where active = 11 and country_or_region = "Canada" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, recovered, latitude, longitude, combined_key, day (date), last_update (date)
province_or_state 7
country_or_region 1
- Canada · 63 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
331677 | 331677 | 2021-08-04 | Canada | Nova Scotia | 5895 | 93 | 5791 | 11 | 44.682 | -63.7443 | 2021-08-05 04:21:51 | Nova Scotia, Canada | ||
1330015 | 1330015 | 2021-07-24 | Canada | New Brunswick | 2350 | 46 | 2293 | 11 | 46.5653 | -66.4619 | 2021-07-25 04:22:12 | New Brunswick, Canada | ||
3137319 | 3137319 | 2021-07-23 | Canada | New Brunswick | 2350 | 46 | 2293 | 11 | 46.5653 | -66.4619 | 2021-07-24 00:21:36 | New Brunswick, Canada | ||
3476082 | 3476082 | 2021-07-22 | Canada | Nova Scotia | 5880 | 93 | 5776 | 11 | 44.682 | -63.7443 | 2021-07-23 04:21:29 | Nova Scotia, Canada | ||
3331301 | 3331301 | 2021-07-21 | Canada | Nova Scotia | 5880 | 92 | 5777 | 11 | 44.682 | -63.7443 | 2021-07-22 04:21:19 | Nova Scotia, Canada | ||
1440351 | 1440351 | 2021-07-07 | Canada | New Brunswick | 2336 | 46 | 2279 | 11 | 46.5653 | -66.4619 | 2021-07-08 04:21:26 | New Brunswick, Canada | ||
2589771 | 2589771 | 2021-06-27 | Canada | Newfoundland and Labrador | 1384 | 7 | 1366 | 11 | 53.1355 | -57.6604 | 2021-06-28 04:21:29 | Newfoundland and Labrador, Canada | ||
3958275 | 3958275 | 2021-06-26 | Canada | Newfoundland and Labrador | 1384 | 7 | 1366 | 11 | 53.1355 | -57.6604 | 2021-06-27 04:21:39 | Newfoundland and Labrador, Canada | ||
1712094 | 1712094 | 2021-06-25 | Canada | Newfoundland and Labrador | 1384 | 7 | 1366 | 11 | 53.1355 | -57.6604 | 2021-06-26 04:21:43 | Newfoundland and Labrador, Canada | ||
2295219 | 2295219 | 2021-06-24 | Canada | Newfoundland and Labrador | 1384 | 7 | 1366 | 11 | 53.1355 | -57.6604 | 2021-06-25 04:21:33 | Newfoundland and Labrador, Canada | ||
2760693 | 2760693 | 2021-05-03 | Canada | Prince Edward Island | 177 | 0 | 166 | 11 | 46.5107 | -63.4168 | 2021-05-04 04:20:34 | Prince Edward Island, Canada | ||
2450546 | 2450546 | 2021-05-02 | Canada | Prince Edward Island | 177 | 0 | 166 | 11 | 46.5107 | -63.4168 | 2021-05-03 04:20:39 | Prince Edward Island, Canada | ||
2824559 | 2824559 | 2021-05-01 | Canada | Prince Edward Island | 177 | 0 | 166 | 11 | 46.5107 | -63.4168 | 2021-05-02 04:20:48 | Prince Edward Island, Canada | ||
379967 | 379967 | 2021-04-30 | Canada | Prince Edward Island | 177 | 0 | 166 | 11 | 46.5107 | -63.4168 | 2021-05-01 04:20:47 | Prince Edward Island, Canada | ||
1636090 | 1636090 | 2021-04-29 | Canada | Prince Edward Island | 177 | 0 | 166 | 11 | 46.5107 | -63.4168 | 2021-04-30 04:21:03 | Prince Edward Island, Canada | ||
3393169 | 3393169 | 2021-04-28 | Canada | Prince Edward Island | 177 | 0 | 166 | 11 | 46.5107 | -63.4168 | 2021-04-29 04:20:55 | Prince Edward Island, Canada | ||
3701885 | 3701885 | 2021-04-27 | Canada | Prince Edward Island | 177 | 0 | 166 | 11 | 46.5107 | -63.4168 | 2021-04-28 04:20:32 | Prince Edward Island, Canada | ||
887894 | 887894 | 2021-04-26 | Canada | Prince Edward Island | 175 | 0 | 164 | 11 | 46.5107 | -63.4168 | 2021-04-27 04:20:52 | Prince Edward Island, Canada | ||
954639 | 954639 | 2021-04-25 | Canada | Prince Edward Island | 175 | 0 | 164 | 11 | 46.5107 | -63.4168 | 2021-04-26 04:21:04 | Prince Edward Island, Canada | ||
3923786 | 3923786 | 2021-04-24 | Canada | Prince Edward Island | 175 | 0 | 164 | 11 | 46.5107 | -63.4168 | 2021-04-25 04:20:32 | Prince Edward Island, Canada | ||
1408817 | 1408817 | 2021-04-23 | Canada | Prince Edward Island | 175 | 0 | 164 | 11 | 46.5107 | -63.4168 | 2021-04-24 04:20:38 | Prince Edward Island, Canada | ||
1338048 | 1338048 | 2021-02-15 | Canada | Nunavut | 311 | 1 | 299 | 11 | 70.2998 | -83.1076 | 2021-02-16 05:24:38 | Nunavut, Canada | ||
2283199 | 2283199 | 2021-02-14 | Canada | Nunavut | 311 | 1 | 299 | 11 | 70.2998 | -83.1076 | 2021-02-15 05:24:49 | Nunavut, Canada | ||
2637494 | 2637494 | 2021-02-11 | Canada | Nova Scotia | 1590 | 65 | 1514 | 11 | 44.682 | -63.7443 | 2021-02-12 05:23:29 | Nova Scotia, Canada | ||
340047 | 340047 | 2021-02-03 | Canada | Nova Scotia | 1583 | 65 | 1507 | 11 | 44.682 | -63.7443 | 2021-02-04 05:22:26 | Nova Scotia, Canada | ||
1006070 | 1006070 | 2020-12-06 | Canada | Prince Edward Island | 80 | 0 | 69 | 11 | 46.5107 | -63.4168 | 2020-12-07 05:26:14 | Prince Edward Island, Canada | ||
74869 | 74869 | 2020-12-03 | Canada | Yukon | 51 | 1 | 39 | 11 | 64.2823 | -135.0 | 2020-12-04 05:27:27 | Yukon, Canada | ||
2079706 | 2079706 | 2020-10-31 | Canada | Nova Scotia | 1109 | 65 | 1033 | 11 | 44.682 | -63.7443 | 2020-11-01 04:36:19 | Nova Scotia, Canada | ||
3990382 | 3990382 | 2020-10-20 | Canada | Newfoundland and Labrador | 287 | 4 | 272 | 11 | 53.1355 | -57.6604 | 2020-10-21 04:24:14 | Newfoundland and Labrador, Canada | ||
1794402 | 1794402 | 2020-10-19 | Canada | Newfoundland and Labrador | 287 | 4 | 272 | 11 | 53.1355 | -57.6604 | 2020-10-20 04:24:22 | Newfoundland and Labrador, Canada | ||
762086 | 762086 | 2020-10-18 | Canada | Newfoundland and Labrador | 287 | 4 | 272 | 11 | 53.1355 | -57.6604 | 2020-10-19 04:24:16 | Newfoundland and Labrador, Canada | ||
1172961 | 1172961 | 2020-09-10 | Canada | Prince Edward Island | 55 | 0 | 44 | 11 | 46.5107 | -63.4168 | 2020-09-11 04:46:23 | Prince Edward Island, Canada | ||
2171326 | 2171326 | 2020-09-09 | Canada | Prince Edward Island | 55 | 0 | 44 | 11 | 46.5107 | -63.4168 | 2020-09-10 04:29:01 | Prince Edward Island, Canada | ||
2708618 | 2708618 | 2020-07-17 | Canada | Manitoba | 336 | 7 | 318 | 11 | 53.7609 | -98.8139 | 2020-07-18 04:34:45 | Manitoba, Canada | ||
887350 | 887350 | 2020-07-07 | Canada | Manitoba | 325 | 7 | 307 | 11 | 53.7609 | -98.8139 | 2020-07-08 05:33:48 | Manitoba, Canada | ||
1136117 | 1136117 | 2020-06-26 | Canada | Manitoba | 318 | 7 | 300 | 11 | 53.7609 | -98.8139 | 2020-06-27 04:33:35 | Manitoba, Canada | ||
1691533 | 1691533 | 2020-06-19 | Canada | Manitoba | 311 | 7 | 293 | 11 | 53.7609 | -98.8139 | 2020-06-20 04:33:19 | Manitoba, Canada | ||
3847252 | 3847252 | 2020-05-13 | Canada | Yukon | 11 | 0 | 0 | 11 | 64.2823 | -135.0 | 2020-05-14 03:32:28 | Yukon, Canada | ||
2581459 | 2581459 | 2020-05-12 | Canada | Yukon | 11 | 0 | 0 | 11 | 64.2823 | -135.0 | 2020-05-13 03:32:26 | Yukon, Canada | ||
3330993 | 3330993 | 2020-05-11 | Canada | Yukon | 11 | 0 | 0 | 11 | 64.2823 | -135.0 | 2020-05-12 03:32:27 | Yukon, Canada | ||
3459608 | 3459608 | 2020-05-10 | Canada | Yukon | 11 | 0 | 0 | 11 | 64.2823 | -135.0 | 2020-05-11 02:32:30 | Yukon, Canada | ||
2899149 | 2899149 | 2020-05-09 | Canada | Yukon | 11 | 0 | 0 | 11 | 64.2823 | -135.0 | 2020-05-10 02:32:30 | Yukon, Canada | ||
114198 | 114198 | 2020-05-08 | Canada | Yukon | 11 | 0 | 0 | 11 | 64.2823 | -135.0 | 2020-05-09 02:32:35 | Yukon, Canada | ||
3295641 | 3295641 | 2020-05-07 | Canada | Yukon | 11 | 0 | 0 | 11 | 64.2823 | -135.0 | 2020-05-08 02:32:32 | Yukon, Canada | ||
2110862 | 2110862 | 2020-05-06 | Canada | Yukon | 11 | 0 | 0 | 11 | 64.2823 | -135.0 | 2020-05-07 02:32:28 | Yukon, Canada | ||
1931902 | 1931902 | 2020-05-05 | Canada | Yukon | 11 | 0 | 0 | 11 | 64.2823 | -135.0 | 2020-05-06 02:32:31 | Yukon, Canada | ||
3084765 | 3084765 | 2020-05-04 | Canada | Yukon | 11 | 0 | 0 | 11 | 64.2823 | -135.0 | 2020-05-05 02:32:34 | Yukon, Canada | ||
2278624 | 2278624 | 2020-05-03 | Canada | Yukon | 11 | 0 | 0 | 11 | 64.2823 | -135.0 | 2020-05-04 02:32:28 | Yukon, Canada | ||
2043300 | 2043300 | 2020-05-02 | Canada | Yukon | 11 | 0 | 0 | 11 | 64.2823 | -135.0 | 2020-05-03 02:32:28 | Yukon, Canada | ||
1184194 | 1184194 | 2020-05-01 | Canada | Yukon | 11 | 0 | 0 | 11 | 64.2823 | -135.0 | 2020-05-02 02:32:27 | Yukon, Canada | ||
228675 | 228675 | 2020-04-30 | Canada | Yukon | 11 | 0 | 0 | 11 | 64.2823 | -135.0 | 2020-05-01 02:32:28 | Yukon, Canada | ||
137422 | 137422 | 2020-04-29 | Canada | Yukon | 11 | 0 | 0 | 11 | 64.2823 | -135.0 | 2020-04-30 02:32:27 | Yukon, Canada | ||
271636 | 271636 | 2020-04-28 | Canada | Yukon | 11 | 0 | 0 | 11 | 64.2823 | -135.0 | 2020-04-29 02:32:29 | Yukon, Canada | ||
3589291 | 3589291 | 2020-04-27 | Canada | Yukon | 11 | 0 | 0 | 11 | 64.2823 | -135.0 | 2020-04-28 02:30:53 | Yukon, Canada | ||
3592469 | 3592469 | 2020-04-26 | Canada | Yukon | 11 | 0 | 0 | 11 | 64.2823 | -135.0 | 2020-04-27 02:30:55 | Yukon, Canada | ||
3502818 | 3502818 | 2020-04-25 | Canada | Yukon | 11 | 0 | 0 | 11 | 64.2823 | -135.0 | 2020-04-26 02:30:54 | Yukon, Canada | ||
1459219 | 1459219 | 2020-04-24 | Canada | Yukon | 11 | 0 | 0 | 11 | 64.2823 | -135.0 | 2020-04-25 06:30:55 | Yukon, Canada | ||
2524808 | 2524808 | 2020-04-23 | Canada | Yukon | 11 | 0 | 0 | 11 | 64.2823 | -135.0 | 2020-04-24 03:31:19 | Yukon, Canada | ||
1199258 | 1199258 | 2020-04-22 | Canada | Yukon | 11 | 0 | 0 | 11 | 64.2823 | -135.0 | 2020-04-22 23:38:42 | Yukon, Canada | ||
522324 | 522324 | 2020-04-21 | Canada | Yukon | 11 | 0 | 0 | 11 | 64.2823 | -135.0 | 2020-04-21 23:38:53 | Yukon, Canada | ||
2473406 | 2473406 | 2020-04-20 | Canada | Yukon | 11 | 0 | 0 | 11 | 64.2823 | -135.0 | 2020-04-20 23:44:34 | Yukon, Canada | ||
2875639 | 2875639 | 2020-03-29 | Canada | Prince Edward Island | 11 | 0 | 0 | 11 | 46.5107 | -63.4168 | 3/29/20 23:13 | Prince Edward Island, Canada | ||
3946975 | 3946975 | 2020-03-28 | Canada | Prince Edward Island | 11 | 0 | 0 | 11 | 46.5107 | -63.4168 | 3/28/20 23:10 | Prince Edward Island, 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]);