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 recovered 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
331669 | 331669 | 2021-08-04 | Canada | Alberta | 235244 | 2328 | 230634 | 2282 | 53.9333 | -116.5765 | 2021-08-05 04:21:51 | Alberta, Canada | ||
3467940 | 3467940 | 2021-08-03 | Canada | Alberta | 235038 | 2328 | 230534 | 2176 | 53.9333 | -116.5765 | 2021-08-04 04:21:25 | Alberta, Canada | ||
3015113 | 3015113 | 2021-08-01 | Canada | Alberta | 234295 | 2328 | 230312 | 1655 | 53.9333 | -116.5765 | 2021-08-02 04:21:36 | Alberta, Canada | ||
3295941 | 3295941 | 2021-07-30 | Canada | Alberta | 234295 | 2328 | 230312 | 1655 | 53.9333 | -116.5765 | 2021-07-31 04:21:35 | Alberta, Canada | ||
3683214 | 3683214 | 2021-08-02 | Canada | Alberta | 234295 | 2328 | 230312 | 1655 | 53.9333 | -116.5765 | 2021-08-03 04:21:39 | Alberta, Canada | ||
3903736 | 3903736 | 2021-07-31 | Canada | Alberta | 234295 | 2328 | 230312 | 1655 | 53.9333 | -116.5765 | 2021-08-01 04:21:50 | Alberta, Canada | ||
3385152 | 3385152 | 2021-07-29 | Canada | Alberta | 234108 | 2325 | 230263 | 1520 | 53.9333 | -116.5765 | 2021-07-30 04:21:34 | Alberta, Canada | ||
408057 | 408057 | 2021-07-28 | Canada | Alberta | 233875 | 2325 | 230216 | 1334 | 53.9333 | -116.5765 | 2021-07-29 04:21:33 | Alberta, Canada | ||
1305918 | 1305918 | 2021-07-27 | Canada | Alberta | 233681 | 2325 | 230183 | 1173 | 53.9333 | -116.5765 | 2021-07-28 04:21:39 | Alberta, Canada | ||
3218061 | 3218061 | 2021-07-26 | Canada | Alberta | 233547 | 2322 | 230142 | 1083 | 53.9333 | -116.5765 | 2021-07-27 04:21:18 | Alberta, Canada | ||
3137314 | 3137314 | 2021-07-23 | Canada | Alberta | 233160 | 2322 | 230066 | 772 | 53.9333 | -116.5765 | 2021-07-24 00:21:36 | Alberta, Canada | ||
3476074 | 3476074 | 2021-07-22 | Canada | Alberta | 233062 | 2320 | 230066 | 676 | 53.9333 | -116.5765 | 2021-07-23 04:21:29 | Alberta, Canada | ||
1330010 | 1330010 | 2021-07-24 | Canada | Alberta | 233160 | 2322 | 230039 | 799 | 53.9333 | -116.5765 | 2021-07-25 04:22:12 | Alberta, Canada | ||
1378270 | 1378270 | 2021-07-25 | Canada | Alberta | 233160 | 2322 | 230039 | 799 | 53.9333 | -116.5765 | 2021-07-26 04:21:28 | Alberta, Canada | ||
3331293 | 3331293 | 2021-07-21 | Canada | Alberta | 232956 | 2318 | 229989 | 649 | 53.9333 | -116.5765 | 2021-07-22 04:21:19 | Alberta, Canada | ||
2371274 | 2371274 | 2021-07-20 | Canada | Alberta | 232875 | 2318 | 229951 | 606 | 53.9333 | -116.5765 | 2021-07-21 04:21:40 | Alberta, Canada | ||
483353 | 483353 | 2021-07-19 | Canada | Alberta | 232806 | 2316 | 229885 | 605 | 53.9333 | -116.5765 | 2021-07-20 04:21:48 | Alberta, Canada | ||
2673576 | 2673576 | 2021-07-18 | Canada | Alberta | 232676 | 2314 | 229783 | 579 | 53.9333 | -116.5765 | 2021-07-19 04:21:24 | Alberta, Canada | ||
2947119 | 2947119 | 2021-07-16 | Canada | Alberta | 232676 | 2314 | 229783 | 579 | 53.9333 | -116.5765 | 2021-07-17 04:22:22 | Alberta, Canada | ||
3705888 | 3705888 | 2021-07-17 | Canada | Alberta | 232676 | 2314 | 229783 | 579 | 53.9333 | -116.5765 | 2021-07-18 04:22:07 | Alberta, Canada | ||
295775 | 295775 | 2021-07-15 | Canada | Alberta | 232635 | 2312 | 229745 | 578 | 53.9333 | -116.5765 | 2021-07-16 04:21:22 | Alberta, Canada | ||
3631720 | 3631720 | 2021-07-14 | Canada | Alberta | 232582 | 2311 | 229702 | 569 | 53.9333 | -116.5765 | 2021-07-15 04:21:48 | Alberta, Canada | ||
578595 | 578595 | 2021-07-13 | Canada | Alberta | 232536 | 2310 | 229627 | 599 | 53.9333 | -116.5765 | 2021-07-14 04:21:35 | Alberta, Canada | ||
3740844 | 3740844 | 2021-07-12 | Canada | Alberta | 232501 | 2307 | 229570 | 624 | 53.9333 | -116.5765 | 2021-07-13 04:21:18 | Alberta, Canada | ||
625641 | 625641 | 2021-07-10 | Canada | Alberta | 232411 | 2307 | 229429 | 675 | 53.9333 | -116.5765 | 2021-07-11 04:21:43 | Alberta, Canada | ||
829360 | 829360 | 2021-07-09 | Canada | Alberta | 232411 | 2307 | 229429 | 675 | 53.9333 | -116.5765 | 2021-07-10 04:21:25 | Alberta, Canada | ||
3659357 | 3659357 | 2021-07-11 | Canada | Alberta | 232411 | 2307 | 229429 | 675 | 53.9333 | -116.5765 | 2021-07-12 04:21:34 | Alberta, Canada | ||
778124 | 778124 | 2021-07-08 | Canada | Alberta | 232359 | 2307 | 229355 | 697 | 53.9333 | -116.5765 | 2021-07-09 04:21:21 | Alberta, Canada | ||
1440346 | 1440346 | 2021-07-07 | Canada | Alberta | 232336 | 2307 | 229284 | 745 | 53.9333 | -116.5765 | 2021-07-08 04:21:26 | Alberta, Canada | ||
2693451 | 2693451 | 2021-07-06 | Canada | Alberta | 232269 | 2305 | 229201 | 763 | 53.9333 | -116.5765 | 2021-07-07 04:21:20 | Alberta, Canada | ||
1932200 | 1932200 | 2021-07-05 | Canada | Alberta | 232236 | 2303 | 229102 | 831 | 53.9333 | -116.5765 | 2021-07-06 04:21:32 | Alberta, Canada | ||
1164931 | 1164931 | 2021-07-04 | Canada | Alberta | 232097 | 2301 | 228901 | 895 | 53.9333 | -116.5765 | 2021-07-05 04:21:28 | Alberta, Canada | ||
1495365 | 1495365 | 2021-07-03 | Canada | Alberta | 232097 | 2301 | 228901 | 895 | 53.9333 | -116.5765 | 2021-07-04 04:21:38 | Alberta, Canada | ||
2071680 | 2071680 | 2021-07-02 | Canada | Alberta | 232097 | 2301 | 228901 | 895 | 53.9333 | -116.5765 | 2021-07-03 04:21:37 | Alberta, Canada | ||
1892904 | 1892904 | 2021-06-30 | Canada | Alberta | 231987 | 2301 | 228631 | 1055 | 53.9333 | -116.5765 | 2021-07-01 04:21:19 | Alberta, Canada | ||
2764696 | 2764696 | 2021-07-01 | Canada | Alberta | 231987 | 2301 | 228631 | 1055 | 53.9333 | -116.5765 | 2021-07-02 04:21:47 | Alberta, Canada | ||
400027 | 400027 | 2021-06-29 | Canada | Alberta | 231911 | 2299 | 228480 | 1132 | 53.9333 | -116.5765 | 2021-06-30 04:21:41 | Alberta, Canada | ||
3125270 | 3125270 | 2021-06-28 | Canada | Alberta | 231850 | 2295 | 228294 | 1261 | 53.9333 | -116.5765 | 2021-06-29 04:21:28 | Alberta, Canada | ||
1712088 | 1712088 | 2021-06-25 | Canada | Alberta | 231641 | 2293 | 227768 | 1580 | 53.9333 | -116.5765 | 2021-06-26 04:21:43 | Alberta, Canada | ||
2295213 | 2295213 | 2021-06-24 | Canada | Alberta | 231641 | 2293 | 227768 | 1580 | 53.9333 | -116.5765 | 2021-06-25 04:21:33 | Alberta, Canada | ||
2589765 | 2589765 | 2021-06-27 | Canada | Alberta | 231641 | 2293 | 227768 | 1580 | 53.9333 | -116.5765 | 2021-06-28 04:21:29 | Alberta, Canada | ||
3958269 | 3958269 | 2021-06-26 | Canada | Alberta | 231641 | 2293 | 227768 | 1580 | 53.9333 | -116.5765 | 2021-06-27 04:21:39 | Alberta, Canada | ||
2422653 | 2422653 | 2021-06-23 | Canada | Alberta | 231568 | 2292 | 227600 | 1676 | 53.9333 | -116.5765 | 2021-06-24 04:21:55 | Alberta, Canada | ||
562730 | 562730 | 2021-06-22 | Canada | Alberta | 231476 | 2290 | 227413 | 1773 | 53.9333 | -116.5765 | 2021-06-23 04:21:46 | Alberta, Canada | ||
3358432 | 3358432 | 2021-06-21 | Canada | Alberta | 231419 | 2292 | 227124 | 2003 | 53.9333 | -116.5765 | 2021-06-22 04:21:34 | Alberta, Canada | ||
2884131 | 2884131 | 2021-06-20 | Canada | Alberta | 231359 | 2290 | 226942 | 2127 | 53.9333 | -116.5765 | 2021-06-21 04:21:41 | Alberta, Canada | ||
107214 | 107214 | 2021-06-19 | Canada | Alberta | 231259 | 2289 | 226800 | 2170 | 53.9333 | -116.5765 | 2021-06-20 04:21:48 | Alberta, Canada | ||
1125357 | 1125357 | 2021-06-18 | Canada | Alberta | 231132 | 2283 | 226513 | 2336 | 53.9333 | -116.5765 | 2021-06-19 04:22:33 | Alberta, Canada | ||
2910935 | 2910935 | 2021-06-17 | Canada | Alberta | 231008 | 2280 | 226257 | 2471 | 53.9333 | -116.5765 | 2021-06-18 04:22:16 | Alberta, Canada | ||
3030053 | 3030053 | 2021-06-16 | Canada | Alberta | 230858 | 2278 | 225941 | 2639 | 53.9333 | -116.5765 | 2021-06-17 04:22:36 | Alberta, Canada | ||
2339159 | 2339159 | 2021-06-15 | Canada | Alberta | 230705 | 2274 | 225627 | 2804 | 53.9333 | -116.5765 | 2021-06-16 04:22:32 | Alberta, Canada | ||
1563855 | 1563855 | 2021-06-14 | Canada | Alberta | 230578 | 2270 | 225219 | 3089 | 53.9333 | -116.5765 | 2021-06-15 04:22:22 | Alberta, Canada | ||
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 |
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]);