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 day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1837708 | 1837708 | 2021-03-12 | Canada | Saskatchewan | 30369 | 404 | 28528 | 1437 | 52.9399 | -106.4509 | 2021-03-13 05:25:15 | Saskatchewan, Canada | ||
352073 | 352073 | 2021-03-11 | Canada | Saskatchewan | 30193 | 401 | 28397 | 1395 | 52.9399 | -106.4509 | 2021-03-12 05:26:50 | 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 | ||
3663385 | 3663385 | 2021-03-09 | Canada | Saskatchewan | 29918 | 400 | 28104 | 1414 | 52.9399 | -106.4509 | 2021-03-10 05:24:35 | Saskatchewan, Canada | ||
2359244 | 2359244 | 2021-03-08 | Canada | Saskatchewan | 29805 | 399 | 27944 | 1463 | 52.9399 | -106.4509 | 2021-03-09 05:28:19 | Saskatchewan, Canada | ||
54582 | 54582 | 2021-03-07 | Canada | Saskatchewan | 29709 | 398 | 27793 | 1518 | 52.9399 | -106.4509 | 2021-03-08 05:24:48 | 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 | ||
1616020 | 1616020 | 2021-03-05 | Canada | Saskatchewan | 29430 | 393 | 27532 | 1507 | 52.9399 | -106.4509 | 2021-03-06 04:23:41 | Saskatchewan, Canada | ||
2207431 | 2207431 | 2021-03-04 | Canada | Saskatchewan | 29220 | 391 | 27407 | 1422 | 52.9399 | -106.4509 | 2021-03-05 05:26:29 | Saskatchewan, Canada | ||
1089852 | 1089852 | 2021-03-03 | Canada | Saskatchewan | 29059 | 389 | 27239 | 1431 | 52.9399 | -106.4509 | 2021-03-04 05:24:24 | Saskatchewan, Canada | ||
3253924 | 3253924 | 2021-03-02 | Canada | Saskatchewan | 28938 | 387 | 27059 | 1492 | 52.9399 | -106.4509 | 2021-03-03 05:23:28 | Saskatchewan, Canada | ||
998216 | 998216 | 2021-03-01 | Canada | Saskatchewan | 28801 | 385 | 26865 | 1551 | 52.9399 | -106.4509 | 2021-03-02 05:23:30 | Saskatchewan, Canada | ||
2367274 | 2367274 | 2021-02-28 | Canada | Saskatchewan | 28647 | 385 | 26719 | 1543 | 52.9399 | -106.4509 | 2021-03-01 05:23:01 | Saskatchewan, Canada | ||
3065776 | 3065776 | 2021-02-27 | Canada | Saskatchewan | 28506 | 385 | 26573 | 1548 | 52.9399 | -106.4509 | 2021-02-28 05:22:20 | Saskatchewan, Canada | ||
2183360 | 2183360 | 2021-02-26 | Canada | Saskatchewan | 28344 | 380 | 26454 | 1510 | 52.9399 | -106.4509 | 2021-02-27 05:22:28 | Saskatchewan, Canada | ||
1857782 | 1857782 | 2021-02-25 | Canada | Saskatchewan | 28191 | 380 | 26318 | 1493 | 52.9399 | -106.4509 | 2021-02-26 05:22:40 | Saskatchewan, Canada | ||
279960 | 279960 | 2021-02-24 | Canada | Saskatchewan | 27980 | 379 | 26176 | 1425 | 52.9399 | -106.4509 | 2021-02-25 05:24:57 | Saskatchewan, Canada | ||
1936228 | 1936228 | 2021-02-23 | Canada | Saskatchewan | 27923 | 376 | 26017 | 1530 | 52.9399 | -106.4509 | 2021-02-24 05:29:16 | Saskatchewan, Canada | ||
530483 | 530483 | 2021-02-22 | Canada | Saskatchewan | 27797 | 372 | 25773 | 1652 | 52.9399 | -106.4509 | 2021-02-23 05:23:41 | Saskatchewan, Canada | ||
181817 | 181817 | 2021-02-21 | Canada | Saskatchewan | 27620 | 372 | 25578 | 1670 | 52.9399 | -106.4509 | 2021-02-22 05:24:21 | Saskatchewan, Canada | ||
742091 | 742091 | 2021-02-20 | Canada | Saskatchewan | 27438 | 368 | 25468 | 1602 | 52.9399 | -106.4509 | 2021-02-21 05:24:33 | Saskatchewan, Canada | ||
471189 | 471189 | 2021-02-19 | Canada | Saskatchewan | 27245 | 365 | 25298 | 1582 | 52.9399 | -106.4509 | 2021-02-20 05:22:51 | Saskatchewan, Canada | ||
1152899 | 1152899 | 2021-02-18 | Canada | Saskatchewan | 27099 | 362 | 25221 | 1516 | 52.9399 | -106.4509 | 2021-02-19 05:24:16 | Saskatchewan, Canada | ||
3600819 | 3600819 | 2021-02-17 | Canada | Saskatchewan | 26953 | 362 | 25050 | 1541 | 52.9399 | -106.4509 | 2021-02-18 05:22:58 | Saskatchewan, Canada | ||
3049954 | 3049954 | 2021-02-16 | Canada | Saskatchewan | 26829 | 357 | 24861 | 1611 | 52.9399 | -106.4509 | 2021-02-17 05:23:10 | Saskatchewan, Canada | ||
1338053 | 1338053 | 2021-02-15 | Canada | Saskatchewan | 26693 | 354 | 24332 | 1864 | 52.9399 | -106.4509 | 2021-02-16 05:24:38 | Saskatchewan, Canada | ||
2283204 | 2283204 | 2021-02-14 | Canada | Saskatchewan | 26550 | 354 | 24332 | 1864 | 52.9399 | -106.4509 | 2021-02-15 05:24:49 | Saskatchewan, Canada | ||
2677604 | 2677604 | 2021-02-13 | Canada | Saskatchewan | 26389 | 354 | 24085 | 1950 | 52.9399 | -106.4509 | 2021-02-14 05:23:43 | Saskatchewan, Canada | ||
3539237 | 3539237 | 2021-02-12 | Canada | Saskatchewan | 26145 | 350 | 23895 | 1900 | 52.9399 | -106.4509 | 2021-02-13 05:22:12 | Saskatchewan, Canada | ||
2637500 | 2637500 | 2021-02-11 | Canada | Saskatchewan | 25957 | 348 | 23674 | 1935 | 52.9399 | -106.4509 | 2021-02-12 05:23:29 | 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 | ||
1527675 | 1527675 | 2021-02-09 | Canada | Saskatchewan | 25654 | 346 | 23282 | 2026 | 52.9399 | -106.4509 | 2021-02-10 05:22:41 | Saskatchewan, Canada | ||
613466 | 613466 | 2021-02-08 | Canada | Saskatchewan | 25574 | 341 | 23029 | 2204 | 52.9399 | -106.4509 | 2021-02-09 05:23:30 | Saskatchewan, Canada | ||
1672235 | 1672235 | 2021-02-07 | Canada | Saskatchewan | 25403 | 339 | 22701 | 2363 | 52.9399 | -106.4509 | 2021-02-08 05:22:39 | Saskatchewan, Canada | ||
974696 | 974696 | 2021-02-06 | Canada | Saskatchewan | 25209 | 336 | 22460 | 2413 | 52.9399 | -106.4509 | 2021-02-07 05:23:00 | Saskatchewan, Canada | ||
1587954 | 1587954 | 2021-02-05 | Canada | Saskatchewan | 24946 | 332 | 22315 | 2299 | 52.9399 | -106.4509 | 2021-02-06 05:23:55 | Saskatchewan, Canada | ||
790161 | 790161 | 2021-02-04 | Canada | Saskatchewan | 24680 | 329 | 22086 | 2265 | 52.9399 | -106.4509 | 2021-02-05 05:22:38 | Saskatchewan, Canada | ||
340053 | 340053 | 2021-02-03 | Canada | Saskatchewan | 24430 | 322 | 21854 | 2254 | 52.9399 | -106.4509 | 2021-02-04 05:22:26 | Saskatchewan, Canada | ||
1684279 | 1684279 | 2021-02-02 | Canada | Saskatchewan | 24236 | 314 | 21602 | 2320 | 52.9399 | -106.4509 | 2021-02-03 05:22:52 | Saskatchewan, Canada | ||
1676249 | 1676249 | 2021-02-01 | Canada | Saskatchewan | 24011 | 306 | 21336 | 2369 | 52.9399 | -106.4509 | 2021-02-02 05:22:49 | Saskatchewan, Canada | ||
1459537 | 1459537 | 2021-01-31 | Canada | Saskatchewan | 23864 | 304 | 19729 | 3831 | 52.9399 | -106.4509 | 2021-02-01 05:22:53 | Saskatchewan, Canada | ||
2211445 | 2211445 | 2021-01-30 | Canada | Saskatchewan | 23626 | 300 | 19729 | 3597 | 52.9399 | -106.4509 | 2021-01-31 05:22:42 | Saskatchewan, Canada | ||
1896932 | 1896932 | 2021-01-29 | Canada | Saskatchewan | 23366 | 292 | 19729 | 3345 | 52.9399 | -106.4509 | 2021-01-30 05:22:49 | Saskatchewan, Canada | ||
2481748 | 2481748 | 2021-01-28 | Canada | Saskatchewan | 23038 | 285 | 19729 | 3024 | 52.9399 | -106.4509 | 2021-01-29 05:22:23 | Saskatchewan, Canada | ||
3153383 | 3153383 | 2021-01-27 | Canada | Saskatchewan | 22794 | 274 | 19729 | 2791 | 52.9399 | -106.4509 | 2021-01-28 05:22:24 | Saskatchewan, Canada | ||
12118 | 12118 | 2021-01-26 | Canada | Saskatchewan | 22646 | 268 | 19729 | 2649 | 52.9399 | -106.4509 | 2021-01-27 05:23:41 | Saskatchewan, Canada | ||
2567442 | 2567442 | 2021-01-25 | Canada | Saskatchewan | 22416 | 254 | 18890 | 3272 | 52.9399 | -106.4509 | 2021-01-26 05:22:02 | Saskatchewan, Canada | ||
1759074 | 1759074 | 2021-01-24 | Canada | Saskatchewan | 22177 | 253 | 18673 | 3251 | 52.9399 | -106.4509 | 2021-01-25 05:22:16 | Saskatchewan, Canada | ||
2426681 | 2426681 | 2021-01-23 | Canada | Saskatchewan | 21917 | 250 | 18506 | 3161 | 52.9399 | -106.4509 | 2021-01-24 05:22:35 | Saskatchewan, Canada | ||
2466583 | 2466583 | 2021-01-22 | Canada | Saskatchewan | 21643 | 247 | 18200 | 3196 | 52.9399 | -106.4509 | 2021-01-23 05:22:03 | Saskatchewan, Canada | ||
435134 | 435134 | 2021-01-21 | Canada | Saskatchewan | 21338 | 239 | 18000 | 3099 | 52.9399 | -106.4509 | 2021-01-22 05:22:10 | Saskatchewan, Canada | ||
1093866 | 1093866 | 2021-01-20 | Canada | Saskatchewan | 21112 | 226 | 17184 | 3702 | 52.9399 | -106.4509 | 2021-01-21 05:22:01 | Saskatchewan, Canada | ||
907956 | 907956 | 2021-01-19 | Canada | Saskatchewan | 20871 | 225 | 16490 | 4156 | 52.9399 | -106.4509 | 2021-01-20 05:21:54 | Saskatchewan, Canada | ||
237019 | 237019 | 2021-01-18 | Canada | Saskatchewan | 20562 | 219 | 16078 | 4265 | 52.9399 | -106.4509 | 2021-01-19 05:22:15 | Saskatchewan, Canada | ||
3503136 | 3503136 | 2021-01-17 | Canada | Saskatchewan | 20272 | 215 | 15936 | 4121 | 52.9399 | -106.4509 | 2021-01-18 05:22:34 | Saskatchewan, Canada | ||
3101219 | 3101219 | 2021-01-16 | Canada | Saskatchewan | 19985 | 212 | 15730 | 4043 | 52.9399 | -106.4509 | 2021-01-17 05:22:17 | Saskatchewan, Canada | ||
3515181 | 3515181 | 2021-01-15 | Canada | Saskatchewan | 19715 | 210 | 15495 | 4010 | 52.9399 | -106.4509 | 2021-01-16 05:22:40 | 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 | ||
3307981 | 3307981 | 2021-01-13 | Canada | Saskatchewan | 19021 | 206 | 15063 | 3748 | 52.9399 | -106.4509 | 2021-01-14 05:22:32 | Saskatchewan, Canada | ||
774126 | 774126 | 2021-01-12 | Canada | Saskatchewan | 18774 | 204 | 14814 | 3752 | 52.9399 | -106.4509 | 2021-01-13 05:22:15 | Saskatchewan, Canada | ||
189847 | 189847 | 2021-01-11 | Canada | Saskatchewan | 18526 | 199 | 14588 | 3735 | 52.9399 | -106.4509 | 2021-01-12 05:22:15 | Saskatchewan, Canada | ||
2625650 | 2625650 | 2021-01-10 | Canada | Saskatchewan | 18114 | 191 | 14426 | 3186 | 52.9399 | -106.4509 | 2021-01-11 05: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 | ||
153761 | 153761 | 2021-01-08 | Canada | Saskatchewan | 17475 | 184 | 14237 | 3053 | 52.9399 | -106.4509 | 2021-01-09 05:22:18 | Saskatchewan, Canada | ||
2541185 | 2541185 | 2021-01-07 | Canada | Saskatchewan | 17139 | 177 | 14014 | 2947 | 52.9399 | -106.4509 | 2021-01-08 05:22:42 | Saskatchewan, Canada | ||
2864494 | 2864494 | 2021-01-06 | Canada | Saskatchewan | 16804 | 174 | 13737 | 2893 | 52.9399 | -106.4509 | 2021-01-07 05:22:03 | Saskatchewan, Canada | ||
3034081 | 3034081 | 2021-01-05 | Canada | Saskatchewan | 16520 | 165 | 13298 | 3057 | 52.9399 | -106.4509 | 2021-01-06 05:22:16 | Saskatchewan, Canada | ||
1061626 | 1061626 | 2021-01-04 | Canada | Saskatchewan | 16367 | 160 | 13180 | 3027 | 52.9399 | -106.4509 | 2021-01-05 05:21:49 | Saskatchewan, Canada | ||
3230229 | 3230229 | 2021-01-03 | Canada | Saskatchewan | 16080 | 158 | 13084 | 2841 | 52.9399 | -106.4509 | 2021-01-04 05:22:02 | Saskatchewan, Canada | ||
2227299 | 2227299 | 2021-01-02 | Canada | Saskatchewan | 15844 | 158 | 12975 | 2712 | 52.9399 | -106.4509 | 2021-01-03 05:22:52 | Saskatchewan, Canada | ||
1136663 | 1136663 | 2021-01-01 | Canada | Saskatchewan | 15634 | 155 | 12496 | 2699 | 52.9399 | -106.4509 | 2021-01-02 05:22:33 | 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 | ||
1010084 | 1010084 | 2020-12-30 | Canada | Saskatchewan | 15159 | 154 | 12057 | 2949 | 52.9399 | -106.4509 | 2020-12-31 05:22:49 | Saskatchewan, Canada | ||
766099 | 766099 | 2020-12-29 | Canada | Saskatchewan | 15021 | 151 | 11680 | 3191 | 52.9399 | -106.4509 | 2020-12-30 05:22:34 | Saskatchewan, Canada | ||
3761363 | 3761363 | 2020-12-28 | Canada | Saskatchewan | 14907 | 141 | 11275 | 3398 | 52.9399 | -106.4509 | 2020-12-29 05:22:37 | 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 | ||
2223288 | 2223288 | 2020-12-26 | Canada | Saskatchewan | 14615 | 134 | 10775 | 3346 | 52.9399 | -106.4509 | 2020-12-27 05:22:55 | Saskatchewan, Canada | ||
202035 | 202035 | 2020-12-25 | Canada | Saskatchewan | 14483 | 134 | 10775 | 3346 | 52.9399 | -106.4509 | 2020-12-26 05:22:28 | 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 | ||
2406610 | 2406610 | 2020-12-23 | Canada | Saskatchewan | 14100 | 130 | 10121 | 3850 | 52.9399 | -106.4509 | 2020-12-24 05:23:04 | 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 | ||
927472 | 927472 | 2020-12-21 | Canada | Saskatchewan | 13759 | 122 | 9649 | 3990 | 52.9399 | -106.4509 | 2020-12-22 05:22:33 | Saskatchewan, Canada | ||
2119493 | 2119493 | 2020-12-20 | Canada | Saskatchewan | 13553 | 118 | 9557 | 3880 | 52.9399 | -106.4509 | 2020-12-21 05:27:58 | Saskatchewan, Canada | ||
2931000 | 2931000 | 2020-12-19 | Canada | Saskatchewan | 13327 | 115 | 9452 | 3762 | 52.9399 | -106.4509 | 2020-12-20 05:27:32 | Saskatchewan, Canada | ||
1900946 | 1900946 | 2020-12-18 | Canada | Saskatchewan | 13075 | 107 | 9234 | 3736 | 52.9399 | -106.4509 | 2020-12-19 05:27:52 | Saskatchewan, Canada | ||
2127772 | 2127772 | 2020-12-17 | Canada | Saskatchewan | 12830 | 105 | 8749 | 3978 | 52.9399 | -106.4509 | 2020-12-18 05:28:18 | Saskatchewan, Canada | ||
3149372 | 3149372 | 2020-12-16 | Canada | Saskatchewan | 12592 | 98 | 8283 | 4213 | 52.9399 | -106.4509 | 2020-12-17 05:28:12 | Saskatchewan, Canada | ||
1034153 | 1034153 | 2020-12-15 | Canada | Saskatchewan | 12430 | 98 | 8130 | 4204 | 52.9399 | -106.4509 | 2020-12-16 05:28:04 | Saskatchewan, Canada | ||
1751047 | 1751047 | 2020-12-14 | Canada | Saskatchewan | 12236 | 91 | 7767 | 4380 | 52.9399 | -106.4509 | 2020-12-15 05:26:38 | 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 | ||
845349 | 845349 | 2020-12-12 | Canada | Saskatchewan | 11747 | 86 | 7566 | 4097 | 52.9399 | -106.4509 | 2020-12-13 05:27:20 | Saskatchewan, Canada | ||
860456 | 860456 | 2020-12-11 | Canada | Saskatchewan | 11473 | 75 | 6853 | 4547 | 52.9399 | -106.4509 | 2020-12-12 05:26:19 | Saskatchewan, Canada | ||
1599998 | 1599998 | 2020-12-10 | Canada | Saskatchewan | 11222 | 75 | 6466 | 4682 | 52.9399 | -106.4509 | 2020-12-11 05:26:59 | Saskatchewan, Canada | ||
2975007 | 2975007 | 2020-12-09 | Canada | Saskatchewan | 10898 | 71 | 6121 | 4707 | 52.9399 | -106.4509 | 2020-12-10 05:26:19 | Saskatchewan, Canada | ||
1818567 | 1818567 | 2020-12-08 | Canada | Saskatchewan | 10596 | 66 | 5868 | 4663 | 52.9399 | -106.4509 | 2020-12-09 05:28:01 | Saskatchewan, Canada | ||
2347203 | 2347203 | 2020-12-07 | Canada | Saskatchewan | 10411 | 60 | 5589 | 4763 | 52.9399 | -106.4509 | 2020-12-08 05:27:42 | Saskatchewan, Canada | ||
1006073 | 1006073 | 2020-12-06 | Canada | Saskatchewan | 10138 | 59 | 5530 | 4550 | 52.9399 | -106.4509 | 2020-12-07 05:26:14 | Saskatchewan, Canada | ||
1632082 | 1632082 | 2020-12-05 | Canada | Saskatchewan | 9729 | 55 | 5484 | 4191 | 52.9399 | -106.4509 | 2020-12-06 05:26:18 | 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 | ||
74868 | 74868 | 2020-12-03 | Canada | Saskatchewan | 9243 | 54 | 5173 | 4017 | 52.9399 | -106.4509 | 2020-12-04 05:27:27 | 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]);