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 country_or_region
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
392014 | 392014 | 2020-11-27 | Canada | Saskatchewan | 7691 | 44 | 4384 | 3263 | 52.9399 | -106.4509 | 2020-11-28 05:25:50 | Saskatchewan, Canada | ||
396026 | 396026 | 2022-10-07 | Canada | Saskatchewan | 143747 | 1507 | 0 | 52.9399 | -106.4509 | 2022-10-08 04:22:56 | Saskatchewan, Canada | |||
400041 | 400041 | 2021-06-29 | Canada | Saskatchewan | 48823 | 568 | 47791 | 464 | 52.9399 | -106.4509 | 2021-06-30 04:21:41 | Saskatchewan, Canada | ||
404055 | 404055 | 2021-12-07 | Canada | Saskatchewan | 81462 | 934 | 0 | 52.9399 | -106.4509 | 2021-12-08 04:22:46 | Saskatchewan, Canada | |||
408071 | 408071 | 2021-07-28 | Canada | Saskatchewan | 49830 | 578 | 48876 | 376 | 52.9399 | -106.4509 | 2021-07-29 04:21:33 | 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 | ||
418769 | 418769 | 2020-04-18 | Canada | Saskatchewan | 313 | 4 | 0 | 309 | 52.9399 | -106.4509 | 2020-04-18 22:40:03 | Saskatchewan, Canada | ||
419097 | 419097 | 2022-09-18 | Canada | Saskatchewan | 143747 | 1507 | 0 | 52.9399 | -106.4509 | 2022-09-19 04:21:49 | Saskatchewan, Canada | |||
423112 | 423112 | 2021-10-10 | Canada | Saskatchewan | 72033 | 747 | 0 | 52.9399 | -106.4509 | 2021-10-11 04:21:31 | 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 | ||
431119 | 431119 | 2022-11-03 | Canada | Saskatchewan | 146888 | 1604 | 0 | 52.9399 | -106.4509 | 2022-11-04 04:22:11 | Saskatchewan, Canada | |||
435134 | 435134 | 2021-01-21 | Canada | Saskatchewan | 21338 | 239 | 18000 | 3099 | 52.9399 | -106.4509 | 2021-01-22 05:22:10 | Saskatchewan, Canada | ||
442701 | 442701 | 2020-07-26 | Canada | Saskatchewan | 1178 | 16 | 873 | 289 | 52.9399 | -106.4509 | 2020-07-27 04:35:02 | Saskatchewan, Canada | ||
443116 | 443116 | 2021-10-20 | Canada | Saskatchewan | 75185 | 798 | 0 | 52.9399 | -106.4509 | 2021-10-21 04:21:18 | Saskatchewan, Canada | |||
447132 | 447132 | 2021-11-17 | Canada | Saskatchewan | 79783 | 901 | 0 | 52.9399 | -106.4509 | 2021-11-18 04:21:33 | Saskatchewan, Canada | |||
451149 | 451149 | 2022-12-21 | Canada | Saskatchewan | 150003 | 1750 | 0 | 52.9399 | -106.4509 | 2022-12-22 04:20:56 | Saskatchewan, Canada | |||
458727 | 458727 | 2020-08-07 | Canada | Saskatchewan | 1409 | 20 | 1221 | 168 | 52.9399 | -106.4509 | 2020-08-08 04:34:53 | Saskatchewan, Canada | ||
459141 | 459141 | 2022-02-02 | Canada | Saskatchewan | 119894 | 997 | 0 | 52.9399 | -106.4509 | 2022-02-03 04:21:21 | Saskatchewan, Canada | |||
463158 | 463158 | 2022-05-02 | Canada | Saskatchewan | 136026 | 1309 | 0 | 52.9399 | -106.4509 | 2022-05-03 04:21:00 | Saskatchewan, Canada | |||
467173 | 467173 | 2021-10-07 | Canada | Saskatchewan | 70457 | 737 | 0 | 52.9399 | -106.4509 | 2021-10-08 04:21:25 | Saskatchewan, Canada | |||
471189 | 471189 | 2021-02-19 | Canada | Saskatchewan | 27245 | 365 | 25298 | 1582 | 52.9399 | -106.4509 | 2021-02-20 05:22:51 | Saskatchewan, Canada | ||
475204 | 475204 | 2022-06-26 | Canada | Saskatchewan | 139663 | 1403 | 0 | 52.9399 | -106.4509 | 2022-06-27 04:21:00 | Saskatchewan, Canada | |||
479352 | 479352 | 2022-11-08 | Canada | Saskatchewan | 146888 | 1604 | 0 | 52.9399 | -106.4509 | 2022-11-09 04:21:22 | Saskatchewan, Canada | |||
483367 | 483367 | 2021-07-19 | Canada | Saskatchewan | 49450 | 575 | 48613 | 262 | 52.9399 | -106.4509 | 2021-07-20 04:21:48 | Saskatchewan, Canada | ||
487382 | 487382 | 2022-11-25 | Canada | Saskatchewan | 148288 | 1662 | 0 | 52.9399 | -106.4509 | 2022-11-26 04:21:11 | Saskatchewan, Canada | |||
491397 | 491397 | 2021-10-14 | Canada | Saskatchewan | 73350 | 769 | 0 | 52.9399 | -106.4509 | 2021-10-15 04:21:26 | Saskatchewan, Canada | |||
495413 | 495413 | 2021-11-06 | Canada | Saskatchewan | 78567 | 866 | 0 | 52.9399 | -106.4509 | 2021-11-07 04:21:53 | Saskatchewan, Canada | |||
499430 | 499430 | 2022-04-02 | Canada | Saskatchewan | 132224 | 1229 | 0 | 52.9399 | -106.4509 | 2022-04-03 04:20:48 | Saskatchewan, Canada | |||
503446 | 503446 | 2022-12-17 | Canada | Saskatchewan | 150003 | 1750 | 0 | 52.9399 | -106.4509 | 2022-12-18 04:21:03 | Saskatchewan, Canada | |||
507461 | 507461 | 2021-08-14 | Canada | Saskatchewan | 51162 | 586 | 0 | 52.9399 | -106.4509 | 2021-08-15 04:21:41 | Saskatchewan, Canada | |||
511475 | 511475 | 2021-08-19 | Canada | Saskatchewan | 51821 | 586 | 0 | 52.9399 | -106.4509 | 2021-08-20 04:21:33 | Saskatchewan, Canada | |||
515490 | 515490 | 2022-10-15 | Canada | Saskatchewan | 145734 | 1566 | 0 | 52.9399 | -106.4509 | 2022-10-16 04:22:39 | Saskatchewan, Canada | |||
522307 | 522307 | 2020-04-21 | Canada | Saskatchewan | 320 | 4 | 0 | 316 | 52.9399 | -106.4509 | 2020-04-21 23:38:53 | 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 | ||
530077 | 530077 | 2020-07-04 | Canada | Saskatchewan | 796 | 14 | 711 | 71 | 52.9399 | -106.4509 | 2020-07-05 04:33:46 | Saskatchewan, Canada | ||
530483 | 530483 | 2021-02-22 | Canada | Saskatchewan | 27797 | 372 | 25773 | 1652 | 52.9399 | -106.4509 | 2021-02-23 05:23:41 | Saskatchewan, Canada | ||
534497 | 534497 | 2021-10-27 | Canada | Saskatchewan | 76830 | 832 | 0 | 52.9399 | -106.4509 | 2021-10-28 04:22:08 | Saskatchewan, Canada | |||
538514 | 538514 | 2022-10-26 | Canada | Saskatchewan | 145734 | 1566 | 0 | 52.9399 | -106.4509 | 2022-10-27 04:22:01 | Saskatchewan, Canada | |||
542530 | 542530 | 2022-12-15 | Canada | Saskatchewan | 150003 | 1750 | 0 | 52.9399 | -106.4509 | 2022-12-16 04:21:01 | 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 | ||
550535 | 550535 | 2021-12-08 | Canada | Saskatchewan | 81510 | 936 | 0 | 52.9399 | -106.4509 | 2021-12-09 04:22:49 | Saskatchewan, Canada | |||
554551 | 554551 | 2022-01-16 | Canada | Saskatchewan | 100173 | 961 | 0 | 52.9399 | -106.4509 | 2022-01-17 04:21:08 | Saskatchewan, Canada | |||
558568 | 558568 | 2022-06-16 | Canada | Saskatchewan | 139224 | 1398 | 0 | 52.9399 | -106.4509 | 2022-06-17 04:20:56 | 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 | ||
566865 | 566865 | 2021-10-29 | Canada | Saskatchewan | 77305 | 846 | 0 | 52.9399 | -106.4509 | 2021-10-30 04:22:03 | Saskatchewan, Canada | |||
574191 | 574191 | 2020-06-06 | Canada | Saskatchewan | 650 | 11 | 611 | 28 | 52.9399 | -106.4509 | 2020-06-07 03:53:30 | Saskatchewan, Canada | ||
574594 | 574594 | 2022-02-25 | Canada | Saskatchewan | 127187 | 1091 | 0 | 52.9399 | -106.4509 | 2022-02-26 04:21:12 | Saskatchewan, Canada | |||
578609 | 578609 | 2021-07-13 | Canada | Saskatchewan | 49304 | 573 | 48356 | 375 | 52.9399 | -106.4509 | 2021-07-14 04:21:35 | Saskatchewan, Canada | ||
582611 | 582611 | 2020-08-13 | Canada | Saskatchewan | 1511 | 20 | 1325 | 166 | 52.9399 | -106.4509 | 2020-08-14 04:51:19 | Saskatchewan, Canada | ||
589079 | 589079 | 2020-04-05 | Canada | Saskatchewan | 249 | 3 | 0 | 246 | 52.9399 | -106.4509 | 2020-04-05 23:13:28 | Saskatchewan, Canada | ||
589405 | 589405 | 2021-08-08 | Canada | Saskatchewan | 50558 | 582 | 0 | 52.9399 | -106.4509 | 2021-08-09 04:21:24 | Saskatchewan, Canada | |||
593420 | 593420 | 2022-07-01 | Canada | Saskatchewan | 139663 | 1403 | 0 | 52.9399 | -106.4509 | 2022-07-02 04:21:16 | Saskatchewan, Canada | |||
597435 | 597435 | 2021-10-19 | Canada | Saskatchewan | 74939 | 793 | 0 | 52.9399 | -106.4509 | 2021-10-20 04:21:00 | Saskatchewan, Canada | |||
601451 | 601451 | 2021-09-23 | Canada | Saskatchewan | 63875 | 658 | 0 | 52.9399 | -106.4509 | 2021-09-24 04:21:44 | Saskatchewan, Canada | |||
605466 | 605466 | 2021-04-09 | Canada | Saskatchewan | 35747 | 453 | 32958 | 2337 | 52.9399 | -106.4509 | 2021-04-10 04:20:59 | Saskatchewan, Canada | ||
609468 | 609468 | 2020-08-29 | Canada | Saskatchewan | 1615 | 24 | 1548 | 43 | 52.9399 | -106.4509 | 2020-08-30 04:28:22 | Saskatchewan, Canada | ||
613466 | 613466 | 2021-02-08 | Canada | Saskatchewan | 25574 | 341 | 23029 | 2204 | 52.9399 | -106.4509 | 2021-02-09 05:23:30 | Saskatchewan, Canada | ||
617624 | 617624 | 2022-11-05 | Canada | Saskatchewan | 146888 | 1604 | 0 | 52.9399 | -106.4509 | 2022-11-06 04:21:24 | Saskatchewan, Canada | |||
621640 | 621640 | 2022-05-22 | Canada | Saskatchewan | 137967 | 1364 | 0 | 52.9399 | -106.4509 | 2022-05-26 04:20:50 | Saskatchewan, Canada | |||
625655 | 625655 | 2021-07-10 | Canada | Saskatchewan | 49240 | 572 | 48254 | 414 | 52.9399 | -106.4509 | 2021-07-11 04:21:43 | Saskatchewan, Canada | ||
629670 | 629670 | 2022-07-12 | Canada | Saskatchewan | 139663 | 1403 | 0 | 52.9399 | -106.4509 | 2022-07-13 04:20:58 | Saskatchewan, Canada | |||
633685 | 633685 | 2021-10-13 | Canada | Saskatchewan | 73035 | 764 | 0 | 52.9399 | -106.4509 | 2021-10-14 04:21:29 | Saskatchewan, Canada | |||
637701 | 637701 | 2021-03-31 | Canada | Saskatchewan | 33590 | 436 | 31199 | 1955 | 52.9399 | -106.4509 | 2021-04-01 04:27:05 | Saskatchewan, Canada | ||
641715 | 641715 | 2021-09-07 | Canada | Saskatchewan | 56838 | 613 | 0 | 52.9399 | -106.4509 | 2021-09-08 04:21:31 | Saskatchewan, Canada | |||
645729 | 645729 | 2021-05-05 | Canada | Saskatchewan | 42220 | 501 | 39452 | 2250 | 52.9399 | -106.4509 | 2021-05-06 04:20:38 | Saskatchewan, Canada | ||
649743 | 649743 | 2021-08-09 | Canada | Saskatchewan | 50614 | 582 | 0 | 52.9399 | -106.4509 | 2021-08-10 04:21:27 | Saskatchewan, Canada | |||
653757 | 653757 | 2021-10-22 | Canada | Saskatchewan | 75842 | 812 | 0 | 52.9399 | -106.4509 | 2021-10-23 04:21:32 | Saskatchewan, Canada | |||
658076 | 658076 | 2022-05-13 | Canada | Saskatchewan | 137502 | 1342 | 0 | 52.9399 | -106.4509 | 2022-05-14 04:20:48 | Saskatchewan, Canada | |||
662079 | 662079 | 2020-08-11 | Canada | Saskatchewan | 1479 | 20 | 1294 | 165 | 52.9399 | -106.4509 | 2020-08-12 04:27:29 | Saskatchewan, Canada | ||
666058 | 666058 | 2020-09-16 | Canada | Saskatchewan | 1751 | 24 | 1620 | 107 | 52.9399 | -106.4509 | 2020-09-17 04:22:00 | Saskatchewan, Canada | ||
670061 | 670061 | 2022-07-21 | Canada | Saskatchewan | 139663 | 1417 | 0 | 52.9399 | -106.4509 | 2022-07-22 04:21:15 | Saskatchewan, Canada | |||
674077 | 674077 | 2022-07-30 | Canada | Saskatchewan | 140291 | 1438 | 0 | 52.9399 | -106.4509 | 2022-07-31 04:21:02 | Saskatchewan, Canada | |||
678091 | 678091 | 2020-11-23 | Canada | Saskatchewan | 6708 | 37 | 3807 | 2864 | 52.9399 | -106.4509 | 2020-11-24 05:27:31 | Saskatchewan, Canada | ||
682102 | 682102 | 2021-10-24 | Canada | Saskatchewan | 76311 | 817 | 0 | 52.9399 | -106.4509 | 2021-10-25 04:22:31 | Saskatchewan, Canada | |||
686118 | 686118 | 2021-11-13 | Canada | Saskatchewan | 79387 | 893 | 0 | 52.9399 | -106.4509 | 2021-11-14 04:21:31 | Saskatchewan, Canada | |||
690135 | 690135 | 2022-12-23 | Canada | Saskatchewan | 150942 | 1781 | 0 | 52.9399 | -106.4509 | 2022-12-24 04:21:02 | Saskatchewan, Canada | |||
694151 | 694151 | 2022-03-17 | Canada | Saskatchewan | 129301 | 1148 | 0 | 52.9399 | -106.4509 | 2022-03-18 04:20:55 | Saskatchewan, Canada | |||
698166 | 698166 | 2021-11-04 | Canada | Saskatchewan | 78262 | 861 | 0 | 52.9399 | -106.4509 | 2021-11-05 04:21:54 | Saskatchewan, Canada | |||
702182 | 702182 | 2021-03-16 | Canada | Saskatchewan | 30883 | 409 | 29182 | 1292 | 52.9399 | -106.4509 | 2021-03-17 05:25:07 | Saskatchewan, Canada | ||
706196 | 706196 | 2021-09-29 | Canada | Saskatchewan | 66737 | 685 | 0 | 52.9399 | -106.4509 | 2021-09-30 04:21:20 | Saskatchewan, Canada | |||
710212 | 710212 | 2022-11-01 | Canada | Saskatchewan | 146888 | 1604 | 0 | 52.9399 | -106.4509 | 2022-11-02 04:22:09 | Saskatchewan, Canada | |||
714227 | 714227 | 2021-11-12 | Canada | Saskatchewan | 79334 | 891 | 0 | 52.9399 | -106.4509 | 2021-11-13 04:21:38 | Saskatchewan, Canada | |||
718244 | 718244 | 2022-12-04 | Canada | Saskatchewan | 149189 | 1701 | 0 | 52.9399 | -106.4509 | 2022-12-02 18:21:06 | Saskatchewan, Canada | |||
722259 | 722259 | 2021-11-20 | Canada | Saskatchewan | 80278 | 910 | 0 | 52.9399 | -106.4509 | 2021-11-21 04:22:13 | Saskatchewan, Canada | |||
726275 | 726275 | 2021-05-22 | Canada | Saskatchewan | 45490 | 526 | 43194 | 1770 | 52.9399 | -106.4509 | 2021-05-23 04:20:51 | Saskatchewan, Canada | ||
730289 | 730289 | 2021-12-27 | Canada | Saskatchewan | 83373 | 945 | 0 | 52.9399 | -106.4509 | 2021-12-28 04:21:47 | Saskatchewan, Canada | |||
737674 | 737674 | 2020-06-12 | Canada | Saskatchewan | 663 | 13 | 627 | 23 | 52.9399 | -106.4509 | 2020-06-13 03:33:14 | Saskatchewan, Canada | ||
738080 | 738080 | 2020-12-02 | Canada | Saskatchewan | 8982 | 53 | 4959 | 3970 | 52.9399 | -106.4509 | 2020-12-03 05:28:22 | Saskatchewan, Canada | ||
742091 | 742091 | 2021-02-20 | Canada | Saskatchewan | 27438 | 368 | 25468 | 1602 | 52.9399 | -106.4509 | 2021-02-21 05:24:33 | Saskatchewan, Canada | ||
746106 | 746106 | 2022-04-23 | Canada | Saskatchewan | 135197 | 1295 | 0 | 52.9399 | -106.4509 | 2022-04-24 04:20:56 | Saskatchewan, Canada | |||
753681 | 753681 | 2020-08-01 | Canada | Saskatchewan | 1334 | 18 | 1054 | 262 | 52.9399 | -106.4509 | 2020-08-02 04:34:47 | 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 | ||
758089 | 758089 | 2021-11-26 | Canada | Saskatchewan | 80775 | 916 | 0 | 52.9399 | -106.4509 | 2021-11-27 04:22:45 | Saskatchewan, Canada | |||
762093 | 762093 | 2020-10-18 | Canada | Saskatchewan | 2330 | 25 | 1963 | 342 | 52.9399 | -106.4509 | 2020-10-19 04:24:16 | Saskatchewan, Canada | ||
766099 | 766099 | 2020-12-29 | Canada | Saskatchewan | 15021 | 151 | 11680 | 3191 | 52.9399 | -106.4509 | 2020-12-30 05:22:34 | Saskatchewan, Canada | ||
770110 | 770110 | 2021-10-23 | Canada | Saskatchewan | 76074 | 817 | 0 | 52.9399 | -106.4509 | 2021-10-24 04:21:22 | Saskatchewan, Canada | |||
774126 | 774126 | 2021-01-12 | Canada | Saskatchewan | 18774 | 204 | 14814 | 3752 | 52.9399 | -106.4509 | 2021-01-13 05:22:15 | Saskatchewan, Canada | ||
778138 | 778138 | 2021-07-08 | Canada | Saskatchewan | 49152 | 570 | 48167 | 415 | 52.9399 | -106.4509 | 2021-07-09 04:21:21 | Saskatchewan, Canada | ||
782152 | 782152 | 2021-12-13 | Canada | Saskatchewan | 81852 | 937 | 0 | 52.9399 | -106.4509 | 2021-12-14 04:22:38 | Saskatchewan, Canada | |||
786156 | 786156 | 2020-10-15 | Canada | Saskatchewan | 2232 | 25 | 1936 | 271 | 52.9399 | -106.4509 | 2020-10-16 04:24:01 | 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]);