johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
954 rows where province_or_state = "Zacatecas" sorted by admin2
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
423459 | 423459 | 2021-10-10 | Mexico | Zacatecas | 40951 | 3277 | 0 | 22.7709 | -102.5832 | 2021-10-11 04:21:31 | Zacatecas, Mexico | |||
427440 | 427440 | 2020-09-07 | Mexico | Zacatecas | 5897 | 542 | 4736 | 619 | 22.7709 | -102.5832 | 2020-09-08 04:28:25 | Zacatecas, Mexico | ||
431467 | 431467 | 2022-11-03 | Mexico | Zacatecas | 79845 | 3925 | 0 | 22.7709 | -102.5832 | 2022-11-04 04:22:11 | Zacatecas, Mexico | |||
435462 | 435462 | 2021-01-21 | Mexico | Zacatecas | 23785 | 1993 | 0 | 21792 | 22.7709 | -102.5832 | 2021-01-22 05:22:10 | Zacatecas, Mexico | ||
442809 | 442809 | 2020-07-26 | Mexico | Zacatecas | 2352 | 201 | 1487 | 664 | 22.7709 | -102.5832 | 2020-07-27 04:35:02 | Zacatecas, Mexico | ||
443463 | 443463 | 2021-10-20 | Mexico | Zacatecas | 41304 | 3332 | 0 | 22.7709 | -102.5832 | 2021-10-21 04:21:18 | Zacatecas, Mexico | |||
447479 | 447479 | 2021-11-17 | Mexico | Zacatecas | 41831 | 3397 | 0 | 22.7709 | -102.5832 | 2021-11-18 04:21:33 | Zacatecas, Mexico | |||
451497 | 451497 | 2022-12-21 | Mexico | Zacatecas | 80362 | 3934 | 0 | 22.7709 | -102.5832 | 2022-12-22 04:20:56 | Zacatecas, Mexico | |||
458836 | 458836 | 2020-08-07 | Mexico | Zacatecas | 3226 | 303 | 2211 | 712 | 22.7709 | -102.5832 | 2020-08-08 04:34:53 | Zacatecas, Mexico | ||
459488 | 459488 | 2022-02-02 | Mexico | Zacatecas | 62277 | 3643 | 0 | 22.7709 | -102.5832 | 2022-02-03 04:21:21 | Zacatecas, Mexico | |||
463505 | 463505 | 2022-05-02 | Mexico | Zacatecas | 67670 | 3850 | 0 | 22.7709 | -102.5832 | 2022-05-03 04:21:00 | Zacatecas, Mexico | |||
467520 | 467520 | 2021-10-07 | Mexico | Zacatecas | 40832 | 3270 | 0 | 22.7709 | -102.5832 | 2021-10-08 04:21:25 | Zacatecas, Mexico | |||
471518 | 471518 | 2021-02-19 | Mexico | Zacatecas | 26929 | 2374 | 0 | 24555 | 22.7709 | -102.5832 | 2021-02-20 05:22:51 | Zacatecas, Mexico | ||
475552 | 475552 | 2022-06-26 | Mexico | Zacatecas | 68547 | 3862 | 0 | 22.7709 | -102.5832 | 2022-06-27 04:21:00 | Zacatecas, Mexico | |||
479700 | 479700 | 2022-11-08 | Mexico | Zacatecas | 79881 | 3925 | 0 | 22.7709 | -102.5832 | 2022-11-09 04:21:22 | Zacatecas, Mexico | |||
483697 | 483697 | 2021-07-19 | Mexico | Zacatecas | 31703 | 2847 | 0 | 28856 | 22.7709 | -102.5832 | 2021-07-20 04:21:48 | Zacatecas, Mexico | ||
487730 | 487730 | 2022-11-25 | Mexico | Zacatecas | 79986 | 3925 | 0 | 22.7709 | -102.5832 | 2022-11-26 04:21:11 | Zacatecas, Mexico | |||
491744 | 491744 | 2021-10-14 | Mexico | Zacatecas | 41147 | 3300 | 0 | 22.7709 | -102.5832 | 2021-10-15 04:21:26 | Zacatecas, Mexico | |||
495760 | 495760 | 2021-11-06 | Mexico | Zacatecas | 41668 | 3382 | 0 | 22.7709 | -102.5832 | 2021-11-07 04:21:53 | Zacatecas, Mexico | |||
499777 | 499777 | 2022-04-02 | Mexico | Zacatecas | 67461 | 3846 | 0 | 22.7709 | -102.5832 | 2022-04-03 04:20:48 | Zacatecas, Mexico | |||
503794 | 503794 | 2022-12-17 | Mexico | Zacatecas | 80308 | 3934 | 0 | 22.7709 | -102.5832 | 2022-12-18 04:21:03 | Zacatecas, Mexico | |||
507791 | 507791 | 2021-08-14 | Mexico | Zacatecas | 35787 | 2988 | 0 | 22.7709 | -102.5832 | 2021-08-15 04:21:41 | Zacatecas, Mexico | |||
511805 | 511805 | 2021-08-19 | Mexico | Zacatecas | 36727 | 3009 | 0 | 22.7709 | -102.5832 | 2021-08-20 04:21:33 | Zacatecas, Mexico | |||
515838 | 515838 | 2022-10-15 | Mexico | Zacatecas | 79938 | 3924 | 0 | 22.7709 | -102.5832 | 2022-10-16 04:22:39 | Zacatecas, Mexico | |||
522964 | 522964 | 2021-06-09 | Mexico | Zacatecas | 30857 | 2812 | 0 | 28045 | 22.7709 | -102.5832 | 2021-06-10 04:23:17 | Zacatecas, Mexico | ||
530184 | 530184 | 2020-07-04 | Mexico | Zacatecas | 1057 | 110 | 706 | 241 | 22.7709 | -102.5832 | 2020-07-05 04:33:46 | Zacatecas, Mexico | ||
530812 | 530812 | 2021-02-22 | Mexico | Zacatecas | 27080 | 2391 | 0 | 24689 | 22.7709 | -102.5832 | 2021-02-23 05:23:41 | Zacatecas, Mexico | ||
534844 | 534844 | 2021-10-27 | Mexico | Zacatecas | 41441 | 3345 | 0 | 22.7709 | -102.5832 | 2021-10-28 04:22:08 | Zacatecas, Mexico | |||
538862 | 538862 | 2022-10-26 | Mexico | Zacatecas | 79808 | 3924 | 0 | 22.7709 | -102.5832 | 2022-10-27 04:22:01 | Zacatecas, Mexico | |||
542878 | 542878 | 2022-12-15 | Mexico | Zacatecas | 80213 | 3932 | 0 | 22.7709 | -102.5832 | 2022-12-16 04:21:01 | Zacatecas, Mexico | |||
546857 | 546857 | 2020-09-12 | Mexico | Zacatecas | 6290 | 598 | 5004 | 688 | 22.7709 | -102.5832 | 2020-09-13 04:30:52 | Zacatecas, Mexico | ||
550882 | 550882 | 2021-12-08 | Mexico | Zacatecas | 42196 | 3421 | 0 | 22.7709 | -102.5832 | 2021-12-09 04:22:49 | Zacatecas, Mexico | |||
554898 | 554898 | 2022-01-16 | Mexico | Zacatecas | 52222 | 3493 | 0 | 22.7709 | -102.5832 | 2022-01-17 04:21:08 | Zacatecas, Mexico | |||
558916 | 558916 | 2022-06-16 | Mexico | Zacatecas | 68083 | 3861 | 0 | 22.7709 | -102.5832 | 2022-06-17 04:20:56 | Zacatecas, Mexico | |||
563074 | 563074 | 2021-06-22 | Mexico | Zacatecas | 30973 | 2832 | 0 | 28141 | 22.7709 | -102.5832 | 2021-06-23 04:21:46 | Zacatecas, Mexico | ||
567212 | 567212 | 2021-10-29 | Mexico | Zacatecas | 41535 | 3362 | 0 | 22.7709 | -102.5832 | 2021-10-30 04:22:03 | Zacatecas, Mexico | |||
574288 | 574288 | 2020-06-06 | Mexico | Zacatecas | 368 | 44 | 238 | 86 | 22.7709 | -102.5832 | 2020-06-07 03:53:30 | Zacatecas, Mexico | ||
574941 | 574941 | 2022-02-25 | Mexico | Zacatecas | 66527 | 3821 | 0 | 22.7709 | -102.5832 | 2022-02-26 04:21:12 | Zacatecas, Mexico | |||
578939 | 578939 | 2021-07-13 | Mexico | Zacatecas | 31381 | 2844 | 0 | 28537 | 22.7709 | -102.5832 | 2021-07-14 04:21:35 | Zacatecas, Mexico | ||
582935 | 582935 | 2020-08-13 | Mexico | Zacatecas | 3856 | 354 | 2618 | 884 | 22.7709 | -102.5832 | 2020-08-14 04:51:19 | Zacatecas, Mexico | ||
589735 | 589735 | 2021-08-08 | Mexico | Zacatecas | 34494 | 2954 | 0 | 22.7709 | -102.5832 | 2021-08-09 04:21:24 | Zacatecas, Mexico | |||
593768 | 593768 | 2022-07-01 | Mexico | Zacatecas | 69076 | 3863 | 0 | 22.7709 | -102.5832 | 2022-07-02 04:21:16 | Zacatecas, Mexico | |||
597782 | 597782 | 2021-10-19 | Mexico | Zacatecas | 41269 | 3327 | 0 | 22.7709 | -102.5832 | 2021-10-20 04:21:00 | Zacatecas, Mexico | |||
601798 | 601798 | 2021-09-23 | Mexico | Zacatecas | 40152 | 3214 | 0 | 22.7709 | -102.5832 | 2021-09-24 04:21:44 | Zacatecas, Mexico | |||
605795 | 605795 | 2021-04-09 | Mexico | Zacatecas | 29221 | 2692 | 0 | 26529 | 22.7709 | -102.5832 | 2021-04-10 04:20:59 | Zacatecas, Mexico | ||
609792 | 609792 | 2020-08-29 | Mexico | Zacatecas | 5195 | 470 | 3970 | 755 | 22.7709 | -102.5832 | 2020-08-30 04:28:22 | Zacatecas, Mexico | ||
613794 | 613794 | 2021-02-08 | Mexico | Zacatecas | 25965 | 2192 | 0 | 23773 | 22.7709 | -102.5832 | 2021-02-09 05:23:30 | Zacatecas, Mexico | ||
617972 | 617972 | 2022-11-05 | Mexico | Zacatecas | 79864 | 3925 | 0 | 22.7709 | -102.5832 | 2022-11-06 04:21:24 | Zacatecas, Mexico | |||
621988 | 621988 | 2022-05-22 | Mexico | Zacatecas | 67681 | 3858 | 0 | 22.7709 | -102.5832 | 2022-05-26 04:20:50 | Zacatecas, Mexico | |||
625985 | 625985 | 2021-07-10 | Mexico | Zacatecas | 31300 | 2843 | 0 | 28457 | 22.7709 | -102.5832 | 2021-07-11 04:21:43 | Zacatecas, Mexico | ||
630018 | 630018 | 2022-07-12 | Mexico | Zacatecas | 70637 | 3868 | 0 | 22.7709 | -102.5832 | 2022-07-13 04:20:58 | Zacatecas, Mexico | |||
634032 | 634032 | 2021-10-13 | Mexico | Zacatecas | 41087 | 3298 | 0 | 22.7709 | -102.5832 | 2021-10-14 04:21:29 | Zacatecas, Mexico | |||
638030 | 638030 | 2021-03-31 | Mexico | Zacatecas | 28912 | 2658 | 0 | 26254 | 22.7709 | -102.5832 | 2021-04-01 04:27:05 | Zacatecas, Mexico | ||
642045 | 642045 | 2021-09-07 | Mexico | Zacatecas | 39074 | 3143 | 0 | 22.7709 | -102.5832 | 2021-09-08 04:21:31 | Zacatecas, Mexico | |||
646058 | 646058 | 2021-05-05 | Mexico | Zacatecas | 30154 | 2756 | 0 | 27398 | 22.7709 | -102.5832 | 2021-05-06 04:20:38 | Zacatecas, Mexico | ||
650073 | 650073 | 2021-08-09 | Mexico | Zacatecas | 34525 | 2954 | 0 | 22.7709 | -102.5832 | 2021-08-10 04:21:27 | Zacatecas, Mexico | |||
654104 | 654104 | 2021-10-22 | Mexico | Zacatecas | 41364 | 3338 | 0 | 22.7709 | -102.5832 | 2021-10-23 04:21:32 | Zacatecas, Mexico | |||
658423 | 658423 | 2022-05-13 | Mexico | Zacatecas | 67680 | 3858 | 0 | 22.7709 | -102.5832 | 2022-05-14 04:20:48 | Zacatecas, Mexico | |||
662402 | 662402 | 2020-08-11 | Mexico | Zacatecas | 3579 | 341 | 2533 | 705 | 22.7709 | -102.5832 | 2020-08-12 04:27:29 | Zacatecas, Mexico | ||
666382 | 666382 | 2020-09-16 | Mexico | Zacatecas | 6527 | 614 | 5332 | 581 | 22.7709 | -102.5832 | 2020-09-17 04:22:00 | Zacatecas, Mexico | ||
670409 | 670409 | 2022-07-21 | Mexico | Zacatecas | 72981 | 3871 | 0 | 22.7709 | -102.5832 | 2022-07-22 04:21:15 | Zacatecas, Mexico | |||
674425 | 674425 | 2022-07-30 | Mexico | Zacatecas | 74841 | 3880 | 0 | 22.7709 | -102.5832 | 2022-07-31 04:21:02 | Zacatecas, Mexico | |||
678418 | 678418 | 2020-11-23 | Mexico | Zacatecas | 14944 | 1203 | 0 | 13741 | 22.7709 | -102.5832 | 2020-11-24 05:27:31 | Zacatecas, Mexico | ||
682449 | 682449 | 2021-10-24 | Mexico | Zacatecas | 41396 | 3339 | 0 | 22.7709 | -102.5832 | 2021-10-25 04:22:31 | Zacatecas, Mexico | |||
686465 | 686465 | 2021-11-13 | Mexico | Zacatecas | 41758 | 3392 | 0 | 22.7709 | -102.5832 | 2021-11-14 04:21:31 | Zacatecas, Mexico | |||
690483 | 690483 | 2022-12-23 | Mexico | Zacatecas | 80362 | 3934 | 0 | 22.7709 | -102.5832 | 2022-12-24 04:21:02 | Zacatecas, Mexico | |||
694498 | 694498 | 2022-03-17 | Mexico | Zacatecas | 67201 | 3835 | 0 | 22.7709 | -102.5832 | 2022-03-18 04:20:55 | Zacatecas, Mexico | |||
698513 | 698513 | 2021-11-04 | Mexico | Zacatecas | 41599 | 3369 | 0 | 22.7709 | -102.5832 | 2021-11-05 04:21:54 | Zacatecas, Mexico | |||
702511 | 702511 | 2021-03-16 | Mexico | Zacatecas | 28197 | 2594 | 0 | 25603 | 22.7709 | -102.5832 | 2021-03-17 05:25:07 | Zacatecas, Mexico | ||
706543 | 706543 | 2021-09-29 | Mexico | Zacatecas | 40443 | 3236 | 0 | 22.7709 | -102.5832 | 2021-09-30 04:21:20 | Zacatecas, Mexico | |||
710560 | 710560 | 2022-11-01 | Mexico | Zacatecas | 79821 | 3924 | 0 | 22.7709 | -102.5832 | 2022-11-02 04:22:09 | Zacatecas, Mexico | |||
714574 | 714574 | 2021-11-12 | Mexico | Zacatecas | 41740 | 3391 | 0 | 22.7709 | -102.5832 | 2021-11-13 04:21:38 | Zacatecas, Mexico | |||
718592 | 718592 | 2022-12-04 | Mexico | Zacatecas | 79986 | 3925 | 0 | 22.7709 | -102.5832 | 2022-12-05 04:20:58 | Zacatecas, Mexico | |||
722606 | 722606 | 2021-11-20 | Mexico | Zacatecas | 41869 | 3398 | 0 | 22.7709 | -102.5832 | 2021-11-21 04:22:13 | Zacatecas, Mexico | |||
726604 | 726604 | 2021-05-22 | Mexico | Zacatecas | 30639 | 2784 | 0 | 27855 | 22.7709 | -102.5832 | 2021-05-23 04:20:51 | Zacatecas, Mexico | ||
730636 | 730636 | 2021-12-27 | Mexico | Zacatecas | 42631 | 3444 | 0 | 22.7709 | -102.5832 | 2021-12-28 04:21:47 | Zacatecas, Mexico | |||
737782 | 737782 | 2020-06-12 | Mexico | Zacatecas | 501 | 55 | 279 | 167 | 22.7709 | -102.5832 | 2020-06-13 03:33:14 | Zacatecas, Mexico | ||
738407 | 738407 | 2020-12-02 | Mexico | Zacatecas | 17277 | 1375 | 0 | 15902 | 22.7709 | -102.5832 | 2020-12-03 05:28:22 | Zacatecas, Mexico | ||
742420 | 742420 | 2021-02-20 | Mexico | Zacatecas | 27005 | 2378 | 0 | 24627 | 22.7709 | -102.5832 | 2021-02-21 05:24:33 | Zacatecas, Mexico | ||
746453 | 746453 | 2022-04-23 | Mexico | Zacatecas | 67645 | 3850 | 0 | 22.7709 | -102.5832 | 2022-04-24 04:20:56 | Zacatecas, Mexico | |||
753790 | 753790 | 2020-08-01 | Mexico | Zacatecas | 2768 | 247 | 1849 | 672 | 22.7709 | -102.5832 | 2020-08-02 04:34:47 | Zacatecas, Mexico | ||
754407 | 754407 | 2020-10-28 | Mexico | Zacatecas | 10663 | 905 | 8383 | 1375 | 22.7709 | -102.5832 | 2020-10-29 04:24:49 | Zacatecas, Mexico | ||
758436 | 758436 | 2021-11-26 | Mexico | Zacatecas | 42016 | 3408 | 0 | 22.7709 | -102.5832 | 2021-11-27 04:22:45 | Zacatecas, Mexico | |||
762418 | 762418 | 2020-10-18 | Mexico | Zacatecas | 9342 | 818 | 7403 | 1121 | 22.7709 | -102.5832 | 2020-10-19 04:24:16 | Zacatecas, Mexico | ||
766426 | 766426 | 2020-12-29 | Mexico | Zacatecas | 20717 | 1734 | 0 | 18983 | 22.7709 | -102.5832 | 2020-12-30 05:22:34 | Zacatecas, Mexico | ||
770457 | 770457 | 2021-10-23 | Mexico | Zacatecas | 41396 | 3339 | 0 | 22.7709 | -102.5832 | 2021-10-24 04:21:22 | Zacatecas, Mexico | |||
774454 | 774454 | 2021-01-12 | Mexico | Zacatecas | 22512 | 1888 | 0 | 20624 | 22.7709 | -102.5832 | 2021-01-13 05:22:15 | Zacatecas, Mexico | ||
778468 | 778468 | 2021-07-08 | Mexico | Zacatecas | 31237 | 2840 | 0 | 28397 | 22.7709 | -102.5832 | 2021-07-09 04:21:21 | Zacatecas, Mexico | ||
782499 | 782499 | 2021-12-13 | Mexico | Zacatecas | 42338 | 3422 | 0 | 22.7709 | -102.5832 | 2021-12-14 04:22:38 | Zacatecas, Mexico | |||
786481 | 786481 | 2020-10-15 | Mexico | Zacatecas | 8869 | 812 | 7048 | 1009 | 22.7709 | -102.5832 | 2020-10-16 04:24:01 | Zacatecas, Mexico | ||
790489 | 790489 | 2021-02-04 | Mexico | Zacatecas | 25376 | 2118 | 0 | 23258 | 22.7709 | -102.5832 | 2021-02-05 05:22:38 | Zacatecas, Mexico | ||
794524 | 794524 | 2022-10-24 | Mexico | Zacatecas | 79891 | 3924 | 0 | 22.7709 | -102.5832 | 2022-10-25 04:21:53 | Zacatecas, Mexico | |||
798538 | 798538 | 2021-12-22 | Mexico | Zacatecas | 42582 | 3438 | 0 | 22.7709 | -102.5832 | 2021-12-23 04:21:21 | Zacatecas, Mexico | |||
805579 | 805579 | 2020-06-01 | Mexico | Zacatecas | 301 | 35 | 202 | 64 | 22.7709 | -102.5832 | 2020-06-02 02:33:08 | Zacatecas, Mexico | ||
809683 | 809683 | 2021-09-20 | Mexico | Zacatecas | 39962 | 3197 | 0 | 22.7709 | -102.5832 | 2021-09-21 04:21:26 | Zacatecas, Mexico | |||
813680 | 813680 | 2020-09-05 | Mexico | Zacatecas | 5756 | 535 | 4533 | 688 | 22.7709 | -102.5832 | 2020-09-06 04:28:33 | Zacatecas, Mexico | ||
817671 | 817671 | 2020-10-09 | Mexico | Zacatecas | 8122 | 773 | 6588 | 761 | 22.7709 | -102.5832 | 2020-10-10 04:23:57 | Zacatecas, Mexico | ||
821676 | 821676 | 2020-11-19 | Mexico | Zacatecas | 13769 | 1167 | 0 | 12602 | 22.7709 | -102.5832 | 2020-11-20 05:26:28 | Zacatecas, Mexico | ||
825690 | 825690 | 2021-06-06 | Mexico | Zacatecas | 30837 | 2808 | 0 | 28029 | 22.7709 | -102.5832 | 2021-06-07 04:22:51 | Zacatecas, Mexico | ||
829704 | 829704 | 2021-07-09 | Mexico | Zacatecas | 31266 | 2841 | 0 | 28425 | 22.7709 | -102.5832 | 2021-07-10 04:21:25 | Zacatecas, 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]);