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 active
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: last_update (date)
day (date) >30 ✖
- 2020-05-20 1
- 2020-05-21 1
- 2020-05-22 1
- 2020-05-23 1
- 2020-05-24 1
- 2020-05-25 1
- 2020-05-26 1
- 2020-05-27 1
- 2020-05-28 1
- 2020-05-29 1
- 2020-05-30 1
- 2020-05-31 1
- 2020-06-01 1
- 2020-06-02 1
- 2020-06-03 1
- 2020-06-04 1
- 2020-06-05 1
- 2020-06-06 1
- 2020-06-07 1
- 2020-06-08 1
- 2020-06-09 1
- 2020-06-10 1
- 2020-06-11 1
- 2020-06-12 1
- 2020-06-13 1
- 2020-06-14 1
- 2020-06-15 1
- 2020-06-16 1
- 2020-06-17 1
- 2020-06-18 1
- …
province_or_state 1
- Aguascalientes · 954 ✖
country_or_region 1
- Mexico · 954 ✖
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active ▼ | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
406 | 406 | 2021-12-02 | Mexico | Aguascalientes | 37220 | 2941 | 0 | 21.8853 | -102.2916 | 2021-12-03 04:23:05 | Aguascalientes, Mexico | |||
4422 | 4422 | 2021-10-28 | Mexico | Aguascalientes | 35722 | 2853 | 0 | 21.8853 | -102.2916 | 2021-10-29 04:22:03 | Aguascalientes, Mexico | |||
16430 | 16430 | 2021-09-18 | Mexico | Aguascalientes | 32664 | 2676 | 0 | 21.8853 | -102.2916 | 2021-09-19 04:21:34 | Aguascalientes, Mexico | |||
24477 | 24477 | 2022-03-20 | Mexico | Aguascalientes | 63293 | 3482 | 0 | 21.8853 | -102.2916 | 2022-03-21 04:20:50 | Aguascalientes, Mexico | |||
28492 | 28492 | 2021-11-11 | Mexico | Aguascalientes | 36280 | 2891 | 0 | 21.8853 | -102.2916 | 2021-11-12 04:22:01 | Aguascalientes, Mexico | |||
32491 | 32491 | 2021-08-25 | Mexico | Aguascalientes | 30389 | 2572 | 0 | 21.8853 | -102.2916 | 2021-08-26 04:21:28 | Aguascalientes, Mexico | |||
43784 | 43784 | 2021-11-02 | Mexico | Aguascalientes | 35846 | 2868 | 0 | 21.8853 | -102.2916 | 2021-11-03 06:22:09 | Aguascalientes, Mexico | |||
63139 | 63139 | 2022-11-12 | Mexico | Aguascalientes | 84631 | 3591 | 0 | 21.8853 | -102.2916 | 2022-11-13 04:21:14 | Aguascalientes, Mexico | |||
67136 | 67136 | 2021-09-01 | Mexico | Aguascalientes | 31186 | 2611 | 0 | 21.8853 | -102.2916 | 2021-09-02 04:21:15 | Aguascalientes, Mexico | |||
71167 | 71167 | 2022-02-07 | Mexico | Aguascalientes | 53290 | 3282 | 0 | 21.8853 | -102.2916 | 2022-02-08 04:21:15 | Aguascalientes, Mexico | |||
87201 | 87201 | 2021-11-09 | Mexico | Aguascalientes | 36148 | 2888 | 0 | 21.8853 | -102.2916 | 2021-11-10 04:21:38 | Aguascalientes, Mexico | |||
91219 | 91219 | 2022-07-23 | Mexico | Aguascalientes | 77059 | 3526 | 0 | 21.8853 | -102.2916 | 2022-07-24 04:20:47 | Aguascalientes, Mexico | |||
99402 | 99402 | 2022-01-14 | Mexico | Aguascalientes | 42387 | 3070 | 0 | 21.8853 | -102.2916 | 2022-01-15 04:21:07 | Aguascalientes, Mexico | |||
103401 | 103401 | 2021-08-15 | Mexico | Aguascalientes | 29239 | 2529 | 0 | 21.8853 | -102.2916 | 2021-08-16 04:21:31 | Aguascalientes, Mexico | |||
114829 | 114829 | 2022-09-06 | Mexico | Aguascalientes | 84093 | 3558 | 0 | 21.8853 | -102.2916 | 2022-09-07 04:20:59 | Aguascalientes, Mexico | |||
126809 | 126809 | 2022-01-09 | Mexico | Aguascalientes | 41186 | 3048 | 0 | 21.8853 | -102.2916 | 2022-01-10 04:22:07 | Aguascalientes, Mexico | |||
130827 | 130827 | 2022-10-04 | Mexico | Aguascalientes | 84529 | 3585 | 0 | 21.8853 | -102.2916 | 2022-10-05 04:23:06 | Aguascalientes, Mexico | |||
138047 | 138047 | 2021-12-04 | Mexico | Aguascalientes | 37363 | 2946 | 0 | 21.8853 | -102.2916 | 2021-12-05 04:22:25 | Aguascalientes, Mexico | |||
142065 | 142065 | 2022-07-09 | Mexico | Aguascalientes | 72104 | 3522 | 0 | 21.8853 | -102.2916 | 2022-07-10 04:20:54 | Aguascalientes, Mexico | |||
150060 | 150060 | 2021-11-29 | Mexico | Aguascalientes | 37083 | 2929 | 0 | 21.8853 | -102.2916 | 2021-11-30 04:22:53 | Aguascalientes, Mexico | |||
158089 | 158089 | 2022-03-29 | Mexico | Aguascalientes | 63836 | 3485 | 0 | 21.8853 | -102.2916 | 2022-03-30 04:20:45 | Aguascalientes, Mexico | |||
162104 | 162104 | 2021-11-19 | Mexico | Aguascalientes | 36579 | 2902 | 0 | 21.8853 | -102.2916 | 2021-11-20 04:22:17 | Aguascalientes, Mexico | |||
166122 | 166122 | 2022-06-21 | Mexico | Aguascalientes | 68954 | 3519 | 0 | 21.8853 | -102.2916 | 2022-06-22 04:20:54 | Aguascalientes, Mexico | |||
178101 | 178101 | 2021-09-02 | Mexico | Aguascalientes | 31341 | 2621 | 0 | 21.8853 | -102.2916 | 2021-09-03 04:21:20 | Aguascalientes, Mexico | |||
186147 | 186147 | 2022-02-13 | Mexico | Aguascalientes | 55525 | 3374 | 0 | 21.8853 | -102.2916 | 2022-02-14 04:20:51 | Aguascalientes, Mexico | |||
198336 | 198336 | 2022-10-19 | Mexico | Aguascalientes | 84615 | 3591 | 0 | 21.8853 | -102.2916 | 2022-10-20 04:22:59 | Aguascalientes, Mexico | |||
218057 | 218057 | 2022-12-26 | Mexico | Aguascalientes | 85637 | 3594 | 0 | 21.8853 | -102.2916 | 2022-12-27 04:21:07 | Aguascalientes, Mexico | |||
222072 | 222072 | 2022-05-09 | Mexico | Aguascalientes | 66137 | 3502 | 0 | 21.8853 | -102.2916 | 2022-05-10 04:20:50 | Aguascalientes, Mexico | |||
229304 | 229304 | 2022-05-31 | Mexico | Aguascalientes | 67535 | 3509 | 0 | 21.8853 | -102.2916 | 2022-06-01 04:20:55 | Aguascalientes, Mexico | |||
233319 | 233319 | 2022-02-11 | Mexico | Aguascalientes | 54439 | 3334 | 0 | 21.8853 | -102.2916 | 2022-02-12 04:21:06 | Aguascalientes, Mexico | |||
245344 | 245344 | 2021-08-17 | Mexico | Aguascalientes | 29348 | 2534 | 0 | 21.8853 | -102.2916 | 2021-08-18 04:21:35 | Aguascalientes, Mexico | |||
249358 | 249358 | 2021-09-04 | Mexico | Aguascalientes | 31675 | 2639 | 0 | 21.8853 | -102.2916 | 2021-09-05 04:21:33 | Aguascalientes, Mexico | |||
253391 | 253391 | 2022-09-08 | Mexico | Aguascalientes | 84093 | 3558 | 0 | 21.8853 | -102.2916 | 2022-09-09 04:21:11 | Aguascalientes, Mexico | |||
257407 | 257407 | 2022-12-10 | Mexico | Aguascalientes | 84925 | 3592 | 0 | 21.8853 | -102.2916 | 2022-12-11 04:20:50 | Aguascalientes, Mexico | |||
261609 | 261609 | 2022-03-15 | Mexico | Aguascalientes | 62441 | 3479 | 0 | 21.8853 | -102.2916 | 2022-03-16 04:20:50 | Aguascalientes, Mexico | |||
276259 | 276259 | 2021-11-03 | Mexico | Aguascalientes | 35896 | 2876 | 0 | 21.8853 | -102.2916 | 2021-11-04 04:22:20 | Aguascalientes, Mexico | |||
288072 | 288072 | 2021-10-31 | Mexico | Aguascalientes | 35837 | 2868 | 0 | 21.8853 | -102.2916 | 2021-11-01 04:22:01 | Aguascalientes, Mexico | |||
292090 | 292090 | 2022-11-15 | Mexico | Aguascalientes | 84638 | 3591 | 0 | 21.8853 | -102.2916 | 2022-11-16 04:21:09 | Aguascalientes, Mexico | |||
303945 | 303945 | 2022-04-16 | Mexico | Aguascalientes | 65451 | 3497 | 0 | 21.8853 | -102.2916 | 2022-04-17 04:20:59 | Aguascalientes, Mexico | |||
307962 | 307962 | 2022-12-13 | Mexico | Aguascalientes | 85042 | 3592 | 0 | 21.8853 | -102.2916 | 2022-12-14 04:21:04 | Aguascalientes, Mexico | |||
311978 | 311978 | 2022-11-13 | Mexico | Aguascalientes | 84631 | 3591 | 0 | 21.8853 | -102.2916 | 2022-11-14 04:21:09 | Aguascalientes, Mexico | |||
315993 | 315993 | 2022-02-12 | Mexico | Aguascalientes | 55525 | 3374 | 0 | 21.8853 | -102.2916 | 2022-02-13 04:21:00 | Aguascalientes, Mexico | |||
320010 | 320010 | 2022-10-30 | Mexico | Aguascalientes | 84545 | 3591 | 0 | 21.8853 | -102.2916 | 2022-10-31 04:21:36 | Aguascalientes, Mexico | |||
327984 | 327984 | 2022-12-27 | Mexico | Aguascalientes | 85740 | 3594 | 0 | 21.8853 | -102.2916 | 2022-12-28 04:21:04 | Aguascalientes, Mexico | |||
336013 | 336013 | 2022-03-18 | Mexico | Aguascalientes | 63055 | 3482 | 0 | 21.8853 | -102.2916 | 2022-03-19 04:20:47 | Aguascalientes, Mexico | |||
348374 | 348374 | 2022-12-14 | Mexico | Aguascalientes | 85042 | 3592 | 0 | 21.8853 | -102.2916 | 2022-12-15 04:20:58 | Aguascalientes, Mexico | |||
356403 | 356403 | 2022-03-11 | Mexico | Aguascalientes | 62073 | 3472 | 0 | 21.8853 | -102.2916 | 2022-03-12 04:20:50 | Aguascalientes, Mexico | |||
360419 | 360419 | 2022-05-07 | Mexico | Aguascalientes | 65865 | 3501 | 0 | 21.8853 | -102.2916 | 2022-05-08 04:20:49 | Aguascalientes, Mexico | |||
372274 | 372274 | 2022-09-13 | Mexico | Aguascalientes | 84249 | 3560 | 0 | 21.8853 | -102.2916 | 2022-09-14 04:20:44 | Aguascalientes, Mexico | |||
384301 | 384301 | 2022-09-23 | Mexico | Aguascalientes | 84419 | 3579 | 0 | 21.8853 | -102.2916 | 2022-09-24 04:21:40 | Aguascalientes, Mexico | |||
396342 | 396342 | 2022-10-07 | Mexico | Aguascalientes | 84585 | 3590 | 0 | 21.8853 | -102.2916 | 2022-10-08 04:22:56 | Aguascalientes, Mexico | |||
404370 | 404370 | 2021-12-07 | Mexico | Aguascalientes | 37416 | 2955 | 0 | 21.8853 | -102.2916 | 2021-12-08 04:22:46 | Aguascalientes, Mexico | |||
419413 | 419413 | 2022-09-18 | Mexico | Aguascalientes | 84329 | 3569 | 0 | 21.8853 | -102.2916 | 2022-09-19 04:21:49 | Aguascalientes, Mexico | |||
423427 | 423427 | 2021-10-10 | Mexico | Aguascalientes | 34503 | 2785 | 0 | 21.8853 | -102.2916 | 2021-10-11 04:21:31 | Aguascalientes, Mexico | |||
431435 | 431435 | 2022-11-03 | Mexico | Aguascalientes | 84563 | 3591 | 0 | 21.8853 | -102.2916 | 2022-11-04 04:22:11 | Aguascalientes, Mexico | |||
443431 | 443431 | 2021-10-20 | Mexico | Aguascalientes | 35293 | 2828 | 0 | 21.8853 | -102.2916 | 2021-10-21 04:21:18 | Aguascalientes, Mexico | |||
447447 | 447447 | 2021-11-17 | Mexico | Aguascalientes | 36521 | 2893 | 0 | 21.8853 | -102.2916 | 2021-11-18 04:21:33 | Aguascalientes, Mexico | |||
451465 | 451465 | 2022-12-21 | Mexico | Aguascalientes | 85306 | 3593 | 0 | 21.8853 | -102.2916 | 2022-12-22 04:20:56 | Aguascalientes, Mexico | |||
459456 | 459456 | 2022-02-02 | Mexico | Aguascalientes | 50193 | 3217 | 0 | 21.8853 | -102.2916 | 2022-02-03 04:21:21 | Aguascalientes, Mexico | |||
463473 | 463473 | 2022-05-02 | Mexico | Aguascalientes | 65866 | 3501 | 0 | 21.8853 | -102.2916 | 2022-05-03 04:21:00 | Aguascalientes, Mexico | |||
467488 | 467488 | 2021-10-07 | Mexico | Aguascalientes | 34266 | 2779 | 0 | 21.8853 | -102.2916 | 2021-10-08 04:21:25 | Aguascalientes, Mexico | |||
475520 | 475520 | 2022-06-26 | Mexico | Aguascalientes | 69561 | 3519 | 0 | 21.8853 | -102.2916 | 2022-06-27 04:21:00 | Aguascalientes, Mexico | |||
479668 | 479668 | 2022-11-08 | Mexico | Aguascalientes | 84600 | 3591 | 0 | 21.8853 | -102.2916 | 2022-11-09 04:21:22 | Aguascalientes, Mexico | |||
487698 | 487698 | 2022-11-25 | Mexico | Aguascalientes | 84691 | 3591 | 0 | 21.8853 | -102.2916 | 2022-11-26 04:21:11 | Aguascalientes, Mexico | |||
491712 | 491712 | 2021-10-14 | Mexico | Aguascalientes | 34970 | 2805 | 0 | 21.8853 | -102.2916 | 2021-10-15 04:21:26 | Aguascalientes, Mexico | |||
495728 | 495728 | 2021-11-06 | Mexico | Aguascalientes | 36062 | 2884 | 0 | 21.8853 | -102.2916 | 2021-11-07 04:21:53 | Aguascalientes, Mexico | |||
499745 | 499745 | 2022-04-02 | Mexico | Aguascalientes | 64178 | 3490 | 0 | 21.8853 | -102.2916 | 2022-04-03 04:20:48 | Aguascalientes, Mexico | |||
503762 | 503762 | 2022-12-17 | Mexico | Aguascalientes | 85231 | 3592 | 0 | 21.8853 | -102.2916 | 2022-12-18 04:21:03 | Aguascalientes, Mexico | |||
507759 | 507759 | 2021-08-14 | Mexico | Aguascalientes | 29239 | 2529 | 0 | 21.8853 | -102.2916 | 2021-08-15 04:21:41 | Aguascalientes, Mexico | |||
511773 | 511773 | 2021-08-19 | Mexico | Aguascalientes | 29715 | 2551 | 0 | 21.8853 | -102.2916 | 2021-08-20 04:21:33 | Aguascalientes, Mexico | |||
515806 | 515806 | 2022-10-15 | Mexico | Aguascalientes | 84615 | 3591 | 0 | 21.8853 | -102.2916 | 2022-10-16 04:22:39 | Aguascalientes, Mexico | |||
534812 | 534812 | 2021-10-27 | Mexico | Aguascalientes | 35569 | 2841 | 0 | 21.8853 | -102.2916 | 2021-10-28 04:22:08 | Aguascalientes, Mexico | |||
538830 | 538830 | 2022-10-26 | Mexico | Aguascalientes | 84536 | 3591 | 0 | 21.8853 | -102.2916 | 2022-10-27 04:22:01 | Aguascalientes, Mexico | |||
542846 | 542846 | 2022-12-15 | Mexico | Aguascalientes | 85076 | 3592 | 0 | 21.8853 | -102.2916 | 2022-12-16 04:21:01 | Aguascalientes, Mexico | |||
550850 | 550850 | 2021-12-08 | Mexico | Aguascalientes | 37499 | 2962 | 0 | 21.8853 | -102.2916 | 2021-12-09 04:22:49 | Aguascalientes, Mexico | |||
554866 | 554866 | 2022-01-16 | Mexico | Aguascalientes | 43433 | 3091 | 0 | 21.8853 | -102.2916 | 2022-01-17 04:21:08 | Aguascalientes, Mexico | |||
558884 | 558884 | 2022-06-16 | Mexico | Aguascalientes | 68571 | 3519 | 0 | 21.8853 | -102.2916 | 2022-06-17 04:20:56 | Aguascalientes, Mexico | |||
567180 | 567180 | 2021-10-29 | Mexico | Aguascalientes | 35800 | 2863 | 0 | 21.8853 | -102.2916 | 2021-10-30 04:22:03 | Aguascalientes, Mexico | |||
574909 | 574909 | 2022-02-25 | Mexico | Aguascalientes | 59619 | 3441 | 0 | 21.8853 | -102.2916 | 2022-02-26 04:21:12 | Aguascalientes, Mexico | |||
589703 | 589703 | 2021-08-08 | Mexico | Aguascalientes | 28593 | 2504 | 0 | 21.8853 | -102.2916 | 2021-08-09 04:21:24 | Aguascalientes, Mexico | |||
593736 | 593736 | 2022-07-01 | Mexico | Aguascalientes | 70378 | 3520 | 0 | 21.8853 | -102.2916 | 2022-07-02 04:21:16 | Aguascalientes, Mexico | |||
597750 | 597750 | 2021-10-19 | Mexico | Aguascalientes | 35215 | 2824 | 0 | 21.8853 | -102.2916 | 2021-10-20 04:21:00 | Aguascalientes, Mexico | |||
601766 | 601766 | 2021-09-23 | Mexico | Aguascalientes | 33197 | 2719 | 0 | 21.8853 | -102.2916 | 2021-09-24 04:21:44 | Aguascalientes, Mexico | |||
617940 | 617940 | 2022-11-05 | Mexico | Aguascalientes | 84583 | 3591 | 0 | 21.8853 | -102.2916 | 2022-11-06 04:21:24 | Aguascalientes, Mexico | |||
621956 | 621956 | 2022-05-22 | Mexico | Aguascalientes | 66898 | 3509 | 0 | 21.8853 | -102.2916 | 2022-05-26 04:20:50 | Aguascalientes, Mexico | |||
629986 | 629986 | 2022-07-12 | Mexico | Aguascalientes | 72644 | 3524 | 0 | 21.8853 | -102.2916 | 2022-07-13 04:20:58 | Aguascalientes, Mexico | |||
634000 | 634000 | 2021-10-13 | Mexico | Aguascalientes | 34795 | 2799 | 0 | 21.8853 | -102.2916 | 2021-10-14 04:21:29 | Aguascalientes, Mexico | |||
642013 | 642013 | 2021-09-07 | Mexico | Aguascalientes | 31880 | 2643 | 0 | 21.8853 | -102.2916 | 2021-09-08 04:21:31 | Aguascalientes, Mexico | |||
650041 | 650041 | 2021-08-09 | Mexico | Aguascalientes | 28596 | 2504 | 0 | 21.8853 | -102.2916 | 2021-08-10 04:21:27 | Aguascalientes, Mexico | |||
654072 | 654072 | 2021-10-22 | Mexico | Aguascalientes | 35430 | 2832 | 0 | 21.8853 | -102.2916 | 2021-10-23 04:21:32 | Aguascalientes, Mexico | |||
658391 | 658391 | 2022-05-13 | Mexico | Aguascalientes | 66137 | 3502 | 0 | 21.8853 | -102.2916 | 2022-05-14 04:20:48 | Aguascalientes, Mexico | |||
670377 | 670377 | 2022-07-21 | Mexico | Aguascalientes | 76375 | 3525 | 0 | 21.8853 | -102.2916 | 2022-07-22 04:21:15 | Aguascalientes, Mexico | |||
674393 | 674393 | 2022-07-30 | Mexico | Aguascalientes | 78260 | 3530 | 0 | 21.8853 | -102.2916 | 2022-07-31 04:21:02 | Aguascalientes, Mexico | |||
682417 | 682417 | 2021-10-24 | Mexico | Aguascalientes | 35471 | 2833 | 0 | 21.8853 | -102.2916 | 2021-10-25 04:22:31 | Aguascalientes, Mexico | |||
686433 | 686433 | 2021-11-13 | Mexico | Aguascalientes | 36344 | 2891 | 0 | 21.8853 | -102.2916 | 2021-11-14 04:21:31 | Aguascalientes, Mexico | |||
690451 | 690451 | 2022-12-23 | Mexico | Aguascalientes | 85306 | 3593 | 0 | 21.8853 | -102.2916 | 2022-12-24 04:21:02 | Aguascalientes, Mexico | |||
694466 | 694466 | 2022-03-17 | Mexico | Aguascalientes | 63055 | 3482 | 0 | 21.8853 | -102.2916 | 2022-03-18 04:20:55 | Aguascalientes, Mexico | |||
698481 | 698481 | 2021-11-04 | Mexico | Aguascalientes | 35926 | 2877 | 0 | 21.8853 | -102.2916 | 2021-11-05 04:21:54 | Aguascalientes, Mexico | |||
706511 | 706511 | 2021-09-29 | Mexico | Aguascalientes | 33682 | 2741 | 0 | 21.8853 | -102.2916 | 2021-09-30 04:21:20 | Aguascalientes, Mexico | |||
710528 | 710528 | 2022-11-01 | Mexico | Aguascalientes | 84545 | 3591 | 0 | 21.8853 | -102.2916 | 2022-11-02 04:22:09 | 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]);