daily_reports (view)

⚠️ This table has been renamed. Use johns_hopkins_csse_daily_reports instead.

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

33 rows where country_or_region = "Mexico" and "day" is on date 2021-09-21 sorted by day descending

✎ View and edit SQL

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

Suggested facets: last_update (date)

country_or_region 1

  • Mexico · 33 ✖
day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
2021-09-21 Mexico Aguascalientes     32988 2698 0   21.8853 -102.2916 2021-09-22 04:21:45 Aguascalientes, Mexico
2021-09-21 Mexico Baja California     59236 9269 0   30.8406 -115.2838 2021-09-22 04:21:45 Baja California, Mexico
2021-09-21 Mexico Baja California Sur     54803 2267 0   26.0444 -111.6661 2021-09-22 04:21:45 Baja California Sur, Mexico
2021-09-21 Mexico Campeche     22062 1872 0   19.8301 -90.5349 2021-09-22 04:21:45 Campeche, Mexico
2021-09-21 Mexico Chiapas     21612 2160 0   16.7569 -93.1292 2021-09-22 04:21:45 Chiapas, Mexico
2021-09-21 Mexico Chihuahua     64517 7868 0   28.63300000000001 -106.0691 2021-09-22 04:21:45 Chihuahua, Mexico
2021-09-21 Mexico Ciudad de Mexico     933802 38650 0   19.4326 -99.1332 2021-09-22 04:21:45 Ciudad de Mexico, Mexico
2021-09-21 Mexico Coahuila     87112 7044 0   27.0587 -101.7068 2021-09-22 04:21:45 Coahuila, Mexico
2021-09-21 Mexico Colima     30418 1833 0   19.1223 -104.0072 2021-09-22 04:21:45 Colima, Mexico
2021-09-21 Mexico Durango     46564 2914 0   24.5593 -104.6588 2021-09-22 04:21:45 Durango, Mexico
2021-09-21 Mexico Guanajuato     167386 11887 0   21.019000000000002 -101.2574 2021-09-22 04:21:45 Guanajuato, Mexico
2021-09-21 Mexico Guerrero     73725 5909 0   17.4392 -99.5451 2021-09-22 04:21:45 Guerrero, Mexico
2021-09-21 Mexico Hidalgo     59063 7347 0   20.0911 -98.7624 2021-09-22 04:21:45 Hidalgo, Mexico
2021-09-21 Mexico Jalisco     149443 15771 0   20.6595 -103.3494 2021-09-22 04:21:45 Jalisco, Mexico
2021-09-21 Mexico Mexico     355193 42088 0   19.4969 -99.7233 2021-09-22 04:21:45 Mexico, Mexico
2021-09-21 Mexico Michoacan     69405 7395 0   19.5665 -101.7068 2021-09-22 04:21:45 Michoacan, Mexico
2021-09-21 Mexico Morelos     46492 4356 0   18.6813 -99.1013 2021-09-22 04:21:45 Morelos, Mexico
2021-09-21 Mexico Nayarit     32100 2618 0   21.7514 -104.8455 2021-09-22 04:21:45 Nayarit, Mexico
2021-09-21 Mexico Nuevo Leon     192956 12076 0   25.5922 -99.9962 2021-09-22 04:21:45 Nuevo Leon, Mexico
2021-09-21 Mexico Oaxaca     74282 5049 0   17.0732 -96.7266 2021-09-22 04:21:45 Oaxaca, Mexico
2021-09-21 Mexico Puebla     115895 14161 0   19.0414 -98.2063 2021-09-22 04:21:45 Puebla, Mexico
2021-09-21 Mexico Queretaro     91328 5173 0   20.5888 -100.3899 2021-09-22 04:21:45 Queretaro, Mexico
2021-09-21 Mexico Quintana Roo     57204 3933 0   19.1817 -88.4791 2021-09-22 04:21:45 Quintana Roo, Mexico
2021-09-21 Mexico San Luis Potosi     97166 6276 0   22.1565 -100.9855 2021-09-22 04:21:45 San Luis Potosi, Mexico
2021-09-21 Mexico Sinaloa     70851 8380 0   25.1721 -107.4795 2021-09-22 04:21:45 Sinaloa, Mexico
2021-09-21 Mexico Sonora     106246 7961 0   29.2972 -110.3309 2021-09-22 04:21:45 Sonora, Mexico
2021-09-21 Mexico Tabasco     129193 5067 0   17.8409 -92.6189 2021-09-22 04:21:45 Tabasco, Mexico
2021-09-21 Mexico Tamaulipas     94273 6210 0   24.2669 -98.8363 2021-09-22 04:21:45 Tamaulipas, Mexico
2021-09-21 Mexico Tlaxcala     27687 2825 0   19.3139 -98.2404 2021-09-22 04:21:45 Tlaxcala, Mexico
2021-09-21 Mexico Unknown     0 0 0       2021-09-22 04:21:45 Unknown, Mexico
2021-09-21 Mexico Veracruz     114883 13170 0   19.1738 -96.1342 2021-09-22 04:21:45 Veracruz, Mexico
2021-09-21 Mexico Yucatan     67657 5151 0   20.7099 -89.0943 2021-09-22 04:21:45 Yucatan, Mexico
2021-09-21 Mexico Zacatecas     40023 3202 0   22.7709 -102.5832 2021-09-22 04:21:45 Zacatecas, Mexico

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;