johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,022 rows where country_or_region = "Canada" and province_or_state = "Saskatchewan" sorted by active 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1864890 | 1864890 | 2020-05-22 | Canada | Saskatchewan | 627 | 7 | 521 | 99 | 52.9399 | -106.4509 | 2020-05-23 02:32:42 | Saskatchewan, Canada | ||
2868494 | 2868494 | 2020-09-13 | Canada | Saskatchewan | 1726 | 24 | 1603 | 99 | 52.9399 | -106.4509 | 2020-09-14 04:26:00 | Saskatchewan, Canada | ||
1543723 | 1543723 | 2020-11-07 | Canada | Saskatchewan | 3738 | 27 | 2726 | 985 | 52.9399 | -106.4509 | 2020-11-08 05:24:56 | Saskatchewan, Canada | ||
1522569 | 1522569 | 2020-06-23 | Canada | Saskatchewan | 753 | 13 | 642 | 98 | 52.9399 | -106.4509 | 2020-06-24 04:33:28 | Saskatchewan, Canada | ||
2625244 | 2625244 | 2020-06-25 | Canada | Saskatchewan | 759 | 13 | 648 | 98 | 52.9399 | -106.4509 | 2020-06-26 04:33:43 | Saskatchewan, Canada | ||
2991052 | 2991052 | 2020-08-24 | Canada | Saskatchewan | 1601 | 22 | 1482 | 98 | 52.9399 | -106.4509 | 2020-08-25 04:28:02 | Saskatchewan, Canada | ||
809035 | 809035 | 2020-03-27 | Canada | Saskatchewan | 104 | 0 | 0 | 95 | 52.9399 | -106.4509 | 2020-03-27 23:27:32 | Saskatchewan, Canada | ||
919128 | 919128 | 2020-03-26 | Canada | Saskatchewan | 95 | 0 | 0 | 95 | 52.9399 | -106.4509 | 2020-03-26 23:53:11 | Saskatchewan, Canada | ||
1510763 | 1510763 | 2020-06-22 | Canada | Saskatchewan | 751 | 13 | 643 | 95 | 52.9399 | -106.4509 | 2020-06-23 04:33:22 | Saskatchewan, Canada | ||
522634 | 522634 | 2021-06-09 | Canada | Saskatchewan | 47591 | 552 | 46084 | 938 | 52.9399 | -106.4509 | 2021-06-10 04:23:17 | Saskatchewan, Canada | ||
375961 | 375961 | 2020-11-06 | Canada | Saskatchewan | 3623 | 25 | 2687 | 911 | 52.9399 | -106.4509 | 2020-11-07 05:24:52 | Saskatchewan, Canada | ||
2716749 | 2716749 | 2021-06-10 | Canada | Saskatchewan | 47683 | 553 | 46213 | 902 | 52.9399 | -106.4509 | 2021-06-11 04:23:20 | Saskatchewan, Canada | ||
3249502 | 3249502 | 2020-06-21 | Canada | Saskatchewan | 746 | 13 | 643 | 90 | 52.9399 | -106.4509 | 2020-06-22 04:33:20 | Saskatchewan, Canada | ||
3491524 | 3491524 | 2020-07-13 | Canada | Saskatchewan | 871 | 15 | 766 | 90 | 52.9399 | -106.4509 | 2020-07-14 04:34:46 | Saskatchewan, Canada | ||
3970327 | 3970327 | 2021-06-11 | Canada | Saskatchewan | 47769 | 554 | 46311 | 899 | 52.9399 | -106.4509 | 2021-06-12 04:22:22 | Saskatchewan, Canada | ||
303223 | 303223 | 2020-07-01 | Canada | Saskatchewan | 785 | 13 | 684 | 88 | 52.9399 | -106.4509 | 2020-07-02 04:33:46 | Saskatchewan, Canada | ||
997867 | 997867 | 2020-05-23 | Canada | Saskatchewan | 630 | 7 | 535 | 88 | 52.9399 | -106.4509 | 2020-05-24 02:32:43 | Saskatchewan, Canada | ||
2974601 | 2974601 | 2020-06-30 | Canada | Saskatchewan | 785 | 13 | 684 | 88 | 52.9399 | -106.4509 | 2020-07-01 04:33:52 | Saskatchewan, Canada | ||
3562348 | 3562348 | 2020-08-25 | Canada | Saskatchewan | 1601 | 23 | 1490 | 88 | 52.9399 | -106.4509 | 2020-08-26 04:28:11 | Saskatchewan, Canada | ||
891899 | 891899 | 2020-11-05 | Canada | Saskatchewan | 3536 | 25 | 2634 | 877 | 52.9399 | -106.4509 | 2020-11-06 05:24:55 | Saskatchewan, Canada | ||
1736286 | 1736286 | 2021-06-12 | Canada | Saskatchewan | 47875 | 555 | 46446 | 874 | 52.9399 | -106.4509 | 2021-06-13 04:22:44 | Saskatchewan, Canada | ||
875676 | 875676 | 2020-05-24 | Canada | Saskatchewan | 632 | 7 | 538 | 87 | 52.9399 | -106.4509 | 2020-05-25 02:32:44 | Saskatchewan, Canada | ||
2633078 | 2633078 | 2020-06-29 | Canada | Saskatchewan | 779 | 13 | 679 | 87 | 52.9399 | -106.4509 | 2020-06-30 04:33:48 | Saskatchewan, Canada | ||
3303973 | 3303973 | 2020-11-02 | Canada | Saskatchewan | 3292 | 25 | 2409 | 858 | 52.9399 | -106.4509 | 2020-11-03 06:00:16 | Saskatchewan, Canada | ||
2497798 | 2497798 | 2020-11-03 | Canada | Saskatchewan | 3373 | 25 | 2506 | 842 | 52.9399 | -106.4509 | 2020-11-04 05:25:09 | Saskatchewan, Canada | ||
546533 | 546533 | 2020-09-12 | Canada | Saskatchewan | 1709 | 24 | 1602 | 83 | 52.9399 | -106.4509 | 2020-09-13 04:30:52 | Saskatchewan, Canada | ||
1104996 | 1104996 | 2020-05-25 | Canada | Saskatchewan | 634 | 7 | 546 | 81 | 52.9399 | -106.4509 | 2020-05-26 02:32:35 | Saskatchewan, Canada | ||
3381152 | 3381152 | 2021-06-13 | Canada | Saskatchewan | 47941 | 555 | 46577 | 809 | 52.9399 | -106.4509 | 2021-06-14 04:22:46 | Saskatchewan, Canada | ||
3045532 | 3045532 | 2020-07-02 | Canada | Saskatchewan | 795 | 14 | 701 | 80 | 52.9399 | -106.4509 | 2020-07-03 04:33:54 | Saskatchewan, Canada | ||
2918961 | 2918961 | 2020-11-04 | Canada | Saskatchewan | 3408 | 25 | 2584 | 799 | 52.9399 | -106.4509 | 2020-11-05 06:05:03 | Saskatchewan, Canada | ||
3409222 | 3409222 | 2020-11-01 | Canada | Saskatchewan | 3218 | 25 | 2395 | 798 | 52.9399 | -106.4509 | 2020-11-02 05:25:04 | Saskatchewan, Canada | ||
1563869 | 1563869 | 2021-06-14 | Canada | Saskatchewan | 47996 | 556 | 46666 | 774 | 52.9399 | -106.4509 | 2021-06-15 04:22:22 | Saskatchewan, Canada | ||
1041266 | 1041266 | 2020-05-26 | Canada | Saskatchewan | 634 | 8 | 549 | 77 | 52.9399 | -106.4509 | 2020-05-27 02:32:31 | Saskatchewan, Canada | ||
1125371 | 1125371 | 2021-06-18 | Canada | Saskatchewan | 48327 | 562 | 47002 | 763 | 52.9399 | -106.4509 | 2021-06-19 04:22:33 | Saskatchewan, Canada | ||
107228 | 107228 | 2021-06-19 | Canada | Saskatchewan | 48381 | 562 | 47059 | 760 | 52.9399 | -106.4509 | 2021-06-20 04:21:48 | Saskatchewan, Canada | ||
2158883 | 2158883 | 2020-07-14 | Canada | Saskatchewan | 876 | 15 | 785 | 76 | 52.9399 | -106.4509 | 2020-07-15 04:34:39 | Saskatchewan, Canada | ||
2910949 | 2910949 | 2021-06-17 | Canada | Saskatchewan | 48220 | 561 | 46907 | 752 | 52.9399 | -106.4509 | 2021-06-18 04:22:16 | Saskatchewan, Canada | ||
2748239 | 2748239 | 2020-07-15 | Canada | Saskatchewan | 881 | 15 | 791 | 75 | 52.9399 | -106.4509 | 2020-07-16 04:44:59 | Saskatchewan, Canada | ||
2884145 | 2884145 | 2021-06-20 | Canada | Saskatchewan | 48441 | 563 | 47135 | 743 | 52.9399 | -106.4509 | 2021-06-21 04:21:41 | Saskatchewan, Canada | ||
2243164 | 2243164 | 2020-10-30 | Canada | Saskatchewan | 3066 | 25 | 2299 | 742 | 52.9399 | -106.4509 | 2020-10-31 04:24:44 | Saskatchewan, Canada | ||
2438095 | 2438095 | 2020-06-20 | Canada | Saskatchewan | 726 | 13 | 639 | 74 | 52.9399 | -106.4509 | 2020-06-21 04:33:19 | Saskatchewan, Canada | ||
2079711 | 2079711 | 2020-10-31 | Canada | Saskatchewan | 3144 | 25 | 2380 | 739 | 52.9399 | -106.4509 | 2020-11-01 04:36:19 | Saskatchewan, Canada | ||
3030067 | 3030067 | 2021-06-16 | Canada | Saskatchewan | 48125 | 561 | 46837 | 726 | 52.9399 | -106.4509 | 2021-06-17 04:22:36 | Saskatchewan, Canada | ||
2339173 | 2339173 | 2021-06-15 | Canada | Saskatchewan | 48042 | 560 | 46761 | 722 | 52.9399 | -106.4509 | 2021-06-16 04:22:32 | Saskatchewan, Canada | ||
1132530 | 1132530 | 2020-03-25 | Canada | Saskatchewan | 86 | 0 | 0 | 72 | 52.9399 | -106.4509 | 2020-03-25 23:37:36 | Saskatchewan, Canada | ||
1479038 | 1479038 | 2020-03-24 | Canada | Saskatchewan | 72 | 0 | 0 | 72 | 52.9399 | -106.4509 | 2020-03-24 23:41:36 | Saskatchewan, Canada | ||
3358446 | 3358446 | 2021-06-21 | Canada | Saskatchewan | 48469 | 564 | 47214 | 711 | 52.9399 | -106.4509 | 2021-06-22 04:21:34 | Saskatchewan, Canada | ||
415515 | 415515 | 2020-07-05 | Canada | Saskatchewan | 796 | 14 | 711 | 71 | 52.9399 | -106.4509 | 2020-07-06 04:33:57 | Saskatchewan, Canada | ||
530077 | 530077 | 2020-07-04 | Canada | Saskatchewan | 796 | 14 | 711 | 71 | 52.9399 | -106.4509 | 2020-07-05 04:33:46 | Saskatchewan, Canada | ||
2234738 | 2234738 | 2020-07-03 | Canada | Saskatchewan | 796 | 14 | 711 | 71 | 52.9399 | -106.4509 | 2020-07-04 04:33:51 | Saskatchewan, Canada | ||
210019 | 210019 | 2020-10-29 | Canada | Saskatchewan | 2990 | 25 | 2258 | 707 | 52.9399 | -106.4509 | 2020-10-30 04:24:49 | Saskatchewan, Canada | ||
2548303 | 2548303 | 2020-05-27 | Canada | Saskatchewan | 637 | 10 | 559 | 68 | 52.9399 | -106.4509 | 2020-05-28 02:32:31 | Saskatchewan, Canada | ||
1691673 | 1691673 | 2020-06-19 | Canada | Saskatchewan | 716 | 13 | 636 | 67 | 52.9399 | -106.4509 | 2020-06-20 04:33:19 | Saskatchewan, Canada | ||
754081 | 754081 | 2020-10-28 | Canada | Saskatchewan | 2908 | 25 | 2217 | 666 | 52.9399 | -106.4509 | 2020-10-29 04:24:49 | Saskatchewan, Canada | ||
1444362 | 1444362 | 2020-09-11 | Canada | Saskatchewan | 1688 | 24 | 1598 | 66 | 52.9399 | -106.4509 | 2020-09-12 04:25:05 | Saskatchewan, Canada | ||
2147095 | 2147095 | 2020-03-23 | Canada | Saskatchewan | 66 | 0 | 0 | 66 | 52.9399 | -106.4509 | 2020-03-23 23:23:10 | Saskatchewan, Canada | ||
1452366 | 1452366 | 2020-10-27 | Canada | Saskatchewan | 2841 | 25 | 2164 | 652 | 52.9399 | -106.4509 | 2020-10-28 04:24:39 | Saskatchewan, Canada | ||
3480090 | 3480090 | 2020-10-26 | Canada | Saskatchewan | 2783 | 25 | 2108 | 650 | 52.9399 | -106.4509 | 2020-10-27 04:24:45 | Saskatchewan, Canada | ||
562744 | 562744 | 2021-06-22 | Canada | Saskatchewan | 48503 | 564 | 47301 | 639 | 52.9399 | -106.4509 | 2021-06-23 04:21:46 | Saskatchewan, Canada | ||
8111 | 8111 | 2020-10-25 | Canada | Saskatchewan | 2729 | 25 | 2085 | 619 | 52.9399 | -106.4509 | 2020-10-26 04:25:02 | Saskatchewan, Canada | ||
1790487 | 1790487 | 2020-05-29 | Canada | Saskatchewan | 641 | 10 | 570 | 61 | 52.9399 | -106.4509 | 2020-05-30 02:32:48 | Saskatchewan, Canada | ||
2712366 | 2712366 | 2020-05-28 | Canada | Saskatchewan | 639 | 10 | 568 | 61 | 52.9399 | -106.4509 | 2020-05-29 02:32:50 | Saskatchewan, Canada | ||
1712102 | 1712102 | 2021-06-25 | Canada | Saskatchewan | 48644 | 565 | 47472 | 609 | 52.9399 | -106.4509 | 2021-06-26 04:21:43 | Saskatchewan, Canada | ||
2422667 | 2422667 | 2021-06-23 | Canada | Saskatchewan | 48537 | 565 | 47365 | 607 | 52.9399 | -106.4509 | 2021-06-24 04:21:55 | Saskatchewan, Canada | ||
2295227 | 2295227 | 2021-06-24 | Canada | Saskatchewan | 48590 | 565 | 47420 | 605 | 52.9399 | -106.4509 | 2021-06-25 04:21:33 | Saskatchewan, Canada | ||
1996424 | 1996424 | 2020-08-26 | Canada | Saskatchewan | 1604 | 24 | 1520 | 60 | 52.9399 | -106.4509 | 2020-08-27 04:28:15 | Saskatchewan, Canada | ||
3958283 | 3958283 | 2021-06-26 | Canada | Saskatchewan | 48706 | 566 | 47543 | 597 | 52.9399 | -106.4509 | 2021-06-27 04:21:39 | Saskatchewan, Canada | ||
1172963 | 1172963 | 2020-09-10 | Canada | Saskatchewan | 1676 | 24 | 1593 | 59 | 52.9399 | -106.4509 | 2020-09-11 04:46:23 | Saskatchewan, Canada | ||
2171328 | 2171328 | 2020-09-09 | Canada | Saskatchewan | 1670 | 24 | 1587 | 59 | 52.9399 | -106.4509 | 2020-09-10 04:29:01 | Saskatchewan, Canada | ||
2685050 | 2685050 | 2020-07-06 | Canada | Saskatchewan | 805 | 14 | 732 | 59 | 52.9399 | -106.4509 | 2020-07-07 04:34:00 | Saskatchewan, Canada | ||
3682822 | 3682822 | 2020-06-18 | Canada | Saskatchewan | 708 | 13 | 636 | 59 | 52.9399 | -106.4509 | 2020-06-19 04:33:17 | Saskatchewan, Canada | ||
427116 | 427116 | 2020-09-07 | Canada | Saskatchewan | 1662 | 24 | 1580 | 58 | 52.9399 | -106.4509 | 2020-09-08 04:28:25 | Saskatchewan, Canada | ||
1243537 | 1243537 | 2020-09-08 | Canada | Saskatchewan | 1669 | 24 | 1587 | 58 | 52.9399 | -106.4509 | 2020-09-09 04:28:48 | Saskatchewan, Canada | ||
2509964 | 2509964 | 2020-08-27 | Canada | Saskatchewan | 1609 | 24 | 1527 | 58 | 52.9399 | -106.4509 | 2020-08-28 04:28:11 | Saskatchewan, Canada | ||
3651348 | 3651348 | 2020-10-24 | Canada | Saskatchewan | 2669 | 25 | 2070 | 574 | 52.9399 | -106.4509 | 2020-10-25 04:24:36 | Saskatchewan, Canada | ||
3847235 | 3847235 | 2020-05-13 | Canada | Saskatchewan | 577 | 6 | 0 | 570 | 52.9399 | -106.4509 | 2020-05-14 03:32:28 | Saskatchewan, Canada | ||
2581442 | 2581442 | 2020-05-12 | Canada | Saskatchewan | 573 | 6 | 0 | 566 | 52.9399 | -106.4509 | 2020-05-13 03:32:26 | Saskatchewan, Canada | ||
3330976 | 3330976 | 2020-05-11 | Canada | Saskatchewan | 568 | 6 | 0 | 561 | 52.9399 | -106.4509 | 2020-05-12 03:32:27 | Saskatchewan, Canada | ||
3459591 | 3459591 | 2020-05-10 | Canada | Saskatchewan | 564 | 6 | 0 | 557 | 52.9399 | -106.4509 | 2020-05-11 02:32:30 | Saskatchewan, Canada | ||
3638946 | 3638946 | 2020-05-30 | Canada | Saskatchewan | 645 | 10 | 580 | 55 | 52.9399 | -106.4509 | 2020-05-31 02:32:45 | Saskatchewan, Canada | ||
2589779 | 2589779 | 2021-06-27 | Canada | Saskatchewan | 48754 | 566 | 47639 | 549 | 52.9399 | -106.4509 | 2021-06-28 04:21:29 | Saskatchewan, Canada | ||
2899132 | 2899132 | 2020-05-09 | Canada | Saskatchewan | 553 | 6 | 0 | 546 | 52.9399 | -106.4509 | 2020-05-10 02:32:30 | Saskatchewan, Canada | ||
887490 | 887490 | 2020-07-07 | Canada | Saskatchewan | 806 | 15 | 737 | 54 | 52.9399 | -106.4509 | 2020-07-08 05:33:48 | Saskatchewan, Canada | ||
114181 | 114181 | 2020-05-08 | Canada | Saskatchewan | 544 | 6 | 0 | 537 | 52.9399 | -106.4509 | 2020-05-09 02:32:35 | Saskatchewan, Canada | ||
1794053 | 1794053 | 2020-05-31 | Canada | Saskatchewan | 646 | 11 | 582 | 53 | 52.9399 | -106.4509 | 2020-06-01 02:32:46 | Saskatchewan, Canada | ||
3295624 | 3295624 | 2020-05-07 | Canada | Saskatchewan | 531 | 6 | 0 | 524 | 52.9399 | -106.4509 | 2020-05-08 02:32:32 | Saskatchewan, Canada | ||
2910583 | 2910583 | 2020-03-22 | Canada | Saskatchewan | 52 | 0 | 0 | 52 | 52.9399 | -106.4509 | 3/22/20 23:48 | Saskatchewan, Canada | ||
1053603 | 1053603 | 2020-10-23 | Canada | Saskatchewan | 2591 | 25 | 2055 | 511 | 52.9399 | -106.4509 | 2020-10-24 04:24:46 | Saskatchewan, Canada | ||
1177273 | 1177273 | 2020-10-22 | Canada | Saskatchewan | 2558 | 25 | 2024 | 509 | 52.9399 | -106.4509 | 2020-10-23 04:24:46 | Saskatchewan, Canada | ||
2110845 | 2110845 | 2020-05-06 | Canada | Saskatchewan | 512 | 6 | 0 | 505 | 52.9399 | -106.4509 | 2020-05-07 02:32:28 | Saskatchewan, Canada | ||
3015127 | 3015127 | 2021-08-01 | Canada | Saskatchewan | 50067 | 578 | 48993 | 496 | 52.9399 | -106.4509 | 2021-08-02 04:21:36 | Saskatchewan, Canada | ||
331683 | 331683 | 2021-08-04 | Canada | Saskatchewan | 50181 | 579 | 49119 | 483 | 52.9399 | -106.4509 | 2021-08-05 04:21:51 | Saskatchewan, Canada | ||
1931885 | 1931885 | 2020-05-05 | Canada | Saskatchewan | 487 | 6 | 0 | 480 | 52.9399 | -106.4509 | 2020-05-06 02:32:31 | Saskatchewan, Canada | ||
1005665 | 1005665 | 2020-07-09 | Canada | Saskatchewan | 813 | 15 | 750 | 48 | 52.9399 | -106.4509 | 2020-07-10 04:34:24 | Saskatchewan, Canada | ||
3161401 | 3161401 | 2020-09-06 | Canada | Saskatchewan | 1651 | 24 | 1579 | 48 | 52.9399 | -106.4509 | 2020-09-07 04:28:30 | Saskatchewan, Canada | ||
3903750 | 3903750 | 2021-07-31 | Canada | Saskatchewan | 50024 | 578 | 48967 | 479 | 52.9399 | -106.4509 | 2021-08-01 04:21:50 | Saskatchewan, Canada | ||
2347203 | 2347203 | 2020-12-07 | Canada | Saskatchewan | 10411 | 60 | 5589 | 4763 | 52.9399 | -106.4509 | 2020-12-08 05:27:42 | Saskatchewan, Canada | ||
3683228 | 3683228 | 2021-08-02 | Canada | Saskatchewan | 50096 | 578 | 49044 | 474 | 52.9399 | -106.4509 | 2021-08-03 04:21:39 | Saskatchewan, Canada | ||
2975007 | 2975007 | 2020-12-09 | Canada | Saskatchewan | 10898 | 71 | 6121 | 4707 | 52.9399 | -106.4509 | 2020-12-10 05:26:19 | Saskatchewan, Canada | ||
805491 | 805491 | 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 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]);