johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
62 rows where country_or_region = "Canada" and deaths = 25 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: recovered, latitude, longitude, combined_key, last_update (date)
province_or_state 5
country_or_region 1
- Canada · 62 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2999068 | 2999068 | 2022-05-24 | Canada | Yukon | 4363 | 25 | 0 | 64.2823 | -135.0 | 2022-05-25 04:20:56 | Yukon, Canada | |||
3592789 | 3592789 | 2022-05-23 | Canada | Yukon | 4349 | 25 | 0 | 64.2823 | -135.0 | 2022-05-24 04:20:57 | Yukon, Canada | |||
1109337 | 1109337 | 2022-05-21 | Canada | Yukon | 4349 | 25 | 0 | 64.2823 | -135.0 | 2022-05-22 04:20:52 | Yukon, Canada | |||
1168961 | 1168961 | 2022-05-20 | Canada | Yukon | 4349 | 25 | 0 | 64.2823 | -135.0 | 2022-05-21 04:20:58 | Yukon, Canada | |||
3895724 | 3895724 | 2022-05-19 | Canada | Yukon | 4345 | 25 | 0 | 64.2823 | -135.0 | 2022-05-20 04:20:57 | Yukon, Canada | |||
1184508 | 1184508 | 2022-05-18 | Canada | Yukon | 4339 | 25 | 0 | 64.2823 | -135.0 | 2022-05-19 04:20:54 | Yukon, Canada | |||
3582405 | 3582405 | 2022-05-17 | Canada | Yukon | 4335 | 25 | 0 | 64.2823 | -135.0 | 2022-05-18 04:20:50 | Yukon, Canada | |||
1503362 | 1503362 | 2022-05-16 | Canada | Yukon | 4328 | 25 | 0 | 64.2823 | -135.0 | 2022-05-17 04:20:59 | Yukon, Canada | |||
2083721 | 2083721 | 2022-05-15 | Canada | Yukon | 4318 | 25 | 0 | 64.2823 | -135.0 | 2022-05-16 04:20:47 | Yukon, Canada | |||
3354432 | 3354432 | 2022-05-14 | Canada | Yukon | 4318 | 25 | 0 | 64.2823 | -135.0 | 2022-05-15 04:20:53 | Yukon, Canada | |||
658077 | 658077 | 2022-05-13 | Canada | Yukon | 4318 | 25 | 0 | 64.2823 | -135.0 | 2022-05-14 04:20:48 | Yukon, Canada | |||
2533160 | 2533160 | 2022-05-12 | Canada | Yukon | 4310 | 25 | 0 | 64.2823 | -135.0 | 2022-05-13 04:20:51 | Yukon, Canada | |||
3444606 | 3444606 | 2022-05-11 | Canada | Yukon | 4301 | 25 | 0 | 64.2823 | -135.0 | 2022-05-12 04:20:54 | Yukon, Canada | |||
3535223 | 3535223 | 2022-05-10 | Canada | Yukon | 4294 | 25 | 0 | 64.2823 | -135.0 | 2022-05-11 04:20:48 | Yukon, Canada | |||
221758 | 221758 | 2022-05-09 | Canada | Yukon | 4290 | 25 | 0 | 64.2823 | -135.0 | 2022-05-10 04:20:50 | Yukon, Canada | |||
2331143 | 2331143 | 2022-05-08 | Canada | Yukon | 4262 | 25 | 0 | 64.2823 | -135.0 | 2022-05-09 04:20:54 | Yukon, Canada | |||
360105 | 360105 | 2022-05-07 | Canada | Yukon | 4262 | 25 | 0 | 64.2823 | -135.0 | 2022-05-08 04:20:49 | Yukon, Canada | |||
1397456 | 1397456 | 2022-05-06 | Canada | Yukon | 4262 | 25 | 0 | 64.2823 | -135.0 | 2022-05-07 04:21:09 | Yukon, Canada | |||
2597811 | 2597811 | 2022-05-05 | Canada | Yukon | 4254 | 25 | 0 | 64.2823 | -135.0 | 2022-05-06 04:21:00 | Yukon, Canada | |||
3265260 | 3265260 | 2022-05-04 | Canada | Yukon | 4237 | 25 | 0 | 64.2823 | -135.0 | 2022-05-05 04:20:55 | Yukon, Canada | |||
1571895 | 1571895 | 2022-05-03 | Canada | Prince Edward Island | 35433 | 25 | 0 | 46.5107 | -63.4168 | 2022-05-04 04:20:59 | Prince Edward Island, Canada | |||
1571899 | 1571899 | 2022-05-03 | Canada | Yukon | 4226 | 25 | 0 | 64.2823 | -135.0 | 2022-05-04 04:20:59 | Yukon, Canada | |||
463155 | 463155 | 2022-05-02 | Canada | Prince Edward Island | 34270 | 25 | 0 | 46.5107 | -63.4168 | 2022-05-03 04:21:00 | Prince Edward Island, Canada | |||
463159 | 463159 | 2022-05-02 | Canada | Yukon | 4217 | 25 | 0 | 64.2823 | -135.0 | 2022-05-03 04:21:00 | Yukon, Canada | |||
3915794 | 3915794 | 2022-05-01 | Canada | Prince Edward Island | 34270 | 25 | 0 | 46.5107 | -63.4168 | 2022-05-02 04:21:10 | Prince Edward Island, Canada | |||
3915798 | 3915798 | 2022-05-01 | Canada | Yukon | 4196 | 25 | 0 | 64.2823 | -135.0 | 2022-05-02 04:21:10 | Yukon, Canada | |||
2840598 | 2840598 | 2022-04-30 | Canada | Prince Edward Island | 34270 | 25 | 0 | 46.5107 | -63.4168 | 2022-05-01 04:20:57 | Prince Edward Island, Canada | |||
2840602 | 2840602 | 2022-04-30 | Canada | Yukon | 4196 | 25 | 0 | 64.2823 | -135.0 | 2022-05-01 04:20:57 | Yukon, Canada | |||
1156911 | 1156911 | 2022-04-29 | Canada | Prince Edward Island | 34270 | 25 | 0 | 46.5107 | -63.4168 | 2022-04-30 04:21:05 | Prince Edward Island, Canada | |||
1156915 | 1156915 | 2022-04-29 | Canada | Yukon | 4196 | 25 | 0 | 64.2823 | -135.0 | 2022-04-30 04:21:05 | Yukon, Canada | |||
1696093 | 1696093 | 2022-04-28 | Canada | Prince Edward Island | 34270 | 25 | 0 | 46.5107 | -63.4168 | 2022-04-29 04:20:59 | Prince Edward Island, Canada | |||
1696097 | 1696097 | 2022-04-28 | Canada | Yukon | 4187 | 25 | 0 | 64.2823 | -135.0 | 2022-04-29 04:20:59 | Yukon, Canada | |||
3851576 | 3851576 | 2022-04-27 | Canada | Prince Edward Island | 34270 | 25 | 0 | 46.5107 | -63.4168 | 2022-04-28 04:20:47 | Prince Edward Island, Canada | |||
3840264 | 3840264 | 2022-01-15 | Canada | Newfoundland and Labrador | 12406 | 25 | 0 | 53.1355 | -57.6604 | 2022-01-16 04:21:12 | Newfoundland and Labrador, Canada | |||
181808 | 181808 | 2021-02-21 | Canada | New Brunswick | 1424 | 25 | 1311 | 88 | 46.5653 | -66.4619 | 2021-02-22 05:24:21 | New Brunswick, Canada | ||
375961 | 375961 | 2020-11-06 | Canada | Saskatchewan | 3623 | 25 | 2687 | 911 | 52.9399 | -106.4509 | 2020-11-07 05:24:52 | Saskatchewan, Canada | ||
891899 | 891899 | 2020-11-05 | Canada | Saskatchewan | 3536 | 25 | 2634 | 877 | 52.9399 | -106.4509 | 2020-11-06 05:24:55 | Saskatchewan, Canada | ||
2918961 | 2918961 | 2020-11-04 | Canada | Saskatchewan | 3408 | 25 | 2584 | 799 | 52.9399 | -106.4509 | 2020-11-05 06:05:03 | Saskatchewan, Canada | ||
2497798 | 2497798 | 2020-11-03 | Canada | Saskatchewan | 3373 | 25 | 2506 | 842 | 52.9399 | -106.4509 | 2020-11-04 05:25:09 | Saskatchewan, Canada | ||
3303973 | 3303973 | 2020-11-02 | Canada | Saskatchewan | 3292 | 25 | 2409 | 858 | 52.9399 | -106.4509 | 2020-11-03 06:00:16 | Saskatchewan, Canada | ||
3409222 | 3409222 | 2020-11-01 | Canada | Saskatchewan | 3218 | 25 | 2395 | 798 | 52.9399 | -106.4509 | 2020-11-02 05:25:04 | Saskatchewan, Canada | ||
2079711 | 2079711 | 2020-10-31 | Canada | Saskatchewan | 3144 | 25 | 2380 | 739 | 52.9399 | -106.4509 | 2020-11-01 04:36:19 | Saskatchewan, Canada | ||
2243164 | 2243164 | 2020-10-30 | Canada | Saskatchewan | 3066 | 25 | 2299 | 742 | 52.9399 | -106.4509 | 2020-10-31 04:24:44 | Saskatchewan, Canada | ||
210019 | 210019 | 2020-10-29 | Canada | Saskatchewan | 2990 | 25 | 2258 | 707 | 52.9399 | -106.4509 | 2020-10-30 04:24:49 | Saskatchewan, Canada | ||
754081 | 754081 | 2020-10-28 | Canada | Saskatchewan | 2908 | 25 | 2217 | 666 | 52.9399 | -106.4509 | 2020-10-29 04:24:49 | Saskatchewan, Canada | ||
1452366 | 1452366 | 2020-10-27 | Canada | Saskatchewan | 2841 | 25 | 2164 | 652 | 52.9399 | -106.4509 | 2020-10-28 04:24:39 | Saskatchewan, Canada | ||
3480090 | 3480090 | 2020-10-26 | Canada | Saskatchewan | 2783 | 25 | 2108 | 650 | 52.9399 | -106.4509 | 2020-10-27 04:24:45 | Saskatchewan, Canada | ||
8111 | 8111 | 2020-10-25 | Canada | Saskatchewan | 2729 | 25 | 2085 | 619 | 52.9399 | -106.4509 | 2020-10-26 04:25:02 | Saskatchewan, Canada | ||
3651348 | 3651348 | 2020-10-24 | Canada | Saskatchewan | 2669 | 25 | 2070 | 574 | 52.9399 | -106.4509 | 2020-10-25 04:24:36 | Saskatchewan, Canada | ||
1053603 | 1053603 | 2020-10-23 | Canada | Saskatchewan | 2591 | 25 | 2055 | 511 | 52.9399 | -106.4509 | 2020-10-24 04:24:46 | Saskatchewan, Canada | ||
1177273 | 1177273 | 2020-10-22 | Canada | Saskatchewan | 2558 | 25 | 2024 | 509 | 52.9399 | -106.4509 | 2020-10-23 04:24:46 | Saskatchewan, Canada | ||
2191378 | 2191378 | 2020-10-21 | Canada | Saskatchewan | 2496 | 25 | 2002 | 469 | 52.9399 | -106.4509 | 2020-10-22 04:24:27 | Saskatchewan, Canada | ||
3990389 | 3990389 | 2020-10-20 | Canada | Saskatchewan | 2439 | 25 | 1987 | 427 | 52.9399 | -106.4509 | 2020-10-21 04:24:14 | Saskatchewan, Canada | ||
1794409 | 1794409 | 2020-10-19 | Canada | Saskatchewan | 2396 | 25 | 1973 | 398 | 52.9399 | -106.4509 | 2020-10-20 04:24:22 | Saskatchewan, Canada | ||
762093 | 762093 | 2020-10-18 | Canada | Saskatchewan | 2330 | 25 | 1963 | 342 | 52.9399 | -106.4509 | 2020-10-19 04:24:16 | Saskatchewan, Canada | ||
1026131 | 1026131 | 2020-10-17 | Canada | Saskatchewan | 2306 | 25 | 1946 | 299 | 52.9399 | -106.4509 | 2020-10-18 04:24:25 | Saskatchewan, Canada | ||
2856626 | 2856626 | 2020-10-16 | Canada | Saskatchewan | 2270 | 25 | 1946 | 299 | 52.9399 | -106.4509 | 2020-10-17 04:24:12 | Saskatchewan, Canada | ||
786156 | 786156 | 2020-10-15 | Canada | Saskatchewan | 2232 | 25 | 1936 | 271 | 52.9399 | -106.4509 | 2020-10-16 04:24:01 | Saskatchewan, Canada | ||
78867 | 78867 | 2020-10-14 | Canada | Saskatchewan | 2199 | 25 | 1920 | 254 | 52.9399 | -106.4509 | 2020-10-15 04:24:28 | Saskatchewan, Canada | ||
3781682 | 3781682 | 2020-10-13 | Canada | Saskatchewan | 2174 | 25 | 1911 | 238 | 52.9399 | -106.4509 | 2020-10-14 04:24:05 | Saskatchewan, Canada | ||
2291222 | 2291222 | 2020-10-12 | Canada | Saskatchewan | 2140 | 25 | 1900 | 215 | 52.9399 | -106.4509 | 2020-10-13 04:24:02 | Saskatchewan, Canada | ||
3785675 | 3785675 | 2020-10-11 | Canada | Saskatchewan | 2092 | 25 | 1888 | 179 | 52.9399 | -106.4509 | 2020-10-12 04:23:45 | Saskatchewan, 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]);