daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,022 rows where province_or_state = "Saskatchewan" sorted by day
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed, 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-03-13 | Canada | Saskatchewan | 2 | 0 | 0 | 52.9399 | -106.4509 | 2020-03-11T20:00:00 | ||||
2020-03-14 | Canada | Saskatchewan | 2 | 0 | 0 | 52.9399 | -106.4509 | 2020-03-14T00:13:05 | ||||
2020-03-15 | Canada | Saskatchewan | 2 | 0 | 0 | 52.9399 | -106.4509 | 2020-03-14T00:13:05 | ||||
2020-03-16 | Canada | Saskatchewan | 7 | 0 | 0 | 52.9399 | -106.4509 | 2020-03-16T20:13:20 | ||||
2020-03-17 | Canada | Saskatchewan | 7 | 0 | 0 | 52.9399 | -106.4509 | 2020-03-16T20:13:20 | ||||
2020-03-18 | Canada | Saskatchewan | 8 | 0 | 0 | 52.9399 | -106.4509 | 2020-03-18T11:53:04 | ||||
2020-03-19 | Canada | Saskatchewan | 16 | 0 | 0 | 52.9399 | -106.4509 | 2020-03-19T01:03:51 | ||||
2020-03-20 | Canada | Saskatchewan | 20 | 0 | 0 | 52.9399 | -106.4509 | 2020-03-20T03:13:18 | ||||
2020-03-21 | Canada | Saskatchewan | 26 | 0 | 0 | 52.9399 | -106.4509 | 2020-03-21T02:43:03 | ||||
2020-03-22 | Canada | Saskatchewan | 52 | 0 | 0 | 52 | 52.9399 | -106.4509 | 3/22/20 23:48 | Saskatchewan, Canada | ||
2020-03-23 | Canada | Saskatchewan | 66 | 0 | 0 | 66 | 52.9399 | -106.4509 | 2020-03-23 23:23:10 | Saskatchewan, Canada | ||
2020-03-24 | Canada | Saskatchewan | 72 | 0 | 0 | 72 | 52.9399 | -106.4509 | 2020-03-24 23:41:36 | 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-26 | Canada | Saskatchewan | 95 | 0 | 0 | 95 | 52.9399 | -106.4509 | 2020-03-26 23:53:11 | 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-28 | Canada | Saskatchewan | 134 | 0 | 0 | 134 | 52.9399 | -106.4509 | 3/28/20 23:10 | Saskatchewan, Canada | ||
2020-03-29 | Canada | Saskatchewan | 134 | 0 | 0 | 156 | 52.9399 | -106.4509 | 3/29/20 23:13 | Saskatchewan, Canada | ||
2020-03-30 | Canada | Saskatchewan | 175 | 2 | 0 | 154 | 52.9399 | -106.4509 | 3/30/20 22:58 | Saskatchewan, Canada | ||
2020-03-31 | Canada | Saskatchewan | 184 | 2 | 0 | 182 | 52.9399 | -106.4509 | 2020-03-31 23:49:13 | Saskatchewan, Canada | ||
2020-04-01 | Canada | Saskatchewan | 193 | 3 | 0 | 190 | 52.9399 | -106.4509 | 2020-04-01 22:04:44 | Saskatchewan, Canada | ||
2020-04-02 | Canada | Saskatchewan | 206 | 3 | 0 | 203 | 52.9399 | -106.4509 | 4/2/20 23:31 | Saskatchewan, Canada | ||
2020-04-03 | Canada | Saskatchewan | 220 | 3 | 0 | 217 | 52.9399 | -106.4509 | 2020-04-03 22:52:30 | Saskatchewan, Canada | ||
2020-04-04 | Canada | Saskatchewan | 231 | 3 | 0 | 217 | 52.9399 | -106.4509 | 4/4/20 23:40 | Saskatchewan, Canada | ||
2020-04-05 | Canada | Saskatchewan | 249 | 3 | 0 | 246 | 52.9399 | -106.4509 | 2020-04-05 23:13:28 | Saskatchewan, Canada | ||
2020-04-06 | Canada | Saskatchewan | 253 | 3 | 0 | 246 | 52.9399 | -106.4509 | 4/6/20 23:28 | Saskatchewan, Canada | ||
2020-04-07 | Canada | Saskatchewan | 260 | 3 | 0 | 257 | 52.9399 | -106.4509 | 2020-04-07 23:11:15 | Saskatchewan, Canada | ||
2020-04-08 | Canada | Saskatchewan | 271 | 3 | 0 | 257 | 52.9399 | -106.4509 | 2020-04-08 22:58:44 | Saskatchewan, Canada | ||
2020-04-09 | Canada | Saskatchewan | 278 | 3 | 0 | 268 | 52.9399 | -106.4509 | 2020-04-09 23:09:01 | Saskatchewan, Canada | ||
2020-04-10 | Canada | Saskatchewan | 285 | 3 | 0 | 282 | 52.9399 | -106.4509 | 2020-04-10 23:01:26 | Saskatchewan, Canada | ||
2020-04-11 | Canada | Saskatchewan | 289 | 4 | 0 | 285 | 52.9399 | -106.4509 | 2020-04-11 22:52:28 | Saskatchewan, Canada | ||
2020-04-12 | Canada | Saskatchewan | 298 | 4 | 0 | 294 | 52.9399 | -106.4509 | 2020-04-12 23:24:00 | Saskatchewan, Canada | ||
2020-04-13 | Canada | Saskatchewan | 300 | 4 | 0 | 296 | 52.9399 | -106.4509 | 2020-04-13 23:15:25 | Saskatchewan, Canada | ||
2020-04-14 | Canada | Saskatchewan | 301 | 4 | 0 | 296 | 52.9399 | -106.4509 | 2020-04-14 23:40:54 | Saskatchewan, Canada | ||
2020-04-15 | Canada | Saskatchewan | 304 | 4 | 0 | 300 | 52.9399 | -106.4509 | 2020-04-15 23:04:09 | Saskatchewan, Canada | ||
2020-04-16 | Canada | Saskatchewan | 305 | 4 | 0 | 301 | 52.9399 | -106.4509 | 2020-04-16 23:38:03 | Saskatchewan, Canada | ||
2020-04-17 | Canada | Saskatchewan | 307 | 4 | 0 | 303 | 52.9399 | -106.4509 | 2020-04-17 23:38:31 | Saskatchewan, Canada | ||
2020-04-18 | Canada | Saskatchewan | 313 | 4 | 0 | 309 | 52.9399 | -106.4509 | 2020-04-18 22:40:03 | Saskatchewan, Canada | ||
2020-04-19 | Canada | Saskatchewan | 315 | 4 | 0 | 311 | 52.9399 | -106.4509 | 2020-04-19 23:48:49 | Saskatchewan, Canada | ||
2020-04-20 | Canada | Saskatchewan | 316 | 4 | 0 | 312 | 52.9399 | -106.4509 | 2020-04-20 23:44:34 | Saskatchewan, Canada | ||
2020-04-21 | Canada | Saskatchewan | 320 | 4 | 0 | 316 | 52.9399 | -106.4509 | 2020-04-21 23:38:53 | Saskatchewan, Canada | ||
2020-04-22 | Canada | Saskatchewan | 326 | 4 | 0 | 322 | 52.9399 | -106.4509 | 2020-04-22 23:38:42 | Saskatchewan, Canada | ||
2020-04-23 | Canada | Saskatchewan | 331 | 4 | 0 | 327 | 52.9399 | -106.4509 | 2020-04-24 03:31:19 | Saskatchewan, Canada | ||
2020-04-24 | Canada | Saskatchewan | 341 | 4 | 0 | 337 | 52.9399 | -106.4509 | 2020-04-25 06:30:55 | Saskatchewan, Canada | ||
2020-04-25 | Canada | Saskatchewan | 349 | 4 | 0 | 345 | 52.9399 | -106.4509 | 2020-04-26 02:30:54 | Saskatchewan, Canada | ||
2020-04-26 | Canada | Saskatchewan | 353 | 4 | 0 | 349 | 52.9399 | -106.4509 | 2020-04-27 02:30:55 | Saskatchewan, Canada | ||
2020-04-27 | Canada | Saskatchewan | 365 | 5 | 0 | 360 | 52.9399 | -106.4509 | 2020-04-28 02:30:53 | Saskatchewan, Canada | ||
2020-04-28 | Canada | Saskatchewan | 366 | 5 | 0 | 361 | 52.9399 | -106.4509 | 2020-04-29 02:32:29 | Saskatchewan, Canada | ||
2020-04-29 | Canada | Saskatchewan | 383 | 6 | 0 | 377 | 52.9399 | -106.4509 | 2020-04-30 02:32:27 | Saskatchewan, Canada | ||
2020-04-30 | Canada | Saskatchewan | 389 | 6 | 0 | 382 | 52.9399 | -106.4509 | 2020-05-01 02:32:28 | Saskatchewan, Canada | ||
2020-05-01 | Canada | Saskatchewan | 415 | 6 | 0 | 408 | 52.9399 | -106.4509 | 2020-05-02 02:32:27 | Saskatchewan, Canada | ||
2020-05-02 | Canada | Saskatchewan | 421 | 6 | 0 | 414 | 52.9399 | -106.4509 | 2020-05-03 02:32:28 | Saskatchewan, Canada | ||
2020-05-03 | Canada | Saskatchewan | 433 | 6 | 0 | 426 | 52.9399 | -106.4509 | 2020-05-04 02:32:28 | Saskatchewan, Canada | ||
2020-05-04 | Canada | Saskatchewan | 467 | 6 | 0 | 460 | 52.9399 | -106.4509 | 2020-05-05 02:32:34 | Saskatchewan, Canada | ||
2020-05-05 | Canada | Saskatchewan | 487 | 6 | 0 | 480 | 52.9399 | -106.4509 | 2020-05-06 02:32:31 | Saskatchewan, Canada | ||
2020-05-06 | Canada | Saskatchewan | 512 | 6 | 0 | 505 | 52.9399 | -106.4509 | 2020-05-07 02:32:28 | Saskatchewan, Canada | ||
2020-05-07 | Canada | Saskatchewan | 531 | 6 | 0 | 524 | 52.9399 | -106.4509 | 2020-05-08 02:32:32 | 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-09 | Canada | Saskatchewan | 553 | 6 | 0 | 546 | 52.9399 | -106.4509 | 2020-05-10 02:32:30 | 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-11 | Canada | Saskatchewan | 568 | 6 | 0 | 561 | 52.9399 | -106.4509 | 2020-05-12 03:32:27 | 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-13 | Canada | Saskatchewan | 577 | 6 | 0 | 570 | 52.9399 | -106.4509 | 2020-05-14 03:32:28 | Saskatchewan, Canada | ||
2020-05-14 | Canada | Saskatchewan | 582 | 6 | 398 | 177 | 52.9399 | -106.4509 | 2020-05-15 02:33:02 | Saskatchewan, Canada | ||
2020-05-15 | Canada | Saskatchewan | 590 | 6 | 408 | 175 | 52.9399 | -106.4509 | 2020-05-16 02:32:19 | Saskatchewan, Canada | ||
2020-05-16 | Canada | Saskatchewan | 591 | 6 | 433 | 151 | 52.9399 | -106.4509 | 2020-05-17 02:32:32 | Saskatchewan, Canada | ||
2020-05-17 | Canada | Saskatchewan | 592 | 6 | 444 | 141 | 52.9399 | -106.4509 | 2020-05-18 02:32:21 | Saskatchewan, Canada | ||
2020-05-18 | Canada | Saskatchewan | 592 | 6 | 455 | 130 | 52.9399 | -106.4509 | 2020-05-19 02:32:18 | Saskatchewan, Canada | ||
2020-05-19 | Canada | Saskatchewan | 599 | 6 | 470 | 122 | 52.9399 | -106.4509 | 2020-05-20 02:32:19 | Saskatchewan, Canada | ||
2020-05-20 | Canada | Saskatchewan | 620 | 6 | 494 | 119 | 52.9399 | -106.4509 | 2020-05-21 02:32:48 | Saskatchewan, Canada | ||
2020-05-21 | Canada | Saskatchewan | 622 | 7 | 509 | 106 | 52.9399 | -106.4509 | 2020-05-22 02:36:51 | Saskatchewan, Canada | ||
2020-05-22 | Canada | Saskatchewan | 627 | 7 | 521 | 99 | 52.9399 | -106.4509 | 2020-05-23 02:32:42 | Saskatchewan, Canada | ||
2020-05-23 | Canada | Saskatchewan | 630 | 7 | 535 | 88 | 52.9399 | -106.4509 | 2020-05-24 02:32:43 | Saskatchewan, Canada | ||
2020-05-24 | Canada | Saskatchewan | 632 | 7 | 538 | 87 | 52.9399 | -106.4509 | 2020-05-25 02:32:44 | Saskatchewan, Canada | ||
2020-05-25 | Canada | Saskatchewan | 634 | 7 | 546 | 81 | 52.9399 | -106.4509 | 2020-05-26 02:32:35 | Saskatchewan, Canada | ||
2020-05-26 | Canada | Saskatchewan | 634 | 8 | 549 | 77 | 52.9399 | -106.4509 | 2020-05-27 02:32:31 | Saskatchewan, Canada | ||
2020-05-27 | Canada | Saskatchewan | 637 | 10 | 559 | 68 | 52.9399 | -106.4509 | 2020-05-28 02:32:31 | Saskatchewan, Canada | ||
2020-05-28 | Canada | Saskatchewan | 639 | 10 | 568 | 61 | 52.9399 | -106.4509 | 2020-05-29 02:32:50 | 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-30 | Canada | Saskatchewan | 645 | 10 | 580 | 55 | 52.9399 | -106.4509 | 2020-05-31 02:32:45 | Saskatchewan, Canada | ||
2020-05-31 | Canada | Saskatchewan | 646 | 11 | 582 | 53 | 52.9399 | -106.4509 | 2020-06-01 02:32:46 | Saskatchewan, Canada | ||
2020-06-01 | Canada | Saskatchewan | 646 | 11 | 588 | 47 | 52.9399 | -106.4509 | 2020-06-02 02:33:08 | Saskatchewan, Canada | ||
2020-06-02 | Canada | Saskatchewan | 646 | 11 | 602 | 33 | 52.9399 | -106.4509 | 2020-06-03 02:33:13 | Saskatchewan, Canada | ||
2020-06-03 | Canada | Saskatchewan | 647 | 11 | 602 | 34 | 52.9399 | -106.4509 | 2020-06-04 02:33:14 | Saskatchewan, Canada | ||
2020-06-04 | Canada | Saskatchewan | 648 | 11 | 608 | 29 | 52.9399 | -106.4509 | 2020-06-05 02:33:06 | Saskatchewan, Canada | ||
2020-06-05 | Canada | Saskatchewan | 649 | 11 | 611 | 27 | 52.9399 | -106.4509 | 2020-06-06 02:33:00 | Saskatchewan, Canada | ||
2020-06-06 | Canada | Saskatchewan | 650 | 11 | 611 | 28 | 52.9399 | -106.4509 | 2020-06-07 03:53:30 | Saskatchewan, Canada | ||
2020-06-07 | Canada | Saskatchewan | 650 | 11 | 623 | 16 | 52.9399 | -106.4509 | 2020-06-08 03:33:22 | Saskatchewan, Canada | ||
2020-06-08 | Canada | Saskatchewan | 654 | 13 | 624 | 17 | 52.9399 | -106.4509 | 2020-06-09 03:33:03 | Saskatchewan, Canada | ||
2020-06-09 | Canada | Saskatchewan | 656 | 13 | 624 | 19 | 52.9399 | -106.4509 | 2020-06-10 04:07:00 | Saskatchewan, Canada | ||
2020-06-10 | Canada | Saskatchewan | 658 | 13 | 624 | 21 | 52.9399 | -106.4509 | 2020-06-11 03:33:41 | Saskatchewan, Canada | ||
2020-06-11 | Canada | Saskatchewan | 660 | 13 | 626 | 21 | 52.9399 | -106.4509 | 2020-06-12 05:09:52 | Saskatchewan, Canada | ||
2020-06-12 | Canada | Saskatchewan | 663 | 13 | 627 | 23 | 52.9399 | -106.4509 | 2020-06-13 03:33:14 | Saskatchewan, Canada | ||
2020-06-13 | Canada | Saskatchewan | 664 | 13 | 627 | 24 | 52.9399 | -106.4509 | 2020-06-14 03:33:15 | Saskatchewan, Canada | ||
2020-06-14 | Canada | Saskatchewan | 665 | 13 | 628 | 24 | 52.9399 | -106.4509 | 2020-06-15 03:33:14 | Saskatchewan, Canada | ||
2020-06-15 | Canada | Saskatchewan | 683 | 13 | 629 | 41 | 52.9399 | -106.4509 | 2020-06-16 04:33:09 | Saskatchewan, Canada | ||
2020-06-16 | Canada | Saskatchewan | 684 | 13 | 631 | 40 | 52.9399 | -106.4509 | 2020-06-17 04:33:21 | Saskatchewan, Canada | ||
2020-06-17 | Canada | Saskatchewan | 693 | 13 | 633 | 47 | 52.9399 | -106.4509 | 2020-06-18 04:33:18 | Saskatchewan, Canada | ||
2020-06-18 | Canada | Saskatchewan | 708 | 13 | 636 | 59 | 52.9399 | -106.4509 | 2020-06-19 04:33:17 | Saskatchewan, Canada | ||
2020-06-19 | Canada | Saskatchewan | 716 | 13 | 636 | 67 | 52.9399 | -106.4509 | 2020-06-20 04:33:19 | Saskatchewan, Canada | ||
2020-06-20 | Canada | Saskatchewan | 726 | 13 | 639 | 74 | 52.9399 | -106.4509 | 2020-06-21 04:33:19 | Saskatchewan, Canada |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;