daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
954 rows where country_or_region = "Mexico" and province_or_state = "Guanajuato" sorted by last_update
This data as json, yaml, Notebook, copyable, CSV (advanced)
day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update ▼ | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-08-28 | Mexico | Guanajuato | 30431 | 1688 | 25518 | 3225 | 21.019 | -101.2574 | 2020-08-29 04:28:19 | Guanajuato, Mexico | ||
2020-08-29 | Mexico | Guanajuato | 30857 | 1916 | 25868 | 3073 | 21.019 | -101.2574 | 2020-08-30 04:28:22 | Guanajuato, Mexico | ||
2020-08-30 | Mexico | Guanajuato | 31253 | 2023 | 26104 | 3126 | 21.019 | -101.2574 | 2020-08-31 04:28:27 | Guanajuato, Mexico | ||
2020-08-31 | Mexico | Guanajuato | 31662 | 2041 | 26766 | 2855 | 21.019 | -101.2574 | 2020-09-01 04:28:31 | Guanajuato, Mexico | ||
2020-09-01 | Mexico | Guanajuato | 31998 | 2150 | 27062 | 2786 | 21.019 | -101.2574 | 2020-09-02 04:28:25 | Guanajuato, Mexico | ||
2020-09-02 | Mexico | Guanajuato | 32376 | 2177 | 27230 | 2969 | 21.019 | -101.2574 | 2020-09-03 04:28:22 | Guanajuato, Mexico | ||
2020-09-03 | Mexico | Guanajuato | 32922 | 2231 | 27589 | 3102 | 21.019 | -101.2574 | 2020-09-04 04:28:26 | Guanajuato, Mexico | ||
2020-09-04 | Mexico | Guanajuato | 33272 | 2273 | 27829 | 3170 | 21.019 | -101.2574 | 2020-09-05 04:28:19 | Guanajuato, Mexico | ||
2020-09-05 | Mexico | Guanajuato | 33773 | 2303 | 28242 | 3228 | 21.019 | -101.2574 | 2020-09-06 04:28:33 | Guanajuato, Mexico | ||
2020-09-06 | Mexico | Guanajuato | 34137 | 2315 | 28602 | 3220 | 21.019 | -101.2574 | 2020-09-07 04:28:30 | Guanajuato, Mexico | ||
2020-09-07 | Mexico | Guanajuato | 34269 | 2325 | 29078 | 2866 | 21.019 | -101.2574 | 2020-09-08 04:28:25 | Guanajuato, Mexico | ||
2020-09-08 | Mexico | Guanajuato | 34441 | 2361 | 29181 | 2899 | 21.019 | -101.2574 | 2020-09-09 04:28:48 | Guanajuato, Mexico | ||
2020-09-09 | Mexico | Guanajuato | 35182 | 2416 | 29768 | 2998 | 21.019 | -101.2574 | 2020-09-10 04:29:01 | Guanajuato, Mexico | ||
2020-09-10 | Mexico | Guanajuato | 35503 | 2488 | 30013 | 3002 | 21.019 | -101.2574 | 2020-09-11 04:46:23 | Guanajuato, Mexico | ||
2020-09-11 | Mexico | Guanajuato | 35911 | 2551 | 30324 | 3036 | 21.019 | -101.2574 | 2020-09-12 04:25:05 | Guanajuato, Mexico | ||
2020-09-12 | Mexico | Guanajuato | 36391 | 2579 | 30833 | 2979 | 21.019 | -101.2574 | 2020-09-13 04:30:52 | Guanajuato, Mexico | ||
2020-09-13 | Mexico | Guanajuato | 36646 | 2607 | 31227 | 2812 | 21.019 | -101.2574 | 2020-09-14 04:26:00 | Guanajuato, Mexico | ||
2020-09-14 | Mexico | Guanajuato | 36973 | 2615 | 31745 | 2613 | 21.019 | -101.2574 | 2020-09-15 03:22:50 | Guanajuato, Mexico | ||
2020-09-15 | Mexico | Guanajuato | 37196 | 2644 | 32004 | 2548 | 21.019 | -101.2574 | 2020-09-16 04:22:53 | Guanajuato, Mexico | ||
2020-09-16 | Mexico | Guanajuato | 37541 | 2657 | 32102 | 2782 | 21.019 | -101.2574 | 2020-09-17 04:22:00 | Guanajuato, Mexico | ||
2020-09-17 | Mexico | Guanajuato | 37796 | 2667 | 32312 | 2817 | 21.019 | -101.2574 | 2020-09-18 05:05:00 | Guanajuato, Mexico | ||
2020-09-18 | Mexico | Guanajuato | 38042 | 2692 | 32686 | 2664 | 21.019 | -101.2574 | 2020-09-19 04:22:00 | Guanajuato, Mexico | ||
2020-09-19 | Mexico | Guanajuato | 38340 | 2709 | 33126 | 2505 | 21.019 | -101.2574 | 2020-09-20 04:22:00 | Guanajuato, Mexico | ||
2020-09-20 | Mexico | Guanajuato | 38577 | 2718 | 33477 | 2382 | 21.019 | -101.2574 | 2020-09-21 04:23:00 | Guanajuato, Mexico | ||
2020-09-21 | Mexico | Guanajuato | 38697 | 2724 | 33820 | 2153 | 21.019 | -101.2574 | 2020-09-22 04:23:00 | Guanajuato, Mexico | ||
2020-09-22 | Mexico | Guanajuato | 39096 | 2752 | 34052 | 2292 | 21.019 | -101.2574 | 2020-09-23 04:23:00 | Guanajuato, Mexico | ||
2020-09-23 | Mexico | Guanajuato | 39320 | 2793 | 34489 | 2038 | 21.019 | -101.2574 | 2020-09-24 04:23:00 | Guanajuato, Mexico | ||
2020-09-24 | Mexico | Guanajuato | 39524 | 2820 | 34768 | 1936 | 21.019 | -101.2574 | 2020-09-25 04:23:00 | Guanajuato, Mexico | ||
2020-09-25 | Mexico | Guanajuato | 39841 | 2826 | 35124 | 1891 | 21.019 | -101.2574 | 2020-09-26 04:23:00 | Guanajuato, Mexico | ||
2020-09-26 | Mexico | Guanajuato | 40045 | 2844 | 35423 | 1778 | 21.019 | -101.2574 | 2020-09-27 04:23:00 | Guanajuato, Mexico | ||
2020-09-27 | Mexico | Guanajuato | 40334 | 2866 | 35739 | 1729 | 21.019 | -101.2574 | 2020-09-28 04:23:00 | Guanajuato, Mexico | ||
2020-09-28 | Mexico | Guanajuato | 40506 | 2876 | 36051 | 1579 | 21.019 | -101.2574 | 2020-09-29 04:23:42 | Guanajuato, Mexico | ||
2020-09-29 | Mexico | Guanajuato | 40645 | 2890 | 36199 | 1556 | 21.019 | -101.2574 | 2020-09-30 04:23:33 | Guanajuato, Mexico | ||
2020-09-30 | Mexico | Guanajuato | 40883 | 2907 | 36202 | 1774 | 21.019 | -101.2574 | 2020-10-01 04:23:42 | Guanajuato, Mexico | ||
2020-10-01 | Mexico | Guanajuato | 41063 | 2946 | 36352 | 1765 | 21.019 | -101.2574 | 2020-10-02 04:23:51 | Guanajuato, Mexico | ||
2020-10-02 | Mexico | Guanajuato | 41369 | 2953 | 36645 | 1771 | 21.019 | -101.2574 | 2020-10-03 04:23:40 | Guanajuato, Mexico | ||
2020-10-03 | Mexico | Guanajuato | 41518 | 2962 | 36837 | 1719 | 21.019 | -101.2574 | 2020-10-04 04:23:44 | Guanajuato, Mexico | ||
2020-10-04 | Mexico | Guanajuato | 41676 | 2972 | 37047 | 1657 | 21.019 | -101.2574 | 2020-10-05 04:23:33 | Guanajuato, Mexico | ||
2020-10-05 | Mexico | Guanajuato | 42213 | 3003 | 37553 | 1657 | 21.019 | -101.2574 | 2020-10-06 04:23:33 | Guanajuato, Mexico | ||
2020-10-06 | Mexico | Guanajuato | 42477 | 3017 | 37777 | 1683 | 21.019 | -101.2574 | 2020-10-07 04:23:40 | Guanajuato, Mexico | ||
2020-10-07 | Mexico | Guanajuato | 42633 | 3029 | 37883 | 1721 | 21.019 | -101.2574 | 2020-10-08 04:23:56 | Guanajuato, Mexico | ||
2020-10-08 | Mexico | Guanajuato | 42849 | 3053 | 38021 | 1775 | 21.019 | -101.2574 | 2020-10-09 04:23:59 | Guanajuato, Mexico | ||
2020-10-09 | Mexico | Guanajuato | 43054 | 3094 | 38188 | 1772 | 21.019 | -101.2574 | 2020-10-10 04:23:57 | Guanajuato, Mexico | ||
2020-10-10 | Mexico | Guanajuato | 43232 | 3113 | 38327 | 1792 | 21.019 | -101.2574 | 2020-10-11 04:23:46 | Guanajuato, Mexico | ||
2020-10-11 | Mexico | Guanajuato | 43563 | 3120 | 38635 | 1808 | 21.019 | -101.2574 | 2020-10-12 04:23:45 | Guanajuato, Mexico | ||
2020-10-12 | Mexico | Guanajuato | 43660 | 3127 | 38822 | 1711 | 21.019 | -101.2574 | 2020-10-13 04:24:02 | Guanajuato, Mexico | ||
2020-10-13 | Mexico | Guanajuato | 43723 | 3146 | 38842 | 1735 | 21.019 | -101.2574 | 2020-10-14 04:24:05 | Guanajuato, Mexico | ||
2020-10-14 | Mexico | Guanajuato | 44052 | 3161 | 39012 | 1879 | 21.019 | -101.2574 | 2020-10-15 04:24:28 | Guanajuato, Mexico | ||
2020-10-15 | Mexico | Guanajuato | 44230 | 3180 | 39165 | 1885 | 21.019 | -101.2574 | 2020-10-16 04:24:01 | Guanajuato, Mexico | ||
2020-10-16 | Mexico | Guanajuato | 44639 | 3193 | 39431 | 2015 | 21.019 | -101.2574 | 2020-10-17 04:24:12 | Guanajuato, Mexico | ||
2020-10-17 | Mexico | Guanajuato | 44766 | 3204 | 39608 | 1954 | 21.019 | -101.2574 | 2020-10-18 04:24:25 | Guanajuato, Mexico | ||
2020-10-18 | Mexico | Guanajuato | 44965 | 3212 | 39782 | 1971 | 21.019 | -101.2574 | 2020-10-19 04:24:16 | Guanajuato, Mexico | ||
2020-10-19 | Mexico | Guanajuato | 45163 | 3218 | 40125 | 1820 | 21.019 | -101.2574 | 2020-10-20 04:24:22 | Guanajuato, Mexico | ||
2020-10-20 | Mexico | Guanajuato | 45428 | 3237 | 40282 | 1909 | 21.019 | -101.2574 | 2020-10-21 04:24:14 | Guanajuato, Mexico | ||
2020-10-21 | Mexico | Guanajuato | 45715 | 3254 | 40330 | 2131 | 21.019 | -101.2574 | 2020-10-22 04:24:27 | Guanajuato, Mexico | ||
2020-10-22 | Mexico | Guanajuato | 46025 | 3254 | 40409 | 2362 | 21.019 | -101.2574 | 2020-10-23 04:24:46 | Guanajuato, Mexico | ||
2020-10-23 | Mexico | Guanajuato | 46484 | 3302 | 40571 | 2611 | 21.019 | -101.2574 | 2020-10-24 04:24:46 | Guanajuato, Mexico | ||
2020-10-24 | Mexico | Guanajuato | 46808 | 3323 | 40828 | 2657 | 21.019 | -101.2574 | 2020-10-25 04:24:36 | Guanajuato, Mexico | ||
2020-10-25 | Mexico | Guanajuato | 46975 | 3330 | 41063 | 2582 | 21.019 | -101.2574 | 2020-10-26 04:25:02 | Guanajuato, Mexico | ||
2020-10-26 | Mexico | Guanajuato | 47174 | 3333 | 41410 | 2431 | 21.019 | -101.2574 | 2020-10-27 04:24:45 | Guanajuato, Mexico | ||
2020-10-27 | Mexico | Guanajuato | 47609 | 3382 | 41328 | 2899 | 21.019 | -101.2574 | 2020-10-28 04:24:39 | Guanajuato, Mexico | ||
2020-10-28 | Mexico | Guanajuato | 47859 | 3399 | 41579 | 2881 | 21.019 | -101.2574 | 2020-10-29 04:24:49 | Guanajuato, Mexico | ||
2020-10-29 | Mexico | Guanajuato | 48272 | 3430 | 41499 | 3343 | 21.019 | -101.2574 | 2020-10-30 04:24:49 | Guanajuato, Mexico | ||
2020-10-30 | Mexico | Guanajuato | 48669 | 3441 | 41813 | 3415 | 21.019 | -101.2574 | 2020-10-31 04:24:44 | Guanajuato, Mexico | ||
2020-10-31 | Mexico | Guanajuato | 48997 | 3450 | 42224 | 3323 | 21.019 | -101.2574 | 2020-11-01 04:36:19 | Guanajuato, Mexico | ||
2020-11-01 | Mexico | Guanajuato | 49399 | 3457 | 42731 | 3211 | 21.019 | -101.2574 | 2020-11-02 05:25:04 | Guanajuato, Mexico | ||
2020-11-02 | Mexico | Guanajuato | 49557 | 3463 | 43218 | 2876 | 21.019 | -101.2574 | 2020-11-03 06:00:16 | Guanajuato, Mexico | ||
2020-11-03 | Mexico | Guanajuato | 49895 | 3471 | 43826 | 2598 | 21.019 | -101.2574 | 2020-11-04 05:25:09 | Guanajuato, Mexico | ||
2020-11-04 | Mexico | Guanajuato | 50409 | 3490 | 44163 | 2756 | 21.019 | -101.2574 | 2020-11-05 06:05:03 | Guanajuato, Mexico | ||
2020-11-05 | Mexico | Guanajuato | 50701 | 3504 | 44388 | 2809 | 21.019 | -101.2574 | 2020-11-06 05:24:55 | Guanajuato, Mexico | ||
2020-11-06 | Mexico | Guanajuato | 51144 | 3520 | 44735 | 2889 | 21.019 | -101.2574 | 2020-11-07 05:24:52 | Guanajuato, Mexico | ||
2020-11-07 | Mexico | Guanajuato | 51625 | 3537 | 45137 | 2951 | 21.019 | -101.2574 | 2020-11-08 05:24:56 | Guanajuato, Mexico | ||
2020-11-08 | Mexico | Guanajuato | 51866 | 3544 | 45630 | 2692 | 21.019 | -101.2574 | 2020-11-09 05:25:45 | Guanajuato, Mexico | ||
2020-11-09 | Mexico | Guanajuato | 52141 | 3562 | 45630 | 2949 | 21.019 | -101.2574 | 2020-11-10 05:40:07 | Guanajuato, Mexico | ||
2020-11-10 | Mexico | Guanajuato | 52404 | 3569 | 45630 | 3205 | 21.019 | -101.2574 | 2020-11-11 05:25:30 | Guanajuato, Mexico | ||
2020-11-11 | Mexico | Guanajuato | 52941 | 3584 | 45630 | 3727 | 21.019 | -101.2574 | 2020-11-12 05:25:55 | Guanajuato, Mexico | ||
2020-11-12 | Mexico | Guanajuato | 53279 | 3598 | 0 | 49681 | 21.019 | -101.2574 | 2020-11-13 05:25:30 | Guanajuato, Mexico | ||
2020-11-13 | Mexico | Guanajuato | 53638 | 3634 | 0 | 50004 | 21.019 | -101.2574 | 2020-11-14 05:25:37 | Guanajuato, Mexico | ||
2020-11-14 | Mexico | Guanajuato | 54017 | 3643 | 0 | 50374 | 21.019 | -101.2574 | 2020-11-15 05:26:53 | Guanajuato, Mexico | ||
2020-11-15 | Mexico | Guanajuato | 54257 | 3651 | 0 | 50606 | 21.019 | -101.2574 | 2020-11-16 05:25:57 | Guanajuato, Mexico | ||
2020-11-16 | Mexico | Guanajuato | 54433 | 3657 | 0 | 50776 | 21.019 | -101.2574 | 2020-11-17 05:25:54 | Guanajuato, Mexico | ||
2020-11-17 | Mexico | Guanajuato | 54609 | 3663 | 0 | 50946 | 21.019 | -101.2574 | 2020-11-18 05:40:31 | Guanajuato, Mexico | ||
2020-11-18 | Mexico | Guanajuato | 55040 | 3681 | 0 | 51359 | 21.019 | -101.2574 | 2020-11-19 05:25:23 | Guanajuato, Mexico | ||
2020-11-19 | Mexico | Guanajuato | 55320 | 3693 | 0 | 51627 | 21.019 | -101.2574 | 2020-11-20 05:26:28 | Guanajuato, Mexico | ||
2020-11-20 | Mexico | Guanajuato | 55967 | 3742 | 0 | 52225 | 21.019 | -101.2574 | 2020-11-21 05:25:51 | Guanajuato, Mexico | ||
2020-11-21 | Mexico | Guanajuato | 56544 | 3754 | 0 | 52790 | 21.019 | -101.2574 | 2020-11-22 05:25:45 | Guanajuato, Mexico | ||
2020-11-22 | Mexico | Guanajuato | 57286 | 3775 | 0 | 53511 | 21.019 | -101.2574 | 2020-11-23 05:25:26 | Guanajuato, Mexico | ||
2020-11-23 | Mexico | Guanajuato | 58020 | 3805 | 0 | 54215 | 21.019 | -101.2574 | 2020-11-24 05:27:31 | Guanajuato, Mexico | ||
2020-11-24 | Mexico | Guanajuato | 58944 | 3835 | 0 | 55109 | 21.019 | -101.2574 | 2020-11-25 05:27:20 | Guanajuato, Mexico | ||
2020-11-25 | Mexico | Guanajuato | 59618 | 3856 | 0 | 55762 | 21.019 | -101.2574 | 2020-11-26 05:27:44 | Guanajuato, Mexico | ||
2020-11-26 | Mexico | Guanajuato | 60030 | 3874 | 0 | 56156 | 21.019 | -101.2574 | 2020-11-27 05:26:53 | Guanajuato, Mexico | ||
2020-11-27 | Mexico | Guanajuato | 60918 | 3917 | 0 | 57001 | 21.019 | -101.2574 | 2020-11-28 05:25:50 | Guanajuato, Mexico | ||
2020-11-28 | Mexico | Guanajuato | 61473 | 3930 | 0 | 57543 | 21.019 | -101.2574 | 2020-11-29 05:25:55 | Guanajuato, Mexico | ||
2020-11-29 | Mexico | Guanajuato | 62073 | 3959 | 0 | 58114 | 21.019 | -101.2574 | 2020-11-30 05:26:13 | Guanajuato, Mexico | ||
2020-11-30 | Mexico | Guanajuato | 62552 | 3985 | 0 | 58567 | 21.019 | -101.2574 | 2020-12-01 05:26:18 | Guanajuato, Mexico | ||
2020-12-01 | Mexico | Guanajuato | 63274 | 4023 | 0 | 59251 | 21.019 | -101.2574 | 2020-12-02 05:27:41 | Guanajuato, Mexico | ||
2020-12-02 | Mexico | Guanajuato | 64253 | 4098 | 0 | 60155 | 21.019 | -101.2574 | 2020-12-03 05:28:22 | Guanajuato, Mexico | ||
2020-12-03 | Mexico | Guanajuato | 65131 | 4160 | 0 | 60971 | 21.019 | -101.2574 | 2020-12-04 05:27:27 | Guanajuato, Mexico | ||
2020-12-04 | Mexico | Guanajuato | 65976 | 4208 | 0 | 61768 | 21.019 | -101.2574 | 2020-12-05 05:27:36 | Guanajuato, Mexico | ||
2020-12-05 | Mexico | Guanajuato | 66516 | 4232 | 0 | 62284 | 21.019 | -101.2574 | 2020-12-06 05:26:18 | Guanajuato, Mexico |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;