johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,026 rows where country_or_region = "Canada" and province_or_state = "Alberta" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
last_update (date) >30 ✖
- 2020-03-11 3
- 2020-03-09 2
- 2020-03-14 1
- 2020-03-15 1
- 2020-03-16 1
- 2020-03-17 1
- 2020-03-18 1
- 2020-03-19 1
- 2020-03-20 1
- 2020-03-21 1
- 2020-03-23 1
- 2020-03-24 1
- 2020-03-25 1
- 2020-03-26 1
- 2020-03-27 1
- 2020-03-31 1
- 2020-04-01 1
- 2020-04-03 1
- 2020-04-05 1
- 2020-04-07 1
- 2020-04-08 1
- 2020-04-09 1
- 2020-04-10 1
- 2020-04-11 1
- 2020-04-12 1
- 2020-04-13 1
- 2020-04-14 1
- 2020-04-15 1
- 2020-04-16 1
- 2020-04-17 1
- …
province_or_state 1
- Alberta · 462 ✖
country_or_region 1
- Canada · 462 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3381138 | 3381138 | 2021-06-13 | Canada | Alberta | 230463 | 2270 | 225013 | 3180 | 53.9333 | -116.5765 | 2021-06-14 04:22:46 | Alberta, Canada | ||
1736272 | 1736272 | 2021-06-12 | Canada | Alberta | 230298 | 2269 | 224782 | 3247 | 53.9333 | -116.5765 | 2021-06-13 04:22:44 | Alberta, Canada | ||
3970313 | 3970313 | 2021-06-11 | Canada | Alberta | 230119 | 2265 | 224325 | 3529 | 53.9333 | -116.5765 | 2021-06-12 04:22:22 | Alberta, Canada | ||
2716735 | 2716735 | 2021-06-10 | Canada | Alberta | 229949 | 2262 | 223877 | 3810 | 53.9333 | -116.5765 | 2021-06-11 04:23:20 | Alberta, Canada | ||
522620 | 522620 | 2021-06-09 | Canada | Alberta | 229771 | 2256 | 223311 | 4204 | 53.9333 | -116.5765 | 2021-06-10 04:23:17 | Alberta, Canada | ||
3472060 | 3472060 | 2021-06-08 | Canada | Alberta | 229458 | 2251 | 222776 | 4431 | 53.9333 | -116.5765 | 2021-06-09 04:23:31 | Alberta, Canada | ||
3145344 | 3145344 | 2021-06-07 | Canada | Alberta | 229319 | 2248 | 222364 | 4707 | 53.9333 | -116.5765 | 2021-06-08 04:22:35 | Alberta, Canada | ||
825346 | 825346 | 2021-06-06 | Canada | Alberta | 229192 | 2246 | 222062 | 4884 | 53.9333 | -116.5765 | 2021-06-07 04:22:51 | Alberta, Canada | ||
2585751 | 2585751 | 2021-06-05 | Canada | Alberta | 228961 | 2246 | 221644 | 5071 | 53.9333 | -116.5765 | 2021-06-06 04:24:03 | Alberta, Canada | ||
2315065 | 2315065 | 2021-06-04 | Canada | Alberta | 228668 | 2243 | 221010 | 5415 | 53.9333 | -116.5765 | 2021-06-05 04:23:03 | Alberta, Canada | ||
1448350 | 1448350 | 2021-06-03 | Canada | Alberta | 228424 | 2236 | 220357 | 5831 | 53.9333 | -116.5765 | 2021-06-04 04:23:37 | Alberta, Canada | ||
1708074 | 1708074 | 2021-06-02 | Canada | Alberta | 228128 | 2231 | 219592 | 6305 | 53.9333 | -116.5765 | 2021-06-03 04:23:32 | Alberta, Canada | ||
2103892 | 2103892 | 2021-06-01 | Canada | Alberta | 227718 | 2228 | 218719 | 6771 | 53.9333 | -116.5765 | 2021-06-02 04:24:34 | Alberta, Canada | ||
1188508 | 1188508 | 2021-05-31 | Canada | Alberta | 227509 | 2227 | 217636 | 7646 | 53.9333 | -116.5765 | 2021-06-01 04:23:09 | Alberta, Canada | ||
3089185 | 3089185 | 2021-05-30 | Canada | Alberta | 227246 | 2219 | 216954 | 8073 | 53.9333 | -116.5765 | 2021-05-31 03:08:59 | Alberta, Canada | ||
50554 | 50554 | 2021-05-29 | Canada | Alberta | 226855 | 2214 | 216167 | 8474 | 53.9333 | -116.5765 | 2021-05-30 04:20:55 | Alberta, Canada | ||
20133 | 20133 | 2021-05-28 | Canada | Alberta | 226449 | 2206 | 214966 | 9277 | 53.9333 | -116.5765 | 2021-05-29 04:20:41 | Alberta, Canada | ||
1806508 | 1806508 | 2021-05-27 | Canada | Alberta | 225937 | 2199 | 213721 | 10017 | 53.9333 | -116.5765 | 2021-05-28 04:20:36 | Alberta, Canada | ||
1309932 | 1309932 | 2021-05-26 | Canada | Alberta | 225424 | 2198 | 212273 | 10953 | 53.9333 | -116.5765 | 2021-05-27 04:20:59 | Alberta, Canada | ||
82858 | 82858 | 2021-05-25 | Canada | Alberta | 225034 | 2192 | 210764 | 12078 | 53.9333 | -116.5765 | 2021-05-26 04:20:35 | Alberta, Canada | ||
1412820 | 1412820 | 2021-05-24 | Canada | Alberta | 224647 | 2183 | 208856 | 13608 | 53.9333 | -116.5765 | 2021-05-25 04:21:08 | Alberta, Canada | ||
1771106 | 1771106 | 2021-05-23 | Canada | Alberta | 224195 | 2176 | 207486 | 14533 | 53.9333 | -116.5765 | 2021-05-24 04:20:53 | Alberta, Canada | ||
726261 | 726261 | 2021-05-22 | Canada | Alberta | 223632 | 2170 | 205960 | 15502 | 53.9333 | -116.5765 | 2021-05-23 04:20:51 | Alberta, Canada | ||
1952276 | 1952276 | 2021-05-21 | Canada | Alberta | 223011 | 2164 | 204270 | 16577 | 53.9333 | -116.5765 | 2021-05-22 04:20:45 | Alberta, Canada | ||
1912975 | 1912975 | 2021-05-20 | Canada | Alberta | 222279 | 2162 | 202442 | 17675 | 53.9333 | -116.5765 | 2021-05-21 04:20:43 | Alberta, Canada | ||
2255496 | 2255496 | 2021-05-19 | Canada | Alberta | 221467 | 2158 | 200496 | 18813 | 53.9333 | -116.5765 | 2021-05-20 04:21:05 | Alberta, Canada | ||
2390534 | 2390534 | 2021-05-18 | Canada | Alberta | 220559 | 2152 | 198394 | 20013 | 53.9333 | -116.5765 | 2021-05-19 04:20:42 | Alberta, Canada | ||
3574359 | 3574359 | 2021-05-17 | Canada | Alberta | 219682 | 2148 | 196246 | 21288 | 53.9333 | -116.5765 | 2021-05-18 04:20:33 | Alberta, Canada | ||
2939089 | 2939089 | 2021-05-16 | Canada | Alberta | 218961 | 2143 | 194538 | 22280 | 53.9333 | -116.5765 | 2021-05-17 04:20:34 | Alberta, Canada | ||
1872719 | 1872719 | 2021-05-15 | Canada | Alberta | 217821 | 2140 | 192688 | 22993 | 53.9333 | -116.5765 | 2021-05-16 04:20:49 | Alberta, Canada | ||
1081688 | 1081688 | 2021-05-14 | Canada | Alberta | 216626 | 2137 | 190616 | 23873 | 53.9333 | -116.5765 | 2021-05-15 04:20:58 | Alberta, Canada | ||
3053954 | 3053954 | 2021-05-13 | Canada | Alberta | 215193 | 2132 | 188475 | 24586 | 53.9333 | -116.5765 | 2021-05-14 04:20:41 | Alberta, Canada | ||
2004424 | 2004424 | 2021-05-12 | Canada | Alberta | 213635 | 2123 | 186550 | 24962 | 53.9333 | -116.5765 | 2021-05-13 04:20:51 | Alberta, Canada | ||
3954255 | 3954255 | 2021-05-11 | Canada | Alberta | 211836 | 2119 | 184719 | 24998 | 53.9333 | -116.5765 | 2021-05-12 04:21:29 | Alberta, Canada | ||
2820534 | 2820534 | 2021-05-10 | Canada | Alberta | 210387 | 2117 | 182832 | 25438 | 53.9333 | -116.5765 | 2021-05-11 04:20:41 | Alberta, Canada | ||
1424866 | 1424866 | 2021-05-09 | Canada | Alberta | 208790 | 2110 | 181483 | 25197 | 53.9333 | -116.5765 | 2021-05-10 04:20:38 | Alberta, Canada | ||
1551734 | 1551734 | 2021-05-08 | Canada | Alberta | 207157 | 2108 | 179894 | 25155 | 53.9333 | -116.5765 | 2021-05-09 04:20:35 | Alberta, Canada | ||
2501792 | 2501792 | 2021-05-07 | Canada | Alberta | 205115 | 2106 | 178149 | 24860 | 53.9333 | -116.5765 | 2021-05-08 04:21:04 | Alberta, Canada | ||
3113248 | 3113248 | 2021-05-06 | Canada | Alberta | 203135 | 2102 | 176536 | 24497 | 53.9333 | -116.5765 | 2021-05-07 04:20:40 | Alberta, Canada | ||
645715 | 645715 | 2021-05-05 | Canada | Alberta | 200924 | 2102 | 174666 | 24156 | 53.9333 | -116.5765 | 2021-05-06 04:20:38 | Alberta, Canada | ||
3675415 | 3675415 | 2021-05-04 | Canada | Alberta | 198653 | 2099 | 172931 | 23623 | 53.9333 | -116.5765 | 2021-05-05 04:20:43 | Alberta, Canada | ||
2760682 | 2760682 | 2021-05-03 | Canada | Alberta | 196910 | 2090 | 171212 | 23608 | 53.9333 | -116.5765 | 2021-05-04 04:20:34 | Alberta, Canada | ||
2450535 | 2450535 | 2021-05-02 | Canada | Alberta | 194898 | 2086 | 169892 | 22920 | 53.9333 | -116.5765 | 2021-05-03 04:20:39 | Alberta, Canada | ||
2824548 | 2824548 | 2021-05-01 | Canada | Alberta | 193167 | 2083 | 168580 | 22504 | 53.9333 | -116.5765 | 2021-05-02 04:20:48 | Alberta, Canada | ||
379956 | 379956 | 2021-04-30 | Canada | Alberta | 190734 | 2082 | 166824 | 21828 | 53.9333 | -116.5765 | 2021-05-01 04:20:47 | Alberta, Canada | ||
1636079 | 1636079 | 2021-04-29 | Canada | Alberta | 188727 | 2075 | 165267 | 21385 | 53.9333 | -116.5765 | 2021-04-30 04:21:03 | Alberta, Canada | ||
3393158 | 3393158 | 2021-04-28 | Canada | Alberta | 186679 | 2073 | 163668 | 20938 | 53.9333 | -116.5765 | 2021-04-29 04:20:55 | Alberta, Canada | ||
3701874 | 3701874 | 2021-04-27 | Canada | Alberta | 184840 | 2067 | 162052 | 20721 | 53.9333 | -116.5765 | 2021-04-28 04:20:32 | Alberta, Canada | ||
887883 | 887883 | 2021-04-26 | Canada | Alberta | 183301 | 2074 | 160617 | 20610 | 53.9333 | -116.5765 | 2021-04-27 04:20:52 | Alberta, Canada | ||
954628 | 954628 | 2021-04-25 | Canada | Alberta | 181806 | 2067 | 159603 | 20136 | 53.9333 | -116.5765 | 2021-04-26 04:21:04 | Alberta, Canada | ||
3923775 | 3923775 | 2021-04-24 | Canada | Alberta | 180369 | 2064 | 158603 | 19702 | 53.9333 | -116.5765 | 2021-04-25 04:20:32 | Alberta, Canada | ||
1408806 | 1408806 | 2021-04-23 | Canada | Alberta | 178777 | 2059 | 157272 | 19446 | 53.9333 | -116.5765 | 2021-04-24 04:20:38 | Alberta, Canada | ||
1567869 | 1567869 | 2021-04-22 | Canada | Alberta | 177087 | 2054 | 155851 | 19182 | 53.9333 | -116.5765 | 2021-04-23 04:20:52 | Alberta, Canada | ||
3242090 | 3242090 | 2021-04-21 | Canada | Alberta | 175230 | 2048 | 153002 | 20180 | 53.9333 | -116.5765 | 2021-04-22 04:20:53 | Alberta, Canada | ||
2020486 | 2020486 | 2021-04-20 | Canada | Alberta | 173531 | 2048 | 153002 | 18481 | 53.9333 | -116.5765 | 2021-04-21 04:21:14 | Alberta, Canada | ||
2410607 | 2410607 | 2021-04-19 | Canada | Alberta | 172186 | 2043 | 151719 | 18424 | 53.9333 | -116.5765 | 2021-04-20 04:20:41 | Alberta, Canada | ||
3129284 | 3129284 | 2021-04-18 | Canada | Alberta | 170795 | 2040 | 150820 | 17935 | 53.9333 | -116.5765 | 2021-04-19 04:20:57 | Alberta, Canada | ||
982712 | 982712 | 2021-04-17 | Canada | Alberta | 169279 | 2037 | 149935 | 17307 | 53.9333 | -116.5765 | 2021-04-18 04:20:41 | Alberta, Canada | ||
169807 | 169807 | 2021-04-16 | Canada | Alberta | 167793 | 2034 | 149000 | 16759 | 53.9333 | -116.5765 | 2021-04-17 04:20:40 | Alberta, Canada | ||
2548638 | 2548638 | 2021-04-15 | Canada | Alberta | 166177 | 2034 | 147920 | 16223 | 53.9333 | -116.5765 | 2021-04-16 04:20:46 | Alberta, Canada | ||
1841708 | 1841708 | 2021-04-14 | Canada | Alberta | 164531 | 2029 | 146933 | 15569 | 53.9333 | -116.5765 | 2021-04-15 04:20:54 | Alberta, Canada | ||
2571442 | 2571442 | 2021-04-13 | Canada | Alberta | 163119 | 2021 | 146011 | 15087 | 53.9333 | -116.5765 | 2021-04-14 04:20:41 | Alberta, Canada | ||
36193 | 36193 | 2021-04-12 | Canada | Alberta | 162038 | 2018 | 145171 | 14849 | 53.9333 | -116.5765 | 2021-04-13 04:20:37 | Alberta, Canada | ||
3883352 | 3883352 | 2021-04-11 | Canada | Alberta | 160902 | 2013 | 144596 | 14293 | 53.9333 | -116.5765 | 2021-04-12 04:21:00 | Alberta, Canada | ||
2983020 | 2983020 | 2021-04-10 | Canada | Alberta | 159719 | 2012 | 144020 | 13687 | 53.9333 | -116.5765 | 2021-04-11 04:20:56 | Alberta, Canada | ||
605452 | 605452 | 2021-04-09 | Canada | Alberta | 158426 | 2007 | 143360 | 13059 | 53.9333 | -116.5765 | 2021-04-10 04:20:59 | Alberta, Canada | ||
2645516 | 2645516 | 2021-04-08 | Canada | Alberta | 156905 | 2005 | 142713 | 12187 | 53.9333 | -116.5765 | 2021-04-09 04:21:13 | Alberta, Canada | ||
2247158 | 2247158 | 2021-04-07 | Canada | Alberta | 155476 | 2002 | 142010 | 11464 | 53.9333 | -116.5765 | 2021-04-08 04:21:13 | Alberta, Canada | ||
3003068 | 3003068 | 2021-04-06 | Canada | Alberta | 154125 | 2001 | 141315 | 10809 | 53.9333 | -116.5765 | 2021-04-07 04:20:53 | Alberta, Canada | ||
3085063 | 3085063 | 2021-04-05 | Canada | Alberta | 153194 | 1998 | 140614 | 10582 | 53.9333 | -116.5765 | 2021-04-06 04:20:32 | Alberta, Canada | ||
387986 | 387986 | 2021-04-04 | Canada | Alberta | 150307 | 1994 | 138560 | 9753 | 53.9333 | -116.5765 | 2021-04-05 04:20:35 | Alberta, Canada | ||
3709902 | 3709902 | 2021-04-03 | Canada | Alberta | 150307 | 1994 | 138560 | 9753 | 53.9333 | -116.5765 | 2021-04-04 04:20:49 | Alberta, Canada | ||
241018 | 241018 | 2021-04-02 | Canada | Alberta | 149207 | 1994 | 138560 | 8653 | 53.9333 | -116.5765 | 2021-04-03 04:20:44 | Alberta, Canada | ||
1301815 | 1301815 | 2021-04-01 | Canada | Alberta | 149207 | 1994 | 138560 | 8653 | 53.9333 | -116.5765 | 2021-04-02 04:20:36 | Alberta, Canada | ||
637687 | 637687 | 2021-03-31 | Canada | Alberta | 148332 | 1990 | 137992 | 8350 | 53.9333 | -116.5765 | 2021-04-01 04:27:05 | Alberta, Canada | ||
3643316 | 3643316 | 2021-03-30 | Canada | Alberta | 147461 | 1987 | 137499 | 7975 | 53.9333 | -116.5765 | 2021-03-31 04:26:25 | Alberta, Canada | ||
1289769 | 1289769 | 2021-03-29 | Canada | Alberta | 146885 | 1983 | 136980 | 7922 | 53.9333 | -116.5765 | 2021-03-30 04:26:23 | Alberta, Canada | ||
1535691 | 1535691 | 2021-03-28 | Canada | Alberta | 146340 | 1983 | 136659 | 7698 | 53.9333 | -116.5765 | 2021-03-29 04:28:35 | Alberta, Canada | ||
1219331 | 1219331 | 2021-03-27 | Canada | Alberta | 145696 | 1980 | 136350 | 7366 | 53.9333 | -116.5765 | 2021-03-28 05:28:10 | Alberta, Canada | ||
1880749 | 1880749 | 2021-03-26 | Canada | Alberta | 145028 | 1979 | 135972 | 7077 | 53.9333 | -116.5765 | 2021-03-27 05:25:04 | Alberta, Canada | ||
1980379 | 1980379 | 2021-03-25 | Canada | Alberta | 144311 | 1976 | 135500 | 6835 | 53.9333 | -116.5765 | 2021-03-26 05:26:55 | Alberta, Canada | ||
2780757 | 2780757 | 2021-03-24 | Canada | Alberta | 143547 | 1973 | 135040 | 6534 | 53.9333 | -116.5765 | 2021-03-25 05:27:00 | Alberta, Canada | ||
1798402 | 1798402 | 2021-03-23 | Canada | Alberta | 142855 | 1971 | 134653 | 6231 | 53.9333 | -116.5765 | 2021-03-24 05:25:40 | Alberta, Canada | ||
1203570 | 1203570 | 2021-03-22 | Canada | Alberta | 142390 | 1968 | 134246 | 6176 | 53.9333 | -116.5765 | 2021-03-23 05:26:18 | Alberta, Canada | ||
3369092 | 3369092 | 2021-03-21 | Canada | Alberta | 141934 | 1963 | 134000 | 5971 | 53.9333 | -116.5765 | 2021-03-22 05:25:43 | Alberta, Canada | ||
1744302 | 1744302 | 2021-03-20 | Canada | Alberta | 141379 | 1961 | 133800 | 5618 | 53.9333 | -116.5765 | 2021-03-21 05:25:44 | Alberta, Canada | ||
3420682 | 3420682 | 2021-03-19 | Canada | Alberta | 140823 | 1957 | 133437 | 5429 | 53.9333 | -116.5765 | 2021-03-20 05:25:46 | Alberta, Canada | ||
3452620 | 3452620 | 2021-03-18 | Canada | Alberta | 140127 | 1957 | 133086 | 5084 | 53.9333 | -116.5765 | 2021-03-19 05:26:09 | Alberta, Canada | ||
3620844 | 3620844 | 2021-03-17 | Canada | Alberta | 139622 | 1956 | 132748 | 4918 | 53.9333 | -116.5765 | 2021-03-18 05:26:22 | Alberta, Canada | ||
702168 | 702168 | 2021-03-16 | Canada | Alberta | 139143 | 1952 | 132415 | 4776 | 53.9333 | -116.5765 | 2021-03-17 05:25:07 | Alberta, Canada | ||
2055646 | 2055646 | 2021-03-15 | Canada | Alberta | 138788 | 1949 | 132028 | 4811 | 53.9333 | -116.5765 | 2021-03-16 05:25:13 | Alberta, Canada | ||
1732258 | 1732258 | 2021-03-14 | Canada | Alberta | 138424 | 1946 | 131781 | 4697 | 53.9333 | -116.5765 | 2021-03-15 05:25:51 | Alberta, Canada | ||
1579915 | 1579915 | 2021-03-13 | Canada | Alberta | 138036 | 1940 | 131502 | 4594 | 53.9333 | -116.5765 | 2021-03-14 05:25:37 | Alberta, Canada | ||
1837694 | 1837694 | 2021-03-12 | Canada | Alberta | 137562 | 1935 | 131081 | 4546 | 53.9333 | -116.5765 | 2021-03-13 05:25:15 | Alberta, Canada | ||
352059 | 352059 | 2021-03-11 | Canada | Alberta | 137137 | 1933 | 130716 | 4488 | 53.9333 | -116.5765 | 2021-03-12 05:26:50 | Alberta, Canada | ||
3962283 | 3962283 | 2021-03-10 | Canada | Alberta | 136773 | 1928 | 130382 | 4463 | 53.9333 | -116.5765 | 2021-03-11 05:25:48 | Alberta, Canada | ||
3663371 | 3663371 | 2021-03-09 | Canada | Alberta | 136374 | 1926 | 129978 | 4470 | 53.9333 | -116.5765 | 2021-03-10 05:24:35 | Alberta, Canada | ||
2359230 | 2359230 | 2021-03-08 | Canada | Alberta | 136119 | 1920 | 129566 | 4633 | 53.9333 | -116.5765 | 2021-03-09 05:28:19 | Alberta, Canada | ||
54568 | 54568 | 2021-03-07 | Canada | Alberta | 135837 | 1914 | 128974 | 4949 | 53.9333 | -116.5765 | 2021-03-08 05:24:48 | Alberta, Canada | ||
3667385 | 3667385 | 2021-03-06 | Canada | Alberta | 135537 | 1914 | 128974 | 4649 | 53.9333 | -116.5765 | 2021-03-07 05:21:54 | Alberta, 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]);