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 day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state >30
- Baja California Sur 948
- Campeche 948
- Chiapas 948
- Chihuahua 948
- Ciudad de Mexico 948
- Coahuila 948
- Colima 948
- Durango 948
- Guanajuato 948
- Guerrero 948
- Hidalgo 948
- Jalisco 948
- Mexico 948
- Michoacan 948
- Morelos 948
- Nayarit 948
- Nuevo Leon 948
- Oaxaca 948
- Puebla 948
- Queretaro 948
- Quintana Roo 948
- San Luis Potosi 948
- Sinaloa 948
- Sonora 948
- Tabasco 948
- Tamaulipas 948
- Tlaxcala 948
- Veracruz 948
- Yucatan 948
- Zacatecas 948
- …
country_or_region 1
- Mexico · 31,189 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
690453 | 690453 | 2022-12-23 | Mexico | Baja California Sur | 125808 | 2768 | 0 | 26.0444 | -111.6661 | 2022-12-24 04:21:02 | Baja California Sur, Mexico | |||
690454 | 690454 | 2022-12-23 | Mexico | Campeche | 43799 | 2286 | 0 | 19.8301 | -90.5349 | 2022-12-24 04:21:02 | Campeche, Mexico | |||
690455 | 690455 | 2022-12-23 | Mexico | Chiapas | 53817 | 2437 | 0 | 16.7569 | -93.1292 | 2022-12-24 04:21:02 | Chiapas, Mexico | |||
690456 | 690456 | 2022-12-23 | Mexico | Chihuahua | 169518 | 10169 | 0 | 28.633 | -106.0691 | 2022-12-24 04:21:02 | Chihuahua, Mexico | |||
690457 | 690457 | 2022-12-23 | Mexico | Ciudad de Mexico | 1774057 | 43665 | 0 | 19.4326 | -99.1332 | 2022-12-24 04:21:02 | Ciudad de Mexico, Mexico | |||
690458 | 690458 | 2022-12-23 | Mexico | Coahuila | 181576 | 8974 | 0 | 27.0587 | -101.7068 | 2022-12-24 04:21:02 | Coahuila, Mexico | |||
690459 | 690459 | 2022-12-23 | Mexico | Colima | 67845 | 2244 | 0 | 19.1223 | -104.0072 | 2022-12-24 04:21:02 | Colima, Mexico | |||
690460 | 690460 | 2022-12-23 | Mexico | Durango | 79570 | 3679 | 0 | 24.5593 | -104.6588 | 2022-12-24 04:21:02 | Durango, Mexico | |||
690461 | 690461 | 2022-12-23 | Mexico | Guanajuato | 353905 | 15112 | 0 | 21.019 | -101.2574 | 2022-12-24 04:21:02 | Guanajuato, Mexico | |||
690462 | 690462 | 2022-12-23 | Mexico | Guerrero | 116903 | 6856 | 0 | 17.4392 | -99.5451 | 2022-12-24 04:21:02 | Guerrero, Mexico | |||
690463 | 690463 | 2022-12-23 | Mexico | Hidalgo | 121313 | 8562 | 0 | 20.0911 | -98.7624 | 2022-12-24 04:21:02 | Hidalgo, Mexico | |||
690464 | 690464 | 2022-12-23 | Mexico | Jalisco | 286815 | 20006 | 0 | 20.6595 | -103.3494 | 2022-12-24 04:21:02 | Jalisco, Mexico | |||
690465 | 690465 | 2022-12-23 | Mexico | Mexico | 710797 | 47956 | 0 | 19.4969 | -99.7233 | 2022-12-24 04:21:02 | Mexico, Mexico | |||
690466 | 690466 | 2022-12-23 | Mexico | Michoacan | 110529 | 8977 | 0 | 19.5665 | -101.7068 | 2022-12-24 04:21:02 | Michoacan, Mexico | |||
690467 | 690467 | 2022-12-23 | Mexico | Morelos | 92722 | 5344 | 0 | 18.6813 | -99.1013 | 2022-12-24 04:21:02 | Morelos, Mexico | |||
690468 | 690468 | 2022-12-23 | Mexico | Nayarit | 72621 | 3250 | 0 | 21.7514 | -104.8455 | 2022-12-24 04:21:02 | Nayarit, Mexico | |||
690469 | 690469 | 2022-12-23 | Mexico | Nuevo Leon | 403415 | 15386 | 0 | 25.5922 | -99.9962 | 2022-12-24 04:21:02 | Nuevo Leon, Mexico | |||
690470 | 690470 | 2022-12-23 | Mexico | Oaxaca | 150612 | 6358 | 0 | 17.0732 | -96.7266 | 2022-12-24 04:21:02 | Oaxaca, Mexico | |||
690471 | 690471 | 2022-12-23 | Mexico | Puebla | 210223 | 16662 | 0 | 19.0414 | -98.2063 | 2022-12-24 04:21:02 | Puebla, Mexico | |||
690472 | 690472 | 2022-12-23 | Mexico | Queretaro | 178439 | 6352 | 0 | 20.5888 | -100.3899 | 2022-12-24 04:21:02 | Queretaro, Mexico | |||
690473 | 690473 | 2022-12-23 | Mexico | Quintana Roo | 116303 | 4441 | 0 | 19.1817 | -88.4791 | 2022-12-24 04:21:02 | Quintana Roo, Mexico | |||
690474 | 690474 | 2022-12-23 | Mexico | San Luis Potosi | 244092 | 7619 | 0 | 22.1565 | -100.9855 | 2022-12-24 04:21:02 | San Luis Potosi, Mexico | |||
690475 | 690475 | 2022-12-23 | Mexico | Sinaloa | 177869 | 9929 | 0 | 25.1721 | -107.4795 | 2022-12-24 04:21:02 | Sinaloa, Mexico | |||
690476 | 690476 | 2022-12-23 | Mexico | Sonora | 197963 | 10310 | 0 | 29.2972 | -110.3309 | 2022-12-24 04:21:02 | Sonora, Mexico | |||
690477 | 690477 | 2022-12-23 | Mexico | Tabasco | 217892 | 6143 | 0 | 17.8409 | -92.6189 | 2022-12-24 04:21:02 | Tabasco, Mexico | |||
690478 | 690478 | 2022-12-23 | Mexico | Tamaulipas | 179093 | 8224 | 0 | 24.2669 | -98.8363 | 2022-12-24 04:21:02 | Tamaulipas, Mexico | |||
690479 | 690479 | 2022-12-23 | Mexico | Tlaxcala | 56764 | 3124 | 0 | 19.3139 | -98.2404 | 2022-12-24 04:21:02 | Tlaxcala, Mexico | |||
690480 | 690480 | 2022-12-23 | Mexico | Unknown | 0 | 0 | 0 | 2022-12-24 04:21:02 | Unknown, Mexico | |||||
690481 | 690481 | 2022-12-23 | Mexico | Veracruz | 226501 | 17058 | 0 | 19.1738 | -96.1342 | 2022-12-24 04:21:02 | Veracruz, Mexico | |||
690482 | 690482 | 2022-12-23 | Mexico | Yucatan | 141244 | 6962 | 0 | 20.7099 | -89.0943 | 2022-12-24 04:21:02 | Yucatan, Mexico | |||
690483 | 690483 | 2022-12-23 | Mexico | Zacatecas | 80362 | 3934 | 0 | 22.7709 | -102.5832 | 2022-12-24 04:21:02 | Zacatecas, Mexico | |||
2179661 | 2179661 | 2022-12-22 | Mexico | Aguascalientes | 85306 | 3593 | 0 | 21.8853 | -102.2916 | 2022-12-23 04:21:04 | Aguascalientes, Mexico | |||
2179662 | 2179662 | 2022-12-22 | Mexico | Baja California | 168812 | 12454 | 0 | 30.8406 | -115.2838 | 2022-12-23 04:21:04 | Baja California, Mexico | |||
2179663 | 2179663 | 2022-12-22 | Mexico | Baja California Sur | 125808 | 2768 | 0 | 26.0444 | -111.6661 | 2022-12-23 04:21:04 | Baja California Sur, Mexico | |||
2179664 | 2179664 | 2022-12-22 | Mexico | Campeche | 43799 | 2286 | 0 | 19.8301 | -90.5349 | 2022-12-23 04:21:04 | Campeche, Mexico | |||
2179665 | 2179665 | 2022-12-22 | Mexico | Chiapas | 53817 | 2437 | 0 | 16.7569 | -93.1292 | 2022-12-23 04:21:04 | Chiapas, Mexico | |||
2179666 | 2179666 | 2022-12-22 | Mexico | Chihuahua | 169518 | 10169 | 0 | 28.633 | -106.0691 | 2022-12-23 04:21:04 | Chihuahua, Mexico | |||
2179667 | 2179667 | 2022-12-22 | Mexico | Ciudad de Mexico | 1774057 | 43665 | 0 | 19.4326 | -99.1332 | 2022-12-23 04:21:04 | Ciudad de Mexico, Mexico | |||
2179668 | 2179668 | 2022-12-22 | Mexico | Coahuila | 181576 | 8974 | 0 | 27.0587 | -101.7068 | 2022-12-23 04:21:04 | Coahuila, Mexico | |||
2179669 | 2179669 | 2022-12-22 | Mexico | Colima | 67845 | 2244 | 0 | 19.1223 | -104.0072 | 2022-12-23 04:21:04 | Colima, Mexico | |||
2179670 | 2179670 | 2022-12-22 | Mexico | Durango | 79570 | 3679 | 0 | 24.5593 | -104.6588 | 2022-12-23 04:21:04 | Durango, Mexico | |||
2179671 | 2179671 | 2022-12-22 | Mexico | Guanajuato | 353905 | 15112 | 0 | 21.019 | -101.2574 | 2022-12-23 04:21:04 | Guanajuato, Mexico | |||
2179672 | 2179672 | 2022-12-22 | Mexico | Guerrero | 116903 | 6856 | 0 | 17.4392 | -99.5451 | 2022-12-23 04:21:04 | Guerrero, Mexico | |||
2179673 | 2179673 | 2022-12-22 | Mexico | Hidalgo | 121313 | 8562 | 0 | 20.0911 | -98.7624 | 2022-12-23 04:21:04 | Hidalgo, Mexico | |||
2179674 | 2179674 | 2022-12-22 | Mexico | Jalisco | 286815 | 20006 | 0 | 20.6595 | -103.3494 | 2022-12-23 04:21:04 | Jalisco, Mexico | |||
2179675 | 2179675 | 2022-12-22 | Mexico | Mexico | 710797 | 47956 | 0 | 19.4969 | -99.7233 | 2022-12-23 04:21:04 | Mexico, Mexico | |||
2179676 | 2179676 | 2022-12-22 | Mexico | Michoacan | 110529 | 8977 | 0 | 19.5665 | -101.7068 | 2022-12-23 04:21:04 | Michoacan, Mexico | |||
2179677 | 2179677 | 2022-12-22 | Mexico | Morelos | 92722 | 5344 | 0 | 18.6813 | -99.1013 | 2022-12-23 04:21:04 | Morelos, Mexico | |||
2179678 | 2179678 | 2022-12-22 | Mexico | Nayarit | 72621 | 3250 | 0 | 21.7514 | -104.8455 | 2022-12-23 04:21:04 | Nayarit, Mexico | |||
2179679 | 2179679 | 2022-12-22 | Mexico | Nuevo Leon | 403415 | 15386 | 0 | 25.5922 | -99.9962 | 2022-12-23 04:21:04 | Nuevo Leon, Mexico | |||
2179680 | 2179680 | 2022-12-22 | Mexico | Oaxaca | 150612 | 6358 | 0 | 17.0732 | -96.7266 | 2022-12-23 04:21:04 | Oaxaca, Mexico | |||
2179681 | 2179681 | 2022-12-22 | Mexico | Puebla | 210223 | 16662 | 0 | 19.0414 | -98.2063 | 2022-12-23 04:21:04 | Puebla, Mexico | |||
2179682 | 2179682 | 2022-12-22 | Mexico | Queretaro | 178439 | 6352 | 0 | 20.5888 | -100.3899 | 2022-12-23 04:21:04 | Queretaro, Mexico | |||
2179683 | 2179683 | 2022-12-22 | Mexico | Quintana Roo | 116303 | 4441 | 0 | 19.1817 | -88.4791 | 2022-12-23 04:21:04 | Quintana Roo, Mexico | |||
2179684 | 2179684 | 2022-12-22 | Mexico | San Luis Potosi | 244092 | 7619 | 0 | 22.1565 | -100.9855 | 2022-12-23 04:21:04 | San Luis Potosi, Mexico | |||
2179685 | 2179685 | 2022-12-22 | Mexico | Sinaloa | 177869 | 9929 | 0 | 25.1721 | -107.4795 | 2022-12-23 04:21:04 | Sinaloa, Mexico | |||
2179686 | 2179686 | 2022-12-22 | Mexico | Sonora | 197963 | 10310 | 0 | 29.2972 | -110.3309 | 2022-12-23 04:21:04 | Sonora, Mexico | |||
2179687 | 2179687 | 2022-12-22 | Mexico | Tabasco | 217892 | 6143 | 0 | 17.8409 | -92.6189 | 2022-12-23 04:21:04 | Tabasco, Mexico | |||
2179688 | 2179688 | 2022-12-22 | Mexico | Tamaulipas | 179093 | 8224 | 0 | 24.2669 | -98.8363 | 2022-12-23 04:21:04 | Tamaulipas, Mexico | |||
2179689 | 2179689 | 2022-12-22 | Mexico | Tlaxcala | 56764 | 3124 | 0 | 19.3139 | -98.2404 | 2022-12-23 04:21:04 | Tlaxcala, Mexico | |||
2179690 | 2179690 | 2022-12-22 | Mexico | Unknown | 0 | 0 | 0 | 2022-12-23 04:21:04 | Unknown, Mexico | |||||
2179691 | 2179691 | 2022-12-22 | Mexico | Veracruz | 226501 | 17058 | 0 | 19.1738 | -96.1342 | 2022-12-23 04:21:04 | Veracruz, Mexico | |||
2179692 | 2179692 | 2022-12-22 | Mexico | Yucatan | 141244 | 6962 | 0 | 20.7099 | -89.0943 | 2022-12-23 04:21:04 | Yucatan, Mexico | |||
2179693 | 2179693 | 2022-12-22 | Mexico | Zacatecas | 80362 | 3934 | 0 | 22.7709 | -102.5832 | 2022-12-23 04:21:04 | Zacatecas, Mexico | |||
451465 | 451465 | 2022-12-21 | Mexico | Aguascalientes | 85306 | 3593 | 0 | 21.8853 | -102.2916 | 2022-12-22 04:20:56 | Aguascalientes, Mexico | |||
451466 | 451466 | 2022-12-21 | Mexico | Baja California | 168812 | 12454 | 0 | 30.8406 | -115.2838 | 2022-12-22 04:20:56 | Baja California, Mexico | |||
451467 | 451467 | 2022-12-21 | Mexico | Baja California Sur | 125808 | 2768 | 0 | 26.0444 | -111.6661 | 2022-12-22 04:20:56 | Baja California Sur, Mexico | |||
451468 | 451468 | 2022-12-21 | Mexico | Campeche | 43799 | 2286 | 0 | 19.8301 | -90.5349 | 2022-12-22 04:20:56 | Campeche, Mexico | |||
451469 | 451469 | 2022-12-21 | Mexico | Chiapas | 53817 | 2437 | 0 | 16.7569 | -93.1292 | 2022-12-22 04:20:56 | Chiapas, Mexico | |||
451470 | 451470 | 2022-12-21 | Mexico | Chihuahua | 169518 | 10169 | 0 | 28.633 | -106.0691 | 2022-12-22 04:20:56 | Chihuahua, Mexico | |||
451471 | 451471 | 2022-12-21 | Mexico | Ciudad de Mexico | 1774057 | 43665 | 0 | 19.4326 | -99.1332 | 2022-12-22 04:20:56 | Ciudad de Mexico, Mexico | |||
451472 | 451472 | 2022-12-21 | Mexico | Coahuila | 181576 | 8974 | 0 | 27.0587 | -101.7068 | 2022-12-22 04:20:56 | Coahuila, Mexico | |||
451473 | 451473 | 2022-12-21 | Mexico | Colima | 67845 | 2244 | 0 | 19.1223 | -104.0072 | 2022-12-22 04:20:56 | Colima, Mexico | |||
451474 | 451474 | 2022-12-21 | Mexico | Durango | 79570 | 3679 | 0 | 24.5593 | -104.6588 | 2022-12-22 04:20:56 | Durango, Mexico | |||
451475 | 451475 | 2022-12-21 | Mexico | Guanajuato | 353905 | 15112 | 0 | 21.019 | -101.2574 | 2022-12-22 04:20:56 | Guanajuato, Mexico | |||
451476 | 451476 | 2022-12-21 | Mexico | Guerrero | 116903 | 6856 | 0 | 17.4392 | -99.5451 | 2022-12-22 04:20:56 | Guerrero, Mexico | |||
451477 | 451477 | 2022-12-21 | Mexico | Hidalgo | 121313 | 8562 | 0 | 20.0911 | -98.7624 | 2022-12-22 04:20:56 | Hidalgo, Mexico | |||
451478 | 451478 | 2022-12-21 | Mexico | Jalisco | 286815 | 20006 | 0 | 20.6595 | -103.3494 | 2022-12-22 04:20:56 | Jalisco, Mexico | |||
451479 | 451479 | 2022-12-21 | Mexico | Mexico | 710797 | 47956 | 0 | 19.4969 | -99.7233 | 2022-12-22 04:20:56 | Mexico, Mexico | |||
451480 | 451480 | 2022-12-21 | Mexico | Michoacan | 110529 | 8977 | 0 | 19.5665 | -101.7068 | 2022-12-22 04:20:56 | Michoacan, Mexico | |||
451481 | 451481 | 2022-12-21 | Mexico | Morelos | 92722 | 5344 | 0 | 18.6813 | -99.1013 | 2022-12-22 04:20:56 | Morelos, Mexico | |||
451482 | 451482 | 2022-12-21 | Mexico | Nayarit | 72621 | 3250 | 0 | 21.7514 | -104.8455 | 2022-12-22 04:20:56 | Nayarit, Mexico | |||
451483 | 451483 | 2022-12-21 | Mexico | Nuevo Leon | 403415 | 15386 | 0 | 25.5922 | -99.9962 | 2022-12-22 04:20:56 | Nuevo Leon, Mexico | |||
451484 | 451484 | 2022-12-21 | Mexico | Oaxaca | 150612 | 6358 | 0 | 17.0732 | -96.7266 | 2022-12-22 04:20:56 | Oaxaca, Mexico | |||
451485 | 451485 | 2022-12-21 | Mexico | Puebla | 210223 | 16662 | 0 | 19.0414 | -98.2063 | 2022-12-22 04:20:56 | Puebla, Mexico | |||
451486 | 451486 | 2022-12-21 | Mexico | Queretaro | 178439 | 6352 | 0 | 20.5888 | -100.3899 | 2022-12-22 04:20:56 | Queretaro, Mexico | |||
451487 | 451487 | 2022-12-21 | Mexico | Quintana Roo | 116303 | 4441 | 0 | 19.1817 | -88.4791 | 2022-12-22 04:20:56 | Quintana Roo, Mexico | |||
451488 | 451488 | 2022-12-21 | Mexico | San Luis Potosi | 244092 | 7619 | 0 | 22.1565 | -100.9855 | 2022-12-22 04:20:56 | San Luis Potosi, Mexico | |||
451489 | 451489 | 2022-12-21 | Mexico | Sinaloa | 177869 | 9929 | 0 | 25.1721 | -107.4795 | 2022-12-22 04:20:56 | Sinaloa, Mexico | |||
451490 | 451490 | 2022-12-21 | Mexico | Sonora | 197963 | 10310 | 0 | 29.2972 | -110.3309 | 2022-12-22 04:20:56 | Sonora, Mexico | |||
451491 | 451491 | 2022-12-21 | Mexico | Tabasco | 217892 | 6143 | 0 | 17.8409 | -92.6189 | 2022-12-22 04:20:56 | Tabasco, Mexico | |||
451492 | 451492 | 2022-12-21 | Mexico | Tamaulipas | 179093 | 8224 | 0 | 24.2669 | -98.8363 | 2022-12-22 04:20:56 | Tamaulipas, Mexico | |||
451493 | 451493 | 2022-12-21 | Mexico | Tlaxcala | 56764 | 3124 | 0 | 19.3139 | -98.2404 | 2022-12-22 04:20:56 | Tlaxcala, Mexico | |||
451494 | 451494 | 2022-12-21 | Mexico | Unknown | 0 | 0 | 0 | 2022-12-22 04:20:56 | Unknown, Mexico | |||||
451495 | 451495 | 2022-12-21 | Mexico | Veracruz | 226501 | 17058 | 0 | 19.1738 | -96.1342 | 2022-12-22 04:20:56 | Veracruz, Mexico | |||
451496 | 451496 | 2022-12-21 | Mexico | Yucatan | 141244 | 6962 | 0 | 20.7099 | -89.0943 | 2022-12-22 04:20:56 | Yucatan, Mexico | |||
451497 | 451497 | 2022-12-21 | Mexico | Zacatecas | 80362 | 3934 | 0 | 22.7709 | -102.5832 | 2022-12-22 04:20:56 | Zacatecas, Mexico | |||
2951464 | 2951464 | 2022-12-20 | Mexico | Aguascalientes | 85306 | 3593 | 0 | 21.8853 | -102.2916 | 2022-12-21 04:21:03 | Aguascalientes, Mexico | |||
2951465 | 2951465 | 2022-12-20 | Mexico | Baja California | 168812 | 12454 | 0 | 30.8406 | -115.2838 | 2022-12-21 04:21:03 | Baja California, Mexico | |||
2951466 | 2951466 | 2022-12-20 | Mexico | Baja California Sur | 125808 | 2768 | 0 | 26.0444 | -111.6661 | 2022-12-21 04:21:03 | Baja California Sur, 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]);