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)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3101205 | 3101205 | 2021-01-16 | Canada | Alberta | 116087 | 1417 | 101957 | 12713 | 53.9333 | -116.5765 | 2021-01-17 05:22:17 | Alberta, Canada | ||
3515167 | 3515167 | 2021-01-15 | Canada | Alberta | 115370 | 1402 | 101779 | 12189 | 53.9333 | -116.5765 | 2021-01-16 05:22:40 | Alberta, Canada | ||
3879340 | 3879340 | 2021-01-14 | Canada | Alberta | 114585 | 1389 | 100762 | 12434 | 53.9333 | -116.5765 | 2021-01-15 05:22:24 | Alberta, Canada | ||
3307967 | 3307967 | 2021-01-13 | Canada | Alberta | 113618 | 1368 | 99412 | 12838 | 53.9333 | -116.5765 | 2021-01-14 05:22:32 | Alberta, Canada | ||
774112 | 774112 | 2021-01-12 | Canada | Alberta | 112743 | 1345 | 98178 | 13220 | 53.9333 | -116.5765 | 2021-01-13 05:22:15 | Alberta, Canada | ||
189833 | 189833 | 2021-01-11 | Canada | Alberta | 112091 | 1307 | 96867 | 13917 | 53.9333 | -116.5765 | 2021-01-12 05:22:15 | Alberta, Canada | ||
2625636 | 2625636 | 2021-01-10 | Canada | Alberta | 111452 | 1284 | 96052 | 14116 | 53.9333 | -116.5765 | 2021-01-11 05:21:50 | Alberta, Canada | ||
3899724 | 3899724 | 2021-01-09 | Canada | Alberta | 110641 | 1272 | 94932 | 14437 | 53.9333 | -116.5765 | 2021-01-10 05:22:12 | Alberta, Canada | ||
153747 | 153747 | 2021-01-08 | Canada | Alberta | 109652 | 1241 | 94783 | 13628 | 53.9333 | -116.5765 | 2021-01-09 05:22:18 | Alberta, Canada | ||
2541171 | 2541171 | 2021-01-07 | Canada | Alberta | 108469 | 1217 | 93954 | 13298 | 53.9333 | -116.5765 | 2021-01-08 05:22:42 | Alberta, Canada | ||
2864480 | 2864480 | 2021-01-06 | Canada | Alberta | 107501 | 1193 | 92858 | 13450 | 53.9333 | -116.5765 | 2021-01-07 05:22:03 | Alberta, Canada | ||
3034067 | 3034067 | 2021-01-05 | Canada | Alberta | 106378 | 1168 | 91799 | 13411 | 53.9333 | -116.5765 | 2021-01-06 05:22:16 | Alberta, Canada | ||
1061612 | 1061612 | 2021-01-04 | Canada | Alberta | 105535 | 1142 | 90554 | 13839 | 53.9333 | -116.5765 | 2021-01-05 05:21:49 | Alberta, Canada | ||
3230215 | 3230215 | 2021-01-03 | Canada | Alberta | 104228 | 1046 | 84827 | 18355 | 53.9333 | -116.5765 | 2021-01-04 05:22:02 | Alberta, Canada | ||
2227285 | 2227285 | 2021-01-02 | Canada | Alberta | 100428 | 1046 | 84827 | 14555 | 53.9333 | -116.5765 | 2021-01-03 05:22:52 | Alberta, Canada | ||
1136649 | 1136649 | 2021-01-01 | Canada | Alberta | 100428 | 1046 | 84827 | 14555 | 53.9333 | -116.5765 | 2021-01-02 05:22:33 | Alberta, Canada | ||
3695255 | 3695255 | 2020-12-31 | Canada | Alberta | 100428 | 1046 | 84827 | 14555 | 53.9333 | -116.5765 | 2021-01-01 05:23:07 | Alberta, Canada | ||
1010070 | 1010070 | 2020-12-30 | Canada | Alberta | 100428 | 1046 | 84827 | 14555 | 53.9333 | -116.5765 | 2020-12-31 05:22:49 | Alberta, Canada | ||
766085 | 766085 | 2020-12-29 | Canada | Alberta | 99141 | 1028 | 83328 | 14785 | 53.9333 | -116.5765 | 2020-12-30 05:22:34 | Alberta, Canada | ||
3761349 | 3761349 | 2020-12-28 | Canada | Alberta | 98269 | 1002 | 81780 | 15487 | 53.9333 | -116.5765 | 2020-12-29 05:22:37 | Alberta, Canada | ||
3777669 | 3777669 | 2020-12-27 | Canada | Alberta | 97352 | 982 | 75070 | 21300 | 53.9333 | -116.5765 | 2020-12-28 05:22:06 | Alberta, Canada | ||
2223274 | 2223274 | 2020-12-26 | Canada | Alberta | 96893 | 955 | 75070 | 20868 | 53.9333 | -116.5765 | 2020-12-27 05:22:55 | Alberta, Canada | ||
202021 | 202021 | 2020-12-25 | Canada | Alberta | 95979 | 938 | 75070 | 19971 | 53.9333 | -116.5765 | 2020-12-26 05:22:28 | Alberta, Canada | ||
3691244 | 3691244 | 2020-12-24 | Canada | Alberta | 94788 | 920 | 75070 | 18798 | 53.9333 | -116.5765 | 2020-12-25 05:22:48 | Alberta, Canada | ||
2406596 | 2406596 | 2020-12-23 | Canada | Alberta | 93781 | 890 | 75070 | 17821 | 53.9333 | -116.5765 | 2020-12-24 05:23:04 | Alberta, Canada | ||
3769642 | 3769642 | 2020-12-22 | Canada | Alberta | 92480 | 871 | 73298 | 18311 | 53.9333 | -116.5765 | 2020-12-23 05:22:03 | Alberta, Canada | ||
927458 | 927458 | 2020-12-21 | Canada | Alberta | 91459 | 860 | 71434 | 19165 | 53.9333 | -116.5765 | 2020-12-22 05:22:33 | Alberta, Canada | ||
2119479 | 2119479 | 2020-12-20 | Canada | Alberta | 90219 | 851 | 70167 | 19201 | 53.9333 | -116.5765 | 2020-12-21 05:27:58 | Alberta, Canada | ||
2930986 | 2930986 | 2020-12-19 | Canada | Alberta | 88933 | 841 | 68832 | 19260 | 53.9333 | -116.5765 | 2020-12-20 05:27:32 | Alberta, Canada | ||
1900932 | 1900932 | 2020-12-18 | Canada | Alberta | 87581 | 815 | 67159 | 19607 | 53.9333 | -116.5765 | 2020-12-19 05:27:52 | Alberta, Canada | ||
2127758 | 2127758 | 2020-12-17 | Canada | Alberta | 86168 | 790 | 65513 | 19865 | 53.9333 | -116.5765 | 2020-12-18 05:28:18 | Alberta, Canada | ||
3149358 | 3149358 | 2020-12-16 | Canada | Alberta | 84597 | 760 | 63668 | 20169 | 53.9333 | -116.5765 | 2020-12-17 05:28:12 | Alberta, Canada | ||
1034139 | 1034139 | 2020-12-15 | Canada | Alberta | 83327 | 744 | 61934 | 20649 | 53.9333 | -116.5765 | 2020-12-16 05:28:04 | Alberta, Canada | ||
1751033 | 1751033 | 2020-12-14 | Canada | Alberta | 81986 | 733 | 60130 | 21123 | 53.9333 | -116.5765 | 2020-12-15 05:26:38 | Alberta, Canada | ||
3847553 | 3847553 | 2020-12-13 | Canada | Alberta | 80099 | 719 | 58818 | 20562 | 53.9333 | -116.5765 | 2020-12-14 05:26:27 | Alberta, Canada | ||
845335 | 845335 | 2020-12-12 | Canada | Alberta | 78382 | 697 | 57613 | 20072 | 53.9333 | -116.5765 | 2020-12-13 05:27:20 | Alberta, Canada | ||
860442 | 860442 | 2020-12-11 | Canada | Alberta | 76792 | 684 | 55947 | 20161 | 53.9333 | -116.5765 | 2020-12-12 05:26:19 | Alberta, Canada | ||
1599984 | 1599984 | 2020-12-10 | Canada | Alberta | 75054 | 666 | 54225 | 20163 | 53.9333 | -116.5765 | 2020-12-11 05:26:59 | Alberta, Canada | ||
2974993 | 2974993 | 2020-12-09 | Canada | Alberta | 73488 | 653 | 52636 | 20199 | 53.9333 | -116.5765 | 2020-12-10 05:26:19 | Alberta, Canada | ||
1818553 | 1818553 | 2020-12-08 | Canada | Alberta | 72028 | 640 | 51000 | 20388 | 53.9333 | -116.5765 | 2020-12-09 05:28:01 | Alberta, Canada | ||
2347189 | 2347189 | 2020-12-07 | Canada | Alberta | 70301 | 631 | 49603 | 20067 | 53.9333 | -116.5765 | 2020-12-08 05:27:42 | Alberta, Canada | ||
1006059 | 1006059 | 2020-12-06 | Canada | Alberta | 68566 | 615 | 48467 | 19484 | 53.9333 | -116.5765 | 2020-12-07 05:26:14 | Alberta, Canada | ||
1632068 | 1632068 | 2020-12-05 | Canada | Alberta | 66730 | 596 | 47328 | 18806 | 53.9333 | -116.5765 | 2020-12-06 05:26:18 | Alberta, Canada | ||
3859596 | 3859596 | 2020-12-04 | Canada | Alberta | 64851 | 590 | 46018 | 18243 | 53.9333 | -116.5765 | 2020-12-05 05:27:36 | Alberta, Canada | ||
74854 | 74854 | 2020-12-03 | Canada | Alberta | 63023 | 575 | 44705 | 17743 | 53.9333 | -116.5765 | 2020-12-04 05:27:27 | Alberta, Canada | ||
738066 | 738066 | 2020-12-02 | Canada | Alberta | 61169 | 561 | 43464 | 17144 | 53.9333 | -116.5765 | 2020-12-03 05:28:22 | Alberta, Canada | ||
2537160 | 2537160 | 2020-12-01 | Canada | Alberta | 59484 | 551 | 42305 | 16628 | 53.9333 | -116.5765 | 2020-12-02 05:27:41 | Alberta, Canada | ||
1583929 | 1583929 | 2020-11-30 | Canada | Alberta | 58177 | 541 | 41182 | 16454 | 53.9333 | -116.5765 | 2020-12-01 05:26:18 | Alberta, Canada | ||
3566332 | 3566332 | 2020-11-29 | Canada | Alberta | 56444 | 533 | 40219 | 15692 | 53.9333 | -116.5765 | 2020-11-30 05:26:13 | Alberta, Canada | ||
2934997 | 2934997 | 2020-11-28 | Canada | Alberta | 54836 | 524 | 39381 | 14931 | 53.9333 | -116.5765 | 2020-11-29 05:25:55 | Alberta, Canada | ||
392000 | 392000 | 2020-11-27 | Canada | Alberta | 53105 | 519 | 38369 | 14217 | 53.9333 | -116.5765 | 2020-11-28 05:25:50 | Alberta, Canada | ||
923447 | 923447 | 2020-11-26 | Canada | Alberta | 51878 | 510 | 37316 | 14052 | 53.9333 | -116.5765 | 2020-11-27 05:26:53 | Alberta, Canada | ||
1972352 | 1972352 | 2020-11-25 | Canada | Alberta | 50801 | 500 | 36582 | 13719 | 53.9333 | -116.5765 | 2020-11-26 05:27:44 | Alberta, Canada | ||
1350083 | 1350083 | 2020-11-24 | Canada | Alberta | 49536 | 492 | 35695 | 13349 | 53.9333 | -116.5765 | 2020-11-25 05:27:20 | Alberta, Canada | ||
678078 | 678078 | 2020-11-23 | Canada | Alberta | 48421 | 476 | 34779 | 13166 | 53.9333 | -116.5765 | 2020-11-24 05:27:31 | Alberta, Canada | ||
3189754 | 3189754 | 2020-11-22 | Canada | Alberta | 46872 | 471 | 34206 | 12195 | 53.9333 | -116.5765 | 2020-11-23 05:25:26 | Alberta, Canada | ||
3836248 | 3836248 | 2020-11-21 | Canada | Alberta | 45288 | 471 | 33543 | 11274 | 53.9333 | -116.5765 | 2020-11-22 05:25:45 | Alberta, Canada | ||
2701276 | 2701276 | 2020-11-20 | Canada | Alberta | 43952 | 462 | 32835 | 10655 | 53.9333 | -116.5765 | 2020-11-21 05:25:51 | Alberta, Canada | ||
821336 | 821336 | 2020-11-19 | Canada | Alberta | 42797 | 451 | 31964 | 10382 | 53.9333 | -116.5765 | 2020-11-20 05:26:28 | Alberta, Canada | ||
122470 | 122470 | 2020-11-18 | Canada | Alberta | 41692 | 443 | 31192 | 10057 | 53.9333 | -116.5765 | 2020-11-19 05:25:23 | Alberta, Canada | ||
3338358 | 3338358 | 2020-11-17 | Canada | Alberta | 40962 | 432 | 30462 | 10068 | 53.9333 | -116.5765 | 2020-11-18 05:40:31 | Alberta, Canada | ||
3169403 | 3169403 | 2020-11-16 | Canada | Alberta | 40189 | 427 | 29731 | 10031 | 53.9333 | -116.5765 | 2020-11-17 05:25:54 | Alberta, Canada | ||
2879971 | 2879971 | 2020-11-15 | Canada | Alberta | 39329 | 407 | 29304 | 9618 | 53.9333 | -116.5765 | 2020-11-16 05:25:57 | Alberta, Canada | ||
2914949 | 2914949 | 2020-11-14 | Canada | Alberta | 38338 | 401 | 28321 | 9616 | 53.9333 | -116.5765 | 2020-11-15 05:26:53 | Alberta, Canada | ||
2784771 | 2784771 | 2020-11-13 | Canada | Alberta | 37312 | 398 | 28321 | 8593 | 53.9333 | -116.5765 | 2020-11-14 05:25:37 | Alberta, Canada | ||
864536 | 864536 | 2020-11-12 | Canada | Alberta | 36405 | 393 | 27707 | 8305 | 53.9333 | -116.5765 | 2020-11-13 05:25:30 | Alberta, Canada | ||
3440581 | 3440581 | 2020-11-11 | Canada | Alberta | 35545 | 383 | 26407 | 8755 | 53.9333 | -116.5765 | 2020-11-12 05:25:55 | Alberta, Canada | ||
271921 | 271921 | 2020-11-10 | Canada | Alberta | 34873 | 376 | 26407 | 8090 | 53.9333 | -116.5765 | 2020-11-11 05:25:30 | Alberta, Canada | ||
1988398 | 1988398 | 2020-11-09 | Canada | Alberta | 34160 | 369 | 25826 | 7965 | 53.9333 | -116.5765 | 2020-11-10 05:40:07 | Alberta, Canada | ||
1728250 | 1728250 | 2020-11-08 | Canada | Alberta | 33504 | 363 | 24684 | 8457 | 53.9333 | -116.5765 | 2020-11-09 05:25:45 | Alberta, Canada | ||
1543710 | 1543710 | 2020-11-07 | Canada | Alberta | 32777 | 357 | 24684 | 7736 | 53.9333 | -116.5765 | 2020-11-08 05:24:56 | Alberta, Canada | ||
375948 | 375948 | 2020-11-06 | Canada | Alberta | 31858 | 352 | 24684 | 6822 | 53.9333 | -116.5765 | 2020-11-07 05:24:52 | Alberta, Canada | ||
891886 | 891886 | 2020-11-05 | Canada | Alberta | 30447 | 343 | 23874 | 6230 | 53.9333 | -116.5765 | 2020-11-06 05:24:55 | Alberta, Canada | ||
2918948 | 2918948 | 2020-11-04 | Canada | Alberta | 29932 | 338 | 23484 | 6110 | 53.9333 | -116.5765 | 2020-11-05 06:05:03 | Alberta, Canada | ||
2497785 | 2497785 | 2020-11-03 | Canada | Alberta | 29932 | 338 | 23484 | 6110 | 53.9333 | -116.5765 | 2020-11-04 05:25:09 | Alberta, Canada | ||
3303960 | 3303960 | 2020-11-02 | Canada | Alberta | 27664 | 323 | 22169 | 5172 | 53.9333 | -116.5765 | 2020-11-03 06:00:16 | Alberta, Canada | ||
3409209 | 3409209 | 2020-11-01 | Canada | Alberta | 27664 | 323 | 22169 | 5172 | 53.9333 | -116.5765 | 2020-11-02 05:25:04 | Alberta, Canada | ||
2079698 | 2079698 | 2020-10-31 | Canada | Alberta | 27664 | 323 | 22169 | 5172 | 53.9333 | -116.5765 | 2020-11-01 04:36:19 | Alberta, Canada | ||
2243151 | 2243151 | 2020-10-30 | Canada | Alberta | 27664 | 323 | 22169 | 5172 | 53.9333 | -116.5765 | 2020-10-31 04:24:44 | Alberta, Canada | ||
210006 | 210006 | 2020-10-29 | Canada | Alberta | 27042 | 318 | 21803 | 4921 | 53.9333 | -116.5765 | 2020-10-30 04:24:49 | Alberta, Canada | ||
754068 | 754068 | 2020-10-28 | Canada | Alberta | 26565 | 313 | 21459 | 4793 | 53.9333 | -116.5765 | 2020-10-29 04:24:49 | Alberta, Canada | ||
1452353 | 1452353 | 2020-10-27 | Canada | Alberta | 26155 | 309 | 21108 | 4738 | 53.9333 | -116.5765 | 2020-10-28 04:24:39 | Alberta, Canada | ||
3480077 | 3480077 | 2020-10-26 | Canada | Alberta | 25733 | 307 | 20949 | 4477 | 53.9333 | -116.5765 | 2020-10-27 04:24:45 | Alberta, Canada | ||
8098 | 8098 | 2020-10-25 | Canada | Alberta | 24261 | 300 | 20310 | 3651 | 53.9333 | -116.5765 | 2020-10-26 04:25:02 | Alberta, Canada | ||
3651335 | 3651335 | 2020-10-24 | Canada | Alberta | 24261 | 300 | 20310 | 3651 | 53.9333 | -116.5765 | 2020-10-25 04:24:36 | Alberta, Canada | ||
1053590 | 1053590 | 2020-10-23 | Canada | Alberta | 24261 | 300 | 20310 | 3651 | 53.9333 | -116.5765 | 2020-10-24 04:24:46 | Alberta, Canada | ||
1177260 | 1177260 | 2020-10-22 | Canada | Alberta | 23829 | 296 | 20014 | 3519 | 53.9333 | -116.5765 | 2020-10-23 04:24:46 | Alberta, Canada | ||
2191365 | 2191365 | 2020-10-21 | Canada | Alberta | 23402 | 296 | 19734 | 3372 | 53.9333 | -116.5765 | 2020-10-22 04:24:27 | Alberta, Canada | ||
3990376 | 3990376 | 2020-10-20 | Canada | Alberta | 22996 | 293 | 19500 | 3203 | 53.9333 | -116.5765 | 2020-10-21 04:24:14 | Alberta, Canada | ||
1794396 | 1794396 | 2020-10-19 | Canada | Alberta | 22673 | 292 | 19243 | 3138 | 53.9333 | -116.5765 | 2020-10-20 04:24:22 | Alberta, Canada | ||
762080 | 762080 | 2020-10-18 | Canada | Alberta | 21775 | 288 | 18651 | 2836 | 53.9333 | -116.5765 | 2020-10-19 04:24:16 | Alberta, Canada | ||
1026118 | 1026118 | 2020-10-17 | Canada | Alberta | 21775 | 288 | 18651 | 2836 | 53.9333 | -116.5765 | 2020-10-18 04:24:25 | Alberta, Canada | ||
2856613 | 2856613 | 2020-10-16 | Canada | Alberta | 21775 | 288 | 18651 | 2836 | 53.9333 | -116.5765 | 2020-10-17 04:24:12 | Alberta, Canada | ||
786143 | 786143 | 2020-10-15 | Canada | Alberta | 21443 | 288 | 18417 | 2738 | 53.9333 | -116.5765 | 2020-10-16 04:24:01 | Alberta, Canada | ||
78854 | 78854 | 2020-10-14 | Canada | Alberta | 21199 | 287 | 18223 | 2689 | 53.9333 | -116.5765 | 2020-10-15 04:24:28 | Alberta, Canada | ||
3781669 | 3781669 | 2020-10-13 | Canada | Alberta | 20956 | 286 | 18055 | 2615 | 53.9333 | -116.5765 | 2020-10-14 04:24:05 | Alberta, Canada | ||
2291209 | 2291209 | 2020-10-12 | Canada | Alberta | 19995 | 283 | 17488 | 2224 | 53.9333 | -116.5765 | 2020-10-13 04:24:02 | Alberta, Canada | ||
3785662 | 3785662 | 2020-10-11 | Canada | Alberta | 19995 | 283 | 17488 | 2224 | 53.9333 | -116.5765 | 2020-10-12 04:23:45 | Alberta, Canada | ||
2601800 | 2601800 | 2020-10-10 | Canada | Alberta | 19995 | 283 | 17488 | 2224 | 53.9333 | -116.5765 | 2020-10-11 04:23:46 | Alberta, Canada | ||
817333 | 817333 | 2020-10-09 | Canada | Alberta | 19995 | 283 | 17488 | 2224 | 53.9333 | -116.5765 | 2020-10-10 04:23:57 | 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]);