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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2450545 | 2450545 | 2021-05-02 | Canada | Ontario | 480173 | 8102 | 436048 | 32988 | 51.2538 | -85.3232 | 2021-05-03 04:20:39 | Ontario, Canada | ||
2824558 | 2824558 | 2021-05-01 | Canada | Ontario | 477228 | 8079 | 433460 | 33056 | 51.2538 | -85.3232 | 2021-05-02 04:20:48 | Ontario, Canada | ||
379966 | 379966 | 2021-04-30 | Canada | Ontario | 473522 | 8050 | 430586 | 33655 | 51.2538 | -85.3232 | 2021-05-01 04:20:47 | Ontario, Canada | ||
1636089 | 1636089 | 2021-04-29 | Canada | Ontario | 470141 | 8029 | 426425 | 34031 | 51.2538 | -85.3232 | 2021-04-30 04:21:03 | Ontario, Canada | ||
3393168 | 3393168 | 2021-04-28 | Canada | Ontario | 466331 | 7988 | 420930 | 34852 | 51.2538 | -85.3232 | 2021-04-29 04:20:55 | Ontario, Canada | ||
3701884 | 3701884 | 2021-04-27 | Canada | Ontario | 462304 | 7964 | 416751 | 35075 | 51.2538 | -85.3232 | 2021-04-28 04:20:32 | Ontario, Canada | ||
887893 | 887893 | 2021-04-26 | Canada | Ontario | 458793 | 7935 | 412639 | 36179 | 51.2538 | -85.3232 | 2021-04-27 04:20:52 | Ontario, Canada | ||
954638 | 954638 | 2021-04-25 | Canada | Ontario | 455647 | 7911 | 408512 | 36914 | 51.2538 | -85.3232 | 2021-04-26 04:21:04 | Ontario, Canada | ||
3923785 | 3923785 | 2021-04-24 | Canada | Ontario | 451958 | 7887 | 404392 | 37167 | 51.2538 | -85.3232 | 2021-04-25 04:20:32 | Ontario, Canada | ||
1408816 | 1408816 | 2021-04-23 | Canada | Ontario | 448191 | 7863 | 400089 | 37455 | 51.2538 | -85.3232 | 2021-04-24 04:20:38 | Ontario, Canada | ||
1567879 | 1567879 | 2021-04-22 | Canada | Ontario | 444076 | 7829 | 395406 | 37824 | 51.2538 | -85.3232 | 2021-04-23 04:20:52 | Ontario, Canada | ||
3242100 | 3242100 | 2021-04-21 | Canada | Ontario | 439588 | 7789 | 390833 | 38071 | 51.2538 | -85.3232 | 2021-04-22 04:20:53 | Ontario, Canada | ||
2020496 | 2020496 | 2021-04-20 | Canada | Ontario | 435563 | 7757 | 384917 | 39992 | 51.2538 | -85.3232 | 2021-04-21 04:21:14 | Ontario, Canada | ||
2410617 | 2410617 | 2021-04-19 | Canada | Ontario | 431548 | 7735 | 381260 | 40245 | 51.2538 | -85.3232 | 2021-04-20 04:20:41 | Ontario, Canada | ||
3129294 | 3129294 | 2021-04-18 | Canada | Ontario | 427877 | 7716 | 377777 | 39361 | 51.2538 | -85.3232 | 2021-04-19 04:20:57 | Ontario, Canada | ||
982722 | 982722 | 2021-04-17 | Canada | Ontario | 423702 | 7698 | 374315 | 38228 | 51.2538 | -85.3232 | 2021-04-18 04:20:41 | Ontario, Canada | ||
169817 | 169817 | 2021-04-16 | Canada | Ontario | 419104 | 7664 | 370341 | 38136 | 51.2538 | -85.3232 | 2021-04-17 04:20:40 | Ontario, Canada | ||
2548648 | 2548648 | 2021-04-15 | Canada | Ontario | 415298 | 7639 | 366873 | 36834 | 51.2538 | -85.3232 | 2021-04-16 04:20:46 | Ontario, Canada | ||
1841718 | 1841718 | 2021-04-14 | Canada | Ontario | 410541 | 7610 | 363632 | 35321 | 51.2538 | -85.3232 | 2021-04-15 04:20:54 | Ontario, Canada | ||
2571452 | 2571452 | 2021-04-13 | Canada | Ontario | 405575 | 7582 | 360560 | 33861 | 51.2538 | -85.3232 | 2021-04-14 04:20:41 | Ontario, Canada | ||
36203 | 36203 | 2021-04-12 | Canada | Ontario | 401303 | 7567 | 357678 | 33216 | 51.2538 | -85.3232 | 2021-04-13 04:20:37 | Ontario, Canada | ||
3883362 | 3883362 | 2021-04-11 | Canada | Ontario | 397211 | 7552 | 354981 | 31664 | 51.2538 | -85.3232 | 2021-04-12 04:21:00 | Ontario, Canada | ||
2983030 | 2983030 | 2021-04-10 | Canada | Ontario | 393147 | 7531 | 352338 | 29779 | 51.2538 | -85.3232 | 2021-04-11 04:20:56 | Ontario, Canada | ||
605462 | 605462 | 2021-04-09 | Canada | Ontario | 388509 | 7512 | 349619 | 28473 | 51.2538 | -85.3232 | 2021-04-10 04:20:59 | Ontario, Canada | ||
2645526 | 2645526 | 2021-04-08 | Canada | Ontario | 384512 | 7494 | 346827 | 27228 | 51.2538 | -85.3232 | 2021-04-09 04:21:13 | Ontario, Canada | ||
2247168 | 2247168 | 2021-04-07 | Canada | Ontario | 380448 | 7475 | 344222 | 26302 | 51.2538 | -85.3232 | 2021-04-08 04:21:13 | Ontario, Canada | ||
3003078 | 3003078 | 2021-04-06 | Canada | Ontario | 376595 | 7458 | 341652 | 25434 | 51.2538 | -85.3232 | 2021-04-07 04:20:53 | Ontario, Canada | ||
3085073 | 3085073 | 2021-04-05 | Canada | Ontario | 373055 | 7450 | 339479 | 24388 | 51.2538 | -85.3232 | 2021-04-06 04:20:32 | Ontario, Canada | ||
387996 | 387996 | 2021-04-04 | Canada | Ontario | 370012 | 7440 | 337043 | 23018 | 51.2538 | -85.3232 | 2021-04-05 04:20:35 | Ontario, Canada | ||
3709912 | 3709912 | 2021-04-03 | Canada | Ontario | 367006 | 7428 | 335550 | 22404 | 51.2538 | -85.3232 | 2021-04-04 04:20:49 | Ontario, Canada | ||
241028 | 241028 | 2021-04-02 | Canada | Ontario | 363905 | 7412 | 332821 | 20914 | 51.2538 | -85.3232 | 2021-04-03 04:20:44 | Ontario, Canada | ||
1301825 | 1301825 | 2021-04-01 | Canada | Ontario | 360846 | 7389 | 331464 | 20221 | 51.2538 | -85.3232 | 2021-04-02 04:20:36 | Ontario, Canada | ||
637697 | 637697 | 2021-03-31 | Canada | Ontario | 357750 | 7366 | 329652 | 19558 | 51.2538 | -85.3232 | 2021-04-01 04:27:05 | Ontario, Canada | ||
3643326 | 3643326 | 2021-03-30 | Canada | Ontario | 354818 | 7351 | 325798 | 17885 | 51.2538 | -85.3232 | 2021-03-31 04:26:25 | Ontario, Canada | ||
1289779 | 1289779 | 2021-03-29 | Canada | Ontario | 352259 | 7337 | 324847 | 17641 | 51.2538 | -85.3232 | 2021-03-30 04:26:23 | Ontario, Canada | ||
1535701 | 1535701 | 2021-03-28 | Canada | Ontario | 349923 | 7327 | 323365 | 17091 | 51.2538 | -85.3232 | 2021-03-29 04:28:35 | Ontario, Canada | ||
1219341 | 1219341 | 2021-03-27 | Canada | Ontario | 347675 | 7308 | 321715 | 16450 | 51.2538 | -85.3232 | 2021-03-28 05:28:10 | Ontario, Canada | ||
1880759 | 1880759 | 2021-03-26 | Canada | Ontario | 345454 | 7292 | 320127 | 15718 | 51.2538 | -85.3232 | 2021-03-27 05:25:04 | Ontario, Canada | ||
1980389 | 1980389 | 2021-03-25 | Canada | Ontario | 342822 | 7280 | 318486 | 15266 | 51.2538 | -85.3232 | 2021-03-26 05:26:55 | Ontario, Canada | ||
2780767 | 2780767 | 2021-03-24 | Canada | Ontario | 340532 | 7263 | 317051 | 14426 | 51.2538 | -85.3232 | 2021-03-25 05:27:00 | Ontario, Canada | ||
1798412 | 1798412 | 2021-03-23 | Canada | Ontario | 338258 | 7253 | 315803 | 14214 | 51.2538 | -85.3232 | 2021-03-24 05:25:40 | Ontario, Canada | ||
1203580 | 1203580 | 2021-03-22 | Canada | Ontario | 336385 | 7244 | 314512 | 14006 | 51.2538 | -85.3232 | 2021-03-23 05:26:18 | Ontario, Canada | ||
3369102 | 3369102 | 2021-03-21 | Canada | Ontario | 334526 | 7241 | 313311 | 13580 | 51.2538 | -85.3232 | 2021-03-22 05:25:43 | Ontario, Canada | ||
1744312 | 1744312 | 2021-03-20 | Canada | Ontario | 332914 | 7223 | 311959 | 13303 | 51.2538 | -85.3232 | 2021-03-21 05:25:44 | Ontario, Canada | ||
3420692 | 3420692 | 2021-03-19 | Canada | Ontario | 331124 | 7212 | 310659 | 12820 | 51.2538 | -85.3232 | 2021-03-20 05:25:46 | Ontario, Canada | ||
3452630 | 3452630 | 2021-03-18 | Canada | Ontario | 329286 | 7202 | 309112 | 12612 | 51.2538 | -85.3232 | 2021-03-19 05:26:09 | Ontario, Canada | ||
3620854 | 3620854 | 2021-03-17 | Canada | Ontario | 327475 | 7187 | 307879 | 12303 | 51.2538 | -85.3232 | 2021-03-18 05:26:22 | Ontario, Canada | ||
702178 | 702178 | 2021-03-16 | Canada | Ontario | 325735 | 7173 | 306474 | 12179 | 51.2538 | -85.3232 | 2021-03-17 05:25:07 | Ontario, Canada | ||
2055656 | 2055656 | 2021-03-15 | Canada | Ontario | 324163 | 7162 | 305368 | 12185 | 51.2538 | -85.3232 | 2021-03-16 05:25:13 | Ontario, Canada | ||
1732268 | 1732268 | 2021-03-14 | Canada | Ontario | 322882 | 7153 | 304311 | 12062 | 51.2538 | -85.3232 | 2021-03-15 05:25:51 | Ontario, Canada | ||
1579925 | 1579925 | 2021-03-13 | Canada | Ontario | 321619 | 7138 | 303172 | 11714 | 51.2538 | -85.3232 | 2021-03-14 05:25:37 | Ontario, Canada | ||
1837704 | 1837704 | 2021-03-12 | Canada | Ontario | 320188 | 7127 | 302035 | 11332 | 51.2538 | -85.3232 | 2021-03-13 05:25:15 | Ontario, Canada | ||
352069 | 352069 | 2021-03-11 | Canada | Ontario | 318580 | 7109 | 300835 | 11140 | 51.2538 | -85.3232 | 2021-03-12 05:26:50 | Ontario, Canada | ||
3962293 | 3962293 | 2021-03-10 | Canada | Ontario | 317087 | 7099 | 299822 | 10984 | 51.2538 | -85.3232 | 2021-03-11 05:25:48 | Ontario, Canada | ||
3663381 | 3663381 | 2021-03-09 | Canada | Ontario | 315707 | 7083 | 298684 | 10984 | 51.2538 | -85.3232 | 2021-03-10 05:24:35 | Ontario, Canada | ||
2359240 | 2359240 | 2021-03-08 | Canada | Ontario | 314460 | 7077 | 297627 | 10756 | 51.2538 | -85.3232 | 2021-03-09 05:28:19 | Ontario, Canada | ||
54578 | 54578 | 2021-03-07 | Canada | Ontario | 313223 | 7067 | 296581 | 10260 | 51.2538 | -85.3232 | 2021-03-08 05:24:48 | Ontario, Canada | ||
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 |
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]);