johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
32 rows where country_or_region = "Mexico" and "day" is on date 2020-07-02 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3045137 | 3045137 | 2020-07-02 | Mexico | Aguascalientes | 2399 | 154 | 1933 | 312 | 21.8853 | -102.2916 | 2020-07-03 04:33:54 | Aguascalientes, Mexico | ||
3045178 | 3045178 | 2020-07-02 | Mexico | Baja California | 9423 | 2007 | 6775 | 641 | 30.8406 | -115.2838 | 2020-07-03 04:33:54 | Baja California, Mexico | ||
3045179 | 3045179 | 2020-07-02 | Mexico | Baja California Sur | 1631 | 79 | 1266 | 286 | 26.0444 | -111.6661 | 2020-07-03 04:33:54 | Baja California Sur, Mexico | ||
3045207 | 3045207 | 2020-07-02 | Mexico | Campeche | 2092 | 223 | 1642 | 227 | 19.8301 | -90.5349 | 2020-07-03 04:33:54 | Campeche, Mexico | ||
3045229 | 3045229 | 2020-07-02 | Mexico | Chiapas | 4649 | 584 | 3712 | 353 | 16.7569 | -93.1292 | 2020-07-03 04:33:54 | Chiapas, Mexico | ||
3045231 | 3045231 | 2020-07-02 | Mexico | Chihuahua | 3211 | 653 | 2405 | 153 | 28.63300000000001 | -106.0691 | 2020-07-03 04:33:54 | Chihuahua, Mexico | ||
3045236 | 3045236 | 2020-07-02 | Mexico | Ciudad de Mexico | 49573 | 6750 | 39104 | 3719 | 19.4326 | -99.1332 | 2020-07-03 04:33:54 | Ciudad de Mexico, Mexico | ||
3045237 | 3045237 | 2020-07-02 | Mexico | Coahuila | 5213 | 240 | 3718 | 1255 | 27.0587 | -101.7068 | 2020-07-03 04:33:54 | Coahuila, Mexico | ||
3045238 | 3045238 | 2020-07-02 | Mexico | Colima | 603 | 78 | 386 | 139 | 19.1223 | -104.0072 | 2020-07-03 04:33:54 | Colima, Mexico | ||
3045254 | 3045254 | 2020-07-02 | Mexico | Durango | 2080 | 149 | 1444 | 487 | 24.5593 | -104.6588 | 2020-07-03 04:33:54 | Durango, Mexico | ||
3045284 | 3045284 | 2020-07-02 | Mexico | Guanajuato | 8062 | 390 | 6014 | 1658 | 21.019000000000002 | -101.2574 | 2020-07-03 04:33:54 | Guanajuato, Mexico | ||
3045288 | 3045288 | 2020-07-02 | Mexico | Guerrero | 5652 | 913 | 4268 | 471 | 17.4392 | -99.5451 | 2020-07-03 04:33:54 | Guerrero, Mexico | ||
3045300 | 3045300 | 2020-07-02 | Mexico | Hidalgo | 4079 | 698 | 2896 | 485 | 20.0911 | -98.7624 | 2020-07-03 04:33:54 | Hidalgo, Mexico | ||
3045321 | 3045321 | 2020-07-02 | Mexico | Jalisco | 7030 | 762 | 5332 | 936 | 20.6595 | -103.3494 | 2020-07-03 04:33:54 | Jalisco, Mexico | ||
3045406 | 3045406 | 2020-07-02 | Mexico | Mexico | 35631 | 4514 | 28901 | 2216 | 19.4969 | -99.7233 | 2020-07-03 04:33:54 | Mexico, Mexico | ||
3045407 | 3045407 | 2020-07-02 | Mexico | Michoacan | 5996 | 479 | 5059 | 458 | 19.5665 | -101.7068 | 2020-07-03 04:33:54 | Michoacan, Mexico | ||
3045417 | 3045417 | 2020-07-02 | Mexico | Morelos | 3032 | 683 | 2136 | 213 | 18.6813 | -99.1013 | 2020-07-03 04:33:54 | Morelos, Mexico | ||
3045429 | 3045429 | 2020-07-02 | Mexico | Nayarit | 1840 | 209 | 1228 | 403 | 21.7514 | -104.8455 | 2020-07-03 04:33:54 | Nayarit, Mexico | ||
3045452 | 3045452 | 2020-07-02 | Mexico | Nuevo Leon | 6656 | 361 | 4791 | 1504 | 25.5922 | -99.9962 | 2020-07-03 04:33:54 | Nuevo Leon, Mexico | ||
3045454 | 3045454 | 2020-07-02 | Mexico | Oaxaca | 5671 | 601 | 4494 | 576 | 17.0732 | -96.7266 | 2020-07-03 04:33:54 | Oaxaca, Mexico | ||
3045486 | 3045486 | 2020-07-02 | Mexico | Puebla | 11161 | 1406 | 8336 | 1419 | 19.0414 | -98.2063 | 2020-07-03 04:33:54 | Puebla, Mexico | ||
3045496 | 3045496 | 2020-07-02 | Mexico | Queretaro | 2052 | 296 | 1501 | 255 | 20.5888 | -100.3899 | 2020-07-03 04:33:54 | Queretaro, Mexico | ||
3045498 | 3045498 | 2020-07-02 | Mexico | Quintana Roo | 3947 | 605 | 2539 | 803 | 19.1817 | -88.4791 | 2020-07-03 04:33:54 | Quintana Roo, Mexico | ||
3045525 | 3045525 | 2020-07-02 | Mexico | San Luis Potosi | 3324 | 161 | 2449 | 714 | 22.1565 | -100.9855 | 2020-07-03 04:33:54 | San Luis Potosi, Mexico | ||
3045547 | 3045547 | 2020-07-02 | Mexico | Sinaloa | 8613 | 1356 | 6829 | 428 | 25.1721 | -107.4795 | 2020-07-03 04:33:54 | Sinaloa, Mexico | ||
3045552 | 3045552 | 2020-07-02 | Mexico | Sonora | 8337 | 773 | 6941 | 623 | 29.2972 | -110.3309 | 2020-07-03 04:33:54 | Sonora, Mexico | ||
3045561 | 3045561 | 2020-07-02 | Mexico | Tabasco | 11165 | 1097 | 8960 | 1108 | 17.8409 | -92.6189 | 2020-07-03 04:33:54 | Tabasco, Mexico | ||
3045563 | 3045563 | 2020-07-02 | Mexico | Tamaulipas | 6553 | 399 | 5103 | 1051 | 24.2669 | -98.8363 | 2020-07-03 04:33:54 | Tamaulipas, Mexico | ||
3045574 | 3045574 | 2020-07-02 | Mexico | Tlaxcala | 2591 | 367 | 1949 | 275 | 19.3139 | -98.2404 | 2020-07-03 04:33:54 | Tlaxcala, Mexico | ||
3045616 | 3045616 | 2020-07-02 | Mexico | Veracruz | 10671 | 1635 | 7934 | 1102 | 19.1738 | -96.1342 | 2020-07-03 04:33:54 | Veracruz, Mexico | ||
3045636 | 3045636 | 2020-07-02 | Mexico | Yucatan | 4601 | 466 | 3063 | 1072 | 20.7099 | -89.0943 | 2020-07-03 04:33:54 | Yucatan, Mexico | ||
3045640 | 3045640 | 2020-07-02 | Mexico | Zacatecas | 973 | 101 | 649 | 223 | 22.7709 | -102.5832 | 2020-07-03 04:33: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]);