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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
2689448 | 2689448 | 2020-10-08 | Canada | Alberta | 19718 | 283 | 17338 | 2097 | 53.9333 | -116.5765 | 2020-10-09 04:23:59 | Alberta, Canada | ||
1041590 | 1041590 | 2020-10-07 | Canada | Alberta | 19354 | 281 | 17163 | 1910 | 53.9333 | -116.5765 | 2020-10-08 04:23:56 | Alberta, Canada | ||
3117251 | 3117251 | 2020-10-06 | Canada | Alberta | 19211 | 281 | 17030 | 1900 | 53.9333 | -116.5765 | 2020-10-07 04:23:40 | Alberta, Canada | ||
3801663 | 3801663 | 2020-10-05 | Canada | Alberta | 18935 | 280 | 16872 | 1783 | 53.9333 | -116.5765 | 2020-10-06 04:23:33 | Alberta, Canada | ||
1822553 | 1822553 | 2020-10-04 | Canada | Alberta | 18357 | 272 | 16527 | 1558 | 53.9333 | -116.5765 | 2020-10-05 04:23:33 | Alberta, Canada | ||
2513937 | 2513937 | 2020-10-03 | Canada | Alberta | 18357 | 272 | 16527 | 1558 | 53.9333 | -116.5765 | 2020-10-04 04:23:44 | Alberta, Canada | ||
3389155 | 3389155 | 2020-10-02 | Canada | Alberta | 18357 | 272 | 16527 | 1558 | 53.9333 | -116.5765 | 2020-10-03 04:23:40 | Alberta, Canada | ||
2379396 | 2379396 | 2020-10-01 | Canada | Alberta | 18235 | 269 | 16370 | 1596 | 53.9333 | -116.5765 | 2020-10-02 04:23:51 | Alberta, Canada | ||
1045582 | 1045582 | 2020-09-30 | Canada | Alberta | 18062 | 267 | 16213 | 1582 | 53.9333 | -116.5765 | 2020-10-01 04:23:42 | Alberta, Canada | ||
966663 | 966663 | 2020-09-29 | Canada | Alberta | 17909 | 266 | 16072 | 1571 | 53.9333 | -116.5765 | 2020-09-30 04:23:33 | Alberta, Canada | ||
1515160 | 1515160 | 2020-09-28 | Canada | Alberta | 17749 | 265 | 15935 | 1549 | 53.9333 | -116.5765 | 2020-09-29 04:23:42 | Alberta, Canada | ||
2581748 | 2581748 | 2020-09-27 | Canada | Alberta | 17343 | 261 | 15585 | 1497 | 53.9333 | -116.5765 | 2020-09-28 04:23:00 | Alberta, Canada | ||
2613800 | 2613800 | 2020-09-26 | Canada | Alberta | 17343 | 261 | 15585 | 1497 | 53.9333 | -116.5765 | 2020-09-27 04:23:00 | Alberta, Canada | ||
2812515 | 2812515 | 2020-09-25 | Canada | Alberta | 17343 | 261 | 15585 | 1497 | 53.9333 | -116.5765 | 2020-09-26 04:23:00 | Alberta, Canada | ||
2605792 | 2605792 | 2020-09-24 | Canada | Alberta | 17190 | 261 | 15467 | 1462 | 53.9333 | -116.5765 | 2020-09-25 04:23:00 | Alberta, Canada | ||
2653535 | 2653535 | 2020-09-23 | Canada | Alberta | 17032 | 260 | 15252 | 1520 | 53.9333 | -116.5765 | 2020-09-24 04:23:00 | Alberta, Canada | ||
3315984 | 3315984 | 2020-09-22 | Canada | Alberta | 16889 | 258 | 15066 | 1565 | 53.9333 | -116.5765 | 2020-09-23 04:23:00 | Alberta, Canada | ||
2836583 | 2836583 | 2020-09-21 | Canada | Alberta | 16739 | 256 | 15024 | 1459 | 53.9333 | -116.5765 | 2020-09-22 04:23:00 | Alberta, Canada | ||
3093188 | 3093188 | 2020-09-20 | Canada | Alberta | 16381 | 255 | 14702 | 1424 | 53.9333 | -116.5765 | 2020-09-21 04:23:00 | Alberta, Canada | ||
2454538 | 2454538 | 2020-09-19 | Canada | Alberta | 16381 | 255 | 14702 | 1424 | 53.9333 | -116.5765 | 2020-09-20 04:22:00 | Alberta, Canada | ||
2848607 | 2848607 | 2020-09-18 | Canada | Alberta | 16381 | 255 | 14702 | 1424 | 53.9333 | -116.5765 | 2020-09-19 04:22:00 | Alberta, Canada | ||
1121356 | 1121356 | 2020-09-17 | Canada | Alberta | 16274 | 254 | 14573 | 1447 | 53.9333 | -116.5765 | 2020-09-18 05:05:00 | Alberta, Canada | ||
666045 | 666045 | 2020-09-16 | Canada | Alberta | 16128 | 254 | 14379 | 1495 | 53.9333 | -116.5765 | 2020-09-17 04:22:00 | Alberta, Canada | ||
2728770 | 2728770 | 2020-09-15 | Canada | Alberta | 15957 | 254 | 14212 | 1491 | 53.9333 | -116.5765 | 2020-09-16 04:22:53 | Alberta, Canada | ||
344042 | 344042 | 2020-09-14 | Canada | Alberta | 15833 | 254 | 14041 | 1538 | 53.9333 | -116.5765 | 2020-09-15 03:22:50 | Alberta, Canada | ||
2868481 | 2868481 | 2020-09-13 | Canada | Alberta | 15415 | 253 | 13718 | 1444 | 53.9333 | -116.5765 | 2020-09-14 04:26:00 | Alberta, Canada | ||
546520 | 546520 | 2020-09-12 | Canada | Alberta | 15415 | 253 | 13718 | 1444 | 53.9333 | -116.5765 | 2020-09-13 04:30:52 | Alberta, Canada | ||
1444349 | 1444349 | 2020-09-11 | Canada | Alberta | 15415 | 253 | 13718 | 1444 | 53.9333 | -116.5765 | 2020-09-12 04:25:05 | Alberta, Canada | ||
1172950 | 1172950 | 2020-09-10 | Canada | Alberta | 15304 | 253 | 13557 | 1494 | 53.9333 | -116.5765 | 2020-09-11 04:46:23 | Alberta, Canada | ||
2171315 | 2171315 | 2020-09-09 | Canada | Alberta | 15093 | 247 | 13154 | 1692 | 53.9333 | -116.5765 | 2020-09-10 04:29:01 | Alberta, Canada | ||
1243524 | 1243524 | 2020-09-08 | Canada | Alberta | 15093 | 247 | 13154 | 1692 | 53.9333 | -116.5765 | 2020-09-09 04:28:48 | Alberta, Canada | ||
427103 | 427103 | 2020-09-07 | Canada | Alberta | 14474 | 242 | 12799 | 1433 | 53.9333 | -116.5765 | 2020-09-08 04:28:25 | Alberta, Canada | ||
3161388 | 3161388 | 2020-09-06 | Canada | Alberta | 14474 | 242 | 12799 | 1433 | 53.9333 | -116.5765 | 2020-09-07 04:28:30 | Alberta, Canada | ||
813343 | 813343 | 2020-09-05 | Canada | Alberta | 14474 | 242 | 12799 | 1433 | 53.9333 | -116.5765 | 2020-09-06 04:28:33 | Alberta, Canada | ||
2661543 | 2661543 | 2020-09-04 | Canada | Alberta | 14474 | 242 | 12799 | 1433 | 53.9333 | -116.5765 | 2020-09-05 04:28:19 | Alberta, Canada | ||
1354083 | 1354083 | 2020-09-03 | Canada | Alberta | 14310 | 242 | 12653 | 1415 | 53.9333 | -116.5765 | 2020-09-04 04:28:26 | Alberta, Canada | ||
1105320 | 1105320 | 2020-09-02 | Canada | Alberta | 14180 | 242 | 12535 | 1403 | 53.9333 | -116.5765 | 2020-09-03 04:28:22 | Alberta, Canada | ||
2059649 | 2059649 | 2020-09-01 | Canada | Alberta | 14066 | 241 | 12427 | 1398 | 53.9333 | -116.5765 | 2020-09-02 04:28:25 | Alberta, Canada | ||
193834 | 193834 | 2020-08-31 | Canada | Alberta | 13902 | 239 | 12293 | 1370 | 53.9333 | -116.5765 | 2020-09-01 04:28:31 | Alberta, Canada | ||
3931793 | 3931793 | 2020-08-30 | Canada | Alberta | 13476 | 237 | 12054 | 1185 | 53.9333 | -116.5765 | 2020-08-31 04:28:27 | Alberta, Canada | ||
609455 | 609455 | 2020-08-29 | Canada | Alberta | 13476 | 237 | 12054 | 1185 | 53.9333 | -116.5765 | 2020-08-30 04:28:22 | Alberta, Canada | ||
1522950 | 1522950 | 2020-08-28 | Canada | Alberta | 13476 | 237 | 12054 | 1185 | 53.9333 | -116.5765 | 2020-08-29 04:28:19 | Alberta, Canada | ||
2509951 | 2509951 | 2020-08-27 | Canada | Alberta | 13318 | 237 | 11923 | 1158 | 53.9333 | -116.5765 | 2020-08-28 04:28:11 | Alberta, Canada | ||
1996411 | 1996411 | 2020-08-26 | Canada | Alberta | 13210 | 235 | 11799 | 1176 | 53.9333 | -116.5765 | 2020-08-27 04:28:15 | Alberta, Canada | ||
3562335 | 3562335 | 2020-08-25 | Canada | Alberta | 13083 | 235 | 11714 | 1134 | 53.9333 | -116.5765 | 2020-08-26 04:28:11 | Alberta, Canada | ||
2991039 | 2991039 | 2020-08-24 | Canada | Alberta | 13006 | 234 | 11600 | 1172 | 53.9333 | -116.5765 | 2020-08-25 04:28:02 | Alberta, Canada | ||
2215434 | 2215434 | 2020-08-23 | Canada | Alberta | 12748 | 230 | 11374 | 1144 | 53.9333 | -116.5765 | 2020-08-24 04:27:56 | Alberta, Canada | ||
2299216 | 2299216 | 2020-08-22 | Canada | Alberta | 12748 | 230 | 11374 | 1144 | 53.9333 | -116.5765 | 2020-08-23 04:27:48 | Alberta, Canada | ||
1479323 | 1479323 | 2020-08-21 | Canada | Alberta | 12748 | 230 | 11374 | 1144 | 53.9333 | -116.5765 | 2020-08-22 04:27:49 | Alberta, Canada | ||
3484072 | 3484072 | 2020-08-20 | Canada | Alberta | 12501 | 227 | 11167 | 1107 | 53.9333 | -116.5765 | 2020-08-21 04:27:41 | Alberta, Canada | ||
206021 | 206021 | 2020-08-19 | Canada | Alberta | 12501 | 227 | 11167 | 1107 | 53.9333 | -116.5765 | 2020-08-20 04:27:43 | Alberta, Canada | ||
3177775 | 3177775 | 2020-08-18 | Canada | Alberta | 12419 | 225 | 11025 | 1169 | 53.9333 | -116.5765 | 2020-08-19 04:27:00 | Alberta, Canada | ||
837379 | 837379 | 2020-08-17 | Canada | Alberta | 12053 | 221 | 10796 | 1036 | 53.9333 | -116.5765 | 2020-08-18 04:27:56 | Alberta, Canada | ||
1555737 | 1555737 | 2020-08-16 | Canada | Alberta | 12053 | 221 | 10796 | 1036 | 53.9333 | -116.5765 | 2020-08-17 04:27:20 | Alberta, Canada | ||
145739 | 145739 | 2020-08-15 | Canada | Alberta | 12053 | 221 | 10796 | 1036 | 53.9333 | -116.5765 | 2020-08-16 04:27:42 | Alberta, Canada | ||
1612014 | 1612014 | 2020-08-14 | Canada | Alberta | 12053 | 221 | 10796 | 1036 | 53.9333 | -116.5765 | 2020-08-15 04:27:31 | Alberta, Canada | ||
582598 | 582598 | 2020-08-13 | Canada | Alberta | 11969 | 220 | 10713 | 1036 | 53.9333 | -116.5765 | 2020-08-14 04:51:19 | Alberta, Canada | ||
3531217 | 3531217 | 2020-08-12 | Canada | Alberta | 11893 | 217 | 10632 | 1044 | 53.9333 | -116.5765 | 2020-08-13 04:29:15 | Alberta, Canada | ||
662066 | 662066 | 2020-08-11 | Canada | Alberta | 11772 | 216 | 10552 | 1004 | 53.9333 | -116.5765 | 2020-08-12 04:27:29 | Alberta, Canada | ||
1920166 | 1920166 | 2020-08-10 | Canada | Alberta | 11687 | 213 | 10384 | 1090 | 53.9333 | -116.5765 | 2020-08-11 04:35:08 | Alberta, Canada | ||
3922975 | 3922975 | 2020-08-09 | Canada | Alberta | 11430 | 208 | 10097 | 1125 | 53.9333 | -116.5765 | 2020-08-10 04:34:55 | Alberta, Canada | ||
371143 | 371143 | 2020-08-08 | Canada | Alberta | 11430 | 208 | 10097 | 1125 | 53.9333 | -116.5765 | 2020-08-09 04:34:54 | Alberta, Canada | ||
458327 | 458327 | 2020-08-07 | Canada | Alberta | 11430 | 208 | 10097 | 1125 | 53.9333 | -116.5765 | 2020-08-08 04:34:53 | Alberta, Canada | ||
3612012 | 3612012 | 2020-08-06 | Canada | Alberta | 11296 | 205 | 9984 | 1107 | 53.9333 | -116.5765 | 2020-08-07 04:35:11 | Alberta, Canada | ||
3792842 | 3792842 | 2020-08-05 | Canada | Alberta | 11240 | 203 | 9891 | 1146 | 53.9333 | -116.5765 | 2020-08-06 04:35:02 | Alberta, Canada | ||
98078 | 98078 | 2020-08-04 | Canada | Alberta | 11146 | 201 | 9754 | 1191 | 53.9333 | -116.5765 | 2020-08-05 04:34:43 | Alberta, Canada | ||
2739961 | 2739961 | 2020-08-03 | Canada | Alberta | 10843 | 196 | 9261 | 1386 | 53.9333 | -116.5765 | 2020-08-04 04:41:59 | Alberta, Canada | ||
2807713 | 2807713 | 2020-08-02 | Canada | Alberta | 10843 | 196 | 9261 | 1386 | 53.9333 | -116.5765 | 2020-08-03 04:34:35 | Alberta, Canada | ||
753281 | 753281 | 2020-08-01 | Canada | Alberta | 10843 | 196 | 9261 | 1386 | 53.9333 | -116.5765 | 2020-08-02 04:34:47 | Alberta, Canada | ||
3264446 | 3264446 | 2020-07-31 | Canada | Alberta | 10843 | 196 | 9261 | 1386 | 53.9333 | -116.5765 | 2020-08-01 04:36:27 | Alberta, Canada | ||
1928153 | 1928153 | 2020-07-30 | Canada | Alberta | 10716 | 195 | 9113 | 1408 | 53.9333 | -116.5765 | 2020-07-31 04:35:18 | Alberta, Canada | ||
2958321 | 2958321 | 2020-07-29 | Canada | Alberta | 10603 | 190 | 8983 | 1430 | 53.9333 | -116.5765 | 2020-07-30 04:35:05 | Alberta, Canada | ||
3184937 | 3184937 | 2020-07-28 | Canada | Alberta | 10470 | 187 | 8886 | 1397 | 53.9333 | -116.5765 | 2020-07-29 04:35:11 | Alberta, Canada | ||
176989 | 176989 | 2020-07-27 | Canada | Alberta | 10390 | 186 | 8774 | 1430 | 53.9333 | -116.5765 | 2020-07-28 04:58:43 | Alberta, Canada | ||
442302 | 442302 | 2020-07-26 | Canada | Alberta | 10086 | 178 | 8567 | 1341 | 53.9333 | -116.5765 | 2020-07-27 04:35:02 | Alberta, Canada | ||
1502546 | 1502546 | 2020-07-25 | Canada | Alberta | 10086 | 178 | 8567 | 1341 | 53.9333 | -116.5765 | 2020-07-26 04:35:00 | Alberta, Canada | ||
2563516 | 2563516 | 2020-07-24 | Canada | Alberta | 10086 | 178 | 8567 | 1341 | 53.9333 | -116.5765 | 2020-07-25 04:47:39 | Alberta, Canada | ||
61747 | 61747 | 2020-07-23 | Canada | Alberta | 9975 | 176 | 8506 | 1293 | 53.9333 | -116.5765 | 2020-07-24 05:30:40 | Alberta, Canada | ||
844536 | 844536 | 2020-07-22 | Canada | Alberta | 9728 | 172 | 8363 | 1193 | 53.9333 | -116.5765 | 2020-07-23 05:15:04 | Alberta, Canada | ||
1707275 | 1707275 | 2020-07-21 | Canada | Alberta | 9728 | 172 | 8363 | 1193 | 53.9333 | -116.5765 | 2020-07-22 04:34:42 | Alberta, Canada | ||
326766 | 326766 | 2020-07-20 | Canada | Alberta | 9587 | 170 | 8308 | 1109 | 53.9333 | -116.5765 | 2020-07-21 04:38:46 | Alberta, Canada | ||
121671 | 121671 | 2020-07-19 | Canada | Alberta | 9219 | 167 | 8193 | 859 | 53.9333 | -116.5765 | 2020-07-20 05:34:40 | Alberta, Canada | ||
3205060 | 3205060 | 2020-07-18 | Canada | Alberta | 9219 | 167 | 8193 | 859 | 53.9333 | -116.5765 | 2020-07-19 04:34:58 | Alberta, Canada | ||
2708362 | 2708362 | 2020-07-17 | Canada | Alberta | 9219 | 167 | 8193 | 859 | 53.9333 | -116.5765 | 2020-07-18 04:34:45 | Alberta, Canada | ||
367181 | 367181 | 2020-07-16 | Canada | Alberta | 9114 | 165 | 8142 | 807 | 53.9333 | -116.5765 | 2020-07-17 04:34:50 | Alberta, Canada | ||
2747849 | 2747849 | 2020-07-15 | Canada | Alberta | 8994 | 163 | 8127 | 704 | 53.9333 | -116.5765 | 2020-07-16 04:44:59 | Alberta, Canada | ||
2158493 | 2158493 | 2020-07-14 | Canada | Alberta | 8912 | 163 | 8048 | 701 | 53.9333 | -116.5765 | 2020-07-15 04:34:39 | Alberta, Canada | ||
3491134 | 3491134 | 2020-07-13 | Canada | Alberta | 8826 | 161 | 7989 | 676 | 53.9333 | -116.5765 | 2020-07-14 04:34:46 | Alberta, Canada | ||
3737396 | 3737396 | 2020-07-12 | Canada | Alberta | 8596 | 160 | 7844 | 592 | 53.9333 | -116.5765 | 2020-07-13 04:43:04 | Alberta, Canada | ||
3435791 | 3435791 | 2020-07-11 | Canada | Alberta | 8596 | 160 | 7844 | 592 | 53.9333 | -116.5765 | 2020-07-12 04:34:30 | Alberta, Canada | ||
3237289 | 3237289 | 2020-07-10 | Canada | Alberta | 8596 | 161 | 7844 | 591 | 53.9333 | -116.5765 | 2020-07-11 04:34:26 | 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]);