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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3101215 | 3101215 | 2021-01-16 | Canada | Ontario | 241478 | 5340 | 207001 | 26704 | 51.2538 | -85.3232 | 2021-01-17 05:22:17 | Ontario, Canada | ||
3515177 | 3515177 | 2021-01-15 | Canada | Ontario | 238798 | 5289 | 203593 | 27232 | 51.2538 | -85.3232 | 2021-01-16 05:22:40 | Ontario, Canada | ||
3879350 | 3879350 | 2021-01-14 | Canada | Ontario | 235627 | 5189 | 200157 | 27699 | 51.2538 | -85.3232 | 2021-01-15 05:22:24 | Ontario, Canada | ||
3307977 | 3307977 | 2021-01-13 | Canada | Ontario | 232659 | 5127 | 196687 | 28020 | 51.2538 | -85.3232 | 2021-01-14 05:22:32 | Ontario, Canada | ||
774122 | 774122 | 2021-01-12 | Canada | Ontario | 229405 | 5053 | 193191 | 28344 | 51.2538 | -85.3232 | 2021-01-13 05:22:15 | Ontario, Canada | ||
189843 | 189843 | 2021-01-11 | Canada | Ontario | 226241 | 5012 | 190042 | 28794 | 51.2538 | -85.3232 | 2021-01-12 05:22:15 | Ontario, Canada | ||
2625646 | 2625646 | 2021-01-10 | Canada | Ontario | 223300 | 4983 | 186984 | 28418 | 51.2538 | -85.3232 | 2021-01-11 05:21:50 | Ontario, Canada | ||
3899734 | 3899734 | 2021-01-09 | Canada | Ontario | 220212 | 4922 | 184417 | 27300 | 51.2538 | -85.3232 | 2021-01-10 05:22:12 | Ontario, Canada | ||
153757 | 153757 | 2021-01-08 | Canada | Ontario | 216887 | 4882 | 181308 | 26745 | 51.2538 | -85.3232 | 2021-01-09 05:22:18 | Ontario, Canada | ||
2541181 | 2541181 | 2021-01-07 | Canada | Ontario | 213121 | 4856 | 178338 | 25482 | 51.2538 | -85.3232 | 2021-01-08 05:22:42 | Ontario, Canada | ||
2864490 | 2864490 | 2021-01-06 | Canada | Ontario | 209023 | 4767 | 175579 | 24904 | 51.2538 | -85.3232 | 2021-01-07 05:22:03 | Ontario, Canada | ||
3034077 | 3034077 | 2021-01-05 | Canada | Ontario | 205222 | 4730 | 172793 | 24543 | 51.2538 | -85.3232 | 2021-01-06 05:22:16 | Ontario, Canada | ||
1061622 | 1061622 | 2021-01-04 | Canada | Ontario | 201866 | 4679 | 170326 | 23901 | 51.2538 | -85.3232 | 2021-01-05 05:21:49 | Ontario, Canada | ||
3230225 | 3230225 | 2021-01-03 | Canada | Ontario | 198656 | 4650 | 168308 | 22396 | 51.2538 | -85.3232 | 2021-01-04 05:22:02 | Ontario, Canada | ||
2227295 | 2227295 | 2021-01-02 | Canada | Ontario | 195341 | 4625 | 164923 | 21495 | 51.2538 | -85.3232 | 2021-01-03 05:22:52 | Ontario, Canada | ||
1136659 | 1136659 | 2021-01-01 | Canada | Ontario | 192482 | 4581 | 162622 | 20154 | 51.2538 | -85.3232 | 2021-01-02 05:22:33 | Ontario, Canada | ||
3695265 | 3695265 | 2020-12-31 | Canada | Ontario | 189176 | 4530 | 161829 | 19970 | 51.2538 | -85.3232 | 2021-01-01 05:23:07 | Ontario, Canada | ||
1010080 | 1010080 | 2020-12-30 | Canada | Ontario | 185786 | 4474 | 159433 | 19172 | 51.2538 | -85.3232 | 2020-12-31 05:22:49 | Ontario, Canada | ||
766095 | 766095 | 2020-12-29 | Canada | Ontario | 182916 | 4455 | 156637 | 18098 | 51.2538 | -85.3232 | 2020-12-30 05:22:34 | Ontario, Canada | ||
3761359 | 3761359 | 2020-12-28 | Canada | Ontario | 179700 | 4414 | 154392 | 17998 | 51.2538 | -85.3232 | 2020-12-29 05:22:37 | Ontario, Canada | ||
3777679 | 3777679 | 2020-12-27 | Canada | Ontario | 176872 | 4377 | 151106 | 18207 | 51.2538 | -85.3232 | 2020-12-28 05:22:06 | Ontario, Canada | ||
2223284 | 2223284 | 2020-12-26 | Canada | Ontario | 174669 | 4359 | 149532 | 18033 | 51.2538 | -85.3232 | 2020-12-27 05:22:55 | Ontario, Canada | ||
202031 | 202031 | 2020-12-25 | Canada | Ontario | 172427 | 4321 | 147699 | 17691 | 51.2538 | -85.3232 | 2020-12-26 05:22:28 | Ontario, Canada | ||
3691254 | 3691254 | 2020-12-24 | Canada | Ontario | 170222 | 4278 | 146991 | 17843 | 51.2538 | -85.3232 | 2020-12-25 05:22:48 | Ontario, Canada | ||
2406606 | 2406606 | 2020-12-23 | Canada | Ontario | 168266 | 4229 | 144711 | 17843 | 51.2538 | -85.3232 | 2020-12-24 05:23:04 | Ontario, Canada | ||
3769652 | 3769652 | 2020-12-22 | Canada | Ontario | 165990 | 4188 | 142651 | 17460 | 51.2538 | -85.3232 | 2020-12-23 05:22:03 | Ontario, Canada | ||
927468 | 927468 | 2020-12-21 | Canada | Ontario | 163432 | 4167 | 140616 | 17255 | 51.2538 | -85.3232 | 2020-12-22 05:22:33 | Ontario, Canada | ||
2119489 | 2119489 | 2020-12-20 | Canada | Ontario | 161199 | 4150 | 138678 | 17026 | 51.2538 | -85.3232 | 2020-12-21 05:27:58 | Ontario, Canada | ||
2930996 | 2930996 | 2020-12-19 | Canada | Ontario | 158836 | 4125 | 136785 | 16823 | 51.2538 | -85.3232 | 2020-12-20 05:27:32 | Ontario, Canada | ||
1900942 | 1900942 | 2020-12-18 | Canada | Ontario | 156570 | 4098 | 134781 | 16287 | 51.2538 | -85.3232 | 2020-12-19 05:27:52 | Ontario, Canada | ||
2127768 | 2127768 | 2020-12-17 | Canada | Ontario | 154138 | 4058 | 132667 | 16150 | 51.2538 | -85.3232 | 2020-12-18 05:28:18 | Ontario, Canada | ||
3149368 | 3149368 | 2020-12-16 | Canada | Ontario | 151790 | 4035 | 130674 | 15744 | 51.2538 | -85.3232 | 2020-12-17 05:28:12 | Ontario, Canada | ||
1034149 | 1034149 | 2020-12-15 | Canada | Ontario | 149470 | 3992 | 128820 | 15396 | 51.2538 | -85.3232 | 2020-12-16 05:28:04 | Ontario, Canada | ||
1751043 | 1751043 | 2020-12-14 | Canada | Ontario | 147243 | 3972 | 127104 | 14975 | 51.2538 | -85.3232 | 2020-12-15 05:26:38 | Ontario, Canada | ||
3847563 | 3847563 | 2020-12-13 | Canada | Ontario | 145149 | 3949 | 125415 | 14490 | 51.2538 | -85.3232 | 2020-12-14 05:26:27 | Ontario, Canada | ||
845345 | 845345 | 2020-12-12 | Canada | Ontario | 143139 | 3933 | 123761 | 14461 | 51.2538 | -85.3232 | 2020-12-13 05:27:20 | Ontario, Canada | ||
860452 | 860452 | 2020-12-11 | Canada | Ontario | 141192 | 3916 | 121956 | 14433 | 51.2538 | -85.3232 | 2020-12-12 05:26:19 | Ontario, Canada | ||
1599994 | 1599994 | 2020-12-10 | Canada | Ontario | 139295 | 3871 | 119951 | 14687 | 51.2538 | -85.3232 | 2020-12-11 05:26:59 | Ontario, Canada | ||
2975003 | 2975003 | 2020-12-09 | Canada | Ontario | 137405 | 3836 | 118253 | 14485 | 51.2538 | -85.3232 | 2020-12-10 05:26:19 | Ontario, Canada | ||
1818563 | 1818563 | 2020-12-08 | Canada | Ontario | 135464 | 3808 | 116368 | 14410 | 51.2538 | -85.3232 | 2020-12-09 05:28:01 | Ontario, Canada | ||
2347199 | 2347199 | 2020-12-07 | Canada | Ontario | 133600 | 3798 | 114682 | 14238 | 51.2538 | -85.3232 | 2020-12-08 05:27:42 | Ontario, Canada | ||
1006069 | 1006069 | 2020-12-06 | Canada | Ontario | 131784 | 3772 | 113214 | 13954 | 51.2538 | -85.3232 | 2020-12-07 05:26:14 | Ontario, Canada | ||
1632078 | 1632078 | 2020-12-05 | Canada | Ontario | 130038 | 3757 | 111197 | 14026 | 51.2538 | -85.3232 | 2020-12-06 05:26:18 | Ontario, Canada | ||
3859606 | 3859606 | 2020-12-04 | Canada | Ontario | 127954 | 3737 | 109483 | 13888 | 51.2538 | -85.3232 | 2020-12-05 05:27:36 | Ontario, Canada | ||
74864 | 74864 | 2020-12-03 | Canada | Ontario | 126074 | 3712 | 107858 | 13648 | 51.2538 | -85.3232 | 2020-12-04 05:27:27 | Ontario, Canada | ||
738076 | 738076 | 2020-12-02 | Canada | Ontario | 124247 | 3698 | 106328 | 13597 | 51.2538 | -85.3232 | 2020-12-03 05:28:22 | Ontario, Canada | ||
2537170 | 2537170 | 2020-12-01 | Canada | Ontario | 122495 | 3663 | 104668 | 13422 | 51.2538 | -85.3232 | 2020-12-02 05:27:41 | Ontario, Canada | ||
1583939 | 1583939 | 2020-11-30 | Canada | Ontario | 120657 | 3656 | 103249 | 12976 | 51.2538 | -85.3232 | 2020-12-01 05:26:18 | Ontario, Canada | ||
3566342 | 3566342 | 2020-11-29 | Canada | Ontario | 119031 | 3648 | 102012 | 12477 | 51.2538 | -85.3232 | 2020-11-30 05:26:13 | Ontario, Canada | ||
2935007 | 2935007 | 2020-11-28 | Canada | Ontario | 117325 | 3624 | 100650 | 12227 | 51.2538 | -85.3232 | 2020-11-29 05:25:55 | Ontario, Canada | ||
392010 | 392010 | 2020-11-27 | Canada | Ontario | 115613 | 3595 | 99074 | 12059 | 51.2538 | -85.3232 | 2020-11-28 05:25:50 | Ontario, Canada | ||
923457 | 923457 | 2020-11-26 | Canada | Ontario | 113860 | 3575 | 97645 | 11660 | 51.2538 | -85.3232 | 2020-11-27 05:26:53 | Ontario, Canada | ||
1972362 | 1972362 | 2020-11-25 | Canada | Ontario | 112026 | 3554 | 96188 | 11612 | 51.2538 | -85.3232 | 2020-11-26 05:27:44 | Ontario, Canada | ||
1350093 | 1350093 | 2020-11-24 | Canada | Ontario | 110312 | 3519 | 94861 | 11629 | 51.2538 | -85.3232 | 2020-11-25 05:27:20 | Ontario, Canada | ||
678088 | 678088 | 2020-11-23 | Canada | Ontario | 108882 | 3505 | 93475 | 11649 | 51.2538 | -85.3232 | 2020-11-24 05:27:31 | Ontario, Canada | ||
3189764 | 3189764 | 2020-11-22 | Canada | Ontario | 107488 | 3486 | 92054 | 11761 | 51.2538 | -85.3232 | 2020-11-23 05:25:26 | Ontario, Canada | ||
3836258 | 3836258 | 2020-11-21 | Canada | Ontario | 106165 | 3472 | 90707 | 11633 | 51.2538 | -85.3232 | 2020-11-22 05:25:45 | Ontario, Canada | ||
2701286 | 2701286 | 2020-11-20 | Canada | Ontario | 104667 | 3451 | 89280 | 11526 | 51.2538 | -85.3232 | 2020-11-21 05:25:51 | Ontario, Canada | ||
821346 | 821346 | 2020-11-19 | Canada | Ontario | 103029 | 3443 | 87814 | 11562 | 51.2538 | -85.3232 | 2020-11-20 05:26:28 | Ontario, Canada | ||
122480 | 122480 | 2020-11-18 | Canada | Ontario | 101550 | 3415 | 86366 | 11676 | 51.2538 | -85.3232 | 2020-11-19 05:25:23 | Ontario, Canada | ||
3338368 | 3338368 | 2020-11-17 | Canada | Ontario | 100085 | 3383 | 84843 | 11939 | 51.2538 | -85.3232 | 2020-11-18 05:40:31 | Ontario, Canada | ||
3169413 | 3169413 | 2020-11-16 | Canada | Ontario | 98832 | 3371 | 83427 | 11933 | 51.2538 | -85.3232 | 2020-11-17 05:25:54 | Ontario, Canada | ||
2879981 | 2879981 | 2020-11-15 | Canada | Ontario | 97447 | 3361 | 82137 | 11826 | 51.2538 | -85.3232 | 2020-11-16 05:25:57 | Ontario, Canada | ||
2914959 | 2914959 | 2020-11-14 | Canada | Ontario | 96138 | 3332 | 80980 | 11597 | 51.2538 | -85.3232 | 2020-11-15 05:26:53 | Ontario, Canada | ||
2784781 | 2784781 | 2020-11-13 | Canada | Ontario | 94680 | 3312 | 79780 | 11422 | 51.2538 | -85.3232 | 2020-11-14 05:25:37 | Ontario, Canada | ||
864546 | 864546 | 2020-11-12 | Canada | Ontario | 93235 | 3293 | 78675 | 11118 | 51.2538 | -85.3232 | 2020-11-13 05:25:30 | Ontario, Canada | ||
3440591 | 3440591 | 2020-11-11 | Canada | Ontario | 91653 | 3275 | 77812 | 10464 | 51.2538 | -85.3232 | 2020-11-12 05:25:55 | Ontario, Canada | ||
271931 | 271931 | 2020-11-10 | Canada | Ontario | 90143 | 3260 | 76932 | 9975 | 51.2538 | -85.3232 | 2020-11-11 05:25:30 | Ontario, Canada | ||
1988408 | 1988408 | 2020-11-09 | Canada | Ontario | 88559 | 3245 | 75877 | 9519 | 51.2538 | -85.3232 | 2020-11-10 05:40:07 | Ontario, Canada | ||
1728260 | 1728260 | 2020-11-08 | Canada | Ontario | 87086 | 3233 | 74991 | 8929 | 51.2538 | -85.3232 | 2020-11-09 05:25:45 | Ontario, Canada | ||
1543720 | 1543720 | 2020-11-07 | Canada | Ontario | 85770 | 3220 | 74084 | 8631 | 51.2538 | -85.3232 | 2020-11-08 05:24:56 | Ontario, Canada | ||
375958 | 375958 | 2020-11-06 | Canada | Ontario | 84658 | 3209 | 73192 | 8302 | 51.2538 | -85.3232 | 2020-11-07 05:24:52 | Ontario, Canada | ||
891896 | 891896 | 2020-11-05 | Canada | Ontario | 83380 | 3195 | 71476 | 8113 | 51.2538 | -85.3232 | 2020-11-06 05:24:55 | Ontario, Canada | ||
2918958 | 2918958 | 2020-11-04 | Canada | Ontario | 82110 | 3182 | 71274 | 8178 | 51.2538 | -85.3232 | 2020-11-05 06:05:03 | Ontario, Canada | ||
2497795 | 2497795 | 2020-11-03 | Canada | Ontario | 81167 | 3166 | 70345 | 8121 | 51.2538 | -85.3232 | 2020-11-04 05:25:09 | Ontario, Canada | ||
3303970 | 3303970 | 2020-11-02 | Canada | Ontario | 80261 | 3152 | 69403 | 7962 | 51.2538 | -85.3232 | 2020-11-03 06:00:16 | Ontario, Canada | ||
3409219 | 3409219 | 2020-11-01 | Canada | Ontario | 79290 | 3145 | 68562 | 7758 | 51.2538 | -85.3232 | 2020-11-02 05:25:04 | Ontario, Canada | ||
2079708 | 2079708 | 2020-10-31 | Canada | Ontario | 78185 | 3136 | 67735 | 7611 | 51.2538 | -85.3232 | 2020-11-01 04:36:19 | Ontario, Canada | ||
2243161 | 2243161 | 2020-10-30 | Canada | Ontario | 77279 | 3127 | 66859 | 7617 | 51.2538 | -85.3232 | 2020-10-31 04:24:44 | Ontario, Canada | ||
210016 | 210016 | 2020-10-29 | Canada | Ontario | 76258 | 3118 | 65964 | 7526 | 51.2538 | -85.3232 | 2020-10-30 04:24:49 | Ontario, Canada | ||
754078 | 754078 | 2020-10-28 | Canada | Ontario | 75358 | 3108 | 65105 | 7401 | 51.2538 | -85.3232 | 2020-10-29 04:24:49 | Ontario, Canada | ||
1452363 | 1452363 | 2020-10-27 | Canada | Ontario | 74409 | 3103 | 64363 | 7351 | 51.2538 | -85.3232 | 2020-10-28 04:24:39 | Ontario, Canada | ||
3480087 | 3480087 | 2020-10-26 | Canada | Ontario | 73514 | 3099 | 63583 | 7250 | 51.2538 | -85.3232 | 2020-10-27 04:24:45 | Ontario, Canada | ||
8108 | 8108 | 2020-10-25 | Canada | Ontario | 72723 | 3093 | 62882 | 7120 | 51.2538 | -85.3232 | 2020-10-26 04:25:02 | Ontario, Canada | ||
3651345 | 3651345 | 2020-10-24 | Canada | Ontario | 71842 | 3086 | 61719 | 6572 | 51.2538 | -85.3232 | 2020-10-25 04:24:36 | Ontario, Canada | ||
1053600 | 1053600 | 2020-10-23 | Canada | Ontario | 70906 | 3080 | 61503 | 6506 | 51.2538 | -85.3232 | 2020-10-24 04:24:46 | Ontario, Canada | ||
1177270 | 1177270 | 2020-10-22 | Canada | Ontario | 69964 | 3071 | 60742 | 6404 | 51.2538 | -85.3232 | 2020-10-23 04:24:46 | Ontario, Canada | ||
2191375 | 2191375 | 2020-10-21 | Canada | Ontario | 68988 | 3062 | 60043 | 6204 | 51.2538 | -85.3232 | 2020-10-22 04:24:27 | Ontario, Canada | ||
3990386 | 3990386 | 2020-10-20 | Canada | Ontario | 68120 | 3053 | 59335 | 6114 | 51.2538 | -85.3232 | 2020-10-21 04:24:14 | Ontario, Canada | ||
1794406 | 1794406 | 2020-10-19 | Canada | Ontario | 67324 | 3050 | 58671 | 5975 | 51.2538 | -85.3232 | 2020-10-20 04:24:22 | Ontario, Canada | ||
762090 | 762090 | 2020-10-18 | Canada | Ontario | 66576 | 3046 | 57972 | 5954 | 51.2538 | -85.3232 | 2020-10-19 04:24:16 | Ontario, Canada | ||
1026128 | 1026128 | 2020-10-17 | Canada | Ontario | 65785 | 3041 | 56766 | 6013 | 51.2538 | -85.3232 | 2020-10-18 04:24:25 | Ontario, Canada | ||
2856623 | 2856623 | 2020-10-16 | Canada | Ontario | 65095 | 3031 | 56635 | 6006 | 51.2538 | -85.3232 | 2020-10-17 04:24:12 | Ontario, Canada | ||
786153 | 786153 | 2020-10-15 | Canada | Ontario | 64396 | 3022 | 55921 | 5827 | 51.2538 | -85.3232 | 2020-10-16 04:24:01 | Ontario, Canada | ||
78864 | 78864 | 2020-10-14 | Canada | Ontario | 63645 | 3017 | 55191 | 5830 | 51.2538 | -85.3232 | 2020-10-15 04:24:28 | Ontario, Canada | ||
3781679 | 3781679 | 2020-10-13 | Canada | Ontario | 62783 | 3017 | 54432 | 5799 | 51.2538 | -85.3232 | 2020-10-14 04:24:05 | Ontario, Canada | ||
2291219 | 2291219 | 2020-10-12 | Canada | Ontario | 61936 | 3008 | 53087 | 5535 | 51.2538 | -85.3232 | 2020-10-13 04:24:02 | Ontario, Canada | ||
3785672 | 3785672 | 2020-10-11 | Canada | Ontario | 61339 | 3005 | 53087 | 5535 | 51.2538 | -85.3232 | 2020-10-12 04:23:45 | Ontario, Canada | ||
2601810 | 2601810 | 2020-10-10 | Canada | Ontario | 60616 | 3004 | 52200 | 5823 | 51.2538 | -85.3232 | 2020-10-11 04:23:46 | Ontario, Canada | ||
817343 | 817343 | 2020-10-09 | Canada | Ontario | 59928 | 2997 | 51522 | 5619 | 51.2538 | -85.3232 | 2020-10-10 04:23:57 | 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]);