johns_hopkins_csse_daily_reports

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

9,444 rows where country_or_region = "Mexico" sorted by day descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

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

country_or_region

  • Mexico · 9,444 ✖
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
900757 900757 2021-03-04 Mexico Aguascalientes     23339 2031 0 21308 21.8853 -102.2916 2021-03-05 05:26:29 Aguascalientes, Mexico
900758 900758 2021-03-04 Mexico Baja California     45225 7466 0 37759 30.8406 -115.2838 2021-03-05 05:26:29 Baja California, Mexico
900759 900759 2021-03-04 Mexico Baja California Sur     26657 1216 0 25441 26.0444 -111.6661 2021-03-05 05:26:29 Baja California Sur, Mexico
900760 900760 2021-03-04 Mexico Campeche     8556 1066 0 7490 19.8301 -90.5349 2021-03-05 05:26:29 Campeche, Mexico
900761 900761 2021-03-04 Mexico Chiapas     10062 1440 0 8622 16.7569 -93.1292 2021-03-05 05:26:29 Chiapas, Mexico
900762 900762 2021-03-04 Mexico Chihuahua     43604 5297 0 38307 28.633000000000006 -106.0691 2021-03-05 05:26:29 Chihuahua, Mexico
900763 900763 2021-03-04 Mexico Ciudad de Mexico     565417 27909 0 537508 19.4326 -99.1332 2021-03-05 05:26:29 Ciudad de Mexico, Mexico
900764 900764 2021-03-04 Mexico Coahuila     65139 5705 0 59434 27.0587 -101.7068 2021-03-05 05:26:29 Coahuila, Mexico
900765 900765 2021-03-04 Mexico Colima     10467 1092 0 9375 19.1223 -104.0072 2021-03-05 05:26:29 Colima, Mexico
900766 900766 2021-03-04 Mexico Durango     31099 2107 0 28992 24.5593 -104.6588 2021-03-05 05:26:29 Durango, Mexico
900767 900767 2021-03-04 Mexico Guanajuato     120636 9230 0 111406 21.019 -101.2574 2021-03-05 05:26:29 Guanajuato, Mexico
900768 900768 2021-03-04 Mexico Guerrero     35702 3701 0 32001 17.4392 -99.5451 2021-03-05 05:26:29 Guerrero, Mexico
900769 900769 2021-03-04 Mexico Hidalgo     34922 5534 0 29388 20.0911 -98.7624 2021-03-05 05:26:29 Hidalgo, Mexico
900770 900770 2021-03-04 Mexico Jalisco     78948 10636 0 68312 20.6595 -103.3494 2021-03-05 05:26:29 Jalisco, Mexico
900771 900771 2021-03-04 Mexico Mexico     219888 29223 0 190665 19.4969 -99.7233 2021-03-05 05:26:29 Mexico, Mexico
900772 900772 2021-03-04 Mexico Michoacan     43462 4547 0 38915 19.5665 -101.7068 2021-03-05 05:26:29 Michoacan, Mexico
900773 900773 2021-03-04 Mexico Morelos     26964 2397 0 24567 18.6813 -99.1013 2021-03-05 05:26:29 Morelos, Mexico
900774 900774 2021-03-04 Mexico Nayarit     10924 1645 0 9279 21.7514 -104.8455 2021-03-05 05:26:29 Nayarit, Mexico
900775 900775 2021-03-04 Mexico Nuevo Leon     116161 8422 0 107739 25.5922 -99.9962 2021-03-05 05:26:29 Nuevo Leon, Mexico
900776 900776 2021-03-04 Mexico Oaxaca     41146 2960 0 38186 17.0732 -96.7266 2021-03-05 05:26:29 Oaxaca, Mexico
900777 900777 2021-03-04 Mexico Puebla     72053 9119 0 62934 19.0414 -98.2063 2021-03-05 05:26:29 Puebla, Mexico
900778 900778 2021-03-04 Mexico Queretaro     58033 3461 0 54572 20.5888 -100.3899 2021-03-05 05:26:29 Queretaro, Mexico
900779 900779 2021-03-04 Mexico Quintana Roo     20309 2411 0 17898 19.1817 -88.4791 2021-03-05 05:26:29 Quintana Roo, Mexico
900780 900780 2021-03-04 Mexico San Luis Potosi     57763 4626 0 53137 22.1565 -100.9855 2021-03-05 05:26:29 San Luis Potosi, Mexico
900781 900781 2021-03-04 Mexico Sinaloa     34284 5328 0 28956 25.1721 -107.4795 2021-03-05 05:26:29 Sinaloa, Mexico
900782 900782 2021-03-04 Mexico Sonora     68182 6078 0 62104 29.2972 -110.3309 2021-03-05 05:26:29 Sonora, Mexico
900783 900783 2021-03-04 Mexico Tabasco     57904 3739 0 54165 17.8409 -92.6189 2021-03-05 05:26:29 Tabasco, Mexico
900784 900784 2021-03-04 Mexico Tamaulipas     52064 4409 0 47655 24.2669 -98.8363 2021-03-05 05:26:29 Tamaulipas, Mexico
900785 900785 2021-03-04 Mexico Tlaxcala     17352 2170 0 15182 19.3139 -98.2404 2021-03-05 05:26:29 Tlaxcala, Mexico
900786 900786 2021-03-04 Mexico Unknown     0 0 1655549 -1655549     2021-03-05 05:26:29 Unknown, Mexico
900787 900787 2021-03-04 Mexico Veracruz     55495 8251 0 47244 19.1738 -96.1342 2021-03-05 05:26:29 Veracruz, Mexico
900788 900788 2021-03-04 Mexico Yucatan     33061 3129 0 29932 20.7099 -89.0943 2021-03-05 05:26:29 Yucatan, Mexico
900789 900789 2021-03-04 Mexico Zacatecas     27690 2521 0 25169 22.7709 -102.5832 2021-03-05 05:26:29 Zacatecas, Mexico
908482 908482 2021-03-03 Mexico Aguascalientes     23273 2025 0 21248 21.8853 -102.2916 2021-03-04 05:24:24 Aguascalientes, Mexico
908483 908483 2021-03-03 Mexico Baja California     45149 7454 0 37695 30.8406 -115.2838 2021-03-04 05:24:24 Baja California, Mexico
908484 908484 2021-03-03 Mexico Baja California Sur     26599 1207 0 25392 26.0444 -111.6661 2021-03-04 05:24:24 Baja California Sur, Mexico
908485 908485 2021-03-03 Mexico Campeche     8542 1065 0 7477 19.8301 -90.5349 2021-03-04 05:24:24 Campeche, Mexico
908486 908486 2021-03-03 Mexico Chiapas     10040 1439 0 8601 16.7569 -93.1292 2021-03-04 05:24:24 Chiapas, Mexico
908487 908487 2021-03-03 Mexico Chihuahua     43475 5282 0 38193 28.633000000000006 -106.0691 2021-03-04 05:24:24 Chihuahua, Mexico
908488 908488 2021-03-03 Mexico Ciudad de Mexico     562559 27711 0 534848 19.4326 -99.1332 2021-03-04 05:24:24 Ciudad de Mexico, Mexico
908489 908489 2021-03-03 Mexico Coahuila     65048 5703 0 59345 27.0587 -101.7068 2021-03-04 05:24:24 Coahuila, Mexico
908490 908490 2021-03-03 Mexico Colima     10447 1088 0 9359 19.1223 -104.0072 2021-03-04 05:24:24 Colima, Mexico
908491 908491 2021-03-03 Mexico Durango     31026 2104 0 28922 24.5593 -104.6588 2021-03-04 05:24:24 Durango, Mexico
908492 908492 2021-03-03 Mexico Guanajuato     120295 9179 0 111116 21.019 -101.2574 2021-03-04 05:24:24 Guanajuato, Mexico
908493 908493 2021-03-03 Mexico Guerrero     35561 3687 0 31874 17.4392 -99.5451 2021-03-04 05:24:24 Guerrero, Mexico
908494 908494 2021-03-03 Mexico Hidalgo     34809 5507 0 29302 20.0911 -98.7624 2021-03-04 05:24:24 Hidalgo, Mexico
908495 908495 2021-03-03 Mexico Jalisco     78719 10599 0 68120 20.6595 -103.3494 2021-03-04 05:24:24 Jalisco, Mexico
908496 908496 2021-03-03 Mexico Mexico     218962 29068 0 189894 19.4969 -99.7233 2021-03-04 05:24:24 Mexico, Mexico
908497 908497 2021-03-03 Mexico Michoacan     43385 4527 0 38858 19.5665 -101.7068 2021-03-04 05:24:24 Michoacan, Mexico
908498 908498 2021-03-03 Mexico Morelos     26848 2386 0 24462 18.6813 -99.1013 2021-03-04 05:24:24 Morelos, Mexico
908499 908499 2021-03-03 Mexico Nayarit     10906 1641 0 9265 21.7514 -104.8455 2021-03-04 05:24:24 Nayarit, Mexico
908500 908500 2021-03-03 Mexico Nuevo Leon     115858 8397 0 107461 25.5922 -99.9962 2021-03-04 05:24:24 Nuevo Leon, Mexico
908501 908501 2021-03-03 Mexico Oaxaca     41045 2953 0 38092 17.0732 -96.7266 2021-03-04 05:24:24 Oaxaca, Mexico
908502 908502 2021-03-03 Mexico Puebla     71730 9018 0 62712 19.0414 -98.2063 2021-03-04 05:24:24 Puebla, Mexico
908503 908503 2021-03-03 Mexico Queretaro     57671 3445 0 54226 20.5888 -100.3899 2021-03-04 05:24:24 Queretaro, Mexico
908504 908504 2021-03-03 Mexico Quintana Roo     20270 2410 0 17860 19.1817 -88.4791 2021-03-04 05:24:24 Quintana Roo, Mexico
908505 908505 2021-03-03 Mexico San Luis Potosi     57611 4613 0 52998 22.1565 -100.9855 2021-03-04 05:24:24 San Luis Potosi, Mexico
908506 908506 2021-03-03 Mexico Sinaloa     34183 5313 0 28870 25.1721 -107.4795 2021-03-04 05:24:24 Sinaloa, Mexico
908507 908507 2021-03-03 Mexico Sonora     68039 6069 0 61970 29.2972 -110.3309 2021-03-04 05:24:24 Sonora, Mexico
908508 908508 2021-03-03 Mexico Tabasco     57731 3736 0 53995 17.8409 -92.6189 2021-03-04 05:24:24 Tabasco, Mexico
908509 908509 2021-03-03 Mexico Tamaulipas     51944 4399 0 47545 24.2669 -98.8363 2021-03-04 05:24:24 Tamaulipas, Mexico
908510 908510 2021-03-03 Mexico Tlaxcala     17308 2167 0 15141 19.3139 -98.2404 2021-03-04 05:24:24 Tlaxcala, Mexico
908511 908511 2021-03-03 Mexico Unknown     0 0 1650230 -1650230     2021-03-04 05:24:24 Unknown, Mexico
908512 908512 2021-03-03 Mexico Veracruz     55394 8223 0 47171 19.1738 -96.1342 2021-03-04 05:24:24 Veracruz, Mexico
908513 908513 2021-03-03 Mexico Yucatan     32937 3120 0 29817 20.7099 -89.0943 2021-03-04 05:24:24 Yucatan, Mexico
908514 908514 2021-03-03 Mexico Zacatecas     27623 2509 0 25114 22.7709 -102.5832 2021-03-04 05:24:24 Zacatecas, Mexico
66882 66882 2021-03-02 Mexico Aguascalientes     23179 2008 0 21171 21.8853 -102.2916 2021-03-03 05:23:28 Aguascalientes, Mexico
66883 66883 2021-03-02 Mexico Baja California     45040 7433 0 37607 30.8406 -115.2838 2021-03-03 05:23:28 Baja California, Mexico
66884 66884 2021-03-02 Mexico Baja California Sur     26537 1204 0 25333 26.0444 -111.6661 2021-03-03 05:23:28 Baja California Sur, Mexico
66885 66885 2021-03-02 Mexico Campeche     8517 1064 0 7453 19.8301 -90.5349 2021-03-03 05:23:28 Campeche, Mexico
66886 66886 2021-03-02 Mexico Chiapas     10020 1436 0 8584 16.7569 -93.1292 2021-03-03 05:23:28 Chiapas, Mexico
66887 66887 2021-03-02 Mexico Chihuahua     43359 5266 0 38093 28.633000000000006 -106.0691 2021-03-03 05:23:28 Chihuahua, Mexico
66888 66888 2021-03-02 Mexico Ciudad de Mexico     559842 27560 0 532282 19.4326 -99.1332 2021-03-03 05:23:28 Ciudad de Mexico, Mexico
66889 66889 2021-03-02 Mexico Coahuila     64936 5689 0 59247 27.0587 -101.7068 2021-03-03 05:23:28 Coahuila, Mexico
66890 66890 2021-03-02 Mexico Colima     10421 1084 0 9337 19.1223 -104.0072 2021-03-03 05:23:28 Colima, Mexico
66891 66891 2021-03-02 Mexico Durango     30976 2095 0 28881 24.5593 -104.6588 2021-03-03 05:23:28 Durango, Mexico
66892 66892 2021-03-02 Mexico Guanajuato     119841 9124 0 110717 21.019 -101.2574 2021-03-03 05:23:28 Guanajuato, Mexico
66893 66893 2021-03-02 Mexico Guerrero     35439 3665 0 31774 17.4392 -99.5451 2021-03-03 05:23:28 Guerrero, Mexico
66894 66894 2021-03-02 Mexico Hidalgo     34675 5487 0 29188 20.0911 -98.7624 2021-03-03 05:23:28 Hidalgo, Mexico
66895 66895 2021-03-02 Mexico Jalisco     78491 10571 0 67920 20.6595 -103.3494 2021-03-03 05:23:28 Jalisco, Mexico
66896 66896 2021-03-02 Mexico Mexico     218073 28952 0 189121 19.4969 -99.7233 2021-03-03 05:23:28 Mexico, Mexico
66897 66897 2021-03-02 Mexico Michoacan     43293 4508 0 38785 19.5665 -101.7068 2021-03-03 05:23:28 Michoacan, Mexico
66898 66898 2021-03-02 Mexico Morelos     26541 2352 0 24189 18.6813 -99.1013 2021-03-03 05:23:28 Morelos, Mexico
66899 66899 2021-03-02 Mexico Nayarit     10881 1629 0 9252 21.7514 -104.8455 2021-03-03 05:23:28 Nayarit, Mexico
66900 66900 2021-03-02 Mexico Nuevo Leon     115649 8334 0 107315 25.5922 -99.9962 2021-03-03 05:23:28 Nuevo Leon, Mexico
66901 66901 2021-03-02 Mexico Oaxaca     40787 2942 0 37845 17.0732 -96.7266 2021-03-03 05:23:28 Oaxaca, Mexico
66902 66902 2021-03-02 Mexico Puebla     71355 8958 0 62397 19.0414 -98.2063 2021-03-03 05:23:28 Puebla, Mexico
66903 66903 2021-03-02 Mexico Queretaro     57370 3424 0 53946 20.5888 -100.3899 2021-03-03 05:23:28 Queretaro, Mexico
66904 66904 2021-03-02 Mexico Quintana Roo     20202 2404 0 17798 19.1817 -88.4791 2021-03-03 05:23:28 Quintana Roo, Mexico
66905 66905 2021-03-02 Mexico San Luis Potosi     57477 4595 0 52882 22.1565 -100.9855 2021-03-03 05:23:28 San Luis Potosi, Mexico
66906 66906 2021-03-02 Mexico Sinaloa     34087 5268 0 28819 25.1721 -107.4795 2021-03-03 05:23:28 Sinaloa, Mexico
66907 66907 2021-03-02 Mexico Sonora     67915 6050 0 61865 29.2972 -110.3309 2021-03-03 05:23:28 Sonora, Mexico
66908 66908 2021-03-02 Mexico Tabasco     57550 3727 0 53823 17.8409 -92.6189 2021-03-03 05:23:28 Tabasco, Mexico
66909 66909 2021-03-02 Mexico Tamaulipas     51847 4393 0 47454 24.2669 -98.8363 2021-03-03 05:23:28 Tamaulipas, Mexico
66910 66910 2021-03-02 Mexico Tlaxcala     17248 2164 0 15084 19.3139 -98.2404 2021-03-03 05:23:28 Tlaxcala, Mexico
66911 66911 2021-03-02 Mexico Unknown     0 0 1645312 -1645312     2021-03-03 05:23:28 Unknown, Mexico
66912 66912 2021-03-02 Mexico Veracruz     55297 8192 0 47105 19.1738 -96.1342 2021-03-03 05:23:28 Veracruz, Mexico
66913 66913 2021-03-02 Mexico Yucatan     32819 3115 0 29704 20.7099 -89.0943 2021-03-03 05:23:28 Yucatan, Mexico
66914 66914 2021-03-02 Mexico Zacatecas     27530 2494 0 25036 22.7709 -102.5832 2021-03-03 05:23:28 Zacatecas, Mexico
1295441 1295441 2021-03-01 Mexico Aguascalientes     23102 1997 0 21105 21.8853 -102.2916 2021-03-02 05:23:30 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]);