johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,022 rows where country_or_region = "Canada" and province_or_state = "Saskatchewan" sorted by rowid descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
Link | rowid ▲ | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4002429 | 4002429 | 2022-10-08 | Canada | Saskatchewan | 143747 | 1507 | 0 | 52.9399 | -106.4509 | 2022-10-09 04:21:16 | Saskatchewan, Canada | |||
3998412 | 3998412 | 2021-12-30 | Canada | Saskatchewan | 84446 | 955 | 0 | 52.9399 | -106.4509 | 2021-12-31 04:21:50 | Saskatchewan, Canada | |||
3994397 | 3994397 | 2022-09-27 | Canada | Saskatchewan | 143747 | 1507 | 0 | 52.9399 | -106.4509 | 2022-09-28 04:23:01 | 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 | ||
3986386 | 3986386 | 2022-09-15 | Canada | Saskatchewan | 141815 | 1479 | 0 | 52.9399 | -106.4509 | 2022-09-16 04:21:19 | Saskatchewan, Canada | |||
3982370 | 3982370 | 2022-06-15 | Canada | Saskatchewan | 139224 | 1398 | 0 | 52.9399 | -106.4509 | 2022-06-16 04:20:55 | Saskatchewan, Canada | |||
3978355 | 3978355 | 2021-02-10 | Canada | Saskatchewan | 25843 | 348 | 23527 | 1968 | 52.9399 | -106.4509 | 2021-02-11 05:23:55 | Saskatchewan, Canada | ||
3974341 | 3974341 | 2021-09-03 | Canada | Saskatchewan | 55396 | 610 | 0 | 52.9399 | -106.4509 | 2021-09-04 04:21:28 | Saskatchewan, Canada | |||
3970327 | 3970327 | 2021-06-11 | Canada | Saskatchewan | 47769 | 554 | 46311 | 899 | 52.9399 | -106.4509 | 2021-06-12 04:22:22 | Saskatchewan, Canada | ||
3966312 | 3966312 | 2022-07-05 | Canada | Saskatchewan | 139663 | 1403 | 0 | 52.9399 | -106.4509 | 2022-07-06 04:20:58 | Saskatchewan, Canada | |||
3962297 | 3962297 | 2021-03-10 | Canada | Saskatchewan | 30028 | 401 | 28244 | 1384 | 52.9399 | -106.4509 | 2021-03-11 05:25:48 | Saskatchewan, Canada | ||
3958283 | 3958283 | 2021-06-26 | Canada | Saskatchewan | 48706 | 566 | 47543 | 597 | 52.9399 | -106.4509 | 2021-06-27 04:21:39 | Saskatchewan, Canada | ||
3954269 | 3954269 | 2021-05-11 | Canada | Saskatchewan | 43490 | 506 | 40911 | 2064 | 52.9399 | -106.4509 | 2021-05-12 04:21:29 | Saskatchewan, Canada | ||
3950254 | 3950254 | 2022-08-17 | Canada | Saskatchewan | 140291 | 1438 | 0 | 52.9399 | -106.4509 | 2022-08-18 04:21:11 | Saskatchewan, Canada | |||
3949927 | 3949927 | 2020-04-09 | Canada | Saskatchewan | 278 | 3 | 0 | 268 | 52.9399 | -106.4509 | 2020-04-09 23:09:01 | Saskatchewan, Canada | ||
3946985 | 3946985 | 2020-03-28 | Canada | Saskatchewan | 134 | 0 | 0 | 134 | 52.9399 | -106.4509 | 3/28/20 23:10 | Saskatchewan, Canada | ||
3939821 | 3939821 | 2022-06-30 | Canada | Saskatchewan | 139663 | 1403 | 0 | 52.9399 | -106.4509 | 2022-07-01 04:21:10 | Saskatchewan, Canada | |||
3935805 | 3935805 | 2022-12-09 | Canada | Saskatchewan | 149189 | 1701 | 0 | 52.9399 | -106.4509 | 2022-12-10 04:21:02 | Saskatchewan, Canada | |||
3931806 | 3931806 | 2020-08-30 | Canada | Saskatchewan | 1615 | 24 | 1549 | 42 | 52.9399 | -106.4509 | 2020-08-31 04:28:27 | Saskatchewan, Canada | ||
3927803 | 3927803 | 2021-10-02 | Canada | Saskatchewan | 68290 | 708 | 0 | 52.9399 | -106.4509 | 2021-10-03 04:21:24 | Saskatchewan, Canada | |||
3923789 | 3923789 | 2021-04-24 | Canada | Saskatchewan | 39683 | 473 | 36652 | 2558 | 52.9399 | -106.4509 | 2021-04-25 04:20:32 | Saskatchewan, Canada | ||
3923375 | 3923375 | 2020-08-09 | Canada | Saskatchewan | 1445 | 20 | 1257 | 168 | 52.9399 | -106.4509 | 2020-08-10 04:34:55 | Saskatchewan, Canada | ||
3915797 | 3915797 | 2022-05-01 | Canada | Saskatchewan | 136026 | 1309 | 0 | 52.9399 | -106.4509 | 2022-05-02 04:21:10 | Saskatchewan, Canada | |||
3911781 | 3911781 | 2022-02-20 | Canada | Saskatchewan | 125780 | 1054 | 0 | 52.9399 | -106.4509 | 2022-02-21 04:21:05 | Saskatchewan, Canada | |||
3907765 | 3907765 | 2022-08-11 | Canada | Saskatchewan | 140291 | 1438 | 0 | 52.9399 | -106.4509 | 2022-08-12 04:20:54 | Saskatchewan, Canada | |||
3903750 | 3903750 | 2021-07-31 | Canada | Saskatchewan | 50024 | 578 | 48967 | 479 | 52.9399 | -106.4509 | 2021-08-01 04:21:50 | Saskatchewan, Canada | ||
3899738 | 3899738 | 2021-01-09 | Canada | Saskatchewan | 17807 | 191 | 14426 | 3186 | 52.9399 | -106.4509 | 2021-01-10 05:22:12 | Saskatchewan, Canada | ||
3895723 | 3895723 | 2022-05-19 | Canada | Saskatchewan | 137502 | 1342 | 0 | 52.9399 | -106.4509 | 2022-05-20 04:20:57 | Saskatchewan, Canada | |||
3891708 | 3891708 | 2021-08-29 | Canada | Saskatchewan | 53875 | 598 | 0 | 52.9399 | -106.4509 | 2021-08-30 04:21:23 | Saskatchewan, Canada | |||
3891508 | 3891508 | 2020-03-17 | Canada | Saskatchewan | 7 | 0 | 0 | 52.9399 | -106.4509 | 2020-03-16T20:13:20 | ||||
3887381 | 3887381 | 2022-06-06 | Canada | Saskatchewan | 138707 | 1385 | 0 | 52.9399 | -106.4509 | 2022-06-07 04:21:08 | Saskatchewan, Canada | |||
3883366 | 3883366 | 2021-04-11 | Canada | Saskatchewan | 36304 | 454 | 33347 | 2504 | 52.9399 | -106.4509 | 2021-04-12 04:21:00 | Saskatchewan, Canada | ||
3879354 | 3879354 | 2021-01-14 | Canada | Saskatchewan | 19333 | 206 | 15264 | 3859 | 52.9399 | -106.4509 | 2021-01-15 05:22:24 | Saskatchewan, Canada | ||
3875339 | 3875339 | 2022-02-19 | Canada | Saskatchewan | 125780 | 1054 | 0 | 52.9399 | -106.4509 | 2022-02-20 04:21:00 | Saskatchewan, Canada | |||
3871323 | 3871323 | 2022-07-31 | Canada | Saskatchewan | 140291 | 1438 | 0 | 52.9399 | -106.4509 | 2022-08-01 04:21:03 | Saskatchewan, Canada | |||
3867307 | 3867307 | 2022-04-05 | Canada | Saskatchewan | 132224 | 1229 | 0 | 52.9399 | -106.4509 | 2022-04-06 04:20:49 | Saskatchewan, Canada | |||
3866912 | 3866912 | 2020-06-03 | Canada | Saskatchewan | 647 | 11 | 602 | 34 | 52.9399 | -106.4509 | 2020-06-04 02:33:14 | Saskatchewan, Canada | ||
3859610 | 3859610 | 2020-12-04 | Canada | Saskatchewan | 9526 | 55 | 5356 | 4116 | 52.9399 | -106.4509 | 2020-12-05 05:27:36 | Saskatchewan, Canada | ||
3855595 | 3855595 | 2022-02-18 | Canada | Saskatchewan | 125780 | 1054 | 0 | 52.9399 | -106.4509 | 2022-02-19 04:21:11 | Saskatchewan, Canada | |||
3851579 | 3851579 | 2022-04-27 | Canada | Saskatchewan | 135197 | 1295 | 0 | 52.9399 | -106.4509 | 2022-04-28 04:20:47 | Saskatchewan, Canada | |||
3847567 | 3847567 | 2020-12-13 | Canada | Saskatchewan | 11969 | 89 | 7694 | 4188 | 52.9399 | -106.4509 | 2020-12-14 05:26:27 | Saskatchewan, Canada | ||
3847235 | 3847235 | 2020-05-13 | Canada | Saskatchewan | 577 | 6 | 0 | 570 | 52.9399 | -106.4509 | 2020-05-14 03:32:28 | Saskatchewan, Canada | ||
3840272 | 3840272 | 2022-01-15 | Canada | Saskatchewan | 98699 | 961 | 0 | 52.9399 | -106.4509 | 2022-01-16 04:21:12 | Saskatchewan, Canada | |||
3836261 | 3836261 | 2020-11-21 | Canada | Saskatchewan | 6237 | 33 | 3667 | 2537 | 52.9399 | -106.4509 | 2020-11-22 05:25:45 | Saskatchewan, Canada | ||
3832247 | 3832247 | 2021-10-05 | Canada | Saskatchewan | 69331 | 726 | 0 | 52.9399 | -106.4509 | 2021-10-06 04:21:33 | Saskatchewan, Canada | |||
3828231 | 3828231 | 2021-12-21 | Canada | Saskatchewan | 82334 | 943 | 0 | 52.9399 | -106.4509 | 2021-12-22 04:21:54 | Saskatchewan, Canada | |||
3824216 | 3824216 | 2022-09-10 | Canada | Saskatchewan | 141815 | 1479 | 0 | 52.9399 | -106.4509 | 2022-09-11 04:20:50 | Saskatchewan, Canada | |||
3820200 | 3820200 | 2022-02-16 | Canada | Saskatchewan | 125780 | 1054 | 0 | 52.9399 | -106.4509 | 2022-02-17 04:20:56 | Saskatchewan, Canada | |||
3816183 | 3816183 | 2021-12-23 | Canada | Saskatchewan | 82640 | 945 | 0 | 52.9399 | -106.4509 | 2021-12-24 04:21:34 | Saskatchewan, Canada | |||
3815860 | 3815860 | 2020-03-31 | Canada | Saskatchewan | 184 | 2 | 0 | 182 | 52.9399 | -106.4509 | 2020-03-31 23:49:13 | Saskatchewan, Canada | ||
3809694 | 3809694 | 2022-01-28 | Canada | Saskatchewan | 115405 | 987 | 0 | 52.9399 | -106.4509 | 2022-01-29 04:21:10 | Saskatchewan, Canada | |||
3805680 | 3805680 | 2021-09-11 | Canada | Saskatchewan | 58293 | 618 | 0 | 52.9399 | -106.4509 | 2021-09-12 04:21:13 | Saskatchewan, Canada | |||
3801676 | 3801676 | 2020-10-05 | Canada | Saskatchewan | 1968 | 24 | 1801 | 143 | 52.9399 | -106.4509 | 2020-10-06 04:23:33 | Saskatchewan, Canada | ||
3797673 | 3797673 | 2022-08-20 | Canada | Saskatchewan | 141815 | 1479 | 0 | 52.9399 | -106.4509 | 2022-08-21 04:20:44 | Saskatchewan, Canada | |||
3793656 | 3793656 | 2021-10-25 | Canada | Saskatchewan | 76481 | 817 | 0 | 52.9399 | -106.4509 | 2021-10-26 04:22:09 | Saskatchewan, Canada | |||
3793242 | 3793242 | 2020-08-05 | Canada | Saskatchewan | 1376 | 18 | 1133 | 225 | 52.9399 | -106.4509 | 2020-08-06 04:35: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 | ||
3781682 | 3781682 | 2020-10-13 | Canada | Saskatchewan | 2174 | 25 | 1911 | 238 | 52.9399 | -106.4509 | 2020-10-14 04:24:05 | Saskatchewan, Canada | ||
3777683 | 3777683 | 2020-12-27 | Canada | Saskatchewan | 14813 | 141 | 11275 | 3398 | 52.9399 | -106.4509 | 2020-12-28 05:22:06 | Saskatchewan, Canada | ||
3773668 | 3773668 | 2022-08-30 | Canada | Saskatchewan | 141815 | 1479 | 0 | 52.9399 | -106.4509 | 2022-08-31 04:20:57 | Saskatchewan, Canada | |||
3769656 | 3769656 | 2020-12-22 | Canada | Saskatchewan | 13941 | 125 | 9872 | 3945 | 52.9399 | -106.4509 | 2020-12-23 05:22:03 | Saskatchewan, Canada | ||
3765641 | 3765641 | 2022-09-11 | Canada | Saskatchewan | 141815 | 1479 | 0 | 52.9399 | -106.4509 | 2022-09-12 04:20:58 | Saskatchewan, Canada | |||
3765395 | 3765395 | 2020-03-13 | Canada | Saskatchewan | 2 | 0 | 0 | 52.9399 | -106.4509 | 2020-03-11T20:00:00 | ||||
3761363 | 3761363 | 2020-12-28 | Canada | Saskatchewan | 14907 | 141 | 11275 | 3398 | 52.9399 | -106.4509 | 2020-12-29 05:22:37 | Saskatchewan, Canada | ||
3757250 | 3757250 | 2021-09-21 | Canada | Saskatchewan | 62989 | 646 | 0 | 52.9399 | -106.4509 | 2021-09-22 04:21:45 | Saskatchewan, Canada | |||
3753235 | 3753235 | 2022-10-13 | Canada | Saskatchewan | 143747 | 1507 | 0 | 52.9399 | -106.4509 | 2022-10-14 04:22:28 | Saskatchewan, Canada | |||
3748888 | 3748888 | 2021-11-22 | Canada | Saskatchewan | 80413 | 912 | 0 | 52.9399 | -106.4509 | 2021-11-23 04:22:39 | Saskatchewan, Canada | |||
3744873 | 3744873 | 2022-09-07 | Canada | Saskatchewan | 141815 | 1479 | 0 | 52.9399 | -106.4509 | 2022-09-08 04:21:02 | Saskatchewan, Canada | |||
3740858 | 3740858 | 2021-07-12 | Canada | Saskatchewan | 49277 | 573 | 48309 | 397 | 52.9399 | -106.4509 | 2021-07-13 04:21:18 | Saskatchewan, Canada | ||
3740533 | 3740533 | 2020-04-03 | Canada | Saskatchewan | 220 | 3 | 0 | 217 | 52.9399 | -106.4509 | 2020-04-03 22:52:30 | Saskatchewan, Canada | ||
3737787 | 3737787 | 2020-07-12 | Canada | Saskatchewan | 815 | 15 | 757 | 43 | 52.9399 | -106.4509 | 2020-07-13 04:43:04 | Saskatchewan, Canada | ||
3734107 | 3734107 | 2020-03-20 | Canada | Saskatchewan | 20 | 0 | 0 | 52.9399 | -106.4509 | 2020-03-20T03:13:18 | ||||
3729995 | 3729995 | 2022-04-03 | Canada | Saskatchewan | 132224 | 1229 | 0 | 52.9399 | -106.4509 | 2022-04-04 04:20:51 | Saskatchewan, Canada | |||
3725979 | 3725979 | 2022-06-07 | Canada | Saskatchewan | 138707 | 1385 | 0 | 52.9399 | -106.4509 | 2022-06-08 04:20:55 | Saskatchewan, Canada | |||
3721963 | 3721963 | 2022-04-25 | Canada | Saskatchewan | 135197 | 1295 | 0 | 52.9399 | -106.4509 | 2022-04-26 04:20:51 | Saskatchewan, Canada | |||
3717947 | 3717947 | 2022-02-21 | Canada | Saskatchewan | 125780 | 1054 | 0 | 52.9399 | -106.4509 | 2022-02-22 04:21:01 | Saskatchewan, Canada | |||
3713931 | 3713931 | 2022-12-06 | Canada | Saskatchewan | 149189 | 1701 | 0 | 52.9399 | -106.4509 | 2022-12-07 04:20:58 | Saskatchewan, Canada | |||
3709916 | 3709916 | 2021-04-03 | Canada | Saskatchewan | 34323 | 436 | 31744 | 2143 | 52.9399 | -106.4509 | 2021-04-04 04:20:49 | Saskatchewan, Canada | ||
3705902 | 3705902 | 2021-07-17 | Canada | Saskatchewan | 49397 | 575 | 48462 | 360 | 52.9399 | -106.4509 | 2021-07-18 04:22:07 | Saskatchewan, Canada | ||
3701888 | 3701888 | 2021-04-27 | Canada | Saskatchewan | 40401 | 482 | 37401 | 2518 | 52.9399 | -106.4509 | 2021-04-28 04:20:32 | Saskatchewan, Canada | ||
3701563 | 3701563 | 2020-04-02 | Canada | Saskatchewan | 206 | 3 | 0 | 203 | 52.9399 | -106.4509 | 4/2/20 23:31 | Saskatchewan, Canada | ||
3695269 | 3695269 | 2020-12-31 | Canada | Saskatchewan | 15349 | 155 | 12496 | 2699 | 52.9399 | -106.4509 | 2021-01-01 05:23:07 | Saskatchewan, Canada | ||
3691258 | 3691258 | 2020-12-24 | Canada | Saskatchewan | 14254 | 134 | 10775 | 3346 | 52.9399 | -106.4509 | 2020-12-25 05:22:48 | Saskatchewan, Canada | ||
3687242 | 3687242 | 2022-01-13 | Canada | Saskatchewan | 96115 | 961 | 0 | 52.9399 | -106.4509 | 2022-01-14 04:21:54 | Saskatchewan, Canada | |||
3683228 | 3683228 | 2021-08-02 | Canada | Saskatchewan | 50096 | 578 | 49044 | 474 | 52.9399 | -106.4509 | 2021-08-03 04:21:39 | Saskatchewan, Canada | ||
3682822 | 3682822 | 2020-06-18 | Canada | Saskatchewan | 708 | 13 | 636 | 59 | 52.9399 | -106.4509 | 2020-06-19 04:33:17 | Saskatchewan, Canada | ||
3675429 | 3675429 | 2021-05-04 | Canada | Saskatchewan | 42006 | 499 | 39202 | 2305 | 52.9399 | -106.4509 | 2021-05-05 04:20:43 | Saskatchewan, Canada | ||
3671414 | 3671414 | 2022-02-15 | Canada | Saskatchewan | 125780 | 1054 | 0 | 52.9399 | -106.4509 | 2022-02-16 04:21:10 | Saskatchewan, Canada | |||
3667399 | 3667399 | 2021-03-06 | Canada | Saskatchewan | 29593 | 396 | 27584 | 1613 | 52.9399 | -106.4509 | 2021-03-07 05:21:54 | Saskatchewan, Canada | ||
3663385 | 3663385 | 2021-03-09 | Canada | Saskatchewan | 29918 | 400 | 28104 | 1414 | 52.9399 | -106.4509 | 2021-03-10 05:24:35 | Saskatchewan, Canada | ||
3659371 | 3659371 | 2021-07-11 | Canada | Saskatchewan | 49260 | 573 | 48288 | 399 | 52.9399 | -106.4509 | 2021-07-12 04:21:34 | Saskatchewan, Canada | ||
3655355 | 3655355 | 2021-12-10 | Canada | Saskatchewan | 81646 | 937 | 0 | 52.9399 | -106.4509 | 2021-12-11 04:22:45 | 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 | ||
3647345 | 3647345 | 2022-08-14 | Canada | Saskatchewan | 140291 | 1438 | 0 | 52.9399 | -106.4509 | 2022-08-15 04:20:59 | Saskatchewan, Canada | |||
3643330 | 3643330 | 2021-03-30 | Canada | Saskatchewan | 33399 | 434 | 31023 | 1942 | 52.9399 | -106.4509 | 2021-03-31 04:26:25 | Saskatchewan, Canada | ||
3639314 | 3639314 | 2021-11-08 | Canada | Saskatchewan | 78824 | 873 | 0 | 52.9399 | -106.4509 | 2021-11-09 04:21:36 | Saskatchewan, Canada | |||
3638946 | 3638946 | 2020-05-30 | Canada | Saskatchewan | 645 | 10 | 580 | 55 | 52.9399 | -106.4509 | 2020-05-31 02:32:45 | Saskatchewan, Canada | ||
3631734 | 3631734 | 2021-07-14 | Canada | Saskatchewan | 49311 | 573 | 48386 | 363 | 52.9399 | -106.4509 | 2021-07-15 04:21:48 | Saskatchewan, Canada | ||
3627719 | 3627719 | 2022-03-13 | Canada | Saskatchewan | 129301 | 1148 | 0 | 52.9399 | -106.4509 | 2022-03-14 04:20:46 | Saskatchewan, Canada | |||
3627391 | 3627391 | 2020-04-06 | Canada | Saskatchewan | 253 | 3 | 0 | 246 | 52.9399 | -106.4509 | 4/6/20 23:28 | 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]);