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 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1858104 | 1858104 | 2021-02-25 | Mexico | Sonora | 67374 | 5951 | 0 | 61423 | 29.2972 | -110.3309 | 2021-02-26 05:22:40 | Sonora, Mexico | ||
280282 | 280282 | 2021-02-24 | Mexico | Sonora | 67245 | 5927 | 0 | 61318 | 29.2972 | -110.3309 | 2021-02-25 05:24:57 | Sonora, Mexico | ||
1936550 | 1936550 | 2021-02-23 | Mexico | Sonora | 67125 | 5912 | 0 | 61213 | 29.2972 | -110.3309 | 2021-02-24 05:29:16 | 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 | ||
182139 | 182139 | 2021-02-21 | Mexico | Sonora | 66941 | 5875 | 0 | 61066 | 29.2972 | -110.3309 | 2021-02-22 05:24:21 | 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 | ||
471511 | 471511 | 2021-02-19 | Mexico | Sonora | 66781 | 5860 | 0 | 60921 | 29.2972 | -110.3309 | 2021-02-20 05:22:51 | Sonora, Mexico | ||
1153220 | 1153220 | 2021-02-18 | Mexico | Sonora | 66650 | 5838 | 0 | 60812 | 29.2972 | -110.3309 | 2021-02-19 05:24:16 | Sonora, Mexico | ||
3601140 | 3601140 | 2021-02-17 | Mexico | Sonora | 66480 | 5802 | 0 | 60678 | 29.2972 | -110.3309 | 2021-02-18 05:22:58 | Sonora, Mexico | ||
3050275 | 3050275 | 2021-02-16 | Mexico | Sonora | 66277 | 5757 | 0 | 60520 | 29.2972 | -110.3309 | 2021-02-17 05:23:10 | Sonora, Mexico | ||
1338374 | 1338374 | 2021-02-15 | Mexico | Sonora | 66138 | 5722 | 0 | 60416 | 29.2972 | -110.3309 | 2021-02-16 05:24:38 | Sonora, Mexico | ||
2283525 | 2283525 | 2021-02-14 | Mexico | Sonora | 66021 | 5714 | 0 | 60307 | 29.2972 | -110.3309 | 2021-02-15 05:24:49 | Sonora, Mexico | ||
2677925 | 2677925 | 2021-02-13 | Mexico | Sonora | 65887 | 5705 | 0 | 60182 | 29.2972 | -110.3309 | 2021-02-14 05:23:43 | Sonora, Mexico | ||
3539558 | 3539558 | 2021-02-12 | Mexico | Sonora | 65677 | 5677 | 0 | 60000 | 29.2972 | -110.3309 | 2021-02-13 05:22:12 | Sonora, Mexico | ||
2637821 | 2637821 | 2021-02-11 | Mexico | Sonora | 65504 | 5640 | 0 | 59864 | 29.2972 | -110.3309 | 2021-02-12 05:23:29 | Sonora, Mexico | ||
3978676 | 3978676 | 2021-02-10 | Mexico | Sonora | 65343 | 5622 | 0 | 59721 | 29.2972 | -110.3309 | 2021-02-11 05:23:55 | Sonora, Mexico | ||
1527996 | 1527996 | 2021-02-09 | Mexico | Sonora | 65148 | 5599 | 0 | 59549 | 29.2972 | -110.3309 | 2021-02-10 05:22:41 | 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 | ||
1672556 | 1672556 | 2021-02-07 | Mexico | Sonora | 64826 | 5517 | 0 | 59309 | 29.2972 | -110.3309 | 2021-02-08 05:22:39 | Sonora, Mexico | ||
975017 | 975017 | 2021-02-06 | Mexico | Sonora | 64675 | 5500 | 0 | 59175 | 29.2972 | -110.3309 | 2021-02-07 05:23:00 | Sonora, Mexico | ||
1588275 | 1588275 | 2021-02-05 | Mexico | Sonora | 64372 | 5472 | 0 | 58900 | 29.2972 | -110.3309 | 2021-02-06 05:23:55 | 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 | ||
340374 | 340374 | 2021-02-03 | Mexico | Sonora | 63637 | 5345 | 0 | 58292 | 29.2972 | -110.3309 | 2021-02-04 05:22:26 | Sonora, Mexico | ||
1684600 | 1684600 | 2021-02-02 | Mexico | Sonora | 63309 | 5298 | 0 | 58011 | 29.2972 | -110.3309 | 2021-02-03 05:22:52 | Sonora, Mexico | ||
1676570 | 1676570 | 2021-02-01 | Mexico | Sonora | 63062 | 5290 | 0 | 57772 | 29.2972 | -110.3309 | 2021-02-02 05:22:49 | Sonora, Mexico | ||
1459858 | 1459858 | 2021-01-31 | Mexico | Sonora | 62912 | 5277 | 0 | 57635 | 29.2972 | -110.3309 | 2021-02-01 05:22:53 | Sonora, Mexico | ||
2211766 | 2211766 | 2021-01-30 | Mexico | Sonora | 62602 | 5260 | 0 | 57342 | 29.2972 | -110.3309 | 2021-01-31 05:22:42 | Sonora, Mexico | ||
1897253 | 1897253 | 2021-01-29 | Mexico | Sonora | 62177 | 5230 | 0 | 56947 | 29.2972 | -110.3309 | 2021-01-30 05:22:49 | Sonora, Mexico | ||
2482069 | 2482069 | 2021-01-28 | Mexico | Sonora | 61746 | 5213 | 0 | 56533 | 29.2972 | -110.3309 | 2021-01-29 05:22:23 | Sonora, Mexico | ||
3153704 | 3153704 | 2021-01-27 | Mexico | Sonora | 61345 | 5192 | 0 | 56153 | 29.2972 | -110.3309 | 2021-01-28 05:22:24 | Sonora, Mexico | ||
12439 | 12439 | 2021-01-26 | Mexico | Sonora | 61003 | 5150 | 0 | 55853 | 29.2972 | -110.3309 | 2021-01-27 05:23:41 | Sonora, Mexico | ||
2567763 | 2567763 | 2021-01-25 | Mexico | Sonora | 60706 | 5123 | 0 | 55583 | 29.2972 | -110.3309 | 2021-01-26 05:22:02 | Sonora, Mexico | ||
1759395 | 1759395 | 2021-01-24 | Mexico | Sonora | 60582 | 5110 | 0 | 55472 | 29.2972 | -110.3309 | 2021-01-25 05:22:16 | Sonora, Mexico | ||
2427002 | 2427002 | 2021-01-23 | Mexico | Sonora | 60368 | 5093 | 0 | 55275 | 29.2972 | -110.3309 | 2021-01-24 05:22:35 | Sonora, Mexico | ||
2466904 | 2466904 | 2021-01-22 | Mexico | Sonora | 59929 | 5055 | 0 | 54874 | 29.2972 | -110.3309 | 2021-01-23 05:22:03 | 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 | ||
1094187 | 1094187 | 2021-01-20 | Mexico | Sonora | 58806 | 4810 | 0 | 53996 | 29.2972 | -110.3309 | 2021-01-21 05:22:01 | Sonora, Mexico | ||
908277 | 908277 | 2021-01-19 | Mexico | Sonora | 58365 | 4757 | 0 | 53608 | 29.2972 | -110.3309 | 2021-01-20 05:21:54 | Sonora, Mexico | ||
237340 | 237340 | 2021-01-18 | Mexico | Sonora | 57748 | 4692 | 0 | 53056 | 29.2972 | -110.3309 | 2021-01-19 05:22:15 | Sonora, Mexico | ||
3503457 | 3503457 | 2021-01-17 | Mexico | Sonora | 57524 | 4671 | 0 | 52853 | 29.2972 | -110.3309 | 2021-01-18 05:22:34 | Sonora, Mexico | ||
3101540 | 3101540 | 2021-01-16 | Mexico | Sonora | 57342 | 4643 | 0 | 52699 | 29.2972 | -110.3309 | 2021-01-17 05:22:17 | Sonora, Mexico | ||
3515502 | 3515502 | 2021-01-15 | Mexico | Sonora | 56828 | 4547 | 0 | 52281 | 29.2972 | -110.3309 | 2021-01-16 05:22:40 | Sonora, Mexico | ||
3879675 | 3879675 | 2021-01-14 | Mexico | Sonora | 56377 | 4522 | 0 | 51855 | 29.2972 | -110.3309 | 2021-01-15 05:22:24 | Sonora, Mexico | ||
3308302 | 3308302 | 2021-01-13 | Mexico | Sonora | 56089 | 4479 | 0 | 51610 | 29.2972 | -110.3309 | 2021-01-14 05:22:32 | 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 | ||
190168 | 190168 | 2021-01-11 | Mexico | Sonora | 55279 | 4432 | 0 | 50847 | 29.2972 | -110.3309 | 2021-01-12 05:22:15 | Sonora, Mexico | ||
2625971 | 2625971 | 2021-01-10 | Mexico | Sonora | 54903 | 4408 | 0 | 50495 | 29.2972 | -110.3309 | 2021-01-11 05:21:50 | Sonora, Mexico | ||
3900059 | 3900059 | 2021-01-09 | Mexico | Sonora | 54505 | 4380 | 0 | 50125 | 29.2972 | -110.3309 | 2021-01-10 05:22:12 | Sonora, Mexico | ||
154082 | 154082 | 2021-01-08 | Mexico | Sonora | 54186 | 4358 | 0 | 49828 | 29.2972 | -110.3309 | 2021-01-09 05:22:18 | Sonora, Mexico | ||
2541506 | 2541506 | 2021-01-07 | Mexico | Sonora | 53674 | 4316 | 0 | 49358 | 29.2972 | -110.3309 | 2021-01-08 05:22:42 | Sonora, Mexico | ||
2864815 | 2864815 | 2021-01-06 | Mexico | Sonora | 53468 | 4296 | 0 | 49172 | 29.2972 | -110.3309 | 2021-01-07 05:22:03 | Sonora, Mexico | ||
3034402 | 3034402 | 2021-01-05 | Mexico | Sonora | 53185 | 4267 | 0 | 48918 | 29.2972 | -110.3309 | 2021-01-06 05:22:16 | Sonora, Mexico | ||
1061947 | 1061947 | 2021-01-04 | Mexico | Sonora | 52864 | 4229 | 0 | 48635 | 29.2972 | -110.3309 | 2021-01-05 05:21:49 | Sonora, Mexico | ||
3230550 | 3230550 | 2021-01-03 | Mexico | Sonora | 52632 | 4221 | 0 | 48411 | 29.2972 | -110.3309 | 2021-01-04 05:22:02 | Sonora, Mexico | ||
2227619 | 2227619 | 2021-01-02 | Mexico | Sonora | 52380 | 4209 | 0 | 48171 | 29.2972 | -110.3309 | 2021-01-03 05:22:52 | Sonora, Mexico | ||
1136983 | 1136983 | 2021-01-01 | Mexico | Sonora | 52146 | 4196 | 0 | 47950 | 29.2972 | -110.3309 | 2021-01-02 05:22:33 | Sonora, Mexico | ||
3695589 | 3695589 | 2020-12-31 | Mexico | Sonora | 51708 | 4161 | 0 | 47547 | 29.2972 | -110.3309 | 2021-01-01 05:23:07 | Sonora, Mexico | ||
1010404 | 1010404 | 2020-12-30 | Mexico | Sonora | 51480 | 4096 | 0 | 47384 | 29.2972 | -110.3309 | 2020-12-31 05:22:49 | 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 | ||
3761683 | 3761683 | 2020-12-28 | Mexico | Sonora | 50842 | 4011 | 0 | 46831 | 29.2972 | -110.3309 | 2020-12-29 05:22:37 | Sonora, Mexico | ||
3778003 | 3778003 | 2020-12-27 | Mexico | Sonora | 50345 | 4003 | 0 | 46342 | 29.2972 | -110.3309 | 2020-12-28 05:22:06 | Sonora, Mexico | ||
2223608 | 2223608 | 2020-12-26 | Mexico | Sonora | 50100 | 3987 | 0 | 46113 | 29.2972 | -110.3309 | 2020-12-27 05:22:55 | Sonora, Mexico | ||
202355 | 202355 | 2020-12-25 | Mexico | Sonora | 50081 | 3981 | 0 | 46100 | 29.2972 | -110.3309 | 2020-12-26 05:22:28 | Sonora, Mexico | ||
3691578 | 3691578 | 2020-12-24 | Mexico | Sonora | 49765 | 3946 | 0 | 45819 | 29.2972 | -110.3309 | 2020-12-25 05:22:48 | Sonora, Mexico | ||
2406930 | 2406930 | 2020-12-23 | Mexico | Sonora | 49425 | 3927 | 0 | 45498 | 29.2972 | -110.3309 | 2020-12-24 05:23:04 | Sonora, Mexico | ||
3769976 | 3769976 | 2020-12-22 | Mexico | Sonora | 49063 | 3883 | 0 | 45180 | 29.2972 | -110.3309 | 2020-12-23 05:22:03 | Sonora, Mexico | ||
927792 | 927792 | 2020-12-21 | Mexico | Sonora | 48905 | 3848 | 0 | 45057 | 29.2972 | -110.3309 | 2020-12-22 05:22:33 | Sonora, Mexico | ||
2119813 | 2119813 | 2020-12-20 | Mexico | Sonora | 48594 | 3841 | 0 | 44753 | 29.2972 | -110.3309 | 2020-12-21 05:27:58 | Sonora, Mexico | ||
2931320 | 2931320 | 2020-12-19 | Mexico | Sonora | 48368 | 3825 | 0 | 44543 | 29.2972 | -110.3309 | 2020-12-20 05:27:32 | Sonora, Mexico | ||
1901266 | 1901266 | 2020-12-18 | Mexico | Sonora | 48164 | 3814 | 0 | 44350 | 29.2972 | -110.3309 | 2020-12-19 05:27:52 | Sonora, Mexico | ||
2128092 | 2128092 | 2020-12-17 | Mexico | Sonora | 47834 | 3769 | 0 | 44065 | 29.2972 | -110.3309 | 2020-12-18 05:28:18 | Sonora, Mexico | ||
3149692 | 3149692 | 2020-12-16 | Mexico | Sonora | 47476 | 3759 | 0 | 43717 | 29.2972 | -110.3309 | 2020-12-17 05:28:12 | Sonora, Mexico | ||
1034473 | 1034473 | 2020-12-15 | Mexico | Sonora | 47289 | 3734 | 0 | 43555 | 29.2972 | -110.3309 | 2020-12-16 05:28:04 | Sonora, Mexico | ||
1751367 | 1751367 | 2020-12-14 | Mexico | Sonora | 47195 | 3700 | 0 | 43495 | 29.2972 | -110.3309 | 2020-12-15 05:26:38 | Sonora, Mexico | ||
3847887 | 3847887 | 2020-12-13 | Mexico | Sonora | 47113 | 3698 | 0 | 43415 | 29.2972 | -110.3309 | 2020-12-14 05:26:27 | Sonora, Mexico | ||
845669 | 845669 | 2020-12-12 | Mexico | Sonora | 47008 | 3686 | 0 | 43322 | 29.2972 | -110.3309 | 2020-12-13 05:27:20 | Sonora, Mexico | ||
860776 | 860776 | 2020-12-11 | Mexico | Sonora | 46729 | 3650 | 0 | 43079 | 29.2972 | -110.3309 | 2020-12-12 05:26:19 | Sonora, Mexico | ||
1600318 | 1600318 | 2020-12-10 | Mexico | Sonora | 46384 | 3622 | 0 | 42762 | 29.2972 | -110.3309 | 2020-12-11 05:26:59 | Sonora, Mexico | ||
2975327 | 2975327 | 2020-12-09 | Mexico | Sonora | 46296 | 3594 | 0 | 42702 | 29.2972 | -110.3309 | 2020-12-10 05:26:19 | Sonora, Mexico | ||
1818887 | 1818887 | 2020-12-08 | Mexico | Sonora | 45880 | 3574 | 0 | 42306 | 29.2972 | -110.3309 | 2020-12-09 05:28:01 | Sonora, Mexico | ||
2347523 | 2347523 | 2020-12-07 | Mexico | Sonora | 45641 | 3549 | 0 | 42092 | 29.2972 | -110.3309 | 2020-12-08 05:27:42 | Sonora, Mexico | ||
1006393 | 1006393 | 2020-12-06 | Mexico | Sonora | 45219 | 3538 | 0 | 41681 | 29.2972 | -110.3309 | 2020-12-07 05:26:14 | Sonora, Mexico | ||
1632402 | 1632402 | 2020-12-05 | Mexico | Sonora | 45122 | 3534 | 0 | 41588 | 29.2972 | -110.3309 | 2020-12-06 05:26:18 | Sonora, Mexico | ||
3859930 | 3859930 | 2020-12-04 | Mexico | Sonora | 44795 | 3508 | 0 | 41287 | 29.2972 | -110.3309 | 2020-12-05 05:27:36 | Sonora, Mexico | ||
75188 | 75188 | 2020-12-03 | Mexico | Sonora | 44476 | 3472 | 0 | 41004 | 29.2972 | -110.3309 | 2020-12-04 05:27:27 | 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 | ||
2537494 | 2537494 | 2020-12-01 | Mexico | Sonora | 43677 | 3449 | 0 | 40228 | 29.2972 | -110.3309 | 2020-12-02 05:27:41 | Sonora, Mexico | ||
1584263 | 1584263 | 2020-11-30 | Mexico | Sonora | 43459 | 3433 | 0 | 40026 | 29.2972 | -110.3309 | 2020-12-01 05:26:18 | Sonora, Mexico | ||
3566666 | 3566666 | 2020-11-29 | Mexico | Sonora | 42974 | 3415 | 0 | 39559 | 29.2972 | -110.3309 | 2020-11-30 05:26:13 | Sonora, Mexico | ||
2935331 | 2935331 | 2020-11-28 | Mexico | Sonora | 42780 | 3444 | 0 | 39336 | 29.2972 | -110.3309 | 2020-11-29 05:25:55 | Sonora, Mexico | ||
392334 | 392334 | 2020-11-27 | Mexico | Sonora | 42540 | 3437 | 0 | 39103 | 29.2972 | -110.3309 | 2020-11-28 05:25:50 | Sonora, Mexico | ||
923781 | 923781 | 2020-11-26 | Mexico | Sonora | 42286 | 3387 | 0 | 38899 | 29.2972 | -110.3309 | 2020-11-27 05:26:53 | Sonora, Mexico | ||
1972686 | 1972686 | 2020-11-25 | Mexico | Sonora | 42127 | 3364 | 0 | 38763 | 29.2972 | -110.3309 | 2020-11-26 05:27:44 | Sonora, Mexico | ||
1350417 | 1350417 | 2020-11-24 | Mexico | Sonora | 41908 | 3351 | 0 | 38557 | 29.2972 | -110.3309 | 2020-11-25 05:27:20 | 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 | ||
3190087 | 3190087 | 2020-11-22 | Mexico | Sonora | 41476 | 3320 | 0 | 38156 | 29.2972 | -110.3309 | 2020-11-23 05:25:26 | Sonora, Mexico | ||
3836581 | 3836581 | 2020-11-21 | Mexico | Sonora | 41262 | 3347 | 0 | 37915 | 29.2972 | -110.3309 | 2020-11-22 05:25:45 | Sonora, Mexico | ||
2701609 | 2701609 | 2020-11-20 | Mexico | Sonora | 41118 | 3306 | 0 | 37812 | 29.2972 | -110.3309 | 2020-11-21 05:25:51 | 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 | ||
122803 | 122803 | 2020-11-18 | Mexico | Sonora | 40757 | 3274 | 0 | 37483 | 29.2972 | -110.3309 | 2020-11-19 05:25:23 | 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]);