johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
32 rows where country_or_region = "Mexico" and last_update = "2020-08-09 04:34:54" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state >30
- Aguascalientes 1
- Baja California 1
- Baja California Sur 1
- Campeche 1
- Chiapas 1
- Chihuahua 1
- Ciudad de Mexico 1
- Coahuila 1
- Colima 1
- Durango 1
- Guanajuato 1
- Guerrero 1
- Hidalgo 1
- Jalisco 1
- Mexico 1
- Michoacan 1
- Morelos 1
- Nayarit 1
- Nuevo Leon 1
- Oaxaca 1
- Puebla 1
- Queretaro 1
- Quintana Roo 1
- San Luis Potosi 1
- Sinaloa 1
- Sonora 1
- Tabasco 1
- Tamaulipas 1
- Tlaxcala 1
- Veracruz 1
- …
country_or_region 1
- Mexico · 32 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
371139 | 371139 | 2020-08-08 | Mexico | Aguascalientes | 4504 | 284 | 3786 | 434 | 21.8853 | -102.2916 | 2020-08-09 04:34:54 | Aguascalientes, Mexico | ||
371180 | 371180 | 2020-08-08 | Mexico | Baja California | 14473 | 2765 | 10916 | 792 | 30.8406 | -115.2838 | 2020-08-09 04:34:54 | Baja California, Mexico | ||
371181 | 371181 | 2020-08-08 | Mexico | Baja California Sur | 5307 | 213 | 3928 | 1166 | 26.0444 | -111.6661 | 2020-08-09 04:34:54 | Baja California Sur, Mexico | ||
371209 | 371209 | 2020-08-08 | Mexico | Campeche | 4940 | 600 | 4059 | 281 | 19.8301 | -90.5349 | 2020-08-09 04:34:54 | Campeche, Mexico | ||
371231 | 371231 | 2020-08-08 | Mexico | Chiapas | 5953 | 945 | 4815 | 193 | 16.7569 | -93.1292 | 2020-08-09 04:34:54 | Chiapas, Mexico | ||
371233 | 371233 | 2020-08-08 | Mexico | Chihuahua | 5886 | 963 | 4342 | 581 | 28.63300000000001 | -106.0691 | 2020-08-09 04:34:54 | Chihuahua, Mexico | ||
371238 | 371238 | 2020-08-08 | Mexico | Ciudad de Mexico | 79899 | 9365 | 64278 | 6256 | 19.4326 | -99.1332 | 2020-08-09 04:34:54 | Ciudad de Mexico, Mexico | ||
371239 | 371239 | 2020-08-08 | Mexico | Coahuila | 15262 | 859 | 11928 | 2475 | 27.0587 | -101.7068 | 2020-08-09 04:34:54 | Coahuila, Mexico | ||
371240 | 371240 | 2020-08-08 | Mexico | Colima | 2237 | 265 | 1477 | 495 | 19.1223 | -104.0072 | 2020-08-09 04:34:54 | Colima, Mexico | ||
371257 | 371257 | 2020-08-08 | Mexico | Durango | 4711 | 334 | 3694 | 683 | 24.5593 | -104.6588 | 2020-08-09 04:34:54 | Durango, Mexico | ||
371290 | 371290 | 2020-08-08 | Mexico | Guanajuato | 23918 | 1189 | 19778 | 2951 | 21.019000000000002 | -101.2574 | 2020-08-09 04:34:54 | Guanajuato, Mexico | ||
371294 | 371294 | 2020-08-08 | Mexico | Guerrero | 12142 | 1449 | 9321 | 1372 | 17.4392 | -99.5451 | 2020-08-09 04:34:54 | Guerrero, Mexico | ||
371306 | 371306 | 2020-08-08 | Mexico | Hidalgo | 7773 | 1194 | 5579 | 1000 | 20.0911 | -98.7624 | 2020-08-09 04:34:54 | Hidalgo, Mexico | ||
371328 | 371328 | 2020-08-08 | Mexico | Jalisco | 14847 | 1754 | 11298 | 1795 | 20.6595 | -103.3494 | 2020-08-09 04:34:54 | Jalisco, Mexico | ||
371415 | 371415 | 2020-08-08 | Mexico | Mexico | 57057 | 6915 | 45548 | 4594 | 19.4969 | -99.7233 | 2020-08-09 04:34:54 | Mexico, Mexico | ||
371416 | 371416 | 2020-08-08 | Mexico | Michoacan | 10996 | 837 | 8789 | 1370 | 19.5665 | -101.7068 | 2020-08-09 04:34:54 | Michoacan, Mexico | ||
371426 | 371426 | 2020-08-08 | Mexico | Morelos | 4384 | 872 | 3146 | 366 | 18.6813 | -99.1013 | 2020-08-09 04:34:54 | Morelos, Mexico | ||
371438 | 371438 | 2020-08-08 | Mexico | Nayarit | 3890 | 443 | 2912 | 535 | 21.7514 | -104.8455 | 2020-08-09 04:34:54 | Nayarit, Mexico | ||
371463 | 371463 | 2020-08-08 | Mexico | Nuevo Leon | 21327 | 1427 | 17467 | 2433 | 25.5922 | -99.9962 | 2020-08-09 04:34:54 | Nuevo Leon, Mexico | ||
371465 | 371465 | 2020-08-08 | Mexico | Oaxaca | 11548 | 1032 | 9603 | 913 | 17.0732 | -96.7266 | 2020-08-09 04:34:54 | Oaxaca, Mexico | ||
371498 | 371498 | 2020-08-08 | Mexico | Puebla | 22086 | 2797 | 17433 | 1856 | 19.0414 | -98.2063 | 2020-08-09 04:34:54 | Puebla, Mexico | ||
371507 | 371507 | 2020-08-08 | Mexico | Queretaro | 4294 | 541 | 3229 | 524 | 20.5888 | -100.3899 | 2020-08-09 04:34:54 | Queretaro, Mexico | ||
371509 | 371509 | 2020-08-08 | Mexico | Quintana Roo | 8609 | 1105 | 6494 | 1010 | 19.1817 | -88.4791 | 2020-08-09 04:34:54 | Quintana Roo, Mexico | ||
371536 | 371536 | 2020-08-08 | Mexico | San Luis Potosi | 11848 | 654 | 8981 | 2213 | 22.1565 | -100.9855 | 2020-08-09 04:34:54 | San Luis Potosi, Mexico | ||
371558 | 371558 | 2020-08-08 | Mexico | Sinaloa | 13729 | 2380 | 10510 | 839 | 25.1721 | -107.4795 | 2020-08-09 04:34:54 | Sinaloa, Mexico | ||
371563 | 371563 | 2020-08-08 | Mexico | Sonora | 18987 | 2277 | 15655 | 1055 | 29.2972 | -110.3309 | 2020-08-09 04:34:54 | Sonora, Mexico | ||
371572 | 371572 | 2020-08-08 | Mexico | Tabasco | 24086 | 2181 | 20099 | 1806 | 17.8409 | -92.6189 | 2020-08-09 04:34:54 | Tabasco, Mexico | ||
371574 | 371574 | 2020-08-08 | Mexico | Tamaulipas | 17903 | 1286 | 15038 | 1579 | 24.2669 | -98.8363 | 2020-08-09 04:34:54 | Tamaulipas, Mexico | ||
371585 | 371585 | 2020-08-08 | Mexico | Tlaxcala | 5064 | 737 | 3828 | 499 | 19.3139 | -98.2404 | 2020-08-09 04:34:54 | Tlaxcala, Mexico | ||
371628 | 371628 | 2020-08-08 | Mexico | Veracruz | 23491 | 3017 | 18162 | 2312 | 19.1738 | -96.1342 | 2020-08-09 04:34:54 | Veracruz, Mexico | ||
371648 | 371648 | 2020-08-08 | Mexico | Yucatan | 11413 | 1013 | 8727 | 1673 | 20.7099 | -89.0943 | 2020-08-09 04:34:54 | Yucatan, Mexico | ||
371652 | 371652 | 2020-08-08 | Mexico | Zacatecas | 3338 | 313 | 2305 | 720 | 22.7709 | -102.5832 | 2020-08-09 04:34:54 | Zacatecas, 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]);