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 = "Guerrero" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2533485 | 2533485 | 2022-05-12 | Mexico | Guerrero | 98402 | 6758 | 0 | 17.4392 | -99.5451 | 2022-05-13 04:20:51 | Guerrero, Mexico | |||
3444931 | 3444931 | 2022-05-11 | Mexico | Guerrero | 98402 | 6758 | 0 | 17.4392 | -99.5451 | 2022-05-12 04:20:54 | Guerrero, Mexico | |||
3535548 | 3535548 | 2022-05-10 | Mexico | Guerrero | 98402 | 6758 | 0 | 17.4392 | -99.5451 | 2022-05-11 04:20:48 | Guerrero, Mexico | |||
222083 | 222083 | 2022-05-09 | Mexico | Guerrero | 98402 | 6758 | 0 | 17.4392 | -99.5451 | 2022-05-10 04:20:50 | Guerrero, Mexico | |||
2331468 | 2331468 | 2022-05-08 | Mexico | Guerrero | 98380 | 6756 | 0 | 17.4392 | -99.5451 | 2022-05-09 04:20:54 | Guerrero, Mexico | |||
360430 | 360430 | 2022-05-07 | Mexico | Guerrero | 98380 | 6756 | 0 | 17.4392 | -99.5451 | 2022-05-08 04:20:49 | Guerrero, Mexico | |||
1397781 | 1397781 | 2022-05-06 | Mexico | Guerrero | 98380 | 6756 | 0 | 17.4392 | -99.5451 | 2022-05-07 04:21:09 | Guerrero, Mexico | |||
2598136 | 2598136 | 2022-05-05 | Mexico | Guerrero | 98380 | 6756 | 0 | 17.4392 | -99.5451 | 2022-05-06 04:21:00 | Guerrero, Mexico | |||
3265585 | 3265585 | 2022-05-04 | Mexico | Guerrero | 98380 | 6756 | 0 | 17.4392 | -99.5451 | 2022-05-05 04:20:55 | Guerrero, Mexico | |||
1572224 | 1572224 | 2022-05-03 | Mexico | Guerrero | 98380 | 6756 | 0 | 17.4392 | -99.5451 | 2022-05-04 04:20:59 | Guerrero, Mexico | |||
463484 | 463484 | 2022-05-02 | Mexico | Guerrero | 98381 | 6756 | 0 | 17.4392 | -99.5451 | 2022-05-03 04:21:00 | Guerrero, Mexico | |||
3916123 | 3916123 | 2022-05-01 | Mexico | Guerrero | 98380 | 6756 | 0 | 17.4392 | -99.5451 | 2022-05-02 04:21:10 | Guerrero, Mexico | |||
2840927 | 2840927 | 2022-04-30 | Mexico | Guerrero | 98380 | 6756 | 0 | 17.4392 | -99.5451 | 2022-05-01 04:20:57 | Guerrero, Mexico | |||
1157240 | 1157240 | 2022-04-29 | Mexico | Guerrero | 98379 | 6756 | 0 | 17.4392 | -99.5451 | 2022-04-30 04:21:05 | Guerrero, Mexico | |||
1696422 | 1696422 | 2022-04-28 | Mexico | Guerrero | 98375 | 6756 | 0 | 17.4392 | -99.5451 | 2022-04-29 04:20:59 | Guerrero, Mexico | |||
3851905 | 3851905 | 2022-04-27 | Mexico | Guerrero | 98365 | 6756 | 0 | 17.4392 | -99.5451 | 2022-04-28 04:20:47 | Guerrero, Mexico | |||
1326335 | 1326335 | 2022-04-26 | Mexico | Guerrero | 98356 | 6755 | 0 | 17.4392 | -99.5451 | 2022-04-27 04:20:52 | Guerrero, Mexico | |||
3722289 | 3722289 | 2022-04-25 | Mexico | Guerrero | 98351 | 6755 | 0 | 17.4392 | -99.5451 | 2022-04-26 04:20:51 | Guerrero, Mexico | |||
2028857 | 2028857 | 2022-04-24 | Mexico | Guerrero | 98351 | 6755 | 0 | 17.4392 | -99.5451 | 2022-04-25 04:20:56 | Guerrero, Mexico | |||
746432 | 746432 | 2022-04-23 | Mexico | Guerrero | 98351 | 6755 | 0 | 17.4392 | -99.5451 | 2022-04-24 04:20:56 | Guerrero, Mexico | |||
3436917 | 3436917 | 2022-04-22 | Mexico | Guerrero | 98341 | 6755 | 0 | 17.4392 | -99.5451 | 2022-04-23 04:20:50 | Guerrero, Mexico | |||
2892502 | 2892502 | 2022-04-21 | Mexico | Guerrero | 98341 | 6755 | 0 | 17.4392 | -99.5451 | 2022-04-22 04:20:45 | Guerrero, Mexico | |||
2307374 | 2307374 | 2022-04-20 | Mexico | Guerrero | 98372 | 6755 | 0 | 17.4392 | -99.5451 | 2022-04-21 04:20:46 | Guerrero, Mexico | |||
2251513 | 2251513 | 2022-04-19 | Mexico | Guerrero | 98368 | 6755 | 0 | 17.4392 | -99.5451 | 2022-04-20 04:20:45 | Guerrero, Mexico | |||
1846063 | 1846063 | 2022-04-18 | Mexico | Guerrero | 98359 | 6754 | 0 | 17.4392 | -99.5451 | 2022-04-19 04:21:00 | Guerrero, Mexico | |||
3417007 | 3417007 | 2022-04-17 | Mexico | Guerrero | 98359 | 6754 | 0 | 17.4392 | -99.5451 | 2022-04-18 04:21:12 | Guerrero, Mexico | |||
303956 | 303956 | 2022-04-16 | Mexico | Guerrero | 98359 | 6754 | 0 | 17.4392 | -99.5451 | 2022-04-17 04:20:59 | Guerrero, Mexico | |||
2669901 | 2669901 | 2022-04-15 | Mexico | Guerrero | 98356 | 6754 | 0 | 17.4392 | -99.5451 | 2022-04-16 04:20:48 | Guerrero, Mexico | |||
1223686 | 1223686 | 2022-04-14 | Mexico | Guerrero | 98354 | 6754 | 0 | 17.4392 | -99.5451 | 2022-04-15 04:20:57 | Guerrero, Mexico | |||
2442844 | 2442844 | 2022-04-13 | Mexico | Guerrero | 98352 | 6754 | 0 | 17.4392 | -99.5451 | 2022-04-13 23:21:06 | Guerrero, Mexico | |||
1948601 | 1948601 | 2022-04-12 | Mexico | Guerrero | 98351 | 6754 | 0 | 17.4392 | -99.5451 | 2022-04-13 04:21:03 | Guerrero, Mexico | |||
3206354 | 3206354 | 2022-04-11 | Mexico | Guerrero | 98350 | 6751 | 0 | 17.4392 | -99.5451 | 2022-04-12 04:20:49 | Guerrero, Mexico | |||
1576240 | 1576240 | 2022-04-10 | Mexico | Guerrero | 98349 | 6751 | 0 | 17.4392 | -99.5451 | 2022-04-11 04:21:02 | Guerrero, Mexico | |||
1652482 | 1652482 | 2022-04-09 | Mexico | Guerrero | 98348 | 6751 | 0 | 17.4392 | -99.5451 | 2022-04-10 04:20:52 | Guerrero, Mexico | |||
2115804 | 2115804 | 2022-04-08 | Mexico | Guerrero | 98324 | 6751 | 0 | 17.4392 | -99.5451 | 2022-04-09 04:20:42 | Guerrero, Mexico | |||
3320328 | 3320328 | 2022-04-07 | Mexico | Guerrero | 98338 | 6751 | 0 | 17.4392 | -99.5451 | 2022-04-08 04:20:48 | Guerrero, Mexico | |||
2800864 | 2800864 | 2022-04-06 | Mexico | Guerrero | 98299 | 6748 | 0 | 17.4392 | -99.5451 | 2022-04-07 04:20:53 | Guerrero, Mexico | |||
3867633 | 3867633 | 2022-04-05 | Mexico | Guerrero | 98346 | 6747 | 0 | 17.4392 | -99.5451 | 2022-04-06 04:20:49 | Guerrero, Mexico | |||
2748975 | 2748975 | 2022-04-04 | Mexico | Guerrero | 98315 | 6747 | 0 | 17.4392 | -99.5451 | 2022-04-05 04:20:48 | Guerrero, Mexico | |||
3730321 | 3730321 | 2022-04-03 | Mexico | Guerrero | 98315 | 6747 | 0 | 17.4392 | -99.5451 | 2022-04-04 04:20:51 | Guerrero, Mexico | |||
499756 | 499756 | 2022-04-02 | Mexico | Guerrero | 98315 | 6746 | 0 | 17.4392 | -99.5451 | 2022-04-03 04:20:48 | Guerrero, Mexico | |||
3350741 | 3350741 | 2022-04-01 | Mexico | Guerrero | 98285 | 6724 | 0 | 17.4392 | -99.5451 | 2022-04-02 04:20:47 | Guerrero, Mexico | |||
1540046 | 1540046 | 2022-03-31 | Mexico | Guerrero | 98281 | 6723 | 0 | 17.4392 | -99.5451 | 2022-04-01 04:20:28 | Guerrero, Mexico | |||
2478059 | 2478059 | 2022-03-30 | Mexico | Guerrero | 98233 | 6701 | 0 | 17.4392 | -99.5451 | 2022-03-31 04:20:56 | Guerrero, Mexico | |||
158100 | 158100 | 2022-03-29 | Mexico | Guerrero | 98233 | 6701 | 0 | 17.4392 | -99.5451 | 2022-03-30 04:20:45 | Guerrero, Mexico | |||
1436671 | 1436671 | 2022-03-28 | Mexico | Guerrero | 98224 | 6701 | 0 | 17.4392 | -99.5451 | 2022-03-29 04:20:46 | Guerrero, Mexico | |||
876352 | 876352 | 2022-03-27 | Mexico | Guerrero | 98223 | 6701 | 0 | 17.4392 | -99.5451 | 2022-03-28 04:20:33 | Guerrero, Mexico | |||
2163635 | 2163635 | 2022-03-26 | Mexico | Guerrero | 98217 | 6701 | 0 | 17.4392 | -99.5451 | 2022-03-27 04:20:47 | Guerrero, Mexico | |||
1720571 | 1720571 | 2022-03-25 | Mexico | Guerrero | 98217 | 6701 | 0 | 17.4392 | -99.5451 | 2022-03-26 04:20:23 | Guerrero, Mexico | |||
1468188 | 1468188 | 2022-03-24 | Mexico | Guerrero | 98181 | 6699 | 0 | 17.4392 | -99.5451 | 2022-03-25 04:20:46 | Guerrero, Mexico | |||
3022362 | 3022362 | 2022-03-23 | Mexico | Guerrero | 98164 | 6699 | 0 | 17.4392 | -99.5451 | 2022-03-24 04:20:43 | Guerrero, Mexico | |||
1905284 | 1905284 | 2022-03-22 | Mexico | Guerrero | 98164 | 6699 | 0 | 17.4392 | -99.5451 | 2022-03-23 04:20:48 | Guerrero, Mexico | |||
3238415 | 3238415 | 2022-03-21 | Mexico | Guerrero | 98162 | 6699 | 0 | 17.4392 | -99.5451 | 2022-03-22 04:20:54 | Guerrero, Mexico | |||
24488 | 24488 | 2022-03-20 | Mexico | Guerrero | 98160 | 6699 | 0 | 17.4392 | -99.5451 | 2022-03-21 04:20:50 | Guerrero, Mexico | |||
1656498 | 1656498 | 2022-03-19 | Mexico | Guerrero | 98128 | 6698 | 0 | 17.4392 | -99.5451 | 2022-03-20 04:20:45 | Guerrero, Mexico | |||
336024 | 336024 | 2022-03-18 | Mexico | Guerrero | 98103 | 6697 | 0 | 17.4392 | -99.5451 | 2022-03-19 04:20:47 | Guerrero, Mexico | |||
694477 | 694477 | 2022-03-17 | Mexico | Guerrero | 98103 | 6697 | 0 | 17.4392 | -99.5451 | 2022-03-18 04:20:55 | Guerrero, Mexico | |||
2319420 | 2319420 | 2022-03-16 | Mexico | Guerrero | 98048 | 6689 | 0 | 17.4392 | -99.5451 | 2022-03-17 04:20:56 | Guerrero, Mexico | |||
261620 | 261620 | 2022-03-15 | Mexico | Guerrero | 97979 | 6684 | 0 | 17.4392 | -99.5451 | 2022-03-16 04:20:50 | Guerrero, Mexico | |||
2263979 | 2263979 | 2022-03-14 | Mexico | Guerrero | 97979 | 6684 | 0 | 17.4392 | -99.5451 | 2022-03-15 04:20:47 | Guerrero, Mexico | |||
3628045 | 3628045 | 2022-03-13 | Mexico | Guerrero | 97974 | 6684 | 0 | 17.4392 | -99.5451 | 2022-03-14 04:20:46 | Guerrero, Mexico | |||
950953 | 950953 | 2022-03-12 | Mexico | Guerrero | 97971 | 6684 | 0 | 17.4392 | -99.5451 | 2022-03-13 04:20:49 | Guerrero, Mexico | |||
356414 | 356414 | 2022-03-11 | Mexico | Guerrero | 97921 | 6678 | 0 | 17.4392 | -99.5451 | 2022-03-12 04:20:50 | Guerrero, Mexico | |||
1865566 | 1865566 | 2022-03-10 | Mexico | Guerrero | 97921 | 6678 | 0 | 17.4392 | -99.5451 | 2022-03-11 04:20:50 | Guerrero, Mexico | |||
2140261 | 2140261 | 2022-03-09 | Mexico | Guerrero | 97817 | 6678 | 0 | 17.4392 | -99.5451 | 2022-03-10 04:20:48 | Guerrero, Mexico | |||
919772 | 919772 | 2022-03-08 | Mexico | Guerrero | 97719 | 6676 | 0 | 17.4392 | -99.5451 | 2022-03-09 04:20:59 | Guerrero, Mexico | |||
1548059 | 1548059 | 2022-03-07 | Mexico | Guerrero | 97614 | 6676 | 0 | 17.4392 | -99.5451 | 2022-03-08 04:20:54 | Guerrero, Mexico | |||
2199728 | 2199728 | 2022-03-06 | Mexico | Guerrero | 97611 | 6676 | 0 | 17.4392 | -99.5451 | 2022-03-07 04:20:47 | Guerrero, Mexico | |||
2092185 | 2092185 | 2022-03-05 | Mexico | Guerrero | 97472 | 6674 | 0 | 17.4392 | -99.5451 | 2022-03-06 04:20:49 | Guerrero, Mexico | |||
2665885 | 2665885 | 2022-03-04 | Mexico | Guerrero | 97314 | 6673 | 0 | 17.4392 | -99.5451 | 2022-03-05 04:21:10 | Guerrero, Mexico | |||
1644450 | 1644450 | 2022-03-03 | Mexico | Guerrero | 97186 | 6666 | 0 | 17.4392 | -99.5451 | 2022-03-04 04:21:09 | Guerrero, Mexico | |||
2525453 | 2525453 | 2022-03-02 | Mexico | Guerrero | 97036 | 6658 | 0 | 17.4392 | -99.5451 | 2022-03-03 04:21:01 | Guerrero, Mexico | |||
1992747 | 1992747 | 2022-03-01 | Mexico | Guerrero | 97036 | 6658 | 0 | 17.4392 | -99.5451 | 2022-03-02 04:21:07 | Guerrero, Mexico | |||
942921 | 942921 | 2022-02-28 | Mexico | Guerrero | 96934 | 6645 | 0 | 17.4392 | -99.5451 | 2022-03-01 04:21:09 | Guerrero, Mexico | |||
2733112 | 2733112 | 2022-02-27 | Mexico | Guerrero | 96846 | 6641 | 0 | 17.4392 | -99.5451 | 2022-02-28 04:21:05 | Guerrero, Mexico | |||
3046265 | 3046265 | 2022-02-26 | Mexico | Guerrero | 96789 | 6640 | 0 | 17.4392 | -99.5451 | 2022-02-27 04:21:04 | Guerrero, Mexico | |||
574920 | 574920 | 2022-02-25 | Mexico | Guerrero | 96623 | 6634 | 0 | 17.4392 | -99.5451 | 2022-02-26 04:21:12 | Guerrero, Mexico | |||
1511496 | 1511496 | 2022-02-24 | Mexico | Guerrero | 96424 | 6612 | 0 | 17.4392 | -99.5451 | 2022-02-25 04:21:11 | Guerrero, Mexico | |||
1057937 | 1057937 | 2022-02-23 | Mexico | Guerrero | 96247 | 6604 | 0 | 17.4392 | -99.5451 | 2022-02-24 04:21:14 | Guerrero, Mexico | |||
2446860 | 2446860 | 2022-02-22 | Mexico | Guerrero | 95654 | 6590 | 0 | 17.4392 | -99.5451 | 2022-02-23 04:21:09 | Guerrero, Mexico | |||
3718273 | 3718273 | 2022-02-21 | Mexico | Guerrero | 95478 | 6589 | 0 | 17.4392 | -99.5451 | 2022-02-22 04:21:01 | Guerrero, Mexico | |||
3912107 | 3912107 | 2022-02-20 | Mexico | Guerrero | 95478 | 6589 | 0 | 17.4392 | -99.5451 | 2022-02-21 04:21:05 | Guerrero, Mexico | |||
3875665 | 3875665 | 2022-02-19 | Mexico | Guerrero | 95287 | 6588 | 0 | 17.4392 | -99.5451 | 2022-02-20 04:21:00 | Guerrero, Mexico | |||
3855921 | 3855921 | 2022-02-18 | Mexico | Guerrero | 94828 | 6568 | 0 | 17.4392 | -99.5451 | 2022-02-19 04:21:11 | Guerrero, Mexico | |||
1298140 | 1298140 | 2022-02-17 | Mexico | Guerrero | 94828 | 6568 | 0 | 17.4392 | -99.5451 | 2022-02-18 04:21:04 | Guerrero, Mexico | |||
3820526 | 3820526 | 2022-02-16 | Mexico | Guerrero | 94511 | 6561 | 0 | 17.4392 | -99.5451 | 2022-02-17 04:20:56 | Guerrero, Mexico | |||
3671740 | 3671740 | 2022-02-15 | Mexico | Guerrero | 94069 | 6527 | 0 | 17.4392 | -99.5451 | 2022-02-16 04:21:10 | Guerrero, Mexico | |||
2641841 | 2641841 | 2022-02-14 | Mexico | Guerrero | 93980 | 6523 | 0 | 17.4392 | -99.5451 | 2022-02-15 04:21:09 | Guerrero, Mexico | |||
186158 | 186158 | 2022-02-13 | Mexico | Guerrero | 93885 | 6521 | 0 | 17.4392 | -99.5451 | 2022-02-14 04:20:51 | Guerrero, Mexico | |||
316004 | 316004 | 2022-02-12 | Mexico | Guerrero | 93885 | 6521 | 0 | 17.4392 | -99.5451 | 2022-02-13 04:21:00 | Guerrero, Mexico | |||
233330 | 233330 | 2022-02-11 | Mexico | Guerrero | 93284 | 6497 | 0 | 17.4392 | -99.5451 | 2022-02-12 04:21:06 | Guerrero, Mexico | |||
1464172 | 1464172 | 2022-02-10 | Mexico | Guerrero | 92903 | 6484 | 0 | 17.4392 | -99.5451 | 2022-02-11 04:21:09 | Guerrero, Mexico | |||
3074133 | 3074133 | 2022-02-09 | Mexico | Guerrero | 92903 | 6484 | 0 | 17.4392 | -99.5451 | 2022-02-10 04:21:14 | Guerrero, Mexico | |||
1362440 | 1362440 | 2022-02-08 | Mexico | Guerrero | 92505 | 6476 | 0 | 17.4392 | -99.5451 | 2022-02-09 04:21:04 | Guerrero, Mexico | |||
71178 | 71178 | 2022-02-07 | Mexico | Guerrero | 92350 | 6460 | 0 | 17.4392 | -99.5451 | 2022-02-08 04:21:15 | Guerrero, Mexico | |||
2012794 | 2012794 | 2022-02-06 | Mexico | Guerrero | 92243 | 6458 | 0 | 17.4392 | -99.5451 | 2022-02-07 04:21:05 | Guerrero, Mexico | |||
1294123 | 1294123 | 2022-02-05 | Mexico | Guerrero | 92068 | 6455 | 0 | 17.4392 | -99.5451 | 2022-02-06 04:21:00 | Guerrero, Mexico | |||
2327451 | 2327451 | 2022-02-04 | Mexico | Guerrero | 91698 | 6447 | 0 | 17.4392 | -99.5451 | 2022-02-05 04:21:05 | Guerrero, Mexico | |||
2474042 | 2474042 | 2022-02-03 | Mexico | Guerrero | 90703 | 6428 | 0 | 17.4392 | -99.5451 | 2022-02-04 04:21:10 | Guerrero, Mexico | |||
459467 | 459467 | 2022-02-02 | Mexico | Guerrero | 90139 | 6423 | 0 | 17.4392 | -99.5451 | 2022-02-03 04:21:21 | Guerrero, 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]);