johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,035 rows where country_or_region = "Canada" and latitude = "51.2538" sorted by longitude
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
387996 | 387996 | 2021-04-04 | Canada | Ontario | 370012 | 7440 | 337043 | 23018 | 51.2538 | -85.3232 | 2021-04-05 04:20:35 | 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 | ||
396022 | 396022 | 2022-10-07 | Canada | Ontario | 1477931 | 14495 | 0 | 51.2538 | -85.3232 | 2022-10-08 04:22:56 | 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 | ||
404051 | 404051 | 2021-12-07 | Canada | Ontario | 631591 | 10036 | 0 | 51.2538 | -85.3232 | 2021-12-08 04:22:46 | 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 | ||
415444 | 415444 | 2020-07-05 | Canada | Ontario | 36232 | 2689 | 32799 | 2111 | 51.2538 | -85.3232 | 2020-07-06 04:33:57 | Ontario, Canada | ||
415876 | 415876 | 2020-01-26 | Canada | Ontario | 3 | 0 | 0 | 51.2538 | -85.3232 | 1/26/20 16:00 | ||||
418757 | 418757 | 2020-04-18 | Canada | Ontario | 12273 | 514 | 0 | 10449 | 51.2538 | -85.3232 | 2020-04-18 22:40:03 | Ontario, Canada | ||
419093 | 419093 | 2022-09-18 | Canada | Ontario | 1450985 | 14283 | 0 | 51.2538 | -85.3232 | 2022-09-19 04:21:49 | Ontario, Canada | |||
423108 | 423108 | 2021-10-10 | Canada | Ontario | 596631 | 9790 | 0 | 51.2538 | -85.3232 | 2021-10-11 04:21:31 | Ontario, Canada | |||
427113 | 427113 | 2020-09-07 | Canada | Ontario | 44195 | 2813 | 40884 | 1568 | 51.2538 | -85.3232 | 2020-09-08 04:28:25 | Ontario, Canada | ||
431115 | 431115 | 2022-11-03 | Canada | Ontario | 1515879 | 14870 | 0 | 51.2538 | -85.3232 | 2022-11-04 04:22:11 | 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 | ||
442630 | 442630 | 2020-07-26 | Canada | Ontario | 39186 | 2763 | 35973 | 1779 | 51.2538 | -85.3232 | 2020-07-27 04:35:02 | Ontario, Canada | ||
443112 | 443112 | 2021-10-20 | Canada | Ontario | 600691 | 9823 | 0 | 51.2538 | -85.3232 | 2021-10-21 04:21:18 | Ontario, Canada | |||
447128 | 447128 | 2021-11-17 | Canada | Ontario | 614065 | 9950 | 0 | 51.2538 | -85.3232 | 2021-11-18 04:21:33 | Ontario, Canada | |||
451145 | 451145 | 2022-12-21 | Canada | Ontario | 1544643 | 15440 | 0 | 51.2538 | -85.3232 | 2022-12-22 04:20:56 | Ontario, Canada | |||
458656 | 458656 | 2020-08-07 | Canada | Ontario | 40377 | 2783 | 37717 | 1269 | 51.2538 | -85.3232 | 2020-08-08 04:34:53 | Ontario, Canada | ||
459137 | 459137 | 2022-02-02 | Canada | Ontario | 1059152 | 11576 | 0 | 51.2538 | -85.3232 | 2022-02-03 04:21:21 | Ontario, Canada | |||
463154 | 463154 | 2022-05-02 | Canada | Ontario | 1276335 | 12842 | 0 | 51.2538 | -85.3232 | 2022-05-03 04:21:00 | Ontario, Canada | |||
467169 | 467169 | 2021-10-07 | Canada | Ontario | 595233 | 9776 | 0 | 51.2538 | -85.3232 | 2021-10-08 04:21:25 | 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 | ||
475200 | 475200 | 2022-06-26 | Canada | Ontario | 1337296 | 13389 | 0 | 51.2538 | -85.3232 | 2022-06-27 04:21:00 | Ontario, Canada | |||
479348 | 479348 | 2022-11-08 | Canada | Ontario | 1518134 | 14919 | 0 | 51.2538 | -85.3232 | 2022-11-09 04:21:22 | 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 | ||
487378 | 487378 | 2022-11-25 | Canada | Ontario | 1531401 | 15176 | 0 | 51.2538 | -85.3232 | 2022-11-26 04:21:11 | Ontario, Canada | |||
491393 | 491393 | 2021-10-14 | Canada | Ontario | 598319 | 9807 | 0 | 51.2538 | -85.3232 | 2021-10-15 04:21:26 | Ontario, Canada | |||
495409 | 495409 | 2021-11-06 | Canada | Ontario | 607669 | 9896 | 0 | 51.2538 | -85.3232 | 2021-11-07 04:21:53 | Ontario, Canada | |||
499426 | 499426 | 2022-04-02 | Canada | Ontario | 1176866 | 12460 | 0 | 51.2538 | -85.3232 | 2022-04-03 04:20:48 | Ontario, Canada | |||
503442 | 503442 | 2022-12-17 | Canada | Ontario | 1544172 | 15440 | 0 | 51.2538 | -85.3232 | 2022-12-18 04:21:03 | Ontario, Canada | |||
507457 | 507457 | 2021-08-14 | Canada | Ontario | 559545 | 9418 | 0 | 51.2538 | -85.3232 | 2021-08-15 04:21:41 | Ontario, Canada | |||
511471 | 511471 | 2021-08-19 | Canada | Ontario | 562345 | 9448 | 0 | 51.2538 | -85.3232 | 2021-08-20 04:21:33 | Ontario, Canada | |||
515486 | 515486 | 2022-10-15 | Canada | Ontario | 1487510 | 14560 | 0 | 51.2538 | -85.3232 | 2022-10-16 04:22:39 | Ontario, Canada | |||
522295 | 522295 | 2020-04-21 | Canada | Ontario | 14001 | 622 | 0 | 12021 | 51.2538 | -85.3232 | 2020-04-21 23:38:53 | 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 | ||
530006 | 530006 | 2020-07-04 | Canada | Ontario | 36134 | 2687 | 32600 | 2181 | 51.2538 | -85.3232 | 2020-07-05 04:33:46 | 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 | ||
534493 | 534493 | 2021-10-27 | Canada | Ontario | 603150 | 9862 | 0 | 51.2538 | -85.3232 | 2021-10-28 04:22:08 | Ontario, Canada | |||
538510 | 538510 | 2022-10-26 | Canada | Ontario | 1499463 | 14690 | 0 | 51.2538 | -85.3232 | 2022-10-27 04:22:01 | Ontario, Canada | |||
542526 | 542526 | 2022-12-15 | Canada | Ontario | 1543747 | 15440 | 0 | 51.2538 | -85.3232 | 2022-12-16 04:21:01 | Ontario, Canada | |||
546530 | 546530 | 2020-09-12 | Canada | Ontario | 45444 | 2814 | 41585 | 1875 | 51.2538 | -85.3232 | 2020-09-13 04:30:52 | Ontario, Canada | ||
550531 | 550531 | 2021-12-08 | Canada | Ontario | 633016 | 10044 | 0 | 51.2538 | -85.3232 | 2021-12-09 04:22:49 | Ontario, Canada | |||
554547 | 554547 | 2022-01-16 | Canada | Ontario | 977228 | 10605 | 0 | 51.2538 | -85.3232 | 2022-01-17 04:21:08 | Ontario, Canada | |||
558564 | 558564 | 2022-06-16 | Canada | Ontario | 1331406 | 13357 | 0 | 51.2538 | -85.3232 | 2022-06-17 04:20:56 | 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 | ||
566861 | 566861 | 2021-10-29 | Canada | Ontario | 603928 | 9865 | 0 | 51.2538 | -85.3232 | 2021-10-30 04:22:03 | Ontario, Canada | |||
574124 | 574124 | 2020-06-06 | Canada | Ontario | 30928 | 2407 | 24420 | 4717 | 51.2538 | -85.3232 | 2020-06-07 03:53:30 | Ontario, Canada | ||
574590 | 574590 | 2022-02-25 | Canada | Ontario | 1108614 | 12386 | 0 | 51.2538 | -85.3232 | 2022-02-26 04:21:12 | 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 | ||
582608 | 582608 | 2020-08-13 | Canada | Ontario | 40909 | 2787 | 38396 | 1083 | 51.2538 | -85.3232 | 2020-08-14 04:51:19 | Ontario, Canada | ||
589067 | 589067 | 2020-04-05 | Canada | Ontario | 5478 | 119 | 0 | 4235 | 51.2538 | -85.3232 | 2020-04-05 23:13:28 | Ontario, Canada | ||
589401 | 589401 | 2021-08-08 | Canada | Ontario | 556683 | 9407 | 0 | 51.2538 | -85.3232 | 2021-08-09 04:21:24 | Ontario, Canada | |||
593416 | 593416 | 2022-07-01 | Canada | Ontario | 1342709 | 13430 | 0 | 51.2538 | -85.3232 | 2022-07-02 04:21:16 | Ontario, Canada | |||
597431 | 597431 | 2021-10-19 | Canada | Ontario | 600247 | 9819 | 0 | 51.2538 | -85.3232 | 2021-10-20 04:21:00 | Ontario, Canada | |||
601447 | 601447 | 2021-09-23 | Canada | Ontario | 587186 | 9677 | 0 | 51.2538 | -85.3232 | 2021-09-24 04:21:44 | 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 | ||
609465 | 609465 | 2020-08-29 | Canada | Ontario | 42746 | 2809 | 39919 | 1270 | 51.2538 | -85.3232 | 2020-08-30 04:28:22 | 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 | ||
617620 | 617620 | 2022-11-05 | Canada | Ontario | 1516369 | 14887 | 0 | 51.2538 | -85.3232 | 2022-11-06 04:21:24 | Ontario, Canada | |||
621636 | 621636 | 2022-05-22 | Canada | Ontario | 1312810 | 13161 | 0 | 51.2538 | -85.3232 | 2022-05-26 04:20:50 | 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 | ||
629666 | 629666 | 2022-07-12 | Canada | Ontario | 1353950 | 13476 | 0 | 51.2538 | -85.3232 | 2022-07-13 04:20:58 | Ontario, Canada | |||
633681 | 633681 | 2021-10-13 | Canada | Ontario | 597733 | 9804 | 0 | 51.2538 | -85.3232 | 2021-10-14 04:21:29 | 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 | ||
641711 | 641711 | 2021-09-07 | Canada | Ontario | 575776 | 9553 | 0 | 51.2538 | -85.3232 | 2021-09-08 04:21:31 | 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 | ||
649739 | 649739 | 2021-08-09 | Canada | Ontario | 557021 | 9407 | 0 | 51.2538 | -85.3232 | 2021-08-10 04:21:27 | Ontario, Canada | |||
653753 | 653753 | 2021-10-22 | Canada | Ontario | 601493 | 9839 | 0 | 51.2538 | -85.3232 | 2021-10-23 04:21:32 | Ontario, Canada | |||
657747 | 657747 | 2020-03-09 | Canada | Ontario | 90 | 1 | 4 | 51.2538 | -85.3232 | 2020-03-09T17:53:24 | ||||
658072 | 658072 | 2022-05-13 | Canada | Ontario | 1299706 | 13052 | 0 | 51.2538 | -85.3232 | 2022-05-14 04:20:48 | Ontario, Canada | |||
662076 | 662076 | 2020-08-11 | Canada | Ontario | 40711 | 2786 | 38175 | 1155 | 51.2538 | -85.3232 | 2020-08-12 04:27:29 | Ontario, Canada | ||
666055 | 666055 | 2020-09-16 | Canada | Ontario | 46693 | 2822 | 42206 | 2410 | 51.2538 | -85.3232 | 2020-09-17 04:22:00 | Ontario, Canada | ||
670057 | 670057 | 2022-07-21 | Canada | Ontario | 1372023 | 13555 | 0 | 51.2538 | -85.3232 | 2022-07-22 04:21:15 | Ontario, Canada | |||
674073 | 674073 | 2022-07-30 | Canada | Ontario | 1385022 | 13702 | 0 | 51.2538 | -85.3232 | 2022-07-31 04:21:02 | 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 | ||
682098 | 682098 | 2021-10-24 | Canada | Ontario | 602057 | 9846 | 0 | 51.2538 | -85.3232 | 2021-10-25 04:22:31 | Ontario, Canada | |||
686114 | 686114 | 2021-11-13 | Canada | Ontario | 611711 | 9927 | 0 | 51.2538 | -85.3232 | 2021-11-14 04:21:31 | Ontario, Canada | |||
690131 | 690131 | 2022-12-23 | Canada | Ontario | 1552652 | 15514 | 0 | 51.2538 | -85.3232 | 2022-12-24 04:21:02 | Ontario, Canada | |||
694147 | 694147 | 2022-03-17 | Canada | Ontario | 1145534 | 12307 | 0 | 51.2538 | -85.3232 | 2022-03-18 04:20:55 | Ontario, Canada | |||
698162 | 698162 | 2021-11-04 | Canada | Ontario | 606540 | 9891 | 0 | 51.2538 | -85.3232 | 2021-11-05 04:21:54 | 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 | ||
706192 | 706192 | 2021-09-29 | Canada | Ontario | 590629 | 9723 | 0 | 51.2538 | -85.3232 | 2021-09-30 04:21:20 | Ontario, Canada | |||
710208 | 710208 | 2022-11-01 | Canada | Ontario | 1509047 | 14785 | 0 | 51.2538 | -85.3232 | 2022-11-02 04:22:09 | Ontario, Canada | |||
714223 | 714223 | 2021-11-12 | Canada | Ontario | 611122 | 9921 | 0 | 51.2538 | -85.3232 | 2021-11-13 04:21:38 | Ontario, Canada | |||
718240 | 718240 | 2022-12-04 | Canada | Ontario | 1538271 | 15300 | 0 | 51.2538 | -85.3232 | 2022-12-02 18:21:06 | Ontario, Canada | |||
722255 | 722255 | 2021-11-20 | Canada | Ontario | 616283 | 9964 | 0 | 51.2538 | -85.3232 | 2021-11-21 04:22:13 | 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 | ||
730285 | 730285 | 2021-12-27 | Canada | Ontario | 731146 | 10161 | 0 | 51.2538 | -85.3232 | 2021-12-28 04:21:47 | Ontario, Canada | |||
737603 | 737603 | 2020-06-12 | Canada | Ontario | 32295 | 2498 | 26698 | 4107 | 51.2538 | -85.3232 | 2020-06-13 03:33:14 | 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 | ||
742087 | 742087 | 2021-02-20 | Canada | Ontario | 296007 | 6848 | 280307 | 9856 | 51.2538 | -85.3232 | 2021-02-21 05:24:33 | Ontario, Canada | ||
746102 | 746102 | 2022-04-23 | Canada | Ontario | 1252916 | 12728 | 0 | 51.2538 | -85.3232 | 2022-04-24 04:20:56 | Ontario, Canada | |||
753610 | 753610 | 2020-08-01 | Canada | Ontario | 39874 | 2777 | 36873 | 1563 | 51.2538 | -85.3232 | 2020-08-02 04:34:47 | 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 | ||
758085 | 758085 | 2021-11-26 | Canada | Ontario | 620885 | 9991 | 0 | 51.2538 | -85.3232 | 2021-11-27 04:22:45 | 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 | ||
766095 | 766095 | 2020-12-29 | Canada | Ontario | 182916 | 4455 | 156637 | 18098 | 51.2538 | -85.3232 | 2020-12-30 05:22:34 | Ontario, Canada | ||
770106 | 770106 | 2021-10-23 | Canada | Ontario | 601807 | 9845 | 0 | 51.2538 | -85.3232 | 2021-10-24 04:21:22 | 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 |
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]);