daily_reports (view)
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 active descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active ▲ | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-01-22 | Canada | Alberta | 119757 | 1512 | 108258 | 9987 | 53.9333 | -116.5765 | 2021-01-23 05:22:03 | Alberta, Canada | ||
2021-04-04 | Canada | Alberta | 150307 | 1994 | 138560 | 9753 | 53.9333 | -116.5765 | 2021-04-05 04:20:35 | Alberta, Canada | ||
2021-04-03 | Canada | Alberta | 150307 | 1994 | 138560 | 9753 | 53.9333 | -116.5765 | 2021-04-04 04:20:49 | Alberta, Canada | ||
2021-01-23 | Canada | Alberta | 120330 | 1525 | 109078 | 9727 | 53.9333 | -116.5765 | 2021-01-24 05:22:35 | Alberta, Canada | ||
2020-05-20 | Canada | Alberta | 6735 | 128 | 5637 | 970 | 53.9333 | -116.5765 | 2020-05-21 02:32:48 | Alberta, Canada | ||
2020-11-15 | Canada | Alberta | 39329 | 407 | 29304 | 9618 | 53.9333 | -116.5765 | 2020-11-16 05:25:57 | Alberta, Canada | ||
2020-11-14 | Canada | Alberta | 38338 | 401 | 28321 | 9616 | 53.9333 | -116.5765 | 2020-11-15 05:26:53 | Alberta, Canada | ||
2020-04-02 | Canada | Alberta | 969 | 13 | 0 | 956 | 53.9333 | -116.5765 | 4/2/20 23:31 | Alberta, Canada | ||
2020-04-03 | Canada | Alberta | 969 | 13 | 0 | 956 | 53.9333 | -116.5765 | 2020-04-03 22:52:30 | Alberta, Canada | ||
2021-01-24 | Canada | Alberta | 120793 | 1549 | 109733 | 9511 | 53.9333 | -116.5765 | 2021-01-25 05:22:16 | Alberta, Canada | ||
2021-01-25 | Canada | Alberta | 121535 | 1574 | 110622 | 9339 | 53.9333 | -116.5765 | 2021-01-26 05:22:02 | Alberta, Canada | ||
2021-05-28 | Canada | Alberta | 226449 | 2206 | 214966 | 9277 | 53.9333 | -116.5765 | 2021-05-29 04:20:41 | Alberta, Canada | ||
2020-05-21 | Canada | Alberta | 6768 | 132 | 5710 | 926 | 53.9333 | -116.5765 | 2020-05-22 02:36:51 | Alberta, Canada | ||
2021-07-04 | Canada | Alberta | 232097 | 2301 | 228901 | 895 | 53.9333 | -116.5765 | 2021-07-05 04:21:28 | Alberta, Canada | ||
2021-07-03 | Canada | Alberta | 232097 | 2301 | 228901 | 895 | 53.9333 | -116.5765 | 2021-07-04 04:21:38 | Alberta, Canada | ||
2021-07-02 | Canada | Alberta | 232097 | 2301 | 228901 | 895 | 53.9333 | -116.5765 | 2021-07-03 04:21:37 | Alberta, Canada | ||
2020-11-11 | Canada | Alberta | 35545 | 383 | 26407 | 8755 | 53.9333 | -116.5765 | 2020-11-12 05:25:55 | Alberta, Canada | ||
2021-04-02 | Canada | Alberta | 149207 | 1994 | 138560 | 8653 | 53.9333 | -116.5765 | 2021-04-03 04:20:44 | Alberta, Canada | ||
2021-04-01 | Canada | Alberta | 149207 | 1994 | 138560 | 8653 | 53.9333 | -116.5765 | 2021-04-02 04:20:36 | Alberta, Canada | ||
2021-01-26 | Canada | Alberta | 121901 | 1587 | 111662 | 8652 | 53.9333 | -116.5765 | 2021-01-27 05:23:41 | Alberta, Canada | ||
2020-05-22 | Canada | Alberta | 6800 | 134 | 5801 | 865 | 53.9333 | -116.5765 | 2020-05-23 02:32:42 | Alberta, Canada | ||
2020-11-13 | Canada | Alberta | 37312 | 398 | 28321 | 8593 | 53.9333 | -116.5765 | 2020-11-14 05:25:37 | Alberta, Canada | ||
2020-07-19 | Canada | Alberta | 9219 | 167 | 8193 | 859 | 53.9333 | -116.5765 | 2020-07-20 05:34:40 | Alberta, Canada | ||
2020-07-17 | Canada | Alberta | 9219 | 167 | 8193 | 859 | 53.9333 | -116.5765 | 2020-07-18 04:34:45 | Alberta, Canada | ||
2020-07-18 | Canada | Alberta | 9219 | 167 | 8193 | 859 | 53.9333 | -116.5765 | 2020-07-19 04:34:58 | Alberta, Canada | ||
2021-05-29 | Canada | Alberta | 226855 | 2214 | 216167 | 8474 | 53.9333 | -116.5765 | 2021-05-30 04:20:55 | Alberta, Canada | ||
2020-11-08 | Canada | Alberta | 33504 | 363 | 24684 | 8457 | 53.9333 | -116.5765 | 2020-11-09 05:25:45 | Alberta, Canada | ||
2021-03-31 | Canada | Alberta | 148332 | 1990 | 137992 | 8350 | 53.9333 | -116.5765 | 2021-04-01 04:27:05 | Alberta, Canada | ||
2021-07-05 | Canada | Alberta | 232236 | 2303 | 229102 | 831 | 53.9333 | -116.5765 | 2021-07-06 04:21:32 | Alberta, Canada | ||
2020-11-12 | Canada | Alberta | 36405 | 393 | 27707 | 8305 | 53.9333 | -116.5765 | 2020-11-13 05:25:30 | Alberta, Canada | ||
2021-01-27 | Canada | Alberta | 122360 | 1599 | 112558 | 8203 | 53.9333 | -116.5765 | 2021-01-28 05:22:24 | Alberta, Canada | ||
2020-05-23 | Canada | Alberta | 6818 | 135 | 5869 | 814 | 53.9333 | -116.5765 | 2020-05-24 02:32:43 | Alberta, Canada | ||
2020-11-10 | Canada | Alberta | 34873 | 376 | 26407 | 8090 | 53.9333 | -116.5765 | 2020-11-11 05:25:30 | Alberta, Canada | ||
2021-05-30 | Canada | Alberta | 227246 | 2219 | 216954 | 8073 | 53.9333 | -116.5765 | 2021-05-31 03:08:59 | Alberta, Canada | ||
2020-07-16 | Canada | Alberta | 9114 | 165 | 8142 | 807 | 53.9333 | -116.5765 | 2020-07-17 04:34:50 | Alberta, Canada | ||
2021-01-28 | Canada | Alberta | 122821 | 1606 | 113174 | 8041 | 53.9333 | -116.5765 | 2021-01-29 05:22:23 | Alberta, Canada | ||
2020-05-24 | Canada | Alberta | 6860 | 135 | 5924 | 801 | 53.9333 | -116.5765 | 2020-05-25 02:32:44 | Alberta, Canada | ||
2021-07-24 | Canada | Alberta | 233160 | 2322 | 230039 | 799 | 53.9333 | -116.5765 | 2021-07-25 04:22:12 | Alberta, Canada | ||
2021-07-25 | Canada | Alberta | 233160 | 2322 | 230039 | 799 | 53.9333 | -116.5765 | 2021-07-26 04:21:28 | Alberta, Canada | ||
2021-03-30 | Canada | Alberta | 147461 | 1987 | 137499 | 7975 | 53.9333 | -116.5765 | 2021-03-31 04:26:25 | Alberta, Canada | ||
2020-11-09 | Canada | Alberta | 34160 | 369 | 25826 | 7965 | 53.9333 | -116.5765 | 2020-11-10 05:40:07 | Alberta, Canada | ||
2021-03-29 | Canada | Alberta | 146885 | 1983 | 136980 | 7922 | 53.9333 | -116.5765 | 2021-03-30 04:26:23 | Alberta, Canada | ||
2021-01-29 | Canada | Alberta | 123364 | 1620 | 113939 | 7805 | 53.9333 | -116.5765 | 2021-01-30 05:22:49 | Alberta, Canada | ||
2020-11-07 | Canada | Alberta | 32777 | 357 | 24684 | 7736 | 53.9333 | -116.5765 | 2020-11-08 05:24:56 | Alberta, Canada | ||
2021-07-23 | Canada | Alberta | 233160 | 2322 | 230066 | 772 | 53.9333 | -116.5765 | 2021-07-24 00:21:36 | Alberta, Canada | ||
2021-03-28 | Canada | Alberta | 146340 | 1983 | 136659 | 7698 | 53.9333 | -116.5765 | 2021-03-29 04:28:35 | Alberta, Canada | ||
2021-05-31 | Canada | Alberta | 227509 | 2227 | 217636 | 7646 | 53.9333 | -116.5765 | 2021-06-01 04:23:09 | Alberta, Canada | ||
2021-07-06 | Canada | Alberta | 232269 | 2305 | 229201 | 763 | 53.9333 | -116.5765 | 2021-07-07 04:21:20 | Alberta, Canada | ||
2020-05-25 | Canada | Alberta | 6879 | 138 | 5979 | 762 | 53.9333 | -116.5765 | 2020-05-26 02:32:35 | Alberta, Canada | ||
2021-01-30 | Canada | Alberta | 123747 | 1631 | 114586 | 7530 | 53.9333 | -116.5765 | 2021-01-31 05:22:42 | Alberta, Canada | ||
2021-01-31 | Canada | Alberta | 124208 | 1639 | 115064 | 7505 | 53.9333 | -116.5765 | 2021-02-01 05:22:53 | Alberta, Canada | ||
2021-07-07 | Canada | Alberta | 232336 | 2307 | 229284 | 745 | 53.9333 | -116.5765 | 2021-07-08 04:21:26 | Alberta, Canada | ||
2020-04-01 | Canada | Alberta | 754 | 9 | 0 | 745 | 53.9333 | -116.5765 | 2020-04-01 22:04:44 | Alberta, Canada | ||
2021-02-01 | Canada | Alberta | 124563 | 1649 | 115527 | 7387 | 53.9333 | -116.5765 | 2021-02-02 05:22:49 | Alberta, Canada | ||
2021-03-27 | Canada | Alberta | 145696 | 1980 | 136350 | 7366 | 53.9333 | -116.5765 | 2021-03-28 05:28:10 | Alberta, Canada | ||
2020-05-26 | Canada | Alberta | 6901 | 139 | 6048 | 714 | 53.9333 | -116.5765 | 2020-05-27 02:32:31 | Alberta, Canada | ||
2021-03-26 | Canada | Alberta | 145028 | 1979 | 135972 | 7077 | 53.9333 | -116.5765 | 2021-03-27 05:25:04 | Alberta, Canada | ||
2020-07-15 | Canada | Alberta | 8994 | 163 | 8127 | 704 | 53.9333 | -116.5765 | 2020-07-16 04:44:59 | Alberta, Canada | ||
2020-07-14 | Canada | Alberta | 8912 | 163 | 8048 | 701 | 53.9333 | -116.5765 | 2020-07-15 04:34:39 | Alberta, Canada | ||
2021-07-08 | Canada | Alberta | 232359 | 2307 | 229355 | 697 | 53.9333 | -116.5765 | 2021-07-09 04:21:21 | Alberta, Canada | ||
2021-02-02 | Canada | Alberta | 124831 | 1660 | 116259 | 6912 | 53.9333 | -116.5765 | 2021-02-03 05:22:52 | Alberta, Canada | ||
2021-03-25 | Canada | Alberta | 144311 | 1976 | 135500 | 6835 | 53.9333 | -116.5765 | 2021-03-26 05:26:55 | Alberta, Canada | ||
2020-11-06 | Canada | Alberta | 31858 | 352 | 24684 | 6822 | 53.9333 | -116.5765 | 2020-11-07 05:24:52 | Alberta, Canada | ||
2020-03-31 | Canada | Alberta | 690 | 8 | 0 | 682 | 53.9333 | -116.5765 | 2020-03-31 23:49:13 | Alberta, Canada | ||
2020-05-27 | Canada | Alberta | 6926 | 141 | 6106 | 679 | 53.9333 | -116.5765 | 2020-05-28 02:32:31 | Alberta, Canada | ||
2021-06-01 | Canada | Alberta | 227718 | 2228 | 218719 | 6771 | 53.9333 | -116.5765 | 2021-06-02 04:24:34 | Alberta, Canada | ||
2021-07-22 | Canada | Alberta | 233062 | 2320 | 230066 | 676 | 53.9333 | -116.5765 | 2021-07-23 04:21:29 | Alberta, Canada | ||
2020-07-13 | Canada | Alberta | 8826 | 161 | 7989 | 676 | 53.9333 | -116.5765 | 2020-07-14 04:34:46 | Alberta, Canada | ||
2021-07-10 | Canada | Alberta | 232411 | 2307 | 229429 | 675 | 53.9333 | -116.5765 | 2021-07-11 04:21:43 | Alberta, Canada | ||
2021-07-09 | Canada | Alberta | 232411 | 2307 | 229429 | 675 | 53.9333 | -116.5765 | 2021-07-10 04:21:25 | Alberta, Canada | ||
2021-07-11 | Canada | Alberta | 232411 | 2307 | 229429 | 675 | 53.9333 | -116.5765 | 2021-07-12 04:21:34 | Alberta, Canada | ||
2021-02-03 | Canada | Alberta | 125090 | 1671 | 116820 | 6599 | 53.9333 | -116.5765 | 2021-02-04 05:22:26 | Alberta, Canada | ||
2021-02-04 | Canada | Alberta | 125672 | 1684 | 117400 | 6588 | 53.9333 | -116.5765 | 2021-02-05 05:22:38 | Alberta, Canada | ||
2020-03-30 | Canada | Alberta | 661 | 3 | 0 | 658 | 53.9333 | -116.5765 | 3/30/20 22:58 | Alberta, Canada | ||
2021-03-24 | Canada | Alberta | 143547 | 1973 | 135040 | 6534 | 53.9333 | -116.5765 | 2021-03-25 05:27:00 | Alberta, Canada | ||
2020-05-28 | Canada | Alberta | 6955 | 143 | 6160 | 652 | 53.9333 | -116.5765 | 2020-05-29 02:32:50 | Alberta, Canada | ||
2021-07-21 | Canada | Alberta | 232956 | 2318 | 229989 | 649 | 53.9333 | -116.5765 | 2021-07-22 04:21:19 | Alberta, Canada | ||
2021-02-05 | Canada | Alberta | 126068 | 1693 | 117968 | 6407 | 53.9333 | -116.5765 | 2021-02-06 05:23:55 | Alberta, Canada | ||
2021-06-02 | Canada | Alberta | 228128 | 2231 | 219592 | 6305 | 53.9333 | -116.5765 | 2021-06-03 04:23:32 | Alberta, Canada | ||
2020-05-13 | Canada | Alberta | 6407 | 120 | 0 | 6287 | 53.9333 | -116.5765 | 2020-05-14 03:32:28 | Alberta, Canada | ||
2021-02-06 | Canada | Alberta | 126416 | 1705 | 118445 | 6266 | 53.9333 | -116.5765 | 2021-02-07 05:23:00 | Alberta, Canada | ||
2021-02-07 | Canada | Alberta | 126767 | 1709 | 118816 | 6242 | 53.9333 | -116.5765 | 2021-02-08 05:22:39 | Alberta, Canada | ||
2021-07-12 | Canada | Alberta | 232501 | 2307 | 229570 | 624 | 53.9333 | -116.5765 | 2021-07-13 04:21:18 | Alberta, Canada | ||
2021-03-23 | Canada | Alberta | 142855 | 1971 | 134653 | 6231 | 53.9333 | -116.5765 | 2021-03-24 05:25:40 | Alberta, Canada | ||
2020-11-05 | Canada | Alberta | 30447 | 343 | 23874 | 6230 | 53.9333 | -116.5765 | 2020-11-06 05:24:55 | Alberta, Canada | ||
2020-05-12 | Canada | Alberta | 6345 | 118 | 0 | 6227 | 53.9333 | -116.5765 | 2020-05-13 03:32:26 | Alberta, Canada | ||
2020-07-07 | Canada | Alberta | 8436 | 157 | 7659 | 620 | 53.9333 | -116.5765 | 2020-07-08 05:33:48 | Alberta, Canada | ||
2021-02-08 | Canada | Alberta | 127036 | 1710 | 119130 | 6196 | 53.9333 | -116.5765 | 2021-02-09 05:23:30 | Alberta, Canada | ||
2020-03-29 | Canada | Alberta | 621 | 2 | 0 | 619 | 53.9333 | -116.5765 | 3/29/20 23:13 | Alberta, Canada | ||
2020-05-11 | Canada | Alberta | 6300 | 117 | 0 | 6183 | 53.9333 | -116.5765 | 2020-05-12 03:32:27 | Alberta, Canada | ||
2021-03-22 | Canada | Alberta | 142390 | 1968 | 134246 | 6176 | 53.9333 | -116.5765 | 2021-03-23 05:26:18 | Alberta, Canada | ||
2020-05-29 | Canada | Alberta | 6979 | 143 | 6220 | 616 | 53.9333 | -116.5765 | 2020-05-30 02:32:48 | Alberta, Canada | ||
2020-05-10 | Canada | Alberta | 6253 | 117 | 0 | 6136 | 53.9333 | -116.5765 | 2020-05-11 02:32:30 | Alberta, Canada | ||
2020-11-03 | Canada | Alberta | 29932 | 338 | 23484 | 6110 | 53.9333 | -116.5765 | 2020-11-04 05:25:09 | Alberta, Canada | ||
2020-11-04 | Canada | Alberta | 29932 | 338 | 23484 | 6110 | 53.9333 | -116.5765 | 2020-11-05 06:05:03 | Alberta, Canada | ||
2020-07-08 | Canada | Alberta | 8482 | 158 | 7716 | 608 | 53.9333 | -116.5765 | 2020-07-09 04:34:23 | Alberta, Canada | ||
2020-07-06 | Canada | Alberta | 8389 | 155 | 7627 | 607 | 53.9333 | -116.5765 | 2020-07-07 04:34:00 | Alberta, Canada | ||
2021-07-20 | Canada | Alberta | 232875 | 2318 | 229951 | 606 | 53.9333 | -116.5765 | 2021-07-21 04:21:40 | Alberta, Canada | ||
2021-07-19 | Canada | Alberta | 232806 | 2316 | 229885 | 605 | 53.9333 | -116.5765 | 2021-07-20 04:21:48 | Alberta, Canada | ||
2020-05-09 | Canada | Alberta | 6157 | 116 | 0 | 6041 | 53.9333 | -116.5765 | 2020-05-10 02:32:30 | Alberta, Canada |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;