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
- Aguascalientes 553
- Baja California 553
- Baja California Sur 553
- Campeche 553
- Chiapas 553
- Chihuahua 553
- Ciudad de Mexico 553
- Coahuila 553
- Colima 553
- Durango 553
- Guanajuato 553
- Guerrero 553
- Hidalgo 553
- Jalisco 553
- Mexico 553
- Michoacan 553
- Morelos 553
- Nayarit 553
- Nuevo Leon 553
- Oaxaca 553
- Puebla 553
- Queretaro 553
- Quintana Roo 553
- San Luis Potosi 553
- Sinaloa 553
- Sonora 553
- Tabasco 553
- Tamaulipas 553
- Tlaxcala 553
- Veracruz 553
- …
country_or_region 1
- Mexico · 18,156 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3070105 | 3070105 | 2021-11-23 | Mexico | Aguascalientes | 36692 | 2918 | 0 | 21.8853 | -102.2916 | 2021-11-24 04:22:14 | Aguascalientes, Mexico | |||
3070106 | 3070106 | 2021-11-23 | Mexico | Baja California | 77355 | 10165 | 0 | 30.8406 | -115.2838 | 2021-11-24 04:22:14 | Baja California, Mexico | |||
3070107 | 3070107 | 2021-11-23 | Mexico | Baja California Sur | 56633 | 2380 | 0 | 26.0444 | -111.6661 | 2021-11-24 04:22:14 | Baja California Sur, Mexico | |||
3070108 | 3070108 | 2021-11-23 | Mexico | Campeche | 24115 | 2076 | 0 | 19.8301 | -90.5349 | 2021-11-24 04:22:14 | Campeche, Mexico | |||
3070109 | 3070109 | 2021-11-23 | Mexico | Chiapas | 23463 | 2281 | 0 | 16.7569 | -93.1292 | 2021-11-24 04:22:14 | Chiapas, Mexico | |||
3070110 | 3070110 | 2021-11-23 | Mexico | Chihuahua | 71547 | 8222 | 0 | 28.63300000000001 | -106.0691 | 2021-11-24 04:22:14 | Chihuahua, Mexico | |||
3070111 | 3070111 | 2021-11-23 | Mexico | Ciudad de Mexico | 980658 | 40055 | 0 | 19.4326 | -99.1332 | 2021-11-24 04:22:14 | Ciudad de Mexico, Mexico | |||
3070112 | 3070112 | 2021-11-23 | Mexico | Coahuila | 96451 | 7515 | 0 | 27.0587 | -101.7068 | 2021-11-24 04:22:14 | Coahuila, Mexico | |||
3070113 | 3070113 | 2021-11-23 | Mexico | Colima | 33270 | 2021 | 0 | 19.1223 | -104.0072 | 2021-11-24 04:22:14 | Colima, Mexico | |||
3070114 | 3070114 | 2021-11-23 | Mexico | Durango | 49432 | 3063 | 0 | 24.5593 | -104.6588 | 2021-11-24 04:22:14 | Durango, Mexico | |||
3070115 | 3070115 | 2021-11-23 | Mexico | Guanajuato | 194269 | 12905 | 0 | 21.019000000000002 | -101.2574 | 2021-11-24 04:22:14 | Guanajuato, Mexico | |||
3070116 | 3070116 | 2021-11-23 | Mexico | Guerrero | 76852 | 6222 | 0 | 17.4392 | -99.5451 | 2021-11-24 04:22:14 | Guerrero, Mexico | |||
3070117 | 3070117 | 2021-11-23 | Mexico | Hidalgo | 62565 | 7836 | 0 | 20.0911 | -98.7624 | 2021-11-24 04:22:14 | Hidalgo, Mexico | |||
3070118 | 3070118 | 2021-11-23 | Mexico | Jalisco | 162743 | 17504 | 0 | 20.6595 | -103.3494 | 2021-11-24 04:22:14 | Jalisco, Mexico | |||
3070119 | 3070119 | 2021-11-23 | Mexico | Mexico | 377780 | 44270 | 0 | 19.4969 | -99.7233 | 2021-11-24 04:22:14 | Mexico, Mexico | |||
3070120 | 3070120 | 2021-11-23 | Mexico | Michoacan | 73428 | 8134 | 0 | 19.5665 | -101.7068 | 2021-11-24 04:22:14 | Michoacan, Mexico | |||
3070121 | 3070121 | 2021-11-23 | Mexico | Morelos | 50090 | 4807 | 0 | 18.6813 | -99.1013 | 2021-11-24 04:22:14 | Morelos, Mexico | |||
3070122 | 3070122 | 2021-11-23 | Mexico | Nayarit | 34108 | 2853 | 0 | 21.7514 | -104.8455 | 2021-11-24 04:22:14 | Nayarit, Mexico | |||
3070123 | 3070123 | 2021-11-23 | Mexico | Nuevo Leon | 206222 | 13211 | 0 | 25.5922 | -99.9962 | 2021-11-24 04:22:14 | Nuevo Leon, Mexico | |||
3070124 | 3070124 | 2021-11-23 | Mexico | Oaxaca | 82777 | 5567 | 0 | 17.0732 | -96.7266 | 2021-11-24 04:22:14 | Oaxaca, Mexico | |||
3070125 | 3070125 | 2021-11-23 | Mexico | Puebla | 124833 | 15467 | 0 | 19.0414 | -98.2063 | 2021-11-24 04:22:14 | Puebla, Mexico | |||
3070126 | 3070126 | 2021-11-23 | Mexico | Queretaro | 98684 | 5579 | 0 | 20.5888 | -100.3899 | 2021-11-24 04:22:14 | Queretaro, Mexico | |||
3070127 | 3070127 | 2021-11-23 | Mexico | Quintana Roo | 59756 | 4068 | 0 | 19.1817 | -88.4791 | 2021-11-24 04:22:14 | Quintana Roo, Mexico | |||
3070128 | 3070128 | 2021-11-23 | Mexico | San Luis Potosi | 104704 | 6667 | 0 | 22.1565 | -100.9855 | 2021-11-24 04:22:14 | San Luis Potosi, Mexico | |||
3070129 | 3070129 | 2021-11-23 | Mexico | Sinaloa | 74254 | 8807 | 0 | 25.1721 | -107.4795 | 2021-11-24 04:22:14 | Sinaloa, Mexico | |||
3070130 | 3070130 | 2021-11-23 | Mexico | Sonora | 115715 | 8644 | 0 | 29.2972 | -110.3309 | 2021-11-24 04:22:14 | Sonora, Mexico | |||
3070131 | 3070131 | 2021-11-23 | Mexico | Tabasco | 143443 | 5577 | 0 | 17.8409 | -92.6189 | 2021-11-24 04:22:14 | Tabasco, Mexico | |||
3070132 | 3070132 | 2021-11-23 | Mexico | Tamaulipas | 102699 | 6912 | 0 | 24.2669 | -98.8363 | 2021-11-24 04:22:14 | Tamaulipas, Mexico | |||
3070133 | 3070133 | 2021-11-23 | Mexico | Tlaxcala | 29387 | 2980 | 0 | 19.3139 | -98.2404 | 2021-11-24 04:22:14 | Tlaxcala, Mexico | |||
3070134 | 3070134 | 2021-11-23 | Mexico | Unknown | 0 | 0 | 0 | 2021-11-24 04:22:14 | Unknown, Mexico | |||||
3070135 | 3070135 | 2021-11-23 | Mexico | Veracruz | 123584 | 14778 | 0 | 19.1738 | -96.1342 | 2021-11-24 04:22:14 | Veracruz, Mexico | |||
3070136 | 3070136 | 2021-11-23 | Mexico | Yucatan | 74857 | 5639 | 0 | 20.7099 | -89.0943 | 2021-11-24 04:22:14 | Yucatan, Mexico | |||
3070137 | 3070137 | 2021-11-23 | Mexico | Zacatecas | 41912 | 3401 | 0 | 22.7709 | -102.5832 | 2021-11-24 04:22:14 | Zacatecas, Mexico | |||
3749203 | 3749203 | 2021-11-22 | Mexico | Aguascalientes | 36692 | 2918 | 0 | 21.8853 | -102.2916 | 2021-11-23 04:22:39 | Aguascalientes, Mexico | |||
3749204 | 3749204 | 2021-11-22 | Mexico | Baja California | 77355 | 10165 | 0 | 30.8406 | -115.2838 | 2021-11-23 04:22:39 | Baja California, Mexico | |||
3749205 | 3749205 | 2021-11-22 | Mexico | Baja California Sur | 56633 | 2380 | 0 | 26.0444 | -111.6661 | 2021-11-23 04:22:39 | Baja California Sur, Mexico | |||
3749206 | 3749206 | 2021-11-22 | Mexico | Campeche | 24115 | 2076 | 0 | 19.8301 | -90.5349 | 2021-11-23 04:22:39 | Campeche, Mexico | |||
3749207 | 3749207 | 2021-11-22 | Mexico | Chiapas | 23463 | 2281 | 0 | 16.7569 | -93.1292 | 2021-11-23 04:22:39 | Chiapas, Mexico | |||
3749208 | 3749208 | 2021-11-22 | Mexico | Chihuahua | 71547 | 8222 | 0 | 28.63300000000001 | -106.0691 | 2021-11-23 04:22:39 | Chihuahua, Mexico | |||
3749209 | 3749209 | 2021-11-22 | Mexico | Ciudad de Mexico | 980658 | 40055 | 0 | 19.4326 | -99.1332 | 2021-11-23 04:22:39 | Ciudad de Mexico, Mexico | |||
3749210 | 3749210 | 2021-11-22 | Mexico | Coahuila | 96451 | 7515 | 0 | 27.0587 | -101.7068 | 2021-11-23 04:22:39 | Coahuila, Mexico | |||
3749211 | 3749211 | 2021-11-22 | Mexico | Colima | 33270 | 2021 | 0 | 19.1223 | -104.0072 | 2021-11-23 04:22:39 | Colima, Mexico | |||
3749212 | 3749212 | 2021-11-22 | Mexico | Durango | 49432 | 3063 | 0 | 24.5593 | -104.6588 | 2021-11-23 04:22:39 | Durango, Mexico | |||
3749213 | 3749213 | 2021-11-22 | Mexico | Guanajuato | 194269 | 12905 | 0 | 21.019000000000002 | -101.2574 | 2021-11-23 04:22:39 | Guanajuato, Mexico | |||
3749214 | 3749214 | 2021-11-22 | Mexico | Guerrero | 76852 | 6222 | 0 | 17.4392 | -99.5451 | 2021-11-23 04:22:39 | Guerrero, Mexico | |||
3749215 | 3749215 | 2021-11-22 | Mexico | Hidalgo | 62565 | 7836 | 0 | 20.0911 | -98.7624 | 2021-11-23 04:22:39 | Hidalgo, Mexico | |||
3749216 | 3749216 | 2021-11-22 | Mexico | Jalisco | 162743 | 17504 | 0 | 20.6595 | -103.3494 | 2021-11-23 04:22:39 | Jalisco, Mexico | |||
3749217 | 3749217 | 2021-11-22 | Mexico | Mexico | 377780 | 44270 | 0 | 19.4969 | -99.7233 | 2021-11-23 04:22:39 | Mexico, Mexico | |||
3749218 | 3749218 | 2021-11-22 | Mexico | Michoacan | 73428 | 8134 | 0 | 19.5665 | -101.7068 | 2021-11-23 04:22:39 | Michoacan, Mexico | |||
3749219 | 3749219 | 2021-11-22 | Mexico | Morelos | 50090 | 4807 | 0 | 18.6813 | -99.1013 | 2021-11-23 04:22:39 | Morelos, Mexico | |||
3749220 | 3749220 | 2021-11-22 | Mexico | Nayarit | 34108 | 2853 | 0 | 21.7514 | -104.8455 | 2021-11-23 04:22:39 | Nayarit, Mexico | |||
3749221 | 3749221 | 2021-11-22 | Mexico | Nuevo Leon | 206222 | 13211 | 0 | 25.5922 | -99.9962 | 2021-11-23 04:22:39 | Nuevo Leon, Mexico | |||
3749222 | 3749222 | 2021-11-22 | Mexico | Oaxaca | 82777 | 5567 | 0 | 17.0732 | -96.7266 | 2021-11-23 04:22:39 | Oaxaca, Mexico | |||
3749223 | 3749223 | 2021-11-22 | Mexico | Puebla | 124833 | 15467 | 0 | 19.0414 | -98.2063 | 2021-11-23 04:22:39 | Puebla, Mexico | |||
3749224 | 3749224 | 2021-11-22 | Mexico | Queretaro | 98684 | 5579 | 0 | 20.5888 | -100.3899 | 2021-11-23 04:22:39 | Queretaro, Mexico | |||
3749225 | 3749225 | 2021-11-22 | Mexico | Quintana Roo | 59756 | 4068 | 0 | 19.1817 | -88.4791 | 2021-11-23 04:22:39 | Quintana Roo, Mexico | |||
3749226 | 3749226 | 2021-11-22 | Mexico | San Luis Potosi | 104704 | 6667 | 0 | 22.1565 | -100.9855 | 2021-11-23 04:22:39 | San Luis Potosi, Mexico | |||
3749227 | 3749227 | 2021-11-22 | Mexico | Sinaloa | 74254 | 8807 | 0 | 25.1721 | -107.4795 | 2021-11-23 04:22:39 | Sinaloa, Mexico | |||
3749228 | 3749228 | 2021-11-22 | Mexico | Sonora | 115715 | 8644 | 0 | 29.2972 | -110.3309 | 2021-11-23 04:22:39 | Sonora, Mexico | |||
3749229 | 3749229 | 2021-11-22 | Mexico | Tabasco | 143443 | 5577 | 0 | 17.8409 | -92.6189 | 2021-11-23 04:22:39 | Tabasco, Mexico | |||
3749230 | 3749230 | 2021-11-22 | Mexico | Tamaulipas | 102699 | 6912 | 0 | 24.2669 | -98.8363 | 2021-11-23 04:22:39 | Tamaulipas, Mexico | |||
3749231 | 3749231 | 2021-11-22 | Mexico | Tlaxcala | 29387 | 2980 | 0 | 19.3139 | -98.2404 | 2021-11-23 04:22:39 | Tlaxcala, Mexico | |||
3749232 | 3749232 | 2021-11-22 | Mexico | Unknown | 0 | 0 | 0 | 2021-11-23 04:22:39 | Unknown, Mexico | |||||
3749233 | 3749233 | 2021-11-22 | Mexico | Veracruz | 123584 | 14778 | 0 | 19.1738 | -96.1342 | 2021-11-23 04:22:39 | Veracruz, Mexico | |||
3749234 | 3749234 | 2021-11-22 | Mexico | Yucatan | 74857 | 5639 | 0 | 20.7099 | -89.0943 | 2021-11-23 04:22:39 | Yucatan, Mexico | |||
3749235 | 3749235 | 2021-11-22 | Mexico | Zacatecas | 41912 | 3401 | 0 | 22.7709 | -102.5832 | 2021-11-23 04:22:39 | Zacatecas, Mexico | |||
1014410 | 1014410 | 2021-11-21 | Mexico | Aguascalientes | 36674 | 2916 | 0 | 21.8853 | -102.2916 | 2021-11-22 04:22:20 | Aguascalientes, Mexico | |||
1014411 | 1014411 | 2021-11-21 | Mexico | Baja California | 77099 | 10146 | 0 | 30.8406 | -115.2838 | 2021-11-22 04:22:20 | Baja California, Mexico | |||
1014412 | 1014412 | 2021-11-21 | Mexico | Baja California Sur | 56595 | 2380 | 0 | 26.0444 | -111.6661 | 2021-11-22 04:22:20 | Baja California Sur, Mexico | |||
1014413 | 1014413 | 2021-11-21 | Mexico | Campeche | 24107 | 2076 | 0 | 19.8301 | -90.5349 | 2021-11-22 04:22:20 | Campeche, Mexico | |||
1014414 | 1014414 | 2021-11-21 | Mexico | Chiapas | 23450 | 2279 | 0 | 16.7569 | -93.1292 | 2021-11-22 04:22:20 | Chiapas, Mexico | |||
1014415 | 1014415 | 2021-11-21 | Mexico | Chihuahua | 71490 | 8220 | 0 | 28.63300000000001 | -106.0691 | 2021-11-22 04:22:20 | Chihuahua, Mexico | |||
1014416 | 1014416 | 2021-11-21 | Mexico | Ciudad de Mexico | 980197 | 40047 | 0 | 19.4326 | -99.1332 | 2021-11-22 04:22:20 | Ciudad de Mexico, Mexico | |||
1014417 | 1014417 | 2021-11-21 | Mexico | Coahuila | 96361 | 7509 | 0 | 27.0587 | -101.7068 | 2021-11-22 04:22:20 | Coahuila, Mexico | |||
1014418 | 1014418 | 2021-11-21 | Mexico | Colima | 33267 | 2021 | 0 | 19.1223 | -104.0072 | 2021-11-22 04:22:20 | Colima, Mexico | |||
1014419 | 1014419 | 2021-11-21 | Mexico | Durango | 49386 | 3063 | 0 | 24.5593 | -104.6588 | 2021-11-22 04:22:20 | Durango, Mexico | |||
1014420 | 1014420 | 2021-11-21 | Mexico | Guanajuato | 194154 | 12878 | 0 | 21.019000000000002 | -101.2574 | 2021-11-22 04:22:20 | Guanajuato, Mexico | |||
1014421 | 1014421 | 2021-11-21 | Mexico | Guerrero | 76812 | 6218 | 0 | 17.4392 | -99.5451 | 2021-11-22 04:22:20 | Guerrero, Mexico | |||
1014422 | 1014422 | 2021-11-21 | Mexico | Hidalgo | 62548 | 7835 | 0 | 20.0911 | -98.7624 | 2021-11-22 04:22:20 | Hidalgo, Mexico | |||
1014423 | 1014423 | 2021-11-21 | Mexico | Jalisco | 162714 | 17491 | 0 | 20.6595 | -103.3494 | 2021-11-22 04:22:20 | Jalisco, Mexico | |||
1014424 | 1014424 | 2021-11-21 | Mexico | Mexico | 377543 | 44256 | 0 | 19.4969 | -99.7233 | 2021-11-22 04:22:20 | Mexico, Mexico | |||
1014425 | 1014425 | 2021-11-21 | Mexico | Michoacan | 73415 | 8133 | 0 | 19.5665 | -101.7068 | 2021-11-22 04:22:20 | Michoacan, Mexico | |||
1014426 | 1014426 | 2021-11-21 | Mexico | Morelos | 50085 | 4804 | 0 | 18.6813 | -99.1013 | 2021-11-22 04:22:20 | Morelos, Mexico | |||
1014427 | 1014427 | 2021-11-21 | Mexico | Nayarit | 34106 | 2852 | 0 | 21.7514 | -104.8455 | 2021-11-22 04:22:20 | Nayarit, Mexico | |||
1014428 | 1014428 | 2021-11-21 | Mexico | Nuevo Leon | 206152 | 13206 | 0 | 25.5922 | -99.9962 | 2021-11-22 04:22:20 | Nuevo Leon, Mexico | |||
1014429 | 1014429 | 2021-11-21 | Mexico | Oaxaca | 82735 | 5567 | 0 | 17.0732 | -96.7266 | 2021-11-22 04:22:20 | Oaxaca, Mexico | |||
1014430 | 1014430 | 2021-11-21 | Mexico | Puebla | 124780 | 15466 | 0 | 19.0414 | -98.2063 | 2021-11-22 04:22:20 | Puebla, Mexico | |||
1014431 | 1014431 | 2021-11-21 | Mexico | Queretaro | 98651 | 5579 | 0 | 20.5888 | -100.3899 | 2021-11-22 04:22:20 | Queretaro, Mexico | |||
1014432 | 1014432 | 2021-11-21 | Mexico | Quintana Roo | 59739 | 4066 | 0 | 19.1817 | -88.4791 | 2021-11-22 04:22:20 | Quintana Roo, Mexico | |||
1014433 | 1014433 | 2021-11-21 | Mexico | San Luis Potosi | 104648 | 6667 | 0 | 22.1565 | -100.9855 | 2021-11-22 04:22:20 | San Luis Potosi, Mexico | |||
1014434 | 1014434 | 2021-11-21 | Mexico | Sinaloa | 74231 | 8807 | 0 | 25.1721 | -107.4795 | 2021-11-22 04:22:20 | Sinaloa, Mexico | |||
1014435 | 1014435 | 2021-11-21 | Mexico | Sonora | 115523 | 8641 | 0 | 29.2972 | -110.3309 | 2021-11-22 04:22:20 | Sonora, Mexico | |||
1014436 | 1014436 | 2021-11-21 | Mexico | Tabasco | 143380 | 5576 | 0 | 17.8409 | -92.6189 | 2021-11-22 04:22:20 | Tabasco, Mexico | |||
1014437 | 1014437 | 2021-11-21 | Mexico | Tamaulipas | 102622 | 6912 | 0 | 24.2669 | -98.8363 | 2021-11-22 04:22:20 | Tamaulipas, Mexico | |||
1014438 | 1014438 | 2021-11-21 | Mexico | Tlaxcala | 29382 | 2977 | 0 | 19.3139 | -98.2404 | 2021-11-22 04:22:20 | Tlaxcala, Mexico | |||
1014439 | 1014439 | 2021-11-21 | Mexico | Unknown | 0 | 0 | 0 | 2021-11-22 04:22:20 | Unknown, Mexico | |||||
1014440 | 1014440 | 2021-11-21 | Mexico | Veracruz | 123552 | 14752 | 0 | 19.1738 | -96.1342 | 2021-11-22 04:22:20 | Veracruz, Mexico | |||
1014441 | 1014441 | 2021-11-21 | Mexico | Yucatan | 74836 | 5632 | 0 | 20.7099 | -89.0943 | 2021-11-22 04:22:20 | Yucatan, Mexico | |||
1014442 | 1014442 | 2021-11-21 | Mexico | Zacatecas | 41903 | 3400 | 0 | 22.7709 | -102.5832 | 2021-11-22 04:22:20 | Zacatecas, Mexico | |||
722574 | 722574 | 2021-11-20 | Mexico | Aguascalientes | 36627 | 2912 | 0 | 21.8853 | -102.2916 | 2021-11-21 04:22:13 | Aguascalientes, 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]);