daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,022 rows where province_or_state = "Saskatchewan" sorted by active descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed, deaths, recovered, active, day (date), last_update (date)
day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active ▲ | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-05-22 | Canada | Saskatchewan | 627 | 7 | 521 | 99 | 52.9399 | -106.4509 | 2020-05-23 02:32:42 | Saskatchewan, Canada | ||
2020-09-13 | Canada | Saskatchewan | 1726 | 24 | 1603 | 99 | 52.9399 | -106.4509 | 2020-09-14 04:26:00 | Saskatchewan, Canada | ||
2020-11-07 | Canada | Saskatchewan | 3738 | 27 | 2726 | 985 | 52.9399 | -106.4509 | 2020-11-08 05:24:56 | Saskatchewan, Canada | ||
2020-06-23 | Canada | Saskatchewan | 753 | 13 | 642 | 98 | 52.9399 | -106.4509 | 2020-06-24 04:33:28 | Saskatchewan, Canada | ||
2020-06-25 | Canada | Saskatchewan | 759 | 13 | 648 | 98 | 52.9399 | -106.4509 | 2020-06-26 04:33:43 | Saskatchewan, Canada | ||
2020-08-24 | Canada | Saskatchewan | 1601 | 22 | 1482 | 98 | 52.9399 | -106.4509 | 2020-08-25 04:28:02 | Saskatchewan, Canada | ||
2020-03-27 | Canada | Saskatchewan | 104 | 0 | 0 | 95 | 52.9399 | -106.4509 | 2020-03-27 23:27:32 | Saskatchewan, Canada | ||
2020-03-26 | Canada | Saskatchewan | 95 | 0 | 0 | 95 | 52.9399 | -106.4509 | 2020-03-26 23:53:11 | Saskatchewan, Canada | ||
2020-06-22 | Canada | Saskatchewan | 751 | 13 | 643 | 95 | 52.9399 | -106.4509 | 2020-06-23 04:33:22 | Saskatchewan, Canada | ||
2021-06-09 | Canada | Saskatchewan | 47591 | 552 | 46084 | 938 | 52.9399 | -106.4509 | 2021-06-10 04:23:17 | Saskatchewan, Canada | ||
2020-11-06 | Canada | Saskatchewan | 3623 | 25 | 2687 | 911 | 52.9399 | -106.4509 | 2020-11-07 05:24:52 | Saskatchewan, Canada | ||
2021-06-10 | Canada | Saskatchewan | 47683 | 553 | 46213 | 902 | 52.9399 | -106.4509 | 2021-06-11 04:23:20 | Saskatchewan, Canada | ||
2020-06-21 | Canada | Saskatchewan | 746 | 13 | 643 | 90 | 52.9399 | -106.4509 | 2020-06-22 04:33:20 | Saskatchewan, Canada | ||
2020-07-13 | Canada | Saskatchewan | 871 | 15 | 766 | 90 | 52.9399 | -106.4509 | 2020-07-14 04:34:46 | Saskatchewan, Canada | ||
2021-06-11 | Canada | Saskatchewan | 47769 | 554 | 46311 | 899 | 52.9399 | -106.4509 | 2021-06-12 04:22:22 | Saskatchewan, Canada | ||
2020-07-01 | Canada | Saskatchewan | 785 | 13 | 684 | 88 | 52.9399 | -106.4509 | 2020-07-02 04:33:46 | Saskatchewan, Canada | ||
2020-05-23 | Canada | Saskatchewan | 630 | 7 | 535 | 88 | 52.9399 | -106.4509 | 2020-05-24 02:32:43 | Saskatchewan, Canada | ||
2020-06-30 | Canada | Saskatchewan | 785 | 13 | 684 | 88 | 52.9399 | -106.4509 | 2020-07-01 04:33:52 | Saskatchewan, Canada | ||
2020-08-25 | Canada | Saskatchewan | 1601 | 23 | 1490 | 88 | 52.9399 | -106.4509 | 2020-08-26 04:28:11 | Saskatchewan, Canada | ||
2020-11-05 | Canada | Saskatchewan | 3536 | 25 | 2634 | 877 | 52.9399 | -106.4509 | 2020-11-06 05:24:55 | Saskatchewan, Canada | ||
2021-06-12 | Canada | Saskatchewan | 47875 | 555 | 46446 | 874 | 52.9399 | -106.4509 | 2021-06-13 04:22:44 | Saskatchewan, Canada | ||
2020-05-24 | Canada | Saskatchewan | 632 | 7 | 538 | 87 | 52.9399 | -106.4509 | 2020-05-25 02:32:44 | Saskatchewan, Canada | ||
2020-06-29 | Canada | Saskatchewan | 779 | 13 | 679 | 87 | 52.9399 | -106.4509 | 2020-06-30 04:33:48 | Saskatchewan, Canada | ||
2020-11-02 | Canada | Saskatchewan | 3292 | 25 | 2409 | 858 | 52.9399 | -106.4509 | 2020-11-03 06:00:16 | Saskatchewan, Canada | ||
2020-11-03 | Canada | Saskatchewan | 3373 | 25 | 2506 | 842 | 52.9399 | -106.4509 | 2020-11-04 05:25:09 | Saskatchewan, Canada | ||
2020-09-12 | Canada | Saskatchewan | 1709 | 24 | 1602 | 83 | 52.9399 | -106.4509 | 2020-09-13 04:30:52 | Saskatchewan, Canada | ||
2020-05-25 | Canada | Saskatchewan | 634 | 7 | 546 | 81 | 52.9399 | -106.4509 | 2020-05-26 02:32:35 | Saskatchewan, Canada | ||
2021-06-13 | Canada | Saskatchewan | 47941 | 555 | 46577 | 809 | 52.9399 | -106.4509 | 2021-06-14 04:22:46 | Saskatchewan, Canada | ||
2020-07-02 | Canada | Saskatchewan | 795 | 14 | 701 | 80 | 52.9399 | -106.4509 | 2020-07-03 04:33:54 | Saskatchewan, Canada | ||
2020-11-04 | Canada | Saskatchewan | 3408 | 25 | 2584 | 799 | 52.9399 | -106.4509 | 2020-11-05 06:05:03 | Saskatchewan, Canada | ||
2020-11-01 | Canada | Saskatchewan | 3218 | 25 | 2395 | 798 | 52.9399 | -106.4509 | 2020-11-02 05:25:04 | Saskatchewan, Canada | ||
2021-06-14 | Canada | Saskatchewan | 47996 | 556 | 46666 | 774 | 52.9399 | -106.4509 | 2021-06-15 04:22:22 | Saskatchewan, Canada | ||
2020-05-26 | Canada | Saskatchewan | 634 | 8 | 549 | 77 | 52.9399 | -106.4509 | 2020-05-27 02:32:31 | Saskatchewan, Canada | ||
2021-06-18 | Canada | Saskatchewan | 48327 | 562 | 47002 | 763 | 52.9399 | -106.4509 | 2021-06-19 04:22:33 | Saskatchewan, Canada | ||
2021-06-19 | Canada | Saskatchewan | 48381 | 562 | 47059 | 760 | 52.9399 | -106.4509 | 2021-06-20 04:21:48 | Saskatchewan, Canada | ||
2020-07-14 | Canada | Saskatchewan | 876 | 15 | 785 | 76 | 52.9399 | -106.4509 | 2020-07-15 04:34:39 | Saskatchewan, Canada | ||
2021-06-17 | Canada | Saskatchewan | 48220 | 561 | 46907 | 752 | 52.9399 | -106.4509 | 2021-06-18 04:22:16 | Saskatchewan, Canada | ||
2020-07-15 | Canada | Saskatchewan | 881 | 15 | 791 | 75 | 52.9399 | -106.4509 | 2020-07-16 04:44:59 | Saskatchewan, Canada | ||
2021-06-20 | Canada | Saskatchewan | 48441 | 563 | 47135 | 743 | 52.9399 | -106.4509 | 2021-06-21 04:21:41 | Saskatchewan, Canada | ||
2020-10-30 | Canada | Saskatchewan | 3066 | 25 | 2299 | 742 | 52.9399 | -106.4509 | 2020-10-31 04:24:44 | Saskatchewan, Canada | ||
2020-06-20 | Canada | Saskatchewan | 726 | 13 | 639 | 74 | 52.9399 | -106.4509 | 2020-06-21 04:33:19 | Saskatchewan, Canada | ||
2020-10-31 | Canada | Saskatchewan | 3144 | 25 | 2380 | 739 | 52.9399 | -106.4509 | 2020-11-01 04:36:19 | Saskatchewan, Canada | ||
2021-06-16 | Canada | Saskatchewan | 48125 | 561 | 46837 | 726 | 52.9399 | -106.4509 | 2021-06-17 04:22:36 | Saskatchewan, Canada | ||
2021-06-15 | Canada | Saskatchewan | 48042 | 560 | 46761 | 722 | 52.9399 | -106.4509 | 2021-06-16 04:22:32 | Saskatchewan, Canada | ||
2020-03-25 | Canada | Saskatchewan | 86 | 0 | 0 | 72 | 52.9399 | -106.4509 | 2020-03-25 23:37:36 | Saskatchewan, Canada | ||
2020-03-24 | Canada | Saskatchewan | 72 | 0 | 0 | 72 | 52.9399 | -106.4509 | 2020-03-24 23:41:36 | Saskatchewan, Canada | ||
2021-06-21 | Canada | Saskatchewan | 48469 | 564 | 47214 | 711 | 52.9399 | -106.4509 | 2021-06-22 04:21:34 | Saskatchewan, Canada | ||
2020-07-05 | Canada | Saskatchewan | 796 | 14 | 711 | 71 | 52.9399 | -106.4509 | 2020-07-06 04:33:57 | Saskatchewan, Canada | ||
2020-07-04 | Canada | Saskatchewan | 796 | 14 | 711 | 71 | 52.9399 | -106.4509 | 2020-07-05 04:33:46 | Saskatchewan, Canada | ||
2020-07-03 | Canada | Saskatchewan | 796 | 14 | 711 | 71 | 52.9399 | -106.4509 | 2020-07-04 04:33:51 | Saskatchewan, Canada | ||
2020-10-29 | Canada | Saskatchewan | 2990 | 25 | 2258 | 707 | 52.9399 | -106.4509 | 2020-10-30 04:24:49 | Saskatchewan, Canada | ||
2020-05-27 | Canada | Saskatchewan | 637 | 10 | 559 | 68 | 52.9399 | -106.4509 | 2020-05-28 02:32:31 | Saskatchewan, Canada | ||
2020-06-19 | Canada | Saskatchewan | 716 | 13 | 636 | 67 | 52.9399 | -106.4509 | 2020-06-20 04:33:19 | Saskatchewan, Canada | ||
2020-10-28 | Canada | Saskatchewan | 2908 | 25 | 2217 | 666 | 52.9399 | -106.4509 | 2020-10-29 04:24:49 | Saskatchewan, Canada | ||
2020-09-11 | Canada | Saskatchewan | 1688 | 24 | 1598 | 66 | 52.9399 | -106.4509 | 2020-09-12 04:25:05 | Saskatchewan, Canada | ||
2020-03-23 | Canada | Saskatchewan | 66 | 0 | 0 | 66 | 52.9399 | -106.4509 | 2020-03-23 23:23:10 | Saskatchewan, Canada | ||
2020-10-27 | Canada | Saskatchewan | 2841 | 25 | 2164 | 652 | 52.9399 | -106.4509 | 2020-10-28 04:24:39 | Saskatchewan, Canada | ||
2020-10-26 | Canada | Saskatchewan | 2783 | 25 | 2108 | 650 | 52.9399 | -106.4509 | 2020-10-27 04:24:45 | Saskatchewan, Canada | ||
2021-06-22 | Canada | Saskatchewan | 48503 | 564 | 47301 | 639 | 52.9399 | -106.4509 | 2021-06-23 04:21:46 | Saskatchewan, Canada | ||
2020-10-25 | Canada | Saskatchewan | 2729 | 25 | 2085 | 619 | 52.9399 | -106.4509 | 2020-10-26 04:25:02 | Saskatchewan, Canada | ||
2020-05-29 | Canada | Saskatchewan | 641 | 10 | 570 | 61 | 52.9399 | -106.4509 | 2020-05-30 02:32:48 | Saskatchewan, Canada | ||
2020-05-28 | Canada | Saskatchewan | 639 | 10 | 568 | 61 | 52.9399 | -106.4509 | 2020-05-29 02:32:50 | Saskatchewan, Canada | ||
2021-06-25 | Canada | Saskatchewan | 48644 | 565 | 47472 | 609 | 52.9399 | -106.4509 | 2021-06-26 04:21:43 | Saskatchewan, Canada | ||
2021-06-23 | Canada | Saskatchewan | 48537 | 565 | 47365 | 607 | 52.9399 | -106.4509 | 2021-06-24 04:21:55 | Saskatchewan, Canada | ||
2021-06-24 | Canada | Saskatchewan | 48590 | 565 | 47420 | 605 | 52.9399 | -106.4509 | 2021-06-25 04:21:33 | Saskatchewan, Canada | ||
2020-08-26 | Canada | Saskatchewan | 1604 | 24 | 1520 | 60 | 52.9399 | -106.4509 | 2020-08-27 04:28:15 | Saskatchewan, Canada | ||
2021-06-26 | Canada | Saskatchewan | 48706 | 566 | 47543 | 597 | 52.9399 | -106.4509 | 2021-06-27 04:21:39 | Saskatchewan, Canada | ||
2020-09-10 | Canada | Saskatchewan | 1676 | 24 | 1593 | 59 | 52.9399 | -106.4509 | 2020-09-11 04:46:23 | Saskatchewan, Canada | ||
2020-09-09 | Canada | Saskatchewan | 1670 | 24 | 1587 | 59 | 52.9399 | -106.4509 | 2020-09-10 04:29:01 | Saskatchewan, Canada | ||
2020-07-06 | Canada | Saskatchewan | 805 | 14 | 732 | 59 | 52.9399 | -106.4509 | 2020-07-07 04:34:00 | Saskatchewan, Canada | ||
2020-06-18 | Canada | Saskatchewan | 708 | 13 | 636 | 59 | 52.9399 | -106.4509 | 2020-06-19 04:33:17 | Saskatchewan, Canada | ||
2020-09-07 | Canada | Saskatchewan | 1662 | 24 | 1580 | 58 | 52.9399 | -106.4509 | 2020-09-08 04:28:25 | Saskatchewan, Canada | ||
2020-09-08 | Canada | Saskatchewan | 1669 | 24 | 1587 | 58 | 52.9399 | -106.4509 | 2020-09-09 04:28:48 | Saskatchewan, Canada | ||
2020-08-27 | Canada | Saskatchewan | 1609 | 24 | 1527 | 58 | 52.9399 | -106.4509 | 2020-08-28 04:28:11 | Saskatchewan, Canada | ||
2020-10-24 | Canada | Saskatchewan | 2669 | 25 | 2070 | 574 | 52.9399 | -106.4509 | 2020-10-25 04:24:36 | Saskatchewan, Canada | ||
2020-05-13 | Canada | Saskatchewan | 577 | 6 | 0 | 570 | 52.9399 | -106.4509 | 2020-05-14 03:32:28 | Saskatchewan, Canada | ||
2020-05-12 | Canada | Saskatchewan | 573 | 6 | 0 | 566 | 52.9399 | -106.4509 | 2020-05-13 03:32:26 | Saskatchewan, Canada | ||
2020-05-11 | Canada | Saskatchewan | 568 | 6 | 0 | 561 | 52.9399 | -106.4509 | 2020-05-12 03:32:27 | Saskatchewan, Canada | ||
2020-05-10 | Canada | Saskatchewan | 564 | 6 | 0 | 557 | 52.9399 | -106.4509 | 2020-05-11 02:32:30 | Saskatchewan, Canada | ||
2020-05-30 | Canada | Saskatchewan | 645 | 10 | 580 | 55 | 52.9399 | -106.4509 | 2020-05-31 02:32:45 | Saskatchewan, Canada | ||
2021-06-27 | Canada | Saskatchewan | 48754 | 566 | 47639 | 549 | 52.9399 | -106.4509 | 2021-06-28 04:21:29 | Saskatchewan, Canada | ||
2020-05-09 | Canada | Saskatchewan | 553 | 6 | 0 | 546 | 52.9399 | -106.4509 | 2020-05-10 02:32:30 | Saskatchewan, Canada | ||
2020-07-07 | Canada | Saskatchewan | 806 | 15 | 737 | 54 | 52.9399 | -106.4509 | 2020-07-08 05:33:48 | Saskatchewan, Canada | ||
2020-05-08 | Canada | Saskatchewan | 544 | 6 | 0 | 537 | 52.9399 | -106.4509 | 2020-05-09 02:32:35 | Saskatchewan, Canada | ||
2020-05-31 | Canada | Saskatchewan | 646 | 11 | 582 | 53 | 52.9399 | -106.4509 | 2020-06-01 02:32:46 | Saskatchewan, Canada | ||
2020-05-07 | Canada | Saskatchewan | 531 | 6 | 0 | 524 | 52.9399 | -106.4509 | 2020-05-08 02:32:32 | Saskatchewan, Canada | ||
2020-03-22 | Canada | Saskatchewan | 52 | 0 | 0 | 52 | 52.9399 | -106.4509 | 3/22/20 23:48 | Saskatchewan, Canada | ||
2020-10-23 | Canada | Saskatchewan | 2591 | 25 | 2055 | 511 | 52.9399 | -106.4509 | 2020-10-24 04:24:46 | Saskatchewan, Canada | ||
2020-10-22 | Canada | Saskatchewan | 2558 | 25 | 2024 | 509 | 52.9399 | -106.4509 | 2020-10-23 04:24:46 | Saskatchewan, Canada | ||
2020-05-06 | Canada | Saskatchewan | 512 | 6 | 0 | 505 | 52.9399 | -106.4509 | 2020-05-07 02:32:28 | Saskatchewan, Canada | ||
2021-08-01 | Canada | Saskatchewan | 50067 | 578 | 48993 | 496 | 52.9399 | -106.4509 | 2021-08-02 04:21:36 | Saskatchewan, Canada | ||
2021-08-04 | Canada | Saskatchewan | 50181 | 579 | 49119 | 483 | 52.9399 | -106.4509 | 2021-08-05 04:21:51 | Saskatchewan, Canada | ||
2020-05-05 | Canada | Saskatchewan | 487 | 6 | 0 | 480 | 52.9399 | -106.4509 | 2020-05-06 02:32:31 | Saskatchewan, Canada | ||
2020-07-09 | Canada | Saskatchewan | 813 | 15 | 750 | 48 | 52.9399 | -106.4509 | 2020-07-10 04:34:24 | Saskatchewan, Canada | ||
2020-09-06 | Canada | Saskatchewan | 1651 | 24 | 1579 | 48 | 52.9399 | -106.4509 | 2020-09-07 04:28:30 | Saskatchewan, Canada | ||
2021-07-31 | Canada | Saskatchewan | 50024 | 578 | 48967 | 479 | 52.9399 | -106.4509 | 2021-08-01 04:21:50 | Saskatchewan, Canada | ||
2020-12-07 | Canada | Saskatchewan | 10411 | 60 | 5589 | 4763 | 52.9399 | -106.4509 | 2020-12-08 05:27:42 | Saskatchewan, Canada | ||
2021-08-02 | Canada | Saskatchewan | 50096 | 578 | 49044 | 474 | 52.9399 | -106.4509 | 2021-08-03 04:21:39 | Saskatchewan, Canada | ||
2020-12-09 | Canada | Saskatchewan | 10898 | 71 | 6121 | 4707 | 52.9399 | -106.4509 | 2020-12-10 05:26:19 | Saskatchewan, Canada | ||
2020-06-01 | Canada | Saskatchewan | 646 | 11 | 588 | 47 | 52.9399 | -106.4509 | 2020-06-02 02:33:08 | Saskatchewan, Canada |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;