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 = "Hidalgo" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2533486 | 2533486 | 2022-05-12 | Mexico | Hidalgo | 93553 | 8410 | 0 | 20.0911 | -98.7624 | 2022-05-13 04:20:51 | Hidalgo, Mexico | |||
3444932 | 3444932 | 2022-05-11 | Mexico | Hidalgo | 93553 | 8410 | 0 | 20.0911 | -98.7624 | 2022-05-12 04:20:54 | Hidalgo, Mexico | |||
3535549 | 3535549 | 2022-05-10 | Mexico | Hidalgo | 93553 | 8410 | 0 | 20.0911 | -98.7624 | 2022-05-11 04:20:48 | Hidalgo, Mexico | |||
222084 | 222084 | 2022-05-09 | Mexico | Hidalgo | 93553 | 8410 | 0 | 20.0911 | -98.7624 | 2022-05-10 04:20:50 | Hidalgo, Mexico | |||
2331469 | 2331469 | 2022-05-08 | Mexico | Hidalgo | 93410 | 8408 | 0 | 20.0911 | -98.7624 | 2022-05-09 04:20:54 | Hidalgo, Mexico | |||
360431 | 360431 | 2022-05-07 | Mexico | Hidalgo | 93410 | 8408 | 0 | 20.0911 | -98.7624 | 2022-05-08 04:20:49 | Hidalgo, Mexico | |||
1397782 | 1397782 | 2022-05-06 | Mexico | Hidalgo | 93410 | 8408 | 0 | 20.0911 | -98.7624 | 2022-05-07 04:21:09 | Hidalgo, Mexico | |||
2598137 | 2598137 | 2022-05-05 | Mexico | Hidalgo | 93410 | 8408 | 0 | 20.0911 | -98.7624 | 2022-05-06 04:21:00 | Hidalgo, Mexico | |||
3265586 | 3265586 | 2022-05-04 | Mexico | Hidalgo | 93410 | 8408 | 0 | 20.0911 | -98.7624 | 2022-05-05 04:20:55 | Hidalgo, Mexico | |||
1572225 | 1572225 | 2022-05-03 | Mexico | Hidalgo | 93410 | 8408 | 0 | 20.0911 | -98.7624 | 2022-05-04 04:20:59 | Hidalgo, Mexico | |||
463485 | 463485 | 2022-05-02 | Mexico | Hidalgo | 93418 | 8408 | 0 | 20.0911 | -98.7624 | 2022-05-03 04:21:00 | Hidalgo, Mexico | |||
3916124 | 3916124 | 2022-05-01 | Mexico | Hidalgo | 93410 | 8408 | 0 | 20.0911 | -98.7624 | 2022-05-02 04:21:10 | Hidalgo, Mexico | |||
2840928 | 2840928 | 2022-04-30 | Mexico | Hidalgo | 93410 | 8408 | 0 | 20.0911 | -98.7624 | 2022-05-01 04:20:57 | Hidalgo, Mexico | |||
1157241 | 1157241 | 2022-04-29 | Mexico | Hidalgo | 93394 | 8408 | 0 | 20.0911 | -98.7624 | 2022-04-30 04:21:05 | Hidalgo, Mexico | |||
1696423 | 1696423 | 2022-04-28 | Mexico | Hidalgo | 93353 | 8407 | 0 | 20.0911 | -98.7624 | 2022-04-29 04:20:59 | Hidalgo, Mexico | |||
3851906 | 3851906 | 2022-04-27 | Mexico | Hidalgo | 93317 | 8406 | 0 | 20.0911 | -98.7624 | 2022-04-28 04:20:47 | Hidalgo, Mexico | |||
1326336 | 1326336 | 2022-04-26 | Mexico | Hidalgo | 93292 | 8405 | 0 | 20.0911 | -98.7624 | 2022-04-27 04:20:52 | Hidalgo, Mexico | |||
3722290 | 3722290 | 2022-04-25 | Mexico | Hidalgo | 93278 | 8403 | 0 | 20.0911 | -98.7624 | 2022-04-26 04:20:51 | Hidalgo, Mexico | |||
2028858 | 2028858 | 2022-04-24 | Mexico | Hidalgo | 93275 | 8403 | 0 | 20.0911 | -98.7624 | 2022-04-25 04:20:56 | Hidalgo, Mexico | |||
746433 | 746433 | 2022-04-23 | Mexico | Hidalgo | 93273 | 8402 | 0 | 20.0911 | -98.7624 | 2022-04-24 04:20:56 | Hidalgo, Mexico | |||
3436918 | 3436918 | 2022-04-22 | Mexico | Hidalgo | 93250 | 8401 | 0 | 20.0911 | -98.7624 | 2022-04-23 04:20:50 | Hidalgo, Mexico | |||
2892503 | 2892503 | 2022-04-21 | Mexico | Hidalgo | 93250 | 8401 | 0 | 20.0911 | -98.7624 | 2022-04-22 04:20:45 | Hidalgo, Mexico | |||
2307375 | 2307375 | 2022-04-20 | Mexico | Hidalgo | 93240 | 8401 | 0 | 20.0911 | -98.7624 | 2022-04-21 04:20:46 | Hidalgo, Mexico | |||
2251514 | 2251514 | 2022-04-19 | Mexico | Hidalgo | 93212 | 8399 | 0 | 20.0911 | -98.7624 | 2022-04-20 04:20:45 | Hidalgo, Mexico | |||
1846064 | 1846064 | 2022-04-18 | Mexico | Hidalgo | 93165 | 8398 | 0 | 20.0911 | -98.7624 | 2022-04-19 04:21:00 | Hidalgo, Mexico | |||
3417008 | 3417008 | 2022-04-17 | Mexico | Hidalgo | 93165 | 8398 | 0 | 20.0911 | -98.7624 | 2022-04-18 04:21:12 | Hidalgo, Mexico | |||
303957 | 303957 | 2022-04-16 | Mexico | Hidalgo | 93160 | 8398 | 0 | 20.0911 | -98.7624 | 2022-04-17 04:20:59 | Hidalgo, Mexico | |||
2669902 | 2669902 | 2022-04-15 | Mexico | Hidalgo | 93119 | 8398 | 0 | 20.0911 | -98.7624 | 2022-04-16 04:20:48 | Hidalgo, Mexico | |||
1223687 | 1223687 | 2022-04-14 | Mexico | Hidalgo | 93111 | 8398 | 0 | 20.0911 | -98.7624 | 2022-04-15 04:20:57 | Hidalgo, Mexico | |||
2442845 | 2442845 | 2022-04-13 | Mexico | Hidalgo | 93110 | 8396 | 0 | 20.0911 | -98.7624 | 2022-04-13 23:21:06 | Hidalgo, Mexico | |||
1948602 | 1948602 | 2022-04-12 | Mexico | Hidalgo | 93101 | 8396 | 0 | 20.0911 | -98.7624 | 2022-04-13 04:21:03 | Hidalgo, Mexico | |||
3206355 | 3206355 | 2022-04-11 | Mexico | Hidalgo | 93096 | 8393 | 0 | 20.0911 | -98.7624 | 2022-04-12 04:20:49 | Hidalgo, Mexico | |||
1576241 | 1576241 | 2022-04-10 | Mexico | Hidalgo | 93094 | 8392 | 0 | 20.0911 | -98.7624 | 2022-04-11 04:21:02 | Hidalgo, Mexico | |||
1652483 | 1652483 | 2022-04-09 | Mexico | Hidalgo | 93091 | 8392 | 0 | 20.0911 | -98.7624 | 2022-04-10 04:20:52 | Hidalgo, Mexico | |||
2115805 | 2115805 | 2022-04-08 | Mexico | Hidalgo | 92990 | 8388 | 0 | 20.0911 | -98.7624 | 2022-04-09 04:20:42 | Hidalgo, Mexico | |||
3320329 | 3320329 | 2022-04-07 | Mexico | Hidalgo | 92867 | 8383 | 0 | 20.0911 | -98.7624 | 2022-04-08 04:20:48 | Hidalgo, Mexico | |||
2800865 | 2800865 | 2022-04-06 | Mexico | Hidalgo | 92767 | 8381 | 0 | 20.0911 | -98.7624 | 2022-04-07 04:20:53 | Hidalgo, Mexico | |||
3867634 | 3867634 | 2022-04-05 | Mexico | Hidalgo | 92551 | 8376 | 0 | 20.0911 | -98.7624 | 2022-04-06 04:20:49 | Hidalgo, Mexico | |||
2748976 | 2748976 | 2022-04-04 | Mexico | Hidalgo | 92384 | 8376 | 0 | 20.0911 | -98.7624 | 2022-04-05 04:20:48 | Hidalgo, Mexico | |||
3730322 | 3730322 | 2022-04-03 | Mexico | Hidalgo | 92343 | 8376 | 0 | 20.0911 | -98.7624 | 2022-04-04 04:20:51 | Hidalgo, Mexico | |||
499757 | 499757 | 2022-04-02 | Mexico | Hidalgo | 92343 | 8376 | 0 | 20.0911 | -98.7624 | 2022-04-03 04:20:48 | Hidalgo, Mexico | |||
3350742 | 3350742 | 2022-04-01 | Mexico | Hidalgo | 92221 | 8376 | 0 | 20.0911 | -98.7624 | 2022-04-02 04:20:47 | Hidalgo, Mexico | |||
1540047 | 1540047 | 2022-03-31 | Mexico | Hidalgo | 92159 | 8372 | 0 | 20.0911 | -98.7624 | 2022-04-01 04:20:28 | Hidalgo, Mexico | |||
2478060 | 2478060 | 2022-03-30 | Mexico | Hidalgo | 92056 | 8370 | 0 | 20.0911 | -98.7624 | 2022-03-31 04:20:56 | Hidalgo, Mexico | |||
158101 | 158101 | 2022-03-29 | Mexico | Hidalgo | 92056 | 8370 | 0 | 20.0911 | -98.7624 | 2022-03-30 04:20:45 | Hidalgo, Mexico | |||
1436672 | 1436672 | 2022-03-28 | Mexico | Hidalgo | 91921 | 8366 | 0 | 20.0911 | -98.7624 | 2022-03-29 04:20:46 | Hidalgo, Mexico | |||
876353 | 876353 | 2022-03-27 | Mexico | Hidalgo | 91918 | 8366 | 0 | 20.0911 | -98.7624 | 2022-03-28 04:20:33 | Hidalgo, Mexico | |||
2163636 | 2163636 | 2022-03-26 | Mexico | Hidalgo | 91761 | 8366 | 0 | 20.0911 | -98.7624 | 2022-03-27 04:20:47 | Hidalgo, Mexico | |||
1720572 | 1720572 | 2022-03-25 | Mexico | Hidalgo | 91761 | 8366 | 0 | 20.0911 | -98.7624 | 2022-03-26 04:20:23 | Hidalgo, Mexico | |||
1468189 | 1468189 | 2022-03-24 | Mexico | Hidalgo | 91542 | 8364 | 0 | 20.0911 | -98.7624 | 2022-03-25 04:20:46 | Hidalgo, Mexico | |||
3022363 | 3022363 | 2022-03-23 | Mexico | Hidalgo | 91384 | 8358 | 0 | 20.0911 | -98.7624 | 2022-03-24 04:20:43 | Hidalgo, Mexico | |||
1905285 | 1905285 | 2022-03-22 | Mexico | Hidalgo | 91384 | 8358 | 0 | 20.0911 | -98.7624 | 2022-03-23 04:20:48 | Hidalgo, Mexico | |||
3238416 | 3238416 | 2022-03-21 | Mexico | Hidalgo | 91365 | 8355 | 0 | 20.0911 | -98.7624 | 2022-03-22 04:20:54 | Hidalgo, Mexico | |||
24489 | 24489 | 2022-03-20 | Mexico | Hidalgo | 91341 | 8355 | 0 | 20.0911 | -98.7624 | 2022-03-21 04:20:50 | Hidalgo, Mexico | |||
1656499 | 1656499 | 2022-03-19 | Mexico | Hidalgo | 91182 | 8354 | 0 | 20.0911 | -98.7624 | 2022-03-20 04:20:45 | Hidalgo, Mexico | |||
336025 | 336025 | 2022-03-18 | Mexico | Hidalgo | 91018 | 8355 | 0 | 20.0911 | -98.7624 | 2022-03-19 04:20:47 | Hidalgo, Mexico | |||
694478 | 694478 | 2022-03-17 | Mexico | Hidalgo | 91018 | 8355 | 0 | 20.0911 | -98.7624 | 2022-03-18 04:20:55 | Hidalgo, Mexico | |||
2319421 | 2319421 | 2022-03-16 | Mexico | Hidalgo | 90751 | 8351 | 0 | 20.0911 | -98.7624 | 2022-03-17 04:20:56 | Hidalgo, Mexico | |||
261621 | 261621 | 2022-03-15 | Mexico | Hidalgo | 90672 | 8343 | 0 | 20.0911 | -98.7624 | 2022-03-16 04:20:50 | Hidalgo, Mexico | |||
2263980 | 2263980 | 2022-03-14 | Mexico | Hidalgo | 90672 | 8343 | 0 | 20.0911 | -98.7624 | 2022-03-15 04:20:47 | Hidalgo, Mexico | |||
3628046 | 3628046 | 2022-03-13 | Mexico | Hidalgo | 90638 | 8342 | 0 | 20.0911 | -98.7624 | 2022-03-14 04:20:46 | Hidalgo, Mexico | |||
950954 | 950954 | 2022-03-12 | Mexico | Hidalgo | 90597 | 8342 | 0 | 20.0911 | -98.7624 | 2022-03-13 04:20:49 | Hidalgo, Mexico | |||
356415 | 356415 | 2022-03-11 | Mexico | Hidalgo | 90262 | 8335 | 0 | 20.0911 | -98.7624 | 2022-03-12 04:20:50 | Hidalgo, Mexico | |||
1865567 | 1865567 | 2022-03-10 | Mexico | Hidalgo | 90262 | 8335 | 0 | 20.0911 | -98.7624 | 2022-03-11 04:20:50 | Hidalgo, Mexico | |||
2140262 | 2140262 | 2022-03-09 | Mexico | Hidalgo | 90040 | 8334 | 0 | 20.0911 | -98.7624 | 2022-03-10 04:20:48 | Hidalgo, Mexico | |||
919773 | 919773 | 2022-03-08 | Mexico | Hidalgo | 89808 | 8324 | 0 | 20.0911 | -98.7624 | 2022-03-09 04:20:59 | Hidalgo, Mexico | |||
1548060 | 1548060 | 2022-03-07 | Mexico | Hidalgo | 89591 | 8321 | 0 | 20.0911 | -98.7624 | 2022-03-08 04:20:54 | Hidalgo, Mexico | |||
2199729 | 2199729 | 2022-03-06 | Mexico | Hidalgo | 89505 | 8320 | 0 | 20.0911 | -98.7624 | 2022-03-07 04:20:47 | Hidalgo, Mexico | |||
2092186 | 2092186 | 2022-03-05 | Mexico | Hidalgo | 89138 | 8316 | 0 | 20.0911 | -98.7624 | 2022-03-06 04:20:49 | Hidalgo, Mexico | |||
2665886 | 2665886 | 2022-03-04 | Mexico | Hidalgo | 88812 | 8308 | 0 | 20.0911 | -98.7624 | 2022-03-05 04:21:10 | Hidalgo, Mexico | |||
1644451 | 1644451 | 2022-03-03 | Mexico | Hidalgo | 88584 | 8295 | 0 | 20.0911 | -98.7624 | 2022-03-04 04:21:09 | Hidalgo, Mexico | |||
2525454 | 2525454 | 2022-03-02 | Mexico | Hidalgo | 88232 | 8288 | 0 | 20.0911 | -98.7624 | 2022-03-03 04:21:01 | Hidalgo, Mexico | |||
1992748 | 1992748 | 2022-03-01 | Mexico | Hidalgo | 88232 | 8288 | 0 | 20.0911 | -98.7624 | 2022-03-02 04:21:07 | Hidalgo, Mexico | |||
942922 | 942922 | 2022-02-28 | Mexico | Hidalgo | 87935 | 8280 | 0 | 20.0911 | -98.7624 | 2022-03-01 04:21:09 | Hidalgo, Mexico | |||
2733113 | 2733113 | 2022-02-27 | Mexico | Hidalgo | 87809 | 8278 | 0 | 20.0911 | -98.7624 | 2022-02-28 04:21:05 | Hidalgo, Mexico | |||
3046266 | 3046266 | 2022-02-26 | Mexico | Hidalgo | 87690 | 8274 | 0 | 20.0911 | -98.7624 | 2022-02-27 04:21:04 | Hidalgo, Mexico | |||
574921 | 574921 | 2022-02-25 | Mexico | Hidalgo | 87381 | 8269 | 0 | 20.0911 | -98.7624 | 2022-02-26 04:21:12 | Hidalgo, Mexico | |||
1511497 | 1511497 | 2022-02-24 | Mexico | Hidalgo | 87021 | 8263 | 0 | 20.0911 | -98.7624 | 2022-02-25 04:21:11 | Hidalgo, Mexico | |||
1057938 | 1057938 | 2022-02-23 | Mexico | Hidalgo | 86686 | 8250 | 0 | 20.0911 | -98.7624 | 2022-02-24 04:21:14 | Hidalgo, Mexico | |||
2446861 | 2446861 | 2022-02-22 | Mexico | Hidalgo | 85851 | 8230 | 0 | 20.0911 | -98.7624 | 2022-02-23 04:21:09 | Hidalgo, Mexico | |||
3718274 | 3718274 | 2022-02-21 | Mexico | Hidalgo | 85749 | 8224 | 0 | 20.0911 | -98.7624 | 2022-02-22 04:21:01 | Hidalgo, Mexico | |||
3912108 | 3912108 | 2022-02-20 | Mexico | Hidalgo | 85749 | 8224 | 0 | 20.0911 | -98.7624 | 2022-02-21 04:21:05 | Hidalgo, Mexico | |||
3875666 | 3875666 | 2022-02-19 | Mexico | Hidalgo | 85658 | 8216 | 0 | 20.0911 | -98.7624 | 2022-02-20 04:21:00 | Hidalgo, Mexico | |||
3855922 | 3855922 | 2022-02-18 | Mexico | Hidalgo | 84919 | 8196 | 0 | 20.0911 | -98.7624 | 2022-02-19 04:21:11 | Hidalgo, Mexico | |||
1298141 | 1298141 | 2022-02-17 | Mexico | Hidalgo | 84919 | 8196 | 0 | 20.0911 | -98.7624 | 2022-02-18 04:21:04 | Hidalgo, Mexico | |||
3820527 | 3820527 | 2022-02-16 | Mexico | Hidalgo | 84514 | 8185 | 0 | 20.0911 | -98.7624 | 2022-02-17 04:20:56 | Hidalgo, Mexico | |||
3671741 | 3671741 | 2022-02-15 | Mexico | Hidalgo | 83564 | 8158 | 0 | 20.0911 | -98.7624 | 2022-02-16 04:21:10 | Hidalgo, Mexico | |||
2641842 | 2641842 | 2022-02-14 | Mexico | Hidalgo | 83462 | 8151 | 0 | 20.0911 | -98.7624 | 2022-02-15 04:21:09 | Hidalgo, Mexico | |||
186159 | 186159 | 2022-02-13 | Mexico | Hidalgo | 83363 | 8148 | 0 | 20.0911 | -98.7624 | 2022-02-14 04:20:51 | Hidalgo, Mexico | |||
316005 | 316005 | 2022-02-12 | Mexico | Hidalgo | 83363 | 8148 | 0 | 20.0911 | -98.7624 | 2022-02-13 04:21:00 | Hidalgo, Mexico | |||
233331 | 233331 | 2022-02-11 | Mexico | Hidalgo | 82250 | 8121 | 0 | 20.0911 | -98.7624 | 2022-02-12 04:21:06 | Hidalgo, Mexico | |||
1464173 | 1464173 | 2022-02-10 | Mexico | Hidalgo | 81544 | 8112 | 0 | 20.0911 | -98.7624 | 2022-02-11 04:21:09 | Hidalgo, Mexico | |||
3074134 | 3074134 | 2022-02-09 | Mexico | Hidalgo | 81544 | 8112 | 0 | 20.0911 | -98.7624 | 2022-02-10 04:21:14 | Hidalgo, Mexico | |||
1362441 | 1362441 | 2022-02-08 | Mexico | Hidalgo | 81097 | 8094 | 0 | 20.0911 | -98.7624 | 2022-02-09 04:21:04 | Hidalgo, Mexico | |||
71179 | 71179 | 2022-02-07 | Mexico | Hidalgo | 80823 | 8087 | 0 | 20.0911 | -98.7624 | 2022-02-08 04:21:15 | Hidalgo, Mexico | |||
2012795 | 2012795 | 2022-02-06 | Mexico | Hidalgo | 80716 | 8076 | 0 | 20.0911 | -98.7624 | 2022-02-07 04:21:05 | Hidalgo, Mexico | |||
1294124 | 1294124 | 2022-02-05 | Mexico | Hidalgo | 80558 | 8070 | 0 | 20.0911 | -98.7624 | 2022-02-06 04:21:00 | Hidalgo, Mexico | |||
2327452 | 2327452 | 2022-02-04 | Mexico | Hidalgo | 79816 | 8058 | 0 | 20.0911 | -98.7624 | 2022-02-05 04:21:05 | Hidalgo, Mexico | |||
2474043 | 2474043 | 2022-02-03 | Mexico | Hidalgo | 78343 | 8027 | 0 | 20.0911 | -98.7624 | 2022-02-04 04:21:10 | Hidalgo, Mexico | |||
459468 | 459468 | 2022-02-02 | Mexico | Hidalgo | 77621 | 8022 | 0 | 20.0911 | -98.7624 | 2022-02-03 04:21:21 | Hidalgo, 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]);