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 = "Guerrero" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2701595 | 2701595 | 2020-11-20 | Mexico | Guerrero | 23112 | 2429 | 0 | 20683 | 17.4392 | -99.5451 | 2020-11-21 05:25:51 | Guerrero, Mexico | ||
821655 | 821655 | 2020-11-19 | Mexico | Guerrero | 23104 | 2421 | 0 | 20683 | 17.4392 | -99.5451 | 2020-11-20 05:26:28 | Guerrero, Mexico | ||
122789 | 122789 | 2020-11-18 | Mexico | Guerrero | 23094 | 2416 | 0 | 20678 | 17.4392 | -99.5451 | 2020-11-19 05:25:23 | Guerrero, Mexico | ||
3338677 | 3338677 | 2020-11-17 | Mexico | Guerrero | 23065 | 2408 | 0 | 20657 | 17.4392 | -99.5451 | 2020-11-18 05:40:31 | Guerrero, Mexico | ||
3169722 | 3169722 | 2020-11-16 | Mexico | Guerrero | 23030 | 2404 | 0 | 20626 | 17.4392 | -99.5451 | 2020-11-17 05:25:54 | Guerrero, Mexico | ||
2880290 | 2880290 | 2020-11-15 | Mexico | Guerrero | 22961 | 2393 | 0 | 20568 | 17.4392 | -99.5451 | 2020-11-16 05:25:57 | Guerrero, Mexico | ||
2915268 | 2915268 | 2020-11-14 | Mexico | Guerrero | 22911 | 2385 | 0 | 20526 | 17.4392 | -99.5451 | 2020-11-15 05:26:53 | Guerrero, Mexico | ||
2785090 | 2785090 | 2020-11-13 | Mexico | Guerrero | 22856 | 2370 | 0 | 20486 | 17.4392 | -99.5451 | 2020-11-14 05:25:37 | Guerrero, Mexico | ||
864855 | 864855 | 2020-11-12 | Mexico | Guerrero | 22800 | 2359 | 0 | 20441 | 17.4392 | -99.5451 | 2020-11-13 05:25:30 | Guerrero, Mexico | ||
3440900 | 3440900 | 2020-11-11 | Mexico | Guerrero | 22756 | 2345 | 20009 | 402 | 17.4392 | -99.5451 | 2020-11-12 05:25:55 | Guerrero, Mexico | ||
272240 | 272240 | 2020-11-10 | Mexico | Guerrero | 22719 | 2335 | 20009 | 375 | 17.4392 | -99.5451 | 2020-11-11 05:25:30 | Guerrero, Mexico | ||
1988717 | 1988717 | 2020-11-09 | Mexico | Guerrero | 22686 | 2318 | 20009 | 359 | 17.4392 | -99.5451 | 2020-11-10 05:40:07 | Guerrero, Mexico | ||
1728569 | 1728569 | 2020-11-08 | Mexico | Guerrero | 22598 | 2219 | 20009 | 370 | 17.4392 | -99.5451 | 2020-11-09 05:25:45 | Guerrero, Mexico | ||
1544029 | 1544029 | 2020-11-07 | Mexico | Guerrero | 22561 | 2218 | 19932 | 411 | 17.4392 | -99.5451 | 2020-11-08 05:24:56 | Guerrero, Mexico | ||
376267 | 376267 | 2020-11-06 | Mexico | Guerrero | 22484 | 2206 | 19874 | 404 | 17.4392 | -99.5451 | 2020-11-07 05:24:52 | Guerrero, Mexico | ||
892205 | 892205 | 2020-11-05 | Mexico | Guerrero | 22428 | 2203 | 19839 | 386 | 17.4392 | -99.5451 | 2020-11-06 05:24:55 | Guerrero, Mexico | ||
2919267 | 2919267 | 2020-11-04 | Mexico | Guerrero | 22356 | 2197 | 19796 | 363 | 17.4392 | -99.5451 | 2020-11-05 06:05:03 | Guerrero, Mexico | ||
2498104 | 2498104 | 2020-11-03 | Mexico | Guerrero | 22319 | 2193 | 19779 | 347 | 17.4392 | -99.5451 | 2020-11-04 05:25:09 | Guerrero, Mexico | ||
3304279 | 3304279 | 2020-11-02 | Mexico | Guerrero | 22277 | 2182 | 19681 | 414 | 17.4392 | -99.5451 | 2020-11-03 06:00:16 | Guerrero, Mexico | ||
3409528 | 3409528 | 2020-11-01 | Mexico | Guerrero | 22204 | 2176 | 19538 | 490 | 17.4392 | -99.5451 | 2020-11-02 05:25:04 | Guerrero, Mexico | ||
2080017 | 2080017 | 2020-10-31 | Mexico | Guerrero | 22163 | 2174 | 19475 | 514 | 17.4392 | -99.5451 | 2020-11-01 04:36:19 | Guerrero, Mexico | ||
2243470 | 2243470 | 2020-10-30 | Mexico | Guerrero | 22124 | 2164 | 19380 | 580 | 17.4392 | -99.5451 | 2020-10-31 04:24:44 | Guerrero, Mexico | ||
210325 | 210325 | 2020-10-29 | Mexico | Guerrero | 22069 | 2145 | 19351 | 573 | 17.4392 | -99.5451 | 2020-10-30 04:24:49 | Guerrero, Mexico | ||
754387 | 754387 | 2020-10-28 | Mexico | Guerrero | 22025 | 2142 | 19262 | 621 | 17.4392 | -99.5451 | 2020-10-29 04:24:49 | Guerrero, Mexico | ||
1452671 | 1452671 | 2020-10-27 | Mexico | Guerrero | 21960 | 2127 | 19288 | 545 | 17.4392 | -99.5451 | 2020-10-28 04:24:39 | Guerrero, Mexico | ||
3480395 | 3480395 | 2020-10-26 | Mexico | Guerrero | 21917 | 2122 | 19245 | 550 | 17.4392 | -99.5451 | 2020-10-27 04:24:45 | Guerrero, Mexico | ||
8416 | 8416 | 2020-10-25 | Mexico | Guerrero | 21839 | 2119 | 19106 | 614 | 17.4392 | -99.5451 | 2020-10-26 04:25:02 | Guerrero, Mexico | ||
3651653 | 3651653 | 2020-10-24 | Mexico | Guerrero | 21761 | 2116 | 18992 | 653 | 17.4392 | -99.5451 | 2020-10-25 04:24:36 | Guerrero, Mexico | ||
1053908 | 1053908 | 2020-10-23 | Mexico | Guerrero | 21667 | 2103 | 18864 | 700 | 17.4392 | -99.5451 | 2020-10-24 04:24:46 | Guerrero, Mexico | ||
1177578 | 1177578 | 2020-10-22 | Mexico | Guerrero | 21580 | 2096 | 18764 | 720 | 17.4392 | -99.5451 | 2020-10-23 04:24:46 | Guerrero, Mexico | ||
2191683 | 2191683 | 2020-10-21 | Mexico | Guerrero | 21404 | 2096 | 18644 | 664 | 17.4392 | -99.5451 | 2020-10-22 04:24:27 | Guerrero, Mexico | ||
3990694 | 3990694 | 2020-10-20 | Mexico | Guerrero | 21340 | 2085 | 18583 | 672 | 17.4392 | -99.5451 | 2020-10-21 04:24:14 | Guerrero, Mexico | ||
1794714 | 1794714 | 2020-10-19 | Mexico | Guerrero | 21277 | 2063 | 18556 | 658 | 17.4392 | -99.5451 | 2020-10-20 04:24:22 | Guerrero, Mexico | ||
762398 | 762398 | 2020-10-18 | Mexico | Guerrero | 21206 | 2063 | 18377 | 766 | 17.4392 | -99.5451 | 2020-10-19 04:24:16 | Guerrero, Mexico | ||
1026436 | 1026436 | 2020-10-17 | Mexico | Guerrero | 21146 | 2061 | 18256 | 829 | 17.4392 | -99.5451 | 2020-10-18 04:24:25 | Guerrero, Mexico | ||
2856931 | 2856931 | 2020-10-16 | Mexico | Guerrero | 21054 | 2046 | 18152 | 856 | 17.4392 | -99.5451 | 2020-10-17 04:24:12 | Guerrero, Mexico | ||
786461 | 786461 | 2020-10-15 | Mexico | Guerrero | 20922 | 2032 | 18037 | 853 | 17.4392 | -99.5451 | 2020-10-16 04:24:01 | Guerrero, Mexico | ||
79172 | 79172 | 2020-10-14 | Mexico | Guerrero | 20814 | 2027 | 17866 | 921 | 17.4392 | -99.5451 | 2020-10-15 04:24:28 | Guerrero, Mexico | ||
3781987 | 3781987 | 2020-10-13 | Mexico | Guerrero | 20694 | 2017 | 17789 | 888 | 17.4392 | -99.5451 | 2020-10-14 04:24:05 | Guerrero, Mexico | ||
2291527 | 2291527 | 2020-10-12 | Mexico | Guerrero | 20617 | 2001 | 17728 | 888 | 17.4392 | -99.5451 | 2020-10-13 04:24:02 | Guerrero, Mexico | ||
3785980 | 3785980 | 2020-10-11 | Mexico | Guerrero | 20499 | 1997 | 17469 | 1033 | 17.4392 | -99.5451 | 2020-10-12 04:23:45 | Guerrero, Mexico | ||
2602118 | 2602118 | 2020-10-10 | Mexico | Guerrero | 20417 | 1995 | 17316 | 1106 | 17.4392 | -99.5451 | 2020-10-11 04:23:46 | Guerrero, Mexico | ||
817651 | 817651 | 2020-10-09 | Mexico | Guerrero | 20295 | 1985 | 17237 | 1073 | 17.4392 | -99.5451 | 2020-10-10 04:23:57 | Guerrero, Mexico | ||
2689766 | 2689766 | 2020-10-08 | Mexico | Guerrero | 20198 | 1974 | 17116 | 1108 | 17.4392 | -99.5451 | 2020-10-09 04:23:59 | Guerrero, Mexico | ||
1041908 | 1041908 | 2020-10-07 | Mexico | Guerrero | 20076 | 1959 | 17047 | 1070 | 17.4392 | -99.5451 | 2020-10-08 04:23:56 | Guerrero, Mexico | ||
3117569 | 3117569 | 2020-10-06 | Mexico | Guerrero | 19935 | 1943 | 17051 | 941 | 17.4392 | -99.5451 | 2020-10-07 04:23:40 | Guerrero, Mexico | ||
3801981 | 3801981 | 2020-10-05 | Mexico | Guerrero | 19811 | 1939 | 16866 | 1006 | 17.4392 | -99.5451 | 2020-10-06 04:23:33 | Guerrero, Mexico | ||
1822871 | 1822871 | 2020-10-04 | Mexico | Guerrero | 19531 | 1916 | 16611 | 1004 | 17.4392 | -99.5451 | 2020-10-05 04:23:33 | Guerrero, Mexico | ||
2514255 | 2514255 | 2020-10-03 | Mexico | Guerrero | 19436 | 1906 | 16358 | 1172 | 17.4392 | -99.5451 | 2020-10-04 04:23:44 | Guerrero, Mexico | ||
3389473 | 3389473 | 2020-10-02 | Mexico | Guerrero | 19296 | 1899 | 16193 | 1204 | 17.4392 | -99.5451 | 2020-10-03 04:23:40 | Guerrero, Mexico | ||
2379714 | 2379714 | 2020-10-01 | Mexico | Guerrero | 19146 | 1896 | 16044 | 1206 | 17.4392 | -99.5451 | 2020-10-02 04:23:51 | Guerrero, Mexico | ||
1045900 | 1045900 | 2020-09-30 | Mexico | Guerrero | 19019 | 1886 | 16018 | 1115 | 17.4392 | -99.5451 | 2020-10-01 04:23:42 | Guerrero, Mexico | ||
966981 | 966981 | 2020-09-29 | Mexico | Guerrero | 18812 | 1881 | 15875 | 1056 | 17.4392 | -99.5451 | 2020-09-30 04:23:33 | Guerrero, Mexico | ||
1515478 | 1515478 | 2020-09-28 | Mexico | Guerrero | 18655 | 1869 | 15717 | 1069 | 17.4392 | -99.5451 | 2020-09-29 04:23:42 | Guerrero, Mexico | ||
2582066 | 2582066 | 2020-09-27 | Mexico | Guerrero | 18510 | 1863 | 15471 | 1176 | 17.4392 | -99.5451 | 2020-09-28 04:23:00 | Guerrero, Mexico | ||
2614118 | 2614118 | 2020-09-26 | Mexico | Guerrero | 18400 | 1859 | 15283 | 1258 | 17.4392 | -99.5451 | 2020-09-27 04:23:00 | Guerrero, Mexico | ||
2812833 | 2812833 | 2020-09-25 | Mexico | Guerrero | 18180 | 1848 | 15173 | 1159 | 17.4392 | -99.5451 | 2020-09-26 04:23:00 | Guerrero, Mexico | ||
2606110 | 2606110 | 2020-09-24 | Mexico | Guerrero | 18031 | 1840 | 15141 | 1050 | 17.4392 | -99.5451 | 2020-09-25 04:23:00 | Guerrero, Mexico | ||
2653853 | 2653853 | 2020-09-23 | Mexico | Guerrero | 17822 | 1834 | 14936 | 1052 | 17.4392 | -99.5451 | 2020-09-24 04:23:00 | Guerrero, Mexico | ||
3316302 | 3316302 | 2020-09-22 | Mexico | Guerrero | 17659 | 1824 | 14829 | 1006 | 17.4392 | -99.5451 | 2020-09-23 04:23:00 | Guerrero, Mexico | ||
2836901 | 2836901 | 2020-09-21 | Mexico | Guerrero | 17545 | 1819 | 14737 | 989 | 17.4392 | -99.5451 | 2020-09-22 04:23:00 | Guerrero, Mexico | ||
3093505 | 3093505 | 2020-09-20 | Mexico | Guerrero | 17367 | 1814 | 14391 | 1162 | 17.4392 | -99.5451 | 2020-09-21 04:23:00 | Guerrero, Mexico | ||
2454855 | 2454855 | 2020-09-19 | Mexico | Guerrero | 17335 | 1811 | 14318 | 1206 | 17.4392 | -99.5451 | 2020-09-20 04:22:00 | Guerrero, Mexico | ||
2848924 | 2848924 | 2020-09-18 | Mexico | Guerrero | 17182 | 1803 | 14243 | 1136 | 17.4392 | -99.5451 | 2020-09-19 04:22:00 | Guerrero, Mexico | ||
1121673 | 1121673 | 2020-09-17 | Mexico | Guerrero | 17035 | 1792 | 14211 | 1032 | 17.4392 | -99.5451 | 2020-09-18 05:05:00 | Guerrero, Mexico | ||
666362 | 666362 | 2020-09-16 | Mexico | Guerrero | 16854 | 1789 | 13980 | 1085 | 17.4392 | -99.5451 | 2020-09-17 04:22:00 | Guerrero, Mexico | ||
2729087 | 2729087 | 2020-09-15 | Mexico | Guerrero | 16734 | 1779 | 13798 | 1157 | 17.4392 | -99.5451 | 2020-09-16 04:22:53 | Guerrero, Mexico | ||
344359 | 344359 | 2020-09-14 | Mexico | Guerrero | 16600 | 1764 | 13641 | 1195 | 17.4392 | -99.5451 | 2020-09-15 03:22:50 | Guerrero, Mexico | ||
2868798 | 2868798 | 2020-09-13 | Mexico | Guerrero | 16454 | 1763 | 13422 | 1269 | 17.4392 | -99.5451 | 2020-09-14 04:26:00 | Guerrero, Mexico | ||
546837 | 546837 | 2020-09-12 | Mexico | Guerrero | 16354 | 1760 | 13236 | 1358 | 17.4392 | -99.5451 | 2020-09-13 04:30:52 | Guerrero, Mexico | ||
1444666 | 1444666 | 2020-09-11 | Mexico | Guerrero | 16252 | 1752 | 13235 | 1265 | 17.4392 | -99.5451 | 2020-09-12 04:25:05 | Guerrero, Mexico | ||
1173267 | 1173267 | 2020-09-10 | Mexico | Guerrero | 16143 | 1749 | 13124 | 1270 | 17.4392 | -99.5451 | 2020-09-11 04:46:23 | Guerrero, Mexico | ||
2171632 | 2171632 | 2020-09-09 | Mexico | Guerrero | 15833 | 1706 | 13147 | 980 | 17.4392 | -99.5451 | 2020-09-10 04:29:01 | Guerrero, Mexico | ||
1243841 | 1243841 | 2020-09-08 | Mexico | Guerrero | 15833 | 1706 | 13147 | 980 | 17.4392 | -99.5451 | 2020-09-09 04:28:48 | Guerrero, Mexico | ||
427420 | 427420 | 2020-09-07 | Mexico | Guerrero | 15682 | 1700 | 13112 | 870 | 17.4392 | -99.5451 | 2020-09-08 04:28:25 | Guerrero, Mexico | ||
3161705 | 3161705 | 2020-09-06 | Mexico | Guerrero | 15548 | 1696 | 12898 | 954 | 17.4392 | -99.5451 | 2020-09-07 04:28:30 | Guerrero, Mexico | ||
813660 | 813660 | 2020-09-05 | Mexico | Guerrero | 15404 | 1687 | 12767 | 950 | 17.4392 | -99.5451 | 2020-09-06 04:28:33 | Guerrero, Mexico | ||
2661860 | 2661860 | 2020-09-04 | Mexico | Guerrero | 15263 | 1685 | 12734 | 844 | 17.4392 | -99.5451 | 2020-09-05 04:28:19 | Guerrero, Mexico | ||
1354400 | 1354400 | 2020-09-03 | Mexico | Guerrero | 15163 | 1681 | 12647 | 835 | 17.4392 | -99.5451 | 2020-09-04 04:28:26 | Guerrero, Mexico | ||
1105637 | 1105637 | 2020-09-02 | Mexico | Guerrero | 15033 | 1676 | 12513 | 844 | 17.4392 | -99.5451 | 2020-09-03 04:28:22 | Guerrero, Mexico | ||
2059966 | 2059966 | 2020-09-01 | Mexico | Guerrero | 14893 | 1670 | 12455 | 768 | 17.4392 | -99.5451 | 2020-09-02 04:28:25 | Guerrero, Mexico | ||
194151 | 194151 | 2020-08-31 | Mexico | Guerrero | 14793 | 1658 | 12373 | 762 | 17.4392 | -99.5451 | 2020-09-01 04:28:31 | Guerrero, Mexico | ||
3932110 | 3932110 | 2020-08-30 | Mexico | Guerrero | 14710 | 1654 | 12255 | 801 | 17.4392 | -99.5451 | 2020-08-31 04:28:27 | Guerrero, Mexico | ||
609772 | 609772 | 2020-08-29 | Mexico | Guerrero | 14654 | 1652 | 12125 | 877 | 17.4392 | -99.5451 | 2020-08-30 04:28:22 | Guerrero, Mexico | ||
1523267 | 1523267 | 2020-08-28 | Mexico | Guerrero | 14566 | 1636 | 11989 | 941 | 17.4392 | -99.5451 | 2020-08-29 04:28:19 | Guerrero, Mexico | ||
2510268 | 2510268 | 2020-08-27 | Mexico | Guerrero | 14432 | 1621 | 11955 | 856 | 17.4392 | -99.5451 | 2020-08-28 04:28:11 | Guerrero, Mexico | ||
1996728 | 1996728 | 2020-08-26 | Mexico | Guerrero | 14337 | 1614 | 11885 | 838 | 17.4392 | -99.5451 | 2020-08-27 04:28:15 | Guerrero, Mexico | ||
3562652 | 3562652 | 2020-08-25 | Mexico | Guerrero | 14273 | 1607 | 11880 | 786 | 17.4392 | -99.5451 | 2020-08-26 04:28:11 | Guerrero, Mexico | ||
2991356 | 2991356 | 2020-08-24 | Mexico | Guerrero | 14198 | 1597 | 11844 | 757 | 17.4392 | -99.5451 | 2020-08-25 04:28:02 | Guerrero, Mexico | ||
2215751 | 2215751 | 2020-08-23 | Mexico | Guerrero | 14116 | 1596 | 11683 | 837 | 17.4392 | -99.5451 | 2020-08-24 04:27:56 | Guerrero, Mexico | ||
2299533 | 2299533 | 2020-08-22 | Mexico | Guerrero | 14054 | 1592 | 11572 | 890 | 17.4392 | -99.5451 | 2020-08-23 04:27:48 | Guerrero, Mexico | ||
1479640 | 1479640 | 2020-08-21 | Mexico | Guerrero | 13880 | 1579 | 11378 | 923 | 17.4392 | -99.5451 | 2020-08-22 04:27:49 | Guerrero, Mexico | ||
3484389 | 3484389 | 2020-08-20 | Mexico | Guerrero | 13752 | 1572 | 11284 | 896 | 17.4392 | -99.5451 | 2020-08-21 04:27:41 | Guerrero, Mexico | ||
206338 | 206338 | 2020-08-19 | Mexico | Guerrero | 13659 | 1559 | 11256 | 844 | 17.4392 | -99.5451 | 2020-08-20 04:27:43 | Guerrero, Mexico | ||
3178092 | 3178092 | 2020-08-18 | Mexico | Guerrero | 13528 | 1540 | 11143 | 845 | 17.4392 | -99.5451 | 2020-08-19 04:27:00 | Guerrero, Mexico | ||
837696 | 837696 | 2020-08-17 | Mexico | Guerrero | 13440 | 1522 | 11056 | 862 | 17.4392 | -99.5451 | 2020-08-18 04:27:56 | Guerrero, Mexico | ||
1556054 | 1556054 | 2020-08-16 | Mexico | Guerrero | 13254 | 1516 | 10827 | 911 | 17.4392 | -99.5451 | 2020-08-17 04:27:20 | Guerrero, Mexico | ||
146056 | 146056 | 2020-08-15 | Mexico | Guerrero | 13141 | 1511 | 10563 | 1067 | 17.4392 | -99.5451 | 2020-08-16 04:27:42 | Guerrero, Mexico | ||
1612331 | 1612331 | 2020-08-14 | Mexico | Guerrero | 13025 | 1503 | 10397 | 1125 | 17.4392 | -99.5451 | 2020-08-15 04:27:31 | Guerrero, Mexico | ||
582915 | 582915 | 2020-08-13 | Mexico | Guerrero | 12883 | 1492 | 10283 | 1108 | 17.4392 | -99.5451 | 2020-08-14 04:51:19 | Guerrero, 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]);