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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2494121 | 2494121 | 2022-08-15 | Mexico | Guanajuato | 343956 | 15021 | 0 | 21.019 | -101.2574 | 2022-08-16 04:20:58 | Guanajuato, Mexico | |||
3647671 | 3647671 | 2022-08-14 | Mexico | Guanajuato | 343867 | 15021 | 0 | 21.019 | -101.2574 | 2022-08-15 04:20:59 | Guanajuato, Mexico | |||
1968677 | 1968677 | 2022-08-13 | Mexico | Guanajuato | 343766 | 15021 | 0 | 21.019 | -101.2574 | 2022-08-14 04:20:55 | Guanajuato, Mexico | |||
2888486 | 2888486 | 2022-08-12 | Mexico | Guanajuato | 340130 | 14998 | 0 | 21.019 | -101.2574 | 2022-08-13 04:20:52 | Guanajuato, Mexico | |||
3908091 | 3908091 | 2022-08-11 | Mexico | Guanajuato | 340130 | 14998 | 0 | 21.019 | -101.2574 | 2022-08-12 04:20:54 | Guanajuato, Mexico | |||
1346408 | 1346408 | 2022-08-10 | Mexico | Guanajuato | 340130 | 14998 | 0 | 21.019 | -101.2574 | 2022-08-11 04:20:49 | Guanajuato, Mexico | |||
1086163 | 1086163 | 2022-08-09 | Mexico | Guanajuato | 340130 | 14998 | 0 | 21.019 | -101.2574 | 2022-08-10 04:20:57 | Guanajuato, Mexico | |||
3543578 | 3543578 | 2022-08-08 | Mexico | Guanajuato | 339129 | 14990 | 0 | 21.019 | -101.2574 | 2022-08-09 04:20:34 | Guanajuato, Mexico | |||
1069981 | 1069981 | 2022-08-07 | Mexico | Guanajuato | 339012 | 14990 | 0 | 21.019 | -101.2574 | 2022-08-08 04:21:08 | Guanajuato, Mexico | |||
1940569 | 1940569 | 2022-08-06 | Mexico | Guanajuato | 338793 | 14990 | 0 | 21.019 | -101.2574 | 2022-08-07 04:20:54 | Guanajuato, Mexico | |||
880368 | 880368 | 2022-08-05 | Mexico | Guanajuato | 335869 | 14977 | 0 | 21.019 | -101.2574 | 2022-08-06 04:20:56 | Guanajuato, Mexico | |||
2008779 | 2008779 | 2022-08-04 | Mexico | Guanajuato | 335869 | 14977 | 0 | 21.019 | -101.2574 | 2022-08-05 04:20:52 | Guanajuato, Mexico | |||
1098206 | 1098206 | 2022-08-03 | Mexico | Guanajuato | 334022 | 14963 | 0 | 21.019 | -101.2574 | 2022-08-04 04:20:58 | Guanajuato, Mexico | |||
1405131 | 1405131 | 2022-08-02 | Mexico | Guanajuato | 331952 | 14957 | 0 | 21.019 | -101.2574 | 2022-08-03 04:20:59 | Guanajuato, Mexico | |||
3617169 | 3617169 | 2022-08-01 | Mexico | Guanajuato | 330010 | 14951 | 0 | 21.019 | -101.2574 | 2022-08-02 04:20:53 | Guanajuato, Mexico | |||
3871649 | 3871649 | 2022-07-31 | Mexico | Guanajuato | 325933 | 14947 | 0 | 21.019 | -101.2574 | 2022-08-01 04:21:03 | Guanajuato, Mexico | |||
674403 | 674403 | 2022-07-30 | Mexico | Guanajuato | 325933 | 14947 | 0 | 21.019 | -101.2574 | 2022-07-31 04:21:02 | Guanajuato, Mexico | |||
1783602 | 1783602 | 2022-07-29 | Mexico | Guanajuato | 325933 | 14947 | 0 | 21.019 | -101.2574 | 2022-07-30 04:20:42 | Guanajuato, Mexico | |||
1065965 | 1065965 | 2022-07-28 | Mexico | Guanajuato | 324257 | 14943 | 0 | 21.019 | -101.2574 | 2022-07-29 04:20:45 | Guanajuato, Mexico | |||
2335484 | 2335484 | 2022-07-27 | Mexico | Guanajuato | 324257 | 14943 | 0 | 21.019 | -101.2574 | 2022-07-28 04:20:56 | Guanajuato, Mexico | |||
1487674 | 1487674 | 2022-07-26 | Mexico | Guanajuato | 319633 | 14932 | 0 | 21.019 | -101.2574 | 2022-07-27 04:21:04 | Guanajuato, Mexico | |||
2594120 | 2594120 | 2022-07-25 | Mexico | Guanajuato | 319633 | 14932 | 0 | 21.019 | -101.2574 | 2022-07-26 04:20:58 | Guanajuato, Mexico | |||
896235 | 896235 | 2022-07-24 | Mexico | Guanajuato | 319317 | 14931 | 0 | 21.019 | -101.2574 | 2022-07-25 04:20:51 | Guanajuato, Mexico | |||
91229 | 91229 | 2022-07-23 | Mexico | Guanajuato | 319028 | 14931 | 0 | 21.019 | -101.2574 | 2022-07-24 04:20:47 | Guanajuato, Mexico | |||
900251 | 900251 | 2022-07-22 | Mexico | Guanajuato | 317120 | 14925 | 0 | 21.019 | -101.2574 | 2022-07-23 04:20:53 | Guanajuato, Mexico | |||
670387 | 670387 | 2022-07-21 | Mexico | Guanajuato | 315081 | 14922 | 0 | 21.019 | -101.2574 | 2022-07-22 04:21:15 | Guanajuato, Mexico | |||
1608350 | 1608350 | 2022-07-20 | Mexico | Guanajuato | 312976 | 14919 | 0 | 21.019 | -101.2574 | 2022-07-21 04:21:10 | Guanajuato, Mexico | |||
958983 | 958983 | 2022-07-19 | Mexico | Guanajuato | 310782 | 14918 | 0 | 21.019 | -101.2574 | 2022-07-20 04:20:59 | Guanajuato, Mexico | |||
3210370 | 3210370 | 2022-07-18 | Mexico | Guanajuato | 308299 | 14918 | 0 | 21.019 | -101.2574 | 2022-07-19 04:20:58 | Guanajuato, Mexico | |||
3405545 | 3405545 | 2022-07-17 | Mexico | Guanajuato | 308299 | 14918 | 0 | 21.019 | -101.2574 | 2022-07-18 04:20:59 | Guanajuato, Mexico | |||
2151745 | 2151745 | 2022-07-16 | Mexico | Guanajuato | 307975 | 14918 | 0 | 21.019 | -101.2574 | 2022-07-17 04:21:15 | Guanajuato, Mexico | |||
2418978 | 2418978 | 2022-07-15 | Mexico | Guanajuato | 306080 | 14914 | 0 | 21.019 | -101.2574 | 2022-07-16 04:21:05 | Guanajuato, Mexico | |||
3429053 | 3429053 | 2022-07-14 | Mexico | Guanajuato | 304059 | 14911 | 0 | 21.019 | -101.2574 | 2022-07-15 04:20:53 | Guanajuato, Mexico | |||
3109573 | 3109573 | 2022-07-13 | Mexico | Guanajuato | 302167 | 14908 | 0 | 21.019 | -101.2574 | 2022-07-14 04:20:57 | Guanajuato, Mexico | |||
629996 | 629996 | 2022-07-12 | Mexico | Guanajuato | 300330 | 14907 | 0 | 21.019 | -101.2574 | 2022-07-13 04:20:58 | Guanajuato, Mexico | |||
1211640 | 1211640 | 2022-07-11 | Mexico | Guanajuato | 298755 | 14903 | 0 | 21.019 | -101.2574 | 2022-07-12 04:20:51 | Guanajuato, Mexico | |||
2789122 | 2789122 | 2022-07-10 | Mexico | Guanajuato | 298522 | 14903 | 0 | 21.019 | -101.2574 | 2022-07-11 04:20:46 | Guanajuato, Mexico | |||
142075 | 142075 | 2022-07-09 | Mexico | Guanajuato | 298207 | 14903 | 0 | 21.019 | -101.2574 | 2022-07-10 04:20:54 | Guanajuato, Mexico | |||
1417175 | 1417175 | 2022-07-08 | Mexico | Guanajuato | 295090 | 14902 | 0 | 21.019 | -101.2574 | 2022-07-09 04:20:59 | Guanajuato, Mexico | |||
2741100 | 2741100 | 2022-07-07 | Mexico | Guanajuato | 295090 | 14902 | 0 | 21.019 | -101.2574 | 2022-07-08 04:20:56 | Guanajuato, Mexico | |||
1199895 | 1199895 | 2022-07-06 | Mexico | Guanajuato | 293473 | 14901 | 0 | 21.019 | -101.2574 | 2022-07-07 04:20:55 | Guanajuato, Mexico | |||
3966638 | 3966638 | 2022-07-05 | Mexico | Guanajuato | 292189 | 14900 | 0 | 21.019 | -101.2574 | 2022-07-06 04:20:58 | Guanajuato, Mexico | |||
3078149 | 3078149 | 2022-07-04 | Mexico | Guanajuato | 291027 | 14897 | 0 | 21.019 | -101.2574 | 2022-07-05 04:20:45 | Guanajuato, Mexico | |||
1767431 | 1767431 | 2022-07-03 | Mexico | Guanajuato | 290938 | 14897 | 0 | 21.019 | -101.2574 | 2022-07-04 04:20:54 | Guanajuato, Mexico | |||
3365417 | 3365417 | 2022-07-02 | Mexico | Guanajuato | 290021 | 14896 | 0 | 21.019 | -101.2574 | 2022-07-03 04:20:59 | Guanajuato, Mexico | |||
593746 | 593746 | 2022-07-01 | Mexico | Guanajuato | 290021 | 14896 | 0 | 21.019 | -101.2574 | 2022-07-02 04:21:16 | Guanajuato, Mexico | |||
3940147 | 3940147 | 2022-06-30 | Mexico | Guanajuato | 289279 | 14894 | 0 | 21.019 | -101.2574 | 2022-07-01 04:21:10 | Guanajuato, Mexico | |||
2490105 | 2490105 | 2022-06-29 | Mexico | Guanajuato | 287855 | 14892 | 0 | 21.019 | -101.2574 | 2022-06-30 04:21:01 | Guanajuato, Mexico | |||
2239487 | 2239487 | 2022-06-28 | Mexico | Guanajuato | 287855 | 14892 | 0 | 21.019 | -101.2574 | 2022-06-29 04:20:59 | Guanajuato, Mexico | |||
2147729 | 2147729 | 2022-06-27 | Mexico | Guanajuato | 287305 | 14891 | 0 | 21.019 | -101.2574 | 2022-06-28 04:20:58 | Guanajuato, Mexico | |||
475530 | 475530 | 2022-06-26 | Mexico | Guanajuato | 287239 | 14891 | 0 | 21.019 | -101.2574 | 2022-06-27 04:21:00 | Guanajuato, Mexico | |||
938905 | 938905 | 2022-06-25 | Mexico | Guanajuato | 287146 | 14891 | 0 | 21.019 | -101.2574 | 2022-06-26 04:21:02 | Guanajuato, Mexico | |||
3346725 | 3346725 | 2022-06-24 | Mexico | Guanajuato | 286315 | 14890 | 0 | 21.019 | -101.2574 | 2022-06-25 04:20:57 | Guanajuato, Mexico | |||
1648466 | 1648466 | 2022-06-23 | Mexico | Guanajuato | 285957 | 14890 | 0 | 21.019 | -101.2574 | 2022-06-24 04:20:58 | Guanajuato, Mexico | |||
2187701 | 2187701 | 2022-06-22 | Mexico | Guanajuato | 285592 | 14889 | 0 | 21.019 | -101.2574 | 2022-06-23 04:20:55 | Guanajuato, Mexico | |||
166132 | 166132 | 2022-06-21 | Mexico | Guanajuato | 285592 | 14889 | 0 | 21.019 | -101.2574 | 2022-06-22 04:20:54 | Guanajuato, Mexico | |||
1763415 | 1763415 | 2022-06-20 | Mexico | Guanajuato | 285329 | 14889 | 0 | 21.019 | -101.2574 | 2022-06-21 04:20:56 | Guanajuato, Mexico | |||
3269601 | 3269601 | 2022-06-19 | Mexico | Guanajuato | 285260 | 14889 | 0 | 21.019 | -101.2574 | 2022-06-20 04:21:01 | Guanajuato, Mexico | |||
3397513 | 3397513 | 2022-06-18 | Mexico | Guanajuato | 284674 | 14889 | 0 | 21.019 | -101.2574 | 2022-06-19 04:20:51 | Guanajuato, Mexico | |||
2311390 | 2311390 | 2022-06-17 | Mexico | Guanajuato | 284674 | 14889 | 0 | 21.019 | -101.2574 | 2022-06-18 04:21:10 | Guanajuato, Mexico | |||
558894 | 558894 | 2022-06-16 | Mexico | Guanajuato | 284674 | 14889 | 0 | 21.019 | -101.2574 | 2022-06-17 04:20:56 | Guanajuato, Mexico | |||
3982696 | 3982696 | 2022-06-15 | Mexico | Guanajuato | 284446 | 14888 | 0 | 21.019 | -101.2574 | 2022-06-16 04:20:55 | Guanajuato, Mexico | |||
946937 | 946937 | 2022-06-14 | Mexico | Guanajuato | 284196 | 14890 | 0 | 21.019 | -101.2574 | 2022-06-15 04:20:54 | Guanajuato, Mexico | |||
2979345 | 2979345 | 2022-06-13 | Mexico | Guanajuato | 283935 | 14889 | 0 | 21.019 | -101.2574 | 2022-06-14 04:20:52 | Guanajuato, Mexico | |||
2235471 | 2235471 | 2022-06-12 | Mexico | Guanajuato | 283935 | 14889 | 0 | 21.019 | -101.2574 | 2022-06-13 04:21:14 | Guanajuato, Mexico | |||
3141669 | 3141669 | 2022-06-11 | Mexico | Guanajuato | 283885 | 14889 | 0 | 21.019 | -101.2574 | 2022-06-12 04:20:53 | Guanajuato, Mexico | |||
1944585 | 1944585 | 2022-06-10 | Mexico | Guanajuato | 283745 | 14888 | 0 | 21.019 | -101.2574 | 2022-06-11 04:21:01 | Guanajuato, Mexico | |||
3157724 | 3157724 | 2022-06-09 | Mexico | Guanajuato | 283417 | 14887 | 0 | 21.019 | -101.2574 | 2022-06-10 04:20:55 | Guanajuato, Mexico | |||
1421191 | 1421191 | 2022-06-08 | Mexico | Guanajuato | 283417 | 14887 | 0 | 21.019 | -101.2574 | 2022-06-09 04:20:54 | Guanajuato, Mexico | |||
3726305 | 3726305 | 2022-06-07 | Mexico | Guanajuato | 283281 | 14887 | 0 | 21.019 | -101.2574 | 2022-06-08 04:20:55 | Guanajuato, Mexico | |||
3887707 | 3887707 | 2022-06-06 | Mexico | Guanajuato | 283172 | 14886 | 0 | 21.019 | -101.2574 | 2022-06-07 04:21:08 | Guanajuato, Mexico | |||
3507476 | 3507476 | 2022-06-05 | Mexico | Guanajuato | 283133 | 14886 | 0 | 21.019 | -101.2574 | 2022-06-06 04:20:57 | Guanajuato, Mexico | |||
3527553 | 3527553 | 2022-06-04 | Mexico | Guanajuato | 283074 | 14885 | 0 | 21.019 | -101.2574 | 2022-06-05 04:20:55 | Guanajuato, Mexico | |||
3133639 | 3133639 | 2022-06-03 | Mexico | Guanajuato | 282884 | 14884 | 0 | 21.019 | -101.2574 | 2022-06-04 04:20:58 | Guanajuato, Mexico | |||
3578714 | 3578714 | 2022-06-02 | Mexico | Guanajuato | 282884 | 14884 | 0 | 21.019 | -101.2574 | 2022-06-03 04:20:58 | Guanajuato, Mexico | |||
971007 | 971007 | 2022-06-01 | Mexico | Guanajuato | 282792 | 14883 | 0 | 21.019 | -101.2574 | 2022-06-02 05:20:39 | Guanajuato, Mexico | |||
229314 | 229314 | 2022-05-31 | Mexico | Guanajuato | 282715 | 14884 | 0 | 21.019 | -101.2574 | 2022-06-01 04:20:55 | Guanajuato, Mexico | |||
3186079 | 3186079 | 2022-05-30 | Mexico | Guanajuato | 282641 | 14884 | 0 | 21.019 | -101.2574 | 2022-05-31 04:20:51 | Guanajuato, Mexico | |||
3198228 | 3198228 | 2022-05-29 | Mexico | Guanajuato | 282319 | 14885 | 0 | 21.019 | -101.2574 | 2022-05-30 04:20:50 | Guanajuato, Mexico | |||
2725106 | 2725106 | 2022-05-28 | Mexico | Guanajuato | 282319 | 14885 | 0 | 21.019 | -101.2574 | 2022-05-29 04:20:53 | Guanajuato, Mexico | |||
1314287 | 1314287 | 2022-05-27 | Mexico | Guanajuato | 282319 | 14885 | 0 | 21.019 | -101.2574 | 2022-05-28 04:21:07 | Guanajuato, Mexico | |||
1850079 | 1850079 | 2022-05-26 | Mexico | Guanajuato | 282319 | 14885 | 0 | 21.019 | -101.2574 | 2022-05-27 04:20:56 | Guanajuato, Mexico | |||
2047955 | 2047955 | 2022-05-25 | Mexico | Guanajuato | 282319 | 14885 | 0 | 21.019 | -101.2574 | 2022-05-26 04:20:50 | Guanajuato, Mexico | |||
2999393 | 2999393 | 2022-05-24 | Mexico | Guanajuato | 282319 | 14885 | 0 | 21.019 | -101.2574 | 2022-05-25 04:20:56 | Guanajuato, Mexico | |||
3593114 | 3593114 | 2022-05-23 | Mexico | Guanajuato | 282319 | 14885 | 0 | 21.019 | -101.2574 | 2022-05-24 04:20:57 | Guanajuato, Mexico | |||
621966 | 621966 | 2022-05-22 | Mexico | Guanajuato | 282319 | 14885 | 0 | 21.019 | -101.2574 | 2022-05-26 04:20:50 | Guanajuato, Mexico | |||
1109662 | 1109662 | 2022-05-21 | Mexico | Guanajuato | 282231 | 14883 | 0 | 21.019 | -101.2574 | 2022-05-22 04:20:52 | Guanajuato, Mexico | |||
1169286 | 1169286 | 2022-05-20 | Mexico | Guanajuato | 282231 | 14883 | 0 | 21.019 | -101.2574 | 2022-05-21 04:20:58 | Guanajuato, Mexico | |||
3896049 | 3896049 | 2022-05-19 | Mexico | Guanajuato | 282231 | 14883 | 0 | 21.019 | -101.2574 | 2022-05-20 04:20:57 | Guanajuato, Mexico | |||
1184833 | 1184833 | 2022-05-18 | Mexico | Guanajuato | 282231 | 14883 | 0 | 21.019 | -101.2574 | 2022-05-19 04:20:54 | Guanajuato, Mexico | |||
3582730 | 3582730 | 2022-05-17 | Mexico | Guanajuato | 282231 | 14883 | 0 | 21.019 | -101.2574 | 2022-05-18 04:20:50 | Guanajuato, Mexico | |||
1503687 | 1503687 | 2022-05-16 | Mexico | Guanajuato | 282231 | 14883 | 0 | 21.019 | -101.2574 | 2022-05-17 04:20:59 | Guanajuato, Mexico | |||
2084046 | 2084046 | 2022-05-15 | Mexico | Guanajuato | 282183 | 14887 | 0 | 21.019 | -101.2574 | 2022-05-16 04:20:47 | Guanajuato, Mexico | |||
3354756 | 3354756 | 2022-05-14 | Mexico | Guanajuato | 282183 | 14887 | 0 | 21.019 | -101.2574 | 2022-05-15 04:20:53 | Guanajuato, Mexico | |||
658401 | 658401 | 2022-05-13 | Mexico | Guanajuato | 282183 | 14887 | 0 | 21.019 | -101.2574 | 2022-05-14 04:20:48 | Guanajuato, Mexico | |||
2533484 | 2533484 | 2022-05-12 | Mexico | Guanajuato | 282183 | 14887 | 0 | 21.019 | -101.2574 | 2022-05-13 04:20:51 | Guanajuato, Mexico | |||
3444930 | 3444930 | 2022-05-11 | Mexico | Guanajuato | 282183 | 14887 | 0 | 21.019 | -101.2574 | 2022-05-12 04:20:54 | Guanajuato, Mexico | |||
3535547 | 3535547 | 2022-05-10 | Mexico | Guanajuato | 282183 | 14887 | 0 | 21.019 | -101.2574 | 2022-05-11 04:20:48 | Guanajuato, Mexico | |||
222082 | 222082 | 2022-05-09 | Mexico | Guanajuato | 282183 | 14887 | 0 | 21.019 | -101.2574 | 2022-05-10 04:20:50 | Guanajuato, Mexico | |||
2331467 | 2331467 | 2022-05-08 | Mexico | Guanajuato | 282090 | 14883 | 0 | 21.019 | -101.2574 | 2022-05-09 04:20:54 | 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]);