johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
954 rows where country_or_region = "Mexico" and province_or_state = "Sonora" sorted by rowid
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
423452 | 423452 | 2021-10-10 | Mexico | Sonora | 109452 | 8300 | 0 | 29.2972 | -110.3309 | 2021-10-11 04:21:31 | Sonora, Mexico | |||
427434 | 427434 | 2020-09-07 | Mexico | Sonora | 22307 | 2699 | 18878 | 730 | 29.2972 | -110.3309 | 2020-09-08 04:28:25 | Sonora, Mexico | ||
431460 | 431460 | 2022-11-03 | Mexico | Sonora | 195216 | 10297 | 0 | 29.2972 | -110.3309 | 2022-11-04 04:22:11 | Sonora, Mexico | |||
435455 | 435455 | 2021-01-21 | Mexico | Sonora | 59440 | 4977 | 0 | 54463 | 29.2972 | -110.3309 | 2021-01-22 05:22:10 | Sonora, Mexico | ||
442721 | 442721 | 2020-07-26 | Mexico | Sonora | 16521 | 1745 | 13756 | 1020 | 29.2972 | -110.3309 | 2020-07-27 04:35:02 | Sonora, Mexico | ||
443456 | 443456 | 2021-10-20 | Mexico | Sonora | 110567 | 8359 | 0 | 29.2972 | -110.3309 | 2021-10-21 04:21:18 | Sonora, Mexico | |||
447472 | 447472 | 2021-11-17 | Mexico | Sonora | 114711 | 8606 | 0 | 29.2972 | -110.3309 | 2021-11-18 04:21:33 | Sonora, Mexico | |||
451490 | 451490 | 2022-12-21 | Mexico | Sonora | 197963 | 10310 | 0 | 29.2972 | -110.3309 | 2022-12-22 04:20:56 | Sonora, Mexico | |||
458747 | 458747 | 2020-08-07 | Mexico | Sonora | 18835 | 2248 | 15496 | 1091 | 29.2972 | -110.3309 | 2020-08-08 04:34:53 | Sonora, Mexico | ||
459481 | 459481 | 2022-02-02 | Mexico | Sonora | 147655 | 9536 | 0 | 29.2972 | -110.3309 | 2022-02-03 04:21:21 | Sonora, Mexico | |||
463498 | 463498 | 2022-05-02 | Mexico | Sonora | 165608 | 10119 | 0 | 29.2972 | -110.3309 | 2022-05-03 04:21:00 | Sonora, Mexico | |||
467513 | 467513 | 2021-10-07 | Mexico | Sonora | 109120 | 8278 | 0 | 29.2972 | -110.3309 | 2021-10-08 04:21:25 | Sonora, Mexico | |||
471511 | 471511 | 2021-02-19 | Mexico | Sonora | 66781 | 5860 | 0 | 60921 | 29.2972 | -110.3309 | 2021-02-20 05:22:51 | Sonora, Mexico | ||
475545 | 475545 | 2022-06-26 | Mexico | Sonora | 169383 | 10165 | 0 | 29.2972 | -110.3309 | 2022-06-27 04:21:00 | Sonora, Mexico | |||
479693 | 479693 | 2022-11-08 | Mexico | Sonora | 195303 | 10298 | 0 | 29.2972 | -110.3309 | 2022-11-09 04:21:22 | Sonora, Mexico | |||
483690 | 483690 | 2021-07-19 | Mexico | Sonora | 83995 | 6891 | 0 | 77104 | 29.2972 | -110.3309 | 2021-07-20 04:21:48 | Sonora, Mexico | ||
487723 | 487723 | 2022-11-25 | Mexico | Sonora | 195683 | 10298 | 0 | 29.2972 | -110.3309 | 2022-11-26 04:21:11 | Sonora, Mexico | |||
491737 | 491737 | 2021-10-14 | Mexico | Sonora | 109919 | 8319 | 0 | 29.2972 | -110.3309 | 2021-10-15 04:21:26 | Sonora, Mexico | |||
495753 | 495753 | 2021-11-06 | Mexico | Sonora | 113040 | 8529 | 0 | 29.2972 | -110.3309 | 2021-11-07 04:21:53 | Sonora, Mexico | |||
499770 | 499770 | 2022-04-02 | Mexico | Sonora | 164905 | 10083 | 0 | 29.2972 | -110.3309 | 2022-04-03 04:20:48 | Sonora, Mexico | |||
503787 | 503787 | 2022-12-17 | Mexico | Sonora | 197826 | 10310 | 0 | 29.2972 | -110.3309 | 2022-12-18 04:21:03 | Sonora, Mexico | |||
507784 | 507784 | 2021-08-14 | Mexico | Sonora | 94074 | 7244 | 0 | 29.2972 | -110.3309 | 2021-08-15 04:21:41 | Sonora, Mexico | |||
511798 | 511798 | 2021-08-19 | Mexico | Sonora | 96372 | 7315 | 0 | 29.2972 | -110.3309 | 2021-08-20 04:21:33 | Sonora, Mexico | |||
515831 | 515831 | 2022-10-15 | Mexico | Sonora | 195646 | 10297 | 0 | 29.2972 | -110.3309 | 2022-10-16 04:22:39 | Sonora, Mexico | |||
522957 | 522957 | 2021-06-09 | Mexico | Sonora | 76123 | 6689 | 0 | 69434 | 29.2972 | -110.3309 | 2021-06-10 04:23:17 | Sonora, Mexico | ||
530097 | 530097 | 2020-07-04 | Mexico | Sonora | 9093 | 830 | 7617 | 646 | 29.2972 | -110.3309 | 2020-07-05 04:33:46 | Sonora, Mexico | ||
530805 | 530805 | 2021-02-22 | Mexico | Sonora | 67011 | 5883 | 0 | 61128 | 29.2972 | -110.3309 | 2021-02-23 05:23:41 | Sonora, Mexico | ||
534837 | 534837 | 2021-10-27 | Mexico | Sonora | 111346 | 8404 | 0 | 29.2972 | -110.3309 | 2021-10-28 04:22:08 | Sonora, Mexico | |||
538855 | 538855 | 2022-10-26 | Mexico | Sonora | 195106 | 10297 | 0 | 29.2972 | -110.3309 | 2022-10-27 04:22:01 | Sonora, Mexico | |||
542871 | 542871 | 2022-12-15 | Mexico | Sonora | 197602 | 10307 | 0 | 29.2972 | -110.3309 | 2022-12-16 04:21:01 | Sonora, Mexico | |||
546851 | 546851 | 2020-09-12 | Mexico | Sonora | 23057 | 2803 | 19357 | 897 | 29.2972 | -110.3309 | 2020-09-13 04:30:52 | Sonora, Mexico | ||
550875 | 550875 | 2021-12-08 | Mexico | Sonora | 119351 | 8817 | 0 | 29.2972 | -110.3309 | 2021-12-09 04:22:49 | Sonora, Mexico | |||
554891 | 554891 | 2022-01-16 | Mexico | Sonora | 133879 | 9294 | 0 | 29.2972 | -110.3309 | 2022-01-17 04:21:08 | Sonora, Mexico | |||
558909 | 558909 | 2022-06-16 | Mexico | Sonora | 166972 | 10156 | 0 | 29.2972 | -110.3309 | 2022-06-17 04:20:56 | Sonora, Mexico | |||
563067 | 563067 | 2021-06-22 | Mexico | Sonora | 78097 | 6748 | 0 | 71349 | 29.2972 | -110.3309 | 2021-06-23 04:21:46 | Sonora, Mexico | ||
567205 | 567205 | 2021-10-29 | Mexico | Sonora | 111851 | 8449 | 0 | 29.2972 | -110.3309 | 2021-10-30 04:22:03 | Sonora, Mexico | |||
574208 | 574208 | 2020-06-06 | Mexico | Sonora | 2865 | 176 | 2246 | 443 | 29.2972 | -110.3309 | 2020-06-07 03:53:30 | Sonora, Mexico | ||
574934 | 574934 | 2022-02-25 | Mexico | Sonora | 160610 | 9916 | 0 | 29.2972 | -110.3309 | 2022-02-26 04:21:12 | Sonora, Mexico | |||
578932 | 578932 | 2021-07-13 | Mexico | Sonora | 82282 | 6860 | 0 | 75422 | 29.2972 | -110.3309 | 2021-07-14 04:21:35 | Sonora, Mexico | ||
582929 | 582929 | 2020-08-13 | Mexico | Sonora | 19625 | 2381 | 16414 | 830 | 29.2972 | -110.3309 | 2020-08-14 04:51:19 | Sonora, Mexico | ||
589728 | 589728 | 2021-08-08 | Mexico | Sonora | 91700 | 7128 | 0 | 29.2972 | -110.3309 | 2021-08-09 04:21:24 | Sonora, Mexico | |||
593761 | 593761 | 2022-07-01 | Mexico | Sonora | 171405 | 10166 | 0 | 29.2972 | -110.3309 | 2022-07-02 04:21:16 | Sonora, Mexico | |||
597775 | 597775 | 2021-10-19 | Mexico | Sonora | 110413 | 8354 | 0 | 29.2972 | -110.3309 | 2021-10-20 04:21:00 | Sonora, Mexico | |||
601791 | 601791 | 2021-09-23 | Mexico | Sonora | 106810 | 8011 | 0 | 29.2972 | -110.3309 | 2021-09-24 04:21:44 | Sonora, Mexico | |||
605788 | 605788 | 2021-04-09 | Mexico | Sonora | 71262 | 6345 | 0 | 64917 | 29.2972 | -110.3309 | 2021-04-10 04:20:59 | Sonora, Mexico | ||
609786 | 609786 | 2020-08-29 | Mexico | Sonora | 21331 | 2637 | 17830 | 864 | 29.2972 | -110.3309 | 2020-08-30 04:28:22 | Sonora, Mexico | ||
613787 | 613787 | 2021-02-08 | Mexico | Sonora | 64936 | 5526 | 0 | 59410 | 29.2972 | -110.3309 | 2021-02-09 05:23:30 | Sonora, Mexico | ||
617965 | 617965 | 2022-11-05 | Mexico | Sonora | 195264 | 10298 | 0 | 29.2972 | -110.3309 | 2022-11-06 04:21:24 | Sonora, Mexico | |||
621981 | 621981 | 2022-05-22 | Mexico | Sonora | 165220 | 10129 | 0 | 29.2972 | -110.3309 | 2022-05-26 04:20:50 | Sonora, Mexico | |||
625978 | 625978 | 2021-07-10 | Mexico | Sonora | 81772 | 6849 | 0 | 74923 | 29.2972 | -110.3309 | 2021-07-11 04:21:43 | Sonora, Mexico | ||
630011 | 630011 | 2022-07-12 | Mexico | Sonora | 176647 | 10187 | 0 | 29.2972 | -110.3309 | 2022-07-13 04:20:58 | Sonora, Mexico | |||
634025 | 634025 | 2021-10-13 | Mexico | Sonora | 109781 | 8316 | 0 | 29.2972 | -110.3309 | 2021-10-14 04:21:29 | Sonora, Mexico | |||
638023 | 638023 | 2021-03-31 | Mexico | Sonora | 70488 | 6274 | 0 | 64214 | 29.2972 | -110.3309 | 2021-04-01 04:27:05 | Sonora, Mexico | ||
642038 | 642038 | 2021-09-07 | Mexico | Sonora | 103059 | 7715 | 0 | 29.2972 | -110.3309 | 2021-09-08 04:21:31 | Sonora, Mexico | |||
646051 | 646051 | 2021-05-05 | Mexico | Sonora | 73630 | 6543 | 0 | 67087 | 29.2972 | -110.3309 | 2021-05-06 04:20:38 | Sonora, Mexico | ||
650066 | 650066 | 2021-08-09 | Mexico | Sonora | 91887 | 7135 | 0 | 29.2972 | -110.3309 | 2021-08-10 04:21:27 | Sonora, Mexico | |||
654097 | 654097 | 2021-10-22 | Mexico | Sonora | 110907 | 8375 | 0 | 29.2972 | -110.3309 | 2021-10-23 04:21:32 | Sonora, Mexico | |||
658416 | 658416 | 2022-05-13 | Mexico | Sonora | 165650 | 10119 | 0 | 29.2972 | -110.3309 | 2022-05-14 04:20:48 | Sonora, Mexico | |||
662396 | 662396 | 2020-08-11 | Mexico | Sonora | 19403 | 2344 | 16172 | 887 | 29.2972 | -110.3309 | 2020-08-12 04:27:29 | Sonora, Mexico | ||
666376 | 666376 | 2020-09-16 | Mexico | Sonora | 23445 | 2812 | 19939 | 694 | 29.2972 | -110.3309 | 2020-09-17 04:22:00 | Sonora, Mexico | ||
670402 | 670402 | 2022-07-21 | Mexico | Sonora | 182385 | 10208 | 0 | 29.2972 | -110.3309 | 2022-07-22 04:21:15 | Sonora, Mexico | |||
674418 | 674418 | 2022-07-30 | Mexico | Sonora | 186157 | 10229 | 0 | 29.2972 | -110.3309 | 2022-07-31 04:21:02 | Sonora, Mexico | |||
678411 | 678411 | 2020-11-23 | Mexico | Sonora | 41752 | 3327 | 0 | 38425 | 29.2972 | -110.3309 | 2020-11-24 05:27:31 | Sonora, Mexico | ||
682442 | 682442 | 2021-10-24 | Mexico | Sonora | 111069 | 8389 | 0 | 29.2972 | -110.3309 | 2021-10-25 04:22:31 | Sonora, Mexico | |||
686458 | 686458 | 2021-11-13 | Mexico | Sonora | 114071 | 8581 | 0 | 29.2972 | -110.3309 | 2021-11-14 04:21:31 | Sonora, Mexico | |||
690476 | 690476 | 2022-12-23 | Mexico | Sonora | 197963 | 10310 | 0 | 29.2972 | -110.3309 | 2022-12-24 04:21:02 | Sonora, Mexico | |||
694491 | 694491 | 2022-03-17 | Mexico | Sonora | 163557 | 10046 | 0 | 29.2972 | -110.3309 | 2022-03-18 04:20:55 | Sonora, Mexico | |||
698506 | 698506 | 2021-11-04 | Mexico | Sonora | 112358 | 8499 | 0 | 29.2972 | -110.3309 | 2021-11-05 04:21:54 | Sonora, Mexico | |||
702504 | 702504 | 2021-03-16 | Mexico | Sonora | 69242 | 6147 | 0 | 63095 | 29.2972 | -110.3309 | 2021-03-17 05:25:07 | Sonora, Mexico | ||
706536 | 706536 | 2021-09-29 | Mexico | Sonora | 107849 | 8176 | 0 | 29.2972 | -110.3309 | 2021-09-30 04:21:20 | Sonora, Mexico | |||
710553 | 710553 | 2022-11-01 | Mexico | Sonora | 195154 | 10297 | 0 | 29.2972 | -110.3309 | 2022-11-02 04:22:09 | Sonora, Mexico | |||
714567 | 714567 | 2021-11-12 | Mexico | Sonora | 113811 | 8571 | 0 | 29.2972 | -110.3309 | 2021-11-13 04:21:38 | Sonora, Mexico | |||
718585 | 718585 | 2022-12-04 | Mexico | Sonora | 195683 | 10298 | 0 | 29.2972 | -110.3309 | 2022-12-05 04:20:58 | Sonora, Mexico | |||
722599 | 722599 | 2021-11-20 | Mexico | Sonora | 115266 | 8633 | 0 | 29.2972 | -110.3309 | 2021-11-21 04:22:13 | Sonora, Mexico | |||
726597 | 726597 | 2021-05-22 | Mexico | Sonora | 74686 | 6590 | 0 | 68096 | 29.2972 | -110.3309 | 2021-05-23 04:20:51 | Sonora, Mexico | ||
730629 | 730629 | 2021-12-27 | Mexico | Sonora | 122477 | 9066 | 0 | 29.2972 | -110.3309 | 2021-12-28 04:21:47 | Sonora, Mexico | |||
737694 | 737694 | 2020-06-12 | Mexico | Sonora | 3715 | 244 | 3132 | 339 | 29.2972 | -110.3309 | 2020-06-13 03:33:14 | Sonora, Mexico | ||
738400 | 738400 | 2020-12-02 | Mexico | Sonora | 44100 | 3460 | 0 | 40640 | 29.2972 | -110.3309 | 2020-12-03 05:28:22 | Sonora, Mexico | ||
742413 | 742413 | 2021-02-20 | Mexico | Sonora | 66876 | 5873 | 0 | 61003 | 29.2972 | -110.3309 | 2021-02-21 05:24:33 | Sonora, Mexico | ||
746446 | 746446 | 2022-04-23 | Mexico | Sonora | 165529 | 10112 | 0 | 29.2972 | -110.3309 | 2022-04-24 04:20:56 | Sonora, Mexico | |||
753701 | 753701 | 2020-08-01 | Mexico | Sonora | 17890 | 1974 | 14902 | 1014 | 29.2972 | -110.3309 | 2020-08-02 04:34:47 | Sonora, Mexico | ||
754401 | 754401 | 2020-10-28 | Mexico | Sonora | 37764 | 3141 | 33774 | 849 | 29.2972 | -110.3309 | 2020-10-29 04:24:49 | Sonora, Mexico | ||
758429 | 758429 | 2021-11-26 | Mexico | Sonora | 117046 | 8690 | 0 | 29.2972 | -110.3309 | 2021-11-27 04:22:45 | Sonora, Mexico | |||
762412 | 762412 | 2020-10-18 | Mexico | Sonora | 36414 | 3063 | 32554 | 797 | 29.2972 | -110.3309 | 2020-10-19 04:24:16 | Sonora, Mexico | ||
766419 | 766419 | 2020-12-29 | Mexico | Sonora | 51177 | 4057 | 0 | 47120 | 29.2972 | -110.3309 | 2020-12-30 05:22:34 | Sonora, Mexico | ||
770450 | 770450 | 2021-10-23 | Mexico | Sonora | 111069 | 8389 | 0 | 29.2972 | -110.3309 | 2021-10-24 04:21:22 | Sonora, Mexico | |||
774447 | 774447 | 2021-01-12 | Mexico | Sonora | 55654 | 4459 | 0 | 51195 | 29.2972 | -110.3309 | 2021-01-13 05:22:15 | Sonora, Mexico | ||
778461 | 778461 | 2021-07-08 | Mexico | Sonora | 81268 | 6827 | 0 | 74441 | 29.2972 | -110.3309 | 2021-07-09 04:21:21 | Sonora, Mexico | ||
782492 | 782492 | 2021-12-13 | Mexico | Sonora | 120451 | 8895 | 0 | 29.2972 | -110.3309 | 2021-12-14 04:22:38 | Sonora, Mexico | |||
786475 | 786475 | 2020-10-15 | Mexico | Sonora | 35949 | 3042 | 32106 | 801 | 29.2972 | -110.3309 | 2020-10-16 04:24:01 | Sonora, Mexico | ||
790482 | 790482 | 2021-02-04 | Mexico | Sonora | 63637 | 5345 | 0 | 58292 | 29.2972 | -110.3309 | 2021-02-05 05:22:38 | Sonora, Mexico | ||
794517 | 794517 | 2022-10-24 | Mexico | Sonora | 195045 | 10297 | 0 | 29.2972 | -110.3309 | 2022-10-25 04:21:53 | Sonora, Mexico | |||
798531 | 798531 | 2021-12-22 | Mexico | Sonora | 121954 | 9015 | 0 | 29.2972 | -110.3309 | 2021-12-23 04:21:21 | Sonora, Mexico | |||
805507 | 805507 | 2020-06-01 | Mexico | Sonora | 2142 | 116 | 1640 | 386 | 29.2972 | -110.3309 | 2020-06-02 02:33:08 | Sonora, Mexico | ||
809676 | 809676 | 2021-09-20 | Mexico | Sonora | 105986 | 7947 | 0 | 29.2972 | -110.3309 | 2021-09-21 04:21:26 | Sonora, Mexico | |||
813674 | 813674 | 2020-09-05 | Mexico | Sonora | 22163 | 2693 | 18593 | 877 | 29.2972 | -110.3309 | 2020-09-06 04:28:33 | Sonora, Mexico | ||
817665 | 817665 | 2020-10-09 | Mexico | Sonora | 35177 | 3005 | 31400 | 772 | 29.2972 | -110.3309 | 2020-10-10 04:23:57 | Sonora, Mexico | ||
821669 | 821669 | 2020-11-19 | Mexico | Sonora | 40921 | 3284 | 0 | 37637 | 29.2972 | -110.3309 | 2020-11-20 05:26:28 | Sonora, Mexico | ||
825683 | 825683 | 2021-06-06 | Mexico | Sonora | 75853 | 6675 | 0 | 69178 | 29.2972 | -110.3309 | 2021-06-07 04:22:51 | Sonora, Mexico | ||
829697 | 829697 | 2021-07-09 | Mexico | Sonora | 81480 | 6832 | 0 | 74648 | 29.2972 | -110.3309 | 2021-07-10 04:21:25 | Sonora, Mexico |
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]);