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 rowid descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
Link | rowid ▲ | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4002415 | 4002415 | 2022-10-08 | Canada | Alberta | 607289 | 4905 | 0 | 53.9333 | -116.5765 | 2022-10-09 04:21:16 | Alberta, Canada | |||
3998398 | 3998398 | 2021-12-30 | Canada | Alberta | 361623 | 3310 | 0 | 53.9333 | -116.5765 | 2021-12-31 04:21:50 | Alberta, Canada | |||
3994383 | 3994383 | 2022-09-27 | Canada | Alberta | 605757 | 4872 | 0 | 53.9333 | -116.5765 | 2022-09-28 04:23:01 | Alberta, Canada | |||
3990376 | 3990376 | 2020-10-20 | Canada | Alberta | 22996 | 293 | 19500 | 3203 | 53.9333 | -116.5765 | 2020-10-21 04:24:14 | Alberta, Canada | ||
3986372 | 3986372 | 2022-09-15 | Canada | Alberta | 604578 | 4848 | 0 | 53.9333 | -116.5765 | 2022-09-16 04:21:19 | Alberta, Canada | |||
3982356 | 3982356 | 2022-06-15 | Canada | Alberta | 586108 | 4591 | 0 | 53.9333 | -116.5765 | 2022-06-16 04:20:55 | 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 | ||
3974327 | 3974327 | 2021-09-03 | Canada | Alberta | 256985 | 2390 | 0 | 53.9333 | -116.5765 | 2021-09-04 04:21:28 | 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 | ||
3966298 | 3966298 | 2022-07-05 | Canada | Alberta | 588691 | 4621 | 0 | 53.9333 | -116.5765 | 2022-07-06 04:20:58 | 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 | ||
3958269 | 3958269 | 2021-06-26 | Canada | Alberta | 231641 | 2293 | 227768 | 1580 | 53.9333 | -116.5765 | 2021-06-27 04:21:39 | Alberta, Canada | ||
3954255 | 3954255 | 2021-05-11 | Canada | Alberta | 211836 | 2119 | 184719 | 24998 | 53.9333 | -116.5765 | 2021-05-12 04:21:29 | Alberta, Canada | ||
3950240 | 3950240 | 2022-08-17 | Canada | Alberta | 599504 | 4721 | 0 | 53.9333 | -116.5765 | 2022-08-18 04:21:11 | Alberta, Canada | |||
3949856 | 3949856 | 2020-04-09 | Canada | Alberta | 1423 | 29 | 0 | 1394 | 53.9333 | -116.5765 | 2020-04-09 23:09:01 | Alberta, Canada | ||
3946916 | 3946916 | 2020-03-28 | Canada | Alberta | 542 | 2 | 0 | 540 | 53.9333 | -116.5765 | 3/28/20 23:10 | Alberta, Canada | ||
3939807 | 3939807 | 2022-06-30 | Canada | Alberta | 588691 | 4621 | 0 | 53.9333 | -116.5765 | 2022-07-01 04:21:10 | Alberta, Canada | |||
3935791 | 3935791 | 2022-12-09 | Canada | Alberta | 620475 | 5262 | 0 | 53.9333 | -116.5765 | 2022-12-10 04:21:02 | 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 | ||
3927789 | 3927789 | 2021-10-02 | Canada | Alberta | 299802 | 2731 | 0 | 53.9333 | -116.5765 | 2021-10-03 04:21:24 | 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 | ||
3922975 | 3922975 | 2020-08-09 | Canada | Alberta | 11430 | 208 | 10097 | 1125 | 53.9333 | -116.5765 | 2020-08-10 04:34:55 | Alberta, Canada | ||
3915783 | 3915783 | 2022-05-01 | Canada | Alberta | 565052 | 4252 | 0 | 53.9333 | -116.5765 | 2022-05-02 04:21:10 | Alberta, Canada | |||
3911767 | 3911767 | 2022-02-20 | Canada | Alberta | 519970 | 3830 | 0 | 53.9333 | -116.5765 | 2022-02-21 04:21:05 | Alberta, Canada | |||
3907751 | 3907751 | 2022-08-11 | Canada | Alberta | 597891 | 4694 | 0 | 53.9333 | -116.5765 | 2022-08-12 04:20:54 | 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 | ||
3899724 | 3899724 | 2021-01-09 | Canada | Alberta | 110641 | 1272 | 94932 | 14437 | 53.9333 | -116.5765 | 2021-01-10 05:22:12 | Alberta, Canada | ||
3895709 | 3895709 | 2022-05-19 | Canada | Alberta | 578291 | 4452 | 0 | 53.9333 | -116.5765 | 2022-05-20 04:20:57 | Alberta, Canada | |||
3891694 | 3891694 | 2021-08-29 | Canada | Alberta | 248954 | 2364 | 0 | 53.9333 | -116.5765 | 2021-08-30 04:21:23 | Alberta, Canada | |||
3891403 | 3891403 | 2020-03-17 | Canada | Alberta | 74 | 0 | 0 | 53.9333 | -116.5765 | 2020-03-17T03:13:18 | ||||
3887367 | 3887367 | 2022-06-06 | Canada | Alberta | 583112 | 4558 | 0 | 53.9333 | -116.5765 | 2022-06-07 04:21:08 | 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 | ||
3879340 | 3879340 | 2021-01-14 | Canada | Alberta | 114585 | 1389 | 100762 | 12434 | 53.9333 | -116.5765 | 2021-01-15 05:22:24 | Alberta, Canada | ||
3875325 | 3875325 | 2022-02-19 | Canada | Alberta | 519970 | 3830 | 0 | 53.9333 | -116.5765 | 2022-02-20 04:21:00 | Alberta, Canada | |||
3871309 | 3871309 | 2022-07-31 | Canada | Alberta | 594474 | 4665 | 0 | 53.9333 | -116.5765 | 2022-08-01 04:21:03 | Alberta, Canada | |||
3867293 | 3867293 | 2022-04-05 | Canada | Alberta | 540733 | 4074 | 0 | 53.9333 | -116.5765 | 2022-04-06 04:20:49 | Alberta, Canada | |||
3866570 | 3866570 | 2020-06-03 | Canada | Alberta | 7076 | 145 | 6587 | 344 | 53.9333 | -116.5765 | 2020-06-04 02:33:14 | 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 | ||
3855581 | 3855581 | 2022-02-18 | Canada | Alberta | 519970 | 3830 | 0 | 53.9333 | -116.5765 | 2022-02-19 04:21:11 | Alberta, Canada | |||
3851565 | 3851565 | 2022-04-27 | Canada | Alberta | 565052 | 4252 | 0 | 53.9333 | -116.5765 | 2022-04-28 04:20:47 | 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 | ||
3847164 | 3847164 | 2020-05-13 | Canada | Alberta | 6407 | 120 | 0 | 6287 | 53.9333 | -116.5765 | 2020-05-14 03:32:28 | Alberta, Canada | ||
3840258 | 3840258 | 2022-01-15 | Canada | Alberta | 436495 | 3380 | 0 | 53.9333 | -116.5765 | 2022-01-16 04:21:12 | Alberta, Canada | |||
3836248 | 3836248 | 2020-11-21 | Canada | Alberta | 45288 | 471 | 33543 | 11274 | 53.9333 | -116.5765 | 2020-11-22 05:25:45 | Alberta, Canada | ||
3832233 | 3832233 | 2021-10-05 | Canada | Alberta | 304502 | 2778 | 0 | 53.9333 | -116.5765 | 2021-10-06 04:21:33 | Alberta, Canada | |||
3828217 | 3828217 | 2021-12-21 | Canada | Alberta | 343734 | 3294 | 0 | 53.9333 | -116.5765 | 2021-12-22 04:21:54 | Alberta, Canada | |||
3824202 | 3824202 | 2022-09-10 | Canada | Alberta | 603501 | 4832 | 0 | 53.9333 | -116.5765 | 2022-09-11 04:20:50 | Alberta, Canada | |||
3820186 | 3820186 | 2022-02-16 | Canada | Alberta | 518538 | 3804 | 0 | 53.9333 | -116.5765 | 2022-02-17 04:20:56 | Alberta, Canada | |||
3816169 | 3816169 | 2021-12-23 | Canada | Alberta | 346705 | 3299 | 0 | 53.9333 | -116.5765 | 2021-12-24 04:21:34 | Alberta, Canada | |||
3815792 | 3815792 | 2020-03-31 | Canada | Alberta | 690 | 8 | 0 | 682 | 53.9333 | -116.5765 | 2020-03-31 23:49:13 | Alberta, Canada | ||
3809680 | 3809680 | 2022-01-28 | Canada | Alberta | 487436 | 3531 | 0 | 53.9333 | -116.5765 | 2022-01-29 04:21:10 | Alberta, Canada | |||
3805666 | 3805666 | 2021-09-11 | Canada | Alberta | 266037 | 2444 | 0 | 53.9333 | -116.5765 | 2021-09-12 04:21:13 | 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 | ||
3797659 | 3797659 | 2022-08-20 | Canada | Alberta | 599504 | 4721 | 0 | 53.9333 | -116.5765 | 2022-08-21 04:20:44 | Alberta, Canada | |||
3793642 | 3793642 | 2021-10-25 | Canada | Alberta | 320768 | 3051 | 0 | 53.9333 | -116.5765 | 2021-10-26 04:22:09 | 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 | ||
3785662 | 3785662 | 2020-10-11 | Canada | Alberta | 19995 | 283 | 17488 | 2224 | 53.9333 | -116.5765 | 2020-10-12 04:23:45 | 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 | ||
3777669 | 3777669 | 2020-12-27 | Canada | Alberta | 97352 | 982 | 75070 | 21300 | 53.9333 | -116.5765 | 2020-12-28 05:22:06 | Alberta, Canada | ||
3773654 | 3773654 | 2022-08-30 | Canada | Alberta | 601337 | 4748 | 0 | 53.9333 | -116.5765 | 2022-08-31 04:20:57 | 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 | ||
3765627 | 3765627 | 2022-09-11 | Canada | Alberta | 603501 | 4832 | 0 | 53.9333 | -116.5765 | 2022-09-12 04:20:58 | Alberta, Canada | |||
3765432 | 3765432 | 2020-03-13 | Canada | Alberta | 29 | 0 | 0 | 53.9333 | -116.5765 | 2020-03-11T20:00:00 | ||||
3761349 | 3761349 | 2020-12-28 | Canada | Alberta | 98269 | 1002 | 81780 | 15487 | 53.9333 | -116.5765 | 2020-12-29 05:22:37 | Alberta, Canada | ||
3757236 | 3757236 | 2021-09-21 | Canada | Alberta | 283710 | 2574 | 0 | 53.9333 | -116.5765 | 2021-09-22 04:21:45 | Alberta, Canada | |||
3753221 | 3753221 | 2022-10-13 | Canada | Alberta | 610027 | 4951 | 0 | 53.9333 | -116.5765 | 2022-10-14 04:22:28 | Alberta, Canada | |||
3752929 | 3752929 | 2020-03-10 | Canada | Alberta | 7 | 0 | 0 | 53.9333 | -116.5765 | 2020-03-09T17:53:24 | ||||
3748874 | 3748874 | 2021-11-22 | Canada | Alberta | 332751 | 3217 | 0 | 53.9333 | -116.5765 | 2021-11-23 04:22:39 | Alberta, Canada | |||
3744859 | 3744859 | 2022-09-07 | Canada | Alberta | 603501 | 4832 | 0 | 53.9333 | -116.5765 | 2022-09-08 04:21:02 | 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 | ||
3740464 | 3740464 | 2020-04-03 | Canada | Alberta | 969 | 13 | 0 | 956 | 53.9333 | -116.5765 | 2020-04-03 22:52:30 | 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 | ||
3734013 | 3734013 | 2020-03-20 | Canada | Alberta | 146 | 1 | 0 | 53.9333 | -116.5765 | 2020-03-20T03:13:18 | ||||
3729981 | 3729981 | 2022-04-03 | Canada | Alberta | 540733 | 4074 | 0 | 53.9333 | -116.5765 | 2022-04-04 04:20:51 | Alberta, Canada | |||
3725965 | 3725965 | 2022-06-07 | Canada | Alberta | 583112 | 4558 | 0 | 53.9333 | -116.5765 | 2022-06-08 04:20:55 | Alberta, Canada | |||
3721949 | 3721949 | 2022-04-25 | Canada | Alberta | 558483 | 4190 | 0 | 53.9333 | -116.5765 | 2022-04-26 04:20:51 | Alberta, Canada | |||
3717933 | 3717933 | 2022-02-21 | Canada | Alberta | 519970 | 3830 | 0 | 53.9333 | -116.5765 | 2022-02-22 04:21:01 | Alberta, Canada | |||
3713917 | 3713917 | 2022-12-06 | Canada | Alberta | 619345 | 5216 | 0 | 53.9333 | -116.5765 | 2022-12-07 04:20:58 | 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 | ||
3705888 | 3705888 | 2021-07-17 | Canada | Alberta | 232676 | 2314 | 229783 | 579 | 53.9333 | -116.5765 | 2021-07-18 04:22:07 | 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 | ||
3701494 | 3701494 | 2020-04-02 | Canada | Alberta | 969 | 13 | 0 | 956 | 53.9333 | -116.5765 | 4/2/20 23:31 | 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 | ||
3691244 | 3691244 | 2020-12-24 | Canada | Alberta | 94788 | 920 | 75070 | 18798 | 53.9333 | -116.5765 | 2020-12-25 05:22:48 | Alberta, Canada | ||
3687228 | 3687228 | 2022-01-13 | Canada | Alberta | 430332 | 3375 | 0 | 53.9333 | -116.5765 | 2022-01-14 04:21:54 | 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 | ||
3682431 | 3682431 | 2020-06-18 | Canada | Alberta | 7579 | 152 | 6938 | 489 | 53.9333 | -116.5765 | 2020-06-19 04:33:17 | Alberta, Canada | ||
3675415 | 3675415 | 2021-05-04 | Canada | Alberta | 198653 | 2099 | 172931 | 23623 | 53.9333 | -116.5765 | 2021-05-05 04:20:43 | Alberta, Canada | ||
3671400 | 3671400 | 2022-02-15 | Canada | Alberta | 517650 | 3790 | 0 | 53.9333 | -116.5765 | 2022-02-16 04:21:10 | 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 | ||
3663371 | 3663371 | 2021-03-09 | Canada | Alberta | 136374 | 1926 | 129978 | 4470 | 53.9333 | -116.5765 | 2021-03-10 05:24:35 | 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 | ||
3655341 | 3655341 | 2021-12-10 | Canada | Alberta | 338428 | 3272 | 0 | 53.9333 | -116.5765 | 2021-12-11 04:22:45 | Alberta, Canada | |||
3651335 | 3651335 | 2020-10-24 | Canada | Alberta | 24261 | 300 | 20310 | 3651 | 53.9333 | -116.5765 | 2020-10-25 04:24:36 | Alberta, Canada | ||
3647331 | 3647331 | 2022-08-14 | Canada | Alberta | 597891 | 4694 | 0 | 53.9333 | -116.5765 | 2022-08-15 04:20:59 | 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 | ||
3639300 | 3639300 | 2021-11-08 | Canada | Alberta | 327283 | 3155 | 0 | 53.9333 | -116.5765 | 2021-11-09 04:21:36 | Alberta, Canada | |||
3638686 | 3638686 | 2020-05-30 | Canada | Alberta | 6992 | 143 | 6245 | 604 | 53.9333 | -116.5765 | 2020-05-31 02:32:45 | 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 | ||
3627705 | 3627705 | 2022-03-13 | Canada | Alberta | 530761 | 4003 | 0 | 53.9333 | -116.5765 | 2022-03-14 04:20:46 | 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]);