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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2533499 | 2533499 | 2022-05-12 | Mexico | Sonora | 165650 | 10119 | 0 | 29.2972 | -110.3309 | 2022-05-13 04:20:51 | Sonora, Mexico | |||
3444945 | 3444945 | 2022-05-11 | Mexico | Sonora | 165650 | 10119 | 0 | 29.2972 | -110.3309 | 2022-05-12 04:20:54 | Sonora, Mexico | |||
3535562 | 3535562 | 2022-05-10 | Mexico | Sonora | 165650 | 10119 | 0 | 29.2972 | -110.3309 | 2022-05-11 04:20:48 | Sonora, Mexico | |||
222097 | 222097 | 2022-05-09 | Mexico | Sonora | 165650 | 10119 | 0 | 29.2972 | -110.3309 | 2022-05-10 04:20:50 | Sonora, Mexico | |||
2331482 | 2331482 | 2022-05-08 | Mexico | Sonora | 165598 | 10118 | 0 | 29.2972 | -110.3309 | 2022-05-09 04:20:54 | Sonora, Mexico | |||
360444 | 360444 | 2022-05-07 | Mexico | Sonora | 165598 | 10118 | 0 | 29.2972 | -110.3309 | 2022-05-08 04:20:49 | Sonora, Mexico | |||
1397795 | 1397795 | 2022-05-06 | Mexico | Sonora | 165598 | 10118 | 0 | 29.2972 | -110.3309 | 2022-05-07 04:21:09 | Sonora, Mexico | |||
2598150 | 2598150 | 2022-05-05 | Mexico | Sonora | 165598 | 10118 | 0 | 29.2972 | -110.3309 | 2022-05-06 04:21:00 | Sonora, Mexico | |||
3265599 | 3265599 | 2022-05-04 | Mexico | Sonora | 165598 | 10118 | 0 | 29.2972 | -110.3309 | 2022-05-05 04:20:55 | Sonora, Mexico | |||
1572238 | 1572238 | 2022-05-03 | Mexico | Sonora | 165598 | 10118 | 0 | 29.2972 | -110.3309 | 2022-05-04 04:20:59 | Sonora, Mexico | |||
463498 | 463498 | 2022-05-02 | Mexico | Sonora | 165608 | 10119 | 0 | 29.2972 | -110.3309 | 2022-05-03 04:21:00 | Sonora, Mexico | |||
3916137 | 3916137 | 2022-05-01 | Mexico | Sonora | 165598 | 10118 | 0 | 29.2972 | -110.3309 | 2022-05-02 04:21:10 | Sonora, Mexico | |||
2840941 | 2840941 | 2022-04-30 | Mexico | Sonora | 165598 | 10118 | 0 | 29.2972 | -110.3309 | 2022-05-01 04:20:57 | Sonora, Mexico | |||
1157254 | 1157254 | 2022-04-29 | Mexico | Sonora | 165576 | 10119 | 0 | 29.2972 | -110.3309 | 2022-04-30 04:21:05 | Sonora, Mexico | |||
1696436 | 1696436 | 2022-04-28 | Mexico | Sonora | 165567 | 10119 | 0 | 29.2972 | -110.3309 | 2022-04-29 04:20:59 | Sonora, Mexico | |||
3851919 | 3851919 | 2022-04-27 | Mexico | Sonora | 165558 | 10114 | 0 | 29.2972 | -110.3309 | 2022-04-28 04:20:47 | Sonora, Mexico | |||
1326349 | 1326349 | 2022-04-26 | Mexico | Sonora | 165535 | 10112 | 0 | 29.2972 | -110.3309 | 2022-04-27 04:20:52 | Sonora, Mexico | |||
3722303 | 3722303 | 2022-04-25 | Mexico | Sonora | 165529 | 10112 | 0 | 29.2972 | -110.3309 | 2022-04-26 04:20:51 | Sonora, Mexico | |||
2028871 | 2028871 | 2022-04-24 | Mexico | Sonora | 165529 | 10112 | 0 | 29.2972 | -110.3309 | 2022-04-25 04:20:56 | Sonora, Mexico | |||
746446 | 746446 | 2022-04-23 | Mexico | Sonora | 165529 | 10112 | 0 | 29.2972 | -110.3309 | 2022-04-24 04:20:56 | Sonora, Mexico | |||
3436931 | 3436931 | 2022-04-22 | Mexico | Sonora | 165509 | 10104 | 0 | 29.2972 | -110.3309 | 2022-04-23 04:20:50 | Sonora, Mexico | |||
2892516 | 2892516 | 2022-04-21 | Mexico | Sonora | 165509 | 10104 | 0 | 29.2972 | -110.3309 | 2022-04-22 04:20:45 | Sonora, Mexico | |||
2307388 | 2307388 | 2022-04-20 | Mexico | Sonora | 165489 | 10104 | 0 | 29.2972 | -110.3309 | 2022-04-21 04:20:46 | Sonora, Mexico | |||
2251527 | 2251527 | 2022-04-19 | Mexico | Sonora | 165463 | 10103 | 0 | 29.2972 | -110.3309 | 2022-04-20 04:20:45 | Sonora, Mexico | |||
1846077 | 1846077 | 2022-04-18 | Mexico | Sonora | 165453 | 10104 | 0 | 29.2972 | -110.3309 | 2022-04-19 04:21:00 | Sonora, Mexico | |||
3417021 | 3417021 | 2022-04-17 | Mexico | Sonora | 165453 | 10104 | 0 | 29.2972 | -110.3309 | 2022-04-18 04:21:12 | Sonora, Mexico | |||
303970 | 303970 | 2022-04-16 | Mexico | Sonora | 165444 | 10104 | 0 | 29.2972 | -110.3309 | 2022-04-17 04:20:59 | Sonora, Mexico | |||
2669915 | 2669915 | 2022-04-15 | Mexico | Sonora | 165422 | 10103 | 0 | 29.2972 | -110.3309 | 2022-04-16 04:20:48 | Sonora, Mexico | |||
1223700 | 1223700 | 2022-04-14 | Mexico | Sonora | 165416 | 10103 | 0 | 29.2972 | -110.3309 | 2022-04-15 04:20:57 | Sonora, Mexico | |||
2442858 | 2442858 | 2022-04-13 | Mexico | Sonora | 165404 | 10102 | 0 | 29.2972 | -110.3309 | 2022-04-13 23:21:06 | Sonora, Mexico | |||
1948615 | 1948615 | 2022-04-12 | Mexico | Sonora | 165387 | 10096 | 0 | 29.2972 | -110.3309 | 2022-04-13 04:21:03 | Sonora, Mexico | |||
3206368 | 3206368 | 2022-04-11 | Mexico | Sonora | 165372 | 10096 | 0 | 29.2972 | -110.3309 | 2022-04-12 04:20:49 | Sonora, Mexico | |||
1576254 | 1576254 | 2022-04-10 | Mexico | Sonora | 165372 | 10096 | 0 | 29.2972 | -110.3309 | 2022-04-11 04:21:02 | Sonora, Mexico | |||
1652496 | 1652496 | 2022-04-09 | Mexico | Sonora | 165372 | 10096 | 0 | 29.2972 | -110.3309 | 2022-04-10 04:20:52 | Sonora, Mexico | |||
2115818 | 2115818 | 2022-04-08 | Mexico | Sonora | 165322 | 10095 | 0 | 29.2972 | -110.3309 | 2022-04-09 04:20:42 | Sonora, Mexico | |||
3320342 | 3320342 | 2022-04-07 | Mexico | Sonora | 165219 | 10095 | 0 | 29.2972 | -110.3309 | 2022-04-08 04:20:48 | Sonora, Mexico | |||
2800878 | 2800878 | 2022-04-06 | Mexico | Sonora | 165106 | 10087 | 0 | 29.2972 | -110.3309 | 2022-04-07 04:20:53 | Sonora, Mexico | |||
3867647 | 3867647 | 2022-04-05 | Mexico | Sonora | 165014 | 10086 | 0 | 29.2972 | -110.3309 | 2022-04-06 04:20:49 | Sonora, Mexico | |||
2748989 | 2748989 | 2022-04-04 | Mexico | Sonora | 164906 | 10083 | 0 | 29.2972 | -110.3309 | 2022-04-05 04:20:48 | Sonora, Mexico | |||
3730335 | 3730335 | 2022-04-03 | Mexico | Sonora | 164905 | 10083 | 0 | 29.2972 | -110.3309 | 2022-04-04 04:20:51 | Sonora, Mexico | |||
499770 | 499770 | 2022-04-02 | Mexico | Sonora | 164905 | 10083 | 0 | 29.2972 | -110.3309 | 2022-04-03 04:20:48 | Sonora, Mexico | |||
3350755 | 3350755 | 2022-04-01 | Mexico | Sonora | 164813 | 10081 | 0 | 29.2972 | -110.3309 | 2022-04-02 04:20:47 | Sonora, Mexico | |||
1540060 | 1540060 | 2022-03-31 | Mexico | Sonora | 164729 | 10080 | 0 | 29.2972 | -110.3309 | 2022-04-01 04:20:28 | Sonora, Mexico | |||
2478073 | 2478073 | 2022-03-30 | Mexico | Sonora | 164519 | 10080 | 0 | 29.2972 | -110.3309 | 2022-03-31 04:20:56 | Sonora, Mexico | |||
158114 | 158114 | 2022-03-29 | Mexico | Sonora | 164519 | 10080 | 0 | 29.2972 | -110.3309 | 2022-03-30 04:20:45 | Sonora, Mexico | |||
1436685 | 1436685 | 2022-03-28 | Mexico | Sonora | 164426 | 10077 | 0 | 29.2972 | -110.3309 | 2022-03-29 04:20:46 | Sonora, Mexico | |||
876366 | 876366 | 2022-03-27 | Mexico | Sonora | 164392 | 10076 | 0 | 29.2972 | -110.3309 | 2022-03-28 04:20:33 | Sonora, Mexico | |||
2163649 | 2163649 | 2022-03-26 | Mexico | Sonora | 164278 | 10073 | 0 | 29.2972 | -110.3309 | 2022-03-27 04:20:47 | Sonora, Mexico | |||
1720585 | 1720585 | 2022-03-25 | Mexico | Sonora | 164278 | 10073 | 0 | 29.2972 | -110.3309 | 2022-03-26 04:20:23 | Sonora, Mexico | |||
1468202 | 1468202 | 2022-03-24 | Mexico | Sonora | 163974 | 10060 | 0 | 29.2972 | -110.3309 | 2022-03-25 04:20:46 | Sonora, Mexico | |||
3022376 | 3022376 | 2022-03-23 | Mexico | Sonora | 163832 | 10054 | 0 | 29.2972 | -110.3309 | 2022-03-24 04:20:43 | Sonora, Mexico | |||
1905298 | 1905298 | 2022-03-22 | Mexico | Sonora | 163832 | 10054 | 0 | 29.2972 | -110.3309 | 2022-03-23 04:20:48 | Sonora, Mexico | |||
3238429 | 3238429 | 2022-03-21 | Mexico | Sonora | 163776 | 10053 | 0 | 29.2972 | -110.3309 | 2022-03-22 04:20:54 | Sonora, Mexico | |||
24502 | 24502 | 2022-03-20 | Mexico | Sonora | 163723 | 10053 | 0 | 29.2972 | -110.3309 | 2022-03-21 04:20:50 | Sonora, Mexico | |||
1656512 | 1656512 | 2022-03-19 | Mexico | Sonora | 163641 | 10051 | 0 | 29.2972 | -110.3309 | 2022-03-20 04:20:45 | Sonora, Mexico | |||
336038 | 336038 | 2022-03-18 | Mexico | Sonora | 163557 | 10046 | 0 | 29.2972 | -110.3309 | 2022-03-19 04:20:47 | Sonora, Mexico | |||
694491 | 694491 | 2022-03-17 | Mexico | Sonora | 163557 | 10046 | 0 | 29.2972 | -110.3309 | 2022-03-18 04:20:55 | Sonora, Mexico | |||
2319434 | 2319434 | 2022-03-16 | Mexico | Sonora | 163395 | 10042 | 0 | 29.2972 | -110.3309 | 2022-03-17 04:20:56 | Sonora, Mexico | |||
261634 | 261634 | 2022-03-15 | Mexico | Sonora | 163324 | 10040 | 0 | 29.2972 | -110.3309 | 2022-03-16 04:20:50 | Sonora, Mexico | |||
2263993 | 2263993 | 2022-03-14 | Mexico | Sonora | 163324 | 10040 | 0 | 29.2972 | -110.3309 | 2022-03-15 04:20:47 | Sonora, Mexico | |||
3628059 | 3628059 | 2022-03-13 | Mexico | Sonora | 163322 | 10039 | 0 | 29.2972 | -110.3309 | 2022-03-14 04:20:46 | Sonora, Mexico | |||
950967 | 950967 | 2022-03-12 | Mexico | Sonora | 163312 | 10037 | 0 | 29.2972 | -110.3309 | 2022-03-13 04:20:49 | Sonora, Mexico | |||
356428 | 356428 | 2022-03-11 | Mexico | Sonora | 162934 | 10008 | 0 | 29.2972 | -110.3309 | 2022-03-12 04:20:50 | Sonora, Mexico | |||
1865580 | 1865580 | 2022-03-10 | Mexico | Sonora | 162934 | 10008 | 0 | 29.2972 | -110.3309 | 2022-03-11 04:20:50 | Sonora, Mexico | |||
2140275 | 2140275 | 2022-03-09 | Mexico | Sonora | 162739 | 9995 | 0 | 29.2972 | -110.3309 | 2022-03-10 04:20:48 | Sonora, Mexico | |||
919786 | 919786 | 2022-03-08 | Mexico | Sonora | 162567 | 9974 | 0 | 29.2972 | -110.3309 | 2022-03-09 04:20:59 | Sonora, Mexico | |||
1548073 | 1548073 | 2022-03-07 | Mexico | Sonora | 162444 | 9962 | 0 | 29.2972 | -110.3309 | 2022-03-08 04:20:54 | Sonora, Mexico | |||
2199742 | 2199742 | 2022-03-06 | Mexico | Sonora | 162431 | 9960 | 0 | 29.2972 | -110.3309 | 2022-03-07 04:20:47 | Sonora, Mexico | |||
2092199 | 2092199 | 2022-03-05 | Mexico | Sonora | 162205 | 9956 | 0 | 29.2972 | -110.3309 | 2022-03-06 04:20:49 | Sonora, Mexico | |||
2665899 | 2665899 | 2022-03-04 | Mexico | Sonora | 161956 | 9951 | 0 | 29.2972 | -110.3309 | 2022-03-05 04:21:10 | Sonora, Mexico | |||
1644464 | 1644464 | 2022-03-03 | Mexico | Sonora | 161733 | 9952 | 0 | 29.2972 | -110.3309 | 2022-03-04 04:21:09 | Sonora, Mexico | |||
2525467 | 2525467 | 2022-03-02 | Mexico | Sonora | 161483 | 9943 | 0 | 29.2972 | -110.3309 | 2022-03-03 04:21:01 | Sonora, Mexico | |||
1992761 | 1992761 | 2022-03-01 | Mexico | Sonora | 161483 | 9943 | 0 | 29.2972 | -110.3309 | 2022-03-02 04:21:07 | Sonora, Mexico | |||
942935 | 942935 | 2022-02-28 | Mexico | Sonora | 161176 | 9930 | 0 | 29.2972 | -110.3309 | 2022-03-01 04:21:09 | Sonora, Mexico | |||
2733126 | 2733126 | 2022-02-27 | Mexico | Sonora | 161108 | 9929 | 0 | 29.2972 | -110.3309 | 2022-02-28 04:21:05 | Sonora, Mexico | |||
3046279 | 3046279 | 2022-02-26 | Mexico | Sonora | 161050 | 9924 | 0 | 29.2972 | -110.3309 | 2022-02-27 04:21:04 | Sonora, Mexico | |||
574934 | 574934 | 2022-02-25 | Mexico | Sonora | 160610 | 9916 | 0 | 29.2972 | -110.3309 | 2022-02-26 04:21:12 | Sonora, Mexico | |||
1511510 | 1511510 | 2022-02-24 | Mexico | Sonora | 160300 | 9907 | 0 | 29.2972 | -110.3309 | 2022-02-25 04:21:11 | Sonora, Mexico | |||
1057951 | 1057951 | 2022-02-23 | Mexico | Sonora | 159833 | 9890 | 0 | 29.2972 | -110.3309 | 2022-02-24 04:21:14 | Sonora, Mexico | |||
2446874 | 2446874 | 2022-02-22 | Mexico | Sonora | 158930 | 9869 | 0 | 29.2972 | -110.3309 | 2022-02-23 04:21:09 | Sonora, Mexico | |||
3718287 | 3718287 | 2022-02-21 | Mexico | Sonora | 158872 | 9866 | 0 | 29.2972 | -110.3309 | 2022-02-22 04:21:01 | Sonora, Mexico | |||
3912121 | 3912121 | 2022-02-20 | Mexico | Sonora | 158872 | 9866 | 0 | 29.2972 | -110.3309 | 2022-02-21 04:21:05 | Sonora, Mexico | |||
3875679 | 3875679 | 2022-02-19 | Mexico | Sonora | 158786 | 9861 | 0 | 29.2972 | -110.3309 | 2022-02-20 04:21:00 | Sonora, Mexico | |||
3855935 | 3855935 | 2022-02-18 | Mexico | Sonora | 157673 | 9842 | 0 | 29.2972 | -110.3309 | 2022-02-19 04:21:11 | Sonora, Mexico | |||
1298154 | 1298154 | 2022-02-17 | Mexico | Sonora | 157673 | 9842 | 0 | 29.2972 | -110.3309 | 2022-02-18 04:21:04 | Sonora, Mexico | |||
3820540 | 3820540 | 2022-02-16 | Mexico | Sonora | 157128 | 9832 | 0 | 29.2972 | -110.3309 | 2022-02-17 04:20:56 | Sonora, Mexico | |||
3671754 | 3671754 | 2022-02-15 | Mexico | Sonora | 155883 | 9788 | 0 | 29.2972 | -110.3309 | 2022-02-16 04:21:10 | Sonora, Mexico | |||
2641855 | 2641855 | 2022-02-14 | Mexico | Sonora | 155663 | 9780 | 0 | 29.2972 | -110.3309 | 2022-02-15 04:21:09 | Sonora, Mexico | |||
186172 | 186172 | 2022-02-13 | Mexico | Sonora | 155491 | 9770 | 0 | 29.2972 | -110.3309 | 2022-02-14 04:20:51 | Sonora, Mexico | |||
316018 | 316018 | 2022-02-12 | Mexico | Sonora | 155491 | 9770 | 0 | 29.2972 | -110.3309 | 2022-02-13 04:21:00 | Sonora, Mexico | |||
233344 | 233344 | 2022-02-11 | Mexico | Sonora | 153833 | 9727 | 0 | 29.2972 | -110.3309 | 2022-02-12 04:21:06 | Sonora, Mexico | |||
1464186 | 1464186 | 2022-02-10 | Mexico | Sonora | 152974 | 9696 | 0 | 29.2972 | -110.3309 | 2022-02-11 04:21:09 | Sonora, Mexico | |||
3074147 | 3074147 | 2022-02-09 | Mexico | Sonora | 152974 | 9696 | 0 | 29.2972 | -110.3309 | 2022-02-10 04:21:14 | Sonora, Mexico | |||
1362454 | 1362454 | 2022-02-08 | Mexico | Sonora | 152246 | 9662 | 0 | 29.2972 | -110.3309 | 2022-02-09 04:21:04 | Sonora, Mexico | |||
71192 | 71192 | 2022-02-07 | Mexico | Sonora | 152123 | 9657 | 0 | 29.2972 | -110.3309 | 2022-02-08 04:21:15 | Sonora, Mexico | |||
2012808 | 2012808 | 2022-02-06 | Mexico | Sonora | 151792 | 9644 | 0 | 29.2972 | -110.3309 | 2022-02-07 04:21:05 | Sonora, Mexico | |||
1294137 | 1294137 | 2022-02-05 | Mexico | Sonora | 151576 | 9636 | 0 | 29.2972 | -110.3309 | 2022-02-06 04:21:00 | Sonora, Mexico | |||
2327465 | 2327465 | 2022-02-04 | Mexico | Sonora | 150682 | 9616 | 0 | 29.2972 | -110.3309 | 2022-02-05 04:21:05 | Sonora, Mexico | |||
2474056 | 2474056 | 2022-02-03 | Mexico | Sonora | 148634 | 9558 | 0 | 29.2972 | -110.3309 | 2022-02-04 04:21:10 | Sonora, Mexico | |||
459481 | 459481 | 2022-02-02 | Mexico | Sonora | 147655 | 9536 | 0 | 29.2972 | -110.3309 | 2022-02-03 04:21:21 | 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]);