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)
last_update (date) >30 ✖
- 2020-02-01 2
- 2020-03-11 2
- 2020-03-09 1
- 2020-03-10 1
- 2020-03-12 1
- 2020-03-14 1
- 2020-03-15 1
- 2020-03-16 1
- 2020-03-17 1
- 2020-03-18 1
- 2020-03-19 1
- 2020-03-20 1
- 2020-03-21 1
- 2020-03-23 1
- 2020-03-24 1
- 2020-03-25 1
- 2020-03-26 1
- 2020-03-27 1
- 2020-03-31 1
- 2020-04-01 1
- 2020-04-03 1
- 2020-04-05 1
- 2020-04-07 1
- 2020-04-08 1
- 2020-04-09 1
- 2020-04-10 1
- 2020-04-11 1
- 2020-04-12 1
- 2020-04-13 1
- 2020-04-14 1
- …
province_or_state 1
- Ontario · 471 ✖
country_or_region 1
- Canada · 471 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3381148 | 3381148 | 2021-06-13 | Canada | Ontario | 544180 | 8957 | 532339 | 5738 | 51.2538 | -85.3232 | 2021-06-14 04:22:46 | Ontario, Canada | ||
1736282 | 1736282 | 2021-06-12 | Canada | Ontario | 543822 | 8950 | 531802 | 5872 | 51.2538 | -85.3232 | 2021-06-13 04:22:44 | Ontario, Canada | ||
3970323 | 3970323 | 2021-06-11 | Canada | Ontario | 543395 | 8935 | 531275 | 6014 | 51.2538 | -85.3232 | 2021-06-12 04:22:22 | Ontario, Canada | ||
2716745 | 2716745 | 2021-06-10 | Canada | Ontario | 542882 | 8931 | 530546 | 6215 | 51.2538 | -85.3232 | 2021-06-11 04:23:20 | Ontario, Canada | ||
522630 | 522630 | 2021-06-09 | Canada | Ontario | 542357 | 8920 | 529717 | 6480 | 51.2538 | -85.3232 | 2021-06-10 04:23:17 | Ontario, Canada | ||
3472070 | 3472070 | 2021-06-08 | Canada | Ontario | 541757 | 8887 | 528816 | 6933 | 51.2538 | -85.3232 | 2021-06-09 04:23:31 | Ontario, Canada | ||
3145354 | 3145354 | 2021-06-07 | Canada | Ontario | 541231 | 8869 | 527970 | 7524 | 51.2538 | -85.3232 | 2021-06-08 04:22:35 | Ontario, Canada | ||
825356 | 825356 | 2021-06-06 | Canada | Ontario | 540795 | 8854 | 526480 | 8267 | 51.2538 | -85.3232 | 2021-06-07 04:22:51 | Ontario, Canada | ||
2585761 | 2585761 | 2021-06-05 | Canada | Ontario | 540305 | 8844 | 525521 | 8585 | 51.2538 | -85.3232 | 2021-06-06 04:24:03 | Ontario, Canada | ||
2315075 | 2315075 | 2021-06-04 | Canada | Ontario | 539713 | 8820 | 524973 | 8733 | 51.2538 | -85.3232 | 2021-06-05 04:23:03 | Ontario, Canada | ||
1448360 | 1448360 | 2021-06-03 | Canada | Ontario | 539004 | 8801 | 523853 | 8987 | 51.2538 | -85.3232 | 2021-06-04 04:23:37 | Ontario, Canada | ||
1708084 | 1708084 | 2021-06-02 | Canada | Ontario | 538148 | 8791 | 522551 | 9421 | 51.2538 | -85.3232 | 2021-06-03 04:23:32 | Ontario, Canada | ||
2103902 | 2103902 | 2021-06-01 | Canada | Ontario | 537291 | 8766 | 520983 | 10161 | 51.2538 | -85.3232 | 2021-06-02 04:24:34 | Ontario, Canada | ||
1188518 | 1188518 | 2021-05-31 | Canada | Ontario | 536474 | 8757 | 519368 | 11071 | 51.2538 | -85.3232 | 2021-06-01 04:23:09 | Ontario, Canada | ||
3089195 | 3089195 | 2021-05-30 | Canada | Ontario | 535790 | 8744 | 516826 | 12349 | 51.2538 | -85.3232 | 2021-05-31 03:08:59 | Ontario, Canada | ||
50564 | 50564 | 2021-05-29 | Canada | Ontario | 535100 | 8726 | 515505 | 12907 | 51.2538 | -85.3232 | 2021-05-30 04:20:55 | Ontario, Canada | ||
20143 | 20143 | 2021-05-28 | Canada | Ontario | 534047 | 8711 | 514081 | 13482 | 51.2538 | -85.3232 | 2021-05-29 04:20:41 | Ontario, Canada | ||
1806518 | 1806518 | 2021-05-27 | Canada | Ontario | 533011 | 8697 | 511977 | 14413 | 51.2538 | -85.3232 | 2021-05-28 04:20:36 | Ontario, Canada | ||
1309942 | 1309942 | 2021-05-26 | Canada | Ontario | 531794 | 8678 | 506713 | 16807 | 51.2538 | -85.3232 | 2021-05-27 04:20:59 | Ontario, Canada | ||
82868 | 82868 | 2021-05-25 | Canada | Ontario | 530593 | 8655 | 505210 | 17497 | 51.2538 | -85.3232 | 2021-05-26 04:20:35 | Ontario, Canada | ||
1412830 | 1412830 | 2021-05-24 | Canada | Ontario | 529589 | 8622 | 503111 | 18371 | 51.2538 | -85.3232 | 2021-05-25 04:21:08 | Ontario, Canada | ||
1771116 | 1771116 | 2021-05-23 | Canada | Ontario | 528576 | 8614 | 502392 | 18742 | 51.2538 | -85.3232 | 2021-05-24 04:20:53 | Ontario, Canada | ||
726271 | 726271 | 2021-05-22 | Canada | Ontario | 527341 | 8599 | 500792 | 19125 | 51.2538 | -85.3232 | 2021-05-23 04:20:51 | Ontario, Canada | ||
1952286 | 1952286 | 2021-05-21 | Canada | Ontario | 525749 | 8579 | 499048 | 19484 | 51.2538 | -85.3232 | 2021-05-22 04:20:45 | Ontario, Canada | ||
1912985 | 1912985 | 2021-05-20 | Canada | Ontario | 523866 | 8552 | 496573 | 20240 | 51.2538 | -85.3232 | 2021-05-21 04:20:43 | Ontario, Canada | ||
2255506 | 2255506 | 2021-05-19 | Canada | Ontario | 522059 | 8525 | 494097 | 20564 | 51.2538 | -85.3232 | 2021-05-20 04:21:05 | Ontario, Canada | ||
2390544 | 2390544 | 2021-05-18 | Canada | Ontario | 519944 | 8506 | 491340 | 21185 | 51.2538 | -85.3232 | 2021-05-19 04:20:42 | Ontario, Canada | ||
3574369 | 3574369 | 2021-05-17 | Canada | Ontario | 518021 | 8489 | 488628 | 22459 | 51.2538 | -85.3232 | 2021-05-18 04:20:33 | Ontario, Canada | ||
2939099 | 2939099 | 2021-05-16 | Canada | Ontario | 516409 | 8485 | 483992 | 24030 | 51.2538 | -85.3232 | 2021-05-17 04:20:34 | Ontario, Canada | ||
1872729 | 1872729 | 2021-05-15 | Canada | Ontario | 514685 | 8455 | 481991 | 24461 | 51.2538 | -85.3232 | 2021-05-16 04:20:49 | Ontario, Canada | ||
1081698 | 1081698 | 2021-05-14 | Canada | Ontario | 512473 | 8431 | 479911 | 24765 | 51.2538 | -85.3232 | 2021-05-15 04:20:58 | Ontario, Canada | ||
3053964 | 3053964 | 2021-05-13 | Canada | Ontario | 510049 | 8405 | 475502 | 26044 | 51.2538 | -85.3232 | 2021-05-14 04:20:41 | Ontario, Canada | ||
2004434 | 2004434 | 2021-05-12 | Canada | Ontario | 507662 | 8374 | 473340 | 26329 | 51.2538 | -85.3232 | 2021-05-13 04:20:51 | Ontario, Canada | ||
3954265 | 3954265 | 2021-05-11 | Canada | Ontario | 505056 | 8342 | 470083 | 26939 | 51.2538 | -85.3232 | 2021-05-12 04:21:29 | Ontario, Canada | ||
2820544 | 2820544 | 2021-05-10 | Canada | Ontario | 502460 | 8327 | 466856 | 28113 | 51.2538 | -85.3232 | 2021-05-11 04:20:41 | Ontario, Canada | ||
1424876 | 1424876 | 2021-05-09 | Canada | Ontario | 500347 | 8308 | 461801 | 29137 | 51.2538 | -85.3232 | 2021-05-10 04:20:38 | Ontario, Canada | ||
1551744 | 1551744 | 2021-05-08 | Canada | Ontario | 498040 | 8261 | 459438 | 29333 | 51.2538 | -85.3232 | 2021-05-09 04:20:35 | Ontario, Canada | ||
2501802 | 2501802 | 2021-05-07 | Canada | Ontario | 495355 | 8236 | 457032 | 29616 | 51.2538 | -85.3232 | 2021-05-08 04:21:04 | Ontario, Canada | ||
3113258 | 3113258 | 2021-05-06 | Canada | Ontario | 492355 | 8213 | 453379 | 30334 | 51.2538 | -85.3232 | 2021-05-07 04:20:40 | Ontario, Canada | ||
645725 | 645725 | 2021-05-05 | Canada | Ontario | 488978 | 8187 | 449670 | 30678 | 51.2538 | -85.3232 | 2021-05-06 04:20:38 | Ontario, Canada | ||
3675425 | 3675425 | 2021-05-04 | Canada | Ontario | 485692 | 8143 | 445861 | 31165 | 51.2538 | -85.3232 | 2021-05-05 04:20:43 | Ontario, Canada | ||
2760692 | 2760692 | 2021-05-03 | Canada | Ontario | 482801 | 8118 | 442002 | 32327 | 51.2538 | -85.3232 | 2021-05-04 04:20:34 | Ontario, Canada | ||
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 |
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]);