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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3667395 | 3667395 | 2021-03-06 | Canada | Ontario | 311945 | 7052 | 295552 | 9843 | 51.2538 | -85.3232 | 2021-03-07 05:21:54 | Ontario, Canada | ||
1616016 | 1616016 | 2021-03-05 | Canada | Ontario | 310622 | 7046 | 294011 | 9956 | 51.2538 | -85.3232 | 2021-03-06 04:23:41 | Ontario, Canada | ||
2207427 | 2207427 | 2021-03-04 | Canada | Ontario | 309330 | 7024 | 293154 | 9987 | 51.2538 | -85.3232 | 2021-03-05 05:26:29 | Ontario, Canada | ||
1089848 | 1089848 | 2021-03-03 | Canada | Ontario | 308080 | 7014 | 292098 | 9910 | 51.2538 | -85.3232 | 2021-03-04 05:24:24 | Ontario, Canada | ||
3253920 | 3253920 | 2021-03-02 | Canada | Ontario | 306937 | 6997 | 290966 | 10128 | 51.2538 | -85.3232 | 2021-03-03 05:23:28 | Ontario, Canada | ||
998212 | 998212 | 2021-03-01 | Canada | Ontario | 305806 | 6986 | 289928 | 10262 | 51.2538 | -85.3232 | 2021-03-02 05:23:30 | Ontario, Canada | ||
2367270 | 2367270 | 2021-02-28 | Canada | Ontario | 304842 | 6980 | 288968 | 10109 | 51.2538 | -85.3232 | 2021-03-01 05:23:01 | Ontario, Canada | ||
3065772 | 3065772 | 2021-02-27 | Canada | Ontario | 303795 | 6960 | 287897 | 10105 | 51.2538 | -85.3232 | 2021-02-28 05:22:20 | Ontario, Canada | ||
2183356 | 2183356 | 2021-02-26 | Canada | Ontario | 302676 | 6944 | 286831 | 10040 | 51.2538 | -85.3232 | 2021-02-27 05:22:28 | Ontario, Canada | ||
1857778 | 1857778 | 2021-02-25 | Canada | Ontario | 301546 | 6916 | 285840 | 9815 | 51.2538 | -85.3232 | 2021-02-26 05:22:40 | Ontario, Canada | ||
279956 | 279956 | 2021-02-24 | Canada | Ontario | 300300 | 6893 | 284735 | 9749 | 51.2538 | -85.3232 | 2021-02-25 05:24:57 | Ontario, Canada | ||
1936224 | 1936224 | 2021-02-23 | Canada | Ontario | 299091 | 6884 | 283519 | 9832 | 51.2538 | -85.3232 | 2021-02-24 05:29:16 | Ontario, Canada | ||
530479 | 530479 | 2021-02-22 | Canada | Ontario | 297938 | 6872 | 281968 | 9960 | 51.2538 | -85.3232 | 2021-02-23 05:23:41 | Ontario, Canada | ||
181813 | 181813 | 2021-02-21 | Canada | Ontario | 297001 | 6861 | 281363 | 9930 | 51.2538 | -85.3232 | 2021-02-22 05:24:21 | Ontario, Canada | ||
742087 | 742087 | 2021-02-20 | Canada | Ontario | 296007 | 6848 | 280307 | 9856 | 51.2538 | -85.3232 | 2021-02-21 05:24:33 | Ontario, Canada | ||
471185 | 471185 | 2021-02-19 | Canada | Ontario | 294870 | 6820 | 279070 | 9947 | 51.2538 | -85.3232 | 2021-02-20 05:22:51 | Ontario, Canada | ||
1152895 | 1152895 | 2021-02-18 | Canada | Ontario | 293642 | 6773 | 277825 | 10089 | 51.2538 | -85.3232 | 2021-02-19 05:24:16 | Ontario, Canada | ||
3600815 | 3600815 | 2021-02-17 | Canada | Ontario | 292428 | 6729 | 276598 | 10208 | 51.2538 | -85.3232 | 2021-02-18 05:22:58 | Ontario, Canada | ||
3049950 | 3049950 | 2021-02-16 | Canada | Ontario | 291307 | 6719 | 275337 | 10682 | 51.2538 | -85.3232 | 2021-02-17 05:23:10 | Ontario, Canada | ||
1338049 | 1338049 | 2021-02-15 | Canada | Ontario | 290299 | 6706 | 271886 | 12886 | 51.2538 | -85.3232 | 2021-02-16 05:24:38 | Ontario, Canada | ||
2283200 | 2283200 | 2021-02-14 | Canada | Ontario | 289406 | 6693 | 270560 | 13457 | 51.2538 | -85.3232 | 2021-02-15 05:24:49 | Ontario, Canada | ||
2677600 | 2677600 | 2021-02-13 | Canada | Ontario | 288460 | 6651 | 270560 | 12704 | 51.2538 | -85.3232 | 2021-02-14 05:23:43 | Ontario, Canada | ||
3539233 | 3539233 | 2021-02-12 | Canada | Ontario | 287469 | 6632 | 269411 | 11825 | 51.2538 | -85.3232 | 2021-02-13 05:22:12 | Ontario, Canada | ||
2637496 | 2637496 | 2021-02-11 | Canada | Ontario | 286264 | 6614 | 268677 | 11971 | 51.2538 | -85.3232 | 2021-02-12 05:23:29 | Ontario, Canada | ||
3978351 | 3978351 | 2021-02-10 | Canada | Ontario | 285018 | 6596 | 267422 | 12301 | 51.2538 | -85.3232 | 2021-02-11 05:23:55 | Ontario, Canada | ||
1527671 | 1527671 | 2021-02-09 | Canada | Ontario | 283695 | 6555 | 265853 | 12754 | 51.2538 | -85.3232 | 2021-02-10 05:22:41 | Ontario, Canada | ||
613462 | 613462 | 2021-02-08 | Canada | Ontario | 282546 | 6538 | 263870 | 13736 | 51.2538 | -85.3232 | 2021-02-09 05:23:30 | Ontario, Canada | ||
1672231 | 1672231 | 2021-02-07 | Canada | Ontario | 281559 | 6505 | 250808 | 25627 | 51.2538 | -85.3232 | 2021-02-08 05:22:39 | Ontario, Canada | ||
974692 | 974692 | 2021-02-06 | Canada | Ontario | 280451 | 6483 | 249676 | 25283 | 51.2538 | -85.3232 | 2021-02-07 05:23:00 | Ontario, Canada | ||
1587950 | 1587950 | 2021-02-05 | Canada | Ontario | 279235 | 6438 | 248518 | 25135 | 51.2538 | -85.3232 | 2021-02-06 05:23:55 | Ontario, Canada | ||
790157 | 790157 | 2021-02-04 | Canada | Ontario | 277741 | 6393 | 255181 | 16758 | 51.2538 | -85.3232 | 2021-02-05 05:22:38 | Ontario, Canada | ||
340049 | 340049 | 2021-02-03 | Canada | Ontario | 276319 | 6305 | 254148 | 16384 | 51.2538 | -85.3232 | 2021-02-04 05:22:26 | Ontario, Canada | ||
1684275 | 1684275 | 2021-02-02 | Canada | Ontario | 274810 | 6238 | 252606 | 16766 | 51.2538 | -85.3232 | 2021-02-03 05:22:52 | Ontario, Canada | ||
1676245 | 1676245 | 2021-02-01 | Canada | Ontario | 273377 | 6224 | 251289 | 17252 | 51.2538 | -85.3232 | 2021-02-02 05:22:49 | Ontario, Canada | ||
1459533 | 1459533 | 2021-01-31 | Canada | Ontario | 272098 | 6188 | 249149 | 17572 | 51.2538 | -85.3232 | 2021-02-01 05:22:53 | Ontario, Canada | ||
2211441 | 2211441 | 2021-01-30 | Canada | Ontario | 270626 | 6145 | 246937 | 17963 | 51.2538 | -85.3232 | 2021-01-31 05:22:42 | Ontario, Canada | ||
1896928 | 1896928 | 2021-01-29 | Canada | Ontario | 268981 | 6072 | 244347 | 18700 | 51.2538 | -85.3232 | 2021-01-30 05:22:49 | Ontario, Canada | ||
2481744 | 2481744 | 2021-01-28 | Canada | Ontario | 267133 | 6014 | 241681 | 19467 | 51.2538 | -85.3232 | 2021-01-29 05:22:23 | Ontario, Canada | ||
3153379 | 3153379 | 2021-01-27 | Canada | Ontario | 265191 | 5958 | 239163 | 20009 | 51.2538 | -85.3232 | 2021-01-28 05:22:24 | Ontario, Canada | ||
12114 | 12114 | 2021-01-26 | Canada | Ontario | 263219 | 5909 | 236503 | 20940 | 51.2538 | -85.3232 | 2021-01-27 05:23:41 | Ontario, Canada | ||
2567438 | 2567438 | 2021-01-25 | Canada | Ontario | 261311 | 5846 | 233798 | 21942 | 51.2538 | -85.3232 | 2021-01-26 05:22:02 | Ontario, Canada | ||
1759070 | 1759070 | 2021-01-24 | Canada | Ontario | 259644 | 5803 | 231354 | 22482 | 51.2538 | -85.3232 | 2021-01-25 05:22:16 | Ontario, Canada | ||
2426677 | 2426677 | 2021-01-23 | Canada | Ontario | 257847 | 5753 | 228722 | 22917 | 51.2538 | -85.3232 | 2021-01-24 05:22:35 | Ontario, Canada | ||
2466579 | 2466579 | 2021-01-22 | Canada | Ontario | 255955 | 5701 | 225605 | 23745 | 51.2538 | -85.3232 | 2021-01-23 05:22:03 | Ontario, Canada | ||
435130 | 435130 | 2021-01-21 | Canada | Ontario | 253485 | 5614 | 222391 | 24519 | 51.2538 | -85.3232 | 2021-01-22 05:22:10 | Ontario, Canada | ||
1093862 | 1093862 | 2021-01-20 | Canada | Ontario | 251137 | 5568 | 219231 | 24935 | 51.2538 | -85.3232 | 2021-01-21 05:22:01 | Ontario, Canada | ||
907952 | 907952 | 2021-01-19 | Canada | Ontario | 248463 | 5479 | 215872 | 25771 | 51.2538 | -85.3232 | 2021-01-20 05:21:54 | Ontario, Canada | ||
237015 | 237015 | 2021-01-18 | Canada | Ontario | 246044 | 5433 | 212811 | 26630 | 51.2538 | -85.3232 | 2021-01-19 05:22:15 | Ontario, Canada | ||
3503132 | 3503132 | 2021-01-17 | Canada | Ontario | 243580 | 5409 | 210004 | 26917 | 51.2538 | -85.3232 | 2021-01-18 05:22:34 | Ontario, Canada | ||
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 |
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]);