johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
38 rows where active = 27 and country_or_region = "Canada" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed, recovered, latitude, combined_key, last_update (date)
province_or_state 6
country_or_region 1
- Canada · 38 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3631726 | 3631726 | 2021-07-14 | Canada | Newfoundland and Labrador | 1410 | 7 | 1376 | 27 | 53.1355 | -57.6604 | 2021-07-15 04:21:48 | Newfoundland and Labrador, Canada | ||
3125275 | 3125275 | 2021-06-28 | Canada | New Brunswick | 2326 | 45 | 2254 | 27 | 46.5653 | -66.4619 | 2021-06-29 04:21:28 | New Brunswick, Canada | ||
3923781 | 3923781 | 2021-04-24 | Canada | Newfoundland and Labrador | 1056 | 6 | 1023 | 27 | 53.1355 | -57.6604 | 2021-04-25 04:20:32 | Newfoundland and Labrador, Canada | ||
1408812 | 1408812 | 2021-04-23 | Canada | Newfoundland and Labrador | 1053 | 6 | 1020 | 27 | 53.1355 | -57.6604 | 2021-04-24 04:20:38 | Newfoundland and Labrador, Canada | ||
1880757 | 1880757 | 2021-03-26 | Canada | Nova Scotia | 1704 | 66 | 1611 | 27 | 44.682 | -63.7443 | 2021-03-27 05:25:04 | Nova Scotia, Canada | ||
1857776 | 1857776 | 2021-02-25 | Canada | Nova Scotia | 1624 | 65 | 1532 | 27 | 44.682 | -63.7443 | 2021-02-26 05:22:40 | Nova Scotia, Canada | ||
279955 | 279955 | 2021-02-24 | Canada | Nunavut | 351 | 1 | 323 | 27 | 70.2998 | -83.1076 | 2021-02-25 05:24:57 | Nunavut, Canada | ||
1152894 | 1152894 | 2021-02-18 | Canada | Nunavut | 330 | 1 | 302 | 27 | 70.2998 | -83.1076 | 2021-02-19 05:24:16 | Nunavut, Canada | ||
1676244 | 1676244 | 2021-02-01 | Canada | Nunavut | 294 | 1 | 266 | 27 | 70.2998 | -83.1076 | 2021-02-02 05:22:49 | Nunavut, Canada | ||
1459532 | 1459532 | 2021-01-31 | Canada | Nunavut | 294 | 1 | 266 | 27 | 70.2998 | -83.1076 | 2021-02-01 05:22:53 | Nunavut, Canada | ||
774120 | 774120 | 2021-01-12 | Canada | Nova Scotia | 1534 | 65 | 1442 | 27 | 44.682 | -63.7443 | 2021-01-13 05:22:15 | Nova Scotia, Canada | ||
1061620 | 1061620 | 2021-01-04 | Canada | Nova Scotia | 1505 | 65 | 1413 | 27 | 44.682 | -63.7443 | 2021-01-05 05:21:49 | Nova Scotia, Canada | ||
3230223 | 3230223 | 2021-01-03 | Canada | Nova Scotia | 1501 | 65 | 1407 | 27 | 44.682 | -63.7443 | 2021-01-04 05:22:02 | Nova Scotia, Canada | ||
2227293 | 2227293 | 2021-01-02 | Canada | Nova Scotia | 1499 | 65 | 1407 | 27 | 44.682 | -63.7443 | 2021-01-03 05:22:52 | Nova Scotia, Canada | ||
1900938 | 1900938 | 2020-12-18 | Canada | Newfoundland and Labrador | 372 | 4 | 341 | 27 | 53.1355 | -57.6604 | 2020-12-19 05:27:52 | Newfoundland and Labrador, Canada | ||
3859602 | 3859602 | 2020-12-04 | Canada | Newfoundland and Labrador | 343 | 4 | 312 | 27 | 53.1355 | -57.6604 | 2020-12-05 05:27:36 | Newfoundland and Labrador, Canada | ||
1510662 | 1510662 | 2020-06-22 | Canada | New Brunswick | 164 | 2 | 135 | 27 | 46.5653 | -66.4619 | 2020-06-23 04:33:22 | New Brunswick, Canada | ||
3249401 | 3249401 | 2020-06-21 | Canada | New Brunswick | 164 | 2 | 135 | 27 | 46.5653 | -66.4619 | 2020-06-22 04:33:20 | New Brunswick, Canada | ||
2437994 | 2437994 | 2020-06-20 | Canada | New Brunswick | 164 | 2 | 135 | 27 | 46.5653 | -66.4619 | 2020-06-21 04:33:19 | New Brunswick, Canada | ||
1691572 | 1691572 | 2020-06-19 | Canada | New Brunswick | 164 | 2 | 135 | 27 | 46.5653 | -66.4619 | 2020-06-20 04:33:19 | New Brunswick, Canada | ||
3682721 | 3682721 | 2020-06-18 | Canada | New Brunswick | 164 | 2 | 135 | 27 | 46.5653 | -66.4619 | 2020-06-19 04:33:17 | New Brunswick, Canada | ||
1269888 | 1269888 | 2020-06-05 | Canada | Saskatchewan | 649 | 11 | 611 | 27 | 52.9399 | -106.4509 | 2020-06-06 02:33:00 | Saskatchewan, Canada | ||
3847224 | 3847224 | 2020-05-13 | Canada | Prince Edward Island | 27 | 0 | 0 | 27 | 46.5107 | -63.4168 | 2020-05-14 03:32:28 | Prince Edward Island, Canada | ||
2581431 | 2581431 | 2020-05-12 | Canada | Prince Edward Island | 27 | 0 | 0 | 27 | 46.5107 | -63.4168 | 2020-05-13 03:32:26 | Prince Edward Island, Canada | ||
3330965 | 3330965 | 2020-05-11 | Canada | Prince Edward Island | 27 | 0 | 0 | 27 | 46.5107 | -63.4168 | 2020-05-12 03:32:27 | Prince Edward Island, Canada | ||
3459580 | 3459580 | 2020-05-10 | Canada | Prince Edward Island | 27 | 0 | 0 | 27 | 46.5107 | -63.4168 | 2020-05-11 02:32:30 | Prince Edward Island, Canada | ||
2899121 | 2899121 | 2020-05-09 | Canada | Prince Edward Island | 27 | 0 | 0 | 27 | 46.5107 | -63.4168 | 2020-05-10 02:32:30 | Prince Edward Island, Canada | ||
114170 | 114170 | 2020-05-08 | Canada | Prince Edward Island | 27 | 0 | 0 | 27 | 46.5107 | -63.4168 | 2020-05-09 02:32:35 | Prince Edward Island, Canada | ||
3295613 | 3295613 | 2020-05-07 | Canada | Prince Edward Island | 27 | 0 | 0 | 27 | 46.5107 | -63.4168 | 2020-05-08 02:32:32 | Prince Edward Island, Canada | ||
2110834 | 2110834 | 2020-05-06 | Canada | Prince Edward Island | 27 | 0 | 0 | 27 | 46.5107 | -63.4168 | 2020-05-07 02:32:28 | Prince Edward Island, Canada | ||
1931874 | 1931874 | 2020-05-05 | Canada | Prince Edward Island | 27 | 0 | 0 | 27 | 46.5107 | -63.4168 | 2020-05-06 02:32:31 | Prince Edward Island, Canada | ||
3084737 | 3084737 | 2020-05-04 | Canada | Prince Edward Island | 27 | 0 | 0 | 27 | 46.5107 | -63.4168 | 2020-05-05 02:32:34 | Prince Edward Island, Canada | ||
2278596 | 2278596 | 2020-05-03 | Canada | Prince Edward Island | 27 | 0 | 0 | 27 | 46.5107 | -63.4168 | 2020-05-04 02:32:28 | Prince Edward Island, Canada | ||
2043272 | 2043272 | 2020-05-02 | Canada | Prince Edward Island | 27 | 0 | 0 | 27 | 46.5107 | -63.4168 | 2020-05-03 02:32:28 | Prince Edward Island, Canada | ||
1184166 | 1184166 | 2020-05-01 | Canada | Prince Edward Island | 27 | 0 | 0 | 27 | 46.5107 | -63.4168 | 2020-05-02 02:32:27 | Prince Edward Island, Canada | ||
228647 | 228647 | 2020-04-30 | Canada | Prince Edward Island | 27 | 0 | 0 | 27 | 46.5107 | -63.4168 | 2020-05-01 02:32:28 | Prince Edward Island, Canada | ||
137394 | 137394 | 2020-04-29 | Canada | Prince Edward Island | 27 | 0 | 0 | 27 | 46.5107 | -63.4168 | 2020-04-30 02:32:27 | Prince Edward Island, Canada | ||
271608 | 271608 | 2020-04-28 | Canada | Prince Edward Island | 27 | 0 | 0 | 27 | 46.5107 | -63.4168 | 2020-04-29 02:32:29 | 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]);