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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1491678 | 1491678 | 2021-10-12 | Mexico | Aguascalientes | 34617 | 2791 | 0 | 21.8853 | -102.2916 | 2021-10-13 04:20:51 | Aguascalientes, Mexico | |||
3007411 | 3007411 | 2021-10-11 | Mexico | Aguascalientes | 34514 | 2785 | 0 | 21.8853 | -102.2916 | 2021-10-12 04:21:09 | Aguascalientes, Mexico | |||
423427 | 423427 | 2021-10-10 | Mexico | Aguascalientes | 34503 | 2785 | 0 | 21.8853 | -102.2916 | 2021-10-11 04:21:31 | Aguascalientes, Mexico | |||
2876284 | 2876284 | 2021-10-09 | Mexico | Aguascalientes | 34422 | 2780 | 0 | 21.8853 | -102.2916 | 2021-10-10 04:21:38 | Aguascalientes, Mexico | |||
2959450 | 2959450 | 2021-10-08 | Mexico | Aguascalientes | 34422 | 2780 | 0 | 21.8853 | -102.2916 | 2021-10-09 04:21:34 | Aguascalientes, Mexico | |||
467488 | 467488 | 2021-10-07 | Mexico | Aguascalientes | 34266 | 2779 | 0 | 21.8853 | -102.2916 | 2021-10-08 04:21:25 | Aguascalientes, Mexico | |||
2458868 | 2458868 | 2021-10-06 | Mexico | Aguascalientes | 34040 | 2771 | 0 | 21.8853 | -102.2916 | 2021-10-07 04:21:36 | Aguascalientes, Mexico | |||
3832562 | 3832562 | 2021-10-05 | Mexico | Aguascalientes | 33944 | 2763 | 0 | 21.8853 | -102.2916 | 2021-10-06 04:21:33 | Aguascalientes, Mexico | |||
987055 | 987055 | 2021-10-04 | Mexico | Aguascalientes | 33944 | 2763 | 0 | 21.8853 | -102.2916 | 2021-10-05 04:21:27 | Aguascalientes, Mexico | |||
1274365 | 1274365 | 2021-10-03 | Mexico | Aguascalientes | 33931 | 2763 | 0 | 21.8853 | -102.2916 | 2021-10-04 04:21:31 | Aguascalientes, Mexico | |||
3928118 | 3928118 | 2021-10-02 | Mexico | Aguascalientes | 33931 | 2763 | 0 | 21.8853 | -102.2916 | 2021-10-03 04:21:24 | Aguascalientes, Mexico | |||
2132098 | 2132098 | 2021-10-01 | Mexico | Aguascalientes | 33851 | 2753 | 0 | 21.8853 | -102.2916 | 2021-10-02 04:21:25 | Aguascalientes, Mexico | |||
2773055 | 2773055 | 2021-09-30 | Mexico | Aguascalientes | 33764 | 2747 | 0 | 21.8853 | -102.2916 | 2021-10-01 04:21:35 | Aguascalientes, Mexico | |||
706511 | 706511 | 2021-09-29 | Mexico | Aguascalientes | 33682 | 2741 | 0 | 21.8853 | -102.2916 | 2021-09-30 04:21:20 | Aguascalientes, Mexico | |||
1334353 | 1334353 | 2021-09-28 | Mexico | Aguascalientes | 33540 | 2737 | 0 | 21.8853 | -102.2916 | 2021-09-29 04:21:45 | Aguascalientes, Mexico | |||
1235722 | 1235722 | 2021-09-27 | Mexico | Aguascalientes | 33411 | 2727 | 0 | 21.8853 | -102.2916 | 2021-09-28 04:21:28 | Aguascalientes, Mexico | |||
2076023 | 2076023 | 2021-09-26 | Mexico | Aguascalientes | 33394 | 2727 | 0 | 21.8853 | -102.2916 | 2021-09-27 04:21:16 | Aguascalientes, Mexico | |||
1724575 | 1724575 | 2021-09-25 | Mexico | Aguascalientes | 33270 | 2724 | 0 | 21.8853 | -102.2916 | 2021-09-26 04:21:29 | Aguascalientes, Mexico | |||
1921295 | 1921295 | 2021-09-24 | Mexico | Aguascalientes | 33270 | 2724 | 0 | 21.8853 | -102.2916 | 2021-09-25 04:21:31 | Aguascalientes, Mexico | |||
601766 | 601766 | 2021-09-23 | Mexico | Aguascalientes | 33197 | 2719 | 0 | 21.8853 | -102.2916 | 2021-09-24 04:21:44 | Aguascalientes, Mexico | |||
3011410 | 3011410 | 2021-09-22 | Mexico | Aguascalientes | 33087 | 2716 | 0 | 21.8853 | -102.2916 | 2021-09-23 04:21:43 | Aguascalientes, Mexico | |||
3757548 | 3757548 | 2021-09-21 | Mexico | Aguascalientes | 32988 | 2698 | 0 | 21.8853 | -102.2916 | 2021-09-22 04:21:45 | Aguascalientes, Mexico | |||
809651 | 809651 | 2021-09-20 | Mexico | Aguascalientes | 32819 | 2687 | 0 | 21.8853 | -102.2916 | 2021-09-21 04:21:26 | Aguascalientes, Mexico | |||
1814850 | 1814850 | 2021-09-19 | Mexico | Aguascalientes | 32795 | 2687 | 0 | 21.8853 | -102.2916 | 2021-09-20 04:21:22 | Aguascalientes, Mexico | |||
16430 | 16430 | 2021-09-18 | Mexico | Aguascalientes | 32664 | 2676 | 0 | 21.8853 | -102.2916 | 2021-09-19 04:21:34 | Aguascalientes, Mexico | |||
2618115 | 2618115 | 2021-09-17 | Mexico | Aguascalientes | 32664 | 2676 | 0 | 21.8853 | -102.2916 | 2021-09-18 04:21:24 | Aguascalientes, Mexico | |||
2808823 | 2808823 | 2021-09-16 | Mexico | Aguascalientes | 32644 | 2676 | 0 | 21.8853 | -102.2916 | 2021-09-17 04:21:46 | Aguascalientes, Mexico | |||
1374568 | 1374568 | 2021-09-15 | Mexico | Aguascalientes | 32586 | 2673 | 0 | 21.8853 | -102.2916 | 2021-09-16 04:22:19 | Aguascalientes, Mexico | |||
2462867 | 2462867 | 2021-09-14 | Mexico | Aguascalientes | 32455 | 2666 | 0 | 21.8853 | -102.2916 | 2021-09-15 03:22:37 | Aguascalientes, Mexico | |||
1385706 | 1385706 | 2021-09-13 | Mexico | Aguascalientes | 32326 | 2661 | 0 | 21.8853 | -102.2916 | 2021-09-14 04:21:41 | Aguascalientes, Mexico | |||
1885075 | 1885075 | 2021-09-12 | Mexico | Aguascalientes | 32315 | 2661 | 0 | 21.8853 | -102.2916 | 2021-09-13 04:21:15 | Aguascalientes, Mexico | |||
3805978 | 3805978 | 2021-09-11 | Mexico | Aguascalientes | 32296 | 2659 | 0 | 21.8853 | -102.2916 | 2021-09-12 04:21:13 | Aguascalientes, Mexico | |||
3448918 | 3448918 | 2021-09-10 | Mexico | Aguascalientes | 32076 | 2652 | 0 | 21.8853 | -102.2916 | 2021-09-11 04:21:30 | Aguascalientes, Mexico | |||
1262864 | 1262864 | 2021-09-09 | Mexico | Aguascalientes | 32076 | 2652 | 0 | 21.8853 | -102.2916 | 2021-09-10 04:21:20 | Aguascalientes, Mexico | |||
2279234 | 2279234 | 2021-09-08 | Mexico | Aguascalientes | 31965 | 2650 | 0 | 21.8853 | -102.2916 | 2021-09-09 04:21:27 | Aguascalientes, Mexico | |||
642013 | 642013 | 2021-09-07 | Mexico | Aguascalientes | 31880 | 2643 | 0 | 21.8853 | -102.2916 | 2021-09-08 04:21:31 | Aguascalientes, Mexico | |||
3194076 | 3194076 | 2021-09-06 | Mexico | Aguascalientes | 31705 | 2639 | 0 | 21.8853 | -102.2916 | 2021-09-07 04:21:35 | Aguascalientes, Mexico | |||
3280944 | 3280944 | 2021-09-05 | Mexico | Aguascalientes | 31679 | 2639 | 0 | 21.8853 | -102.2916 | 2021-09-06 04:21:22 | Aguascalientes, Mexico | |||
249358 | 249358 | 2021-09-04 | Mexico | Aguascalientes | 31675 | 2639 | 0 | 21.8853 | -102.2916 | 2021-09-05 04:21:33 | Aguascalientes, Mexico | |||
3974639 | 3974639 | 2021-09-03 | Mexico | Aguascalientes | 31548 | 2630 | 0 | 21.8853 | -102.2916 | 2021-09-04 04:21:28 | Aguascalientes, Mexico | |||
178101 | 178101 | 2021-09-02 | Mexico | Aguascalientes | 31341 | 2621 | 0 | 21.8853 | -102.2916 | 2021-09-03 04:21:20 | Aguascalientes, Mexico | |||
67136 | 67136 | 2021-09-01 | Mexico | Aguascalientes | 31186 | 2611 | 0 | 21.8853 | -102.2916 | 2021-09-02 04:21:15 | Aguascalientes, Mexico | |||
2067978 | 2067978 | 2021-08-31 | Mexico | Aguascalientes | 31027 | 2604 | 0 | 21.8853 | -102.2916 | 2021-09-01 04:21:38 | Aguascalientes, Mexico | |||
1775432 | 1775432 | 2021-08-30 | Mexico | Aguascalientes | 30928 | 2587 | 0 | 21.8853 | -102.2916 | 2021-08-31 04:21:46 | Aguascalientes, Mexico | |||
3892006 | 3892006 | 2021-08-29 | Mexico | Aguascalientes | 30898 | 2587 | 0 | 21.8853 | -102.2916 | 2021-08-30 04:21:23 | Aguascalientes, Mexico | |||
2793109 | 2793109 | 2021-08-28 | Mexico | Aguascalientes | 30894 | 2587 | 0 | 21.8853 | -102.2916 | 2021-08-29 04:21:14 | Aguascalientes, Mexico | |||
2923268 | 2923268 | 2021-08-27 | Mexico | Aguascalientes | 30755 | 2582 | 0 | 21.8853 | -102.2916 | 2021-08-28 04:21:28 | Aguascalientes, Mexico | |||
1596282 | 1596282 | 2021-08-26 | Mexico | Aguascalientes | 30518 | 2572 | 0 | 21.8853 | -102.2916 | 2021-08-27 04:21:37 | Aguascalientes, Mexico | |||
32491 | 32491 | 2021-08-25 | Mexico | Aguascalientes | 30389 | 2572 | 0 | 21.8853 | -102.2916 | 2021-08-26 04:21:28 | Aguascalientes, Mexico | |||
3105530 | 3105530 | 2021-08-24 | Mexico | Aguascalientes | 30262 | 2566 | 0 | 21.8853 | -102.2916 | 2021-08-25 04:21:41 | Aguascalientes, Mexico | |||
3165701 | 3165701 | 2021-08-23 | Mexico | Aguascalientes | 30116 | 2559 | 0 | 21.8853 | -102.2916 | 2021-08-24 04:21:19 | Aguascalientes, Mexico | |||
2175628 | 2175628 | 2021-08-22 | Mexico | Aguascalientes | 30087 | 2559 | 0 | 21.8853 | -102.2916 | 2021-08-23 04:21:27 | Aguascalientes, Mexico | |||
3555724 | 3555724 | 2021-08-21 | Mexico | Aguascalientes | 30085 | 2559 | 0 | 21.8853 | -102.2916 | 2021-08-22 04:21:29 | Aguascalientes, Mexico | |||
1854066 | 1854066 | 2021-08-20 | Mexico | Aguascalientes | 29914 | 2554 | 0 | 21.8853 | -102.2916 | 2021-08-21 04:21:38 | Aguascalientes, Mexico | |||
511773 | 511773 | 2021-08-19 | Mexico | Aguascalientes | 29715 | 2551 | 0 | 21.8853 | -102.2916 | 2021-08-20 04:21:33 | Aguascalientes, Mexico | |||
2518252 | 2518252 | 2021-08-18 | Mexico | Aguascalientes | 29529 | 2548 | 0 | 21.8853 | -102.2916 | 2021-08-19 04:21:15 | Aguascalientes, Mexico | |||
245344 | 245344 | 2021-08-17 | Mexico | Aguascalientes | 29348 | 2534 | 0 | 21.8853 | -102.2916 | 2021-08-18 04:21:35 | Aguascalientes, Mexico | |||
1604307 | 1604307 | 2021-08-16 | Mexico | Aguascalientes | 29254 | 2531 | 0 | 21.8853 | -102.2916 | 2021-08-17 04:21:49 | Aguascalientes, Mexico | |||
103401 | 103401 | 2021-08-15 | Mexico | Aguascalientes | 29239 | 2529 | 0 | 21.8853 | -102.2916 | 2021-08-16 04:21:31 | Aguascalientes, Mexico | |||
507759 | 507759 | 2021-08-14 | Mexico | Aguascalientes | 29239 | 2529 | 0 | 21.8853 | -102.2916 | 2021-08-15 04:21:41 | Aguascalientes, Mexico | |||
1483631 | 1483631 | 2021-08-13 | Mexico | Aguascalientes | 29095 | 2522 | 0 | 21.8853 | -102.2916 | 2021-08-14 04:21:25 | Aguascalientes, Mexico | |||
2899761 | 2899761 | 2021-08-12 | Mexico | Aguascalientes | 29004 | 2519 | 0 | 21.8853 | -102.2916 | 2021-08-13 04:21:24 | Aguascalientes, Mexico | |||
1342365 | 1342365 | 2021-08-11 | Mexico | Aguascalientes | 28872 | 2517 | 0 | 21.8853 | -102.2916 | 2021-08-12 04:21:25 | Aguascalientes, Mexico | |||
2351512 | 2351512 | 2021-08-10 | Mexico | Aguascalientes | 28746 | 2516 | 0 | 21.8853 | -102.2916 | 2021-08-11 04:21:58 | Aguascalientes, Mexico | |||
650041 | 650041 | 2021-08-09 | Mexico | Aguascalientes | 28596 | 2504 | 0 | 21.8853 | -102.2916 | 2021-08-10 04:21:27 | Aguascalientes, Mexico | |||
589703 | 589703 | 2021-08-08 | Mexico | Aguascalientes | 28593 | 2504 | 0 | 21.8853 | -102.2916 | 2021-08-09 04:21:24 | Aguascalientes, Mexico | |||
2203715 | 2203715 | 2021-08-07 | Mexico | Aguascalientes | 28586 | 2504 | 0 | 21.8853 | -102.2916 | 2021-08-08 04:21:33 | Aguascalientes, Mexico | |||
1117665 | 1117665 | 2021-08-06 | Mexico | Aguascalientes | 28502 | 2501 | 0 | 21.8853 | -102.2916 | 2021-08-07 04:21:30 | Aguascalientes, Mexico | |||
1956602 | 1956602 | 2021-08-05 | Mexico | Aguascalientes | 28361 | 2500 | 0 | 21.8853 | -102.2916 | 2021-08-06 04:21:18 | Aguascalientes, Mexico | |||
331981 | 331981 | 2021-08-04 | Mexico | Aguascalientes | 28189 | 2497 | 0 | 25692 | 21.8853 | -102.2916 | 2021-08-05 04:21:51 | Aguascalientes, Mexico | ||
3468252 | 3468252 | 2021-08-03 | Mexico | Aguascalientes | 28044 | 2496 | 0 | 25548 | 21.8853 | -102.2916 | 2021-08-04 04:21:25 | Aguascalientes, Mexico | ||
3683526 | 3683526 | 2021-08-02 | Mexico | Aguascalientes | 27946 | 2494 | 0 | 25452 | 21.8853 | -102.2916 | 2021-08-03 04:21:39 | Aguascalientes, Mexico | ||
3015425 | 3015425 | 2021-08-01 | Mexico | Aguascalientes | 27921 | 2494 | 0 | 25427 | 21.8853 | -102.2916 | 2021-08-02 04:21:36 | Aguascalientes, Mexico | ||
3904048 | 3904048 | 2021-07-31 | Mexico | Aguascalientes | 27917 | 2492 | 0 | 25425 | 21.8853 | -102.2916 | 2021-08-01 04:21:50 | Aguascalientes, Mexico | ||
3296253 | 3296253 | 2021-07-30 | Mexico | Aguascalientes | 27828 | 2490 | 0 | 25338 | 21.8853 | -102.2916 | 2021-07-31 04:21:35 | Aguascalientes, Mexico | ||
3385464 | 3385464 | 2021-07-29 | Mexico | Aguascalientes | 27755 | 2489 | 0 | 25266 | 21.8853 | -102.2916 | 2021-07-30 04:21:34 | Aguascalientes, Mexico | ||
408369 | 408369 | 2021-07-28 | Mexico | Aguascalientes | 27672 | 2488 | 0 | 25184 | 21.8853 | -102.2916 | 2021-07-29 04:21:33 | Aguascalientes, Mexico | ||
1306230 | 1306230 | 2021-07-27 | Mexico | Aguascalientes | 27542 | 2487 | 0 | 25055 | 21.8853 | -102.2916 | 2021-07-28 04:21:39 | Aguascalientes, Mexico | ||
3218373 | 3218373 | 2021-07-26 | Mexico | Aguascalientes | 27422 | 2485 | 0 | 24937 | 21.8853 | -102.2916 | 2021-07-27 04:21:18 | Aguascalientes, Mexico | ||
1378582 | 1378582 | 2021-07-25 | Mexico | Aguascalientes | 27421 | 2485 | 0 | 24936 | 21.8853 | -102.2916 | 2021-07-26 04:21:28 | Aguascalientes, Mexico | ||
1330322 | 1330322 | 2021-07-24 | Mexico | Aguascalientes | 27420 | 2485 | 0 | 24935 | 21.8853 | -102.2916 | 2021-07-25 04:22:12 | Aguascalientes, Mexico | ||
3137626 | 3137626 | 2021-07-23 | Mexico | Aguascalientes | 27359 | 2485 | 0 | 24874 | 21.8853 | -102.2916 | 2021-07-24 00:21:36 | Aguascalientes, Mexico | ||
3476386 | 3476386 | 2021-07-22 | Mexico | Aguascalientes | 27303 | 2483 | 0 | 24820 | 21.8853 | -102.2916 | 2021-07-23 04:21:29 | Aguascalientes, Mexico | ||
3331605 | 3331605 | 2021-07-21 | Mexico | Aguascalientes | 27255 | 2482 | 0 | 24773 | 21.8853 | -102.2916 | 2021-07-22 04:21:19 | Aguascalientes, Mexico | ||
2371586 | 2371586 | 2021-07-20 | Mexico | Aguascalientes | 27169 | 2482 | 0 | 24687 | 21.8853 | -102.2916 | 2021-07-21 04:21:40 | Aguascalientes, Mexico | ||
483665 | 483665 | 2021-07-19 | Mexico | Aguascalientes | 27107 | 2479 | 0 | 24628 | 21.8853 | -102.2916 | 2021-07-20 04:21:48 | Aguascalientes, Mexico | ||
2673888 | 2673888 | 2021-07-18 | Mexico | Aguascalientes | 27095 | 2479 | 0 | 24616 | 21.8853 | -102.2916 | 2021-07-19 04:21:24 | Aguascalientes, Mexico | ||
3706200 | 3706200 | 2021-07-17 | Mexico | Aguascalientes | 27095 | 2479 | 0 | 24616 | 21.8853 | -102.2916 | 2021-07-18 04:22:07 | Aguascalientes, Mexico | ||
2947431 | 2947431 | 2021-07-16 | Mexico | Aguascalientes | 27052 | 2478 | 0 | 24574 | 21.8853 | -102.2916 | 2021-07-17 04:22:22 | Aguascalientes, Mexico | ||
296087 | 296087 | 2021-07-15 | Mexico | Aguascalientes | 27011 | 2478 | 0 | 24533 | 21.8853 | -102.2916 | 2021-07-16 04:21:22 | Aguascalientes, Mexico | ||
3632032 | 3632032 | 2021-07-14 | Mexico | Aguascalientes | 26966 | 2478 | 0 | 24488 | 21.8853 | -102.2916 | 2021-07-15 04:21:48 | Aguascalientes, Mexico | ||
578907 | 578907 | 2021-07-13 | Mexico | Aguascalientes | 26937 | 2478 | 0 | 24459 | 21.8853 | -102.2916 | 2021-07-14 04:21:35 | Aguascalientes, Mexico | ||
3741156 | 3741156 | 2021-07-12 | Mexico | Aguascalientes | 26904 | 2476 | 0 | 24428 | 21.8853 | -102.2916 | 2021-07-13 04:21:18 | Aguascalientes, Mexico | ||
3659669 | 3659669 | 2021-07-11 | Mexico | Aguascalientes | 26903 | 2476 | 0 | 24427 | 21.8853 | -102.2916 | 2021-07-12 04:21:34 | Aguascalientes, Mexico | ||
625953 | 625953 | 2021-07-10 | Mexico | Aguascalientes | 26901 | 2476 | 0 | 24425 | 21.8853 | -102.2916 | 2021-07-11 04:21:43 | Aguascalientes, Mexico | ||
829672 | 829672 | 2021-07-09 | Mexico | Aguascalientes | 26886 | 2476 | 0 | 24410 | 21.8853 | -102.2916 | 2021-07-10 04:21:25 | Aguascalientes, Mexico | ||
778436 | 778436 | 2021-07-08 | Mexico | Aguascalientes | 26869 | 2476 | 0 | 24393 | 21.8853 | -102.2916 | 2021-07-09 04:21:21 | Aguascalientes, Mexico | ||
1440658 | 1440658 | 2021-07-07 | Mexico | Aguascalientes | 26855 | 2471 | 0 | 24384 | 21.8853 | -102.2916 | 2021-07-08 04:21:26 | Aguascalientes, Mexico | ||
2693763 | 2693763 | 2021-07-06 | Mexico | Aguascalientes | 26834 | 2469 | 0 | 24365 | 21.8853 | -102.2916 | 2021-07-07 04:21:20 | Aguascalientes, Mexico | ||
1932512 | 1932512 | 2021-07-05 | Mexico | Aguascalientes | 26818 | 2470 | 0 | 24348 | 21.8853 | -102.2916 | 2021-07-06 04:21:32 | 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]);