⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

463 rows where country_or_region = "Canada" and province_or_state = "Alberta" sorted by day descending

View and edit SQL

Suggested facets: day (date), last_update (date)

province_or_state

  • Alberta · 463

country_or_region

  • Canada · 463
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
222690 2021-06-14 Canada Alberta     230578 2270 225219 3089 53.9333 -116.5765 2021-06-15 04:22:22 Alberta, Canada
214722 2021-06-13 Canada Alberta     230463 2270 225013 3180 53.9333 -116.5765 2021-06-14 04:22:46 Alberta, Canada
281292 2021-06-12 Canada Alberta     230298 2269 224782 3247 53.9333 -116.5765 2021-06-13 04:22:44 Alberta, Canada
1633391 2021-06-11 Canada Alberta     230119 2265 224325 3529 53.9333 -116.5765 2021-06-12 04:22:22 Alberta, Canada
662677 2021-06-10 Canada Alberta     229949 2262 223877 3810 53.9333 -116.5765 2021-06-11 04:23:20 Alberta, Canada
881781 2021-06-09 Canada Alberta     229771 2256 223311 4204 53.9333 -116.5765 2021-06-10 04:23:17 Alberta, Canada
1709780 2021-06-08 Canada Alberta     229458 2251 222776 4431 53.9333 -116.5765 2021-06-09 04:23:31 Alberta, Canada
1465624 2021-06-07 Canada Alberta     229319 2248 222364 4707 53.9333 -116.5765 2021-06-08 04:22:35 Alberta, Canada
993391 2021-06-06 Canada Alberta     229192 2246 222062 4884 53.9333 -116.5765 2021-06-07 04:22:51 Alberta, Canada
158181 2021-06-05 Canada Alberta     228961 2246 221644 5071 53.9333 -116.5765 2021-06-06 04:24:03 Alberta, Canada
1516166 2021-06-04 Canada Alberta     228668 2243 221010 5415 53.9333 -116.5765 2021-06-05 04:23:03 Alberta, Canada
1140477 2021-06-03 Canada Alberta     228424 2236 220357 5831 53.9333 -116.5765 2021-06-04 04:23:37 Alberta, Canada
426921 2021-06-02 Canada Alberta     228128 2231 219592 6305 53.9333 -116.5765 2021-06-03 04:23:32 Alberta, Canada
539428 2021-06-01 Canada Alberta     227718 2228 218719 6771 53.9333 -116.5765 2021-06-02 04:24:34 Alberta, Canada
786613 2021-05-31 Canada Alberta     227509 2227 217636 7646 53.9333 -116.5765 2021-06-01 04:23:09 Alberta, Canada
1330011 2021-05-30 Canada Alberta     227246 2219 216954 8073 53.9333 -116.5765 2021-05-31 03:08:59 Alberta, Canada
67220 2021-05-29 Canada Alberta     226855 2214 216167 8474 53.9333 -116.5765 2021-05-30 04:20:55 Alberta, Canada
195406 2021-05-28 Canada Alberta     226449 2206 214966 9277 53.9333 -116.5765 2021-05-29 04:20:41 Alberta, Canada
938665 2021-05-27 Canada Alberta     225937 2199 213721 10017 53.9333 -116.5765 2021-05-28 04:20:36 Alberta, Canada
1226340 2021-05-26 Canada Alberta     225424 2198 212273 10953 53.9333 -116.5765 2021-05-27 04:20:59 Alberta, Canada
1337979 2021-05-25 Canada Alberta     225034 2192 210764 12078 53.9333 -116.5765 2021-05-26 04:20:35 Alberta, Canada
202811 2021-05-24 Canada Alberta     224647 2183 208856 13608 53.9333 -116.5765 2021-05-25 04:21:08 Alberta, Canada
98975 2021-05-23 Canada Alberta     224195 2176 207486 14533 53.9333 -116.5765 2021-05-24 04:20:53 Alberta, Canada
523494 2021-05-22 Canada Alberta     223632 2170 205960 15502 53.9333 -116.5765 2021-05-23 04:20:51 Alberta, Canada
859189 2021-05-21 Canada Alberta     223011 2164 204270 16577 53.9333 -116.5765 2021-05-22 04:20:45 Alberta, Canada
720612 2021-05-20 Canada Alberta     222279 2162 202442 17675 53.9333 -116.5765 2021-05-21 04:20:43 Alberta, Canada
407743 2021-05-19 Canada Alberta     221467 2158 200496 18813 53.9333 -116.5765 2021-05-20 04:21:05 Alberta, Canada
782629 2021-05-18 Canada Alberta     220559 2152 198394 20013 53.9333 -116.5765 2021-05-19 04:20:42 Alberta, Canada
1422771 2021-05-17 Canada Alberta     219682 2148 196246 21288 53.9333 -116.5765 2021-05-18 04:20:33 Alberta, Canada
739957 2021-05-16 Canada Alberta     218961 2143 194538 22280 53.9333 -116.5765 2021-05-17 04:20:34 Alberta, Canada
1116490 2021-05-15 Canada Alberta     217821 2140 192688 22993 53.9333 -116.5765 2021-05-16 04:20:49 Alberta, Canada
1586999 2021-05-14 Canada Alberta     216626 2137 190616 23873 53.9333 -116.5765 2021-05-15 04:20:58 Alberta, Canada
1674916 2021-05-13 Canada Alberta     215193 2132 188475 24586 53.9333 -116.5765 2021-05-14 04:20:41 Alberta, Canada
802543 2021-05-12 Canada Alberta     213635 2123 186550 24962 53.9333 -116.5765 2021-05-13 04:20:51 Alberta, Canada
1180931 2021-05-11 Canada Alberta     211836 2119 184719 24998 53.9333 -116.5765 2021-05-12 04:21:29 Alberta, Canada
324721 2021-05-10 Canada Alberta     210387 2117 182832 25438 53.9333 -116.5765 2021-05-11 04:20:41 Alberta, Canada
603868 2021-05-09 Canada Alberta     208790 2110 181483 25197 53.9333 -116.5765 2021-05-10 04:20:38 Alberta, Canada
985615 2021-05-08 Canada Alberta     207157 2108 179894 25155 53.9333 -116.5765 2021-05-09 04:20:35 Alberta, Canada
434097 2021-05-07 Canada Alberta     205115 2106 178149 24860 53.9333 -116.5765 2021-05-08 04:21:04 Alberta, Canada
900878 2021-05-06 Canada Alberta     203135 2102 176536 24497 53.9333 -116.5765 2021-05-07 04:20:40 Alberta, Canada
71204 2021-05-05 Canada Alberta     200924 2102 174666 24156 53.9333 -116.5765 2021-05-06 04:20:38 Alberta, Canada
790597 2021-05-04 Canada Alberta     198653 2099 172931 23623 53.9333 -116.5765 2021-05-05 04:20:43 Alberta, Canada
1613127 2021-05-03 Canada Alberta     196910 2090 171212 23608 53.9333 -116.5765 2021-05-04 04:20:34 Alberta, Canada
885765 2021-05-02 Canada Alberta     194898 2086 169892 22920 53.9333 -116.5765 2021-05-03 04:20:39 Alberta, Canada
511470 2021-05-01 Canada Alberta     193167 2083 168580 22504 53.9333 -116.5765 2021-05-02 04:20:48 Alberta, Canada
14406 2021-04-30 Canada Alberta     190734 2082 166824 21828 53.9333 -116.5765 2021-05-01 04:20:47 Alberta, Canada
1124510 2021-04-29 Canada Alberta     188727 2075 165267 21385 53.9333 -116.5765 2021-04-30 04:21:03 Alberta, Canada
461807 2021-04-28 Canada Alberta     186679 2073 163668 20938 53.9333 -116.5765 2021-04-29 04:20:55 Alberta, Canada
1314513 2021-04-27 Canada Alberta     184840 2067 162052 20721 53.9333 -116.5765 2021-04-28 04:20:32 Alberta, Canada
1548940 2021-04-26 Canada Alberta     183301 2074 160617 20610 53.9333 -116.5765 2021-04-27 04:20:52 Alberta, Canada
1629407 2021-04-25 Canada Alberta     181806 2067 159603 20136 53.9333 -116.5765 2021-04-26 04:21:04 Alberta, Canada
353547 2021-04-24 Canada Alberta     180369 2064 158603 19702 53.9333 -116.5765 2021-04-25 04:20:32 Alberta, Canada
724596 2021-04-23 Canada Alberta     178777 2059 157272 19446 53.9333 -116.5765 2021-04-24 04:20:38 Alberta, Canada
1469608 2021-04-22 Canada Alberta     177087 2054 155851 19182 53.9333 -116.5765 2021-04-23 04:20:52 Alberta, Canada
1222356 2021-04-21 Canada Alberta     175230 2048 153002 20180 53.9333 -116.5765 2021-04-22 04:20:53 Alberta, Canada
457823 2021-04-20 Canada Alberta     173531 2048 153002 18481 53.9333 -116.5765 2021-04-21 04:21:14 Alberta, Canada
1300011 2021-04-19 Canada Alberta     172186 2043 151719 18424 53.9333 -116.5765 2021-04-20 04:20:41 Alberta, Canada
1069590 2021-04-18 Canada Alberta     170795 2040 150820 17935 53.9333 -116.5765 2021-04-19 04:20:57 Alberta, Canada
1045472 2021-04-17 Canada Alberta     169279 2037 149935 17307 53.9333 -116.5765 2021-04-18 04:20:41 Alberta, Canada
596748 2021-04-16 Canada Alberta     167793 2034 149000 16759 53.9333 -116.5765 2021-04-17 04:20:40 Alberta, Canada
1621164 2021-04-15 Canada Alberta     166177 2034 147920 16223 53.9333 -116.5765 2021-04-16 04:20:46 Alberta, Canada
950595 2021-04-14 Canada Alberta     164531 2029 146933 15569 53.9333 -116.5765 2021-04-15 04:20:54 Alberta, Canada
592764 2021-04-13 Canada Alberta     163119 2021 146011 15087 53.9333 -116.5765 2021-04-14 04:20:41 Alberta, Canada
32703 2021-04-12 Canada Alberta     162038 2018 145171 14849 53.9333 -116.5765 2021-04-13 04:20:37 Alberta, Canada
1371718 2021-04-11 Canada Alberta     160902 2013 144596 14293 53.9333 -116.5765 2021-04-12 04:21:00 Alberta, Canada
1666970 2021-04-10 Canada Alberta     159719 2012 144020 13687 53.9333 -116.5765 2021-04-11 04:20:56 Alberta, Canada
1159586 2021-04-09 Canada Alberta     158426 2007 143360 13059 53.9333 -116.5765 2021-04-10 04:20:59 Alberta, Canada
1057421 2021-04-08 Canada Alberta     156905 2005 142713 12187 53.9333 -116.5765 2021-04-09 04:21:13 Alberta, Canada
1500210 2021-04-07 Canada Alberta     155476 2002 142010 11464 53.9333 -116.5765 2021-04-08 04:21:13 Alberta, Canada
1207415 2021-04-06 Canada Alberta     154125 2001 141315 10809 53.9333 -116.5765 2021-04-07 04:20:53 Alberta, Canada
122716 2021-04-05 Canada Alberta     153194 1998 140614 10582 53.9333 -116.5765 2021-04-06 04:20:32 Alberta, Canada
1254517 2021-04-04 Canada Alberta     150307 1994 138560 9753 53.9333 -116.5765 2021-04-05 04:20:35 Alberta, Canada
1128494 2021-04-03 Canada Alberta     150307 1994 138560 9753 53.9333 -116.5765 2021-04-04 04:20:49 Alberta, Canada
269885 2021-04-02 Canada Alberta     149207 1994 138560 8653 53.9333 -116.5765 2021-04-03 04:20:44 Alberta, Canada
1173217 2021-04-01 Canada Alberta     149207 1994 138560 8653 53.9333 -116.5765 2021-04-02 04:20:36 Alberta, Canada
515528 2021-03-31 Canada Alberta     148332 1990 137992 8350 53.9333 -116.5765 2021-04-01 04:27:05 Alberta, Canada
289257 2021-03-30 Canada Alberta     147461 1987 137499 7975 53.9333 -116.5765 2021-03-31 04:26:25 Alberta, Canada
1574794 2021-03-29 Canada Alberta     146885 1983 136980 7922 53.9333 -116.5765 2021-03-30 04:26:23 Alberta, Canada
631071 2021-03-28 Canada Alberta     146340 1983 136659 7698 53.9333 -116.5765 2021-03-29 04:28:35 Alberta, Canada
607852 2021-03-27 Canada Alberta     145696 1980 136350 7366 53.9333 -116.5765 2021-03-28 05:28:10 Alberta, Canada
1333995 2021-03-26 Canada Alberta     145028 1979 135972 7077 53.9333 -116.5765 2021-03-27 05:25:04 Alberta, Canada
150434 2021-03-25 Canada Alberta     144311 1976 135500 6835 53.9333 -116.5765 2021-03-26 05:26:55 Alberta, Canada
1597955 2021-03-24 Canada Alberta     143547 1973 135040 6534 53.9333 -116.5765 2021-03-25 05:27:00 Alberta, Canada
403759 2021-03-23 Canada Alberta     142855 1971 134653 6231 53.9333 -116.5765 2021-03-24 05:25:40 Alberta, Canada
1387296 2021-03-22 Canada Alberta     142390 1968 134246 6176 53.9333 -116.5765 2021-03-23 05:26:18 Alberta, Canada
304783 2021-03-21 Canada Alberta     141934 1963 134000 5971 53.9333 -116.5765 2021-03-22 05:25:43 Alberta, Canada
253832 2021-03-20 Canada Alberta     141379 1961 133800 5618 53.9333 -116.5765 2021-03-21 05:25:44 Alberta, Canada
1230588 2021-03-19 Canada Alberta     140823 1957 133437 5429 53.9333 -116.5765 2021-03-20 05:25:46 Alberta, Canada
974513 2021-03-18 Canada Alberta     140127 1957 133086 5084 53.9333 -116.5765 2021-03-19 05:26:09 Alberta, Canada
1532148 2021-03-17 Canada Alberta     139622 1956 132748 4918 53.9333 -116.5765 2021-03-18 05:26:22 Alberta, Canada
55342 2021-03-16 Canada Alberta     139143 1952 132415 4776 53.9333 -116.5765 2021-03-17 05:25:07 Alberta, Canada
562655 2021-03-15 Canada Alberta     138788 1949 132028 4811 53.9333 -116.5765 2021-03-16 05:25:13 Alberta, Canada
851224 2021-03-14 Canada Alberta     138424 1946 131781 4697 53.9333 -116.5765 2021-03-15 05:25:51 Alberta, Canada
942649 2021-03-13 Canada Alberta     138036 1940 131502 4594 53.9333 -116.5765 2021-03-14 05:25:37 Alberta, Canada
1310529 2021-03-12 Canada Alberta     137562 1935 131081 4546 53.9333 -116.5765 2021-03-13 05:25:15 Alberta, Canada
1077367 2021-03-11 Canada Alberta     137137 1933 130716 4488 53.9333 -116.5765 2021-03-12 05:26:50 Alberta, Canada
954579 2021-03-10 Canada Alberta     136773 1928 130382 4463 53.9333 -116.5765 2021-03-11 05:25:48 Alberta, Canada
543412 2021-03-09 Canada Alberta     136374 1926 129978 4470 53.9333 -116.5765 2021-03-10 05:24:35 Alberta, Canada
1520150 2021-03-08 Canada Alberta     136119 1920 129566 4633 53.9333 -116.5765 2021-03-09 05:28:19 Alberta, Canada
866431 2021-03-07 Canada Alberta     135837 1914 128974 4949 53.9333 -116.5765 2021-03-08 05:24:48 Alberta, Canada

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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] INTEGER,
   [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]);