daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
31,389 rows where country_or_region = "Mexico" sorted by latitude
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: last_update (date)
province_or_state >30
- Aguascalientes 954
- Baja California 954
- Baja California Sur 954
- Campeche 954
- Chiapas 954
- Chihuahua 954
- Ciudad de Mexico 954
- Coahuila 954
- Colima 954
- Durango 954
- Guanajuato 954
- Guerrero 954
- Hidalgo 954
- Jalisco 954
- Mexico 954
- Michoacan 954
- Morelos 954
- Nayarit 954
- Nuevo Leon 954
- Oaxaca 954
- Puebla 954
- Queretaro 954
- Quintana Roo 954
- San Luis Potosi 954
- Sinaloa 954
- Sonora 954
- Tabasco 954
- Tamaulipas 954
- Tlaxcala 954
- Veracruz 954
- …
day (date) >30 ✖
- 2020-11-12 33
- 2020-11-13 33
- 2020-11-14 33
- 2020-11-15 33
- 2020-11-16 33
- 2020-11-17 33
- 2020-11-18 33
- 2020-11-19 33
- 2020-11-20 33
- 2020-11-21 33
- 2020-11-22 33
- 2020-11-23 33
- 2020-11-24 33
- 2020-11-25 33
- 2020-11-26 33
- 2020-11-27 33
- 2020-11-28 33
- 2020-11-29 33
- 2020-11-30 33
- 2020-12-01 33
- 2020-12-02 33
- 2020-12-03 33
- 2020-12-04 33
- 2020-12-05 33
- 2020-12-06 33
- 2020-12-07 33
- 2020-12-08 33
- 2020-12-09 33
- 2020-12-10 33
- 2020-12-11 33
- …
country_or_region 1
- Mexico · 31,389 ✖
day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude ▼ | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-12-02 | Mexico | Unknown | 0 | 0 | 0 | 2021-12-03 04:23:05 | Unknown, Mexico | |||||
2021-10-28 | Mexico | Unknown | 0 | 0 | 0 | 2021-10-29 04:22:03 | Unknown, Mexico | |||||
2021-01-26 | Mexico | Unknown | 0 | 0 | 1348660 | 0 | 2021-01-27 05:23:41 | Unknown, Mexico | ||||
2021-09-18 | Mexico | Unknown | 0 | 0 | 0 | 2021-09-19 04:21:34 | Unknown, Mexico | |||||
2021-05-28 | Mexico | Unknown | 0 | 0 | 1923744 | 0 | 2021-05-29 04:20:41 | Unknown, Mexico | ||||
2022-03-20 | Mexico | Unknown | 0 | 0 | 0 | 2022-03-21 04:20:50 | Unknown, Mexico | |||||
2021-11-11 | Mexico | Unknown | 0 | 0 | 0 | 2021-11-12 04:22:01 | Unknown, Mexico | |||||
2021-08-25 | Mexico | Unknown | 0 | 0 | 0 | 2021-08-26 04:21:28 | Unknown, Mexico | |||||
2021-04-12 | Mexico | Unknown | 0 | 0 | 1812694 | 0 | 2021-04-13 04:20:37 | Unknown, Mexico | ||||
2021-11-02 | Mexico | Unknown | 0 | 0 | 0 | 2021-11-03 06:22:09 | Unknown, Mexico | |||||
2021-05-29 | Mexico | Unknown | 0 | 0 | 1924865 | 0 | 2021-05-30 04:20:55 | Unknown, Mexico | ||||
2021-03-07 | Mexico | Unknown | 0 | 0 | 1670431 | 0 | 2021-03-08 05:24:48 | Unknown, Mexico | ||||
2022-11-12 | Mexico | Unknown | 0 | 0 | 0 | 2022-11-13 04:21:14 | Unknown, Mexico | |||||
2021-09-01 | Mexico | Unknown | 0 | 0 | 0 | 2021-09-02 04:21:15 | Unknown, Mexico | |||||
2022-02-07 | Mexico | Unknown | 0 | 0 | 0 | 2022-02-08 04:21:15 | Unknown, Mexico | |||||
2020-12-03 | Mexico | Unknown | 0 | 0 | 843231 | 0 | 2020-12-04 05:27:27 | Unknown, Mexico | ||||
2021-05-25 | Mexico | Unknown | 0 | 0 | 1917958 | 0 | 2021-05-26 04:20:35 | Unknown, Mexico | ||||
2021-11-09 | Mexico | Unknown | 0 | 0 | 0 | 2021-11-10 04:21:38 | Unknown, Mexico | |||||
2022-07-23 | Mexico | Unknown | 0 | 0 | 0 | 2022-07-24 04:20:47 | Unknown, Mexico | |||||
2022-01-14 | Mexico | Unknown | 0 | 0 | 0 | 2022-01-15 04:21:07 | Unknown, Mexico | |||||
2021-08-15 | Mexico | Unknown | 0 | 0 | 0 | 2021-08-16 04:21:31 | Unknown, Mexico | |||||
2021-06-19 | Mexico | Unknown | 0 | 0 | 1966702 | 0 | 2021-06-20 04:21:48 | Unknown, Mexico | ||||
2022-09-06 | Mexico | Unknown | 0 | 0 | 0 | 2022-09-07 04:20:59 | Unknown, Mexico | |||||
2020-11-18 | Mexico | Unknown | 0 | 0 | 762025 | 0 | 2020-11-19 05:25:23 | Unknown, Mexico | ||||
2022-01-09 | Mexico | Unknown | 0 | 0 | 0 | 2022-01-10 04:22:07 | Unknown, Mexico | |||||
2022-10-04 | Mexico | Unknown | 0 | 0 | 0 | 2022-10-05 04:23:06 | Unknown, Mexico | |||||
2021-12-04 | Mexico | Unknown | 0 | 0 | 0 | 2021-12-05 04:22:25 | Unknown, Mexico | |||||
2022-07-09 | Mexico | Unknown | 0 | 0 | 0 | 2022-07-10 04:20:54 | Unknown, Mexico | |||||
2021-11-29 | Mexico | Unknown | 0 | 0 | 0 | 2021-11-30 04:22:53 | Unknown, Mexico | |||||
2021-01-08 | Mexico | Unknown | 0 | 0 | 1134877 | 0 | 2021-01-09 05:22:18 | Unknown, Mexico | ||||
2022-03-29 | Mexico | Unknown | 0 | 0 | 0 | 2022-03-30 04:20:45 | Unknown, Mexico | |||||
2021-11-19 | Mexico | Unknown | 0 | 0 | 0 | 2021-11-20 04:22:17 | Unknown, Mexico | |||||
2022-06-21 | Mexico | Unknown | 0 | 0 | 0 | 2022-06-22 04:20:54 | Unknown, Mexico | |||||
2021-04-16 | Mexico | Unknown | 0 | 0 | 1823732 | 0 | 2021-04-17 04:20:40 | Unknown, Mexico | ||||
2021-09-02 | Mexico | Unknown | 0 | 0 | 0 | 2021-09-03 04:21:20 | Unknown, Mexico | |||||
2021-02-21 | Mexico | Unknown | 0 | 0 | 1595320 | 0 | 2021-02-22 05:24:21 | Unknown, Mexico | ||||
2022-02-13 | Mexico | Unknown | 0 | 0 | 0 | 2022-02-14 04:20:51 | Unknown, Mexico | |||||
2021-01-11 | Mexico | Unknown | 0 | 0 | 1160373 | 0 | 2021-01-12 05:22:15 | Unknown, Mexico | ||||
2022-10-19 | Mexico | Unknown | 0 | 0 | 0 | 2022-10-20 04:22:59 | Unknown, Mexico | |||||
2020-12-25 | Mexico | Unknown | 0 | 0 | 1023916 | 0 | 2020-12-26 05:22:28 | Unknown, Mexico | ||||
2022-12-26 | Mexico | Unknown | 0 | 0 | 0 | 2022-12-27 04:21:07 | Unknown, Mexico | |||||
2022-05-09 | Mexico | Unknown | 0 | 0 | 0 | 2022-05-10 04:20:50 | Unknown, Mexico | |||||
2022-05-31 | Mexico | Unknown | 0 | 0 | 0 | 2022-06-01 04:20:55 | Unknown, Mexico | |||||
2022-02-11 | Mexico | Unknown | 0 | 0 | 0 | 2022-02-12 04:21:06 | Unknown, Mexico | |||||
2021-01-18 | Mexico | Unknown | 0 | 0 | 1237321 | 0 | 2021-01-19 05:22:15 | Unknown, Mexico | ||||
2021-04-02 | Mexico | Unknown | 0 | 0 | 1781629 | 0 | 2021-04-03 04:20:44 | Unknown, Mexico | ||||
2021-08-17 | Mexico | Unknown | 0 | 0 | 0 | 2021-08-18 04:21:35 | Unknown, Mexico | |||||
2021-09-04 | Mexico | Unknown | 0 | 0 | 0 | 2021-09-05 04:21:33 | Unknown, Mexico | |||||
2022-09-08 | Mexico | Unknown | 0 | 0 | 0 | 2022-09-09 04:21:11 | Unknown, Mexico | |||||
2022-12-10 | Mexico | Unknown | 0 | 0 | 0 | 2022-12-11 04:20:50 | Unknown, Mexico | |||||
2022-03-15 | Mexico | Unknown | 0 | 0 | 0 | 2022-03-16 04:20:50 | Unknown, Mexico | |||||
2021-11-03 | Mexico | Unknown | 0 | 0 | 0 | 2021-11-04 04:22:20 | Unknown, Mexico | |||||
2021-02-24 | Mexico | Unknown | 0 | 0 | 1614614 | 0 | 2021-02-25 05:24:57 | Unknown, Mexico | ||||
2021-10-31 | Mexico | Unknown | 0 | 0 | 0 | 2021-11-01 04:22:01 | Unknown, Mexico | |||||
2022-11-15 | Mexico | Unknown | 0 | 0 | 0 | 2022-11-16 04:21:09 | Unknown, Mexico | |||||
2021-07-15 | Mexico | Unknown | 0 | 0 | 2068175 | 0 | 2021-07-16 04:21:22 | Unknown, Mexico | ||||
2022-04-16 | Mexico | Unknown | 0 | 0 | 0 | 2022-04-17 04:20:59 | Unknown, Mexico | |||||
2022-12-13 | Mexico | Unknown | 0 | 0 | 0 | 2022-12-14 04:21:04 | Unknown, Mexico | |||||
2022-11-13 | Mexico | Unknown | 0 | 0 | 0 | 2022-11-14 04:21:09 | Unknown, Mexico | |||||
2022-02-12 | Mexico | Unknown | 0 | 0 | 0 | 2022-02-13 04:21:00 | Unknown, Mexico | |||||
2022-10-30 | Mexico | Unknown | 0 | 0 | 0 | 2022-10-31 04:21:36 | Unknown, Mexico | |||||
2022-12-27 | Mexico | Unknown | 0 | 0 | 0 | 2022-12-28 04:21:04 | Unknown, Mexico | |||||
2021-08-04 | Mexico | Unknown | 0 | 0 | 2270427 | 0 | 2021-08-05 04:21:51 | Unknown, Mexico | ||||
2022-03-18 | Mexico | Unknown | 0 | 0 | 0 | 2022-03-19 04:20:47 | Unknown, Mexico | |||||
2021-02-03 | Mexico | Unknown | 0 | 0 | 1450237 | 0 | 2021-02-04 05:22:26 | Unknown, Mexico | ||||
2022-12-14 | Mexico | Unknown | 0 | 0 | 0 | 2022-12-15 04:20:58 | Unknown, Mexico | |||||
2021-03-11 | Mexico | Unknown | 0 | 0 | 1691093 | 0 | 2021-03-12 05:26:50 | Unknown, Mexico | ||||
2022-03-11 | Mexico | Unknown | 0 | 0 | 0 | 2022-03-12 04:20:50 | Unknown, Mexico | |||||
2022-05-07 | Mexico | Unknown | 0 | 0 | 0 | 2022-05-08 04:20:49 | Unknown, Mexico | |||||
2022-09-13 | Mexico | Unknown | 0 | 0 | 0 | 2022-09-14 04:20:44 | Unknown, Mexico | |||||
2021-04-30 | Mexico | Unknown | 0 | 0 | 1864914 | 0 | 2021-05-01 04:20:47 | Unknown, Mexico | ||||
2022-09-23 | Mexico | Unknown | 0 | 0 | 0 | 2022-09-24 04:21:40 | Unknown, Mexico | |||||
2021-04-04 | Mexico | Unknown | 0 | 0 | 1788209 | 0 | 2021-04-05 04:20:35 | Unknown, Mexico | ||||
2020-11-27 | Mexico | Unknown | 0 | 0 | 808618 | 0 | 2020-11-28 05:25:50 | Unknown, Mexico | ||||
2022-10-07 | Mexico | Unknown | 0 | 0 | 0 | 2022-10-08 04:22:56 | Unknown, Mexico | |||||
2021-06-29 | Mexico | Unknown | 0 | 0 | 1997381 | 0 | 2021-06-30 04:21:41 | Unknown, Mexico | ||||
2021-12-07 | Mexico | Unknown | 0 | 0 | 0 | 2021-12-08 04:22:46 | Unknown, Mexico | |||||
2021-07-28 | Mexico | Unknown | 0 | 0 | 2181291 | 0 | 2021-07-29 04:21:33 | Unknown, Mexico | ||||
2022-09-18 | Mexico | Unknown | 0 | 0 | 0 | 2022-09-19 04:21:49 | Unknown, Mexico | |||||
2021-10-10 | Mexico | Unknown | 0 | 0 | 0 | 2021-10-11 04:21:31 | Unknown, Mexico | |||||
2022-11-03 | Mexico | Unknown | 0 | 0 | 0 | 2022-11-04 04:22:11 | Unknown, Mexico | |||||
2021-01-21 | Mexico | Unknown | 0 | 0 | 1264780 | 0 | 2021-01-22 05:22:10 | Unknown, Mexico | ||||
2021-10-20 | Mexico | Unknown | 0 | 0 | 0 | 2021-10-21 04:21:18 | Unknown, Mexico | |||||
2021-11-17 | Mexico | Unknown | 0 | 0 | 0 | 2021-11-18 04:21:33 | Unknown, Mexico | |||||
2022-12-21 | Mexico | Unknown | 0 | 0 | 0 | 2022-12-22 04:20:56 | Unknown, Mexico | |||||
2022-02-02 | Mexico | Unknown | 0 | 0 | 0 | 2022-02-03 04:21:21 | Unknown, Mexico | |||||
2022-05-02 | Mexico | Unknown | 0 | 0 | 0 | 2022-05-03 04:21:00 | Unknown, Mexico | |||||
2021-10-07 | Mexico | Unknown | 0 | 0 | 0 | 2021-10-08 04:21:25 | Unknown, Mexico | |||||
2021-02-19 | Mexico | Unknown | 0 | 0 | 1584704 | 0 | 2021-02-20 05:22:51 | Unknown, Mexico | ||||
2022-06-26 | Mexico | Unknown | 0 | 0 | 0 | 2022-06-27 04:21:00 | Unknown, Mexico | |||||
2022-11-08 | Mexico | Unknown | 0 | 0 | 0 | 2022-11-09 04:21:22 | Unknown, Mexico | |||||
2021-07-19 | Mexico | Unknown | 0 | 0 | 2095953 | 0 | 2021-07-20 04:21:48 | Unknown, Mexico | ||||
2022-11-25 | Mexico | Unknown | 0 | 0 | 0 | 2022-11-26 04:21:11 | Unknown, Mexico | |||||
2021-10-14 | Mexico | Unknown | 0 | 0 | 0 | 2021-10-15 04:21:26 | Unknown, Mexico | |||||
2021-11-06 | Mexico | Unknown | 0 | 0 | 0 | 2021-11-07 04:21:53 | Unknown, Mexico | |||||
2022-04-02 | Mexico | Unknown | 0 | 0 | 0 | 2022-04-03 04:20:48 | Unknown, Mexico | |||||
2022-12-17 | Mexico | Unknown | 0 | 0 | 0 | 2022-12-18 04:21:03 | Unknown, Mexico | |||||
2021-08-14 | Mexico | Unknown | 0 | 0 | 0 | 2021-08-15 04:21:41 | Unknown, Mexico | |||||
2021-08-19 | Mexico | Unknown | 0 | 0 | 0 | 2021-08-20 04:21:33 | Unknown, Mexico | |||||
2022-10-15 | Mexico | Unknown | 0 | 0 | 0 | 2022-10-16 04:22:39 | Unknown, Mexico |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;