johns_hopkins_csse_daily_reports

⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

1,555 rows where country_or_region = "Mexico" sorted by day descending

View and edit SQL

country_or_region

  • Mexico · 1,555
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
311630 2020-07-04 Mexico Aguascalientes     2438 158 2018 262 21.8853 -102.2916 2020-07-05 04:33:46 Aguascalientes, Mexico
311671 2020-07-04 Mexico Baja California     9780 2055 7085 640 30.8406 -115.2838 2020-07-05 04:33:46 Baja California, Mexico
311672 2020-07-04 Mexico Baja California Sur     1744 86 1335 323 26.0444 -111.6661 2020-07-05 04:33:46 Baja California Sur, Mexico
311700 2020-07-04 Mexico Campeche     2261 239 1816 206 19.8301 -90.5349 2020-07-05 04:33:46 Campeche, Mexico
311722 2020-07-04 Mexico Chiapas     4796 611 3870 315 16.7569 -93.1292 2020-07-05 04:33:46 Chiapas, Mexico
311724 2020-07-04 Mexico Chihuahua     3347 671 2533 143 28.63300000000001 -106.0691 2020-07-05 04:33:46 Chihuahua, Mexico
311729 2020-07-04 Mexico Ciudad de Mexico     51658 6921 40731 4006 19.4326 -99.1332 2020-07-05 04:33:46 Ciudad de Mexico, Mexico
311730 2020-07-04 Mexico Coahuila     5513 257 4083 1173 27.0587 -101.7068 2020-07-05 04:33:46 Coahuila, Mexico
311731 2020-07-04 Mexico Colima     664 85 431 148 19.1223 -104.0072 2020-07-05 04:33:46 Colima, Mexico
311747 2020-07-04 Mexico Durango     2254 157 1553 544 24.5593 -104.6588 2020-07-05 04:33:46 Durango, Mexico
311777 2020-07-04 Mexico Guanajuato     8914 413 6736 1765 21.019 -101.2574 2020-07-05 04:33:46 Guanajuato, Mexico
311781 2020-07-04 Mexico Guerrero     5954 973 4448 533 17.4392 -99.5451 2020-07-05 04:33:46 Guerrero, Mexico
311793 2020-07-04 Mexico Hidalgo     4224 714 3024 486 20.0911 -98.7624 2020-07-05 04:33:46 Hidalgo, Mexico
311814 2020-07-04 Mexico Jalisco     7507 807 5667 1033 20.6595 -103.3494 2020-07-05 04:33:46 Jalisco, Mexico
311899 2020-07-04 Mexico Mexico     37360 4670 30406 2284 19.4969 -99.7233 2020-07-05 04:33:46 Mexico, Mexico
311900 2020-07-04 Mexico Michoacan     6162 491 5333 338 19.5665 -101.7068 2020-07-05 04:33:46 Michoacan, Mexico
311910 2020-07-04 Mexico Morelos     3147 693 2237 217 18.6813 -99.1013 2020-07-05 04:33:46 Morelos, Mexico
311922 2020-07-04 Mexico Nayarit     1959 213 1326 420 21.7514 -104.8455 2020-07-05 04:33:46 Nayarit, Mexico
311944 2020-07-04 Mexico Nuevo Leon     7227 399 5263 1565 25.5922 -99.9962 2020-07-05 04:33:46 Nuevo Leon, Mexico
311946 2020-07-04 Mexico Oaxaca     6128 617 4952 559 17.0732 -96.7266 2020-07-05 04:33:46 Oaxaca, Mexico
311978 2020-07-04 Mexico Puebla     11874 1481 9218 1175 19.0414 -98.2063 2020-07-05 04:33:46 Puebla, Mexico
311988 2020-07-04 Mexico Queretaro     2135 323 1562 250 20.5888 -100.3899 2020-07-05 04:33:46 Queretaro, Mexico
311990 2020-07-04 Mexico Quintana Roo     4196 615 2749 832 19.1817 -88.4791 2020-07-05 04:33:46 Quintana Roo, Mexico
312016 2020-07-04 Mexico San Luis Potosi     3541 172 2657 712 22.1565 -100.9855 2020-07-05 04:33:46 San Luis Potosi, Mexico
312038 2020-07-04 Mexico Sinaloa     8902 1404 7144 354 25.1721 -107.4795 2020-07-05 04:33:46 Sinaloa, Mexico
312043 2020-07-04 Mexico Sonora     9093 830 7617 646 29.2972 -110.3309 2020-07-05 04:33:46 Sonora, Mexico
312052 2020-07-04 Mexico Tabasco     11857 1151 9578 1128 17.8409 -92.6189 2020-07-05 04:33:46 Tabasco, Mexico
312054 2020-07-04 Mexico Tamaulipas     7215 464 5666 1085 24.2669 -98.8363 2020-07-05 04:33:46 Tamaulipas, Mexico
312065 2020-07-04 Mexico Tlaxcala     2809 387 2102 320 19.3139 -98.2404 2020-07-05 04:33:46 Tlaxcala, Mexico
312106 2020-07-04 Mexico Veracruz     11477 1719 8530 1228 19.1738 -96.1342 2020-07-05 04:33:46 Veracruz, Mexico
312126 2020-07-04 Mexico Yucatan     4972 480 3348 1144 20.7099 -89.0943 2020-07-05 04:33:46 Yucatan, Mexico
312130 2020-07-04 Mexico Zacatecas     1057 110 706 241 22.7709 -102.5832 2020-07-05 04:33:46 Zacatecas, Mexico
252064 2020-07-03 Mexico Aguascalientes     2415 156 1975 284 21.8853 -102.2916 2020-07-04 04:33:51 Aguascalientes, Mexico
252105 2020-07-03 Mexico Baja California     9639 2033 6903 703 30.8406 -115.2838 2020-07-04 04:33:51 Baja California, Mexico
252106 2020-07-03 Mexico Baja California Sur     1680 83 1296 301 26.0444 -111.6661 2020-07-04 04:33:51 Baja California Sur, Mexico
252134 2020-07-03 Mexico Campeche     2170 234 1703 233 19.8301 -90.5349 2020-07-04 04:33:51 Campeche, Mexico
252156 2020-07-03 Mexico Chiapas     4681 599 3761 321 16.7569 -93.1292 2020-07-04 04:33:51 Chiapas, Mexico
252158 2020-07-03 Mexico Chihuahua     3265 659 2443 163 28.63300000000001 -106.0691 2020-07-04 04:33:51 Chihuahua, Mexico
252163 2020-07-03 Mexico Ciudad de Mexico     50592 6848 39850 3894 19.4326 -99.1332 2020-07-04 04:33:51 Ciudad de Mexico, Mexico
252164 2020-07-03 Mexico Coahuila     5360 243 3900 1217 27.0587 -101.7068 2020-07-04 04:33:51 Coahuila, Mexico
252165 2020-07-03 Mexico Colima     643 82 408 153 19.1223 -104.0072 2020-07-04 04:33:51 Colima, Mexico
252181 2020-07-03 Mexico Durango     2157 156 1502 499 24.5593 -104.6588 2020-07-04 04:33:51 Durango, Mexico
252211 2020-07-03 Mexico Guanajuato     8465 399 6322 1744 21.019 -101.2574 2020-07-04 04:33:51 Guanajuato, Mexico
252215 2020-07-03 Mexico Guerrero     5767 947 4352 468 17.4392 -99.5451 2020-07-04 04:33:51 Guerrero, Mexico
252227 2020-07-03 Mexico Hidalgo     4169 711 2930 528 20.0911 -98.7624 2020-07-04 04:33:51 Hidalgo, Mexico
252248 2020-07-03 Mexico Jalisco     7261 787 5467 1007 20.6595 -103.3494 2020-07-04 04:33:51 Jalisco, Mexico
252333 2020-07-03 Mexico Mexico     36584 4615 29725 2244 19.4969 -99.7233 2020-07-04 04:33:51 Mexico, Mexico
252334 2020-07-03 Mexico Michoacan     6086 487 5198 401 19.5665 -101.7068 2020-07-04 04:33:51 Michoacan, Mexico
252344 2020-07-03 Mexico Morelos     3108 692 2194 222 18.6813 -99.1013 2020-07-04 04:33:51 Morelos, Mexico
252356 2020-07-03 Mexico Nayarit     1905 212 1281 412 21.7514 -104.8455 2020-07-04 04:33:51 Nayarit, Mexico
252378 2020-07-03 Mexico Nuevo Leon     6843 384 4995 1464 25.5922 -99.9962 2020-07-04 04:33:51 Nuevo Leon, Mexico
252380 2020-07-03 Mexico Oaxaca     5930 608 4735 587 17.0732 -96.7266 2020-07-04 04:33:51 Oaxaca, Mexico
252412 2020-07-03 Mexico Puebla     11557 1458 8790 1309 19.0414 -98.2063 2020-07-04 04:33:51 Puebla, Mexico
252422 2020-07-03 Mexico Queretaro     2084 312 1529 243 20.5888 -100.3899 2020-07-04 04:33:51 Queretaro, Mexico
252424 2020-07-03 Mexico Quintana Roo     4074 608 2626 840 19.1817 -88.4791 2020-07-04 04:33:51 Quintana Roo, Mexico
252450 2020-07-03 Mexico San Luis Potosi     3408 163 2559 686 22.1565 -100.9855 2020-07-04 04:33:51 San Luis Potosi, Mexico
252472 2020-07-03 Mexico Sinaloa     8748 1383 6952 413 25.1721 -107.4795 2020-07-04 04:33:51 Sinaloa, Mexico
252477 2020-07-03 Mexico Sonora     8857 810 7290 757 29.2972 -110.3309 2020-07-04 04:33:51 Sonora, Mexico
252486 2020-07-03 Mexico Tabasco     11444 1118 9229 1097 17.8409 -92.6189 2020-07-04 04:33:51 Tabasco, Mexico
252488 2020-07-03 Mexico Tamaulipas     6955 443 5366 1146 24.2669 -98.8363 2020-07-04 04:33:51 Tamaulipas, Mexico
252499 2020-07-03 Mexico Tlaxcala     2668 374 2023 271 19.3139 -98.2404 2020-07-04 04:33:51 Tlaxcala, Mexico
252540 2020-07-03 Mexico Veracruz     10894 1656 8182 1056 19.1738 -96.1342 2020-07-04 04:33:51 Veracruz, Mexico
252560 2020-07-03 Mexico Yucatan     4841 477 3182 1182 20.7099 -89.0943 2020-07-04 04:33:51 Yucatan, Mexico
252564 2020-07-03 Mexico Zacatecas     1001 106 677 218 22.7709 -102.5832 2020-07-04 04:33:51 Zacatecas, Mexico
203445 2020-07-02 Mexico Aguascalientes     2399 154 1933 312 21.8853 -102.2916 2020-07-03 04:33:54 Aguascalientes, Mexico
203486 2020-07-02 Mexico Baja California     9423 2007 6775 641 30.8406 -115.2838 2020-07-03 04:33:54 Baja California, Mexico
203487 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
203515 2020-07-02 Mexico Campeche     2092 223 1642 227 19.8301 -90.5349 2020-07-03 04:33:54 Campeche, Mexico
203537 2020-07-02 Mexico Chiapas     4649 584 3712 353 16.7569 -93.1292 2020-07-03 04:33:54 Chiapas, Mexico
203539 2020-07-02 Mexico Chihuahua     3211 653 2405 153 28.63300000000001 -106.0691 2020-07-03 04:33:54 Chihuahua, Mexico
203544 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
203545 2020-07-02 Mexico Coahuila     5213 240 3718 1255 27.0587 -101.7068 2020-07-03 04:33:54 Coahuila, Mexico
203546 2020-07-02 Mexico Colima     603 78 386 139 19.1223 -104.0072 2020-07-03 04:33:54 Colima, Mexico
203562 2020-07-02 Mexico Durango     2080 149 1444 487 24.5593 -104.6588 2020-07-03 04:33:54 Durango, Mexico
203592 2020-07-02 Mexico Guanajuato     8062 390 6014 1658 21.019000000000002 -101.2574 2020-07-03 04:33:54 Guanajuato, Mexico
203596 2020-07-02 Mexico Guerrero     5652 913 4268 471 17.4392 -99.5451 2020-07-03 04:33:54 Guerrero, Mexico
203608 2020-07-02 Mexico Hidalgo     4079 698 2896 485 20.0911 -98.7624 2020-07-03 04:33:54 Hidalgo, Mexico
203629 2020-07-02 Mexico Jalisco     7030 762 5332 936 20.6595 -103.3494 2020-07-03 04:33:54 Jalisco, Mexico
203714 2020-07-02 Mexico Mexico     35631 4514 28901 2216 19.4969 -99.7233 2020-07-03 04:33:54 Mexico, Mexico
203715 2020-07-02 Mexico Michoacan     5996 479 5059 458 19.5665 -101.7068 2020-07-03 04:33:54 Michoacan, Mexico
203725 2020-07-02 Mexico Morelos     3032 683 2136 213 18.6813 -99.1013 2020-07-03 04:33:54 Morelos, Mexico
203737 2020-07-02 Mexico Nayarit     1840 209 1228 403 21.7514 -104.8455 2020-07-03 04:33:54 Nayarit, Mexico
203759 2020-07-02 Mexico Nuevo Leon     6656 361 4791 1504 25.5922 -99.9962 2020-07-03 04:33:54 Nuevo Leon, Mexico
203761 2020-07-02 Mexico Oaxaca     5671 601 4494 576 17.0732 -96.7266 2020-07-03 04:33:54 Oaxaca, Mexico
203793 2020-07-02 Mexico Puebla     11161 1406 8336 1419 19.0414 -98.2063 2020-07-03 04:33:54 Puebla, Mexico
203803 2020-07-02 Mexico Queretaro     2052 296 1501 255 20.5888 -100.3899 2020-07-03 04:33:54 Queretaro, Mexico
203805 2020-07-02 Mexico Quintana Roo     3947 605 2539 803 19.1817 -88.4791 2020-07-03 04:33:54 Quintana Roo, Mexico
203831 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
203853 2020-07-02 Mexico Sinaloa     8613 1356 6829 428 25.1721 -107.4795 2020-07-03 04:33:54 Sinaloa, Mexico
203858 2020-07-02 Mexico Sonora     8337 773 6941 623 29.2972 -110.3309 2020-07-03 04:33:54 Sonora, Mexico
203867 2020-07-02 Mexico Tabasco     11165 1097 8960 1108 17.8409 -92.6189 2020-07-03 04:33:54 Tabasco, Mexico
203869 2020-07-02 Mexico Tamaulipas     6553 399 5103 1051 24.2669 -98.8363 2020-07-03 04:33:54 Tamaulipas, Mexico
203880 2020-07-02 Mexico Tlaxcala     2591 367 1949 275 19.3139 -98.2404 2020-07-03 04:33:54 Tlaxcala, Mexico
203922 2020-07-02 Mexico Veracruz     10671 1635 7934 1102 19.1738 -96.1342 2020-07-03 04:33:54 Veracruz, Mexico
203942 2020-07-02 Mexico Yucatan     4601 466 3063 1072 20.7099 -89.0943 2020-07-03 04:33:54 Yucatan, Mexico
203946 2020-07-02 Mexico Zacatecas     973 101 649 223 22.7709 -102.5832 2020-07-03 04:33:54 Zacatecas, Mexico
159686 2020-07-01 Mexico Aguascalientes     2363 151 1877 335 21.8853 -102.2916 2020-07-02 04:33:46 Aguascalientes, Mexico
159727 2020-07-01 Mexico Baja California     9221 1962 6677 582 30.8406 -115.2838 2020-07-02 04:33:46 Baja California, Mexico
159728 2020-07-01 Mexico Baja California Sur     1578 77 1221 280 26.0444 -111.6661 2020-07-02 04:33:46 Baja California Sur, Mexico
159756 2020-07-01 Mexico Campeche     1998 216 1560 222 19.8301 -90.5349 2020-07-02 04:33:46 Campeche, Mexico

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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] INTEGER,
   [latitude] TEXT,
   [longitude] TEXT,
   [last_update] TEXT,
   [combined_key] TEXT
);
Powered by Datasette · Query took 2437.344ms · Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette