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 = "Aguascalientes" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2533474 | 2533474 | 2022-05-12 | Mexico | Aguascalientes | 66137 | 3502 | 0 | 21.8853 | -102.2916 | 2022-05-13 04:20:51 | Aguascalientes, Mexico | |||
3444920 | 3444920 | 2022-05-11 | Mexico | Aguascalientes | 66137 | 3502 | 0 | 21.8853 | -102.2916 | 2022-05-12 04:20:54 | Aguascalientes, Mexico | |||
3535537 | 3535537 | 2022-05-10 | Mexico | Aguascalientes | 66137 | 3502 | 0 | 21.8853 | -102.2916 | 2022-05-11 04:20:48 | Aguascalientes, Mexico | |||
222072 | 222072 | 2022-05-09 | Mexico | Aguascalientes | 66137 | 3502 | 0 | 21.8853 | -102.2916 | 2022-05-10 04:20:50 | Aguascalientes, Mexico | |||
2331457 | 2331457 | 2022-05-08 | Mexico | Aguascalientes | 65865 | 3501 | 0 | 21.8853 | -102.2916 | 2022-05-09 04:20:54 | Aguascalientes, Mexico | |||
360419 | 360419 | 2022-05-07 | Mexico | Aguascalientes | 65865 | 3501 | 0 | 21.8853 | -102.2916 | 2022-05-08 04:20:49 | Aguascalientes, Mexico | |||
1397770 | 1397770 | 2022-05-06 | Mexico | Aguascalientes | 65865 | 3501 | 0 | 21.8853 | -102.2916 | 2022-05-07 04:21:09 | Aguascalientes, Mexico | |||
2598125 | 2598125 | 2022-05-05 | Mexico | Aguascalientes | 65865 | 3501 | 0 | 21.8853 | -102.2916 | 2022-05-06 04:21:00 | Aguascalientes, Mexico | |||
3265574 | 3265574 | 2022-05-04 | Mexico | Aguascalientes | 65865 | 3501 | 0 | 21.8853 | -102.2916 | 2022-05-05 04:20:55 | Aguascalientes, Mexico | |||
1572213 | 1572213 | 2022-05-03 | Mexico | Aguascalientes | 65865 | 3501 | 0 | 21.8853 | -102.2916 | 2022-05-04 04:20:59 | Aguascalientes, Mexico | |||
463473 | 463473 | 2022-05-02 | Mexico | Aguascalientes | 65866 | 3501 | 0 | 21.8853 | -102.2916 | 2022-05-03 04:21:00 | Aguascalientes, Mexico | |||
3916112 | 3916112 | 2022-05-01 | Mexico | Aguascalientes | 65865 | 3501 | 0 | 21.8853 | -102.2916 | 2022-05-02 04:21:10 | Aguascalientes, Mexico | |||
2840916 | 2840916 | 2022-04-30 | Mexico | Aguascalientes | 65865 | 3501 | 0 | 21.8853 | -102.2916 | 2022-05-01 04:20:57 | Aguascalientes, Mexico | |||
1157229 | 1157229 | 2022-04-29 | Mexico | Aguascalientes | 65832 | 3500 | 0 | 21.8853 | -102.2916 | 2022-04-30 04:21:05 | Aguascalientes, Mexico | |||
1696411 | 1696411 | 2022-04-28 | Mexico | Aguascalientes | 65804 | 3498 | 0 | 21.8853 | -102.2916 | 2022-04-29 04:20:59 | Aguascalientes, Mexico | |||
3851894 | 3851894 | 2022-04-27 | Mexico | Aguascalientes | 65782 | 3498 | 0 | 21.8853 | -102.2916 | 2022-04-28 04:20:47 | Aguascalientes, Mexico | |||
1326324 | 1326324 | 2022-04-26 | Mexico | Aguascalientes | 65736 | 3498 | 0 | 21.8853 | -102.2916 | 2022-04-27 04:20:52 | Aguascalientes, Mexico | |||
3722278 | 3722278 | 2022-04-25 | Mexico | Aguascalientes | 65687 | 3498 | 0 | 21.8853 | -102.2916 | 2022-04-26 04:20:51 | Aguascalientes, Mexico | |||
2028846 | 2028846 | 2022-04-24 | Mexico | Aguascalientes | 65687 | 3498 | 0 | 21.8853 | -102.2916 | 2022-04-25 04:20:56 | Aguascalientes, Mexico | |||
746421 | 746421 | 2022-04-23 | Mexico | Aguascalientes | 65687 | 3498 | 0 | 21.8853 | -102.2916 | 2022-04-24 04:20:56 | Aguascalientes, Mexico | |||
3436906 | 3436906 | 2022-04-22 | Mexico | Aguascalientes | 65623 | 3498 | 0 | 21.8853 | -102.2916 | 2022-04-23 04:20:50 | Aguascalientes, Mexico | |||
2892491 | 2892491 | 2022-04-21 | Mexico | Aguascalientes | 65623 | 3498 | 0 | 21.8853 | -102.2916 | 2022-04-22 04:20:45 | Aguascalientes, Mexico | |||
2307363 | 2307363 | 2022-04-20 | Mexico | Aguascalientes | 65584 | 3498 | 0 | 21.8853 | -102.2916 | 2022-04-21 04:20:46 | Aguascalientes, Mexico | |||
2251502 | 2251502 | 2022-04-19 | Mexico | Aguascalientes | 65543 | 3498 | 0 | 21.8853 | -102.2916 | 2022-04-20 04:20:45 | Aguascalientes, Mexico | |||
1846052 | 1846052 | 2022-04-18 | Mexico | Aguascalientes | 65510 | 3497 | 0 | 21.8853 | -102.2916 | 2022-04-19 04:21:00 | Aguascalientes, Mexico | |||
3416996 | 3416996 | 2022-04-17 | Mexico | Aguascalientes | 65510 | 3497 | 0 | 21.8853 | -102.2916 | 2022-04-18 04:21:12 | Aguascalientes, Mexico | |||
303945 | 303945 | 2022-04-16 | Mexico | Aguascalientes | 65451 | 3497 | 0 | 21.8853 | -102.2916 | 2022-04-17 04:20:59 | Aguascalientes, Mexico | |||
2669890 | 2669890 | 2022-04-15 | Mexico | Aguascalientes | 65416 | 3497 | 0 | 21.8853 | -102.2916 | 2022-04-16 04:20:48 | Aguascalientes, Mexico | |||
1223675 | 1223675 | 2022-04-14 | Mexico | Aguascalientes | 65416 | 3497 | 0 | 21.8853 | -102.2916 | 2022-04-15 04:20:57 | Aguascalientes, Mexico | |||
2442833 | 2442833 | 2022-04-13 | Mexico | Aguascalientes | 65414 | 3496 | 0 | 21.8853 | -102.2916 | 2022-04-13 23:21:06 | Aguascalientes, Mexico | |||
1948590 | 1948590 | 2022-04-12 | Mexico | Aguascalientes | 65405 | 3496 | 0 | 21.8853 | -102.2916 | 2022-04-13 04:21:03 | Aguascalientes, Mexico | |||
3206343 | 3206343 | 2022-04-11 | Mexico | Aguascalientes | 65403 | 3496 | 0 | 21.8853 | -102.2916 | 2022-04-12 04:20:49 | Aguascalientes, Mexico | |||
1576229 | 1576229 | 2022-04-10 | Mexico | Aguascalientes | 65403 | 3496 | 0 | 21.8853 | -102.2916 | 2022-04-11 04:21:02 | Aguascalientes, Mexico | |||
1652471 | 1652471 | 2022-04-09 | Mexico | Aguascalientes | 65403 | 3496 | 0 | 21.8853 | -102.2916 | 2022-04-10 04:20:52 | Aguascalientes, Mexico | |||
2115793 | 2115793 | 2022-04-08 | Mexico | Aguascalientes | 65307 | 3496 | 0 | 21.8853 | -102.2916 | 2022-04-09 04:20:42 | Aguascalientes, Mexico | |||
3320317 | 3320317 | 2022-04-07 | Mexico | Aguascalientes | 64893 | 3495 | 0 | 21.8853 | -102.2916 | 2022-04-08 04:20:48 | Aguascalientes, Mexico | |||
2800853 | 2800853 | 2022-04-06 | Mexico | Aguascalientes | 64534 | 3495 | 0 | 21.8853 | -102.2916 | 2022-04-07 04:20:53 | Aguascalientes, Mexico | |||
3867622 | 3867622 | 2022-04-05 | Mexico | Aguascalientes | 64390 | 3491 | 0 | 21.8853 | -102.2916 | 2022-04-06 04:20:49 | Aguascalientes, Mexico | |||
2748964 | 2748964 | 2022-04-04 | Mexico | Aguascalientes | 64180 | 3490 | 0 | 21.8853 | -102.2916 | 2022-04-05 04:20:48 | Aguascalientes, Mexico | |||
3730310 | 3730310 | 2022-04-03 | Mexico | Aguascalientes | 64180 | 3490 | 0 | 21.8853 | -102.2916 | 2022-04-04 04:20:51 | Aguascalientes, Mexico | |||
499745 | 499745 | 2022-04-02 | Mexico | Aguascalientes | 64178 | 3490 | 0 | 21.8853 | -102.2916 | 2022-04-03 04:20:48 | Aguascalientes, Mexico | |||
3350730 | 3350730 | 2022-04-01 | Mexico | Aguascalientes | 64060 | 3490 | 0 | 21.8853 | -102.2916 | 2022-04-02 04:20:47 | Aguascalientes, Mexico | |||
1540035 | 1540035 | 2022-03-31 | Mexico | Aguascalientes | 64003 | 3489 | 0 | 21.8853 | -102.2916 | 2022-04-01 04:20:28 | Aguascalientes, Mexico | |||
2478048 | 2478048 | 2022-03-30 | Mexico | Aguascalientes | 63836 | 3485 | 0 | 21.8853 | -102.2916 | 2022-03-31 04:20:56 | Aguascalientes, Mexico | |||
158089 | 158089 | 2022-03-29 | Mexico | Aguascalientes | 63836 | 3485 | 0 | 21.8853 | -102.2916 | 2022-03-30 04:20:45 | Aguascalientes, Mexico | |||
1436660 | 1436660 | 2022-03-28 | Mexico | Aguascalientes | 63740 | 3483 | 0 | 21.8853 | -102.2916 | 2022-03-29 04:20:46 | Aguascalientes, Mexico | |||
876341 | 876341 | 2022-03-27 | Mexico | Aguascalientes | 63740 | 3483 | 0 | 21.8853 | -102.2916 | 2022-03-28 04:20:33 | Aguascalientes, Mexico | |||
2163624 | 2163624 | 2022-03-26 | Mexico | Aguascalientes | 63637 | 3483 | 0 | 21.8853 | -102.2916 | 2022-03-27 04:20:47 | Aguascalientes, Mexico | |||
1720560 | 1720560 | 2022-03-25 | Mexico | Aguascalientes | 63637 | 3483 | 0 | 21.8853 | -102.2916 | 2022-03-26 04:20:23 | Aguascalientes, Mexico | |||
1468177 | 1468177 | 2022-03-24 | Mexico | Aguascalientes | 63453 | 3483 | 0 | 21.8853 | -102.2916 | 2022-03-25 04:20:46 | Aguascalientes, Mexico | |||
3022351 | 3022351 | 2022-03-23 | Mexico | Aguascalientes | 63295 | 3482 | 0 | 21.8853 | -102.2916 | 2022-03-24 04:20:43 | Aguascalientes, Mexico | |||
1905273 | 1905273 | 2022-03-22 | Mexico | Aguascalientes | 63295 | 3482 | 0 | 21.8853 | -102.2916 | 2022-03-23 04:20:48 | Aguascalientes, Mexico | |||
3238404 | 3238404 | 2022-03-21 | Mexico | Aguascalientes | 63293 | 3482 | 0 | 21.8853 | -102.2916 | 2022-03-22 04:20:54 | Aguascalientes, Mexico | |||
24477 | 24477 | 2022-03-20 | Mexico | Aguascalientes | 63293 | 3482 | 0 | 21.8853 | -102.2916 | 2022-03-21 04:20:50 | Aguascalientes, Mexico | |||
1656487 | 1656487 | 2022-03-19 | Mexico | Aguascalientes | 63190 | 3482 | 0 | 21.8853 | -102.2916 | 2022-03-20 04:20:45 | Aguascalientes, Mexico | |||
336013 | 336013 | 2022-03-18 | Mexico | Aguascalientes | 63055 | 3482 | 0 | 21.8853 | -102.2916 | 2022-03-19 04:20:47 | Aguascalientes, Mexico | |||
694466 | 694466 | 2022-03-17 | Mexico | Aguascalientes | 63055 | 3482 | 0 | 21.8853 | -102.2916 | 2022-03-18 04:20:55 | Aguascalientes, Mexico | |||
2319409 | 2319409 | 2022-03-16 | Mexico | Aguascalientes | 62680 | 3479 | 0 | 21.8853 | -102.2916 | 2022-03-17 04:20:56 | Aguascalientes, Mexico | |||
261609 | 261609 | 2022-03-15 | Mexico | Aguascalientes | 62441 | 3479 | 0 | 21.8853 | -102.2916 | 2022-03-16 04:20:50 | Aguascalientes, Mexico | |||
2263968 | 2263968 | 2022-03-14 | Mexico | Aguascalientes | 62441 | 3479 | 0 | 21.8853 | -102.2916 | 2022-03-15 04:20:47 | Aguascalientes, Mexico | |||
3628034 | 3628034 | 2022-03-13 | Mexico | Aguascalientes | 62440 | 3479 | 0 | 21.8853 | -102.2916 | 2022-03-14 04:20:46 | Aguascalientes, Mexico | |||
950942 | 950942 | 2022-03-12 | Mexico | Aguascalientes | 62435 | 3479 | 0 | 21.8853 | -102.2916 | 2022-03-13 04:20:49 | Aguascalientes, Mexico | |||
356403 | 356403 | 2022-03-11 | Mexico | Aguascalientes | 62073 | 3472 | 0 | 21.8853 | -102.2916 | 2022-03-12 04:20:50 | Aguascalientes, Mexico | |||
1865555 | 1865555 | 2022-03-10 | Mexico | Aguascalientes | 62073 | 3472 | 0 | 21.8853 | -102.2916 | 2022-03-11 04:20:50 | Aguascalientes, Mexico | |||
2140250 | 2140250 | 2022-03-09 | Mexico | Aguascalientes | 61896 | 3471 | 0 | 21.8853 | -102.2916 | 2022-03-10 04:20:48 | Aguascalientes, Mexico | |||
919761 | 919761 | 2022-03-08 | Mexico | Aguascalientes | 61705 | 3467 | 0 | 21.8853 | -102.2916 | 2022-03-09 04:20:59 | Aguascalientes, Mexico | |||
1548048 | 1548048 | 2022-03-07 | Mexico | Aguascalientes | 61399 | 3464 | 0 | 21.8853 | -102.2916 | 2022-03-08 04:20:54 | Aguascalientes, Mexico | |||
2199717 | 2199717 | 2022-03-06 | Mexico | Aguascalientes | 61399 | 3464 | 0 | 21.8853 | -102.2916 | 2022-03-07 04:20:47 | Aguascalientes, Mexico | |||
2092174 | 2092174 | 2022-03-05 | Mexico | Aguascalientes | 61144 | 3464 | 0 | 21.8853 | -102.2916 | 2022-03-06 04:20:49 | Aguascalientes, Mexico | |||
2665874 | 2665874 | 2022-03-04 | Mexico | Aguascalientes | 60844 | 3461 | 0 | 21.8853 | -102.2916 | 2022-03-05 04:21:10 | Aguascalientes, Mexico | |||
1644439 | 1644439 | 2022-03-03 | Mexico | Aguascalientes | 60559 | 3455 | 0 | 21.8853 | -102.2916 | 2022-03-04 04:21:09 | Aguascalientes, Mexico | |||
2525442 | 2525442 | 2022-03-02 | Mexico | Aguascalientes | 60273 | 3455 | 0 | 21.8853 | -102.2916 | 2022-03-03 04:21:01 | Aguascalientes, Mexico | |||
1992736 | 1992736 | 2022-03-01 | Mexico | Aguascalientes | 60273 | 3455 | 0 | 21.8853 | -102.2916 | 2022-03-02 04:21:07 | Aguascalientes, Mexico | |||
942910 | 942910 | 2022-02-28 | Mexico | Aguascalientes | 59987 | 3448 | 0 | 21.8853 | -102.2916 | 2022-03-01 04:21:09 | Aguascalientes, Mexico | |||
2733101 | 2733101 | 2022-02-27 | Mexico | Aguascalientes | 59971 | 3448 | 0 | 21.8853 | -102.2916 | 2022-02-28 04:21:05 | Aguascalientes, Mexico | |||
3046254 | 3046254 | 2022-02-26 | Mexico | Aguascalientes | 59946 | 3448 | 0 | 21.8853 | -102.2916 | 2022-02-27 04:21:04 | Aguascalientes, Mexico | |||
574909 | 574909 | 2022-02-25 | Mexico | Aguascalientes | 59619 | 3441 | 0 | 21.8853 | -102.2916 | 2022-02-26 04:21:12 | Aguascalientes, Mexico | |||
1511485 | 1511485 | 2022-02-24 | Mexico | Aguascalientes | 59203 | 3437 | 0 | 21.8853 | -102.2916 | 2022-02-25 04:21:11 | Aguascalientes, Mexico | |||
1057926 | 1057926 | 2022-02-23 | Mexico | Aguascalientes | 58757 | 3436 | 0 | 21.8853 | -102.2916 | 2022-02-24 04:21:14 | Aguascalientes, Mexico | |||
2446849 | 2446849 | 2022-02-22 | Mexico | Aguascalientes | 57782 | 3411 | 0 | 21.8853 | -102.2916 | 2022-02-23 04:21:09 | Aguascalientes, Mexico | |||
3718262 | 3718262 | 2022-02-21 | Mexico | Aguascalientes | 57779 | 3411 | 0 | 21.8853 | -102.2916 | 2022-02-22 04:21:01 | Aguascalientes, Mexico | |||
3912096 | 3912096 | 2022-02-20 | Mexico | Aguascalientes | 57779 | 3411 | 0 | 21.8853 | -102.2916 | 2022-02-21 04:21:05 | Aguascalientes, Mexico | |||
3875654 | 3875654 | 2022-02-19 | Mexico | Aguascalientes | 57759 | 3411 | 0 | 21.8853 | -102.2916 | 2022-02-20 04:21:00 | Aguascalientes, Mexico | |||
3855910 | 3855910 | 2022-02-18 | Mexico | Aguascalientes | 56869 | 3404 | 0 | 21.8853 | -102.2916 | 2022-02-19 04:21:11 | Aguascalientes, Mexico | |||
1298129 | 1298129 | 2022-02-17 | Mexico | Aguascalientes | 56869 | 3404 | 0 | 21.8853 | -102.2916 | 2022-02-18 04:21:04 | Aguascalientes, Mexico | |||
3820515 | 3820515 | 2022-02-16 | Mexico | Aguascalientes | 56427 | 3402 | 0 | 21.8853 | -102.2916 | 2022-02-17 04:20:56 | Aguascalientes, Mexico | |||
3671729 | 3671729 | 2022-02-15 | Mexico | Aguascalientes | 55554 | 3374 | 0 | 21.8853 | -102.2916 | 2022-02-16 04:21:10 | Aguascalientes, Mexico | |||
2641830 | 2641830 | 2022-02-14 | Mexico | Aguascalientes | 55552 | 3374 | 0 | 21.8853 | -102.2916 | 2022-02-15 04:21:09 | Aguascalientes, Mexico | |||
186147 | 186147 | 2022-02-13 | Mexico | Aguascalientes | 55525 | 3374 | 0 | 21.8853 | -102.2916 | 2022-02-14 04:20:51 | Aguascalientes, Mexico | |||
315993 | 315993 | 2022-02-12 | Mexico | Aguascalientes | 55525 | 3374 | 0 | 21.8853 | -102.2916 | 2022-02-13 04:21:00 | Aguascalientes, Mexico | |||
233319 | 233319 | 2022-02-11 | Mexico | Aguascalientes | 54439 | 3334 | 0 | 21.8853 | -102.2916 | 2022-02-12 04:21:06 | Aguascalientes, Mexico | |||
1464161 | 1464161 | 2022-02-10 | Mexico | Aguascalientes | 53768 | 3301 | 0 | 21.8853 | -102.2916 | 2022-02-11 04:21:09 | Aguascalientes, Mexico | |||
3074122 | 3074122 | 2022-02-09 | Mexico | Aguascalientes | 53768 | 3301 | 0 | 21.8853 | -102.2916 | 2022-02-10 04:21:14 | Aguascalientes, Mexico | |||
1362429 | 1362429 | 2022-02-08 | Mexico | Aguascalientes | 53301 | 3288 | 0 | 21.8853 | -102.2916 | 2022-02-09 04:21:04 | Aguascalientes, Mexico | |||
71167 | 71167 | 2022-02-07 | Mexico | Aguascalientes | 53290 | 3282 | 0 | 21.8853 | -102.2916 | 2022-02-08 04:21:15 | Aguascalientes, Mexico | |||
2012783 | 2012783 | 2022-02-06 | Mexico | Aguascalientes | 53269 | 3282 | 0 | 21.8853 | -102.2916 | 2022-02-07 04:21:05 | Aguascalientes, Mexico | |||
1294112 | 1294112 | 2022-02-05 | Mexico | Aguascalientes | 53253 | 3281 | 0 | 21.8853 | -102.2916 | 2022-02-06 04:21:00 | Aguascalientes, Mexico | |||
2327440 | 2327440 | 2022-02-04 | Mexico | Aguascalientes | 52422 | 3264 | 0 | 21.8853 | -102.2916 | 2022-02-05 04:21:05 | Aguascalientes, Mexico | |||
2474031 | 2474031 | 2022-02-03 | Mexico | Aguascalientes | 50914 | 3230 | 0 | 21.8853 | -102.2916 | 2022-02-04 04:21:10 | Aguascalientes, Mexico | |||
459456 | 459456 | 2022-02-02 | Mexico | Aguascalientes | 50193 | 3217 | 0 | 21.8853 | -102.2916 | 2022-02-03 04:21:21 | Aguascalientes, 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]);