daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
954 rows where country_or_region = "Mexico" and province_or_state = "Aguascalientes" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
day | country_or_region | province_or_state | admin2 | fips ▼ | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-12-02 | Mexico | Aguascalientes | 37220 | 2941 | 0 | 21.8853 | -102.2916 | 2021-12-03 04:23:05 | Aguascalientes, Mexico | |||
2021-10-28 | Mexico | Aguascalientes | 35722 | 2853 | 0 | 21.8853 | -102.2916 | 2021-10-29 04:22:03 | Aguascalientes, Mexico | |||
2020-10-25 | Mexico | Aguascalientes | 9040 | 810 | 7310 | 920 | 21.8853 | -102.2916 | 2020-10-26 04:25:02 | Aguascalientes, Mexico | ||
2021-01-26 | Mexico | Aguascalientes | 20172 | 1624 | 0 | 18548 | 21.8853 | -102.2916 | 2021-01-27 05:23:41 | Aguascalientes, Mexico | ||
2021-09-18 | Mexico | Aguascalientes | 32664 | 2676 | 0 | 21.8853 | -102.2916 | 2021-09-19 04:21:34 | Aguascalientes, Mexico | |||
2021-05-28 | Mexico | Aguascalientes | 26492 | 2418 | 0 | 24074 | 21.8853 | -102.2916 | 2021-05-29 04:20:41 | Aguascalientes, Mexico | ||
2022-03-20 | Mexico | Aguascalientes | 63293 | 3482 | 0 | 21.8853 | -102.2916 | 2022-03-21 04:20:50 | Aguascalientes, Mexico | |||
2021-11-11 | Mexico | Aguascalientes | 36280 | 2891 | 0 | 21.8853 | -102.2916 | 2021-11-12 04:22:01 | Aguascalientes, Mexico | |||
2021-08-25 | Mexico | Aguascalientes | 30389 | 2572 | 0 | 21.8853 | -102.2916 | 2021-08-26 04:21:28 | Aguascalientes, Mexico | |||
2021-04-12 | Mexico | Aguascalientes | 25353 | 2273 | 0 | 23080 | 21.8853 | -102.2916 | 2021-04-13 04:20:37 | Aguascalientes, Mexico | ||
2021-11-02 | Mexico | Aguascalientes | 35846 | 2868 | 0 | 21.8853 | -102.2916 | 2021-11-03 06:22:09 | Aguascalientes, Mexico | |||
2021-05-29 | Mexico | Aguascalientes | 26501 | 2418 | 0 | 24083 | 21.8853 | -102.2916 | 2021-05-30 04:20:55 | Aguascalientes, Mexico | ||
2021-03-07 | Mexico | Aguascalientes | 23462 | 2035 | 0 | 21427 | 21.8853 | -102.2916 | 2021-03-08 05:24:48 | Aguascalientes, Mexico | ||
2020-07-23 | Mexico | Aguascalientes | 3620 | 224 | 2889 | 507 | 21.8853 | -102.2916 | 2020-07-24 03:34:53 | Aguascalientes, Mexico | ||
2022-11-12 | Mexico | Aguascalientes | 84631 | 3591 | 0 | 21.8853 | -102.2916 | 2022-11-13 04:21:14 | Aguascalientes, Mexico | |||
2021-09-01 | Mexico | Aguascalientes | 31186 | 2611 | 0 | 21.8853 | -102.2916 | 2021-09-02 04:21:15 | Aguascalientes, Mexico | |||
2022-02-07 | Mexico | Aguascalientes | 53290 | 3282 | 0 | 21.8853 | -102.2916 | 2022-02-08 04:21:15 | Aguascalientes, Mexico | |||
2020-12-03 | Mexico | Aguascalientes | 14083 | 1123 | 0 | 12960 | 21.8853 | -102.2916 | 2020-12-04 05:27:27 | Aguascalientes, Mexico | ||
2020-10-14 | Mexico | Aguascalientes | 8054 | 725 | 6741 | 588 | 21.8853 | -102.2916 | 2020-10-15 04:24:28 | Aguascalientes, Mexico | ||
2021-05-25 | Mexico | Aguascalientes | 26454 | 2409 | 0 | 24045 | 21.8853 | -102.2916 | 2021-05-26 04:20:35 | Aguascalientes, Mexico | ||
2021-11-09 | Mexico | Aguascalientes | 36148 | 2888 | 0 | 21.8853 | -102.2916 | 2021-11-10 04:21:38 | Aguascalientes, Mexico | |||
2022-07-23 | Mexico | Aguascalientes | 77059 | 3526 | 0 | 21.8853 | -102.2916 | 2022-07-24 04:20:47 | Aguascalientes, Mexico | |||
2020-08-04 | Mexico | Aguascalientes | 4229 | 269 | 3600 | 360 | 21.8853 | -102.2916 | 2020-08-05 04:34:43 | Aguascalientes, Mexico | ||
2022-01-14 | Mexico | Aguascalientes | 42387 | 3070 | 0 | 21.8853 | -102.2916 | 2022-01-15 04:21:07 | Aguascalientes, Mexico | |||
2021-08-15 | Mexico | Aguascalientes | 29239 | 2529 | 0 | 21.8853 | -102.2916 | 2021-08-16 04:21:31 | Aguascalientes, Mexico | |||
2021-06-19 | Mexico | Aguascalientes | 26688 | 2456 | 0 | 24232 | 21.8853 | -102.2916 | 2021-06-20 04:21:48 | Aguascalientes, Mexico | ||
2022-09-06 | Mexico | Aguascalientes | 84093 | 3558 | 0 | 21.8853 | -102.2916 | 2022-09-07 04:20:59 | Aguascalientes, Mexico | |||
2020-07-19 | Mexico | Aguascalientes | 3417 | 207 | 2654 | 556 | 21.8853 | -102.2916 | 2020-07-20 05:34:40 | Aguascalientes, Mexico | ||
2020-11-18 | Mexico | Aguascalientes | 11235 | 962 | 0 | 10273 | 21.8853 | -102.2916 | 2020-11-19 05:25:23 | Aguascalientes, Mexico | ||
2022-01-09 | Mexico | Aguascalientes | 41186 | 3048 | 0 | 21.8853 | -102.2916 | 2022-01-10 04:22:07 | Aguascalientes, Mexico | |||
2022-10-04 | Mexico | Aguascalientes | 84529 | 3585 | 0 | 21.8853 | -102.2916 | 2022-10-05 04:23:06 | Aguascalientes, Mexico | |||
2021-12-04 | Mexico | Aguascalientes | 37363 | 2946 | 0 | 21.8853 | -102.2916 | 2021-12-05 04:22:25 | Aguascalientes, Mexico | |||
2022-07-09 | Mexico | Aguascalientes | 72104 | 3522 | 0 | 21.8853 | -102.2916 | 2022-07-10 04:20:54 | Aguascalientes, Mexico | |||
2020-08-15 | Mexico | Aguascalientes | 4771 | 324 | 4087 | 360 | 21.8853 | -102.2916 | 2020-08-16 04:27:42 | Aguascalientes, Mexico | ||
2021-11-29 | Mexico | Aguascalientes | 37083 | 2929 | 0 | 21.8853 | -102.2916 | 2021-11-30 04:22:53 | Aguascalientes, Mexico | |||
2021-01-08 | Mexico | Aguascalientes | 17612 | 1428 | 0 | 16184 | 21.8853 | -102.2916 | 2021-01-09 05:22:18 | Aguascalientes, Mexico | ||
2022-03-29 | Mexico | Aguascalientes | 63836 | 3485 | 0 | 21.8853 | -102.2916 | 2022-03-30 04:20:45 | Aguascalientes, Mexico | |||
2021-11-19 | Mexico | Aguascalientes | 36579 | 2902 | 0 | 21.8853 | -102.2916 | 2021-11-20 04:22:17 | Aguascalientes, Mexico | |||
2022-06-21 | Mexico | Aguascalientes | 68954 | 3519 | 0 | 21.8853 | -102.2916 | 2022-06-22 04:20:54 | Aguascalientes, Mexico | |||
2021-04-16 | Mexico | Aguascalientes | 25605 | 2309 | 0 | 23296 | 21.8853 | -102.2916 | 2021-04-17 04:20:40 | Aguascalientes, Mexico | ||
2020-07-27 | Mexico | Aguascalientes | 3777 | 243 | 3122 | 412 | 21.8853 | -102.2916 | 2020-07-28 04:58:43 | Aguascalientes, Mexico | ||
2021-09-02 | Mexico | Aguascalientes | 31341 | 2621 | 0 | 21.8853 | -102.2916 | 2021-09-03 04:21:20 | Aguascalientes, Mexico | |||
2021-02-21 | Mexico | Aguascalientes | 22621 | 1950 | 0 | 20671 | 21.8853 | -102.2916 | 2021-02-22 05:24:21 | Aguascalientes, Mexico | ||
2022-02-13 | Mexico | Aguascalientes | 55525 | 3374 | 0 | 21.8853 | -102.2916 | 2022-02-14 04:20:51 | Aguascalientes, Mexico | |||
2021-01-11 | Mexico | Aguascalientes | 17752 | 1447 | 0 | 16305 | 21.8853 | -102.2916 | 2021-01-12 05:22:15 | Aguascalientes, Mexico | ||
2020-08-31 | Mexico | Aguascalientes | 5631 | 405 | 4847 | 379 | 21.8853 | -102.2916 | 2020-09-01 04:28:31 | Aguascalientes, Mexico | ||
2022-10-19 | Mexico | Aguascalientes | 84615 | 3591 | 0 | 21.8853 | -102.2916 | 2022-10-20 04:22:59 | Aguascalientes, Mexico | |||
2020-12-25 | Mexico | Aguascalientes | 16499 | 1330 | 0 | 15169 | 21.8853 | -102.2916 | 2020-12-26 05:22:28 | Aguascalientes, Mexico | ||
2020-08-19 | Mexico | Aguascalientes | 4928 | 347 | 4206 | 375 | 21.8853 | -102.2916 | 2020-08-20 04:27:43 | Aguascalientes, Mexico | ||
2020-10-29 | Mexico | Aguascalientes | 9450 | 842 | 7719 | 889 | 21.8853 | -102.2916 | 2020-10-30 04:24:49 | Aguascalientes, Mexico | ||
2020-06-08 | Mexico | Aguascalientes | 1160 | 53 | 792 | 315 | 21.8853 | -102.2916 | 2020-06-09 03:33:03 | Aguascalientes, Mexico | ||
2022-12-26 | Mexico | Aguascalientes | 85637 | 3594 | 0 | 21.8853 | -102.2916 | 2022-12-27 04:21:07 | Aguascalientes, Mexico | |||
2022-05-09 | Mexico | Aguascalientes | 66137 | 3502 | 0 | 21.8853 | -102.2916 | 2022-05-10 04:20:50 | Aguascalientes, Mexico | |||
2022-05-31 | Mexico | Aguascalientes | 67535 | 3509 | 0 | 21.8853 | -102.2916 | 2022-06-01 04:20:55 | Aguascalientes, Mexico | |||
2022-02-11 | Mexico | Aguascalientes | 54439 | 3334 | 0 | 21.8853 | -102.2916 | 2022-02-12 04:21:06 | Aguascalientes, Mexico | |||
2021-01-18 | Mexico | Aguascalientes | 18519 | 1498 | 0 | 17021 | 21.8853 | -102.2916 | 2021-01-19 05:22:15 | Aguascalientes, Mexico | ||
2021-04-02 | Mexico | Aguascalientes | 24936 | 2162 | 0 | 22774 | 21.8853 | -102.2916 | 2021-04-03 04:20:44 | Aguascalientes, Mexico | ||
2021-08-17 | Mexico | Aguascalientes | 29348 | 2534 | 0 | 21.8853 | -102.2916 | 2021-08-18 04:21:35 | Aguascalientes, Mexico | |||
2021-09-04 | Mexico | Aguascalientes | 31675 | 2639 | 0 | 21.8853 | -102.2916 | 2021-09-05 04:21:33 | Aguascalientes, Mexico | |||
2022-09-08 | Mexico | Aguascalientes | 84093 | 3558 | 0 | 21.8853 | -102.2916 | 2022-09-09 04:21:11 | Aguascalientes, Mexico | |||
2022-12-10 | Mexico | Aguascalientes | 84925 | 3592 | 0 | 21.8853 | -102.2916 | 2022-12-11 04:20:50 | Aguascalientes, Mexico | |||
2022-03-15 | Mexico | Aguascalientes | 62441 | 3479 | 0 | 21.8853 | -102.2916 | 2022-03-16 04:20:50 | Aguascalientes, Mexico | |||
2020-05-21 | Mexico | Aguascalientes | 586 | 21 | 402 | 163 | 21.8853 | -102.2916 | 2020-05-22 02:36:51 | Aguascalientes, Mexico | ||
2020-11-10 | Mexico | Aguascalientes | 10866 | 902 | 8450 | 1514 | 21.8853 | -102.2916 | 2020-11-11 05:25:30 | Aguascalientes, Mexico | ||
2021-11-03 | Mexico | Aguascalientes | 35896 | 2876 | 0 | 21.8853 | -102.2916 | 2021-11-04 04:22:20 | Aguascalientes, Mexico | |||
2021-02-24 | Mexico | Aguascalientes | 22870 | 1984 | 0 | 20886 | 21.8853 | -102.2916 | 2021-02-25 05:24:57 | Aguascalientes, Mexico | ||
2020-06-15 | Mexico | Aguascalientes | 1467 | 71 | 1078 | 318 | 21.8853 | -102.2916 | 2020-06-16 04:33:09 | Aguascalientes, Mexico | ||
2021-10-31 | Mexico | Aguascalientes | 35837 | 2868 | 0 | 21.8853 | -102.2916 | 2021-11-01 04:22:01 | Aguascalientes, Mexico | |||
2022-11-15 | Mexico | Aguascalientes | 84638 | 3591 | 0 | 21.8853 | -102.2916 | 2022-11-16 04:21:09 | Aguascalientes, Mexico | |||
2021-07-15 | Mexico | Aguascalientes | 27011 | 2478 | 0 | 24533 | 21.8853 | -102.2916 | 2021-07-16 04:21:22 | Aguascalientes, Mexico | ||
2020-07-01 | Mexico | Aguascalientes | 2363 | 151 | 1877 | 335 | 21.8853 | -102.2916 | 2020-07-02 04:33:46 | Aguascalientes, Mexico | ||
2022-04-16 | Mexico | Aguascalientes | 65451 | 3497 | 0 | 21.8853 | -102.2916 | 2022-04-17 04:20:59 | Aguascalientes, Mexico | |||
2022-12-13 | Mexico | Aguascalientes | 85042 | 3592 | 0 | 21.8853 | -102.2916 | 2022-12-14 04:21:04 | Aguascalientes, Mexico | |||
2022-11-13 | Mexico | Aguascalientes | 84631 | 3591 | 0 | 21.8853 | -102.2916 | 2022-11-14 04:21:09 | Aguascalientes, Mexico | |||
2022-02-12 | Mexico | Aguascalientes | 55525 | 3374 | 0 | 21.8853 | -102.2916 | 2022-02-13 04:21:00 | Aguascalientes, Mexico | |||
2022-10-30 | Mexico | Aguascalientes | 84545 | 3591 | 0 | 21.8853 | -102.2916 | 2022-10-31 04:21:36 | Aguascalientes, Mexico | |||
2020-07-20 | Mexico | Aguascalientes | 3486 | 209 | 2745 | 532 | 21.8853 | -102.2916 | 2020-07-21 04:38:46 | Aguascalientes, Mexico | ||
2022-12-27 | Mexico | Aguascalientes | 85740 | 3594 | 0 | 21.8853 | -102.2916 | 2022-12-28 04:21:04 | Aguascalientes, Mexico | |||
2021-08-04 | Mexico | Aguascalientes | 28189 | 2497 | 0 | 25692 | 21.8853 | -102.2916 | 2021-08-05 04:21:51 | Aguascalientes, Mexico | ||
2022-03-18 | Mexico | Aguascalientes | 63055 | 3482 | 0 | 21.8853 | -102.2916 | 2022-03-19 04:20:47 | Aguascalientes, Mexico | |||
2021-02-03 | Mexico | Aguascalientes | 21251 | 1771 | 0 | 19480 | 21.8853 | -102.2916 | 2021-02-04 05:22:26 | Aguascalientes, Mexico | ||
2020-09-14 | Mexico | Aguascalientes | 6441 | 508 | 5620 | 313 | 21.8853 | -102.2916 | 2020-09-15 03:22:50 | Aguascalientes, Mexico | ||
2022-12-14 | Mexico | Aguascalientes | 85042 | 3592 | 0 | 21.8853 | -102.2916 | 2022-12-15 04:20:58 | Aguascalientes, Mexico | |||
2021-03-11 | Mexico | Aguascalientes | 23708 | 2060 | 0 | 21648 | 21.8853 | -102.2916 | 2021-03-12 05:26:50 | Aguascalientes, Mexico | ||
2022-03-11 | Mexico | Aguascalientes | 62073 | 3472 | 0 | 21.8853 | -102.2916 | 2022-03-12 04:20:50 | Aguascalientes, Mexico | |||
2022-05-07 | Mexico | Aguascalientes | 65865 | 3501 | 0 | 21.8853 | -102.2916 | 2022-05-08 04:20:49 | Aguascalientes, Mexico | |||
2020-07-16 | Mexico | Aguascalientes | 3207 | 201 | 2605 | 401 | 21.8853 | -102.2916 | 2020-07-17 04:34:50 | Aguascalientes, Mexico | ||
2020-08-08 | Mexico | Aguascalientes | 4504 | 284 | 3786 | 434 | 21.8853 | -102.2916 | 2020-08-09 04:34:54 | Aguascalientes, Mexico | ||
2022-09-13 | Mexico | Aguascalientes | 84249 | 3560 | 0 | 21.8853 | -102.2916 | 2022-09-14 04:20:44 | Aguascalientes, Mexico | |||
2020-11-06 | Mexico | Aguascalientes | 10133 | 896 | 8360 | 877 | 21.8853 | -102.2916 | 2020-11-07 05:24:52 | Aguascalientes, Mexico | ||
2021-04-30 | Mexico | Aguascalientes | 26037 | 2371 | 0 | 23666 | 21.8853 | -102.2916 | 2021-05-01 04:20:47 | Aguascalientes, Mexico | ||
2022-09-23 | Mexico | Aguascalientes | 84419 | 3579 | 0 | 21.8853 | -102.2916 | 2022-09-24 04:21:40 | Aguascalientes, Mexico | |||
2021-04-04 | Mexico | Aguascalientes | 24951 | 2162 | 0 | 22789 | 21.8853 | -102.2916 | 2021-04-05 04:20:35 | Aguascalientes, Mexico | ||
2020-11-27 | Mexico | Aguascalientes | 12998 | 1099 | 0 | 11899 | 21.8853 | -102.2916 | 2020-11-28 05:25:50 | Aguascalientes, Mexico | ||
2022-10-07 | Mexico | Aguascalientes | 84585 | 3590 | 0 | 21.8853 | -102.2916 | 2022-10-08 04:22:56 | Aguascalientes, Mexico | |||
2021-06-29 | Mexico | Aguascalientes | 26770 | 2469 | 0 | 24301 | 21.8853 | -102.2916 | 2021-06-30 04:21:41 | Aguascalientes, Mexico | ||
2021-12-07 | Mexico | Aguascalientes | 37416 | 2955 | 0 | 21.8853 | -102.2916 | 2021-12-08 04:22:46 | Aguascalientes, Mexico | |||
2021-07-28 | Mexico | Aguascalientes | 27672 | 2488 | 0 | 25184 | 21.8853 | -102.2916 | 2021-07-29 04:21:33 | Aguascalientes, Mexico | ||
2020-07-05 | Mexico | Aguascalientes | 2440 | 158 | 2065 | 217 | 21.8853 | -102.2916 | 2020-07-06 04:33:57 | Aguascalientes, Mexico | ||
2022-09-18 | Mexico | Aguascalientes | 84329 | 3569 | 0 | 21.8853 | -102.2916 | 2022-09-19 04:21:49 | Aguascalientes, Mexico |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;