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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
103099 | 103099 | 2021-08-15 | Canada | Ontario | 560008 | 9418 | 0 | 51.2538 | -85.3232 | 2021-08-16 04:21:31 | Ontario, Canada | |||
507457 | 507457 | 2021-08-14 | Canada | Ontario | 559545 | 9418 | 0 | 51.2538 | -85.3232 | 2021-08-15 04:21:41 | Ontario, Canada | |||
1483329 | 1483329 | 2021-08-13 | Canada | Ontario | 559034 | 9416 | 0 | 51.2538 | -85.3232 | 2021-08-14 04:21:25 | Ontario, Canada | |||
2899459 | 2899459 | 2021-08-12 | Canada | Ontario | 558493 | 9412 | 0 | 51.2538 | -85.3232 | 2021-08-13 04:21:24 | Ontario, Canada | |||
1342063 | 1342063 | 2021-08-11 | Canada | Ontario | 557954 | 9412 | 0 | 51.2538 | -85.3232 | 2021-08-12 04:21:25 | Ontario, Canada | |||
2351210 | 2351210 | 2021-08-10 | Canada | Ontario | 557419 | 9409 | 0 | 51.2538 | -85.3232 | 2021-08-11 04:21:58 | Ontario, Canada | |||
649739 | 649739 | 2021-08-09 | Canada | Ontario | 557021 | 9407 | 0 | 51.2538 | -85.3232 | 2021-08-10 04:21:27 | Ontario, Canada | |||
589401 | 589401 | 2021-08-08 | Canada | Ontario | 556683 | 9407 | 0 | 51.2538 | -85.3232 | 2021-08-09 04:21:24 | Ontario, Canada | |||
2203413 | 2203413 | 2021-08-07 | Canada | Ontario | 556329 | 9401 | 0 | 51.2538 | -85.3232 | 2021-08-08 04:21:33 | Ontario, Canada | |||
1117363 | 1117363 | 2021-08-06 | Canada | Ontario | 555984 | 9392 | 0 | 51.2538 | -85.3232 | 2021-08-07 04:21:30 | Ontario, Canada | |||
1956300 | 1956300 | 2021-08-05 | Canada | Ontario | 555536 | 9374 | 0 | 51.2538 | -85.3232 | 2021-08-06 04:21:18 | Ontario, Canada | |||
331679 | 331679 | 2021-08-04 | Canada | Ontario | 555177 | 9360 | 547673 | 1593 | 51.2538 | -85.3232 | 2021-08-05 04:21:51 | Ontario, Canada | ||
3467950 | 3467950 | 2021-08-03 | Canada | Ontario | 554903 | 9349 | 547531 | 1586 | 51.2538 | -85.3232 | 2021-08-04 04:21:25 | Ontario, Canada | ||
3683224 | 3683224 | 2021-08-02 | Canada | Ontario | 554687 | 9348 | 547153 | 1535 | 51.2538 | -85.3232 | 2021-08-03 04:21:39 | Ontario, Canada | ||
3015123 | 3015123 | 2021-08-01 | Canada | Ontario | 554537 | 9347 | 547121 | 1539 | 51.2538 | -85.3232 | 2021-08-02 04:21:36 | Ontario, Canada | ||
3903746 | 3903746 | 2021-07-31 | Canada | Ontario | 554376 | 9345 | 547010 | 1511 | 51.2538 | -85.3232 | 2021-08-01 04:21:50 | Ontario, Canada | ||
3295951 | 3295951 | 2021-07-30 | Canada | Ontario | 554177 | 9339 | 546916 | 1448 | 51.2538 | -85.3232 | 2021-07-31 04:21:35 | Ontario, Canada | ||
3385162 | 3385162 | 2021-07-29 | Canada | Ontario | 553945 | 9328 | 546761 | 1377 | 51.2538 | -85.3232 | 2021-07-30 04:21:34 | Ontario, Canada | ||
408067 | 408067 | 2021-07-28 | Canada | Ontario | 553697 | 9325 | 546590 | 1322 | 51.2538 | -85.3232 | 2021-07-29 04:21:33 | Ontario, Canada | ||
1305928 | 1305928 | 2021-07-27 | Canada | Ontario | 553459 | 9321 | 546438 | 1287 | 51.2538 | -85.3232 | 2021-07-28 04:21:39 | Ontario, Canada | ||
3218071 | 3218071 | 2021-07-26 | Canada | Ontario | 553286 | 9316 | 546262 | 1352 | 51.2538 | -85.3232 | 2021-07-27 04:21:18 | Ontario, Canada | ||
1378280 | 1378280 | 2021-07-25 | Canada | Ontario | 553155 | 9313 | 546062 | 1294 | 51.2538 | -85.3232 | 2021-07-26 04:21:28 | Ontario, Canada | ||
1330020 | 1330020 | 2021-07-24 | Canada | Ontario | 553019 | 9311 | 545920 | 1329 | 51.2538 | -85.3232 | 2021-07-25 04:22:12 | Ontario, Canada | ||
3137324 | 3137324 | 2021-07-23 | Canada | Ontario | 552872 | 9308 | 545825 | 1329 | 51.2538 | -85.3232 | 2021-07-24 00:21:36 | Ontario, Canada | ||
3476084 | 3476084 | 2021-07-22 | Canada | Ontario | 552691 | 9307 | 545662 | 1313 | 51.2538 | -85.3232 | 2021-07-23 04:21:29 | Ontario, Canada | ||
3331303 | 3331303 | 2021-07-21 | Canada | Ontario | 552495 | 9300 | 545512 | 1270 | 51.2538 | -85.3232 | 2021-07-22 04:21:19 | Ontario, Canada | ||
2371284 | 2371284 | 2021-07-20 | Canada | Ontario | 552319 | 9296 | 545379 | 1252 | 51.2538 | -85.3232 | 2021-07-21 04:21:40 | Ontario, Canada | ||
483363 | 483363 | 2021-07-19 | Canada | Ontario | 552153 | 9294 | 545205 | 1304 | 51.2538 | -85.3232 | 2021-07-20 04:21:48 | Ontario, Canada | ||
2673586 | 2673586 | 2021-07-18 | Canada | Ontario | 552012 | 9294 | 544995 | 1300 | 51.2538 | -85.3232 | 2021-07-19 04:21:24 | Ontario, Canada | ||
3705898 | 3705898 | 2021-07-17 | Canada | Ontario | 551884 | 9288 | 544879 | 1282 | 51.2538 | -85.3232 | 2021-07-18 04:22:07 | Ontario, Canada | ||
2947129 | 2947129 | 2021-07-16 | Canada | Ontario | 551730 | 9285 | 544709 | 1338 | 51.2538 | -85.3232 | 2021-07-17 04:22:22 | Ontario, Canada | ||
295785 | 295785 | 2021-07-15 | Canada | Ontario | 551558 | 9275 | 544530 | 1341 | 51.2538 | -85.3232 | 2021-07-16 04:21:22 | Ontario, Canada | ||
3631730 | 3631730 | 2021-07-14 | Canada | Ontario | 551370 | 9265 | 544379 | 1372 | 51.2538 | -85.3232 | 2021-07-15 04:21:48 | Ontario, Canada | ||
578605 | 578605 | 2021-07-13 | Canada | Ontario | 551225 | 9258 | 544165 | 1443 | 51.2538 | -85.3232 | 2021-07-14 04:21:35 | Ontario, Canada | ||
3740854 | 3740854 | 2021-07-12 | Canada | Ontario | 551068 | 9251 | 543954 | 1525 | 51.2538 | -85.3232 | 2021-07-13 04:21:18 | Ontario, Canada | ||
3659367 | 3659367 | 2021-07-11 | Canada | Ontario | 550954 | 9251 | 543715 | 1580 | 51.2538 | -85.3232 | 2021-07-12 04:21:34 | Ontario, Canada | ||
625651 | 625651 | 2021-07-10 | Canada | Ontario | 550825 | 9245 | 543530 | 1649 | 51.2538 | -85.3232 | 2021-07-11 04:21:43 | Ontario, Canada | ||
829370 | 829370 | 2021-07-09 | Canada | Ontario | 550668 | 9237 | 543379 | 1681 | 51.2538 | -85.3232 | 2021-07-10 04:21:25 | Ontario, Canada | ||
778134 | 778134 | 2021-07-08 | Canada | Ontario | 550496 | 9228 | 543134 | 1742 | 51.2538 | -85.3232 | 2021-07-09 04:21:21 | Ontario, Canada | ||
1440356 | 1440356 | 2021-07-07 | Canada | Ontario | 550337 | 9224 | 542903 | 1749 | 51.2538 | -85.3232 | 2021-07-08 04:21:26 | Ontario, Canada | ||
2693461 | 2693461 | 2021-07-06 | Canada | Ontario | 550110 | 9224 | 542619 | 1808 | 51.2538 | -85.3232 | 2021-07-07 04:21:20 | Ontario, Canada | ||
1932210 | 1932210 | 2021-07-05 | Canada | Ontario | 549888 | 9215 | 542430 | 1906 | 51.2538 | -85.3232 | 2021-07-06 04:21:32 | Ontario, Canada | ||
1164941 | 1164941 | 2021-07-04 | Canada | Ontario | 549754 | 9214 | 541977 | 1989 | 51.2538 | -85.3232 | 2021-07-05 04:21:28 | Ontario, Canada | ||
1495375 | 1495375 | 2021-07-03 | Canada | Ontario | 549596 | 9205 | 541759 | 2069 | 51.2538 | -85.3232 | 2021-07-04 04:21:38 | Ontario, Canada | ||
2071690 | 2071690 | 2021-07-02 | Canada | Ontario | 549377 | 9196 | 541529 | 2132 | 51.2538 | -85.3232 | 2021-07-03 04:21:37 | Ontario, Canada | ||
2764706 | 2764706 | 2021-07-01 | Canada | Ontario | 549179 | 9187 | 541073 | 2216 | 51.2538 | -85.3232 | 2021-07-02 04:21:47 | Ontario, Canada | ||
1892914 | 1892914 | 2021-06-30 | Canada | Ontario | 548993 | 9168 | 541033 | 2214 | 51.2538 | -85.3232 | 2021-07-01 04:21:19 | Ontario, Canada | ||
400037 | 400037 | 2021-06-29 | Canada | Ontario | 548760 | 9154 | 540594 | 2432 | 51.2538 | -85.3232 | 2021-06-30 04:21:41 | Ontario, Canada | ||
3125280 | 3125280 | 2021-06-28 | Canada | Ontario | 548523 | 9129 | 540214 | 2663 | 51.2538 | -85.3232 | 2021-06-29 04:21:28 | Ontario, Canada | ||
2589775 | 2589775 | 2021-06-27 | Canada | Ontario | 548331 | 9126 | 539504 | 2965 | 51.2538 | -85.3232 | 2021-06-28 04:21:29 | Ontario, Canada | ||
3958279 | 3958279 | 2021-06-26 | Canada | Ontario | 548125 | 9114 | 539256 | 3024 | 51.2538 | -85.3232 | 2021-06-27 04:21:39 | Ontario, Canada | ||
1712098 | 1712098 | 2021-06-25 | Canada | Ontario | 547882 | 9101 | 538876 | 3159 | 51.2538 | -85.3232 | 2021-06-26 04:21:43 | Ontario, Canada | ||
2295223 | 2295223 | 2021-06-24 | Canada | Ontario | 547576 | 9099 | 538533 | 3216 | 51.2538 | -85.3232 | 2021-06-25 04:21:33 | Ontario, Canada | ||
2422663 | 2422663 | 2021-06-23 | Canada | Ontario | 547278 | 9093 | 538183 | 3266 | 51.2538 | -85.3232 | 2021-06-24 04:21:55 | Ontario, Canada | ||
562740 | 562740 | 2021-06-22 | Canada | Ontario | 546986 | 9082 | 537644 | 3513 | 51.2538 | -85.3232 | 2021-06-23 04:21:46 | Ontario, Canada | ||
3358442 | 3358442 | 2021-06-21 | Canada | Ontario | 546708 | 9022 | 537340 | 3707 | 51.2538 | -85.3232 | 2021-06-22 04:21:34 | Ontario, Canada | ||
2884141 | 2884141 | 2021-06-20 | Canada | Ontario | 546508 | 9019 | 536374 | 4160 | 51.2538 | -85.3232 | 2021-06-21 04:21:41 | Ontario, Canada | ||
107224 | 107224 | 2021-06-19 | Canada | Ontario | 546240 | 9007 | 536047 | 4270 | 51.2538 | -85.3232 | 2021-06-20 04:21:48 | Ontario, Canada | ||
1125367 | 1125367 | 2021-06-18 | Canada | Ontario | 545958 | 8994 | 535668 | 4386 | 51.2538 | -85.3232 | 2021-06-19 04:22:33 | Ontario, Canada | ||
2910945 | 2910945 | 2021-06-17 | Canada | Ontario | 545634 | 8993 | 535219 | 4533 | 51.2538 | -85.3232 | 2021-06-18 04:22:16 | Ontario, Canada | ||
3030063 | 3030063 | 2021-06-16 | Canada | Ontario | 545280 | 8986 | 534694 | 4708 | 51.2538 | -85.3232 | 2021-06-17 04:22:36 | Ontario, Canada | ||
2339169 | 2339169 | 2021-06-15 | Canada | Ontario | 544916 | 8974 | 534007 | 4978 | 51.2538 | -85.3232 | 2021-06-16 04:22:32 | Ontario, Canada | ||
1563865 | 1563865 | 2021-06-14 | Canada | Ontario | 544536 | 8961 | 533335 | 5361 | 51.2538 | -85.3232 | 2021-06-15 04:22:22 | Ontario, Canada | ||
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 |
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]);