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 recovered
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
657790 | 657790 | 2020-03-09 | Canada | Alberta | 7 | 0 | 0 | 53.9333 | -116.5765 | 2020-03-09T17:53:24 | ||||
658062 | 658062 | 2022-05-13 | Canada | Alberta | 575185 | 4391 | 0 | 53.9333 | -116.5765 | 2022-05-14 04:20:48 | Alberta, Canada | |||
670047 | 670047 | 2022-07-21 | Canada | Alberta | 592767 | 4652 | 0 | 53.9333 | -116.5765 | 2022-07-22 04:21:15 | Alberta, Canada | |||
674063 | 674063 | 2022-07-30 | Canada | Alberta | 594474 | 4665 | 0 | 53.9333 | -116.5765 | 2022-07-31 04:21:02 | Alberta, Canada | |||
682088 | 682088 | 2021-10-24 | Canada | Alberta | 319176 | 3026 | 0 | 53.9333 | -116.5765 | 2021-10-25 04:22:31 | Alberta, Canada | |||
686104 | 686104 | 2021-11-13 | Canada | Alberta | 329030 | 3171 | 0 | 53.9333 | -116.5765 | 2021-11-14 04:21:31 | Alberta, Canada | |||
690121 | 690121 | 2022-12-23 | Canada | Alberta | 622428 | 5351 | 0 | 53.9333 | -116.5765 | 2022-12-24 04:21:02 | Alberta, Canada | |||
694137 | 694137 | 2022-03-17 | Canada | Alberta | 533783 | 4019 | 0 | 53.9333 | -116.5765 | 2022-03-18 04:20:55 | Alberta, Canada | |||
698152 | 698152 | 2021-11-04 | Canada | Alberta | 325517 | 3137 | 0 | 53.9333 | -116.5765 | 2021-11-05 04:21:54 | Alberta, Canada | |||
706182 | 706182 | 2021-09-29 | Canada | Alberta | 296466 | 2697 | 0 | 53.9333 | -116.5765 | 2021-09-30 04:21:20 | Alberta, Canada | |||
710198 | 710198 | 2022-11-01 | Canada | Alberta | 612693 | 5011 | 0 | 53.9333 | -116.5765 | 2022-11-02 04:22:09 | Alberta, Canada | |||
714213 | 714213 | 2021-11-12 | Canada | Alberta | 329030 | 3171 | 0 | 53.9333 | -116.5765 | 2021-11-13 04:21:38 | Alberta, Canada | |||
718230 | 718230 | 2022-12-04 | Canada | Alberta | 619345 | 5216 | 0 | 53.9333 | -116.5765 | 2022-12-02 18:21:06 | Alberta, Canada | |||
722245 | 722245 | 2021-11-20 | Canada | Alberta | 331626 | 3211 | 0 | 53.9333 | -116.5765 | 2021-11-21 04:22:13 | Alberta, Canada | |||
730275 | 730275 | 2021-12-27 | Canada | Alberta | 346705 | 3299 | 0 | 53.9333 | -116.5765 | 2021-12-28 04:21:47 | Alberta, Canada | |||
746092 | 746092 | 2022-04-23 | Canada | Alberta | 558483 | 4190 | 0 | 53.9333 | -116.5765 | 2022-04-24 04:20:56 | Alberta, Canada | |||
758075 | 758075 | 2021-11-26 | Canada | Alberta | 334203 | 3235 | 0 | 53.9333 | -116.5765 | 2021-11-27 04:22:45 | Alberta, Canada | |||
770096 | 770096 | 2021-10-23 | Canada | Alberta | 319176 | 3026 | 0 | 53.9333 | -116.5765 | 2021-10-24 04:21:22 | Alberta, Canada | |||
782138 | 782138 | 2021-12-13 | Canada | Alberta | 339291 | 3275 | 0 | 53.9333 | -116.5765 | 2021-12-14 04:22:38 | Alberta, Canada | |||
794162 | 794162 | 2022-10-24 | Canada | Alberta | 611389 | 4983 | 0 | 53.9333 | -116.5765 | 2022-10-25 04:21:53 | Alberta, Canada | |||
798177 | 798177 | 2021-12-22 | Canada | Alberta | 345080 | 3299 | 0 | 53.9333 | -116.5765 | 2021-12-23 04:21:21 | Alberta, Canada | |||
808968 | 808968 | 2020-03-27 | Canada | Alberta | 542 | 2 | 0 | 540 | 53.9333 | -116.5765 | 2020-03-27 23:27:32 | Alberta, Canada | ||
809339 | 809339 | 2021-09-20 | Canada | Alberta | 282191 | 2545 | 0 | 53.9333 | -116.5765 | 2021-09-21 04:21:26 | Alberta, Canada | |||
833375 | 833375 | 2022-12-02 | Canada | Alberta | 619345 | 5216 | 0 | 53.9333 | -116.5765 | 2022-12-02 18:21:06 | Alberta, Canada | |||
849347 | 849347 | 2022-11-02 | Canada | Alberta | 614234 | 5047 | 0 | 53.9333 | -116.5765 | 2022-11-03 04:22:05 | Alberta, Canada | |||
853363 | 853363 | 2022-09-30 | Canada | Alberta | 607289 | 4905 | 0 | 53.9333 | -116.5765 | 2022-10-01 04:23:01 | Alberta, Canada | |||
860059 | 860059 | 2020-04-15 | Canada | Alberta | 1870 | 48 | 0 | 1822 | 53.9333 | -116.5765 | 2020-04-15 23:04:09 | Alberta, Canada | ||
868547 | 868547 | 2022-12-11 | Canada | Alberta | 620475 | 5262 | 0 | 53.9333 | -116.5765 | 2022-12-12 04:21:01 | Alberta, Canada | |||
876012 | 876012 | 2022-03-27 | Canada | Alberta | 536166 | 4044 | 0 | 53.9333 | -116.5765 | 2022-03-28 04:20:33 | Alberta, Canada | |||
880028 | 880028 | 2022-08-05 | Canada | Alberta | 596126 | 4673 | 0 | 53.9333 | -116.5765 | 2022-08-06 04:20:56 | Alberta, Canada | |||
895895 | 895895 | 2022-07-24 | Canada | Alberta | 592767 | 4652 | 0 | 53.9333 | -116.5765 | 2022-07-25 04:20:51 | Alberta, Canada | |||
899911 | 899911 | 2022-07-22 | Canada | Alberta | 592767 | 4652 | 0 | 53.9333 | -116.5765 | 2022-07-23 04:20:53 | Alberta, Canada | |||
903926 | 903926 | 2021-11-24 | Canada | Alberta | 333468 | 3231 | 0 | 53.9333 | -116.5765 | 2021-11-25 04:22:33 | Alberta, Canada | |||
911956 | 911956 | 2022-10-29 | Canada | Alberta | 612693 | 5011 | 0 | 53.9333 | -116.5765 | 2022-10-30 04:22:14 | Alberta, Canada | |||
919061 | 919061 | 2020-03-26 | Canada | Alberta | 486 | 2 | 0 | 484 | 53.9333 | -116.5765 | 2020-03-26 23:53:11 | Alberta, Canada | ||
919432 | 919432 | 2022-03-08 | Canada | Alberta | 529184 | 3979 | 0 | 53.9333 | -116.5765 | 2022-03-09 04:20:59 | Alberta, Canada | |||
934165 | 934165 | 2020-04-16 | Canada | Alberta | 1996 | 48 | 0 | 1948 | 53.9333 | -116.5765 | 2020-04-16 23:38:03 | Alberta, Canada | ||
934548 | 934548 | 2021-10-16 | Canada | Alberta | 314252 | 2946 | 0 | 53.9333 | -116.5765 | 2021-10-17 04:21:29 | Alberta, Canada | |||
938565 | 938565 | 2022-06-25 | Canada | Alberta | 587890 | 4604 | 0 | 53.9333 | -116.5765 | 2022-06-26 04:21:02 | Alberta, Canada | |||
942581 | 942581 | 2022-02-28 | Canada | Alberta | 525816 | 3912 | 0 | 53.9333 | -116.5765 | 2022-03-01 04:21:09 | Alberta, Canada | |||
946597 | 946597 | 2022-06-14 | Canada | Alberta | 584763 | 4567 | 0 | 53.9333 | -116.5765 | 2022-06-15 04:20:54 | Alberta, Canada | |||
950613 | 950613 | 2022-03-12 | Canada | Alberta | 530761 | 4003 | 0 | 53.9333 | -116.5765 | 2022-03-13 04:20:49 | Alberta, Canada | |||
958643 | 958643 | 2022-07-19 | Canada | Alberta | 591083 | 4633 | 0 | 53.9333 | -116.5765 | 2022-07-20 04:20:59 | Alberta, Canada | |||
962659 | 962659 | 2022-09-09 | Canada | Alberta | 603501 | 4832 | 0 | 53.9333 | -116.5765 | 2022-09-10 04:21:10 | Alberta, Canada | |||
970667 | 970667 | 2022-06-01 | Canada | Alberta | 583112 | 4558 | 0 | 53.9333 | -116.5765 | 2022-06-02 05:20:39 | Alberta, Canada | |||
978696 | 978696 | 2022-02-01 | Canada | Alberta | 495953 | 3579 | 0 | 53.9333 | -116.5765 | 2022-02-02 04:21:09 | Alberta, Canada | |||
986726 | 986726 | 2021-10-04 | Canada | Alberta | 303839 | 2752 | 0 | 53.9333 | -116.5765 | 2021-10-05 04:21:27 | Alberta, Canada | |||
990742 | 990742 | 2022-08-16 | Canada | Alberta | 597891 | 4694 | 0 | 53.9333 | -116.5765 | 2022-08-17 04:20:59 | Alberta, Canada | |||
1014081 | 1014081 | 2021-11-21 | Canada | Alberta | 331626 | 3211 | 0 | 53.9333 | -116.5765 | 2021-11-22 04:22:20 | Alberta, Canada | |||
1018098 | 1018098 | 2022-12-24 | Canada | Alberta | 622428 | 5351 | 0 | 53.9333 | -116.5765 | 2022-12-25 04:21:04 | Alberta, Canada | |||
1022114 | 1022114 | 2022-11-04 | Canada | Alberta | 614234 | 5047 | 0 | 53.9333 | -116.5765 | 2022-11-05 04:21:52 | Alberta, Canada | |||
1030123 | 1030123 | 2021-12-06 | Canada | Alberta | 337180 | 3263 | 0 | 53.9333 | -116.5765 | 2021-12-07 04:22:34 | Alberta, Canada | |||
1049586 | 1049586 | 2022-11-06 | Canada | Alberta | 614234 | 5047 | 0 | 53.9333 | -116.5765 | 2022-11-07 04:21:26 | Alberta, Canada | |||
1057597 | 1057597 | 2022-02-23 | Canada | Alberta | 523104 | 3883 | 0 | 53.9333 | -116.5765 | 2022-02-24 04:21:14 | Alberta, Canada | |||
1065625 | 1065625 | 2022-07-28 | Canada | Alberta | 594474 | 4665 | 0 | 53.9333 | -116.5765 | 2022-07-29 04:20:45 | Alberta, Canada | |||
1069641 | 1069641 | 2022-08-07 | Canada | Alberta | 596126 | 4673 | 0 | 53.9333 | -116.5765 | 2022-08-08 04:21:08 | Alberta, Canada | |||
1073657 | 1073657 | 2022-12-28 | Canada | Alberta | 622428 | 5351 | 0 | 53.9333 | -116.5765 | 2022-12-29 04:21:01 | Alberta, Canada | |||
1077672 | 1077672 | 2021-12-09 | Canada | Alberta | 338141 | 3271 | 0 | 53.9333 | -116.5765 | 2021-12-10 04:22:28 | Alberta, Canada | |||
1085823 | 1085823 | 2022-08-09 | Canada | Alberta | 596126 | 4673 | 0 | 53.9333 | -116.5765 | 2022-08-10 04:20:57 | Alberta, Canada | |||
1097866 | 1097866 | 2022-08-03 | Canada | Alberta | 596126 | 4673 | 0 | 53.9333 | -116.5765 | 2022-08-04 04:20:58 | Alberta, Canada | |||
1109322 | 1109322 | 2022-05-21 | Canada | Alberta | 578291 | 4452 | 0 | 53.9333 | -116.5765 | 2022-05-22 04:20:52 | Alberta, Canada | |||
1113337 | 1113337 | 2022-01-11 | Canada | Alberta | 417533 | 3352 | 0 | 53.9333 | -116.5765 | 2022-01-12 04:21:44 | Alberta, Canada | |||
1117353 | 1117353 | 2021-08-06 | Canada | Alberta | 236010 | 2325 | 0 | 53.9333 | -116.5765 | 2021-08-07 04:21:30 | Alberta, Canada | |||
1132464 | 1132464 | 2020-03-25 | Canada | Alberta | 358 | 2 | 0 | 356 | 53.9333 | -116.5765 | 2020-03-25 23:37:36 | Alberta, Canada | ||
1140660 | 1140660 | 2022-01-23 | Canada | Alberta | 466616 | 3429 | 0 | 53.9333 | -116.5765 | 2022-01-24 04:21:12 | Alberta, Canada | |||
1144676 | 1144676 | 2021-12-01 | Canada | Alberta | 335677 | 3255 | 0 | 53.9333 | -116.5765 | 2021-12-02 04:22:37 | Alberta, Canada | |||
1148693 | 1148693 | 2022-12-12 | Canada | Alberta | 620475 | 5262 | 0 | 53.9333 | -116.5765 | 2022-12-13 04:21:01 | Alberta, Canada | |||
1156900 | 1156900 | 2022-04-29 | Canada | Alberta | 565052 | 4252 | 0 | 53.9333 | -116.5765 | 2022-04-30 04:21:05 | Alberta, Canada | |||
1160916 | 1160916 | 2022-08-18 | Canada | Alberta | 599504 | 4721 | 0 | 53.9333 | -116.5765 | 2022-08-19 04:20:54 | Alberta, Canada | |||
1168946 | 1168946 | 2022-05-20 | Canada | Alberta | 578291 | 4452 | 0 | 53.9333 | -116.5765 | 2022-05-21 04:20:58 | Alberta, Canada | |||
1176969 | 1176969 | 2020-03-18 | Canada | Alberta | 97 | 0 | 0 | 53.9333 | -116.5765 | 2020-03-18T03:33:03 | ||||
1184106 | 1184106 | 2020-05-01 | Canada | Alberta | 5573 | 92 | 0 | 5481 | 53.9333 | -116.5765 | 2020-05-02 02:32:27 | Alberta, Canada | ||
1184493 | 1184493 | 2022-05-18 | Canada | Alberta | 578291 | 4452 | 0 | 53.9333 | -116.5765 | 2022-05-19 04:20:54 | Alberta, Canada | |||
1199172 | 1199172 | 2020-04-22 | Canada | Alberta | 3401 | 66 | 0 | 3335 | 53.9333 | -116.5765 | 2020-04-22 23:38:42 | Alberta, Canada | ||
1199555 | 1199555 | 2022-07-06 | Canada | Alberta | 589726 | 4636 | 0 | 53.9333 | -116.5765 | 2022-07-07 04:20:55 | Alberta, Canada | |||
1211300 | 1211300 | 2022-07-11 | Canada | Alberta | 589726 | 4639 | 0 | 53.9333 | -116.5765 | 2022-07-12 04:20:51 | Alberta, Canada | |||
1215315 | 1215315 | 2022-01-08 | Canada | Alberta | 395252 | 3338 | 0 | 53.9333 | -116.5765 | 2022-01-09 04:21:46 | Alberta, Canada | |||
1223346 | 1223346 | 2022-04-14 | Canada | Alberta | 552403 | 4141 | 0 | 53.9333 | -116.5765 | 2022-04-15 04:20:57 | Alberta, Canada | |||
1227361 | 1227361 | 2022-01-24 | Canada | Alberta | 466616 | 3429 | 0 | 53.9333 | -116.5765 | 2022-01-25 04:21:05 | Alberta, Canada | |||
1231377 | 1231377 | 2021-11-28 | Canada | Alberta | 334203 | 3235 | 0 | 53.9333 | -116.5765 | 2021-11-29 04:22:30 | Alberta, Canada | |||
1235393 | 1235393 | 2021-09-27 | Canada | Alberta | 293538 | 2645 | 0 | 53.9333 | -116.5765 | 2021-09-28 04:21:28 | Alberta, Canada | |||
1239409 | 1239409 | 2022-11-28 | Canada | Alberta | 618030 | 5177 | 0 | 53.9333 | -116.5765 | 2022-11-29 04:21:05 | Alberta, Canada | |||
1250119 | 1250119 | 2020-04-10 | Canada | Alberta | 1451 | 32 | 0 | 1419 | 53.9333 | -116.5765 | 2020-04-10 23:01:26 | Alberta, Canada | ||
1250505 | 1250505 | 2022-08-23 | Canada | Alberta | 599504 | 4721 | 0 | 53.9333 | -116.5765 | 2022-08-24 04:20:46 | Alberta, Canada | |||
1254520 | 1254520 | 2021-12-20 | Canada | Alberta | 342948 | 3292 | 0 | 53.9333 | -116.5765 | 2021-12-21 03:21:27 | Alberta, Canada | |||
1258536 | 1258536 | 2021-12-18 | Canada | Alberta | 341023 | 3286 | 0 | 53.9333 | -116.5765 | 2021-12-19 04:21:11 | Alberta, Canada | |||
1262552 | 1262552 | 2021-09-09 | Canada | Alberta | 264564 | 2434 | 0 | 53.9333 | -116.5765 | 2021-09-10 04:21:20 | Alberta, Canada | |||
1274036 | 1274036 | 2021-10-03 | Canada | Alberta | 299802 | 2731 | 0 | 53.9333 | -116.5765 | 2021-10-04 04:21:31 | Alberta, Canada | |||
1281737 | 1281737 | 2022-01-05 | Canada | Alberta | 384126 | 3333 | 0 | 53.9333 | -116.5765 | 2022-01-06 04:22:09 | Alberta, Canada | |||
1285753 | 1285753 | 2022-01-04 | Canada | Alberta | 379374 | 3322 | 0 | 53.9333 | -116.5765 | 2022-01-05 04:21:59 | Alberta, Canada | |||
1293783 | 1293783 | 2022-02-05 | Canada | Alberta | 503433 | 3634 | 0 | 53.9333 | -116.5765 | 2022-02-06 04:21:00 | Alberta, Canada | |||
1297800 | 1297800 | 2022-02-17 | Canada | Alberta | 519351 | 3822 | 0 | 53.9333 | -116.5765 | 2022-02-18 04:21:04 | Alberta, Canada | |||
1313947 | 1313947 | 2022-05-27 | Canada | Alberta | 580881 | 4507 | 0 | 53.9333 | -116.5765 | 2022-05-28 04:21:07 | Alberta, Canada | |||
1317962 | 1317962 | 2022-01-26 | Canada | Alberta | 477841 | 3483 | 0 | 53.9333 | -116.5765 | 2022-01-27 04:21:19 | Alberta, Canada | |||
1321978 | 1321978 | 2021-11-14 | Canada | Alberta | 329030 | 3171 | 0 | 53.9333 | -116.5765 | 2021-11-15 04:21:36 | Alberta, Canada | |||
1325995 | 1325995 | 2022-04-26 | Canada | Alberta | 558483 | 4190 | 0 | 53.9333 | -116.5765 | 2022-04-27 04:20:52 | Alberta, Canada | |||
1334024 | 1334024 | 2021-09-28 | Canada | Alberta | 294784 | 2663 | 0 | 53.9333 | -116.5765 | 2021-09-29 04:21:45 | Alberta, Canada | |||
1342053 | 1342053 | 2021-08-11 | Canada | Alberta | 237807 | 2331 | 0 | 53.9333 | -116.5765 | 2021-08-12 04:21:25 | Alberta, Canada | |||
1346068 | 1346068 | 2022-08-10 | Canada | Alberta | 597891 | 4694 | 0 | 53.9333 | -116.5765 | 2022-08-11 04:20:49 | Alberta, Canada | |||
1358084 | 1358084 | 2021-11-27 | Canada | Alberta | 334203 | 3235 | 0 | 53.9333 | -116.5765 | 2021-11-28 04:22:43 | 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]);