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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
2879984 | 2879984 | 2020-11-15 | Canada | Saskatchewan | 5001 | 31 | 3163 | 1807 | 52.9399 | -106.4509 | 2020-11-16 05:25:57 | Saskatchewan, Canada | ||
2914962 | 2914962 | 2020-11-14 | Canada | Saskatchewan | 4820 | 29 | 3100 | 1691 | 52.9399 | -106.4509 | 2020-11-15 05:26:53 | Saskatchewan, Canada | ||
2784784 | 2784784 | 2020-11-13 | Canada | Saskatchewan | 4513 | 29 | 3057 | 1427 | 52.9399 | -106.4509 | 2020-11-14 05:25:37 | Saskatchewan, Canada | ||
864549 | 864549 | 2020-11-12 | Canada | Saskatchewan | 4437 | 29 | 2949 | 1459 | 52.9399 | -106.4509 | 2020-11-13 05:25:30 | Saskatchewan, Canada | ||
3440594 | 3440594 | 2020-11-11 | Canada | Saskatchewan | 4326 | 29 | 2934 | 1363 | 52.9399 | -106.4509 | 2020-11-12 05:25:55 | Saskatchewan, Canada | ||
271934 | 271934 | 2020-11-10 | Canada | Saskatchewan | 4214 | 29 | 2880 | 1305 | 52.9399 | -106.4509 | 2020-11-11 05:25:30 | Saskatchewan, Canada | ||
1988411 | 1988411 | 2020-11-09 | Canada | Saskatchewan | 4087 | 29 | 2769 | 1289 | 52.9399 | -106.4509 | 2020-11-10 05:40:07 | Saskatchewan, Canada | ||
1728263 | 1728263 | 2020-11-08 | Canada | Saskatchewan | 3897 | 28 | 2747 | 1122 | 52.9399 | -106.4509 | 2020-11-09 05:25:45 | Saskatchewan, Canada | ||
1543723 | 1543723 | 2020-11-07 | Canada | Saskatchewan | 3738 | 27 | 2726 | 985 | 52.9399 | -106.4509 | 2020-11-08 05:24:56 | Saskatchewan, 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 | ||
2601813 | 2601813 | 2020-10-10 | Canada | Saskatchewan | 2068 | 24 | 1883 | 161 | 52.9399 | -106.4509 | 2020-10-11 04:23:46 | Saskatchewan, Canada | ||
817346 | 817346 | 2020-10-09 | Canada | Saskatchewan | 2034 | 24 | 1871 | 139 | 52.9399 | -106.4509 | 2020-10-10 04:23:57 | 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]);