⚠️ 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

472 rows where country_or_region = "Canada" and province_or_state = "Ontario" sorted by day descending

View and edit SQL

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

province_or_state

  • Ontario · 472

country_or_region

  • Canada · 472
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
222700 2021-06-14 Canada Ontario     547657 8936 533335 5386 51.2538 -85.3232 2021-06-15 04:22:22 Ontario, Canada
214732 2021-06-13 Canada Ontario     547034 8920 532339 5775 51.2538 -85.3232 2021-06-14 04:22:46 Ontario, Canada
281302 2021-06-12 Canada Ontario     546624 8918 531802 5904 51.2538 -85.3232 2021-06-13 04:22:44 Ontario, Canada
1633401 2021-06-11 Canada Ontario     546224 8911 531275 6038 51.2538 -85.3232 2021-06-12 04:22:22 Ontario, Canada
662687 2021-06-10 Canada Ontario     545692 8906 530546 6240 51.2538 -85.3232 2021-06-11 04:23:20 Ontario, Canada
881791 2021-06-09 Canada Ontario     545117 8892 529717 6508 51.2538 -85.3232 2021-06-10 04:23:17 Ontario, Canada
1709790 2021-06-08 Canada Ontario     544636 8869 528816 6951 51.2538 -85.3232 2021-06-09 04:23:31 Ontario, Canada
1465634 2021-06-07 Canada Ontario     544363 8848 527970 7545 51.2538 -85.3232 2021-06-08 04:22:35 Ontario, Canada
993401 2021-06-06 Canada Ontario     543601 8823 526480 8298 51.2538 -85.3232 2021-06-07 04:22:51 Ontario, Canada
158191 2021-06-05 Canada Ontario     542950 8817 525521 8612 51.2538 -85.3232 2021-06-06 04:24:03 Ontario, Canada
1516176 2021-06-04 Canada Ontario     542526 8808 524973 8745 51.2538 -85.3232 2021-06-05 04:23:03 Ontario, Canada
1140487 2021-06-03 Canada Ontario     541641 8783 523853 9005 51.2538 -85.3232 2021-06-04 04:23:37 Ontario, Canada
426931 2021-06-02 Canada Ontario     540763 8768 522551 9444 51.2538 -85.3232 2021-06-03 04:23:32 Ontario, Canada
539438 2021-06-01 Canada Ontario     539910 8745 520983 10182 51.2538 -85.3232 2021-06-02 04:24:34 Ontario, Canada
786623 2021-05-31 Canada Ontario     539196 8737 519368 11091 51.2538 -85.3232 2021-06-01 04:23:09 Ontario, Canada
1330021 2021-05-30 Canada Ontario     537919 8704 516826 12389 51.2538 -85.3232 2021-05-31 03:08:59 Ontario, Canada
67230 2021-05-29 Canada Ontario     537138 8698 515505 12935 51.2538 -85.3232 2021-05-30 04:20:55 Ontario, Canada
195416 2021-05-28 Canada Ontario     536274 8694 514081 13499 51.2538 -85.3232 2021-05-29 04:20:41 Ontario, Canada
938675 2021-05-27 Canada Ontario     535087 8678 511977 14432 51.2538 -85.3232 2021-05-28 04:20:36 Ontario, Canada
1226350 2021-05-26 Canada Ontario     532198 8619 506713 16866 51.2538 -85.3232 2021-05-27 04:20:59 Ontario, Canada
1337989 2021-05-25 Canada Ontario     531362 8599 505210 17553 51.2538 -85.3232 2021-05-26 04:20:35 Ontario, Canada
202821 2021-05-24 Canada Ontario     530104 8591 503111 18402 51.2538 -85.3232 2021-05-25 04:21:08 Ontario, Canada
98985 2021-05-23 Canada Ontario     529748 8588 502392 18768 51.2538 -85.3232 2021-05-24 04:20:53 Ontario, Canada
523504 2021-05-22 Canada Ontario     528516 8575 500792 19149 51.2538 -85.3232 2021-05-23 04:20:51 Ontario, Canada
859199 2021-05-21 Canada Ontario     527111 8564 499048 19499 51.2538 -85.3232 2021-05-22 04:20:45 Ontario, Canada
720622 2021-05-20 Canada Ontario     525365 8533 496573 20259 51.2538 -85.3232 2021-05-21 04:20:43 Ontario, Canada
407753 2021-05-19 Canada Ontario     523186 8508 494097 20581 51.2538 -85.3232 2021-05-20 04:21:05 Ontario, Canada
782639 2021-05-18 Canada Ontario     521031 8486 491340 21205 51.2538 -85.3232 2021-05-19 04:20:42 Ontario, Canada
1422781 2021-05-17 Canada Ontario     519576 8470 488628 22478 51.2538 -85.3232 2021-05-18 04:20:33 Ontario, Canada
739967 2021-05-16 Canada Ontario     516507 8440 483992 24075 51.2538 -85.3232 2021-05-17 04:20:34 Ontario, Canada
1116500 2021-05-15 Canada Ontario     514907 8430 481991 24486 51.2538 -85.3232 2021-05-16 04:20:49 Ontario, Canada
1587009 2021-05-14 Canada Ontario     513107 8418 479911 24778 51.2538 -85.3232 2021-05-15 04:20:58 Ontario, Canada
1674926 2021-05-13 Canada Ontario     509951 8381 475502 26068 51.2538 -85.3232 2021-05-14 04:20:41 Ontario, Canada
802553 2021-05-12 Canada Ontario     508043 8360 473340 26343 51.2538 -85.3232 2021-05-13 04:20:51 Ontario, Canada
1180941 2021-05-11 Canada Ontario     505364 8320 470083 26961 51.2538 -85.3232 2021-05-12 04:21:29 Ontario, Canada
324731 2021-05-10 Canada Ontario     503296 8304 466856 28136 51.2538 -85.3232 2021-05-11 04:20:41 Ontario, Canada
603878 2021-05-09 Canada Ontario     499246 8258 461801 29187 51.2538 -85.3232 2021-05-10 04:20:38 Ontario, Canada
985625 2021-05-08 Canada Ontario     497032 8246 459438 29348 51.2538 -85.3232 2021-05-09 04:20:35 Ontario, Canada
434107 2021-05-07 Canada Ontario     494884 8229 457032 29623 51.2538 -85.3232 2021-05-08 04:21:04 Ontario, Canada
900888 2021-05-06 Canada Ontario     491926 8202 453379 30345 51.2538 -85.3232 2021-05-07 04:20:40 Ontario, Canada
71214 2021-05-05 Canada Ontario     488535 8173 449670 30692 51.2538 -85.3232 2021-05-06 04:20:38 Ontario, Canada
790607 2021-05-04 Canada Ontario     485172 8146 445861 31165 51.2538 -85.3232 2021-05-05 04:20:43 Ontario, Canada
1613137 2021-05-03 Canada Ontario     482447 8109 442002 32336 51.2538 -85.3232 2021-05-04 04:20:34 Ontario, Canada
885775 2021-05-02 Canada Ontario     477138 8070 436048 33020 51.2538 -85.3232 2021-05-03 04:20:39 Ontario, Canada
511480 2021-05-01 Canada Ontario     474595 8062 433460 33073 51.2538 -85.3232 2021-05-02 04:20:48 Ontario, Canada
14416 2021-04-30 Canada Ontario     472291 8050 430586 33655 51.2538 -85.3232 2021-05-01 04:20:47 Ontario, Canada
1124520 2021-04-29 Canada Ontario     468485 8024 426425 34036 51.2538 -85.3232 2021-04-30 04:21:03 Ontario, Canada
461817 2021-04-28 Canada Ontario     463770 7980 420930 34860 51.2538 -85.3232 2021-04-29 04:20:55 Ontario, Canada
1314523 2021-04-27 Canada Ontario     459790 7946 416751 35093 51.2538 -85.3232 2021-04-28 04:20:32 Ontario, Canada
1548950 2021-04-26 Canada Ontario     456753 7921 412639 36193 51.2538 -85.3232 2021-04-27 04:20:52 Ontario, Canada
1629417 2021-04-25 Canada Ontario     453337 7895 408512 36930 51.2538 -85.3232 2021-04-26 04:21:04 Ontario, Canada
353557 2021-04-24 Canada Ontario     449446 7871 404392 37183 51.2538 -85.3232 2021-04-25 04:20:32 Ontario, Canada
724606 2021-04-23 Canada Ontario     445407 7849 400089 37469 51.2538 -85.3232 2021-04-24 04:20:38 Ontario, Canada
1469618 2021-04-22 Canada Ontario     441059 7816 395406 37837 51.2538 -85.3232 2021-04-23 04:20:52 Ontario, Canada
1222366 2021-04-21 Canada Ontario     436693 7786 390833 38074 51.2538 -85.3232 2021-04-22 04:20:53 Ontario, Canada
457833 2021-04-20 Canada Ontario     432666 7741 384917 40008 51.2538 -85.3232 2021-04-21 04:21:14 Ontario, Canada
1300021 2021-04-19 Canada Ontario     429240 7716 381260 40264 51.2538 -85.3232 2021-04-20 04:20:41 Ontario, Canada
1069600 2021-04-18 Canada Ontario     424854 7703 377777 39374 51.2538 -85.3232 2021-04-19 04:20:57 Ontario, Canada
1045482 2021-04-17 Canada Ontario     420241 7680 374315 38246 51.2538 -85.3232 2021-04-18 04:20:41 Ontario, Canada
596758 2021-04-16 Canada Ontario     416141 7653 370341 38147 51.2538 -85.3232 2021-04-17 04:20:40 Ontario, Canada
1621174 2021-04-15 Canada Ontario     411346 7620 366873 36853 51.2538 -85.3232 2021-04-16 04:20:46 Ontario, Canada
950605 2021-04-14 Canada Ontario     406563 7592 363632 35339 51.2538 -85.3232 2021-04-15 04:20:54 Ontario, Canada
592774 2021-04-13 Canada Ontario     402003 7559 360560 33884 51.2538 -85.3232 2021-04-14 04:20:41 Ontario, Canada
32713 2021-04-12 Canada Ontario     398461 7546 357678 33237 51.2538 -85.3232 2021-04-13 04:20:37 Ontario, Canada
1371728 2021-04-11 Canada Ontario     394197 7530 354981 31686 51.2538 -85.3232 2021-04-12 04:21:00 Ontario, Canada
1666980 2021-04-10 Canada Ontario     389648 7513 352338 29797 51.2538 -85.3232 2021-04-11 04:20:56 Ontario, Canada
1159596 2021-04-09 Canada Ontario     385604 7496 349619 28489 51.2538 -85.3232 2021-04-10 04:20:59 Ontario, Canada
1057431 2021-04-08 Canada Ontario     381549 7478 346827 27244 51.2538 -85.3232 2021-04-09 04:21:13 Ontario, Canada
1500220 2021-04-07 Canada Ontario     377999 7461 344222 26316 51.2538 -85.3232 2021-04-08 04:21:13 Ontario, Canada
1207425 2021-04-06 Canada Ontario     374544 7448 341652 25444 51.2538 -85.3232 2021-04-07 04:20:53 Ontario, Canada
122726 2021-04-05 Canada Ontario     371317 7437 339479 24401 51.2538 -85.3232 2021-04-06 04:20:32 Ontario, Canada
1254527 2021-04-04 Canada Ontario     367501 7425 337043 23033 51.2538 -85.3232 2021-04-05 04:20:35 Ontario, Canada
1128504 2021-04-03 Canada Ontario     365382 7415 335550 22417 51.2538 -85.3232 2021-04-04 04:20:49 Ontario, Canada
269895 2021-04-02 Canada Ontario     361147 7391 332821 20935 51.2538 -85.3232 2021-04-03 04:20:44 Ontario, Canada
1173227 2021-04-01 Canada Ontario     359074 7384 331464 20226 51.2538 -85.3232 2021-04-02 04:20:36 Ontario, Canada
515538 2021-03-31 Canada Ontario     356576 7366 329652 19558 51.2538 -85.3232 2021-04-01 04:27:05 Ontario, Canada
289267 2021-03-30 Canada Ontario     351034 7316 325798 1737 51.2538 -85.3232 2021-03-31 04:26:25 Ontario, Canada
1574804 2021-03-29 Canada Ontario     349825 7307 324847 17671 51.2538 -85.3232 2021-03-30 04:26:23 Ontario, Canada
631081 2021-03-28 Canada Ontario     347783 7301 323365 17117 51.2538 -85.3232 2021-03-29 04:28:35 Ontario, Canada
607862 2021-03-27 Canada Ontario     345473 7285 321715 16473 51.2538 -85.3232 2021-03-28 05:28:10 Ontario, Canada
1334005 2021-03-26 Canada Ontario     343137 7274 320127 15736 51.2538 -85.3232 2021-03-27 05:25:04 Ontario, Canada
150444 2021-03-25 Canada Ontario     341032 7260 318486 15286 51.2538 -85.3232 2021-03-26 05:26:55 Ontario, Canada
1597965 2021-03-24 Canada Ontario     338740 7242 317051 14447 51.2538 -85.3232 2021-03-25 05:27:00 Ontario, Canada
403769 2021-03-23 Canada Ontario     337270 7232 315803 14235 51.2538 -85.3232 2021-03-24 05:25:40 Ontario, Canada
1387306 2021-03-22 Canada Ontario     335762 7222 314512 14028 51.2538 -85.3232 2021-03-23 05:26:18 Ontario, Canada
304793 2021-03-21 Canada Ontario     334132 7220 313311 13601 51.2538 -85.3232 2021-03-22 05:25:43 Ontario, Canada
253842 2021-03-20 Canada Ontario     332485 7214 311959 13312 51.2538 -85.3232 2021-03-21 05:25:44 Ontario, Canada
1230598 2021-03-19 Canada Ontario     330691 7199 310659 12833 51.2538 -85.3232 2021-03-20 05:25:46 Ontario, Canada
974523 2021-03-18 Canada Ontario     328926 7188 309112 12626 51.2538 -85.3232 2021-03-19 05:26:09 Ontario, Canada
1532158 2021-03-17 Canada Ontario     327369 7175 307879 12315 51.2538 -85.3232 2021-03-18 05:26:22 Ontario, Canada
55352 2021-03-16 Canada Ontario     325826 7162 306474 12190 51.2538 -85.3232 2021-03-17 05:25:07 Ontario, Canada
562665 2021-03-15 Canada Ontario     324715 7150 305368 12197 51.2538 -85.3232 2021-03-16 05:25:13 Ontario, Canada
851234 2021-03-14 Canada Ontario     323526 7144 304311 12071 51.2538 -85.3232 2021-03-15 05:25:51 Ontario, Canada
942659 2021-03-13 Canada Ontario     322024 7129 303172 11723 51.2538 -85.3232 2021-03-14 05:25:37 Ontario, Canada
1310539 2021-03-12 Canada Ontario     320494 7119 302035 11340 51.2538 -85.3232 2021-03-13 05:25:15 Ontario, Canada
1077377 2021-03-11 Canada Ontario     319084 7104 300835 11145 51.2538 -85.3232 2021-03-12 05:26:50 Ontario, Canada
954589 2021-03-10 Canada Ontario     317905 7093 299822 10990 51.2538 -85.3232 2021-03-11 05:25:48 Ontario, Canada
543422 2021-03-09 Canada Ontario     316751 7080 298684 10987 51.2538 -85.3232 2021-03-10 05:24:35 Ontario, Canada
1520160 2021-03-08 Canada Ontario     315460 7071 297627 10762 51.2538 -85.3232 2021-03-09 05:28:19 Ontario, Canada
866441 2021-03-07 Canada Ontario     313908 7061 296581 10266 51.2538 -85.3232 2021-03-08 05:24:48 Ontario, 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]);