⚠️ 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

8,091 rows where country_or_region = "Mexico" sorted by day descending

View and edit SQL

Suggested facets: day (date), last_update (date)

country_or_region

  • Mexico · 8,091
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
89755 2021-01-22 Mexico Aguascalientes     19445 1558 0 17887 21.8853 -102.2916 2021-01-23 05:22:03 Aguascalientes, Mexico
89756 2021-01-22 Mexico Baja California     40325 6511 0 33814 30.8406 -115.2838 2021-01-23 05:22:03 Baja California, Mexico
89757 2021-01-22 Mexico Baja California Sur     21795 886 0 20909 26.0444 -111.6661 2021-01-23 05:22:03 Baja California Sur, Mexico
89758 2021-01-22 Mexico Campeche     7718 997 0 6721 19.8301 -90.5349 2021-01-23 05:22:03 Campeche, Mexico
89759 2021-01-22 Mexico Chiapas     8985 1279 0 7706 16.7569 -93.1292 2021-01-23 05:22:03 Chiapas, Mexico
89760 2021-01-22 Mexico Chihuahua     39271 4784 0 34487 28.633000000000006 -106.0691 2021-01-23 05:22:03 Chihuahua, Mexico
89761 2021-01-22 Mexico Ciudad de Mexico     439547 20517 0 419030 19.4326 -99.1332 2021-01-23 05:22:03 Ciudad de Mexico, Mexico
89762 2021-01-22 Mexico Coahuila     57183 4929 0 52254 27.0587 -101.7068 2021-01-23 05:22:03 Coahuila, Mexico
89763 2021-01-22 Mexico Colima     8953 862 0 8091 19.1223 -104.0072 2021-01-23 05:22:03 Colima, Mexico
89764 2021-01-22 Mexico Durango     27780 1789 0 25991 24.5593 -104.6588 2021-01-23 05:22:03 Durango, Mexico
89765 2021-01-22 Mexico Guanajuato     100177 6613 0 93564 21.019 -101.2574 2021-01-23 05:22:03 Guanajuato, Mexico
89766 2021-01-22 Mexico Guerrero     29406 2939 0 26467 17.4392 -99.5451 2021-01-23 05:22:03 Guerrero, Mexico
89767 2021-01-22 Mexico Hidalgo     29756 4235 0 25521 20.0911 -98.7624 2021-01-23 05:22:03 Hidalgo, Mexico
89768 2021-01-22 Mexico Jalisco     64072 7663 0 56409 20.6595 -103.3494 2021-01-23 05:22:03 Jalisco, Mexico
89769 2021-01-22 Mexico Mexico     178259 22657 0 155602 19.4969 -99.7233 2021-01-23 05:22:03 Mexico, Mexico
89770 2021-01-22 Mexico Michoacan     38043 3269 0 34774 19.5665 -101.7068 2021-01-23 05:22:03 Michoacan, Mexico
89771 2021-01-22 Mexico Morelos     15625 1699 0 13926 18.6813 -99.1013 2021-01-23 05:22:03 Morelos, Mexico
89772 2021-01-22 Mexico Nayarit     9234 1205 0 8029 21.7514 -104.8455 2021-01-23 05:22:03 Nayarit, Mexico
89773 2021-01-22 Mexico Nuevo Leon     99023 6111 0 92912 25.5922 -99.9962 2021-01-23 05:22:03 Nuevo Leon, Mexico
89774 2021-01-22 Mexico Oaxaca     32924 2383 0 30541 17.0732 -96.7266 2021-01-23 05:22:03 Oaxaca, Mexico
89775 2021-01-22 Mexico Puebla     57063 6622 0 50441 19.0414 -98.2063 2021-01-23 05:22:03 Puebla, Mexico
89776 2021-01-22 Mexico Queretaro     41641 2527 0 39114 20.5888 -100.3899 2021-01-23 05:22:03 Queretaro, Mexico
89777 2021-01-22 Mexico Quintana Roo     17807 2185 0 15622 19.1817 -88.4791 2021-01-23 05:22:03 Quintana Roo, Mexico
89778 2021-01-22 Mexico San Luis Potosi     47269 3540 0 43729 22.1565 -100.9855 2021-01-23 05:22:03 San Luis Potosi, Mexico
89779 2021-01-22 Mexico Sinaloa     29819 4530 0 25289 25.1721 -107.4795 2021-01-23 05:22:03 Sinaloa, Mexico
89780 2021-01-22 Mexico Sonora     59929 5055 0 54874 29.2972 -110.3309 2021-01-23 05:22:03 Sonora, Mexico
89781 2021-01-22 Mexico Tabasco     50309 3394 0 46915 17.8409 -92.6189 2021-01-23 05:22:03 Tabasco, Mexico
89782 2021-01-22 Mexico Tamaulipas     45763 3696 0 42067 24.2669 -98.8363 2021-01-23 05:22:03 Tamaulipas, Mexico
89783 2021-01-22 Mexico Tlaxcala     13805 1707 0 12098 19.3139 -98.2404 2021-01-23 05:22:03 Tlaxcala, Mexico
89784 2021-01-22 Mexico Unknown     0 0 1291940 -1291940     2021-01-23 05:22:03 Unknown, Mexico
89785 2021-01-22 Mexico Veracruz     48360 6887 0 41473 19.1738 -96.1342 2021-01-23 05:22:03 Veracruz, Mexico
89786 2021-01-22 Mexico Yucatan     29078 2587 0 26491 20.7099 -89.0943 2021-01-23 05:22:03 Yucatan, Mexico
89787 2021-01-22 Mexico Zacatecas     23926 1998 0 21928 22.7709 -102.5832 2021-01-23 05:22:03 Zacatecas, Mexico
302661 2021-01-21 Mexico Aguascalientes     19217 1543 0 17471 21.8853 -102.2916 2021-01-22 05:22:10 Aguascalientes, Mexico
302662 2021-01-21 Mexico Baja California     39917 6468 0 33148 30.8406 -115.2838 2021-01-22 05:22:10 Baja California, Mexico
302663 2021-01-21 Mexico Baja California Sur     21516 875 0 20412 26.0444 -111.6661 2021-01-22 05:22:10 Baja California Sur, Mexico
302664 2021-01-21 Mexico Campeche     7682 996 0 6650 19.8301 -90.5349 2021-01-22 05:22:10 Campeche, Mexico
302665 2021-01-21 Mexico Chiapas     8944 1277 0 7596 16.7569 -93.1292 2021-01-22 05:22:10 Chiapas, Mexico
302666 2021-01-21 Mexico Chihuahua     38985 4761 0 34056 28.633000000000006 -106.0691 2021-01-22 05:22:10 Chihuahua, Mexico
302667 2021-01-21 Mexico Ciudad de Mexico     432631 20298 0 404638 19.4326 -99.1332 2021-01-22 05:22:10 Ciudad de Mexico, Mexico
302668 2021-01-21 Mexico Coahuila     56620 4878 0 51365 27.0587 -101.7068 2021-01-22 05:22:10 Coahuila, Mexico
302669 2021-01-21 Mexico Colima     8841 858 0 7921 19.1223 -104.0072 2021-01-22 05:22:10 Colima, Mexico
302670 2021-01-21 Mexico Durango     27624 1781 0 25656 24.5593 -104.6588 2021-01-22 05:22:10 Durango, Mexico
302671 2021-01-21 Mexico Guanajuato     99098 6522 0 91347 21.019 -101.2574 2021-01-22 05:22:10 Guanajuato, Mexico
302672 2021-01-21 Mexico Guerrero     29163 2923 0 25869 17.4392 -99.5451 2021-01-22 05:22:10 Guerrero, Mexico
302673 2021-01-21 Mexico Hidalgo     29483 4183 0 25021 20.0911 -98.7624 2021-01-22 05:22:10 Hidalgo, Mexico
302674 2021-01-21 Mexico Jalisco     63256 7557 0 54878 20.6595 -103.3494 2021-01-22 05:22:10 Jalisco, Mexico
302675 2021-01-21 Mexico Mexico     175900 22421 0 151355 19.4969 -99.7233 2021-01-22 05:22:10 Mexico, Mexico
302676 2021-01-21 Mexico Michoacan     37830 3219 0 34456 19.5665 -101.7068 2021-01-22 05:22:10 Michoacan, Mexico
302677 2021-01-21 Mexico Morelos     15179 1692 0 13166 18.6813 -99.1013 2021-01-22 05:22:10 Morelos, Mexico
302678 2021-01-21 Mexico Nayarit     9159 1189 0 7874 21.7514 -104.8455 2021-01-22 05:22:10 Nayarit, Mexico
302679 2021-01-21 Mexico Nuevo Leon     97667 6012 0 90501 25.5922 -99.9962 2021-01-22 05:22:10 Nuevo Leon, Mexico
302680 2021-01-21 Mexico Oaxaca     32540 2363 0 29869 17.0732 -96.7266 2021-01-22 05:22:10 Oaxaca, Mexico
302681 2021-01-21 Mexico Puebla     56318 6566 0 49110 19.0414 -98.2063 2021-01-22 05:22:10 Puebla, Mexico
302682 2021-01-21 Mexico Queretaro     40671 2475 0 37352 20.5888 -100.3899 2021-01-22 05:22:10 Queretaro, Mexico
302683 2021-01-21 Mexico Quintana Roo     17625 2178 0 15262 19.1817 -88.4791 2021-01-22 05:22:10 Quintana Roo, Mexico
302684 2021-01-21 Mexico San Luis Potosi     46753 3506 0 42749 22.1565 -100.9855 2021-01-22 05:22:10 San Luis Potosi, Mexico
302685 2021-01-21 Mexico Sinaloa     29604 4514 0 24927 25.1721 -107.4795 2021-01-22 05:22:10 Sinaloa, Mexico
302686 2021-01-21 Mexico Sonora     59440 4977 0 53996 29.2972 -110.3309 2021-01-22 05:22:10 Sonora, Mexico
302687 2021-01-21 Mexico Tabasco     50035 3381 0 46396 17.8409 -92.6189 2021-01-22 05:22:10 Tabasco, Mexico
302688 2021-01-21 Mexico Tamaulipas     45338 3669 0 41197 24.2669 -98.8363 2021-01-22 05:22:10 Tamaulipas, Mexico
302689 2021-01-21 Mexico Tlaxcala     13715 1681 0 11871 19.3139 -98.2404 2021-01-22 05:22:10 Tlaxcala, Mexico
302690 2021-01-21 Mexico Unknown     0 0 1264780 -1264780     2021-01-22 05:22:10 Unknown, Mexico
302691 2021-01-21 Mexico Veracruz     47868 6841 0 40700 19.1738 -96.1342 2021-01-22 05:22:10 Veracruz, Mexico
302692 2021-01-21 Mexico Yucatan     28879 2577 0 26145 20.7099 -89.0943 2021-01-22 05:22:10 Yucatan, Mexico
302693 2021-01-21 Mexico Zacatecas     23785 1993 0 21619 22.7709 -102.5832 2021-01-22 05:22:10 Zacatecas, Mexico
893713 2021-01-20 Mexico Aguascalientes     19001 1530 0 17471 21.8853 -102.2916 2021-01-21 05:22:01 Aguascalientes, Mexico
893714 2021-01-20 Mexico Baja California     39561 6413 0 33148 30.8406 -115.2838 2021-01-21 05:22:01 Baja California, Mexico
893715 2021-01-20 Mexico Baja California Sur     21274 862 0 20412 26.0444 -111.6661 2021-01-21 05:22:01 Baja California Sur, Mexico
893716 2021-01-20 Mexico Campeche     7643 993 0 6650 19.8301 -90.5349 2021-01-21 05:22:01 Campeche, Mexico
893717 2021-01-20 Mexico Chiapas     8869 1273 0 7596 16.7569 -93.1292 2021-01-21 05:22:01 Chiapas, Mexico
893718 2021-01-20 Mexico Chihuahua     38795 4739 0 34056 28.633000000000006 -106.0691 2021-01-21 05:22:01 Chihuahua, Mexico
893719 2021-01-20 Mexico Ciudad de Mexico     424666 20028 0 404638 19.4326 -99.1332 2021-01-21 05:22:01 Ciudad de Mexico, Mexico
893720 2021-01-20 Mexico Coahuila     56193 4828 0 51365 27.0587 -101.7068 2021-01-21 05:22:01 Coahuila, Mexico
893721 2021-01-20 Mexico Colima     8770 849 0 7921 19.1223 -104.0072 2021-01-21 05:22:01 Colima, Mexico
893722 2021-01-20 Mexico Durango     27433 1777 0 25656 24.5593 -104.6588 2021-01-21 05:22:01 Durango, Mexico
893723 2021-01-20 Mexico Guanajuato     97793 6446 0 91347 21.019 -101.2574 2021-01-21 05:22:01 Guanajuato, Mexico
893724 2021-01-20 Mexico Guerrero     28772 2903 0 25869 17.4392 -99.5451 2021-01-21 05:22:01 Guerrero, Mexico
893725 2021-01-20 Mexico Hidalgo     29139 4118 0 25021 20.0911 -98.7624 2021-01-21 05:22:01 Hidalgo, Mexico
893726 2021-01-20 Mexico Jalisco     62279 7401 0 54878 20.6595 -103.3494 2021-01-21 05:22:01 Jalisco, Mexico
893727 2021-01-20 Mexico Mexico     173452 22097 0 151355 19.4969 -99.7233 2021-01-21 05:22:01 Mexico, Mexico
893728 2021-01-20 Mexico Michoacan     37638 3182 0 34456 19.5665 -101.7068 2021-01-21 05:22:01 Michoacan, Mexico
893729 2021-01-20 Mexico Morelos     14831 1665 0 13166 18.6813 -99.1013 2021-01-21 05:22:01 Morelos, Mexico
893730 2021-01-20 Mexico Nayarit     9053 1179 0 7874 21.7514 -104.8455 2021-01-21 05:22:01 Nayarit, Mexico
893731 2021-01-20 Mexico Nuevo Leon     96418 5917 0 90501 25.5922 -99.9962 2021-01-21 05:22:01 Nuevo Leon, Mexico
893732 2021-01-20 Mexico Oaxaca     32210 2341 0 29869 17.0732 -96.7266 2021-01-21 05:22:01 Oaxaca, Mexico
893733 2021-01-20 Mexico Puebla     55585 6475 0 49110 19.0414 -98.2063 2021-01-21 05:22:01 Puebla, Mexico
893734 2021-01-20 Mexico Queretaro     39800 2448 0 37352 20.5888 -100.3899 2021-01-21 05:22:01 Queretaro, Mexico
893735 2021-01-20 Mexico Quintana Roo     17426 2164 0 15262 19.1817 -88.4791 2021-01-21 05:22:01 Quintana Roo, Mexico
893736 2021-01-20 Mexico San Luis Potosi     46230 3481 0 42749 22.1565 -100.9855 2021-01-21 05:22:01 San Luis Potosi, Mexico
893737 2021-01-20 Mexico Sinaloa     29400 4473 0 24927 25.1721 -107.4795 2021-01-21 05:22:01 Sinaloa, Mexico
893738 2021-01-20 Mexico Sonora     58806 4810 0 53996 29.2972 -110.3309 2021-01-21 05:22:01 Sonora, Mexico
893739 2021-01-20 Mexico Tabasco     49766 3370 0 46396 17.8409 -92.6189 2021-01-21 05:22:01 Tabasco, Mexico
893740 2021-01-20 Mexico Tamaulipas     44809 3612 0 41197 24.2669 -98.8363 2021-01-21 05:22:01 Tamaulipas, Mexico
893741 2021-01-20 Mexico Tlaxcala     13524 1653 0 11871 19.3139 -98.2404 2021-01-21 05:22:01 Tlaxcala, Mexico
893742 2021-01-20 Mexico Unknown     0 0 1264780 -1264780     2021-01-21 05:22:01 Unknown, Mexico
893743 2021-01-20 Mexico Veracruz     47497 6797 0 40700 19.1738 -96.1342 2021-01-21 05:22:01 Veracruz, Mexico
893744 2021-01-20 Mexico Yucatan     28714 2569 0 26145 20.7099 -89.0943 2021-01-21 05:22:01 Yucatan, Mexico
893745 2021-01-20 Mexico Zacatecas     23597 1978 0 21619 22.7709 -102.5832 2021-01-21 05:22:01 Zacatecas, Mexico
322280 2021-01-19 Mexico Aguascalientes     18739 1521 0 17218 21.8853 -102.2916 2021-01-20 05:21:54 Aguascalientes, 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
);
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]);