johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
31,389 rows where country_or_region = "Mexico" sorted by active descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date)
province_or_state >30
- Aguascalientes 954
- Baja California 954
- Baja California Sur 954
- Campeche 954
- Chiapas 954
- Chihuahua 954
- Ciudad de Mexico 954
- Coahuila 954
- Colima 954
- Durango 954
- Guanajuato 954
- Guerrero 954
- Hidalgo 954
- Jalisco 954
- Mexico 954
- Michoacan 954
- Morelos 954
- Nayarit 954
- Nuevo Leon 954
- Oaxaca 954
- Puebla 954
- Queretaro 954
- Quintana Roo 954
- San Luis Potosi 954
- Sinaloa 954
- Sonora 954
- Tabasco 954
- Tamaulipas 954
- Tlaxcala 954
- Veracruz 954
- …
last_update (date) >30 ✖
- 2022-04-13 66
- 2022-05-26 66
- 2020-11-13 33
- 2020-11-14 33
- 2020-11-15 33
- 2020-11-16 33
- 2020-11-17 33
- 2020-11-18 33
- 2020-11-19 33
- 2020-11-20 33
- 2020-11-21 33
- 2020-11-22 33
- 2020-11-23 33
- 2020-11-24 33
- 2020-11-25 33
- 2020-11-26 33
- 2020-11-27 33
- 2020-11-28 33
- 2020-11-29 33
- 2020-11-30 33
- 2020-12-01 33
- 2020-12-02 33
- 2020-12-03 33
- 2020-12-04 33
- 2020-12-05 33
- 2020-12-06 33
- 2020-12-07 33
- 2020-12-08 33
- 2020-12-09 33
- 2020-12-10 33
- …
country_or_region 1
- Mexico · 31,389 ✖
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active ▲ | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
954947 | 954947 | 2021-04-25 | Mexico | Colima | 11168 | 1172 | 0 | 9996 | 19.1223 | -104.0072 | 2021-04-26 04:21:04 | Colima, Mexico | ||
3924094 | 3924094 | 2021-04-24 | Mexico | Colima | 11162 | 1171 | 0 | 9991 | 19.1223 | -104.0072 | 2021-04-25 04:20:32 | Colima, Mexico | ||
762416 | 762416 | 2020-10-18 | Mexico | Veracruz | 35818 | 4638 | 30181 | 999 | 19.1738 | -96.1342 | 2020-10-19 04:24:16 | Veracruz, Mexico | ||
2863839 | 2863839 | 2020-06-10 | Mexico | Guanajuato | 2936 | 159 | 1778 | 999 | 21.019000000000002 | -101.2574 | 2020-06-11 03:33:41 | Guanajuato, Mexico | ||
380284 | 380284 | 2021-04-30 | Mexico | Nayarit | 11782 | 1793 | 0 | 9989 | 21.7514 | -104.8455 | 2021-05-01 04:20:47 | Nayarit, Mexico | ||
2586067 | 2586067 | 2021-06-05 | Mexico | Chiapas | 11636 | 1647 | 0 | 9989 | 16.7569 | -93.1292 | 2021-06-06 04:24:03 | Chiapas, Mexico | ||
217365 | 217365 | 2020-06-08 | Mexico | Tabasco | 5667 | 665 | 4004 | 998 | 17.8409 | -92.6189 | 2020-06-09 03:33:03 | Tabasco, Mexico | ||
2379723 | 2379723 | 2020-10-01 | Mexico | Puebla | 31380 | 4097 | 26285 | 998 | 19.0414 | -98.2063 | 2020-10-02 04:23:51 | Puebla, Mexico | ||
1636407 | 1636407 | 2021-04-29 | Mexico | Nayarit | 11761 | 1783 | 0 | 9978 | 21.7514 | -104.8455 | 2021-04-30 04:21:03 | Nayarit, Mexico | ||
2211751 | 2211751 | 2021-01-30 | Mexico | Guanajuato | 107064 | 7317 | 0 | 99747 | 21.019 | -101.2574 | 2021-01-31 05:22:42 | Guanajuato, Mexico | ||
1409125 | 1409125 | 2021-04-23 | Mexico | Colima | 11142 | 1171 | 0 | 9971 | 19.1223 | -104.0072 | 2021-04-24 04:20:38 | Colima, Mexico | ||
1510794 | 1510794 | 2020-06-22 | Mexico | Tamaulipas | 4348 | 278 | 3073 | 997 | 24.2669 | -98.8363 | 2020-06-23 04:33:22 | Tamaulipas, Mexico | ||
2700673 | 2700673 | 2020-06-24 | Mexico | Jalisco | 5715 | 528 | 4190 | 997 | 20.6595 | -103.3494 | 2020-06-25 05:26:54 | Jalisco, Mexico | ||
2740327 | 2740327 | 2020-08-03 | Mexico | Quintana Roo | 8026 | 1018 | 6011 | 997 | 19.1817 | -88.4791 | 2020-08-04 04:41:59 | Quintana Roo, Mexico | ||
2211759 | 2211759 | 2021-01-30 | Mexico | Nuevo Leon | 106333 | 6724 | 0 | 99609 | 25.5922 | -99.9962 | 2021-01-31 05:22:42 | Nuevo Leon, Mexico | ||
1568188 | 1568188 | 2021-04-22 | Mexico | Colima | 11130 | 1170 | 0 | 9960 | 19.1223 | -104.0072 | 2021-04-23 04:20:52 | Colima, Mexico | ||
1996743 | 1996743 | 2020-08-26 | Mexico | Tabasco | 27448 | 2506 | 23946 | 996 | 17.8409 | -92.6189 | 2020-08-27 04:28:15 | Tabasco, Mexico | ||
3785992 | 3785992 | 2020-10-11 | Mexico | San Luis Potosi | 24660 | 1790 | 21874 | 996 | 22.1565 | -100.9855 | 2020-10-12 04:23:45 | San Luis Potosi, Mexico | ||
3393486 | 3393486 | 2021-04-28 | Mexico | Nayarit | 11735 | 1781 | 0 | 9954 | 21.7514 | -104.8455 | 2021-04-29 04:20:55 | Nayarit, Mexico | ||
2315381 | 2315381 | 2021-06-04 | Mexico | Chiapas | 11598 | 1647 | 0 | 9951 | 16.7569 | -93.1292 | 2021-06-05 04:23:03 | Chiapas, Mexico | ||
582916 | 582916 | 2020-08-13 | Mexico | Hidalgo | 8307 | 1285 | 6027 | 995 | 20.0911 | -98.7624 | 2020-08-14 04:51:19 | Hidalgo, Mexico | ||
1479654 | 1479654 | 2020-08-21 | Mexico | Sonora | 20537 | 2478 | 17064 | 995 | 29.2972 | -110.3309 | 2020-08-22 04:27:49 | Sonora, Mexico | ||
1612332 | 1612332 | 2020-08-14 | Mexico | Hidalgo | 8417 | 1315 | 6107 | 995 | 20.0911 | -98.7624 | 2020-08-15 04:27:31 | Hidalgo, Mexico | ||
1750849 | 1750849 | 2020-04-04 | Mexico | 1688 | 60 | 633 | 995 | 23.6345 | -102.5528 | 4/4/20 23:34 | Mexico | |||
2685004 | 2685004 | 2020-07-06 | Mexico | Puebla | 12250 | 1516 | 9739 | 995 | 19.0414 | -98.2063 | 2020-07-07 04:34:00 | Puebla, Mexico | ||
3249533 | 3249533 | 2020-06-21 | Mexico | Tamaulipas | 4114 | 275 | 2844 | 995 | 24.2669 | -98.8363 | 2020-06-22 04:33:20 | Tamaulipas, Mexico | ||
2422968 | 2422968 | 2021-06-23 | Mexico | Campeche | 11226 | 1279 | 0 | 9947 | 19.8301 | -90.5349 | 2021-06-24 04:21:55 | Campeche, Mexico | ||
3859919 | 3859919 | 2020-12-04 | Mexico | Mexico | 115499 | 16035 | 0 | 99464 | 19.4969 | -99.7233 | 2020-12-05 05:27:36 | Mexico, Mexico | ||
2227622 | 2227622 | 2021-01-02 | Mexico | Tlaxcala | 11366 | 1424 | 0 | 9942 | 19.3139 | -98.2404 | 2021-01-03 05:22:52 | Tlaxcala, Mexico | ||
3242409 | 3242409 | 2021-04-21 | Mexico | Colima | 11111 | 1170 | 0 | 9941 | 19.1223 | -104.0072 | 2021-04-22 04:20:53 | Colima, Mexico | ||
2039896 | 2039896 | 2020-06-27 | Mexico | Nuevo Leon | 4943 | 298 | 3651 | 994 | 25.5922 | -99.9962 | 2020-06-28 04:34:04 | Nuevo Leon, Mexico | ||
3389489 | 3389489 | 2020-10-02 | Mexico | Tamaulipas | 29201 | 2281 | 25926 | 994 | 24.2669 | -98.8363 | 2020-10-03 04:23:40 | Tamaulipas, Mexico | ||
1448666 | 1448666 | 2021-06-03 | Mexico | Chiapas | 11582 | 1644 | 0 | 9938 | 16.7569 | -93.1292 | 2021-06-04 04:23:37 | Chiapas, Mexico | ||
3702202 | 3702202 | 2021-04-27 | Mexico | Nayarit | 11718 | 1780 | 0 | 9938 | 21.7514 | -104.8455 | 2021-04-28 04:20:32 | Nayarit, Mexico | ||
1136986 | 1136986 | 2021-01-01 | Mexico | Tlaxcala | 11351 | 1420 | 0 | 9931 | 19.3139 | -98.2404 | 2021-01-02 05:22:33 | Tlaxcala, Mexico | ||
2020805 | 2020805 | 2021-04-20 | Mexico | Colima | 11099 | 1168 | 0 | 9931 | 19.1223 | -104.0072 | 2021-04-21 04:21:14 | Colima, Mexico | ||
458490 | 458490 | 2020-08-07 | Mexico | Hidalgo | 7618 | 1177 | 5448 | 993 | 20.0911 | -98.7624 | 2020-08-08 04:34:53 | Hidalgo, Mexico | ||
574217 | 574217 | 2020-06-06 | Mexico | Tabasco | 5293 | 640 | 3660 | 993 | 17.8409 | -92.6189 | 2020-06-07 03:53:30 | Tabasco, Mexico | ||
1920597 | 1920597 | 2020-08-10 | Mexico | Tamaulipas | 18085 | 1341 | 15751 | 993 | 24.2669 | -98.8363 | 2020-08-11 04:35:08 | Tamaulipas, Mexico | ||
2614127 | 2614127 | 2020-09-26 | Mexico | Puebla | 30808 | 4008 | 25807 | 993 | 19.0414 | -98.2063 | 2020-09-27 04:23:00 | Puebla, Mexico | ||
888211 | 888211 | 2021-04-26 | Mexico | Nayarit | 11707 | 1780 | 0 | 9927 | 21.7514 | -104.8455 | 2021-04-27 04:20:52 | Nayarit, Mexico | ||
954956 | 954956 | 2021-04-25 | Mexico | Nayarit | 11701 | 1779 | 0 | 9922 | 21.7514 | -104.8455 | 2021-04-26 04:21:04 | Nayarit, Mexico | ||
2306561 | 2306561 | 2020-06-28 | Mexico | Nuevo Leon | 5090 | 298 | 3800 | 992 | 25.5922 | -99.9962 | 2020-06-29 04:33:44 | Nuevo Leon, Mexico | ||
3682906 | 3682906 | 2020-06-18 | Mexico | Veracruz | 7400 | 1160 | 5248 | 992 | 19.1738 | -96.1342 | 2020-06-19 04:33:17 | Veracruz, Mexico | ||
1897238 | 1897238 | 2021-01-29 | Mexico | Guanajuato | 106371 | 7185 | 0 | 99186 | 21.019 | -101.2574 | 2021-01-30 05:22:49 | Guanajuato, Mexico | ||
2410926 | 2410926 | 2021-04-19 | Mexico | Colima | 11080 | 1165 | 0 | 9915 | 19.1223 | -104.0072 | 2021-04-20 04:20:41 | Colima, Mexico | ||
3924103 | 3924103 | 2021-04-24 | Mexico | Nayarit | 11693 | 1779 | 0 | 9914 | 21.7514 | -104.8455 | 2021-04-25 04:20:32 | Nayarit, Mexico | ||
1708390 | 1708390 | 2021-06-02 | Mexico | Chiapas | 11554 | 1643 | 0 | 9911 | 16.7569 | -93.1292 | 2021-06-03 04:23:32 | Chiapas, Mexico | ||
376281 | 376281 | 2020-11-06 | Mexico | Sonora | 38999 | 3211 | 34797 | 991 | 29.2972 | -110.3309 | 2020-11-07 05:24:52 | Sonora, Mexico | ||
2602128 | 2602128 | 2020-10-10 | Mexico | Queretaro | 10208 | 1064 | 8153 | 991 | 20.5888 | -100.3899 | 2020-10-11 04:23:46 | Queretaro, Mexico | ||
3129603 | 3129603 | 2021-04-18 | Mexico | Colima | 11072 | 1163 | 0 | 9909 | 19.1223 | -104.0072 | 2021-04-19 04:20:57 | Colima, Mexico | ||
983031 | 983031 | 2021-04-17 | Mexico | Colima | 11065 | 1163 | 0 | 9902 | 19.1223 | -104.0072 | 2021-04-18 04:20:41 | Colima, Mexico | ||
3801999 | 3801999 | 2020-10-05 | Mexico | Veracruz | 34233 | 4417 | 28826 | 990 | 19.1738 | -96.1342 | 2020-10-06 04:23:33 | Veracruz, Mexico | ||
546829 | 546829 | 2020-09-12 | Mexico | Campeche | 5772 | 788 | 4885 | 99 | 19.8301 | -90.5349 | 2020-09-13 04:30:52 | Campeche, Mexico | ||
1793821 | 1793821 | 2020-05-31 | Mexico | Baja California Sur | 631 | 35 | 497 | 99 | 26.0444 | -111.6661 | 2020-06-01 02:32:46 | Baja California Sur, Mexico | ||
1897246 | 1897246 | 2021-01-29 | Mexico | Nuevo Leon | 105584 | 6643 | 0 | 98941 | 25.5922 | -99.9962 | 2021-01-30 05:22:49 | Nuevo Leon, Mexico | ||
1409134 | 1409134 | 2021-04-23 | Mexico | Nayarit | 11670 | 1777 | 0 | 9893 | 21.7514 | -104.8455 | 2021-04-24 04:20:38 | Nayarit, Mexico | ||
2935320 | 2935320 | 2020-11-28 | Mexico | Mexico | 110779 | 11867 | 0 | 98912 | 19.4969 | -99.7233 | 2020-11-29 05:25:55 | Mexico, Mexico | ||
2104208 | 2104208 | 2021-06-01 | Mexico | Chiapas | 11533 | 1643 | 0 | 9890 | 16.7569 | -93.1292 | 2021-06-02 04:24:34 | Chiapas, Mexico | ||
344368 | 344368 | 2020-09-14 | Mexico | Puebla | 29259 | 3824 | 24446 | 989 | 19.0414 | -98.2063 | 2020-09-15 03:22:50 | Puebla, Mexico | ||
2836901 | 2836901 | 2020-09-21 | Mexico | Guerrero | 17545 | 1819 | 14737 | 989 | 17.4392 | -99.5451 | 2020-09-22 04:23:00 | Guerrero, Mexico | ||
170126 | 170126 | 2021-04-16 | Mexico | Colima | 11046 | 1163 | 0 | 9883 | 19.1223 | -104.0072 | 2021-04-17 04:20:40 | Colima, Mexico | ||
2625164 | 2625164 | 2020-06-25 | Mexico | Nuevo Leon | 4580 | 277 | 3315 | 988 | 25.5922 | -99.9962 | 2020-06-26 04:33:43 | Nuevo Leon, Mexico | ||
1568197 | 1568197 | 2021-04-22 | Mexico | Nayarit | 11651 | 1774 | 0 | 9877 | 21.7514 | -104.8455 | 2021-04-23 04:20:52 | Nayarit, Mexico | ||
2191678 | 2191678 | 2020-10-21 | Mexico | Ciudad de Mexico | 150456 | 14554 | 126028 | 9874 | 19.4326 | -99.1332 | 2020-10-22 04:24:27 | Ciudad de Mexico, Mexico | ||
3242418 | 3242418 | 2021-04-21 | Mexico | Nayarit | 11646 | 1774 | 0 | 9872 | 21.7514 | -104.8455 | 2021-04-22 04:20:53 | Nayarit, Mexico | ||
2555977 | 2555977 | 2020-06-02 | Mexico | Tabasco | 4609 | 562 | 3060 | 987 | 17.8409 | -92.6189 | 2020-06-03 02:33:13 | Tabasco, Mexico | ||
3923395 | 3923395 | 2020-08-09 | Mexico | Sonora | 19040 | 2295 | 15758 | 987 | 29.2972 | -110.3309 | 2020-08-10 04:34:55 | Sonora, Mexico | ||
2548957 | 2548957 | 2021-04-15 | Mexico | Colima | 11027 | 1162 | 0 | 9865 | 19.1223 | -104.0072 | 2021-04-16 04:20:46 | Colima, Mexico | ||
563045 | 563045 | 2021-06-22 | Mexico | Campeche | 11137 | 1274 | 0 | 9863 | 19.8301 | -90.5349 | 2021-06-23 04:21:46 | Campeche, Mexico | ||
376279 | 376279 | 2020-11-06 | Mexico | San Luis Potosi | 29835 | 2140 | 26709 | 986 | 22.1565 | -100.9855 | 2020-11-07 05:24:52 | San Luis Potosi, Mexico | ||
2729099 | 2729099 | 2020-09-15 | Mexico | San Luis Potosi | 21022 | 1444 | 18592 | 986 | 22.1565 | -100.9855 | 2020-09-16 04:22:53 | San Luis Potosi, Mexico | ||
3117587 | 3117587 | 2020-10-06 | Mexico | Veracruz | 34422 | 4432 | 29004 | 986 | 19.1738 | -96.1342 | 2020-10-07 04:23:40 | Veracruz, Mexico | ||
1188824 | 1188824 | 2021-05-31 | Mexico | Chiapas | 11432 | 1573 | 0 | 9859 | 16.7569 | -93.1292 | 2021-06-01 04:23:09 | Chiapas, Mexico | ||
75177 | 75177 | 2020-12-03 | Mexico | Mexico | 114492 | 15961 | 0 | 98531 | 19.4969 | -99.7233 | 2020-12-04 05:27:27 | Mexico, Mexico | ||
3089501 | 3089501 | 2021-05-30 | Mexico | Chiapas | 11426 | 1573 | 0 | 9853 | 16.7569 | -93.1292 | 2021-05-31 03:08:59 | Chiapas, Mexico | ||
2020814 | 2020814 | 2021-04-20 | Mexico | Nayarit | 11622 | 1771 | 0 | 9851 | 21.7514 | -104.8455 | 2021-04-21 04:21:14 | Nayarit, Mexico | ||
1842027 | 1842027 | 2021-04-14 | Mexico | Colima | 11007 | 1162 | 0 | 9845 | 19.1223 | -104.0072 | 2021-04-15 04:20:54 | Colima, Mexico | ||
2482054 | 2482054 | 2021-01-28 | Mexico | Guanajuato | 105498 | 7055 | 0 | 98443 | 21.019 | -101.2574 | 2021-01-29 05:22:23 | Guanajuato, Mexico | ||
50870 | 50870 | 2021-05-29 | Mexico | Chiapas | 11413 | 1573 | 0 | 9840 | 16.7569 | -93.1292 | 2021-05-30 04:20:55 | Chiapas, Mexico | ||
98116 | 98116 | 2020-08-04 | Mexico | Baja California Sur | 4745 | 192 | 3569 | 984 | 26.0444 | -111.6661 | 2020-08-05 04:34:43 | Baja California Sur, Mexico | ||
272248 | 272248 | 2020-11-10 | Mexico | Oaxaca | 22308 | 1774 | 19550 | 984 | 17.0732 | -96.7266 | 2020-11-11 05:25:30 | Oaxaca, Mexico | ||
3785984 | 3785984 | 2020-10-11 | Mexico | Michoacan | 22194 | 1753 | 19457 | 984 | 19.5665 | -101.7068 | 2020-10-12 04:23:45 | Michoacan, Mexico | ||
190159 | 190159 | 2021-01-11 | Mexico | Morelos | 11341 | 1502 | 0 | 9839 | 18.6813 | -99.1013 | 2021-01-12 05:22:15 | Morelos, Mexico | ||
2410935 | 2410935 | 2021-04-19 | Mexico | Nayarit | 11601 | 1769 | 0 | 9832 | 21.7514 | -104.8455 | 2021-04-20 04:20:41 | Nayarit, Mexico | ||
3358747 | 3358747 | 2021-06-21 | Mexico | Campeche | 11099 | 1267 | 0 | 9832 | 19.8301 | -90.5349 | 2021-06-22 04:21:34 | Campeche, Mexico | ||
2514264 | 2514264 | 2020-10-03 | Mexico | Puebla | 31574 | 4128 | 26463 | 983 | 19.0414 | -98.2063 | 2020-10-04 04:23:44 | Puebla, Mexico | ||
2625033 | 2625033 | 2020-06-25 | Mexico | Jalisco | 5875 | 563 | 4329 | 983 | 20.6595 | -103.3494 | 2020-06-26 04:33:43 | Jalisco, Mexico | ||
392323 | 392323 | 2020-11-27 | Mexico | Mexico | 110093 | 11823 | 0 | 98270 | 19.4969 | -99.7233 | 2020-11-28 05:25:50 | Mexico, Mexico | ||
20449 | 20449 | 2021-05-28 | Mexico | Chiapas | 11399 | 1572 | 0 | 9827 | 16.7569 | -93.1292 | 2021-05-29 04:20:41 | Chiapas, Mexico | ||
2571761 | 2571761 | 2021-04-13 | Mexico | Colima | 10983 | 1160 | 0 | 9823 | 19.1223 | -104.0072 | 2021-04-14 04:20:41 | Colima, Mexico | ||
3129612 | 3129612 | 2021-04-18 | Mexico | Nayarit | 11590 | 1769 | 0 | 9821 | 21.7514 | -104.8455 | 2021-04-19 04:20:57 | Nayarit, Mexico | ||
1354391 | 1354391 | 2020-09-03 | Mexico | Baja California Sur | 8000 | 368 | 6650 | 982 | 26.0444 | -111.6661 | 2020-09-04 04:28:26 | Baja California Sur, Mexico | ||
1822889 | 1822889 | 2020-10-04 | Mexico | Veracruz | 33809 | 4358 | 28469 | 982 | 19.1738 | -96.1342 | 2020-10-05 04:23:33 | Veracruz, Mexico | ||
2582082 | 2582082 | 2020-09-27 | Mexico | Tamaulipas | 28642 | 2206 | 25454 | 982 | 24.2669 | -98.8363 | 2020-09-28 04:23:00 | Tamaulipas, Mexico | ||
983040 | 983040 | 2021-04-17 | Mexico | Nayarit | 11587 | 1768 | 0 | 9819 | 21.7514 | -104.8455 | 2021-04-18 04:20:41 | Nayarit, Mexico | ||
2625962 | 2625962 | 2021-01-10 | Mexico | Morelos | 11319 | 1501 | 0 | 9818 | 18.6813 | -99.1013 | 2021-01-11 05:21:50 | Morelos, Mexico | ||
2884446 | 2884446 | 2021-06-20 | Mexico | Campeche | 11081 | 1265 | 0 | 9816 | 19.8301 | -90.5349 | 2021-06-21 04:21:41 | Campeche, Mexico | ||
3276428 | 3276428 | 2020-05-15 | Mexico | 45032 | 4767 | 30451 | 9814 | 23.6345 | -102.5528 | 2020-05-16 02:32:19 | Mexico | |||
2482062 | 2482062 | 2021-01-28 | Mexico | Nuevo Leon | 104668 | 6544 | 0 | 98124 | 25.5922 | -99.9962 | 2021-01-29 05:22:23 | Nuevo Leon, 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]);