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 = "Guanajuato" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
908262 | 908262 | 2021-01-19 | Mexico | Guanajuato | 96588 | 6291 | 0 | 90297 | 21.019 | -101.2574 | 2021-01-20 05:21:54 | Guanajuato, Mexico | ||
237325 | 237325 | 2021-01-18 | Mexico | Guanajuato | 95394 | 6227 | 0 | 89167 | 21.019 | -101.2574 | 2021-01-19 05:22:15 | Guanajuato, Mexico | ||
3503442 | 3503442 | 2021-01-17 | Mexico | Guanajuato | 94939 | 6181 | 0 | 88758 | 21.019 | -101.2574 | 2021-01-18 05:22:34 | Guanajuato, Mexico | ||
3101525 | 3101525 | 2021-01-16 | Mexico | Guanajuato | 94272 | 6139 | 0 | 88133 | 21.019 | -101.2574 | 2021-01-17 05:22:17 | Guanajuato, Mexico | ||
3515487 | 3515487 | 2021-01-15 | Mexico | Guanajuato | 93000 | 6082 | 0 | 86918 | 21.019 | -101.2574 | 2021-01-16 05:22:40 | Guanajuato, Mexico | ||
3879660 | 3879660 | 2021-01-14 | Mexico | Guanajuato | 91820 | 6034 | 0 | 85786 | 21.019 | -101.2574 | 2021-01-15 05:22:24 | Guanajuato, Mexico | ||
3308287 | 3308287 | 2021-01-13 | Mexico | Guanajuato | 90793 | 5938 | 0 | 84855 | 21.019 | -101.2574 | 2021-01-14 05:22:32 | Guanajuato, Mexico | ||
774432 | 774432 | 2021-01-12 | Mexico | Guanajuato | 90049 | 5886 | 0 | 84163 | 21.019 | -101.2574 | 2021-01-13 05:22:15 | Guanajuato, Mexico | ||
190153 | 190153 | 2021-01-11 | Mexico | Guanajuato | 89334 | 5835 | 0 | 83499 | 21.019 | -101.2574 | 2021-01-12 05:22:15 | Guanajuato, Mexico | ||
2625956 | 2625956 | 2021-01-10 | Mexico | Guanajuato | 88669 | 5779 | 0 | 82890 | 21.019 | -101.2574 | 2021-01-11 05:21:50 | Guanajuato, Mexico | ||
3900044 | 3900044 | 2021-01-09 | Mexico | Guanajuato | 88344 | 5750 | 0 | 82594 | 21.019 | -101.2574 | 2021-01-10 05:22:12 | Guanajuato, Mexico | ||
154067 | 154067 | 2021-01-08 | Mexico | Guanajuato | 87379 | 5701 | 0 | 81678 | 21.019 | -101.2574 | 2021-01-09 05:22:18 | Guanajuato, Mexico | ||
2541491 | 2541491 | 2021-01-07 | Mexico | Guanajuato | 86483 | 5650 | 0 | 80833 | 21.019 | -101.2574 | 2021-01-08 05:22:42 | Guanajuato, Mexico | ||
2864800 | 2864800 | 2021-01-06 | Mexico | Guanajuato | 85781 | 5562 | 0 | 80219 | 21.019 | -101.2574 | 2021-01-07 05:22:03 | Guanajuato, Mexico | ||
3034387 | 3034387 | 2021-01-05 | Mexico | Guanajuato | 85350 | 5499 | 0 | 79851 | 21.019 | -101.2574 | 2021-01-06 05:22:16 | Guanajuato, Mexico | ||
1061932 | 1061932 | 2021-01-04 | Mexico | Guanajuato | 84609 | 5467 | 0 | 79142 | 21.019 | -101.2574 | 2021-01-05 05:21:49 | Guanajuato, Mexico | ||
3230535 | 3230535 | 2021-01-03 | Mexico | Guanajuato | 84049 | 5428 | 0 | 78621 | 21.019 | -101.2574 | 2021-01-04 05:22:02 | Guanajuato, Mexico | ||
2227604 | 2227604 | 2021-01-02 | Mexico | Guanajuato | 83813 | 5382 | 0 | 78431 | 21.019 | -101.2574 | 2021-01-03 05:22:52 | Guanajuato, Mexico | ||
1136968 | 1136968 | 2021-01-01 | Mexico | Guanajuato | 83520 | 5365 | 0 | 78155 | 21.019 | -101.2574 | 2021-01-02 05:22:33 | Guanajuato, Mexico | ||
3695574 | 3695574 | 2020-12-31 | Mexico | Guanajuato | 82517 | 5341 | 0 | 77176 | 21.019 | -101.2574 | 2021-01-01 05:23:07 | Guanajuato, Mexico | ||
1010389 | 1010389 | 2020-12-30 | Mexico | Guanajuato | 81957 | 5262 | 0 | 76695 | 21.019 | -101.2574 | 2020-12-31 05:22:49 | Guanajuato, Mexico | ||
766404 | 766404 | 2020-12-29 | Mexico | Guanajuato | 81433 | 5198 | 0 | 76235 | 21.019 | -101.2574 | 2020-12-30 05:22:34 | Guanajuato, Mexico | ||
3761668 | 3761668 | 2020-12-28 | Mexico | Guanajuato | 80911 | 5148 | 0 | 75763 | 21.019 | -101.2574 | 2020-12-29 05:22:37 | Guanajuato, Mexico | ||
3777988 | 3777988 | 2020-12-27 | Mexico | Guanajuato | 80583 | 5114 | 0 | 75469 | 21.019 | -101.2574 | 2020-12-28 05:22:06 | Guanajuato, Mexico | ||
2223593 | 2223593 | 2020-12-26 | Mexico | Guanajuato | 80161 | 5085 | 0 | 75076 | 21.019 | -101.2574 | 2020-12-27 05:22:55 | Guanajuato, Mexico | ||
202340 | 202340 | 2020-12-25 | Mexico | Guanajuato | 79837 | 5047 | 0 | 74790 | 21.019 | -101.2574 | 2020-12-26 05:22:28 | Guanajuato, Mexico | ||
3691563 | 3691563 | 2020-12-24 | Mexico | Guanajuato | 78812 | 4990 | 0 | 73822 | 21.019 | -101.2574 | 2020-12-25 05:22:48 | Guanajuato, Mexico | ||
2406915 | 2406915 | 2020-12-23 | Mexico | Guanajuato | 78148 | 4914 | 0 | 73234 | 21.019 | -101.2574 | 2020-12-24 05:23:04 | Guanajuato, Mexico | ||
3769961 | 3769961 | 2020-12-22 | Mexico | Guanajuato | 77557 | 4867 | 0 | 72690 | 21.019 | -101.2574 | 2020-12-23 05:22:03 | Guanajuato, Mexico | ||
927777 | 927777 | 2020-12-21 | Mexico | Guanajuato | 77341 | 4813 | 0 | 72528 | 21.019 | -101.2574 | 2020-12-22 05:22:33 | Guanajuato, Mexico | ||
2119798 | 2119798 | 2020-12-20 | Mexico | Guanajuato | 76922 | 4794 | 0 | 72128 | 21.019 | -101.2574 | 2020-12-21 05:27:58 | Guanajuato, Mexico | ||
2931305 | 2931305 | 2020-12-19 | Mexico | Guanajuato | 76282 | 4778 | 0 | 71504 | 21.019 | -101.2574 | 2020-12-20 05:27:32 | Guanajuato, Mexico | ||
1901251 | 1901251 | 2020-12-18 | Mexico | Guanajuato | 75587 | 4747 | 0 | 70840 | 21.019 | -101.2574 | 2020-12-19 05:27:52 | Guanajuato, Mexico | ||
2128077 | 2128077 | 2020-12-17 | Mexico | Guanajuato | 74591 | 4693 | 0 | 69898 | 21.019 | -101.2574 | 2020-12-18 05:28:18 | Guanajuato, Mexico | ||
3149677 | 3149677 | 2020-12-16 | Mexico | Guanajuato | 73815 | 4650 | 0 | 69165 | 21.019 | -101.2574 | 2020-12-17 05:28:12 | Guanajuato, Mexico | ||
1034458 | 1034458 | 2020-12-15 | Mexico | Guanajuato | 73257 | 4611 | 0 | 68646 | 21.019 | -101.2574 | 2020-12-16 05:28:04 | Guanajuato, Mexico | ||
1751352 | 1751352 | 2020-12-14 | Mexico | Guanajuato | 72849 | 4563 | 0 | 68286 | 21.019 | -101.2574 | 2020-12-15 05:26:38 | Guanajuato, Mexico | ||
3847872 | 3847872 | 2020-12-13 | Mexico | Guanajuato | 72211 | 4534 | 0 | 67677 | 21.019 | -101.2574 | 2020-12-14 05:26:27 | Guanajuato, Mexico | ||
845654 | 845654 | 2020-12-12 | Mexico | Guanajuato | 71581 | 4508 | 0 | 67073 | 21.019 | -101.2574 | 2020-12-13 05:27:20 | Guanajuato, Mexico | ||
860761 | 860761 | 2020-12-11 | Mexico | Guanajuato | 70711 | 4463 | 0 | 66248 | 21.019 | -101.2574 | 2020-12-12 05:26:19 | Guanajuato, Mexico | ||
1600303 | 1600303 | 2020-12-10 | Mexico | Guanajuato | 69826 | 4405 | 0 | 65421 | 21.019 | -101.2574 | 2020-12-11 05:26:59 | Guanajuato, Mexico | ||
2975312 | 2975312 | 2020-12-09 | Mexico | Guanajuato | 69188 | 4359 | 0 | 64829 | 21.019 | -101.2574 | 2020-12-10 05:26:19 | Guanajuato, Mexico | ||
1818872 | 1818872 | 2020-12-08 | Mexico | Guanajuato | 68236 | 4304 | 0 | 63932 | 21.019 | -101.2574 | 2020-12-09 05:28:01 | Guanajuato, Mexico | ||
2347508 | 2347508 | 2020-12-07 | Mexico | Guanajuato | 67644 | 4273 | 0 | 63371 | 21.019 | -101.2574 | 2020-12-08 05:27:42 | Guanajuato, Mexico | ||
1006378 | 1006378 | 2020-12-06 | Mexico | Guanajuato | 67124 | 4250 | 0 | 62874 | 21.019 | -101.2574 | 2020-12-07 05:26:14 | Guanajuato, Mexico | ||
1632387 | 1632387 | 2020-12-05 | Mexico | Guanajuato | 66516 | 4232 | 0 | 62284 | 21.019 | -101.2574 | 2020-12-06 05:26:18 | Guanajuato, Mexico | ||
3859915 | 3859915 | 2020-12-04 | Mexico | Guanajuato | 65976 | 4208 | 0 | 61768 | 21.019 | -101.2574 | 2020-12-05 05:27:36 | Guanajuato, Mexico | ||
75173 | 75173 | 2020-12-03 | Mexico | Guanajuato | 65131 | 4160 | 0 | 60971 | 21.019 | -101.2574 | 2020-12-04 05:27:27 | Guanajuato, Mexico | ||
738385 | 738385 | 2020-12-02 | Mexico | Guanajuato | 64253 | 4098 | 0 | 60155 | 21.019 | -101.2574 | 2020-12-03 05:28:22 | Guanajuato, Mexico | ||
2537479 | 2537479 | 2020-12-01 | Mexico | Guanajuato | 63274 | 4023 | 0 | 59251 | 21.019 | -101.2574 | 2020-12-02 05:27:41 | Guanajuato, Mexico | ||
1584248 | 1584248 | 2020-11-30 | Mexico | Guanajuato | 62552 | 3985 | 0 | 58567 | 21.019 | -101.2574 | 2020-12-01 05:26:18 | Guanajuato, Mexico | ||
3566651 | 3566651 | 2020-11-29 | Mexico | Guanajuato | 62073 | 3959 | 0 | 58114 | 21.019 | -101.2574 | 2020-11-30 05:26:13 | Guanajuato, Mexico | ||
2935316 | 2935316 | 2020-11-28 | Mexico | Guanajuato | 61473 | 3930 | 0 | 57543 | 21.019 | -101.2574 | 2020-11-29 05:25:55 | Guanajuato, Mexico | ||
392319 | 392319 | 2020-11-27 | Mexico | Guanajuato | 60918 | 3917 | 0 | 57001 | 21.019 | -101.2574 | 2020-11-28 05:25:50 | Guanajuato, Mexico | ||
923766 | 923766 | 2020-11-26 | Mexico | Guanajuato | 60030 | 3874 | 0 | 56156 | 21.019 | -101.2574 | 2020-11-27 05:26:53 | Guanajuato, Mexico | ||
1972671 | 1972671 | 2020-11-25 | Mexico | Guanajuato | 59618 | 3856 | 0 | 55762 | 21.019 | -101.2574 | 2020-11-26 05:27:44 | Guanajuato, Mexico | ||
1350402 | 1350402 | 2020-11-24 | Mexico | Guanajuato | 58944 | 3835 | 0 | 55109 | 21.019 | -101.2574 | 2020-11-25 05:27:20 | Guanajuato, Mexico | ||
678396 | 678396 | 2020-11-23 | Mexico | Guanajuato | 58020 | 3805 | 0 | 54215 | 21.019 | -101.2574 | 2020-11-24 05:27:31 | Guanajuato, Mexico | ||
3190072 | 3190072 | 2020-11-22 | Mexico | Guanajuato | 57286 | 3775 | 0 | 53511 | 21.019 | -101.2574 | 2020-11-23 05:25:26 | Guanajuato, Mexico | ||
3836566 | 3836566 | 2020-11-21 | Mexico | Guanajuato | 56544 | 3754 | 0 | 52790 | 21.019 | -101.2574 | 2020-11-22 05:25:45 | Guanajuato, Mexico | ||
2701594 | 2701594 | 2020-11-20 | Mexico | Guanajuato | 55967 | 3742 | 0 | 52225 | 21.019 | -101.2574 | 2020-11-21 05:25:51 | Guanajuato, Mexico | ||
821654 | 821654 | 2020-11-19 | Mexico | Guanajuato | 55320 | 3693 | 0 | 51627 | 21.019 | -101.2574 | 2020-11-20 05:26:28 | Guanajuato, Mexico | ||
122788 | 122788 | 2020-11-18 | Mexico | Guanajuato | 55040 | 3681 | 0 | 51359 | 21.019 | -101.2574 | 2020-11-19 05:25:23 | Guanajuato, Mexico | ||
3338676 | 3338676 | 2020-11-17 | Mexico | Guanajuato | 54609 | 3663 | 0 | 50946 | 21.019 | -101.2574 | 2020-11-18 05:40:31 | Guanajuato, Mexico | ||
3169721 | 3169721 | 2020-11-16 | Mexico | Guanajuato | 54433 | 3657 | 0 | 50776 | 21.019 | -101.2574 | 2020-11-17 05:25:54 | Guanajuato, Mexico | ||
2880289 | 2880289 | 2020-11-15 | Mexico | Guanajuato | 54257 | 3651 | 0 | 50606 | 21.019 | -101.2574 | 2020-11-16 05:25:57 | Guanajuato, Mexico | ||
2915267 | 2915267 | 2020-11-14 | Mexico | Guanajuato | 54017 | 3643 | 0 | 50374 | 21.019 | -101.2574 | 2020-11-15 05:26:53 | Guanajuato, Mexico | ||
2785089 | 2785089 | 2020-11-13 | Mexico | Guanajuato | 53638 | 3634 | 0 | 50004 | 21.019 | -101.2574 | 2020-11-14 05:25:37 | Guanajuato, Mexico | ||
864854 | 864854 | 2020-11-12 | Mexico | Guanajuato | 53279 | 3598 | 0 | 49681 | 21.019 | -101.2574 | 2020-11-13 05:25:30 | Guanajuato, Mexico | ||
3440899 | 3440899 | 2020-11-11 | Mexico | Guanajuato | 52941 | 3584 | 45630 | 3727 | 21.019 | -101.2574 | 2020-11-12 05:25:55 | Guanajuato, Mexico | ||
272239 | 272239 | 2020-11-10 | Mexico | Guanajuato | 52404 | 3569 | 45630 | 3205 | 21.019 | -101.2574 | 2020-11-11 05:25:30 | Guanajuato, Mexico | ||
1988716 | 1988716 | 2020-11-09 | Mexico | Guanajuato | 52141 | 3562 | 45630 | 2949 | 21.019 | -101.2574 | 2020-11-10 05:40:07 | Guanajuato, Mexico | ||
1728568 | 1728568 | 2020-11-08 | Mexico | Guanajuato | 51866 | 3544 | 45630 | 2692 | 21.019 | -101.2574 | 2020-11-09 05:25:45 | Guanajuato, Mexico | ||
1544028 | 1544028 | 2020-11-07 | Mexico | Guanajuato | 51625 | 3537 | 45137 | 2951 | 21.019 | -101.2574 | 2020-11-08 05:24:56 | Guanajuato, Mexico | ||
376266 | 376266 | 2020-11-06 | Mexico | Guanajuato | 51144 | 3520 | 44735 | 2889 | 21.019 | -101.2574 | 2020-11-07 05:24:52 | Guanajuato, Mexico | ||
892204 | 892204 | 2020-11-05 | Mexico | Guanajuato | 50701 | 3504 | 44388 | 2809 | 21.019 | -101.2574 | 2020-11-06 05:24:55 | Guanajuato, Mexico | ||
2919266 | 2919266 | 2020-11-04 | Mexico | Guanajuato | 50409 | 3490 | 44163 | 2756 | 21.019 | -101.2574 | 2020-11-05 06:05:03 | Guanajuato, Mexico | ||
2498103 | 2498103 | 2020-11-03 | Mexico | Guanajuato | 49895 | 3471 | 43826 | 2598 | 21.019 | -101.2574 | 2020-11-04 05:25:09 | Guanajuato, Mexico | ||
3304278 | 3304278 | 2020-11-02 | Mexico | Guanajuato | 49557 | 3463 | 43218 | 2876 | 21.019 | -101.2574 | 2020-11-03 06:00:16 | Guanajuato, Mexico | ||
3409527 | 3409527 | 2020-11-01 | Mexico | Guanajuato | 49399 | 3457 | 42731 | 3211 | 21.019 | -101.2574 | 2020-11-02 05:25:04 | Guanajuato, Mexico | ||
2080016 | 2080016 | 2020-10-31 | Mexico | Guanajuato | 48997 | 3450 | 42224 | 3323 | 21.019 | -101.2574 | 2020-11-01 04:36:19 | Guanajuato, Mexico | ||
2243469 | 2243469 | 2020-10-30 | Mexico | Guanajuato | 48669 | 3441 | 41813 | 3415 | 21.019 | -101.2574 | 2020-10-31 04:24:44 | Guanajuato, Mexico | ||
210324 | 210324 | 2020-10-29 | Mexico | Guanajuato | 48272 | 3430 | 41499 | 3343 | 21.019 | -101.2574 | 2020-10-30 04:24:49 | Guanajuato, Mexico | ||
754386 | 754386 | 2020-10-28 | Mexico | Guanajuato | 47859 | 3399 | 41579 | 2881 | 21.019 | -101.2574 | 2020-10-29 04:24:49 | Guanajuato, Mexico | ||
1452670 | 1452670 | 2020-10-27 | Mexico | Guanajuato | 47609 | 3382 | 41328 | 2899 | 21.019 | -101.2574 | 2020-10-28 04:24:39 | Guanajuato, Mexico | ||
3480394 | 3480394 | 2020-10-26 | Mexico | Guanajuato | 47174 | 3333 | 41410 | 2431 | 21.019 | -101.2574 | 2020-10-27 04:24:45 | Guanajuato, Mexico | ||
8415 | 8415 | 2020-10-25 | Mexico | Guanajuato | 46975 | 3330 | 41063 | 2582 | 21.019 | -101.2574 | 2020-10-26 04:25:02 | Guanajuato, Mexico | ||
3651652 | 3651652 | 2020-10-24 | Mexico | Guanajuato | 46808 | 3323 | 40828 | 2657 | 21.019 | -101.2574 | 2020-10-25 04:24:36 | Guanajuato, Mexico | ||
1053907 | 1053907 | 2020-10-23 | Mexico | Guanajuato | 46484 | 3302 | 40571 | 2611 | 21.019 | -101.2574 | 2020-10-24 04:24:46 | Guanajuato, Mexico | ||
1177577 | 1177577 | 2020-10-22 | Mexico | Guanajuato | 46025 | 3254 | 40409 | 2362 | 21.019 | -101.2574 | 2020-10-23 04:24:46 | Guanajuato, Mexico | ||
2191682 | 2191682 | 2020-10-21 | Mexico | Guanajuato | 45715 | 3254 | 40330 | 2131 | 21.019 | -101.2574 | 2020-10-22 04:24:27 | Guanajuato, Mexico | ||
3990693 | 3990693 | 2020-10-20 | Mexico | Guanajuato | 45428 | 3237 | 40282 | 1909 | 21.019 | -101.2574 | 2020-10-21 04:24:14 | Guanajuato, Mexico | ||
1794713 | 1794713 | 2020-10-19 | Mexico | Guanajuato | 45163 | 3218 | 40125 | 1820 | 21.019 | -101.2574 | 2020-10-20 04:24:22 | Guanajuato, Mexico | ||
762397 | 762397 | 2020-10-18 | Mexico | Guanajuato | 44965 | 3212 | 39782 | 1971 | 21.019 | -101.2574 | 2020-10-19 04:24:16 | Guanajuato, Mexico | ||
1026435 | 1026435 | 2020-10-17 | Mexico | Guanajuato | 44766 | 3204 | 39608 | 1954 | 21.019 | -101.2574 | 2020-10-18 04:24:25 | Guanajuato, Mexico | ||
2856930 | 2856930 | 2020-10-16 | Mexico | Guanajuato | 44639 | 3193 | 39431 | 2015 | 21.019 | -101.2574 | 2020-10-17 04:24:12 | Guanajuato, Mexico | ||
786460 | 786460 | 2020-10-15 | Mexico | Guanajuato | 44230 | 3180 | 39165 | 1885 | 21.019 | -101.2574 | 2020-10-16 04:24:01 | Guanajuato, Mexico | ||
79171 | 79171 | 2020-10-14 | Mexico | Guanajuato | 44052 | 3161 | 39012 | 1879 | 21.019 | -101.2574 | 2020-10-15 04:24:28 | Guanajuato, Mexico | ||
3781986 | 3781986 | 2020-10-13 | Mexico | Guanajuato | 43723 | 3146 | 38842 | 1735 | 21.019 | -101.2574 | 2020-10-14 04:24:05 | Guanajuato, Mexico | ||
2291526 | 2291526 | 2020-10-12 | Mexico | Guanajuato | 43660 | 3127 | 38822 | 1711 | 21.019 | -101.2574 | 2020-10-13 04:24:02 | Guanajuato, 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]);