⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

464 rows where country_or_region = "Canada" and province_or_state = "Saskatchewan" sorted by day descending

View and edit SQL

Suggested facets: day (date), last_update (date)

province_or_state

  • Saskatchewan · 464

country_or_region

  • Canada · 464
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
168237 2021-06-19 Canada Saskatchewan     48381 562 47059 760 52.9399 -106.4509 2021-06-20 04:21:48 Saskatchewan, Canada
685762 2021-06-18 Canada Saskatchewan     48327 562 47002 763 52.9399 -106.4509 2021-06-19 04:22:33 Saskatchewan, Canada
957819 2021-06-17 Canada Saskatchewan     48220 561 46907 752 52.9399 -106.4509 2021-06-18 04:22:16 Saskatchewan, Canada
1281186 2021-06-16 Canada Saskatchewan     48125 562 46837 726 52.9399 -106.4509 2021-06-17 04:22:36 Saskatchewan, Canada
681776 2021-06-15 Canada Saskatchewan     48043 560 46761 722 52.9399 -106.4509 2021-06-16 04:22:32 Saskatchewan, Canada
372330 2021-06-14 Canada Saskatchewan     47996 556 46666 774 52.9399 -106.4509 2021-06-15 04:22:22 Saskatchewan, Canada
1223146 2021-06-13 Canada Saskatchewan     47941 555 46577 809 52.9399 -106.4509 2021-06-14 04:22:46 Saskatchewan, Canada
80427 2021-06-12 Canada Saskatchewan     47875 555 46446 874 52.9399 -106.4509 2021-06-13 04:22:44 Saskatchewan, Canada
969730 2021-06-11 Canada Saskatchewan     47764 554 46311 899 52.9399 -106.4509 2021-06-12 04:22:22 Saskatchewan, Canada
1438303 2021-06-10 Canada Saskatchewan     47668 553 46213 902 52.9399 -106.4509 2021-06-11 04:23:20 Saskatchewan, Canada
1156802 2021-06-09 Canada Saskatchewan     47574 552 46084 938 52.9399 -106.4509 2021-06-10 04:23:17 Saskatchewan, Canada
1231118 2021-06-08 Canada Saskatchewan     47517 551 45913 1053 52.9399 -106.4509 2021-06-09 04:23:31 Saskatchewan, Canada
360114 2021-06-07 Canada Saskatchewan     47427 549 45736 1142 52.9399 -106.4509 2021-06-08 04:22:35 Saskatchewan, Canada
1075742 2021-06-06 Canada Saskatchewan     47359 546 45617 1196 52.9399 -106.4509 2021-06-07 04:22:51 Saskatchewan, Canada
1613134 2021-06-05 Canada Saskatchewan     47285 546 45498 1241 52.9399 -106.4509 2021-06-06 04:24:03 Saskatchewan, Canada
1125420 2021-06-04 Canada Saskatchewan     47186 543 45351 1292 52.9399 -106.4509 2021-06-05 04:23:03 Saskatchewan, Canada
317876 2021-06-03 Canada Saskatchewan     47097 543 45240 1314 52.9399 -106.4509 2021-06-04 04:23:37 Saskatchewan, Canada
1133389 2021-06-02 Canada Saskatchewan     46964 541 45138 1285 52.9399 -106.4509 2021-06-03 04:23:32 Saskatchewan, Canada
291566 2021-06-01 Canada Saskatchewan     46834 540 45022 1272 52.9399 -106.4509 2021-06-02 04:24:34 Saskatchewan, Canada
1651517 2021-05-31 Canada Saskatchewan     46748 539 44841 1368 52.9399 -106.4509 2021-06-01 04:23:09 Saskatchewan, Canada
980745 2021-05-30 Canada Saskatchewan     46635 538 44667 1430 52.9399 -106.4509 2021-05-31 03:08:59 Saskatchewan, Canada
841126 2021-05-29 Canada Saskatchewan     46464 537 44519 1408 52.9399 -106.4509 2021-05-30 04:20:55 Saskatchewan, Canada
697698 2021-05-28 Canada Saskatchewan     46285 536 44378 1371 52.9399 -106.4509 2021-05-29 04:20:41 Saskatchewan, Canada
1369199 2021-05-27 Canada Saskatchewan     46163 534 44247 1382 52.9399 -106.4509 2021-05-28 04:20:36 Saskatchewan, Canada
1292284 2021-05-26 Canada Saskatchewan     46001 528 44031 1442 52.9399 -106.4509 2021-05-27 04:20:59 Saskatchewan, Canada
602655 2021-05-25 Canada Saskatchewan     45820 527 43842 1451 52.9399 -106.4509 2021-05-26 04:20:35 Saskatchewan, Canada
1365213 2021-05-24 Canada Saskatchewan     45709 527 43645 1537 52.9399 -106.4509 2021-05-25 04:21:08 Saskatchewan, Canada
419726 2021-05-23 Canada Saskatchewan     45605 527 43416 1662 52.9399 -106.4509 2021-05-24 04:20:53 Saskatchewan, Canada
54065 2021-05-22 Canada Saskatchewan     45490 526 43194 1770 52.9399 -106.4509 2021-05-23 04:20:51 Saskatchewan, Canada
368344 2021-05-21 Canada Saskatchewan     45310 524 43010 1776 52.9399 -106.4509 2021-05-22 04:20:45 Saskatchewan, Canada
1024143 2021-05-20 Canada Saskatchewan     45128 522 42821 1785 52.9399 -106.4509 2021-05-21 04:20:43 Saskatchewan, Canada
1678769 2021-05-19 Canada Saskatchewan     44982 522 42674 1786 52.9399 -106.4509 2021-05-20 04:21:05 Saskatchewan, Canada
64756 2021-05-18 Canada Saskatchewan     44841 522 42494 1825 52.9399 -106.4509 2021-05-19 04:20:42 Saskatchewan, Canada
1242828 2021-05-17 Canada Saskatchewan     44709 519 42225 1965 52.9399 -106.4509 2021-05-18 04:20:33 Saskatchewan, Canada
1067676 2021-05-16 Canada Saskatchewan     44531 517 41932 2082 52.9399 -106.4509 2021-05-17 04:20:34 Saskatchewan, Canada
504804 2021-05-15 Canada Saskatchewan     44364 516 41776 2072 52.9399 -106.4509 2021-05-16 04:20:49 Saskatchewan, Canada
892409 2021-05-14 Canada Saskatchewan     44159 515 41569 2075 52.9399 -106.4509 2021-05-15 04:20:58 Saskatchewan, Canada
531744 2021-05-13 Canada Saskatchewan     43926 513 41381 2032 52.9399 -106.4509 2021-05-14 04:20:41 Saskatchewan, Canada
1719031 2021-05-12 Canada Saskatchewan     43673 508 41149 2016 52.9399 -106.4509 2021-05-13 04:20:51 Saskatchewan, Canada
1723017 2021-05-11 Canada Saskatchewan     43481 506 40911 2064 52.9399 -106.4509 2021-05-12 04:21:29 Saskatchewan, Canada
1164774 2021-05-10 Canada Saskatchewan     43288 502 40645 2141 52.9399 -106.4509 2021-05-11 04:20:41 Saskatchewan, Canada
1168760 2021-05-09 Canada Saskatchewan     43141 502 40379 2260 52.9399 -106.4509 2021-05-10 04:20:38 Saskatchewan, Canada
1659547 2021-05-08 Canada Saskatchewan     42964 502 40169 2293 52.9399 -106.4509 2021-05-09 04:20:35 Saskatchewan, Canada
799645 2021-05-07 Canada Saskatchewan     42695 502 39954 2239 52.9399 -106.4509 2021-05-08 04:21:04 Saskatchewan, Canada
1219160 2021-05-06 Canada Saskatchewan     42376 501 39717 2158 52.9399 -106.4509 2021-05-07 04:20:40 Saskatchewan, Canada
415740 2021-05-05 Canada Saskatchewan     42203 501 39452 2250 52.9399 -106.4509 2021-05-06 04:20:38 Saskatchewan, Canada
673761 2021-05-04 Canada Saskatchewan     42006 499 39202 2305 52.9399 -106.4509 2021-05-05 04:20:43 Saskatchewan, Canada
1087785 2021-05-03 Canada Saskatchewan     41806 498 38911 2397 52.9399 -106.4509 2021-05-04 04:20:34 Saskatchewan, Canada
1727003 2021-05-02 Canada Saskatchewan     41599 495 38667 2437 52.9399 -106.4509 2021-05-03 04:20:39 Saskatchewan, Canada
1083799 2021-05-01 Canada Saskatchewan     41360 494 38414 2452 52.9399 -106.4509 2021-05-02 04:20:48 Saskatchewan, Canada
1388327 2021-04-30 Canada Saskatchewan     41098 491 38181 2426 52.9399 -106.4509 2021-05-01 04:20:47 Saskatchewan, Canada
38146 2021-04-29 Canada Saskatchewan     40824 487 37929 2408 52.9399 -106.4509 2021-04-30 04:21:03 Saskatchewan, Canada
11719 2021-04-28 Canada Saskatchewan     40614 486 37685 2443 52.9399 -106.4509 2021-04-29 04:20:55 Saskatchewan, Canada
853102 2021-04-27 Canada Saskatchewan     40401 482 37401 2518 52.9399 -106.4509 2021-04-28 04:20:32 Saskatchewan, Canada
1063690 2021-04-26 Canada Saskatchewan     40177 476 37163 2538 52.9399 -106.4509 2021-04-27 04:20:52 Saskatchewan, Canada
1475940 2021-04-25 Canada Saskatchewan     39932 475 36942 2515 52.9399 -106.4509 2021-04-26 04:21:04 Saskatchewan, Canada
743561 2021-04-24 Canada Saskatchewan     39683 473 36652 2558 52.9399 -106.4509 2021-04-25 04:20:32 Saskatchewan, Canada
1430360 2021-04-23 Canada Saskatchewan     39392 471 36458 2463 52.9399 -106.4509 2021-04-24 04:20:38 Saskatchewan, Canada
96189 2021-04-22 Canada Saskatchewan     39137 470 36162 2505 52.9399 -106.4509 2021-04-23 04:20:52 Saskatchewan, Canada
849116 2021-04-21 Canada Saskatchewan     38883 469 35863 2551 52.9399 -106.4509 2021-04-22 04:20:53 Saskatchewan, Canada
826734 2021-04-20 Canada Saskatchewan     38651 465 35546 2640 52.9399 -106.4509 2021-04-21 04:21:14 Saskatchewan, Canada
770445 2021-04-19 Canada Saskatchewan     38401 465 35310 2626 52.9399 -106.4509 2021-04-20 04:20:41 Saskatchewan, Canada
1415754 2021-04-18 Canada Saskatchewan     38160 465 34953 2742 52.9399 -106.4509 2021-04-19 04:20:57 Saskatchewan, Canada
984731 2021-04-17 Canada Saskatchewan     37615 462 34550 2603 52.9399 -106.4509 2021-04-18 04:20:41 Saskatchewan, Canada
237794 2021-04-16 Canada Saskatchewan     37615 462 34550 2603 52.9399 -106.4509 2021-04-17 04:20:40 Saskatchewan, Canada
579523 2021-04-15 Canada Saskatchewan     37384 460 34325 2599 52.9399 -106.4509 2021-04-16 04:20:46 Saskatchewan, Canada
1266151 2021-04-14 Canada Saskatchewan     37085 458 34102 2525 52.9399 -106.4509 2021-04-15 04:20:54 Saskatchewan, Canada
701684 2021-04-13 Canada Saskatchewan     36892 457 33880 2555 52.9399 -106.4509 2021-04-14 04:20:41 Saskatchewan, Canada
1670797 2021-04-12 Canada Saskatchewan     36604 455 33600 2549 52.9399 -106.4509 2021-04-13 04:20:37 Saskatchewan, Canada
784502 2021-04-11 Canada Saskatchewan     36305 454 33347 2504 52.9399 -106.4509 2021-04-12 04:21:00 Saskatchewan, Canada
1392313 2021-04-10 Canada Saskatchewan     35983 453 33149 2381 52.9399 -106.4509 2021-04-11 04:20:56 Saskatchewan, Canada
965744 2021-04-09 Canada Saskatchewan     35748 453 32958 2337 52.9399 -106.4509 2021-04-10 04:20:59 Saskatchewan, Canada
689748 2021-04-08 Canada Saskatchewan     35376 447 32788 2141 52.9399 -106.4509 2021-04-09 04:21:13 Saskatchewan, Canada
1277200 2021-04-07 Canada Saskatchewan     35171 445 32588 2138 52.9399 -106.4509 2021-04-08 04:21:13 Saskatchewan, Canada
88219 2021-04-06 Canada Saskatchewan     34980 443 32342 2195 52.9399 -106.4509 2021-04-07 04:20:53 Saskatchewan, Canada
122601 2021-04-05 Canada Saskatchewan     34763 440 32121 2202 52.9399 -106.4509 2021-04-06 04:20:32 Saskatchewan, Canada
73103 2021-04-04 Canada Saskatchewan     34544 439 31909 2196 52.9399 -106.4509 2021-04-05 04:20:35 Saskatchewan, Canada
791719 2021-04-03 Canada Saskatchewan     34323 436 31744 2143 52.9399 -106.4509 2021-04-04 04:20:49 Saskatchewan, Canada
1020157 2021-04-02 Canada Saskatchewan     34043 437 31554 2052 52.9399 -106.4509 2021-04-03 04:20:44 Saskatchewan, Canada
1350319 2021-04-01 Canada Saskatchewan     33789 436 31404 1949 52.9399 -106.4509 2021-04-02 04:20:36 Saskatchewan, Canada
1690705 2021-03-31 Canada Saskatchewan     33590 436 31199 1955 52.9399 -106.4509 2021-04-01 04:27:05 Saskatchewan, Canada
873074 2021-03-30 Canada Saskatchewan     33399 434 31023 1942 52.9399 -106.4509 2021-03-31 04:26:25 Saskatchewan, Canada
1400121 2021-03-29 Canada Saskatchewan     33233 433 30822 1978 52.9399 -106.4509 2021-03-30 04:26:23 Saskatchewan, Canada
1624524 2021-03-28 Canada Saskatchewan     33031 433 30648 1950 52.9399 -106.4509 2021-03-29 04:28:35 Saskatchewan, Canada
1471954 2021-03-27 Canada Saskatchewan     32783 430 30536 1817 52.9399 -106.4509 2021-03-28 05:28:10 Saskatchewan, Canada
720501 2021-03-26 Canada Saskatchewan     32559 430 30449 1680 52.9399 -106.4509 2021-03-27 05:25:04 Saskatchewan, Canada
1617120 2021-03-25 Canada Saskatchewan     32346 422 30301 1623 52.9399 -106.4509 2021-03-26 05:26:55 Saskatchewan, Canada
469781 2021-03-24 Canada Saskatchewan     32181 420 30196 1565 52.9399 -106.4509 2021-03-25 05:27:00 Saskatchewan, Canada
1584821 2021-03-23 Canada Saskatchewan     31991 419 30100 1472 52.9399 -106.4509 2021-03-24 05:25:40 Saskatchewan, Canada
716515 2021-03-22 Canada Saskatchewan     31842 418 29948 1476 52.9399 -106.4509 2021-03-23 05:26:18 Saskatchewan, Canada
1674783 2021-03-21 Canada Saskatchewan     31637 418 29772 1447 52.9399 -106.4509 2021-03-22 05:25:43 Saskatchewan, Canada
1746722 2021-03-20 Canada Saskatchewan     31459 417 29608 1434 52.9399 -106.4509 2021-03-21 05:25:44 Saskatchewan, Canada
229844 2021-03-19 Canada Saskatchewan     31259 414 29500 1345 52.9399 -106.4509 2021-03-20 05:25:46 Saskatchewan, Canada
477779 2021-03-18 Canada Saskatchewan     31085 411 29392 1282 52.9399 -106.4509 2021-03-19 05:26:09 Saskatchewan, Canada
1426374 2021-03-17 Canada Saskatchewan     30970 410 29296 1264 52.9399 -106.4509 2021-03-18 05:26:22 Saskatchewan, Canada
1592962 2021-03-16 Canada Saskatchewan     30883 409 29182 1292 52.9399 -106.4509 2021-03-17 05:25:07 Saskatchewan, Canada
1175961 2021-03-15 Canada Saskatchewan     30727 407 29021 1299 52.9399 -106.4509 2021-03-16 05:25:13 Saskatchewan, Canada
275646 2021-03-14 Canada Saskatchewan     30620 407 28814 1399 52.9399 -106.4509 2021-03-15 05:25:51 Saskatchewan, Canada
1160788 2021-03-13 Canada Saskatchewan     30522 405 28648 1469 52.9399 -106.4509 2021-03-14 05:25:37 Saskatchewan, Canada
22295 2021-03-12 Canada Saskatchewan     30369 404 28528 1437 52.9399 -106.4509 2021-03-13 05:25:15 Saskatchewan, Canada

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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] INTEGER,
   [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]);