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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2462555 | 2462555 | 2021-09-14 | Canada | Alberta | 272211 | 2471 | 0 | 53.9333 | -116.5765 | 2021-09-15 03:22:37 | Alberta, Canada | |||
1385394 | 1385394 | 2021-09-13 | Canada | Alberta | 270777 | 2462 | 0 | 53.9333 | -116.5765 | 2021-09-14 04:21:41 | Alberta, Canada | |||
1884763 | 1884763 | 2021-09-12 | Canada | Alberta | 266037 | 2444 | 0 | 53.9333 | -116.5765 | 2021-09-13 04:21:15 | Alberta, Canada | |||
3805666 | 3805666 | 2021-09-11 | Canada | Alberta | 266037 | 2444 | 0 | 53.9333 | -116.5765 | 2021-09-12 04:21:13 | Alberta, Canada | |||
3448606 | 3448606 | 2021-09-10 | Canada | Alberta | 266037 | 2444 | 0 | 53.9333 | -116.5765 | 2021-09-11 04:21:30 | Alberta, Canada | |||
1262552 | 1262552 | 2021-09-09 | Canada | Alberta | 264564 | 2434 | 0 | 53.9333 | -116.5765 | 2021-09-10 04:21:20 | Alberta, Canada | |||
2278922 | 2278922 | 2021-09-08 | Canada | Alberta | 263054 | 2425 | 0 | 53.9333 | -116.5765 | 2021-09-09 04:21:27 | Alberta, Canada | |||
641701 | 641701 | 2021-09-07 | Canada | Alberta | 261888 | 2407 | 0 | 53.9333 | -116.5765 | 2021-09-08 04:21:31 | Alberta, Canada | |||
3193764 | 3193764 | 2021-09-06 | Canada | Alberta | 256985 | 2390 | 0 | 53.9333 | -116.5765 | 2021-09-07 04:21:35 | Alberta, Canada | |||
3280632 | 3280632 | 2021-09-05 | Canada | Alberta | 256985 | 2390 | 0 | 53.9333 | -116.5765 | 2021-09-06 04:21:22 | Alberta, Canada | |||
249046 | 249046 | 2021-09-04 | Canada | Alberta | 256985 | 2390 | 0 | 53.9333 | -116.5765 | 2021-09-05 04:21:33 | Alberta, Canada | |||
3974327 | 3974327 | 2021-09-03 | Canada | Alberta | 256985 | 2390 | 0 | 53.9333 | -116.5765 | 2021-09-04 04:21:28 | Alberta, Canada | |||
177789 | 177789 | 2021-09-02 | Canada | Alberta | 255584 | 2388 | 0 | 53.9333 | -116.5765 | 2021-09-03 04:21:20 | Alberta, Canada | |||
66824 | 66824 | 2021-09-01 | Canada | Alberta | 254245 | 2383 | 0 | 53.9333 | -116.5765 | 2021-09-02 04:21:15 | Alberta, Canada | |||
2067666 | 2067666 | 2021-08-31 | Canada | Alberta | 252930 | 2375 | 0 | 53.9333 | -116.5765 | 2021-09-01 04:21:38 | Alberta, Canada | |||
1775120 | 1775120 | 2021-08-30 | Canada | Alberta | 252010 | 2371 | 0 | 53.9333 | -116.5765 | 2021-08-31 04:21:46 | Alberta, Canada | |||
3891694 | 3891694 | 2021-08-29 | Canada | Alberta | 248954 | 2364 | 0 | 53.9333 | -116.5765 | 2021-08-30 04:21:23 | Alberta, Canada | |||
2792797 | 2792797 | 2021-08-28 | Canada | Alberta | 248954 | 2364 | 0 | 53.9333 | -116.5765 | 2021-08-29 04:21:14 | Alberta, Canada | |||
2922956 | 2922956 | 2021-08-27 | Canada | Alberta | 248954 | 2364 | 0 | 53.9333 | -116.5765 | 2021-08-28 04:21:28 | Alberta, Canada | |||
1595970 | 1595970 | 2021-08-26 | Canada | Alberta | 247786 | 2360 | 0 | 53.9333 | -116.5765 | 2021-08-27 04:21:37 | Alberta, Canada | |||
32179 | 32179 | 2021-08-25 | Canada | Alberta | 246674 | 2356 | 0 | 53.9333 | -116.5765 | 2021-08-26 04:21:28 | Alberta, Canada | |||
3105218 | 3105218 | 2021-08-24 | Canada | Alberta | 245598 | 2355 | 0 | 53.9333 | -116.5765 | 2021-08-25 04:21:41 | Alberta, Canada | |||
3165389 | 3165389 | 2021-08-23 | Canada | Alberta | 244969 | 2348 | 0 | 53.9333 | -116.5765 | 2021-08-24 04:21:19 | Alberta, Canada | |||
2175316 | 2175316 | 2021-08-22 | Canada | Alberta | 242997 | 2343 | 0 | 53.9333 | -116.5765 | 2021-08-23 04:21:27 | Alberta, Canada | |||
3555412 | 3555412 | 2021-08-21 | Canada | Alberta | 242997 | 2343 | 0 | 53.9333 | -116.5765 | 2021-08-22 04:21:29 | Alberta, Canada | |||
1853754 | 1853754 | 2021-08-20 | Canada | Alberta | 242997 | 2343 | 0 | 53.9333 | -116.5765 | 2021-08-21 04:21:38 | Alberta, Canada | |||
511461 | 511461 | 2021-08-19 | Canada | Alberta | 242248 | 2342 | 0 | 53.9333 | -116.5765 | 2021-08-20 04:21:33 | Alberta, Canada | |||
2517940 | 2517940 | 2021-08-18 | Canada | Alberta | 241431 | 2338 | 0 | 53.9333 | -116.5765 | 2021-08-19 04:21:15 | Alberta, Canada | |||
245032 | 245032 | 2021-08-17 | Canada | Alberta | 240753 | 2336 | 0 | 53.9333 | -116.5765 | 2021-08-18 04:21:35 | Alberta, Canada | |||
1603995 | 1603995 | 2021-08-16 | Canada | Alberta | 240346 | 2333 | 0 | 53.9333 | -116.5765 | 2021-08-17 04:21:49 | Alberta, Canada | |||
103089 | 103089 | 2021-08-15 | Canada | Alberta | 238939 | 2332 | 0 | 53.9333 | -116.5765 | 2021-08-16 04:21:31 | Alberta, Canada | |||
507447 | 507447 | 2021-08-14 | Canada | Alberta | 238939 | 2332 | 0 | 53.9333 | -116.5765 | 2021-08-15 04:21:41 | Alberta, Canada | |||
1483319 | 1483319 | 2021-08-13 | Canada | Alberta | 238939 | 2332 | 0 | 53.9333 | -116.5765 | 2021-08-14 04:21:25 | Alberta, Canada | |||
2899449 | 2899449 | 2021-08-12 | Canada | Alberta | 238357 | 2331 | 0 | 53.9333 | -116.5765 | 2021-08-13 04:21:24 | Alberta, Canada | |||
1342053 | 1342053 | 2021-08-11 | Canada | Alberta | 237807 | 2331 | 0 | 53.9333 | -116.5765 | 2021-08-12 04:21:25 | Alberta, Canada | |||
2351200 | 2351200 | 2021-08-10 | Canada | Alberta | 237306 | 2330 | 0 | 53.9333 | -116.5765 | 2021-08-11 04:21:58 | Alberta, Canada | |||
649729 | 649729 | 2021-08-09 | Canada | Alberta | 237027 | 2328 | 0 | 53.9333 | -116.5765 | 2021-08-10 04:21:27 | Alberta, Canada | |||
589391 | 589391 | 2021-08-08 | Canada | Alberta | 236010 | 2325 | 0 | 53.9333 | -116.5765 | 2021-08-09 04:21:24 | Alberta, Canada | |||
2203403 | 2203403 | 2021-08-07 | Canada | Alberta | 236010 | 2325 | 0 | 53.9333 | -116.5765 | 2021-08-08 04:21:33 | Alberta, Canada | |||
1117353 | 1117353 | 2021-08-06 | Canada | Alberta | 236010 | 2325 | 0 | 53.9333 | -116.5765 | 2021-08-07 04:21:30 | Alberta, Canada | |||
1956290 | 1956290 | 2021-08-05 | Canada | Alberta | 235641 | 2329 | 0 | 53.9333 | -116.5765 | 2021-08-06 04:21:18 | Alberta, Canada | |||
331669 | 331669 | 2021-08-04 | Canada | Alberta | 235244 | 2328 | 230634 | 2282 | 53.9333 | -116.5765 | 2021-08-05 04:21:51 | Alberta, Canada | ||
3467940 | 3467940 | 2021-08-03 | Canada | Alberta | 235038 | 2328 | 230534 | 2176 | 53.9333 | -116.5765 | 2021-08-04 04:21:25 | Alberta, Canada | ||
3683214 | 3683214 | 2021-08-02 | Canada | Alberta | 234295 | 2328 | 230312 | 1655 | 53.9333 | -116.5765 | 2021-08-03 04:21:39 | Alberta, Canada | ||
3015113 | 3015113 | 2021-08-01 | Canada | Alberta | 234295 | 2328 | 230312 | 1655 | 53.9333 | -116.5765 | 2021-08-02 04:21:36 | Alberta, Canada | ||
3903736 | 3903736 | 2021-07-31 | Canada | Alberta | 234295 | 2328 | 230312 | 1655 | 53.9333 | -116.5765 | 2021-08-01 04:21:50 | Alberta, Canada | ||
3295941 | 3295941 | 2021-07-30 | Canada | Alberta | 234295 | 2328 | 230312 | 1655 | 53.9333 | -116.5765 | 2021-07-31 04:21:35 | Alberta, Canada | ||
3385152 | 3385152 | 2021-07-29 | Canada | Alberta | 234108 | 2325 | 230263 | 1520 | 53.9333 | -116.5765 | 2021-07-30 04:21:34 | Alberta, Canada | ||
408057 | 408057 | 2021-07-28 | Canada | Alberta | 233875 | 2325 | 230216 | 1334 | 53.9333 | -116.5765 | 2021-07-29 04:21:33 | Alberta, Canada | ||
1305918 | 1305918 | 2021-07-27 | Canada | Alberta | 233681 | 2325 | 230183 | 1173 | 53.9333 | -116.5765 | 2021-07-28 04:21:39 | Alberta, Canada | ||
3218061 | 3218061 | 2021-07-26 | Canada | Alberta | 233547 | 2322 | 230142 | 1083 | 53.9333 | -116.5765 | 2021-07-27 04:21:18 | Alberta, Canada | ||
1378270 | 1378270 | 2021-07-25 | Canada | Alberta | 233160 | 2322 | 230039 | 799 | 53.9333 | -116.5765 | 2021-07-26 04:21:28 | Alberta, Canada | ||
1330010 | 1330010 | 2021-07-24 | Canada | Alberta | 233160 | 2322 | 230039 | 799 | 53.9333 | -116.5765 | 2021-07-25 04:22:12 | Alberta, Canada | ||
3137314 | 3137314 | 2021-07-23 | Canada | Alberta | 233160 | 2322 | 230066 | 772 | 53.9333 | -116.5765 | 2021-07-24 00:21:36 | Alberta, Canada | ||
3476074 | 3476074 | 2021-07-22 | Canada | Alberta | 233062 | 2320 | 230066 | 676 | 53.9333 | -116.5765 | 2021-07-23 04:21:29 | Alberta, Canada | ||
3331293 | 3331293 | 2021-07-21 | Canada | Alberta | 232956 | 2318 | 229989 | 649 | 53.9333 | -116.5765 | 2021-07-22 04:21:19 | Alberta, Canada | ||
2371274 | 2371274 | 2021-07-20 | Canada | Alberta | 232875 | 2318 | 229951 | 606 | 53.9333 | -116.5765 | 2021-07-21 04:21:40 | Alberta, Canada | ||
483353 | 483353 | 2021-07-19 | Canada | Alberta | 232806 | 2316 | 229885 | 605 | 53.9333 | -116.5765 | 2021-07-20 04:21:48 | Alberta, Canada | ||
2673576 | 2673576 | 2021-07-18 | Canada | Alberta | 232676 | 2314 | 229783 | 579 | 53.9333 | -116.5765 | 2021-07-19 04:21:24 | Alberta, Canada | ||
3705888 | 3705888 | 2021-07-17 | Canada | Alberta | 232676 | 2314 | 229783 | 579 | 53.9333 | -116.5765 | 2021-07-18 04:22:07 | Alberta, Canada | ||
2947119 | 2947119 | 2021-07-16 | Canada | Alberta | 232676 | 2314 | 229783 | 579 | 53.9333 | -116.5765 | 2021-07-17 04:22:22 | Alberta, Canada | ||
295775 | 295775 | 2021-07-15 | Canada | Alberta | 232635 | 2312 | 229745 | 578 | 53.9333 | -116.5765 | 2021-07-16 04:21:22 | Alberta, Canada | ||
3631720 | 3631720 | 2021-07-14 | Canada | Alberta | 232582 | 2311 | 229702 | 569 | 53.9333 | -116.5765 | 2021-07-15 04:21:48 | Alberta, Canada | ||
578595 | 578595 | 2021-07-13 | Canada | Alberta | 232536 | 2310 | 229627 | 599 | 53.9333 | -116.5765 | 2021-07-14 04:21:35 | Alberta, Canada | ||
3740844 | 3740844 | 2021-07-12 | Canada | Alberta | 232501 | 2307 | 229570 | 624 | 53.9333 | -116.5765 | 2021-07-13 04:21:18 | Alberta, Canada | ||
3659357 | 3659357 | 2021-07-11 | Canada | Alberta | 232411 | 2307 | 229429 | 675 | 53.9333 | -116.5765 | 2021-07-12 04:21:34 | Alberta, Canada | ||
625641 | 625641 | 2021-07-10 | Canada | Alberta | 232411 | 2307 | 229429 | 675 | 53.9333 | -116.5765 | 2021-07-11 04:21:43 | Alberta, Canada | ||
829360 | 829360 | 2021-07-09 | Canada | Alberta | 232411 | 2307 | 229429 | 675 | 53.9333 | -116.5765 | 2021-07-10 04:21:25 | Alberta, Canada | ||
778124 | 778124 | 2021-07-08 | Canada | Alberta | 232359 | 2307 | 229355 | 697 | 53.9333 | -116.5765 | 2021-07-09 04:21:21 | Alberta, Canada | ||
1440346 | 1440346 | 2021-07-07 | Canada | Alberta | 232336 | 2307 | 229284 | 745 | 53.9333 | -116.5765 | 2021-07-08 04:21:26 | Alberta, Canada | ||
2693451 | 2693451 | 2021-07-06 | Canada | Alberta | 232269 | 2305 | 229201 | 763 | 53.9333 | -116.5765 | 2021-07-07 04:21:20 | Alberta, Canada | ||
1932200 | 1932200 | 2021-07-05 | Canada | Alberta | 232236 | 2303 | 229102 | 831 | 53.9333 | -116.5765 | 2021-07-06 04:21:32 | Alberta, Canada | ||
1164931 | 1164931 | 2021-07-04 | Canada | Alberta | 232097 | 2301 | 228901 | 895 | 53.9333 | -116.5765 | 2021-07-05 04:21:28 | Alberta, Canada | ||
1495365 | 1495365 | 2021-07-03 | Canada | Alberta | 232097 | 2301 | 228901 | 895 | 53.9333 | -116.5765 | 2021-07-04 04:21:38 | Alberta, Canada | ||
2071680 | 2071680 | 2021-07-02 | Canada | Alberta | 232097 | 2301 | 228901 | 895 | 53.9333 | -116.5765 | 2021-07-03 04:21:37 | Alberta, Canada | ||
2764696 | 2764696 | 2021-07-01 | Canada | Alberta | 231987 | 2301 | 228631 | 1055 | 53.9333 | -116.5765 | 2021-07-02 04:21:47 | Alberta, Canada | ||
1892904 | 1892904 | 2021-06-30 | Canada | Alberta | 231987 | 2301 | 228631 | 1055 | 53.9333 | -116.5765 | 2021-07-01 04:21:19 | Alberta, Canada | ||
400027 | 400027 | 2021-06-29 | Canada | Alberta | 231911 | 2299 | 228480 | 1132 | 53.9333 | -116.5765 | 2021-06-30 04:21:41 | Alberta, Canada | ||
3125270 | 3125270 | 2021-06-28 | Canada | Alberta | 231850 | 2295 | 228294 | 1261 | 53.9333 | -116.5765 | 2021-06-29 04:21:28 | Alberta, Canada | ||
2589765 | 2589765 | 2021-06-27 | Canada | Alberta | 231641 | 2293 | 227768 | 1580 | 53.9333 | -116.5765 | 2021-06-28 04:21:29 | Alberta, Canada | ||
3958269 | 3958269 | 2021-06-26 | Canada | Alberta | 231641 | 2293 | 227768 | 1580 | 53.9333 | -116.5765 | 2021-06-27 04:21:39 | Alberta, Canada | ||
1712088 | 1712088 | 2021-06-25 | Canada | Alberta | 231641 | 2293 | 227768 | 1580 | 53.9333 | -116.5765 | 2021-06-26 04:21:43 | Alberta, Canada | ||
2295213 | 2295213 | 2021-06-24 | Canada | Alberta | 231641 | 2293 | 227768 | 1580 | 53.9333 | -116.5765 | 2021-06-25 04:21:33 | Alberta, Canada | ||
2422653 | 2422653 | 2021-06-23 | Canada | Alberta | 231568 | 2292 | 227600 | 1676 | 53.9333 | -116.5765 | 2021-06-24 04:21:55 | Alberta, Canada | ||
562730 | 562730 | 2021-06-22 | Canada | Alberta | 231476 | 2290 | 227413 | 1773 | 53.9333 | -116.5765 | 2021-06-23 04:21:46 | Alberta, Canada | ||
3358432 | 3358432 | 2021-06-21 | Canada | Alberta | 231419 | 2292 | 227124 | 2003 | 53.9333 | -116.5765 | 2021-06-22 04:21:34 | Alberta, Canada | ||
2884131 | 2884131 | 2021-06-20 | Canada | Alberta | 231359 | 2290 | 226942 | 2127 | 53.9333 | -116.5765 | 2021-06-21 04:21:41 | Alberta, Canada | ||
107214 | 107214 | 2021-06-19 | Canada | Alberta | 231259 | 2289 | 226800 | 2170 | 53.9333 | -116.5765 | 2021-06-20 04:21:48 | Alberta, Canada | ||
1125357 | 1125357 | 2021-06-18 | Canada | Alberta | 231132 | 2283 | 226513 | 2336 | 53.9333 | -116.5765 | 2021-06-19 04:22:33 | Alberta, Canada | ||
2910935 | 2910935 | 2021-06-17 | Canada | Alberta | 231008 | 2280 | 226257 | 2471 | 53.9333 | -116.5765 | 2021-06-18 04:22:16 | Alberta, Canada | ||
3030053 | 3030053 | 2021-06-16 | Canada | Alberta | 230858 | 2278 | 225941 | 2639 | 53.9333 | -116.5765 | 2021-06-17 04:22:36 | Alberta, Canada | ||
2339159 | 2339159 | 2021-06-15 | Canada | Alberta | 230705 | 2274 | 225627 | 2804 | 53.9333 | -116.5765 | 2021-06-16 04:22:32 | Alberta, Canada | ||
1563855 | 1563855 | 2021-06-14 | Canada | Alberta | 230578 | 2270 | 225219 | 3089 | 53.9333 | -116.5765 | 2021-06-15 04:22:22 | Alberta, Canada | ||
3381138 | 3381138 | 2021-06-13 | Canada | Alberta | 230463 | 2270 | 225013 | 3180 | 53.9333 | -116.5765 | 2021-06-14 04:22:46 | Alberta, Canada | ||
1736272 | 1736272 | 2021-06-12 | Canada | Alberta | 230298 | 2269 | 224782 | 3247 | 53.9333 | -116.5765 | 2021-06-13 04:22:44 | Alberta, Canada | ||
3970313 | 3970313 | 2021-06-11 | Canada | Alberta | 230119 | 2265 | 224325 | 3529 | 53.9333 | -116.5765 | 2021-06-12 04:22:22 | Alberta, Canada | ||
2716735 | 2716735 | 2021-06-10 | Canada | Alberta | 229949 | 2262 | 223877 | 3810 | 53.9333 | -116.5765 | 2021-06-11 04:23:20 | Alberta, Canada | ||
522620 | 522620 | 2021-06-09 | Canada | Alberta | 229771 | 2256 | 223311 | 4204 | 53.9333 | -116.5765 | 2021-06-10 04:23:17 | Alberta, Canada | ||
3472060 | 3472060 | 2021-06-08 | Canada | Alberta | 229458 | 2251 | 222776 | 4431 | 53.9333 | -116.5765 | 2021-06-09 04:23:31 | Alberta, Canada | ||
3145344 | 3145344 | 2021-06-07 | Canada | Alberta | 229319 | 2248 | 222364 | 4707 | 53.9333 | -116.5765 | 2021-06-08 04: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]);