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 latitude
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
670387 | 670387 | 2022-07-21 | Mexico | Guanajuato | 315081 | 14922 | 0 | 21.019 | -101.2574 | 2022-07-22 04:21:15 | Guanajuato, Mexico | |||
674403 | 674403 | 2022-07-30 | Mexico | Guanajuato | 325933 | 14947 | 0 | 21.019 | -101.2574 | 2022-07-31 04:21:02 | 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 | ||
690461 | 690461 | 2022-12-23 | Mexico | Guanajuato | 353905 | 15112 | 0 | 21.019 | -101.2574 | 2022-12-24 04:21:02 | Guanajuato, Mexico | |||
702489 | 702489 | 2021-03-16 | Mexico | Guanajuato | 123749 | 9558 | 0 | 114191 | 21.019 | -101.2574 | 2021-03-17 05:25:07 | Guanajuato, Mexico | ||
710538 | 710538 | 2022-11-01 | Mexico | Guanajuato | 351726 | 15098 | 0 | 21.019 | -101.2574 | 2022-11-02 04:22:09 | Guanajuato, Mexico | |||
718570 | 718570 | 2022-12-04 | Mexico | Guanajuato | 352129 | 15104 | 0 | 21.019 | -101.2574 | 2022-12-05 04:20:58 | Guanajuato, Mexico | |||
726582 | 726582 | 2021-05-22 | Mexico | Guanajuato | 131654 | 10760 | 0 | 120894 | 21.019 | -101.2574 | 2021-05-23 04:20:51 | Guanajuato, Mexico | ||
737426 | 737426 | 2020-06-12 | Mexico | Guanajuato | 3221 | 178 | 2022 | 1021 | 21.019 | -101.2574 | 2020-06-13 03:33:14 | 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 | ||
742398 | 742398 | 2021-02-20 | Mexico | Guanajuato | 116774 | 8737 | 0 | 108037 | 21.019 | -101.2574 | 2021-02-21 05:24:33 | 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 | ||
762397 | 762397 | 2020-10-18 | Mexico | Guanajuato | 44965 | 3212 | 39782 | 1971 | 21.019 | -101.2574 | 2020-10-19 04:24:16 | 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 | ||
774432 | 774432 | 2021-01-12 | Mexico | Guanajuato | 90049 | 5886 | 0 | 84163 | 21.019 | -101.2574 | 2021-01-13 05:22:15 | Guanajuato, Mexico | ||
778446 | 778446 | 2021-07-08 | Mexico | Guanajuato | 133467 | 11115 | 0 | 122352 | 21.019 | -101.2574 | 2021-07-09 04:21:21 | 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 | ||
790467 | 790467 | 2021-02-04 | Mexico | Guanajuato | 108483 | 7577 | 0 | 100906 | 21.019 | -101.2574 | 2021-02-05 05:22:38 | Guanajuato, Mexico | ||
794502 | 794502 | 2022-10-24 | Mexico | Guanajuato | 351828 | 15079 | 0 | 21.019 | -101.2574 | 2022-10-25 04:21:53 | Guanajuato, Mexico | |||
805274 | 805274 | 2020-06-01 | Mexico | Guanajuato | 1680 | 112 | 992 | 576 | 21.019 | -101.2574 | 2020-06-02 02:33:08 | Guanajuato, Mexico | ||
813659 | 813659 | 2020-09-05 | Mexico | Guanajuato | 33773 | 2303 | 28242 | 3228 | 21.019 | -101.2574 | 2020-09-06 04:28:33 | Guanajuato, Mexico | ||
817650 | 817650 | 2020-10-09 | Mexico | Guanajuato | 43054 | 3094 | 38188 | 1772 | 21.019 | -101.2574 | 2020-10-10 04:23:57 | 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 | ||
825668 | 825668 | 2021-06-06 | Mexico | Guanajuato | 132166 | 10974 | 0 | 121192 | 21.019 | -101.2574 | 2021-06-07 04:22:51 | Guanajuato, Mexico | ||
829682 | 829682 | 2021-07-09 | Mexico | Guanajuato | 133589 | 11118 | 0 | 122471 | 21.019 | -101.2574 | 2021-07-10 04:21:25 | Guanajuato, Mexico | ||
833715 | 833715 | 2022-12-02 | Mexico | Guanajuato | 352129 | 15104 | 0 | 21.019 | -101.2574 | 2022-12-03 04:21:02 | Guanajuato, Mexico | |||
837695 | 837695 | 2020-08-17 | Mexico | Guanajuato | 26948 | 1375 | 23090 | 2483 | 21.019 | -101.2574 | 2020-08-18 04:27:56 | 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 | ||
849687 | 849687 | 2022-11-02 | Mexico | Guanajuato | 351757 | 15102 | 0 | 21.019 | -101.2574 | 2022-11-03 04:22:05 | Guanajuato, Mexico | |||
853703 | 853703 | 2022-09-30 | Mexico | Guanajuato | 351547 | 15075 | 0 | 21.019 | -101.2574 | 2022-10-01 04:23:01 | 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 | ||
864854 | 864854 | 2020-11-12 | Mexico | Guanajuato | 53279 | 3598 | 0 | 49681 | 21.019 | -101.2574 | 2020-11-13 05:25:30 | Guanajuato, Mexico | ||
868887 | 868887 | 2022-12-11 | Mexico | Guanajuato | 352852 | 15108 | 0 | 21.019 | -101.2574 | 2022-12-12 04:21:01 | Guanajuato, Mexico | |||
880368 | 880368 | 2022-08-05 | Mexico | Guanajuato | 335869 | 14977 | 0 | 21.019 | -101.2574 | 2022-08-06 04:20:56 | Guanajuato, Mexico | |||
887242 | 887242 | 2020-07-07 | Mexico | Guanajuato | 9893 | 451 | 7565 | 1877 | 21.019 | -101.2574 | 2020-07-08 05:33:48 | Guanajuato, Mexico | ||
888204 | 888204 | 2021-04-26 | Mexico | Guanajuato | 130287 | 10540 | 0 | 119747 | 21.019 | -101.2574 | 2021-04-27 04:20: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 | ||
896235 | 896235 | 2022-07-24 | Mexico | Guanajuato | 319317 | 14931 | 0 | 21.019 | -101.2574 | 2022-07-25 04:20:51 | Guanajuato, Mexico | |||
900251 | 900251 | 2022-07-22 | Mexico | Guanajuato | 317120 | 14925 | 0 | 21.019 | -101.2574 | 2022-07-23 04:20:53 | Guanajuato, Mexico | |||
908262 | 908262 | 2021-01-19 | Mexico | Guanajuato | 96588 | 6291 | 0 | 90297 | 21.019 | -101.2574 | 2021-01-20 05:21:54 | Guanajuato, Mexico | ||
912296 | 912296 | 2022-10-29 | Mexico | Guanajuato | 351837 | 15082 | 0 | 21.019 | -101.2574 | 2022-10-30 04:22:14 | 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 | ||
927777 | 927777 | 2020-12-21 | Mexico | Guanajuato | 77341 | 4813 | 0 | 72528 | 21.019 | -101.2574 | 2020-12-22 05:22:33 | Guanajuato, Mexico | ||
938905 | 938905 | 2022-06-25 | Mexico | Guanajuato | 287146 | 14891 | 0 | 21.019 | -101.2574 | 2022-06-26 04:21:02 | Guanajuato, Mexico | |||
946937 | 946937 | 2022-06-14 | Mexico | Guanajuato | 284196 | 14890 | 0 | 21.019 | -101.2574 | 2022-06-15 04:20:54 | Guanajuato, Mexico | |||
954949 | 954949 | 2021-04-25 | Mexico | Guanajuato | 130265 | 10511 | 0 | 119754 | 21.019 | -101.2574 | 2021-04-26 04:21:04 | Guanajuato, Mexico | ||
958983 | 958983 | 2022-07-19 | Mexico | Guanajuato | 310782 | 14918 | 0 | 21.019 | -101.2574 | 2022-07-20 04:20:59 | Guanajuato, Mexico | |||
962999 | 962999 | 2022-09-09 | Mexico | Guanajuato | 350490 | 15056 | 0 | 21.019 | -101.2574 | 2022-09-10 04:21:10 | Guanajuato, Mexico | |||
966980 | 966980 | 2020-09-29 | Mexico | Guanajuato | 40645 | 2890 | 36199 | 1556 | 21.019 | -101.2574 | 2020-09-30 04:23:33 | Guanajuato, Mexico | ||
971007 | 971007 | 2022-06-01 | Mexico | Guanajuato | 282792 | 14883 | 0 | 21.019 | -101.2574 | 2022-06-02 05:20:39 | Guanajuato, Mexico | |||
975002 | 975002 | 2021-02-06 | Mexico | Guanajuato | 110658 | 7844 | 0 | 102814 | 21.019 | -101.2574 | 2021-02-07 05:23:00 | Guanajuato, Mexico | ||
983033 | 983033 | 2021-04-17 | Mexico | Guanajuato | 129685 | 10365 | 0 | 119320 | 21.019 | -101.2574 | 2021-04-18 04:20:41 | Guanajuato, Mexico | ||
991082 | 991082 | 2022-08-16 | Mexico | Guanajuato | 344704 | 15024 | 0 | 21.019 | -101.2574 | 2022-08-17 04:20:59 | Guanajuato, Mexico | |||
998523 | 998523 | 2021-03-01 | Mexico | Guanajuato | 119423 | 9077 | 0 | 110346 | 21.019 | -101.2574 | 2021-03-02 05:23:30 | Guanajuato, Mexico | ||
1005417 | 1005417 | 2020-07-09 | Mexico | Guanajuato | 10707 | 506 | 8113 | 2088 | 21.019 | -101.2574 | 2020-07-10 04:34:24 | 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 | ||
1010389 | 1010389 | 2020-12-30 | Mexico | Guanajuato | 81957 | 5262 | 0 | 76695 | 21.019 | -101.2574 | 2020-12-31 05:22:49 | Guanajuato, Mexico | ||
1018438 | 1018438 | 2022-12-24 | Mexico | Guanajuato | 354923 | 15117 | 0 | 21.019 | -101.2574 | 2022-12-25 04:21:04 | Guanajuato, Mexico | |||
1022454 | 1022454 | 2022-11-04 | Mexico | Guanajuato | 351789 | 15102 | 0 | 21.019 | -101.2574 | 2022-11-05 04:21:52 | 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 | ||
1034458 | 1034458 | 2020-12-15 | Mexico | Guanajuato | 73257 | 4611 | 0 | 68646 | 21.019 | -101.2574 | 2020-12-16 05:28:04 | Guanajuato, Mexico | ||
1041907 | 1041907 | 2020-10-07 | Mexico | Guanajuato | 42633 | 3029 | 37883 | 1721 | 21.019 | -101.2574 | 2020-10-08 04:23:56 | Guanajuato, Mexico | ||
1045899 | 1045899 | 2020-09-30 | Mexico | Guanajuato | 40883 | 2907 | 36202 | 1774 | 21.019 | -101.2574 | 2020-10-01 04:23:42 | Guanajuato, Mexico | ||
1049926 | 1049926 | 2022-11-06 | Mexico | Guanajuato | 351789 | 15102 | 0 | 21.019 | -101.2574 | 2022-11-07 04:21:26 | 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 | ||
1061932 | 1061932 | 2021-01-04 | Mexico | Guanajuato | 84609 | 5467 | 0 | 79142 | 21.019 | -101.2574 | 2021-01-05 05:21:49 | Guanajuato, Mexico | ||
1065965 | 1065965 | 2022-07-28 | Mexico | Guanajuato | 324257 | 14943 | 0 | 21.019 | -101.2574 | 2022-07-29 04:20:45 | Guanajuato, Mexico | |||
1069981 | 1069981 | 2022-08-07 | Mexico | Guanajuato | 339012 | 14990 | 0 | 21.019 | -101.2574 | 2022-08-08 04:21:08 | Guanajuato, Mexico | |||
1073997 | 1073997 | 2022-12-28 | Mexico | Guanajuato | 355473 | 15118 | 0 | 21.019 | -101.2574 | 2022-12-29 04:21:01 | Guanajuato, Mexico | |||
1082009 | 1082009 | 2021-05-14 | Mexico | Guanajuato | 131297 | 10684 | 0 | 120613 | 21.019 | -101.2574 | 2021-05-15 04:20:58 | Guanajuato, Mexico | ||
1086163 | 1086163 | 2022-08-09 | Mexico | Guanajuato | 340130 | 14998 | 0 | 21.019 | -101.2574 | 2022-08-10 04:20:57 | Guanajuato, Mexico | |||
1090159 | 1090159 | 2021-03-03 | Mexico | Guanajuato | 120295 | 9179 | 0 | 111116 | 21.019 | -101.2574 | 2021-03-04 05:24:24 | Guanajuato, Mexico | ||
1094172 | 1094172 | 2021-01-20 | Mexico | Guanajuato | 97793 | 6446 | 0 | 91347 | 21.019 | -101.2574 | 2021-01-21 05:22:01 | Guanajuato, Mexico | ||
1098206 | 1098206 | 2022-08-03 | Mexico | Guanajuato | 334022 | 14963 | 0 | 21.019 | -101.2574 | 2022-08-04 04:20:58 | Guanajuato, Mexico | |||
1105636 | 1105636 | 2020-09-02 | Mexico | Guanajuato | 32376 | 2177 | 27230 | 2969 | 21.019 | -101.2574 | 2020-09-03 04:28:22 | Guanajuato, Mexico | ||
1109662 | 1109662 | 2022-05-21 | Mexico | Guanajuato | 282231 | 14883 | 0 | 21.019 | -101.2574 | 2022-05-22 04:20:52 | Guanajuato, Mexico | |||
1117675 | 1117675 | 2021-08-06 | Mexico | Guanajuato | 141120 | 11202 | 0 | 21.019 | -101.2574 | 2021-08-07 04:21:30 | Guanajuato, Mexico | |||
1121672 | 1121672 | 2020-09-17 | Mexico | Guanajuato | 37796 | 2667 | 32312 | 2817 | 21.019 | -101.2574 | 2020-09-18 05:05:00 | Guanajuato, Mexico | ||
1125679 | 1125679 | 2021-06-18 | Mexico | Guanajuato | 132605 | 11070 | 0 | 121535 | 21.019 | -101.2574 | 2021-06-19 04:22:33 | Guanajuato, Mexico | ||
1136009 | 1136009 | 2020-06-26 | Mexico | Guanajuato | 6402 | 327 | 4405 | 1670 | 21.019 | -101.2574 | 2020-06-27 04:33:35 | 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 | ||
1149033 | 1149033 | 2022-12-12 | Mexico | Guanajuato | 353011 | 15108 | 0 | 21.019 | -101.2574 | 2022-12-13 04:21:01 | Guanajuato, Mexico | |||
1153205 | 1153205 | 2021-02-18 | Mexico | Guanajuato | 115858 | 8598 | 0 | 107260 | 21.019 | -101.2574 | 2021-02-19 05:24:16 | Guanajuato, Mexico | ||
1157239 | 1157239 | 2022-04-29 | Mexico | Guanajuato | 282085 | 14880 | 0 | 21.019 | -101.2574 | 2022-04-30 04:21:05 | Guanajuato, Mexico | |||
1161256 | 1161256 | 2022-08-18 | Mexico | Guanajuato | 345412 | 15029 | 0 | 21.019 | -101.2574 | 2022-08-19 04:20:54 | Guanajuato, Mexico | |||
1165253 | 1165253 | 2021-07-04 | Mexico | Guanajuato | 133176 | 11116 | 0 | 122060 | 21.019 | -101.2574 | 2021-07-05 04:21:28 | Guanajuato, Mexico | ||
1169286 | 1169286 | 2022-05-20 | Mexico | Guanajuato | 282231 | 14883 | 0 | 21.019 | -101.2574 | 2022-05-21 04:20:58 | Guanajuato, Mexico | |||
1173266 | 1173266 | 2020-09-10 | Mexico | Guanajuato | 35503 | 2488 | 30013 | 3002 | 21.019 | -101.2574 | 2020-09-11 04:46:23 | 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 | ||
1184833 | 1184833 | 2022-05-18 | Mexico | Guanajuato | 282231 | 14883 | 0 | 21.019 | -101.2574 | 2022-05-19 04:20:54 | Guanajuato, Mexico | |||
1188830 | 1188830 | 2021-05-31 | Mexico | Guanajuato | 131942 | 10872 | 0 | 121070 | 21.019 | -101.2574 | 2021-06-01 04:23:09 | Guanajuato, Mexico | ||
1195777 | 1195777 | 2020-06-17 | Mexico | Guanajuato | 4061 | 215 | 2794 | 1052 | 21.019 | -101.2574 | 2020-06-18 04:33:18 | Guanajuato, Mexico | ||
1199895 | 1199895 | 2022-07-06 | Mexico | Guanajuato | 293473 | 14901 | 0 | 21.019 | -101.2574 | 2022-07-07 04:20:55 | Guanajuato, Mexico | |||
1203891 | 1203891 | 2021-03-22 | Mexico | Guanajuato | 125374 | 9747 | 0 | 115627 | 21.019 | -101.2574 | 2021-03-23 05:26:18 | Guanajuato, Mexico | ||
1211640 | 1211640 | 2022-07-11 | Mexico | Guanajuato | 298755 | 14903 | 0 | 21.019 | -101.2574 | 2022-07-12 04:20:51 | Guanajuato, Mexico | |||
1219652 | 1219652 | 2021-03-27 | Mexico | Guanajuato | 127076 | 9896 | 0 | 117180 | 21.019 | -101.2574 | 2021-03-28 05:28:10 | Guanajuato, Mexico | ||
1239749 | 1239749 | 2022-11-28 | Mexico | Guanajuato | 352129 | 15104 | 0 | 21.019 | -101.2574 | 2022-11-29 04:21:05 | Guanajuato, Mexico | |||
1243840 | 1243840 | 2020-09-08 | Mexico | Guanajuato | 34441 | 2361 | 29181 | 2899 | 21.019 | -101.2574 | 2020-09-09 04:28:48 | Guanajuato, Mexico | ||
1250845 | 1250845 | 2022-08-23 | Mexico | Guanajuato | 347784 | 15040 | 0 | 21.019 | -101.2574 | 2022-08-24 04:20:46 | Guanajuato, Mexico | |||
1273396 | 1273396 | 2020-06-11 | Mexico | Guanajuato | 3053 | 171 | 1875 | 1007 | 21.019 | -101.2574 | 2020-06-12 05:09:52 | 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]);