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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
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 |
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]);