johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,035 rows where country_or_region = "Canada" and province_or_state = "Ontario" sorted by day descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3069786 | 3069786 | 2021-11-23 | Canada | Ontario | 618248 | 9974 | 0 | 51.2538 | -85.3232 | 2021-11-24 04:22:14 | Ontario, Canada | |||
3748884 | 3748884 | 2021-11-22 | Canada | Ontario | 617474 | 9968 | 0 | 51.2538 | -85.3232 | 2021-11-23 04:22:39 | Ontario, Canada | |||
1014091 | 1014091 | 2021-11-21 | Canada | Ontario | 616894 | 9967 | 0 | 51.2538 | -85.3232 | 2021-11-22 04:22:20 | Ontario, Canada | |||
722255 | 722255 | 2021-11-20 | Canada | Ontario | 616283 | 9964 | 0 | 51.2538 | -85.3232 | 2021-11-21 04:22:13 | Ontario, Canada | |||
161785 | 161785 | 2021-11-19 | Canada | Ontario | 615556 | 9959 | 0 | 51.2538 | -85.3232 | 2021-11-20 04:22:17 | Ontario, Canada | |||
3288672 | 3288672 | 2021-11-18 | Canada | Ontario | 614880 | 9955 | 0 | 51.2538 | -85.3232 | 2021-11-19 04:21:40 | Ontario, Canada | |||
447128 | 447128 | 2021-11-17 | Canada | Ontario | 614065 | 9950 | 0 | 51.2538 | -85.3232 | 2021-11-18 04:21:33 | Ontario, Canada | |||
3342378 | 3342378 | 2021-11-16 | Canada | Ontario | 613382 | 9938 | 0 | 51.2538 | -85.3232 | 2021-11-17 04:21:48 | Ontario, Canada | |||
2287214 | 2287214 | 2021-11-15 | Canada | Ontario | 612701 | 9937 | 0 | 51.2538 | -85.3232 | 2021-11-16 04:21:10 | Ontario, Canada | |||
1321988 | 1321988 | 2021-11-14 | Canada | Ontario | 612203 | 9934 | 0 | 51.2538 | -85.3232 | 2021-11-15 04:21:36 | Ontario, Canada | |||
686114 | 686114 | 2021-11-13 | Canada | Ontario | 611711 | 9927 | 0 | 51.2538 | -85.3232 | 2021-11-14 04:21:31 | Ontario, Canada | |||
714223 | 714223 | 2021-11-12 | Canada | Ontario | 611122 | 9921 | 0 | 51.2538 | -85.3232 | 2021-11-13 04:21:38 | Ontario, Canada | |||
28173 | 28173 | 2021-11-11 | Canada | Ontario | 610459 | 9916 | 0 | 51.2538 | -85.3232 | 2021-11-12 04:22:01 | Ontario, Canada | |||
2844612 | 2844612 | 2021-11-10 | Canada | Ontario | 609756 | 9912 | 0 | 51.2538 | -85.3232 | 2021-11-11 04:21:45 | Ontario, Canada | |||
86882 | 86882 | 2021-11-09 | Canada | Ontario | 609151 | 9903 | 0 | 51.2538 | -85.3232 | 2021-11-10 04:21:38 | Ontario, Canada | |||
3639310 | 3639310 | 2021-11-08 | Canada | Ontario | 608572 | 9900 | 0 | 51.2538 | -85.3232 | 2021-11-09 04:21:36 | Ontario, Canada | |||
2000418 | 2000418 | 2021-11-07 | Canada | Ontario | 608147 | 9898 | 0 | 51.2538 | -85.3232 | 2021-11-08 04:21:43 | Ontario, Canada | |||
495409 | 495409 | 2021-11-06 | Canada | Ontario | 607669 | 9896 | 0 | 51.2538 | -85.3232 | 2021-11-07 04:21:53 | Ontario, Canada | |||
3121264 | 3121264 | 2021-11-05 | Canada | Ontario | 607139 | 9896 | 0 | 51.2538 | -85.3232 | 2021-11-06 04:21:51 | Ontario, Canada | |||
698162 | 698162 | 2021-11-04 | Canada | Ontario | 606540 | 9891 | 0 | 51.2538 | -85.3232 | 2021-11-05 04:21:54 | Ontario, Canada | |||
275940 | 275940 | 2021-11-03 | Canada | Ontario | 606011 | 9886 | 0 | 51.2538 | -85.3232 | 2021-11-04 04:22:20 | Ontario, Canada | |||
43465 | 43465 | 2021-11-02 | Canada | Ontario | 605484 | 9881 | 0 | 51.2538 | -85.3232 | 2021-11-03 06:22:09 | Ontario, Canada | |||
3511161 | 3511161 | 2021-11-01 | Canada | Ontario | 605036 | 9874 | 0 | 51.2538 | -85.3232 | 2021-11-02 04:22:03 | Ontario, Canada | |||
287753 | 287753 | 2021-10-31 | Canada | Ontario | 604659 | 9871 | 0 | 51.2538 | -85.3232 | 2021-11-01 04:22:01 | Ontario, Canada | |||
2720759 | 2720759 | 2021-10-30 | Canada | Ontario | 604335 | 9869 | 0 | 51.2538 | -85.3232 | 2021-10-31 04:22:08 | Ontario, Canada | |||
566861 | 566861 | 2021-10-29 | Canada | Ontario | 603928 | 9865 | 0 | 51.2538 | -85.3232 | 2021-10-30 04:22:03 | Ontario, Canada | |||
4103 | 4103 | 2021-10-28 | Canada | Ontario | 603564 | 9865 | 0 | 51.2538 | -85.3232 | 2021-10-29 04:22:03 | Ontario, Canada | |||
534493 | 534493 | 2021-10-27 | Canada | Ontario | 603150 | 9862 | 0 | 51.2538 | -85.3232 | 2021-10-28 04:22:08 | Ontario, Canada | |||
3491930 | 3491930 | 2021-10-26 | Canada | Ontario | 602690 | 9852 | 0 | 51.2538 | -85.3232 | 2021-10-27 04:22:32 | Ontario, Canada | |||
3793652 | 3793652 | 2021-10-25 | Canada | Ontario | 602364 | 9846 | 0 | 51.2538 | -85.3232 | 2021-10-26 04:22:09 | Ontario, Canada | |||
682098 | 682098 | 2021-10-24 | Canada | Ontario | 602057 | 9846 | 0 | 51.2538 | -85.3232 | 2021-10-25 04:22:31 | Ontario, Canada | |||
770106 | 770106 | 2021-10-23 | Canada | Ontario | 601807 | 9845 | 0 | 51.2538 | -85.3232 | 2021-10-24 04:21:22 | Ontario, Canada | |||
653753 | 653753 | 2021-10-22 | Canada | Ontario | 601493 | 9839 | 0 | 51.2538 | -85.3232 | 2021-10-23 04:21:32 | Ontario, Canada | |||
2123500 | 2123500 | 2021-10-21 | Canada | Ontario | 601086 | 9827 | 0 | 51.2538 | -85.3232 | 2021-10-22 04:21:14 | Ontario, Canada | |||
443112 | 443112 | 2021-10-20 | Canada | Ontario | 600691 | 9823 | 0 | 51.2538 | -85.3232 | 2021-10-21 04:21:18 | Ontario, Canada | |||
597431 | 597431 | 2021-10-19 | Canada | Ontario | 600247 | 9819 | 0 | 51.2538 | -85.3232 | 2021-10-20 04:21:00 | Ontario, Canada | |||
2043608 | 2043608 | 2021-10-18 | Canada | Ontario | 599876 | 9815 | 0 | 51.2538 | -85.3232 | 2021-10-19 04:20:54 | Ontario, Canada | |||
1908969 | 1908969 | 2021-10-17 | Canada | Ontario | 599559 | 9813 | 0 | 51.2538 | -85.3232 | 2021-10-18 04:21:10 | Ontario, Canada | |||
934558 | 934558 | 2021-10-16 | Canada | Ontario | 599199 | 9814 | 0 | 51.2538 | -85.3232 | 2021-10-17 04:21:29 | Ontario, Canada | |||
2943113 | 2943113 | 2021-10-15 | Canada | Ontario | 598815 | 9809 | 0 | 51.2538 | -85.3232 | 2021-10-16 04:21:15 | Ontario, Canada | |||
491393 | 491393 | 2021-10-14 | Canada | Ontario | 598319 | 9807 | 0 | 51.2538 | -85.3232 | 2021-10-15 04:21:26 | Ontario, Canada | |||
633681 | 633681 | 2021-10-13 | Canada | Ontario | 597733 | 9804 | 0 | 51.2538 | -85.3232 | 2021-10-14 04:21:29 | Ontario, Canada | |||
1491359 | 1491359 | 2021-10-12 | Canada | Ontario | 597359 | 9792 | 0 | 51.2538 | -85.3232 | 2021-10-13 04:20:51 | Ontario, Canada | |||
3007092 | 3007092 | 2021-10-11 | Canada | Ontario | 596985 | 9792 | 0 | 51.2538 | -85.3232 | 2021-10-12 04:21:09 | Ontario, Canada | |||
423108 | 423108 | 2021-10-10 | Canada | Ontario | 596631 | 9790 | 0 | 51.2538 | -85.3232 | 2021-10-11 04:21:31 | Ontario, Canada | |||
2875965 | 2875965 | 2021-10-09 | Canada | Ontario | 596270 | 9788 | 0 | 51.2538 | -85.3232 | 2021-10-10 04:21:38 | Ontario, Canada | |||
2959131 | 2959131 | 2021-10-08 | Canada | Ontario | 595781 | 9786 | 0 | 51.2538 | -85.3232 | 2021-10-09 04:21:34 | Ontario, Canada | |||
467169 | 467169 | 2021-10-07 | Canada | Ontario | 595233 | 9776 | 0 | 51.2538 | -85.3232 | 2021-10-08 04:21:25 | Ontario, Canada | |||
2458549 | 2458549 | 2021-10-06 | Canada | Ontario | 594580 | 9771 | 0 | 51.2538 | -85.3232 | 2021-10-07 04:21:36 | Ontario, Canada | |||
3832243 | 3832243 | 2021-10-05 | Canada | Ontario | 593994 | 9757 | 0 | 51.2538 | -85.3232 | 2021-10-06 04:21:33 | Ontario, Canada | |||
986736 | 986736 | 2021-10-04 | Canada | Ontario | 593346 | 9754 | 0 | 51.2538 | -85.3232 | 2021-10-05 04:21:27 | Ontario, Canada | |||
1274046 | 1274046 | 2021-10-03 | Canada | Ontario | 592912 | 9752 | 0 | 51.2538 | -85.3232 | 2021-10-04 04:21:31 | Ontario, Canada | |||
3927799 | 3927799 | 2021-10-02 | Canada | Ontario | 592402 | 9750 | 0 | 51.2538 | -85.3232 | 2021-10-03 04:21:24 | Ontario, Canada | |||
2131779 | 2131779 | 2021-10-01 | Canada | Ontario | 591883 | 9743 | 0 | 51.2538 | -85.3232 | 2021-10-02 04:21:25 | Ontario, Canada | |||
2772736 | 2772736 | 2021-09-30 | Canada | Ontario | 591275 | 9732 | 0 | 51.2538 | -85.3232 | 2021-10-01 04:21:35 | Ontario, Canada | |||
706192 | 706192 | 2021-09-29 | Canada | Ontario | 590629 | 9723 | 0 | 51.2538 | -85.3232 | 2021-09-30 04:21:20 | Ontario, Canada | |||
1334034 | 1334034 | 2021-09-28 | Canada | Ontario | 589995 | 9715 | 0 | 51.2538 | -85.3232 | 2021-09-29 04:21:45 | Ontario, Canada | |||
1235403 | 1235403 | 2021-09-27 | Canada | Ontario | 589390 | 9704 | 0 | 51.2538 | -85.3232 | 2021-09-28 04:21:28 | Ontario, Canada | |||
2075704 | 2075704 | 2021-09-26 | Canada | Ontario | 588890 | 9704 | 0 | 51.2538 | -85.3232 | 2021-09-27 04:21:16 | Ontario, Canada | |||
1724256 | 1724256 | 2021-09-25 | Canada | Ontario | 588436 | 9698 | 0 | 51.2538 | -85.3232 | 2021-09-26 04:21:29 | Ontario, Canada | |||
1920976 | 1920976 | 2021-09-24 | Canada | Ontario | 587841 | 9688 | 0 | 51.2538 | -85.3232 | 2021-09-25 04:21:31 | Ontario, Canada | |||
601447 | 601447 | 2021-09-23 | Canada | Ontario | 587186 | 9677 | 0 | 51.2538 | -85.3232 | 2021-09-24 04:21:44 | Ontario, Canada | |||
3011108 | 3011108 | 2021-09-22 | Canada | Ontario | 586528 | 9670 | 0 | 51.2538 | -85.3232 | 2021-09-23 04:21:43 | Ontario, Canada | |||
3757246 | 3757246 | 2021-09-21 | Canada | Ontario | 585809 | 9663 | 0 | 51.2538 | -85.3232 | 2021-09-22 04:21:45 | Ontario, Canada | |||
809349 | 809349 | 2021-09-20 | Canada | Ontario | 585168 | 9655 | 0 | 51.2538 | -85.3232 | 2021-09-21 04:21:26 | Ontario, Canada | |||
1814548 | 1814548 | 2021-09-19 | Canada | Ontario | 584570 | 9653 | 0 | 51.2538 | -85.3232 | 2021-09-20 04:21:22 | Ontario, Canada | |||
16128 | 16128 | 2021-09-18 | Canada | Ontario | 584038 | 9647 | 0 | 51.2538 | -85.3232 | 2021-09-19 04:21:34 | Ontario, Canada | |||
2617813 | 2617813 | 2021-09-17 | Canada | Ontario | 583383 | 9637 | 0 | 51.2538 | -85.3232 | 2021-09-18 04:21:24 | Ontario, Canada | |||
2808521 | 2808521 | 2021-09-16 | Canada | Ontario | 582645 | 9632 | 0 | 51.2538 | -85.3232 | 2021-09-17 04:21:46 | Ontario, Canada | |||
1374266 | 1374266 | 2021-09-15 | Canada | Ontario | 581816 | 9629 | 0 | 51.2538 | -85.3232 | 2021-09-16 04:22:19 | Ontario, Canada | |||
2462565 | 2462565 | 2021-09-14 | Canada | Ontario | 581051 | 9624 | 0 | 51.2538 | -85.3232 | 2021-09-15 03:22:37 | Ontario, Canada | |||
1385404 | 1385404 | 2021-09-13 | Canada | Ontario | 580211 | 9617 | 0 | 51.2538 | -85.3232 | 2021-09-14 04:21:41 | Ontario, Canada | |||
1884773 | 1884773 | 2021-09-12 | Canada | Ontario | 579662 | 9611 | 0 | 51.2538 | -85.3232 | 2021-09-13 04:21:15 | Ontario, Canada | |||
3805676 | 3805676 | 2021-09-11 | Canada | Ontario | 579072 | 9605 | 0 | 51.2538 | -85.3232 | 2021-09-12 04:21:13 | Ontario, Canada | |||
3448616 | 3448616 | 2021-09-10 | Canada | Ontario | 578345 | 9590 | 0 | 51.2538 | -85.3232 | 2021-09-11 04:21:30 | Ontario, Canada | |||
1262562 | 1262562 | 2021-09-09 | Canada | Ontario | 577477 | 9579 | 0 | 51.2538 | -85.3232 | 2021-09-10 04:21:20 | Ontario, Canada | |||
2278932 | 2278932 | 2021-09-08 | Canada | Ontario | 576621 | 9569 | 0 | 51.2538 | -85.3232 | 2021-09-09 04:21:27 | Ontario, Canada | |||
641711 | 641711 | 2021-09-07 | Canada | Ontario | 575776 | 9553 | 0 | 51.2538 | -85.3232 | 2021-09-08 04:21:31 | Ontario, Canada | |||
3193774 | 3193774 | 2021-09-06 | Canada | Ontario | 575074 | 9550 | 0 | 51.2538 | -85.3232 | 2021-09-07 04:21:35 | Ontario, Canada | |||
3280642 | 3280642 | 2021-09-05 | Canada | Ontario | 574516 | 9548 | 0 | 51.2538 | -85.3232 | 2021-09-06 04:21:22 | Ontario, Canada | |||
249056 | 249056 | 2021-09-04 | Canada | Ontario | 573893 | 9545 | 0 | 51.2538 | -85.3232 | 2021-09-05 04:21:33 | Ontario, Canada | |||
3974337 | 3974337 | 2021-09-03 | Canada | Ontario | 573220 | 9536 | 0 | 51.2538 | -85.3232 | 2021-09-04 04:21:28 | Ontario, Canada | |||
177799 | 177799 | 2021-09-02 | Canada | Ontario | 572347 | 9530 | 0 | 51.2538 | -85.3232 | 2021-09-03 04:21:20 | Ontario, Canada | |||
66834 | 66834 | 2021-09-01 | Canada | Ontario | 571454 | 9516 | 0 | 51.2538 | -85.3232 | 2021-09-02 04:21:15 | Ontario, Canada | |||
2067676 | 2067676 | 2021-08-31 | Canada | Ontario | 570654 | 9503 | 0 | 51.2538 | -85.3232 | 2021-09-01 04:21:38 | Ontario, Canada | |||
1775130 | 1775130 | 2021-08-30 | Canada | Ontario | 569840 | 9498 | 0 | 51.2538 | -85.3232 | 2021-08-31 04:21:46 | Ontario, Canada | |||
3891704 | 3891704 | 2021-08-29 | Canada | Ontario | 569205 | 9498 | 0 | 51.2538 | -85.3232 | 2021-08-30 04:21:23 | Ontario, Canada | |||
2792807 | 2792807 | 2021-08-28 | Canada | Ontario | 568608 | 9496 | 0 | 51.2538 | -85.3232 | 2021-08-29 04:21:14 | Ontario, Canada | |||
2922966 | 2922966 | 2021-08-27 | Canada | Ontario | 567896 | 9489 | 0 | 51.2538 | -85.3232 | 2021-08-28 04:21:28 | Ontario, Canada | |||
1595980 | 1595980 | 2021-08-26 | Canada | Ontario | 567116 | 9472 | 0 | 51.2538 | -85.3232 | 2021-08-27 04:21:37 | Ontario, Canada | |||
32189 | 32189 | 2021-08-25 | Canada | Ontario | 566243 | 9472 | 0 | 51.2538 | -85.3232 | 2021-08-26 04:21:28 | Ontario, Canada | |||
3105228 | 3105228 | 2021-08-24 | Canada | Ontario | 565441 | 9471 | 0 | 51.2538 | -85.3232 | 2021-08-25 04:21:41 | Ontario, Canada | |||
3165399 | 3165399 | 2021-08-23 | Canada | Ontario | 564791 | 9453 | 0 | 51.2538 | -85.3232 | 2021-08-24 04:21:19 | Ontario, Canada | |||
2175326 | 2175326 | 2021-08-22 | Canada | Ontario | 564255 | 9453 | 0 | 51.2538 | -85.3232 | 2021-08-23 04:21:27 | Ontario, Canada | |||
3555422 | 3555422 | 2021-08-21 | Canada | Ontario | 563747 | 9451 | 0 | 51.2538 | -85.3232 | 2021-08-22 04:21:29 | Ontario, Canada | |||
1853764 | 1853764 | 2021-08-20 | Canada | Ontario | 563062 | 9450 | 0 | 51.2538 | -85.3232 | 2021-08-21 04:21:38 | Ontario, Canada | |||
511471 | 511471 | 2021-08-19 | Canada | Ontario | 562345 | 9448 | 0 | 51.2538 | -85.3232 | 2021-08-20 04:21:33 | Ontario, Canada | |||
2517950 | 2517950 | 2021-08-18 | Canada | Ontario | 561635 | 9431 | 0 | 51.2538 | -85.3232 | 2021-08-19 04:21:15 | Ontario, Canada | |||
245042 | 245042 | 2021-08-17 | Canada | Ontario | 560970 | 9428 | 0 | 51.2538 | -85.3232 | 2021-08-18 04:21:35 | Ontario, Canada | |||
1604005 | 1604005 | 2021-08-16 | Canada | Ontario | 560446 | 9418 | 0 | 51.2538 | -85.3232 | 2021-08-17 04:21:49 | Ontario, 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]);