johns_hopkins_csse_daily_reports
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)
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
- …
last_update (date) >30 ✖
- 2022-04-13 66
- 2022-05-26 66
- 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
- …
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 ✖
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude ▼ | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
435 | 435 | 2021-12-02 | Mexico | Unknown | 0 | 0 | 0 | 2021-12-03 04:23:05 | Unknown, Mexico | |||||
4451 | 4451 | 2021-10-28 | Mexico | Unknown | 0 | 0 | 0 | 2021-10-29 04:22:03 | Unknown, Mexico | |||||
12443 | 12443 | 2021-01-26 | Mexico | Unknown | 0 | 0 | 1348660 | 0 | 2021-01-27 05:23:41 | Unknown, Mexico | ||||
16459 | 16459 | 2021-09-18 | Mexico | Unknown | 0 | 0 | 0 | 2021-09-19 04:21:34 | Unknown, Mexico | |||||
20474 | 20474 | 2021-05-28 | Mexico | Unknown | 0 | 0 | 1923744 | 0 | 2021-05-29 04:20:41 | Unknown, Mexico | ||||
24506 | 24506 | 2022-03-20 | Mexico | Unknown | 0 | 0 | 0 | 2022-03-21 04:20:50 | Unknown, Mexico | |||||
28521 | 28521 | 2021-11-11 | Mexico | Unknown | 0 | 0 | 0 | 2021-11-12 04:22:01 | Unknown, Mexico | |||||
32520 | 32520 | 2021-08-25 | Mexico | Unknown | 0 | 0 | 0 | 2021-08-26 04:21:28 | Unknown, Mexico | |||||
36533 | 36533 | 2021-04-12 | Mexico | Unknown | 0 | 0 | 1812694 | 0 | 2021-04-13 04:20:37 | Unknown, Mexico | ||||
43813 | 43813 | 2021-11-02 | Mexico | Unknown | 0 | 0 | 0 | 2021-11-03 06:22:09 | Unknown, Mexico | |||||
50895 | 50895 | 2021-05-29 | Mexico | Unknown | 0 | 0 | 1924865 | 0 | 2021-05-30 04:20:55 | Unknown, Mexico | ||||
54908 | 54908 | 2021-03-07 | Mexico | Unknown | 0 | 0 | 1670431 | 0 | 2021-03-08 05:24:48 | Unknown, Mexico | ||||
63168 | 63168 | 2022-11-12 | Mexico | Unknown | 0 | 0 | 0 | 2022-11-13 04:21:14 | Unknown, Mexico | |||||
67165 | 67165 | 2021-09-01 | Mexico | Unknown | 0 | 0 | 0 | 2021-09-02 04:21:15 | Unknown, Mexico | |||||
71196 | 71196 | 2022-02-07 | Mexico | Unknown | 0 | 0 | 0 | 2022-02-08 04:21:15 | Unknown, Mexico | |||||
75192 | 75192 | 2020-12-03 | Mexico | Unknown | 0 | 0 | 843231 | 0 | 2020-12-04 05:27:27 | Unknown, Mexico | ||||
83198 | 83198 | 2021-05-25 | Mexico | Unknown | 0 | 0 | 1917958 | 0 | 2021-05-26 04:20:35 | Unknown, Mexico | ||||
87230 | 87230 | 2021-11-09 | Mexico | Unknown | 0 | 0 | 0 | 2021-11-10 04:21:38 | Unknown, Mexico | |||||
91248 | 91248 | 2022-07-23 | Mexico | Unknown | 0 | 0 | 0 | 2022-07-24 04:20:47 | Unknown, Mexico | |||||
99431 | 99431 | 2022-01-14 | Mexico | Unknown | 0 | 0 | 0 | 2022-01-15 04:21:07 | Unknown, Mexico | |||||
103430 | 103430 | 2021-08-15 | Mexico | Unknown | 0 | 0 | 0 | 2021-08-16 04:21:31 | Unknown, Mexico | |||||
107555 | 107555 | 2021-06-19 | Mexico | Unknown | 0 | 0 | 1966702 | 0 | 2021-06-20 04:21:48 | Unknown, Mexico | ||||
114858 | 114858 | 2022-09-06 | Mexico | Unknown | 0 | 0 | 0 | 2022-09-07 04:20:59 | Unknown, Mexico | |||||
122807 | 122807 | 2020-11-18 | Mexico | Unknown | 0 | 0 | 762025 | 0 | 2020-11-19 05:25:23 | Unknown, Mexico | ||||
126838 | 126838 | 2022-01-09 | Mexico | Unknown | 0 | 0 | 0 | 2022-01-10 04:22:07 | Unknown, Mexico | |||||
130856 | 130856 | 2022-10-04 | Mexico | Unknown | 0 | 0 | 0 | 2022-10-05 04:23:06 | Unknown, Mexico | |||||
138076 | 138076 | 2021-12-04 | Mexico | Unknown | 0 | 0 | 0 | 2021-12-05 04:22:25 | Unknown, Mexico | |||||
142094 | 142094 | 2022-07-09 | Mexico | Unknown | 0 | 0 | 0 | 2022-07-10 04:20:54 | Unknown, Mexico | |||||
150089 | 150089 | 2021-11-29 | Mexico | Unknown | 0 | 0 | 0 | 2021-11-30 04:22:53 | Unknown, Mexico | |||||
154086 | 154086 | 2021-01-08 | Mexico | Unknown | 0 | 0 | 1134877 | 0 | 2021-01-09 05:22:18 | Unknown, Mexico | ||||
158118 | 158118 | 2022-03-29 | Mexico | Unknown | 0 | 0 | 0 | 2022-03-30 04:20:45 | Unknown, Mexico | |||||
162133 | 162133 | 2021-11-19 | Mexico | Unknown | 0 | 0 | 0 | 2021-11-20 04:22:17 | Unknown, Mexico | |||||
166151 | 166151 | 2022-06-21 | Mexico | Unknown | 0 | 0 | 0 | 2022-06-22 04:20:54 | Unknown, Mexico | |||||
170147 | 170147 | 2021-04-16 | Mexico | Unknown | 0 | 0 | 1823732 | 0 | 2021-04-17 04:20:40 | Unknown, Mexico | ||||
178130 | 178130 | 2021-09-02 | Mexico | Unknown | 0 | 0 | 0 | 2021-09-03 04:21:20 | Unknown, Mexico | |||||
182143 | 182143 | 2021-02-21 | Mexico | Unknown | 0 | 0 | 1595320 | 0 | 2021-02-22 05:24:21 | Unknown, Mexico | ||||
186176 | 186176 | 2022-02-13 | Mexico | Unknown | 0 | 0 | 0 | 2022-02-14 04:20:51 | Unknown, Mexico | |||||
190172 | 190172 | 2021-01-11 | Mexico | Unknown | 0 | 0 | 1160373 | 0 | 2021-01-12 05:22:15 | Unknown, Mexico | ||||
198365 | 198365 | 2022-10-19 | Mexico | Unknown | 0 | 0 | 0 | 2022-10-20 04:22:59 | Unknown, Mexico | |||||
202359 | 202359 | 2020-12-25 | Mexico | Unknown | 0 | 0 | 1023916 | 0 | 2020-12-26 05:22:28 | Unknown, Mexico | ||||
218086 | 218086 | 2022-12-26 | Mexico | Unknown | 0 | 0 | 0 | 2022-12-27 04:21:07 | Unknown, Mexico | |||||
222101 | 222101 | 2022-05-09 | Mexico | Unknown | 0 | 0 | 0 | 2022-05-10 04:20:50 | Unknown, Mexico | |||||
229333 | 229333 | 2022-05-31 | Mexico | Unknown | 0 | 0 | 0 | 2022-06-01 04:20:55 | Unknown, Mexico | |||||
233348 | 233348 | 2022-02-11 | Mexico | Unknown | 0 | 0 | 0 | 2022-02-12 04:21:06 | Unknown, Mexico | |||||
237344 | 237344 | 2021-01-18 | Mexico | Unknown | 0 | 0 | 1237321 | 0 | 2021-01-19 05:22:15 | Unknown, Mexico | ||||
241358 | 241358 | 2021-04-02 | Mexico | Unknown | 0 | 0 | 1781629 | 0 | 2021-04-03 04:20:44 | Unknown, Mexico | ||||
245373 | 245373 | 2021-08-17 | Mexico | Unknown | 0 | 0 | 0 | 2021-08-18 04:21:35 | Unknown, Mexico | |||||
249387 | 249387 | 2021-09-04 | Mexico | Unknown | 0 | 0 | 0 | 2021-09-05 04:21:33 | Unknown, Mexico | |||||
253420 | 253420 | 2022-09-08 | Mexico | Unknown | 0 | 0 | 0 | 2022-09-09 04:21:11 | Unknown, Mexico | |||||
257436 | 257436 | 2022-12-10 | Mexico | Unknown | 0 | 0 | 0 | 2022-12-11 04:20:50 | Unknown, Mexico | |||||
261638 | 261638 | 2022-03-15 | Mexico | Unknown | 0 | 0 | 0 | 2022-03-16 04:20:50 | Unknown, Mexico | |||||
276288 | 276288 | 2021-11-03 | Mexico | Unknown | 0 | 0 | 0 | 2021-11-04 04:22:20 | Unknown, Mexico | |||||
280286 | 280286 | 2021-02-24 | Mexico | Unknown | 0 | 0 | 1614614 | 0 | 2021-02-25 05:24:57 | Unknown, Mexico | ||||
288101 | 288101 | 2021-10-31 | Mexico | Unknown | 0 | 0 | 0 | 2021-11-01 04:22:01 | Unknown, Mexico | |||||
292119 | 292119 | 2022-11-15 | Mexico | Unknown | 0 | 0 | 0 | 2022-11-16 04:21:09 | Unknown, Mexico | |||||
296116 | 296116 | 2021-07-15 | Mexico | Unknown | 0 | 0 | 2068175 | 0 | 2021-07-16 04:21:22 | Unknown, Mexico | ||||
303974 | 303974 | 2022-04-16 | Mexico | Unknown | 0 | 0 | 0 | 2022-04-17 04:20:59 | Unknown, Mexico | |||||
307991 | 307991 | 2022-12-13 | Mexico | Unknown | 0 | 0 | 0 | 2022-12-14 04:21:04 | Unknown, Mexico | |||||
312007 | 312007 | 2022-11-13 | Mexico | Unknown | 0 | 0 | 0 | 2022-11-14 04:21:09 | Unknown, Mexico | |||||
316022 | 316022 | 2022-02-12 | Mexico | Unknown | 0 | 0 | 0 | 2022-02-13 04:21:00 | Unknown, Mexico | |||||
320039 | 320039 | 2022-10-30 | Mexico | Unknown | 0 | 0 | 0 | 2022-10-31 04:21:36 | Unknown, Mexico | |||||
328013 | 328013 | 2022-12-27 | Mexico | Unknown | 0 | 0 | 0 | 2022-12-28 04:21:04 | Unknown, Mexico | |||||
332010 | 332010 | 2021-08-04 | Mexico | Unknown | 0 | 0 | 2270427 | 0 | 2021-08-05 04:21:51 | Unknown, Mexico | ||||
336042 | 336042 | 2022-03-18 | Mexico | Unknown | 0 | 0 | 0 | 2022-03-19 04:20:47 | Unknown, Mexico | |||||
340378 | 340378 | 2021-02-03 | Mexico | Unknown | 0 | 0 | 1450237 | 0 | 2021-02-04 05:22:26 | Unknown, Mexico | ||||
348403 | 348403 | 2022-12-14 | Mexico | Unknown | 0 | 0 | 0 | 2022-12-15 04:20:58 | Unknown, Mexico | |||||
352399 | 352399 | 2021-03-11 | Mexico | Unknown | 0 | 0 | 1691093 | 0 | 2021-03-12 05:26:50 | Unknown, Mexico | ||||
356432 | 356432 | 2022-03-11 | Mexico | Unknown | 0 | 0 | 0 | 2022-03-12 04:20:50 | Unknown, Mexico | |||||
360448 | 360448 | 2022-05-07 | Mexico | Unknown | 0 | 0 | 0 | 2022-05-08 04:20:49 | Unknown, Mexico | |||||
372303 | 372303 | 2022-09-13 | Mexico | Unknown | 0 | 0 | 0 | 2022-09-14 04:20:44 | Unknown, Mexico | |||||
380296 | 380296 | 2021-04-30 | Mexico | Unknown | 0 | 0 | 1864914 | 0 | 2021-05-01 04:20:47 | Unknown, Mexico | ||||
384330 | 384330 | 2022-09-23 | Mexico | Unknown | 0 | 0 | 0 | 2022-09-24 04:21:40 | Unknown, Mexico | |||||
388326 | 388326 | 2021-04-04 | Mexico | Unknown | 0 | 0 | 1788209 | 0 | 2021-04-05 04:20:35 | Unknown, Mexico | ||||
392338 | 392338 | 2020-11-27 | Mexico | Unknown | 0 | 0 | 808618 | 0 | 2020-11-28 05:25:50 | Unknown, Mexico | ||||
396371 | 396371 | 2022-10-07 | Mexico | Unknown | 0 | 0 | 0 | 2022-10-08 04:22:56 | Unknown, Mexico | |||||
400368 | 400368 | 2021-06-29 | Mexico | Unknown | 0 | 0 | 1997381 | 0 | 2021-06-30 04:21:41 | Unknown, Mexico | ||||
404399 | 404399 | 2021-12-07 | Mexico | Unknown | 0 | 0 | 0 | 2021-12-08 04:22:46 | Unknown, Mexico | |||||
408398 | 408398 | 2021-07-28 | Mexico | Unknown | 0 | 0 | 2181291 | 0 | 2021-07-29 04:21:33 | Unknown, Mexico | ||||
419442 | 419442 | 2022-09-18 | Mexico | Unknown | 0 | 0 | 0 | 2022-09-19 04:21:49 | Unknown, Mexico | |||||
423456 | 423456 | 2021-10-10 | Mexico | Unknown | 0 | 0 | 0 | 2021-10-11 04:21:31 | Unknown, Mexico | |||||
431464 | 431464 | 2022-11-03 | Mexico | Unknown | 0 | 0 | 0 | 2022-11-04 04:22:11 | Unknown, Mexico | |||||
435459 | 435459 | 2021-01-21 | Mexico | Unknown | 0 | 0 | 1264780 | 0 | 2021-01-22 05:22:10 | Unknown, Mexico | ||||
443460 | 443460 | 2021-10-20 | Mexico | Unknown | 0 | 0 | 0 | 2021-10-21 04:21:18 | Unknown, Mexico | |||||
447476 | 447476 | 2021-11-17 | Mexico | Unknown | 0 | 0 | 0 | 2021-11-18 04:21:33 | Unknown, Mexico | |||||
451494 | 451494 | 2022-12-21 | Mexico | Unknown | 0 | 0 | 0 | 2022-12-22 04:20:56 | Unknown, Mexico | |||||
459485 | 459485 | 2022-02-02 | Mexico | Unknown | 0 | 0 | 0 | 2022-02-03 04:21:21 | Unknown, Mexico | |||||
463502 | 463502 | 2022-05-02 | Mexico | Unknown | 0 | 0 | 0 | 2022-05-03 04:21:00 | Unknown, Mexico | |||||
467517 | 467517 | 2021-10-07 | Mexico | Unknown | 0 | 0 | 0 | 2021-10-08 04:21:25 | Unknown, Mexico | |||||
471515 | 471515 | 2021-02-19 | Mexico | Unknown | 0 | 0 | 1584704 | 0 | 2021-02-20 05:22:51 | Unknown, Mexico | ||||
475549 | 475549 | 2022-06-26 | Mexico | Unknown | 0 | 0 | 0 | 2022-06-27 04:21:00 | Unknown, Mexico | |||||
479697 | 479697 | 2022-11-08 | Mexico | Unknown | 0 | 0 | 0 | 2022-11-09 04:21:22 | Unknown, Mexico | |||||
483694 | 483694 | 2021-07-19 | Mexico | Unknown | 0 | 0 | 2095953 | 0 | 2021-07-20 04:21:48 | Unknown, Mexico | ||||
487727 | 487727 | 2022-11-25 | Mexico | Unknown | 0 | 0 | 0 | 2022-11-26 04:21:11 | Unknown, Mexico | |||||
491741 | 491741 | 2021-10-14 | Mexico | Unknown | 0 | 0 | 0 | 2021-10-15 04:21:26 | Unknown, Mexico | |||||
495757 | 495757 | 2021-11-06 | Mexico | Unknown | 0 | 0 | 0 | 2021-11-07 04:21:53 | Unknown, Mexico | |||||
499774 | 499774 | 2022-04-02 | Mexico | Unknown | 0 | 0 | 0 | 2022-04-03 04:20:48 | Unknown, Mexico | |||||
503791 | 503791 | 2022-12-17 | Mexico | Unknown | 0 | 0 | 0 | 2022-12-18 04:21:03 | Unknown, Mexico | |||||
507788 | 507788 | 2021-08-14 | Mexico | Unknown | 0 | 0 | 0 | 2021-08-15 04:21:41 | Unknown, Mexico | |||||
511802 | 511802 | 2021-08-19 | Mexico | Unknown | 0 | 0 | 0 | 2021-08-20 04:21:33 | Unknown, Mexico | |||||
515835 | 515835 | 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 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] TEXT, [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]);