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

17,133 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 · 17,133 ✖
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
32359 32359 2021-10-23 Mexico Aguascalientes     35471 2833 0   21.8853 -102.2916 2021-10-24 04:21:22 Aguascalientes, Mexico
32360 32360 2021-10-23 Mexico Baja California     66753 9617 0   30.8406 -115.2838 2021-10-24 04:21:22 Baja California, Mexico
32361 32361 2021-10-23 Mexico Baja California Sur     55866 2360 0   26.0444 -111.6661 2021-10-24 04:21:22 Baja California Sur, Mexico
32362 32362 2021-10-23 Mexico Campeche     23767 2039 0   19.8301 -90.5349 2021-10-24 04:21:22 Campeche, Mexico
32363 32363 2021-10-23 Mexico Chiapas     23114 2260 0   16.7569 -93.1292 2021-10-24 04:21:22 Chiapas, Mexico
32364 32364 2021-10-23 Mexico Chihuahua     67631 8043 0   28.63300000000001 -106.0691 2021-10-24 04:21:22 Chihuahua, Mexico
32365 32365 2021-10-23 Mexico Ciudad de Mexico     967113 39723 0   19.4326 -99.1332 2021-10-24 04:21:22 Ciudad de Mexico, Mexico
32366 32366 2021-10-23 Mexico Coahuila     92363 7349 0   27.0587 -101.7068 2021-10-24 04:21:22 Coahuila, Mexico
32367 32367 2021-10-23 Mexico Colima     32923 1969 0   19.1223 -104.0072 2021-10-24 04:21:22 Colima, Mexico
32368 32368 2021-10-23 Mexico Durango     48430 3013 0   24.5593 -104.6588 2021-10-24 04:21:22 Durango, Mexico
32369 32369 2021-10-23 Mexico Guanajuato     186109 12461 0   21.019000000000002 -101.2574 2021-10-24 04:21:22 Guanajuato, Mexico
32370 32370 2021-10-23 Mexico Guerrero     75980 6091 0   17.4392 -99.5451 2021-10-24 04:21:22 Guerrero, Mexico
32371 32371 2021-10-23 Mexico Hidalgo     61685 7708 0   20.0911 -98.7624 2021-10-24 04:21:22 Hidalgo, Mexico
32372 32372 2021-10-23 Mexico Jalisco     159897 16944 0   20.6595 -103.3494 2021-10-24 04:21:22 Jalisco, Mexico
32373 32373 2021-10-23 Mexico Mexico     372355 43673 0   19.4969 -99.7233 2021-10-24 04:21:22 Mexico, Mexico
32374 32374 2021-10-23 Mexico Michoacan     72683 7979 0   19.5665 -101.7068 2021-10-24 04:21:22 Michoacan, Mexico
32375 32375 2021-10-23 Mexico Morelos     49027 4696 0   18.6813 -99.1013 2021-10-24 04:21:22 Morelos, Mexico
32376 32376 2021-10-23 Mexico Nayarit     33772 2778 0   21.7514 -104.8455 2021-10-24 04:21:22 Nayarit, Mexico
32377 32377 2021-10-23 Mexico Nuevo Leon     202882 12893 0   25.5922 -99.9962 2021-10-24 04:21:22 Nuevo Leon, Mexico
32378 32378 2021-10-23 Mexico Oaxaca     81025 5417 0   17.0732 -96.7266 2021-10-24 04:21:22 Oaxaca, Mexico
32379 32379 2021-10-23 Mexico Puebla     123281 15140 0   19.0414 -98.2063 2021-10-24 04:21:22 Puebla, Mexico
32380 32380 2021-10-23 Mexico Queretaro     96499 5476 0   20.5888 -100.3899 2021-10-24 04:21:22 Queretaro, Mexico
32381 32381 2021-10-23 Mexico Quintana Roo     59199 4021 0   19.1817 -88.4791 2021-10-24 04:21:22 Quintana Roo, Mexico
32382 32382 2021-10-23 Mexico San Luis Potosi     102507 6551 0   22.1565 -100.9855 2021-10-24 04:21:22 San Luis Potosi, Mexico
32383 32383 2021-10-23 Mexico Sinaloa     73118 8646 0   25.1721 -107.4795 2021-10-24 04:21:22 Sinaloa, Mexico
32384 32384 2021-10-23 Mexico Sonora     111069 8389 0   29.2972 -110.3309 2021-10-24 04:21:22 Sonora, Mexico
32385 32385 2021-10-23 Mexico Tabasco     141204 5410 0   17.8409 -92.6189 2021-10-24 04:21:22 Tabasco, Mexico
32386 32386 2021-10-23 Mexico Tamaulipas     100826 6691 0   24.2669 -98.8363 2021-10-24 04:21:22 Tamaulipas, Mexico
32387 32387 2021-10-23 Mexico Tlaxcala     29101 2937 0   19.3139 -98.2404 2021-10-24 04:21:22 Tlaxcala, Mexico
32388 32388 2021-10-23 Mexico Unknown     0 0 0       2021-10-24 04:21:22 Unknown, Mexico
32389 32389 2021-10-23 Mexico Veracruz     121622 14356 0   19.1738 -96.1342 2021-10-24 04:21:22 Veracruz, Mexico
32390 32390 2021-10-23 Mexico Yucatan     72993 5457 0   20.7099 -89.0943 2021-10-24 04:21:22 Yucatan, Mexico
32391 32391 2021-10-23 Mexico Zacatecas     41396 3339 0   22.7709 -102.5832 2021-10-24 04:21:22 Zacatecas, Mexico
312843 312843 2021-10-22 Mexico Aguascalientes     35430 2832 0   21.8853 -102.2916 2021-10-23 04:21:32 Aguascalientes, Mexico
312844 312844 2021-10-22 Mexico Baja California     66319 9608 0   30.8406 -115.2838 2021-10-23 04:21:32 Baja California, Mexico
312845 312845 2021-10-22 Mexico Baja California Sur     55846 2358 0   26.0444 -111.6661 2021-10-23 04:21:32 Baja California Sur, Mexico
312846 312846 2021-10-22 Mexico Campeche     23739 2034 0   19.8301 -90.5349 2021-10-23 04:21:32 Campeche, Mexico
312847 312847 2021-10-22 Mexico Chiapas     23088 2258 0   16.7569 -93.1292 2021-10-23 04:21:32 Chiapas, Mexico
312848 312848 2021-10-22 Mexico Chihuahua     67483 8032 0   28.63300000000001 -106.0691 2021-10-23 04:21:32 Chihuahua, Mexico
312849 312849 2021-10-22 Mexico Ciudad de Mexico     966372 39719 0   19.4326 -99.1332 2021-10-23 04:21:32 Ciudad de Mexico, Mexico
312850 312850 2021-10-22 Mexico Coahuila     92217 7346 0   27.0587 -101.7068 2021-10-23 04:21:32 Coahuila, Mexico
312851 312851 2021-10-22 Mexico Colima     32893 1968 0   19.1223 -104.0072 2021-10-23 04:21:32 Colima, Mexico
312852 312852 2021-10-22 Mexico Durango     48387 3012 0   24.5593 -104.6588 2021-10-23 04:21:32 Durango, Mexico
312853 312853 2021-10-22 Mexico Guanajuato     185690 12452 0   21.019000000000002 -101.2574 2021-10-23 04:21:32 Guanajuato, Mexico
312854 312854 2021-10-22 Mexico Guerrero     75941 6088 0   17.4392 -99.5451 2021-10-23 04:21:32 Guerrero, Mexico
312855 312855 2021-10-22 Mexico Hidalgo     61619 7701 0   20.0911 -98.7624 2021-10-23 04:21:32 Hidalgo, Mexico
312856 312856 2021-10-22 Mexico Jalisco     159675 16893 0   20.6595 -103.3494 2021-10-23 04:21:32 Jalisco, Mexico
312857 312857 2021-10-22 Mexico Mexico     372079 43635 0   19.4969 -99.7233 2021-10-23 04:21:32 Mexico, Mexico
312858 312858 2021-10-22 Mexico Michoacan     72597 7964 0   19.5665 -101.7068 2021-10-23 04:21:32 Michoacan, Mexico
312859 312859 2021-10-22 Mexico Morelos     48952 4689 0   18.6813 -99.1013 2021-10-23 04:21:32 Morelos, Mexico
312860 312860 2021-10-22 Mexico Nayarit     33735 2777 0   21.7514 -104.8455 2021-10-23 04:21:32 Nayarit, Mexico
312861 312861 2021-10-22 Mexico Nuevo Leon     202665 12872 0   25.5922 -99.9962 2021-10-23 04:21:32 Nuevo Leon, Mexico
312862 312862 2021-10-22 Mexico Oaxaca     80783 5410 0   17.0732 -96.7266 2021-10-23 04:21:32 Oaxaca, Mexico
312863 312863 2021-10-22 Mexico Puebla     123196 15127 0   19.0414 -98.2063 2021-10-23 04:21:32 Puebla, Mexico
312864 312864 2021-10-22 Mexico Queretaro     96354 5472 0   20.5888 -100.3899 2021-10-23 04:21:32 Queretaro, Mexico
312865 312865 2021-10-22 Mexico Quintana Roo     59180 4020 0   19.1817 -88.4791 2021-10-23 04:21:32 Quintana Roo, Mexico
312866 312866 2021-10-22 Mexico San Luis Potosi     102372 6547 0   22.1565 -100.9855 2021-10-23 04:21:32 San Luis Potosi, Mexico
312867 312867 2021-10-22 Mexico Sinaloa     73065 8628 0   25.1721 -107.4795 2021-10-23 04:21:32 Sinaloa, Mexico
312868 312868 2021-10-22 Mexico Sonora     110907 8375 0   29.2972 -110.3309 2021-10-23 04:21:32 Sonora, Mexico
312869 312869 2021-10-22 Mexico Tabasco     141075 5401 0   17.8409 -92.6189 2021-10-23 04:21:32 Tabasco, Mexico
312870 312870 2021-10-22 Mexico Tamaulipas     100715 6680 0   24.2669 -98.8363 2021-10-23 04:21:32 Tamaulipas, Mexico
312871 312871 2021-10-22 Mexico Tlaxcala     29079 2937 0   19.3139 -98.2404 2021-10-23 04:21:32 Tlaxcala, Mexico
312872 312872 2021-10-22 Mexico Unknown     0 0 0       2021-10-23 04:21:32 Unknown, Mexico
312873 312873 2021-10-22 Mexico Veracruz     121507 14326 0   19.1738 -96.1342 2021-10-23 04:21:32 Veracruz, Mexico
312874 312874 2021-10-22 Mexico Yucatan     72885 5454 0   20.7099 -89.0943 2021-10-23 04:21:32 Yucatan, Mexico
312875 312875 2021-10-22 Mexico Zacatecas     41364 3338 0   22.7709 -102.5832 2021-10-23 04:21:32 Zacatecas, Mexico
2134865 2134865 2021-10-21 Mexico Aguascalientes     35346 2828 0   21.8853 -102.2916 2021-10-22 04:21:14 Aguascalientes, Mexico
2134866 2134866 2021-10-21 Mexico Baja California     65939 9594 0   30.8406 -115.2838 2021-10-22 04:21:14 Baja California, Mexico
2134867 2134867 2021-10-21 Mexico Baja California Sur     55807 2358 0   26.0444 -111.6661 2021-10-22 04:21:14 Baja California Sur, Mexico
2134868 2134868 2021-10-21 Mexico Campeche     23701 2029 0   19.8301 -90.5349 2021-10-22 04:21:14 Campeche, Mexico
2134869 2134869 2021-10-21 Mexico Chiapas     23067 2256 0   16.7569 -93.1292 2021-10-22 04:21:14 Chiapas, Mexico
2134870 2134870 2021-10-21 Mexico Chihuahua     67346 8030 0   28.63300000000001 -106.0691 2021-10-22 04:21:14 Chihuahua, Mexico
2134871 2134871 2021-10-21 Mexico Ciudad de Mexico     965467 39694 0   19.4326 -99.1332 2021-10-22 04:21:14 Ciudad de Mexico, Mexico
2134872 2134872 2021-10-21 Mexico Coahuila     92070 7330 0   27.0587 -101.7068 2021-10-22 04:21:14 Coahuila, Mexico
2134873 2134873 2021-10-21 Mexico Colima     32856 1967 0   19.1223 -104.0072 2021-10-22 04:21:14 Colima, Mexico
2134874 2134874 2021-10-21 Mexico Durango     48353 3011 0   24.5593 -104.6588 2021-10-22 04:21:14 Durango, Mexico
2134875 2134875 2021-10-21 Mexico Guanajuato     185164 12422 0   21.019000000000002 -101.2574 2021-10-22 04:21:14 Guanajuato, Mexico
2134876 2134876 2021-10-21 Mexico Guerrero     75897 6082 0   17.4392 -99.5451 2021-10-22 04:21:14 Guerrero, Mexico
2134877 2134877 2021-10-21 Mexico Hidalgo     61581 7697 0   20.0911 -98.7624 2021-10-22 04:21:14 Hidalgo, Mexico
2134878 2134878 2021-10-21 Mexico Jalisco     159491 16858 0   20.6595 -103.3494 2021-10-22 04:21:14 Jalisco, Mexico
2134879 2134879 2021-10-21 Mexico Mexico     371762 43622 0   19.4969 -99.7233 2021-10-22 04:21:14 Mexico, Mexico
2134880 2134880 2021-10-21 Mexico Michoacan     72547 7954 0   19.5665 -101.7068 2021-10-22 04:21:14 Michoacan, Mexico
2134881 2134881 2021-10-21 Mexico Morelos     48892 4686 0   18.6813 -99.1013 2021-10-22 04:21:14 Morelos, Mexico
2134882 2134882 2021-10-21 Mexico Nayarit     33709 2774 0   21.7514 -104.8455 2021-10-22 04:21:14 Nayarit, Mexico
2134883 2134883 2021-10-21 Mexico Nuevo Leon     202425 12862 0   25.5922 -99.9962 2021-10-22 04:21:14 Nuevo Leon, Mexico
2134884 2134884 2021-10-21 Mexico Oaxaca     80595 5402 0   17.0732 -96.7266 2021-10-22 04:21:14 Oaxaca, Mexico
2134885 2134885 2021-10-21 Mexico Puebla     123102 15114 0   19.0414 -98.2063 2021-10-22 04:21:14 Puebla, Mexico
2134886 2134886 2021-10-21 Mexico Queretaro     96234 5461 0   20.5888 -100.3899 2021-10-22 04:21:14 Queretaro, Mexico
2134887 2134887 2021-10-21 Mexico Quintana Roo     59153 4018 0   19.1817 -88.4791 2021-10-22 04:21:14 Quintana Roo, Mexico
2134888 2134888 2021-10-21 Mexico San Luis Potosi     102270 6542 0   22.1565 -100.9855 2021-10-22 04:21:14 San Luis Potosi, Mexico
2134889 2134889 2021-10-21 Mexico Sinaloa     73020 8626 0   25.1721 -107.4795 2021-10-22 04:21:14 Sinaloa, Mexico
2134890 2134890 2021-10-21 Mexico Sonora     110705 8365 0   29.2972 -110.3309 2021-10-22 04:21:14 Sonora, Mexico
2134891 2134891 2021-10-21 Mexico Tabasco     140896 5395 0   17.8409 -92.6189 2021-10-22 04:21:14 Tabasco, Mexico
2134892 2134892 2021-10-21 Mexico Tamaulipas     100637 6673 0   24.2669 -98.8363 2021-10-22 04:21:14 Tamaulipas, Mexico
2134893 2134893 2021-10-21 Mexico Tlaxcala     29062 2936 0   19.3139 -98.2404 2021-10-22 04:21:14 Tlaxcala, Mexico
2134894 2134894 2021-10-21 Mexico Unknown     0 0 0       2021-10-22 04:21:14 Unknown, Mexico
2134895 2134895 2021-10-21 Mexico Veracruz     121390 14309 0   19.1738 -96.1342 2021-10-22 04:21:14 Veracruz, Mexico
2134896 2134896 2021-10-21 Mexico Yucatan     72740 5439 0   20.7099 -89.0943 2021-10-22 04:21:14 Yucatan, Mexico
2134897 2134897 2021-10-21 Mexico Zacatecas     41332 3335 0   22.7709 -102.5832 2021-10-22 04:21:14 Zacatecas, Mexico
226184 226184 2021-10-20 Mexico Aguascalientes     35293 2828 0   21.8853 -102.2916 2021-10-21 04:21:18 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]);