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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3667385 | 3667385 | 2021-03-06 | Canada | Alberta | 135537 | 1914 | 128974 | 4649 | 53.9333 | -116.5765 | 2021-03-07 05:21:54 | Alberta, Canada | ||
1616006 | 1616006 | 2021-03-05 | Canada | Alberta | 135196 | 1913 | 128644 | 4639 | 53.9333 | -116.5765 | 2021-03-06 04:23:41 | Alberta, Canada | ||
2207417 | 2207417 | 2021-03-04 | Canada | Alberta | 134785 | 1911 | 128261 | 4613 | 53.9333 | -116.5765 | 2021-03-05 05:26:29 | Alberta, Canada | ||
1089838 | 1089838 | 2021-03-03 | Canada | Alberta | 134454 | 1902 | 127903 | 4649 | 53.9333 | -116.5765 | 2021-03-04 05:24:24 | Alberta, Canada | ||
3253910 | 3253910 | 2021-03-02 | Canada | Alberta | 134052 | 1890 | 127531 | 4631 | 53.9333 | -116.5765 | 2021-03-03 05:23:28 | Alberta, Canada | ||
998202 | 998202 | 2021-03-01 | Canada | Alberta | 133795 | 1888 | 127233 | 4674 | 53.9333 | -116.5765 | 2021-03-02 05:23:30 | Alberta, Canada | ||
2367260 | 2367260 | 2021-02-28 | Canada | Alberta | 133504 | 1886 | 127034 | 4584 | 53.9333 | -116.5765 | 2021-03-01 05:23:01 | Alberta, Canada | ||
3065762 | 3065762 | 2021-02-27 | Canada | Alberta | 133203 | 1883 | 126774 | 4546 | 53.9333 | -116.5765 | 2021-02-28 05:22:20 | Alberta, Canada | ||
2183346 | 2183346 | 2021-02-26 | Canada | Alberta | 132788 | 1877 | 126406 | 4505 | 53.9333 | -116.5765 | 2021-02-27 05:22:28 | Alberta, Canada | ||
1857768 | 1857768 | 2021-02-25 | Canada | Alberta | 132432 | 1874 | 126074 | 4484 | 53.9333 | -116.5765 | 2021-02-26 05:22:40 | Alberta, Canada | ||
279946 | 279946 | 2021-02-24 | Canada | Alberta | 132033 | 1866 | 125622 | 4545 | 53.9333 | -116.5765 | 2021-02-25 05:24:57 | Alberta, Canada | ||
1936214 | 1936214 | 2021-02-23 | Canada | Alberta | 131603 | 1853 | 125234 | 4516 | 53.9333 | -116.5765 | 2021-02-24 05:29:16 | Alberta, Canada | ||
530469 | 530469 | 2021-02-22 | Canada | Alberta | 131336 | 1843 | 124818 | 4675 | 53.9333 | -116.5765 | 2021-02-23 05:23:41 | Alberta, Canada | ||
181803 | 181803 | 2021-02-21 | Canada | Alberta | 131063 | 1827 | 124478 | 4758 | 53.9333 | -116.5765 | 2021-02-22 05:24:21 | Alberta, Canada | ||
742077 | 742077 | 2021-02-20 | Canada | Alberta | 130735 | 1818 | 124114 | 4803 | 53.9333 | -116.5765 | 2021-02-21 05:24:33 | Alberta, Canada | ||
471175 | 471175 | 2021-02-19 | Canada | Alberta | 130355 | 1812 | 123703 | 4840 | 53.9333 | -116.5765 | 2021-02-20 05:22:51 | Alberta, Canada | ||
1152885 | 1152885 | 2021-02-18 | Canada | Alberta | 130030 | 1805 | 123338 | 4887 | 53.9333 | -116.5765 | 2021-02-19 05:24:16 | Alberta, Canada | ||
3600805 | 3600805 | 2021-02-17 | Canada | Alberta | 129615 | 1798 | 122960 | 4857 | 53.9333 | -116.5765 | 2021-02-18 05:22:58 | Alberta, Canada | ||
3049940 | 3049940 | 2021-02-16 | Canada | Alberta | 129338 | 1791 | 122554 | 4993 | 53.9333 | -116.5765 | 2021-02-17 05:23:10 | Alberta, Canada | ||
1338039 | 1338039 | 2021-02-15 | Canada | Alberta | 129075 | 1782 | 122071 | 5222 | 53.9333 | -116.5765 | 2021-02-16 05:24:38 | Alberta, Canada | ||
2283190 | 2283190 | 2021-02-14 | Canada | Alberta | 128824 | 1780 | 121829 | 5215 | 53.9333 | -116.5765 | 2021-02-15 05:24:49 | Alberta, Canada | ||
2677590 | 2677590 | 2021-02-13 | Canada | Alberta | 128540 | 1775 | 121494 | 5271 | 53.9333 | -116.5765 | 2021-02-14 05:23:43 | Alberta, Canada | ||
3539223 | 3539223 | 2021-02-12 | Canada | Alberta | 128235 | 1760 | 121068 | 5407 | 53.9333 | -116.5765 | 2021-02-13 05:22:12 | Alberta, Canada | ||
2637486 | 2637486 | 2021-02-11 | Canada | Alberta | 127921 | 1744 | 120676 | 5501 | 53.9333 | -116.5765 | 2021-02-12 05:23:29 | Alberta, Canada | ||
3978341 | 3978341 | 2021-02-10 | Canada | Alberta | 127570 | 1728 | 120136 | 5706 | 53.9333 | -116.5765 | 2021-02-11 05:23:55 | Alberta, Canada | ||
1527661 | 1527661 | 2021-02-09 | Canada | Alberta | 127231 | 1722 | 119678 | 5831 | 53.9333 | -116.5765 | 2021-02-10 05:22:41 | Alberta, Canada | ||
613452 | 613452 | 2021-02-08 | Canada | Alberta | 127036 | 1710 | 119130 | 6196 | 53.9333 | -116.5765 | 2021-02-09 05:23:30 | Alberta, Canada | ||
1672221 | 1672221 | 2021-02-07 | Canada | Alberta | 126767 | 1709 | 118816 | 6242 | 53.9333 | -116.5765 | 2021-02-08 05:22:39 | Alberta, Canada | ||
974682 | 974682 | 2021-02-06 | Canada | Alberta | 126416 | 1705 | 118445 | 6266 | 53.9333 | -116.5765 | 2021-02-07 05:23:00 | Alberta, Canada | ||
1587940 | 1587940 | 2021-02-05 | Canada | Alberta | 126068 | 1693 | 117968 | 6407 | 53.9333 | -116.5765 | 2021-02-06 05:23:55 | Alberta, Canada | ||
790147 | 790147 | 2021-02-04 | Canada | Alberta | 125672 | 1684 | 117400 | 6588 | 53.9333 | -116.5765 | 2021-02-05 05:22:38 | Alberta, Canada | ||
340039 | 340039 | 2021-02-03 | Canada | Alberta | 125090 | 1671 | 116820 | 6599 | 53.9333 | -116.5765 | 2021-02-04 05:22:26 | Alberta, Canada | ||
1684265 | 1684265 | 2021-02-02 | Canada | Alberta | 124831 | 1660 | 116259 | 6912 | 53.9333 | -116.5765 | 2021-02-03 05:22:52 | Alberta, Canada | ||
1676235 | 1676235 | 2021-02-01 | Canada | Alberta | 124563 | 1649 | 115527 | 7387 | 53.9333 | -116.5765 | 2021-02-02 05:22:49 | Alberta, Canada | ||
1459523 | 1459523 | 2021-01-31 | Canada | Alberta | 124208 | 1639 | 115064 | 7505 | 53.9333 | -116.5765 | 2021-02-01 05:22:53 | Alberta, Canada | ||
2211431 | 2211431 | 2021-01-30 | Canada | Alberta | 123747 | 1631 | 114586 | 7530 | 53.9333 | -116.5765 | 2021-01-31 05:22:42 | Alberta, Canada | ||
1896918 | 1896918 | 2021-01-29 | Canada | Alberta | 123364 | 1620 | 113939 | 7805 | 53.9333 | -116.5765 | 2021-01-30 05:22:49 | Alberta, Canada | ||
2481734 | 2481734 | 2021-01-28 | Canada | Alberta | 122821 | 1606 | 113174 | 8041 | 53.9333 | -116.5765 | 2021-01-29 05:22:23 | Alberta, Canada | ||
3153369 | 3153369 | 2021-01-27 | Canada | Alberta | 122360 | 1599 | 112558 | 8203 | 53.9333 | -116.5765 | 2021-01-28 05:22:24 | Alberta, Canada | ||
12104 | 12104 | 2021-01-26 | Canada | Alberta | 121901 | 1587 | 111662 | 8652 | 53.9333 | -116.5765 | 2021-01-27 05:23:41 | Alberta, Canada | ||
2567428 | 2567428 | 2021-01-25 | Canada | Alberta | 121535 | 1574 | 110622 | 9339 | 53.9333 | -116.5765 | 2021-01-26 05:22:02 | Alberta, Canada | ||
1759060 | 1759060 | 2021-01-24 | Canada | Alberta | 120793 | 1549 | 109733 | 9511 | 53.9333 | -116.5765 | 2021-01-25 05:22:16 | Alberta, Canada | ||
2426667 | 2426667 | 2021-01-23 | Canada | Alberta | 120330 | 1525 | 109078 | 9727 | 53.9333 | -116.5765 | 2021-01-24 05:22:35 | Alberta, Canada | ||
2466569 | 2466569 | 2021-01-22 | Canada | Alberta | 119757 | 1512 | 108258 | 9987 | 53.9333 | -116.5765 | 2021-01-23 05:22:03 | Alberta, Canada | ||
435120 | 435120 | 2021-01-21 | Canada | Alberta | 119114 | 1500 | 107358 | 10256 | 53.9333 | -116.5765 | 2021-01-22 05:22:10 | Alberta, Canada | ||
1093852 | 1093852 | 2021-01-20 | Canada | Alberta | 118436 | 1484 | 106387 | 10565 | 53.9333 | -116.5765 | 2021-01-21 05:22:01 | Alberta, Canada | ||
907942 | 907942 | 2021-01-19 | Canada | Alberta | 117767 | 1463 | 105208 | 11096 | 53.9333 | -116.5765 | 2021-01-20 05:21:54 | Alberta, Canada | ||
237005 | 237005 | 2021-01-18 | Canada | Alberta | 117311 | 1447 | 103941 | 11923 | 53.9333 | -116.5765 | 2021-01-19 05:22:15 | Alberta, Canada | ||
3503122 | 3503122 | 2021-01-17 | Canada | Alberta | 116837 | 1436 | 103167 | 12234 | 53.9333 | -116.5765 | 2021-01-18 05:22:34 | Alberta, Canada | ||
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 |
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]);