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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
738080 | 738080 | 2020-12-02 | Canada | Saskatchewan | 8982 | 53 | 4959 | 3970 | 52.9399 | -106.4509 | 2020-12-03 05:28:22 | Saskatchewan, Canada | ||
2537174 | 2537174 | 2020-12-01 | Canada | Saskatchewan | 8745 | 51 | 4875 | 3819 | 52.9399 | -106.4509 | 2020-12-02 05:27:41 | Saskatchewan, Canada | ||
1583943 | 1583943 | 2020-11-30 | Canada | Saskatchewan | 8564 | 47 | 4638 | 3879 | 52.9399 | -106.4509 | 2020-12-01 05:26:18 | Saskatchewan, Canada | ||
3566346 | 3566346 | 2020-11-29 | Canada | Saskatchewan | 8239 | 45 | 4589 | 3605 | 52.9399 | -106.4509 | 2020-11-30 05:26:13 | Saskatchewan, Canada | ||
2935011 | 2935011 | 2020-11-28 | Canada | Saskatchewan | 7888 | 45 | 4521 | 3322 | 52.9399 | -106.4509 | 2020-11-29 05:25:55 | Saskatchewan, Canada | ||
392014 | 392014 | 2020-11-27 | Canada | Saskatchewan | 7691 | 44 | 4384 | 3263 | 52.9399 | -106.4509 | 2020-11-28 05:25:50 | Saskatchewan, Canada | ||
923461 | 923461 | 2020-11-26 | Canada | Saskatchewan | 7362 | 40 | 4176 | 3146 | 52.9399 | -106.4509 | 2020-11-27 05:26:53 | Saskatchewan, Canada | ||
1972366 | 1972366 | 2020-11-25 | Canada | Saskatchewan | 7047 | 37 | 3998 | 3012 | 52.9399 | -106.4509 | 2020-11-26 05:27:44 | Saskatchewan, Canada | ||
1350097 | 1350097 | 2020-11-24 | Canada | Saskatchewan | 6883 | 37 | 3919 | 2927 | 52.9399 | -106.4509 | 2020-11-25 05:27:20 | Saskatchewan, Canada | ||
678091 | 678091 | 2020-11-23 | Canada | Saskatchewan | 6708 | 37 | 3807 | 2864 | 52.9399 | -106.4509 | 2020-11-24 05:27:31 | Saskatchewan, Canada | ||
3189767 | 3189767 | 2020-11-22 | Canada | Saskatchewan | 6473 | 33 | 3757 | 2683 | 52.9399 | -106.4509 | 2020-11-23 05:25:26 | 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 | ||
2701289 | 2701289 | 2020-11-20 | Canada | Saskatchewan | 5804 | 33 | 3626 | 2145 | 52.9399 | -106.4509 | 2020-11-21 05:25:51 | Saskatchewan, Canada | ||
821349 | 821349 | 2020-11-19 | Canada | Saskatchewan | 5651 | 32 | 3553 | 2066 | 52.9399 | -106.4509 | 2020-11-20 05:26:28 | Saskatchewan, Canada | ||
122483 | 122483 | 2020-11-18 | Canada | Saskatchewan | 5553 | 32 | 3422 | 2099 | 52.9399 | -106.4509 | 2020-11-19 05:25:23 | Saskatchewan, Canada | ||
3338371 | 3338371 | 2020-11-17 | Canada | Saskatchewan | 5422 | 31 | 3336 | 2055 | 52.9399 | -106.4509 | 2020-11-18 05:40:31 | Saskatchewan, Canada | ||
3169416 | 3169416 | 2020-11-16 | Canada | Saskatchewan | 5182 | 31 | 3223 | 1928 | 52.9399 | -106.4509 | 2020-11-17 05:25:54 | 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]);